SQL to pandas converter

Learn pandas using what you know from SQL! Generate Python code that pandas can work with, by selecting from the tips dataset below using SQL. Keep in mind:

• Python is case-sensitive, SQL is not.
• In this tool, use quotes like 'this', not "this". Learn more about what SQL syntax is supported by this converter.
• You can expand the typing area by dragging the bottom right corner.
• Check out some great resources to bring your pandas and Python skills to the next level. For example a SQL to pandas cheat sheet!
• Latest article: SQL aggregations in pandas

Support this site and get good: Buy the Bible of pandas, written by its creator, Wes McKinney: Data Analysis with Python (Amazon)