Moving from Excel to R: Joining tables in R (vlookup to left_join)

Описание к видео Moving from Excel to R: Joining tables in R (vlookup to left_join)

In this video I demonstrate how to use left_join, right_join, full_join and inner_join to join tables.
I also show how anti_join and semi_join can be used to filter rows.

I forgot to mention the difference between semi_join to inner_join (both retain rows which appear in both tables, only that inner_join also adds the columns from the second table).

Note that in order for the functions to work you need to have a shared key variable in the two tables (otherwise you mush use the "by" argument, which I forgot to show in the video...)

Комментарии

Информация по комментариям в разработке