pandas数据拼接

最新推荐文章于 2024-05-29 16:21:04 发布

原创最新推荐文章于 2024-05-29 16:21:04 发布 · 530 阅读

1 ·

CC 4.0 BY-SA版权

数据分析专栏收录该内容

35 篇文章

订阅专栏

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)