Discover the minimum and maximum values within a JavaScript array in order to assess the array's properties

Question

Discover the minimum and maximum values within a JavaScript array in order to assess the array's properties

I am working on extracting the minimum and maximum values from a multidimensional JavaScript array based on two specific fields.

The data I receive is in timeseries format from an IoT device:

timestamp, device id, value1, value2, value3, etc.

To achieve this, I need to create a function that can determine the min/max values for each device based on a particular field.

Below is a sample of the array:

[
    [
        1577912341,
        "ITEM1",
        131.98840369
    ],
    [
        1577998742,
        "ITEM2",
        127.27418424
    ],
    [
        1578085141,
        "ITEM2",
        133.67909395
    ],
    [
        1578171541,
        "ITEM1",
        134.82513897
    ]
]

I am looking to find the min/max value for each unique item in field 1 using the value in field 3. For instance, I want to identify the max value of field 3 for (ITEM1), which in this case would be "134.82513897".

The min value of field 2 (ITEM1) is 131.98840369. The max value of field 2 (ITEM1) is 134.82513897.

The min value of field 2 (ITEM2) is 127.27418424. The max value of field 2 (ITEM2) is 133.67909395.

javascript arrays

Answer 1

Answer №1

Here is a code snippet that could help you kickstart your project.

const data = [
    [
        1577912341,
        "ITEM1",
        131.98840369
    ],
    [
        1577998742,
        "ITEM2",
        127.27418424
    ],
    [
        1578085141,
        "ITEM2",
        133.67909395
    ],
    [
        1578171541,
        "ITEM1",
        134.82513897
    ]
];
const items = [...new Set(data.map(d => d[1]))];
console.log(items);

const results = items.map(item => {
  const subset = data.filter(d => d[1] === item).map(d => d[2]);
  return {
    item: item,
    min: Math.min(...subset),
    max: Math.max(...subset)
  };
});
console.log(results);

Answer 2

Here is a code snippet that could help you kickstart your project.

const data = [
    [
        1577912341,
        "ITEM1",
        131.98840369
    ],
    [
        1577998742,
        "ITEM2",
        127.27418424
    ],
    [
        1578085141,
        "ITEM2",
        133.67909395
    ],
    [
        1578171541,
        "ITEM1",
        134.82513897
    ]
];
const items = [...new Set(data.map(d => d[1]))];
console.log(items);

const results = items.map(item => {
  const subset = data.filter(d => d[1] === item).map(d => d[2]);
  return {
    item: item,
    min: Math.min(...subset),
    max: Math.max(...subset)
  };
});
console.log(results);

Discover the minimum and maximum values within a JavaScript array in order to assess the array's properties

Answer №1

Similar questions

In MongoDB and Node.js, encountered error: 'Unable to access property 'collection' as it is undefined'

Automated deletion of text input in v-textarea after a specified duration

Encountering a Zone.js error when trying to load an Angular 7 app using ng serve, preventing the application from loading

Modifying the anchor link in a pop-up window according to the clicked link using JQuery

Modify the ngb-timepicker formatting to output a string instead of an object

What methods can I utilize to showcase the JSON data on my webpage efficiently?

I encountered an issue when trying to include the dotenv file, receiving the following error message: [TypeError: Network request failed]

Animate the movement of a div

Customize chart.js for your specific region

Package.json file is not included in Typescript

CrossBrowser - Obtain CSS color information

Use Javascript to display an image based on the date, otherwise hide the div

Storing three values in a Java array

AngularJS - Issue with Checklist-Model not accurately reflecting changes in the model when checkboxes are toggled

Error: The array contains an undefined image object

Tips on saving php variable content in HTML "id"

Failing to transfer a string from fixed memory to allocated memory

Issue with narrowing TypeScript arrays often encountered

Transferring JavaScript objects from child process to parent through streaming

TS1057: It is required that an async function or method has a return type that can be awaited