Take dates and times from multiple columns to one datetime object with Python

Asked Jul 15 '20 at 07:38

Active Jul 15 '20 at 09:12

Viewed 64 times

I've got a dataset with multiple time values as below.

Area,Year,Month,Day of Week,Time of Day,Hour of Day
x,2016,1,6.0,108,1.0
z,2016,1,6.0,140,1.0
n,2016,1,6.0,113,1.0
p,2016,1,6.0,150,1.0
r,2016,1,6.0,158,1.0

I have been trying to transform this into a single datetime object to simplify the dataset and be able to do proper time series analysis against it.

For some reason I have been unable to get the right outcome using the datetime library from Python. Would anyone be able to point me in the right direction?

Update - Example of stats here.

https://data.pa.gov/Public-Safety/Crash-Incident-Details-CY-1997-Current-Annual-Coun/dc5b-gebx/data

I don't think there is a week column. Hmm. I wonder if I've missed something?

Any suggestions would be great. Really just looking to simplify this dataset. Maybe even create another table / sheet for the causes of crash, as their's a lot of superfluous columns that are taking up a lot of data, which can be labeled with simple ints.

edited Jul 15 '20 at 09:12

asked Jul 15 '20 at 07:38

LeCoda

what is the code that you've tried with? – ewokx Jul 15 '20 at 07:42
2

So which week is it? You have day of week, but no indicator which week it is. – pinegulf Jul 15 '20 at 07:52
https://docs.python.org/3/library/datetime.html#timedelta-objects Have you tried to use this? And then maybe the following approach https://stackoverflow.com/a/62488169/4213362 – Vishesh Mangla Jul 15 '20 at 09:23
1

Seem like they don't provide the actual date of the crash. Maybe for privacy reasons. – Roy2012 Jul 15 '20 at 10:14
Yes that definitely seems right – LeCoda Jul 15 '20 at 11:27

Take dates and times from multiple columns to one datetime object with Python

Update - Example of stats here.

0 Answers0