Mô tả

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.

Bạn sẽ học được gì

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

Yêu cầu

  • 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

Nội dung khoá học

27 sections

Introduction to the Course

4 lectures
A Practical Example - What Will You Learn in This Course?
04:46
What Does the Course Cover?
05:36
Download All Resources
00:15
FAQ
10:29

Introduction to Data Analytics

5 lectures
Introduction to the World of Business and Data
02:26
Relevant Terms Explained
05:45
Data Analyst Compared to Other Data Jobs
02:27
Data Analyst Job Description
05:42
Why Python
05:42

Setting up the Environment

11 lectures
Introduction
01:24
Programming Explained in a Few Minutes
05:04
Programming Explained in a Few Minutes
2 questions
Jupyter - Introduction
03:29
Jupyter - Installing Anaconda
04:00
Jupyter - Intro to Using Jupyter
03:10
Jupyter - Working with Notebook Files
06:09
Jupyter - Using Shortcuts
03:07
Jupyter - Handling Error Messages
05:52
Jupyter - Restarting the Kernel
02:17
Jupyter - Introduction
5 questions

Python Basics

151 lectures
Python Variables
03:37
Python Variables - Exercise #1
1 question
Python Variables - Exercise #2
1 question
Python Variables - Exercise #3
1 question
Python Variables - Exercise #4
1 question
Python Variables
1 question
Types of Data - Numbers and Boolean Values
03:05
Numbers and Boolean Values - Exercise #1
1 question
Numbers and Boolean Values - Exercise #2
1 question
Numbers and Boolean Values - Exercise #3
1 question
Numbers and Boolean Values - Exercise #4
1 question
Numbers and Boolean Values - Exercise #5
1 question
Types of Data - Numbers and Boolean Values
1 question
Types of Data - Strings
05:40
Strings - Exercise #1
1 question
Strings - Exercise #2
1 question
Strings - Exercise #3
1 question
Strings - Exercise #4
1 question
Strings - Exercise #5
1 question
Types of Data - Strings
2 questions
Basic Python Syntax - Arithmetic Operators
03:23
Arithmetic Operators - Exercise #1
1 question
Arithmetic Operators - Exercise #2
1 question
Arithmetic Operators - Exercise #3
1 question
Arithmetic Operators - Exercise #4
1 question
Arithmetic Operators - Exercise #5
1 question
Arithmetic Operators - Exercise #6
1 question
Arithmetic Operators - Exercise #7
1 question
Arithmetic Operators - Exercise #8
1 question
Basic Python Syntax - Arithmetic Operators
1 question
Basic Python Syntax - The Double Equality Sign
01:33
The Double Equality Sign - Exercise #1
1 question
Basic Python Syntax - The Double Equality Sign
1 question
Basic Python Syntax - Reassign Values
01:08
Reassign Values - Exercise #1
1 question
Reassign Values - Exercise #2
1 question
Reassign Values - Exercise #3
1 question
Reassign Values - Exercise #4
1 question
Basic Python Syntax - Reassign Values
1 question
Basic Python Syntax - Add Comments
01:34
Basic Python Syntax - Add Comments
1 question
Basic Python Syntax - Line Continuation
00:49
Line Continuation - Exercise #1
1 question
Basic Python Syntax - Indexing Elements
01:18
Indexing Elements - Exercise #1
1 question
Indexing Elements - Exercise #2
1 question
Basic Python Syntax - Indexing Elements
1 question
Basic Python Syntax - Indentation
01:44
Indentation - Exercise #1
1 question
Basic Python Syntax - Indentation
1 question
Operators - Comparison Operators
02:10
Comparison Operators - Exercise #1
1 question
Comparison Operators - Exercise #2
1 question
Comparison Operators - Exercise #3
1 question
Comparison Operators - Exercise #4
1 question
Operators - Comparison Operators
2 questions
Operators - Logical and Identity Operators
05:35
Logical and Identity Operators - Exercise #1
1 question
Logical and Identity Operators - Exercise #2
1 question
Logical and Identity Operators - Exercise #3
1 question
Logical and Identity Operators - Exercise #4
1 question
Logical and Identity Operators - Exercise #5
1 question
Logical and Identity Operators - Exercise #6
1 question
Operators - Logical and Identity Operators
2 questions
Conditional Statements - The IF Statement
03:01
The IF Statement - Exercise #1
1 question
The IF Statement - Exercise #2
1 question
Conditional Statements - The IF Statement
1 question
Conditional Statements - The ELSE Statement
02:45
The ELSE Statement - Exercise #1
1 question
Conditional Statements - The ELIF Statement
05:34
The ELIF Statement - Exercise #1
1 question
The ELIF Statement - Exercise #2
1 question
Conditional Statements - A Note on Boolean Values
02:13
Conditional Statements - A Note on Boolean Values
1 question
Functions - Defining a Function in Python
02:02
Functions - Creating a Function with a Parameter
03:49
Creating a Function with a Parameter - Exercise #1
1 question
Creating a Function with a Parameter - Exercise #2
1 question
Functions - Another Way to Define a Function
02:36
Another Way to Define a Function - Exercise #1
1 question
Functions - Using a Function in Another Function
01:49
Using a Function in Another Function - Exercise #1
1 question
Functions - Combining Conditional Statements and Functions
03:06
Conditional Statements and Functions - Exercise #1
1 question
Functions - Creating Functions That Contain a Few Arguments
01:17
Functions - Notable Built-in Functions in Python
03:56
Notable Built-In Functions in Python - Exercise #1
1 question
Notable Built-In Functions in Python - Exercise #2
1 question
Notable Built-In Functions in Python - Exercise #3
1 question
Notable Built-In Functions in Python - Exercise #4
1 question
Notable Built-In Functions in Python - Exercise #5
1 question
Notable Built-In Functions in Python - Exercise #6
1 question
Notable Built-In Functions in Python - Exercise #7
1 question
Notable Built-In Functions in Python - Exercise #8
1 question
Notable Built-In Functions in Python - Exercise #9
1 question
Functions
1 question
Sequences - Lists
04:02
Lists - Exercise #1
1 question
Lists - Exercise #2
1 question
Lists - Exercise #3
1 question
Lists - Exercise #4
1 question
Lists - Exercise #5
1 question
Sequences - Lists
1 question
Sequences - Using Methods
03:19
Using Methods - Exercise #1
1 question
Using Methods - Exercise #2
1 question
Using Methods - Exercise #3
1 question
Using Methods - Exercise #4
1 question
Sequences - Using Methods
1 question
Sequences - List Slicing
04:31
List Slicing - Exercise #1
1 question
List Slicing - Exercise #2
1 question
List Slicing - Exercise #3
1 question
List Slicing - Exercise #4
1 question
List Slicing - Exercise #5
1 question
List Slicing - Exercise #6
1 question
List Slicing - Exercise #7
1 question
Sequences - Tuples
03:11
Tuples - Exercise #1
1 question
Tuples - Exercise #2
1 question
Tuples - Exercise #3
1 question
Tuples - Exercise #4
1 question
Sequences - Dictionaries
04:04
Dictionaries - Exercise #1
1 question
Dictionaries - Exercise #2
1 question
Dictionaries - Exercise #3
1 question
Dictionaries - Exercise #4
1 question
Dictionaries - Exercise #5
1 question
Dictionaries - Exercise #6
1 question
Sequences - Dictionaries
1 question
Iteration - For Loops
02:56
For Loops - Exercise #1
1 question
For Loops - Exercise #2
1 question
Iteration - For Loops
1 question
Iteration - While Loops and Incrementing
02:26
While Loops and Incrementing - Exercise #1
1 question
Iteration - Create Lists with the range() Function
03:49
Create Lists with the range() Function - Exercise #1
1 question
Create Lists with the range() Function - Exercise #2
1 question
Create Lists with the range() Function - Exercise #3
1 question
Iteration - Create Lists with the range() Function
1 question
Iteration - Use Conditional Statements and Loops Together
03:11
Conditional Statements and Loops - Exercise #1
1 question
Conditional Statements and Loops - Exercise #2
1 question
Conditional Statements and Loops - Exercise #3
1 question
Iteration - Conditional Statements, Functions, and Loops
02:27
Conditional Statements, Functions, and Loops - Exercise #1
1 question
Iteration - Iterating over Dictionaries
03:07
Iterating over Dictionaries - Exercise #1
1 question
Iterating over Dictionaries - Exercise #2
1 question

Fundamentals for Coding in Python

6 lectures
Object-Oriented Programming (OOP)
05:00
Modules, Packages, and the Python Standard Library
04:24
Importing Modules
03:24
Introduction to Using NumPy and pandas
09:09
What is Software Documentation?
03:57
The Python Documentation
06:23

Mathematics for Python

11 lectures
What Is а Matrix?
03:37
Scalars and Vectors
02:58
Linear Algebra and Geometry
03:06
Arrays in Python
05:09
What Is a Tensor?
03:00
Adding and Subtracting Matrices
03:36
Errors When Adding Matrices
02:01
Transpose
05:13
Dot Product of Vectors
03:48
Dot Product of Matrices
08:23
Why is Linear Algebra Useful
10:10

NumPy Basics

5 lectures
The NumPy Package and Why We Use It
04:03
Installing/Upgrading NumPy
02:01
Ndarray
03:06
The NumPy Documentation
04:42
NumPy Basics - Exercise
00:15

Pandas - Basics

55 lectures
Introduction to the pandas Library
05:41
Installing and Running pandas
05:57
Installing and Running pandas - Exercise #1
1 question
A Note on Completing the Upcoming Coding Exercises
01:22
Installing and Running pandas - Exercise #2
1 question
Introduction to pandas Series
08:41
Introduction to pandas Series - Exercise #1
1 question
Introduction to pandas Series - Exercise #2
1 question
Introduction to pandas Series - Exercise #3
1 question
Introduction to pandas Series - Exercise #4
1 question
Introduction to pandas Series - Exercise #5
1 question
Introduction to pandas Series - Exercise #6
1 question
Introduction to pandas Series - Exercise #7
1 question
Introduction to pandas Series - Exercise #8
1 question
Introduction to pandas Series - Exercise #9
1 question
Introduction to pandas Series - Exercise #10
1 question
Working with Attributes in Python
05:22
Working with Attributes in Python - Exercise #1
1 question
Working with Attributes in Python - Exercise #2
1 question
Working with Attributes in Python - Exercise #3
1 question
Working with Attributes in Python - Exercise #4
1 question
Working with Attributes in Python - Exercise #5
1 question
Working with Attributes in Python - Exercise #6
1 question
Working with Attributes in Python - Exercise #7
1 question
Using an Index in pandas
04:00
Using an Index in pandas - Exercise #1
1 question
Using an Index in pandas - Exercise #2
1 question
Using an Index in pandas - Exercise #3
1 question
Using an Index in pandas - Exercise #4
1 question
Using an Index in pandas - Exercise #5
1 question
Label-based vs Position-based Indexing
04:31
Label-based vs Position-based Indexing - Exercise #1
1 question
Label-based vs Position-based Indexing - Exercise #2
1 question
More on Working with Indices in Python
05:37
More on Working with Indices in Python - Exercise #3
1 question
More on Working with Indices in Python - Exercise #4
1 question
More on Working with Indices in Python - Exercise #5
1 question
Using Methods in Python - Part I
04:55
Using Methods in Python - Part II
02:36
Using Methods in Python - Exercise #1
1 question
Using Methods in Python - Exercise #2
1 question
Parameters vs Arguments
04:35
Parameters vs Arguments - Exercise #1
1 question
Parameters vs Arguments - Exercise #2
1 question
The pandas Documentation
09:54
Introduction to pandas DataFrames
05:23
Creating DataFrames from Scratch - Part I
05:56
Creating DataFrames from Scratch - Exercise #1
1 question
Creating DataFrames from Scratch - Exercise #2
1 question
Creating DataFrames from Scratch - Part II
05:03
Creating DataFrames from Scratch - Exercise #3
1 question
Creating DataFrames from Scratch - Exercise #4
1 question
Creating DataFrames from Scratch - Exercise #5
1 question
Additional Notes on Using DataFrames
01:58
pandas Basics - Conclusion
00:44

Working with Text Files

29 lectures
Working with Files in Python - An Introduction
03:46
File vs File Object, Read vs Parse
02:52
Structured vs Semi-Structured and Unstructured Data
03:10
Data Connectivity through Text Files
03:06
Principles of Importing Data in Python
04:50
More on Text Files (*.txt vs *.csv)
04:33
Fixed-width Files
01:26
Common Naming Conventions Used in Programming
03:49
Importing Text Files in Python ( open() )
09:00
Importing Text Files in Python ( with open() )
04:53
Importing *.csv Files with pandas - Part I
05:35
Importing *.csv Files with pandas - Part II
02:37
Importing *.csv Files with pandas - Part III
05:57
Importing Data with the "index_col" Parameter
02:35
Importing Data with NumPy - .loadtxt() vs genfromtxt()
10:43
Importing Data with NumPy - Partial Cleaning While Importing
07:21
Importing Data with NumPy - Exercise
00:15
Importing *.json Files
05:14
Prelude to Working with Excel Files in Python
03:40
Working with Excel Data (the *.xlsx Format)
01:55
An Important Exercise on Importing Data in Python
05:44
Importing Data with the pandas' "Squeeze" Method
03:23
A Note on Importing Files in Jupyter
03:10
Saving Your Data with pandas
03:11
Saving Your Data with NumPy - np.save()
05:23
Saving Your Data with NumPy - np.savez()
05:12
Saving Your Data with NumPy - np.savetxt()
03:58
Saving Your Data with NumPy - Exercise
00:15
Working with Text Files - Conclusion
00:42

Working with Text Data

44 lectures
Working with Text Data and Argument Specifiers
09:18
Text Data and Argument Specifiers - Exercise #1
1 question
Text Data and Argument Specifiers - Exercise #2
1 question
Text Data and Argument Specifiers - Exercise #3
1 question
Manipulating Python Strings
04:13
Manipulating Python Strings - Exercise #1
1 question
Manipulating Python Strings - Exercise #2
1 question
Manipulating Python Strings - Exercise #3
1 question
Manipulating Python Strings - Exercise #4
1 question
Manipulating Python Strings - Exercise #5
1 question
Using Various Python String Methods - Part I
06:51
Python String Methods - Exercise #1
1 question
Python String Methods - Exercise #2
1 question
Python String Methods - Exercise #3
1 question
Python String Methods - Exercise #4
1 question
Python String Methods - Exercise #5
1 question
Python String Methods - Exercise #6
1 question
Python String Methods - Exercise #7
1 question
Python String Methods - Exercise #8
1 question
Python String Methods - Exercise #9
1 question
Python String Methods - Exercise #10
1 question
Python String Methods - Exercise #11
1 question
Python String Methods - Exercise #12
1 question
Python String Methods - Exercise #13
1 question
Python String Methods - Exercise #14
1 question
Python String Methods - Exercise #15
1 question
Using Various Python String Methods - Part II
06:44
Python String Methods - Exercise #16
1 question
Python String Methods - Exercise #17
1 question
Python String Methods - Exercise #18
1 question
Python String Methods - Exercise #19
1 question
Python String Methods - Exercise #20
1 question
String Accessors
04:49
String Accessors - Exercise #1
1 question
String Accessors - Exercise #2
1 question
String Accessors - Exercise #3
1 question
String Accessors - Exercise #4
1 question
String Accessors - Exercise #5
1 question
Using the .format() Method
09:02
Using the .format() Method - Exercise #1
1 question
Using the .format() Method - Exercise #2
1 question
Using the .format() Method - Exercise #3
1 question
Using the .format() Method - Exercise #4
1 question
Using the .format() Method - Exercise #5
1 question

Must-Know Python Tools

21 lectures
Iterating Over Range Objects
04:17
Nested For Loops - Introduction
05:59
Triple Nested For Loops
05:37
Triple Nested For Loops - Exercise #1
1 question
Triple Nested For Loops - Exercise #2
1 question
Triple Nested For Loops - Exercise #3
1 question
Triple Nested For Loops - Exercise #4
1 question
Triple Nested For Loops - Exercise #5
1 question
Triple Nested For Loops - Exercise #6
1 question
Triple Nested For Loops - Exercise #7
1 question
List Comprehensions
08:30
List Comprehensions - Exercise #1
1 question
List Comprehensions - Exercise #2
1 question
List Comprehensions - Exercise #3
1 question
List Comprehensions - Exercise #4
1 question
List Comprehensions - Exercise #5
1 question
Anonymous (Lambda) Functions
07:00
Anonymous Functions - Exercise #1
1 question
Anonymous Functions - Exercise #2
1 question
Anonymous Functions - Exercise #3
1 question
Anonymous Functions - Exercise #4
1 question

Data Gathering/Data Collection

1 lectures
What is data gathering/data collection?
06:32

APIs (POST requests are not needed for this course)

12 lectures
Overview of APIs
03:10
GET and POST Requests
02:35
Data Exchange Format for APIs: JSON
02:24
Introducing the Exchange Rates API
04:57
Including Parameters in a GET Request
03:18
More Functionalities of the Exchange Rates API
04:39
Coding a Simple Currency Conversion Calculator
04:52
iTunes API
04:41
iTunes API: Homework
00:12
iTunes API: Structuring and Exporting the Data
02:10
Pagination: GitHub API
04:21
APIs: Exercise
00:14

Data Cleaning and Data Preprocessing

1 lectures
Data Cleaning and Data Preprocessing
05:27

pandas Series

26 lectures
Running pandas - Exercise
1 question
.unique(), .nunique()
03:49
.unique(), .nunique() - Exercise #1
1 question
.unique(), .nunique() - Exercise #2
1 question
.unique(), .nunique() - Exercise #3
1 question
.unique(), .nunique() - Exercise #4
1 question
.unique(), .nunique() - Exercise #5
1 question
.unique(), .nunique() - Exercise #6
1 question
Converting Series into Arrays
05:29
.sort_values()
03:58
.sort_values() - Exercise #1
1 question
.sort_values() - Exercise #2
1 question
.sort_values() - Exercise #3
1 question
.sort_values() - Exercise #4
1 question
Attribute and Method Chaining
04:21
Attribute and Method Chaining - Exercise #1
1 question
Attribute and Method Chaining - Exercise #2
1 question
Attribute and Method Chaining - Exercise #3
1 question
Attribute and Method Chaining - Exercise #4
1 question
Attribute and Method Chaining - Exercise #5
1 question
Attribute and Method Chaining - Exercise #6
1 question
.sort_index()
03:59
.sort_index - Exercise #1
1 question
.sort_index - Exercise #2
1 question
.sort_index - Exercise #3
1 question
.sort_index - Exercise #4
1 question

pandas DataFrames

6 lectures
A Revision to pandas DataFrames
05:05
Common Attributes for Working with DataFrames
04:15
Data Selection in pandas DataFrames
06:55
Data Selection - Indexing with .iloc[]
05:56
Data Selection - Indexing with .loc[]
04:01
A Few Comments on Using .loc[] and .iloc[]
11:40

NumPy Fundamentals

7 lectures
Indexing in NumPy
05:51
Assigning Values in NumPy
04:16
Elementwise Properties of Arrays
04:29
Types of Data Supported by NumPy
05:56
Characteristics of NumPy Functions Part 1
04:43
Characteristics of NumPy Functions Part 2
03:30
NumPy Fundamentals - Exercise
00:14

NumPy DataTypes

4 lectures
ndarrays
09:52
Arrays vs Lists
06:55
Strings vs Object vs Number
07:14
NumPy DataTypes - Exercise
00:14

Working with Arrays

5 lectures
Basic Slicing in NumPy
10:04
Stepwise Slicing in NumPy
04:58
Conditional Slicing in NumPy
04:51
Dimensions and the Squeeze Function
06:52
Working with Arrays - Exercise
00:15

Generating Data with NumPy

8 lectures
Arrays of 0s and 1s
05:32
"_like" functions in NumPy
03:13
A Non-Random Sequence of Numbers
05:02
Random Generators and Seeds
05:21
Basic Random Functions in NumPy
03:56
Probability Distributions in NumPy
05:19
Applications of Random Data in NumPy
04:09
Generating Data with NumPy - Exercise
00:15

Statistics with NumPy

9 lectures
Using Statistical Functions in NumPy
07:44
Minimal and Maximal Values in NumPy
06:02
Statistical Order Functions in NumPy
06:25
Averages and Variance in NumPy
04:17
Covariance and Correlation in NumPy
02:59
Histograms in NumPy (Part 1)
07:36
Histograms in NumPy (Part 2)
04:15
NAN Equivalent Functions in NumPy
03:08
Statistics with NumPy - Exercise
00:15

NumPy - Preprocessing

13 lectures
Checking for Missing Values in Ndarrays
09:23
Substituting Missing Values in Ndarrays
08:29
Reshaping Ndarrays
06:31
Removing Values from Ndarrays
04:20
Sorting Ndarrays
09:45
Argument Sort in NumPy
05:48
Argument Where in NumPy
11:12
Shuffling Ndarrays
06:51
Casting Ndarrays
06:14
Striping Values from Ndarrays
04:43
Stacking Ndarrays
10:31
Concatenating Ndarrays
06:27
Finding Unique Values in Ndarrays
05:04

A Loan Data Example with NumPy

15 lectures
Setting Up: Introduction to the Practical Example
04:50
Setting Up: Importing the Data Set
04:10
Setting Up: Checking for Incomplete Data
04:35
Setting Up: Splitting the Dataset
05:27
Setting Up: Creating Checkpoints
02:50
Manipulating Text Data: Issue Date
05:26
Manipulating Text Data: Loan Status and Term
07:08
Manipulating Text Data: Grade and Sub Grade
08:54
Manipulating Text Data: Verification Status & URL
05:20
Manipulating Text Data: State Address
06:01
Manipulating Text Data: Converting Strings and Creating a Checkpoint
03:28
Manipulating Numeric Data: Substitute Filler Values
07:51
Manipulating Numeric Data: Currency Change – The Exchange Rate
06:32
Manipulating Numeric Data: Currency Change - From USD to EUR
08:22
Completing the Dataset
06:46

The "Absenteeism" Exercise - Introduction

3 lectures
An Introduction to the "Absenteeism" Exercise
01:11
The "Absenteeism" Exercise from a Business Perspective
02:19
The Dataset
01:34

Solution to the "Absenteeism" Exercise

18 lectures
How to Complete the Absenteeism Exercise
01:57
Eyeball Your Data First
05:53
Note: Programming vs the Rest of the World
03:27
Using a Statistical Approach to Solve Our Exercise
02:17
Dropping the 'ID' Column
06:27
Analysis of the 'Reason for Absence' Column
05:04
Splitting the Reasons for Absence into Multiple Dummy Variables
08:37
Working with Dummy Variables - A Statistical Perspective
01:28
Grouping the Reason for Absence Columns
08:35
Concatenating Columns in a pandas DataFrame
04:35
Reordering Columns in a DataFrame
01:43
Creating Checkpoints
00:08
Working on the 'Date' Column
07:49
Extracting the Month Value from the 'Date' Column
07:00
Creating the 'Day of the Week' Column
03:36
Understanding the Meaning of 5 More Columns
03:17
Modifying the 'Education' Column
04:38
Final Remarks on the Absenteeism Exercise
01:40

Data Visualization

37 lectures
What Is Data Visualization and Why Is It Important?
04:31
Why Learn Data Visualization?
06:08
Choosing the Right Visualization – What Are Some Popular Approaches and Framewor
06:58
Introduction into Colors and Color Theory
08:56
Bar Chart - Introduction - General Theory and Getting to Know the Dataset
01: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
02:50
Pie Chart - Introduction - General Theory and Dataset
04:04
Pie Chart - How to Create a Pie Chart Using Python
06:39
Pie Chart – Interpreting the Pie Chart
01:32
Pie Chart - Why You Should Never Create a Pie Graph
07:32
Stacked Area Chart - Introduction - General Theory. Getting to Know the Dataset
03:16
Stacked Area Chart - How to Create a Stacked Area Chart Using Python
07:48
Stacked Area Chart - Interpreting the Stacked Area Graph
02:30
Stacked Area Chart - How to Make a Good Stacked Area Chart
03:52
Line Chart - Introduction - General Theory. Getting to Know the Dataset
02:03
Line Chart - How to Create a Line Chart in Python
08:05
Line Chart - Interpretation
03:11
Line Chart - How to Make a Good Line Chart
06:30
Histogram - Introduction - General Theory. Getting to Know the Dataset
04:39
Histogram - How to Create a Histogram Using Python
05:43
Histogram – Interpreting the Histogram
02:11
Histogram – Choosing the Number of Bins in a Histogram
05:28
Histogram - How to Make a Good Histogram
04:43
Scatter Plot - Introduction - General Theory. Getting to Know the Dataset
02:29
Scatter Plot - How to Create a Scatter Plot Using Python
08:39
Scatter Plot – Interpreting the Scatter Plot
02:42
Scatter Plot - How to Make a Good Scatter Plot
02:56
Regression Plot - Introduction - General Theory. Getting to Know the Dataset
03:03
Regression Plot - How to Create a Regression Scatter Plot Using Python
07:08
Regression Plot – Interpreting the Regression Scatter Plot
04:36
Regression Plot - How to Make a Good Regression Plot
03:14
Bar and Line Chart - Introduction - General Theory. Getting to Know the Dataset
03:10
Bar and Line Chart - How to Create a Combination Bar and Line Graph Using Python
07:39
Bar and Line Chart – Interpreting the Combination Bar and Line Graph
02:36
Bar and Line Chart – How to Make a Good Bar and Line Graph
04:04
Data Visualization - Exercise
00:11

Conclusion

2 lectures
Conclusion
02:22
Bonus
00:29

Đánh giá của học viên

Chưa có đánh giá
Course Rating
5
0%
4
0%
3
0%
2
0%
1
0%

Bình luận khách hàng

Viết Bình Luận

Bạn đánh giá khoá học này thế nào?

image

Đăng ký get khoá học Udemy - Unica - Gitiho giá chỉ 50k!

Get khoá học giá rẻ ngay trước khi bị fix.