How to group DataFrame by a period of time?

by

You can group on any array/Series of the same length as your DataFrame — even a computed factor that’s not actually a column of the DataFrame. So to group by minute you can do:

df.groupby(df.index.map(lambda t: t.minute))

If you want to group by minute and something else, just mix the above with the column you want to use:

df.groupby([df.index.map(lambda t: t.minute), 'Source'])

Personally I find it useful to just add columns to the DataFrame to store some of these computed things (e.g., a “Minute” column) if I want to group by them often, since it makes the grouping code less verbose.

Or you could try something like this:

df.groupby([df['Source'],pd.TimeGrouper(freq='Min')])

More Related Contents:

  1. Pandas conditional creation of a series/dataframe column
  2. Why does concatenation of DataFrames get exponentially slower?
  3. Combine Date and Time columns using python pandas
  4. Pandas: How to easily share a sample dataframe using df.to_dict()?
  5. Pandas/Python: Set value of one column based on value in another column
  6. Accessing Pandas column using squared brackets vs using a dot (like an attribute)
  7. how to get ticks every hour?
  8. Calculate weighted average using a pandas/dataframe
  9. How to add value labels on a bar chart
  10. How to remove blanks/NA’s from dataframe and shift the values up
  11. Why does my Pandas DataFrame not display new order using `sort_values`?
  12. Ambiguity in Pandas Dataframe / Numpy Array “axis” definition
  13. Difference(s) between merge() and concat() in pandas
  14. How can I see the formulas of an excel spreadsheet in pandas / python?
  15. Pandas SettingWithCopyWarning [duplicate]
  16. flattening nested Json in pandas data frame
  17. Count distinct words from a Pandas Data Frame
  18. subsetting a Python DataFrame
  19. How to use Pandas stylers for coloring an entire row based on a given column?
  20. pandas: combine two columns in a DataFrame
  21. python pandas read_csv delimiter in column data
  22. Pandas Plotting Display all date values on x-axis (matplolib only displays few values) formatted as MMM-YYYY [duplicate]
  23. Numpy isnan() fails on an array of floats (from pandas dataframe apply)
  24. How do I create a sum row and sum column in pandas?
  25. Remove ends of string entries in pandas DataFrame column
  26. How to compute jaccard similarity from a pandas dataframe
  27. why is a sum of strings converted to floats
  28. Pandas: remove duplicates that exist in any order
  29. Difference between df[x], df[[x]], df[‘x’] , df[[‘x’]] and df.x
  30. Numpy.dtype has the wrong size, try recompiling

Leave a Comment