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
En esta página del sitio puede ver el video en línea Top 10 Common SQL operations to perform using Python Pandas de Duración hora minuto segunda en buena calidad , que subió el usuario GeoScope 12 septiembre 2021, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 1,541 veces y le gustó 68 a los espectadores. Disfruta viendo!