1.
df1 = pd.read_csv('aa.txt')
df1.columns = ['id', 't1', 't2']
df2 = pd.read_csv('bb.txt')
df = df1[df1['id'].isin(df2['id'])]
print('join_set_rate = %.6f' % (len(df) / len(df1)))
1.
df1 = pd.read_csv('aa.txt')
df1.columns = ['id', 't1', 't2']
df2 = pd.read_csv('bb.txt')
df = df1[df1['id'].isin(df2['id'])]
print('join_set_rate = %.6f' % (len(df) / len(df1)))