Merging DataFrames in Pandas | Python Pandas Tutorials

Поділитися
Вставка
  • Опубліковано 22 гру 2024

КОМЕНТАРІ •

  • @JW-pu1uk
    @JW-pu1uk Рік тому +37

    This is such a solid explanation on this. If someone is familiar with SQL JOINS, they should feel right at home here (with a few exceptions of course). Don't sleep on Pandas, and don't sleep on AtA videos.

  • @SamiMouloudMerkouche
    @SamiMouloudMerkouche Рік тому +7

    Im datascience learner I use datacamp as my learning platform and your video has helped a lot with that.Thanks for the amazing explanation and keep going we need more people like you.

  • @sj1795
    @sj1795 11 місяців тому +4

    Really appreciate how you explain these concepts so clearly. As always, THANK YOU ALEX! You are the BEST!

  • @casual_gaming001
    @casual_gaming001 Рік тому +2

    Thanks alot, i have been on youtube and Stack overflow all evening. Best explanation

  • @Richardo-o3z
    @Richardo-o3z 2 місяці тому

    Right away from Ghana , every bit of your explanation is on point and you have had so much impact on my journey as a data analyst. Thank you Alex

  • @nobodyonlyboss
    @nobodyonlyboss 4 години тому

    It feels soothing to see your appearence after going through some newly oriented tasks...

  • @JaimeHaddad
    @JaimeHaddad Рік тому +3

    Thank you Alex ! Well explained and very simple to understand ! Great as always!! 👏

  • @bhavikakapadia2497
    @bhavikakapadia2497 Рік тому +8

    Thanks Alex for the amazing Explanation. I learn a lot by watching your video. Are we expecting more pandas tutorials in the upcoming video?

    • @AlexTheAnalyst
      @AlexTheAnalyst  Рік тому +2

      Yep! I've got about 3 more including visualizations, data cleaning, and data exploration :)

  • @midohany9
    @midohany9 Рік тому +1

    Thanks for the amazing explanation. This is the first playlist I know you from and Your way of illustration is pretty simple and helped me get confusing pandas terms. Many thanks again ❤

  • @vijayj8024
    @vijayj8024 Рік тому +3

    Thank you alex. You are amazing....

  • @carmelool1
    @carmelool1 8 місяців тому +1

    Excellent Video. Very well explained. Thanks for doing it.

  • @БулатШарафутдинов-р6д

    Thank you!)

  • @Niranga.555
    @Niranga.555 Рік тому +3

    Dear Alex,
    Thanks for your nice explanation..!

  • @venudunde3453
    @venudunde3453 Рік тому +2

    thanks Alex, nice explanation

  • @OliviaWu-q9z
    @OliviaWu-q9z 11 місяців тому +1

    This is so helpful. Thank you!

  • @djitymik
    @djitymik Рік тому +1

    You nailed it! Thank u very much sir!!!

  • @anurasenarathna1703
    @anurasenarathna1703 7 місяців тому +1

    Very useful series, very well explained. Thank you very much for sharing your knowledge.

  • @femikomolafe5604
    @femikomolafe5604 Рік тому +2

    Wished I saw this video earlier....I would have saved days of wasted hours with simple concatenate function. Tnk Alex

  • @aissamboudra7995
    @aissamboudra7995 Рік тому +1

    Many thanks, clear and useful

  • @abdulkadirguven1173
    @abdulkadirguven1173 Рік тому +1

    Nice tuto. Thank you very much.

  • @t_millagain5255
    @t_millagain5255 Рік тому +1

    Definitely what i needed 👍🏽

  • @chingchan3000
    @chingchan3000 2 місяці тому

    you explain better than my professor....thank you!

  • @pavithras4085
    @pavithras4085 7 місяців тому +1

    Many Thanks for this clear explanation :)

  • @neildelacruz6059
    @neildelacruz6059 Рік тому +1

    Excellent Thanks

  • @pamm6281
    @pamm6281 5 місяців тому +1

    Well Explained Sir.... Thanku so much

  • @thaonguyen-xu2tw
    @thaonguyen-xu2tw 4 місяці тому

    hi, thank you for the explanation. I liked it already but still want to comment to appreciate your effort.

  • @shadrinan90
    @shadrinan90 5 місяців тому

    Thank you for concise and interesting video. I ve learned everything I wanted

  • @Daniel-me6mu
    @Daniel-me6mu 3 місяці тому

    Love this explanation. It will help me to go through my exam :))

  • @abdullahmirza7606
    @abdullahmirza7606 Рік тому +1

    Alex the king 👑👑

  • @vidyutroy2868
    @vidyutroy2868 4 місяці тому

    thank you for sharing such tutorials

  • @albertneil290
    @albertneil290 10 місяців тому

    Awesome ❤❤
    Very well explained.....

  • @chamo7110
    @chamo7110 8 місяців тому +1

    You have a new subscriber here

  • @ElBasraoui
    @ElBasraoui 7 місяців тому +2

    bro I'm a data scientist student, it's the first time I understand that in such a stunningly beautiful way

  • @josemariahernandezlara4061
    @josemariahernandezlara4061 Рік тому +1

    The best!

  • @levimungai1846
    @levimungai1846 2 місяці тому +3

    This is set theory... union, intersection, set difference and cross product

  • @stanTrX
    @stanTrX 2 місяці тому

    Thanks. What do you think about capability of these compared to power query in excel?

  • @hello-fs9bt
    @hello-fs9bt 5 місяців тому

    Thank you very much! I don't know how to tell you how much this video help me but you just saved me a lot of time! Very well-explained, easy to understand! I wish you all the good things in life.

  • @stefanvilcu8260
    @stefanvilcu8260 10 місяців тому

    wonderful video

  • @SieanElpidama
    @SieanElpidama 7 місяців тому

    Qestion is there a function of merge as well in Sql specifically PostgeSQL?

  • @sachinmaroky4600
    @sachinmaroky4600 Рік тому

    thank you

  • @sandeepmanjunath8004
    @sandeepmanjunath8004 Рік тому +1

    Just one doubt is it possible to join on any condition other than equality condition in pandas like we do in SQL for example T1.Col1 < T2.Col1

  • @osiomogieasekome8799
    @osiomogieasekome8799 Рік тому +1

    I don't know if its because I learnt sql first but I feel its more straight forward than python... Also doing this a month later, the append still works without any warning 😅 I wonder python would decide to remove

  • @khadijashaikh9617
    @khadijashaikh9617 4 місяці тому

    please make a video on numpy library in python

  • @garry6882
    @garry6882 2 місяці тому

    how do you put image in the notebook?

  • @rashadkasim
    @rashadkasim Рік тому

    Can we do 2 dataframes side by side in pyspark? Similar to concatenate here

  • @ReadyF0RHeady
    @ReadyF0RHeady Місяць тому

    can i also do it with json files or do they need to be csv files ?

  • @monique1112223
    @monique1112223 11 місяців тому

    I got an error message on the cross join and it isn't visible in the menu with SHIFT + TAB either. Interesting.

  • @angelinesworld5841
    @angelinesworld5841 3 місяці тому

    Need notes for this. Could you please share this

  • @guocity
    @guocity 9 місяців тому

    how to do union in dataframe?

  • @winaraj
    @winaraj 7 місяців тому

    merge doesnt work in vsc? says no attribute

  • @hafsaabdullahi1250
    @hafsaabdullahi1250 Місяць тому

    Am unable to import the dataset am getting the error 'str' object is not callable. what could be the issue?

  • @shalinivijayravikumar9713
    @shalinivijayravikumar9713 Рік тому +1

    "Hi Alex, could you please upload a video on NumPy for beginners? It would be incredibly helpful for me, and I would greatly appreciate it."

  • @garvjain3462
    @garvjain3462 Рік тому +2

    🎯 Key Takeaways for quick navigation:
    Merging, joining, and concatenating data frames in Pandas is crucial for combining separate data frames into one.
    Types of joins: inner join (default), outer join, left join, and right join.
    Cross join compares each value from the left data frame with every value from the right data frame.
    The join function is used to join data frames based on specified indexes, but it requires more manual configuration compared to the merge function.
    Concatenation places one data frame on top of another (vertically) or side by side (horizontally).
    The append function is deprecated and should be replaced with the pandas.concat function for appending rows from one data frame to another.
    Understanding these operations is essential for working with multiple data sources in Pandas.
    Made with HARPA AI

  • @anikkantisikder2179
    @anikkantisikder2179 Рік тому

    Great

  • @ArtyomAshigov-l8j
    @ArtyomAshigov-l8j Рік тому +3

    I watched other videos about Pandas, they were really good.
    I just wrote a comment here, that was probably deleted and I am not sure why

    • @AlexTheAnalyst
      @AlexTheAnalyst  Рік тому +3

      Had an issue with my first video and had to reupload - thanks for watching! :D

  • @the_seahawk22
    @the_seahawk22 Рік тому

    wait how did you get the file path link? Sorry I am not computer savy

    • @shivamborkotoky3788
      @shivamborkotoky3788 Рік тому

      after you download the file from the given link in description, copy the file path from your pc

  • @vintage_anime_vault
    @vintage_anime_vault 5 місяців тому

    wonder how many Data Analysts you made out there !!

  • @beingotaku9864
    @beingotaku9864 Рік тому +14

    Merge is bettter hands down.

  • @مسافر-ح2ط
    @مسافر-ح2ط 7 місяців тому

    Alex tell me the truth, are you a divine angel?

  • @yilmazah
    @yilmazah 2 місяці тому

    Selam. Oglun cok sansli, ona duskun bir babasi var masallah

  • @milanvulic7947
    @milanvulic7947 Місяць тому

    Barromir :O

  • @mdsy2707
    @mdsy2707 11 місяців тому

    1:38
    😂🤣🤣

  • @akzork
    @akzork Рік тому

    Dark mode when?

  • @patrickmeehan6856
    @patrickmeehan6856 Рік тому +2

    Barromir= Boromir

  • @ankuryadav9908
    @ankuryadav9908 Місяць тому +1

    #append_is_no_more

  • @jameelabduljalil25
    @jameelabduljalil25 Рік тому

    I thought Lord of the Rings sponsored this video.

  • @_sweeteststarr
    @_sweeteststarr 7 місяців тому

    Legolas 😂😂

  • @soundmagus
    @soundmagus 3 місяці тому

    Hey Alex, thanks for these videos they are great :) However i am getting different results from you when using df1.merge(df2), its showing IDs 1001,2,6,7,8 - and i cant figure out why, has soimething changed in the most up to date python? (also shows the same if i use df1.merge(df2, how = 'inner', on = ['FellowshipID', 'FirstName'])but with _x and y_ for Age.
    FellowshipID FirstName Age_x Age_y
    0 1001 Frodo 50 50
    1 1002 Samwise 39 39
    2 1006 Legolas 2931 2931
    3 1007 Elrond 6520 6520
    4 1008 Barromir 51 51