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

Combining four numbers to calculate a total with the click of a button

Guide to executing a batch file using electron

Is it necessary to integrate the Facebook JavaScript SDK even if I do not plan on utilizing its features?

Modify the height of an element in real-time using jQuery

I'm having issues with my flipclock moving too quickly and skipping over certain numbers. Any suggestions on how to resolve this issue?

How can I pass arguments from a Python command line program (compiled to an EXE) to a JavaScript file?

Error: An anomaly token was encountered while deploying a Laravel/Vue project using the pipeline yml in Yarn Run

The transition effect is not activated when using the MUI Drawer with react-router-dom

What's the reason for the mousewheel functioning in Chrome but not in Firefox?

Implementing change event to activate select dropdown with jQuery

Expanding list - Using individual toggles to expand and collapse multiple list items

Designing a unique shape geometry using THREE JS

Error encountered with Node.js clustering

JavaScript encountering issues when parsing a string that was serialized using Gson in Java

Choosing an item in an AngularJS select directive from an external origin

Which regular expression should be used to validate names with international characters?

Using NextJs <Script> is only effective after a page has been reloaded

Troublesome CSS Zoom causing issues with jQuery scrollTop

What is the best way to transmit two variables in a single message with Socket.io?

Navigating sub-domains swiftly