擅长:python、mysql、java
<p>一个附加选项:</p>
<pre><code>In [158]: formulas = """
...: new_count__4s_abc = (A==4)*1 + (B==4)*1 + (C==4)*1
...: new_sum__abc = A + B + C
...: """
In [159]: df.eval(formulas)
Out[159]:
A B C D count__4s_abc sum__abc new_count__4s_abc new_sum__abc
0 1 2 4 1 1 7 1 7
1 0 4 4 4 2 8 2 8
</code></pre>
<p><a href="https://jakevdp.github.io/PythonDataScienceHandbook/03.12-performance-eval-and-query.html" rel="nofollow noreferrer">^{<cd1>} method can (but not always) be faster compared to regular Pandas arithmetic</a></p>