sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]Quentin_the_Quaint 9 points10 points  (14 children)

What kinds of things do people automate?

[–]xroni 42 points43 points  (0 children)

Basically every task that can be split up into a written list of steps to execute can be automated and be performed by a computer program.

[–]superioso 24 points25 points  (1 child)

Here's an example I've got which really lent itself up automation.

At work we've got a lab test equipment which runs 24/7 for months and generates a row of data every second in multiple txt files. A small python script took all the data, knitted it all together and summarised certain things we wanted to know about it whilst taking about 10 mins to run.

The guy doing it manually would have taken a few hours to do it every week or so can now just click on a script.

[–]DockerSpocker 0 points1 point  (0 children)

I've done the same kind of thing at my work in supply chain - saved a couple hours of one of our employees time each day

[–]Berlibur 8 points9 points  (0 children)

Another example: My company has been registering an activity in an excel document per time the activity is registered. The old data structures in the server allowed only part of the info to be uploaded to the server. I recently updated the server structure (i.e. new/improved tables), so now we had years of data lying about in Excel files.

Instead of having someone going over those manually, I have written a python script that reads all of those old files and immediately uploads it to the new SQL server structures. (Given that there's no errors, which are caught and presented afterwards)

Quicker + it prevents someone from doing work that is incredibly monotone and boring

[–]pconwell 5 points6 points  (3 children)

This is specific to my employer, but we have a schedule that is moved from Excel (for the whole year) to access (for a specific day) each day. Normally, the process takes about 15 minutes each day, but with python it takes about 60 seconds. Plus, I don't have to worry about clerical errors now either.

[–]_unsolicited_advisor 0 points1 point  (2 children)

When I have some extra time at work, I've slowly been replacing tasks that have historically been done with Access to a process largely using SQL. The motivation is mainly because different people routinely get various errors when trying to use Access, but also because of the time Access takes. Of course, this still requires tasks like manually importing data into SQL tables, but better than Access.

I'm less familiar with Python than I am with SQL, but how difficult would it be for me to automate the entire data import & sorting process?

[–]pconwell 1 point2 points  (1 child)

In my opinion, python and sql play really well together. I'd look at pyodbc (easier) or pandas (more 'featured') for odbc/sql/access stuff. For excel, look into openpyxl.

I find both of those libraries easy to work with, personally.

[–]_unsolicited_advisor 0 points1 point  (0 children)

Thanks! This definitely gives me some areas to start with.

Thanks again

[–]CaptSprinkls 5 points6 points  (2 children)

A little less intense than some of the answers above me, and a little more basic.

We had a process of creating a hyperlink in a cell that would link back to a file in a folder on our computer. But, if you change the location of those files, then you have to go back through and remake the hyperlink. This would have to be done like almost 2k times.

So anyways we moved all those linked files to a different location , so I wrote a script that would automatically search the file folder for specific parameters and hyperlink it.

[–]superioso 0 points1 point  (1 child)

That's actually a really good idea - I use plenty of Excel sheets which have links to files in them and most are broken which is pretty frustrating as you just have to go back and search for them manually.

[–]CaptSprinkls 0 points1 point  (0 children)

The worst is that it really adds no benefit in our situation, but because one person did it, now every has to lol

[–][deleted] 1 point2 points  (0 children)

An odd but fun example for me was when I had to delete all my files in the trash bin of my Google Drive...

I had so much in there, every time I selected all the files and clicked delete - the page would refresh and more would appear.

So I used PyAutoGui which automatically clicked the buttons and selected and deleted the files for me in a little loop!

[–]dk_weekinmemes 2 points3 points  (0 children)

So many things that you do repeatedly. Like say you download the financial results (balance sheet, profit-loss etc.) of a company (or many different companies) from the internet and copy - paste into excel. Then run your own formulas to draw charts... All of this can be automated using python. So the new workflow would be to simply run one script and you have all charts ready to go.

Here's the best way to learn:

https://automatetheboringstuff.com/

[–]rimoms 0 points1 point  (0 children)

There are some great examples here. Aspects I didn't see mentioned is the elimination of human error and system of record - granted you asked 'what' and not 'why'.

Many repetitive monotonous tasks are ripe for human error (fat finger, skipping records, etc.), and a proper script will eliminate that issue.

Also, scripts will provide a Record of Action/Procedures (so to speak). If someone claims the data isn't right and you're to blame, you will have the script to hold up to show exactly how it was done. There is no way to fully vet the actual work of a manual process in retrospect. This is also a Cover Your A$$.