Scribd
Upload
121 views27 pages

SQL to Pandas: Key Comparisons

The document outlines various SQL concepts and their Pandas equivalents such as selecting columns, filtering rows, aggregation, joins, unions, and more. It is authored by Uzwal Goud Vaddeboina and provides code examples to demonstrate translating tasks from SQL to Pandas.

Uploaded by

Pro free fire
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
121 views27 pages

SQL to Pandas: Key Comparisons

The document outlines various SQL concepts and their Pandas equivalents such as selecting columns, filtering rows, aggregation, joins, unions, and more. It is authored by Uzwal Goud Vaddeboina and provides code examples to demonstrate translating tasks from SQL to Pandas.

Uploaded by

Pro free fire
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
Select all columns

"From SQL to Pandas" By Uzwal


Select specific column

"From SQL to Pandas" By Uzwal


Select specific columns

Uzwal Goud Vaddeboina


Filter Rows

Uzwal Goud Vaddeboina


Limit vs Head

Uzwal Goud Vaddeboina


Distinct vs Unique

Uzwal Goud Vaddeboina


Distinct vs nunique

Uzwal Goud Vaddeboina


Total elements in Table/DataFrame

table/dataframe

Uzwal Goud Vaddeboina


Get column names, data types, etc

table/dataframe

Uzwal Goud Vaddeboina


Descriptive Stats: Pandas | SQL

Uzwal Goud Vaddeboina


GROUP BY

Uzwal Goud Vaddeboina


Sort by Column

Uzwal Goud Vaddeboina


Sort by Multiple Columns

Uzwal Goud Vaddeboina


Value Count

Uzwal Goud Vaddeboina


Drop Duplicates - If All Columns Duplicated

Uzwal Goud Vaddeboina


Drop Duplicates - If 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 - Specific Columns

Uzwal Goud Vaddeboina


UNION ALL - All Columns

Uzwal Goud Vaddeboina


UNION - Specific Column

Uzwal Goud Vaddeboina


UNION - All Columns

Uzwal Goud Vaddeboina


Found this post
helpful?

Uzwal

for tips on
SQL, Python,
and Data Analytics.

You might also like