Python Intermediate - Training Course
Use Python for efficient Data Analysis
Python Intermediate Course
Build on your Python Beginner skills with Nexacu’s Python Intermediate training course. This hands-on Python course focuses on practical data analysis using pandas, Jupyter Notebooks, Matplotlib, Seaborn and scikit-learn.
You will learn to import, clean, manipulate and summarise datasets, customise notebook output, visualise distributions and relationships, and fit a basic model using scikit-learn.
Foundational Python and pandas knowledge is required. We recommend completing the Python Beginner course or having equivalent experience before attending.
Python Intermediate is designed for learners who already understand Python basics and want to use Python more effectively for data analysis. It suits analysts, reporting professionals, data users, business teams and technical learners who need to work with datasets in a structured and repeatable way.
The course supports practical workplace tasks such as importing data, handling missing values, summarising datasets, working with dates and strings, joining related DataFrames, and visualising patterns using commonly used Python libraries.
After completing Python Intermediate, learners who want to continue building their data analysis capability can progress to Python Advanced where suitable.
We are currently developing these courses. Please contact us to register your interest.
Python BeginnerLearn Python with this beginner-friendly Python course. Get started with Python programming, JupyterLab, and data analysis using pandas, no prior coding experience required.
Python AdvancedAdvance your data skills with our Python advanced course. Automate analysis, write efficient Python code, and build interactive dashboards using pandas and Bokeh.
Introduction
Python Intermediate
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
Working with dates
Add columns with assign()
Working with strings
Reordering and dropping columns
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
Is this Python Intermediate course right for me?
This course is suitable if you already understand Python basics and want to use Python for data analysis. It is designed for learners who are ready to work with pandas DataFrames, import and manipulate datasets, visualise data and explore basic modelling.
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 practical data analysis techniques, including working with pandas display options, handling missing data, importing and manipulating datasets, joining DataFrames, creating visualisations with Matplotlib and Seaborn, and basic modelling with scikit-learn.
Will I learn to work with real-world datasets?
Yes. You will practise importing data, cleaning and transforming it, summarising datasets, working with dates and strings, grouping data, joining DataFrames and exploring relationships through visualisations.
What Python libraries are used in this course?
The course uses Python data analysis libraries including pandas, NumPy, Matplotlib, Seaborn and scikit-learn. These libraries support common data manipulation, visualisation and basic modelling workflows.
Is this course useful for workplace data analysis?
Yes. The course is focused on practical data tasks such as importing data, cleaning missing values, summarising datasets, joining related data and creating visualisations that support analysis and reporting.
Is Python Intermediate available face-to-face or live online?
Python Intermediate is available as instructor-led training with face-to-face and live online options, depending on the current course schedule. Select your preferred location or remote option when reviewing available dates.
What is remote training?
Remote training at Nexacu means your course is delivered virtually by a trainer. Students can attend via video conferencing, ask questions, participate in discussion and share their screen with the trainer when they need help.
Do I need to install anything before class?
No. We provide guidance on setting up your environment using Anaconda. If you have already completed our Python Beginner course, you should already have the required setup in place.
Python Training in Brisbane
View Dates
Python Training in Melbourne
View Dates
Python Training in Sydney
View Dates
Python Training in Adelaide
View Dates
Python Training in Perth
View Dates
Python Training in Canberra
View Dates
Python Training in Remote Online
View Dates Python BeginnerLearn Python with this beginner-friendly Python course. Get started with Python programming, JupyterLab, and data analysis using pandas, no prior coding experience required.
Python AdvancedAdvance your data skills with our Python advanced course. Automate analysis, write efficient Python code, and build interactive dashboards using pandas and Bokeh.
Python Training in Brisbane
View Dates
Python Training in Melbourne
View Dates
Python Training in Sydney
View Dates
Python Training in Adelaide
View Dates
Python Training in Perth
View Dates
Python Training in Canberra
View Dates
Python Training in Remote Online
View Datesat 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
Students
4 & 5 Star Reviews
Google Reviews
Businesses Trust Nexacu
Custom workbook included with a step by step exercises
Learn with expert instructors, wherever you are
Valued by Individuals
