Combining duplicate objects in a JavaScript array

Question

Combining duplicate objects in a JavaScript array

I am looking to identify duplicates by country code and merge them into a single object

The array structure is:

[{...},{...}]

Objects

{Country_Code: "RU", Country: "Russia", Provider: "Shell1", Price: "0.123"},
{Country_Code: "EN", Country: "Russia", Provider: "Shell", Price: "0.76856"},
{Country_Code: "RO", Country: "Russia", Provider: "Shell", Price: "0.563"},
{Country_Code: "RU", Country: "Russia", Provider: "Shell2", Price: "0.90890"},
{Country_Code: "RU", Country: "Russia", Provider: "Shell3", Price: "0.90"}

I want to get an array of objects like this

[{Country_Code: "RU", Country: "Russia", Provider: "Shell1 - 0.123</br>Shell2 - 0.90890</br>Shell3 - 0.90", Price: "0.123"},
{Country_Code: "EN", Country: "Russia", Provider: "Shell", Price: "0.76856"},
{Country_Code: "RO", Country: "Russia", Provider: "Shell", Price: "0.563"}]

If I think the approach should be something like

var NewArr =[],NewObj ={};
data.forEach(function(dataItem,index) {
    CC = dataItem.Country_Code;
    counts[CC]= (counts[CC]||0) + 1; // Count duplicates
        if(counts[CC]>1){
            NewObj.Country_Code = dataItem.Country_Code;
            NewObj.Country = dataItem.Country;
            NewObj.Provider = dataItem.Provider + " - " + dataItem.Price + "</br>";
            NewObj.Price = dataItem.Price;
            NewArr[indexOfDup] = NewObj; 
        }else{
            NewArr.push(data[index]);
        }

});

This syntax is incorrect, so how can I correct it?

javascript arrays object

Answer 1

Answer №1

When tackling this issue, I approached it from a unique angle. My solution involves an algorithm that operates without the need for any search algorithms. This approach allows it to efficiently handle large arrays.

var myArray = [{Country_Code: "RU", Country: "Russia", Provider: "Shell1", Price: "0.123"},
{Country_Code: "EN", Country: "Russia", Provider: "Shell", Price: "0.76856"},
{Country_Code: "RO", Country: "Russia", Provider: "Shell", Price: "0.563"},
{Country_Code: "RU", Country: "Russia", Provider: "Shell2", Price: "0.90890"},
{Country_Code: "RU", Country: "Russia", Provider: "Shell3", Price: "0.90"}];


var groupByCountryCode = function(xs, key) {
  return xs.reduce(function(rv, x) {
    if(rv[x[key]]){
      // It has found more than one instance

      rv[x[key]][0].Provider += " " + x.Provider;
    }else{
      rv[x[key]] = [];
      rv[x[key]].push(x);
    }
    return rv;
  }, {});
};

var grouppedElementsByKey = groupByCountryCode(myArray,"Country_Code");

var grouppedArray =   Object.keys(grouppedElementsByKey).map(function(key){
  return grouppedElementsByKey[key][0];
});


console.log(grouppedArray);

The end result will align with your original request.

Answer 2

When tackling this issue, I approached it from a unique angle. My solution involves an algorithm that operates without the need for any search algorithms. This approach allows it to efficiently handle large arrays.

var myArray = [{Country_Code: "RU", Country: "Russia", Provider: "Shell1", Price: "0.123"},
{Country_Code: "EN", Country: "Russia", Provider: "Shell", Price: "0.76856"},
{Country_Code: "RO", Country: "Russia", Provider: "Shell", Price: "0.563"},
{Country_Code: "RU", Country: "Russia", Provider: "Shell2", Price: "0.90890"},
{Country_Code: "RU", Country: "Russia", Provider: "Shell3", Price: "0.90"}];


var groupByCountryCode = function(xs, key) {
  return xs.reduce(function(rv, x) {
    if(rv[x[key]]){
      // It has found more than one instance

      rv[x[key]][0].Provider += " " + x.Provider;
    }else{
      rv[x[key]] = [];
      rv[x[key]].push(x);
    }
    return rv;
  }, {});
};

var grouppedElementsByKey = groupByCountryCode(myArray,"Country_Code");

var grouppedArray =   Object.keys(grouppedElementsByKey).map(function(key){
  return grouppedElementsByKey[key][0];
});


console.log(grouppedArray);

The end result will align with your original request.

Answer 3

Answer №2

To achieve this task, you can utilize the array.reduce method. The idea is to iterate through an array using array.reduce, and for each object in the array, check if there is already an object with a matching country code using findIndex. If a matching object is found, update the property value accordingly.

let data = [{
    Country_Code: "RU",
    Country: "Russia",
    Provider: "Shell1",
    Price: "0.123"
  },
  {
    Country_Code: "EN",
    Country: "Russia",
    Provider: "Shell",
    Price: "0.76856"
  },
  {
    Country_Code: "RO",
    Country: "Russia",
    Provider: "Shell",
    Price: "0.563"
  },
  {
    Country_Code: "RU",
    Country: "Russia",
    Provider: "Shell2",
    Price: "0.90890"
  },
  {
    Country_Code: "RU",
    Country: "Russia",
    Provider: "Shell3",
    Price: "0.90"
  }
]

let result = data.reduce(function(acc, curr) {
  let findIndex = acc.findIndex((item) => {
    return item['Country_Code'] === curr['Country_Code']
  });
  if (findIndex === -1) {
    acc.push(curr)
  } else {
    acc[findIndex].Provider = acc[findIndex].Provider + ' - ' + acc[findIndex].Price + '<br/>' + curr.Provider + ' - ' + curr.Price
  }

  return acc;


}, []);

console.log(result)

Answer 4

To achieve this task, you can utilize the array.reduce method. The idea is to iterate through an array using array.reduce, and for each object in the array, check if there is already an object with a matching country code using findIndex. If a matching object is found, update the property value accordingly.

let data = [{
    Country_Code: "RU",
    Country: "Russia",
    Provider: "Shell1",
    Price: "0.123"
  },
  {
    Country_Code: "EN",
    Country: "Russia",
    Provider: "Shell",
    Price: "0.76856"
  },
  {
    Country_Code: "RO",
    Country: "Russia",
    Provider: "Shell",
    Price: "0.563"
  },
  {
    Country_Code: "RU",
    Country: "Russia",
    Provider: "Shell2",
    Price: "0.90890"
  },
  {
    Country_Code: "RU",
    Country: "Russia",
    Provider: "Shell3",
    Price: "0.90"
  }
]

let result = data.reduce(function(acc, curr) {
  let findIndex = acc.findIndex((item) => {
    return item['Country_Code'] === curr['Country_Code']
  });
  if (findIndex === -1) {
    acc.push(curr)
  } else {
    acc[findIndex].Provider = acc[findIndex].Provider + ' - ' + acc[findIndex].Price + '<br/>' + curr.Provider + ' - ' + curr.Price
  }

  return acc;


}, []);

console.log(result)

Answer 5

Answer №3

'use strict';

const info = [
  {Country_Code: "RU", Country: "Russia", Provider: "Shell1", Price: "0.123"},
  {Country_Code: "EN", Country: "Russia", Provider: "Shell", Price: "0.76856"},
  {Country_Code: "RO", Country: "Russia", Provider: "Shell", Price: "0.563"},
  {Country_Code: "RU", Country: "Russia", Provider: "Shell2", Price: "0.90890"},
  {Country_Code: "RU", Country: "Russia", Provider: "Shell3", Price: "0.90"}
];

// convert the data into a hashmap based on country code
const countryDataMap = info.reduce((dataByCountry, current) => {
  const itemObj = {};
  if (dataByCountry[current.Country_Code]) {
    dataByCountry[current.Country_Code].Provider.push(current.Provider);
  } else {
    dataByCountry[current.Country_Code] = { 
      ...current,
      Provider: [current.Provider],
    };
  }

  return dataByCountry;
}, {});

/** 
 * Convert the hashmap back to an array of objects for display purposes,
 * also concatenating the Providers.
 **/
const processedCountriesInfo = Object.keys(countryDataMap).map((code) => {
  const countryData = { ...countryDataMap[code] };

  countryData.Provider = countryData.Provider.join('<br>-');

  return countryData;
});

console.log(processedCountriesInfo);

Answer 6

'use strict';

const info = [
  {Country_Code: "RU", Country: "Russia", Provider: "Shell1", Price: "0.123"},
  {Country_Code: "EN", Country: "Russia", Provider: "Shell", Price: "0.76856"},
  {Country_Code: "RO", Country: "Russia", Provider: "Shell", Price: "0.563"},
  {Country_Code: "RU", Country: "Russia", Provider: "Shell2", Price: "0.90890"},
  {Country_Code: "RU", Country: "Russia", Provider: "Shell3", Price: "0.90"}
];

// convert the data into a hashmap based on country code
const countryDataMap = info.reduce((dataByCountry, current) => {
  const itemObj = {};
  if (dataByCountry[current.Country_Code]) {
    dataByCountry[current.Country_Code].Provider.push(current.Provider);
  } else {
    dataByCountry[current.Country_Code] = { 
      ...current,
      Provider: [current.Provider],
    };
  }

  return dataByCountry;
}, {});

/** 
 * Convert the hashmap back to an array of objects for display purposes,
 * also concatenating the Providers.
 **/
const processedCountriesInfo = Object.keys(countryDataMap).map((code) => {
  const countryData = { ...countryDataMap[code] };

  countryData.Provider = countryData.Provider.join('<br>-');

  return countryData;
});

console.log(processedCountriesInfo);

Answer 7

Answer №4

Below is a solution utilizing the reduce method. Initially, I structured a map using arrays for properties with multiple values. Subsequently, I used this organized structure to format the data according to your requirements:

var data = [{
  Country_Code: "RU",
  Country: "Russia",
  Provider: "Shell1",
  Price: "0.123"
}, {
  Country_Code: "EN",
  Country: "Russia",
  Provider: "Shell",
  Price: "0.76856"
}, {
  Country_Code: "RO",
  Country: "Russia",
  Provider: "Shell",
  Price: "0.563"
}, {
  Country_Code: "RU",
  Country: "Russia",
  Provider: "Shell2",
  Price: "0.90890"
}, {
  Country_Code: "RU",
  Country: "Russia",
  Provider: "Shell3",
  Price: "0.90"
}];

//Creating a map structure for organization
var map = data.reduce((map, el) => {
  let provider = [];
  let price = [];
  if (map[el.Country_Code]) {
    provider = map[el.Country_Code].Provider;
    price = map[el.Country_Code].Price;
  }
  provider.push(el.Provider);
  price.push(el.Price);

  map[el.Country_Code] = {
    Country_Code: el.Country_Code,
    Country: el.Country,
    Provider: provider,
    Price: price
  }
  return map;
}, {});

//Utilizing the data map to present the data in desired format
var formatted = Object.values(map).map((el) => {
  return {
    Country_Code: el.Country_Code,
    Country: el.Country,
    Provider: el.Provider.reduce((str, providerEl, idx) => {
      return str += `${providerEl} - ${el.Price[idx]}</br>`;
    }, ''),
    Price: el.Price[0]
  }
});

console.log(Object.values(formatted));
//{Country_Code: "RU", Country: "Russia", Provider: "Shell1 - 0.123</br>Shell2 - 0.90890</br>Shell3 - 0.90", Price: "0.123"}

Answer 8

Below is a solution utilizing the reduce method. Initially, I structured a map using arrays for properties with multiple values. Subsequently, I used this organized structure to format the data according to your requirements:

var data = [{
  Country_Code: "RU",
  Country: "Russia",
  Provider: "Shell1",
  Price: "0.123"
}, {
  Country_Code: "EN",
  Country: "Russia",
  Provider: "Shell",
  Price: "0.76856"
}, {
  Country_Code: "RO",
  Country: "Russia",
  Provider: "Shell",
  Price: "0.563"
}, {
  Country_Code: "RU",
  Country: "Russia",
  Provider: "Shell2",
  Price: "0.90890"
}, {
  Country_Code: "RU",
  Country: "Russia",
  Provider: "Shell3",
  Price: "0.90"
}];

//Creating a map structure for organization
var map = data.reduce((map, el) => {
  let provider = [];
  let price = [];
  if (map[el.Country_Code]) {
    provider = map[el.Country_Code].Provider;
    price = map[el.Country_Code].Price;
  }
  provider.push(el.Provider);
  price.push(el.Price);

  map[el.Country_Code] = {
    Country_Code: el.Country_Code,
    Country: el.Country,
    Provider: provider,
    Price: price
  }
  return map;
}, {});

//Utilizing the data map to present the data in desired format
var formatted = Object.values(map).map((el) => {
  return {
    Country_Code: el.Country_Code,
    Country: el.Country,
    Provider: el.Provider.reduce((str, providerEl, idx) => {
      return str += `${providerEl} - ${el.Price[idx]}</br>`;
    }, ''),
    Price: el.Price[0]
  }
});

console.log(Object.values(formatted));
//{Country_Code: "RU", Country: "Russia", Provider: "Shell1 - 0.123</br>Shell2 - 0.90890</br>Shell3 - 0.90", Price: "0.123"}

Answer 9

Answer №5

A convenient way to find the index of a specific value in an array is by using the array.indexOf(someValue) method.

Answer 10

A convenient way to find the index of a specific value in an array is by using the array.indexOf(someValue) method.

Combining duplicate objects in a JavaScript array

Answer №1

Answer №2

Answer №3

Answer №4

Answer №5

Similar questions

choose multiple elements from an array simultaneously

Releasing the mouse button after dragging successfully without the use of any libraries

What could be causing a problem with the select query in SQLite for iOS using PhoneGap

How to filter an array in Angular 4 without the need for creating a new array and then displaying the filtered results within the same

Guide to adding Angular 2 components to various locations in the DOM of a vanilla JavaScript webpage

Using Svelte to effectively connect to a specified object within an array

What is the best way to assign the result of a promise to a variable?

How can I organize data from A to Z in alphabetical order in React Native when the user chooses the A to Z option from the dropdown menu?

How can you store a Json Object with nested arrays, including other Json objects, in a single table in an SQL database?

Trouble populating array using the .Split method

Angular Starter Kit

Is there a way to assign an array to a jagged array column in VBA without having to declare the former as Variant?

Leverage IBM Worklight to initiate iOS native code execution upon plugin creation

Exploring Enum properties within an angular js select drop down

Is there a way to handle the ajax request only when necessary, instead of processing it every few seconds?

What causes the truncation of the backslash in the string "videos1_visualisation.mp4"?

I am experiencing an issue with my date filter where it does not display any results when I choose the same date for the start and end dates. Can anyone help me troub

Trapped in the Web of Facebook OAuth

What is the method for converting this pattern into a JavaScript regex?

Place the outcome of the function into the div element's attribute