擅长:python、mysql、java
<p>对多个条件和值使用<a href="https://docs.scipy.org/doc/numpy/reference/generated/numpy.select.html" rel="nofollow noreferrer">^{<cd1>}</a></p>
<pre><code>conditions = [
df['KPI'].str.contains('Margin| Revenue|Revenue/|ROE|ROA'),
df['KPI'].str.contains('/Revenue|Current|Quick|Turnover')
]
values = ['Max', 'Min']
df['scope'] = pd.np.select(conditions, values, default='Min/Max')
</code></pre>
<p>当所有条件都不匹配时,保持<code>default</code>参数为所需的值。你知道吗</p>
<p>或者</p>
<p>如果你只有一个条件</p>
<pre><code>condition = df['KPI'].str.contains('Margin| Revenue|ROE|ROA')
df['scope'] = pd.np.where(condition, 'Max', 'Min')
</code></pre>
<p><code>np.where</code>的第一个参数是条件,第二个是True时要放入的值,第三个是False时要放入的值</p>