Querying stored data

DataLab with SQL

Jasmin Ludolf

Senior Data Science and AI Content Developer, DataCamp

Parameterizing queries

min_sales = 20

SELECT *
FROM sales_data.csv
WHERE quantity_sold > {{min_sales}};

DataFrame with mode and name highlighted

SELECT *
FROM sales_data.csv

WHERE customer_type = 'New';

-> Saved as new_sales DataFrame

SELECT *
FROM new_sales;

GIF of DataLab showing the naming, storing, and reusing of a DataFrame

GIF of DataLab showing storing and reusing a query

PostgreSQL and Python logos with arrows between them

Before a query

min_sales = 20

SELECT *
FROM sales_data.csv
WHERE quantity_sold > {{min_sales}};

After a query

SELECT *
FROM sales_data.csv
WHERE quantity_sold > {{min_sales}};

-> Store as filtered_sales DataFrame

filtered_sales["product_category"]

GIF of DataLab showing an example of using a Python variable within a query

DataLab with SQL