Home>Courses>Mastering Data Analysis with Python Pandas

Mastering Data Analysis with Python Pandas

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.

Beginner

56 Lessons

2h 25min

Certificate of Completion

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.

AI-POWERED

Explanations

AI-POWERED

Explanations

This course includes

103 Playgrounds

9 Challenges

9 Quizzes

Course Overview

What You'll Learn

Course Content

Apply Your Skills

Course Overview

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

Course Content

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

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

Course Author

Soner Yildirim

Project

Data Analysis and Visualization with sidetable and Bokeh

beginner

1 hour

Project

Data Analysis and Visualization with sidetable and Bokeh

Learn data analysis using sidetable and visualize results with Bokeh for effective decision-making.

beginner

1 hour

Project

Visualize Geospatial Data Using Folium

intermediate

1 hour

Project

Visualize Geospatial Data Using Folium

Learn to create and customize interactive maps using Folium, including markers, heat maps, and clustering for clear geospatial data visualization.

intermediate

1 hour

Trusted by 2.5 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."

Carlos Matias La Borde

Software Developer

"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

"I've tried probably 5-7 different sites and Educative is easily the best. It perfectly blends explanation with interactivity"

Eric Downs

Musician/Entrepeneur

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

Put your skills to the test in a simulated interview setting. Receive personalized feedback based on your performance. Available in Premium & Premium Plus plans.

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