An insurance-style billing team adds GST to base premiums.
Return policy_id, total_premium, where total premium is base_premium * (1 + gst_pct / 100), rounded to 2 decimal places. Sort by policy_id ascending.
These DataFrames are passed to solve(spark, dfs). Access one with dfs['name'].
policies6 rows| policy_id (int) | customer_name (string) | base_premium (double) | gst_pct (double) |
|---|---|---|---|
| 1 | Aarav | 12000 | 18 |
| 2 | Bela | 8500 | 18 |
| 3 | Chen | 24000 | 18 |
| 4 | Dia | 5000 | 5 |
| 5 | Eli | 15000 | 18 |
| 6 | Fay | 30000 | 5 |
Column names and order must match. Sort order is specified in the question.