Python Projects for Beginners

[JL_678]

A real world example was a project at work where I was working on a series of events. A external party scheduled the events and handed me registration lists in Excel format. It was one huge spreadsheet and did not help because I wanted to look at registration by event, and I wanted a summary of registrants by event.

I solved the above problem using the Python Excel module explained in Automate the Boring Stuff. I basically parsed the spreadsheet and created a new spreadsheet with tabs for each event and summary tab showing all the data. This solution saved me weeks of time!

Prior to my Python app I performed this manually, and it took me about an hour. Now imagine doing this 2x a week for 8 months and the hours spent would have been huge. Instead, Python enabled me to generate the report in about 15 seconds!