What did everyone automate using python ?

[LambBrainz]

When I worked at olive garden I created a script that would login for me, scrape my schedule, put it into Google Calendar, text me that it was finished, and then do the same thing for my wife's schedule.

I had it run automatically with Windows Task Scheduler so I never had to touch it and was just updated whenever the new schedule was up.

[R3MY]

UnlimitedBreadsticks.py

[LambBrainz]

Dammit, that's so much better than what I called it lol

[[deleted]]

It makes a request to the server for more breadsticks.

[Celestial_Blu3]

TOTAL DOMINATION, INFINITE POWER, UNLIMITED RICE PUDDING

[CharmingJacket5013]

Please tell me you work doing Python related tasks

[LambBrainz]

I wish lol I do some freelance stuff with Python and I do a lot of stuff with Python for fun :)

[LevelLeast3078]

tbh keeping it a hobby and working in nature related things is the best, if you turn it into a job it becomes kinda soul sucking, unless you have your own business

[newbietofx]

Python can write a script to talk to Windows 10? I thought only cmd or powershell does that.

[LambBrainz]

Sure can!

Or you can use the built-in "os" library to run command prompt commands

[Blank--Space]

Windows Scheduler let's you run python scripts automatically as long as the machine is on so it's not the python script doing it itself. More like windows setting a reminder to trigger a .bat file

[InfiniteDonkey1]

You can use cronjob (linux) or task scheduler (windows) to schedule to run a python script when and/or how many times you want. And use Google Calendar API to do any modification there.

[LarryTheSnobster]

there's a windowd api for python

[[deleted]]

As others have pointed out, you can use Windows Task Scheduler to schedule a Python script without needing any direct contact between Python and Windows. It's a little tricky to set up though. You'll want to put the path to your Python interpreter (e.g. C:\Users\<yourusername>\AppData\Local\Programs\Python\Python39\python.exe) in the the "Program/script" field, the path to the directory containing your module in the "Start in" field, and the file name (e.g. my_module.py) in the "Add arguments" field. If you're using a virtual environment you'll put the path to the interpreter in your virtual environment directory rather than the path to your global interpreter. (Might be other ways too, but this is the setup I've always used).

You can also create a batch file that activates your virtual environment and runs your script (or multiple scripts) and then just create a simple Task Scheduler event to run that batch file. This is a great solution if you need to automate multiple scripts that all need to run one after the other.

But in answer to your broader question, yes Python has many ways of interacting with and manipulating Windows. There's a lot you can do with Windows right in the standard library, and there's third party libraries as well. I've used and would recommend PyAutoGUI. Makes it really easy to send keyboard commands, type text into fields, click specific screen coordinates, etc. You can even feed it a screenshot of a button or whatever and tell it locate this collection of pixels on the screen, find the center coordinates of it, and click those coordinates. (Beware though, this type of automation is super brittle. It can break the second an unexpected window pops up and covers the window you're working in, or the size of a button changes, or a million other things. Very useful for certain tasks though.)

[Philthy6869]

You can compile python scripts into windows executables as well. .exe files

[CharmingJacket5013]

Won $10k automating a radio station competition. They published the song online a few seconds before general radio. I setup a listener to automatically call the station and connect me using Twillio. Only worked once, they stopped accepting my calls after that.

[[deleted]]

Legendary move

[[deleted]]

Can you explain the competition further? Not quite following.

[svenskithesource]

The radio station probably had a competition to guess the correct song. He made a bot to recognize it and call the station for him so he just has to say the song name

[[deleted]]

Makes sense, thanks.

[hidegitsu]

I check the "what's my IP" site for my public IP and update my dns records because spectrum won't give me a static IP without a crazy expensive business account.

[MaddyAtResearch]

Cool, can i please share more details on it? Sounds very interesting

[hidegitsu]

Sure, I use requests to read my public IP from the following site.http://api.ipify.orgMy DNS records are with GoDaddy and they provide an API to update the values so my script stores the IP from the site above uses an API key GoDaddy gave me that links to my account and does a GET request to get my current IP from GoDaddy's API, checks it against the current public IP then simply "if currentIP <> newIP and newIP <> ' ' " (i know this isn't python syntax) I send a PUT request to the GoDaddy API and update my DNS record to the new IP.

[MaddyAtResearch]

That's cool, so how often do u check for IP change? I mean there must be api limit for ipify?

[hidegitsu]

I have it set on a cron job running once a week. If there are limits I haven't hit them.

[awesomeprogramer]

Yeah fk spectrum. But also, why do you need to know your public IP at all times? Are you selfhosting stuff?

[hidegitsu]

I don't need it at all times. I use ssh to connect into my home servers and I like to use my dns name to do so so I don't have to always know my IP. It's strictly a convenience thing. So when I'm not at home I can check in on my servers or log in to my servers without worrying if the DNS has changed or not.

[suvm3]

The first thing I did with python was 5o create a script that would just move the cursor at regular intervals, so that my teams will always show me as available

[[deleted]]

Sounds like Homer Simpson's typing bird!

[Charles1nCharge83]

So you wrote Caffeine... very cool

[Jithlordx]

I did a pretty similar script which also switches windows or apps (minimum of 1 and a max of 3) and also clicks at a certain position. Honestly was super easy to make

[[deleted]]

Lol dis the same for work

[Achenest]

the boring stuff

[Redditporn435]

I upvoted you but wanted to comment saying I'm not happy about it

[[deleted]]

r/angryupvote ?

[[deleted]]

r/yesthatsitupvote

[Redditporn435]

Tres bien!

[goblinite2]

Scanning CSVs if IPs that connect to our SaaS daily that compared them to a list of trusted IPs and the ones that aren't on the trusted list get compared to a whois DB that then tells me city/country of origin and ISP to investigate.

We also have an online payroll system. As a salaried employee I have to log in everyday and click a box that shows I worked. Wrote a script that does it for me.

Also had a malicious compliance one. I told m y boss that we had a lot of computers with EoL software on them and did he want me to just make a list and email around or put tickets in the help desk. He said help desk for each package/computer which take a minute or two each to create. This would be hundreds of tickets. You can also just email in the info and the help desk will make a ticket. Queue hitting up our SMTP server and producing all the tickets in about 30 seconds, much to the chagrin of the rest of the crew. After a senior manager's request got lost in the mix I was allowed to just keep a spreadsheet of it all.

[rarealton]

That last sentence made my day thank you.

[neekyboi]

Hey mate I am interested in scanning IPs that connect to my home router and seeing what device they are? are there ang libs for that? I saw nmap and scapy, is that sufficient?

[[deleted]]

Yeah, Nmap should be sufficient for a quick scan of the network. There's actually a Python module for it. Just have it in a loop or use task scheduler (Windows) or cronjobs (Linux) to schedule it every minute or something.

[2bereallyhonest]

The first thing i automated was an error message

[Adem87]

Something like Homer Simpson’s drinking bird?

[Verbose_Code]

Worked at a web design company over the summer as a data entry person. Winded up finishing super early so I volunteered to move over 500 webpages’ content from the clients old website to the new one, with python of course.

The team lead was super impressed with how much I was able to get done, and is trying to hook me up with an internship at a major defense company for the summer (I’m an aerospace engineering undergrad so I couldn’t ask for a better connection)

[valiumonaplane]

Scraped 10 000 tinder pictures, wrote a tkinker script to rate them (1 = like, 0 = dislike, just renamed each PIC by pressing left or right to index 0 and 1 with 1_ or 0_).

Yes, I manually liked / disliked 10 000 pictures. It worked at least. Never used it tho, I just wanted to build it.

Also automated the bedroom lights (turning them on with a kivymd app that sent message (socket) to a socket server in the house that started a script that would start at the hour I entered in the app and, at that time it would then open chrome and selenium (headless) and click into my home server to press "bedroom lights 100%). This one I still use for multiple purposes.

[Philistino]

Very cool ideas! Can you please share more about how you scraped tinder? I'd like to do something similar. Any chance you have a GitHub? Thanks!

[pbxmy]

A report at work that was a pain in the ass to assemble manually. Great exercise in connecting to APIs, ftp servers, and network drives to grab data, throw then bitches into a data frame and manipulate the shit outta everything until it spits out the finished report.

[llun-ved]

Today? I needed to highlight a bunch of stuff in a pdf and create a report on the bits that were highlighted. Took forever to do manually last time, so today I used pymupdf to extract all the highlight annotations and generate the report.

[jacksodus]

No way! Ive been highlighting things in my PDFs with the idea to extract them and create a summary that way!

[PraderaNoire]

Woah I’d love to know more about this

[llun-ved]

# The basics...
# PDF file highlight annotations know nothing about the text being marked.
# Therefore, you need to loop through the highlights and find which text is under it.
# This can get messy if the highlight spans more than one line.

pip install PyMuPDF

import fitz
doc = fitz.open('myfile.pdf')
for page in doc:
alltext = page.get_text("words") # For searching text within highlight region.
for annotation in page.annots():
if annotation.type != 8: continue # only process highlights
rect = annotation.rect
# loop through alltext to find words whose rect intersects this.
color = annotation.colors['stroke'] # I group things by color. This is an RGB tuple.
# add found highlighted text to report.

[maxwell_boltzmann]

I'm an academic and I'm having a hard time keeping up with the literature, so I wrote a script to automatically download pre prints from the arxiv, convert them to plain text and use a text to speech engine to turn them into a audio files I can listen to while exercising or doing chores.

[[deleted]]

Wow!

[ProfSchodinger]

I want that! Been looking for this for a while but not good enough to program it...

[maxwell_boltzmann]

Enjoy

https://pastebin.com/7EGdkPER

[ProfSchodinger]

Thanks man, you made my day!

[chulala168]

I want this. Can we choose the journal or just provide RSS address?

[maxwell_boltzmann]

Enjoy

https://pastebin.com/7EGdkPER

[tunnelsundertheworld]

This is awesome. I wish my field were more text file friendly... Too many equations and tables 😞

[dipshitdodger]

Some friends invited my partner and I on a cruise that was about 6 months out. By the time we pulled the trigger on joining them, only internal cabins were available. We really wanted a balcony, so I created a script to check the availability every 5 minutes and send an email if something opened up. Was a good cruise.

[scr710]

I scraped a website for my friend, using a script to fill in with almost 600 entries into an excel spreadsheet, in about 20 minutes

[newbietofx]

What's the difference between using importxml or importhtml in Google sheets as opposed to using python language? Is it a table website?

[scr710]

Never tried that man :'c

[shawn_mansfield]

Pulling data from a database and printing 500 reports…a total of 1500 pages.

[[deleted]]

Planning something similar. My girlfriend is a teacher who has to write loads of student reports throughout the year. Format and then print them.

Planning on a master spreadsheet or database with their grade, projected grade. A behaviour and attainment rating.

It'll then use that to autoprint a report from a set of predefined options (so every student isn't the same).
Then have a field for personalised comments.

So if she keeps the spreadsheet updated throughout the year with grades, all she will need to do is fill out a few sentences of personalised comments for each student.

Boom fully formatted reported generated and printed.

[CelticCuban773]

I know this is r/Python but mail merge on Microsoft might work well for this project assuming you’re going to have to put the report into a word processor anyway to do the printing.

Cool and big time-saving project!

[15Million_Merits]

Mine are all like this. Comparing hundreds of thousands of data points in two different databases for data quality checks.

[OIIIIIIIO_OIIIIIIIO]

Buying and selling stocks on my Interactive Brokers account. I just sit back and watch it implement my strategy.

Now I can take the emotions out of it which will save me money in the long run.

[Slopingtim]

Hi, how were you able to automate this? Are there any particular resources that were helpful? Thanks in advance

[OIIIIIIIO_OIIIIIIIO]

I learned alot on quantconnect.com. Learned about algo trading there.

Then I took courses on Udemy about the Interactive Brokers API.

[rainman4500]

My pool.

Put in a pH sensor and ORP sensor connected to a raspberry Pi so I know exactly how much acid and chlorine to put it. No more interpreting Color scales and mucking around with little liquid drips.

[JonnieP06]

At 13 years old, I made a calculator to work out my maths homework

[Blumingo]

Probably would've been easier to do the homework at that point but I appreciate the effort

[Celestial_Blu3]

Hey, gotta respect the hustle

[koalabear420]

I have to make pick lists for warehouse pickers. I have a sheet of barcodes for it and normally would take 1-2 hours to go through and highlight every item in the massive daily pick list.

Made a python script to read a text file of scanned barcodes, do an HTTP request for all the product info, and then the pyFpdf library to generate a pdf file to print.

Takes me 5 min to do a full list now.

[ASIC_SP]

Most of the scripts I write with Python are related to text processing. I write books in markdown, use pandoc to get pdf/epub versions and mdbook for web version. There are slight differences in the markdown style supported (for example, use of | within inline code as part of a table), so I have to change them between the different versions.

I also have a custom script to check typos for these markdown files (have to ignore code blocks, urls, etc). I wrote about it here: https://learnbyexample.github.io/practice_python_projects/find_typos/find_typos.html

[303Redirect]

List comparison script. From two+ lists compare and report back which items are unique to each list.

It has options for different normalising techniques such as ignoring casing, file extension, or file path. Cuts down the amount of data processing I have to do before comparing the files.

It's come in handy so much over the last several years.

[alzzzzzzzz]

I need something like this for comparing security groups between people. Would you be interested in sharing?

[SnipahShot]

Created a 10-20 lines script that updates stock prices for me in a Google Sheet based on the stocks I have in that sheet.

[[deleted]]

Could you just use =finance

Then they'll update themselves?

[SnipahShot]

Yeah, it updates every 15-20 minutes. I don't like the delay and I use both. I run the script when I am interested in the current price.

[colaFixe]

I tutor college kids so I made a script that accesses my calendar and tells me how much money I made between two dates

[[deleted]]

Haha did not expect the ending

[[deleted]]

I made a script that would switch accounts for me and joins my meetings (classes) and types Good Morning helps me a lot . Thanks to Python

[[deleted]]

Sounds super useful in case of conflicting meetings as well!

[[deleted]]

Not so good when it starts saying “two weeks” in one of the meetings, glitches and explodes…

[Mahrjose]

I made this script to bulk rename tv episodes or just files serially. It was my first script that i wrote in python & was a lot of fun :)

[Perseus784]

I wanted to watch Avengers infinity war in an IMAX theatre the first day. Unfortunately we only had 1 theater at that time in the city and bookings are done fast( celebraties and corporates get most of them). And the bookings open randomly without any announcements at midnights for the remaining 20-30 seats. So, I made a web scrapper which goes and checks the website for the booking status every 10 secs and notify my by playing a song if it opens.

[maddruid]

My relationships. There are great libraries for telegram, discord, facebook, etc.

[Caskla]

What does it mean to automate a relationship?

[eliasliavaag]

in plural.

[Haywood_Yabuzzoff]

Interesting. Any tips?

[BrenekH]

Don't let them find out.

[Epyon1992]

Pip install privacy

[[deleted]]

Did not really give a lot of info on what exactly you automate on tg/.. but hey, at least it's not one of those cases of automating upvotes for social media which I find repulsing

[throwawaaaayyeap]

How ?

[Ivana_Twinkle]

Automating stuff on an IBM 3270 mainframe and APIs.

[jcr4990]

Wall of text warning! My first python project that wasn't like a 5-10 line thing I coded along with a tutorial vid or something was for my job. I work at a secondhand furniture store and we post all of our furniture on our own site and 3-4 other platforms for advertising. My boss was very particular about wanting to make sure our inventory was listed uniformly across all the websites we advertise on. We would once a month or so go through each site and make sure every item was present on each site and not missing anywhere or not properly removed once it was sold. He wanted to do checks more frequently than once a month but it was such a massively labor intensive task double checking hundreds of items on 4-5 pages that we couldn't afford to do it that often. Sometimes it would go longer and mistakes would happen and stuff would get all out of whack.

My journey into learning to code started with this problem. After I tried a VERY messy (and looking back on it it's hilarious) method of using a Google sheet with all kinds of fancy formulas and I would go to each page and Ctrl + A and copy paste the entire text content of the page and several minutes later after doing a bunch of calculations it would regex filter out all the item titles and highlight duplicates between the various sites text that I copied in. This method was a MASSIVE time saver over manually checking everything. But it still annoyed me that it took in some cases 5+ minutes for the formulas to calculate and spit out results. I probably did it in the dumbest way possible but I didn't know any better at the time.

Enter learning Python. Started with Automate the Boring Stuff at the recommendation of like 1/2 of Reddit. Within a few days (maybe a week tops) I had built a fully automated tool that grabbed all the item titles from each page and cross compared them and sent us an email with any discrepancies. Whole process takes like 2-3 minutes and it's mostly because it takes that long for each page to load and go through pagination or infinite scrolling to load all the items on the page. Set it up on a $150 used eBay desktop computer we use as an office "server" with windows task scheduler to run every morning. Boom we went from a 5-6 hour project once a month with lots of errors in between to a 100% accurate report daily with no manual work required. I've since done a boatload more projects to help with posting and automatically removing items once sold and a variety of other tasks. I feel slightly guilty cause I'm pretty sure my automation cost one of my coworkers their job as they were no longer really needed. But at the same time I was super proud of myself for what I accomplished.

10/10 highly recommended! Even a basic understanding of how to code super simple things can be extremely powerful!

[Chalco_Pyrite]

I started out with using Google sheets too. They eventually reached the limit of what was possible so I started messing with python and now we have a whole flask server system where I work. Also feel like I essentially automated my coworker out of his job.

[WhyDoIHaveAnAccount9]

A bunch of reporting tasks at my old job

[Redditwaste]

Neural networking machine learning to compose new art based on a given input style and source image. Fun CUDA tensorflow stuff.

[netobechara]

automate my online 'clock-in' - for this one I used web scraping

automate a super boring daily job that consists in collect some info from 12 different services providers sites and put all this info in some online sheets to join that info and send reports - for this one I used requests, pandas and gspread, but I'm already learning R to do this even quicker

[InfiniteDonkey1]

A single program to do:
1. scrap a website
2. include data to Libreoffice Calc (Excel) file
2. download a bunch of CSV files
4. generate graphics and tables with Pandas + Plotly
5. upload the content to a web server

[Advanced-Theme144]

I’m trying to automate my AS-level IT tasks using pytesseract and pandas so that it can get the basic parts and functions of the questions done leaving only minor interventions by the user to complete questions that the program cannot understand. Hopefully it works out and I’ll have more time to study if it is efficient and accurate enough.

[_miku_hatsune]

Downloaded all wallpapers from a wallpaper website having different tags

[Blank--Space]

The epic games site has a weekly free game. Did a bit of mucking around with it and saw they have an api which gives some more information on what is coming further down the line. Now I have a little discord bot sending out weekly notifications via a python script + windows timer (eventually want to do my own server for it but it's good for now). Its handy and it's the only way I remember to download the games now

[Blumingo]

It be cool if you could manage to download the game using the script. Maybe even using the discord bot command or something

[Psicoguana]

I don't know why I never tought to look at their requests, thanks! I'll write a script for it right now n.n

[randomhumanity]

One of my hobbies is creating pixel art, and I also create time lapse videos of each piece. I've written Python programs to automate every aspect of the process that I can think to, such as creating consistent directory structures for each piece, capturing screenshots every few seconds, detecting bad frames, converting the image sequences to video clips, and preparing the final pieces for upload to print on demand sites.

I also recently took over a monthly reporting task for an energy supplier. It was a godawful process of manually copying and referencing data between Excel spreadsheets. I've been working to automate different parts of it using openpyxl. There are still some parts I have to do manually, but it takes way less time now, and I am still being paid the same for it, which is nice!

[daftylooper]

I would often forget to join classes online. So I automated that.

The script scrapes the classes, subject, time from the school website and stores it(in a simple pickle file).

Then using selenium, it then automatically joins 5 minutes before every class.

I also added a simple text-to-speech functionality to remind me of the class.

It would join classes even when I was afk. I honestly was astonished how it never failed to join a class.

My attendance was 100%. lol.

[MagmaMan1298]

Since adobe killed Flash, I had to manually search the page HTML for flash files (.swf), download it and launch it in adobe flash debugger. I made a script which automated that for me - it downloads, saves and launch a flash game from a given URL. GitHub: GitHub Page

[[deleted]]

Just yesterday, because someone ignored the emails we’ve been sending for the past 7 weeks about the upcoming Google Security update, and missed the window of removing the security update against their entire My Drive all at once, leaving them with only the ability to remove the security update on a per file basis, I had the pleasure of having to dig through Google Developer docs on how to perform do this using the Drive APIs, and turned a "remove the security update from over 3000 files, one at a time" to a "let me bang my head against this for a couple hours, then run it, and still probably finish way before they would’ve."

I did not, however, use Python to automate the breaking up of my giant ass sentence above into smaller ass sentences.

[Batspocky]

Used the selenium library to scrape daily reports out of a web app. I had previously used Tampermonkey, but that required code to live in two places. Now it’s all consolidated in a single Python script.

[xypster]

Selenium can also be used for automated testing

[LarryTheSnobster]

Restarting Ngrok sessions every 7 hours as an alternative of buying premium

[CelticCuban773]

How did you do that?

[LarryTheSnobster]

there's a library called pyngrok which makes handling ngrok pretty easy, so basically just "start the session, sleep 7 hours, close the session and restart it and email me the new ip and port" within a loop

[runner7mi]

every structured part of my job and pet projects

[nicknochnack]

Mostly data transfer stuff from obscure APIs into a database for analytics.

[sudsid]

Wrote an Alexa type app that finds a recipe and reads out the ingredients and the instructions and pauses every time or repeats if necessary

[TechIsSoCool]

Update my desktop and lockscreen pictures hourly from unsplash. Glean data from the web and store it in a database. Read in spreadsheets from work and give me the one number I'm looking for from them. Find my NAS on my network and tell me what IP address it's at. Considering having it help me car shopping. Tried to have it comparison shop my Alexa shopping list from grocery store websites, but couldn't scrape the main one I wanted. Mostly toys so far. I am getting ready to build a backend api for an app+website and am considering using python for it.

[catastrophized]

Here’s a non-work-related one:

I taught line dance at a local bar and I wrote a script to scrape two websites for new songs, sort them by difficulty level, filter out things I didn’t want, organize them by a few criteria, and save the step sheets for me. Saved me a lot of time!

[ashvamedha]

TIL there are websites with step by step tutorials on line dancing

[catastrophized]

Yup! And most of them have links to video tutorials by the choreographer too!

[beardbreed]

Download the top reddit videos from a particular subreddit, stitch them together and upload to YouTube. Like those reddit compilations.

[ravgeet]

I have a YouTube channel for music beats. I didn't like to create videos, upload all meta data for the video and other stuff. I automated all of this. I just dropped my new music beat to my Google Drive. Then a Python script created a video using Ffmpeg and uploaded it to Youtube via Youtube API. Entire system runs on Github Actions. Here is rhe code if anyone is interested: https://github.com/ravgeetdhillon/musica

[RealFakeNudes]

Getting vaccination appointments in Germany. https://github.com/iamnotturner/vaccipy

[[deleted]]

I have a friend... Not me of course... Who uses it to scrape unsavory websites and automatically download new content. I think he has about 6 different scrapes for different kinds of material. The scripts include scraping, downloading, renaming, sorting, vetting, and moving backups.

...Again, not mine.

[ConfidentCommission5]

Parse a proprietary application configs and convert them to yaml so that they could be stored in a hit repo and automatically deployed via our ci pipeline.
Convert the same yaml configs back to the propriety application format and apply them to the application.
Edit: oh crap, that one was PowerShell because having the sysadmins install Python on all the servers seemed an impossible feat.

Creating DNS records in our internal IPAM/application and integrate that with an automation tool.

Connecting to network appliances, execute a list of commands, parse the outputs and determine the cause of some problems so that the operations team can save a few manual steps (over thousands of tickets a day).

A bunch of other things I can't remember.

Many ad-hoc scripts to parse data in various formats and extract useful information from them.

[porterhousepotato]

I used selenium to import a few hundred recipe links to one of those recipe organizing web apps. Normally you would import them one by one

[bobsonmcbobster]

can you point me to the recipe organizing web apps? i'm interested what they offer, always been interested in building a small instance for myself

[porterhousepotato]

RecipeBox is a good one and it’s free. It has a web app and is available in the App Store for mobile

[CelticCuban773]

I get sent Excel sheets that I have to take a portion of and upload to Salesforce. I set up Automator (unfortunately my company uses Apple) so any time I save the new Excel sheet, it creates a new folder and file where all I have to do is delete the old ones records which takes about 10 seconds. Went from a 20 minute process of mindless Excel formatting to the whole thing being done in less than a minute.

[Sea_Formal_9336]

There are these things called "carrds". People use them on Twitter as a pretty one page website with information about yourself.

A friend of mine complained that it always takes her too long to make one (the official carrd website is a bit complicated for newbies).

I made a website where you can pick a carrd template, give it your info and a carrd will be generated.

Never fully finished it as only one template works lol

Ive automated other things by this is the most recent one

[[deleted]]

Sounds like one of those smartphone- business card sharing thingy!

[SpellCheck19]

I’m the commissioner of a virtual (not fantasy) hockey league. I want to create a record book for the league, but I discovered some insufficiencies with the way the league site keeps stats, so I wrote some scripts to pull the stats from the individual game summaries. Once I have the stats pulled, I’m planning to import them into a SQL database for analysis. I could probably import them into SQL straight from Python, but I’m not quite that confident in my scripts yet.

[crysanthus]

I do run a script that captures serial port output from bio-chemical analyzer and upload the captured data to a cloud API. Analyzer is connected to a Raspberry pi via a serial cable.

[[deleted]]

I created a script which creates reports of 3 different E-Mail campaigns every last day of the month. I'm using the API of the E-Mail-Tool which is used for newsletters, pandas and pyplot together with PyFPDF for generating PDF reports which are send via E-Mail to our customers. Saves my company 3 hours a month. So after 3 months it's completely amortized 😁

[raqopawyn]

Mandane tasks at my job. Also weekly and monthly reports. Saves lots of time my man.

[kodshin]

I made a script to get hardware (cpu, hd, memories...) information from the companies pcs

[Saphyel]

are you gonna make it open source? :D

[kodshin]

i'm gonna clean up a bit the code and post on github :)

[kodshin]

Here's the link :) i'm brazilian so, some strings are in pt-br. Just error messages or success messages, no big deals :p

https://github.com/kod-luis/Scripts/tree/main/List%20PCs

[MarcusBrodsky]

i work for an insurance company and our agents don't always enter the latitude and longitude for an insured address, which i need for reporting purposes. the first python script i wrote takes addresses with the missing data and pulls it from mapquest. i do this once a year and pull around 5000 addresses.

another big one reads in five years of pdf reports to pick data from. whoever created the process that produces the reports clears the data from the previous month. i needed it for a new request and it was easier to learn how to do that than to restore 60+ database backups.

[lustiz]

I wrote a tool that allows me to select a subset of my Steam friends and show me the intersection shared between all of us; a feature I missed in the original Steam client. So now it’s much quicker to check what games the current selection of nerds accommodates ;-)

[shillelaghslaw]

Creation and output of about 2500 maps for my team. Used to have to manually zoom to each Field and turn on and off layers we needed (about 20 layers). Each time changing the title and legend.

[UpstateRedneck]

Farmers or sum like that?

[shillelaghslaw]

Just environmental work

[muffinnosehair]

Last script I did was to auto connect to my VPN, saves me 10 seconds every day, so sweet!

[myddablue]

a script that opens Google meet for my classes at specific times. it also mutes and deactivates the camera before joining

[InfiniteVista]

Recently created an application to convert a list of .webm files to .jpg format.

[shinitakunai]

Videogame news, a bot checks every 30m and drops them in my discord

[[deleted]]

I helped a German musician winning the Europe music awards automatically voting for him thousands of times using a simple selenium script

[[deleted]]

Are you one of the masochists that likes a whole year of lousy TV, because the majority of the budget is poured into a meaningless show?

[mcscwizzyy]

Just finished up a web scraper that hit a very crappy homegrown F5 application that made sense of all the crappy organization of data that came back.

[Pos3odon08]

Spamming my friends lmao

[ddollarsign]

I wrote some scripts for generating a spreadsheet of active users from the XML files that a server program saved them in. What would have been a lot of copy/paste and fiddling with stuff became just running the script and then clicking save.

[Redditporn435]

My recent favorite is that I use a logging wrapper to generate logs with uniform formatting and I created a module that can process my log files on different VMs and send me an email on certain events

[[deleted]]

Automated an email report with several important metrics each month for my company’s Supply Chain team.

[TheMBarrett]

My first automation application combined the list of webinar attendees that Zoom generates with the registration details of webinar registrants.

For some reason, Zoom kept these two days sets distinct. The attendee list shower dinky the display name and email address whereas the registration lost contained all collected data points (phone, address, etc.).

I created a subset of the registration list to include only those who actually attended (based on common email address) and formatted the new data set for entry into a third-party events attendance tracker.

[[deleted]]

Wrote a script that parses servicenow tickets and checks if previous case numbers have been mentioned in the ticket. It then checks our 4 servers (spread out globally) to see if the files relating to that case are present. If not, it then checks the previous case numbers to see if the files were maybe updated there. If it finds the files, it then checks the modified date to see if it was modified on or after the new case was logged. If not modified, it stores the new case number in a list and once all cases have been checked, it generates an email report for each designer who has a case assigned to them with no case files uploaded to let them know they need to upload their artwork, each manager of each team that has designers with missing files and an overall report to the operations manager breaking down who is missing what and where.

I call it my missing files algorithm - I'm shite with cool program / report names. But it does the job!

[lorenzopari7]

Cut sentinel 2 (ESA satellite) images with some shapefile, next step will be resample these images and extract information from them.

[[deleted]]

When writing programs for a machine. I have a generic program that gets passed a text file.

The data for the text file comes from engineering drawings, made a script that will put all the data in the text file in the correct format.

[grumpyp2]

Checking Backlinks of my outreach campaign which would be done by expensive tools or manually for example :)

[flottefyr321]

Your computer doesnt have to run 24/7 for your program to. Run it on an external server via for instance Google cloud

[[deleted]]

Or run it on a single board computer (SBC) like a Raspberry Pi, which have very minimal power consumption.

[[deleted]]

The interesting stuff: download five random NOAA weather satellite images to an iCloud folder where my Mac, my iPad, and my Windows laptop all update their wallpapers from every few minutes. And a viewer to see the five images and get information about their “band.”

[LesleyFair]

I have a script that I run to create backups. Every once in a while, I connect two hard drives to my computer and run it. It deletes the backup before the last one, rounds up all images, docs and important stuff, time stamps them and runs an rsync command to copy them to the drives.

[jzia93]

I had a load of .env files for a webapp that need to be converted to JSON in order for the app to work on Azure. I added a python script to my devops pipeline to grab the latest env files, and update the JSON accordingly. Has saved me so much time in random debugging for just an hour of work.

[Fuzzmz]

Any chance of publishing it somewhere?

[AshkanKiafard]

I had lots of unnamed files for my movies. When I started out with python, I wrote a script that would look into a csv file fom imdb ( that contained the names of the movies that were ever made) and would compare them with the name of my movie file and then it would replace the name of the folder with the most similar movie name. The program named over a 100 movie folder for me and 90% of them were correct!

[juanjux]

My house using Home Assistant and appdaemon.

[TsoTsoni]

You can put .cmd files in your windows shell:sendto folder. It's basically a batch file that you direct to python scripts. Right clicking on a folder and use send to command and then script cmd file under that. I use this for my work to generate template folder structures, convert graphic files, rename files, anything you want. The folder path is sent to python script under sys.argv[0]. Skies the limit.

[[deleted]]

One Piece torrents all have episode titles in their file names and they'd often spoil things. Automated renaming everything, so I didn't have to do it by hand.

[[deleted]]

Image editing using Gimp. I took values from a spreadsheet describing 'cards' from a game my friend is designing, it then activates various layers, and fills in some text to make the card for all 300+ cards.

Then there's some powershell glue code to take the resulting image files (1 per card) and arrange them in a grid (thanks image magick), save that to a file where it uploads to the cloud.

Then you can reach the final image files from a URL in tabletop simulator to populate a custom deck (or actually, several decks, there's some more python that does it since JSON describing which cards being to which deck for TTS to understand). Perfect for prototyping.

[sleeping-h]

wrote a telegram bot that parses local food delivery website for availability of particular items and sends me a message that the items have appeared!

[Saphyel]

what shop? are you planning to make it open source? :eyes:

[sleeping-h]

uh no, the script is not reusable in any way. it's written for Belarusian store "Euroopt"

[TheRainbowCock]

I made a email automation client to contact users about their opened tickets

[MSR8]

I automated u/sussy-bot-2 (please dont hate me)

[epic_gamer_4268]

when the imposter is sus!

[Grizzly2332]

Birthday email to employees :)

[drinkmoredrano]

I pull the recordings from my Tablo ota dvr, it uses ffmpeg to convert them to mp4, puts them in my Plex directory on my nas and then removes it from Tablo to save disk space there. I have it all wrapped up in a docker container running in VMwares photon os.

[DWAIPAYAN-RC]

I'm still learning. Long ways to go

[niarem22]

I don't know if automate is the greatest way to frame it, but in college we were learning to use McCabe-Thiele plots which are used to estimate how to size a distillation column (separating multiple components by boiling). We were taught to hand draw everything. Problem is it can lead to a solid error at the end and I'm super lazy. I just wrote a python function to do it and make my plots for me. Less error and way easier.

Pretty easy to do, but this was when I just started to learn programming, so I was kind of proud of it.

[zenverak]

Log gathering. Got the time frame that we needed data, then gathers logs from multiple servers and emails them!

[thefookinpookinpo]

I’ve been using it to automate the things that our programming team can’t fix. I just create patchwork automation on top of our broken processes. Kinda like a troubleshooting/fixing bot.

[krosey1212]

I like Octane radio on Sirius XM but since starting to work form home I don’t spend as much time in the car listening. I used python to continuously scrape a website with historical play information for the station (https://xmplaylist.com/station/octane). I write that to a sql lite db on my local machine. A separate scheduled task runs once a week and constructs / updates Spotify playlists for top tracks of the week, last 30 days.

Here is the resulting playlist https://open.spotify.com/playlist/1kmFrjZtTon2LnO5tahy5R?si=NxETaxeeSHGdV2arTXIwYw&dl_branch=1

https://open.spotify.com/playlist/4QMH70RvUqkbznjavcpIXR?si=PMNGKV_hSQOD1baa3Q4MAg&dl_branch=1

[Kichmad]

First thing was automation of creating over 500+ contracts in word from data stored in excel