Data Training Courses

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. It focuses on using Python for data analysis.

Course Length

2 days

Learning Objectives

You will learn how to use more powerful techniques in Python, including object-oriented and functional programming styles. You will learn how to use the fundamental Python packages for data analysis: numpy, pandas and matplotlib.

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

The Python numpy package – a fundamental package for data analysis and AI.

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.
• Object-Oriented Programming (OOP) in Python

Optional topics

Other topics in this course, depending on the interest of attendees, may include:

• Handling exceptions with the try / except / finally block.
• Using Python in VSCode (a very popular editor)
• Regular Expressions
• Scraping data from web pages
• An example of machine learning

What is OOP and when is it useful?

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