我有這個資料集：
Data A
2015-01-01 00:15:00 0
2015-01-01 00:30:00 1
2015-01-01 00:45:00 2
2015-01-01 01:00:00 3
2015-01-01 01:15:00 4
我正在嘗試將資料設定為頻率。我有熊貓來識別索引的日期時間。
DatetimeIndex(['2015-01-01 00:00:00', '2015-01-01 00:15:00',
'2015-01-01 00:30:00', '2015-01-01 00:45:00',
'2015-01-01 01:00:00', '2015-01-01 01:15:00',
'2015-01-01 01:30:00', '2015-01-01 01:45:00',
'2015-01-01 02:00:00', '2015-01-01 02:15:00',
...
'2016-09-30 21:30:00', '2016-09-30 21:45:00',
'2016-09-30 22:00:00', '2016-09-30 22:15:00',
'2016-09-30 22:30:00', '2016-09-30 22:45:00',
'2016-09-30 23:00:00', '2016-09-30 23:15:00',
'2016-09-30 23:30:00', '2016-09-30 23:45:00'],
dtype='datetime64[ns]', name='Data', length=61340, freq=None)
我試過這樣做
df.asfreq(freq='15M')
但我收到以下錯誤
ValueError: cannot reindex from a duplicate axis
uj5u.com熱心網友回復：
您可以使用DataFrame.resample一些聚合函式，如sum, mean, first：
df.resample('15M').sum()
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/399704.html