用pandas中的reset_index报错是为什么？

2017-11-16 04:44:52 952 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

多维聚合后的数据操纵：pandas MultiIndex实战指南多维聚合是数据分析的核心环节，其本质是基于MultiIndex构建的高维坐标系数据结构。理解groupby返回的Series或DataFrame索引形态、agg函数对列名的嵌套影响、以及reset_index与set_index对索引层级的破坏机制，是避免KeyError、NaN蔓延和同比错位等高频问题的前提。技术价值在于将稀疏的业务维度组合转化为稠密、可计算、可交付的规范形态——包括列名扁平化、缺失组合补全、维度折叠与跨维度广播计算。典型应用场景涵盖电商复购率分析、金融风控指标监控及SaaS客户健康度报表阅读详情

代码如下，我希望把原来的索引时间去掉，改成股票代码Stkcd：

test=stock_daily[['Stkcd', 'Dretnd']]

print(date[0])

slice=test[str(date[0])].reset_index()

print(slice)

del slice['Trddt']

print(slice.reset_index('Stkcd',drop=True).T)

运行结果：
2000-07-10 00:00:00
Trddt Stkcd Dretnd
0 2000-07-10 600230 0.020356
1 2000-07-10 600738 -0.013671
Traceback (most recent call last):
File "<input>", line 6, in <module>
File "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/site-packages/pandas/core/frame.py", line 3341, in reset_index
level = [self.index._get_level_number(lev) for lev in level]
File "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/site-packages/pandas/core/frame.py", line 3341, in <listcomp>
level = [self.index._get_level_number(lev) for lev in level]
File "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/site-packages/pandas/core/indexes/base.py", line 1620, in _get_level_number
self._validate_index_level(level)
File "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/site-packages/pandas/core/indexes/base.py", line 1617, in _validate_index_level
(level, self.name))
KeyError: 'Level Stkcd must be same as name (None)'

...全文