I have a data structure of an array of objects with number of hours spent for a number of different roles like below:
[{"week 01" : {"Developer" : 1}},
{"week 01" : {"Project Manager" : 5}},
{"week 01" : {"Project Manager" : 6}},
{"week 01": {"Developer" : 8}},
{"week 02" : {"Strategy" : 4}}]
The roles and weeks are dynamic (i.e. I don't know the key/values beforehand) and I would like to sum all the hours for the same role and same week to get the below output:
[{"week 01" : {
"Developer" : 9
"Project Manager" : 11
}
},
{"week 02" : {
"Strategy" : 4
}
}]
I have tried using the reduce function, but I can't seem to get it right:
function reduceArray(arr) {
const result = arr.reduce((result, item) => {
let obj = {};
const existing = result.find(function (x) {
for (var prop in x) {
if (x[prop] === item[prop]) {
//same week number found
//loop through roles
for (var subProp in x[prop]) {
if (x[prop][subProp] === item[prop][subProp]) {
obj[prop][subProp] = x[prop][subProp] item[prop][subProp]
//This is where I lose myself in the prop-loops....
}
}
}
}
})
}, [])
return result;
}
CodePudding user response：
const data = [
{ "week 01": { Developer: 1 } },
{ "week 01": { "Project Manager": 5 } },
{ "week 01": { "Project Manager": 6 } },
{ "week 01": { Developer: 8 } },
{ "week 02": { Strategy: 4 } },
];
const result = data.reduce(
(prev, item) => {
for (const week in item) {
if (prev[week]) {
for (const act in item[week]) {
if (prev[week][act]) {
prev[week][act] = item[week][act];
} else {
prev[week][act] = item[week][act];
}
}
} else {
prev[week] = item[week];
}
}
return prev;
},
{}
);
console.log(result);CodePudding user response：
You could generate a single object with the accumulated values for all types.
const
data = [{ "week 01": { Developer: 1 } }, { "week 01": { "Project Manager": 5 } }, { "week 01": { "Project Manager" : 6 } }, { "week 01": { Developer : 8 } }, { "week 02": { Strategy: 4 } }],
result = data.reduce((r, o) => {
Object
.entries(o)
.forEach(([week, q]) => Object
.entries(q)
.forEach(([type, value]) => {
(r[week] ??= {})[type] ??= 0;
r[week][type] = value;
})
);
return r;
}, {});
console.log(result);.as-console-wrapper { max-height: 100% !important; top: 0; }CodePudding user response：
const data = [ {"week 01" : {"Developer" : 1}}, {"week 01" : {"Project Manager" : 5}}, {"week 01" : {"Project Manager" : 6}}, {"week 01": {"Developer" : 8}}, {"week 02" : {"Strategy" : 4}} ];
const res =
[...data.reduce((weekPositionsMap, obj) => {
Object.entries(obj).forEach(([week, positionCount]) => {
const weekPositions = weekPositionsMap.get(week);
if(!weekPositions) {
weekPositionsMap.set(week, positionCount);
} else {
Object.entries(positionCount).forEach(([position, count]) => {
weekPositionsMap.set(week, {...weekPositions, [position]: (weekPositions[position] || 0) count});
});
}
});
return weekPositionsMap;
}, new Map)]
.map(([week, positionsCount]) => ({ [week]: positionsCount }));
console.log(res);CodePudding user response：
I would use reflection and nested loops instead of reduce.
const weeks = {};
for(let cell of array){
//Assumes your cells will only have one key and that key is a week
for(let key in Object.keys(cell)){
if(!weeks[key]){
weeks[key] = {};
}
//Similiar assumption here
for(let role in Object.keys(cell[key])){
weeks[key][role] = (weeks[key][role] ? weeks[key][role] : 0) cell[key][role];
}
}
}
CodePudding user response：
Here's a simple way to do it. Hopefully the comments are useful.
const data = [
{ "week 01": { Developer: 1 } },
{ "week 01": { "Project Manager": 5 } },
{ "week 01": { "Project Manager": 6 } },
{ "week 01": { Developer: 8 } },
{ "week 02": { Strategy: 4 } }
];
function cleanUp(data) {
return data.reduce((acc, item) => {
// assign variables
const week = Object.keys(item).pop();
const [job, value] = Object.entries(item[week]).pop();
// initialise them, if they aren't in the accumilator.
if (!acc[week]) acc[week] = {};
if (!acc[week][job]) acc[week][job] = 0;
// add the value
acc[week][job] = value;
return acc;
}, {});
}
console.log(cleanUp(data));Here's one that uses for...in instead of Object.keys() and Object.entries(),
const data = [
{ "week 01": { Developer: 1 } },
{ "week 01": { "Project Manager": 5 } },
{ "week 01": { "Project Manager": 6 } },
{ "week 01": { Developer: 8 } },
{ "week 02": { Strategy: 4 } }
];
function cleanUp(data) {
return data.reduce((acc, item) => {
for (const week in item) {
if (!acc[week]) acc[week] = {};
for (const job in item[week]) {
if (!acc[week][job]) acc[week][job] = 0;
acc[week][job] = item[week][job];
}
}
return acc;
}, {});
}
console.log(cleanUp(data));CodePudding user response：
Use nested loops. in pure javascript you may get something like
const data = [{ "week 01": { "Developer": 1 } },
{ "week 01": { "Project Manager": 5 } },
{ "week 01": { "Project Manager": 6 } },
{ "week 01": { "Developer": 8 } },
{ "week 02": { "Strategy": 4 } }];
function getTotalHoursPerRole(data) {
let totalHoursPerRole = [];
for (let i = 0; i < data.length; i ) {
for (let week in data[i]) {
let roleWithHour = data[i][week];
for (let role in roleWithHour) {
if (!totalHoursPerRole[week]) totalHoursPerRole[week] = {};
if (!totalHoursPerRole[week][role]) totalHoursPerRole[week][role] = 0;
totalHoursPerRole[week][role] = roleWithHour[role];
}
}
}
return totalHoursPerRole;
}
console.log(getTotalHoursPerRole(data));