Storing Information in a Two-Dimensional Array using JavaScript

Question

Storing Information in a Two-Dimensional Array using JavaScript

Looking to loop through the Data array and indicate with an "O" if it contains the specified Month and Number. For example, for "Jan-1", Array1[0][0] should be set to "O". However, the code provided below is not working as expected. Any assistance would be appreciated.

var Data = ["Jan-1", "Feb-4", "Apr-5"];
var Month= ["Jan", "Feb", "Mar", "Apr", "May"];
var Number = ["1", "2", "3", "4", "5"];
var Array1 = [[]];

for (var k = 0; k < Data.length; k++) {
    var split = Data[k].split("-");
    for (var z = 0; z < Month.length; z++) {
        for (var s = 0; s < Number.length; s++) {
            if (Month[z] == split[0] && Number[s] == split[1]) {
                Array1[z][s] = "O";
            } else {
                Array1[z][s] = "X";
            }             
        }
    }
}

number/month |  Jan  |  Feb  |  Mar  |  Apr  | May
------------------------------------------------------
     1       |   O   |   X   |   X   |   X   |   X  
     2       |   X   |   X   |   X   |   X   |   X  
     3       |   X   |   X   |   X   |   X   |   X  
     4       |   X   |   O   |   X   |   X   |   X  
     5       |   X   |   X   |   X   |   O   |   X

javascript arrays loops multidimensional-array tabular

Answer 1

Answer №1

To efficiently compare the elements in the Number and Month arrays, create a loop that checks for the presence of the combination Month[j] + "-" + Number[i] in the Data array:

var Data = ["Jan-1", "Feb-4", "Apr-5"];

var Month = ["Jan", "Feb", "Mar", "Apr", "May"];
var Number = ["1", "2", "3", "4", "5"];

var result = [];


for (var i = 0; i < Number.length; i++) {                   // loop through each number
  result[i] = [];                                           // create a row for the current number
  for (var j = 0; j <Month.length; j++) {                   // iterate over each month
    if (Data.indexOf(Month[j] + "-" + Number[i]) !== -1) {  // check if the current combination is present in the Data array
      result[i][j] = "O";
    } else {
      result[i][j] = "X";
    }
  }
}

result.forEach(function(row) {
  console.log(row.join(" | "));
});

Answer 2

To efficiently compare the elements in the Number and Month arrays, create a loop that checks for the presence of the combination Month[j] + "-" + Number[i] in the Data array:

var Data = ["Jan-1", "Feb-4", "Apr-5"];

var Month = ["Jan", "Feb", "Mar", "Apr", "May"];
var Number = ["1", "2", "3", "4", "5"];

var result = [];


for (var i = 0; i < Number.length; i++) {                   // loop through each number
  result[i] = [];                                           // create a row for the current number
  for (var j = 0; j <Month.length; j++) {                   // iterate over each month
    if (Data.indexOf(Month[j] + "-" + Number[i]) !== -1) {  // check if the current combination is present in the Data array
      result[i][j] = "O";
    } else {
      result[i][j] = "X";
    }
  }
}

result.forEach(function(row) {
  console.log(row.join(" | "));
});

Answer 3

Answer №2

Reviewing the provided code:

var Data = ["Jan-1", "Feb-4", "Apr-5"];
var Month= ["Jan", "Feb", "Mar", "Apr", "May"];
var Number = ["1", "2", "3", "4", "5"];
var Array1 = [  ["X","X","X","X","X"],  ["X","X","X","X","X"],  "X","X","X","X","X"],  ["X","X","X","X","X"],  ["X","X","X","X","X"]]; //Setting all elements to "X" initially. Only changing specific indexes.

for (var k = 0; k < Data.length; k++) {
    var split = Data[k].split("-");
    for (var z = 0; z < Month.length; z++) {
        for (var s = 0; s < Number.length; s++) {
            if (Month[z] == split[0] && Number[s] == split[1]) {
                Array1[z][s] = "O";
            } else {
                //Array1[z][s] = "X"; Avoid changing here as the loop iterates over the entire array multiple times. This could overwrite previous changes.
            }             
        }
    }
}

Lastly, execute console.table(Array1); to display values.

Insight: The rows are assigned as months and columns as days during initialization, yet the desired output expects the opposite. To achieve the desired result, either print in transposed form or adjust the values during definition:

if (Month[z] == split[0] && Number[s] == split[1]) {
            Array1[s][z] = "O";
        }

Answer 4

Reviewing the provided code:

var Data = ["Jan-1", "Feb-4", "Apr-5"];
var Month= ["Jan", "Feb", "Mar", "Apr", "May"];
var Number = ["1", "2", "3", "4", "5"];
var Array1 = [  ["X","X","X","X","X"],  ["X","X","X","X","X"],  "X","X","X","X","X"],  ["X","X","X","X","X"],  ["X","X","X","X","X"]]; //Setting all elements to "X" initially. Only changing specific indexes.

for (var k = 0; k < Data.length; k++) {
    var split = Data[k].split("-");
    for (var z = 0; z < Month.length; z++) {
        for (var s = 0; s < Number.length; s++) {
            if (Month[z] == split[0] && Number[s] == split[1]) {
                Array1[z][s] = "O";
            } else {
                //Array1[z][s] = "X"; Avoid changing here as the loop iterates over the entire array multiple times. This could overwrite previous changes.
            }             
        }
    }
}

Lastly, execute console.table(Array1); to display values.

Insight: The rows are assigned as months and columns as days during initialization, yet the desired output expects the opposite. To achieve the desired result, either print in transposed form or adjust the values during definition:

if (Month[z] == split[0] && Number[s] == split[1]) {
            Array1[s][z] = "O";
        }

Answer 5

Answer №3

To create a new array containing data represented by 'O' or 'X' based on the given data set, you can iterate through the month and number arrays.

var data = ["Jan-1", "Feb-4", "Apr-5"],
    month = ["Jan", "Feb", "Mar", "Apr", "May"],
    number = ["1", "2", "3", "4", "5"],
    result = [],
    hash = Object.create(null);

data.forEach(function(s) {
    var [m, d] = s.split('-');
    hash[m] = hash[m] || {};
    hash[m][d] = true;
});

result = month.map(function (m, z) {
    return number.map(function (s) {
        return (hash[m] || {})[s] ? 'O' : 'X';
    });
});

console.log(result);

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

Answer 6

To create a new array containing data represented by 'O' or 'X' based on the given data set, you can iterate through the month and number arrays.

var data = ["Jan-1", "Feb-4", "Apr-5"],
    month = ["Jan", "Feb", "Mar", "Apr", "May"],
    number = ["1", "2", "3", "4", "5"],
    result = [],
    hash = Object.create(null);

data.forEach(function(s) {
    var [m, d] = s.split('-');
    hash[m] = hash[m] || {};
    hash[m][d] = true;
});

result = month.map(function (m, z) {
    return number.map(function (s) {
        return (hash[m] || {})[s] ? 'O' : 'X';
    });
});

console.log(result);

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

Storing Information in a Two-Dimensional Array using JavaScript

Answer №1

Answer №2

Answer №3

Similar questions

Encountering an issue when attempting to send a post request with an image, resulting in the following error: "Request failed with status code

An unusual html element

Angular Satellizer causing issues with Facebook login on mobile devices

Utilize Vue.js to sort by price bracket and category

How can I ensure that the images span the entire width of the page in ResponsiveSlides?

What causes the v-for in a template to only update when the input text changes?

The perplexing behavior of RxJS Observables with Mongo Cursors

Invoking WinJS.Binding.List.createFiltered with an asynchronous call to the predicate function

Tips for integrating both client-side and server-side validation techniques in your web application

Every time I use my NodeJS MySQL Query function, the results I get are never

Generate a unique splatter design using Cascading Style Sheets

Triggering a new window on button click with Vue and Nuxt

implementing geolocation using jquery and javascript

Having trouble implementing the FCKeditor in a Zend form

Vue.js behaving abnormally due to certain circumstances

What steps can I take to ensure that WebStorm properly recognizes a package's functions?

Efficiently managing desktop and mobile pages while implementing lazy loading in Angular

A sleek and streamlined scrollspy that dynamically updates the active class exclusively for anchor tags

The Datepicker and Tablesorter dilemma

Application Path-related Relative Path Problem in MVC Deployment