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

import pandas as pd
import datetime as dt

df1 = pd.read_csv("Nowcoder1.csv", sep=",")
df2 = pd.read_csv("Nowcoder2.csv", sep=",")

pd.set_option("display.width", 300)  # 设置字符显示宽度
pd.set_option("display.max_rows", None)  # 设置显示最大行
pd.set_option("display.max_columns", None)

df = pd.merge(df1,df2,how='outer',on='Nowcoder_ID')
print(df[['Name','Num_of_exercise','Number_of_submissions']])