Python for Data Automation

Week 1: Python Fundamentals & Programming Basics

• Introduction to Python and setting up your environment

• Data types, variables, and basic operators

• Writing clean and readable code (PEP8 standards)

• Control flow: if statements, loops (for, while), and logic

• Functions, arguments, and return values

• Error handling and debugging basics

• Hands-on Project: Create a basic calculator and a mini text-based game

Week 2: Working with Data in Python

• Lists, dictionaries, sets, and tuples

• File handling: reading/writing to CSV and text files

• Introduction to libraries: Pandas, NumPy

• Data cleaning, sorting, and filtering with Pandas

• Exploratory data analysis (EDA) basics

• Hands-on Project: Clean and analyse a real-world dataset (e.g. sales or survey data)

Week 3: Data Visualisation & Automation

• Visualisation tools: Matplotlib and Seaborn

• Creating bar charts, line graphs, histograms, and heatmaps

• Automating repetitive tasks with Python

• Scheduling scripts, sending automated emails, and working with APIs

• Introduction to working with Excel and PDFs in Python

• Hands-on Project: Build an automated reporting tool with visual outputs

Week 4: Final Project & Career Readiness

• Capstone Project: Solve a business case from start to finish using Python

• Code review and peer feedback

• Introduction to Git and version control (GitHub basics)

• Building your portfolio with Jupyter Notebooks

• CV building, LinkedIn optimisation, and interview prep

• One-month placement briefing + career next steps

Bonus Support Throughout the Course

• Weekly live coding sessions and Q&A

• Access to real-world datasets and project templates

• Ongoing mentor support and feedback

• Lifetime access to course materials and updates