group by week in pandas

by

First, convert column date to_datetime and subtract one week as we want the sum for the week ahead of the date and not the week before that date.

Then use groupby with Grouper by W-MON and aggregate sum:

df['Date'] = pd.to_datetime(df['Date']) - pd.to_timedelta(7, unit="d")
df = df.groupby(['Name', pd.Grouper(key='Date', freq='W-MON')])['Quantity']
    .sum()
    .reset_index()
    .sort_values('Date')
print (df)

  Name       Date  Quantity
0   Apple 2017-07-10        90
3  orange 2017-07-10        20
1   Apple 2017-07-17        30
2  Orange 2017-07-24        40

More Related Contents:

  1. How do I Pandas group-by to get sum?
  2. Apply multiple functions to multiple groupby columns
  3. Python Pandas : group by in group by and average?
  4. Python: get a frequency count based on two columns (variables) in pandas dataframe some row appers
  5. Pandas dataframe get first row of each group
  6. pandas groupby sort within groups
  7. Add months to a date in Pandas
  8. group by pandas dataframe and select latest in each group
  9. Naming returned columns in Pandas aggregate function? [duplicate]
  10. Pandas sum by groupby, but exclude certain columns
  11. Python Pandas: Group datetime column into hour and minute aggregations
  12. Sort a pandas dataframe series by month name
  13. Matplotlib DateFormatter for axis label not working
  14. Splitting timestamp column into separate date and time columns
  15. Get week start date (Monday) from a date column in Python (pandas)?
  16. How can I use cumsum within a group in Pandas?
  17. Add a sequential counter column on groups to a pandas dataframe
  18. pandas group by and find first non null value for all columns
  19. Sample each group after pandas groupby
  20. Which is the fastest way to extract day, month and year from a given date?
  21. Pandas groupby for zero values
  22. Split pandas dataframe based on values in a column using groupby
  23. Number rows within group in increasing order in a pandas dataframe
  24. pandas divide row value by aggregated sum with a condition set by other cell
  25. Select row by max value in group in a pandas dataframe
  26. Extracting dates that are in different formats using regex and sorting them – pandas
  27. How to create Pandas groupby plot with subplots
  28. Convert dates to pd.to_datetime where month could be either a number or month name
  29. Pandas: groupby forward fill with datetime index
  30. Why do I get a KeyError when using pandas apply?

Leave a Comment