将df合并到两个键中，只对一个键起作用

我有两个df，他们需要合并在两个键通道和周。当尝试合并时，它会返回Contacts_F列中所有行的NaN值。 日期:

df = pd.DataFrame({ 'week' : ['01', '02', '45'] ,
                    'Channel' : ['AA', 'BB', 'CC'],
                    'level' : ['1degre','2degre','3degre']  })
df.dtypes
out[131]:
week               object
Channel            object
level              object



reff_table = pd.DataFrame({ 'week' : ['01', '02', '45'] ,
                            'Channel' : ['AA', 'BB', 'CC'],
                            'Contacts_F' : ['0.11','0.546','0.06458']  })
reff_table.dtypes
out[132]:
week               object
Channel            object
Contacts_F         float64



print(df.week[:3]), print(reff_table.week[:3])

0    00
1    00
2    00
Name: week, dtype: object
0    103
1    102
2    101
Name: week, dtype: object
(None, None)

我的尝试: /.

df = pd.merge(df, reff_table [["Channel", "week" , "Contacts_F"]],on=['Channel','week'], how='left')

如果我只在Column=Channel上合并，它会工作，但是我需要匹配两列。

df = pd.merge(df, reff_table [["Channel", "week" , "Contacts_F"]],on=['Channel', how='left')

问题来源StackOverflow 地址：/questions/59383082/merge-df-in-two-keys-just-working-for-one-key