DEV Community


Posted on

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.

SQL meet Pandas

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.

Top comments (2)

chrisgreening profile image
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 profile image

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