AI-powered learning
Save this course
Effective Data Manipulation with pandas
Learn effective data manipulation with pandas. Discover filtering, merging, grouping, and reshaping techniques through hands-on examples, best practices, and performance tips for real-world analysis.
4.8
89 Lessons
24h
Updated 4 months ago
Join 2.9 million developers at
Join 2.9 million developers at
LEARNING OBJECTIVES
- An understanding of efficient data manipulation techniques for working with data in pandas
- Working knowledge of different techniques for handling missing data in pandas
- The ability to reshape and pivot data
- Hands-on experience of the best practices for working with pandas
Learning Roadmap
1.
Introduction
Introduction
Get familiar with pandas data structures for efficient data manipulation in Python.
2.
Series Deep Dive
Series Deep Dive
Unpack the core of pandas Series manipulation, covering attributes, operations, and data cleaning.
Data Loading and Series AttributesOperators and Dunder MethodsAggregate MethodsExercise: Aggregate MethodsSolution: Aggregate MethodsConversion MethodsManipulation MethodsQuiz: Methods in SeriesConditional MethodsHandling Missing DataOther Manipulation MethodsData CleaningQuiz: Duplicate values and NaNIndexing OperationsIndexing Operations (.iloc)Exercise: Data Manipulation and IndexingSolution: Data Manipulation and IndexingQuiz: Indexing, Manipulation Methods, and Data CleaningString ManipulationOptimizing Manipulations Using CythonDate and Time ManipulationDates in the IndexQuiz: String Manipulation, Date-Time Manipulation, and DT IndexingPlotting with a Series: Histogram, Box Plot, and Kernel DensityPlotting with a Series: Line, Bar, and Pie PlotsCategorical ManipulationQuiz: Plotting and Categorical Data
3.
DataFrames
DataFrames
29 Lessons
29 Lessons
Examine building, manipulating, and visualizing DataFrames in pandas for effective data analysis.
4.
Manipulating Data
Manipulating Data
21 Lessons
21 Lessons
Grasp the fundamentals of manipulating and reshaping data, handling time series, joins, and exporting formats.
Certificate of Completion
Showcase your accomplishment by sharing your certificate of completion.
Complete more lessons to unlock your certificate
Developed by MAANG Engineers
ABOUT THIS COURSE
The course is a comprehensive guide to using pandas for data analysis. It covers a wide range of topics related to data manipulation, including filtering, merging, grouping, pivoting, and reshaping data.
In this course, you’ll learn about the best practices and efficient techniques for working with data. You’ll be provided with numerous examples of real-world data analysis problems and gain hands-on experience with the pandas library to solve them effectively. This course will also cover performance considerations and provide insights on common pitfalls to avoid when using pandas.
The course is suitable for both beginners and experienced users of pandas. It includes detailed explanations of pandas concepts and functions, as well as tips and tricks for optimizing your code. By the time you’re done with this course, you’ll be able to effectively handle data using pandas.
Trusted by 2.9 million developers working at companies
A
Anthony Walker
@_webarchitect_
E
Evan Dunbar
ML Engineer
S
Software Developer
Carlos Matias La Borde
S
Souvik Kundu
Front-end Developer
V
Vinay Krishnaiah
Software Developer
Built for 10x Developers
No Passive Learning
Learn by building with project-based lessons and in-browser code editor


Personalized Roadmaps
The platform adapts to your strengths & skills gaps as you go


Future-proof Your Career
Get hands-on with in-demand skills


AI Code Mentor
Write better code with AI feedback, smart debugging, and "Ask AI"




MAANG+ Interview Prep
AI Mock Interviews simulate every technical loop at top companies


Free Resources