Convert SQL Queries into Python Pandas | Part-3 | UNION JOIN INSERT UPDATE DELETE

Welcome to "The AI University".
About this video:
This Part-3 video of "Convert SQL Queries into Python Pandas | Part-3 | UNION JOIN INSERT UPDATE DELETE" series explains python pandas equivalent statements of SQL queries from the perspective of performing exploratory data analysis before building machine learning models. It will cover SQL constructs like UNION ALL, UNION, JOIN, INSERT, UPDATE, DELETE, IN, NOT IN.

Subtitles available in: English

FOLLOW ME ON:

About this Channel:
The AI University is a channel which is on a mission to democratize the Artificial Intelligence, Big Data Hadoop and Cloud Computing education to the entire world. The aim of this channel is to impart the knowledge to the data science, data analysis, data engineering and cloud architecture aspirants as well as providing advanced knowledge to the ones who already possess some of this knowledge.

Please share, comment, like and subscribe if you liked this video. If you have any specific questions then you can comment on the comment section and I'll definitely try to get back to you.

*******Other AI, ML, Deep Learning, Augmented Reality related Video Series*****

******************************************************************

#SQLtoPython #SQLtoPandas #ExploratoryDataAnalysis

[TheAIUniversity]

In order to perform exploratory data analysis, do you you mostly use Python or SQL ?

[powerofpeace]

Hi Sir, Thank you, sir. It's a great explanation and it will useful concepts. Thank you

[Eltoncbraz]

That was awesome 👏🏻 . Thanks you for sharing your knowledge! It will help me a lot to analize Telecommunication Data!

[Karmihir]

Could you please share the case, decide, group by operations using python

[hectors]

Yours are some of the best examples I have seen.
I recently needed to replace a value in a column named Response with a substring of that column. (the date had other values "xx01/01/2001bbb") when a different column named ColType had a value of "Date" . Would something like the following do that.


This would equate to Sql: Update customers set Response = substring(Response, 2, 8) where ColType = 'Date'
customers = == 'Date', 'Response'] = customers.Response[2:10]


Most of the examples I have seen has been assigning a value but not from a calculated value. Does this make sense?

[cutyoopsmoments]

Bro, can u tell how I convert English speaking video into Hindi speaking video....????

[BlueSkyGoldSun]

For join you used left join because the relation is one to one ?

[BHARATHEEYUDU.]

super explanation sir
I Have a doubt in real time work sql to dataframe converting and manipulating the data is necessary
or pd.read.sql(sql, con)
query is enough to python data anlayst job profile