How to calculate the mean of dateTime.time

Asked Jun 07 '21 at 21:49

Active Jun 07 '21 at 22:04

Viewed 151 times

I have a dataframe that has many rows and is in the below form. I am interested in calculating the mean value of hours. What should be the correct way to do in pandas? The datatype of the date and time column is in DateTime. Thanks in advance.

arrivalDate	arrivalTime	dayOfWeek
2020-10-01	13:55:00	Thursday
2020-01-16	14:01:00	Thursday
2020-01-02	14:02:00	Thursday

edited Jun 07 '21 at 22:04

Henry Ecker

34,399
18
41
57

asked Jun 07 '21 at 21:49

nishant

What does your code look like so far? (What have you tried?) – Bill_Stewart Jun 07 '21 at 21:50
1

Take a look at this SO post: https://stackoverflow.com/questions/19681703/average-time-for-datetime-list. – bobtho'-' Jun 07 '21 at 22:07
in question show expected result. – furas Jun 08 '21 at 00:57
Do you want just global average of `arrivalTime` or average `arrivalTime` per `dayOfWeek`, month, year, ...? – Corralien Jun 08 '21 at 06:49

How to calculate the mean of dateTime.time

0 Answers0