擅长:python、mysql、java
<p>使用<a href="http://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.mask.html" rel="nofollow noreferrer">^{<cd1>}</a>:</p>
<pre><code>df[['Count1','Value1']] = df[['Count1','Value1']].mask(df.Count1 < 5)
df[['Count2','Value2']] = df[['Count2','Value2']].mask(df.Count2 < 5)
print (df)
ID Count1 Value1 Count2 Value2
0 111 5.0 10.0 5.0 25.0
1 112 NaN NaN 6.0 25.0
2 113 6.0 7.0 NaN NaN
3 114 NaN NaN NaN NaN
4 115 7.0 1.0 8.0 10.0
</code></pre>