Pandas Plotting with Multi-Index

python matplotlib pandas multi-index
Reustonium picture Reustonium · Aug 19, 2014 · Viewed 65k times · Source

After performing a groupby.sum() on a DataFrame I'm having some trouble trying to create my intended plot.

grouped dataframe with multi-index

How can I create a subplot (kind='bar') for each Code, where the x-axis is the Month and the bars are ColA and ColB?

Answer

Reustonium picture Reustonium · Aug 20, 2014

I found the unstack(level) method to work perfectly, which has the added benefit of not needing a priori knowledge about how many Codes there are.

df.unstack(level=0).plot(kind='bar', subplots=True)

Related questions

Plot correlation matrix using pandas

I have a data set with huge number of features, so analysing the correlation matrix has become very difficult. I want to plot a correlation matrix which we get using dataframe.corr() function from pandas library. Is there any built-in …

Read More
Add x and y labels to a pandas plot

Suppose I have the following code that plots something very simple using pandas: import pandas as pd values = [[1, 2], [2, 5]] df2 = pd.DataFrame(values, columns=['Type A', 'Type B'], index=['Index 1', 'Index 2']) df2.plot(lw=2, colormap='jet', marker='.', …

Read More
How to plot two columns of a pandas data frame using points?

I have a pandas data frame and would like to plot values from one column versus the values from another column. Fortunately, there is plot method associated with the data-frames that seems to do what I need: df.plot(x=…

Read More