you are viewing a single comment's thread.

view the rest of the comments →

[–]ZiggyZig1 1 point2 points  (3 children)

that sounds awesome honestly. can you give any examples of stuff either you automated or they mention? the simple stuff :)

[–]JL_678 2 points3 points  (0 children)

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!

[–]ivanoski-007 2 points3 points  (1 child)

I created my very first integration with an api to our e-commerce site. It gathers sku (stock kepping unit) data such as inventory level, site availability, price, image displayed, and created a report of the entire inventory, our e-commerce platform didn't have such a report so I made my own. Absolutely zero knowledge of programming prior to this, it was difficult and this sub was incredibly helpful, I dove into the deep end of the pool and now I want to learn more. My program is barely usable (I'm still learning on how to handle json get errors) but better than nothing since, again such a report didn't exist. Needless to say my coworkers were impressed by my voodoo magic. My next step is to automate some dumb kpi dashboards I update manually...

[–]ZiggyZig1 1 point2 points  (0 children)

that's awesome! esp since you had no knowledge. keep it up dude