combine different datasets into one | relational data | R for data science | left_join function in R

Hello everyone,

This video is based on R for Data Science chapter 13 Relational data. It is very common to have messy data in real life, and it is often true that the data for your analysis is from different resources. In this video, you will learn how to combine data tables and use them for analysis, through a few real-life datasets and two small data examples.

You may read chapter 13 through this link: https://r4ds.had.co.nz/

0:00 a quick intro
5:12 combine flights data with other information
such as weather, planes, and airlines
12:26 an easy and quick explanation using drawing to explain left_join
14:10 understand the joining functions using two smaller datasets

The R code in this video is available here: https://github.com/yz-DataScience/R-for-data-science/blob/main/R%20code%20for%20relational%20data.R

You may find the playlist on R for data science book club here ( I have been recording the videos according to a popular book): https://youtube.com/playlist?list=PLKNR1HvYSio7IaKu2vGkNJ1_jGNYiJPmT

You may set the video speed to 1.25 or 1.5 to make the video go faster by clicking the setting from the bottom right of the video, and set the speed to 1.25 or 1.5.

You need to install R and RStudio before you use RStudio. Follow this instruction here:
https://github.com/yz-DataScience/R-for-data-science/blob/main/R%20and%20RStudio%20Installation%20file.pdf

Видео combine different datasets into one | relational data | R for data science | left_join function in R канала Data Science with Yan