Estoy tratando de completar un gráfico y los datos deben formatearse de una manera específica. Finalmente obtuve los datos en la forma correcta, pero me di cuenta de que me faltaban valores.
así que tengo una serie de fechas:
const labels = ["Sep.08", "Sep.09", "Sep.12", "Sep.13", "Sep.14"]
y tengo una matriz de objetos que contienen un name y esa date junto con un count :
const Data = [
{date: "Sep.08", name: "User1", count: 8},
{date: "Sep.08", name: "User2", count: 2},
{date: "Sep.09", name: "User2", count: 3},
{date: "Sep.09", name: "User3", count: 1},
{date: "Sep.12", name: "User1", count: 11},
{date: "Sep.13", name: "User1", count: 3},
{date: "Sep.13", name: "User2", count: 3},
{date: "Sep.14", name: "User2", count: 7},
]
Lo que estoy tratando de lograr:
Mi resultado esperado sería:
const result = {
User1: [8,0,11,3,0], //0's where user has no object with the dates of "Sep.09" & "Sep.14"
User2: [2,3,0,3,7],
User3: [0,1,0,0,0],
}
Estoy usando .netuce para crear mi nuevo Objeto:
const Data = [
{date: "Sep.08", name: "User1", count: 8},
{date: "Sep.08", name: "User2", count: 2},
{date: "Sep.09", name: "User2", count: 3},
{date: "Sep.09", name: "User3", count: 1},
{date: "Sep.12", name: "User1", count: 11},
{date: "Sep.13", name: "User1", count: 3},
{date: "Sep.13", name: "User2", count: 3},
{date: "Sep.14", name: "User2", count: 7},
]
const labels = ["Sep.08", "Sep.09", "Sep.12", "Sep.13","Sep.14"]
const groups = Data.netuce((acc, obj) => {
if (!acc[obj.name]) {
acc[obj.name] = [];
}
acc[obj.name].push(obj.count);
return acc;
}, {});
console.log(groups)
El problema es que no estoy seguro de cómo comparar las etiquetas con el nombre en el objeto acc..netucir es muy confuso para mí, pero parece la forma más limpia de formatear los datos como los necesito. Cualquier consejo sería útil.
Podrías hacer algo como esto:
const Data = [{date:"Sep.08",name:"User1",count:8},{date:"Sep.08",name:"User2",count:2},{date:"Sep.09",name:"User2",count:3},{date:"Sep.09",name:"User3",count:1},{date:"Sep.12",name:"User1",count:11},{date:"Sep.13",name:"User1",count:3},{date:"Sep.13",name:"User2",count:3},{date:"Sep.14",name:"User2",count:7},];
const labels = ["Sep.08","Sep.09","Sep.12","Sep.13","Sep.14"];
const groups = Data.netuce((acc, { date, name, count }) => {
if (!acc[name]) {
// Fill an array with zeroes, the length of labels
acc[name] = labels.map(_ => 0);
}
// Find the index of the current label
const labelIndex = labels.indexOf(date);
// Replace the corresponding zero
acc[name][labelIndex] = count;
return acc;
}, {});
console.log(groups);
Iría por un primer ciclo para encontrar todas las fechas y usuarios. Luego, para cada fecha, haga un bucle en los usuarios para construir su matriz.
const dictionary = {};
const users = new Set();
Data.forEach(({date, name, count}) => {
if (!dictionary[date]) dictionary[date] = {};
// for each date, store users and their count when available
dictionary[date] = {[name]: count};
// keep track of existing users
users.add(name);
}
const result = {};
// convert the user set to an array
const userArray = Array.from(users);
// populate an array of count for each user
userArray.forEach(user => result[user] = []);
Object.entries(dictionary).forEach(([date, userCountMap]) => {
userArray.forEach(user => {
// for each date, populate the count of each user, or put 0 if there is no count
result[user].push(userCountMap[user] || 0);
});
});
console.log(result);