I have been trying to join my data for the last 4 days and finally! Thank you! I have been starting from the way beginning of your videos from 3 years ago. Thank you for sharing and being so detailed and adding extra functions and ideas that someone else may need to use.
@Riffomonas5 ай бұрын
Im so glad to hear they’ve been helpful!
@timmytesla96552 жыл бұрын
Super useful explanation. The Anti-join function here is easier than that in SQL. Thanks for the video.
@Riffomonas2 жыл бұрын
My pleasure! Thanks for watching Timmy
@j.knetsch34135 ай бұрын
omg thank you!
@sohilausamarabie96312 жыл бұрын
Amazing explanation! Thank you!!
@Riffomonas2 жыл бұрын
Thanks for watching Sohila! 🤓
@hansmeiser60782 жыл бұрын
Cool.
@niceday2015 Жыл бұрын
Always great.
@ieliemielio2 жыл бұрын
The joins are also the way to mimic Excel’s much-loved VLOOKUP function
@Riffomonas2 жыл бұрын
I feel like I need to do a “Pat relearns Excel” series 😂
@jamesleleji6984 Жыл бұрын
How do you combine two data frames with different column names with the union function
@DanJohanssonJLB2 жыл бұрын
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....
@Riffomonas2 жыл бұрын
Hi Daniel - thanks for watching and writing. I *love* the joins. I get a lot out of seeing how other people use them
@peteralfred70062 жыл бұрын
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.
@Riffomonas2 жыл бұрын
Hi Peter - I'm sorry the link above wasn't working but it is now. You can find it in the original video from this series (kzbin.info/www/bejne/p5LOpKCHlseAi6s) or on the github repository at raw.githubusercontent.com/riffomonas/vaccination_attitudes/main/august_october_2020.csv
@cristianjaviermena69556 ай бұрын
goatttttt
@johnschloss6942 жыл бұрын
Cool video
@Riffomonas2 жыл бұрын
Thanks dude
@russtin12 жыл бұрын
I remember really struggling to get merge to perform a left_join in my pre-tidyverse days
@lichaccakaven1462 жыл бұрын
超喜欢你的讲解!!^_^
@haraldurkarlsson1147 Жыл бұрын
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.
@Riffomonas5 ай бұрын
Both would work
@hansmeiser60782 жыл бұрын
What is the difference between merge(all=TRUE) and full_join()?
@Riffomonas2 жыл бұрын
The *_join functions are the same functionality as provided by merge, but with a cleaner syntax