Master Using SQL with Python: Lesson 1 - Using SQL with Pandas

Learn how to get jump-started in Python data analysis by using SQL, the language of relational database management systems. In this video, you will learn how you can instantly start using SQL to query Pandas data frames.

Join my Patreon Community and Watch this Video without Ads!

Twitter: @BryanCafferky

[vitalisdexter]

Thanks Bryan, I really love how you don't cut out the pronunciation mistakes, makes it fun to watch too.

[alrios]

Thanks, Bryan very didactic video. Topic important for anywhere developer working with data science.

[klzntek]

I am so happy to find this channel. Thank you so much!!

[tinavo]

Thank you for sharing the Microsoft Learning. It's like a whole new world to me! Thank you :)

[alexanderevans]

Refreshing video. Great work. Thank you!

[drywater]

Amazing video Bryan! Thank you so much.

[qiannanliu]

Thank you for sharing!!!! It helps a lot!

[linust]

Thank's Mr.Cafferky, it was very clear!

[jaydimayuga]

Nice simple tutorial easy to learn from ...

[Noobsmove]

Thanks a lot Bryan! Again another fantastic video^^

Does the recommended courses for a certification at Microsoft Learn contain all knowledge necessary for the certification?

I am asking because I would like to do the Data Science Associate Certification...

[carloss]

What an amazing video! Thank you so much Bryan!

[kphorce]

rock. Love from NYC. The Videos are Dope as Hell.
I want to become a Data Engineer, correction, I have to become a data engineer.
I am learning MYSQL and python at the moment. Do you have videos on Etracting and transforming the data?
If you have or going to make future videos let me know. I would subscribe to you but I have already done so, it
is sad I couldn't subscribe twice. keep the videos coming because I really appreciate the knowledge you are
dropping on us.

[marcosoliveira]

The type of content I was looking for!
+1

[summer-fn]

Thanks a lot sir!!!!please don't stop teaching us new things even if you get less audience and views....

[zarinabakhytzhan]

thank you very much. it was really clear and understandable 😅 watching videos night before the interview😂😂

[DaManOommen]

The index will go away if you assign the output of set index to another or the same variable and then call the sql command on that df.

[sheikhakbar]

Thanks for the video, this is my first video to learn SQL (I searched YT and decided that I will follow your course!) .. The reason why I decided to learn SQL now (besides my long-time interest in it) is that I am scraping a website, and I could already see that scraped data will be huge to be handled by Pandas (something around 60 GB) .... So my question, is SQL the right data structure to access data of this size? Would you recommend something else? I am pretty much comfortable with pandas, but once DataFames exceed 2 GB pandas become useless.

[akj]

Thanks Bryan, what would you use for a 5TB SQL data if you need to analyze it? Thanks.

[arashahadi]

Can you do left join on index? like on (c.index = s.index)?

[tirtha]

Lets say a pandas df have column A, B, C and same is written to a mysql database

now how to upsert a pandas df to mysql table?
lets say we have a new similar df, now
If column A matches update the row in Mysql ie Column B, and C
If column a it not found, then do an Insert into

whats the most efficient way to do this?