Complete Data Analyst Bootcamp

Introduction to the Course

A Practical Example - What Will You Learn in This Course?

What Does the course cover?

Download All Resources

FAQ

Introduction to Data Analytics

Introduction to the World of Business and Data

Relevant Terms Explained

Data Analyst Compared to Other Data Jobs

Data Analyst Job Description

Why Python

Setting up the Environment

Introduction

Programming Explained in a Few Minutes

Jupyter - Introduction

Jupyter - Installing Anaconda

Jupyter - Intro to Using Jupyter

Jupyter - Working with Notebook Files

Jupyter - Using Shortcuts

Jupyter - Handling Error Messages

Jupyter - Restarting the Kernel

Jupyter - Introduction

Python Basics

Python Variables

Python Variables - Exercise #1

Python Variables - Exercise #2

Python Variables - Exercise #3

Python Variables - Exercise #4

Python Variables

Types of DATA - Numbers and Boolean Values

Numbers and Boolean Values - Exercise #1

Numbers and Boolean Values - Exercise #2

Numbers and Boolean Values - Exercise #3

Numbers and Boolean Values - Exercise #4

Numbers and Boolean Values - Exercise #5

Types of Data - Numbers and Boolean Values

Types of Data - Strings

Strings - Exercise #1

Strings - Exercise #2

Strings - Exercise #3

Strings - Exercise #4

Strings - Exercise #5

Types of Data - Strings

Basic Python Syntax - Arithmetic Operators

Arithmetic Operators - Exercise #1

Arithmetic Operators - Exercise #2

Arithmetic Operators - Exercise #3

Arithmetic Operators - Exercise #4

Arithmetic Operators - Exercise #5

Arithmetic Operators - Exercise #6

Arithmetic Operators - Exercise #7

Arithmetic Operators - Exercise #8

Basic Python Syntax - Arithmetic Operators

Basic Python Syntax - The Double Equality Sign

The Double Equality Sign - Exercise #1

Basic Python Syntax - The Double Equality Sign

Basic Python Syntax - Reassign Values

Reassign Values - Exercise #1

Reassign Values - Exercise #2

Reassign Values - Exercise #3

Reassign Values - Exercise #4

Basic Python Syntax - Reassign Values

Basic Python Syntax - Add Comments

Basic Python Syntax - Add Comments

Basic Python Syntax - Line Continuation

Line Continuation - Exercise #1

Basic Python Syntax - Indexing Elements

Indexing Elements - Exercise #1

Indexing Elements - Exercise #2

Basic Python Syntax - Indexing Elements

Basic Python Syntax - Indentation

Indentation - Exercise #1

Basic Python Syntax - Indentation

Operators - Comparison Operators

Comparison Operators - Exercise #1

Comparison Operators - Exercise #2

Comparison Operators - Exercise #3

Comparison Operators - Exercise #4

Operators - Comparison Operators

Operators - Logical and Identity Operators

Logical and Identity Operators - Exercise #1

Logical and Identity Operators - Exercise #2

Logical and Identity Operators - Exercise #3

Logical and Identity Operators - Exercise #4

Logical and Identity Operators - Exercise #5

Logical and Identity Operators - Exercise #6

Operators - Logical and Identity Operators

Conditional Statements - The IF Statement

The IF Statement - Exercise #1

The IF Statement - Exercise #2

Conditional Statements - The IF Statement

Conditional Statements - The ELSE Statement

The ELSE Statement - Exercise #1

Conditional Statements - The ELIF Statement

The ELIF Statement - Exercise #1

The ELIF Statement - Exercise #2

Conditional Statements - A Note on Boolean Values

Conditional Statements - A Note on Boolean Values

Functions - Defining a Function in Python

Functions - Creating a Function with a Parameter

Creating a Function with a Parameter - Exercise #1

Creating a Function with a Parameter - Exercise #2

Functions - Another Way to Define a Function

Another Way to Define a Function - Exercise #1

Functions - Using a Function in Another Function

Using a Function in Another Function - Exercise #1

Functions - Combining Conditional Statements and Functions

Conditional Statements and Functions - Exercise #1

Functions - Creating Functions That Contain a Few Arguments

Functions - Notable Built-in Functions in Python

Notable Built-In Functions in Python - Exercise #1

Notable Built-In Functions in Python - Exercise #2

Notable Built-In Functions in Python - Exercise #3

Notable Built-In Functions in Python - Exercise #4

Notable Built-In Functions in Python - Exercise #5

Notable Built-In Functions in Python - Exercise #6

Notable Built-In Functions in Python - Exercise #7

Notable Built-In Functions in Python - Exercise #8

Notable Built-In Functions in Python - Exercise #9

Functions

Sequences - Lists

Lists - Exercise #1

Lists - Exercise #2

Lists - Exercise #3

Lists - Exercise #4

Lists - Exercise #5

Sequences - Lists

Sequences - Using Methods

Using Methods - Exercise #1

Using Methods - Exercise #2

Using Methods - Exercise #3

Using Methods - Exercise #4

Sequences - Using Methods

Sequences - List Slicing

List Slicing - Exercise #1

List Slicing - Exercise #2

List Slicing - Exercise #3

List Slicing - Exercise #4

List Slicing - Exercise #5

List Slicing - Exercise #6

List Slicing - Exercise #7

Sequences - Tuples

Tuples - Exercise #1

Tuples - Exercise #2

Tuples - Exercise #3

Tuples - Exercise #4

Sequences - Dictionaries

Dictionaries - Exercise #1

Dictionaries - Exercise #2

Dictionaries - Exercise #3

Dictionaries - Exercise #4

Dictionaries - Exercise #5

Dictionaries - Exercise #6

Sequences - Dictionaries

Iteration - For Loops

For Loops - Exercise #1

For Loops - Exercise #2

Iteration - For Loops

Iteration - While Loops and Incrementing

While Loops and Incrementing - Exercise #1

Iteration - Create Lists with the range() Function

Create Lists with the range() Function - Exercise #1

Create Lists with the range() Function - Exercise #2

Create Lists with the range() Function - Exercise #3

Iteration - Create Lists with the range() Function

Iteration - Use Conditional Statements and Loops Together

Conditional Statements and Loops - Exercise #1

Conditional Statements and Loops - Exercise #2

Conditional Statements and Loops - Exercise #3

Iteration - Conditional Statements, Functions, and Loops

Conditional Statements, Functions, and Loops - Exercise #1

Iteration - Iterating over Dictionaries

Iterating over Dictionaries - Exercise #1

Iterating over Dictionaries - Exercise #2

Fundamentals for Coding in Python

Object-Oriented Programming (OOP)

Modules, Packages, and the Python Standard Library

Importing Modules

Introduction to Using NumPy and pandas

What is Software Documentation?

The Python Documentation

Mathematics for Python

What Is а Matrix?

Scalars and Vectors

Linear Algebra and Geometry

Arrays in Python

What Is a Tensor?

Adding and Subtracting Matrices

Errors When Adding Matrices

Transpose

Dot Product of Vectors

Dot Product of Matrices

Why is Linear Algebra Useful

NumPy Basics

The NumPy Package and Why We Use It

Installing/Upgrading NumPy

Ndarray

The NumPy Documentation

NumPy Basics - Exercise

Pandas-Basics

Introduction to the pandas Library

Installing and Running pandas

Installing and Running pandas - Exercise #1

A Note on Completing the Upcoming Coding Exercises

Installing and Running pandas - Exercise #2

Introduction to pandas Series

Introduction to pandas Series - Exercise #1

Introduction to pandas Series - Exercise #2

Introduction to pandas Series - Exercise #3

Introduction to pandas Series - Exercise #4

Introduction to pandas Series - Exercise #5

Introduction to pandas Series - Exercise #6

Introduction to pandas Series - Exercise #7

Introduction to pandas Series - Exercise #8

Introduction to pandas Series - Exercise #9

Introduction to pandas Series - Exercise #10

Working with Attributes in Python

Working with Attributes in Python - Exercise #1

Working with Attributes in Python - Exercise #2

Working with Attributes in Python - Exercise #3

Working with Attributes in Python - Exercise #4

Working with Attributes in Python - Exercise #5

Working with Attributes in Python - Exercise #6

Working with Attributes in Python - Exercise #7

Using an Index in pandas

Using an Index in pandas - Exercise #1

Using an Index in pandas - Exercise #2

Using an Index in pandas - Exercise #3

Using an Index in pandas - Exercise #4

Using an Index in pandas - Exercise #5

Label-based vs Position-based Indexing

Label-based vs Position-based Indexing - Exercise #1

Label-based vs Position-based Indexing - Exercise #2

More on Working with Indices in Python

More on Working with Indices in Python - Exercise #3

More on Working with Indices in Python - Exercise #4

More on Working with Indices in Python - Exercise #5

Using Methods in Python - Part I

Using Methods in Python - Part II

Using Methods in Python - Exercise #1

Using Methods in Python - Exercise #2

Parameters vs Arguments

Parameters vs Arguments - Exercise #1

Parameters vs Arguments - Exercise #2

The pandas Documentation

Introduction to pandas DataFrames

Creating DataFrames from Scratch - Part I

Creating DataFrames from Scratch - Exercise #1

Creating DataFrames from Scratch - Exercise #2

Creating DataFrames from Scratch - Part II

Creating DataFrames from Scratch - Exercise #3

Creating DataFrames from Scratch - Exercise #4

Creating DataFrames from Scratch - Exercise #5

Additional Notes on Using DataFrames

pandas Basics - Conclusion

Working with Text Files

Working with Files in Python - An Introduction

File vs File Object, Read vs Parse

Structured vs Semi-Structured and Unstructured Data

Data Connectivity through Text Files

Principles of Importing Data in Python

More on Text Files (*.txt vs *.csv)

Fixed-width Files

Common Naming Conventions Used in Programming

Importing Text Files in Python ( open() )

Importing Text Files in Python ( with open() )

Importing *.csv Files with pandas - Part I

Importing *.csv Files with pandas - Part II

Importing *.csv Files with pandas - Part III

Importing Data with the "index_col" Parameter

Importing Data with NumPy - .loadtxt() vs genfromtxt()

Importing Data with NumPy - Partial Cleaning While Importing

Importing Data with NumPy - Exercise

Importing *.json Files

Prelude to Working with Excel Files in Python

Working with Excel Data (the *.xlsx Format)

An Important Exercise on Importing Data in Python

Importing Data with the pandas' "Squeeze" Method

A Note on Importing Files in Jupyter

Saving Your Data with pandas

Saving Your Data with NumPy - np.save()

Saving Your Data with NumPy - np.savez()

Saving Your Data with NumPy - np.savetxt()

Saving Your Data with NumPy - Exercise

Working with Text Files - Conclusion

Working with Text Data

Working with Text Data and Argument Specifiers

Text Data and Argument Specifiers - Exercise #1

Text Data and Argument Specifiers - Exercise #2

Text Data and Argument Specifiers - Exercise #3

Manipulating Python Strings

Manipulating Python Strings - Exercise #1

Manipulating Python Strings - Exercise #2

Manipulating Python Strings - Exercise #3

Manipulating Python Strings - Exercise #4

Manipulating Python Strings - Exercise #5

Using Various Python String Methods - Part I

Python String Methods - Exercise #1

Python String Methods - Exercise #2

Python String Methods - Exercise #3

Python String Methods - Exercise #4

Python String Methods - Exercise #5

Python String Methods - Exercise #6

Python String Methods - Exercise #7

Python String Methods - Exercise #8

Python String Methods - Exercise #9

Python String Methods - Exercise #10

Python String Methods - Exercise #11

Python String Methods - Exercise #12

Python String Methods - Exercise #13

Python String Methods - Exercise #14

Python String Methods - Exercise #15

Using Various Python String Methods - Part II

Python String Methods - Exercise #16

Python String Methods - Exercise #17

Python String Methods - Exercise #18

Python String Methods - Exercise #19

Python String Methods - Exercise #20

String Accessors

String Accessors - Exercise #1

String Accessors - Exercise #2

String Accessors - Exercise #3

String Accessors - Exercise #4

String Accessors - Exercise #5

Using the .format() Method

Using the .format() Method - Exercise #1

Using the .format() Method - Exercise #2

Using the .format() Method - Exercise #3

Using the .format() Method - Exercise #4

Using the .format() Method - Exercise #5

Must Know Python Tools

Iterating Over Range Objects

Nested For Loops - Introduction

Triple Nested For Loops

Triple Nested For Loops - Exercise #1

Triple Nested For Loops - Exercise #2

Triple Nested For Loops - Exercise #3

Triple Nested For Loops - Exercise #4

Triple Nested For Loops - Exercise #5

Triple Nested For Loops - Exercise #6

Triple Nested For Loops - Exercise #7

List Comprehensions

List Comprehensions - Exercise #1

List Comprehensions - Exercise #2

List Comprehensions - Exercise #3

List Comprehensions - Exercise #4

List Comprehensions - Exercise #5

Anonymous (Lambda) Functions

Anonymous Functions - Exercise #1

Anonymous Functions - Exercise #2

Anonymous Functions - Exercise #3

Anonymous Functions - Exercise #4

Data Gathering/Data Collection

What is data gathering/data collection?

APIs (POST requests are not needed for this course )

Overview of APIs

GET and POST Requests

Data Exchange Format for APIs: JSON

Introducing the Exchange Rates API

Including Parameters in a GET Request

More Functionalities of the Exchange Rates API

Coding a Simple Currency Conversion Calculator

iTunes API

iTunes API: Homework

iTunes API: Structuring and Exporting the Data

Pagination: GitHub API

APIs: Exercise

Data Cleaning and Data Preprocessing

Data Cleaning and Data Preprocessing

Pandas Series

Running pandas - Exercise

.unique(), .nunique()

.unique(), .nunique() - Exercise #1

.unique(), .nunique() - Exercise #2

.unique(), .nunique() - Exercise #3

.unique(), .nunique() - Exercise #4

.unique(), .nunique() - Exercise #5

.unique(), .nunique() - Exercise #6

Converting Series into Arrays

.sort_values()

.sort_values() - Exercise #1

.sort_values() - Exercise #2

.sort_values() - Exercise #3

.sort_values() - Exercise #4

Attribute and Method Chaining

Attribute and Method Chaining - Exercise #1

Attribute and Method Chaining - Exercise #2

Attribute and Method Chaining - Exercise #3

Attribute and Method Chaining - Exercise #4

Attribute and Method Chaining - Exercise #5

Attribute and Method Chaining - Exercise #6

.sort_index()

.sort_index - Exercise #1

.sort_index - Exercise #2

.sort_index - Exercise #3

.sort_index - Exercise #4

Pandas DataFrames

A Revision to pandas DataFrames

Common Attributes for Working with DataFrames

Data Selection in pandas DataFrames

Data Selection - Indexing with .iloc[]

Data Selection - Indexing with .loc[]

A Few Comments on Using .loc[] and .iloc[]

NumPy Fundamentals

Indexing in NumPy

Assigning Values in NumPy

Elementwise Properties of Arrays

Types of Data Supported by NumPy

Characteristics of NumPy Functions Part 1

Characteristics of NumPy Functions Part 2

NumPy Fundamentals - Exercise

NumPy DataTypes

ndarrays

Arrays vs Lists

Strings vs Object vs Number

NumPy DataTypes - Exercise

Working with Arrays

Basic Slicing in NumPy

Stepwise Slicing in NumPy

Conditional Slicing in NumPy

Dimensions and the Squeeze Function

Working with Arrays - Exercise

Generating Data with NumPy

Arrays of 0s and 1s

"_like" functions in NumPy

A Non-Random Sequence of Numbers

Random Generators and Seeds

Basic Random Functions in NumPy

Probability Distributions in NumPy

Applications of Random Data in NumPy

Generating Data with NumPy - Exercise

Statistics with NumPy

Using Statistical Functions in NumPy

Minimal and Maximal Values in NumPy

Statistical Order Functions in NumPy

Averages and Variance in NumPy

Covariance and Correlation in NumPy

Histograms in NumPy (Part 1)

Histograms in NumPy (Part 2)

NAN Equivalent Functions in NumPy

Statistics with NumPy - Exercise

NumPy - Preprocessing

Checking for Missing Values in Ndarrays

Substituting Missing Values in Ndarrays

Reshaping Ndarrays

Removing Values from Ndarrays

Sorting Ndarrays

Argument Sort in NumPy

Argument Where in NumPy

Shuffling Ndarrays

Casting Ndarrays

Striping Values from Ndarrays

Stacking Ndarrays

Concatenating Ndarrays

Finding Unique Values in Ndarrays

A Loan Data Example with NumPy

Setting Up: Introduction to the Practical Example

Setting Up: Importing the Data Set

Setting Up: Checking for Incomplete Data

Setting Up: Splitting the Dataset

Setting Up: Creating Checkpoints

Manipulating Text Data: Issue Date

Manipulating Text Data: Loan Status and Term

Manipulating Text Data: Grade and Sub Grade

Manipulating Text Data: Verification Status & URL

Manipulating Text Data: State Address

Manipulating Text Data: Converting Strings and Creating a Checkpoint

Manipulating Numeric Data: Substitute Filler Values

Manipulating Numeric Data: Currency Change – The Exchange Rate

Manipulating Numeric Data: Currency Change - From USD to EUR

Completing the Dataset

The "Absenteeism" Exercise - Introduction

An Introduction to the "Absenteeism" Exercise

The "Absenteeism" Exercise from a Business Perspective

The Dataset

Solution to the "Absenteeism" Exercise

How to Complete the Absenteeism Exercise

Eyeball Your Data First

Note: Programming vs the Rest of the World

Using a Statistical Approach to Solve Our Exercise

Dropping the 'ID' Column

Analysis of the 'Reason for Absence' Column

Splitting the Reasons for Absence into Multiple Dummy Variables

Working with Dummy Variables - A Statistical Perspective

Grouping the Reason for Absence Columns

Concatenating Columns in a pandas DataFrame

Reordering Columns in a DataFrame

Creating Checkpoints

Working on the 'Date' Column

Extracting the Month Value from the 'Date' Column

Creating the 'Day of the Week' Column

Understanding the Meaning of 5 More Columns

Modifying the 'Education' Column

Final Remarks on the Absenteeism Exercise

Data Visualization

What Is Data Visualization and Why Is It Important?

Why Learn Data Visualization?

Choosing the Right Visualization – What Are Some Popular Approaches and Framewor

Introduction into Colors and Color Theory

Bar Chart - Introduction - General Theory and Getting to Know the Dataset

Bar Chart - How to Create a Bar Chart Using Python

Bar Chart – Interpreting the Bar Graph. How to Make a Good Bar Graph

Pie Chart - Introduction - General Theory and Dataset

Pie Chart - How to Create a Pie Chart Using Python

Pie Chart – Interpreting the Pie Chart

Pie Chart - Why You Should Never Create a Pie Graph

Stacked Area Chart - Introduction - General Theory. Getting to Know the Dataset

Stacked Area Chart - How to Create a Stacked Area Chart Using Python

Stacked Area Chart - Interpreting the Stacked Area Graph

Stacked Area Chart - How to Make a Good Stacked Area Chart

Line Chart - Introduction - General Theory. Getting to Know the Dataset

Line Chart - How to Create a Line Chart in Python

Line Chart - Interpretation

Line Chart - How to Make a Good Line Chart

Histogram - Introduction - General Theory. Getting to Know the Dataset

Histogram - How to Create a Histogram Using Python

Histogram – Interpreting the Histogram

Histogram – Choosing the Number of Bins in a Histogram

Histogram - How to Make a Good Histogram

Scatter Plot - Introduction - General Theory. Getting to Know the Dataset

Scatter Plot - How to Create a Scatter Plot Using Python

Scatter Plot – Interpreting the Scatter Plot

Scatter Plot - How to Make a Good Scatter Plot

Regression Plot - Introduction - General Theory. Getting to Know the Dataset

Regression Plot - How to Create a Regression Scatter Plot Using Python

Regression Plot – Interpreting the Regression Scatter Plot

Regression Plot - How to Make a Good Regression Plot

Bar and Line Chart - Introduction - General Theory. Getting to Know the Dataset

Bar and Line Chart - How to Create a Combination Bar and Line Graph Using Python

Bar and Line Chart – Interpreting the Combination Bar and Line Graph

Bar and Line Chart – How to Make a Good Bar and Line Graph

Data Visualization - Exercise

Conclusion

Conclusion

Bonus