PythonAutomationProject

Project to demonstrate various automation with python

---

🔰 Automate the Boring Stuff with Python teaches simple programming skills to automate everyday computer tasks.

🔰 Various Tasks can be Automated using Python Programs like Scraping any Web data with Python Modules like beautifulsoup,webbrowser,selenium webdrivers.

🔰 Simlarly we can interconvert various documents like PDFs,WordDoc,Excel,CSV etc using Simple Python Code

This Project demonstrates usage of Automating tasks concepts in two separate python files. Concepts that are covered is listed as follows.

---

🔱 File 1 FinalFile.py
♦️ Contributors:

• Srishti Bhandarkar
• Swathi Prabhu

♦️ Topics Covered

• Excel File (With Employee Data)
• Database: Sqlite3 (CRUD operations on Employee Data and store Query Results creating new Excel file)
• Word Document (Excel to Word)
• Pdf Documnets (Word to Pdf, Pdf Merger)
• Selenium Web Drivers(Mail Automation)

---

🔱 File 2 Scarping_quotes.py
♦️ Contributors:

• Sudhiksha S Prabhu
• Siona Misha Nazareth

♦️ Topics Covered

• Web Scraping with beautifulsoup (Scrape Inspirational Quotes)
• CSV (Scrapped data to CSV file)
• JSON (CSV to JSON)
• PDF (JSON data stored in pdf)

---

---

🔸 Python Modules Used

• openpyxl
• sqlite3
• docx
• PyPDF2
• selenium
• docx2pdf
• bs4
• csv
• json
• fpdf
• requests