擅长:python、mysql、java
<p>修复此问题的最简单方法是融化数据帧并合并数据帧</p>
<pre><code>data1 = {'key': ['abc','efg', 'xyz', 'sdf']}
data2 = {'key1' : ['abc','sss','ggg','ccc'],
'key2' : ['aaa','efg','xyz', 'sdf'],
'msg' : ['happy','mad','smile','great']}
data1 = pd.DataFrame(data1)
data2 = pd.DataFrame(data2).melt(id_vars='msg', value_name='key').drop('variable', axis=1)
df = data1.merge(data2, on='key')
df =
key msg
0 abc happy
1 efg mad
2 xyz smile
3 sdf great
</code></pre>