Dplyr Advanced Guide: data cleaning, reshaping, and merging with lubridate, stringr, tidyr, ggplot2
dataslice
·
Beginner
·4y ago
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
Watch on YouTube ↗
(saves to browser)
Sign in to unlock AI tutor explanation · ⚡30
Playlist
Uploads from Dataslice · Dataslice · 15 of 16
1
2
3
4
5
6
7
8
9
10
11
12
13
14
▶
16
Web Scrape Text from ANY Website - Web Scraping in R (Part 1)
Dataslice
Web Scrape Nested Links/Multiple Pages - Web Scraping in R (Part 2)
Dataslice
Animate Graphs in R: Make Gorgeous Animated Plots with gganimate
dataslice
Word Clouds in R: Useful & Beautiful Word Clouds with wordcloud2
dataslice
Web Scrape in Google Sheets: IMPORTHTML, IMPORTDATA, & IMPORTFEED Functions (Part 1)
dataslice
Web Scrape in Google Sheets: IMPORTXML Function (Part 2)
Dataslice
Make Interactive Graphs in R: Creating & Embedding Interactive Graphs with plotly
dataslice
R Maps: Beautiful Interactive Choropleth & Scatter Maps with Plotly
Dataslice
Build a Data Science Portfolio (Free & Easy) with Jekyll & GitHub Pages | Part 1: Site Configuration
dataslice
Build a Data Science Portfolio (Free & Easy) with Jekyll & GitHub Pages | Part 2: Adding Posts
dataslice
Build a Data Science Portfolio (Free & Easy) with Jekyll & GitHub Pages | Part 3: Customization
dataslice
Regex Basics | Match, Extract, and Clean Text
Dataslice
Scrape Websites with Regular Expressions
Dataslice
Dplyr Essentials (easy data manipulation in R): select, mutate, filter, group_by, summarise, & more
Dataslice
Dplyr Advanced Guide: data cleaning, reshaping, and merging with lubridate, stringr, tidyr, ggplot2
dataslice
Linear Regression Plots in R
dataslice
More on: ML Pipelines
View skill →Chapters (6)
Intro
1:30
Cleaning dates
3:15
String cleaning & extraction
7:30
Reshaping data
10:57
Merging data frames
14:05
Graphing
🎓
Tutor Explanation
DeepCamp AI