Combining two or more arrays containing similar values into a single array

Question

Combining two or more arrays containing similar values into a single array

Within my array, there are 100 subarrays, each containing 3160 values of an object with two attributes: a sequence number (which only appears if it is present as 1), and another value of either 0 or 1.

My goal is to merge all 100 arrays into one single array consisting of 3160 values of an object. This new array should have a list of all the sequence numbers found in the original arrays, along with the total sum of all the 0s and 1s combined.

I attempted to use concatenation, but I want to ensure that the final array does not exceed 3160 entries.

/* Current structure of my data:
  Array(100)
    [0]Array(3160)
      [0]: Seq: 12345
           fq: 1
      [1]: Seq: 12345
           fq: 0
      [2]: Seq: 12345
           fq: 1
      [3]: Seq: 12345
           fq: 0
      ...and so on...
    [1]Array(3160)
      [0]: Seq: 12346
           fq: 1
      [1]: Seq: 12346
           fq: 1
      [2]: Seq: 12346
           fq: 0
      [3]: Seq: 12346
           fq: 0
      ...and so on...
    [2]Array(3160)
      [0]: Seq: 12347
           fq: 1
      [1]: Seq: 12347
           fq: 0
      [2]: Seq: 12347
           fq: 1
      [3]: Seq: 12347
           fq: 0
      ...and so on...
    ...and so on...


Desired Output:
    Array(3160)
      [0]: Seq: 12345, 12346, 12347
           fq: 3
      [1]: Seq: 12346
           fq: 1
      [2]: Seq: 12345, 12347
           fq: 2
      [3]: Seq: 
           fq: 0
*/

javascript arrays database merge

Answer 1

Answer №1

After considering your feedback, it seems like you are interested in an approach similar to the one outlined below:

let data = [[{ID: 12345, count: 1}, {ID: 12345, count: 0}],
             [{ID: 12346, count: 1}, {ID: 12346, count: 1}],
             [{ID: 12346, count: 1}, {ID: 12346, count: 1}],
             [{ID: 12347, count: 1}, {ID: 12347, count: 0}]];

let result = new Array();
             

data.forEach(entries => entries.forEach((object, ind) => {
  if(object.count) {
    result[ind] = result[ind] || {ID: [], count: 0};
    if(!result[ind].ID.includes(object.ID)) result[ind].ID.push(object.ID);
    result[ind].count += object.count;
  }
}));

console.log(result);

Given that this solution deviates slightly from what was initially requested, I have opted to provide a fresh answer rather than modifying the original response.

Answer 2

After considering your feedback, it seems like you are interested in an approach similar to the one outlined below:

let data = [[{ID: 12345, count: 1}, {ID: 12345, count: 0}],
             [{ID: 12346, count: 1}, {ID: 12346, count: 1}],
             [{ID: 12346, count: 1}, {ID: 12346, count: 1}],
             [{ID: 12347, count: 1}, {ID: 12347, count: 0}]];

let result = new Array();
             

data.forEach(entries => entries.forEach((object, ind) => {
  if(object.count) {
    result[ind] = result[ind] || {ID: [], count: 0};
    if(!result[ind].ID.includes(object.ID)) result[ind].ID.push(object.ID);
    result[ind].count += object.count;
  }
}));

console.log(result);

Given that this solution deviates slightly from what was initially requested, I have opted to provide a fresh answer rather than modifying the original response.

Answer 3

Answer №2

Here is a JavaScript code snippet that manipulates an array of objects:

let array = [[{Seq: 12345, fq: 1}, {Seq: 12345, fq: 0}],
             [{Seq: 12346, fq: 1}, {Seq: 12346, fq: 1}],
             [{Seq: 12347, fq: 1}, {Seq: 12347, fq: 0}]];

let output = new Array();
             

array.forEach(entrie => entrie.forEach((obj, index) => {
  if(obj.fq) {
    output[index] = output[index] || {Seq: [], fq: 0};
    output[index].Seq.push(obj.Seq);
    output[index].fq += obj.fq;
  }
}));

console.log(output);

Answer 4

Here is a JavaScript code snippet that manipulates an array of objects:

let array = [[{Seq: 12345, fq: 1}, {Seq: 12345, fq: 0}],
             [{Seq: 12346, fq: 1}, {Seq: 12346, fq: 1}],
             [{Seq: 12347, fq: 1}, {Seq: 12347, fq: 0}]];

let output = new Array();
             

array.forEach(entrie => entrie.forEach((obj, index) => {
  if(obj.fq) {
    output[index] = output[index] || {Seq: [], fq: 0};
    output[index].Seq.push(obj.Seq);
    output[index].fq += obj.fq;
  }
}));

console.log(output);

Answer 5

Answer №3

If you were to loop through the array and create new elements at the same index as the provided inner arrays, you could achieve a desired outcome.

var data = [[{ Seq: 12345, fq: 1 }, { Seq: 12345, fq: 0 }, { Seq: 12345, fq: 1 }, { Seq: 12345, fq: 0 }], [{ Seq: 12346, fq: 1 }, { Seq: 12346, fq: 1 }, { Seq: 12346, fq: 0 }, { Seq: 12346, fq: 0 }], [{ Seq: 12347, fq: 1 }, { Seq: 12347, fq: 0 }, { Seq: 12347, fq: 1 }, { Seq: 12347, fq: 0 }]],
    result = data.reduce((r, a) => {
        a.forEach(({ Seq, fq }, i) => {
            if (!fq) return;
            r[i] = r[i] || { Seq: [], fq: 0 };
            r[i].Seq.push(Seq);
            r[i].fq++;
        });
        return r;
    }, []);

console.log(result);

.as-console-wrapper { max-height: 100% !important; top: 0; }

Answer 6

If you were to loop through the array and create new elements at the same index as the provided inner arrays, you could achieve a desired outcome.

var data = [[{ Seq: 12345, fq: 1 }, { Seq: 12345, fq: 0 }, { Seq: 12345, fq: 1 }, { Seq: 12345, fq: 0 }], [{ Seq: 12346, fq: 1 }, { Seq: 12346, fq: 1 }, { Seq: 12346, fq: 0 }, { Seq: 12346, fq: 0 }], [{ Seq: 12347, fq: 1 }, { Seq: 12347, fq: 0 }, { Seq: 12347, fq: 1 }, { Seq: 12347, fq: 0 }]],
    result = data.reduce((r, a) => {
        a.forEach(({ Seq, fq }, i) => {
            if (!fq) return;
            r[i] = r[i] || { Seq: [], fq: 0 };
            r[i].Seq.push(Seq);
            r[i].fq++;
        });
        return r;
    }, []);

console.log(result);

.as-console-wrapper { max-height: 100% !important; top: 0; }

Combining two or more arrays containing similar values into a single array

Answer №1

Answer №2

Answer №3

Similar questions

Creating markers from Mysql database is a simple and efficient process

Is there a way to obtain an array after subscribing to an RxJS method?

Restricting the type of user input in HTML forms

Difficulty displaying data from PapaParse in VueJS despite successful retrieval in console

Is there a clear definition of behavior when using non-Promise values with Promise.all?

Press the 'enter' button to post your tweet with Greasemonkey

Iterating through textboxes and buttons to trigger actions in JavaScript

Securing Email and Password Data in Cypress Tests

Unable to locate the module '/workspace/mySQL/node_modules/faker/index.js'

How can I intercept/manage the back button of the browser in React-router?

Determine whether there is only one array in the object that contains values

AngularJS Splice Function Used to Remove Selected Items from List

Issue regarding navigation using nuxt-links to pages with hashtags/anchors

Loading indicator for buttons

The error message says: "VueComponent.filterKategori function cannot read property 'filter' because it is undefined at line 16260 in app.js."

Ways to utilize a single HTML page for various URLs while changing one variable value based on the queried URL

Custom Joi middleware in Express v4 is failing to pass the Request, Response, and Next objects

Does turning off javascript in a browser impact ajax requests and javascript functions?

Transfer information using cURL without the need to refresh the webpage

"Exploring the capabilities of Rxjs ReplaySubject and its usage with the