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
Upcoming Courses
Related Courses
ArcGIS for Spatial Analysis
14 HoursThis instructor-led, live training in Malaysia (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.
ArcGIS from Basic to Advanced
35 HoursThis instructor-led, live training in Malaysia (online or onsite) is aimed at beginner-level to advanced-level GIS professionals and analysts who wish to learn how to effectively use ArcGIS for data visualization, spatial analysis, and geospatial project management.
By the end of this training, participants will be able to:
- Navigate and utilize ArcGIS tools for geospatial data management.
- Create and customize 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 Malaysia (online or onsite) is targeted at beginner-level IT support personnel who wish to deliver robust support for ArcGIS Enterprise, effectively addressing any anomalies or system failures.
Upon completion of this training, participants will be able to:
- Grasp the architecture and components of ArcGIS Enterprise.
- Acquire the skills to install, configure, and manage ArcGIS Enterprise.
- Develop troubleshooting skills to resolve common issues.
- Gain proficiency in monitoring and maintaining ArcGIS Enterprise environments.
- Master techniques for backup, recovery, and performance optimisation.
ArcGIS Fundamentals
14 HoursThis live, instructor-led training in Malaysia (online or on-site) is geared towards beginner-level professionals eager to learn the essential concepts and tools of ArcGIS.
By the conclusion of this training, participants will be able to:
- Understand the basic concepts of GIS and spatial data.
- Navigate the ArcGIS interface.
- Create and manage spatial data.
- Perform basic spatial analysis.
- Create maps and visualizations.
ArcGIS Professional Plus: Advanced GIS Data Management and Analysis
14 HoursArcGIS Professional Plus represents an advanced iteration of ArcGIS Pro, delivering enhanced 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 deepen their expertise in spatial data analysis, automation, and data sharing using ArcGIS Professional Plus tools.
Upon completing this training, participants will be able to:
- Utilise ArcGIS Pro Plus tools to visualise and analyse data effectively.
- Develop 2D and 3D maps incorporating advanced symbology and geoprocessing techniques.
- Automate workflows through ModelBuilder and Python scripting.
- Integrate ArcGIS with external data services and enterprise systems.
Course Format
- Interactive lectures and discussions.
- Ample exercises and practical practice.
- Hands-on implementation within a live-lab environment.
Course Customisation Options
- To request customised training for this course, please contact us to arrange.
Advanced ArcGIS Pro for Spatial Analysis
35 HoursThis instructor-led live training in Malaysia (online or onsite) is designed for advanced-level GIS professionals who wish to use ArcGIS Pro to enhance their spatial analysis capabilities, conduct comprehensive geostatistical analysis, and apply advanced 3D modeling 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.
- Utilize Python scripting for automation and complex data processing.
- Apply spatial modeling for problem-solving in real-world scenarios.
- Conduct geostatistical analysis for advanced data interpretation.
- Integrate external data sources and leverage 3D spatial data analysis.
Advanced Power Systems and GIS Integrated Solutions
70 HoursIn the rapidly evolving energy sector, combining electrical transient analysis with accurate geographic data has become a strategic imperative. Relying on disjointed data currently exposes organizations to significant operational risks. This intensive 14-day program in Melbourne aims to bridge the gap between electrical engineering principles and geospatial management.
Advanced Geographic Information Systems (GIS)
21 HoursThis instructor-led, live training in Malaysia (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 visualizations for various applications.
- Utilize programming and automation to streamline GIS workflows.
Insurance in the Digital Era
14 HoursInsurance in the Digital Era offers a practical overview of how digital transformation is reshaping products, operations, and customer engagement within the insurance industry.
This instructor-led live training (available online or onsite) is designed for intermediate-level insurance professionals seeking to understand and apply digital technologies, data-driven strategies, and innovation frameworks to modernize their insurance offerings and operational processes.
Upon completion of this training, participants will be able to:
- Explain the role of AI, Big Data, IoT, and automation in modern insurance workflows.
- Identify InsurTech trends and their impact on the insurance ecosystem.
- Design customer-centric strategies enabled by digital tools and data insights.
- Apply data-driven approaches to risk management and decision making.
- Develop an innovation and change management approach suitable for insurers.
- Assess real-world case studies and translate lessons into local initiatives.
Format of the Course
- Interactive lecture and discussion.
- Case study analysis and group workshops.
- Practical exercises and action planning for participants’ organizations.
Course Customization Options
- To request a customized training for this course, please contact us to arrange.
QGIS (Advanced Level) Manage Corporate Spatial Data with PostGIS and QGIS
7 HoursThis instructor-led, online live training is designed for advanced learners who wish to develop skills in managing large-scale spatial databases using PostGIS and QGIS.
Course Format
- Interactive lectures and discussions.
- Extensive exercises and practical sessions.
- Hands-on implementation in a live laboratory environment.
Customization Options
- To request tailored training for this course, please contact us to arrange.
Python for ArcGIS and QGIS for Earth Sciences and Engineering Professionals
35 HoursThis instructor-led live training in Malaysia (online or onsite) targets beginner-level earth sciences and engineering professionals who wish to utilize Python for geospatial analysis in ArcGIS and QGIS environments.
By the end of this training, participants will be able to:
- Learn Python syntax and control structures for executing geospatial tasks efficiently.
- Use Pandas, Numpy, and Matplotlib for data analysis and visualization in GIS.
- Manipulate and analyze vector data with Geopandas, Arcpy, and PyQGIS libraries.
- Automate geospatial processes and workflows using Python scripting in ArcGIS and QGIS.
- Develop custom Python-based geoprocessing tools for ArcGIS and QGIS to streamline tasks.
QGIS for Geographic Information System
21 HoursA Geographic Information System (GIS) is a framework designed to capture, store, manipulate, analyze, manage, and present spatial or geographic data. The term GIS is occasionally used to denote Geographic Information Science (GIScience), referring to the academic discipline that studies these systems, which forms a significant domain within the broader field of geoinformatics.
QGIS serves as open-source GIS software, enabling users to analyze 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 allows for image georeferencing. In summary, it empowers users to create, edit, visualize, analyze, and publish geospatial information across Windows, Mac, Linux, and BSD operating systems.
In the initial phase, this program introduces the QGIS interface for general usage. The second phase focuses on PyQGIS—the Python libraries of QGIS—which facilitates the integration of GIS functionalities into your Python code or applications. This allows you to even develop your own Python plugins tailored to specific GIS functions.
QGIS Quick Start (Beginner Level)
7 HoursA Geographic Information System (GIS) is a framework designed to capture, store, manipulate, analyse, manage, and present spatial or geographic data. The term GIS is occasionally used to refer to Geographic Information Science (GIScience), which is the academic discipline studying these systems and forms a significant part of the broader field of geoinformatics.
This instructor-led live training (conducted online) is designed for beginners who wish to acquire knowledge of GIS concepts and develop practical skills for using QGIS.
Course Format
- Interactive lectures and discussions.
- Numerous exercises and practice sessions.
- Hands-on implementation in a live-lab environment.
Course Customization Options
- To request customized training for this course, please contact us to arrange.
QGIS (Intermediate Level) Remote Sensing and Image Classification with QGIS
7 HoursThis instructor-led, live online training at the intermediate level focuses on QGIS, guiding participants on how to handle satellite imagery and execute image classification.
Course Format
- Interactive lectures and discussions.
- Numerous exercises and practical sessions.
- Practical implementation in a live-lab environment.
Course Customization Options
- For those wishing to request tailored training for this course, please reach out to us to make arrangements.