Pandas functions: merge vs. join vs. concat

Поделиться
HTML-код
  • Опубликовано: 22 ноя 2024

Комментарии • 63

  • @misraturp
    @misraturp  2 года назад +6

    Which Pandas functions would you like me to compare/explain next?

    • @YogiNotTheBear007
      @YogiNotTheBear007 2 года назад

      hi, could you please explain cut, apply and map?

    • @misraturp
      @misraturp  2 года назад +2

      @@YogiNotTheBear007 Added to the list! Thank you!

    • @arshad1781
      @arshad1781 2 года назад

      Make a complete video series A to Z step by step on Data science, Machine learning, Deep learning like hot 🔥 topic

    • @misraturp
      @misraturp  2 года назад

      @@arshad1781 Good idea, thanks Arshad!

    • @zulhishamtan4308
      @zulhishamtan4308 9 месяцев назад

      Merge_asof() is awesome for time series merging. Hope you can consider to make a video for it. Thanks again.

  • @mosama22
    @mosama22 8 месяцев назад +1

    Do you know what I really LOVE about your videos, you COVER THE WHOLE TOPIC, so if we talking about reshaping for example you mentioned all the 8 functions could be used and then you chose. Having the full picture really helps a lot. Even if you are an expert, going back to your videos, sometimes help remind us what other options do we have, or what other functions we might forget about.

  • @mosama22
    @mosama22 8 месяцев назад +2

    Thank you for the beautiful videos, I'd just appreciate if you added a link to the data set and the notebook you use for each video please, so we can follow up with you.
    Thanks a million again for the beautiful videos 🙂

  • @oscar-expertprojectmanager6733

    Thank you Misra. Great explanation on the Pandas functions: merge vs. join vs. concat. One comment I would make about using pd.set_options('display.max_rows', None) and pd.set_options('display.max_columns', None); If your dataset is large, you run the risk of crushing your notebook, and you would have to go through a process to fix it.

  • @bethuelthipe-moukangwe7786
    @bethuelthipe-moukangwe7786 Год назад

    The lessons about pandas are now making sense to me, especially on how to use groupby, apply ,apply map and lambda function.
    Big thanks Ms Misra Turp.

  • @gaganbhattacharya9890
    @gaganbhattacharya9890 11 месяцев назад

    I didn't know what does ''left_on & right_on' means in merge & the difference between merge & join but now I understand!
    Thanks!

  • @Xirato95
    @Xirato95 Год назад

    Thank you for your clear explanations! I love it how you explain it while using a simple example and go through it step by step. I’m new to Python and Pandas library and while looking up different functions the explanations can be a little bit overwhelming. You made this noobie prove! Keep up the good work and much appreciated!

    • @misraturp
      @misraturp  Год назад

      This is awesome to hear, you're welcome!

  • @kentjordan4658
    @kentjordan4658 Год назад +2

    May you provide the dataset? Thanks! 😄

  • @harishpoalampalli9637
    @harishpoalampalli9637 Год назад +1

    Hey Turp !! great explanantion !! Is it possibe to provide the data sets !! Thanks

  • @loordgo8772
    @loordgo8772 2 года назад +1

    thanx for the video. what about Merge Conflict? can be detected using Pandas?

  • @blackpenny9628
    @blackpenny9628 Год назад

    great...concise and straight

  • @SESHUNITR
    @SESHUNITR 2 года назад

    loved it Misra. clear explanation and a quick reference if we forget.

  • @ArunKumar-sc9dl
    @ArunKumar-sc9dl 2 года назад +1

    Thank you, very simple explanation.

  • @ahmedalhomeidy
    @ahmedalhomeidy 2 года назад

    clear explanation and precise and on to the point, I love it

  • @tusharwarade4603
    @tusharwarade4603 Год назад +1

    plz add datasets used in this video😊😊

  • @zulhishamtan4308
    @zulhishamtan4308 9 месяцев назад

    Thank you for the sharing... Awesome... I learnt a lot...

  • @avirajankitjain256
    @avirajankitjain256 Год назад +1

    Hi , where is the data set?

  • @khemrajpatil5683
    @khemrajpatil5683 2 года назад

    Thanks for the vide!. It gives me clarity.

  • @mariaclaraceballos3488
    @mariaclaraceballos3488 2 года назад

    thanks for the explanation! what happens if we use the function concat with 2 dataframes that have repeated data, i mean an ID that is in both dataframes?

  • @CultureofSpeech
    @CultureofSpeech Месяц назад

    Bravo 👏 Maestro 👏 Lit 🌠 Impressive 😍

  • @domillima
    @domillima Год назад

    When you merge left_on='ID', right_on='ID2'.. two columns of different names with the same IDs, is there a way to drop one of these, other than adding .dop(col_name) at the end? thanks

  • @vaibhavk2430
    @vaibhavk2430 2 года назад

    In streamlit can you implement direction feature like we have in google maps i.e. we choose our starting point and ending point and and there is a direction showing the way

    • @misraturp
      @misraturp  2 года назад

      I don't think so but then again I never tried doing that.

  • @ahamedsuhails
    @ahamedsuhails Год назад

    Thank you

  • @batyratayev2230
    @batyratayev2230 Год назад

    Thanks @misraturp!

  • @ishanseth4442
    @ishanseth4442 10 месяцев назад

    Thanks a lot

  • @GregThatcher
    @GregThatcher 7 месяцев назад

    Thanks!

  • @ashwinr1407
    @ashwinr1407 2 года назад

    clear and informative ! thanks.

  • @nicknicknick7860
    @nicknicknick7860 2 года назад

    Nailed the explanation, thank youu!

  • @AmitMishra-xd7yo
    @AmitMishra-xd7yo 2 года назад

    Thanks! It's pretty useful!

  • @86Maryj
    @86Maryj 2 года назад

    Hi can you please help to do pivot with multiple sheets

  • @abinetayele7901
    @abinetayele7901 2 года назад

    Perfect video.

  • @bryan-9742
    @bryan-9742 2 года назад

    I never got sent any of the cheat sheets. Are you sure that links is still functioning?

    • @misraturp
      @misraturp  2 года назад

      Hey Bryan, it should still be working. Could you check your spam folder. I see that someone with the name Bryan submitted the form but never confirmed their email. (Don't want to share the last name here but that could be you). Either way, if you cannot find the mail in your spam folder, you can get it here too: misraturp.gumroad.com/l/pandascs

  • @vigneshm4916
    @vigneshm4916 2 года назад

    Great video !

  • @vijhey3850
    @vijhey3850 2 года назад

    wheres video for group by ()?

  • @arshad1781
    @arshad1781 2 года назад

    Nice 👍

  • @busrauygun1158
    @busrauygun1158 Год назад

    Videolarınıza Türkçe altyazı ekleseniz Türkler de bu nimetten faydalansa çok güzel olmaz mı

  • @sanooosai
    @sanooosai 2 года назад

    rocker

  • @chethanhv3125
    @chethanhv3125 Год назад

    thanks @misra Turp

  • @kennethstephani692
    @kennethstephani692 Год назад

    Great video!!

  • @anurajms
    @anurajms Год назад

    thank you