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, available in Denmark either online or onsite, is tailored for advanced-level DevOps and SRE professionals aiming to refine their alerting and automation capabilities using Grafana and Prometheus.
By the conclusion of this training, participants will be capable of:
- Developing and managing advanced alerting rules in Prometheus.
- Connecting Prometheus Alertmanager with external tools via webhooks.
- Accelerating issue resolution by automating alert responses.
- Utilizing Grafana to visualize and manage alerts efficiently.
ArcGIS for Spatial Analysis
14 HoursThis live, instructor-led training in Denmark, offered either online or onsite, is designed for field ecologists and conservation managers looking to create spatial data projects in ArcGIS.
By the conclusion of this training, participants will be capable of:
- Presenting spatial data through visualizations.
- Performing geostatistics on actual datasets.
- Carrying out spatial data analysis, processing, and mapping using ArcGIS.
- Analyzing spatial data for specific projects within ArcGIS.
ArcGIS from Basic to Advanced
35 HoursThis live, instructor-led course in Denmark (delivered online or on-site) is designed for GIS professionals and analysts of all levels, from beginners to advanced users, who seek to proficiently leverage ArcGIS for visualizing data, conducting spatial analysis, and managing geospatial projects.
Upon completion of this program, participants will be equipped to:
- Manage geospatial data efficiently using ArcGIS tools.
- Construct and customize maps incorporating various layers and attributes.
- Carry out sophisticated spatial analysis and geoprocessing tasks.
- Optimize workflows by employing ModelBuilder and Python.
ArcGIS Enterprise for Technical Support
14 HoursThis live, instructor-led training in Denmark (delivered online or onsite) is tailored for beginner-level IT support personnel aiming to provide robust support for ArcGIS Enterprise. The focus is on effectively managing anomalies and resolving failures.
By the end of the program, participants will have the ability to:
- Understand the architecture and components of ArcGIS Enterprise.
- Install, configure, and manage the platform.
- Troubleshoot and resolve common issues.
- Monitor and maintain ArcGIS Enterprise environments.
- Master backup, recovery, and performance optimization techniques.
ArcGIS Fundamentals
14 HoursThis live, instructor-led programme in Denmark, offered online or on-site, is tailored for entry-level professionals aiming to acquire the essential concepts and tools of ArcGIS.
By the conclusion of this training, participants will be capable of:
- Understanding core GIS principles and spatial data concepts.
- Navigating the ArcGIS interface efficiently.
- Creating and managing spatial data.
- Performing basic spatial analysis.
- Designing maps and visualizations.
ArcGIS Professional Plus: Advanced GIS Data Management and Analysis
14 HoursAdvanced ArcGIS Pro for Spatial Analysis
35 HoursThis live, instructor-led training, delivered in Denmark (either online or onsite), is tailored for advanced GIS professionals. It aims to help users refine their spatial analysis skills via ArcGIS Pro, execute detailed geostatistical assessments, and apply advanced 3D modeling techniques to improve decision-making and solve real-world problems.
By the conclusion of the program, participants will be able to:
- Refine advanced spatial analysis techniques using ArcGIS Pro.
- Apply Python scripting for automation and complex data processing.
- Use spatial modeling to tackle real-world scenarios.
- Execute geostatistical analysis for advanced data interpretation.
- Combine external data sources with 3D spatial data analysis.
Advanced Power Systems and GIS Integrated Solutions
70 HoursWithin the dynamic energy sector, combining electrical transient analysis with accurate geographic information has become a critical strategic requirement. The current dependence on fragmented data creates substantial operational vulnerabilities. This 14-day intensive program in Melbourne is crafted to narrow the gap between electrical engineering and geospatial management.
Advanced Geographic Information Systems (GIS)
21 HoursThis live, instructor-led training—delivered either online or on-site—is designed for intermediate-level geographers looking to enhance their proficiency in spatial analysis, data management, and practical GIS applications.
Upon completion, participants will be equipped to:
- Apply sophisticated spatial analysis techniques to address complex geographical challenges.
- Oversee large-scale spatial databases and ensure rigorous data quality control.
- Develop dynamic, interactive maps and visualizations tailored to diverse applications.
- Leverage programming and automation to optimize GIS workflows.
Insurance in the Digital Era
14 HoursIREB CPRE – Foundation Level (Extended): Practical Requirements Engineering and Certification Preparation
14 HoursPython for ArcGIS and QGIS for Earth Sciences and Engineering Professionals
35 HoursThis live, instructor-led training Denmark (delivered online or onsite) is specifically designed for entry-level earth sciences and engineering professionals aiming to leverage Python for geospatial analysis within ArcGIS and QGIS.
By the end of this session, participants will have the competence to:
- Apply Python syntax and control structures to perform geospatial tasks more efficiently.
- Leverage Pandas, NumPy, and Matplotlib for insightful data analysis and visualization in GIS projects.
- Manipulate and process vector data using the Geopandas, Arcpy, and PyQGIS libraries.
- Automate complex geospatial workflows via Python scripting in both ArcGIS and QGIS.
- Create bespoke geoprocessing tools in Python for ArcGIS and QGIS to optimize task execution.
QGIS for Geographic Information System
21 HoursRequirements Analysis
21 HoursThis live, instructor-led session in Denmark (available online or onsite) is tailored for professionals who want to deepen their understanding of requirements analysis and apply it effectively to their projects using specialized analysis techniques.
By the end of the training, participants will be equipped to:
- Differentiate between various types of requirements.
- Understand the fundamental concepts and activities within the requirements analysis process.
- Become well-versed in the standard requirements analysis methodology.
- Utilize diverse analysis techniques to their full advantage.
- Structure requirements logically to enable efficient collaboration with architects and developers through iterative gathering.