python中合并表格的两种方法

import numpy as np

import pandas as pd

import matplotlib as plt

id1=pd.read_csv('/Users/wuwu/Desktop/2021_ICM_Problem_D_Data/id4.csv')

dba=pd.read_csv('/Users/wuwu/Desktop/2021_ICM_Problem_D_Data/dba2.csv')

id1.head()

df1=id1.set_index('influencer_name')

df2=dba

df2=dba.set_index('influencer_name')

w=df1.join(df2)

w.info()

import numpy as np

import pandas as pd

import matplotlib as plt

id4=pd.read_csv('/Users/wuwu/Desktop/2021_ICM_Problem_D_Data/id4.csv')

dba=pd.read_csv('/Users/wuwu/Desktop/2021_ICM_Problem_D_Data/dba2.csv')

id4.head()

df1=id4.set_index('influencer_name')

df2=dba

df2=dba.set_index('influencer_name')

df3 = pd.merge(df1,df2,how='inner',on='influencer_name')

print(df3)

df3.to_csv('/Users/wuwu/Desktop/2021_ICM_Problem_D_Data/alldataexceptyear.csv')

pd.merge(df1,df2,how='inner',on='influencer_name')