Given the following array, I need to reduce it by employee function names and also sum a few rows.
Reduce if Row[1] is equal with any other, and sum Row[2] and Row[5].
example array
[
[ 20, 'AJUDANTE GERAL ', 2, 'HH', 6.36, 12.72, '', '' ],
[ 20, 'AJUDANTE GERAL ', 8, 'HH', 6.36, 50.88, '', '' ],
[ 20, 'AJUDANTE GERAL ', 0.15, 'HH', 6.36, 0.954, '', '' ],
[ 20, 'AJUDANTE GERAL ', 8, 'HH', 6.36, 50.88, '', '' ],
[ 125, 'CALDEREIRO', 8, 'HH', 13.05, 104.4, '', '' ],
[ 0, 'ISOLADOR', 2, 'HH', 10.68, 21.36, '', '' ],
[ 0, 'ISOLADOR', 8, 'HH', 10.68, 85.44, '', '' ],
[ 0, 'ISOLADOR', 0.15, 'HH', 10.68, 1.6019999999999999, '', '' ],
[ 585, 'PINTOR', 2, 'HH', 10.91, 21.82, '', '' ]
]
result expected
[
[ 20, 'AJUDANTE GERAL ', 18.15, 'HH', 6.36, 115.434, '', '' ],
[ 125, 'CALDEREIRO', 8, 'HH', 13.05, 104.4, '', '' ],
[ 0, 'ISOLADOR', 10.15, 'HH', 10.68, 108.402, '', '' ],
[ 585, 'PINTOR', 2, 'HH', 10.91, 21.82, '', '' ]
]
I was able to achieve this using a few for loops which I believe it is not the real deal, since I am changing values during the loop. It is working, however, I would like to understand how could I do it with reduces and maps.
// sheetMapped is the array with all data duplicated
// uniqueRows is where I am keeping only the unique values with the sum values
let uniqueRows = [];
for (let i = 0; i < sheetMapped.length; i += 1) {
let row = sheetMapped[i];
let found = false;
for (let j = 0; j < uniqueRows.length; j += 1) {
let rowUniqueTest = uniqueRows[j];
if (row[1] === rowUniqueTest[1]) {
found = true;
uniqueRows[j][2] += row[2];
uniqueRows[j][5] += row[5];
break;
}
}
if (!found) {
uniqueRows.push(row);
}
}
I already tried a few examples using Array.from, set Maps, reduces, but they were a bit hard to understand since I am working with more data in array and not just key/value pairs.
Thanks in advance
This can be done with a fairly standard 'group by' operation using reduce().
The snippet below uses a Map as it maintains insertion order where as an object sorts numeric properties. The resulting Map is converted back to an array using Array.from() called on the Map.values()
const input = [ [ 20, 'AJUDANTE GERAL ', 2, 'HH', 6.36, 12.72, '', '' ], [ 20, 'AJUDANTE GERAL ', 8, 'HH', 6.36, 50.88, '', '' ], [ 20, 'AJUDANTE GERAL ', 0.15, 'HH', 6.36, 0.954, '', '' ], [ 20, 'AJUDANTE GERAL ', 8, 'HH', 6.36, 50.88, '', '' ], [ 125, 'CALDEREIRO', 8, 'HH', 13.05, 104.4, '', '' ], [ 0, 'ISOLADOR', 2, 'HH', 10.68, 21.36, '', '' ], [ 0, 'ISOLADOR', 8, 'HH', 10.68, 85.44, '', '' ], [ 0, 'ISOLADOR', 0.15, 'HH', 10.68, 1.6019999999999999, '', '' ], [ 585, 'PINTOR', 2, 'HH', 10.91, 21.82, '', '' ], ];
const result = Array.from(
input
.reduce((a, row) => {
if (!a.has(row[1])) {
a.set(row[1], [...row]);
} else {
const _row = a.get(row[1]);
_row[2] += row[2];
_row[5] += row[5];
}
return a;
}, new Map())
.values()
);
console.log(result);.as-console-wrapper { max-height: 100% !important; top: 0; }with an array as accumulator in reduce this is a piece of cake take a look at below code
var data = [
[ 20, 'AJUDANTE GERAL ', 2, 'HH', 6.36, 12.72, '', '' ],
[ 20, 'AJUDANTE GERAL ', 8, 'HH', 6.36, 50.88, '', '' ],
[ 20, 'AJUDANTE GERAL ', 0.15, 'HH', 6.36, 0.954, '', '' ],
[ 20, 'AJUDANTE GERAL ', 8, 'HH', 6.36, 50.88, '', '' ],
[ 125, 'CALDEREIRO', 8, 'HH', 13.05, 104.4, '', '' ],
[ 0, 'ISOLADOR', 2, 'HH', 10.68, 21.36, '', '' ],
[ 0, 'ISOLADOR', 8, 'HH', 10.68, 85.44, '', '' ],
[ 0, 'ISOLADOR', 0.15, 'HH', 10.68, 1.6019999999999999, '', '' ],
[ 585, 'PINTOR', 2, 'HH', 10.91, 21.82, '', '' ]
]
data = data.reduce((a,e)=>{
let sInd = a.findIndex(each=>each.indexOf(e[1]) != -1)
if(sInd >= 0){ // if entry added already
a[sInd][2] += e[2]
a[sInd][5] += e[5]
}
else{a.push(e)} // if new entry
return a
},[])
console.log(data.join("\n"))If row and col are fixed, You can use below sample code. Merge as an object and get all values.
const data = [
[20, "AJUDANTE GERAL ", 2, "HH", 6.36, 12.72, "", ""],[20, "AJUDANTE GERAL ", 8, "HH", 6.36, 50.88, "", ""],[20, "AJUDANTE GERAL ", 0.15, "HH", 6.36, 0.954, "", ""],[20, "AJUDANTE GERAL ", 8, "HH", 6.36, 50.88, "", ""],
[125, "CALDEREIRO", 8, "HH", 13.05, 104.4, "", ""],
[0, "ISOLADOR", 2, "HH", 10.68, 21.36, "", ""],[0, "ISOLADOR", 8, "HH", 10.68, 85.44, "", ""],[0, "ISOLADOR", 0.15, "HH", 10.68, 1.6019999999999999, "", ""],[585, "PINTOR", 2, "HH", 10.91, 21.82, "", ""],
];
const map = data.reduce((m, row) => {
const id = row[0];
if (id in m) {
m[id][2] += row[2];
m[id][5] += row[5];
} else {
m[id] = row;
}
return m;
}, {});
console.log(Object.values(map));