SQL to Pandas Translator

Prompt

Translate my SQL queries into Pandas code.

Database context: [DESCRIBE YOUR TABLES / DATA STRUCTURE]
DataFrame variable names to use: [e.g. df_orders, df_customers, df_products]

For each query:
1. Show the original SQL
2. Write the equivalent Pandas code (clean and readable)
3. Add a one-line comment for each pandas operation explaining the SQL equivalent
4. Note any cases where the Pandas output might differ from SQL behavior (NULL handling, sort order, etc.)
5. If there's a more efficient Pandas approach than the direct translation, show that too

SQL queries:
```sql
[PASTE YOUR SQL QUERIES]
```

Also add a setup cell at the beginning showing how to load these DataFrames from CSV files.