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
Need help picking the right course?
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
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 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 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 HoursBy the end of this training, participants will be able to:
- Understanding GIS concepts and spatial data types using the latest version of ArcGIS Pro.
- Investigate the user interface and evaluate the uses
- Explore ArcGIS* Pro and how to utilize online content
- Manage, manipulate and analyze your own data
- Display and share your data in a meaningful and creative way
Note: We will use the latest version of ArcGIS Pro.
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.
QGIS for Geographic Information System
21 HoursA geographic information system (GIS) is a system designed to capture, store, manipulate, analyze, manage, and present spatial or geographic data. The acronym GIS is sometimes used for geographic information science (GIScience) to refer to the academic discipline that studies geographic information systems and is a large domain within the broader academic discipline of geoinformatics.
QGIS functions as geographic information system (GIS) software, allowing users to analyze and edit spatial information, in addition to composing and exporting graphical maps. QGIS supports both raster and vector layers; vector data is stored as either point, line, or polygon features. Multiple formats of raster images are supported, and the software can georeference images. To summarize it allows the users to Create, edit, visualise, analyse and publish geospatial information on Windows, Mac, Linux, BSD.
This program, in its first phase, introduces the QGIS interface for general usage. In the second phase, we introduce PyQGIS - the python libraries of QGIS that allows the integration of GIS functionalities in your python code or your python application, so that you may even create your own Python Plugin around a particular GIS functionality.
Advanced Data Analysis with TIBCO Spotfire
14 HoursThis instructor-led, live training in the UAE (online or onsite) is aimed at business analysts who wish to learn advanced Spotfire Analyst techniques for analyzing data.
By the end of this training, participants will be able to:
- Share visualizations among different team members.
- Secure access to software based on roles and access controls.
- Create visualizations such as map charts.
- Integrate statistical computing languages such as R with Spotfire.
Introduction to Spotfire
14 HoursThis instructor-led, live training in the UAE (online or onsite) is aimed at business analysts and data analysts who wish to learn basic Spotfire Analyst techniques for analyzing data.
By the end of this training, participants will be able to:
- Install and configure TIBCO Spotfire.
- Combine data from different databases.
- Visualize large datasets.
- Create and share complex dashboards.
AI-Driven Data Analysis with TIBCO Spotfire X
14 HoursThis instructor-led, live training in the UAE (online or onsite) is aimed at business analysts and data analysts who wish to use TIBCO Spotfire X with its artificial intelligence capabilities to visualize, transform, and analyze data.
By the end of this training, participants will be able to:
- Install and configure TIBCO Spotfire X.
- Understand the features and architecture of TIBCO Spotfire X.
- Understand the concepts behind augmented and predictive analytics.
- Learn how to load, process, and visualize data using Spotfire X.
- Create interactive and enhanced data visualizations.
Data Analysis with SQL, Python and Spotfire
14 HoursIn this instructor-led, live training in the UAE, participants will learn three different approaches for accessing, analyzing and visualizing data. We start with an introduction to RDMS databases; the focus will be on accessing and querying an Oracle database using the SQL language. Then we look at strategies for accessing an RDMS database programmatically using the Python language. Finally, we look at how to visualize and present data graphically using TIBCO Spotfire.
Format of the Course
Interactive lecture and discussion.
Lots of exercises and practice.
Hands-on implementation in a live-lab environment.
Insurtech: A Practical Introduction for Managers
14 HoursInsurtech (a.k.a Digital Insurance) refers to the convergence of insurance + new technologies. In the field of Insurtech "digital insurers" apply technology innovations to their business and operating models in order to reduce costs, improve the customer experience and enhance the agility of their operations.
In this instructor-led training, participants will gain an understanding of the technologies, methods and mindset needed to bring about a digital transformation within their organizations and in the industry at large. The training is aimed at managers who need to gain a big picture understanding, break down the hype and jargon, and take the first steps in establishing an Insurtech strategy.
By the end of this training, participants will be able to:
- Discuss Insurtech and all its component parts intelligently and systematically
- Identify and demystify the role of each key technology within Insurtech.
- Draft a general strategy for implementing Insurtech within their organization
Audience
- Insurers
- Technologists within the insurance industry
- Insurance stakeholders
- Consultants and business analysts
Format of the course
- Part lecture, part discussion, exercises and case study group activities
Sensu: Beginner to Advanced
14 HoursThis instructor-led, live training in the UAE (online or onsite) is aimed at devops engineers who wish to create monitoring systems for multi-cloud infrastructures.
By the end of this training, participants will be able to:
- Monitor an enterprise from any cloud.
- Use auto-scaling and real-time visibility to create advanced monitoring systems.
- Authenticate a monitoring system with the Sensu API.
- Share programmed monitoring workflows amongst team members.
Monitoring Your Resources with Munin
7 HoursMunin is an open-source monitoring tool that helps system administrators monitor resources such as servers, workstations, networks, SANs, applications, network devices, etc. It shows resource trends and provides insights into questions such as "what just happened to kill our performance?" It includes visualization tools and is available on various flavors of Linux and FreeBSD.
Format of the Course
- Heavy emphasis on hands-on practice. Most of the concepts are learned through samples, exercises and hands-on development.