Pandas: Shift down values by one row within a group

by

Newer versions of pandas can now perform a shift on a group:

df['B_shifted'] = df.groupby(['A'])['B'].shift(1)

Note that when shifting down, it’s the first row that has NaN.

More Related Contents:

  1. How do I select rows from a DataFrame based on column values?
  2. Aggregation in Pandas
  3. Convert DataFrame column type from string to datetime
  4. Compare two DataFrames and output their differences side-by-side
  5. Constructing pandas DataFrame from values in variables gives “ValueError: If using all scalar values, you must pass an index”
  6. Can pandas automatically read dates from a CSV file?
  7. Selecting a row of pandas series/dataframe by integer index
  8. df.append() is not appending to the DataFrame
  9. pandas dataframe str.contains() AND operation
  10. Pandas groupby mean – into a dataframe?
  11. How do I find the closest values in a Pandas series to an input number?
  12. How do I count the NaN values in a column in pandas DataFrame?
  13. getting the index of a row in a pandas apply function
  14. How to flatten a pandas dataframe with some columns as json?
  15. Tilde sign in pandas DataFrame
  16. Drop columns whose name contains a specific string from pandas DataFrame
  17. Find the unique values in a column and then sort them
  18. how do I calculate a rolling idxmax
  19. Python Pandas How to assign groupby operation results back to columns in parent dataframe?
  20. Pandas won’t fillna() inplace
  21. python Pandas DataFrame copy(deep=False) vs copy(deep=True) vs ‘=’
  22. From password-protected Excel file to pandas DataFrame
  23. How to filter a pandas dataframe based on the length of a entry
  24. How can repetitive rows of data be collected in a single row in pandas?
  25. Change the color of text within a pandas dataframe html table python using styles and css
  26. Row-wise average for a subset of columns with missing values
  27. Plot multiple columns of pandas DataFrame using Seaborn
  28. Dynamically filtering a pandas dataframe
  29. Remove substring from column based on another column
  30. How to upload a CSV file in FastAPI and convert it into a Pandas Dataframe?

Leave a Comment