The customers table stores lowercase country codes.
Return customer_id, country_code with each code converted to uppercase. Sort by customer_id ascending.
These DataFrames are passed to solve(spark, dfs). Access one with dfs['name'].
customers5 rows| customer_id (int) | country_code (string) |
|---|---|
| 1 | in |
| 2 | us |
| 3 | gb |
| 4 | de |
| 5 | ca |
Column names and order must match. Sort order is specified in the question.