sophisticated method for sorting through data within an array of arrays

Question

sophisticated method for sorting through data within an array of arrays

How can data be filtered from an array of arrays?

Below is an example to help explain the process.

To filter the data, use startnumber and endnumber in the query.

const data =  [
{
  "name": "x",
  "points": [
    [100, 50, 1],        //[number, value, bit]       
    [150, 51, 0],
    [170, 52, 1],
    [200, 53, 0]
  ]
},
{
  "name": "y",
  "points": [
    [60, 50, 1],
    [100, 5, 1],
    [150, 6, 0],
    [170, 7, 1],
    [200, 53, 1]
  ]
},
{
  "name": "z",
  "points": [
    [300, 50, 1],
    [350, 51, 0],
    [370, 52, 1],
    [400, 53, 1]
  ]
}
]

// To find records with names x & y and numbers between 100 to 170

const names = ["x", "y"];
const startnumber = 100;
const endnumber = 170;

const finalResult= [];
for(const n of names){
  console.log('name', n);
  console.log('startnumber', startnumber)
  console.log('endnuumber', endnumber)
  const result = data.find(x=>x.name === n)
  
  // How can startnumber and endnumber be applied in the query above? Or is there another elegant solution?

  if(result){
    finalResult.push('result', result);
  }
}

if(finalResult.length){
  console.log(finalResult);
}

The expected result should be

[
  {
    "name": "x",
    "points": [
      [100, 50, 1],
      [150, 51, 0],
      [170, 52, 1],
    ]
  },
  {
    "name": "y",
    "points": [
      [100, 5, 1],
      [150, 6, 0],
      [170, 7, 1],
    ]
  }
]

javascript filter

Answer 1

Answer №1

const filteredResults = data.filter(elem => !!names.find(name => name == elem.name))

Explanation:

data.filter is used to iterate through each element in the array data.
names.find is applied to each element in the array names to find a matching value.
The double negation (!!) is utilized since find returns an element, converting it into a boolean.
The resulting array contains elements from data with names that match the values in names.

const data = [
{
  "name": "x",
  "points": [
    [100, 50, 1],
    [150, 51, 0],
    [170, 52, 1],
    [200, 53, 0]
  ]
},
{
  "name": "y",
  "points": [
    [60, 50, 1],
    [100, 5, 1],
    [150, 6, 0],
    [170, 7, 1],
    [200, 53, 1]
  ]
},
{
  "name": "y",
  "points": [
    [60, 50, 1],
    [200, 53, 1]
  ]
},
{
  "name": "z",
  "points": [
    [300, 50, 1],
    [350, 51, 0],
    [370, 52, 1],
    [400, 53, 1]
  ]
}
]

// Want to filter records with names 'x' and 'y', where number is between 100 and 170.

const names = ["x", "y"];
const startNumber = 100;
const endNumber = 170;

const filteredResults = data
  .filter(elem => !!names.find(name => name == elem.name))
  .map(elem => {
    return {
      name: elem.name,
      points: elem.points.filter(point => point[0] >= startNumber && point[0] <= endNumber)
    }
  })
  .filter(elem => elem.points.length > 0)

console.log(filteredResults)

Answer 2

const filteredResults = data.filter(elem => !!names.find(name => name == elem.name))

Explanation:

data.filter is used to iterate through each element in the array data.
names.find is applied to each element in the array names to find a matching value.
The double negation (!!) is utilized since find returns an element, converting it into a boolean.
The resulting array contains elements from data with names that match the values in names.

const data = [
{
  "name": "x",
  "points": [
    [100, 50, 1],
    [150, 51, 0],
    [170, 52, 1],
    [200, 53, 0]
  ]
},
{
  "name": "y",
  "points": [
    [60, 50, 1],
    [100, 5, 1],
    [150, 6, 0],
    [170, 7, 1],
    [200, 53, 1]
  ]
},
{
  "name": "y",
  "points": [
    [60, 50, 1],
    [200, 53, 1]
  ]
},
{
  "name": "z",
  "points": [
    [300, 50, 1],
    [350, 51, 0],
    [370, 52, 1],
    [400, 53, 1]
  ]
}
]

// Want to filter records with names 'x' and 'y', where number is between 100 and 170.

const names = ["x", "y"];
const startNumber = 100;
const endNumber = 170;

const filteredResults = data
  .filter(elem => !!names.find(name => name == elem.name))
  .map(elem => {
    return {
      name: elem.name,
      points: elem.points.filter(point => point[0] >= startNumber && point[0] <= endNumber)
    }
  })
  .filter(elem => elem.points.length > 0)

console.log(filteredResults)

Answer 3

Answer №2

This method offers a sophisticated approach:

const result = data.reduce((accumulator, current) => {
  const { title, values } = current
  const filteredValues = points.filter(value => value[0] >= startValue && value[0] <= endValue)
  return titles.includes(title) && filteredValues.length > 0 ? accumulator.concat({ title, values: filteredValues }) : accumulator
}, [])

Answer 4

This method offers a sophisticated approach:

const result = data.reduce((accumulator, current) => {
  const { title, values } = current
  const filteredValues = points.filter(value => value[0] >= startValue && value[0] <= endValue)
  return titles.includes(title) && filteredValues.length > 0 ? accumulator.concat({ title, values: filteredValues }) : accumulator
}, [])

Answer 5

Answer №3

When analyzing the task and the two provided data structures, it becomes apparent that a dual-layered filtering process is required for each data element.

The first step involves identifying the data item based on its name (obtained from the additional names array).
The second step entails filtering the points array of each data item to determine if the first element in the points array falls within a specified number range (defined by the supplementary startnumber and endnumber values).

Consequently, an effective strategy was to utilize the reduce function on the given data array with a reducer function that handles these two tasks for each data item.

The initial value for the reducer function serves as a configuration and collection object that includes...

A name lookup mechanism (implemented as a Map instance) for the specific data items to be processed.
The startnumber and endnumber range values designated as lowerNumber and upperNumber, respectively.
An array named result where only those data items meeting all criteria are stored.

function collectItemsByNameWhichHavePointsInNumberRange(collector, item) {
  const { nameLookup, lowerNumber, upperNumber, result } = collector;
  let { name, points } = item;

  // ... code snippet to gather items by name ...
  if (nameLookup.has(name)) {
    points = points
      .filter(([number]) =>
        (number >= lowerNumber) && (number <= upperNumber)
      );

    // ... filter out items with points falling within the defined number range ...

    if (points.length >= 1) {
      result
        .push({
          ...item,
          points,
        });
    }
  }
  return collector;
}

const data = [{
  name: "x",
  points: [
    [100, 50, 1],
    [150, 51, 0],
    [170, 52, 1],
    [200, 53, 0],
  ],
}, {
  name: "y",
  points: [
    [60, 50, 1],
    [100, 5, 1],
    [150, 6, 0],
    [170, 7, 1],
    [200, 53, 1],
  ],
}, {
  name: "z",
  points: [
    [300, 50, 1],
    [350, 51, 0],
    [370, 52, 1],
    [400, 53, 1],
  ],
}];

const names = ["x", "y"];
const startnumber = 100;
const endnumber = 170;

const { result } = data
  .reduce(collectItemsByNameWhichHavePointsInNumberRange, {
    nameLookup: new Map(names.map(value => [value, value])),
    lowerNumber: startnumber,
    upperNumber: endnumber,
    result: [],
  });

console.log({ result });

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

Answer 6

When analyzing the task and the two provided data structures, it becomes apparent that a dual-layered filtering process is required for each data element.

The first step involves identifying the data item based on its name (obtained from the additional names array).
The second step entails filtering the points array of each data item to determine if the first element in the points array falls within a specified number range (defined by the supplementary startnumber and endnumber values).

Consequently, an effective strategy was to utilize the reduce function on the given data array with a reducer function that handles these two tasks for each data item.

The initial value for the reducer function serves as a configuration and collection object that includes...

A name lookup mechanism (implemented as a Map instance) for the specific data items to be processed.
The startnumber and endnumber range values designated as lowerNumber and upperNumber, respectively.
An array named result where only those data items meeting all criteria are stored.

function collectItemsByNameWhichHavePointsInNumberRange(collector, item) {
  const { nameLookup, lowerNumber, upperNumber, result } = collector;
  let { name, points } = item;

  // ... code snippet to gather items by name ...
  if (nameLookup.has(name)) {
    points = points
      .filter(([number]) =>
        (number >= lowerNumber) && (number <= upperNumber)
      );

    // ... filter out items with points falling within the defined number range ...

    if (points.length >= 1) {
      result
        .push({
          ...item,
          points,
        });
    }
  }
  return collector;
}

const data = [{
  name: "x",
  points: [
    [100, 50, 1],
    [150, 51, 0],
    [170, 52, 1],
    [200, 53, 0],
  ],
}, {
  name: "y",
  points: [
    [60, 50, 1],
    [100, 5, 1],
    [150, 6, 0],
    [170, 7, 1],
    [200, 53, 1],
  ],
}, {
  name: "z",
  points: [
    [300, 50, 1],
    [350, 51, 0],
    [370, 52, 1],
    [400, 53, 1],
  ],
}];

const names = ["x", "y"];
const startnumber = 100;
const endnumber = 170;

const { result } = data
  .reduce(collectItemsByNameWhichHavePointsInNumberRange, {
    nameLookup: new Map(names.map(value => [value, value])),
    lowerNumber: startnumber,
    upperNumber: endnumber,
    result: [],
  });

console.log({ result });

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

sophisticated method for sorting through data within an array of arrays

The expected result should be

Answer №1

Answer №2

Answer №3

Similar questions

Retrieve all entries and merge a field with aggregated information in Mongoose (MongoDB)

Enhance the performance of node.js when processing data from a massive file

Instead of using a v-if condition, add a condition directly in the Vue attribute

How to trigger a force reload on a VueJS route with a different query parameter?

What is the best way to connect click events with ExtJS template elements?

Choose or deselect images from a selection

Differences seen in display when using Internet Explorer's prependTo feature

Tips for preserving component state during page rerenders or changes

Utilize Mapbox-GL.JS to animate several points along designated routes

Implementing a function or template from one component into another within a Vue.js application, despite lacking a direct connection between the two components

Passing data from a child component to a parent component in Vue 3: How

The checkbox will be automatically checked whenever there is any modification in the textbox

Encountering an illegal invocation error in jQuery

I am interested in extracting information from a public Facebook post

Javascript: regular expression to validate alphanumeric and special characters

How can I attach an existing event to a dynamically loaded element using AJAX?

Developing Modules in NodeJS using Constructors or Object Literals

Is there a way to live filter results using Vue?

Encountering Err_Connection_Refused while working with MVC WebAPI 2 and AngularJS

Using TextField with nested Object for onChange Event