我有两个数据帧:
df1:
Calendar
0 Mauritius
1 MIL
2 EG
df2:
Calendar Country
0 0A South Australia
1 MEL Australia - Victoria (Regional)
2 QLD Queensland Australia
3 Mauritius Mauritius
4 7A Australia - Tasmania
5 MIL MILANO
6 NSET TRADING NSE Stock Exchange
7 AUF Australian Fixed Income
8 EG Eq Guinea
预期输出:
Calendar Country
0 Mauritius Mauritius
1 MIL MILANO
2 EG Eq Guinea
当我尝试使用合并时
df_merge = pd.merge(df1, df2, on=['Calendar'])
我得到一个空的数据帧-我该如何解决这个问题?
只需使用更改顺序:-
df_merge=pd.merge(df2,df1,on='Calendar')
或者你可以做掩蔽,即
mask=df1['Calendar'].isin(df2['Calendar'])
df_merge=df2[mask]