Data Analysis with Python, Pandas and Numpy Training Course
Python is a highly adaptable programming language renowned for its simplicity and clarity. Pandas is a Python library that offers data structures designed for handling structured (tabular, multidimensional, potentially heterogeneous) and time series data efficiently. Numpy supports numerical computing with powerful array operations. Together, these tools create a strong ecosystem for effective data management and analysis in Python.
This instructor-led training session (held either online or at your location) is tailored for intermediate-level Python developers and data analysts looking to refine their skills in data analysis and manipulation using Pandas and NumPy.
Upon completion of this course, participants will be able to:
- Establish a development environment incorporating Python, Pandas, and NumPy.
- Develop a data analysis application utilizing Pandas and NumPy.
- Execute advanced data manipulation tasks such as sorting and filtering.
- Perform aggregate operations and analyze time series datasets.
- Create visual representations of data using Matplotlib and other visualization tools.
- Debug and enhance the performance of their data analysis code.
Course Format
- Engaging lectures and discussions.
- A wealth of exercises and practical application opportunities.
- Hands-on implementation in a live-lab setting.
Customization Options for the Course
- To arrange a customized training session, please contact us to discuss your requirements.
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
Need help picking the right course?
Data Analysis with Python, Pandas and Numpy Training Course - 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 the UAE (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 the UAE (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 the UAE (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 the UAE (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 the UAE (online or onsite) is aimed at beginner-level professionals who wish to learn the fundamental 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 Pro for Spatial Analysis
14 HoursUpon completion of this training, participants will be able to:
- Grasp GIS concepts and spatial data types using the most recent version of ArcGIS Pro.
- Examine the user interface and assess its applications.
- Explore ArcGIS* Pro and leverage online content effectively.
- Handle, manipulate, and analyze their own datasets.
- Present and share their data in a meaningful and innovative manner.
Note: The training will utilize the latest version of ArcGIS Pro.
ArcGIS Professional Plus: Advanced GIS Data Management and Analysis
14 HoursArcGIS Professional Plus is an advanced version of ArcGIS Pro, offering extended features for geospatial data analysis, 3D modeling, automation, and enterprise collaboration.
This instructor-led, live training (online or onsite) is aimed at intermediate-level GIS professionals who wish to deepen their skills in spatial data analysis, automation, and sharing using ArcGIS Professional Plus tools.
By the end of this training, participants will be able to:
- Leverage ArcGIS Pro Plus tools for data visualization and analysis.
- Create 2D and 3D maps with advanced symbology and geoprocessing techniques.
- Automate workflows using ModelBuilder and Python scripting.
- Integrate ArcGIS with external data services and enterprise systems.
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.
Advanced ArcGIS Pro for Spatial Analysis
35 HoursThis instructor-led, live training in the UAE (online or onsite) 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 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.
ArcGIS with Python Scripting
14 HoursThis instructor-led, live training in the UAE (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 Geographic Information Systems (GIS)
21 HoursThis instructor-led, live training in the UAE (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.
Google Maps API for Developers
14 HoursThis instructor-led, live training in the UAE (online or onsite) is aimed at developers who wish to enhance their website or web application by adding geo-location functionality through Google Maps.
By the end of this training, participants will be able to:
- Embed a map into a new or existing website or web application.
- Display live data that synchs with current location.
- Create a mashup that includes Google Maps.
- Apply good CSS and JavaScript coding practices
- Create a custom map for an application.
Python for Geographic Information System (GIS)
21 HoursA geographic information system (GIS) is a specialized system designed for capturing, storing, manipulating, analyzing, managing, and presenting spatial or geographic data. Sometimes, the acronym GIS is used to denote geographic information science (GIScience), which refers to the academic field that studies these systems and falls under the broader discipline of geoinformatics.
The integration of Python with GIS has significantly grown over the past two decades, especially following the release of Python 2.0 in 2000, which introduced numerous new programming features that greatly simplified its use. Since then, Python has been widely adopted not only by commercial GIS products like those from Esri but also by open-source platforms such as QGIS and GRASS. Currently, Python is undoubtedly the most commonly used language among GIS users and developers.
This program focuses on using Python along with advanced libraries such as geopandas, pysal, bokeh, and osmnx to develop your own GIS functionalities. Additionally, it includes introductory modules covering the ArcGIS API and QGIS toolbox.
Python for ArcGIS and QGIS for Earth Sciences and Engineering Professionals
35 HoursThis instructor-led, live training in the UAE (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 designed to capture, store, manipulate, analyze, manage, and present spatial or geographic data. The acronym GIS can also refer to geographic information science (GIScience), which is the academic field that studies these systems and falls under the broader discipline of geoinformatics.
QGIS serves as a geographic information system (GIS) software enabling users to analyze and modify spatial data, as well as create and export graphical maps. It supports both raster and vector layers; vector data can be in point, line, or polygon formats. QGIS handles multiple raster image formats and can georeference images. In essence, it allows users to create, edit, visualize, analyze, and publish geospatial information on Windows, Mac, Linux, and BSD.
In the initial phase of this program, we will introduce the general use of the QGIS interface. During the second phase, we will cover PyQGIS—the Python libraries for QGIS—which allows you to integrate GIS functionalities into your Python code or applications, enabling you to develop your own Python plugins based on specific GIS features.