DEV Community

Softhints
Softhints

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.

Discussion (2)

Collapse
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

Collapse
softhints profile image
Softhints Author

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