The Data Analyst Course: Complete Data Analyst Bootcamp
0% Completed
01 – Introduction to the Course
02 – Introduction to Data Analytics
Lesson 001 Introduction to the World of Business and Data
Video - 00:2:26 mins
Lesson 002 Relevant Terms Explained
Video - 00:5:45 mins
Lesson 003 Data Analyst Compared to Other Data Jobs
Video - 00:2:28 mins
Lesson 004 Data Analyst Job Description
Video - 00:5:42 mins
Lesson 005 Why Python
Video - 00:5:42 mins
03 – Setting up the Environment
01 – Introduction to the Course
02 – Introduction to Data Analytics
Lesson 001 Introduction to the World of Business and Data
Video - 00:2:26 mins
Lesson 002 Relevant Terms Explained
Video - 00:5:45 mins
Lesson 003 Data Analyst Compared to Other Data Jobs
Video - 00:2:28 mins
Lesson 004 Data Analyst Job Description
Video - 00:5:42 mins
Lesson 005 Why Python
Video - 00:5:42 mins
03 – Setting up the Environment
Download Attachment
Reading
Lesson 001 Introduction
Video - 00:1:24 mins
Lesson 002 Programming Explained in a Few Minutes
Video - 00:5:4 mins
Lesson 004 Jupyter - Introduction
Video - 00:3:29 mins
Lesson 005 Jupyter - Installing Anaconda
Video - 00:4:00 mins
Lesson 006 Jupyter - Intro to Using Jupyter
Video - 00:3:11 mins
Lesson 007 Jupyter - Working with Notebook Files
Video - 00:6:9 mins
Lesson 008 Jupyter - Using Shortcuts
Video - 00:3:7 mins
Lesson 009 Jupyter - Handling Error Messages
Video - 00:5:52 mins
Lesson 010 Jupyter - Restarting the Kernel
Video - 00:2:18 mins
04 – Python Basics
Download Attachment
Reading
Lesson 001 Python Variables
Video - 00:3:37 mins
Lesson 007 Types of Data - Numbers and Boolean Values
Video - 00:3:5 mins
Lesson 014 Types of Data - Strings
Video - 00:5:40 mins
Lesson 021 Basic Python Syntax - Arithmetic Operators
Video - 00:3:23 mins
Lesson 031 Basic Python Syntax - The Double Equality Sign
Video - 00:1:33 mins
Lesson 034 Basic Python Syntax - Reassign Values
Video - 00:1:8 mins
Lesson 040 Basic Python Syntax - Add Comments
Video - 00:1:34 mins
Lesson 042 Basic Python Syntax - Line Continuation
Video - 00:00:49 mins
Lesson 044 Basic Python Syntax - Indexing Elements
Video - 00:1:18 mins
Lesson 048 Basic Python Syntax - Indentation
Video - 00:1:44 mins
Lesson 051 Operators - Comparison Operators
Video - 00:2:10 mins
Lesson 057 Operators - Logical and Identity Operators
Video - 00:5:36 mins
Lesson 065 Conditional Statements - The IF Statement
Video - 00:3:2 mins
Lesson 069 Conditional Statements - The ELSE Statement
Video - 00:2:45 mins
Lesson 071 Conditional Statements - The ELIF Statement
Video - 00:5:34 mins
Lesson 074 Conditional Statements - A Note on Boolean Values
Video - 00:2:14 mins
Lesson 076 Functions - Defining a Function in Python
Video - 00:2:2 mins
Lesson 077 Functions - Creating a Function with a Parameter
Video - 00:3:49 mins
Lesson 080 Functions - Another Way to Define a Function
Video - 00:2:36 mins
Lesson 082 Functions - Using a Function in Another Function
Video - 00:1:49 mins
Lesson 084 Functions - Combining Conditional Statements and Functions
Video - 00:3:6 mins
Lesson 086 Functions - Creating Functions That Contain a Few Arguments
Video - 00:1:17 mins
Lesson 087 Functions - Notable Built-in Functions in Python
Video - 00:3:56 mins
Lesson 098 Sequences - Lists
Video - 00:4:2 mins
Lesson 105 Sequences - Using Methods
Video - 00:3:19 mins
Lesson 111 Sequences - List Slicing
Video - 00:4:31 mins
Lesson 119 Sequences - Tuples
Video - 00:3:11 mins
Lesson 124 Sequences - Dictionaries
Video - 00:4:4 mins
Lesson 132 Iteration - For Loops
Video - 00:2:56 mins
Lesson 136 Iteration - While Loops and Incrementing
Video - 00:2:26 mins
Lesson 138 Iteration - Create Lists with the range() Function
Video - 00:3:49 mins
Lesson 143 Iteration - Use Conditional Statements and Loops Together
Video - 00:3:11 mins
Lesson 147 Iteration - Conditional Statements, Functions, and Loops
Video - 00:2:27 mins
Lesson 149 Iteration - Iterating over Dictionaries
Video - 00:3:7 mins
05 – Fundamentals for Coding in Python
Download Attachment
Reading
Lesson 001 Object-Oriented Programming (OOP)
Video - 00:5:00 mins
Lesson 002 Modules, Packages, and the Python Standard Library
Video - 00:4:24 mins
Lesson 003 Importing Modules
Video - 00:3:25 mins
Lesson 004 Introduction to Using NumPy and pandas
Video - 00:9:9 mins
Lesson 005 What is Software Documentation
Video - 00:3:58 mins
Lesson 006 The Python Documentation
Video - 00:6:23 mins
06 – Mathematics for Python
Download Attachment
Reading
Lesson 001 What Is а Matrix.decrypted
Video - 00:3:37 mins
Lesson 001 What Is а Matrix
Video - 00:3:37 mins
Lesson 002 Scalars and Vectors
Video - 00:2:58 mins
Lesson 003 Linear Algebra and Geometry
Video - 00:3:6 mins
Lesson 004 Arrays in Python
Video - 00:5:9 mins
Lesson 005 What Is a Tensor
Video - 00:3:00 mins
Lesson 006 Adding and Subtracting Matrices
Video - 00:3:36 mins
Lesson 007 Errors When Adding Matrices
Video - 00:2:1 mins
Lesson 008 Transpose
Video - 00:5:13 mins
Lesson 009 Dot Product of Vectors
Video - 00:3:48 mins
Lesson 010 Dot Product of Matrices
Video - 00:8:23 mins
Lesson 011 Why is Linear Algebra Useful
Video - 00:10:10 mins
07 – NumPy Basics
08 – Pandas – Basics
Download Attachment
Reading
Lesson 001 Introduction to the pandas Library
Video - 00:5:41 mins
Lesson 002 Installing and Running pandas
Video - 00:5:57 mins
Lesson 006 Introduction to pandas Series
Video - 00:8:41 mins
Lesson 017 Working with Attributes in Python
Video - 00:5:22 mins
Lesson 025 Using an Index in pandas
Video - 00:4:00 mins
Lesson 031 Label-based vs Position-based Indexing
Video - 00:4:31 mins
Lesson 034 More on Working with Indices in Python
Video - 00:5:37 mins
Lesson 038 Using Methods in Python - Part I
Video - 00:4:55 mins
Lesson 039 Using Methods in Python - Part II
Video - 00:2:36 mins
Lesson 042 Parameters vs Arguments
Video - 00:4:35 mins
Lesson 045 The pandas Documentation
Video - 00:9:54 mins
Lesson 046 Introduction to pandas DataFrames
Video - 00:5:23 mins
Lesson 047 Creating DataFrames from Scratch - Part I
Video - 00:5:56 mins
Lesson 050 Creating DataFrames from Scratch - Part II
Video - 00:5:3 mins
Lesson 054 Additional Notes on Using DataFrames
Video - 00:1:58 mins
09 – Working with Text Files
Download Attachment
Reading
Lesson 001 Working with Files in Python - An Introduction
Video - 00:3:46 mins
Lesson 002 File vs File Object, Read vs Parse
Video - 00:2:52 mins
Lesson 003 Structured vs Semi-Structured and Unstructured Data
Video - 00:3:10 mins
Lesson 004 Data Connectivity through Text Files
Video - 00:3:6 mins
Lesson 005 Principles of Importing Data in Python
Video - 00:4:50 mins
Lesson 006 More on Text Files (.txt vs .csv)
Video - 00:4:33 mins
Lesson 007 Fixed-width Files
Video - 00:1:26 mins
Lesson 008 Common Naming Conventions Used in Programming
Video - 00:3:49 mins
Lesson 009 Importing Text Files in Python ( open() )
Video - 00:9:00 mins
Lesson 010 Importing Text Files in Python ( with open() )
Video - 00:4:53 mins
Lesson 011 Importing .csv Files with pandas - Part I
Video - 00:5:35 mins
Lesson 012 Importing .csv Files with pandas - Part II
Video - 00:2:37 mins
Lesson 013 Importing .csv Files with pandas - Part III
Video - 00:5:57 mins
Lesson 014 Importing Data with the index_col Parameter
Video - 00:2:35 mins
Lesson 015 Importing Data with NumPy - .loadtxt() vs genfromtxt()
Video - 00:10:44 mins
Lesson 016 Importing Data with NumPy - Partial Cleaning While Importing
Video - 00:7:21 mins
Lesson 018 Importing .json Files
Video - 00:5:15 mins
Lesson 019 Prelude to Working with Excel Files in Python
Video - 00:3:40 mins
Lesson 020 Working with Excel Data (the .xlsx Format)
Video - 00:1:55 mins
Lesson 021 An Important Exercise on Importing Data in Python
Video - 00:5:44 mins
Lesson 022 Importing Data with the pandas' Squeeze Method
Video - 00:3:23 mins
Lesson 023 A Note on Importing Files in Jupyter
Video - 00:3:10 mins
Lesson 024 Saving Your Data with pandas
Video - 00:3:11 mins
Lesson 025 Saving Your Data with NumPy - np.save()
Video - 00:5:23 mins
Lesson 026 Saving Your Data with NumPy - np.savez()
Video - 00:5:12 mins
Lesson 027 Saving Your Data with NumPy - np.savetxt()
Video - 00:3:58 mins
Lesson 029 Working with Text Files - Conclusion
Video - 00:00:42 mins
10 – Working with Text Data
Download Attachment
Reading
Lesson 001 Working with Text Data and Argument Specifiers
Video - 00:9:18 mins
Lesson 005 Manipulating Python Strings
Video - 00:4:13 mins
Lesson 011 Using Various Python String Methods - Part I
Video - 00:6:51 mins
Lesson 027 Using Various Python String Methods - Part II
Video - 00:6:44 mins
Lesson 033 String Accessors
Video - 00:4:50 mins
Lesson 039 Using the .format() Method
Video - 00:9:3 mins
11 – Must-Know Python Tools
Download Attachment
Reading
Lesson 001 Iterating Over Range Objects
Video - 00:4:17 mins
Lesson 002 Nested For Loops - Introduction
Video - 00:5:59 mins
Lesson 003 Triple Nested For Loops
Video - 00:5:37 mins
Lesson 011 List Comprehensions
Video - 00:8:30 mins
Lesson 017 Anonymous (Lambda) Functions
Video - 00:7:00 mins
12 – Data GatheringData Collection
13 – APIs (POST requests are not needed for this course)
Download Attachment
Reading
Lesson 001 Overview of APIs
Video - 00:3:10 mins
Lesson 002 GET and POST Requests
Video - 00:2:35 mins
Lesson 003 Data Exchange Format for APIs JSON
Video - 00:2:24 mins
Lesson 004 Introducing the Exchange Rates API
Video - 00:4:57 mins
Lesson 005 Including Parameters in a GET Request
Video - 00:3:18 mins
Lesson 006 More Functionalities of the Exchange Rates API
Video - 00:4:39 mins
Lesson 007 Coding a Simple Currency Conversion Calculator
Video - 00:4:52 mins
Lesson 008 iTunes API
Video - 00:4:41 mins
Lesson 010 iTunes API Structuring and Exporting the Data
Video - 00:2:10 mins
Lesson 011 Pagination GitHub API
Video - 00:4:21 mins
14 – Data Cleaning and Data Preprocessing
15 – pandas Series
16 – pandas DataFrames
Download Attachment
Reading
Lesson 001 A Revision to pandas DataFrames
Video - 00:5:5 mins
Lesson 002 Common Attributes for Working with DataFrames
Video - 00:4:15 mins
Lesson 003 Data Selection in pandas DataFrames
Video - 00:6:55 mins
Lesson 004 Data Selection - Indexing with .iloc[]
Video - 00:5:56 mins
Lesson 005 Data Selection - Indexing with .loc[]
Video - 00:4:2 mins
Lesson 006 A Few Comments on Using .loc[] and .iloc[]
Video - 00:11:40 mins
17 – NumPy Fundamentals
Download Attachment
Reading
Lesson 001 Indexing in NumPy
Video - 00:5:52 mins
Lesson 002 Assigning Values in NumPy
Video - 00:4:16 mins
Lesson 003 Elementwise Properties of Arrays
Video - 00:4:29 mins
Lesson 004 Types of Data Supported by NumPy
Video - 00:5:56 mins
Lesson 005 Characteristics of NumPy Functions Part 1
Video - 00:4:43 mins
Lesson 006 Characteristics of NumPy Functions Part 2
Video - 00:3:31 mins
18 – NumPy DataTypes
19 – Working with Arrays
20 – Generating Data with NumPy
Download Attachment
Reading
Lesson 001 Arrays of 0s and 1s
Video - 00:5:32 mins
Lesson 002 _like functions in NumPy
Video - 00:3:13 mins
Lesson 003 A Non-Random Sequence of Numbers
Video - 00:5:2 mins
Lesson 004 Random Generators and Seeds
Video - 00:5:21 mins
Lesson 005 Basic Random Functions in NumPy
Video - 00:3:56 mins
Lesson 006 Probability Distributions in NumPy
Video - 00:5:19 mins
Lesson 007 Applications of Random Data in NumPy
Video - 00:4:9 mins
21 – Statistics with NumPy
Download Attachment
Reading
Lesson 001 Using Statistical Functions in NumPy
Video - 00:7:45 mins
Lesson 002 Minimal and Maximal Values in NumPy
Video - 00:6:2 mins
Lesson 003 Statistical Order Functions in NumPy
Video - 00:6:26 mins
Lesson 004 Averages and Variance in NumPy
Video - 00:4:17 mins
Lesson 005 Covariance and Correlation in NumPy
Video - 00:2:59 mins
Lesson 006 Histograms in NumPy (Part 1)
Video - 00:7:36 mins
Lesson 007 Histograms in NumPy (Part 2)
Video - 00:4:15 mins
Lesson 008 NAN Equivalent Functions in NumPy
Video - 00:3:9 mins
22 – NumPy – Preprocessing
Download Attachment
Reading
Lesson 001 Checking for Missing Values in Ndarrays
Video - 00:9:23 mins
Lesson 002 Substituting Missing Values in Ndarrays
Video - 00:8:29 mins
Lesson 003 Reshaping Ndarrays
Video - 00:6:31 mins
Lesson 004 Removing Values from Ndarrays
Video - 00:4:20 mins
Lesson 005 Sorting Ndarrays
Video - 00:9:45 mins
Lesson 006 Argument Sort in NumPy
Video - 00:5:48 mins
Lesson 007 Argument Where in NumPy
Video - 00:11:13 mins
Lesson 008 Shuffling Ndarrays
Video - 00:6:51 mins
Lesson 009 Casting Ndarrays
Video - 00:6:14 mins
Lesson 010 Striping Values from Ndarrays
Video - 00:4:43 mins
Lesson 011 Stacking Ndarrays
Video - 00:10:31 mins
Lesson 012 Concatenating Ndarrays
Video - 00:6:28 mins
Lesson 013 Finding Unique Values in Ndarrays
Video - 00:5:4 mins
23 – A Loan Data Example with NumPy
Download Attachment
Reading
Lesson 001 Setting Up Introduction to the Practical Example
Video - 00:4:50 mins
Lesson 002 Setting Up Importing the Data Set
Video - 00:4:10 mins
Lesson 003 Setting Up Checking for Incomplete Data
Video - 00:4:35 mins
Lesson 004 Setting Up Splitting the Dataset
Video - 00:5:27 mins
Lesson 005 Setting Up Creating Checkpoints
Video - 00:2:50 mins
Lesson 006 Manipulating Text Data Issue Date
Video - 00:5:27 mins
Lesson 007 Manipulating Text Data Loan Status and Term
Video - 00:7:8 mins
Lesson 008 Manipulating Text Data Grade and Sub Grade
Video - 00:8:54 mins
Lesson 009 Manipulating Text Data Verification Status & URL
Video - 00:5:20 mins
Lesson 010 Manipulating Text Data State Address
Video - 00:6:2 mins
Lesson 011 Manipulating Text Data Converting Strings and Creating a Checkpoint
Video - 00:3:28 mins
Lesson 012 Manipulating Numeric Data Substitute Filler Values
Video - 00:7:51 mins
Lesson 013 Manipulating Numeric Data Currency Change – The Exchange Rate
Video - 00:6:32 mins
Lesson 014 Manipulating Numeric Data Currency Change - From USD to EUR
Video - 00:8:22 mins
Lesson 015 Completing the Dataset
Video - 00:6:46 mins
24 – The Absenteeism Exercise – Introduction
25 – Solution to the Absenteeism Exercise
Download Attachment
Reading
Lesson 001 How to Complete the Absenteeism Exercise
Video - 00:1:57 mins
Lesson 002 Eyeball Your Data First
Video - 00:5:53 mins
Lesson 003 Note Programming vs the Rest of the World
Video - 00:3:28 mins
Lesson 004 Using a Statistical Approach to Solve Our Exercise
Video - 00:2:17 mins
Lesson 005 Dropping the 'ID' Column
Video - 00:6:27 mins
Lesson 006 Analysis of the 'Reason for Absence' Column
Video - 00:5:4 mins
Lesson 007 Splitting the Reasons for Absence into Multiple Dummy Variables
Video - 00:8:37 mins
Lesson 008 Working with Dummy Variables - A Statistical Perspective
Video - 00:1:28 mins
Lesson 009 Grouping the Reason for Absence Columns
Video - 00:8:35 mins
Lesson 010 Concatenating Columns in a pandas DataFrame
Video - 00:4:35 mins
Lesson 011 Reordering Columns in a DataFrame
Video - 00:1:43 mins
Lesson 013 Working on the 'Date' Column
Video - 00:7:49 mins
Lesson 014 Extracting the Month Value from the 'Date' Column
Video - 00:7:00 mins
Lesson 015 Creating the 'Day of the Week' Column
Video - 00:3:36 mins
Lesson 016 Understanding the Meaning of 5 More Columns
Video - 00:3:17 mins
Lesson 017 Modifying the 'Education' Column
Video - 00:4:38 mins
Lesson 018 Final Remarks on the Absenteeism Exercise
Video - 00:1:41 mins
26 – Data Visualization
Download Attachment
Reading
Lesson 001 What Is Data Visualization and Why Is It Important
Video - 00:4:31 mins
Lesson 002 Why Learn Data Visualization
Video - 00:6:8 mins
Lesson 003 Choosing the Right Visualization – What Are Some Popular Approaches and Framewor
Video - 00:6:58 mins
Lesson 004 Introduction into Colors and Color Theory
Video - 00:8:56 mins
Lesson 005 Bar Chart - Introduction - General Theory and Getting to Know the Dataset
Video - 00:1:30 mins
Lesson 006 Bar Chart - How to Create a Bar Chart Using Python
Video - 00:11:27 mins
Lesson 007 Bar Chart – Interpreting the Bar Graph. How to Make a Good Bar Graph
Video - 00:2:50 mins
Lesson 008 Pie Chart - Introduction - General Theory and Dataset
Video - 00:4:4 mins
Lesson 009 Pie Chart - How to Create a Pie Chart Using Python
Video - 00:6:39 mins
Lesson 010 Pie Chart – Interpreting the Pie Chart
Video - 00:1:32 mins
Lesson 011 Pie Chart - Why You Should Never Create a Pie Graph
Video - 00:7:32 mins
Lesson 012 Stacked Area Chart - Introduction - General Theory. Getting to Know the Dataset
Video - 00:3:16 mins
Lesson 013 Stacked Area Chart - How to Create a Stacked Area Chart Using Python
Video - 00:7:48 mins
Lesson 014 Stacked Area Chart - Interpreting the Stacked Area Graph
Video - 00:2:30 mins
Lesson 015 Stacked Area Chart - How to Make a Good Stacked Area Chart
Video - 00:3:53 mins
Lesson 016 Line Chart - Introduction - General Theory. Getting to Know the Dataset
Video - 00:2:3 mins
Lesson 017 Line Chart - How to Create a Line Chart in Python
Video - 00:8:5 mins
Lesson 018 Line Chart - Interpretation
Video - 00:3:11 mins
Lesson 019 Line Chart - How to Make a Good Line Chart
Video - 00:6:30 mins
Lesson 020 Histogram - Introduction - General Theory. Getting to Know the Dataset
Video - 00:4:39 mins
Lesson 021 Histogram - How to Create a Histogram Using Python
Video - 00:5:43 mins
Lesson 022 Histogram – Interpreting the Histogram
Video - 00:2:11 mins
Lesson 023 Histogram – Choosing the Number of Bins in a Histogram
Video - 00:5:28 mins
Lesson 024 Histogram - How to Make a Good Histogram
Video - 00:4:43 mins
Lesson 025 Scatter Plot - Introduction - General Theory. Getting to Know the Dataset
Video - 00:2:29 mins
Lesson 026 Scatter Plot - How to Create a Scatter Plot Using Python
Video - 00:8:39 mins
Lesson 027 Scatter Plot – Interpreting the Scatter Plot
Video - 00:2:42 mins
Lesson 028 Scatter Plot - How to Make a Good Scatter Plot
Video - 00:2:57 mins
Lesson 029 Regression Plot - Introduction - General Theory. Getting to Know the Dataset
Video - 00:3:3 mins
Lesson 030 Regression Plot - How to Create a Regression Scatter Plot Using Python
Video - 00:7:8 mins
Lesson 031 Regression Plot – Interpreting the Regression Scatter Plot
Video - 00:4:36 mins
Lesson 032 Regression Plot - How to Make a Good Regression Plot
Video - 00:3:14 mins
Lesson 033 Bar and Line Chart - Introduction - General Theory. Getting to Know the Dataset
Video - 00:3:10 mins
Lesson 034 Bar and Line Chart - How to Create a Combination Bar and Line Graph Using Python
Video - 00:7:40 mins
Lesson 035 Bar and Line Chart – Interpreting the Combination Bar and Line Graph
Video - 00:2:36 mins
Lesson 036 Bar and Line Chart – How to Make a Good Bar and Line Graph
Video - 00:4:4 mins
27 – Conclusion
Download Vietnamese subtitle: Click here
Download English subtitle: Click here
Finish Course Early?
You have not completed all required lessons and assessments.
Your Progress
0%
