Data and Analytics - Category Banner

Python Intermediate

  • Length 1 day
  • Price  NZD 703.48 exc GST
Course overview
View dates &
book now
Register interest

Why study this course

Python is a very versatile programming language, broad in its application due to its simplicity and power. While it can be used for automation, artificial intelligence, web development, and more, this series of courses focuses on using Python for data analysis. You'll learn to manipulate, analyse, and visualise data more effectively with Python and related tools and libraries.

Following on from the Python Beginner course, this Intermediate course will build on your foundational knowledge of Python and pandas, and introduces more advanced techniques. You'll learn how to import and manipulate data, handle missing data, create custom functions, display visualisations, and basic modelling. 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.

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.

Nexacu Public Schedule

Nexacu is part of the Lumify Group, offering you the largest public schedule of end user applications and professional development training in Australia, New Zealand, and the Philippines. You can now access the schedule of courses and book, by clicking on the button below.

Request Course Information


What you’ll learn

After completing this course, students 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

  • Fit a basic model using scikit-learn


Python Logo

Python at Lumify Work

Lumify Work's Python offering has been refreshed to include courses which fully align to certifications from the Python Institute. Our courses are delivered by Python programming experts who can structure their topic flow to your goals and functions, whether it's Python for automation or for data science or for finance.


Who is the course for?

This course is intended for those who want to build on their foundational knowledge of Python and pandas.


Course subjects

User-Defined Functions in Python

  • Function basics

  • Parameters

  • Positional vs keyword arguments

  • Defining a function

  • Indentation

  • Scope

  • *args and **kwargs

  • Unpacking operators

  • Lambda expressions

  • Conditional expressions

  • List comprehensions

Modifying 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

Exporting Notebooks

  • 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

  • Summarising a dataset

  • Reporting and displaying multiple summary statistics

  • Ordering data

  • Working with dates

  • Adding columns with assign()

  • Working with strings

  • Reordering and dropping columns

  • Selecting rows based on values

  • Grouping and summarising data

  • Replacing values

  • Concatenating 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

  • Creating a linear model with scikit-learn


Prerequisites

Students should have completed the Python Beginner course or have equivalent knowledge. You should be familiar with Python syntax, working in JupyterLab, and using pandas DataFrames.


Terms & Conditions

The supply of this course by Lumify Work is governed by the booking terms and conditions. Please read the terms and conditions carefully before enrolling in this course, as enrolment in the course is conditional on acceptance of these terms and conditions.


Request Course Information

Awaiting course schedule

If you would like to receive a notification when this course becomes available, enter your details below.

Nexacu Public Schedule

Nexacu is part of the Lumify Group, offering you the largest public schedule of end user applications and professional development training in Australia, New Zealand, and the Philippines. You can now access the schedule of courses and book, by clicking on the button below.