Analyze the elements within arrays and determine the occurrence rate of each element

Question

Analyze the elements within arrays and determine the occurrence rate of each element

Issue at hand:

var rawData = [[two],[three],[four],[one],[two],[two],[two],[three],[four],[five],[three],[four],[five]];

Given an array of arrays, the goal is to identify the unique elements within one of the arrays and provide a count of each unique element, presenting the results in two separate arrays as follows:

var uniqueList = [one,two,three,four,five...]
var count = [countOfOne, countOfTwo, countOfThree, countOfFour, countOfFive...]

(It should be noted that rawData is subject to change as data is sourced from a large spreadsheet.) What would be the most effective method to accomplish this task?

javascript arrays google-apps-script google-sheets

Answer 1

Answer №1

Maybe it can be done this way? Both instances could also utilize reduce, but I personally find it more challenging to decipher.

let list = {}
const rawData = ["two","three","four","one","two","two","two","three","four","five","three","four","five"]
  .forEach(item => {
    const obj = list[item] || { count: 0 };
    obj.count = obj.count ? obj.count + 1 : 1;
    list[item] = obj;
  });


 ["one","two","three","four","five"].forEach(item => console.log(item,list[item]))

Only including elements from the comparison array

let list = {}
const compareList  = ["two","three"];
const rawData = ["two","three","four","one","two","two","two","three","four","five","three","four","five"]
  .forEach(item => {
    if (compareList.indexOf(item) !=-1) {
      const obj = list[item] || { count: 0 };
      obj.count = obj.count ? obj.count + 1 : 1;
      list[item] = obj;
    }
  });


 console.log(list)

Answer 2

Maybe it can be done this way? Both instances could also utilize reduce, but I personally find it more challenging to decipher.

let list = {}
const rawData = ["two","three","four","one","two","two","two","three","four","five","three","four","five"]
  .forEach(item => {
    const obj = list[item] || { count: 0 };
    obj.count = obj.count ? obj.count + 1 : 1;
    list[item] = obj;
  });


 ["one","two","three","four","five"].forEach(item => console.log(item,list[item]))

Only including elements from the comparison array

let list = {}
const compareList  = ["two","three"];
const rawData = ["two","three","four","one","two","two","two","three","four","five","three","four","five"]
  .forEach(item => {
    if (compareList.indexOf(item) !=-1) {
      const obj = list[item] || { count: 0 };
      obj.count = obj.count ? obj.count + 1 : 1;
      list[item] = obj;
    }
  });


 console.log(list)

Analyze the elements within arrays and determine the occurrence rate of each element

Answer №1

Similar questions

JS Executing functions in a pop-up window

Exploring the possibilities of node-webkit: node-odbc encounters a setback

Retrieve individual item

Reloading nested Iframe with Selenium automation script

Issue with AWS SDK client-S3 upload: Chrome freezes after reaching 8 GB upload limit

Invoke the parent method within the child application

Encountering a TypeError: relativeURL.replace is not a valid function in Next.js

Retrieve the numerical suffix from a key that begins with a particular substring

Does this function only function on a singular div?

Transmit information to the client-side webpage using Node.js

Maintain checkbox state through page reloads using ajax

Carry out numerous commitments across a range of elements

Converting a Javascript object to JSON format only once using AngularJS

The $scope.$watch function does not activate with each individual change

Bug allows unauthorized access to password in Bootstrap Password Revealer

Refresh Material-Ui's Selection Options

Node.js Express not inserting data with Mongoose when using form data

Utilize CSS to format the output of a script embedded within

Using AJAX to submit a form to a CodeIgniter 3 controller

How can I retrieve a formController in AngularJS?