Getting max value(s) in JSON array

Question

I'm trying to create a JavaScript function which takes information from an array in an external JSON and then takes the max value (or the top 5 values) for one of the JSON variables. For this example, let's say I want to get the max value for the value "ppg". Here is a small sample of the array:

[
{
    "player" : "Andre Drummond",
    "team" : "Detroit Pistons",
    "ppg" : "15.4",
    "rpg" : "11.6",
    "apg" : "2.4",
    "bpg" : "1.6",
    "spg" : "0.8",
    "3pg" : "0.1"
},
{
    "player" : "Anthony Davis",
    "team" : "New Orleans Pelicans",
    "ppg" : "16.4",
    "rpg" : "13.6",
    "apg" : "2.6",
    "bpg" : "3.5",
    "spg" : "1.2",
    "3pg" : "0.1"
},
{
    "player" : "Carmelo Anthony",
    "team" : "New York Knicks",
    "ppg" : "27.4",
    "rpg" : "5.4",
    "apg" : "4.5",
    "bpg" : "1.1",
    "spg" : "1.5",
    "3pg" : "1.6"
}
]

What would be the best way to go through the array to get the max value and then get the values "player" and "team" from this value? The page will be interactive, as I will have a drop-down menu bar with allows the viewer to choose between one of the six JSON values aside from "player" and "team". Thanks in advance!

Duplicate of stackoverflow.com/questions/4020796/… please see it for solution — user3511851
– user3511851, Commented Apr 8, 2014 at 22:48
maybe my problem would be i'm new to json, and i think i could figure out the code if it was a javascript array. i'm writing code in the meantime to see if i can figure it out on my own. — Les Paul
– Les Paul, Commented Apr 8, 2014 at 22:49
@LesPaul - JSON is just a text format for expressing some javascript data structures. Once you call JSON.parse() on the JSON, it's just regular javascript. — jfriend00
– jfriend00, Commented Apr 8, 2014 at 22:50
For future reference, anyone who wants to try to load an external JSON file into a variable check out here: stackoverflow.com/questions/2177548/load-json-into-variable — Les Paul
– Les Paul, Commented Apr 9, 2014 at 3:38

Community · Accepted Answer · 2019-10-05 21:40:47Z

30

Just cycle through the array, and keep track of the max as you go:

function getMax(arr, prop) {
    var max;
    for (var i=0 ; i<arr.length ; i++) {
        if (max == null || parseInt(arr[i][prop]) > parseInt(max[prop]))
            max = arr[i];
    }
    return max;
}

Usage is like:

var maxPpg = getMax(arr, "ppg");
console.log(maxPpg.player + " - " + maxPpg.team);

Fiddle demo

Edit

You can also use the Javascript "sort" method to get the top n values:

function getTopN(arr, prop, n) {
    // clone before sorting, to preserve the original array
    var clone = arr.slice(0); 

    // sort descending
    clone.sort(function(x, y) {
        if (x[prop] == y[prop]) return 0;
        else if (parseInt(x[prop]) < parseInt(y[prop])) return 1;
        else return -1;
    });

    return clone.slice(0, n || 1);
}

Usage:

var topScorers = getTopN(arr, "ppg", 2);
topScorers.forEach(function(item, index) {
    console.log("#" + (index+1) + ": " + item.player);
});

Fiddle demo

edited Oct 5, 2019 at 21:40

CommunityBot

11 silver badge

answered Apr 8, 2014 at 22:49

McGarnagle

103k31 gold badges235 silver badges264 bronze badges

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

6 Comments

Les Paul Over a year ago

This works when I have the array as a variable within the JavaScript function, but when I have arr as: var arr = $.getJSON(file); then it doesn't work.

McGarnagle Over a year ago

@LesPaul sounds like an async problem? You have to use a callback, like $.getJSON(function(arr) { var top2 = getTopN(arr, "ppg", 2); });

Les Paul Over a year ago

For future reference, anyone who wants to try to load an external JSON file into a variable check out here: stackoverflow.com/questions/2177548/load-json-into-variable

Les Paul Over a year ago

Now that I have paid more attention to the results in the console, I see that I do not get the players I am supposed to as the top scorers. For instance, I should be getting Kevin Durant (32.1) but I get Chris Kaman as the top scorer. I could easily fix this if CK was the lowest scorer but he's not....he's square in the middle.

McGarnagle Over a year ago

@LesPaul ah, I think I see the problem. The values in the JSON are strings, so they're being compared as strings. Using parseInt on the values should fix this. I've updated above.

|

ashleedawg · Accepted Answer · 2019-12-25 16:59:09Z

I found the following approach very neat:

arr.sort( 
  function(a, b) {
     return parseFloat(b['ppg']) - parseFloat(a['ppg']);
  }
)[0]['player']

Demo in snippet:

var arr =[
{
    "player" : "Andre Drummond",
    "team" : "Detroit Pistons",
    "ppg" : "15.4",
    "rpg" : "11.6",
    "apg" : "2.4",
    "bpg" : "1.6",
    "spg" : "0.8",
    "3pg" : "0.1"
},
{
    "player" : "Anthony Davis",
    "team" : "New Orleans Pelicans",
    "ppg" : "16.4",
    "rpg" : "13.6",
    "apg" : "2.6",
    "bpg" : "3.5",
    "spg" : "1.2",
    "3pg" : "0.1"
},
{
    "player" : "Carmelo Anthony",
    "team" : "New York Knicks",
    "ppg" : "27.4",
    "rpg" : "5.4",
    "apg" : "4.5",
    "bpg" : "1.1",
    "spg" : "1.5",
    "3pg" : "1.6"
}
]
console.log(
arr.sort( 
    function(a, b) {
       return parseFloat(b['ppg']) - parseFloat(a['ppg']);
    }
    )[0]['player']
);

First, I sort the array in descending order, then I choose the first element which contains the max value. In the code, I found the player who has the max ppg value. Hope this helps!

Akinkunle Allen · Accepted Answer · 2014-04-08 23:02:08Z

5

This should work:

var highestValue = 0; //keep track of highest value

//loop through array of objects
for (var i=0, len = ary.length; i<len; i++) {
  var value = Number(ary[i]["ppg"]);
  if (value > highestValue) {
      highestValue = value;
  }
}

edited Apr 8, 2014 at 23:02

answered Apr 8, 2014 at 22:53

Akinkunle Allen

1,30912 silver badges20 bronze badges

Comments

BenR · Accepted Answer · 2014-04-08 23:01:12Z

2

You might find this sortByAttribute function useful. Just pass in the attribute by string you're looking to sort it by, and it'll return whatever object has the max value for the specific attribute you're looking for. It'll still return the whole array, just sorted ascending by the property you specified.

var myArr = [
    {
        "player" : "Andre Drummond",
        "team" : "Detroit Pistons",
        "ppg" : "15.4",
        "rpg" : "11.6",
        "apg" : "2.4",
        "bpg" : "1.6",
        "spg" : "0.8",
        "3pg" : "0.1"
    },
    {
        "player" : "Anthony Davis",
        "team" : "New Orleans Pelicans",
        "ppg" : "16.4",
        "rpg" : "13.6",
        "apg" : "2.6",
        "bpg" : "3.5",
        "spg" : "1.2",
        "3pg" : "0.1"
    },
    {
        "player" : "Carmelo Anthony",
        "team" : "New York Knicks",
        "ppg" : "27.4",
        "rpg" : "5.4",
        "apg" : "4.5",
        "bpg" : "1.1",
        "spg" : "1.5",
        "3pg" : "1.6"
    }
  ]


function sortByAttribue(arr, attribute) {
  return arr.sort(function(a,b) { 
    return a[attribute] < b[attribute];
  });
}

sortByAttribue(myArr, "3pg") // returns Carmelo Anthony first
sortByAttribue(myArr, "bpg") // returns Anthony Davis first

answered Apr 8, 2014 at 23:01

BenR

2,9453 gold badges29 silver badges39 bronze badges

1 Comment

Les Paul Over a year ago

This almost works. Whatever the first sortByAttribute function returns, that's the value I get for both sortByAttributes in both Firefox's and Chrome's console. So if I have "3pg" as the value passed in the first sortByAttribute function, I get "Carmelo Anthony" first for both sortByAttribute functions. If I have "bpg" as the value passed in the first sortByAttribute function, I get "Anthony Davis" first for both sortByAttribute functions.

jwriteclub · Accepted Answer · 2018-04-02 12:48:00Z

2

function getMaxOfJson(jsonalreadyparsed, property) {
    var max = null;
    for (var i=0 ; i<jsonalreadyparsed.length ; i++) {

            if(max == null){

                max = jsonalreadyparsed[i][property];

            } else {

            if (parseFloat(jsonalreadyparsed[i][property]) > max){

                max = jsonalreadyparsed[i][property];

            }

        }

    }
    return max;
}

This works for me.

edited Apr 2, 2018 at 12:48

jwriteclub

1,6151 gold badge17 silver badges33 bronze badges

answered Apr 2, 2018 at 11:15

Dankyi Anno Kwaku

1,3305 gold badges19 silver badges27 bronze badges

Comments

A. Wheatman · Accepted Answer · 2014-04-08 23:02:45Z

1

function that's looking for item with the specific property'x maximum:

function getMax(array, propName) {
    var max = 0;
    var maxItem = null;
    for(var i=0; i<array.length; i++) {
        var item = array[i];
        if(item[propName] > max) {
            max = item[propName];
            maxItem = item;
        }
    }

    return maxItem;
}

usage:

$(document).ready(function() {
    $('#getMaxBtn').click(function() {
        var max = getMax(jsonArray, 'ppg');

        alert(max.player);
    });
});

answered Apr 8, 2014 at 23:02

A. Wheatman

6,4366 gold badges48 silver badges63 bronze badges

Comments

KingKongFrog · Accepted Answer · 2014-04-09 03:42:53Z

1

This will allow you to choose what stat you want and what information you want back.

http://jsbin.com/tudegofa/1/edit

data => is the array

stat => is the stat you want to sort by

info => is an array of properties you want returned.

function getValues (data, stat, info)
{
  var selectedValues = data.map(function(x) {
    return parseFloat(x[stat]);
  })

  var i = selectedValues.indexOf(Math.max.apply(Math, selectedValues));

  var result = {};
  info.forEach(function(x) {
      result[x] = test[i][x];
  })
  return result;
}

var myData = '';
$.getJSON('/url/to/grab/json', function(data) {

  myData = data;

});

getValues(myData, "bpg", ["player","team"]);

//[object Object] {
//  player: "Anthony Davis",
//  team: "New Orleans Pelicans"
// }

edited Apr 9, 2014 at 3:42

answered Apr 8, 2014 at 22:59

KingKongFrog

14.5k22 gold badges78 silver badges134 bronze badges

4 Comments

Les Paul Over a year ago

I get this error in the console.log: TypeError: data.map is not a function

KingKongFrog Over a year ago

is your data in the form of an array, like you mentioned above?

Les Paul Over a year ago

it is as listed above. it should be noted that it is in an external json file

KingKongFrog Over a year ago

I added some code to show how to get your json into the function.

kmonsoor · Accepted Answer · 2016-08-26 11:55:31Z

1

Simplicity thanks you in the long run.

function getMaxValueByAttribute(arr, attr) {
    var max = "-99999999999";
    arr.forEach(function (member, index) {
            // console.log(member, index);
            if (member.hasOwnProperty(attr) && parseFloat(member[attr]) > parseFloat(max)) {
                max = member[attr];
                // console.log("Max now: " + max);
            }
        });
    return max;
    }

Then use it like:

var result = getMaxValueByAttribute(arr, "ppg");
// result = "27.4"

answered Aug 26, 2016 at 11:55

kmonsoor

8,1797 gold badges43 silver badges58 bronze badges

Comments

Penny Liu · Accepted Answer · 2018-11-01 06:42:45Z

You can do it by lodash so easily.

var players = [{
    "player": "Andre Drummond",
    "team": "Detroit Pistons",
    "ppg": "15.4",
    "rpg": "11.6",
    "apg": "2.4",
    "bpg": "1.6",
    "spg": "0.8",
    "3pg": "0.1"
  },
  {
    "player": "Anthony Davis",
    "team": "New Orleans Pelicans",
    "ppg": "16.4",
    "rpg": "13.6",
    "apg": "2.6",
    "bpg": "3.5",
    "spg": "1.2",
    "3pg": "0.1"
  },
  {
    "player": "Carmelo Anthony",
    "team": "New York Knicks",
    "ppg": "27.4",
    "rpg": "5.4",
    "apg": "4.5",
    "bpg": "1.1",
    "spg": "1.5",
    "3pg": "1.6"
  }
];

var topscorer = _
  .chain(players)
  .sortBy('ppg')
  .reverse()
  .map(function(o) {
    return 'Top scorer: ' + o.player + ' - ' + o.team;
  })
  .head()
  .value();

console.log(topscorer);

<script src="https://cdnjs.cloudflare.com/ajax/libs/lodash.js/4.17.11/lodash.core.min.js"></script>

Or even shorter:

var players = [{
    "player": "Andre Drummond",
    "team": "Detroit Pistons",
    "ppg": "15.4",
    "rpg": "11.6",
    "apg": "2.4",
    "bpg": "1.6",
    "spg": "0.8",
    "3pg": "0.1"
  },
  {
    "player": "Anthony Davis",
    "team": "New Orleans Pelicans",
    "ppg": "16.4",
    "rpg": "13.6",
    "apg": "2.6",
    "bpg": "3.5",
    "spg": "1.2",
    "3pg": "0.1"
  },
  {
    "player": "Carmelo Anthony",
    "team": "New York Knicks",
    "ppg": "27.4",
    "rpg": "5.4",
    "apg": "4.5",
    "bpg": "1.1",
    "spg": "1.5",
    "3pg": "1.6"
  }
];
console.log(_.maxBy(players, 'ppg').player);

<script src="https://cdnjs.cloudflare.com/ajax/libs/lodash.js/4.17.4/lodash.min.js"></script>

Juan · Accepted Answer · 2020-04-09 18:34:45Z

1

My solution here. Remember to use == instead of === to compare a number with a string.

const getMax = (arr, prop) => {
  const tmp = arr.map(x => x[prop]);
  const max = Math.max(...tmp);
  return arr.filter(x => x[prop] == max);
}

getMax(myArr,"bpg")

One line version:

myArr.filter( x => x["bpg"] == Math.max(...myArr.map(x => x["bpg"])) )

answered Apr 9, 2020 at 18:34

Juan

391 silver badge10 bronze badges

Comments

Mister Jojo · Accepted Answer · 2020-09-24 00:48:50Z

1

the more simple:

const players =                                           
  [ { player: 'Andre Drummond',  team: 'Detroit Pistons',      ppg: '15.4', rpg: '11.6', apg: '2.4', bpg: '1.6', spg: '0.8', '3pg': '0.1' } 
  , { player: 'Anthony Davis',   team: 'New Orleans Pelicans', ppg: '16.4', rpg: '13.6', apg: '2.6', bpg: '3.5', spg: '1.2', '3pg': '0.1' } 
  , { player: 'Carmelo Anthony', team: 'New York Knicks',      ppg: '27.4', rpg: '5.4',  apg: '4.5', bpg: '1.1', spg: '1.5', '3pg': '1.6' } 
  ] 

const getPlayerMax_on = cod => players.reduce((a,c)=>((+a[cod])<(+c[cod]))?c:a)

const maxOn_ppg = getPlayerMax_on('ppg')

console.log( maxOn_ppg.player, maxOn_ppg.team, maxOn_ppg.ppg )

answered Sep 24, 2020 at 0:48

Mister Jojo

22.9k6 gold badges28 silver badges45 bronze badges

Comments

SamiElk · Accepted Answer · 2022-02-02 16:13:01Z

1

Lodash MaxBy

e.g.

var players = [{
     "name": "marvin",
     "age": "21"
  },
  {
    "name": "Lucy",
    "age": "26"
  },
  {
    "name": "james",
    "age": "21"
  }
];

maxBy(Players, 'age')

if its a raw json object i.e

maxBy(JSON.parse(Players), 'age')

=> {"name": "Lucy","age": "26"},

You can even return just the age i.e. maxBy(Players, 'age').age

=> 26

edited Feb 2, 2022 at 16:13

SamiElk

2,3829 silver badges22 bronze badges

answered Feb 2, 2022 at 11:57

James Mwali

111 bronze badge

Comments

Vikram Singh Katewa · Accepted Answer · 2024-05-20 03:08:31Z

0

const arr = [
{
    "player" : "Andre Drummond",
    "team" : "Detroit Pistons",
    "ppg" : "15.4",
    "rpg" : "11.6",
    "apg" : "2.4",
    "bpg" : "1.6",
    "spg" : "0.8",
    "3pg" : "0.1"
},
{
    "player" : "Anthony Davis",
    "team" : "New Orleans Pelicans",
    "ppg" : "16.4",
    "rpg" : "13.6",
    "apg" : "2.6",
    "bpg" : "3.5",
    "spg" : "1.2",
    "3pg" : "0.1"
},
{
    "player" : "Carmelo Anthony",
    "team" : "New York Knicks",
    "ppg" : "27.4",
    "rpg" : "5.4",
    "apg" : "4.5",
    "bpg" : "1.1",
    "spg" : "1.5",
    "3pg" : "1.6"
}
];
const maxValue = arr.reduce((n, {rpg}) => parseFloat(n) > parseFloat(rpg) ? parseFloat(n) :  parseFloat(rpg), 0)
console.log(maxValue)

answered May 20, 2024 at 3:08

Vikram Singh Katewa

4194 silver badges5 bronze badges

Collectives™ on Stack Overflow

Getting max value(s) in JSON array

13 Answers 13

6 Comments

Comments

Comments

1 Comment

Comments

Comments

4 Comments

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

13 Answers 13

6 Comments

Comments

Comments

1 Comment

Comments

Comments

4 Comments

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related