Python Forum
Getting the hourly average of a time series dataset
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Getting the hourly average of a time series dataset
#1
Hello guys, I have a large dataframe of 10000 rows and 2 columns .The first column is the dates(years,months,days,hours,minutes) as index. My dates column doesnt have a stable frequency. I am trying to get the average value of 2nd column of every 1 hour .
Any ideas on how can I iterate this problem for the whole time series?
My df looks like this and I want to get the average value from 20:00 to 21:00 and so on.

time value
2019-03-21 20:03:30.351000 22.6
2019-03-21 20:33:30.392000 22.7
2019-03-21 20:38:30.428000 22.6
2019-03-21 20:43:30.363000 22.7
2019-03-21 21:13:30.382000 22.6
2019-03-21 22:33:34.762000 22.5
2019-03-21 22:38:34.696000 22.6
Reply


Messages In This Thread
Getting the hourly average of a time series dataset - by Raskou07 - Nov-24-2020, 03:31 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
Photo Converting Pandas DataFrame to a table of hourly blocks Abedin 1 771 Apr-24-2025, 01:05 PM
Last Post: snippsat
  Date Time Series Help...Please spra8560 2 1,414 Feb-01-2024, 01:38 PM
Last Post: spra8560
  Print names in x-axis of a time-series values hobbyist 4 2,477 Apr-22-2023, 09:29 PM
Last Post: deanhystad
  Time series JasminQuinn 0 1,529 Apr-22-2022, 10:33 PM
Last Post: JasminQuinn
  How to read rainfall time series and insert missing data points MadsM 4 3,525 Jan-06-2022, 10:39 AM
Last Post: amdi40
  Plotting A Time Series With Shaded Recession Bars adamszymanski 1 3,932 Jan-24-2021, 09:08 PM
Last Post: nealc
  Tableau Time Series Prediction using Python Integration tobimarsh43 0 2,474 Jul-24-2020, 10:38 AM
Last Post: tobimarsh43
  Bode plot from time series experiment data discus 4 10,373 Jun-20-2020, 07:46 AM
Last Post: discus
  Convert quarterly time series to monthly time series donnertrud 1 6,646 May-22-2020, 10:16 AM
Last Post: pyzyx3qwerty
  Parsing Date/Time from Metar Reports with 6 hourly weather information Lawrence 0 3,224 May-03-2020, 08:15 PM
Last Post: Lawrence

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020