日期时间格式熊猫

Question

我正在尝试读取csv并将datetime列转换为datetime索引，但格式很难。如何在pd.to_datetime的格式参数中指定+2？

非常感谢，

date  = ['2015-02-03 21:00:00+02:00','2015-02-03 22:30:00+02:00','2016-02-03 21:00:00+02:00','2016-02-03   22:00:00+02:00']
value_column = [33.24  , 500  , 34.39  , 34.49 ]

df = pd.DataFrame({'V1':value_column}, index=pd.to_datetime(date,format='%Y-%m-%d %H:%M'))
print(df.head())

V1 
index                                     
2015-02-03 21:00:00+02:00  33.24   
2015-02-03 22:30:00+02:00  500   
2016-02-03 21:00:00+02:00  34.39   
2016-02-03 22:00:00+02:00  34.49   

Answer 1

使用parse_dates=['date']作为pd.read_csv:的参数

df = pd.read_csv('data.csv', parse_dates=['date'], index_col='date')

输出：

>>> df
V1
date                             
2015-02-03 21:00:00+02:00   33.24
2015-02-03 22:30:00+02:00  500.00
2016-02-03 21:00:00+02:00   34.39
2016-02-03 22:00:00+02:00   34.49
>>> df.index
DatetimeIndex(['2015-02-03 21:00:00+02:00', '2015-02-03 22:30:00+02:00',
'2016-02-03 21:00:00+02:00', '2016-02-03 22:00:00+02:00'],
dtype='datetime64[ns, pytz.FixedOffset(120)]', name='date', freq=None)

csv文件内容：

date,V1
2015-02-03 21:00:00+02:00,33.24
2015-02-03 22:30:00+02:00,500
2016-02-03 21:00:00+02:00,34.39
2016-02-03 22:00:00+02:00,34.49