This is Pandas cheat sheet is intended for people who know SQL. The full version and high quality images are available here:
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.
Top comments (2)
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
Thanks for the nice words!
We plan to add more resources like that in future - related to DS mainly.