Filtering JSON data with JavaScript

Question

Filtering JSON data with JavaScript

Looking to group data in AngularJS using UnderscoreJS. Here is the JSON data:

 data = [   
        {
          "Building*": "Building A",
          "Wing*": "Wing C",
          "Floor*": "Floor 3",
          "Room Name*": "Room 3",
          "Room Type*": "AC",
          "Location*": "Location 1",
          "Device ID*": 27,
          "Category*": "Soap Hygene",
          "Dispenser Name*": "Dispenser 34",
          "Type*": "Manual",
          "Cartridge Type*": "Type 1",
          "Date of installation": "2016-04-11T06:06:22 -06:-30",
          "Contact Last Name": "Maynard",
          "Email Address": "<a href="/cdn-cgi/l/email-protection" class="__cf_email__" data-cfemail="47332f282a263469252834242f223507202a262e2b6924282a">[email protected]</a>",
          "Mobile Number with country code": "+1 (949) 590-3465",
          "Description": "Description of device",
          "Model": 37
        },
        {
          "Building*": "Building B",
          "Wing*": "Wing B",
          "Floor*": "Floor 3",
          "Room Name*": "Room 1",
          "Room Type*": "AC",
          "Location*": "Location 3",
          "Device ID*": 26,
          "Category*": "Soap Hygene",
          "Dispenser Name*": "Dispenser 33",
          "Type*": "Manual",
          "Cartridge Type*": "Type 2",
          "Date of installation": "2015-07-24T12:42:24 -06:-30",
          "Contact Last Name": "Holland",
          "Email Address": "<a href="/cdn-cgi/l/email-protection" class="__cf_email__" data-cfemail="42362a2d2f23316c202d31221a27300225">[email protected]</a>",
          "Mobile Number with country code": "+1 (947) 491-2353",
          "Description": "Description of device",
          "Model": 32
        }         
      ]

Desired format:

  updateData = [{ 
    building: 'Building A' , 
    buildingData:[{
        wing: "Wing A",
         wingData: [{
          floor:'Floor 2',
          floorData:[{
            room:'Room 3',
            roomData:[]
            }]
          }]
        }]
  }];

Tried implementing it on jsFiddle, but it didn't work. Seeking assistance. Thank you.

javascript json

Answer 1

Answer №1

It seems like you are looking to group the data in a nested order as follows:

Building -> Wing -> Floor -> Room

To achieve this, you can utilize recursion or loop through the data by providing an array of the desired nesting order. Here is a sample code snippet for reference:

const nestedOrder = ['Building*', 'Wing*', 'Floor*', 'Room Name*']

function groupFilter (rawData, attrList) {
  if (attrList.length == 0) return rawData

  var currentAttr = _(attrList).first()
  return _(rawData)
    .chain()
    .groupBy(currentAttr)
    .map((list, attrName) => Object({
      [currentAttr]: attrName,
      [`${currentAttr}Data`]: groupFilter(list, _(attrList).rest())
    }))
    .value()
}

console.log(groupFilter(data, nestedOrder))

This approach will condense the raw data to the innermost attribute specified, which in this case is 'Room Name*'. You can then apply your custom filter logic to determine the contents of RoomData.

If performance is not a major concern, this method should work effectively for your needs.

I hope this solution is helpful and meets your requirements.

Answer 2

It seems like you are looking to group the data in a nested order as follows:

Building -> Wing -> Floor -> Room

To achieve this, you can utilize recursion or loop through the data by providing an array of the desired nesting order. Here is a sample code snippet for reference:

const nestedOrder = ['Building*', 'Wing*', 'Floor*', 'Room Name*']

function groupFilter (rawData, attrList) {
  if (attrList.length == 0) return rawData

  var currentAttr = _(attrList).first()
  return _(rawData)
    .chain()
    .groupBy(currentAttr)
    .map((list, attrName) => Object({
      [currentAttr]: attrName,
      [`${currentAttr}Data`]: groupFilter(list, _(attrList).rest())
    }))
    .value()
}

console.log(groupFilter(data, nestedOrder))

This approach will condense the raw data to the innermost attribute specified, which in this case is 'Room Name*'. You can then apply your custom filter logic to determine the contents of RoomData.

If performance is not a major concern, this method should work effectively for your needs.

I hope this solution is helpful and meets your requirements.

Filtering JSON data with JavaScript

Answer №1

Similar questions

Making changes to a JSON file using JavaScript

Looking to add some random circle markers to your SVG map?

Creating "search result pages" with HTML, PHP, Javascript, and MySQL

Reconfigure a portion of a string using Vue's dynamic replacement feature

Choose a specific element using jQuery based on a class that is shared by several elements

React/NextJS: Firebase Realtime Database displaying the message "Error: Client is offline"

Utilize datetime values in chartjs ajax for data visualization

Is it possible to trigger an AJAX validation only after the jQuery validation plugin has successfully validated the input?

Synchronize information between two drop-down lists

Using v-for to show the values of an object in Vuetify

Tips for updating a boolean value in a JSON file with a button in Angular and TypeScript

Unable to retrieve scope data in controller function

Guide to activating animation on one element when hovering over another element?

transferring information from PHP to JavaScript through the use of JSON encoding

Get your hands on the base64 image by triggering the save as popup and downloading

React App stalled due to continuously running function

Accessing the statusText of a 403 response in Axios (React, Express, Node.js)

The $route object in Vue is not configured

Determine total and showcase it as the range slider is adjusted

The absence of PHP GET variable being set