题解 | #两份用户信息表格中的查找#

# 导入Pandas库
import pandas as pd

Nowcoder1 = pd.read_csv("Nowcoder1.csv")

Nowcoder2 = pd.read_csv("Nowcoder2.csv")

# 注意外连接
Nowcoder_all = pd.merge(Nowcoder1, Nowcoder2, how="outer", on="Nowcoder_ID")

name_exercise_submission = Nowcoder_all[["Name", "Num_of_exercise", "Number_of_submissions"]]

# 打印结果
print(name_exercise_submission)