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
-
-
22
Solution Link Submission
-
Solution Link Submission
-