Sort by object property in two dimensional array in Javascript/Node.Js

Question

I am analysing log files and I'd like to make it easier to read by sorting the requests by descending order. The problem is that I have a two dimensional array with an object in each, I want to sort the arrays by one of their object property (Average response time here) and I don't know how to access to it...

Here is a piece of the final log file for you to understand:

[
    [
        {
            "Request": "/sql/sqlweb/",
            "Average response time": "2.685 ms",
            "Number of calls": 1
        }
    ],
    [
        {
            "Request": "/",
            "Average response time": "1.219 ms",
            "Number of calls": 2529
        }
    ],
    [
        {
            "Request": "/mysql/admin/",
            "Average response time": "4.086 ms",
            "Number of calls": 1
        }
    ],
    [
        {
            "Request": "/mysql/sqlmanager/",
            "Average response time": "2.774 ms",
            "Number of calls": 1
        }
    ],
    [
        {
            "Request": "/phpmyadmin/",
            "Average response time": "2.417 ms",
            "Number of calls": 2
        }
    ]
]

This is after a JSON.stringify() on my array. I can also copy/paste the current version of my code if you need it.

Ps: I can easily remove the "ms" if it helps.

you want to sort the inner arrays? so result will be similar to this (2 dimensional array) but sorted the inner array. or you want one final array (1 dimensional) where the objects will be there in sorted order? — Koushik Chatterjee
– Koushik Chatterjee, Commented Jul 24, 2017 at 15:52

Dij · Accepted Answer · 2017-07-24 15:55:14Z

you can use sort(), you can write a comparator function in which you compare objects inside array using there average response times, for this you can use parseFloat()

var arr = [
[
    {
        "Request": "/sql/sqlweb/",
        "Average response time": "2.685 ms",
        "Number of calls": 1
    }
],
[
    {
        "Request": "/",
        "Average response time": "1.219 ms",
        "Number of calls": 2529
    }
],
[
    {
        "Request": "/mysql/admin/",
        "Average response time": "4.086 ms",
        "Number of calls": 1
    }
],
[
    {
        "Request": "/mysql/sqlmanager/",
        "Average response time": "2.774 ms",
        "Number of calls": 1
    }
],
[
    {
        "Request": "/phpmyadmin/",
        "Average response time": "2.417 ms",
        "Number of calls": 2
    }
]
];

arr.sort(function(a,b){
return parseFloat(a[0]["Average response time"]) - parseFloat(b[0]["Average response time"]);
});

console.log(arr);

Nina Scholz · Accepted Answer · 2017-07-24 15:53:56Z

0

You could take the first object of the inner array and then the wanted property for sorting.

var array = [[{ Request: "/sql/sqlweb/", "Average response time": "2.685 ms", "Number of calls": 1 }], [{ Request: "/", "Average response time": "1.219 ms", "Number of calls": 2529 }], [{ Request: "/mysql/admin/", "Average response time": "4.086 ms", "Number of calls": 1 }], [{ Request: "/mysql/sqlmanager/", "Average response time": "2.774 ms", "Number of calls": 1 }], [{ Request: "/phpmyadmin/", "Average response time": "2.417 ms", "Number of calls": 2 }]];

array.sort(function (a, b) {
    function getV(o) {
        return o[0]['Average response time'].match(/\d+\.?\d*/);
    }
    return getV(b) - getV(a);
});

console.log(array);

.as-console-wrapper { max-height: 100% !important; top: 0; }

answered Jul 24, 2017 at 15:53

Nina Scholz

388k26 gold badges367 silver badges417 bronze badges

1 Comment

Psychologist Over a year ago

Actually I eventually found the answer to my question by adding the [0] index but thanks for your quick answer anyway! Ps: Thanks for the tip to keep only the value with the regex :)

Jake Boggs · Accepted Answer · 2017-07-24 15:58:54Z

You can do this:

[
    [
        {
            "Request": "/sql/sqlweb/",
            "Average response time": "2.685 ms",
            "Number of calls": 1
        }
    ],
    [
        {
            "Request": "/",
            "Average response time": "1.219 ms",
            "Number of calls": 2529
        }
    ],
    [
        {
            "Request": "/mysql/admin/",
            "Average response time": "4.086 ms",
            "Number of calls": 1
        }
    ],
    [
        {
            "Request": "/mysql/sqlmanager/",
            "Average response time": "2.774 ms",
            "Number of calls": 1
        }
    ],
    [
        {
            "Request": "/phpmyadmin/",
            "Average response time": "2.417 ms",
            "Number of calls": 2
        }
    ]
].sort(function(a, b) {
    return Number(a[0]["Average response time"].replace(/[^0-9]+/g, "")) - Number(b[0]["Average response time"].replace(/[^0-9]+/g, ""));
});

amtg · Accepted Answer · 2017-07-24 16:00:07Z

0

You need to use array.sort with a custom comparator.

answered Jul 24, 2017 at 16:00

amtg

1346 bronze badges

Collectives™ on Stack Overflow

Sort by object property in two dimensional array in Javascript/Node.Js

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related