javascript - 在对象数组中对具有相同键的值进行分组

Question

要在 highcharts.js 中显示数据，我需要转以下数据:

"personas": [
      {
        "category":"Persona1",
        "month":"6",
        "week":"24",
        "day":"18",
        "dayaverage":0.5,
        "weekaverage":1.33333333333333,
        "monthaverage":1.53571428571429
      },
      {
        "category":"Persona2",
        "month":"6",
        "week":"24",
        "day":"18",
        "dayaverage":0.146477031224456,
        "weekaverage":0.194758246723904,
        "monthaverage":0.601273296708939
      },
      {
        "category":"Persona3",
        "month":"6",
        "week":"24",
        "day":"18",
        "dayaverage":1.25559947299078,
        "weekaverage":1.43618513323983,
        "monthaverage":0.998426393184655
      },
      {
        "category":"Persona4",
        "month":"6",
        "week":"24",
        "day":"18",
        "dayaverage":0.799332962757087,
        "weekaverage":0.923262727610554,
        "monthaverage":0.769477297163179
      },
      {
        "category":"Persona5",
        "month":"6",
        "week":"24",
        "day":"18",
        "dayaverage":0.669041769041769,
        "weekaverage":0.67394482002558,
        "monthaverage":0.670944920469891
      },
      {
        "category":"Persona6",
        "month":"6",
        "week":"24",
        "day":"18",
        "dayaverage":0.656381486676017,
        "weekaverage":0.722973507315144,
        "monthaverage":0.69689774371321
      },
      {
        "category":"Persona7",
        "month":"6",
        "week":"24",
        "day":"18",
        "dayaverage":0.540495407737267,
        "weekaverage":0.576413277444205,
        "monthaverage":0.693495281755596
      }
    ]

转换成这种格式:

[
   {
      name: 'dayaverage',
      data: [0.5, 0.146477031224456, 1.25559947299078, 0.799332962757087, 0.669041769041769, 0.656381486676017, 0.540495407737267]
   },
   {
     name: 'weekaverage',
     data: [1.33333333333333, 0.194758246723904, 1.43618513323983, 0.923262727610554, 0.67394482002558, 0.722973507315144, 0.576413277444205]
   }, {
     name: 'monthaverage',
     data: [1.53571428571429, 0.601273296708939, 0.998426393184655, 0.769477297163179, 0.670944920469891, 0.69689774371321, 0.693495281755596]
   }
].

我所做的就是将 dayaverage、weekaverage 和 monthaverage 值分组到一个数组中，并使用名称键指定它们的含义-值对。

我在写这个时遇到了麻烦，因为父函数将调用一个标准列表(对于上面的例子，它是:criteria = ['dayaverage', 'weekaverage', 'monthaverage']; )，这可能会改变。

感谢任何帮助，谢谢

Answer 1

您可以为所需的属性使用一个数组，并用数据构建一个数组。

function getGrouped(array, groups) {
    var grouped = groups.map(function (a) {
            return { name: a, data: [] };
        });

    array.personas.forEach(function (a) {
        groups.forEach(function (k, i) {
            grouped[i].data.push(a[k]);
        });
    });
    return grouped;
}

var data = { personas: [{ category: "Persona1", month: 6, week: 24, day: 18, dayaverage: 0.5, weekaverage: 1.33333333333333, monthaverage: 1.53571428571429 }, { category: "Persona2", month: 6, week: 24, day: 18, dayaverage: 0.146477031224456, weekaverage: 0.194758246723904, monthaverage: 0.601273296708939 }, { category: "Persona3", month: 6, week: 24, day: 18, dayaverage: 1.25559947299078, weekaverage: 1.43618513323983, monthaverage: 0.998426393184655 }, { category: "Persona4", month: 6, week: 24, day: 18, dayaverage: 0.799332962757087, weekaverage: 0.923262727610554, monthaverage: 0.769477297163179 }, { category: "Persona5", month: 6, week: 24, day: 18, dayaverage: 0.669041769041769, weekaverage: 0.67394482002558, monthaverage: 0.670944920469891 }, { category: "Persona6", month: 6, week: 24, day: 18, dayaverage: 0.656381486676017, weekaverage: 0.722973507315144, monthaverage: 0.69689774371321 }, { category: "Persona7", month: 6, week: 24, day: 18, dayaverage: 0.540495407737267, weekaverage: 0.576413277444205, monthaverage: 0.693495281755596 }] };

console.log(getGrouped(data, ['day', 'dayaverage', 'weekaverage', 'monthaverage']));

.as-console-wrapper { max-height: 100% !important; top: 0; }