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
Advanced Alerting and Automation with Grafana and Prometheus
14 HoursThis instructor-led, live training in Czech Republic (online or onsite) is aimed at advanced-level DevOps and SRE professionals who wish to enhance their alerting and automation skills with Grafana and Prometheus.
By the end of this training, participants will be able to:
- Create and manage advanced alerting rules in Prometheus.
- Integrate Prometheus Alertmanager with external tools using webhooks.
- Automate responses to alerts for faster issue resolution.
- Use Grafana to visualize and manage alerts effectively.
ArcGIS for Spatial Analysis
14 HoursThis instructor-led, live training in Czech Republic (online or onsite) is aimed at field ecologists and conservation managers who wish to create spatial data projects in ArcGIS.
By the end of this training, participants will be able to:
- Output spatial data as visualizations.
- Conduct geostatistics 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 Czech Republic (online or in-person) targets beginner to advanced GIS professionals and analysts who aim 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 Czech Republic (online or onsite) is aimed at beginner-level IT support personnel who wish to provide robust support for ArcGIS Enterprise, addressing any anomalies or failures effectively.
By the end of this training, participants will be able to:
- Understand the architecture and components of ArcGIS Enterprise.
- Learn to install, configure, and manage ArcGIS Enterprise.
- Gain skills in troubleshooting and resolving common issues.
- Develop proficiency in monitoring and maintaining ArcGIS Enterprise environments.
- Master the techniques for backup, recovery, and performance optimization.
ArcGIS Fundamentals
14 HoursThis instructor-led live training in Czech Republic (online or onsite) targets beginner-level professionals aiming to learn the foundational concepts and tools of ArcGIS.
By the end 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, providing extended capabilities for geospatial data analysis, 3D modeling, automation, and enterprise-level collaboration.
This instructor-led live training, available either online or onsite, is designed for GIS professionals with intermediate experience who aim to enhance their expertise in spatial data analysis, automation, and sharing through ArcGIS Professional Plus tools.
Upon completion of this training, participants will be able to:
- Utilize ArcGIS Pro Plus tools effectively for data visualization and analysis.
- Develop 2D and 3D maps employing 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 practical practice sessions.
- Hands-on implementation within a live-lab environment.
Options for Course Customization
- To request a customized training session for this course, please contact us to make arrangements.
Advanced ArcGIS Pro for Spatial Analysis
35 HoursThis instructor-led live training in Czech Republic (online or onsite) targets advanced GIS professionals who wish to enhance their spatial analysis capabilities with ArcGIS Pro. Participants will conduct comprehensive geostatistical analysis and apply advanced 3D modeling techniques to improve decision-making and problem-solving in practical scenarios.
Upon completion of this training, participants will be able to:
- Demonstrate advanced proficiency in spatial analysis techniques within ArcGIS Pro.
- Employ Python scripting for automation and complex data processing.
- Implement spatial modeling to address real-world challenges.
- Perform geostatistical analysis for in-depth data interpretation.
- Integrate external data sources and utilize 3D spatial data analysis.
Advanced Power Systems and GIS Integrated Solutions
70 HoursIn the dynamic energy sector, combining electrical transient analysis with accurate geographic data has become a strategic imperative. Currently, depending on disconnected data sources creates substantial operational risks. This 14-day intensive 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 Czech Republic (online or on-site) is designed for geographers at an intermediate level who aim to deepen their expertise in spatial analysis, data management, and GIS applications.
Upon completion of this training, participants will be able to:
- Employ advanced spatial analysis techniques to address complex geographical challenges.
- Manage large-scale spatial databases and conduct data quality control.
- Design dynamic and interactive maps and visualizations for diverse applications.
- Leverage programming and automation to streamline GIS workflows.
Insurance in the Digital Era
14 HoursInsurance in the Digital Era provides a practical look at how digital transformation is reshaping products, operations, and customer engagement within the insurance sector.
This instructor-led, live training (available online or onsite) targets intermediate-level insurance professionals who want to understand and implement digital technologies, data-driven strategies, and innovation frameworks to modernize their insurance offerings and operations.
By the end 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 how they affect 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.
IREB CPRE – Foundation Level (Extended): Practical Requirements Engineering and Certification Preparation
14 HoursRequirements Engineering (RE) serves as a critical discipline in software and systems development, concentrating on the identification, documentation, and management of stakeholder needs and constraints to guarantee project success.
This instructor-led live training, available online or onsite, targets intermediate-level professionals aiming to enhance their grasp of practical Requirements Engineering while preparing for the IREB CPRE – Foundation Level certification exam.
After completing this training, participants will be equipped to:
- Grasp and apply the core concepts and terminology outlined in the IREB CPRE Foundation syllabus.
- Identify and elicit requirements using effective techniques suited to the specific context.
- Model, document, and validate requirements for real-world projects.
- Manage requirements changes, traceability, and prioritization throughout the project lifecycle.
- Utilize Requirements Engineering tools and best practices to improve communication and project outcomes.
- Feel fully prepared to take and pass the IREB CPRE – Foundation Level certification exam.
Course Format
- Interactive lectures and discussions.
- Case-based exercises and collaborative workshops.
- Dedicated exam preparation sessions and practice questions.
Customization Options
- Additional modules or industry-specific case studies can be included upon request.
Python for ArcGIS and QGIS for Earth Sciences and Engineering Professionals
35 HoursThis instructor-led, live training in Czech Republic (online or onsite) is aimed at beginner-level earth sciences and engineering professionals who wish to use Python for geospatial analysis in both 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 sometimes used interchangeably with Geographic Information Science (GIScience) to denote the academic discipline focused on studying these systems, representing a significant domain within the broader field of geoinformatics.
QGIS operates as 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 multiple raster image formats and can georeference images. In summary, it empowers users to create, edit, visualize, analyze, and publish geospatial information across Windows, Mac, Linux, and BSD platforms.
In its initial phase, this program introduces the QGIS interface for general usage. The second phase covers PyQGIS—the Python libraries of QGIS that allow the integration of GIS functionalities into your Python code or applications. This enables you to create your own Python Plugin tailored to specific GIS functionalities.
Requirements Analysis
21 HoursThis instructor-led, live training in Czech Republic (online or onsite) is designed for individuals who wish to understand requirements analysis and execute it efficiently and accurately by utilizing analysis techniques for their projects.
Upon completing this training, participants will be able to:
- recognize various types of requirements.
- comprehend the overarching concepts and activities involved in requirements analysis.
- gain familiarity with the requirements analysis methodology.
- leverage diverse requirements analysis techniques for optimal results.
- organize requirements to facilitate efficient communication with architects and developers through an iterative requirement gathering process.