Calculating the mean value of a multidimensional array that has been sorted in JavaScript

Question

Calculating the mean value of a multidimensional array that has been sorted in JavaScript

Check out the structure of my JSON File below.

{
    "questions": ["Question1", "Question2"],
    "orgs": ["Org1", "Org2", "Org3"],
    "dates": ["Q1", "Q2", "Q3"],
    "values": [
        [
            [5, 88, 18],
            [50, 83, 10],
            [29, 78, 80]

        ],
        [
            [46, 51, 61],
            [95, 21, 15],
            [49, 86, 43]
        ]
    ]
}

I am attempting to extract a single array of values by looping through each question, indexed using an "orgs" value and then adding each retrieved value while dividing it by data.dates.length.

Below is the code I have;

d3.json("data.json", function(error, data) {

  var array = new Array()
  var orgS = "Org2"
  var org = data.orgs.indexOf(orgS);

  for (var question = 0; question < data.questions.length; question++) {
    array.push(
      data.values[question][org]
    )

    console.log(array)
  }

  // add array together
  array.reduce(function(a, b) {
    return a + b;
  })

  // calculate average
  var avg = array / data.dates.length;
})

Here is a plnk;

http://plnkr.co/edit/wMv8GmkD1ynjo9WZVlMb?p=preview

The issue I believe lies in how I am retrieving the values initially? Currently, even though the correct values are being displayed in the console log, they are showing up twice and both times inside nested arrays. Not sure how to fix this problem?

Just as a guide;

[question1][org1] corresponds to the values [5, 88, 18].

Any helpful advice would be much appreciated!

Thank you!

javascript arrays

Answer 1

Answer №1

After taking into account your specific request to compute individual averages for each question, I have revised my response accordingly. It is advisable to carry out all the necessary calculations within the for loop as it iterates through the questions. Subsequently, you can save these averages in an array.

d3.json("data.json", function(error, data) {

  var calculatedAverages = new Array()
  var organizationSearched = "Org2"
  var orgIndex = data.orgs.indexOf(organizationSearched);

  var questionValues, totalSum;

  for (var i = 0; i < data.questions.length; i++) {
    // attain the values pertaining to the question/organization
    questionValues = data.values[i][orgIndex];

    // ascertain the total sum
    totalSum = questionValues.reduce(function(a, b) {
      return a + b;
    });

    // determine the average
    calculatedAverages.push(totalSum / questionValues.length);
  }

  console.log(calculatedAverages);

});

Answer 2

After taking into account your specific request to compute individual averages for each question, I have revised my response accordingly. It is advisable to carry out all the necessary calculations within the for loop as it iterates through the questions. Subsequently, you can save these averages in an array.

d3.json("data.json", function(error, data) {

  var calculatedAverages = new Array()
  var organizationSearched = "Org2"
  var orgIndex = data.orgs.indexOf(organizationSearched);

  var questionValues, totalSum;

  for (var i = 0; i < data.questions.length; i++) {
    // attain the values pertaining to the question/organization
    questionValues = data.values[i][orgIndex];

    // ascertain the total sum
    totalSum = questionValues.reduce(function(a, b) {
      return a + b;
    });

    // determine the average
    calculatedAverages.push(totalSum / questionValues.length);
  }

  console.log(calculatedAverages);

});

Answer 3

Answer №2

To achieve the desired outcome, utilize the .reduce() method within a for loop and then push the result into an array. This approach will provide you with an array containing the expected results.

array.push(data.values[question][org].reduce(function(a, b) {
  return a + b
}, 0) / data.dates.length)

[
  47.666666666666664,
  43.666666666666664
]

The current issue lies in attempting to perform addition on the arrays themselves within the .reduce() callback, rather than reducing the values of each individual array to their sum first, followed by calculating the average.

Demo: (Expand for full function)

var data = {
  "questions": ["Question1", "Question2"],
  "orgs": ["Org1", "Org2", "Org3"],
  "dates": ["Q1", "Q2", "Q3"],
  "values": [
    [
      [5, 88, 18],
      [50, 83, 10],
      [29, 78, 80]

    ],
    [
      [46, 51, 61],
      [95, 21, 15],
      [49, 86, 43]
    ]
  ]
}

x(data)

// Your callback function.
function x(data) {
  var array = new Array()
  var orgS = "Org2"
  var org = data.orgs.indexOf(orgS);

  for (var question = 0; question < data.questions.length; question++) {
    array.push(data.values[question][org].reduce(function(a, b) {
      return a + b
    }, 0) / data.dates.length)
  }

  console.log(array)
}

Another alternative to using a for loop is replacing it with the .map() method.

var array = data.questions.map(function(_, question) {
  return data.values[question][org].reduce(function(a, b) {
    return a + b
  }, 0) / data.dates.length
})

Demo: (Expand for full function)

var data = {
  "questions": ["Question1", "Question2"],
  "orgs": ["Org1", "Org2", "Org3"],
  "dates": ["Q1", "Q2", "Q3"],
  "values": [
    [
      [5, 88, 18],
      [50, 83, 10],
      [29, 78, 80]

    ],
    [
      [46, 51, 61],
      [95, 21, 15],
      [49, 86, 43]
    ]
  ]
}

x(data)

// Your callback function.
function x(data) {
  var orgS = "Org2"
  var org = data.orgs.indexOf(orgS);

  var array = data.questions.map(function(_, question) {
    return data.values[question][org].reduce(function(a, b) {
      return a + b
    }, 0) / data.dates.length
  })

  console.log(array)
}

Answer 4

To achieve the desired outcome, utilize the .reduce() method within a for loop and then push the result into an array. This approach will provide you with an array containing the expected results.

array.push(data.values[question][org].reduce(function(a, b) {
  return a + b
}, 0) / data.dates.length)

[
  47.666666666666664,
  43.666666666666664
]

The current issue lies in attempting to perform addition on the arrays themselves within the .reduce() callback, rather than reducing the values of each individual array to their sum first, followed by calculating the average.

Demo: (Expand for full function)

var data = {
  "questions": ["Question1", "Question2"],
  "orgs": ["Org1", "Org2", "Org3"],
  "dates": ["Q1", "Q2", "Q3"],
  "values": [
    [
      [5, 88, 18],
      [50, 83, 10],
      [29, 78, 80]

    ],
    [
      [46, 51, 61],
      [95, 21, 15],
      [49, 86, 43]
    ]
  ]
}

x(data)

// Your callback function.
function x(data) {
  var array = new Array()
  var orgS = "Org2"
  var org = data.orgs.indexOf(orgS);

  for (var question = 0; question < data.questions.length; question++) {
    array.push(data.values[question][org].reduce(function(a, b) {
      return a + b
    }, 0) / data.dates.length)
  }

  console.log(array)
}

Another alternative to using a for loop is replacing it with the .map() method.

var array = data.questions.map(function(_, question) {
  return data.values[question][org].reduce(function(a, b) {
    return a + b
  }, 0) / data.dates.length
})

Demo: (Expand for full function)

var data = {
  "questions": ["Question1", "Question2"],
  "orgs": ["Org1", "Org2", "Org3"],
  "dates": ["Q1", "Q2", "Q3"],
  "values": [
    [
      [5, 88, 18],
      [50, 83, 10],
      [29, 78, 80]

    ],
    [
      [46, 51, 61],
      [95, 21, 15],
      [49, 86, 43]
    ]
  ]
}

x(data)

// Your callback function.
function x(data) {
  var orgS = "Org2"
  var org = data.orgs.indexOf(orgS);

  var array = data.questions.map(function(_, question) {
    return data.values[question][org].reduce(function(a, b) {
      return a + b
    }, 0) / data.dates.length
  })

  console.log(array)
}

Answer 5

Answer №3

To keep track of the total sum, utilize the result from the reduce function.

// Adding up all elements in array
// Storing the sum in a variable called 'sum'
var sum = array.reduce(function(a, b) {
    return a + b;
}, 0); // Initializing with 0 as starting value

When calculating the average, remember that instead of the length of data.dates, you need the length of the array since it holds all the values.

// Calculating the average
var avg = sum / array.length;

Merging all values together might look like this:

var data = { "questions": ["Question1", "Question2"], "orgs": ["Org1", "Org2", "Org3"], "dates": ["Q1", "Q2", "Q3"], "values": [[[5, 88, 18], [50, 83, 10], [29, 78, 80]], [[46, 51, 61], [95, 21, 15], [49, 86, 43]]] },
    sum = [];

data.values.forEach(function (a, i) {
    sum[i] = sum[i] || [];
    a.forEach(function (b) {
        b.forEach(function (c, j) {
            sum[i][j] = sum[i][j] || 0;
            sum[i][j] += c;
        });
    });
});

data.avg = sum.map(function (a, i) {
    return a.map(function (b) {
        return b / data.values[i].length;
    });
});

console.log(sum);
console.log(data);

Answer 6

To keep track of the total sum, utilize the result from the reduce function.

// Adding up all elements in array
// Storing the sum in a variable called 'sum'
var sum = array.reduce(function(a, b) {
    return a + b;
}, 0); // Initializing with 0 as starting value

When calculating the average, remember that instead of the length of data.dates, you need the length of the array since it holds all the values.

// Calculating the average
var avg = sum / array.length;

Merging all values together might look like this:

var data = { "questions": ["Question1", "Question2"], "orgs": ["Org1", "Org2", "Org3"], "dates": ["Q1", "Q2", "Q3"], "values": [[[5, 88, 18], [50, 83, 10], [29, 78, 80]], [[46, 51, 61], [95, 21, 15], [49, 86, 43]]] },
    sum = [];

data.values.forEach(function (a, i) {
    sum[i] = sum[i] || [];
    a.forEach(function (b) {
        b.forEach(function (c, j) {
            sum[i][j] = sum[i][j] || 0;
            sum[i][j] += c;
        });
    });
});

data.avg = sum.map(function (a, i) {
    return a.map(function (b) {
        return b / data.values[i].length;
    });
});

console.log(sum);
console.log(data);

Calculating the mean value of a multidimensional array that has been sorted in JavaScript

Answer №1

Answer №2

Answer №3

Similar questions

What is the best way to apply custom styles in reactJs to toggle the visibility of Google Maps?

Changing the color of a div while implementing a show and hide effect in JavaScript

Using jQuery AJAX to Redirect to a 404 Page in Case the Load Method Encounters Failure

retrieving information via AJAX call using jQuery

Browserify pulls in entire module even if only specific parts are utilized, such as react-addons

Unusual compilation issue encountered in Vue when trying to use a template for a slot

Efficient methods to reach the desired result using Selenium WebDriver promises

Continuously receiving unhandled promise rejection errors despite implementing a try-catch block

What is the best way to input individual students' CA and exam scores into distinct fields and then calculate their total scores in a separate text field?

Cors policy error encountered in Node.js application and React application

What could be causing the state to continuously appear as null in my redux application?

My objective is to upload a video file and store it on the server using multer

Implementing a JQuery modal with backend coding

Tips for utilizing Selenium Webdriver to input text into a webpage textbox using onblur, onfocus, and onkeydown attributes

Disable hover effects in CSS with JavaScript

Effortlessly retrieving the id attribute from an HTML tag using jQuery

Struggling to make even the most basic example work with TypeScript and npm modules

You cannot add properties to an object within an async function

MUI: reveal multiple selection when hovering & prevent dropdown from moving around

How can I display the Bootstrap 5.3.0 Collapsible button on this basic website?