TLDR;

5 lesser-known pandas tricks:

1. Date Ranges

2. Merge with indicator

3. Nearest merge by timestamp

4. Create an Excel report from pandas

5. Use gzip with when saving to csv