Pandas pivot_table给出了错误ValueError: None多次出现，请使用级别编号
Pandas pivot_table给出了错误ValueError: None多次出现，请使用级别编号
提问于 2020-01-07 19:58:59
我有一个熊猫数据框
print(df.head()) Row ID Order ID Order Date ... Quantity Discount Profit
0 1 CA-2013-152156 09/11/2013 ... 2 0.00 41.9136
1 2 CA-2013-152156 09/11/2013 ... 3 0.00 219.5820
2 3 CA-2013-138688 13/06/2013 ... 2 0.00 6.8714
3 4 US-2012-108966 11/10/2012 ... 5 0.45 -383.0310
4 5 US-2012-108966 11/10/2012 ... 2 0.20 2.5164当我执行此命令时：
ans = pd.pivot_table(data=df, index=['Segment'], columns=['Region'], values = ['Sales'], aggfunc={'Sales':['sum', 'mean']}, margins=True, dropna=False)它会给出这个错误：
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "/usr/local/lib/python3.6/dist-packages/pandas/core/reshape/pivot.py", line 162, in pivot_table
fill_value=fill_value,
File "/usr/local/lib/python3.6/dist-packages/pandas/core/reshape/pivot.py", line 208, in _add_margins
if margins_name in table.columns.get_level_values(level):
File "/usr/local/lib/python3.6/dist-packages/pandas/core/indexes/multi.py", line 1598, in
get_level_values
level = self._get_level_number(level)
File "/usr/local/lib/python3.6/dist-packages/pandas/core/indexes/multi.py", line 1292, in
_get_level_number
"The name %s occurs multiple times, use a " "level number" % level
ValueError: The name None occurs multiple times, use a level number回答 1
Stack Overflow用户
发布于 2020-01-07 20:03:27
也许可以帮助省略以下内容中的列表：
ans = pd.pivot_table(data=df,
index=['Segment'],
columns=['Region'],
values= ['Sales'],
aggfunc={'Sales':['sum', 'mean']}, margins=True, dropna=False)至：
ans = pd.pivot_table(data=df,
index= 'Segment',
columns= 'Region',
values= 'Sales',
aggfunc={'Sales':['sum', 'mean']}, margins=True, dropna=False)页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/59628014
复制相关文章
相似问题
腾讯云开发者
