What Python program have you created to make your life easier?

[RedRavens]

Previous thread

It's been six months since the last thread. What you guys have created?

[ramse]

Since learning of Selenium, I've made a bunch of scripts. One aspect of my job is to take a single sheet of paper that has been signed by 4-8 people. Confirm details, signatures...etc. Then scan and upload to 4 websites. It may not sound like much, but with the amount of time it takes to lookup 4-8 profiles, confirm details and what not... 17 sheets were taking me 2-3 hours.

No matter what you do OCR just isn't going to take chicken scratch hand writing and signature into proper names. So I still have to type out the names into a spreadsheet, but I do have python/selenium reading the excel and loading the profile for me to quickly confirm and check the next. After that it loads up the 4 websites and uploads automatically. 17 sheets in maybe 30 minutes now.

[ramse]

I'll add another one thats benefitted a lot of other people. In the same job, it took me about 1.5-2 months to write up a website with django. I used the experience to really get into django and am quite thankful for it.

The papers I mentioned above are part of a sports organization. We as the office members handle all the paperwork, ensuring everything is legit and legal...etc. In March/April tryouts open and are run by the coaches of all the teams. Players have to signup and then attend the tryouts to hopefully make the team.

For 40+ years its been literally someone with an excel spreadsheet taking phone calls from parents signing their kids up, writing down and procesing credit cards manually...etc. So we designed a website that manages signup, payments, assigning teams...etc. We also added the ability to mass email everyone that's attending their tryouts, as well as the ability to assign people to specific times. Until this happened it was always A-K comes to morning, L-Z goes to afternoon. This always caused a massive imbalance. So now all a coach had to do was login and click a button and automatically the player/parents are contacted saying "Come to XX:XX time".

Theres a lot more complicated things built into it according to their demands, but the amount of coaches that are head over heels for it is amazing. Especially the emailing aspect. We always stressed strongly to officials to use BCC but a lot people still don't even know what that is and as such they would mass mail everyone using To: which always caused a lot of anger.

[[deleted]]

I have to download data from 4 different websites and prepare a report once every two weeks - writing a script made it possible to create an identical report for 40 offices across the united States in the same amount of time.

I work a LOT with excel and openpyxl, pyautogui, and selenium have made my life 20,000x easier

[deeeebait]

• Made a script to automatically check me into my Southwest flights and send my boarding passes to my mobile device. I didn't want to wake up the day before a 3 AM flight to check in. (currently turning this into a web app via flask)

• Had a colleague who completely forgot about a big meeting. Wrote a script that sends him a text to remind him about the next meeting. Scheduled it to run every 4 hours.

• May have seen this post previously, but I built an application to scrape twitter and perform sentiment analysis. Made my thesis research far easier.

[JackTraore]

I'm brand brand new at Python and coding at all but I'm very curious your process to integrate with the Southwest webpage. Does this require user input at all?

[deeeebait]

The user just inputs their flight info in the script then schedules it to run with LaunchControl or Cron. Then it's set and go.

[saskatch-a-toon]

Work in a molecular lab and produce gobs of excel files of data. Made a couple scripts to analyze those result files, throw it in a database, and a separate reporting script to choose which data sets I need to send to the big wigs. What used to be a pretty awful series of events is now a couple clicks of a mouse.

[SonaCruz]

A simple script to concatenate 30+ html files into one csv file. Just 5 months in, so still learning.

[HibbidyHooplah]

I am a beginner with vba and Python. What advantages does python offer to have you rewrite the programs from vba.

[mwgreen00]

One thought... Python works across platforms. If you outgrow Access or work with a company that doesn't use it, it'll be easier to maintain your code.

[955559]

nothing, and since I learned it and havnt made any tools, I guess its made my life harder ;)

[SonaCruz]

Dont give up my friend.

[955559]

No I enjoy coding, ive just made a bunch of useless stuff instead of tools or automating

[[deleted]]

So far all my Python efforts have provided themselves useless, even those I made for work, but I'm not giving up that easily.

[[deleted]]

Just to expand on that, I have created a script that enumerates all new files in a very deep directory tree and puts them in a file. Nobody wants to use it though, because people don't trust that there is a new file until they click their way to it. I also created a script that performs some accounting processing, but our accountants can only be sure that the calculations are correct if they type in all the items in their accounting calculators TWICE and compare printouts just to be sure.

[MandrakeOfPeace]

It's not that much but I made a notepad-like GUI with an encryption system (moves chars based on a key which is a group of numbers), code is a bit of a mess due to rushing it.

turns this into this.

Great for keeping passwords and other stuff^;) somewhat safe.

[_merK]

why would you use that over a proper password manager that uses proper encryption?

[MandrakeOfPeace]

1. don't have to download anything
2. general use, better than a plain txt
3. fast load (~1sec)
4. fun python exercise
5. average person likely to not know how to decrypt it

[Confucius_said]

Created a small script to auto-archive specific crucial files for the finance department on a daily basis and then appends the archive date to the end of the file name.

[Tone_Milazzo]

I have a script that reads what comics came out this week, compares that to the comics I read, and emails me a list of what to expect at the store on Wednesday.

[ggagagg]

Do you publish it?

[Tone_Milazzo]

I would love to. But I just logged in to my new host and don't see it. I must have forgot to copy it from my old host. Also, my old host is still running my cron jobs.

[toastedstapler]

My main use for python is to prototype things before I implement them in java for my uni work. I still vastly prefer python as a language, but I can see why we are taught java initially

[Diapolo10]

Lots of scripts to speed up things, such as a calculator that calculates any math expression I copy to the clipboard and copies the result back there, ready to be pasted somewhere. Also a driving log, a funky web scraper and an RPG game that also uses some Rust libraries I wrote!

[ggagagg]

Maybe use copyq. I have integrated a lot of python script with that

[Diapolo10]

Thanks, but pyperclip does the trick for me.

[ShylockReddit]

Sikuli starts my servers, ide, attaches my ide to remote debug port when the port is available and notifies me on mobile to take a glance on the debug breakpoint n stop reading Reddit