How to shift a column in Pandas DataFrame

by 
In [18]: a
Out[18]: 
   x1  x2
0   0   5
1   1   6
2   2   7
3   3   8
4   4   9

In [19]: a['x2'] = a.x2.shift(1)

In [20]: a
Out[20]: 
   x1  x2
0   0 NaN
1   1   5
2   2   6
3   3   7
4   4   8

More Related Contents:

  1. error when applying function to a series object
  2. Groupby value counts on the dataframe pandas
  3. Using Pandas to pd.read_excel() for multiple worksheets of the same workbook
  4. How to add pandas data to an existing csv file?
  5. How to explode a list inside a Dataframe cell into separate rows
  6. How to print pandas DataFrame without index
  7. How to map numeric data into categories / bins in Pandas dataframe
  8. Normalize columns of pandas data frame
  9. How do I sum values in a column that match a given condition using pandas?
  10. How to loop over grouped Pandas dataframe?
  11. Update a dataframe in pandas while iterating row by row
  12. Is there a simple way to change a column of yes/no to 1/0 in a Pandas dataframe?
  13. Conditionally format Python pandas cell
  14. How to concatenate multiple column values into a single column in Pandas dataframe
  15. How to create a dictionary of two pandas DataFrame columns
  16. How can I use cumsum within a group in Pandas?
  17. Pandas dataframe – running sum with reset
  18. What is dtype(‘O’), in pandas?
  19. Why does df.apply(tuple) work but not df.apply(list)?
  20. Merge a list of pandas dataframes
  21. Checking if particular value (in cell) is NaN in pandas DataFrame not working using ix or iloc
  22. Move column by name to front of table in pandas
  23. Convert List to Pandas Dataframe Column
  24. How to repeat a Pandas DataFrame?
  25. Get column name where value is something in pandas dataframe
  26. dataframe to dict such that one column is the key and the other is the value [duplicate]
  27. Is there a way to speed up handling large CSVs and dataframes in python?
  28. What values are valid in Pandas ‘Freq’ tags?
  29. How to convert DataFrame.append() to pandas.concat()?
  30. How to efficiently assign unique ID to individuals with multiple entries based on name in very large df

Leave a Comment