准备工作:下载示例数据,提取码:tkqn 数据例子数据预览
在数据合并中,有merge和concat是比较常用的。
merge:左连、右连、内连
新建两个dataframe数据集:
import pandas as pd
df1 = pd.DataFrame({'key1':['b','b','a','a','b','a','c'],'key2':['i','j','k','k','i','j','k'],'data1':range(7)})
df2 = pd.DataFrame({'key1':['a','b','d'],'key2':['k','j','i'],'data2':range(3)})以索引进行合并
merge1 = pd.merge(df1,df2,how='left',left_index=True,right_index=True) #index 左连
merge2 = pd.merge(df1,df2,how='right',left_index=True,right_index=True) #index 右连
merge3 = pd.