reference 1: http://blog.csdn.net/zutsoft/article/details/51498026
author:lianghc
《 连接:merge 通过键拼接列》
#两个dataframe之间通过某一个变量的值作为主键们进行拼接
import pandas as pd
online_Df=pd.DataFrame({'Cate_cd':['A类','B类','C类'],'series_code':['2002','2004','2005']})
SQL_df=pd.DataFrame({'vouch':['1001','1002','1003','1004','1005'],'series_code':['2001','2002','2003','2004','2005']})
newDf=pd.merge(SQL_df,online_Df,how='left')
这个包真的太好用了8! 避免又长又久的循环语句,感恩!!