<p>我想你在找这样的东西:</p>
<pre><code>import pandas as pd
import re
def fn(row):
if re.search('/Revenue|Current|Quick|Turnover', row['KPI']):
return 'Min'
elif re.search('Margin|Revenue|ROA|ROE', row['KPI']):
return 'Max'
df = pd.read_csv('so.csv')
df['scope'] = df.apply (lambda row: fn(row), axis=1)
print (df)
</code></pre>
<p>这只是使用<code>df.apply()</code>函数,该函数接受每一行并对其应用所提供的函数。你知道吗</p>
<p>对于给定的数据,得出以下结果:</p>
<pre><code>0 Gross Margin % 0.5820 0.4760 Max
1 EBITDA Margin % 0.1910 0.2300 Max
2 EBIT Margin % 0.1450 0.1830 Max
3 SG&A/Revenue 0.1410 0.0300 Min
4 COGS/Revenue 0.4180 0.5240 Min
5 CapE/Revenue 0.0577 0.1204 Min
6 ROA 0.0640 0.0930 Max
7 ROE 0.1380 0.2430 Max
8 Revenue/Employee $K 290.9000 934.4000 Max
9 Inventory Turnover 2.2000 3.2700 Min
10 AR Turnover 13.0200 14.2900 Min
11 Tot Asset Turnover 0.6800 0.7400 Min
12 Current Ratio 0.9000 0.8000 Min
13 Quick Ratio 0.3000 0.4000 Min
</code></pre>
<p>希望这有帮助!你知道吗</p>