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