Recent Searches
Category

Microsoft Power BI

Category

Microsoft Excel

Category

Microsoft Copilot Courses

Category

SharePoint

Category

Professional Development

Category

Microsoft Project

Category

Power Automate

Category

Power Apps

Category

AI for Business

Category

SQL

Category

Microsoft 365

Category

Microsoft Word

Category

Python

Category

Microsoft Teams

Category

Excel Specialist

Category

Microsoft PowerPoint

Category

Microsoft Outlook

Category

R Programming

Category

Microsoft Access

Category

Microsoft Visio

Category

HTML Courses

Category

WordPress

Category

Microsoft Windows 11 Courses

Category

Adobe InDesign Courses

Category

Adobe Premiere Pro Training

Category

Adobe After Effects Training

Category

Adobe Photoshop Courses

Category

Adobe Illustrator Courses

Category

Canva Courses

Category

Articulate

Category

Adobe Acrobat Courses

Category

Adobe Animate Training

Category

Adobe Captivate Training

Course

Power BI Beginner

Course

Excel Beginner

Course

Copilot for M365

Course

SharePoint Beginner

Course

Achieving Leadership & Success

Course

Project Beginner

Course

Power Apps Beginner

Course

SQL Beginner

Course

Word Intermediate

Course

Word Beginner

Course

Word Advanced

Course

Python Beginner

Course

Teams Essentials

Course

Financial Modelling

Course

PowerPoint Level 1

Course

Microsoft Outlook Beginner to Intermediate

Course

R Programming Beginner

Course

Microsoft Access Essentials

Course

Visio Essentials

Course

HTML Training Intro

Course

Windows 11 End User Course

Course

InDesign Lite

Course

Premiere Training Intro

Course

After Effects Training Intro

Course

Photoshop Lite

Course

Illustrator Training Intro

Course

Articulate Storyline 360 Essentials

Course

Acrobat Essentials

Course

Animate Training Intro

Course

Captivate Training

Course

Power BI Intermediate

Course

Excel Intermediate

Course

Copilot for Word

Course

SharePoint Intermediate

Course

Anger Management & Negotiation Skills

Course

Project Intermediate

Course

Power Apps Intermediate

Course

ChatGPT Beginner

Course

SQL Intermediate

Course

Python Intermediate

Course

Analysis and Dashboards

Course

PowerPoint Level 2

Course

R Programming Intermediate

Course

InDesign Training Intro

Course

Photoshop Training Intro

Course

Articulate Storyline 3 & 360 Advanced

Course

Acrobat Forms

Course

Power BI Advanced

Course

Excel Advanced

Course

Copilot for Excel

Course

SharePoint Advanced (Site Owner)

Course

Assertiveness & Confidence

Course

Project Advanced

Course

Power Apps Intermediate | Power Automate + Power BI Integration

Course

AI Prompting Fundamentals

Course

Python Advanced

Course

Excel VBA

Course

R Programming Advanced

Course

Microsoft Access Advanced

Course

InDesign Training Advanced

Course

Canva Beginners

Course

Power BI DAX

Course

Excel Expert

Course

Copilot for PowerPoint

Course

SharePoint Advanced (Document Governance)

Course

Building Resilience

Course

Power Apps Advanced

Course

Machine Learning in R

Course

Canva Intermediate

Course

Copilot for Outlook and Teams

Course

Coaching and Mentoring

Course

Canva Advanced

Course

Communications

Course

WordPress Essentials

Course

Premiere Basics Training

Course

Advanced After Effects Training

Course

Illustrator Training Advanced

Course

Canva AI

Course

Microsoft Copilot Agent Builder

Course

Communications & Quality Client Service Training

Course

AI for Business Leaders and Managers

Course

Advanced Premiere Training

Course

Photoshop Training Advanced

Course

Power BI Copilot Training

Course

Critical Thinking and Problem Solving

Course

AI Governance Training

Course

InDesign Interactivity Training

Course

Copilot for Customer Service

Course

Cultural Diversity in the Workplace

Course

InDesign Accessibility Training

Course

Copilot for Executives and Managers

Course

Embracing Change

Course

Microsoft Outlook Advanced

Course

Copilot for Finance

Course

Growing Emotional Intelligence

Course

SQL Advanced

Course

Copilot for HR

Course

Minute Taking

Course

Planner Premium

Course

Excel Tables and Pivot Tables

Course

Copilot for Legal Services

Course

Power Automate Beginner

Course

Microsoft 365 Essentials

Course

Data Transformation with Power Query

Course

Excel Macro Mastery

Course

Copilot for Marketing

Course

Persuasion and Negotiation Skills

Course

Power Automate Intermediate

Course

Power BI Desktop Advanced Reporting

Course

Copilot for Operations

Course

Presentation Skills and Public Speaking

Course

Data Visualisation with Power BI Desktop

Course

Copilot for Sales

Course

Practical Project Management

Course

Respect, Equity and Diversity (RED)

Course

Resumé Writing and Interview Skills

Course

Stress Management

Course

Team Leadership, Management and Development

Course

Time Management Intensive

Course

Train the Trainer

Course

Write Effective Business Documents

Course

Dealing with Difficult People

Course

Managing Difficult Conversations

Course

Managing the Virtual Workplace

Course

Customer Service Training

Course

Technical Writing

Python Advanced Course

Write more efficient Python code for data analysis workflows

Build on your Python Intermediate skills with Nexacu’s Python Advanced training course. This hands-on Python course focuses on writing more efficient, reusable code for data analysis using Python and pandas.

You will learn to use control flow structures, loops, custom functions and classes to automate analysis tasks. The course also covers method chaining and pipes for DataFrame workflows, interactive visualisations with Bokeh, and reusable code for data processing.

By the end of this Python course, you will:

  • Create user-defined functions and classes for reusable Python code.
  • Use loops, control structures and list comprehensions efficiently.
  • Perform multiple pandas DataFrame operations using method chaining and piping.
  • Create interactive data visualisations using Bokeh.
  • Write reusable code to automate data processing workflows.

Prerequisite:

Completion of our Python Beginner and Python Intermediate course, or equivalent experience. You should be comfortable with Python syntax, data structures, pandas DataFrames, and basic plotting with Matplotlib.

Read more about this Python Advanced course

Python Advanced is designed for learners who already use Python and pandas and want to improve how they structure, automate and repeat data analysis tasks. It suits analysts, data users, reporting professionals and technical learners who need to move beyond manual or one-off scripts.

The course supports practical workplace data workflows, including writing reusable functions, organising code with classes, applying efficient alternatives such as list comprehensions, and using method chaining to make pandas workflows clearer and more repeatable.

Learners will also work with interactive visualisation concepts using Bokeh and write code that can help automate common data processing and analysis steps.

Course Details

Download Course PDF
Price
$745
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
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
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
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
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
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
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
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 20 Aug 26
Thu
20
Aug
Python Advanced
Remote East
Status: Scheduled
Scheduled
Tue 3 Nov 26
Tue
3
Nov
Python Advanced
Remote East
Status: Scheduled
Scheduled
Brisbane
Date
Course
City
Status
Thu 20 Aug 26
Thu
20
Aug
Python Advanced
Brisbane
Status: Scheduled
Scheduled
Sydney
Date
Course
City
Status
Fri 24 Jul 26
Fri
24
Jul
Python Advanced
Sydney
Status: Scheduled
Scheduled
Melbourne

We currently have no public courses scheduled. Please contact us to register your interest.

Canberra
Date
Course
City
Status
Tue 3 Nov 26
Tue
3
Nov
Python Advanced
Canberra
Status: Scheduled
Scheduled
Adelaide
Date
Course
City
Status
Wed 16 Sep 26
Wed
16
Sep
Python Advanced
Adelaide
Status: Scheduled
Scheduled
Perth
Date
Course
City
Status
Wed 30 Sep 26
Wed
30
Sep
Python Advanced
Perth
Status: Scheduled
Scheduled
Remote West
Date
Course
City
Status
Wed 30 Sep 26
Wed
30
Sep
Python Advanced
Remote West
Status: Scheduled
Scheduled
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
Course Icon Python Intermediate

Boost your skills with our intermediate Python course. Learn data manipulation, build custom Python functions, and create visualisations with Matplotlib and Seaborn.

download course pdf
Price: $745

Python Advanced Course Content

Expand All | Collapse All

Introduction

Working more efficiently in Python

Automating frequent data analysis operations

Principles of working more efficiently with code

User-Defined Functions

When to create your own functions

Function basics

Parameters

Positional vs keyword arguments

Defining a function

Indentation

Scope

*args and **kwargs

Unpacking operators

Order of arguments in a function

Adding a docstring

Assertions

Loading functions for reuse

Lambda expressions

Loops and Other Control Structures

if...elif...else

for loops

Looping over sequences

Looping over ranges

Enumerate

Looping over pandas groups

Looping over multiple lists

while loops

else, break and continue

Saving results from a loop

Combining loops and functions

Loop and If-Else Alternatives

np.where() and np.select()

Conditional expressions

List comprehensions

Python built-in map() function

Evaluating performance efficiency

IPython and magic commands

pandas map()

pandas apply() and applymap()

User-Defined Classes

When to create your own class

Defining classes

Docstrings

The __init__() method

The self parameter

Class objects, attribute references and instantiation

Data attributes

Methods

Scope

Dunder methods

Performing Multiple Operations on DataFrames

Method chaining

Using pandas pipes with custom functions

Interactive Visualisations with Bokeh

Bokeh basics

Working with Bokeh in Jupyter

Glyphs

Providing data

Using the Bokeh toolbar

Customising the Bokeh toolbar

Creating links between plots

Using interactive legends

Adding tooltips

Plotting from a grouped pandas DataFrame

Saving your Bokeh chart

Frequently Asked Questions

Is Python Advanced suitable for beginners?

No. Python Advanced is designed for learners who already understand Python basics, pandas DataFrames and basic plotting. If you are new to Python, start with our Python Beginner course, then complete the Python Intermediate course before moving into Advanced.

What are the prerequisites for Python Advanced?

Completion of our Python Beginner and Python Intermediate courses, or equivalent experience, is recommended. You should be comfortable with Python syntax, data structures, pandas DataFrames, and basic plotting with Matplotlib before attending this advanced Python training course.

What will I learn in Python Advanced?

You will learn how to work more efficiently in Python by using control flow structures, loops, user-defined functions and classes. The course also covers method chaining, pandas pipes, interactive visualisations with Bokeh, and reusable code for automating data analysis workflows.

Who should attend this Python Advanced course?

This course is suited to analysts, reporting professionals, data users and technical learners who already use Python and pandas, and want to write cleaner, more reusable code. It is useful for people who need to reduce repetitive manual steps in data preparation, analysis and visualisation.

What is the difference between Python Intermediate and Python Advanced?

Python Intermediate focuses on practical data analysis tasks such as importing, cleaning, manipulating and visualising datasets. Python Advanced moves further into efficient coding practices, including functions, classes, loops, method chaining, pipes, automation and interactive visualisation with Bokeh.

Will I learn to create my own Python functions and classes?

Yes. Python Advanced includes user-defined functions and user-defined classes. You will learn when to create them, how to structure them, how parameters and scope work, and how functions and classes can help make your Python code more reusable and efficient.

How does this course help with Python automation?

The course helps you automate common data analysis operations by combining loops, control structures, functions, classes and reusable code patterns. These skills can reduce repeated manual work when processing, transforming or analysing datasets.

Will I learn pandas method chaining and pipes?

Yes. The course covers method chaining and the use of pandas pipes with custom functions. These techniques help you perform multiple DataFrame operations in a more structured and readable way.

Will I create interactive visualisations in this course?

Yes. Python Advanced covers interactive visualisations with Bokeh, including Bokeh basics, working with Bokeh in Jupyter, glyphs, toolbars, linked plots, interactive legends, tooltips and saving Bokeh charts.

What Python tools and libraries are used in this advanced course?

The course builds on Python and pandas, with advanced use of DataFrames, functions, classes, loops and automation techniques. It also includes Bokeh for interactive visualisations and Jupyter-based workflows.

Is Python Advanced useful for workplace data analysis?

Yes. The course is focused on practical workplace data workflows, including automating repeated analysis steps, writing reusable code, performing efficient DataFrame operations and creating interactive charts that support data exploration and reporting.

What should I do after completing Python Advanced?

After Python Advanced, learners can continue building their broader data capability with related Nexacu courses in Power BI, SQL or Excel, depending on their role and reporting needs. These skills can complement Python for data analysis, business intelligence and automation workflows.

Course Details

Download Course PDF
Price
$745
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
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
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
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
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
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
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
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

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
Course Icon Python Intermediate

Boost your skills with our intermediate Python course. Learn data manipulation, build custom Python functions, and create visualisations with Matplotlib and Seaborn.

download course pdf
Price: $745

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 across 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?

step by step courseware

Step by Step Courseware

Custom workbook included with a step by step exercises

Facility Image 2
Facility Image 3
Facility Image 1

Interactive real time training

Interactive, Real-Time Training

Learn with expert instructors, wherever you are

More than 1,300 Business trust Nexacu

Trusted by Business

Procured by Government

Procured by Goverment

Reviews Not Found

Valued by Individuals