Converting dataframe to datetime in pandas

Question

I have a dataframe called 'times', the head of which looks like this:

year    month   day hour    minute  second
0   2015    02  03  01  12  04
1   2015    02  03  01  12  07
2   2015    02  03  01  12  11
3   2015    02  03  01  12  13
4   2015    02  03  01  12  17

When I try to put all of these together into a single datetime series like this:

timeData = pd.to_datetime(times)

it throws this error:

TypeError: arg must be a string, datetime, list, tuple, 1-d array, or Series

Why does it throw this error, and how can I fix it?

It works on my machine.

Merlin
– Merlin

2016-07-11 06:09:47 +00:00
Commented Jul 11, 2016 at 6:09 — Merlin
– Merlin, Commented Jul 11, 2016 at 6:09

piRSquared · Accepted Answer · 2016-07-11 06:35:41Z

1

Your solution works for me as well.

But you can also try:

times.apply(lambda x: pd.datetime(*x), axis=1)

Or:

times.T.apply(lambda x: pd.datetime(*x))

answered Jul 11, 2016 at 6:35

piRSquared

296k68 gold badges509 silver badges654 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Converting dataframe to datetime in pandas

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related