Using dplyr's join functions in R to filter and merge data frames (CC164)

Would location %in% c(“Australia”, “Brazil”, …) not have worked here? I guess that is mute since you filter with a join later but still good to know that there is a short-cut.

Always great.

How do you combine two data frames with different column names with the union function

Super useful explanation. The Anti-join function here is easier than that in SQL. Thanks for the video.

Amazing explanation! Thank you!!

The joins are also the way to mimic Excel’s much-loved VLOOKUP function

pat i love hadley so much for making my hard learned SQL skills relevant again by bringing them into R. As you mentioned, i also like to be explicit and always use the "by" argument, but this is also why i always use left_join. I feel like inner_join hides missing records from me and I want to know things are missing so I can handle those missing entries right away. Obviously you could look for missing data further along in your code but i'd rather just deal with it now. maybe there's a better way that I'm not aware of....

I remember really struggling to get merge to perform a left_join in my pre-tidyverse days

Hey Pat I am lost on the way. I want to know where did you come up with the ipsos dataset? I followed the link, I was totally lost on the way.

What is the difference between merge(all=TRUE) and full_join()?

Cool.

Cool video

超喜欢你的讲解！！^_^