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

"Transforming the Website Background with a Splash of Color

Is extracting the title of an image from Flickr?

Embed the aspx file within the background-image attribute similar to how an image source is

Attempting to generate a cost estimator, however, no results are showing up upon clicking the calculate button

The process of merging these two functions involves ensuring that one function does not start until the other has successfully completed its task

Pass Form ID To Function In A Dynamic Way

Error: global not declared in the context of web3

Is it recommended to exclude the NGXS NgxsLoggerPluginModule for production deployments?

Utilizing Visual Studio: Implementing jsmin in post-build actions

Is it possible to create a personalized serialize form when sending an AJAX POST request

Connection lost from JS client in Twilio's Programmable Chat

I have developed a function that adds up price values, but for some reason it is always lagging one step behind

Learn how to utilize JavaScript produced by the `webpack output library` in a `nodejs` application

Utilizing the change function in conjunction with that

Distance Calculator for Geolocation WatchPosition

Smoothly transition between the new and existing child elements in a React component with a

Refresh a TextBox using an Ajax Response

Angular: monitoring changes in HTML content within a Component or Directive

Audio waves visualization - silence is golden

Value of type 'string' cannot be assigned to type '{ model: { nodes: []; links: []; }; }'