Excel is the tool we love to hate. It’s great at what it does well, but… not so great at what it isn’t meant to do. In the age of ever-important data, you’re often getting workbooks and workbooks piled on your from different sources and asked to produce magic with them.
In this post, you’ll learn exactly that — how to do Excel magic with the power of simple Python scripts.
What you’ll learn!
Let’s imagine you’re given a bunch of Excel files with different salespeoples’ sales figures. The problem is the files don’t tell you who is who, aside from their file name. You’ve been asked to figure out some high levels stats about the sales!
You’ll learn how to:
- Combine multiple workbooks into a single dataframe,
- Create a pivot table of your data,
- Generate a final Excel workbook with all your work.
And you’ll do it all without ever actually touching Excel.
Turn a bunch of loose files into an actionable report, ready with an Excel chart! Image by: Nik Piepenbreier
#coding #python #data-science
