Course curriculum

  • 1

    1_Introduction & Course Outline

    • 1_Course Introduction

    • 2_Course Outline

    • 3_Course Goal

    • 4_Book Recommendation
  • 2

    2_Data Expectations vs. Reality

    • 1_Data Reality
  • 3

    3_What is Data

    • 1_What is Data

    • 2_Data should look like

    • 3_Types of Data
  • 4

    4_Raw and Processed Data

    • 1_Raw vs Processed Data
  • 5

    5_The Components of Tidy Data

    • 1_The Components of Tidy Data

    • 2_The Raw Data

    • 3_The Tidy Data

    • 4_The Code Book
  • 6

    6_Downloading Data Files

    • 1_Download Data Overview

    • 2_Working Directory

    • 3_Download Data
  • 7

    7_Reading Text and CSV Files

    • 1_Read Table 1

    • 2_Read Table 2

    • 3_Read CSV

    • 4_Exercise fread
  • 8

    8_Reading Excel Files

    • 1_Read Excel File 1

    • 2_Read Excel File 2

    • 3_Write Excel 1

    • 4_Excel Learning Exercise
  • 9

    9_Web Scrapping

    • 1_Web Scrapping 1

    • 2_Web Scrapping 2

    • 3_Web Scrapping 3

    • 4_Web Scrapping 4

    • 5_Web Scrapping 5
  • 10

    10_Read Data from Databases

    • 1_Database SQL

    • 2_SQLite Create DB n Tables 1

    • 3_SQLite Create DB n Tables 2

    • 4_SQLite Create DB n Tables 3

    • 5_SQLite ExecuteQuery 1

    • 6_SQLite ExecuteQuery 2

    • 7_SQLite Parameterized Query

    • 8_None Tabular Results 1

    • 9_None Tabular Results 2

    • 10_SQLite Other Functions

    • 11_SQLite Conclusion

    • 12_MySQL 1

    • 13_MySQL 2

    • 14_MySQL 3
  • 11

    11_Using data table

    • 1_Outline Overview

    • 2_Data Table Overview

    • 3_Data Table Code

    • 4_Data Table Add Column

    • 5_Data Table Merge

    • 6_Data Table Sort with Data Frame
  • 12

    12_Subset and Sort

    • 1_Subseting Sorting 1

    • 2_Subseting Sorting 2

    • 3_Subseting Sorting 3
  • 13

    13_Dealing with Missing Values

    • 1_Missing Values Overview

    • 2_Test for Missing Values

    • 3_Impute Missing Values

    • 4_Exclude Missing Values

    • 5_Exercise

    • 6_Self Study
  • 14

    14_Split & Apply

    • 1_Split & Apply a

    • 2_Split & Apply b
  • 15

    15_MergeJoin dataframes

    • 1_Merge datafarmes 1

    • 2_Merge datafarmes 2

    • 3_Merge datafarmes 3

    • 4_Merge datafarmes 4

    • 5_Merge datafarmes 5
  • 16

    16_The Tidyverse Library

    • 1_Tidyverse

    • 2_Dplyr

    • 3_Dplyr 2

    • 4_Dplyr 3

    • 5_Dplyr 4

    • 6_Tidyr 1

    • 7_Tidyr 2

    • 8_Practice notebooks
  • 17

    17_Dealing with Text Data

    • 1_Dealing with Text Data 1

    • 2_Dealing with Text Data 2

    • 3_Dealing with Text Data 3
  • 18

    18_Course Conclusion

    • 1_Course Conclusion
  • 19

    Congratulations! You have successfully completed this course!

    • Congratulations !