Get only unique data from array of objects in JavaScript

Question

So I have the following structure:

[{
    "isOpen": 1,
    "weekday": 1,
    "humanDay": "Monday",
    "periods": [{
        "openDay": "Monday",
        "openTime": "12:00",
        "closeDay": "Monday",
        "closeTime": "14:30"
      },
      {
        "openDay": "Monday",
        "openTime": "19:00",
        "closeDay": "Monday",
        "closeTime": "22:30"
      },
      {
        "openDay": "Monday",
        "openTime": "23:00",
        "closeDay": "Monday",
        "closeTime": "23:30"
      }
    ]
  },
  {
    "isOpen": 1,
    "weekday": 1,
    "humanDay": "Tuesday",
    "periods": [{
        "openDay": "Tuesday",
        "openTime": "12:00",
        "closeDay": "Tuesday",
        "closeTime": "14:30"
      },
      {
        "openDay": "Tuesday",
        "openTime": "19:00",
        "closeDay": "Tuesday",
        "closeTime": "22:30"
      },
      {
        "openDay": "Tuesday",
        "openTime": "23:00",
        "closeDay": "Tuesday",
        "closeTime": "23:30"
      }
    ]
  }
]

What I want to do, is if all periods for a given day are the same as any other day(matching by their openTime and closeTime) in the array to merge them (or just delete the second occurrence). If the periods are of a different length no action will occur. Also if just one of the openTime or closeTime is different, again no action will occur. So far I have tried looping through all days and comparing one with the following after it. Got stuck in comparing the periods. Tried following the explanation here - https://gomakethings.com/check-if-two-arrays-or-objects-are-equal-with-javascript/, but again got lost. The desired output will be:

[{
    "isOpen": 1,
    "weekday": 1,
    "humanDay": "Monday, Tuesday",
    "periods": [{
        "openDay": "Monday",
        "openTime": "12:00",
        "closeDay": "Monday",
        "closeTime": "14:30"
      },
      {
        "openDay": "Monday",
        "openTime": "19:00",
        "closeDay": "Monday",
        "closeTime": "22:30"
      },
      {
        "openDay": "Monday",
        "openTime": "23:00",
        "closeDay": "Monday",
        "closeTime": "23:30"
      }
    ]
  },

As I don't care about changing the openDay/closeDay in the periods. I want to do this check for all days in the array.

So what should the final array be like after merging/removing duplicates for the given example above? — Ahmad
– Ahmad, Commented May 31, 2020 at 8:39
Please edit your question and include the expected output with proper code formatting — Ahmad
– Ahmad, Commented May 31, 2020 at 8:41
Does this answer your question? Remove duplicate values from JS array. Checkout the section "Unique by..." of the this answer. — ssc-hrep3
– ssc-hrep3, Commented May 31, 2020 at 8:50

LeiMagnus · Accepted Answer · 2020-05-31 08:56:06Z

1

You just need a function that will compare the two objects Also, as you want an array with no duplicates, its probably a good idea to test for duplicates before adding to the array.

function CompareSchedule(s1, s2) {
  return s1.openTime == s2.openTime && s1.closeTime == s2.closeTime;
}

function AddToArray(s) {
  for (var i = 0; i < schedules.length; i++) {
    if (CompareSchedule(s, schedules[i]))
      return false;
  }
  schedules.push(s);
  return true;
}

You can then change your Compare method if you need additional checks etc.

edited May 31, 2020 at 8:56

user11141611

answered May 31, 2020 at 8:49

LeiMagnus

3112 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ahmad · Accepted Answer · 2020-05-31 09:14:39Z

0

I understand what you are trying to do. And I also noticed that your output might be a little bit confusing, since you are reducing the duplicates from the outer level of the array (by joining the humanDay names) but keeping the inner (openDay closeDay) tags.

I have re-written how the output should be like, and also, joined weekday names in an array for more convenience.

let timings = [{
    isOpen: 1,
    weekday: 1,
    humanDay: "Monday",
    periods: [{
        openDay: "Monday",
        openTime: "12:00",
        closeDay: "Monday",
        closeTime: "14:30",
      },
      {
        openDay: "Monday",
        openTime: "19:00",
        closeDay: "Monday",
        closeTime: "22:30",
      },
      {
        openDay: "Monday",
        openTime: "23:00",
        closeDay: "Monday",
        closeTime: "23:30",
      },
    ],
  },
  {
    isOpen: 1,
    weekday: 1,
    humanDay: "Tuesday",
    periods: [{
        openDay: "Tuesday",
        openTime: "12:00",
        closeDay: "Tuesday",
        closeTime: "14:30",
      },
      {
        openDay: "Tuesday",
        openTime: "19:00",
        closeDay: "Tuesday",
        closeTime: "22:30",
      },
      {
        openDay: "Tuesday",
        openTime: "23:00",
        closeDay: "Tuesday",
        closeTime: "23:30",
      },
    ],
  },
];

// create an empty object
const weekdays = {};

timings.forEach((timing) => {
  timing.periods.forEach((period) => {
    // check if the object has a key matching
    // the openTime to CloseTime string
    // (this can be any key, but we want to capture all
    // .. days that have the same open and close times)
    
    if (!weekdays[`${period.openTime}-${period.closeTime}`]) {
      // the key does not exist, so lets create an new sub-object for 
      // that given key, and prepare its array of days:
      weekdays[`${period.openTime}-${period.closeTime}`] = {
        days: [],
      };
    }
    
    // now, add the current day to the pre-defined sub-array:
    weekdays[`${period.openTime}-${period.closeTime}`].days.push(
      timing.humanDay
    );
    
    // also, store the openTime and closeTime as sub-properties, for convenience
    // i know they are stored in the key but the whole purpose of the key
    // is to reduce duplicates by taking advantage of javascript built in
    // funcationalities.

    weekdays[`${period.openTime}-${period.closeTime}`]["openTime"] =
      period.openTime;

    weekdays[`${period.openTime}-${period.closeTime}`]["closeTime"] =
      period.closeTime;
  });
});




console.log(weekdays);

edited May 31, 2020 at 9:14

answered May 31, 2020 at 9:00

Ahmad

12.8k7 gold badges53 silver badges98 bronze badges

3 Comments

devinthemaking Over a year ago

do you mind explaining the following syntax - [${period.openTime}-${period.closeTime}]?

Ahmad Over a year ago

@devinthemaking I have added some comments to my code.

devinthemaking Over a year ago

but what if I want exact matches - I mean only I want to "merge" them if all periods are the same of each day?

Rajneesh · Accepted Answer · 2020-05-31 09:50:26Z

0

You can sum up the entire process inside reduce method:

var data = [{ "isOpen":1, "weekday":1, "humanDay":"Monday", "periods": [ { "openDay":"Monday", "openTime":"12:00", "closeDay":"Monday", "closeTime":"14:30" }, { "openDay":"Monday", "openTime":"19:00", "closeDay":"Monday", "closeTime":"22:30" }, { "openDay":"Monday", "openTime":"23:00", "closeDay":"Monday", "closeTime":"23:30" } ]},{ "isOpen":1, "weekday":1, "humanDay":"Tuesday", "periods": [ { "openDay":"Tuesday", "openTime":"12:00", "closeDay":"Tuesday", "closeTime":"14:30" }, { "openDay":"Tuesday", "openTime":"19:00", "closeDay":"Tuesday", "closeTime":"22:30" }, { "openDay":"Tuesday", "openTime":"23:00", "closeDay":"Tuesday", "closeTime":"23:30" } ]}];

var result = Object.values(data.reduce((acc, elem, i, self)=>{
   otherDays = self.filter(k=>k.periods.every((d,j)=>d.openTime == elem.periods[j].openTime && d.closeTime == elem.periods[j].closeTime));
   key = otherDays.map(({humanDay})=>humanDay).join(',');
   acc[key] = acc[key] || {...elem, humanDay:key};
   return acc;
},{}));

console.log(result);

edited May 31, 2020 at 9:50

answered May 31, 2020 at 9:17

Rajneesh

5,3181 gold badge10 silver badges20 bronze badges

1 Comment

devinthemaking Over a year ago

if I have only one period per day it works correct, however when periods is 2+ I get "Cannot read property 'openTime' of undefined"". @gorak

Varun Sharma · Accepted Answer · 2020-06-10 17:07:06Z

I hope this will help you out solving your issue. This code will remove duplicate values from periods array from each object. I have copied some periods and tried duplicating the values.

var data = [
    {
        "isOpen": 1,
        "weekday": 1,
        "humanDay": "Monday",
        "periods":
            [
                {
                    "openDay": "Monday",
                    "openTime": "12:00",
                    "closeDay": "Monday",
                    "closeTime": "14:30"
                },
                {
                    "openDay": "Monday",
                    "openTime": "19:00",
                    "closeDay": "Monday",
                    "closeTime": "22:30"
                }, {
                    "openDay": "Monday",
                    "openTime": "19:00",
                    "closeDay": "Monday",
                    "closeTime": "22:30"
                },
                {
                    "openDay": "Monday",
                    "openTime": "23:00",
                    "closeDay": "Monday",
                    "closeTime": "23:30"
                }
            ]
    },
    {
        "isOpen": 1,
        "weekday": 1,
        "humanDay": "Tuesday",
        "periods":
            [
                {
                    "openDay": "Tuesday",
                    "openTime": "12:00",
                    "closeDay": "Tuesday",
                    "closeTime": "14:30"
                },
                {
                    "openDay": "Tuesday",
                    "openTime": "19:00",
                    "closeDay": "Tuesday",
                    "closeTime": "22:30"
                },
                {
                    "openDay": "Tuesday",
                    "openTime": "19:00",
                    "closeDay": "Tuesday",
                    "closeTime": "22:30"
                },
                {
                    "openDay": "Tuesday",
                    "openTime": "19:00",
                    "closeDay": "Tuesday",
                    "closeTime": "22:30"
                },
                {
                    "openDay": "Tuesday",
                    "openTime": "23:00",
                    "closeDay": "Tuesday",
                    "closeTime": "23:30"
                }
            ]
    }
]

for (const dt of data) {
    let pr = [];
    for (const period of dt.periods) {
        let prIndex = pr.findIndex(p => (p.openTime == period.openTime && p.closeTime == period.closeTime));
        if (prIndex == -1) {
            pr.push({
                "openDay": period.openDay,
                "openTime": period.openTime,
                "closeDay": period.closeDay,
                "closeTime": period.closeTime
            });
        }
    }

    dt.periods = pr;
}
console.log(data);

Collectives™ on Stack Overflow

Get only unique data from array of objects in JavaScript

4 Answers 4

Comments

3 Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

3 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related