pandas - Increase datetime hour(More information is in the article.)

Question

I pulled out one column from the data frame and added it to a variable named timestamp.

0    2017-01-10 04:45:00
1    2017-01-10 04:45:00
2    2017-01-10 04:45:00
3    2017-01-10 04:46:00
4    2017-01-10 04:46:00
5    2017-01-10 04:46:00
6    2017-01-10 04:47:00
7    2017-01-10 04:47:00
8    2017-01-10 17:47:00
9    2017-01-10 17:52:00
Name: timestamp, dtype: object

The type of data is:

type(timestamp)

Out[1]: pandas.core.series.Series

type(timestamp.values)

Out[1]: numpy.ndarray

What I want to do is add 9 hours.

0    2017-01-10 13:45:00
1    2017-01-10 13:45:00
2    2017-01-10 13:45:00
3    2017-01-10 13:46:00
4    2017-01-10 13:46:00
5    2017-01-10 13:46:00
6    2017-01-10 13:47:00
7    2017-01-10 13:47:00
8    2017-01-11 02:47:00
9    2017-01-11 02:52:00
Name: timestamp, dtype: object

I would appreciate it if you could tell me what I should do.

score 4 · Accepted Answer · answered Sep 16 '17 at 05:19

4

Use pd.Timedelta:

 s1 + pd.Timedelta(hours=9)

Output:

0   2017-01-10 13:45:00
1   2017-01-10 13:45:00
2   2017-01-10 13:45:00
3   2017-01-10 13:46:00
4   2017-01-10 13:46:00
5   2017-01-10 13:46:00
6   2017-01-10 13:47:00
7   2017-01-10 13:47:00
8   2017-01-11 02:47:00
9   2017-01-11 02:52:00
Name: 1, dtype: datetime64[ns]

answered Sep 16 '17 at 05:19

Scott Boston

147,308
15
139
187

I got this error. TypeError: must be str, not Timedelta What type should I change? – Cian Sep 16 '17 at 05:34
Ah.. Your original series is not a pandas datetime. It is a datetime module datetime. You could pd.to_datetime(timestamp). – Scott Boston Sep 16 '17 at 05:35
Thank you. I did not get an error because of this, but the time does not change./ a = pd.to_datetime(timestamp)\n a = a + pd.Timedelta(hours=9)\n a – Cian Sep 16 '17 at 05:45
That's odd. a = a + pd.Timedelta(hours=9) didn't advance a nine hours? – Scott Boston Sep 16 '17 at 05:46
Oh! I'm sorry. I was wrong. Thank you for letting us know. – Cian Sep 16 '17 at 05:59

pandas - Increase datetime hour(More information is in the article.)

1 Answers1