I've never heard of pandasql before. Looks very intriguing. I'm always looking up "how to do this sql thing in pandas" or similar cheatsheets when working with pandas.