Dplyr Advanced Guide: data cleaning, reshaping, and merging with lubridate, stringr, tidyr, ggplot2
Dplyr Advanced Guide: data cleaning, reshaping, and merging with lubridate, stringr, tidyr, ggplot2
Timeline
0:00 Intro
1:30 Cleaning dates
3:15 String cleaning & extraction
7:30 Reshaping data
10:57 Merging data frames
14:05 Graphing
Code: https://github.com/abhimotgi/dataslice/blob/master/R/Dplyr%20Advanced%20Topics.Rmd
Datasets:
Billboard Hot 100: https://www.kaggle.com/dhruvildave/billboard-the-hot-100-songs
MTV 10,000 artists: https://gist.github.com/mbejda/9912f7a366c62c1f296c
Cheat sheets:
Lubridate: https://evoldyn.gitlab.io/evomics-2018/ref-sheets/R_lubridate.pdf
Stringr: https://evoldyn.gitlab.io/evomics-2018/ref-sheets/R_strings.pdf
Tidyr: https://community.rstudio.com/t/tidyr-cheatsheet-with-pivot-functions/62981
Ggplot2: https://www.maths.usyd.edu.au/u/UG/SM/STAT3022/r/current/Misc/data-visualization-2.1.pdf