Given users, return rows where country = 'India'. Project user_id, name, age and order by user_id ascending.
| user_id | name | country | age |
|---|---|---|---|
| 1 | Mira | USA | 30 |
| 2 | Kabir | Canada | 36 |
| 3 | Zara | UK | 61 |
| 4 | Zara | Germany | 22 |
| 5 | Yash | Brazil | 57 |
| 6 | Arjun | Japan | 28 |
These DataFrames are passed to solve(spark, dfs). Access one with dfs['name'].
users10 rows| user_id (int) | name (string) | country (string) | age (int) |
|---|---|---|---|
| 1 | Mira | USA | 30 |
| 2 | Kabir | Canada | 36 |
| 3 | Zara | UK | 61 |
| 4 | Zara | Germany | 22 |
| 5 | Yash | Brazil | 57 |
| 6 | Arjun | Japan | 28 |
| 7 | Ansh | Singapore | 35 |
| 8 | Kian | Canada | 27 |
| 9 | Aryan | France | 79 |
| 10 | Aditi | Canada | 31 |
Column names and order must match. Sort order is specified in the question.