Python Pandas Group by date using datetime data

by

You can use groupby by dates of column Date_Time by dt.date:

df = df.groupby([df['Date_Time'].dt.date]).mean()

Sample:

df = pd.DataFrame({'Date_Time': pd.date_range('10/1/2001 10:00:00', periods=3, freq='10H'),
                   'B':[4,5,6]})

print (df)
   B           Date_Time
0  4 2001-10-01 10:00:00
1  5 2001-10-01 20:00:00
2  6 2001-10-02 06:00:00

print (df['Date_Time'].dt.date)
0    2001-10-01
1    2001-10-01
2    2001-10-02
Name: Date_Time, dtype: object

df = df.groupby([df['Date_Time'].dt.date])['B'].mean()
print(df)
Date_Time
2001-10-01    4.5
2001-10-02    6.0
Name: B, dtype: float64

Another solution with resample:

df = df.set_index('Date_Time').resample('D')['B'].mean()

print(df)
Date_Time
2001-10-01    4.5
2001-10-02    6.0
Freq: D, Name: B, dtype: float64

More Related Contents:

  1. Get statistics for each group (such as count, mean, etc) using pandas GroupBy?
  2. Aggregation in Pandas
  3. How to join two dataframes for which column values are within a certain range?
  4. Converting a Pandas GroupBy output from Series to DataFrame
  5. datetime dtypes in pandas read_csv
  6. Multiple aggregations of the same column using pandas GroupBy.agg()
  7. Pandas groupby mean – into a dataframe?
  8. Python Pandas max value in a group as a new column
  9. pandas dataframe groupby datetime month
  10. How to loop over grouped Pandas dataframe?
  11. python pandas extract year from datetime: df[‘year’] = df[‘date’].year is not working
  12. Pandas Groupby and Sum Only One Column
  13. Removing the timestamp from a datetime in pandas dataframe
  14. Pandas filter dataframe rows with a specific year
  15. Pandas get frequency of item occurrences in a column as percentage [duplicate]
  16. Python/Pandas convert string to time only
  17. Pandas – dataframe groupby – how to get sum of multiple columns
  18. Group dataframe and get sum AND count?
  19. Truncate `TimeStamp` column to hour precision in pandas `DataFrame`
  20. Python pandas integer YYYYMMDD to datetime
  21. How to summarize on different groupby combinations?
  22. get first and last values in a groupby
  23. Pandas groupby and aggregation output should include all the original columns (including the ones not aggregated on)
  24. Python: Adding hours to pandas timestamp
  25. Get the row corresponding to the max in pandas GroupBy [duplicate]
  26. pandas extract year from datetime: df[‘year’] = df[‘date’].year is not working
  27. Python Pandas : pandas.to_datetime() is switching day & month when day is less than 13
  28. How to get number of groups in a groupby object in pandas?
  29. Get weekday/day-of-week for Datetime column of DataFrame
  30. When is it appropriate to use df.value_counts() vs df.groupby(‘…’).count()?

Leave a Comment