Course curriculum

  • 1

    Introduction & Course Outline

    • Course Description

    • 0.1.Course_Introduction

    • 0.2.Course_Outline

    • 0.3.Course_Goal

    • 0.4.Book Recommendation
  • 2

    Practice Exercises Notebook - Github

    • Practice Exercises Notebooks
  • 3

    Group Learning and Q/A Community

    • Group Learning and Q/A Community
  • 4

    What is Data?

    • 1.1.What is Data

    • 1.2.Data_should_look_like

    • 1.3.Types_of_Data
  • 5

    Data: Expectations vs. Reality

    • 2.1.Data_Reality
  • 6

    Raw and Processed Data

    • 3.1.Raw_vs_Processed_Data
  • 7

    The Components of Tidy Data

    • 4.1.The_Components_of_Tidy_Data

    • 4.2.The_Raw_Data

    • 4.3.The_Tidy_Data

    • 4.4.The_Code_Book
  • 8

    Downloading Data Files

    • 5.1.Download_Data_Overview

    • 5.2.Working_Directory

    • 5.3.Download_Data
  • 9

    Reading Text and CSV Files

    • 6.1.Read_Table_1

    • 6.2.Read_Table_2

    • 6.3.Read_CSV

    • 6.4.Exercise_fread
  • 10

    Reading Excel Files

    • 7.1.Read_Excel_File_1

    • 7.2.Read_Excel_File_2

    • 7.3.Write_Excel_1

    • 7.4.Excel_Learning_Exercise
  • 11

    Web Scrapping

    • 8.1.Web_Scrapping_1

    • 8.2.Web_Scrapping_2

    • 8.3.Web_Scrapping_3

    • 8.4.Web_Scrapping_4

    • 8.5.Web_Scrapping_5
  • 12

    Read Data from Databases

    • 9.1.Database_SQL

    • 9.2.SQLite_Create_DB_n_Tables_1

    • 9.3.SQLite_Create_DB_n_Tables_2

    • 9.4.SQLite_Create_DB_n_Tables_3

    • 9.5.SQLite_Execute_Query_1

    • 9.6.SQLite_Execute_Query_2

    • 9.7.SQLite_Parameterized_Query

    • 9.8.None-Tabular_Results_1

    • 9.9.None-Tabular_Results_2

    • 9.10.SQLite_Other_Functions

    • 9.11.SQLite_Conclusion

    • SQLite Class Example Script

    • 9.12.MySQL_1

    • 9.13.MySQL_2

    • 9.14.MySQL_3

    • MySQL Class Example Script
  • 13

    Using data.table

    • 10.0.Outline_Overview

    • 10.1.Data.Table_Overview

    • 10.2.Data.Table_Code

    • 10.3.Data.Table_Add_Column

    • 10.4.Data.Table_Merge

    • 10.5.Data.Table_Sort_with_Data.Frame
  • 14

    Subset and Sort

    • 11.1.Subseting_Sorting_1

    • 11.2.Subseting_Sorting_2

    • 11.3.Subseting_Sorting_3
  • 15

    Dealing with Missing Values

    • 12.1.Missing_Values_Overview

    • 12.2.Test_for_Missing_Values

    • 12.3.Impute_Missing_Values

    • 12.4.Exclude_Missing_Values

    • 12.5.Exercise

    • 12.6.Self_Study

    • Self_Study
  • 16

    Split & Apply

    • 13.2.Split_&_Apply

    • 13.1.Split_&_Apply
  • 17

    Merge/Join dataframes

    • 14.1.Merge_datafarmes_1

    • 14.2.Merge_datafarmes_2

    • 14.3.Merge_datafarmes_3

    • 14.4.Merge_datafarmes_4

    • 14.5.Merge_datafarmes_5

    • Learn by Doing it
  • 18

    The Tidyverse Library

    • 15.1.Tidyverse

    • 15.2.Dplyr

    • Dataset - msleep.csv

    • 15.3.Dplyr_2

    • 15.4.Dplyr_3

    • 15.5.Dplyr_4

    • Dplyr - Learn by Doing it

    • Mutate Function - Learn by Doing it

    • Sort/Ordering Dataframe - Learn by Doing it

    • 15.6.Tidyr_1

    • 15.7.Tidyr_2

    • 15.8.Practice_notebooks
  • 19

    Dealing with Text Data

    • 16.1.Dealing_with_Text_Data_1

    • 16.2.Dealing_with_Text_Data_2

    • 16.3.Dealing_with_Text_Data_3
  • 20

    Course Conclusion

    • 17.0.Course_Conclusion
  • 21

    Resources

    • Data Collection & Data Wrangling Slides

    • Class Examples Code