我想将最后一个日期(索引)从2017-06-18
替换为date_replace
,后者是datetime64格式。但是,当我替换它时出现错误,代码如下:
>>> date_replace
0 2017-06-19
Name: trading_day, dtype: datetime64[ns]
Stock Open High Low Close Adj Close Volume
Date
2017-06-13 AD 5.230000 5.260000 5.200000 5.260000 5.260000 5000
2017-06-16 AD 5.220000 5.260000 5.220000 5.260000 5.260000 6000
2017-06-17 AD 5.210000 5.560000 5.210000 5.560000 5.560000 200
2017-06-18 AD 5.200000 5.250000 5.200000 5.250000 5.250000 9000
>>> df.index[-1] = date_replace
TypeError: Index does not support mutable operations
>>> import datetime
>>> df.rename({df.index[-1]: datetime.date.date_replace()}, inplace = True)
AttributeError: type object 'datetime.date' has no attribute 'date_replace'
我想要的输出:
Stock Open High Low Close Adj Close Volume
Date
2017-06-13 AD 5.230000 5.260000 5.200000 5.260000 5.260000 5000
2017-06-16 AD 5.220000 5.260000 5.220000 5.260000 5.260000 6000
2017-06-17 AD 5.210000 5.560000 5.210000 5.560000 5.560000 200
2017-06-19 AD 5.200000 5.250000 5.200000 5.250000 5.250000 9000
那么,如何在没有错误和相同格式的情况下优雅地替换日期呢?你知道吗
使用
pd.DataFrame.rename
。您可以将字典传递给index
参数,以指定将哪些索引重命名为哪些索引。你知道吗相关问题 更多 >
编程相关推荐