Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Data Wrangling Bootcamp: Turn Alien Data into AI
Section 01: Introduction
Introduction (4:20)
Exercise: Meet Your Classmates and Instructor
Understanding Your Video Player
Course Resources
Set Your Learning Streak Goal
Section 02: Data Wrangling 101
Introduction to Data Wrangling (5:52)
Our Data Wrangling Framework (4:55)
The Importance of Exploratory Data Analysis (EDA) (5:18)
A Note to Students - PLEASE READ
Section 03: Programming Basics for Data Wrangling
What is Programming? (6:28)
The Programming Environment (13:22)
Disabling Colab's AI Tools (5:08)
Values and Types (8:20)
Functions (10:17)
Expressions (10:04)
Expressions in COLAB (5:03)
Variables (13:29)
Naming Variables (6:19)
Exercises - Part 1
Errors (6:43)
Comments (5:39)
Text Cells (20:46)
Colab Tips and Tricks (14:45)
Objects, Attributes, and Methods (9:13)
Using Python Modules (12:17)
Lists (12:07)
Tuples (9:21)
Dictionaries (17:41)
Exercises - Part 2
Let's Have Some Fun (+ More Resources)
Section 04: DataFrames and Datasets
IMPORTANT - DOWNLOAD EXAMPLE DATASETS
Introducing DataFrames (10:47)
Introducing Our Datasets (2:39)
'read_csv' and DataFrames - Part 1 (10:48)
'read_csv' and DataFrames - Part 2 (4:35)
Providing Column Names (5:57)
Inspecting DataFrames (7:59)
The 'info' Method (11:16)
Renaming Columns (7:14)
Dropping Columns (7:00)
Selecting Columns (4:25)
Exercises
Course Check-In
Section 05: Series
Series 101 (9:13)
Converting Series with to_numeric (10:57)
Converting Series with to_datetime (6:08)
Adding Columns (Series) to DataFrames (10:04)
Creating Derived Columns (16:21)
The 'assign' Method (12:40)
Exercises
Unlimited Updates
Section 06: Exploratory Data Analysis with Pandas
The 'sum' Method (12:50)
The 'count' Method (10:26)
Mean and Median (12:40)
The 'describe' Method (12:38)
The 'describe' Method (12:38)
Using 'describe' on Non-Numeric Fields (11:01)
The 'unique' and 'nunique' Methods (10:36)
The 'value_counts' Method (6:49)
Exercises
Implement a New Life System
Section 07: AI Tools in Colab
AI Tools in Colab - Overview (2:47)
Enabling AI Tools in Colab (3:29)
In-Cell Gemini AI - Part 1 (9:32)
In-Cell Gemini AI - Part 2 (12:05)
AI-Powered Code Completion (11:01)
The Data Science Agent (DSA) (15:14)
DSA Demos (12:58)
Prompting Best Practices (6:07)
Global Superstore Data Wrangling Project: Introduction (2:01)
Global Superstore Data Wrangling Project: Solution (16:41)
Exercise: Imposter Syndrome (2:55)
Section 08: Data Wrangling Project - Phase 1
Data Wrangling Project - Phase 1 Introduction (4:45)
Data Wrangling Project - Phase 1 Requirements
Data Wrangling Project - Phase 1 Solution (6:59)
Section 09: Indexing and Sorting
The 'iloc' Method (14:42)
Indexing Basics (14:01)
The 'loc' Method (6:48)
Sorting by Index (11:36)
Sorting by Columns (16:04)
Dropping Rows by Index (9:39)
Exercises
Section 10: Selecting Data with Criteria
Filtering DataFrames with a Boolean Series (11:49)
Applying Other Logical Conditions (11:34)
The 'between' and 'isin' Methods (11:54)
Combining Conditions Using the AND Operator (18:50)
Combining Conditions Using the OR Operator (6:07)
Combining AND and OR (18:41)
Negation (11:26)
The 'isna' Method (16:22)
Exercises
Section 11: Updating DataFrames
Updating DataFrame Values with loc (9:24)
Replacing DataFrame Values (10:04)
Updating Values with Boolean Masks (15:49)
Removing Null Values (14:53)
Replacing Null Values (9:51)
Identifying Duplicate Data (9:29)
Removing Duplicate Data (11:03)
Exercises
Section 12: Working with String Data
The 'upper', 'lower', and 'capitalize' Methods (7:53)
The 'len' Method (4:19)
Regular Expressions (15:07)
Matching Digits (6:53)
The 'contains' Method (14:17)
The 'replace' Method - Part 1 (8:30)
The 'replace' Method - Part 2 (8:13)
Exercises
Section 13: Data Wrangling Project - Phase 2
Data Wrangling Project - Phase 2 Introduction (3:37)
Data Wrangling Project - Phase 2 Requirements
Data Wrangling Project - Phase 2 Solution (11:58)
Section 14: Combining Datasets
Stacking Datasets Vertically - Part 1 (11:20)
Stacking Datasets Vertically - Part 2 (9:07)
Importing All Excel Sheets Into a DataFrame (10:32)
Joining DataFrames with 'merge' - Part 1 (10:26)
Joining DataFrames with 'merge' - Part 2 (8:53)
Left and Right Joins (12:54)
Full Outer Joins (7:52)
Combining More Than Two Tables (11:03)
Exercises
Section 15: Data Wrangling Project - Phase 3
Data Wrangling Project - Phase 3 Introduction (4:25)
Data Wrangling Project - Phase 3 Requirements
Data Wrangling Project - Phase 3 Solution (8:46)
Section 16: Grouping and Aggregation
Grouping and Aggregating 101 (15:40)
Applying Multiple Aggregations (14:33)
Grouping by Multiple Columns (9:05)
The 'transform' Method (15:22)
Pythonic Pivot Tables (14:22)
Exercises
Section 17: Working with Datetime Data
Using Datetime Values as Criteria (15:00)
The 'datetime' Module - Part 1 (10:29)
The 'datetime' Module - Part 2 (8:51)
Date Math in Pandas (15:10)
The 'shift' Method - Part 1 (12:55)
The 'shift' Method - Part 2 (10:19)
Rolling Averages (14:03)
Getting Data Out of Colab (7:51)
Exercises
Section 18: Data Wrangling Project - Phase 4
Data Wrangling Project - Phase 4 Introduction (4:19)
Data Wrangling Project - Phase 4 Requirements
Data Wrangling Project - Phase 4 Solution (9:34)
Section 19: Functional Programming in Python
Note to Students - PLEASE READ
Apply-ing Functions to Data Analysis (4:39)
If Statements (10:43)
Applying Multiple Logical Conditions (11:27)
Incorporating "And" and "Or" Logic (13:32)
Creating Custom Functions (10:17)
Returning Values From Functions - Part 1 (8:30)
Returning Values From Functions - Part 2 (8:51)
Exercises
Section 20: Leveraging the 'map' and 'apply' Methods
The 'map' Method (10:38)
Using 'map' with Functions - Part 1 (9:35)
Using 'map' with Functions - Part 2 (10:47)
The 'apply' Method (10:11)
Applying 'apply' to Multiple Columns (7:15)
Exercises
Section 21: Feature Engineering & Preprocessing for Machine Learning
Introducing Machine Learning (5:15)
From Data to Predictions (10:18)
Data Cleaning for Machine Learning (15:28)
Encoding Categorical Data (12:15)
Training Your First Machine Learning Model (14:18)
Improving Model Accuracy with 'get_dummies' (9:11)
Feature Engineering for Machine Learning (13:02)
Section 22: Data Wrangling Project - Phase 5
Data Wrangling Project - Phase 5 Introduction (5:29)
Data Wrangling Project - Phase 5 Requirements
Data Wrangling Project - Phase 5 Solution (14:27)
Section 23: BONUS PROJECT - Fine-Tune a Transformer Model
From Tables to Text (8:34)
Fine-Tuning Transformers (9:40)
Data Wrangling for Transfomers - Project Introduction (9:41)
Data Wrangling for Transfomers - Project Requirements
Data Wrangling for Transformers - Project Solution (8:48)
Creating the Label Column (7:33)
Setting Up the Training (12:00)
Training and Testing (11:40)
Deploying with Gradio (17:12)
Section 24: Python In Excel
Introducing Python in Excel (7:05)
READ THIS: Do You Have Python in Excel?
Sharing Python-Powered Excel Workbooks
Working with Values and Cells (15:12)
Working with Ranges and Tables (16:22)
Row-Major Order - Part 1 (11:41)
Row-Major Order - Part 2 (10:29)
Separation of Concerns (9:09)
Adding Dynamic Inputs (9:55)
Incorporating Power Query (19:09)
Incorporating AI Tools (9:14)
The Python Editor (9:09)
Machine Learning Demo - Part 1 (12:52)
Machine Learning Demo - Part 2 (6:36)
Data Visualization Demo - Part 1 (13:56)
Data Visualization Demo - Part 2 (10:57)
Sentiment Analysis Project: Introduction (5:53)
Sentiment Analysis Project: Solution (17:33)
Where To Go From Here?
Thank You! (1:17)
Review This Course!
Become An Alumni
Learning Guideline
ZTM Events Every Month
LinkedIn Endorsements
Combining More Than Two Tables
This lecture is available exclusively for ZTM Academy members.
If you're already a member,
you'll need to login
.
Join ZTM To Unlock All Lectures