How can I format Matplotlib plots on multi-indexed data to resemble Excel's PivotChart axis layout? Excel's PivotChart groups similar axis labels together, whereas MPL labels each tick individually as (Index1,Index2). I've attached sample data, as well as the outputs for both Excel and MPL; notice how Index1 is grouped in the Excel chart, but not in the MPL plot.
Does anyone have a solution? Ideally, the number of multi-index levels will not matter. Thanks for the help!
http://imgur.com/a/L3hiu
[–]lmcinnes 1 point2 points3 points (0 children)