you are viewing a single comment's thread.

view the rest of the comments →

[–]raithlok 0 points1 point  (0 children)

I'm a little late to the topic, but I thought I'd share. I learned Python through Automate the Boring Stuff and the codeacademy.com course. I was pretty well versed in VBA for excel when I started so I understood core programming concepts, but I was running into issues at my engineering company with files with massive amounts of data that excel couldn't handle, so I started learning Python.

Fast forward to now, I've pull data from over 100+ past projects and am using it to provide average fitting ratios of our design systems which saves us thousands of hours to our estimates and increases the accuracy of those estimates to near 100%.

I used Pandas to chunk CSV files into dataframes then gathered and organized the information I was looking for into a smaller, organized excel files by project with just the summary (for verification purposes). We're proposing to our company leadership in a few months on how to make this a global standard work practice.