Data Wrangling 2 - using dplyr to bind, join, and merge data (bind_rows, inner_join, etc., mutate)

Описание: 00:00 - Skippable Introduction
02:17 - Overview of combining data sources
05:29 - Overview of commands covered in video
06:20 - bind_rows to append tables
12:10 - Analytics on the Spotify data
14:30 - Towards joins - why we merge sources
17:33 - left_join
19:42 - by=join_by shortcuts
20:37 - Joining by composite keys (combination of columns)
23:16 - right_join
24:38 - inner_join
25:07 - full_join
26:54 - Merging the telecom data
30:33 - Analytics on telecom data - probability that women who have streaming TV end up churning
33:30 - mutate command for adding columns and an example
35:29 - Example of adding a new categorical variable with ifelse() and factor()
37:30 - Use multiple mutates to add multiple columns to a data frame
39:05 - Recap - be prepared to spend a LOT of time doing data wrangling!
39:57 - Skippable outro video

Files on Dropbox: https://www.dropbox.com/scl/fo/qgvma7...

Reading in data from google sheets - get the bindrowsjoinmutate.R file and you'll see the code in there. Unfortunately if I try pasting the code here it turns it into a URL that doesn't work!