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
Get Python Jupyter Notebook used in this video here : https://github.com/akash19x/Tutorials...
Like, Share, Subscribe for more such contents.
Follow us on my other social media platforms :
Twitter: / techbieschannel
Machine Learning Blog : https://akashmishra.hashnode.dev
Instagram: / techbiesblog
#Python #MachineLearning #SQL
On this page of the site you can watch the video online Top 10 Common SQL operations to perform using Python Pandas with a duration of hours minute second in good quality, which was uploaded by the user GeoScope 12 September 2021, share the link with friends and acquaintances, this video has already been watched 1,541 times on youtube and it was liked by 68 viewers. Enjoy your viewing!
