How to shift a column in Pandas DataFrame without losing value

Question

I would like to shift a column in a Pandas DataFrame, but I haven't been able to find a method to do it without losing values. (This post is quite similar to How to shift a column in Pandas DataFrame but the validated answer doesn't give the desired output and I can't comment it). Does anyone know how to do it?

##    x1   x2
##0  206  214
##1  226  234
##2  245  253
##3  265  272
##4  283  291

Desired output:

##    x1   x2
##0  206  nan
##1  226  214
##2  245  234
##3  265  253
##4  283  271
##5  nan  291

Possible duplicate of How to shift a column in Pandas DataFrame — Kay Wittig
– Kay Wittig, Commented Jul 9, 2018 at 18:24

root · Accepted Answer · 2016-03-16 17:39:39Z

12

Use loc to add a new blank row to the DataFrame, then perform the shift.

df.loc[max(df.index)+1, :] = None
df.x2 = df.x2.shift(1)

The code above assumes that your index is integer based, which is the pandas default. If you're using a non-integer based index, replace max(df.index)+1 with whatever you want the new last index to be.

answered Mar 16, 2016 at 17:39

root

34.1k6 gold badges77 silver badges89 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to shift a column in Pandas DataFrame without losing value

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related