4.16 将并列排名的成员拼接起来
将成绩表按数学成绩排名,成绩相同的姓名用逗号连接起来:
| Name | Maths |
|---|---|
| Tom | 85 |
| John | 92 |
| Joan | 86 |
| Rocky | 95 |
| Ham | 92 |
| Kate | 83 |
| Rose | 95 |
| Nomy | 78 |
| Neil | 92 |
| Jack | 86 |
| Joe | 98 |
脚本:
| A | |
|---|---|
| 1 | =T(“score.xlsx”) |
| 2 | =A1.group(Maths).(~.(Name).concat@c()).rvs().new(#:Rank,~:Name) |
A2 按数学成绩分组 (分组的同时已经默认按分组字段排序了),组内把名字拼接起来,最后逆序,序号则是排名
运行结果:
| Rank | Name |
|---|---|
| 1 | Joe |
| 2 | Rocky,Rose |
| 3 | John,Ham,Neil |
| 4 | Joan,Jack |
| 5 | Tom |
| 6 | Kate |
| 7 | Nomy |
