I wrote a Jupyter notebook that demonstrates how you can easily use pandas together with pygal. Because it won’t work here on my blogging system, you have to read about it on GitHub: Jupyter notebook HTML export (fully interactive version)
Effective interactive data visualization with pandas and pygal
