Average time for datetime list

by

Here’s a short and sweet solution (perhaps not the fastest though). It takes the difference between each date in the date list and some arbitrary reference date (returning a datetime.timedelta), and then sums these differences and averages them. Then it adds back in the original reference date. 

import datetime
def avg(dates):
  any_reference_date = datetime.datetime(1900, 1, 1)
  return any_reference_date + sum([date - any_reference_date for date in dates], datetime.timedelta()) / len(dates)

More Related Contents:

  1. Convert Pandas Column to DateTime
  2. How to join two dataframes for which column values are within a certain range?
  3. Calculate Time Difference Between Two Pandas Columns in Hours and Minutes
  4. Extracting just Month and Year separately from Pandas Datetime column
  5. Pandas Dataframe line plot display date on xaxis
  6. datetime to string with series in pandas
  7. pandas datetime to unix timestamp seconds
  8. python pandas extract year from datetime: df[‘year’] = df[‘date’].year is not working
  9. How to group a pandas dataframe by a defined time interval?
  10. Python Pandas Group by date using datetime data
  11. How do I round datetime column to nearest quarter hour
  12. Removing the timestamp from a datetime in pandas dataframe
  13. Pandas filter dataframe rows with a specific year
  14. Subtract a year from a datetime column in pandas
  15. Pandas: Return Hour from Datetime Column Directly
  16. pandas .plot() x-axis tick frequency — how can I show more ticks?
  17. Pandas: How to create a datetime object from Week and Year?
  18. Leave dates as strings using read_excel function from pandas in python
  19. Combine Date and Time columns using pandas
  20. Converting time zone pandas dataframe
  21. Python pandas integer YYYYMMDD to datetime
  22. Pandas parse non-english string dates
  23. filter pandas dataframe by time
  24. Convert a column of timestamps into periods in pandas
  25. Python: Adding hours to pandas timestamp
  26. how to specify the datetime format in read_csv
  27. How to combine year, month, and day columns to single datetime column?
  28. Pandas datetimes with different formats in the same column
  29. Python generating a list of dates between two dates
  30. Get weekday/day-of-week for Datetime column of DataFrame

Leave a Comment