Escaping Excel Hell, or, How I Learned to Love the Codes
Wed Feb 27 2019
I just listened to this episode of Talk Python to Me and it really resonated with me. I used to describe myself as an Excel Monkey, paid to cobble together a bunch of data and logic. Most things start off pretty informally but sometimes (most of the time) things really do get out of hand with Excel.
Just perusing through Practical Business Python, I can see that I'm definitely not alone. I would have loved this resource 10 years ago when I was knee deep in spreadsheets. Pandas really can be a replacement for most of what I did 10 years ago (mortgage data analytics) and with the numerous data visualization libraries, I could probably have done everything in Python and saved myself the constant heartache of working with hand-typed "data" and version-control-by-file-name that I used to do.
Now, being knee deep in the codes, I forget how much of the world really runs on Excel and how much daily processes could be improved if only some of these tasks were to be done in something else besides Excel. Oh, the mistakes I've made.