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

What is the best way to denote arrays in ember-data models?

The JavaScript .load() function fails to run

What is the easiest way to include a copyright symbol in a React component?

The choice between using inline style objects with React or utilizing traditional CSS classes presents distinct advantages and

Incorporate fresh Google sites into different web pages using iFrame integration

What is the best way to create a Div element that functions as a button, becoming active when clicked while deactivating all other Div elements

How can I prevent a repetitive div from appearing in a JQuery show/hide function?

Enhance the size of dynamically generated svg elements by scrolling the mouse wheel in and out

Dynamic horizontal scrolling

The barcode is not displaying when using javascript:window.print() to print

Searching for an array of IDs in Mongoose

Ways to detach event listener in Vue Component

Unraveling the Enigma of Event Handlers: Mastering the Organization of a Sprawling jQuery File within an AJAX

The JSON output is throwing an error because it is unable to access the property '0' since it is

Error message: Unable to load image from local source in Vue application

The functionality of wp_script_is in WordPress seems to be malfunctioning when it comes to

Having trouble with Django REST API and Axios POST request not functioning properly

How can I activate JQUERY when an event occurs?

Steps for generating an HTML form in a fresh window

Search the database to retrieve a specific value from a multi-dimensional array