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

In this video, we will be learning how to import and export data from multiple different sources. We will cover CSV, JSON, Excel, SQL, and more.
This video is sponsored by Brilliant. Go to brilliant.org/cms to sign up for free. Be one of the first 200 people to sign up with this link and get 20% off your premium subscription.
In this Python Programming video, we will be learning how to load and save data using multiple different sources. We will learn how to read/write data to CSV, JSON, Excel, SQL, and more. This covers the vast majority of formats you'll see in the data science field and will be extremely useful to know. Let's get started...
Video Timestamps:
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)
The code for this video can be found at:
bit.ly/Pandas-11
StackOverflow Survey Download Page - bit.ly/SO-Survey-Download
Environment Variables Tutorial - • Python Quick Tip: Hidi...
✅ Support My Channel Through Patreon:
/ coreyms
✅ Become a Channel Member:
/ @coreyms
✅ One-Time Contribution Through PayPal:
goo.gl/649HFY
✅ Cryptocurrency Donations:
Bitcoin Wallet - 3MPH8oY2EAgbLVy7RBMinwcBntggi7qeG3
Ethereum Wallet - 0x151649418616068fB46C3598083817101d3bCD33
Litecoin Wallet - MPvEBY5fxGkmPQgocfJbxP6EmTo5UUXMot
✅ Corey's Public Amazon Wishlist
a.co/inIyro1
✅ Equipment I Use and Books I Recommend:
www.amazon.com/shop/coreyschafer
▶️ You Can Find Me On:
My Website - coreyms.com/
My Second Channel - / coreymschafer
Facebook - / coreymschafer
Twitter - / coreymschafer
Instagram - / coreymschafer
#Python #Pandas

Пікірлер: 332

  • @coreyms
    @coreyms4 жыл бұрын

    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 KZread API, Twitter, Reddit, and some others. Hope you're all having a great week!

  • @GamerDra

    @GamerDra

    4 жыл бұрын

    Can we get machine learning?

  • @AngelTaylorgang809

    @AngelTaylorgang809

    4 жыл бұрын

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

  • @ramil17998

    @ramil17998

    4 жыл бұрын

    KZread API could be really fun!

  • @migueldomingos4570

    @migueldomingos4570

    4 жыл бұрын

    Do you have any personal projects you are working on?

  • @kevingzc334

    @kevingzc334

    4 жыл бұрын

    For Mysql could you explain the difference please ?

  • @xintongliu8068
    @xintongliu80684 жыл бұрын

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

  • @datascience9224

    @datascience9224

    3 жыл бұрын

    High Five!!

  • @ironpolux

    @ironpolux

    2 жыл бұрын

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

  • @nowyouknow2249
    @nowyouknow22494 жыл бұрын

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

  • @yashbhoyar7889
    @yashbhoyar78894 жыл бұрын

    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

    Жыл бұрын

    That's playlists covers all things of pandas ?

  • @uralbeking

    @uralbeking

    9 ай бұрын

    ​@@ce13_piyushprajapati40only basics of pandas

  • @sakinakhan8586
    @sakinakhan8586 Жыл бұрын

    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.

  • @atharvaingle3567
    @atharvaingle35674 жыл бұрын

    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 .......

  • @mayankdwivedi7169
    @mayankdwivedi71694 жыл бұрын

    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
    @purushottammitra12584 жыл бұрын

    I was searching for some decent Panda tutorials over KZread,,,, 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 👍

  • @EnglishGeekWahoo
    @EnglishGeekWahoo4 жыл бұрын

    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!!

  • @SilasDBrito
    @SilasDBrito4 жыл бұрын

    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.

  • @ManishKumar-yf8jg
    @ManishKumar-yf8jg4 жыл бұрын

    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 ♥️

  • @ryan_chew97
    @ryan_chew973 жыл бұрын

    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

  • @dhanapal1123
    @dhanapal11234 жыл бұрын

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

  • @sahajrajmalla
    @sahajrajmalla4 жыл бұрын

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

  • @joshuaj.aguero2225
    @joshuaj.aguero22253 жыл бұрын

    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.

  • @j._7054
    @j._70543 жыл бұрын

    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

  • @MANISH12665
    @MANISH1266518 күн бұрын

    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 .

  • @niloufarshahdoust7952
    @niloufarshahdoust79524 жыл бұрын

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

  • @coreyms

    @coreyms

    4 жыл бұрын

    Thanks!

  • @JoeBurnett
    @JoeBurnett4 жыл бұрын

    Thank you for continuing to post these great tutorials!

  • @harshalbabu45
    @harshalbabu454 жыл бұрын

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

  • @deepsasmal578
    @deepsasmal5783 жыл бұрын

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

  • @mehdiezzine292
    @mehdiezzine29210 ай бұрын

    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

  • @soumyadippal3443
    @soumyadippal34434 жыл бұрын

    This is a real GEM of a series.

  • @mangaart3366
    @mangaart33663 жыл бұрын

    Thanks Corey for the series. It was amazing!

  • @AbdulWahid-fi7vs
    @AbdulWahid-fi7vs2 жыл бұрын

    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.

  • @nehapant1027
    @nehapant10274 жыл бұрын

    Thank you for making everything so easy .

  • @jaxnaur218
    @jaxnaur2182 жыл бұрын

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

  • @vipulsuthar3796
    @vipulsuthar37966 ай бұрын

    Thank you so much Corey for this series!

  • @venukumar6291
    @venukumar62914 жыл бұрын

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

  • @fenilpatel7698
    @fenilpatel76984 жыл бұрын

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

  • @coldy5845
    @coldy58454 жыл бұрын

    Thank you for the amazing Pandas series, Corey! I really can't thank you enough for sharing such a great knowledge in a so clear and understandable way. Thank you, brother. You are the man. It would be nice if you also make a series on Machine Learning. The are also a lot of people, who asked about it, I guess.

  • @priyaramraj5207
    @priyaramraj520711 ай бұрын

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

  • @ektabansal7109
    @ektabansal710923 күн бұрын

    A great pandas series !! Thanks a lot Corey

  • @davidcardenas4266
    @davidcardenas4266 Жыл бұрын

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

  • @mem191919
    @mem1919194 жыл бұрын

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

  • @vrushalinehe6297
    @vrushalinehe62974 ай бұрын

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

  • @fatihcamgoz
    @fatihcamgoz3 жыл бұрын

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

  • @lemonteurdesanuseur9686
    @lemonteurdesanuseur96864 ай бұрын

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

  • @charlesjackson1796
    @charlesjackson17964 жыл бұрын

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

  • @sinanyaman2007
    @sinanyaman20074 жыл бұрын

    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

  • @anycatdessai
    @anycatdessai4 жыл бұрын

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

  • @mohammedka.3657
    @mohammedka.36572 жыл бұрын

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

  • @ChandraShekhar-ds8cp
    @ChandraShekhar-ds8cp4 жыл бұрын

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

  • @cybersphere
    @cybersphere2 жыл бұрын

    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.

  • @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!

  • @mary.a5898
    @mary.a589810 ай бұрын

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

  • @harinath_mishra
    @harinath_mishra4 жыл бұрын

    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........

  • @darkbanditEX
    @darkbanditEX2 жыл бұрын

    Thank you Corey What a great series

  • @Ruben-rj9ux
    @Ruben-rj9ux3 жыл бұрын

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

  • @swadhikarc7858
    @swadhikarc78584 жыл бұрын

    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

  • @jlin74
    @jlin743 жыл бұрын

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

  • @ftronkoso
    @ftronkoso6 ай бұрын

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

  • @kehagupta142
    @kehagupta14215 күн бұрын

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

  • @prasadnirmal6426
    @prasadnirmal64263 ай бұрын

    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. ❤💯

  • @moushumitamanna
    @moushumitamanna4 жыл бұрын

    stay safe Corey. Love all your tutorials.

  • @shwetaredkar734
    @shwetaredkar7344 жыл бұрын

    I love Corey

  • @natashaanstey2063
    @natashaanstey20634 жыл бұрын

    These videos are really really great, thank you so much! I would love a video explaining more about the openpyxl module if possible. Cheers!

  • @flavio4923
    @flavio49232 жыл бұрын

    Thank you for this series, I watched the whole thing and hope to watch more of your tutorials. :D

  • @woestyn202
    @woestyn202 Жыл бұрын

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

  • @zhalie12345
    @zhalie123453 жыл бұрын

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

  • @neilcollins7726
    @neilcollins77265 ай бұрын

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

  • @ronenportnoy4263
    @ronenportnoy4263 Жыл бұрын

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

  • @nothingDone-ei2fj
    @nothingDone-ei2fj9 ай бұрын

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

  • @akshaychoudhary5770
    @akshaychoudhary577010 күн бұрын

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

  • @manosveisakis8030
    @manosveisakis80303 жыл бұрын

    Wonderful series Corey! Keep up the good work!

  • @tav9755
    @tav97557 ай бұрын

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

  • @TheGauss
    @TheGauss Жыл бұрын

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

  • @jacktran5260
    @jacktran52604 жыл бұрын

    Hi Corey. I just wanted to thank you so much for your tutorial in Django and hope you will release some more features to your blog web application soon! I will be slowly moving towards your Panda and Matplotlib tutorial after as the skills you have taught us are invaluable in the real world for employment.

  • @pdboudreau
    @pdboudreau4 жыл бұрын

    You rock Corey! Keep up the great work!

  • @hasanuzzamananuz8270
    @hasanuzzamananuz82703 жыл бұрын

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

  • @redviper20
    @redviper203 жыл бұрын

    Dude... that was a great series!

  • @ibrahimbadhusha1401
    @ibrahimbadhusha14012 жыл бұрын

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

  • @nghiepcrypto7034
    @nghiepcrypto70344 жыл бұрын

    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

  • @Mahima_Yadav1
    @Mahima_Yadav1 Жыл бұрын

    Really helpful series, thank you for putting this together!

  • @Pragmatyk91
    @Pragmatyk91 Жыл бұрын

    Best pandas tutorial on yt - many thanks ;)

  • @Once-Upon-A-Dime
    @Once-Upon-A-Dime2 жыл бұрын

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

  • @abhishekbs1904
    @abhishekbs19042 жыл бұрын

    Thank you Corey for this amazing Playlist on Pandas

  • @algiffaryriony
    @algiffaryriony4 жыл бұрын

    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.

  • @algiffaryriony

    @algiffaryriony

    4 жыл бұрын

    testt

  • @algiffaryriony

    @algiffaryriony

    4 жыл бұрын

    test

  • @aninehartog3950
    @aninehartog39503 жыл бұрын

    Thanks to very much for this series!

  • @shreyashkashyap
    @shreyashkashyap Жыл бұрын

    Thank you Corey for such amazing content for free

  • @finncollins5696
    @finncollins569611 ай бұрын

    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..

  • @manabean8145
    @manabean8145 Жыл бұрын

    Thank you for such high quality contents on pandas! Great for beginners.

  • @eltorayy11
    @eltorayy113 жыл бұрын

    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

  • @garvitkumar3013
    @garvitkumar30134 жыл бұрын

    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.

  • @soheylmoheb7273
    @soheylmoheb72739 ай бұрын

    Just finieshed the playlist. Awesome teacher.

  • @undisclosedmusic4969
    @undisclosedmusic49694 жыл бұрын

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

  • @archie1810
    @archie18104 жыл бұрын

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

  • @bevg1
    @bevg12 жыл бұрын

    Thank you for making these videos!!

  • @arunachalamm3399
    @arunachalamm3399 Жыл бұрын

    Amazing series man, thanks a lot

  • @user-zg2bx5cb3d
    @user-zg2bx5cb3d Жыл бұрын

    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!

  • @didierleprince6106
    @didierleprince61064 жыл бұрын

    Enfin! Merci !

  • @SleepyAizawa69
    @SleepyAizawa697 ай бұрын

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

  • @vitellinho
    @vitellinho2 ай бұрын

    great video and great pandas tutorial playlist, thank you very much.

  • @blaze-pn6fk
    @blaze-pn6fk4 жыл бұрын

    Thank you sm for these Tutorials

  • @HarmanHundal01
    @HarmanHundal013 жыл бұрын

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

  • @AmanChauhan-hy1sb
    @AmanChauhan-hy1sb4 жыл бұрын

    Really appreciate your Effort. Thanks a ton Corey. Its time to share Pandas playlist with colleagues.

  • @mosama22
    @mosama22 Жыл бұрын

    This was a BEAUTIFUL series 😊😊

  • @davidburns7045
    @davidburns70453 жыл бұрын

    Great series. Thank you.

  • @vivekr4690
    @vivekr46904 жыл бұрын

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

  • @coreyms

    @coreyms

    4 жыл бұрын

    Thanks!

  • @mariusmiginis2623
    @mariusmiginis26232 жыл бұрын

    Thank you man! great tutorial