Python Developer Course Materials

Welcome to the Python Developer Course! This repository contains all the necessary templates, cheat sheets, and project files to help you master Python programming and automation. Each section is organized by topic and includes hands-on examples and a capstone project to apply your knowledge.

Directory Structure

Python_Developer_Course/
|
├── Day_1_Foundations/
│   └── python_basics_cheat_sheet.txt
│
├── Day_2_File_Folder_Automation/
│   └── file_automation_template.py
│
├── Day_3_Web_Scraping/
│   └── web_scraping_cheat_sheet.txt
│
├── Day_4_Spreadsheet_PDF/
│   └── excel_pdf_cheat_sheet.txt
│
├── Day_5_Communication_Automation/
│   └── email_template.py
│
└── Capstone_Project/
    └── capstone_project.py

Overview of Each Section

Day 1: Python Foundations

• File: python_basics_cheat_sheet.txt
• Topics Covered:
  • Variables, data types, loops, conditionals, and functions.
  • A quick reference guide to essential Python syntax and features.

Day 2: File and Folder Automation

• File: file_automation_template.py
• Topics Covered:
  • Automating file and folder management.
  • A reusable script for organizing files by type.

Day 3: Web Scraping

• File: web_scraping_cheat_sheet.txt
• Topics Covered:
  • Using requests and BeautifulSoup to scrape data from websites.
  • Extracting links and parsing HTML.

Day 4: Spreadsheet and PDF Automation

• File: excel_pdf_cheat_sheet.txt
• Topics Covered:
  • Manipulating Excel files with pandas and openpyxl.
  • Merging and editing PDFs using PyPDF2.

Day 5: Communication Automation

• File: email_template.py
• Topics Covered:
  • Sending automated emails with attachments.
  • Using smtplib and email libraries.

Capstone Project: End-to-End Automation Pipeline

• File: capstone_project.py
• Description:
  • Combines all skills learned during the course.
  • Automates:
    1. Web scraping to extract data.
    2. Saving data into an Excel file.
    3. Merging multiple PDFs.
    4. Sending an email with the generated files attached.

How to Use the Materials

1. Clone or download this repository to your local machine.
2. Navigate to the directory corresponding to the day's lesson.
3. Open and execute the scripts using Python (version 3.8 or higher is recommended).
4. Modify the templates as needed to fit your specific automation tasks.

Prerequisites

• Install Python 3.8 or higher.
• Install required Python libraries:

  pip install requests beautifulsoup4 pandas openpyxl PyPDF2

Running the Capstone Project

1. Update the placeholders in capstone_project.py with your own credentials and file paths.
2. Run the script:

   python capstone_project.py

3. The output files (Excel and merged PDF) will be saved in the Capstone_Project folder.

Support

If you encounter any issues or have questions, feel free to reach out to the course instructor or post in the course support forum.

Enjoy learning Python and happy coding!