Course Acad ID: ACAD0139
Python with Pandas and NumPy Training

Focuses on working with structured data using Pandas and performing high-performance numerical operations with NumPy.

Overview

This Python with Pandas and NumPy training is designed to help participants master data manipulation, numerical computing, and analytical workflows using Python’s most powerful libraries. The course focuses on working with structured data using Pandas and performing high-performance numerical operations with NumPy. Participants will gain hands-on experience to clean, transform, analyze, and visualize datasets efficiently for data analysis, business intelligence, and data science use cases.

Learning Outcomes

• Understand core Python programming concepts for data analysis and scientific computing.
• Work with NumPy arrays for efficient numerical computations and mathematical operations.
• Perform data cleaning, transformation, filtering, and aggregation using Pandas.
• Analyze structured datasets using DataFrames, statistical functions, and data manipulation techniques.
• Handle real-world data from CSV, Excel, and JSON sources for business analysis.
• Build data-driven reports, visualizations, and analytical workflows using Python libraries.

Duration & Delivery Mode

14 hours

We serve:
Target Audience

 • Data analysts and business analysts
 • Data scientists and aspiring data professionals
 • Python developers working with data
 • Business intelligence professionals
 • Students and professionals entering data analytics

Pre-requisites

 • Basic knowledge of Python programming
 • Basic understanding of data concepts is helpful
 • Familiarity with spreadsheets or CSV data formats

Skillset Achieved

 • Performing data analysis using Pandas
 • Manipulating and transforming datasets
 • Working with NumPy arrays and vectorized operations
 • Handling missing data and data cleaning
 • Merging, joining, and reshaping datasets
 • Performing statistical and numerical analysis
 • Building efficient data analysis workflows

Course Outcome

By the end of this training, participants will be able to confidently use Pandas and NumPy to analyze, clean, and transform data for real-world business and data science applications. Learners will gain practical skills to build efficient analytical workflows and prepare datasets for advanced analytics, machine learning, and reporting.

Course Outline

Introduction to NumPy for Numerical Computing
 • NumPy arrays and data types
 • Creating and reshaping arrays
 • Indexing, slicing, and broadcasting
 • Vectorized operations and performance benefits

Foundations of Pandas
 • Pandas Series and DataFrames
 • Loading data from CSV, Excel, and databases
 • Inspecting and exploring datasets
 • Basic data selection and filtering

Data Cleaning & Preprocessing
 • Handling missing values
 • Data type conversions
 • Removing duplicates
 • Basic data validation

Exploratory Data Analysis with Pandas
 • Descriptive statistics
 • Sorting and ranking data
 • GroupBy operations
 • Basic data aggregation

Advanced Pandas Operations
 • Merging and joining DataFrames
 • Concatenating datasets
 • Reshaping with pivot tables and melt
 • Working with hierarchical indexes

Time Series Data Analysis
 • Working with date and time data
 • Resampling and rolling windows
 • Time-based indexing
 • Time series feature extraction

Numerical Analysis with NumPy
 • Mathematical and statistical functions
 • Random number generation
 • Linear algebra basics
 • Performance optimization with NumPy

Data Visualization Integration
 • Integrating Pandas with Matplotlib
 • Creating basic charts and plots
 • Visualizing trends and distributions
 • Best practices for data visualization

Building End-to-End Data Analysis Workflows
 • Designing repeatable analysis pipelines
 • Combining NumPy and Pandas effectively
 • Managing large datasets efficiently
 • Best practices for production-ready analysis

Assessment Topics

• Python Fundamentals for Data Analysis Assessment
• NumPy Array Operations Assessment
• Pandas Data Manipulation Assessment
• Data Cleaning & Transformation Assessment
• Data Analysis & Reporting Mini Project Assessment
 

Evaluation

Participants will be evaluated through hands-on labs, real-world data analysis exercises, instructor-led code reviews, and a final practical assessment focused on applying Pandas and NumPy for business and analytical use cases.

Course Materials

Participants will receive course materials, slides, reference materials, exercises and access to resources for further learning.

Certification

Upon successful completion of the training, participants will receive an AcadNXT Certificate of Completion for Python with Pandas and NumPy. This digital, verifiable certification validates practical data analysis and numerical computing skills and can be shared on LinkedIn and included in professional profiles.

SELECT AN UPCOMING CLASS
Wed 2nd Dec 2026 – Thu 3rd Dec 2026
⏱ 2 days 📍 Classroom
AcadNXT Classroom - Los Angeles, California Los Angeles United States
Wed 2nd Dec 2026 – Thu 3rd Dec 2026
⏱ 2 days 📍 Classroom
AcadNXT Classroom - Kandy, Sri Lanka Kandy Sri Lanka
Wed 2nd Dec 2026 – Thu 3rd Dec 2026
⏱ 2 days 📍 Classroom
AcadNXT Classroom - Galle, Sri Lanka Galle Sri Lanka
Wed 2nd Dec 2026 – Thu 3rd Dec 2026
⏱ 2 days 📍 Classroom
AcadNXT Classroom - Gurgaon, Haryana, India Gurgaon India
Thu 3rd Dec 2026 – Fri 4th Dec 2026
⏱ 2 days 📍 Classroom
AcadNXT Classroom - Bengaluru, India Bengaluru India
Thu 3rd Dec 2026 – Fri 4th Dec 2026
⏱ 2 days 📍 Classroom
AcadNXT Classroom - Chennai, India Chennai India
Thu 3rd Dec 2026 – Fri 4th Dec 2026
⏱ 2 days 📍 Classroom
AcadNXT Classroom - Seattle, Washington Seattle United States
Thu 3rd Dec 2026 – Fri 4th Dec 2026
⏱ 2 days 📍 Classroom
AcadNXT Classroom - Adelaide, SA, Australia Adelaide Australia
Thu 3rd Dec 2026 – Fri 4th Dec 2026
⏱ 2 days 📍 Classroom
AcadNXT Classroom - Ahmedabad, Gujarat, India Ahmedabad India
Fri 4th Dec 2026 – Sat 5th Dec 2026
⏱ 2 days 📍 Classroom
AcadNXT Classroom - Hyderabad, India Hyderabad India
Fri 4th Dec 2026 – Sat 5th Dec 2026
⏱ 2 days 📍 Classroom
AcadNXT Classroom - San Francisco, California San Francisco United States
Fri 4th Dec 2026 – Sat 5th Dec 2026
⏱ 2 days 📍 Classroom
AcadNXT Classroom - Sharjah, UAE Sharjah United Arab Emirates
Mon 7th Dec 2026 – Tue 8th Dec 2026
⏱ 2 days 📍 Online Instructor-led
Wed 9th Dec 2026 – Thu 10th Dec 2026
⏱ 2 days 📍 Online Instructor-led
Thu 10th Dec 2026 – Fri 11th Dec 2026
⏱ 2 days 📍 Online Instructor-led
Fri 11th Dec 2026 – Sat 12th Dec 2026
⏱ 2 days 📍 Online Instructor-led
Sat 12th Dec 2026 – Sun 13th Dec 2026
⏱ 2 days 📍 Online Instructor-led
Wed 23rd Dec 2026 – Thu 24th Dec 2026
⏱ 2 days 📍 Online Instructor-led
Thu 24th Dec 2026 – Fri 25th Dec 2026
⏱ 2 days 📍 Online Instructor-led
Fri 25th Dec 2026 – Sat 26th Dec 2026
⏱ 2 days 📍 Online Instructor-led
Tue 29th Dec 2026 – Wed 30th Dec 2026
⏱ 2 days 📍 Online Instructor-led
Wed 30th Dec 2026 – Thu 31st Dec 2026
⏱ 2 days 📍 Online Instructor-led
No upcoming classes are currently available for this delivery mode.

Enroll Now

By submitting your details you agree to be contacted in order to respond to your enquiry.

Availability

Available global regions for this course

Browse the active regions where this course currently has scheduled delivery.

6 regions
Availability

Countries where this course is available

Browse all the countries currently offering scheduled delivery for this course.

6 countries