0

I have a dataset like the one below

Date           Price
2017-01-01     100
2017-01-02     187
2017-01-03     183

How can I create a column that gets the previous days info like

Date           Price    Previous_Days_Price
2017-01-01     100      NaN
2017-01-02     187      100
2017-01-03     183      187
OptimusPrime
  • 619
  • 8
  • 17
  • Is possible some dates are missing, e.g `2017-01-01`, `2017-01-03`,`2017-01-04`,`2017-01-06`,`2017-01-07`? – jezrael Nov 25 '17 at 17:38

1 Answers1

1

pandas.Series.shift is what you want...

df['Price'].shift(1)
blacksite
  • 12,086
  • 10
  • 64
  • 109