SQL meet Data Science (Pandas) cheat sheet

This is Pandas cheat sheet is intended for people who know SQL. The full version and high quality images are available here:

Pandas vs SQL Cheat Sheet

The cheat sheet is divided into different sections and aims to help beginners in SQL and/or Pandas. It offers easy navigation, examples and beautiful visualizations.

It includes most common SQL operations like:

• Select
• Where
• Like, and, or
• Group by
• Join
• Union
• Limit
• Update
• Delete
• Insert

Plus extra materials like:

• Differences between SQL and Pandas
• Pandas to SQL
• Pandas from SQL
• Pandas and SQL with SQLAlchemy and PyMySQL
• Run SQL code in Pandas
• Generate SQL statements in Pandas

Enjoy :)

This is the second part from a Pandas cheat sheet series.

Comments

[Chris Greening]

Thanks for the resource! I really love learning the parallels to SQL in pandas and dplyr (in R) so I'm always on the lookout for new tips and tricks

[Softhints]

Thanks for the nice words!
We plan to add more resources like that in future - related to DS mainly.