Does anybody know of a reliable way to create pivot charts from a pivot table in python?
I can create charts from a dataframe within python using matplotlib and seaborn.
I don’t know how to create viz from a pivot table that I’ve created out of the dataframe.
You can use df = pd.pivot_table() in pandas to make a table. There are a number of parameters, including aggregation that you can add to the function to arrange the table. And then you can plot the df as a barplot or whatever. ie: df.plot(kind = 'bar') .
See:
https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.pivot_table.html
1 Like