Understanding and aggregating data from JSON files

Question

Understanding and aggregating data from JSON files

I am in possession of a group of json values outlined below

{"labels":[ "time", "softirq", "user", "system", "nice", "iowait" ], "data":[ [ 1490088352, 0, 14.64646, 3.53535, 0, 1.0101 ], [ 1490088351, 0, 27.77778, 3.0303, 0, 0 ], [ 1490088350, 0.49751, 12.93532, 2.98508, 0, 4.47761 ] }

My aim is to analyze this json file. I intend to add up the values for

{ "softirq", "user", "system", "nice", "iowait"}

labels and store them in a separate variable named "sum". The anticipated output should resemble the following:

{ "time" : 1490088352 , "sum": "the calculated total value "}
{"time" : 1490088351 , "sum": "the calculated total value "}
{"time" : 1490088350 , "sum": "the calculated total value "}

If anyone could provide assistance with this query, it would be greatly appreciated.

javascript json

Answer 1

Answer №1

Utilize the Array#reduce method to condense an array into a single value

Array.slice(1) can be used to retrieve an array without the first element

var data = {
  "labels": ["time", "softirq", "user", "system", "nice", "iowait"],
  "data": [
    [1490088352, 0, 14.64646, 3.53535, 0, 1.0101],
    [1490088351, 0, 27.77778, 3.0303, 0, 0],
    [1490088350, 0.49751, 12.93532, 2.98508, 0, 4.47761]
  ]
};
var op = [];
data.data.forEach(function(el) {
  var obj = {
    time: el[0]
  };
  obj.sum = el.slice(1).reduce(function(a, b) {
    return a + b;
  });
  op.push(obj);
});
console.log(op);

Answer 2

Utilize the Array#reduce method to condense an array into a single value

Array.slice(1) can be used to retrieve an array without the first element

var data = {
  "labels": ["time", "softirq", "user", "system", "nice", "iowait"],
  "data": [
    [1490088352, 0, 14.64646, 3.53535, 0, 1.0101],
    [1490088351, 0, 27.77778, 3.0303, 0, 0],
    [1490088350, 0.49751, 12.93532, 2.98508, 0, 4.47761]
  ]
};
var op = [];
data.data.forEach(function(el) {
  var obj = {
    time: el[0]
  };
  obj.sum = el.slice(1).reduce(function(a, b) {
    return a + b;
  });
  op.push(obj);
});
console.log(op);

Answer 3

Answer №2

Let's start by loading the data:

var info = {
  "keys": ["timestamp", "task1", "task2", "task3", "task4", "task5"],
  "dataValues": [
    [1490088352, 0, 14.64646, 3.53535, 0, 1.0101],
    [1490088351, 0, 27.77778, 3.0303, 0, 0],
    [1490088350, 0.49751, 12.93532, 2.98508, 0, 4.47761]
  ]
};

Next step is to compute the sum of tasks:

var updatedInfo = info.dataValues.map(function(task){return {"timestamp":task[0], "total": task.splice(1, task.length).reduce((a, b) => a + b, 0)};});

Answer 4

Let's start by loading the data:

var info = {
  "keys": ["timestamp", "task1", "task2", "task3", "task4", "task5"],
  "dataValues": [
    [1490088352, 0, 14.64646, 3.53535, 0, 1.0101],
    [1490088351, 0, 27.77778, 3.0303, 0, 0],
    [1490088350, 0.49751, 12.93532, 2.98508, 0, 4.47761]
  ]
};

Next step is to compute the sum of tasks:

var updatedInfo = info.dataValues.map(function(task){return {"timestamp":task[0], "total": task.splice(1, task.length).reduce((a, b) => a + b, 0)};});

Answer 5

Answer №3

    var info = {
  "categories": ["timestamp", "softirq", "user", "system", "nice", "iowait"],
  "values": [
    [1490088352, 0, 14.64646, 3.53535, 0, 1.0101],
    [1490088351, 0, 27.77778, 3.0303, 0, 0],
    [1490088350, 0.49751, 12.93532, 2.98508, 0, 4.47761]
  ]
};

var dataValues = info.values;

var processedData = [];
var individualData={};

for(var k in dataValues){
  total=0;
  individualData={};
  for(var m=1,n=dataValues[k].length;m<n;m++ ){
    total+=dataValues[k][m];
  }

  individualData.timestamp=dataValues[k][0];
  individualData.total=total;
  processedData.push(individualData);

  console.log(processedData);
}

Answer 6

    var info = {
  "categories": ["timestamp", "softirq", "user", "system", "nice", "iowait"],
  "values": [
    [1490088352, 0, 14.64646, 3.53535, 0, 1.0101],
    [1490088351, 0, 27.77778, 3.0303, 0, 0],
    [1490088350, 0.49751, 12.93532, 2.98508, 0, 4.47761]
  ]
};

var dataValues = info.values;

var processedData = [];
var individualData={};

for(var k in dataValues){
  total=0;
  individualData={};
  for(var m=1,n=dataValues[k].length;m<n;m++ ){
    total+=dataValues[k][m];
  }

  individualData.timestamp=dataValues[k][0];
  individualData.total=total;
  processedData.push(individualData);

  console.log(processedData);
}

Answer 7

Answer №4


var array = {"labels":[ "time", "softirq", "user", "system", "nice", "iowait" ], "data":[ [ 1490088352, 0, 14.64646, 3.53535, 0, 1.0101 ], [ 1490088351, 0, 27.77778, 3.0303, 0, 0 ], [ 1490088350, 0.49751, 12.93532, 2.98508, 0, 4.47761 ]] };
var output = [];
for(var i = 0; i < array.data.length; i++){
    var object = {};
    object.time = array.data[i][0];
    object.sum = 0;
    for(var j = 1; j < array.data[i].length; j++){
        object.sum += array.data[i][j];
    }
    output.push(object);
}
console.log(output);

Answer 8


var array = {"labels":[ "time", "softirq", "user", "system", "nice", "iowait" ], "data":[ [ 1490088352, 0, 14.64646, 3.53535, 0, 1.0101 ], [ 1490088351, 0, 27.77778, 3.0303, 0, 0 ], [ 1490088350, 0.49751, 12.93532, 2.98508, 0, 4.47761 ]] };
var output = [];
for(var i = 0; i < array.data.length; i++){
    var object = {};
    object.time = array.data[i][0];
    object.sum = 0;
    for(var j = 1; j < array.data[i].length; j++){
        object.sum += array.data[i][j];
    }
    output.push(object);
}
console.log(output);

Answer 9

Answer №5

If you want to calculate sums based on specific labels and group them by time, one approach could be to utilize an array for the labels you are interested in and a hash table for grouping by time.

var data = { "labels": ["time", "softirq", "user", "system", "nice", "iowait"], "data": [[1490088352, 0, 14.64646, 3.53535, 0, 1.0101], [1490088351, 0, 27.77778, 3.0303, 0, 0], [1490088350, 0.49751, 12.93532, 2.98508, 0, 4.47761]] },
    labels = ["softirq", "user", "system", "nice", "iowait"],
    result = data.data.reduce(function (hash) {
        return function (r, a) {
            if (!hash[a[0]]) {
                hash[a[0]] = { time: a[0], sum: 0 };
                r.push(hash[a[0]]);
            }
            hash[a[0]].sum += labels.reduce(function (r, l) { return r + (a[data.labels.indexOf(l)] || 0); }, 0);
            return r;
        };
    }(Object.create(null)),[]);

console.log(result);

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

Answer 10

If you want to calculate sums based on specific labels and group them by time, one approach could be to utilize an array for the labels you are interested in and a hash table for grouping by time.

var data = { "labels": ["time", "softirq", "user", "system", "nice", "iowait"], "data": [[1490088352, 0, 14.64646, 3.53535, 0, 1.0101], [1490088351, 0, 27.77778, 3.0303, 0, 0], [1490088350, 0.49751, 12.93532, 2.98508, 0, 4.47761]] },
    labels = ["softirq", "user", "system", "nice", "iowait"],
    result = data.data.reduce(function (hash) {
        return function (r, a) {
            if (!hash[a[0]]) {
                hash[a[0]] = { time: a[0], sum: 0 };
                r.push(hash[a[0]]);
            }
            hash[a[0]].sum += labels.reduce(function (r, l) { return r + (a[data.labels.indexOf(l)] || 0); }, 0);
            return r;
        };
    }(Object.create(null)),[]);

console.log(result);

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

Answer 11

Answer №6

    var data = {
      "labels": ["time", "softirq", "user", "system", "nice", "iowait"],
      "data": [
        [1490088352, 0, 14.64646, 3.53535, 0, 1.0101],
        [1490088351, 0, 27.77778, 3.0303, 0, 0],
        [1490088350, 0.49751, 12.93532, 2.98508, 0, 4.47761]
      ]
    };
    var processedData = [];
for(var x = 0; x < data.data.length; x++){
  var jsonData = {"time" : data.data[x][0], "sum" : 0}
  for(var y = 1; y < data.data[x].length; y++){
        jsonData.sum += data.data[x][y];
  }
   processedData.push(jsonData)
}
console.log(processedData)

Answer 12

    var data = {
      "labels": ["time", "softirq", "user", "system", "nice", "iowait"],
      "data": [
        [1490088352, 0, 14.64646, 3.53535, 0, 1.0101],
        [1490088351, 0, 27.77778, 3.0303, 0, 0],
        [1490088350, 0.49751, 12.93532, 2.98508, 0, 4.47761]
      ]
    };
    var processedData = [];
for(var x = 0; x < data.data.length; x++){
  var jsonData = {"time" : data.data[x][0], "sum" : 0}
  for(var y = 1; y < data.data[x].length; y++){
        jsonData.sum += data.data[x][y];
  }
   processedData.push(jsonData)
}
console.log(processedData)

Understanding and aggregating data from JSON files

Answer №1

Answer №2

Answer №3

Answer №4

Answer №5

Answer №6

Similar questions

Convert a string with the characters '"' retrieved from a MySQL database into JSON

JavaScript Canvas - Preserve Image Transparency

Ways to trigger an npm script from a higher-level directory?

Display contents from a JSON file

I am experiencing an issue in Next.js where the styling of the Tailwind class obtained from the API is not being applied to my

Having trouble displaying images from the images folder in React

Express 4 Alert: Headers cannot be modified once they have been sent

Using Javascript to efficiently remove elements with AJAX

One can pass parameters to a promise's success callback within AngularJS using $q

ShadowBox not displaying Vimeo videos

An issue with displaying images has been identified within Next.js, resulting in an error message related to the hostname

What could be preventing the webpack dev server from launching my express server?

Setting multiple cookies with the setHeader method in NodeJs is a powerful capability that allows developers

"Incorporating JSON and Ajax to dynamically populate one select based on the selection in another select

Creating a simple bootstrap code for developing plugins in Wordpress

What is the best way to show and hide the information in a FAQ section when each one is clicked?

Personal Information Management

Only execute the NPM script if there is a staged JavaScript file

Partial implementation of jQuery datepicker feature facing technical issues

What is the best way to access automatically generated JavaScript variables in TypeScript?