Mini Map
Search
⌘ K
AI Features
Log In
Mastering Data Analysis with Python Pandas
1.
Course Introduction
Why Should You Take This Course?
What Will You Achieve by Completing This Course?
2.
Pandas Data Structures
Pandas Series
Pandas DataFrame
3.
Creating a Data Frame
Reading Data from a File
Create a DataFrame
4.
Exploring a Data Frame
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
5.
Filtering a Data Frame
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
6.
String Manipulation with Pandas
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
7.
Date Manipulation with 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
8.
Handling Missing Values with Pandas
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
9.
Data Analysis with Pandas
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
Histogram
Line Plot
Scatter Plot
Quiz Yourself: Data Visualization with Pandas
11.
Combining DataFrames with Pandas
The Concat Function
The Merge Function
Quiz Yourself: Combining DataFrames with Pandas
Project
Premium
Data Visualization with Seaborn for Walmart Sales Projection
12.
Final Challenge and Quiz
Final Challenge: Find the Day of Week with the Most Sales
Final Quiz
Mock Interview
Premium
Movie Recommendation System