Are You Still Using Excel? AUTOMATE it with PYTHON

Published: 18 February 2022
on channel: John Watson Rooney
49,724
1.4k

If you do the same thing over and over in excel at work you should seriously consider automating it with Python and Pandas! I'll show you how to easily import several csv files into a dataframe, and create some summary pivote tables of the data to share.

code here: https://github.com/jhnwr/automate-csv...

Support Me:

Patreon:   / johnwatsonrooney  
Proxies: https://iproyal.club/JWR50
Hosting: Digital Ocean: https://m.do.co/c/c7c90f161ff6
Gear I use: https://www.amazon.co.uk/shop/johnwat...
Twitter   / jhnwr