擅长:python、mysql、java
<p>你可以用纽比。在哪里函数来匹配数据帧</p>
<p>例如:</p>
<pre><code>datadf = pd.DataFrame([['USA','Business1'],['AUS','Business2'],['UK','Business3'],['IND','Business4']],
columns=['country','business'])
configdf = pd.DataFrame([['AUS','Business2'],['IND','Business4'],['USA','Business1'],['UK','Business3']],
columns=['country','business'])
datadf['new_col'] = datadf.apply(lambda x: (np.where(x == configdf)[0][0]),axis=1)
print(datadf)
</code></pre>
<p>输出:</p>
^{pr2}$
<p><strong>编辑1:</strong></p>
<p>好吧,那样的话,你可以用</p>
<pre><code>datadf['new_col'] = datadf.apply(lambda x: (np.where((x['country'] == configdf['country']) & (x['business'] == configdf['business']))[0][0]),axis=1)
</code></pre>
<p>基于示例数据帧datadf和configdf的输出:</p>
<pre><code> country business new_col
0 A 1 0
1 A 1 0
2 A 2 1
3 A 2 1
4 B 1 2
5 B 1 2
6 B 2 3
7 C 1 4
8 C 2 5
</code></pre>