javascript - 如何在javascript数组（NodeJs）中分组（多个键）和多个属性值的总和

Question

什么是最有效的分组方式（多个键）和javascript数组中多个属性值的总和

对于前 -

[ 
    { Phase: "Phase 1", Step: "Step 1", Value1: "15", Value2: "5" },
    { Phase: "Phase 1", Step: "Step 2", Value1: "20", Value2: "10" },
    { Phase: "Phase 2", Step: "Step 1", Value1: "25", Value2: "15" },
    { Phase: "Phase 2", Step: "Step 2", Value1: "30", Value2: "20" },
    { Phase: "Phase 1", Step: "Step 1", Value1: "35", Value2: "25" },
    { Phase: "Phase 1", Step: "Step 2", Value1: "40", Value2: "30" },
    { Phase: "Phase 2", Step: "Step 1", Value1: "45", Value2: "35" },
    { Phase: "Phase 2", Step: "Step 2", Value1: "50", Value2: "40" }
]

预期产出

[ 
    { Phase: "Phase 1", Step: "Step 1", Value1: "50", Value2: "30" },
    { Phase: "Phase 1", Step: "Step 2", Value1: "60", Value2: "40" },
    { Phase: "Phase 2", Step: "Step 1", Value1: "70", Value2: "50" },
    { Phase: "Phase 2", Step: "Step 2", Value1: "80", Value2: "60" }
]

标签： javascriptarraysobjectgroup-byunderscore.js

Answer 1

你可以做到这一点reduce并采取Object.values它：

var array = [ { Phase: "Phase 1", Step: "Step 1", Value1: "15", Value2: "5" }, { Phase: "Phase 1", Step: "Step 2", Value1: "20", Value2: "10" }, { Phase: "Phase 2", Step: "Step 1", Value1: "25", Value2: "15" }, { Phase: "Phase 2", Step: "Step 2", Value1: "30", Value2: "20" }, { Phase: "Phase 1", Step: "Step 1", Value1: "35", Value2: "25" }, { Phase: "Phase 1", Step: "Step 2", Value1: "40", Value2: "30" }, { Phase: "Phase 2", Step: "Step 1", Value1: "45", Value2: "35" }, { Phase: "Phase 2", Step: "Step 2", Value1: "50", Value2: "40" }];

var result = Object.values(array.reduce((acc, {Value1, Value2,...rest})=>{
    const key = Object.values(rest).join('|');
    acc[key] = acc[key] || {...rest, Value1:0,Value2:0};
    acc[key].Value1+=+Value1;
    acc[key].Value2+=+Value2;
    return acc;
},{}));

console.log(result);