Encoding Time Values

Question

I am using Python/Scikit to do data encoding before I go ahead and train my Neural Network. I have a few columns that look like this

07:05:00
08:41:00
17:25:00
12:58:00
08:56:00
11:59:00
17:25:00
15:24:00

Any suggestions on how to encode this? Or is leaving it like this fine?

i recommend using datetime in python to extract features from the timestamp: https://docs.python.org/2/library/datetime.html — Vadim Smolyakov, Aug 16 '17 at 19:30

score 2 · Answer 1 · answered Jun 29 '17 at 19:11

A common step in "feature engineering" is parsing these out into multiple values that might give you additional information during ML. For example:

If you also had day, that would open a lot more to detect seasonality like:

score 1 · Accepted Answer · answered Jun 29 '17 at 18:39

1

I have decided to convert the strings into seconds. Since these are all Time of Day values, I will convert them to contiguous seconds.

answered Jun 29 '17 at 18:39

Patrick Zawadzki

in your training (and test) data did you then replaced the Date_time column with a 'contiguous_secs' (int) column? – sAguinaga Dec 09 '19 at 17:20

2 Answers2