Python for Data Analytics

Uncategorized

Course Content

Buổi 1: GETTING STARTED

1. Introduction

00:00
2. Python for Dev vs Python for DA

00:00
3. Course structure

00:00
4. Learning method

00:00
5. Data Analysis Workflow with Python

00:00
6. Set up Google Colab

00:00
7. Quotes and Comments

00:00
8. Line & identification

00:00
9. Python variable

00:00
10. Input data

00:00
11. Print()

00:00
Quiz buổi 1

Buổi 2: OPERATORS & DATA TYPES

1. Today’s plan

00:00
2. Operator #1

00:00
3. Operator #1 Challenge

00:00
4. Operator #1 Solution

00:00
5. Operator #2

00:00
6. Numeric & Boolean

00:00
7. String

00:00
8. String Challenge

00:00
9. String Solution

00:00
10. List

00:00
11. List Challenge

00:00
12. List Solution

00:00
13. Tupple

00:00
14. Dictionary

00:00
15. Dictionary Challenge

00:00
16. Dictionary Solution

00:00
Quiz buổi 2

Buổi 3: PRACTICE

Buổi 4: LOGICAL CONDITION

1. Today’s plan

00:00
2. If-else

00:00
3. If-else Challenge

00:00
4. If-else Solution

00:00
5. Loop

00:00
6. Loop Challenge

00:00
7. Loop Solution

00:00
8. Nested Loop

00:00
9. Nested Loop Challenge

00:00
10. Nested Loop Solution

00:00
11. Break & Continue

00:00
12. Break & Continue Challenge

00:00
13. Break & Continue Solution

00:00
14. List Comprehension

00:00
15. List Comprehension Challenge

00:00
16. List Comprehension Solution

00:00
Quiz 4

Buổi 5: [PHASE 1] PRACTICE

Buổi 6: FUNCTION

1. Today’s plan

00:00
2. What is a Function?

00:00
3. UDF

00:00
4. UDF Challenge – Solution

00:00
5. Lambda

00:00
6. Built-in function & Lambda

00:00
7. Built-in function & Lambda challenge

00:00
8. Built-in function & Lambda Solution

00:00
9. Package, Libary (from import/ import)

00:00
Quiz buổi 6

Buổi 7: PRACICE

Buổi 8: SERIES & GATHERING DATA

1. Data Description
2. Today’s plan

00:00
3. Pandas introduction

00:00
4. Create Series

00:00
5. Series Selection

00:00
6. Series Operators

00:00
7. Series với numpy

00:00
8. Series Challenge

00:00
9. Series Solution

00:00
10. Gathering data process

00:00
11. Create Dataframe

00:00
12. Quick Explore Dataframe

00:00
13. Gathering data Challenge

00:00
14. Gathering data Solution

00:00
Quiz buổi 8

Buổi 9: DATA SELECTION & GROUPING

1. Today’s plan

00:00
2. Select data

00:00
3. Drop_duplicates()

00:00
4. Filtering

00:00
5. Filtering Challenge

00:00
6. Filtering Solution

00:00
7. Sorting

00:00
8. Mathetics operator

00:00
9. Mathetics operator Challenge

00:00
10. Mathetics operator Solution

00:00
11. Aggregate Function

00:00
12. Grouping #1

00:00
13. Grouping Challenge

00:00
14. Grouping Solution

00:00
Quiz buổi 9

Buổi 10: PRACTICE

Buổi 11: LOGIC CONDITION & CREATE SINGLE TABLE

1. Today’s plan

00:00
2. Group by – Transform

00:00
3. Groupby-Trasform() Challenge

00:00
4. Groupby-Trasform() Solution

00:00
5. Condition

00:00
6. Condition Challenge

00:00
7. Condition Solution

00:00
8. Concat

00:00
9. Type of Joins

00:00
10. Join demo

00:00
11. Join Challenge

00:00
12. Join Solution

00:00
Quiz buổi 11

Buổi 12: WORKING WITH STRING & DATETIME DATA

1. Today’s plan

00:00
2. upper(), lower(), capitaize(), len()

00:00
3. Find Pattern

00:00
4. Find Pattern Challenge

00:00
5. Find pattern solution

00:00
6. Extract

00:00
7. replace()

00:00
8. split(), Concatenation

00:00
9. split() challenge

00:00
10. split() solution

00:00
11. pd.to_datetime()

00:00
12. Extract datetime component

00:00
13. Datetime Calculation

00:00
14. shift() Method

00:00
15. rolling() Method

00:00
Quiz buổi 12

Buổi 13: PRACTICE

Buổi 14: CLEAN DATA

1. Clean data Overview

00:00
2. Issue 1: Datatypes

00:00
3. Issue 1: Datatypes Challenge

00:00
4. Issue 1: Datatypes Solution

00:00
5. Issue 2: Inconsistent Text & Types

00:00
6. Issue 2: Inconsistent Text & Types Challenge

00:00
7. Issue 2: Inconsistent Text & Types Solution

00:00
8. Issue 3: Duplicates

00:00
9. Issue 4: Missing data

00:00
10. Issue 4: Missing data Challenge

00:00
11. Issue 4: Missing data Solution

00:00
Quiz buổi 14

Buổi 15: [PHASE 2] PRACTICE

Buổi 16: MID COURSE TEST

Buổi 17: VISUALIZATION #1

1. Today’s plan

00:00
2. Why Statistics ?

00:00
3. Data types in Statistics

00:00
5. Measure of central tendency

00:00
6. Measure of Variability

00:00
7. Measure of Correlation

00:00
8. How to choose the right chart #1

00:00
9. How to choose the right chart #2

00:00
Quiz buổi 17

Buổi 18: [PHASE 3] VISUALIZATION #2

Buổi 19: PRACTICE

Buổi 20: PROBLEM SOLVING STRATEGY

Buổi 21: PRACTICE

Buổi 22: DATA ANALYSIS #1

Buổi 23: DATA ANALYSIS # 2

Buổi 24: DATA ANALYSIS #3

Buổi 25 – 28: PRACTICE

Buổi 29: PRESENTATION & STORY TELLING

Buổi 30: PRACTICE