Love your channel. I’m new to R and will need to merge two data frames shortly for a project I am doing. This was an excellent primer on the prices. Thank you!
Thank you, these are helpful overall. Though, I wish people will explain how to solve problems, all of the examples are so neat that one encounters issues and have not idea how to solve.
Hey Yousif, this depends on your desired output. If you want to combine data by certain IDs of your observations, you would use a merge. If you would simply like to stack your data on top of each other, you would use rbind. Regards, Joachim
@@StatisticsGlobe hi, i have 2 data frames and I want to merge by the date columns, but the names of 2 columns are different, "date_activity" & "date_sleep" . How can I merge them then?
hey Globe, if I merge data frames by either ID1 or ID2, is it possible? Now I have two datasets. Some people gave their phone number,some people gave their email address, some people gave both, some people put their email address into the cell of phone number. I have merge these two data set.
Hey, you might combine your two ID columns using the paste() function, and then you might use this combined ID to merge your data sets. Regards, Joachim
> head(wiki) Land Haushaltsgroesse Haushaltanzahl 1 China 2.70 522689264 2 India 4.57 299727860 3 United States 2.49 132736055 4 Indonesia 3.86 69855344 5 Brazil 3.31 64124398 6 Russia 2.58 56771478 > head(isoo) ISO Land 1 AFG Afghanistan 2 ALA Aland Islands 3 ALB Albania 4 DZA Algeria 5 ASM American Samoa 6 AND Andorra
@@StatisticsGlobe waiting for video on data through which we can understand and apply the same on real life.hope you will think about it and get time soon to make video on it. Thanks for your support
You have a very effective teaching style which I appreciate. Clear concise practical examples. Thank you.
Thank you very much for the great feedback Robert! :)
Love your channel. I’m new to R and will need to merge two data frames shortly for a project I am doing. This was an excellent primer on the prices. Thank you!
Awesome, thank you for the positive feedback Kelsey!
Thank you, these are helpful overall. Though, I wish people will explain how to solve problems, all of the examples are so neat that one encounters issues and have not idea how to solve.
Thanks a lot for your feedback! 🙂
Thanks for the tutorial Joachim, always great for keeping my R skills sharp!!
Thanks for the comment AG! :)
@@StatisticsGlobe You are very welcome, I am looking forward your next tutorial!!
It will be released today at 4 PM :)
@@StatisticsGlobe Awsome
Thanks for this. I'm new to R, and I was able to understand this.
Thank you very much for your kind feedback. Glad it helped! 🙂
Thank you for the video. I enjoyed this quick lesson
Thank you Bridgett! Glad you enjoyed it!
Very clear, thanks, helped a lot!
Thanks Rehan! Glad it helped!
If the names of the columns are the same in both data frames. Can we use rbind or we would use the merge function?
Hey Yousif, this depends on your desired output. If you want to combine data by certain IDs of your observations, you would use a merge. If you would simply like to stack your data on top of each other, you would use rbind. Regards, Joachim
@@StatisticsGlobe hi, i have 2 data frames and I want to merge by the date columns, but the names of 2 columns are different, "date_activity" & "date_sleep" . How can I merge them then?
hey Globe, if I merge data frames by either ID1 or ID2, is it possible? Now I have two datasets. Some people gave their phone number,some people gave their email address, some people gave both, some people put their email address into the cell of phone number. I have merge these two data set.
Hey, you might combine your two ID columns using the paste() function, and then you might use this combined ID to merge your data sets. Regards, Joachim
@@StatisticsGlobe hey Gloe, thank you for your reply. let me try it tomorrow and I will let you know the whether it works.
Very useful video! Thank you so much!
Thanks Jarrod! Glad you enjoyed it!
Nice one
Thanks for watching Caduguimaraes!
My merge works and there is a new file with all the columns but not data. (it worked in a different merge)
Hey Tom, could you share the structure of your data and your code?
@@StatisticsGlobe thank you for the reply Joachim. Here is my Code
wiki
What is returned when you run this:
wiki %
select(-one_of(col_remove))
colnames(isoo)
> head(wiki)
Land Haushaltsgroesse Haushaltanzahl
1 China 2.70 522689264
2 India 4.57 299727860
3 United States 2.49 132736055
4 Indonesia 3.86 69855344
5 Brazil 3.31 64124398
6 Russia 2.58 56771478
> head(isoo)
ISO Land
1 AFG Afghanistan
2 ALA Aland Islands
3 ALB Albania
4 DZA Algeria
5 ASM American Samoa
6 AND Andorra
Hey Tom, sorry for the late reply, for some reason your comment was blocked by RUclips. Do you still need help with this? Regards, Joachim
Great nice video ...
Thank you very much Sudhir!
@@StatisticsGlobe waiting for video on data through which we can understand and apply the same on real life.hope you will think about it and get time soon to make video on it.
Thanks for your support