Python Automation Scripts

⏱ Estimated reading time: 2 min

Python Automation Scripts

Python is widely used for automation tasks, allowing developers to automate repetitive tasks, file operations, web scraping, emails, and system administration.

1. File and Folder Automation

• Creating, renaming, moving, and deleting files/folders using os and shutil.

import os
import shutil

# Create folder
os.mkdir('TestFolder')

# Rename folder
os.rename('TestFolder', 'NewFolder')

# Move folder
shutil.move('NewFolder', 'DestinationPath')

# Delete folder
os.rmdir('DestinationPath/NewFolder')

2. Working with CSV and Excel Files

• Reading and writing data using pandas.

import pandas as pd

# Read CSV
df = pd.read_csv('data.csv')

# Write CSV
df.to_csv('output.csv', index=False)

# Read Excel
df_excel = pd.read_excel('data.xlsx')

# Write Excel
df_excel.to_excel('output.xlsx', index=False)

3. Web Automation

• Automate browsers using Selenium.

from selenium import webdriver

driver = webdriver.Chrome(executable_path='chromedriver')
driver.get("https://www.google.com")

search_box = driver.find_element('name', 'q')
search_box.send_keys("Python Automation")
search_box.submit()

4. Email Automation

• Send emails using smtplib.

import smtplib

server = smtplib.SMTP('smtp.gmail.com', 587)
server.starttls()
server.login('youremail@gmail.com', 'password')
server.sendmail('youremail@gmail.com', 'recipient@gmail.com', 'Hello, this is an automated email!')
server.quit()

5. Web Scraping

• Extract data from websites using BeautifulSoup.

import requests
from bs4 import BeautifulSoup

url = "https://example.com"
response = requests.get(url)
soup = BeautifulSoup(response.text, 'html.parser')

# Extract all links
links = [a['href'] for a in soup.find_all('a', href=True)]
print(links)

6. Scheduling Tasks

• Run scripts automatically at intervals using schedule or cron jobs.

import schedule
import time

def job():
    print("Running automated task...")

schedule.every(10).seconds.do(job)

while True:
    schedule.run_pending()
    time.sleep(1)

7. Key Points

• Python automates file handling, web tasks, emails, and reports.

• Libraries like os, shutil, pandas, selenium, requests, BeautifulSoup are commonly used.

• Can schedule tasks using schedule module or operating system cron jobs.

• Saves time, reduces human errors, and improves productivity.