Unlocking JSON data with identical keys using JavaScriptLearn how to access JSON data with

Question

Unlocking JSON data with identical keys using JavaScriptLearn how to access JSON data with

I need help converting my JSON training data that includes classes and sentences into a different format.

[
  { class: 'Reservation', sentence: 'make reservation' },
    { class: 'Reservation', sentence: 'do reservation' },
    { class: 'Greetings', sentence: 'Hello' },
    { class: 'Greetings', sentence: 'Good Morning' }
]

How can I transform it into the following format?

[
  { class: 'Reservation', sentence: ['make reservation', 'do reservation'] },
  { class: 'Greetings', sentence: ['Hello', 'Good Morning'] }
]

javascript json

Answer 1

Answer №1

To create a new array, iterate through each object and add them based on certain conditions. Before adding an object to the new array, validate if it already exists in order to avoid duplicates. Instead of adding a duplicate, append the current sentence to the existing object.

Follow these steps:

Initialize an empty array
Iterate over the array containing objects (the original object array)
Verify if the object with a specific class value already exists
If not found, add a new object to the new array with the class value and a sentence array that includes the current sentence as the first item (refer to the provided code snippet). If found, simply push the current sentence to the existing object's sentence array.

var data = [
  { class: 'Reservation', sentence: 'make reservation' },
  { class: 'Reservation', sentence: 'do reservation' },
  { class: 'Greetings', sentence: 'Hello' },
  { class: 'Greetings', sentence: 'Good Morning' }
]

var dataFormatted = [];

for(var i = 0; i < data.length; i++){
    //document.write(JSON.stringify(data[i]));
  const existingClass = dataFormatted.find(d => d.class == data[i].class);
  if(existingClass){
    existingClass.sentence.push(data[i].sentence)
  } else{
    dataFormatted.push({
        class: data[i].class,
      sentence: [data[i].sentence]
    });
  }
}

document.write(JSON.stringify(dataFormatted))

I hope this explanation is clear.

Answer 2

To create a new array, iterate through each object and add them based on certain conditions. Before adding an object to the new array, validate if it already exists in order to avoid duplicates. Instead of adding a duplicate, append the current sentence to the existing object.

Follow these steps:

Initialize an empty array
Iterate over the array containing objects (the original object array)
Verify if the object with a specific class value already exists
If not found, add a new object to the new array with the class value and a sentence array that includes the current sentence as the first item (refer to the provided code snippet). If found, simply push the current sentence to the existing object's sentence array.

var data = [
  { class: 'Reservation', sentence: 'make reservation' },
  { class: 'Reservation', sentence: 'do reservation' },
  { class: 'Greetings', sentence: 'Hello' },
  { class: 'Greetings', sentence: 'Good Morning' }
]

var dataFormatted = [];

for(var i = 0; i < data.length; i++){
    //document.write(JSON.stringify(data[i]));
  const existingClass = dataFormatted.find(d => d.class == data[i].class);
  if(existingClass){
    existingClass.sentence.push(data[i].sentence)
  } else{
    dataFormatted.push({
        class: data[i].class,
      sentence: [data[i].sentence]
    });
  }
}

document.write(JSON.stringify(dataFormatted))

I hope this explanation is clear.

Answer 3

Answer №2

If you need to manipulate a json array, you can iterate through it and create a new array by either adding elements to an existing list or creating a new one if no match is found:

const jsonData = [
  { category: 'Fruit', item: 'apple' },
  { category: 'Fruit', item: 'orange' },
  { category: 'Vegetable', item: 'carrot' },
  { category: 'Vegetable', item: 'spinach' }
]

const newData = []
jsonData.forEach((element) => {
  let matchedCategory = newData.find(e => e.category === element.category);
  if (matchedCategory) {
    matchedCategory.item.push(element.item);
  } else {
    newData.push({
      category: element.category,
      item: [element.item]
    });
  }
})

console.log(newData)

Answer 4

If you need to manipulate a json array, you can iterate through it and create a new array by either adding elements to an existing list or creating a new one if no match is found:

const jsonData = [
  { category: 'Fruit', item: 'apple' },
  { category: 'Fruit', item: 'orange' },
  { category: 'Vegetable', item: 'carrot' },
  { category: 'Vegetable', item: 'spinach' }
]

const newData = []
jsonData.forEach((element) => {
  let matchedCategory = newData.find(e => e.category === element.category);
  if (matchedCategory) {
    matchedCategory.item.push(element.item);
  } else {
    newData.push({
      category: element.category,
      item: [element.item]
    });
  }
})

console.log(newData)

Answer 5

Answer №3

Maybe you're looking to combine data in this way:

function combineData(data){
  const result = [];
  for(let i=0, obj, prev, len=data.length; i<len; i++){
    obj = data[i]; 
    prev = result.find(d=>d.class === obj.class);
    if(prev){
      prev.sentence.push(obj.sentence);
    }
    else{
      result.push({class:obj.class, sentence:[obj.sentence]}); 
    }
  }
  return result;
}
const testData = [
  { class: 'Reservation', sentence: 'make reservation' },
  { class: 'Reservation', sentence: 'do reservation' },
  { class: 'Greetings', sentence: 'Hello' },
  { class: 'Greetings', sentence: 'Good Morning' }
];
console.log(combineData(testData));

Answer 6

Maybe you're looking to combine data in this way:

function combineData(data){
  const result = [];
  for(let i=0, obj, prev, len=data.length; i<len; i++){
    obj = data[i]; 
    prev = result.find(d=>d.class === obj.class);
    if(prev){
      prev.sentence.push(obj.sentence);
    }
    else{
      result.push({class:obj.class, sentence:[obj.sentence]}); 
    }
  }
  return result;
}
const testData = [
  { class: 'Reservation', sentence: 'make reservation' },
  { class: 'Reservation', sentence: 'do reservation' },
  { class: 'Greetings', sentence: 'Hello' },
  { class: 'Greetings', sentence: 'Good Morning' }
];
console.log(combineData(testData));

Unlocking JSON data with identical keys using JavaScriptLearn how to access JSON data with

Answer №1

Answer №2

Answer №3

Similar questions

No visible alterations were observed to the object following the invocation of JSONDecoder

Utilizing React JS with Material-UI Autocomplete allows for seamlessly transferring the selected item from the renderInput to the InputProps of the textfield component

What is the best way to place content in a single div without it being divided into several separate boxes

What is causing the search filter in the App.js code to malfunction?

Various filters have been utilized on an array of objects

Flask web framework fails to deliver Jquery ajax json get call

Having issues with jQuery when trying to select only a single checkbox?

"Implementing legends in charts with c3.js and JSON data: A step-by-step guide

Having trouble parsing JSON data using JSONArray in Android

What is the best way to keep tab content fixed when switching?

Having trouble retrieving parameters within the expressjs router.delete endpoint implementation

No specification has been provided for the delivery

JavaScript equivalent code to C#'s File.ReadLines(filepath) would be reading a file line

failure to properly assign a property during model update in mongoose

Is it correct to use React Router's useNavigate with a useEffect hook for navigation?

Tailored NodeJS compilation incorporating JavaScript modules

Create a JSON file on the fly

Search for data in a JSON file using PHP and retrieve the desired result

Tips for fading the text of list items when their checkbox is marked as done?

Validating Responses in RESTful APIs