Python Intermediate Course: Automate Real Office Work

You can write loops, functions and simple pandas code. This course turns that into scripts you can rely on at work: proper project folders and virtual environments, comprehensions, error handling and logging, dates and the Indian financial year, deeper pandas, regular expressions for UPI narrations and GSTINs, formatted Excel reports with openpyxl, JSON and APIs, command-line tools, and a final monthly-report pipeline.

Every lesson comes with a complete script that we ran ourselves, its exact output, and the same practice data: invoices, customers, products, a bank statement and currency rates.

Before you start: the Python Beginner Course. You need Python 3.10+ with pandas and openpyxl (pip install pandas openpyxl).

1. 1Python Intermediate Lesson 1: Project Folders, pathlib and Virtual EnvironmentsSet up Python projects properly: one folder per project, a virtual environment, requirements.txt and pathlib paths that work wherever the script runs.
2. 2Python Intermediate Lesson 2: Comprehensions, Generators and SortingWrite shorter, faster Python: list, dict and set comprehensions, generator expressions, enumerate, zip and sorted with a key function, on real invoice…
3. 3Python Intermediate Lesson 3: Errors, try/except and LoggingProcess files with bad rows without crashing: catch specific exceptions, log what was skipped and why, and use finally for clean-up.
4. 4Python Intermediate Lesson 4: Dates, Formats and the Indian Financial YearParse and format dates with strptime and strftime, compute FY labels and quarters, add working days with holidays and find month ends…
5. 5Python Intermediate Lesson 5: pandas in Depth – Merge, GroupBy and Pivot TablesClean types with to_datetime and to_numeric, merge three tables, use named aggregations in groupby and build pivot tables, avoiding the duplicate-column trap.
6. 6Python Intermediate Lesson 6: Regular Expressions for UPI, GSTIN and PANUse Python regex with named groups to parse UPI bank narrations and validate GSTIN, PAN and phone numbers, with patterns explained piece…
7. 7Python Intermediate Lesson 7: Formatted Excel Reports With openpyxlWrite Excel files people like to open: several sheets, live formulas, header styles, number formats, frozen panes and a chart, all from…
8. 8Python Intermediate Lesson 8: JSON and APIsRead and write JSON, call a REST API with requests, check status codes and handle errors, and convert rupees to other currencies…
9. 9Python Intermediate Lesson 9: Command-Line Tools With argparseTurn a script into a reusable tool with options and help text using argparse, and run it from a batch file or…
10. 10Python Intermediate Lesson 10: Project – A Monthly Report PipelineFinal project: read every monthly CSV in a folder, combine, enrich with products and customers, compute KPIs and write a multi-sheet Excel…

Next: combine this with the SQL Intermediate Course (pandas.read_sql) or schedule your pipeline with Windows Task Scheduler.