Calculate average across nested array of objects - JavaScript

Question

So I'm almost embarrassed to be asking this, but alas, I've reached my head scratching threshold... I have this data structure which is a nested array of objects representing a span of 3 subsequent days. I need to loop through the entire array (what I'm working on is much larger than this..) and obtain the average of 'x' for those three days and I also need to get the average for 'y' for this same time period.

           var myArray = [
            {
                day: 1,
                values: [
                    {
                        x: 8
                    }, {
                        y: 10
                    }
                ]
            }, {
                day: 2,
                values: [
                    {
                        x: 9
                    }, {
                        y: 15
                    }
                ]
            }, {
                day: 3,
                values: [
                    {
                        x: 10
                    }, {
                        y: 16
                    }
                ]
            }
        ];

I have this nested loop...

        var avg = 0;
        for (var i=0; i<data.length; i++) {

            for (var b=0; b<data[i].values.length; b++) {
                avg += data[i].values[b] / data[i].values.length
            }

        }

Obviously, this is not correct so I'm turning to you good people for help. Am I approaching this correctly? I'm looking for a solution that is straight JS or maybe a solution involving UnderscoreJS as the actual data structure I'm working with contains over 300 of these objects in a 30k line JSON file.

Thanks in advance..

One average for each value key (i.e. avg for x, avg for y) or an avg of all values? — ioseph
– ioseph, Commented May 7, 2014 at 3:56

chenglou · Accepted Answer · 2014-05-07 03:56:16Z

3

var totalX = 0;
var totalY = 0;
for (var i = 0; i < myArray.length; i++) {
  totalX += myArray[i].values[0].x;
  totalY += myArray[i].values[1].y;
}

var averageX = totalX / myArray.length;
var averageY = totalY / myArray.length;

answered May 7, 2014 at 3:56

chenglou

3,6402 gold badges28 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

adeneo · Accepted Answer · 2014-05-07 04:04:37Z

2

var avgx = myArray.map(function(obj) {return obj.values[0].x})
                  .reduce(function(a, b) { return a + b }) / myArray.length;
var avgy = myArray.map(function(obj) {return obj.values[1].y})
                  .reduce(function(a, b) { return a + b }) / myArray.length;

FIDDLE

edited May 7, 2014 at 4:04

answered May 7, 2014 at 3:58

adeneo

319k29 gold badges410 silver badges392 bronze badges

Comments

elclanrs · Accepted Answer · 2014-05-07 03:58:34Z

0

You could implement it with reduce:

var result = myArray.reduce(function(acc, obj, i) {
  var len = myArray.length;
  acc.x += obj.values[0].x;
  acc.y += obj.values[1].y;
  if (i == len-1) {
    acc.x /= len;
    acc.y /= len;
  }
  return acc;
}, {x:0, y:0});

console.log(result); //=> {x: 9, y: 13.66}

answered May 7, 2014 at 3:58

elclanrs

94.2k21 gold badges137 silver badges171 bronze badges

Collectives™ on Stack Overflow

Calculate average across nested array of objects - JavaScript

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related