Automation

Write a Python script that connects to an email account via IMAP. The script should scan the inbox for unread messages and move them to specific folders (e.g., 'Finance', 'Work', 'Personal') based on keywords found in the subject line or sender address. Ensure the script handles errors gracefully and logs its actions.

Create a script that runs once a day to visit a specific product page on a major e-commerce site. Extract the current product price and compare it to a target price. If the current price is lower than the target, send an email notification alerting the user. Include error handling for network issues or changes in the website structure.

Design a script that reads multiple CSV files from a specific directory, merges them based on a common column, and performs basic calculations (sum, average). The output should be a new Excel file with multiple sheets: 'Raw Data', 'Summary', and 'Charts'. The script should apply conditional formatting to the summary sheet.

Write a script that monitors the 'Downloads' folder. Every time a new file is added, the script should identify the file type (e.g., .pdf, .jpg, .exe) and move it to a corresponding subfolder (e.g., 'Documents', 'Images', 'Installers'). If the subfolder does not exist, the script should create it.

Develop an application that allows a user to write a post and select a future date and time. The app should use the APIs of platforms like Twitter or LinkedIn to schedule the post. Ensure the automation includes a validation step to check for character limits and restricted words before scheduling.

Build an automation pipeline where a user drops a PDF invoice into a folder. The system uses OCR (Optical Character Recognition) to extract the Invoice Number, Date, Vendor Name, and Total Amount. This data is then validated and automatically inserted into a SQL database or an ERP system.

Create a configuration file (e.g., Jenkinsfile or GitHub Actions workflow) that automates the process of building a Docker container from a code repository. The pipeline should run automated unit tests, and only if the tests pass, deploy the container to a staging environment. Include a step for rolling back if deployment fails.

Write an automated testing script using Selenium or Playwright. The script should navigate to a login page, test various scenarios (valid credentials, invalid password, empty fields), and verify the success/error messages. The script should generate a report indicating which test cases passed or failed.

Develop a script or daemon that runs every 5 minutes to check the current CPU and RAM usage of a Linux server. If the CPU usage exceeds 80% or memory usage exceeds 90% for two consecutive checks, the script should trigger an alert via Slack webhook or email and log the event in a system log file.

Outline the logic and write the code for a customer support bot. The bot should analyze incoming text messages. If keywords like 'refund', 'status', or 'password' are detected, it should categorize the ticket and automatically reply with the relevant FAQ information. If the query is too complex, it should escalate the issue to a human agent.