Data Analysis with Python, Pandas and Numpy Training Course
Python is a versatile programming language known for its simplicity and readability. Pandas is a Python package that provides data structures for working with structured (tabular, multidimensional, potentially heterogeneous) and time series data. Numpy provides fundamental support for numerical computing with its array operations. Together, they form a robust ecosystem for efficient data handling and analysis in Python.
This instructor-led, live training (online or onsite) is aimed at intermediate-level Python developers and data analysts who wish 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 that includes 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 analyze time series data.
- Visualize data using Matplotlib and other visualization libraries.
- Debug and optimize their data analysis code.
Format of the Course
- Interactive lecture and discussion.
- Lots of exercises and practice.
- Hands-on implementation in a live-lab environment.
Course Customization Options
- To request a customized training 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
- Optimizing performance by avoiding loops
- Optimizing performance with cProfile
Data Analysis with Pandas
- Using vectorized data in pandas
- Data wrangling
- Sorting and filtering data
- Aggregate operations
- Analyzing time series
Data Visualization with Matplotlib
- Plotting diagrams with Matplotlib
- Using Matplotlib from within pandas
- Creating quality diagrams
- Visualizing data in Jupyter notebooks
- Other visualization 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 Australia (online or onsite) is aimed at field ecologists and conservation managers who wish to create data spatial projects in ArcGIS.
By the end of this training, participants will be able to:
- Output spatial data as visualizations.
- Conduct geostatics on actual data.
- Implement spatial data analysis, data processing, and mapping with ArcGIS.
- Analyze spatial data for projects in ArcGIS.
ArcMap in ArcGIS
14 HoursThis instructor-led, live training in Australia (online or onsite) is aimed at intermediate-level environmental scientists and archaeologists who wish to learn how to use ArcMap in ArcGIS for collecting, organizing, managing, and analyzing geographic information.
By the end of this training, participants will be able to:
- Understand the fundamentals of ArcMap and ArcGIS.
- Collect, organize, manage, and analyze geographic information on the social and archaeological elements.
- Conduct spatial queries for impact evaluation.
ArcGIS from Basic to Advanced
35 HoursThis instructor-led, live training in Australia (online or onsite) is tailored for beginner to advanced GIS professionals and analysts who want to learn how to effectively utilise ArcGIS for data visualisation, spatial analysis, and geospatial project management.
By the conclusion of this training, participants will be able to:
- Navigate and utilise ArcGIS tools for geospatial data management.
- Create and customise maps using 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 Australia (online or onsite) is designed for beginner-level IT support personnel who wish to provide comprehensive support for ArcGIS Enterprise, effectively addressing any anomalies or failures.
Upon completion of this training, participants will be able to:
- Gain a clear understanding of the architecture and components of ArcGIS Enterprise.
- Learn to install, configure, and manage ArcGIS Enterprise environments.
- Develop skills in troubleshooting and resolving common issues.
- Become proficient in monitoring and maintaining ArcGIS Enterprise systems.
- Master techniques for backup, recovery, and performance optimisation.
ArcGIS Fundamentals
14 HoursThis instructor-led, live training in Australia (online or onsite) is designed for professionals at the beginner level who wish to master the core concepts and tools of ArcGIS.
Upon completion of this training, participants will be able to:
- Grasp the fundamental concepts of GIS and spatial data.
- Navigate the ArcGIS interface with confidence.
- Create and manage spatial data effectively.
- Conduct basic spatial analysis.
- Produce maps and visualisations.
ArcGIS Pro for Spatial Analysis
14 HoursUpon completion of this training, participants will be equipped with the following capabilities:
- Gain a solid understanding of GIS concepts and spatial data types using the most recent version of ArcGIS Pro.
- Navigate the user interface and assess its various applications.
- Explore ArcGIS Pro and discover how to leverage online content effectively.
- Manage, manipulate, and analyse your own data.
- Display and share your data in a meaningful and creative manner.
Note: This course utilises the latest version of ArcGIS Pro.
ArcGIS Professional Plus: Advanced GIS Data Management and Analysis
14 HoursArcGIS Pro Plus is an advanced iteration of ArcGIS Pro, providing extended capabilities for geospatial data analysis, 3D modelling, automation, and enterprise collaboration.
This instructor-led, live training (available online or onsite) is designed for intermediate-level GIS professionals looking to enhance their skills in spatial data analysis, automation, and data sharing using ArcGIS Pro Plus tools.
Upon completion of this training, participants will be able to:
- Utilise ArcGIS Pro Plus tools for data visualisation and analysis.
- Create 2D and 3D maps using advanced symbology and geoprocessing techniques.
- Automate workflows using ModelBuilder and Python scripting.
- Integrate ArcGIS with external data services and enterprise systems.
Course Format
- Interactive lectures and discussions.
- Numerous exercises and practice opportunities.
- Hands-on implementation in a live-lab environment.
Course Customisation Options
- To request a customised training session for this course, please contact us to make arrangements.
Advanced ArcGIS Pro for Spatial Analysis
35 HoursThis instructor-led, live training in Australia (online or onsite) is designed for advanced-level GIS professionals seeking to utilise ArcGIS Pro to bolster their spatial analysis capabilities, perform comprehensive geostatistical analysis, and apply advanced 3D modelling techniques to facilitate more effective decision-making and problem-solving in real-world scenarios.
Upon completion of this training, participants will be able to:
- Develop advanced proficiency in spatial analysis techniques using ArcGIS Pro.
- Employ Python scripting for automation and complex data processing.
- Apply spatial modelling to address problem-solving challenges in real-world contexts.
- Conduct geostatistical analysis for sophisticated data interpretation.
- Integrate external data sources and leverage 3D spatial data analysis.
ArcGIS with Python Scripting
14 HoursThis instructor-led live training in Australia (online or onsite) is aimed at GIS analysts who wish to automate repetitive tasks in GIS processes.
By the end of this training, participants will be able to:
- Build GIS applications using Python and ArcGIS tools.
- Develop with the ArcGIS package ArcPy, using Python.
- Apply the ArcGIS modules for map automation using object classes in Python.
Advanced Power Systems and GIS Integrated Solutions
70 HoursIn the dynamic energy sector, merging electrical transient analysis with precise geographic data is a strategic imperative. At present, depending on disjointed data creates substantial operational risks. This intensive 14-day program, hosted in Melbourne, aims to bridge the gap between electrical engineering and geospatial management.
Advanced Geographic Information Systems (GIS)
21 HoursThis instructor-led, live training in Australia (online or onsite) is designed for intermediate-level geographers seeking to deepen their expertise in spatial analysis, data management, and GIS applications.
Upon completing this training, participants will be capable of:
- Applying advanced spatial analysis techniques to resolve complex geographical challenges.
- Managing extensive spatial databases and executing data quality assurance.
- Developing dynamic and interactive maps and visualisations for diverse applications.
- Utilising programming and automation to optimise GIS workflows.
Google Maps API for Developers
14 HoursThis instructor-led, live training in Australia (online or on-site) is designed for developers seeking to enhance their website or web application by incorporating geo-location functionality through Google Maps.
Upon completion of this training, participants will be able to:
- Embed a map into a new or existing website or web application.
- Display live data that syncs with the current location.
- Create a mashup that includes Google Maps.
- Apply robust CSS and JavaScript coding practices.
- Construct a custom map tailored to an application.
Python for ArcGIS and QGIS for Earth Sciences and Engineering Professionals
35 HoursThis instructor-led, live training in Australia (online or onsite) is designed for beginner-level earth sciences and engineering professionals who wish to use Python for geospatial analysis in both ArcGIS and QGIS environments.
Upon completing this training, participants will be capable of:
- Mastering Python syntax and control structures to execute geospatial tasks efficiently.
- Employing Pandas, Numpy, and Matplotlib for data analysis and visualisation within GIS.
- Manipulating and analysing vector data using the Geopandas, Arcpy, and PyQGIS libraries.
- Automating geospatial processes and workflows through Python scripting in ArcGIS and QGIS.
- Creating custom Python-based geoprocessing tools for ArcGIS and QGIS to optimise tasks.
QGIS for Geographic Information System
21 HoursA geographic information system (GIS) is designed to capture, store, manipulate, analyse, manage, and present spatial or geographic data. The acronym GIS is occasionally used to refer to geographic information science (GIScience), which denotes the academic discipline studying these systems and forms a significant part of the broader field of geoinformatics.
QGIS operates as GIS software, enabling users to analyse and edit spatial information, as well as compose and export graphical maps. It supports both raster and vector layers; vector data is stored as point, line, or polygon features. The software accommodates various raster image formats and can georeference images. In summary, it empowers users to create, edit, visualise, analyse, and publish geospatial information across Windows, Mac, Linux, and BSD platforms.
In the first phase, this program introduces the QGIS interface for general usage. In the second phase, we explore PyQGIS—the Python libraries of QGIS—which allow the integration of GIS functionalities into your Python code or applications. This enables you to develop your own Python Plugins centred on specific GIS functionalities.