import pandas as pd import numpy as np from pandas import DataFrame, Series df = DataFrame( {'integer':[1,2,3,6,7,23,8,3], 'float':[2,3.4,5,6,2,4.7,4,8], 'string':['saya',None,'aku','cinta','kamu','a','b','jika']} ) df df_new = DataFrame( {'string':['a','b'], 'str_value':[2,4]} ) df_new df_merge_inner = pd.merge(df,df_new,on='string',how='inner') print df_merge_inner df_merge_outer = pd.merge(df,df_new,on='string',how='outer') print df_merge_outer df_merge_left = pd.merge(df,df_new,on='string',how='left') df_merge_left df_merge_right = pd.merge(df,df_new,on='string',how='right') df_merge_right