FROM
SQL
TO
PANDAS
Uzwal Goud Vaddeboina
INDEX
SELECT ALL COLUMNS COLUMNS
SELECT SINGLE COLUMN ADD SINGLE COLUMN
SELECT MULTIPLE COLUMNS DROP SINGLE COLUMN
FILTER ROWS DROP MULTIPLE COLUMNS
TOP N ROWS RENAME SINGLE COLUMN
DISTINCT VALUES RENAME MULTIPLE COLUMNS
COUNT OF DISTINCT VALUES UPDATE
COUNT OF TOTAL VALUES UPDATE SINGLE COLUMN SINGLE ROW
STRUCTURE OF TABLE UPDATE MULTIPLE COLUMNS SINGLE ROW
DESCRIPTIVE STATISTICS UPDATE SINGLE COLUMN MULTIPLE ROWS
GROUP BY SINGLE COLUMN UPDATE MULTIPLE COLUMNS MULTIPLE ROWS
SORT BY SINGLE COLUMN UPDATE SINGLE COLUMN ALL ROWS
SORT BY MULTIPLE COLUMNS
COUNT OF UNIQUE VALUES
DROP ROW - ALL COLUMNS DUPLICATED
DROP ROW - KEY COLUMN DUPLICATED
JOINS
INNER JOIN
LEFT JOIN
RIGHT JOIN
FULL JOIN
CROSS JOIN
UNION
UNION ALL BY SINGLE COLUMN
UNION ALL BY ALL COLUMNS
UNION BY SINGLE COLUMN
UNION BY ALL COLUMNS Uzwal Goud Vaddeboina
SELECT ALL COLUMNS
Uzwal Goud Vaddeboina
SELECT SINGLE COLUMN
Uzwal Goud Vaddeboina
SELECT MULTIPLE COLUMNS
Uzwal Goud Vaddeboina
FILTER ROWS
Uzwal Goud Vaddeboina
TOP N ROWS
Uzwal Goud Vaddeboina
DISTINCT VALUES
Uzwal Goud Vaddeboina
COUNT OF DISTINCT VALUES
Uzwal Goud Vaddeboina
COUNT OF TOTAL VALUES
table/dataframe
Uzwal Goud Vaddeboina
STRUCTURE OF TABLE
table/dataframe
Uzwal Goud Vaddeboina
DESCRIPTIVE STATISTICS
Uzwal Goud Vaddeboina
GROUP BY SINGLE COLUMN
Uzwal Goud Vaddeboina
SORT BY SINGLE COLUMN
Uzwal Goud Vaddeboina
SORT BY MULTIPLE COLUMNS
Uzwal Goud Vaddeboina
COUNT OF UNIQUE VALUES
Uzwal Goud Vaddeboina
DROP ROW - ALL COLUMNS DUPLICATED
Uzwal Goud Vaddeboina
DROP ROW - KEY COLUMN DUPLICATED
Uzwal Goud Vaddeboina
INNER JOIN
Uzwal Goud Vaddeboina
LEFT JOIN
Uzwal Goud Vaddeboina
RIGHT JOIN
Uzwal Goud Vaddeboina
FULL JOIN
Uzwal Goud Vaddeboina
CROSS JOIN
Uzwal Goud Vaddeboina
UNION ALL BY SINGLE COLUMN
Uzwal Goud Vaddeboina
UNION ALL BY ALL COLUMNS
Uzwal Goud Vaddeboina
UNION BY SINGLE COLUMN
Uzwal Goud Vaddeboina
UNION BY ALL COLUMNS
Uzwal Goud Vaddeboina
ADD SINGLE COLUMN
Uzwal Goud Vaddeboina
DROP SINGLE COLUMN
Uzwal Goud Vaddeboina
DROP MULTIPLE COLUMNS
Uzwal Goud Vaddeboina
RENAME SINGLE COLUMN
Uzwal Goud Vaddeboina
RENAME MULTIPLE COLUMNS
Uzwal Goud Vaddeboina
UPDATE SINGLE COLUMN SINGLE ROW
Uzwal Goud Vaddeboina
UPDATE MULTIPLE COLUMNS SINGLE ROW
Uzwal Goud Vaddeboina
UPDATE SINGLE COLUMN MULTIPLE ROWS
Uzwal Goud Vaddeboina
UPDATE MULTIPLE COLUMNS MULTIPLE ROWS
Uzwal Goud Vaddeboina
UPDATE SINGLE COLUMN ALL ROWS
Uzwal Goud Vaddeboina
That’s a wrap!
If you liked this content,
follow Uzwal on LinkedIn
and click the bell icon
for updates.
