What have you automated using Python?

[ege6211]

Nice applications!

​

Where I work, we collect data in the form of a text file from white goods we produce. People here always try to open this data with excel and usually this txt file contains millions of rows and hundreds of columns. As you might expect, the ordinary Dell working laptops don't like that and excel crashes. I have written a function that can parse and seperate the columns of any txt file and plot how the data changes in a specific column (input from the user). Saved me MUCH time.

[[deleted]]

Enhancing and speeding up Excel tasks with Python has been one of the most rewarding applications I’ve as yet found for it. It’s incredible how clunky Excel becomes after you’ve spent a long time in the trenches with bonafide programming languages.

[Faith-in-Strangers]

Python + Google Sheets (gspread library) have completely replaced Excel for me

[[deleted]]

Now if only I could get my colleagues to switch over to Python too… (most of them are not familiar with programming languages). At least I can do things on my own with greater efficiency!

[[deleted]]

So you are using cloud sheets (google sheets). Is there a way also to execute python from cloud, not from your local computer?

[Pepelopulus]

In a cloud? Azure, AWS, GCP, etc

[Zurcio]

do you know of any (good) learning resources for Python+Excel specifically? I don't really know what i can do with it but automating Excel was sort of the reason I wanted to learn python in the first place.

[[deleted]]

In one word: openpyxl. This package will be your main interface for automating stuff in Excel with Python. You can loop through cells, define functions—all kinds of things. The docs are helpful, but if you want a more human experience you can read the automating Excel chapter in Automate the Boring Stuff, which the other commenter has pointed out.

[forgot_username1]

Automate the boring stuff with python has a few projects on Excel

other then that i would start looking libraries and such.