import pandas as pd
Nowcoder1=pd.read_csv('Nowcoder1.csv')
Nowcoder2=pd.read_csv('Nowcoder2.csv')

Nowcoder_all=pd.merge(Nowcoder1,Nowcoder2,how='inner',on='Nowcoder_ID')


data=Nowcoder_all[['Name','Num_of_exercise','Number_of_submissions']]

print(data)