擅长:python、mysql、java
<p>我是通过有问题的文本创建代码,而不是通过示例代码:</p>
<pre><code>df_baseScenario = pd.DataFrame({'Calc_Period':[1,2,3],
'Rate Index Spread':[4,5,6],
'D':[1,3,5],
'E':[5,3,6],
'F':[7,4,3],
'G':[4,2,9],
'H':[5,7,8],
'I':[8,5,4]})
print (df_baseScenario)
start_columns = ['D','E','F']
end_columns = ['G','H','I']
df = df_baseScenario[start_columns].mul(df_baseScenario[end_columns].values) \
.sub(1) \
.div(df_baseScenario['Calc_Period'], axis=0) \
.add(df_baseScenario['Rate Index Spread'], axis=0)
#assign calumne names by end_columns
df.columns = end_columns
#add prefix
df = df.add_suffix('fwd_rate')
print (df)
Gfwd_rate Hfwd_rate Ifwd_rate
0 7.000000 28.000000 59.000000
1 7.500000 15.000000 14.500000
2 20.666667 21.666667 9.666667
</code></pre>
<hr/>
^{pr2}$