Is there a way to condense a multidimensional array into a single array that shares a common value?

Question

Is there a way to condense a multidimensional array into a single array that shares a common value?

Clarifying My Query:

I have a multidimensional array structured as follows

var data = [
   [2017,   1,       0,       0,       0,       0],
   [2017,   0,       0,       23,      0,       0],
   [2017,   0,       0,       0,       0,       9],
   [2017,   0,       12,      0,       0,       0],
   [2017,   0,       0,       0,       18,      0]
];

My goal is to simplify this data into the following format:

var data = [2017, 1, 12, 23, 18, 9];

Specifically:

The year in Column #0 remains consistent across rows.
In each row, only one element from Columns #1 through #5 will be non-zero.

Is there a straightforward approach to achieve this conversion without relying on multiple nested loops? I'm curious if there's a built-in method within JavaScript's Array type or perhaps a function available in a library that can assist with this task.

javascript arrays multidimensional-array

Answer 1

Answer №1

Iterate through the array and compare each number with the current highest number:

let numbers = [
   [10, 5, 18, 2],
   [9, 15, 7, 12],
   [4, 6, 11, 3]
];

let maxNumbers = [];

for (row of numbers) {
  for (let i = 0; i<row.length; ++i) {
    maxNumbers[i] = (!maxNumbers[i] || row[i] > maxNumbers[i]) ? row[i] : maxNumbers[i];
  }
}
console.log(maxNumbers);

result:

[10, 15, 18, 12]

Answer 2

Iterate through the array and compare each number with the current highest number:

let numbers = [
   [10, 5, 18, 2],
   [9, 15, 7, 12],
   [4, 6, 11, 3]
];

let maxNumbers = [];

for (row of numbers) {
  for (let i = 0; i<row.length; ++i) {
    maxNumbers[i] = (!maxNumbers[i] || row[i] > maxNumbers[i]) ? row[i] : maxNumbers[i];
  }
}
console.log(maxNumbers);

result:

[10, 15, 18, 12]

Answer 3

Answer №2

Utilize the Array.map() function at the beginning to extract a column index, then employ reduce method to consolidate all rows into a single non-zero value within that column:

const data = [
   [2017,   1,       0,       0,       0,       0],
   [2017,   0,       0,       23,      0,       0],
   [2017,   0,       0,       0,       0,       9],
   [2017,   0,       12,      0,       0,       0],
   [2017,   0,       0,       0,       18,      0]
];

const result = data[0]
  .map((_, i) => 
    data.reduce((r, e) => r ? r : e[i], 0)
  );
  
console.log(result);

Answer 4

Utilize the Array.map() function at the beginning to extract a column index, then employ reduce method to consolidate all rows into a single non-zero value within that column:

const data = [
   [2017,   1,       0,       0,       0,       0],
   [2017,   0,       0,       23,      0,       0],
   [2017,   0,       0,       0,       0,       9],
   [2017,   0,       12,      0,       0,       0],
   [2017,   0,       0,       0,       18,      0]
];

const result = data[0]
  .map((_, i) => 
    data.reduce((r, e) => r ? r : e[i], 0)
  );
  
console.log(result);

Answer 5

Answer №3

After considering the following two conditions:

The year in Column #0 will remain constant across all rows.
In each row, only one non-zero element will be present in Columns #1 through #5.

You have the option to utilize the reduce() and findIndex() functions on the inner arrays to identify the initial number greater than zero whose index is not zero. This value can then be placed at the corresponding index of the accumulated result. This approach enhances performance slightly by avoiding the need to iterate over the entire inner array during each iteration of the reduce method.

var data = [
   [2017, 1, 0,  0,  0,  0],
   [2017, 0, 0,  23, 0,  0],
   [2017, 0, 0,  0,  0,  9],
   [2017, 0, 12, 0,  0,  0],
   [2017, 0, 0,  0,  18, 0]
];

let res = data.slice(1).reduce((acc, curr) =>
{
    let found = curr.findIndex((n, idx) => n > 0 && idx > 0);
    acc[found] = curr[found];
    return acc;

}, data[0]);

console.log(JSON.stringify(res));

Answer 6

After considering the following two conditions:

The year in Column #0 will remain constant across all rows.
In each row, only one non-zero element will be present in Columns #1 through #5.

You have the option to utilize the reduce() and findIndex() functions on the inner arrays to identify the initial number greater than zero whose index is not zero. This value can then be placed at the corresponding index of the accumulated result. This approach enhances performance slightly by avoiding the need to iterate over the entire inner array during each iteration of the reduce method.

var data = [
   [2017, 1, 0,  0,  0,  0],
   [2017, 0, 0,  23, 0,  0],
   [2017, 0, 0,  0,  0,  9],
   [2017, 0, 12, 0,  0,  0],
   [2017, 0, 0,  0,  18, 0]
];

let res = data.slice(1).reduce((acc, curr) =>
{
    let found = curr.findIndex((n, idx) => n > 0 && idx > 0);
    acc[found] = curr[found];
    return acc;

}, data[0]);

console.log(JSON.stringify(res));

Is there a way to condense a multidimensional array into a single array that shares a common value?

Answer №1

Answer №2

Answer №3

Similar questions

Retrieving Information from Ajax Response Following a Successful Insert Query in Codeigniter

Tips on inserting a button within a select element using jQuery

Enhancing XTemplate in ExtJS 4.2.1 with dynamic data refresh from store

Are there any compatibility issues when inserting an <iframe> containing HTML4 content into a HTML5 webpage?

Express-hbs: Dynamic Helper Function with Additional Features

What is the best approach for implementing AJAX in this situation?

What is the reason for the browser attempting to access files via HTTPS when the host is set as 0.0.0.0?

What is the reason for Promise.all() causing Array.prototype.then to be executed if it is defined?

AngularJS automatically selects the first value within a select box

"Observed Issue: Ionic2 Array Fails to Update in HTML Display

Create genuinely private methods within an ES6 Module/Class specifically for use in a nodejs-exclusive environment, ensuring that no data is exposed

`Python automation for seamless HTTP browsing and HTML document generation`

Sending data using jQuery's AJAX feature

Looking to pass the `Item Index` to functions within v-list-item-action in Vuetify?

Replicated shadows brought to life in three.js

Working with Multidimensional Arrays in VueJS

When using Three.js raycaster to intersect objects, it may not function properly if THREE.Points contains only one vertex or if the vertices are arranged in a straight line

Troubleshooting jQuery and Mootools compatibility problem in Internet Explorer 8

I'm new to this, but can someone explain why I'm being redirected to the register_db.php page when I click on the register button?

Are just a handful of things from my class being showcased?