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.

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:

✅ Support My Channel Through Patreon:

✅ Become a Channel Member:

✅ One-Time Contribution Through PayPal:

✅ Cryptocurrency Donations:
Bitcoin Wallet - 3MPH8oY2EAgbLVy7RBMinwcBntggi7qeG3
Ethereum Wallet - 0x151649418616068fB46C3598083817101d3bCD33
Litecoin Wallet - MPvEBY5fxGkmPQgocfJbxP6EmTo5UUXMot

✅ Corey's Public Amazon Wishlist

✅ Equipment I Use and Books I Recommend:

▶️ You Can Find Me On:

#Python #Pandas

[coreyms]

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

[xintongliu]

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

[nowyouknow]

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

[yashbhoyar]

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

[sakinakhan]

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.

[atharvaingle]

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

[mayankdwivedi]

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

[purushottammitra]

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

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]

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-yfjg]

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_chew]

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

[dhanapal]

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]

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

[joshuaj.aguero]

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

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

[MANISH]

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 .

[niloufarshahdoust]

Dear Corey Schafer, Pandas Tutorial Videos are nothing but AMAZING!! thank you million times!! :) :) <3 <3 everything is so clear and organized, I'm really really enjoying watching them. thank

[JoeBurnett]

Thank you for continuing to post these great tutorials!

[harshalbabu]

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