pandas数据拼接

import pandas as pd


# 加载数据
detail1 = pd.read_excel('meal_order_detail.xlsx', sheet_name=0)
# detail2 = pd.read_excel('meal_order_detail.xlsx', sheet_name=1)
# detail3 = pd.read_excel('meal_order_detail.xlsx', sheet_name=2)
# print(detail1)
# print(detail2)
# print(detail3)
detail4 = pd.read_csv('meal_order_info.csv', encoding='gbk')
# print(detail4)

# 进行纵向拼接
# new_detail = pd.concat((detail1, detail2, detail3))
# print(new_detail)

# 主键拼接
# detail5 = pd.merge(detail1, detail4, how='inner', left_on='order_id', right_on='info_id')
# print(detail5)
# print(detail5.columns)
detail6 = pd.read_excel('users.xlsx')
# print(detail6)
detail7 = pd.merge(detail4, detail6, left_on='name', right_on='ACCOUNT', how='inner')
print(detail7)