Course Overview
The problem
Most data analyst, data science, and coding courses miss a critical practical step. They don’t teach you how to work with raw data, how to clean, and preprocess it. This creates a sizeable gap between the skills you need on the job and the abilities you have acquired in training. Truth be told, real-world data is messy, so you need to know how to overcome this obstacle to become an independent data professional.
The bootcamps we have seen online and even live classes neglect this aspect and show you how to work with ‘clean’ data. But this isn’t doing you a favour. In reality, it will set you back both when you are applying for jobs, and when you’re on the job.
The solution
Our goal is to provide you with complete preparation. And this course will turn you into a job-ready data analyst. To take you there, we will cover the following fundamental topics extensively.
Theory about the field of data analytics
Basic Python
Advanced Python
NumPy
Pandas
Working with text files
Data collection
Data cleaning
Data preprocessing
Data visualization
Final practical example
Each of these subjects builds on the previous ones. And this is precisely what makes our curriculum so valuable. Everything is shown in the right order and we guarantee that you are not going to get lost along the way, as we have provided all necessary steps in video (not a single one skipped). In other words, we are not going to teach you how to analyse data before you know how to gather and clean it.
So, to prepare you for the entry-level job that leads to a data science position - data analyst - we created The Data Analyst Course.
This is a rather unique training program because it teaches the fundamentals you need on the job. A frequently neglected aspect of vital importance.
Moreover, our focus is to teach topics that flow smoothly and complement each other. The course provides complete preparation for someone who wants to become a data analyst at a fraction of the cost of traditional programs (not to mention the amount of time you will save). We believe that this resource will significantly boost your chances of landing a job, as it will prepare you for practical tasks and concepts that are frequently included in interviews.
The topics we will cover
1. Theory about the field of data analytics
2. Basic Python
3. Advanced Python
4. NumPy
5. Pandas
6. Working with text files
7. Data collection
8. Data cleaning
9. Data preprocessing
10. Data visualization
11. Final practical example
1. Theory about the field of data analytics
Here we will focus on the big picture. But don’t imagine long boring pages with terms you’ll have to check up in a dictionary every minute. Instead, this is where we want to define who a data analyst is, what they do, and how they create value for an organization.
Why learn it?
You need a general understanding to appreciate how every part of the course fits in with the rest of the content. As they say, if you know where you are going, chances are that you will eventually get there. And since data analyst and other data jobs are relatively new and constantly evolving, we want to provide you with a good grasp of the data analyst role specifically. Then, in the following chapters, we will teach you the actual tools you need to become a data analyst.
2. Basic Python
This course is centred around Python. So, we’ll start from the very basics. Don’t be afraid if you do not have prior programming experience.
Why learn it?
You need to learn a programming language to take full advantage of the data-rich world we live in. Unless you are equipped with such a skill, you will always be dependent on other people’s ability to extract and manipulate data, and you want to be independent while doing analysis, right? Also, you don’t necessarily need to learn many programming languages at once. It is enough to be very skilled at just one, and we’ve naturally chosen Python which has established itself as the number one language for data analysis and data science (thanks to its rich libraries and versatility).
3. Advanced Python
We will introduce advanced Python topics such as working with text data and using tools such as list comprehensions and anonymous functions.
Why learn it?
These lessons will turn you into a proficient Python user who is independent on the job. You will be able to use Python’s core strengths to your advantage. So, here it is not just about the topics, it is also about the depth in which we explore the most relevant Python tools.
4. NumPy
NumPy is Python’s fundamental package for scientific computing. It has established itself as the go-to tool when you need to compute mathematical and statical operations.
Why learn it?
A large portion of a data analyst’s work is dedicated to preprocessing datasets. Unquestionably, this involves tons of mathematical and statistical techniques that NumPy is renowned for. In addition, the package introduces multi-dimensional array structures and provides a plethora of built-in functions and methods to use while working with them. In other words, NumPy can be described as a computationally stable state-of-the-art Python instrument that provides flexibility and can take your analysis to the next level.
5. Pandas
The pandas library is one of the most popular Python tools that facilitate data manipulation and analysis. It is very valuable because you can use it to manipulate all sorts of information - numerical tables and time series data, as well as text.
Why learn it?
Pandas is the other main tool an analyst needs to clean and preprocess the data they are working with. Its data manipulation features are second to none in Python because of the diversity and richness it provides in terms of methods and functions. The combined ability to work with both NumPy and pandas is extremely powerful as the two libraries complement each other. You need to be capable to operate with both to produce a complete and consistent analysis independently.
6. Working with text files
Exchanging information with text files is practically how we exchange information today. In this part of the course, we will use the Python, pandas, and NumPy tools learned earlier to give you the essentials you need when importing or saving data.
Why learn it?
In many courses, you are just given a dataset to practice your analytical and programming skills. However, we don’t want to close our eyes to reality, where converting a raw dataset from an external file into a workable Python format can be a massive challenge.
7. Data collection
In the real world, you don’t always have the data readily available for you. In this part of the course, you will learn how to retrieve data from an API.
Why learn it?
You need to know how to source your data, right? To be a well-rounded analyst you must be able to collect data from outside sources. This is rarely a one-click process. This section aims at providing you with all the necessary tools to do that on your own.
8. Data cleaning
The next logical step is to clean your data. This is where you will apply the pandas skills acquired earlier in practice. All lessons throughout the course have a real-world perspective.
Why learn it?
A large part of a data analyst’s job in the real world involves cleaning data and preparing it for the actual analysis. You can’t expect that you’ll deal with flawless data sources, right? So, it will be up to you to overcome this stage and clean your data.
9. Data preprocessing
Even when your dataset is clean and in an understandable shape, it isn’t quite ready to be processed for visualizations and analysis just yet. There is a crucial step in between, and that’s data preprocessing.
Why learn it?
Data preprocessing is where a data analyst can demonstrate how good or great they are at their job. This stage of the work requires the ability to choose the right statistical tool that will improve the quality of your dataset and the knowledge to implement it with advanced pandas and NumPy techniques. Only when you’ve completed this step can you say that your dataset is preprocessed and ready for the next part, which is data visualization.
10. Data visualization
Data visualization is the face of data. Many people look at the data and see nothing. The reason for that is that they are not creating good visualizations. Or even worse – they are creating nice graphs but cannot interpret them accurately.
Why learn it?
This part of the course will teach you how to use your data to produce meaningful insights. At the end of the day, data charts are what conveys the most information in the shortest amount of time. And nothing speaks better than a well crafted and meaningful data visualization.
11. Practical example
The course contains plenty of exercises and practical cases. In the end, we have included a comprehensive practical example that will show you how everything you have learned along the way comes nicely together. This is where you will be able to appreciate how far you have come in your journey to becoming a data analyst and starting your data career.
What you get
A program worth $1,250
Active Q&A support
All the knowledge to become a data analyst
A community of aspiring data analysts
A certificate of completion
Access to frequent future updates
Real-world training
Get ready to become a data analyst from scratch
Why wait? Every day is a missed opportunity.
Click the “Buy Now” button and become a part of our data analyst program today.
FAQ
FAQ area empty
Course curriculum
Chương 1 Introduction to the Course 4 bài · 10 phút
Chương 2 Introduction to Data Analytics 5 bài · 22 phút
- Introduction to the World of Business and Data Học thử 2:26
-
Relevant Terms Explained 5:45
-
Data Analyst Compared to Other Data Jobs 2:27
- Data Analyst Job Description Học thử 5:42
-
Why Python 5:42
Chương 3 Setting up the Environment 11 bài · 39 phút
- Introduction Học thử 1:24
- Programming Explained in a Few Minutes Học thử 5:29
-
Programming Explained in a Few Minutes
-
Jupyter - Introduction 3:28
-
Jupyter - Installing Anaconda 3:35
-
Jupyter - Intro to Using Jupyter 4:53
-
Jupyter - Working with Notebook Files 4:30
-
Jupyter - Using Shortcuts 7:24
-
Jupyter - Handling Error Messages 5:52
-
Jupyter - Restarting the Kernel 2:03
-
Jupyter - Introduction
Chương 4 Python Basics 156 bài · 2 giờ 1 phút
-
Python Variables 3:37
-
Python Coding Exercises - Part I 4:58
-
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 3:05
-
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 5:40
-
Strings - Exercise #1
-
Strings - Exercise #2
-
Strings - Exercise #3
-
Strings - Exercise #4
-
Strings - Exercise #5
-
Types of Data - Strings
-
Introduction to Anaconda AI 2:27
-
Using the Anaconda Assistant: Strings 4:07
-
Basic Python Syntax - Arithmetic Operators 3:23
-
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 1:33
-
The Double Equality Sign - Exercise #1
-
Basic Python Syntax - The Double Equality Sign
-
Basic Python Syntax - Reassign Values 1:08
-
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 1:34
-
Basic Python Syntax - Add Comments
-
Basic Python Syntax - Line Continuation 0:49
-
Line Continuation - Exercise #1
-
Basic Python Syntax - Indexing Elements 1:18
-
Indexing Elements - Exercise #1
-
Indexing Elements - Exercise #2
-
Basic Python Syntax - Indexing Elements
-
Basic Python Syntax - Indentation 1:44
-
Indentation - Exercise #1
-
Basic Python Syntax - Indentation
-
Operators - Comparison Operators 2:10
-
Comparison Operators - Exercise #1
-
Comparison Operators - Exercise #2
-
Comparison Operators - Exercise #3
-
Comparison Operators - Exercise #4
-
Operators - Comparison Operators
-
Operators - Logical and Identity Operators 5:35
-
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 3:01
-
The IF Statement - Exercise #1
-
The IF Statement - Exercise #2
-
Conditional Statements - The IF Statement
-
Conditional Statements - The ELSE Statement 2:45
-
The ELSE Statement - Exercise #1
-
Conditional Statements - The ELIF Statement 5:34
-
The ELIF Statement - Exercise #1
-
The ELIF Statement - Exercise #2
-
Conditional Statements - A Note on Boolean Values 2:13
-
Conditional Statements - A Note on Boolean Values
-
Functions - Defining a Function in Python 2:02
-
Functions - Creating a Function with a Parameter 3:49
-
Creating a Function with a Parameter - Exercise #1
-
Creating a Function with a Parameter - Exercise #2
-
Functions - Another Way to Define a Function 2:36
-
Another Way to Define a Function - Exercise #1
-
Functions - Using a Function in Another Function 1:49
-
Using a Function in Another Function - Exercise #1
-
Functions - Combining Conditional Statements and Functions 3:06
-
Conditional Statements and Functions - Exercise #1
-
Functions - Creating Functions That Contain a Few Arguments 1:17
-
Functions - Notable Built-in Functions in Python 3:56
-
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 4:02
-
Lists - Exercise #1
-
Lists - Exercise #2
-
Lists - Exercise #3
-
Lists - Exercise #4
-
Lists - Exercise #5
-
Sequences - Lists
-
Sequences - Using Methods 3:19
-
Using Methods - Exercise #1
-
Using Methods - Exercise #2
-
Using Methods - Exercise #3
-
Using Methods - Exercise #4
-
Sequences - Using Methods
-
Sequences - List Slicing 4:31
-
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 3:11
-
Tuples - Exercise #1
-
Tuples - Exercise #2
-
Tuples - Exercise #3
-
Tuples - Exercise #4
-
Sequences - Dictionaries 4:04
-
Dictionaries - Exercise #1
-
Dictionaries - Exercise #2
-
Dictionaries - Exercise #3
-
Dictionaries - Exercise #4
-
Dictionaries - Exercise #5
-
Dictionaries - Exercise #6
-
Sequences - Dictionaries
-
Iteration - For Loops 2:56
-
For Loops - Exercise #1
-
For Loops - Exercise #2
-
Iteration - For Loops
-
Iteration - While Loops and Incrementing 2:26
-
While Loops and Incrementing - Exercise #1
-
Iteration - Create Lists with the range() Function 3:49
-
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 3:11
-
Conditional Statements and Loops - Exercise #1
-
Conditional Statements and Loops - Exercise #2
-
Conditional Statements and Loops - Exercise #3
-
Iteration - Conditional Statements, Functions, and Loops 2:27
-
Conditional Statements, Functions, and Loops - Exercise #1
-
Using the Anaconda Assistant: Several Python Tools 5:56
-
Iteration - Iterating over Dictionaries 3:07
-
Iterating over Dictionaries - Exercise #1
-
Iterating over Dictionaries - Exercise #2
-
Using the Anaconda Assistant: Dictionaries 2:22
Chương 5 Fundamentals for Coding in Python 7 bài · 32 phút
-
Object-Oriented Programming (OOP) 5:00
-
Modules, Packages, and the Python Standard Library 4:24
-
Importing Modules 3:24
-
Introduction to Using NumPy and pandas 9:09
-
What is Software Documentation? 3:57
-
The Python Documentation 6:23
-
Practical Python at Work — Four Quick Questions
Chương 6 Mathematics for Python 11 bài · 51 phút
-
What Is а Matrix? 3:37
-
Scalars and Vectors 2:58
-
Linear Algebra and Geometry 3:06
-
Arrays in Python 5:09
-
What Is a Tensor? 3:00
-
Adding and Subtracting Matrices 3:36
-
Errors When Adding Matrices 2:01
-
Transpose 5:13
-
Dot Product of Vectors 3:48
-
Dot Product of Matrices 8:23
-
Why is Linear Algebra Useful 10:10
Chương 7 NumPy Basics 9 bài · 19 phút
-
The NumPy Package and Why We Use It 4:03
-
Installing/Upgrading NumPy 2:01
-
Ndarray 3:06
-
The NumPy Documentation 4:42
-
NumPy Basics - Exercise
-
Python Coding Exercises - Part II 5:35
-
NumPy Basics - Exercise #1
-
NumPy Basics - Exercise #2
-
NumPy Basics - Exercise #3
Chương 8 Pandas - Basics 55 bài · 1 giờ 20 phút
-
Introduction to the pandas Library 5:41
-
Installing and Running pandas 5:57
-
Installing and Running pandas - Exercise #1
-
A Note on Completing the Upcoming Coding Exercises
-
Installing and Running pandas - Exercise #2
-
Introduction to pandas Series 8:41
-
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 5:22
-
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 4:00
-
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 4:31
-
Label-based vs Position-based Indexing - Exercise #1
-
Label-based vs Position-based Indexing - Exercise #2
-
More on Working with Indices in Python 5:37
-
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 4:55
-
Using Methods in Python - Part II 2:36
-
Using Methods in Python - Exercise #1
-
Using Methods in Python - Exercise #2
-
Parameters vs Arguments 4:35
-
Parameters vs Arguments - Exercise #1
-
Parameters vs Arguments - Exercise #2
-
The pandas Documentation 9:54
-
Introduction to pandas DataFrames 5:23
-
Creating DataFrames from Scratch - Part I 5:56
-
Creating DataFrames from Scratch - Exercise #1
-
Creating DataFrames from Scratch - Exercise #2
-
Creating DataFrames from Scratch - Part II 5:03
-
Creating DataFrames from Scratch - Exercise #3
-
Creating DataFrames from Scratch - Exercise #4
-
Creating DataFrames from Scratch - Exercise #5
-
Additional Notes on Using DataFrames 1:58
-
Pandas Basics - Conclusion
Chương 9 Working with Text Files 85 bài · 1 giờ 58 phút
-
Working with Files in Python - An Introduction 3:46
-
File vs File Object, Read vs Parse 2:52
-
Structured vs Semi-Structured and Unstructured Data 3:10
-
Data Connectivity through Text Files 3:06
-
Principles of Importing Data in Python 4:50
-
More on Text Files (*.txt vs *.csv) 4:33
-
Fixed-width Files 1:26
-
Common Naming Conventions Used in Programming 3:49
-
Importing Text Files in Python ( open() ) 9:00
-
Importing Text Files in Python ( open() ) - Exercise #1
-
Importing Text Files in Python ( open() ) - Exercise #2
-
Importing Text Files in Python ( with open() ) 4:53
-
Importing Text Files in Python ( with open() ) - Exercise #1
-
Importing Text Files in Python ( with open() ) - Exercise #2
-
Importing Text Files in Python ( with open() ) - Exercise #3
-
Importing Text Files in Python ( with open() ) - Exercise #4
-
Importing Text Files in Python ( with open() ) - Exercise #5
-
Importing *.csv Files with pandas - Part I 5:35
-
Importing *.csv Files with pandas - Part II 2:37
-
Importing *.csv Files with pandas - Exercise #1
-
Importing *.csv Files with pandas - Exercise #2
-
Importing *.csv Files with pandas - Exercise #3
-
Importing *.csv Files with pandas - Part III 5:57
-
Importing *.csv Files with pandas - Exercise #4
-
Importing *.csv Files with pandas - Exercise #5
-
Importing Data with the "index_col" Parameter 2:35
-
Importing Data with the "index_col" Parameter - Exercise #1
-
Importing Data with the "index_col" Parameter - Exercise #2
-
Importing Data with NumPy - .loadtxt() vs genfromtxt() 10:43
-
Importing Data with NumPy - Exercise #1
-
Importing Data with NumPy - Exercise #2
-
Importing Data with NumPy - Partial Cleaning While Importing 7:21
-
A Note on Using the NumPy .genfromtxt() Function
-
Partial Cleaning While Importing - Exercise #1
-
Partial Cleaning While Importing - Exercise #2
-
Partial Cleaning While Importing - Exercise #3
-
Partial Cleaning While Importing - Exercise #4
-
Importing *.json Files 5:14
-
Importing *.json Files - Exercise #1
-
Importing *.json Files - Exercise #2
-
Importing *.json Files - Exercise #3
-
Importing *.json Files - Exercise #4
-
Importing *.json Files - Exercise #5
-
Importing *.json Files - Exercise #6
-
Importing *.json Files - Exercise #7
-
Importing *.json Files - Exercise #8
-
Importing *.json Files - Exercise #9
-
Prelude to Working with Excel Files in Python 3:40
-
Working with Excel Data (the *.xlsx Format) 1:55
-
Importing Data with NumPy - Exercise
-
A Note on Using NumPy Data Types
-
An Important Exercise on Importing Data in Python 5:44
-
Importing Data in Python - Exercise #1
-
Importing Data in Python - Exercise #2
-
Importing Data in Python - Exercise #3
-
Importing Data in Python - Exercise #4
-
Importing Data with the pandas' "Squeeze" Method 3:23
-
Importing Data with the pandas' "Squeeze" Method - Exercise #1
-
Importing Data with the pandas' "Squeeze" Method - Exercise #2
-
Importing Data with the pandas' "Squeeze" Method - Exercise #3
-
Importing Data with the pandas' "Squeeze" Method - Exercise #4
-
Importing Data with the pandas' "Squeeze" Method - Exercise #5
-
Importing Data with the pandas' "Squeeze" Method - Exercise #6
-
Importing Data with the pandas' "Squeeze" Method - Exercise #7
-
Importing Data with the pandas' "Squeeze" Method - Exercise #8
-
Importing Data with the pandas' "Squeeze" Method - Exercise #9
-
Importing Data with the pandas' "Squeeze" Method - Exercise #10
-
Importing Data with the pandas' "Squeeze" Method - Exercise #11
-
Importing Data with the pandas' "Squeeze" Method - Exercise #12
-
Importing Data with the pandas' "Squeeze" Method - Exercise #13
-
Importing Data with the pandas' "Squeeze" Method - Exercise #14
-
A Note on Importing Files in Jupyter 3:10
-
A Note on Importing Files in Jupyter - Exercise #1
-
Saving Your Data with pandas 3:11
-
Saving your Data with pandas - Exercise #1
-
Saving your Data with pandas - Exercise #2
-
Saving your Data with pandas - Exercise #3
-
Saving Your Data with NumPy - np.save() 5:23
-
Saving Your Data with NumPy - np.save() - Exercise #1
-
Saving Your Data with NumPy - np.savez() 5:12
-
Saving Your Data with NumPy - np.savez() - Exercise #1
-
Saving Your Data with NumPy - np.savetxt() 3:58
-
Saving Your Data with NumPy - np.savetxt() - Exercise #1
-
Saving Your Data with NumPy - Exercise
-
Working with Text Files - Conclusion 0:42
Chương 10 Working with Text Data 44 bài · 41 phút
-
Working with Text Data and Argument Specifiers 9:18
-
Text Data and Argument Specifiers - Exercise #1
-
Text Data and Argument Specifiers - Exercise #2
-
Text Data and Argument Specifiers - Exercise #3
-
Manipulating Python Strings 4:13
-
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 6:51
-
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 6:44
-
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 4:49
-
String Accessors - Exercise #1
-
String Accessors - Exercise #2
-
String Accessors - Exercise #3
-
String Accessors - Exercise #4
-
String Accessors - Exercise #5
-
Using the .format() Method 9:02
-
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
Chương 11 Must-Know Python Tools 21 bài · 31 phút
-
Iterating Over Range Objects 4:17
-
Nested For Loops - Introduction 5:59
-
Triple Nested For Loops 5:37
-
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 8:30
-
List Comprehensions - Exercise #1
-
List Comprehensions - Exercise #2
-
List Comprehensions - Exercise #3
-
List Comprehensions - Exercise #4
-
List Comprehensions - Exercise #5
-
Anonymous (Lambda) Functions 7:00
-
Anonymous Functions - Exercise #1
-
Anonymous Functions - Exercise #2
-
Anonymous Functions - Exercise #3
-
Anonymous Functions - Exercise #4
Chương 12 Data Gathering/Data Collection 1 bài · 7 phút
-
What is data gathering/data collection? 6:32
Chương 13 APIs (POST requests are not needed for this course) 11 bài · 34 phút
-
Overview of APIs 3:10
-
GET and POST Requests 2:35
-
Data Exchange Format for APIs: JSON 2:24
-
Introducing the Exchange Rates API 6:00
-
Including Parameters in a GET Request 4:31
-
More Functionalities of the Exchange Rates API 4:37
-
Coding a Simple Currency Conversion Calculator 4:57
-
ITunes API 4:12
-
ITunes API: Homework
-
ITunes API: Structuring and Exporting the Data 1:59
-
APIs: Exercise
Chương 14 Data Cleaning and Data Preprocessing 1 bài · 5 phút
-
Data Cleaning and Data Preprocessing 5:27
Chương 15 Pandas Series 26 bài · 22 phút
-
Running pandas - Exercise #1
-
.unique(), .nunique() 3:49
-
.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 5:29
-
.sort_values() 3:58
-
.sort_values() - Exercise #1
-
.sort_values() - Exercise #2
-
.sort_values() - Exercise #3
-
.sort_values() - Exercise #4
-
Attribute and Method Chaining 4:21
-
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() 3:59
-
.sort_index - Exercise #1
-
.sort_index - Exercise #2
-
.sort_index - Exercise #3
-
.sort_index - Exercise #4
Chương 16 Pandas DataFrames 54 bài · 43 phút
-
A Revision to pandas DataFrames 5:05
-
A Revision to pandas DataFrames - Exercise #0
-
A Revision to pandas DataFrames - Exercise #1
-
A Revision to pandas DataFrames - Exercise #2
-
A Revision to pandas DataFrames - Exercise #3
-
A Revision to pandas DataFrames - Exercise #4
-
A Revision to pandas DataFrames - Exercise #5
-
Using the Anaconda Assistant: Importing Data with pandas 4:41
-
Common Attributes for Working with DataFrames 4:15
-
Common Attributes for Working with DataFrames - Exercise #1
-
Common Attributes for Working with DataFrames - Exercise #2
-
Common Attributes for Working with DataFrames - Exercise #3
-
Common Attributes for Working with DataFrames - Exercise #4
-
Common Attributes for Working with DataFrames - Exercise #5
-
Common Attributes for Working with DataFrames - Exercise #6
-
Common Attributes for Working with DataFrames - Exercise #7
-
Common Attributes for Working with DataFrames - Exercise #8
-
Common Attributes for Working with DataFrames - Exercise #9
-
Common Attributes for Working with DataFrames - Exercise #10
-
Common Attributes for Working with DataFrames - Exercise #11
-
Common Attributes for Working with DataFrames - Exercise #12
-
Common Attributes for Working with DataFrames - Exercise #13
-
Data Selection in pandas DataFrames 6:55
-
Data Selection in pandas DataFrames - Exercise #1
-
Data Selection in pandas DataFrames - Exercise #2
-
Data Selection in pandas DataFrames - Exercise #3
-
Data Selection in pandas DataFrames - Exercise #4
-
Data Selection in pandas DataFrames - Exercise #5
-
Data Selection in pandas DataFrames - Exercise #6
-
Data Selection in pandas DataFrames - Exercise #7
-
Data Selection in pandas DataFrames - Exercise #8
-
Data Selection in pandas DataFrames - Exercise #9
-
Data Selection in pandas DataFrames - Exercise #10
-
Data Selection - Indexing with .iloc[] 5:56
-
Data Selection - Indexing with .iloc[] - Exercise #1
-
Data Selection - Indexing with .iloc[] - Exercise #2
-
Data Selection - Indexing with .iloc[] - Exercise #3
-
Data Selection - Indexing with .iloc[] - Exercise #4
-
Data Selection - Indexing with .iloc[] - Exercise #5
-
Data Selection - Indexing with .iloc[] - Exercise #6
-
Data Selection - Indexing with .iloc[] - Exercise #7
-
Data Selection - Indexing with .iloc[] - Exercise #8
-
Data Selection - Indexing with .loc[] 4:01
-
Data Selection - Indexing with .loc[] - Exercise #1
-
Data Selection - Indexing with .loc[] - Exercise #2
-
Data Selection - Indexing with .loc[] - Exercise #3
-
Data Selection - Indexing with .loc[] - Exercise #4
-
Data Selection - Indexing with .loc[] - Exercise #5
-
A Few Comments on Using .loc[] and .iloc[] 11:40
-
A Few Comments on Using .loc[] and .iloc[] - Exercise #1
-
A Few Comments on Using .loc[] and .iloc[] - Exercise #2
-
A Few Comments on Using .loc[] and .iloc[] - Exercise #3
-
A Few Comments on Using .loc[] and .iloc[] - Exercise #4
-
A Few Comments on Using .loc[] and .iloc[] - Exercise #5
Chương 17 NumPy Fundamentals 17 bài · 29 phút
-
Indexing in NumPy 5:51
-
Indexing in NumPy - Exercise #1
-
Indexing in NumPy - Exercise #2
-
Indexing in NumPy - Exercise #3
-
Assigning Values in NumPy 4:16
-
Assigning Values in NumPy - Exercise #1
-
Assigning Values in NumPy - Exercise #2
-
Elementwise Properties of Arrays 4:29
-
Elementwise Properties of Arrays - Exercise #1
-
Elementwise Properties of Arrays - Exercise #2
-
Types of Data Supported by NumPy 5:56
-
Types of Data Supported by NumPy - Exercise #1
-
Characteristics of NumPy Functions Part 1 4:43
-
Characteristics of NumPy Functions - Exercise #1
-
Characteristics of NumPy Functions Part 2 3:30
-
Characteristics of NumPy Functions - Exercise #2
-
NumPy Fundamentals - Exercise
Chương 18 NumPy DataTypes 4 bài · 24 phút
-
Ndarrays 9:52
-
Arrays vs Lists 6:55
-
Strings vs Object vs Number 7:14
-
NumPy DataTypes - Exercise
Chương 19 Working with Arrays 13 bài · 27 phút
-
Basic Slicing in NumPy 10:04
-
Slicing in NumPy - Exercise #1
-
Stepwise Slicing in NumPy 4:58
-
Slicing in NumPy - Exercise #2
-
Conditional Slicing in NumPy 4:51
-
Slicing in NumPy - Exercise #3
-
Slicing in NumPy - Exercise #4
-
Slicing in NumPy - Exercise #5
-
Slicing in NumPy - Exercise #6
-
Dimensions and the Squeeze Function 6:52
-
Dimensions and the Squeeze Function - Exercise #1
-
Dimensions and the Squeeze Function - Exercise #2
-
Working with Arrays - Exercise
Chương 20 Generating Data with NumPy 17 bài · 33 phút
-
Arrays of 0s and 1s 5:32
-
NumPy - Arrays of 0s and 1s - Exercise #1
-
"_like" functions in NumPy 3:13
-
"_like" functions in NumPy - Exercise #1
-
A Non-Random Sequence of Numbers 5:02
-
NumPy - A Non-Random Sequence of Numbers - Exercise #1
-
Random Generators and Seeds 5:21
-
NumPy - Random Generators and Seeds - Exercise #1
-
Basic Random Functions in NumPy 3:56
-
Basic Random Functions in NumPy - Exercise #1
-
Basic Random Functions in NumPy - Exercise #2
-
Basic Random Functions in NumPy - Exercise #3
-
Basic Random Functions in NumPy - Exercise #4
-
Probability Distributions in NumPy 5:19
-
Probability Distributions in NumPy - Exercise #1
-
Applications of Random Data in NumPy 4:09
-
Generating Data with NumPy - Exercise
Chương 21 Statistics with NumPy 15 bài · 42 phút
-
Using Statistical Functions in NumPy 7:44
-
Minimal and Maximal Values in NumPy 6:02
-
Minimal and Maximal Values in NumPy - Exercise #1
-
Statistical Order Functions in NumPy 6:25
-
Statistical Order Functions in NumPy - Exercise #1
-
Statistical Order Functions in NumPy - Exercise #2
-
Averages and Variance in NumPy 4:17
-
Covariance and Correlation in NumPy 2:59
-
Statistical Functions in NumPy - Exercise #1
-
Histograms in NumPy (Part 1) 7:36
-
Histograms in NumPy (Part 2) 4:15
-
Histograms in NumPy - Exercise #1
-
NAN Equivalent Functions in NumPy 3:08
-
NAN Equivalent Functions in NumPy - Exercise #1
-
Statistics with NumPy - Exercise
Chương 22 NumPy - Preprocessing 13 bài · 1 giờ 35 phút
-
Checking for Missing Values in Ndarrays 9:23
-
Substituting Missing Values in Ndarrays 8:29
-
Reshaping Ndarrays 6:31
-
Removing Values from Ndarrays 4:20
-
Sorting Ndarrays 9:45
-
Argument Sort in NumPy 5:48
-
Argument Where in NumPy 11:12
-
Shuffling Ndarrays 6:51
-
Casting Ndarrays 6:14
-
Striping Values from Ndarrays 4:43
-
Stacking Ndarrays 10:31
-
Concatenating Ndarrays 6:27
-
Finding Unique Values in Ndarrays 5:04
Chương 23 A Loan Data Example with NumPy 15 bài · 1 giờ 28 phút
-
Setting Up: Introduction to the Practical Example 4:50
-
Setting Up: Importing the Data Set 4:10
-
Setting Up: Checking for Incomplete Data 4:35
-
Setting Up: Splitting the Dataset 5:27
-
Setting Up: Creating Checkpoints 2:50
-
Manipulating Text Data: Issue Date 5:26
-
Manipulating Text Data: Loan Status and Term 7:08
-
Manipulating Text Data: Grade and Sub Grade 8:54
-
Manipulating Text Data: Verification Status & URL 5:20
-
Manipulating Text Data: State Address 6:01
-
Manipulating Text Data: Converting Strings and Creating a Checkpoint 3:28
-
Manipulating Numeric Data: Substitute Filler Values 7:51
-
Manipulating Numeric Data: Currency Change – The Exchange Rate 6:32
-
Manipulating Numeric Data: Currency Change - From USD to EUR 8:22
-
Completing the Dataset 6:46
Chương 24 The "Absenteeism" Exercise - Introduction 3 bài · 5 phút
-
An Introduction to the "Absenteeism" Exercise 1:11
-
The "Absenteeism" Exercise from a Business Perspective 2:19
-
The Dataset 1:34
Chương 25 Solution to the "Absenteeism" Exercise 20 bài · 1 giờ 18 phút
-
How to Complete the Absenteeism Exercise 1:57
-
Eyeball Your Data First 5:53
-
Note: Programming vs the Rest of the World 3:27
-
A Summary of Regression Analysis
-
Using a Statistical Approach to Solve Our Exercise 2:17
-
Dropping the 'ID' Column 6:27
-
Analysis of the 'Reason for Absence' Column 5:04
-
Splitting the Reasons for Absence into Multiple Dummy Variables 8:37
-
How to Drop a Dummy Variable
-
Working with Dummy Variables - A Statistical Perspective 1:28
-
Grouping the Reason for Absence Columns 8:35
-
Concatenating Columns in a pandas DataFrame 4:35
-
Reordering Columns in a DataFrame 1:43
-
Creating Checkpoints
-
Working on the 'Date' Column 7:49
-
Extracting the Month Value from the 'Date' Column 7:00
-
Creating the 'Day of the Week' Column 3:36
-
Understanding the Meaning of 5 More Columns 3:17
-
Modifying the 'Education' Column 4:38
-
Final Remarks on the Absenteeism Exercise 1:40
Chương 26 Data Visualization 37 bài · 2 giờ 54 phút
-
What Is Data Visualization and Why Is It Important? 4:31
-
Why Learn Data Visualization? 6:08
-
Choosing the Right Visualization – What Are Some Popular Approaches and Framewor 6:58
-
Introduction into Colors and Color Theory 8:56
-
Bar Chart - Introduction - General Theory and Getting to Know the Dataset 1:29
-
Bar Chart - How to Create a Bar Chart Using Python 11:27
-
Bar Chart – Interpreting the Bar Graph. How to Make a Good Bar Graph 2:50
-
Pie Chart - Introduction - General Theory and Dataset 4:04
-
Pie Chart - How to Create a Pie Chart Using Python 6:39
-
Pie Chart – Interpreting the Pie Chart 1:32
-
Pie Chart - Why You Should Never Create a Pie Graph 7:32
-
Stacked Area Chart - Introduction - General Theory. Getting to Know the Dataset 3:16
-
Stacked Area Chart - How to Create a Stacked Area Chart Using Python 7:48
-
Stacked Area Chart - Interpreting the Stacked Area Graph 2:30
-
Stacked Area Chart - How to Make a Good Stacked Area Chart 3:52
-
Line Chart - Introduction - General Theory. Getting to Know the Dataset 2:03
-
Line Chart - How to Create a Line Chart in Python 8:05
-
Line Chart - Interpretation 3:11
-
Line Chart - How to Make a Good Line Chart 6:30
-
Histogram - Introduction - General Theory. Getting to Know the Dataset 4:39
-
Histogram - How to Create a Histogram Using Python 5:43
-
Histogram – Interpreting the Histogram 2:11
-
Histogram – Choosing the Number of Bins in a Histogram 5:28
-
Histogram - How to Make a Good Histogram 4:43
-
Scatter Plot - Introduction - General Theory. Getting to Know the Dataset 2:29
-
Scatter Plot - How to Create a Scatter Plot Using Python 8:39
-
Scatter Plot – Interpreting the Scatter Plot 2:42
-
Scatter Plot - How to Make a Good Scatter Plot 2:56
-
Regression Plot - Introduction - General Theory. Getting to Know the Dataset 3:03
-
Regression Plot - How to Create a Regression Scatter Plot Using Python 7:08
-
Regression Plot – Interpreting the Regression Scatter Plot 4:36
-
Regression Plot - How to Make a Good Regression Plot 3:14
-
Bar and Line Chart - Introduction - General Theory. Getting to Know the Dataset 3:10
-
Bar and Line Chart - How to Create a Combination Bar and Line Graph Using Python 7:39
-
Bar and Line Chart – Interpreting the Combination Bar and Line Graph 2:36
-
Bar and Line Chart – How to Make a Good Bar and Line Graph 4:04
-
Data Visualization - Exercise
Chương 27 Conclusion 2 bài · 2 phút
-
Conclusion 2:22
-
Bonus
Requirment
-
No prior experience is required. We will start from the very basics
-
You’ll need to install Anaconda. We will show you how to do that step by step
Outcomes
-
The course provides the complete preparation you need to become a data analyst
-
Fill up your resume with in-demand data skills: Python programming, NumPy, pandas, data preparation - data collection, data cleaning, data preprocessing, data visualization; data analysis, data analytics
-
Acquire a big picture understanding of the data analyst role
-
Learn beginner and advanced Python
-
Study mathematics for Python
-
We will teach you NumPy and pandas, basics and advanced
-
Be able to work with text files
-
Understand different data types and their memory usage
-
Learn how to obtain interesting, real-time information from an API with a simple script
-
Clean data with pandas Series and DataFrames
-
Complete a data cleaning exercise on absenteeism rate
-
Expand your knowledge of NumPy – statistics and preprocessing
-
Go through a complete loan data case study and apply your NumPy skills
-
Master data visualization
-
Learn how to create pie, bar, line, area, histogram, scatter, regression, and combo charts
-
Engage with coding exercises that will prepare you for the job
-
Practice with real-world data
-
Solve a final capstone project
0 Student
9 Courses
0 review