擅长:python、mysql、java
<p>或者用面具</p>
<pre><code>df['average'] = df.mask(df.filter(like='Revenue')<=1000).mean(1)
</code></pre>
<pre><code> Name Revenue1 Revenue2 Revenue3 Revenue4 average
0 Peter 1000 2000 3000 2500 2500.0
1 Jane 9000 10000 5000 8000 8000.0
</code></pre>