如何基于Unique_ID字段合并数组中的对象？

输入数组 #

[  
  {
    "countHouses": 1,
    "Name": "Bob",
    "Unique_ID": "12345"
  },
  {
    "countFlats": 4,
    "Name": "Bob",
    "Unique_ID": "12345"
  },
  {
    "countStadiums": 5,
    "Name": "Efac",
    "Unique_ID": "31124"
  },
  {
    "countStadiums": 1,
    "Name": "Bob",
    "Unique_ID": "12345"
  },
  {
    "countFlats": 1,
    "Name": "Efac",
    "Unique_ID__c": "31124"
  },
  {
    "countHouses": 245,
    "Name": "Efac",
    "Unique_ID": "31124"
  },
  {
    "countHouses": 300,
    "Name": "Pox",
    "Unique_ID": "18110"
  }
]

需求说明 #

• 以Unique_ID为标识合并对象，若对象字段为Unique_ID__c，需视为同一标识的对象
• 合并时保留每个count类字段的对应数值
• 若某个标识仅对应单个对象，需为其补充另外两个count类字段，默认值设为0

最终结果 #

[  
  {
    "countHouses": 1,
    "countFlats": 4,
    "countStadiums": 1,
    "Name": "Bob",
    "Unique_ID": "12345"
  },
  {
    "countHouses": 245,
    "countFlats": 1,
    "countStadiums": 5,
    "Name": "Efac",
    "Unique_ID": "31124"
  },
  {
    "countHouses": 300,
    "countFlats": 0,
    "countStadiums": 0,
    "Name": "Pox",
    "Unique_ID": "18110"
  }
]

内容的提问来源于stack exchange，提问作者SH4444KO