我有一个数据集,里面有世界上每个国家的男女人数。
"country","sex","amount"
"Afghanistan","men","number"
"Afghanistan","women","number"
"Albania","men","number"
"Albania","women","number"...
我想添加合并每对国家行,并删除性别列,这样我就结束了:
"country","amount"
"Afghanistan","number"
"Albania","number"
如何在Google/Open Refine中以这种方式添加行?
- 如果列表没有排序,按国家排序并使源永久
- 国家栏空白
- 删除性别栏
- 在Amount列上连接多值单元格
- 用
forEach(value.split(','),a,a.toNumber()).sum()
一行的表达式转换Amount列