The inventory table stores the current stock for each product.
Return product_id, product_name for products with zero stock. Sort by product_id ascending.
These DataFrames are passed to solve(spark, dfs). Access one with dfs['name'].
inventory5 rows| product_id (int) | product_name (string) | stock (int) |
|---|---|---|
| 1 | Notebook | 0 |
| 2 | Pen | 5 |
| 3 | Marker | 0 |
| 4 | Folder | 12 |
| 5 | Stapler | 0 |
Column names and order must match. Sort order is specified in the question.