JSON representation of 2 arrays

Question

JSON representation of 2 arrays

I am looking to combine 2 arrays in JSON format with keys and values.

MyArray1 [ "Orange:10", "Orange:5", "Banana:20", "Apple:5" ]
MyArray2 [ "Orange:5", "Banana:10", "Apple:15" ]

MyJSON   [
      {"fruit": "Orange", "value": 15},
      {"fruit": "Banana", "value": 20},
      {"fruit": "Apple ", "value": 5},
    ],[
      {"fruit": "Orange", "value": 5},
      {"fruit": "Banana", "value": 10},
      {"fruit": "Apple ", "value": 15},
    ]
  ]

I attempted this method but I require key-value pairs to concatenate my 2 arrays together:

MyArray1.forEach(function(val) {
                    var item = val.split(":");
                    var key = item[0];
                    var num = parseInt(item[1], 10);

                    if (MyArray1.hasOwnProperty(key)) {
                    MyArray1[key] += num;
                    } else {
                        MyArray1[key] = num;
                    }
                });

javascript arrays json object

Answer 1

Answer №1

Here is a revised version summarizing the values of the same fruits. The values are now integers for easier addition. If you prefer strings, simply use arr[i].value=arr[i].value.toString(). Your feedback is appreciated.

var myArray1 =  [ "Orange:10", "Orange:5", "Banana:20", "Apple:5" ];
var myArray2 = [ "Orange:5", "Banana:10", "Apple:15" ];

var myObjectArray1 = arrayToObjectArray(myArray1);
var myObjectArray2 = arrayToObjectArray(myArray2);

var myOnlyOneObjectArray= myObjectArray1.concat(myObjectArray2);

var myResult = mergeObjectArray(myOnlyOneObjectArray,"fruit","value")

console.log(myResult);

function arrayToObjectArray(arr){
// Using map to transform each array row
var arr2 = arr.map(function(item) {
var items = item.split(":");
item = {};
item.fruit = items[0];
item.value = parseInt(items[1]);
return item;
});
return arr2;
}
 
function mergeObjectArray(arr,compareKey,addKey){
// Loop through arr in reverse and check for matching fruits to sum their values
for(var i = arr.length-1; i >=0;i--){
for(var j = 0; j < arr.length -1;j++){
if((arr[i][compareKey]==arr[j][compareKey]) && (i!=j)){ 
arr[j][addKey]+=arr[i][addKey];  
arr.splice(i, 1); 
break;
}
}
}
return arr;
}

Answer 2

Here is a revised version summarizing the values of the same fruits. The values are now integers for easier addition. If you prefer strings, simply use arr[i].value=arr[i].value.toString(). Your feedback is appreciated.

var myArray1 =  [ "Orange:10", "Orange:5", "Banana:20", "Apple:5" ];
var myArray2 = [ "Orange:5", "Banana:10", "Apple:15" ];

var myObjectArray1 = arrayToObjectArray(myArray1);
var myObjectArray2 = arrayToObjectArray(myArray2);

var myOnlyOneObjectArray= myObjectArray1.concat(myObjectArray2);

var myResult = mergeObjectArray(myOnlyOneObjectArray,"fruit","value")

console.log(myResult);

function arrayToObjectArray(arr){
// Using map to transform each array row
var arr2 = arr.map(function(item) {
var items = item.split(":");
item = {};
item.fruit = items[0];
item.value = parseInt(items[1]);
return item;
});
return arr2;
}
 
function mergeObjectArray(arr,compareKey,addKey){
// Loop through arr in reverse and check for matching fruits to sum their values
for(var i = arr.length-1; i >=0;i--){
for(var j = 0; j < arr.length -1;j++){
if((arr[i][compareKey]==arr[j][compareKey]) && (i!=j)){ 
arr[j][addKey]+=arr[i][addKey];  
arr.splice(i, 1); 
break;
}
}
}
return arr;
}

Answer 3

Answer №2

Check out this example showcasing a simple transformation process: I created a basic function to convert a flat array into an array of objects, followed by grouping the two modified arrays into another array

var myFruits1 =  [ "Peach:8", "Pear:4", "Kiwi:12", "Grape:7" ];
var myFruits2 = [ "Peach:4", "Kiwi:9", "Grape:15" ];

var myFruits1Updated = updateArrayObjects(myFruits1);
var myFruits2Updated = updateArrayObjects(myFruits2);

var combinedResult = [myFruits1Updated, myFruits2Updated];

console.log(combinedResult);

function updateArrayObjects(arr){
var arrModified = arr.map(function(item) {
var itemsSplit = item.split(":");
item = {};
item.name = itemsSplit[0];
item.quantity = itemsSplit[1];

return item;
});
return arrModified;
}

Answer 4

Check out this example showcasing a simple transformation process: I created a basic function to convert a flat array into an array of objects, followed by grouping the two modified arrays into another array

var myFruits1 =  [ "Peach:8", "Pear:4", "Kiwi:12", "Grape:7" ];
var myFruits2 = [ "Peach:4", "Kiwi:9", "Grape:15" ];

var myFruits1Updated = updateArrayObjects(myFruits1);
var myFruits2Updated = updateArrayObjects(myFruits2);

var combinedResult = [myFruits1Updated, myFruits2Updated];

console.log(combinedResult);

function updateArrayObjects(arr){
var arrModified = arr.map(function(item) {
var itemsSplit = item.split(":");
item = {};
item.name = itemsSplit[0];
item.quantity = itemsSplit[1];

return item;
});
return arrModified;
}

JSON representation of 2 arrays

Answer №1

Answer №2

Similar questions

Is it possible to showcase D3 charts on an .epub file?

What is the best way to initialize a value asynchronously for React context API in the latest version of NextJS, version

Deactivating Node.js files in vsCode for client-side JavaScript files

What is the best way to retrieve a value from a multiple select element being utilized by asmselect?

Leveraging symbols in JSON with Python

When navigating within a page, Firefox shows {{ }} tags while Chrome does not in AngularJS

Easily compare arrays using mathematical operators

Tips for saving HTML data locally

The feature of filtering in Telerik software

`The enforcement of a function's parameter requiring it to be part of the generic type T`

Getting the backslash character to display correctly within a JSON object value in Java can sometimes be tricky, as it

Delay in only a portion of the AJAX response

When exporting a Mongoose model, it mysteriously becomes undefined

Guide on creating a function that accepts an Array of strings as a parameter and displays the initial letter of each element individually on separate lines

Is it possible to simultaneously execute an animate and a fade out effect?

"The text() or json() methods in Javascript's fetch function never seem to resolve, leaving the operation in a perpetual

Executing a query with a `has many` relationship in MongoDB: Step-by-step guide

Using JavaScript/JQuery, change relative or viewport sizes to fixed sizes when the page loads

Clicking on a single checkbox causes the entire input to become deactivated due to the way the system is

Trouble with modifying style in Google Chrome and Internet Explorer prior to AJAX request