python添加时间戳,Python：向熊猫时间戳添加小时

I read a csv file into pandas dataframe df and I get the following:

df.columns

Index([u'TDate', u'Hour', u'SPP'], dtype='object')

>>> type(df['TDate'][0])

type(df['Hour'][0])

>>> type(df['TradingDate'])

>>> type(df['Hour'])

Both the Hour and TDate columns have 100 elements. I want to add the corresponding elements of Hour to TDate.

I tried the following:

import pandas as pd

from datetime import date, timedelta as td

z3 = pd.DatetimeIndex(df['TDate']).to_pydatetime() + td(hours = df['Hour'])

But I get error as it seems td doesn't take array as argument. How do I add each element of Hour to corresponding element of TDate.

解决方案

I think you can add to column TDate column Hour converted to_timedelta with unit='h':

df = pd.DataFrame({'TDate':['2005-01-03','2005-01-04','2005-01-05'],

'Hour':[4,5,6]})

df['TDate'] = pd.to_datetime(df.TDate)

print (df)

Hour TDate

0 4 2005-01-03

1 5 2005-01-04

2 6 2005-01-05

df['TDate'] += pd.to_timedelta(df.Hour, unit='h')

print (df)

Hour TDate

0 4 2005-01-03 04:00:00

1 5 2005-01-04 05:00:00

2 6 2005-01-05 06:00:00