学习笔记(41):零基础搞定Python数据分析与挖掘-数据的合并与连接

立即学习:https://edu.csdn.net/course/play/6861/326776?utm_source=blogtoedu

数据的合并与连接

数据合并

《从零开始学python数据分析与挖掘》

import pandas as pd
df1 = pd.DataFrame({'name':['张三','王五','李四'],'age':[12,13,43],'gender':['男','女','男']})
df2 = pd.DataFrame({'name':['二哈','二蛋','二丫'],'age':[23,43,23],'gender':['女','女','男']})
df1
df2
pd.concat([df1,df2],keys=['df1','df2']).reset_index().drop(labels='level_1',axis=1).rename(columns={'level_0':'f'})

df2 = pd.DataFrame({'Name':['狗娃','牛蛙'],'age':[21,32],'gender':['女','女']})
df2
pd.concat([df1,df2])#name和Name 不能合并  所以合并的时候变量名称要一致
df2.rename(columns={'Name':'name'},inplace=True)
pd.concat([df1,df2])#name和Name 不能合并  所以合并的时候变量名称要一致

 

 

 

数据的链接

import pandas as pd
df3 = pd.DataFrame({'id':[1,2,3,4,5],'name':['张三','李四','王二','王二麻子','赵五'],'age':[21,32,44,2,43],'gender':['女','男','女','男','男']})
df4 = pd.DataFrame({'Id':[1,2,2,4,4,4,5],'score':[21,32,44,33,22,32,33],'kemu':['科目1','科目1','科目2','科目1','科目2','科目3','科目1']})
df5 = pd.DataFrame({'id':[1,3,5],'name':['张三','王二','赵五'],'income':[21,32,44]})
print(df3)
print(df4)
print(df5)
#先链接df3和df4
merge1 = pd.merge(left=df3,right=df4,how='left',left_on='id',right_on='Id')
merge1
#再链接和df5
merge2 = pd.merge(left=merge1,right=df5,how='left')
merge2