利用pandas实现类似sql中的left join操作

使用pandas的merge函数

import pandas as pd

df1 = pd.read_csv(r"1.csv",index_col=0)

df2 = pd.read_csv(r"2.csv",index_col=0)

# on中填写根据哪个字段来进行连接，how为left代表left join
df = pd.merge(df1,df2, on='LocationID',how='left')
# print(df)

# 只取出这些列，组成新的DataFrame，带有col_name
df = df[['LocationName','Description','ActiveFlag','owner name','the location nature']]
# 将列进行重命名
new_col = ['location code', 'location name', 'ActiveFlag','owner name','the location nature']
df.columns = new_col
print(df)
# 导出为csv
df.to_csv(path_or_buf=r"3.csv", encoding="utf_8_sig")