HomeCoursesMastering Data Analysis with Python Pandas

Beginner

2h 25min

Updated 1 month ago

Mastering Data Analysis with Python Pandas
Save

Gain insights into using Python Pandas for efficient data analysis and manipulation. Delve into detailed functions, parameters, and methods to elevate your data handling skills.

Join 2.7 million developers at

Overview

Content

Reviews

There are several exercises that focus on how to use a particular function and method. The functions are covered in detail by explaining the important parameters and how to use them. By completing this course, you will be able to do data analysis and manipulation with Pandas easily and efficiently.

There are several exercises that focus on how to use a particular function and method. The functions are covered in detail by ex...Show More

WHAT YOU'LL LEARN

Hands-on experience with Python Pandas

Learn about data analysis and manipulation functions of Python Pandas

Hands-on experience with Python Pandas

Content

56 Lessons10 Quizzes9 Challenges

Course Introduction

2 Lessons

Get familiar with mastering data analysis using Python Pandas for data cleaning and insights.

Why Should You Take This Course?

What Will You Achieve by Completing This Course?

Pandas Data Structures

2 Lessons

Walk through Pandas Series and DataFrame to efficiently manage and analyze data.

Pandas Series

Pandas DataFrame

Creating a Data Frame

2 Lessons

Go hands-on with creating and reading DataFrames from files and various data structures in Pandas.

Reading Data from a File

Create a DataFrame

Exploring a Data Frame

6 Lessons

Grasp the fundamentals of analyzing a DataFrame's size, data types, values, and central tendency.

Size of a DataFrame

Data Types of Columns

Different Values in a Column

Measures of Central Tendency

Challenge: Find the Most Frequent Values in a Column

Quiz Yourself: Exploring a DataFrame

Filtering a Data Frame

7 Lessons

Map out the steps for effective DataFrame filtering using various methods and techniques.

Why Do We Need Filtering?

Filtering with "loc" and "iloc" Methods

Filtering by Selecting a Subset of Columns

Filtering by Condition

Filtering Rows with the Query Function

Challenge: Filter Out the Values Below Average

Quiz Yourself: Filtering a DataFrame

String Manipulation with Pandas

8 Lessons

Follow the process of mastering string manipulation techniques in Pandas, enhancing data analysis skills.

Slicing and Indexing on Strings

Splitting and Combining Strings

Converting Strings to Upper and Lower Case

Challenge: Create City and State Columns from the Address

Replacing Characters in a String

Chained Operations

Challenge: Make the Salary Column Proper

Quiz Yourself: String Manipulation with Pandas

Date Manipulation with Pandas

6 Lessons

Master the steps to manipulate and extract date and time information using Pandas.

Pandas Date and Time Data Types

Extracting Information from Dates

The dt Accessor

Manipulating Dates by Adding Time Intervals

Challenge: The Age of Employees

Quiz Yourself: Date Manipulation

Handling Missing Values with Pandas

6 Lessons

Learn how to use Pandas functions to effectively handle missing values in data.

Missing Value Types and Representation

Finding the Missing Values

Dropping Rows and Columns with Missing Values

Replacing the Missing Values

Challenge: Filling the Missing Values

Quiz Yourself: Handling Missing Values

Data Analysis with Pandas

8 Lessons

Get started with advanced data analysis in Pandas using groupby, pivot tables, cut, and where functions.

The groupby Function

Enhancing the groupby Function

Challenge: Find the Weekly Sales Quantities

The Pivot Table Function

The Cut and Qcut Functions

Challenge: Categorize Groceries Based on Price

The "where" Function

Quiz Yourself: Data Analysis with Pandas

10.

Data Visualization with Pandas

4 Lessons

Work your way through visualizing data distributions, trends, and relationships using Pandas plots.

Histogram

Line Plot

Scatter Plot

Quiz Yourself: Data Visualization with Pandas

11.

Combining DataFrames with Pandas

3 Lessons

Grasp the fundamentals of combining DataFrames using concat and merge functions in Pandas.

The Concat Function

The Merge Function

Quiz Yourself: Combining DataFrames with Pandas

Data Visualization with Seaborn for Walmart Sales Projection

Project

12.

Final Challenge and Quiz

2 Lessons

Solve problems in analyzing sales data, handling missing values, and computing average sales.

Final Challenge: Find the Day of Week with the Most Sales

Final Quiz

Certificate of Completion

Showcase your accomplishment by sharing your certificate of completion.

Course Author:

Soner Yildirim

Developed by MAANG Engineers

Every Educative resource is designed by our team of ex-MAANG software engineers and PhD computer science educators — subject matter experts who’ve shipped production code at scale and taught the theory behind it. The goal is to get you hands-on with the skills you need to stay ahead in today's constantly evolving tech landscape. No videos, no fluff — just interactive, project-based learning with personalized feedback that adapts to your goals and experience.

Trusted by 2.7 million developers working at companies

"These are high-quality courses. Trust me. I own around 10 and the price is worth it for the content quality. EducativeInc came at the right time in my career. I'm understanding topics better than with any book or online video tutorial I've done. Truly made for developers. Thanks"

Anthony Walker

@_webarchitect_

"Just finished my first full #ML course: Machine learning for Software Engineers from Educative, Inc. ... Highly recommend!"

Evan Dunbar

ML Engineer

"You guys are the gold standard of crash-courses... Narrow enough that it doesn't need years of study or a full blown book to get the gist, but broad enough that an afternoon of Googling doesn't cut it."

Software Developer

Carlos Matias La Borde

"I spend my days and nights on Educative. It is indispensable. It is such a unique and reader-friendly site"

Souvik Kundu

Front-end Developer

"Your courses are simply awesome, the depth they go into and the breadth of coverage is so good that I don't have to refer to 10 different websites looking for interview topics and content."

Vinay Krishnaiah

Software Developer

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 Mock Interviews

Test your skills in a simulated interview setting. Receive personalized feedback based on your performance. Available for Coding Interviews, System Design, and more.

Adaptive Learning

At various checkpoints throughout Educative courses, you will be prompted to take a quick assessment. Receive a condensed curriculum tailored to your strengths and skill gaps.

Explain with AI

Select any text within any Educative course, and get an instant explanation — without ever leaving your browser.

AI Code Mentor

AI Code Mentor helps you quickly identify errors in your code, learn from your mistakes, and nudge you in the right direction — just like a 1:1 tutor!

Free Resources

FOR TEAMS

Interested in this course for your business or team?

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

Mastering Data Analysis with Python Pandas Save

Mastering Data Analysis with Python Pandas
Save