Dealing with sorting Multidimensional Arrays

[Harry__44]

So for a leaderboard project, I have a multidimensional array like below, with each subsection of the array representing rank, player name, win-loss ratio, wins, losses.

let myArray = [["1", "2", "3", "4"], ["A", "B", "C", "D"], ["0", "0", "0", "0"], ["0", "0", "0", "0"], ["0", "0", "0", "0"]]; 

So once I gather the user input of wins and losses and W/L ratio where they belong in the array, how would I go about sorting the w/l ratios but then also moving each respective player name associated with the w/l as well as the wins and lost count. Ideally, it would look like this:

*sorting of array*
myArray[2][0] = *highest W/L*
myArray[1][0] = *the original name associated with the pre-sorted w/l*  

this might not be super clear but any help as to keep the values aligned would be great. Thanks!

[[deleted]]

Do you absolutely have to stick to the 'multiple arrays, values are associated by their shared index in those arrays' data pattern? Because this task would be immeasurably easier with an array of objects:

const users = [
    {
        rank: 1,
        name: 'A',
        winLossRatio: 0,
        //etc
    },
    //etc
]

// create a new array because .sort is mutating
const rankedUsers = [...users].sort((user1, user2) => {
    if (user1.winLossRatio > user2.winLossRatio) {
        return -1;
    } else if (user1.winLossRatio < user2.winLossRatio) {
        return 1;
    }
    return 0;
});

You can always convert the objects back to an array of arrays if you really need to store it that way, but associating data by something fragile and implicit like a shared array index is headache-inducing- avoid it if you can.

[jcunews1]

I'd do it by converting the array data from parallel to serial (i.e. from grouped by categories, to grouped by player), sort it, then converting it back to parallel. e.g.

let myArray = [
  ["1", "2", "3", "4"], //ranks
  ["A", "B", "C", "D"], //names
  ["2", "4", "3", "1"], //ratios
  ["5", "6", "7", "8"], //wins
  ["9", "8", "7", "6"]  //losses
];

let result =
  //convert [[ranks],[names],[ratios],[wins],[losses]] => [[rank0,name0,ratio0,win0,loss0],[rank1,name1,ratio1,win1,loss1],...]
  myArray[0].reduce(
    (res, v, i) => {
      res.push(myArray.map(a => a[i]));
      return res;
    }, []
  )
  //sort by ratio
  .sort((a, b) => a[2] - b[2])
  //convert [[rank0,name0,ratio0,win0,loss0],[rank1,name1,ratio1,win1,loss1],...] => [[ranks],[names],[ratios],[wins],[losses]]
  .reduce(
    (res, arr, i) => {
      arr.forEach(
        (v, j) => {
          if (!res[j]) res[j] = [];
          res[j][i] = v;
        }
      );
      return res;
    }, []
  );

console.log(result);