Scribd
Upload
59 views33 pages

SQL To Pandas

The document provides a guide for translating common SQL operations to equivalent operations in Pandas. It includes sections on selecting, filtering, aggregating, joining, grouping and sorting data as well as adding, dropping, and renaming columns. The guide aims to help users transition from SQL to working with dataframes in Pandas.

Uploaded by

RODRIGO ALMEIDA
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
59 views33 pages

SQL To Pandas

The document provides a guide for translating common SQL operations to equivalent operations in Pandas. It includes sections on selecting, filtering, aggregating, joining, grouping and sorting data as well as adding, dropping, and renaming columns. The guide aims to help users transition from SQL to working with dataframes in Pandas.

Uploaded by

RODRIGO ALMEIDA
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

FROM

SQL
TO
PANDAS
Uzwal Goud Vaddeboina
INDEX

SELECT ALL COLUMNS ADD SINGLE COLUMN


SELECT SINGLE COLUMN DROP SINGLE COLUMN
SELECT MULTIPLE COLUMNS DROP MULTIPLE COLUMNS
FILTER ROWS RENAME SINGLE COLUMN
TOP N ROWS RENAME MULTIPLE COLUMNS
DISTINCT VALUES
COUNT OF DISTINCT VALUES
COUNT OF TOTAL VALUES
STRUCTURE OF TABLE
DESCRIPTIVE STATISTICS
GROUP BY SINGLE COLUMN
SORT BY SINGLE COLUMN
SORT BY MULTIPLE COLUMNS
COUNT OF UNIQUE VALUES
DROP ROW - ALL COLUMNS DUPLICATED
DROP ROW - KEY COLUMN DUPLICATED
INNER JOIN
LEFT JOIN
RIGHT JOIN
FULL JOIN
CROSS JOIN
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


That’s a wrap!

If you liked this content,


follow Uzwal on LinkedIn
and click the bell icon
for updates.

You might also like