Python Pandas Tutorial (Part 11): Reading/Writing Data to Different Sources - Excel, JSON, SQL, Etc

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

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

  • @coreyms
    @coreyms  4 года назад +125

    If anyone would like to jump to a specific file format, here are the timestamps for the video:
    Read CSV - 0:56
    Write CSV - 3:20
    Write TSV - 4:40
    Read TSV - 6:00
    Write Excel - 6:15
    Read Excel - 10:42 (Start at 6:15 to see installed packages)
    Write JSON - 12:18
    Read JSON - 15:41
    Write SQL - 16:59
    Read SQL - 24:57 (Start at 16:59 to see installed packages)
    Hope everyone is staying safe and healthy! I'm going to be taking a break from the Pandas series for a bit after this video. I'd like to cover some fun one-off videos where we can do some API coding. Suggestions are welcome. I might try to do a video on the RUclips API, Twitter, Reddit, and some others. Hope you're all having a great week!

    • @GamerDra
      @GamerDra 4 года назад +5

      Can we get machine learning?

    • @AngelTaylorgang809
      @AngelTaylorgang809 4 года назад +1

      No thanks, I’ll just watch the entire video lol

    • @ramil17998
      @ramil17998 4 года назад +2

      RUclips API could be really fun!

    • @migueldomingos4570
      @migueldomingos4570 4 года назад +1

      Do you have any personal projects you are working on?

    • @kevingzc334
      @kevingzc334 4 года назад

      For Mysql could you explain the difference please ?

  • @yashbhoyar7889
    @yashbhoyar7889 4 года назад +85

    just finished the playlist and Now i can say that I know pandas much well, before i was struggling to understand how to learn and how to use pandas , now I am feeling pretty confident.Thanks Corey Sir, great teacher , I think I got a great mentor for my journey of a data scientist

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

      what are you doing these days? working?

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

      That's playlists covers all things of pandas ?

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

      ​@@ce13_piyushprajapati40only basics of pandas

  • @nowyouknow2249
    @nowyouknow2249 4 года назад +110

    while True:
    print("Thanks Corey! ✌️")

  • @xintongliu8068
    @xintongliu8068 4 года назад +134

    We made it! High five guys.
    Move to the plot series.

    • @datascience9224
      @datascience9224 3 года назад +1

      High Five!!

    • @ironpolux
      @ironpolux 3 года назад +1

      */*Pulls out a bottle of purel*/* Hi five buddy!!

  • @sakinakhan8586
    @sakinakhan8586 2 года назад +9

    Hello , I have finally completed all 11 videos and would like to thank you because now from having zero knowledge in pandas I can do much more than I imagined. THANK YOU . Really appreciate all your efforts.

  • @AbdulWahid-fi7vs
    @AbdulWahid-fi7vs 3 года назад +1

    Just finished the Panadas tutorial:
    First of All i am highly thankful for Brilliant to sponsor a free tutorial and then for Corey Schafer. I would say! what a talent of teaching.

  • @ryan_chew97
    @ryan_chew97 4 года назад +12

    god damn that was painful. But in two days, I went from pandas novice to pretty damn confident in pandas just by watching this series. You are literally insane. Not kidding

  • @sahajrajmalla
    @sahajrajmalla 4 года назад +31

    upload more sir, your tutorials are the best in my point of view!

  • @atharvaingle3567
    @atharvaingle3567 4 года назад +4

    Hands down to the best tutorial series on Pandas for someone looking forward to getting started with Data Analysis.
    Thank you, Corey, for making things easy .......

  • @Abdirahman2323
    @Abdirahman2323 5 месяцев назад +2

    finally completed and now I assume that i can discuss data analysis while i have SQL knowledge before thank you very much Corey Schafer.

  • @niloufarshahdoust7952
    @niloufarshahdoust7952 4 года назад +4

    Dear Corey Schafer, Pandas Tutorial Videos are nothing but AMAZING!! thank you million times!! :) :)

  • @mayankdwivedi7169
    @mayankdwivedi7169 4 года назад +23

    I would like to say "THANK YOU" for bringing awesome series.
    All 11 videos are full of content, practical and very informative.
    I really appreciate your inspiration and hard work in putting this together !!

  • @purushottammitra1258
    @purushottammitra1258 4 года назад +14

    I was searching for some decent Panda tutorials over RUclips,,,, And finally found these tutorials,,, It is undoubtedly the best I ever found and each and every code snippets are clearly described,,,Thanks a Ton,,, Corey 👍

  • @soumyadippal3443
    @soumyadippal3443 4 года назад +2

    This is a real GEM of a series.

  • @harinath_mishra
    @harinath_mishra 4 года назад +6

    I was waiting for next video of the pandas series.........for week thanks for providing this series..........😊😊
    Thanks a lot corey sir...... 😍 😍 loving your python videos from India........

  • @SuperNovaxFF
    @SuperNovaxFF 4 месяца назад +1

    Even after 4 years of changes to pandas module this playlist still Gold one ❤

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

    Best Pandas series on the internet. Thanks so much Corey!!

  • @j._7054
    @j._7054 3 года назад +1

    Huge thanks for this series! For two days I couldn't stop watching and taking notes. Feels good to have a clue what I'm looking at now when I see examples online, and am finally able to work effectively with my data. Also signed up for brilliant so thanks for the 20%.

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

      hey could you please share the notes

  • @fenilpatel7698
    @fenilpatel7698 4 года назад +5

    If you like something and doctor says you eat that this is the moment for me thank you Corey for this.🙌

  • @КириллКириллович
    @КириллКириллович 2 года назад +3

    I've completed this series of videos by 2 days and now I feel free to read DS code and solve some tasks by my own.
    I'm a professional computer programmer and all these 11 videos are gorgeous, full of content, easy to understand for non-naitive English speakers.
    Thank you a lot, Mr Schafer, I cannot express enough how much your job has meant to me!

  • @nghiepcrypto7034
    @nghiepcrypto7034 4 года назад +2

    Sometimes I know the skill already, but cannot resist myself to click play button. When I have a thought that I should switch watching something else, I feel guilty because your videos are so good.
    Thanks from Viet Nam

  • @nehapant1027
    @nehapant1027 4 года назад +15

    Thank you for making everything so easy .

  • @dhanapal1123
    @dhanapal1123 4 года назад +8

    The entire series was very informative , easy to understand and useful for a beginner like me . Thank you Corey _/\_ . Keep up the good work.

  • @ManishKumar-yf8jg
    @ManishKumar-yf8jg 4 года назад +4

    Hey Corey!!!! Thanks for adding this up...we are quarantine and want to utilise this time by learning from you... please add up here more!!!! Million thanks ♥️

  • @hasanuzzamananuz8270
    @hasanuzzamananuz8270 4 года назад

    This is the best pandas tutorial series that I had seen. If I watched it before I didn't get for the paid course

  • @algiffaryriony
    @algiffaryriony 4 года назад +1

    Thank you so much for keeping the series alive! I just finished the last ten videos and the timing couldnt have been better. I hope you'd take as long as you need to finish this series or the other tutorial series. You don't owe your viewers anything and besides you might ruin the quality of the series if you finished it for the sake of finishing it.

  • @venukumar6291
    @venukumar6291 4 года назад +3

    Thanks Corey😊😊😊
    You have been my mentor ... Your tutorials and explanation is very great......Thanks a lot for sharing knowledge.

  • @MANISH12665
    @MANISH12665 5 месяцев назад

    Thank you so Corey finally completed the whole playlist of Pandas series of 11 videos now i am feeling much more confident in Pandas .thank you so so much .

  • @JoeBurnett
    @JoeBurnett 4 года назад +5

    Thank you for continuing to post these great tutorials!

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

    Clearly the best tutor when it comes to Python. Thanks a lot!!,

  • @moushumitamanna
    @moushumitamanna 4 года назад +2

    stay safe Corey. Love all your tutorials.

  • @EnglishGeekWahoo
    @EnglishGeekWahoo 4 года назад +1

    Thank you, Corey, that was a very helpful beginning for me, I liked the long video trend of you because giving up is harder when you feel the journey is short but the fun is massive!!

  • @mangaart3366
    @mangaart3366 3 года назад +1

    Thanks Corey for the series. It was amazing!

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

    I'm getting ready to do my Masters in Data Science, I just finished the playlist in 2 days. I am simply amazed by the content, many thanks, God bless you!

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

    Hey Corey!
    Just letting you know that I've completed this series .
    Thank you very much Corey for this .

  • @LidyaEskinder-i2f
    @LidyaEskinder-i2f 4 месяца назад

    so cool of u to suggest other channels, don't see that more often that's the "abundance spirit" that i love.

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

    just finished the course , thank you so much for what youre doing.This was thaught excellently and I will recommend it to anyone wanting to learn pandas

  • @undisclosedmusic4969
    @undisclosedmusic4969 4 года назад +4

    Don’t have time to watch right now but opened the video just to give it a thumbs up

  • @llatyntseva
    @llatyntseva 7 месяцев назад +1

    Thanks!

  • @SilasDBrito
    @SilasDBrito 4 года назад +2

    I've just started a formation where we have to learn mostly by ourself.
    The staff just give us some hints and some objectives.
    You saved me this week ^^ you got a new sub. thx for that playlist.

  • @jlin74
    @jlin74 3 года назад

    While there are many good youtube teachers, but Corey you are the best! Thank you very much!

  • @Once-Upon-A-Dime
    @Once-Upon-A-Dime 2 года назад

    Saw your entire playlist on Pandas. Thank you very much sir and love from India.

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

    Thanks Corey.i learned a lot from your channel which is valuable for my data science career. I watched the list in this lesson completely. It's worth more to me. ❤💯

  • @kehagupta142
    @kehagupta142 5 месяцев назад

    Amazing !! Easily and clearly understood pandas. Thanks a lot!!

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

    Just finished an let me say, you, Corey Schafer, are a GOD!

  • @deepsasmal578
    @deepsasmal578 4 года назад

    Well done! Corey , completed the entire series in one day. Keep up the good work.

  • @harshalbabu45
    @harshalbabu45 4 года назад +3

    It's really an amazing help. You're making this quarantine the most productive time in my life so far 🙂

  • @zhalie12345
    @zhalie12345 4 года назад

    Finished part 11 and just wanna say thanks for the awesome tutorial sir !
    Stay healthy and love from Indonesia...

  • @anycatdessai
    @anycatdessai 4 года назад +2

    Thanks for this series, your videos could cause a change of career path for me.

  • @charlesjackson1796
    @charlesjackson1796 4 года назад +1

    Nice series. Very informative and straightforward. Thank you Corey.

  • @akshaychoudhary5770
    @akshaychoudhary5770 5 месяцев назад

    Thanks Chorey!! completed all 11 videos on pandas & its extremely helpful

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

    Thank you for this wonderful course on Pandas, Corey, I enjoyed it too much. You are the Panda Man!

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

    Thanks Corey (and Brilliant) for this excellent series of tutorials. 🎉

  • @ironpolux
    @ironpolux 3 года назад

    Yo corey! you are great! we cant thank enough, and yes every single one of us is waiting for more content about pandas and data.

  • @shwetaredkar734
    @shwetaredkar734 4 года назад +9

    I love Corey

  • @sinanyaman2007
    @sinanyaman2007 4 года назад

    Corey, I am grateful I discovered this channel better late than never. Your vids and explanations are amaaaazing! Now I am gonna go ahead and watch all of your videos lmao

  • @joshuaj.aguero2225
    @joshuaj.aguero2225 3 года назад

    These videos are amazing. You really are a great teacher. You make it so easy to understand the concepts you're showing us. I have learned so much by watching you and following along. I know I haven't absorbed it all quite yet and I'll be revisiting these videos until I internalize it all. Thank you for putting this information out there for everyone to access. Its amazing that there is so much knowledge out there available for free.

  • @mohammedka.3657
    @mohammedka.3657 2 года назад

    thank you corey, i used your tutorials to revise and enforce my learning journey .. thank you

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

    Thank you for your tutorials. It seems you allowed me to explore pandas fairly deeply

  • @nothingDone-ei2fj
    @nothingDone-ei2fj Год назад

    Great videos on pandas series. Thank you very much Corey Schafer. Just completed all videos.

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

    Corey, Thanks so much for this video series. You helped me a lot. Im planning to learn ML and AI. And your this video series help me a lot to learn Pandas. Thanks so much for this freee video series. You are the best Tutor. Really grateful..

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

    Awesome, comprehensible content, Corey! Very well done. Thank you!😊

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

    This is an awesome series! Thanks for such a quality content and waiting for upcoming one.

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

    Thanks for this excellent introduction to Pandas. From this point, I plan on reading Wes McKinney's Panda's book and completing Boris Paskhaver's Pandas course to enhance and prove my knowledge of pandas.

  • @Ruben-rj9ux
    @Ruben-rj9ux 4 года назад

    I like your full 11 videos tutorial! You did a great job! Congrats!

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

    Thanks Corey, I needed a Pandas refresher and this was great

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

    完结,撒花~ Thanks Corey! You're doing great job here! those videos are really helpful!

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

    Thank you Corey for such amazing content for free

  • @mem191919
    @mem191919 4 года назад +1

    Thank U Corey for all the videos uploaded, they have been really useful.

  • @MrVivekc
    @MrVivekc 4 года назад +1

    your tutorials are very helpful in optimum utilization of the lockdown time. Thanks from India..

  • @HarmanHundal01
    @HarmanHundal01 3 года назад

    Thank you for this entire Series. ! India loves you Corey !!

  • @mary.a5898
    @mary.a5898 Год назад

    You were great Corey. Thank you so much. We're looking forward to your upcoming tutorials

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

    Thank you so much Corey. It was a wonderful series to cover.

  • @orkhangasanov
    @orkhangasanov 4 года назад +10

    If you are facing with an error: "excel xlsx file not supported", try this: test = pd.read_excel('data/modified.xlsx', index_col='Respondent', engine='openpyxl').

  • @garvitkumar3013
    @garvitkumar3013 4 года назад

    Thank you Corey for your tutorials. please teach us ML as it is very confusing topic and you are the only one who can teach us properly.

  • @ektabansal7109
    @ektabansal7109 5 месяцев назад

    A great pandas series !! Thanks a lot Corey

  • @swadhikarc7858
    @swadhikarc7858 4 года назад

    Hi Corey, first of thanks for the phenomenal pandas tutorial series, you have nailed it as usual. Also, thanks much for considering India in order to show the examples. With true gratitude and love from India

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

    Best pandas tutorial on yt - many thanks ;)

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

    Hey Corey, Thank you so much for such an awesome series!!. Great content, good tips and suggestions.

  • @vivekr4690
    @vivekr4690 4 года назад

    congrats on reaching 500K subscribers! Your videos have been of immense help!
    Please keep up the good work and stay safe!

  • @fatihcamgoz
    @fatihcamgoz 4 года назад +1

    What a great series! I enjoyed it and learned a lot. Thanks so much

  • @archie1810
    @archie1810 4 года назад +1

    Corey... You're brilliant!... Thank you.

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

    This was a BEAUTIFUL series 😊😊

  • @manojdevareddy8831
    @manojdevareddy8831 4 года назад +2

    Learning a lot because of u sir..🥰😍🤩😘

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

    Just finieshed the playlist.
    Awesome teacher.

  • @pdboudreau
    @pdboudreau 4 года назад +1

    You rock Corey! Keep up the great work!

  • @eltorayy11
    @eltorayy11 3 года назад

    Thanks so much!! I have been wondering how to connect mysql to python and i managed to do that using mysqlclient after watching this. You amazinggg

  • @GeoPoly55
    @GeoPoly55 4 года назад +3

    Love you corey. Thanks for the such awesome content. I really enjoyed it. ❤😘

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

    Hey Corey, I learned a ton by your panda course... thanks good luck 🎉🎉🎉

  • @ChandraShekhar-ds8cp
    @ChandraShekhar-ds8cp 4 года назад

    Your videos are just amazing Corey. Your videos are full of something new. I've learned a lot and looking forward to learn more . Thanks a ton...
    Keep it Going:)

  • @jameskulu
    @jameskulu 4 года назад +1

    Congratualations for 500k subscribers Corey !!!!!!!!!!

  • @arwahsapi
    @arwahsapi 4 года назад

    With all the knowledge you have and share on Python I have a feeling it was you who created the language.

  • @airsofttrooper08
    @airsofttrooper08 4 года назад

    Has anyone finished watching all 138 videos in his Python Tutorial playlist? if so, are you fluent in python yet? can you do pretty much anything? I'm on his 9th tutorial and I have learned a ton already. I'm just worried I wont be able to implement the knowledge practically once I learn it, I know this will take more time and practice in itself. I plan on finishing a tutorial or 2 a day until I have finished every one! Give me your reviews guys and thank you Corey for all your hard work! you're an amazing teacher. Keep it up,

  • @saipavanthota3568
    @saipavanthota3568 4 года назад +1

    Thanks for such informative course.

  • @elnazdehkharghani6121
    @elnazdehkharghani6121 4 года назад +1

    Just like always, Great Tutorial 👌

  • @the-ghost-in-the-machine1108
    @the-ghost-in-the-machine1108 Год назад

    ---- FINISH ----- appreciate your work sir.

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

    Hey Corey, greetings from Turkey, very good tutorial, thank you very much ..

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

    Simply loved the contents provided by corey. You are one in a million teachers whom should be admired forever for the teaching :)

  • @manosveisakis8030
    @manosveisakis8030 4 года назад

    Wonderful series Corey! Keep up the good work!

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

    Thank you so much Corey for this series!