A Facebook-style communities team reviews large groups.
Return group_id, group_name, members for groups with at least 50,000 members. Sort by group_id ascending.
These DataFrames are passed to solve(spark, dfs). Access one with dfs['name'].
groups6 rows| group_id (int) | group_name (string) | members (int) |
|---|---|---|
| 1 | Weekend Hikers | 52000 |
| 2 | Home Chefs | 18000 |
| 3 | City Cyclists | 76000 |
| 4 | Book Club | 50000 |
| 5 | Photo Walkers | 34000 |
| 6 | Pet Parents | 91000 |
Column names and order must match. Sort order is specified in the question.