Don’t forget probably the most useful tool in pandas!

pandas.DataFrame.pivot_table() 

With that you can probably build a nice little toolchain of SQL->pandas->plot/spreadsheet and get a lot of nasty hand analysis done with rather large datasets that would make a normal spreadsheet cry.