Ordering and categorizing a JSON dataset

Question

Ordering and categorizing a JSON dataset

data = [
        {
            name: "Alpha",
            set: 5,
            weight: 185
        },      
        {
            name: "Alpha",
            set: 6,
            weight: 350
        },        
        {
            name: "Bravo",
            set: 2,
            weight: 185
        },        
        {
            name: "Charlie",
            set: 3,
            weight: 185
        },         
        {
            name: "Echo",
            set: 4,
            weight: 185
        }
]

I have a list of data objects which contain various attributes including the name and weight. My task is to filter this data based on the highest weight for each unique name. For instance, from the two objects with "Alpha", I need to select only the one with the greater weight (the second object). The challenge lies in filtering and reconstructing this data array while retaining the original values.

To facilitate visualizing all the data in a table, I must maintain the initial data array unchanged. However, I also need to create an additional array containing just the objects with the highest weight value for each specified name.

javascript angularjs arrays json

Answer 1

Answer №1

Utilizing lodash version 4 or higher is recommended for this particular task.

var sortedData = _.orderBy(entries, ['mass'], ['desc']);

By using the code snippet above, you can easily sort the data based on mass. After sorting, execute the following line of code: _.uniqBy(sortedData, 'label')

This will result in the final array containing unique elements.

var entries = [
        {
            label: "Alpha",
            group: 5,
            mass: 185
        },      
        {
            label: "Alpha",
            group: 5,
            mass: 350
        },        
        {
            label: "Bravo",
            group: 5,
            mass: 185
        },        
        {
            label: "Charlie",
            group: 5,
            mass: 185
        },         
        {
            label: "Delta",
            group: 5,
            mass: 185
        }
]

var sortedData = _.orderBy(entries, ['mass'], ['desc'])

_.uniqBy(sortedData, 'label')

Answer 2

Utilizing lodash version 4 or higher is recommended for this particular task.

var sortedData = _.orderBy(entries, ['mass'], ['desc']);

By using the code snippet above, you can easily sort the data based on mass. After sorting, execute the following line of code: _.uniqBy(sortedData, 'label')

This will result in the final array containing unique elements.

var entries = [
        {
            label: "Alpha",
            group: 5,
            mass: 185
        },      
        {
            label: "Alpha",
            group: 5,
            mass: 350
        },        
        {
            label: "Bravo",
            group: 5,
            mass: 185
        },        
        {
            label: "Charlie",
            group: 5,
            mass: 185
        },         
        {
            label: "Delta",
            group: 5,
            mass: 185
        }
]

var sortedData = _.orderBy(entries, ['mass'], ['desc'])

_.uniqBy(sortedData, 'label')

Answer 3

Answer №2

My suggestion is to adopt a functional programming strategy:

let filteredRecords = records
    .filter(function(record) { 
        return records.find(function(innerRecord) {
            return innerRecord.name === record.name && innerRecord.weight > record.weight; }) === undefined;
     });

In this scenario, you will only keep records where there is no other record with the same name but higher weight. The resulting array of records is stored in filteredRecords, while keeping your original array untouched.

Answer 4

My suggestion is to adopt a functional programming strategy:

let filteredRecords = records
    .filter(function(record) { 
        return records.find(function(innerRecord) {
            return innerRecord.name === record.name && innerRecord.weight > record.weight; }) === undefined;
     });

In this scenario, you will only keep records where there is no other record with the same name but higher weight. The resulting array of records is stored in filteredRecords, while keeping your original array untouched.

Answer 5

Answer №3

If you want to streamline your code, consider incorporating lodash instead of creating your own functions from scratch. For instance, if you need to sort an array by name, simply use the following snippet:

var data = [
    { name: "Alpha", set: 5, weight: 185 },
    { name: "Bravo", set: 5, weight: 350 },
    { name: "Charlie", set: 5, weight: 185 },
    { name: "Delta", set: 5, weight: 185 }
];

var sortedData = _.sortBy(data, ['name']);

Another scenario would be filtering based on both name and weight:

var filteredData = _.filter(data, {'name': 'Alpha', 'weight': 350});

Answer 6

If you want to streamline your code, consider incorporating lodash instead of creating your own functions from scratch. For instance, if you need to sort an array by name, simply use the following snippet:

var data = [
    { name: "Alpha", set: 5, weight: 185 },
    { name: "Bravo", set: 5, weight: 350 },
    { name: "Charlie", set: 5, weight: 185 },
    { name: "Delta", set: 5, weight: 185 }
];

var sortedData = _.sortBy(data, ['name']);

Another scenario would be filtering based on both name and weight:

var filteredData = _.filter(data, {'name': 'Alpha', 'weight': 350});

Answer 7

Answer №4

This code snippet demonstrates a technique to sort items first by name and then by weight, filtering out duplicates based on the first occurrence of each item.

var records = [{
    name: "Alpha",
    set: 5,
    weight: 185
  },
  {
    name: "Alpha",
    set: 5,
    weight: 350
  },
  {
    name: "Bravo",
    set: 5,
    weight: 185
  },
  {
    name: "Charlie",
    set: 5,
    weight: 185
  },
  {
    name: "Charlie",
    set: 5,
    weight: 200
  },
  {
    name: "Delta",
    set: 5,
    weight: 185
  }
]

console.log(
  records.sort((a, b) => {
    if (a.name === b.name) {
      return a.weight >= b.weight ? -1 : 1
    }
    return a.name > b.name ? 1 : -1
  })
  .filter((rec, i, arr) => {
    if (i === 0) return true
    return rec.name !== arr[i - 1].name
  })
)

Answer 8

This code snippet demonstrates a technique to sort items first by name and then by weight, filtering out duplicates based on the first occurrence of each item.

var records = [{
    name: "Alpha",
    set: 5,
    weight: 185
  },
  {
    name: "Alpha",
    set: 5,
    weight: 350
  },
  {
    name: "Bravo",
    set: 5,
    weight: 185
  },
  {
    name: "Charlie",
    set: 5,
    weight: 185
  },
  {
    name: "Charlie",
    set: 5,
    weight: 200
  },
  {
    name: "Delta",
    set: 5,
    weight: 185
  }
]

console.log(
  records.sort((a, b) => {
    if (a.name === b.name) {
      return a.weight >= b.weight ? -1 : 1
    }
    return a.name > b.name ? 1 : -1
  })
  .filter((rec, i, arr) => {
    if (i === 0) return true
    return rec.name !== arr[i - 1].name
  })
)

Ordering and categorizing a JSON dataset

Answer №1

Answer №2

Answer №3

Answer №4

Similar questions

Function not activating with ng-keypress event

Should I assign functions to services and app-wide variables to factories in relation to angular?

Mastering the comprehension of JSON objects with jQuery by transferring data via AJAX requests

Leveraging Python for JSON Operations

Data not being properly set in the form

What specific circumstances make Avro a better choice than Json?

Managing information from various selection fields

Creating a direct connection between a parent node and all of its children in OrgChartjs

Utilizing jQuery to Adjust Tab Transparency

Loading complex models with Three.js

Dealing with multiple select elements using jQuery when an option is chosen from each one

Notify the parent component about the connectivity status of the children

What is the best way to assign the value of an HTTP GET request to a subarray in Angular 8

What is the process for creating a button that can sort an array and count its elements?

Can someone help me identify the issue with my JavaScript code?

Sending an array to unmanaged code and receiving it back without the need for duplication

The removeEventListener method in JavaScript fails to function properly

Is there a way to create an HTML select element where each option has a unique background color, and will display properly

Assistance with utilizing Google Sheets scripts for retrieving formulas is needed

Limiting the character count in a textarea can be achieved by implementing the 'jQuery InlineEdit' feature