Reorganizing JSON Information

Question

Reorganizing JSON Information

Currently, I am dealing with a JSON file that contains multiple sets of data structured like this:

{"name": ["Adelphi University"], "supp": ["Yes: E, WS"], "ed": ["\u00a0"], "online": ["$40"], "ea": ["12/1"], "mid": ["No"], "rd": ["Rolling"], "recs": ["Yes: CR"], "mail": ["$40"], "schoolr": ["Yes"]}

The intention is for this line to represent a university (hence the name) with other variables like "supp", "online", etc. as attributes of that school. My goal is to restructure this data so that the "name" variable defines the data and the other variables become children of the "name" parent. The desired format of my data should be:

{
  "schools": {
    "Adelphi University": {
      "supp": "Yes: E, WS",
      "ed": "\u00a0",
      "online": "$40",
      "ea": "12/1", 
      "mid": "No", 
      "rd": "Rolling", 
      "recs": "Yes: CR", 
      "mail": "$40", 
      "schoolr": "Yes",    
    },
    "Dartmouth College": { ... },
    "Harvard University": { ... }
  }
}

I am seeking guidance on how to achieve this restructuring. Can someone assist me with this?

javascript json parsing firebase firebase-realtime-database

Answer 1

Answer №1

To streamline the process, you can loop through the keys and check for the presence of the 'name' key in order to construct an object with the name and assign it to a temporary object. Otherwise, assign the values directly.

var array = [{ "name": ["Adelphi University"], "supp": ["Yes: E, WS"], "ed": ["\u00a0"], "online": ["$40"], "ea": ["12/1"], "mid": ["No"], "rd": ["Rolling"], "recs": ["Yes: CR"], "mail": ["$40"], "schoolr": ["Yes"] }, { "name": ["Dartmouth College"], "supp": ["Yes: E, WS"], "ed": ["\u00a0"], "online": ["$40"], "ea": ["12/1"], "mid": ["No"], "rd": ["Rolling"], "recs": ["Yes: CR"], "mail": ["$40"], "schoolr": ["Yes"] }],
    schools = {},
    result = { schools: schools };

array.forEach(function (a) {
    var temp = {};
    Object.keys(a).forEach(function (k) {
        if (k === 'name') {
            schools[a[k][0]] = temp;
            return;
        }
        temp[k] = a[k][0];
    });
});

console.log(JSON.stringify(result));
console.log(result);

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

Answer 2

To streamline the process, you can loop through the keys and check for the presence of the 'name' key in order to construct an object with the name and assign it to a temporary object. Otherwise, assign the values directly.

var array = [{ "name": ["Adelphi University"], "supp": ["Yes: E, WS"], "ed": ["\u00a0"], "online": ["$40"], "ea": ["12/1"], "mid": ["No"], "rd": ["Rolling"], "recs": ["Yes: CR"], "mail": ["$40"], "schoolr": ["Yes"] }, { "name": ["Dartmouth College"], "supp": ["Yes: E, WS"], "ed": ["\u00a0"], "online": ["$40"], "ea": ["12/1"], "mid": ["No"], "rd": ["Rolling"], "recs": ["Yes: CR"], "mail": ["$40"], "schoolr": ["Yes"] }],
    schools = {},
    result = { schools: schools };

array.forEach(function (a) {
    var temp = {};
    Object.keys(a).forEach(function (k) {
        if (k === 'name') {
            schools[a[k][0]] = temp;
            return;
        }
        temp[k] = a[k][0];
    });
});

console.log(JSON.stringify(result));
console.log(result);

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

Answer 3

Answer №2

If the object displayed at the beginning is just one of many similar items within an array, you can achieve the desired outcome by implementing the following solution:

var schoolArray = [/** your current json structure **/];
var schools = {};

schoolArray.forEach(function(item) {
  // Check for existence for safety
  var name = item.name[0];
  schools[name] = {};
  delete item.name;
  Object.keys(item).forEach(function(key) {
    // Ensure existence on the right side is also checked
    schools[name][key] = item[key][0];
  });
});

console.log({ schools : schools });  // The desired structure will be outputted

Answer 4

If the object displayed at the beginning is just one of many similar items within an array, you can achieve the desired outcome by implementing the following solution:

var schoolArray = [/** your current json structure **/];
var schools = {};

schoolArray.forEach(function(item) {
  // Check for existence for safety
  var name = item.name[0];
  schools[name] = {};
  delete item.name;
  Object.keys(item).forEach(function(key) {
    // Ensure existence on the right side is also checked
    schools[name][key] = item[key][0];
  });
});

console.log({ schools : schools });  // The desired structure will be outputted

Reorganizing JSON Information

Answer №1

Answer №2

Similar questions

The styling of MUI components adapts when the Navigate component in React Router is initialized

Unveiling the information retrieved from an AJAX request during page load

React.js Filter Component

Website experiencing issues with moderating Facebook comments

I'm consistently encountering issues with my ajax call, does anyone have any suggestions on how to fix

Exploring the capabilities of the Javascript Fetch API by making requests for binary Float32Array data with multiple

Turning an array into JSON using PHP

What is the best way to sort my chat groups based on the most recent update when working with denormalized data in Firebase?

Determine the moment when jQuery's load() function completes the loading of several images

Locate a particular word in every element within an array range (angularjs)

I encountered an issue while iterating through Object HTMLDivElement and applying ChileNode style z-index, resulting in an undefined output in both Firefox and Chrome browsers

utilize ng-include in angularjs to include a page

When an AJAX request is made, it can either return an array or a single object, potentially leading to

Could it be possible that my consecutive POST and GET axios requests are gradually slowing down?

Tips for eliminating default classes from Mui Typography styling

Ways to utilize a single HTML page for various URLs while changing one variable value based on the queried URL

Unleash the power of Azure Data Factory for transforming JSON documents into SQL Database through unpivoting

Managing state in a live chat application

Node functions continue to run smoothly without affecting the loop

Guide on uploading a file to Pinata directly from a React application