I am guessing from the TOC that they are using pandas. My team quickly ran into memory spikes when multiple programs using pandas would run. We have since migrated to using ibis with a duckdb backend to smooth out the memory spikes.
Yeah... I wondered about the title "Automate Excel with Pandas" but Excel users would have no idea what I was talking about. Those who never leave the safe harbor of Microsoft will have heard distant rumblings about Python but not specific modules. Forgive me for sort of equating "Python" with "Pandas" but if it gets more folks using Python then I hope the ends justify the means.