Sorting a 2D array in Javascript based on numerical values

Question

Sorting a 2D array in Javascript based on numerical values

I've come across a few similar posts regarding this issue, but none have provided solutions that work for my specific situation. I'm feeling lost on how to solve this problem (like Sort a 2D array by the second value)

Let me explain the challenge I'm facing in JavaScript;

I have two arrays that I'm using to generate a chart in a third-party tool. Here are the variables I'm working with;

label["Stock A", "Stock B", "Stock C", "Stock D"]

value["200", "1000", "900", "800"]

I would like to organize this data into a 2D array

sorted["Stock B, 1000","Stock C, 900", "Stock D, 800", "Stock A, 200"]

I want to sort based on the numerical value, if possible. The issue arises when I try the solution from the aforementioned question, as it only compares one value with another. I need it to go through all values stored in the array.

Last week, I stumbled upon a complicated method that sorted values like 100 and 1000 next to each other - which I initially thought was due to them not being integers, but that wasn't the case. In frustration, I deleted that code last Friday.

I'm hoping that someone out there can offer guidance to a novice coder like me. Since the values come in as strings, they'll need to be converted to integers.

The array could potentially have an unlimited number of entries, and once they're correctly sorted, I need to keep the top 10 and group the rest together with a total count - resulting in 11 entries. But sorting is the first hurdle I must overcome.

Thank you in advance for any assistance.

javascript sorting multidimensional-array

Answer 1

Answer №1

I am interested in converting this into a 2D array
sorted["Stock B, 1000","Stock C, 900", "Stock D, 800", "Stock A, 200"]

It's important to note that what you have is actually a single dimensional array of strings. To create a true 2D array, it should look like this:

sorted = [["Stock B", 1000], ["Stock C", 900], ["Stock D", 800], ["Stock A", 200]];

To sort this 2D array by the second value, you can use the following code snippet:

sorted.sort(function(a, b) {
    var avalue = a[1],
        bvalue = b[1];
    if (avalue < bvalue) {
        return -1;
    }
    if (avalue > bvalue) {
        return 1;
    }
    return 0;
});

Alternatively, you could consider using a single-dimensional array of objects for better organization:

sorted = [
    {name: "Stock B", quantity: 1000},
    {name: "Stock C", quantity: 900},
    {name: "Stock D", quantity: 800},
    {name: "Stock A", quantity: 200}
];

This array of objects can be sorted as well with the following code:

sorted.sort(function(a, b) {
    var avalue = a.quantity,
        bvalue = b.quantity;
    if (avalue < bvalue) {
        return -1;
    }
    if (avalue > bvalue) {
        return 1;
    }
    return 0;
});

Answer 2

I am interested in converting this into a 2D array
sorted["Stock B, 1000","Stock C, 900", "Stock D, 800", "Stock A, 200"]

It's important to note that what you have is actually a single dimensional array of strings. To create a true 2D array, it should look like this:

sorted = [["Stock B", 1000], ["Stock C", 900], ["Stock D", 800], ["Stock A", 200]];

To sort this 2D array by the second value, you can use the following code snippet:

sorted.sort(function(a, b) {
    var avalue = a[1],
        bvalue = b[1];
    if (avalue < bvalue) {
        return -1;
    }
    if (avalue > bvalue) {
        return 1;
    }
    return 0;
});

Alternatively, you could consider using a single-dimensional array of objects for better organization:

sorted = [
    {name: "Stock B", quantity: 1000},
    {name: "Stock C", quantity: 900},
    {name: "Stock D", quantity: 800},
    {name: "Stock A", quantity: 200}
];

This array of objects can be sorted as well with the following code:

sorted.sort(function(a, b) {
    var avalue = a.quantity,
        bvalue = b.quantity;
    if (avalue < bvalue) {
        return -1;
    }
    if (avalue > bvalue) {
        return 1;
    }
    return 0;
});

Sorting a 2D array in Javascript based on numerical values

Answer №1

Similar questions

Carousel Alert: Ensure that every child within the list is assigned a distinct "key" property

JSON syntax error: "r" is not a valid token at the beginning position

Converting data into a multidimensional array in AngularJS: A comprehensive guide

Is there a messaging app that provides real-time updates for when messages are posted?

Issues with Mega Menu functionality preventing items from being clickable and links from properly navigating

Different browsers have varying ways of handling transition end callbacks with AddEventListener()

Why Jquery's nth-child selection and conditional formatting are failing to work

Having trouble retrieving POST parameters

Exploring error management in Vue3 and Vite when deploying to production

Is it possible to modify the HTML/CSS of a child component using the parent component in Angular 2+?

I am struggling to set up angular-localstorage4

Angular 1.5 component causing Typescript compiler error due to missing semi-colon

Getting callback data from a function in the AWS SDK without using asynchronous methods

Discovering an item within an array of objects using the find method in Ajax

Fixing the hydration error in Next 13 can be challenging, especially when it occurs outside of a Suspense boundary

Encountering issues with fs.writeFile function in a freshly set up Vue project

Sharing tips for sending error objects to a socket.io callback

Every div must have at least one checkbox checked

Refreshing a view in Laravel after a successful insertion using JQuery Ajax

Presentation comparing ng-show and ng-hide efficiency