An Amazon-style marketplace team calculates seller revenue after marketplace fees.
Return seller_id, net_revenue, where net revenue is gross_revenue * (1 - fee_pct / 100), rounded to 2 decimal places. Sort by seller_id ascending.
These DataFrames are passed to solve(spark, dfs). Access one with dfs['name'].
seller_sales6 rows| seller_id (string) | seller_name (string) | gross_revenue (double) | fee_pct (double) |
|---|---|---|---|
| S1 | TechNest | 50000 | 15 |
| S2 | HomeHarbor | 32000 | 12 |
| S3 | FitGear | 18000 | 18 |
| S4 | BookBay | 25000 | 8 |
| S5 | KitchenKing | 42000 | 15 |
| S6 | PetPalace | 27500 | 10 |
Column names and order must match. Sort order is specified in the question.