dplyr: Joins

แชร์
ฝัง
  • เผยแพร่เมื่อ 16 ธ.ค. 2024

ความคิดเห็น • 22

  • @j7andrew
    @j7andrew 2 ปีที่แล้ว +1

    This is awesome! You have a gift for teaching. Thank you

  • @mariamaroni8104
    @mariamaroni8104 4 ปีที่แล้ว +1

    Thank you so much! This was really helpful. Hugs from Argentina!

  • @michaelhudson2375
    @michaelhudson2375 3 ปีที่แล้ว

    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.

  • @bukolaadebayo1891
    @bukolaadebayo1891 2 ปีที่แล้ว

    Thank you so much!! The join multiple columns was really helpful.

  • @jamesleleji6984
    @jamesleleji6984 ปีที่แล้ว

    which IDE are you using to run the codes? Thanks

  • @walterbondzie2464
    @walterbondzie2464 4 ปีที่แล้ว +3

    Please what if you have two datasets with different colnames and rows but you are asked to merge the two

    • @DataDaft
      @DataDaft  4 ปีที่แล้ว +3

      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.

  • @carolwrezende
    @carolwrezende 3 ปีที่แล้ว

    FINALLY A VIDEO ABOUT THIS SUBJECT IN AMERICAN ENGLISH

  • @svendavidsson
    @svendavidsson 4 ปีที่แล้ว

    Straight to the point! Very helpful. cheers

  • @lichaccakaven146
    @lichaccakaven146 5 ปีที่แล้ว +5

    very basic ,very good.

  • @data_kom
    @data_kom 2 ปีที่แล้ว

    Great video on joins. Thanks

  • @joankettfield6194
    @joankettfield6194 3 ปีที่แล้ว

    Thank you very clear presentation. Can dplyr replace SQL?

  • @Timska
    @Timska 4 ปีที่แล้ว +2

    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=

    • @DataDaft
      @DataDaft  4 ปีที่แล้ว

      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")

  • @simonebellisario3682
    @simonebellisario3682 ปีที่แล้ว

    THANK YOU

  • @amrsalaheldinabdallahhammo663
    @amrsalaheldinabdallahhammo663 2 ปีที่แล้ว

    Thank you genius :)

  • @KirtiTewari
    @KirtiTewari 3 ปีที่แล้ว

    Very helpful

  • @nitufahmidakhalique2698
    @nitufahmidakhalique2698 3 ปีที่แล้ว

    thank you

  • @shantileitch
    @shantileitch 3 ปีที่แล้ว

    awesome

  • @jhonataoliveira2175
    @jhonataoliveira2175 3 ปีที่แล้ว

    i fucking love u
    you saved me

  • @jamesleleji6984
    @jamesleleji6984 ปีที่แล้ว

    which IDE are you using to run the codes? Thanks