I have the following array of objects
const mi_array = [{
agrupacion: "Total país",
col2015: '81.8',
col2016: '86.4',
col2017: '67.3',
col2018: '70.8',
col2019: '67.6'
},{
agrupacion: "otra cosa",
col2015: '90.8',
col2016: '67.4',
col2017: '39.3',
col2018: '50.8',
col2019: '95.6'
}];
I need to transform this into something like this:
const new_array = [{
name: "Total país",
data: [81.8, 86.4, 67.3, 70.8, 67.6]
}, {
name: "otra cosa",
data: [90.8, 67.4, 39.3, 50.8, 95.6]
}];
I tried this but since values on keys col2015 thru 2019 are all strings, it doesn't work as intended
const result = mi_array.map(e => ({
name: e.agrupacion,
data: Object.values(e).filter(e => typeof e == 'number')
}))
console.log(result)
output:
[{
data: [],
name: "Total país"
}, {
data: [],
name: "otra cosa"
}]
I know it will work if I can transform those values into numbers somehow so i tried to achieve that with this:
for(let key of Object.keys(mi_array)) mi_array[key] = +mi_array[key]
console.log(mi_array);
however my output is:
[NaN, NaN]
another attempt:
var result = Object.keys(mi_array).map(function(key) {
return [Number(key), mi_array[key]];
});
console.log(result);
another failed output:
[[0, {
agrupacion: "Total país",
col2015: "81.8",
col2016: "86.4",
col2017: "67.3",
col2018: "70.8",
col2019: "67.6"
}], [1, {
agrupacion: "otra cosa",
col2015: "90.8",
col2016: "67.4",
col2017: "39.3",
col2018: "50.8",
col2019: "95.6"
}]]
Is there an efficient way of doing this?
You could destructure name and take from the rest only the values as data, after mapping with Number.
This approach takes the original order of the object.
const
mi_array = [{ agrupacion: "Total país", col2015: '81.8', col2016: '86.4', col2017: '67.3', col2018: '70.8', col2019: '67.6' }, { agrupacion: "otra cosa", col2015: '90.8', col2016: '67.4', col2017: '39.3', col2018: '50.8', col2019: '95.6' }],
result = mi_array.map(({ agrupacion: name, ...o }) => ({
name,
data: Object.values(o).map(Number)
}));
console.log(result);.as-console-wrapper { max-height: 100% !important; top: 0; }const new_array = [];
for(let i = 0; i < mi_array.length; ++i) {
const new_obj = {"name":"", "data":[]};
for(const key in mi_array[i]) {
const num = Number(mi_array[i][key]);
if(isNaN(num)) {
new_obj.name = mi_array[i][key];
} else {
new_obj.data.push(num);
}
}
new_array.push(new_obj);
}
You could use it.
First, map array and take properties agrupacion and rest props for map in data and convert to Number.
const newArr = mi_array.map(({agrupacion, ...props})=> ({
name:agrupacion,
data: [...Object.values(props).map(value => Number(value))]
}))