Pandas pivot 产生“ValueError:索引包含重复的条目，无法重塑"；

2022-01-10 00:00:00 python pandas dataframe pivot duplicates

问题描述

我有一个格式如下的熊猫表:

I have a pandas table formatted as following:

  anger_metric  metric_name angle_value
0   71.0991 roll    14.6832
1   71.0991 yaw     0.7009
2   71.0991 pitch   22.5075
3   90.1341 roll    4.8566
4   90.1341 yaw     6.4458
5   90.1341 pitch   -10.1930

我需要创建一个这样的视图，将其旋转成这样:

I need to create a view of this that pivots it to sth like this:

  anger_metric  roll yaw pitch 
0   71.0991     14.6832 0.7009 22.5075
1   90.1341     4.8566  6.4458 -10.1930

这是我的代码:

df2= results.pivot(index='anger_metric', columns='metric_name', values='angle_value')
# results is the pnadas table/list

我收到以下错误:

ValueError: Index contains duplicate entries, cannot reshape

如何处理?

解决方案

试试pivot_table:

df
   anger_metric metric_name  angle_value
0       71.0991        roll      14.6832
1       71.0991         yaw       0.7009
2       71.0991       pitch      22.5075
3       90.1341        roll       4.8566
4       90.1341         yaw       6.4458
5       90.1341       pitch     -10.1930

result = df.pivot_table(index='anger_metric', 
                        columns='metric_name', 
                        values='angle_value')
result.columns.name = None

result
                pitch     roll     yaw
anger_metric                          
71.0991       22.5075  14.6832  0.7009
90.1341      -10.1930   4.8566  6.4458

相关文章