Data and AI Training

Home | Power BI | Excel | Python | SQL | Generative AI | Visualising Data | Analysing Data

Python Intermediate Course

Who should attend

People who have attended the Python foundation course and want to improve their Python skills.

Course Length

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

Learning Objectives

You will learn how to use more powerful techniques in Python, including how to write functions and the functional programming style. You will have an introduction to several popular Python packages: e.g., datetime and requests, and some examples of automating tasks with Python.

Pre-requisites

Completion of the Python foundation course.

Course Content

Write and use functions: the basic structure of a function, positional and named arguments, return values.

A quick tour of some popular useful Python libraries, for example:

• the datetime module for handling dates and date arithmetic
• the requests module for getting data from APIs and web pages
• the math and statistics modules

Some examples of automating the boring stuff with Python: for example:

• creating and reading Excel files
• scaping data from web sites

Functional Programming in Python

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