pandas dataframe groupby datetime month

by

Managed to do it:

b = pd.read_csv('b.dat')
b.index = pd.to_datetime(b['date'],format="%m/%d/%y %I:%M%p")
b.groupby(by=[b.index.month, b.index.year])

Or 

b.groupby(pd.Grouper(freq='M'))  # update for v0.21+

More Related Contents:

  1. Python Pandas Group by date using datetime data
  2. How to change the datetime format in Pandas
  3. Aggregation in Pandas
  4. Filtering Pandas DataFrames on dates
  5. Pandas GroupBy.apply method duplicates first group
  6. Pandas Dataframe line plot display date on xaxis
  7. Changing the formatting of a datetime axis in matplotlib
  8. Pandas groupby mean – into a dataframe?
  9. How to use groupby to concatenate strings in python pandas?
  10. Generating random dates within a given range in pandas
  11. How to access pandas groupby dataframe by key
  12. group by pandas dataframe and select latest in each group
  13. How to change the datetime tick label frequency for matplotlib plots
  14. pandas to_datetime parsing wrong year
  15. How to drop duplicates based on two or more subsets criteria in Pandas data-frame
  16. Python Pandas Conditional Sum with Groupby
  17. Pandas get frequency of item occurrences in a column as percentage [duplicate]
  18. Python/Pandas convert string to time only
  19. Transform vs. aggregate in Pandas
  20. Convert Pandas Series to DateTime in a DataFrame
  21. Convert dataframe index to datetime
  22. How to add/subtract time (hours, minutes, etc.) from a Pandas DataFrame.Index whos objects are of type datetime.time?
  23. Which is the fastest way to extract day, month and year from a given date?
  24. In Pandas how do I convert a string of date strings to datetime objects and put them in a DataFrame?
  25. Pandas groupby to to_csv
  26. Group DataFrame in 5-minute intervals
  27. pd.to_datetime is getting half my dates with flipped day / months
  28. Clean way to convert quarterly periods to datetime in pandas
  29. pandas extract year from datetime: df[‘year’] = df[‘date’].year is not working
  30. Python Pandas : pandas.to_datetime() is switching day & month when day is less than 13

Leave a Comment