I have a pandas Dataframe in the form:
A B K S
2012-03-31 NaN NaN NaN 10
2012-04-30 62.74449 15.2 71.64 0
2012-05-31 2029.487 168.8 71.64 0
2012-06-30 170.7191 30.4 71.64 0
我将尝试创建一个函数,使用df['S'][index-1]的值替换df['S']。
例如:
for index,row in df.iterrows:
if index = 1:
pass
else:
df['S'] = min(df['A'] + df['S'][index-1]?? - df['B'], df['K'])
but i dont know how to get df['S'][index - 1]
iterrows()
处理当前/前一行,请参见 iterrows pandas get next rows value。 - xtian