How can I automate tasks using Python in real-world scenarios?

How can I automate tasks using Python in real-world scenarios?

You can use Python libraries like selenium for web automation, pandas for data manipulation, and schedule for task scheduling.

Can you give me an example of using Selenium for web scraping?

Sure! You can use Selenium to open a browser, navigate to a webpage, and extract data. For example:

from selenium import webdriver

# Set up the driver
driver = webdriver.Chrome()

# Open a webpage
driver.get('https://example.com')

# Extract data
content = driver.find_element_by_id('content').text
print(content)

# Close the driver
driver.quit()

What about automating Excel tasks with Python?

You can use the openpyxl library to read and write Excel files. For example:

import openpyxl

# Load a workbook
wb = openpyxl.load_workbook('file.xlsx')

# Select a sheet
sheet = wb.active

# Read a cell
value = sheet['A1'].value
print(value)

# Write to a cell
sheet['A2'] = 'Hello, World!'
wb.save('file.xlsx')

Are there any libraries for automating email tasks?

Yes, you can use the smtplib library to send emails and imaplib to read emails. Here's a simple example to send an email:

import smtplib

# Set up the server
server = smtplib.SMTP('smtp.gmail.com', 587)
server.starttls()

# Login
server.login('[email protected]', 'your_password')

# Send email
server.sendmail('[email protected]', '[email protected]', 'Subject: Test

This is a test email.')

# Quit the server
server.quit()