Following on from our Python Beginner course, Python Intermediate will build on your foundational knowledge of Python and pandas. You will learn how to manipulate data, create custom functions, plot with Matplotlib and display visualisations.

Understanding how to use Python for Data Analysis empowers you to be much more efficient and opens up the possibility of using a wide array of freely available tools. 

Upon completion of this course you will be able to:

  • use the extensive data manipulation capabilities of pandas DataFrames
  • customise the display of the output in Jupyter Notebooks
  • use the plotting capabilities of Matplotlib to plot distributions and bar charts
  • use the data visualisation library, Seaborn, and
  • fit a basic model using scikit-learn.

Prerequisite:

Students should have attended our Python Beginner course or have a foundational knowledge of Python and pandas.

Course Details

Download Course PDF
Price
$745 $820
Duration
1 day
Times
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Live Online

Course Details

Download Course PDF
Price
$745 $820
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 8
201 Charlotte Street
Brisbane QLD 4000

Course Details

Download Course PDF
Price
$745 $820
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 24/477 Pitt Street
Sydney
New South Wales 2000

Course Details

Download Course PDF
Price
$745 $820
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 12A
45 William Street Melbourne VIC 3000

Course Details

Download Course PDF
Price
$745 $820
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
NEW LOCATION
Level 2
221 London Circuit
Canberra ACT 2600

Course Details

Download Course PDF
Price
$745 $820
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 15
33 King William Street
Adelaide 5000

Course Details

Download Course PDF
Price
$745 $820
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 7
553 Hay Street
Perth WA 6000

Course Details

Download Course PDF
Price
$745 $820
Duration
1 day
Times
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Live Online

Upcoming Courses

Remote East

Brisbane

Sydney

Melbourne

Canberra

Adelaide

Perth

Remote West

Remote East
Date
Course
City
Status
Thu 21 Aug 25
Thu
21
Aug
Python Intermediate
Remote East
Status: Few Seats
Few Seats
Wed 3 Sep 25
Wed
3
Sep
Python Intermediate
Remote East
Status: Confirmed
Confirmed
Thu 25 Sep 25
Thu
25
Sep
Python Intermediate
Remote East
Status: Confirmed
Confirmed
Wed 15 Oct 25
Wed
15
Oct
Python Intermediate
Remote East
Status: Scheduled
Scheduled
Brisbane
Date
Course
City
Status
Wed 3 Sep 25
Wed
3
Sep
Python Intermediate
Brisbane
Status: Confirmed
Confirmed
Wed 15 Oct 25
Wed
15
Oct
Python Intermediate
Brisbane
Status: Scheduled
Scheduled
Sydney
Date
Course
City
Status
Wed 3 Sep 25
Wed
3
Sep
Python Intermediate
Sydney
Status: Scheduled
Scheduled
Melbourne

We are currently developing these courses. Please contact us to register your interest.

Canberra
Date
Course
City
Status
Thu 21 Aug 25
Thu
21
Aug
Python Intermediate
Canberra
Status: Sold Out
Sold Out
Wed 3 Sep 25
Wed
3
Sep
Python Intermediate
Canberra
Status: Sold Out
Sold Out
Thu 25 Sep 25
Thu
25
Sep
Python Intermediate
Canberra
Status: Confirmed
Confirmed
Wed 15 Oct 25
Wed
15
Oct
Python Intermediate
Canberra
Status: Scheduled
Scheduled
Adelaide

We are currently developing these courses. Please contact us to register your interest.

Perth

We are currently developing these courses. Please contact us to register your interest.

Remote West

We are currently developing these courses. Please contact us to register your interest.

Scheduled
Taking enrollments.
Confirmed
Taking enrollments.
Few Seats left
Book Now.
Sold Out
Try another date.

Python Training Courses

Course Icon Python Beginner

Learn Python with this beginner-friendly Python course. Get started with Python programming, JupyterLab, and data analysis using pandas, no prior coding experience required.

download course pdf
Price: $745 $820
Course Icon Python Advanced

Advance your data skills with our Python advanced course. Automate analysis, write efficient Python code, and build interactive dashboards using pandas and Bokeh.

download course pdf
Price: $745 $820

Python Intermediate Course Content

Expand All | Collapse All

Introduction

Python Intermediate

User-Defined Functions in Python

Function basics

Parameters

Positional vs keyword arguments

Defining a function

Indentation

User-Defined Functions in Python (cont'd)

Scope

*args and **kwargs

Unpacking operators

Lambda expressions

Conditional expressions

List comprehensions

Modify the DataFrame Display

pandas options

Working with pandas styles

Applying a style that is not dependent on values

Formatting values

String formats

Applying a style that is dependent on values

Built-in conditional formatting

Export Notebook as

Export to PDF or HTML

Create slides

Copy vs View

Setting with copy warning

Working with Missing Values

Missing values

inf and -inf

Removing missing values

Replacing missing values

Importing Data

Importing into a pandas DataFrame

Manipulating Data

Summarise a dataset

Report and display multiple summary statistics

Ordering data

Manipulating Data (cont'd)

Working with dates

Add columns with assign()

Working with strings

Reordering and dropping columns

Manipulating Data (cont'd)

Selecting rows based on values

Grouping and summarising data

Replacing values

Concatenate data

Bin continuous variables into categories

Working with Relational Data

Joining data from two DataFrames

Visualising Distributions

Visual representation of distributions with Matplotlib and Seaborn

Histograms

Boxplots

Bar and column charts

Multivariate Analysis

Scatterplot matrix

Bar and column charts

Basic Modelling

Create a linear model with scikit-learn

Frequently Asked Questions

Course Introduction

Our Python courses were designed by Tamara Shatar, who holds a PhD in Agricultural Data Science. She focused her extensive experience and skills in modelling using machine learning, simulation and other techniques to create a course with depth and applicability.

The course is consistently well-reviewed by students.

"Great trainer, structure, material and manual. I have completed programming courses before but this one just made more sense!" - Using R Beginner Sydney

Is Python compatible with Microsoft?

Python can be used within a number of Microsoft products. In Power BI, reusable Python scripts can be used to manipulate data and create visualisations. In Azure, machine learning models can be written in Python and trained and deployed within the Azure Machine Learning Workspace.

What is Remote Training?

Remote training at Nexacu means our experienced trainers will deliver your training virtually. With remote learning, students can access our usual classroom training courses via video conferencing, ask questions, participate in the discussion, and share their screen with the trainer if they need help at any point in the course. Students have the same level of participation and access to the trainer as they would in classroom training sessions.

Do I need to complete Python Beginner before taking this course?

Yes, we recommend completing our Python Beginner course first, or having equivalent knowledge. You should be familiar with Python syntax, working in JupyterLab, and using pandas DataFrames before enrolling in the Intermediate course.

What will I learn in Python Intermediate?

This course builds on the fundamentals and introduces more advanced techniques, including creating user-defined functions, lambda expressions, list comprehensions, handling missing data, conditional formatting with pandas styles, importing and manipulating datasets, and basic modelling with scikit-learn.

Will I learn to work with real-world datasets?

Yes. You’ll gain hands-on experience working with realistic datasets. You’ll practise importing data, cleaning and transforming it, exploring relationships using visualisations, and even building simple predictive models using scikit-learn.

What libraries are used in this course?

In addition to Python’s built-in functionality, the course uses key data science libraries including pandas, NumPy, Matplotlib, Seaborn, and scikit-learn. These are all commonly used in professional Python workflows.

Will I learn to create my own functions?

Absolutely. A key part of the course focuses on user-defined functions, including parameters, scope, *args and **kwargs, and lambda expressions. You’ll also explore how to write reusable and efficient code.

Do I need to install anything before class?

No. We’ll provide guidance on setting up your environment using Anaconda. If you’ve already completed our Beginner course, you’ll already have everything installed.

Course Details

Download Course PDF
Price
$745 $820
Duration
1 day
Times
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Live Online

Course Details

Download Course PDF
Price
$745 $820
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 8
201 Charlotte Street
Brisbane QLD 4000

Course Details

Download Course PDF
Price
$745 $820
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 24/477 Pitt Street
Sydney
New South Wales 2000

Course Details

Download Course PDF
Price
$745 $820
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 12A
45 William Street Melbourne VIC 3000

Course Details

Download Course PDF
Price
$745 $820
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
NEW LOCATION
Level 2
221 London Circuit
Canberra ACT 2600

Course Details

Download Course PDF
Price
$745 $820
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 15
33 King William Street
Adelaide 5000

Course Details

Download Course PDF
Price
$745 $820
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 7
553 Hay Street
Perth WA 6000

Course Details

Download Course PDF
Price
$745 $820
Duration
1 day
Times
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Live Online

skills test nexacu

Skills Test

Try our short skills test and find out which course is right for you.

 skills test

 

Contact Us

Can’t find a suitable date or have questions about the course? Fill out the form below, and our team will get back to you promptly.

Locations In-Person & Online

Find the nearest location and date that works for you

Locations In-Person & Online

Find the nearest location and date that works for you

Related Training Courses

Course Icon Python Beginner

Learn Python with this beginner-friendly Python course. Get started with Python programming, JupyterLab, and data analysis using pandas, no prior coding experience required.

download course pdf
Price: $745 $820
Course Icon Python Advanced

Advance your data skills with our Python advanced course. Automate analysis, write efficient Python code, and build interactive dashboards using pandas and Bokeh.

download course pdf
Price: $745 $820

Locations In-Person & Online

Find the nearest location and date that works for you

Locations In-Person & Online

Find the nearest location and date that works for you

Trusted Nationwide by Leading Organisations

at Nexacu, we're proud to be the trusted training partner for hundreds of leading organisations accross Australia and New Zealand. From government departments to top corporates, we help teams upskill and succeed everyday

  • 400+ companies rely on Nexacu for team training
  • Trusted by federal, state, and local government agencies
  • Delivering training across 9 countries

Why Nexacu?

Books Icon

Step by Step Courseware

Custom workbook included with a step by step exercises

Facility Image 2
Facility Image 3
Facility Image 1

Refresh Icon

Free Refresher

Resit your course for free within 6 Months

More than 1,300 Business trust Nexacu

Trusted by Business

Procured by Government

Procured by Goverment

Reviews Not Found

Valued by Individuals