Thank you! Excellent explanation and coverage of the joins in dplyr. I learnt a lot from coding along with you. I hope you make more videos to share your knowledge of R, and data science.
If you have two columns with different names but that contain the same information/unique identifiers, such as "P_ID" in one data set and "Patient_ID" in the other, you can use the argument by = c("P_ID" = "Patient_ID") to join on that column despite the different column names. If the data sets don't have any variables in common (regardless of whether they actually have the column names) I'm not sure how they can be joined/merged in a meaningful way.
Thank you for making these videos on dplyr and R studio, its really helping me out! If also may ask why is it that the full_join is the only command of the joins that uses by=c( ) instead of by=
When joining on only one column, you can pass in that single column name using --> by = "join_col" In the full_join example where we are joining on two columns, we have to pass a vector of columns so we use --> by = c("join_col1", "join_col2")
This is awesome! You have a gift for teaching. Thank you
Thank you so much! This was really helpful. Hugs from Argentina!
Thank you! Excellent explanation and coverage of the joins in dplyr. I learnt a lot from coding along with you. I hope you make more videos to share your knowledge of R, and data science.
Thank you so much!! The join multiple columns was really helpful.
which IDE are you using to run the codes? Thanks
Please what if you have two datasets with different colnames and rows but you are asked to merge the two
If you have two columns with different names but that contain the same information/unique identifiers, such as "P_ID" in one data set and "Patient_ID" in the other, you can use the argument by = c("P_ID" = "Patient_ID") to join on that column despite the different column names.
If the data sets don't have any variables in common (regardless of whether they actually have the column names) I'm not sure how they can be joined/merged in a meaningful way.
FINALLY A VIDEO ABOUT THIS SUBJECT IN AMERICAN ENGLISH
Straight to the point! Very helpful. cheers
very basic ,very good.
Great video on joins. Thanks
Thank you very clear presentation. Can dplyr replace SQL?
Thank you for making these videos on dplyr and R studio, its really helping me out!
If also may ask why is it that the full_join is the only command of the joins that uses by=c( ) instead of by=
When joining on only one column, you can pass in that single column name using --> by = "join_col"
In the full_join example where we are joining on two columns, we have to pass a vector of columns so we use --> by = c("join_col1", "join_col2")
THANK YOU
Thank you genius :)
Very helpful
thank you
awesome
i fucking love u
you saved me
which IDE are you using to run the codes? Thanks