Sort an array by mapping it in decreasing order based on the total sum of its elements

Question

Sort an array by mapping it in decreasing order based on the total sum of its elements

I came across a JSON structure that looks like the following:

{
"user": [
   {"username": "x1", "pfp": "", "scores": [{"easy": 10, "normal": 1, "hard": 2, "oni": 3, "uraoni": 4}]},
   {"username": "x2", "pfp": "", "scores": [{"easy": 3, "normal": 1, "hard": 2, "oni": 3, "uraoni": 4}]},
   {"username": "x3", "pfp": "", "scores": [{"easy": 5, "normal": 1, "hard": 2, "oni": 3, "uraoni": 4}]},
   {"username": "x4", "pfp": "", "scores": [{"easy": 0, "normal": 40, "hard": 2, "oni": 3, "uraoni": 4}]}
]
}

The desired result when ordered by username should be: x4, x1, x3, x2 (x4 with a total of 49, x1 with 20, x2 with 15, and x3 with 13).

I am looking to use the map() function to organize the array based on the sum of the scores.

I attempted to use map for reducing the scores and then sorting it, but encountered difficulties with the reduce() method.

let userscopy = userjson
  userscopy.map((user) => (
    user.scores[0] = JSON.parse(user.scores).reduce((a, b) => a + b)
  ))

https://i.stack.imgur.com/eoWRN.png Any thoughts or suggestions?

javascript next.js

Answer 1

Answer №1

To simplify your code, consider creating a helper function called calculateTotal that can be used to calculate the total scores and then sort them accordingly:

const data = {
  user: [
    {
      username: 'player1',
      scores: [{ easy: 10, normal: 1, hard: 2, expert: 3, master: 4 }],
    },
    {
      username: 'player2',
      scores: [{ easy: 3, normal: 1, hard: 2, expert: 3, master: 4 }],
    },
    {
      username: 'player3',
      scores: [{ easy: 5, normal: 1, hard: 2, expert: 3, master: 4 }],
    },
    {
      username: 'player4',
      scores: [{ easy: 0, normal: 40, hard: 2, expert: 3, master: 4 }],
    },
  ],
};

const calculateTotal = (user) => {
  if (user.scores.length === 0) return 0;
  const { easy, normal, hard, expert, master } = user.scores[0];
  return easy + normal + hard + expert + master;
};

const sortedUsers = data.user.sort((a, b) => calculateTotal(b) - calculateTotal(a));

console.log(sortedUsers);

Answer 2

To simplify your code, consider creating a helper function called calculateTotal that can be used to calculate the total scores and then sort them accordingly:

const data = {
  user: [
    {
      username: 'player1',
      scores: [{ easy: 10, normal: 1, hard: 2, expert: 3, master: 4 }],
    },
    {
      username: 'player2',
      scores: [{ easy: 3, normal: 1, hard: 2, expert: 3, master: 4 }],
    },
    {
      username: 'player3',
      scores: [{ easy: 5, normal: 1, hard: 2, expert: 3, master: 4 }],
    },
    {
      username: 'player4',
      scores: [{ easy: 0, normal: 40, hard: 2, expert: 3, master: 4 }],
    },
  ],
};

const calculateTotal = (user) => {
  if (user.scores.length === 0) return 0;
  const { easy, normal, hard, expert, master } = user.scores[0];
  return easy + normal + hard + expert + master;
};

const sortedUsers = data.user.sort((a, b) => calculateTotal(b) - calculateTotal(a));

console.log(sortedUsers);

Answer 3

Answer №2

Do you happen to need this information?

const userjson = {
  "user": [{
      "username": "x",
      "pfp": "",
      "scores": [{
        "easy": 0,
        "normal": 1,
        "hard": 2,
        "oni": 3,
        "uraoni": 4
      }]
    },
    {
      "username": "x",
      "pfp": "",
      "scores": [{
        "easy": 0,
        "normal": 1,
        "hard": 2,
        "oni": 3,
        "uraoni": 4
      }]
    },
    {
      "username": "x",
      "pfp": "",
      "scores": [{
        "easy": 0,
        "normal": 1,
        "hard": 2,
        "oni": 3,
        "uraoni": 4
      }]
    },
    {
      "username": "x",
      "pfp": "",
      "scores": [{
        "easy": 0,
        "normal": 1,
        "hard": 2,
        "oni": 3,
        "uraoni": 4
  }]
}

] }

1- .map() is used with arrays, so use userjson.user.map() instead of userjson.map() as the array is inside the user property

2- JSON.parse() should be removed since the json is not valid at the moment

3- Use index for your x.scores[i]

const result = userjson.user.map((x,i) => (
    x.scores[i] = x.scores.reduce((a, b) => a + b)
  ))
  
console.log(result);

Answer 4

Do you happen to need this information?

const userjson = {
  "user": [{
      "username": "x",
      "pfp": "",
      "scores": [{
        "easy": 0,
        "normal": 1,
        "hard": 2,
        "oni": 3,
        "uraoni": 4
      }]
    },
    {
      "username": "x",
      "pfp": "",
      "scores": [{
        "easy": 0,
        "normal": 1,
        "hard": 2,
        "oni": 3,
        "uraoni": 4
      }]
    },
    {
      "username": "x",
      "pfp": "",
      "scores": [{
        "easy": 0,
        "normal": 1,
        "hard": 2,
        "oni": 3,
        "uraoni": 4
      }]
    },
    {
      "username": "x",
      "pfp": "",
      "scores": [{
        "easy": 0,
        "normal": 1,
        "hard": 2,
        "oni": 3,
        "uraoni": 4
  }]
}

] }

1- .map() is used with arrays, so use userjson.user.map() instead of userjson.map() as the array is inside the user property

2- JSON.parse() should be removed since the json is not valid at the moment

3- Use index for your x.scores[i]

const result = userjson.user.map((x,i) => (
    x.scores[i] = x.scores.reduce((a, b) => a + b)
  ))
  
console.log(result);

Answer 5

Answer №3

const userScores = {
"user": [
   {"username": "x1", "pfp": "", "scores": [{"easy": 10, "normal": 1, "hard": 2, "oni": 3, "uraoni": 4}]},
   {"username": "x2", "pfp": "", "scores": [{"easy": 3, "normal": 1, "hard": 2, "oni": 3, "uraoni": 4}]},
   {"username": "x3", "pfp": "", "scores": [{"easy": 5, "normal": 1, "hard": 2, "oni": 3, "uraoni": 4}]},
   {"username": "x4", "pfp": "", "scores": [{"easy": 0, "normal": 40, "hard": 2, "oni": 3, "uraoni": 4}]}
]
};

const orderedUsernames = userScores.user
  .sort((a, b) => calculateTotalScore(b.scores[0]) - calculateTotalScore(a.scores[0]))
  .map(({ username }) => username);

console.log(orderedUsernames);

function calculateTotalScore(scores) {
  return Object.values(scores).reduce((previous, next) => previous + next, 0);
}

Answer 6

const userScores = {
"user": [
   {"username": "x1", "pfp": "", "scores": [{"easy": 10, "normal": 1, "hard": 2, "oni": 3, "uraoni": 4}]},
   {"username": "x2", "pfp": "", "scores": [{"easy": 3, "normal": 1, "hard": 2, "oni": 3, "uraoni": 4}]},
   {"username": "x3", "pfp": "", "scores": [{"easy": 5, "normal": 1, "hard": 2, "oni": 3, "uraoni": 4}]},
   {"username": "x4", "pfp": "", "scores": [{"easy": 0, "normal": 40, "hard": 2, "oni": 3, "uraoni": 4}]}
]
};

const orderedUsernames = userScores.user
  .sort((a, b) => calculateTotalScore(b.scores[0]) - calculateTotalScore(a.scores[0]))
  .map(({ username }) => username);

console.log(orderedUsernames);

function calculateTotalScore(scores) {
  return Object.values(scores).reduce((previous, next) => previous + next, 0);
}

Sort an array by mapping it in decreasing order based on the total sum of its elements

Answer №1

Answer №2

Answer №3

Similar questions

ReactJs CSS - This file type requires a specific loader for processing. There are currently no loaders configured to handle this file

Having difficulty implementing pagination functionality when web scraping using NodeJS

I'm curious, which ref tag should I utilize for draft.js?

Tips for triggering jquery code when a variable containing a CSS attribute is modified

Display visual information without requiring the parameters to be filtered beforehand in vue.js

Unable to upload file on ReactJS platform

Alter the Cascading Style Sheets (CSS) value by accessing a

Angular Translate Directive Unleashes the Power of XSS Vulnerabilities

Some of the Tailwind CSS colors may not be fully supported by Next.js for rendering

What is the best way to eliminate YouTube branding from a video embedded in a website?

Navigating the issue of "Experiencing additional hooks rendered compared to the previous render"

After upgrading from Next.js 14.1.0 to 14.1.4, I encountered an error stating that the session cookie exceeds the allowed 4096 bytes limit in Next Auth

Using Express and Node.js to implement the Google Maps API

When attempting to access API>19 on my Android device, I encountered an error in my Interface to Java that stated: "TypeError: Android.method is not a function."

Sending Python Object from Django View to Javascript Script in Template

Occasionally, the render process may be delayed by the Next.js buildManifest and ssgManifest

Encountering Error 500 with Jquery Min.Map File

Storing the order of jQuery UI Sortable in the WordPress Admin Panel

Updating text color with Ajax response value

Encountered a CLIENT_FETCH_ERROR when attempting to access getSession within the apollo context