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

import pandas as pd

# 设置pandas显示配置,以显示完整的数据框
pd.set_option("display.width", 300)
pd.set_option("display.max_rows", None)
pd.set_option("display.max_columns", None)

users_info = pd.read_csv('Nowcoder1.csv')
users_active = pd.read_csv('Nowcoder2.csv')

merged_table = pd.merge(users_info,users_active,on='Nowcoder_ID',how='left')
filtered_columns = ['Name','Num_of_exercise','Number_of_submissions']

print(merged_table[filtered_columns])