Tutorials Programming Tutorials, Guides & Best Practices

Example folder structure:

dataset/
    John/
        img1.jpg
        img2.jpg
    Sarah/
        img1.jpg
        img2.jpg

import smtplib

# Email configuration
EMAIL_ADDRESS = "your_email@example.com"
EMAIL_PASSWORD = "your_password"

def send_email_alert(product, price):
    subject = "Price Drop Alert!"
    body = f"The price of '{product}' has dropped to ${price}. Check it out here: {URL}"
    message = f"Subject: {subject}\n\n{body}"

    # Connect to the email server and send the email
    with smtplib.SMTP("smtp.gmail.com", 587) as server:
        server.starttls()
        server.login(EMAIL_ADDRESS, EMAIL_PASSWORD)
        server.sendmail(EMAIL_ADDRESS, EMAIL_ADDRESS, message)

    print("Email alert sent!")

Use the schedule library to run the script periodically (e.g., every hour).

• Read data from an Excel file.
• Perform calculations and manipulate the data.
• Format Excel cells dynamically.
• Automate the creation of summary reports.

Excel is a powerful tool, but manual tasks like calculating totals, applying conditional formatting, and creating charts can be time-consuming. Python provides an efficient way to automate these tasks, saving hours of effort while ensuring consistency and accuracy.