问题描述
我有一个格式如下的熊猫表:
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