Log In
0% completed
All Lessons
Free Lessons (3)
Before We Begin
Course Introduction
Reading Data into pandas
Importance of Data Ingestion
Read Data from the Web
Read Data from HTML Files
Read Data from XML Files
Read Data from Statistical Software Files
Read Data from SQL Databases
Read Data from Binary Files (Feather, HDF5, ORC, Parquet)
Quiz
Combining Data
Importance of Combining Data
Concatenate
Merging—Types of Joins
Merge 2—Implementation
Merging—Scenarios
Combine and Update
Quiz
Reshaping and Manipulating Data
Importance of Reshaping and Manipulating Data
GroupBy—The groupby() method
GroupBy—Aggregate
GroupBy—Transform and Filter
GroupBy—Further Useful Features
Pivot—Long and Wide Formats
Pivot—The pivot() method
Unpivot
Stack and Unstack
Further Reshaping Capabilities
Advanced Indexing 1
Advanced Indexing 2
Quiz
Encoding Data Types
Inspect Data Types
Convert and Encode Data Types
Handling Numerical Data
Arithmetic Operations 1
Arithmetic Operations 2
Comparison Operations
Filtering
Ordered Numerical Data
Discretize and Clip Data
Statistical Methods
Cumulative Operations
Apply Custom Functions
Quiz
Handling Categorical Data
Encode Categorical Data
Modify Categorical Data
Comparison and Other Common Operations
Factorize and Cross-Tabulate
Other Features and Properties
Quiz
Handling Text Data
Text Data Types
String Methods—Basic Transformations and Checks
String Methods—Slice, Split, and Partition
String Methods—Concatenate and Match
String Methods—Find, Extract, and Replace
String Methods—Leading and Trailing Characters
Quiz
Handling Time Series Data
Time Series Data Types
Time Series Indexes—Creating Indexes
Time Series Indexes—Slice and Index
Time Series Indexes—Attributes
Time Series Indexes—Methods
Arithmetic Operations with Timedelta and DateOffset
Closer Look at Time Deltas
Business Dates and Holidays
Business Hours
Time Zones
Timeseries Merging
Resampling—Upsample and Downsample
Resampling—Aggregation and Other Parameters
Shifting and Frequency Conversion
Window Operations—Rolling
Window Operations—Weighted, Expanding, and Exponential Moving
Quiz
Handling Sparse Data Structures
Sparse Arrays
Accessors and Operations
Handling Missing Data
Missing Data Representation
Missing Data Detection and Calculations
Managing Missing Data
Quiz
Project
Data Analysis and Visualization with sidetable and Bokeh
Leveraging Further Features of pandas
Function Chaining with pipe()
Assertion Functions
DataFrame Table Styles
Option Settings
Efficiency Boosts
Quiz
Utilizing Extended Libraries
ydata-profiling
pandarallel
polars
pandasAI
Quiz
Wrap Up
Conclusion
Appendix
What's New in pandas 2.0
Setup Requirements
Overview of Statistical Software and Binary File Formats
Prerequisite Setup for Reading Data into pandas
Prerequisite Setup for Utilizing Extended Libraries
Project
Time Series Analysis and Visualization Using Python and Plotly
Advanced pandas—Going Beyond the Basics
/
...
/
Quiz
Quiz
Check your understanding of different data types that can be imported into pandas.
We'll cover the following...
...