Home>
Courses>

Effective Data Manipulation with pandas

Effective Data Manipulation with pandas

Beginner

89 Lessons

24h

Certificate of Completion

AI-POWERED

Explanations

AI-POWERED

Explanations

This course includes

564 Playgrounds
17 Quizzes

This course includes

564 Playgrounds
17 Quizzes
Course Overview
What You'll Learn
Course Content

Course Overview

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 consid...Show More

What You'll Learn

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

What You'll Learn

An understanding of efficient data manipulation techniques for working with data in pandas

Show more

Course Content

1.

Introduction

Before We Start
Data Structures
Series IntroductionNaN Values in SeriesSimilarities in pandas and NumPyCategorical Data in pandasExercise: Series in pandasSolution: Series in pandasSummaryQuiz: pandas Series
2.

Series Deep Dive

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

Introduction to DataFramesSimilarities between Series and DataFrameMath Methods on DataFramesQuiz: DataFrames and Math Methods on DataFramesExercise: DataFrames in pandasSolution: DataFrames in pandasLooping and AggregationThe apply() MethodExercise: Looping, Aggregation and apply() MethodSolution: Looping, Aggregation, and apply() MethodColumns Types, .assign, and Memory UsageCreating and Updating ColumnsDealing with Missing and Duplicated DataQuiz: Missing and Duplicated DataSorting Columns and IndexesFiltering and Indexing OperationsIndexing by PositionIndexing by NameFiltering with Function and .locLine and Bar PlotsScatter, Area, and Stacked Bar PlotsExercise: Sorting, Columns, Filtering, and Indexing Operations.Solution: Sorting, Columns, Filtering, and Indexing OperationsExercise: PlottingSolution: PlottingQuiz: Sorting Columns, Filtering, and Indexing Operations.Reshaping DataFrames with DummiesReshaping by Pivoting and GroupingAggregations
4.

Manipulating Data

GroupingMore AggregationsCross-tabulation Deep DiveExercise: Reshaping/AggregationsSolution: Reshaping/AggregationsQuiz: Reshaping, Pivot Tables, AggregationsMelting and Transposing DataStacking and Flattening DataQuiz: Melting, Transposing, Stacking, and Unstacking DataWorking with Time SeriesAdding Rows and Columns in a DataFrameJoins in DataFramesJoining Real-World DatasetsQuiz: Joining in pandasExporting Data to CSV and ExcelExporting Data to Feather, SQL, and JSONStyling DataFramesChecking if DataFrames are EqualDebugging ChainsDebugging apply (and friends)Debugging Memory Usage and Timing Information
5.

Wrapping Up

Conclusion
6.

Appendix

1 Lesson

Trusted by 1.4 million developers working at companies

Anthony Walker

@_webarchitect_

Emma Bostian 🐞

@EmmaBostian

Evan Dunbar

ML Engineer

Carlos Matias La Borde

Software Developer

Souvik Kundu

Front-end Developer

Vinay Krishnaiah

Software Developer

Eric Downs

Musician/Entrepeneur

Kenan Eyvazov

DevOps Engineer

Souvik Kundu

Front-end Developer

Eric Downs

Musician/Entrepeneur

Anthony Walker

@_webarchitect_

Emma Bostian 🐞

@EmmaBostian

Hands-on Learning Powered by AI

See how Educative uses AI to make your learning more immersive than ever before.

Instant Code Feedback

Evaluate and debug your code with the click of a button. Get real-time feedback on test cases, including time and space complexity of your solutions.

AI-Powered Mock Interviews

Adaptive Learning

Explain with AI

AI Code Mentor

FOR TEAMS

Interested in this course for your business or team?

Unlock this course (and 1,000+ more) for your entire org with DevPath