How to add/sum the desired indexs of an array from specific array?

Question

I have the following data structure and this data needs to be sorted by the sum of the first two indexes of an array in "104".

{
  "data":{
    "Org 1":{
      "102":[
        0.1444,
        0.1551,
        0.2369,
        0.3353,
        0.1282
      ],
      "104":[
        0.309,
        0.3483,
        0.218,
        0.0657,
        0.059
      ]
    },
    "Org 2":{
      "102":[
        0.19444444444444448,
        0.1388888888888889,
        0.19444444444444448,
        0.33333333333333326,
        0.1388888888888889
      ],
      "104":[
        0.20588235294117646,
        0.38235294117647056,
        0.14705882352941177,
        0.14705882352941177,
        0.1176470588235294
      ],
    },
    "Org 3":{
      "102":[
        0.0967741935483871,
        0.2903225806451613,
        0.16129032258064516,
        0.3548387096774194,
        0.0967741935483871
      ],
      "104":[
        0.44,
        0.24,
        0.2,
        0.04,
        0.08
      ]
    }
  }
}

How can I make this work? Can someone please help?

This is what I tried so far but it's not working as expected

let orgs = Object.keys(data);
let options = [];
let selection = orgs.forEach((data, d) => {
  data["104"].forEach((val, i) => {
    options[i].data.push(val);
  })
});

@HereticMonkey sorry, I meant to say values of the first two indexes in array 104 and not the actual index. — Shaun
– Shaun, Commented Apr 2, 2021 at 20:21

Zunayed Shahriar · Accepted Answer · 2021-04-02 20:31:22Z

1

First, we need to transform the data into an array for sorting.

Then define our own compare function as our requirement.

Finally, sort the array.

Run the snippet to check the result.

Solution:

var data = {
  "Org 1":{
    "102":[
      0.1444,
      0.1551,
      0.2369,
      0.3353,
      0.1282
    ],
    "104":[
      0.309,
      0.3483,
      0.218,
      0.0657,
      0.059
    ]
  },
  "Org 2":{
    "102":[
      0.19444444444444448,
      0.1388888888888889,
      0.19444444444444448,
      0.33333333333333326,
      0.1388888888888889
    ],
    "104":[
      0.20588235294117646,
      0.38235294117647056,
      0.14705882352941177,
      0.14705882352941177,
      0.1176470588235294
    ],
  },
  "Org 3":{
    "102":[
      0.0967741935483871,
      0.2903225806451613,
      0.16129032258064516,
      0.3548387096774194,
      0.0967741935483871
    ],
    "104":[
      0.44,
      0.24,
      0.2,
      0.04,
      0.08
    ]
  }
};

const transformedData = [];

Object.keys(data).forEach(
  f => {
    transformedData.push(data[f]);
  }
)

function compare(a, b) {
  var arrA = a["104"];
  var arrB = b["104"];

  if (arrA[0]+arrA[1] < arrB[0]+arrB[1]) {
    return -1;
  }
  if (arrA[0]+arrA[1] > arrB[0]+arrB[1]) {
    return 1;
  }
  
  return 0;
}

transformedData.sort(compare);
console.log(transformedData);

Breakdown:

(0.205882352941176 + 0.38235294117647) < (0.309 + 0.3483) < (0.44 + 0.24)

edited Apr 2, 2021 at 20:31

answered Apr 2, 2021 at 20:25

Zunayed Shahriar

2,7632 gold badges14 silver badges15 bronze badges

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

2 Comments

Heretic Monkey Over a year ago

This does not sort the structure so much as change the structure into one that can be sorted, which is not what the OP asked for.

Zunayed Shahriar Over a year ago

@HereticMonkey, I'm confused now. Let's see what the OP says about it.

Collectives™ on Stack Overflow

How to add/sum the desired indexs of an array from specific array?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related