擅长:python、mysql、java
<p>有一个通用的解决方案应该可以很好地解决这个问题</p>
<pre class="lang-py prettyprint-override"><code>def gt_mask(row,df):
mask = True
for key,val in row.items():
mask &= df[key] > val
return len(df[mask])
df2['greater'] = df2.apply(gt_mask,df=df1,axis=1)
</code></pre>
<p>输出df2</p>
<pre class="lang-py prettyprint-override"><code>,alligator_apple,barbadine,capulin_cherry,greater
0,6,3,1,4
1,7,19,9,1
2,15,25,15,0
3,5,12,27,3
</code></pre>
<p>这将创建一个掩码,遍历给定行的键/值对</p>
<p>编辑这个答案很有帮助:<a href="https://stackoverflow.com/questions/40895067/masking-a-dataframe-on-multiple-column-conditions-inside-a-loop">Masking a DataFrame on multiple column conditions - inside a loop</a></p>