Data Analysis with Python, Pandas and Numpy Training Course
Python is a versatile programming language renowned for its simplicity and readability. Pandas is a Python package that delivers data structures for working with structured (tabular, multidimensional, potentially heterogeneous) and time series data. NumPy provides foundational support for numerical computing through its array operations. Together, they create a robust ecosystem for efficient data handling and analysis in Python.
This instructor-led, live training (available online or on-site) is designed for intermediate-level Python developers and data analysts seeking to enhance their skills in data analysis and manipulation using Pandas and NumPy.
By the end of this training, participants will be able to:
- Set up a development environment including Python, Pandas, and NumPy.
- Create a data analysis application using Pandas and NumPy.
- Perform advanced data wrangling, sorting, and filtering operations.
- Conduct aggregate operations and analyse time series data.
- Visualise data using Matplotlib and other visualisation libraries.
- Debug and optimise their data analysis code.
Course Format
- Interactive lecture and discussion.
- Abundant exercises and practical practice.
- Hands-on implementation in a live-lab environment.
Course Customisation Options
- To request a customised training session for this course, please contact us to arrange.
Course Outline
Day 1:
Basic Python and Data Analysis Skills Review
Introduction to NumPy
- Creating NumPy arrays
- Common operations on matrices
- Using ufuncs
- Views and broadcasting on NumPy arrays
- Optimising performance by avoiding loops
- Optimising performance with cProfile
Data Analysis with Pandas
- Using vectorised data in pandas
- Data wrangling
- Sorting and filtering data
- Aggregate operations
- Analysing time series
Data Visualisation with Matplotlib
- Plotting diagrams with Matplotlib
- Using Matplotlib from within pandas
- Creating quality diagrams
- Visualising data in Jupyter notebooks
- Other visualisation libraries in Python
Day 2:
Other Python Libraries for Data Analysis
- scikit-learn
- Scipy
- statsmodel
- RPy2
Summary and Next Steps
Requirements
- Basic Python and data analysis skills
Audience
- Python developer
- Data analysts
Open Training Courses require 5+ participants.
Data Analysis with Python, Pandas and Numpy Training Course - Booking
Data Analysis with Python, Pandas and Numpy Training Course - Enquiry
Data Analysis with Python, Pandas and Numpy - Consultancy Enquiry
Testimonials (1)
Trainer develops training based on participant's pace
Farris Chua
Course - Data Analysis in Python using Pandas and Numpy
Provisional Upcoming Courses (Require 5+ participants)
Related Courses
ArcGIS for Spatial Analysis
14 HoursThis instructor-led, live training in New Zealand (available online or on-site) is tailored for field ecologists and conservation managers who wish to create spatial data projects using ArcGIS.
By the end of this training, participants will be able to:
- Present spatial data as visualisations.
- Perform geostatistics on real-world data.
- Implement spatial data analysis, data processing, and mapping using ArcGIS.
- Analyse spatial data for projects within ArcGIS.
ArcGIS from Basic to Advanced
35 HoursThis instructor-led, live training in New Zealand (online or onsite) is designed for GIS professionals and analysts, from beginner to advanced levels, who wish to learn how to effectively use ArcGIS for data visualisation, spatial analysis, and geospatial project management.
By the end of this training, participants will be able to:
- Navigate and utilise ArcGIS tools for geospatial data management.
- Create and customise maps with layers and attributes.
- Perform advanced spatial analysis and geoprocessing tasks.
- Automate workflows using ModelBuilder and Python.
ArcGIS Enterprise for Technical Support
14 HoursThis instructor-led, live training in New Zealand (online or onsite) is designed for beginner-level IT support personnel who wish to provide robust support for ArcGIS Enterprise, effectively addressing any anomalies or failures.
By the end of this training, participants will be able to:
- Understand the architecture and components of ArcGIS Enterprise.
- Learn how to install, configure, and manage ArcGIS Enterprise.
- Gain practical skills in troubleshooting and resolving common issues.
- Develop proficiency in monitoring and maintaining ArcGIS Enterprise environments.
- Master techniques for backup, recovery, and performance optimisation.
ArcGIS Fundamentals
14 HoursThis instructor-led live training in New Zealand (online or onsite) is targeted at beginner-level professionals who want to learn the fundamental concepts and tools of ArcGIS.
By the conclusion of this training, participants will be able to:
- Understand the core concepts of GIS and spatial data.
- Navigate the ArcGIS interface.
- Create and manage spatial data.
- Perform basic spatial analysis.
- Create maps and visualisations.
ArcGIS Professional Plus: Advanced GIS Data Management and Analysis
14 HoursAdvanced ArcGIS Pro for Spatial Analysis
35 HoursThis instructor-led, live training in New Zealand (online or on-site) is aimed at advanced-level GIS professionals who wish to use ArcGIS Pro to enhance their spatial analysis capabilities, conduct comprehensive geostatistical analysis, and apply advanced 3D modelling techniques for more effective decision-making and problem-solving in real-world scenarios.
By the end of this training, participants will be able to:
- Develop advanced skills in spatial analysis techniques using ArcGIS Pro.
- Utilise Python scripting for automation and complex data processing.
- Apply spatial modelling for problem-solving in real-world scenarios.
- Conduct geostatistical analysis for advanced data interpretation.
- Integrate external data sources and leverage 3D spatial data analysis.
Digital Transformation in Banking and Fintech
7 HoursThis live, instructor-led training in New Zealand (delivered online or onsite) is tailored for intermediate-level managers and specialists seeking to grasp what propels digital change in financial services and how to implement it within their own organisations.
Upon completing this training, participants will be able to:
• Explain the key drivers of digital change in banking and financial services.
• Identify value creation opportunities in digital channels, lending, and SME banking.
• Understand how Agile methodologies and product thinking facilitate transformation.
• Draw insights from both successful and unsuccessful transformation initiatives.
Advanced Power Systems and GIS Integrated Solutions
70 HoursIn the rapidly changing energy landscape, combining electrical transient analysis with accurate geospatial data is a strategic imperative. Reliance on disjointed information currently creates substantial operational risks. This intensive 14-day programme in Melbourne aims to close the gap between electrical engineering and geospatial management.
Advanced Geographic Information Systems (GIS)
21 HoursThis instructor-led, live training in New Zealand (online or onsite) is aimed at intermediate-level geographers who wish to deepen their expertise in spatial analysis, data management, and GIS applications.
By the end of this training, participants will be able to:
- Apply advanced spatial analysis techniques to solve complex geographical problems.
- Manage large spatial databases and perform data quality control.
- Create dynamic and interactive maps and visualisations for various applications.
- Utilise programming and automation to streamline GIS workflows.
Insurance in the Digital Era
14 HoursA practical training in New Zealand that empowers insurance professionals to leverage AI, data, and InsurTech trends to modernize operations and customer engagement. Through workshops, case studies, and practical exercises, participants will build robust digital strategies to thrive in a rapidly evolving industry.
IREB CPRE – Foundation Level (Extended): Practical Requirements Engineering and Certification Preparation
14 HoursThis facilitator-led live training in New Zealand explores practical Requirements Engineering concepts, elicitation strategies, and documentation methods. It offers comprehensive exam preparation to assist participants in mastering the IREB CPRE syllabus and successfully achieving Foundation Level certification.
Python for ArcGIS and QGIS for Earth Sciences and Engineering Professionals
35 HoursThis instructor-led, live training in New Zealand (available online or on-site) is designed for beginner-level earth sciences and engineering professionals who wish to utilise Python for geospatial analysis in both ArcGIS and QGIS environments.
By the end of this training, participants will be able to:
- Master Python syntax and control structures to execute geospatial tasks efficiently.
- Leverage Pandas, Numpy, and Matplotlib for data analysis and visualisation in GIS.
- Manipulate and analyse vector data using the Geopandas, Arcpy, and PyQGIS libraries.
- Automate geospatial processes and workflows through Python scripting in both ArcGIS and QGIS.
- Develop custom Python-based geoprocessing tools for ArcGIS and QGIS to streamline operational tasks.
QGIS for Geographic Information System
21 HoursRequirements Analysis
21 HoursThis instructor-led, live training in New Zealand (online or on-site) is designed for individuals who wish to understand requirements analysis and carry it out efficiently and accurately using proven analysis techniques for their projects.
By the end of this training, participants will be able to:
- Identify different types of requirements.
- Understand the overarching concepts and activities involved in requirements analysis.
- Gain familiarity with requirements analysis methodology.
- Leverage various requirements analysis techniques to their advantage.
- Structure requirements to communicate effectively with architects and developers through an iterative requirement gathering process.