Sep-08-2020, 02:01 PM
Hi,
I have three Data Frames with a common column (ID) and I want to merge them into one.
df1:
result:
I use below code, but it got error:
I have three Data Frames with a common column (ID) and I want to merge them into one.
df1:
ID Pop RANK A1 T1 1 A1 T1 3 B1 T1 4 B2 T1 2 K1 T1 9 K1 T1 1 K2 T1 5df2:
ID Pop TEMP RANK A1 T1 20 1 A1 T1 56 3 B1 T1 72 4 B2 T1 45 2 K1 T1 0 9 K1 T1 20 1 K2 T1 43 5 KN T2 56 1 KP T2 23 5 NH6 T3 56 23 KL5 T4 19 16df3:
ID Status RANK A1 NOR 1 A1 ABN 3 B1 HOT 4 B2 COOL 2 K1 HOT 9 K1 ER 1 K2 RAMP 5 KN BAK 1 KP HOT 5 NH6 COOL 23 KL5 RAMP 16I want to merge based on ID:
result:
ID Pop RANK TEMP Status A1 T1 1 20 NOR A1 T1 3 56 ABN B1 T1 4 72 HOT B2 T1 2 45 COOL K1 T1 9 0 HOT K1 T1 1 20 ER K2 T1 5 43 RAMPwhen merge, merge TEMP column from df2, and Status column from df3.
I use below code, but it got error:
df1.set_index('ID',inplace=True) df2.set_index('ID',inplace=True) df3.set_index('ID',inplace=True) df = pd.concat([df1,df2,df3],axis=1).reset_index() df.rename(columns = {'index':'ID'})ValueError: Shape of passed values is (7, 11), indices imply (7, 9)