Top 10 Common SQL operations to perform using Python Pandas

How can we perform basic SQL operations in Python?
Can we store large sql query results in variables and do manipulations on them?

Such questions will be answered in this video and also the basic operations like : Selecting the data, Using aggregate functions, Using Order By and Group By, Join operations, Inserting, Updating, Deleting etc will be explained too.

0:00 Introduction
1:05 Know the datasets
2:49 Selecting the Data
6:50 Aggregate Functions
9:10 Order By
11:21 Group By
13:45 IN and Not In
16:25 Joins
19:34 Creating new columns
21:27 Selecting Data Conditionally
24:16 Insert
26:47 Update
29:22 Delete

Like, Share, Subscribe for more such contents.

Follow us on my other social media platforms :

#Python #MachineLearning #SQL

[aloktripathi]

This is helpful, helped me in knowing sql with pandas

[annachan]

can u give us the files so we can access and follow along? seems a bit fruitless just watching u code

[indrar]

Am searching for this kind of video, thank finally u fulfilled my wish. God bless you man & keep educating us by posting such brilliant videos. I subscribed to ur channel.
And I actually need ur help in solving an assignment related to pandas and SQL. If u can help me then v can connect via Google meet for 10 minutes. It will be more helpful and am waiting for your response 🙏🙏🙏