Welcome toVigges Developer Community-Open, Learning,Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
353 views
in Technique[技术] by (71.8m points)

python - How can I figure out a new row by current row divide its last row by dataframe?

 price = 
  price
0 111
1 222
2 333
3 444

I want newprice =

  price
0 111
1 222/111
2 333/222
3 444/333

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)

Use df.shift with df.fillna:

In [1046]: df['new_price'] = df.price.div(df.price.shift()).fillna(df.price)

In [1047]: df
Out[1047]: 
   price   new_price
0    111  111.000000
1    222    2.000000
2    333    1.500000
3    444    1.333333

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to Vigges Developer Community for programmer and developer-Open, Learning and Share
...