Shift column in pandas dataframe up by one?

by 
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

More Related Contents:

  1. Pandas conditional creation of a series/dataframe column
  2. Truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all()
  3. How to unnest (explode) a column in a pandas DataFrame, into multiple rows
  4. How to split a dataframe string column into two columns?
  5. Error: pandas hashtable keyerror
  6. Writing a pandas DataFrame to CSV file
  7. Remove unwanted parts from strings in a column
  8. Find row where values for column is maximal in a pandas DataFrame
  9. Comparing two dataframes and getting the differences [duplicate]
  10. How to filter rows containing a string pattern from a Pandas dataframe [duplicate]
  11. Accessing Pandas column using squared brackets vs using a dot (like an attribute)
  12. Get the name of a pandas DataFrame
  13. Why does my Pandas DataFrame not display new order using `sort_values`?
  14. python/pandas: convert month int to month name
  15. How to check if a column exists in Pandas
  16. What is the difference between join and merge in Pandas?
  17. Ambiguity in Pandas Dataframe / Numpy Array “axis” definition
  18. How to read a .xlsx file using the pandas Library in iPython?
  19. Pandas – dataframe groupby – how to get sum of multiple columns
  20. pandas comparison raises TypeError: cannot compare a dtyped [float64] array with a scalar of type [bool]
  21. Mapping ranges of values in pandas dataframe [duplicate]
  22. pandas: combine two columns in a DataFrame
  23. How do I filter a pandas DataFrame based on value counts?
  24. Lambda including if…elif…else
  25. Convert month int to month name in Pandas
  26. Pandas query function not working with spaces in column names
  27. Pandas DataFrame sort by categorical column but by specific class ordering
  28. Remove NaN values from pandas dataframe and reshape table [duplicate]
  29. How to return a csv file/Pandas DataFrame in JSON format using FastAPI?
  30. How to get number of groups in a groupby object in pandas?

Leave a Comment