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

import pandas as pd 

#1-导入数据
data_1 = pd.read_csv('Nowcoder1.csv', sep = ',')
data_2 = pd.read_csv('Nowcoder2.csv', sep = ',')
#2-显示设置
pd.set_option('display.width', 300)#显示宽度设置为300
pd.set_option('display.max_rows', None)#输出所有行
pd.set_option('display.max_columns', None)#输出所有列
#3-连接
data = pd.merge(data_1, data_2, on = 'Nowcoder_ID', how = 'inner')
#4-输出
a = data[['Name', 'Num_of_exercise', 'Number_of_submissions']].reset_index(drop = True)#重置索引
print(a)