javascript - 将 API 中的 JSON 数据转换为有用的格式？

Question

我有一个 API 以这种格式返回指标数据:

[
    {
            "concept": "population",
            "year": 2012,
            "value": 9.5,
            "country-name": "Sweden",
    },
    {
            "concept": "education",
            "year": 2012,
            "value": 12,
            "country-name": "Sweden",
    },
    {
            "concept": "population",
            "year": 2012,
            "value": 5,
            "country-name": "Norway",
    },
    {
            "concept": "eduction",
            "year": 2012,
            "value": 12,
            "country-name": "Norway",
    }
]

基于此，我通常需要按国家和年份对其进行分组以获得如下内容:

var data = [
   {id : Sweden, population : 9.5, education: 12},
   {id : Norway, population : 5, education: 12},
]

或者仅将国家/地区和年份值作为数组:

var data = [
   {id : Sweden, values : [ { year : 2012, population : 9.5, education: 12 }, {...} ]},
   {id : Norway, values : [ { year : 2012, population : 5, education: 12 }, {...} ]},
]

1. 哪些 JS 库可以帮助管理这些常见的数据转换？
2. 您能否提供执行上述操作的示例(使用库或普通 js)？

Answer 1

您可以自己做，只需迭代并创建您需要的任何内容，例如

var data = [];

json.forEach(function(item) {
    var country = item['country-name'],
        match   = false,
        obj     = {}

    data.forEach(function(dataItem, i) {
        if (dataItem.id === country) {
            match = true;
            obj   = data[i];
        }
    });

    obj.id = country;
    obj[item.concept] = item.value;

    if (!match) data.push(obj)
});

FIDDLE