多表联合-JOIN MERGE

最新推荐文章于 2023-07-27 11:30:00 发布

小丸子头又很大了

最新推荐文章于 2023-07-27 11:30:00 发布

阅读量126

点赞数

本文链接：https://blog.csdn.net/weixin_48660856/article/details/115103740

版权


```python
import pandas as pd

# students = pd.read_excel('C:/Temp/Student_score.xlsx', sheet_name='Students')
# scores = pd.read_excel('C:/Temp/Student_score.xlsx', sheet_name='Scores')
# table = students.merge(scores, how='left', on='ID').fillna(0)
# table.Score = table.Score.astype(int)
# print(table)

# students = pd.read_excel('C:/Temp/Student_score.xlsx', sheet_name='Students', index_col='ID')
# scores = pd.read_excel('C:/Temp/Student_score.xlsx', sheet_name='Scores', index_col='ID')
# table = students.merge(scores, how='left', left_on=students.index, right_on=scores.index).fillna(0)
# table.Score = table.Score.astype(int)
# print(table)

students = pd.read_excel('D:/Code/.vscode/Student_Score.xlsx', sheet_name='Students', index_col='ID')
scores = pd.read_excel('D:/Code/.vscode/Student_Score.xlsx', sheet_name='Scores', index_col='ID')
table = students.join(scores, how='left').fillna(0)
table.Score = table.Score.astype(int)
print(table)

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

小丸子头又很大了

关注关注

0
点赞
踩
1

收藏

觉得还不错? 一键收藏
0
评论
多表联合-JOIN MERGE

```pythonimport pandas as pd# students = pd.read_excel('C:/Temp/Student_score.xlsx', sheet_name='Students')# scores = pd.read_excel('C:/Temp/Student_score.xlsx', sheet_name='Scores')# table = students.merge(scores, how='left', on='ID').fillna(0)# ta.
复制链接

扫一扫