Storing and reusing a DataFrame
Awesome job working with queries. This time you want to save your outputs as a DataFrame for further querying and manipulation.
You'll be working with the sales_data.csv again here.
This exercise is part of the course
DataLab with SQL
Exercise instructions
- Update the query to filter the results where the
product_categoryis'Furniture'. - Store the output as a DataFrame called
furniture_sales. - Create a new SQL cell and query the
furniture_salesDataFrame, storing this next result asfurniture_subset.
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
Start Exercise