Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Data Science Bootcamp 12
Welcome to the course!
Warm Welcome
⚡ Thor is Coming
School Philosophy - Becoming Generalist
How to attend LIVE classes
How to study on-demand videos 🍟
Free Pre-Sessional Course
Free Software
README - Data Analyst Career Guide
README - Data Science Free Learning Path
Kata - Monkeytype
Believe Then Act
Join Our Discord 🍻
Quiz - School Philosophy
Community
Meet Your Friends
Live Classes Are Here! 📢
💯 How to Use Our School [Must-Watch] (2:07)
Main Live Classes
🌵 Sprint Homework
Bonus Classes Are Here! 📢
Bonus Live Classes
Building A Second Brain
New Content Update (2023)
What is Second Brain?
Notion is evolving over time
How to use Notion 101 (66:01)
Intro to Notion Database [Old] (4:52)
Intro to Notion Database [New] (2:39)
Other Note-Taking Software
Quiz - Building A Second Brain
Notion Primer
💯 New Content Alert (0:25)
EP01 - Getting Started with Notion (1:38)
EP02 - Template (1:48)
No Workspaces, No Worries
EP03 - Your First Notion Page (3:37)
EP04 - Common Blocks (3:28)
EP05 - Quick Setting (2:43)
EP06 - Design Structure (3:07)
EP07 - What is Notion Database? (2:41)
EP08 - Work Like Spreadsheets, But Cooler! (2:19)
EP09 - Database View (2:13)
EP10 - Sharing (2:00)
Quiz - Notion Primer
📝 What Would You Like to Build?
Sprint 01 - Google Sheets 101
Exercise File
EP01 - Why Google Sheets (2:12)
EP02 - Manually Input Data (6:01)
EP03 - Cell References (3:03)
EP04 - What is Function? (3:22)
📑 Google Sheets Shortcuts
EP05 - If and Array (3:42)
EP06 - Nested IF and IFS (4:28)
EP07 - AND OR NOT (3:52)
EP08 - SWITCH (2:56)
EP09 - AVERAGE SUM MEDIAN (5:37)
EP10 - AVERAGEIF and SUMIF (3:30)
Quiz - Google Sheets 101
Sprint 01 - Google Sheets 102
Exercise File
EP01 - Import Data (6:08)
EP02 - COUNTIFS (4:52)
EP03 - SUMIFS (3:22)
EP04 - Filter (5:29)
EP05 - Sort Sheets (4:12)
EP06 - VLOOKUP (6:34)
EP07 - VLOOKUP Part 2 (3:27)
EP08 - Index and Match (7:10)
EP09 - DATE (4:54)
EP10 - DATEDIF (3:40)
Quiz - Google Sheets 102
Sprint 01 - Google Sheets 103
Exercise File
EP01 - Query Functions (4:03)
EP02 - Select Data (4:37)
EP03 - Filter Data (4:45)
EP04 - Filter NULL (1:55)
📑 How to filter DATE
EP05 - Aggregate Functions (1:54)
EP06 - Group By (2:30)
EP07 - Label (3:13)
EP08 - Pivot (2:24)
EP09 - Order By (2:44)
Review Core Concepts in Google Sheets
🌵 New - How to Create Drop Down List (2023) (1:00)
EP10 - Dynamic Query (5:10)
Then, What SQL Looks Like?
🌭 Secret Sauce - How to Get Better at Google Sheets
Quiz - QUERY Function
Sprint 01 - Google Sheets 104
Exercise File
📑 Pivot Table Formula
Intro to Pivot Table (Google Sheets) (73:35)
🅱️ Transfer Knowledge to Microsoft Excel
Sprint 02 - SQL References
Code for SQL Classes
W3schools SQL References
SQLite Online Editor
How to save result from SQLiteOnline
Mini Quiz - Warm Up SQL
Sprint 02 - Intro to Database and CRUD
EP01 - SQLite Online Editor (3:36)
EP02 - Create Table (2:37)
EP03 - Insert Data (2:28)
📑 Common SQL Errors
EP04 - Select Data (1:35)
EP05 - Transform Columns (2:51)
EP06 - Filter Data (5:19)
EP07 - Update Data (1:57)
EP08 - Delete Data (1:41)
EP09 - Alter Table (3:21)
EP10 - Copy and Drop Table (2:52)
Sprint 02 - SQL for Data Analyst 101
Download Database and ER Diagram
EP01 - Database and ER Diagram (7:13)
EP02 - DB Browser Installation (Optional) (6:01)
EP03 - Select Columns (2:20)
EP04 - Create New Columns (6:54)
EP05 - CASE WHEN (2:29)
EP06 - Working with DateTime in SQLite (5:29)
EP07 - Select Data From Multiple Tables (3:05)
EP08 - INNER vs. LEFT JOIN (3:46)
EP09 - More JOIN Examples (4:35)
EP10 - Random Rows (3:06)
Sprint 02 - SQL for Data Analyst 102
📑 How to use WHERE clause?
EP01 - Filter Data Part 1 (6:52)
EP02 - Filter Data Part 2 (6:33)
EP03 - Filter Data Part 3 (4:50)
EP04 - COALESCE (4:37)
EP05 - JOIN Data using WHERE (6:44)
EP06 - Aggregate Functions (3:32)
EP07 - COUNT Distinct (1:19)
EP08 - GROUP BY (3:41)
EP09 - HAVING (1:49)
EP10 - ORDER BY (3:13)
Sprint 02 - SQL for Data Analyst 103
EP01 - JOIN using WHERE clause (6:59)
EP02 - Convert WHERE to INNER JOIN (2:48)
EP03 - Review JOIN Concepts (3:39)
EP04 - Review CREATE TABLE (2:20)
EP05 - INNER vs. LEFT JOIN (2:40)
EP06 - CROSS JOIN (3:13)
EP07 - SELF JOIN (5:14)
EP08 - Intersect and Except (2:57)
EP09 - UNION (2:55)
EP10 - Intro to Subqueries (4:55)
SQL Workshops (Optional)
SQL Workshop Part 1 (73:26)
SQL Workshop Part 2 (73:21)
Coming Soon
You are awesome!
Sprint 03 - R101 / Getting Started with R
Meet RStudio Cloud
Quiz - Have You Tried RStudio Cloud
EP01 - Download and Install Software (3:36)
📑 How to use setwd() on RStudio Cloud (0:23)
EP02 - Create and Remove Variables (7:41)
EP03 - Compare Values (2:23)
EP04 - Data Types (7:37)
Quiz - Data Types
EP05 - Convert Data Types (2:28)
EP06 - Vector (4:44)
EP07 - Matrix (3:24)
EP08 - List (2:27)
EP09 - Data Frame (3:33)
Quiz - Data Frame
EP10 - Subset (7:15)
We're NOT done yet!
Sprint 03 - R102 / Control Flow and Function
📑 Common Errors in RStudio
What is control flow?
Quiz - Control Flow
EP01 - IF (4:29)
EP02 - ifelse() (2:16)
EP03 - FOR (4:31)
EP04 - WHILE (2:20)
EP05 - Function (1:44)
EP06 - Create Our First Function (3:19)
Quiz - Function
EP07 - Function Parameter & Argument (3:22)
EP08 - Function Kata (5:10)
EP09 - Looping over a dataframe (7:06)
EP10 - apply() coolest function (3:06)
Quiz - Loop and Apply
📑 Reading - Hands On Programming with R
Sprint 03 - R103 / Working with Data
💯 R superpower!
📝 Upload File
📑 How to install R packages (3:21)
EP01 - Text File (3:58)
EP02 - CSV (2:10)
EP03 - Excel File (4:42)
Quiz - Read Data
EP04 - Google Sheets (1:59)
EP05 - JSON (3:26)
Quiz - Google Sheets & JSON
EP06 - Bind Rows (UNION ALL) (2:30)
EP07 - Bind Cols (!= JOIN) (2:05)
📑 We will learn about JOIN in the next sprint
Quiz - Bind Rows & Columns
EP08 - SQL (4:27)
EP09 - SQLite (4:23)
EP10 - How to save data in R (2:18)
⭐ Now you are a Data Analyst Star [Lord]!
📝 README - Regular Expression
EP01 - What is Regular Expression?
EP02 - Basic Regular Expression
EP03 - How to write RE in Google Sheets?
EP04 - Extract Text using RE
EP05 - Regular Expression for Thai Language
Sprint 04 - Data Transformation
⭐ The Most Important Skill
EP01 - Intro to Data Transformation (3:27)
EP02 - Read CSV Files (7:26)
EP03 - Select Columns (5:33)
EP04 - Filter Data Part I (7:52)
EP05 - Filter Data Part II (5:10)
Quiz - Basic Transformation I
EP06 - Create New Colunms (4:18)
EP07 - Arrange Data (2:28)
EP08 - Summary Statistics (3:45)
EP09 - Join Tables (2:49)
Quiz - Basic Transformation II
EP10 - Export CSV File (2:34)
Quiz - Based vs. Modern R Functions
📑 Reading - R for Data Science Chapter 5
Sprint 04 - Data Transformation (Intermediate)
📑 Let's continue
EP01 - Tibble (2:40)
EP02 - Sample Data (2:29)
EP03 - Slice (2:09)
Quiz - Tibble
📢 More EP Coming Soon
Sprint 04 - Windows Terminal (Optional)
EP01 - Windows Terminal (2:28)
EP02 - Echo (Print Text) (3:00)
EP03 - Quick Start (3:27)
EP04 - Change Directory (1:56)
EP05 - Create Text File (4:13)
EP06 - Delete Files and Folders (4:57)
EP07 - Rename Files (1:38)
EP08 - Find String (3:12)
EP09 - Download Data with Curl (3:54)
EP10 - Ping (2:27)
EP11 - Move Files (3:13)
EP12 - Install WSL (3:10)
EP13 - Nano Editor (3:16)
EP14 - Intro to Ubuntu Command Line (3:33)
EP15 - Run Python Script (3:25)
EP16 - Free REPL Online (3:50)
Sprint 05 - Intro to Data Visualization
🌭 Secret Sauce - How to get better at programming
Exercise File
Data Visualization in Google Sheets (75:11)
Data Visualization in R (89:56)
📑 Data Visualization in R Cheat Sheet
Sprint 05 - Data Visualization in Excel
Exercise File
EP01 - Sparklines (3:27)
EP02 - Histogram (2:21)
EP03 - Boxplot (3:40)
EP04 - Bar (2:37)
EP05 - Line (2:29)
EP06 - Pie (1:45)
EP07 - Scatter (2:05)
EP08 - Stacked Bar (2:03)
EP09 - Summary Bar (2:10)
EP10 - Pareto (3:03)
EP11 - Waterfall (2:21)
EP12 - Treemap (2:18)
EP13 - Bubble (1:50)
EP14 - Bing Maps (2:11)
EP15 - Pivot Chart (3:53)
Sprint 06 - STAT101 / Intro to Statistics
📑 Read Me First
EP01 - Intro to Statistics (110:36)
EP02 - Intro to AB Testing (105:08)
Correlation and Regression for Beginners
EP03 - Correlation and Linear Regression (175:06)
EP04 - Logistic Regression (112:29)
Sprint 06 - STAT102 / Descriptive Statistics
Coming Soon
Sprint 07 - Essential ML 101
Download Lecture Slide
What we are going to learn! (1:34)
EP01 - What is ML (5:16)
EP02 - Model = Algorithm + Data (3:15)
Quiz - Model vs. Algorithm
EP03 - Types of ML (1:19)
EP04 - Supervised Learning (2:47)
EP05 - Unsupervised Learning (3:06)
Quiz - Types of ML
EP06 - Reinforcement Learning (2:14)
EP07 - Basic ML Workflow (3:20)
EP08 - Regression Example (9:27)
📑 How to train model using caret
EP09 - Classification Example (1:53)
EP10 - Course Summary (1:31)
Quiz - Basic ML Workflow
Sprint 07 - Essential ML 102
📑 New Way of Teaching | Learn Faster
Quiz - Reading vs. Speaking
📑 Review - What is Algorithm?
Coming Soon
EP01 - The Ultimate Goal of Model
EP02 - Regularization
Quiz - Overfitting
EP03 - Revisit Linear Regression
EP04 - Ridge & Lasso Regression
📑 Optional Reading - Ridge & Lasso Explained by DataCamp
Quiz - Ridge vs. Lasso
Sprint 08 - Intro to Python
Download Slide
Download Code
EP01 - Intro (2:18)
EP02 - DataFrame (2:09)
EP03 - DataLore (3:12)
EP04 - Variable (3:29)
EP05 - String (3:12)
EP06 - String Methods (2:58)
EP07 - List (3:38)
EP08 - Dictionary (4:36)
EP09 - Function (3:38)
EP10 - OOP (6:07)
Sprint 09 - Essential Python for Data Science
Download Files
📑 Pandas Documentation
EP11 - Intro to Pandas 🐼 (1:51)
EP12 - Create DataFrame (2:25)
EP13 - Add a new column (1:40)
EP14 - Drop column (3:19)
EP15 - Rename columns (1:39)
EP16 - Series vs DataFrame (4:36)
EP17 - Write CSV file (1:29)
EP18 - Upload data to datalore (1:46)
EP19 - Read Excel data (2:10)
EP20 - JSON (2:39)
Sprint 09 - Intermediate Pandas I
EP21 - Preview penguins dataframe (4:05)
EP22 - Select columns (1:28)
EP23 -iloc (2:40)
EP24 - Filter dataframe with one condition (2:23)
EP25 - Filter dataframe more than one condition (2:08)
EP26 - Query (1:53)
EP27 - Missing Values (2:53)
EP28 - Fill missing values (2:34)
EP29 - Sort dataframe (3:05)
EP30 - Unique and Count (3:05)
Sprint 09 - Intermediate Pandas II
EP31 - Describe (2:14)
EP32 - Group by (2:26)
EP33 - Group by aggregation (2:39)
EP34 - If your code is long (0:47)
EP35 - Map (2:14)
EP36 - Numpy (2:29)
EP37 - Where (3:09)
EP38 - Merge (1:54)
EP39 - Intro to Pandas Plots (5:28)
EP40 - DataLore Visualization (1:36)
EP41 - Course Review (0:48)
EP42 - Say Hi to Final Project 🐼 (1:18)
🐼 Pandas Project
Intro to Web Scraping - Python Edition
🍟 The Fastest Intro
EP01 - What is Web Scraping
EP02 - Gazpacho
EP03 - GET request web page (0:08)
Quiz - Essential HTML
EP04 - Find the element you want
EP05 - Using strip() to get clean texts
📝 Optional Reading - Gazpacho
Sprint 10 - Looker Studio
Coming Soon
Bootcamp Final Exam
The Moment of Truth
Warm Up Test Exam
Then, What SQL Looks Like?
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock