javascript - 请问有什么方法可以将这些数据处理成所需的格式？(Is there any way to manipulate this data into the desired format please?)

Question

I would like to go from this:(我想从这里开始：)

[ { compID: 1, problem: 1, usersID: 1, completed: 1 }, { compID: 1, problem: 1, usersID: 5, completed: 1 }, { compID: 1, problem: 2, usersID: 1, completed: 0 }, { compID: 1, problem: 2, usersID: 5, completed: 1 }, { compID: 1, problem: 3, usersID: 1, completed: 1 }, { compID: 1, problem: 3, usersID: 5, completed: 0 }, { compID: 1, problem: 4, usersID: 1, completed: 0 }, { compID: 1, problem: 4, usersID: 5, completed: 1 }, { compID: 1, problem: 5, usersID: 1, completed: 1 }, { compID: 1, problem: 5, usersID: 5, completed: 0 } ] To this:(对此：) [ { compID: 1, problem: [1,2,3,4,5], usersID: 1, completed: [1,0,1,0,1] }, { compID: 1, problem: [1,2,3,4,5], usersID: 5, completed: [1,1,0,1,0] } ] I will need to do this manipulation for each usersID.(我将需要对每个usersID进行此操作。) Thank you(谢谢)   ask by singh3244 translate from so

Answer 1

you need to manipulate your array to get the result.(您需要操纵数组以获得结果。)

You can try like below,(您可以尝试以下操作，) var data = [ { compID: 1, problem: 1, usersID: 1, completed: 1 }, { compID: 1, problem: 1, usersID: 5, completed: 1 }, { compID: 1, problem: 2, usersID: 1, completed: 0 }, { compID: 1, problem: 2, usersID: 5, completed: 1 }, { compID: 1, problem: 3, usersID: 1, completed: 1 }, { compID: 1, problem: 3, usersID: 5, completed: 0 }, { compID: 1, problem: 4, usersID: 1, completed: 0 }, { compID: 1, problem: 4, usersID: 5, completed: 1 }, { compID: 1, problem: 5, usersID: 1, completed: 1 }, { compID: 1, problem: 5, usersID: 5, completed: 0 } ] var res ={}; data.map(d => { if(res[d.usersID]) { res[d.usersID].problem.push(d.problem); res[d.usersID].completed.push(d.completed); } else { res[d.usersID] = {compID: d.compID, problem: [d.problem], usersID: d.usersID, completed: [d.completed] } } }) console.log(Object.values(res))