擅长:python、mysql、java
<p>您可以尝试以下方法:</p>
<pre><code>import pandas as pd
df = pd.DataFrame({'Scenario':['HI','HI','HI','HI','HI','HI'],
'Savings':['Total_FFC_base0','Total_FFC_savings1','Total_FFC_saving2',
'Total_FFC_savings3','Total_site_base0','Total_site_savings1'],
'PC1':[0.12,0.15,0.12,0.17,0.12,0.15],
'PC2':[0.13,0.12,0.14,0.15,0.15,0.15]})
df['Saving'] = df['Savings'].str.split('_').apply(lambda x: x[1])
df['EL'] = df['Savings'].str.extract('(\d+)') #To extract only digits
df = df.drop(columns='Savings')
print(df)
</code></pre>
<p>输出:</p>
<pre><code> Scenario Saving PC1 PC2 EL
0 HI FFC 0.12 0.13 0
1 HI FFC 0.15 0.12 1
2 HI FFC 0.12 0.14 2
3 HI FFC 0.17 0.15 3
4 HI site 0.12 0.15 0
5 HI site 0.15 0.15 1
</code></pre>