绘制 Pandas 多指数条形图

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/34248741/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-09-14 00:22:40  来源:igfitidea点击:

Plotting Pandas Multiindex Bar Chart

pythonpandasmatplotlibbokehplotly

提问by rbinnun

How can I plot a Python Pandas multiindex dataframe as a bar chart with group labels? Do any of the plotting libraries directly support this? This SO postshows a custom solution using matplotlib, but is there direct support for it?

如何将 Python Pandas 多索引数据框绘制为带有组标签的条形图?是否有任何绘图库直接支持这一点?这篇SO post展示了一个使用 matplotlib 的自定义解决方案,但是否有直接支持?

As an example:

举个例子:

quarter  company
Q1       Blue       100
         Green      300
Q2       Blue       200
         Green      350
Q3       Blue       300
         Green      400
Q4       Blue       400
         Green      450
Name: count, dtype: int64

...can this dataframe be plotted with group labels like this?

...可以在此数据帧可以用组标签绘制这样

Thanks in advance,

提前致谢,

Rafi

拉菲

回答by Goodword

import pandas as pd

data = pd.DataFrame([
        ('Q1','Blue',100),
        ('Q1','Green',300),
        ('Q2','Blue',200),
        ('Q2','Green',350),
        ('Q3','Blue',300),
        ('Q3','Green',400),
        ('Q4','Blue',400),
        ('Q4','Green',450),
    ], 
    columns=['quarter', 'company', 'value']
)
data = data.set_index(['quarter', 'company']).value

data.unstack().plot(kind='bar', stacked=True)

stacked bar chart from multiindex

来自多索引的堆积条形图

If you don't want to stack your bar chart:

如果您不想堆叠条形图:

data.unstack().plot(kind='bar')

not-stacked bar chart

非堆叠条形图