Zomalex | Data and AI Training

Home | Power BI | Excel | Python | SQL | Gen AI | Contact Us | LBAG | info@zomalex.co.uk

Python Advanced Course

Who should attend

People who want to take their Python skills to an advanced level.

Learning Objectives

You will learn advanced topics in Python and how to use the Python environment well.

Course Content

Automate tasks with Python

Lab exercises to automate several tasks with Python. For example:

• analyse data in Excel files with the pandas and openpyxl packages
• scrape data from web sites
• retrieve data from APIs, for example the OpenAI API for access to ChatGPT

Functional Programming in Python

• what is Functional Programming and when is it useful?
• lambda functions, and the map and filter functions

Manage practical aspects of the Python environment

• Use GitHub Codespaces to create and manage a repository (a set of Python and other files)
• Use VSCode (a very popular editor) to edit and run Python notebooks and (.py) scripts
• Install packages with pip
• Use the terminal command line

Use AI tools to help write Python

Use GitHub Copilot, Claude and ChatGPT to assist with writing Python code. This is an introduction. There is a full course on using AI models to help write Python code.

Object-Oriented Programming

What is Object-Oriented Programming (OOP) and when is it useful?

• Classes
• Instance variables
• Instance Methods
• Properties – getters and setters
• Class methods

This section is not covered in the short course. It is covered in the full course.

Course Length

Either 1 day (short course) or preferably 2 days (full course)

Pre-requisites

Completion of both the Python foundation and intermediate courses.

Snapshots from the course exercises

Part of the lesson on reading and analysing Excel data with pandas