Pandas vs SQL cheat sheet

This is a Pandas cheat sheet for SQL people and vice versa. It’s covers most common Pandas and SQL operations side by side.

If you like to see the full version you can visit: Pandas vs SQL Cheat Sheet

It has many different categories like from SQL and Pandas:

• Selection
• Where/ Filtering
• Like, and, or — Text operations
• Group by
• Join / Merge / Concat
• Union
• Update / Change data
• Delete / Remove rows
• Insert / Add column

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