Shift column in pandas dataframe up by one

Question

I ve got a pandas dataframe  I want to  lag  one of my columns  Meaning  for example  shifting the entire column  gdp  up by one  and then removing all the excess data at the bottom of the remaining rows so that all columns are of equal length again   df       y  gdp  cap 0   1    2    5 1   2    3    9 2   8    7    2 3   3    4    7 4   6    7    7  df lag       y  gdp  cap 0   1    3    5 1   2    7    9 2   8    4    2 3   3    7    7   Anyway to do this

User · Accepted Answer

In  44   df  gdp     df  gdp   shift -1   In  45   df Out 45       y  gdp  cap 0  1    3    5 1  2    7    9 2  8    4    2 3  3    7    7 4  6  NaN    7  In  46   df  -1                                                                                                                                                                                                                                                                                                                 Out 46       y  gdp  cap 0  1    3    5 1  2    7    9 2  8    4    2 3  3    7    7

User · Answer

df gdp   df gdp shift -1     shift up df gdp drop df gdp shape 0  - 1 inplace   True     removing the last row

User · Answer

shift column gdp up   df gdp   df gdp shift -1    and then remove the last row

User · Answer

First shift the column   df  gdp     df  gdp   shift -1    Second remove the last row which contains an NaN Cell   df   df  -1    Third reset the index   df   df reset index drop True

User · Answer

To easily shift by 5 values for example and also get rid of the NaN rows  without having to keep track of the number of values you shifted by   d  gdp     df  gdp   shift -5  df   df dropna

[python] Shift column in pandas dataframe up by one?

Examples related to python

Examples related to pandas

Examples related to dataframe