The products table lists catalogue prices and the discount percentage currently offered on each item.
Return product_id, product_name, discounted_price, where discounted_price is the price after the discount, rounded to 2 decimal places. Sort by product_id ascending.
These DataFrames are passed to solve(spark, dfs). Access one with dfs['name'].
products6 rows| product_id (int) | product_name (string) | price (double) | discount_pct (int) |
|---|---|---|---|
| 1 | Aero Mug | 24.99 | 10 |
| 2 | Trail Bottle | 39.49 | 25 |
| 3 | Desk Lamp | 58 | 0 |
| 4 | Canvas Tote | 18.75 | 40 |
| 5 | Wireless Pad | 49.99 | 15 |
| 6 | Notebook Set | 12.5 | 5 |
Column names and order must match. Sort order is specified in the question.