I'm a third-year student working on my first internship project and struggling with organizing and aggregating data from a JSON object. The goal is to group the data by name, calculate total weight per name, and sum up the grades for each entry. I've been attempting this task for the past two days without much success. The desired output should be in the format of {name, weightTotal, grade{grade1total:, grade2total, grade2total}}. I've researched numerous Stack Overflow questions and experimented with reduce and foreach functions, but I can't seem to grasp the concepts. This information is crucial for me to proceed with the frontend development and display the results in a table. Just to provide some context, this data is retrieved from a REST endpoint.
Data
"data": [
{
name: "france Naicin",
avgTotalWeight: 16,
grade: {
grade1: 16,
grade2: 0,
grade3: 0,
},
},
// Additional data entries...
],
Current Code:
let aggregatedData = [];
for (let i = 0; i <= data.length; i++) {
if (!data[i]) {
continue;
}
const {avgTotalWeight} = data[i];
const {name} = data[i].truerun.batch.shellfish;
const {alias} = data[i].truerun.grade_list;
// Logic for calculating grades based on alias...
let entry = {
name: name,
avgTotalWeight: avgTotalWeight,
grade: {
grade1: grade1,
grade2: grade2,
grade3: grade3,
},
};
aggregatedData.push(entry);
}
}
return aggregatedData;