Organize arrays within arrays in Javascript

Question

Organize arrays within arrays in Javascript

My array of data is structured for visualization as shown below:


var Dataset1 = [
  {
    "commentBy": "saurabh",
    "comment": "Testing",
    "datestamp": "07/07/2017",
    "weekcount": 1
  },
  {
    "commentBy": "raman",
    "comment": "Planning",
    "datestamp": "07/07/2017",
    "weekcount": 1
  },
  {
    "commentBy": "Execution",
    "comment": "Alfa Beta",
    "datestamp": "07/07/2017",
    "weekcount": 2
  },
  {
    "commentBy": "Execution",
    "comment": "Zseta Gama",
    "datestamp": "07/07/2017",
    "weekcount": 2
  }
]

// Despite attempting to create a function, the desired result has not been achieved.

var groupBy = function(xs, key) {
  return xs.reduce(function(rv, x) {
    (rv[x[key]] = rv[x[key]] || []).push(x);
    return rv;
  }, {});
};
var groubedByTeam = groupBy(Dataset1, 'weekcount')
console.log(groubedByTeam);

In order to group the dataset by weekcount, I wish to see the following result:

[
  {
    "weekcount": 1,
    "grouped": [
      {
        "commentBy": "saurabh",
        "comment": "Testing",
        "datestamp": "07/07/2017"
      },
      {
        "commentBy": "raman",
        "comment": "Planning",
        "datestamp": "07/07/2017"
      }
    ]
  },
  {
    "weekcount": 2,
    "grouped": [
      {
        "commentBy": "Execution",
        "comment": "Alfa Beta",
        "datestamp": "07/07/2017"
      },
      {
        "commentBy": "Execution",
        "comment": "Zseta Gama",
        "datestamp": "07/07/2017"
      }
    ]
  }
]

javascript arrays json

Answer 1

Answer №1

const formattedData = [];

Dataset1.forEach((data) => {
  const { weekCount, commentText, commenterName, timeStamp } = data;
  let obj = formattedData.find((item) => item.weekCount === weekCount);

  if (!obj) {
    formattedData.push({
      weekCount,
      groupedData: [{
        commentText,
        commenterName,
        timeStamp
      }]
    })
  } else {
    obj.groupedData.push({
      commentText,
      commenterName,
      timeStamp
    });
  }
});

const Dataset1 = [{
  "commenterName": "saurabh",
  "commentText": "Testing",
  "timeStamp": "07/07/2017",
  "weekCount": 1
}, {
  "commenterName": "raman",
  "commentText": "Planning",
  "timeStamp": "07/07/2017",
  "weekCount": 1
}, {
  "commenterName": "Execution",
  "commentText": "Alfa Beta",
  "timeStamp": "07/07/2017",
  "weekCount": 2
}, {
  "commenterName": "Execution",
  "commentText": "Zseta Gama",
  "timeStamp": "07/07/2017",
  "weekCount": 2
}];

const formattedData = [];

Dataset1.forEach((data) => {
  const { weekCount, commentText, commenterName, timeStamp } = data;
  let obj = formattedData.find((item) => item.weekCount === weekCount);

  if (!obj) {
    formattedData.push({
      weekCount,
      groupedData: [{
        commentText,
        commenterName,
        timeStamp
      }]
    })
  } else {
    obj.groupedData.push({
      commentText,
      commenterName,
      timeStamp
    });
  }
});

console.log(formattedData);

Answer 2

const formattedData = [];

Dataset1.forEach((data) => {
  const { weekCount, commentText, commenterName, timeStamp } = data;
  let obj = formattedData.find((item) => item.weekCount === weekCount);

  if (!obj) {
    formattedData.push({
      weekCount,
      groupedData: [{
        commentText,
        commenterName,
        timeStamp
      }]
    })
  } else {
    obj.groupedData.push({
      commentText,
      commenterName,
      timeStamp
    });
  }
});

const Dataset1 = [{
  "commenterName": "saurabh",
  "commentText": "Testing",
  "timeStamp": "07/07/2017",
  "weekCount": 1
}, {
  "commenterName": "raman",
  "commentText": "Planning",
  "timeStamp": "07/07/2017",
  "weekCount": 1
}, {
  "commenterName": "Execution",
  "commentText": "Alfa Beta",
  "timeStamp": "07/07/2017",
  "weekCount": 2
}, {
  "commenterName": "Execution",
  "commentText": "Zseta Gama",
  "timeStamp": "07/07/2017",
  "weekCount": 2
}];

const formattedData = [];

Dataset1.forEach((data) => {
  const { weekCount, commentText, commenterName, timeStamp } = data;
  let obj = formattedData.find((item) => item.weekCount === weekCount);

  if (!obj) {
    formattedData.push({
      weekCount,
      groupedData: [{
        commentText,
        commenterName,
        timeStamp
      }]
    })
  } else {
    obj.groupedData.push({
      commentText,
      commenterName,
      timeStamp
    });
  }
});

console.log(formattedData);

Answer 3

Answer №2

Here's a great method to group your data efficiently, allowing you to easily customize the formatting according to your preferences using this initial structure.

groupedData = {}

Dataset1.forEach(function(entry, position){

    if (!groupedData[entry.weeknumber]) groupedData[entry.weeknumber] = [];
    groupedData[entry.weeknumber].push(entry);

});

The groupedData object is organized based on week numbers. If a particular week number isn't present as a key in the object, an empty array is generated and the relevant data is subsequently added. Subsequent data with the same week number is appended to the existing array during subsequent iterations.

Answer 4

Here's a great method to group your data efficiently, allowing you to easily customize the formatting according to your preferences using this initial structure.

groupedData = {}

Dataset1.forEach(function(entry, position){

    if (!groupedData[entry.weeknumber]) groupedData[entry.weeknumber] = [];
    groupedData[entry.weeknumber].push(entry);

});

The groupedData object is organized based on week numbers. If a particular week number isn't present as a key in the object, an empty array is generated and the relevant data is subsequently added. Subsequent data with the same week number is appended to the existing array during subsequent iterations.

Answer 5

Answer №3

To iterate through each week count from 0 to the maximum value and filter the array accordingly, you can use the following approach:

var Data =  [
      {
        "commentBy" : "Alice",
        "comment" : "Reviewing",
        "datestamp" : "07/08/2017",
        "weekcount" : 1
      },

       {
        "commentBy" : "Bob",
        "comment" : "Implementing",
        "datestamp" : "07/08/2017",
        "weekcount" : 1
      },
       {
        "commentBy" : "Charlie",
        "comment" : "Testing",
        "datestamp" : "07/08/2017",
        "weekcount" : 2
      },
        {
        "commentBy" : "Dave",
        "comment" : "Debugging",
        "datestamp" : "07/08/2017",
        "weekcount" : 2
      } 
        ]

var maxWeekCount = 4;
var output = []
for(var j=0; j<maxWeekCount; j++){
  var groupedData = Data.filter(object => object.weekcount === j)
  if(groupedData.length) {
    output.push({
      weekNumber: j,
      dataGroup: groupedData
    })
  }
}

console.log(output)

Answer 6

To iterate through each week count from 0 to the maximum value and filter the array accordingly, you can use the following approach:

var Data =  [
      {
        "commentBy" : "Alice",
        "comment" : "Reviewing",
        "datestamp" : "07/08/2017",
        "weekcount" : 1
      },

       {
        "commentBy" : "Bob",
        "comment" : "Implementing",
        "datestamp" : "07/08/2017",
        "weekcount" : 1
      },
       {
        "commentBy" : "Charlie",
        "comment" : "Testing",
        "datestamp" : "07/08/2017",
        "weekcount" : 2
      },
        {
        "commentBy" : "Dave",
        "comment" : "Debugging",
        "datestamp" : "07/08/2017",
        "weekcount" : 2
      } 
        ]

var maxWeekCount = 4;
var output = []
for(var j=0; j<maxWeekCount; j++){
  var groupedData = Data.filter(object => object.weekcount === j)
  if(groupedData.length) {
    output.push({
      weekNumber: j,
      dataGroup: groupedData
    })
  }
}

console.log(output)

Answer 7

Answer №4

Utilize a helper entity that maintains a connection to the weekcount objects in order to condense the array into a grouped structure.

var Dataset1 = [{"commentBy":"saurabh","comment":"Testing","datestamp":"07/07/2017","weekcount":1},{"commentBy":"raman","comment":"Planning","datestamp":"07/07/2017","weekcount":1},{"commentBy":"Execution","comment":"Alfa Beta","datestamp":"07/07/2017","weekcount":2},{"commentBy":"Execution","comment":"Zseta Gama","datestamp":"07/07/2017","weekcount":2}];

var helperMap = {};

var result = Dataset1.reduce(function(arr, obj) {
  var current = helperMap[obj.weekcount];
  
  if(!current) {
    current = { 
      weekcount: obj.weekcount,
      grouped: [] 
    };
    
   helperMap[obj.weekcount] = current;
    
    arr.push(current);
  }

  current.grouped.push({
    commentBy: obj.commentBy,
    comment: obj.comment,
    datestamp: obj.datestamp
  });
  
  return arr;
}, []);

console.log(result);

Answer 8

Utilize a helper entity that maintains a connection to the weekcount objects in order to condense the array into a grouped structure.

var Dataset1 = [{"commentBy":"saurabh","comment":"Testing","datestamp":"07/07/2017","weekcount":1},{"commentBy":"raman","comment":"Planning","datestamp":"07/07/2017","weekcount":1},{"commentBy":"Execution","comment":"Alfa Beta","datestamp":"07/07/2017","weekcount":2},{"commentBy":"Execution","comment":"Zseta Gama","datestamp":"07/07/2017","weekcount":2}];

var helperMap = {};

var result = Dataset1.reduce(function(arr, obj) {
  var current = helperMap[obj.weekcount];
  
  if(!current) {
    current = { 
      weekcount: obj.weekcount,
      grouped: [] 
    };
    
   helperMap[obj.weekcount] = current;
    
    arr.push(current);
  }

  current.grouped.push({
    commentBy: obj.commentBy,
    comment: obj.comment,
    datestamp: obj.datestamp
  });
  
  return arr;
}, []);

console.log(result);

Answer 9

Answer №5

const customGroupBy = (arr, prop) => {
  return arr.reduce((result, item) => {
    if (result[item[prop]] === undefined){
      result[item[prop]] = {"weekcount": item[prop], "grouped": []}
    }
    const stripped = {}
    for(const key in item) if(key !== prop) stripped[key] = item[key]; //strip "prop" property
    result[item[prop]]["grouped"].push(stripped);
    return result;
  }, []);
};

This innovative solution adapts to any input effortlessly by removing the specified property, ensuring it remains effective even when properties are added or removed from the input data.

Answer 10

const customGroupBy = (arr, prop) => {
  return arr.reduce((result, item) => {
    if (result[item[prop]] === undefined){
      result[item[prop]] = {"weekcount": item[prop], "grouped": []}
    }
    const stripped = {}
    for(const key in item) if(key !== prop) stripped[key] = item[key]; //strip "prop" property
    result[item[prop]]["grouped"].push(stripped);
    return result;
  }, []);
};

This innovative solution adapts to any input effortlessly by removing the specified property, ensuring it remains effective even when properties are added or removed from the input data.

Organize arrays within arrays in Javascript

Answer №1

Answer №2

Answer №3

Answer №4

Answer №5

Similar questions

What is the best method for directing a search URL with an embedded query string?

Is there a way to transform a .pcm file to a wav file using node.js?

Generating aggregated statistics from JSON logs using Apache Spark

Tips for displaying the message "{"POWER":"ON"}" within the else if statement (this.responseText == ({"POWER":"ON"})) {

Obtaining the distinct identifier of a MongoDB document during insertion

Ways to avoid scrolling on a fixed element

The newly added radio button does not function as a separate group as expected

Tips for optimizing the creation and compilation of expansive maps using c++

Exploring the capabilities of HTML5's file API along with Octokit.js to work with

Encountering an issue with Angular routing: Cross-origin requests are restricted to specific protocol schemes, such as HTTP

Consistent integration into React component

Combining Vue.js for handling both enter key and blur events simultaneously

How can I effectively utilize my JSON HTTP Request header in Swift?

In Visual Studio, make sure to include a reference to AngularJS.min.js within another JavaScript file

how can a select dropdown be dynamically displayed based on the previous selection?

Upon refreshing the browser, an error pops up saying "unable to set headers after they have been sent."

Prevent unauthorized users from accessing the expressjs application

A guide on decoding a JSON object with a JSON array in Laravel

Step-by-step guide on entering text into a hidden field with Selenium WebDriver and Java

Exchange information between two selected items