SQL ↔ Pandas ↔ Pandasql Cheat Sheet
SELECT all
SQL pandas pandasql
SELECT * FROM students; students [Link]('SELECT * FROM students;', locals())
WHERE (filter rows)
SQL pandas pandasql
SELECT name, grade FROM students WHERE grade
students[students['grade']
> 85; > 85][['name','grade']] [Link]('SELECT name, grade FROM students WHERE gra
ORDER BY
SQL pandas pandasql
SELECT name, grade FROM students ORDER BYstudents[['name','grade']].sort_values(by='grade',
grade DESC; ascending=False)
[Link]('SELECT name, grade FROM students ORDER BY
GROUP BY + Aggregation
SQL pandas pandasql
SELECT class, AVG(grade) AS avg_grade FROM students
[Link]('class')['grade'].mean().reset_index()
GROUP BY class; [Link]('SELECT class, AVG(grade) as avg_grade FROM s
COUNT + Aggregation
SQL pandas pandasql
SELECT COUNT(*) AS student_count, AVG(grade)students['grade'].agg(['count','mean'])
AS avg_grade FROM students; [Link]('SELECT COUNT(*) AS student_count, AVG(grade
JOIN
SQL pandas pandasql
SELECT [Link], [Link], [Link] FROM students
[Link](courses,
s JOIN courses c ON [Link]
on='class',
= [Link];
how='inner')[['name','class','teacher']]
[Link]('''SELECT [Link], [Link], [Link] FROM studen
UPDATE
SQL pandas pandasql
UPDATE students SET grade = 95 WHERE name =
[Link][students['name']
'Alice'; ■ Not supported
== 'Alice', 'grade'] = 95
DELETE
SQL pandas pandasql
DELETE FROM students WHERE name = 'Charlie';students = students[students['name'] != 'Charlie'] ■ Not supported
