Merge objects based on specific property within an array of objects

Question

Merge objects based on specific property within an array of objects

Is there a way to merge objects based on one property and also add missing Days names in the output?

Consider this example:

var array =  [
       {
      "heure1": "14:00",
      "heure2": "17:00",
      "day": "Sunday",
    },
       {
      "heure1": "08:00",
      "heure2": "13:00",
      "day": "Sunday",
    },
       {
      "heure1": "14:00",
      "heure2": "16:00",
      "day": "Monday",
    },
       {
      "heure1": "08:00",
      "heure2": "18:00",
      "day": "Monday",
    },
  ];

Desired outcome:

var array =  [
       {
      "heure": ["14:00","17:00","08:00","13:00"],
      "day": "Sunday",
    },
     {
      "heure": ["14:00","16:00","08:00","18:00"],
      "day": "Monday",
    },
    {
      "heure": [],
      "day": "Saturday",
    },
    {
      "heure": [],
      "day": "Friday",
    },
    {
      "heure": [],
      "day": "Thursday",
    },
    {
      "heure": [],
      "day": "Wednesday",
    },
    {
      "heure": [],
      "day": "Tuesday",
    },

  ];

I have tried various Stack Overflow solutions without success. Any help would be appreciated. Thank you!

javascript arrays object

Answer 1

Answer №1

Attempting the Challenge

<script>
    var data = [{
            "start_time": "2:00 PM",
            "end_time": "5:00 PM",
            "day_of_week": "Sunday",
        },
        {
            "start_time": "8:00 AM",
            "end_time": "1:00 PM",
            "day_of_week": "Sunday",
        },
        {
            "start_time": "2:00 PM",
            "end_time": "4:00 PM",
            "day_of_week": "Monday",
        },
        {
            "start_time": "8:00 AM",
            "end_time": "6:00 PM",
            "day_of_week": "Monday",
        },
    ];
    var weekdays = ["Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Sunday", "Saturday"];
    var output = [];
    weekdays.map(function (weekday) {
        var timesByDay = data.filter(function (element) {
            return weekday == element.day_of_week
        })
        if (timesByDay.length) {
            timeSlots = [];
            timesByDay.map(function (sched, i) {
                for (var prop in sched) {
                    if (timesByDay[0].hasOwnProperty(prop) && prop != "day_of_week") {
                        timeSlots.push(sched[prop])
                    }
                }
            })
            output.push({
                "weekday": weekday,
                "time_slots": timeSlots
            })
        } else {
            output.push({
                "weekday": weekday,
                "time_slots": []
            })
        }
    })
    console.log(output);
</script>

Answer 2

Attempting the Challenge

<script>
    var data = [{
            "start_time": "2:00 PM",
            "end_time": "5:00 PM",
            "day_of_week": "Sunday",
        },
        {
            "start_time": "8:00 AM",
            "end_time": "1:00 PM",
            "day_of_week": "Sunday",
        },
        {
            "start_time": "2:00 PM",
            "end_time": "4:00 PM",
            "day_of_week": "Monday",
        },
        {
            "start_time": "8:00 AM",
            "end_time": "6:00 PM",
            "day_of_week": "Monday",
        },
    ];
    var weekdays = ["Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Sunday", "Saturday"];
    var output = [];
    weekdays.map(function (weekday) {
        var timesByDay = data.filter(function (element) {
            return weekday == element.day_of_week
        })
        if (timesByDay.length) {
            timeSlots = [];
            timesByDay.map(function (sched, i) {
                for (var prop in sched) {
                    if (timesByDay[0].hasOwnProperty(prop) && prop != "day_of_week") {
                        timeSlots.push(sched[prop])
                    }
                }
            })
            output.push({
                "weekday": weekday,
                "time_slots": timeSlots
            })
        } else {
            output.push({
                "weekday": weekday,
                "time_slots": []
            })
        }
    })
    console.log(output);
</script>

Answer 3

Answer №2

To start, create 7 entries representing each day of the week and initialize them with an empty array for the heure property.

Next, iterate through the original data, find the corresponding entry for each day, and add the specified times to the heure array.

It's important to note that in your input example, the property names for Day have different spellings (DAY, Day). It's recommended to use consistent lowercase formatting for property names.

Check out this implementation:

var array =  [{"heure1": "14:00","heure2": "17:00","day": "Sunday",}, {"heure1": "08:00","heure2": "13:00","day": "Sunday",}, {"heure1": "14:00","heure2": "16:00","day": "Monday",}, {"heure1": "08:00","heure2": "18:00","day": "Monday", },];

let days = ["Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday", "Sunday"];
let obj = Object.fromEntries(days.map(day => [day, { heure: [], day }]));
for (let {heure1, heure2, day} of array) obj[day].heure.push(heure1, heure2);
let result = Object.values(obj);

console.log(result);

Answer 4

To start, create 7 entries representing each day of the week and initialize them with an empty array for the heure property.

Next, iterate through the original data, find the corresponding entry for each day, and add the specified times to the heure array.

It's important to note that in your input example, the property names for Day have different spellings (DAY, Day). It's recommended to use consistent lowercase formatting for property names.

Check out this implementation:

var array =  [{"heure1": "14:00","heure2": "17:00","day": "Sunday",}, {"heure1": "08:00","heure2": "13:00","day": "Sunday",}, {"heure1": "14:00","heure2": "16:00","day": "Monday",}, {"heure1": "08:00","heure2": "18:00","day": "Monday", },];

let days = ["Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday", "Sunday"];
let obj = Object.fromEntries(days.map(day => [day, { heure: [], day }]));
for (let {heure1, heure2, day} of array) obj[day].heure.push(heure1, heure2);
let result = Object.values(obj);

console.log(result);

Answer 5

Answer №3

the path I follow...

var arr_1 = 
    [ { heure1: '14:00', heure2: '17:00', day: 'Sunday' } 
    , { heure1: '08:00', heure2: '13:00', day: 'Sunday' } 
    , { heure1: '14:00', heure2: '16:00', day: 'Monday' } 
    , { heure1: '08:00', heure2: '18:00', day: 'Monday' } 
    ] 

const days = ['Sunday', 'Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday', 'Saturday']

const res = days.map(d=>
        {
        let r = { heure:[], day:d }
        arr_1.filter(x=>x.day===d)
             .forEach(({heure1,heure2})=> { r.heure.push(heure1,heure2) })
        r.heure.sort() 
        return r
        })


console.log( res  )

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

Answer 6

the path I follow...

var arr_1 = 
    [ { heure1: '14:00', heure2: '17:00', day: 'Sunday' } 
    , { heure1: '08:00', heure2: '13:00', day: 'Sunday' } 
    , { heure1: '14:00', heure2: '16:00', day: 'Monday' } 
    , { heure1: '08:00', heure2: '18:00', day: 'Monday' } 
    ] 

const days = ['Sunday', 'Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday', 'Saturday']

const res = days.map(d=>
        {
        let r = { heure:[], day:d }
        arr_1.filter(x=>x.day===d)
             .forEach(({heure1,heure2})=> { r.heure.push(heure1,heure2) })
        r.heure.sort() 
        return r
        })


console.log( res  )

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

Answer 7

Answer №4

Do we really need that specific structure for the result?

If not, by adjusting the structure of the result, you can achieve something similar to this:

const getHeureByDay = (heureArray) => {
  let output = {
    Sunday: { heure: [] },
    Monday: { heure: [] },
    Tuesday: { heure: [] },
    Wednesday: { heure: [] },
    Thursday: { heure: [] },
    Friday: { heure: [] },
    Saturday: { heure: [] },
  };
  
  heureArray.forEach((heureItem) => {
    Object.keys(heureItem).forEach((key) => {
      if (key !== "day") {
        output[heureItem.day].heure.push(heureItem[key]);
      }
    })
  });
  
  return output;
};

const heureArray = [
  {
    "heure1": "14:00",
    "heure2": "17:00",
    "day": "Sunday",
  },
  {
    "heure1": "08:00",
    "heure2": "13:00",
    "day": "Sunday",
  },
     {
    "heure1": "14:00",
    "heure2": "16:00",
    "day": "Monday",
  },
     {
    "heure1": "08:00",
    "heure2": "18:00",
    "day": "Monday",
  }
];

console.log(getHeureByDay(heureArray));

Answer 8

Do we really need that specific structure for the result?

If not, by adjusting the structure of the result, you can achieve something similar to this:

const getHeureByDay = (heureArray) => {
  let output = {
    Sunday: { heure: [] },
    Monday: { heure: [] },
    Tuesday: { heure: [] },
    Wednesday: { heure: [] },
    Thursday: { heure: [] },
    Friday: { heure: [] },
    Saturday: { heure: [] },
  };
  
  heureArray.forEach((heureItem) => {
    Object.keys(heureItem).forEach((key) => {
      if (key !== "day") {
        output[heureItem.day].heure.push(heureItem[key]);
      }
    })
  });
  
  return output;
};

const heureArray = [
  {
    "heure1": "14:00",
    "heure2": "17:00",
    "day": "Sunday",
  },
  {
    "heure1": "08:00",
    "heure2": "13:00",
    "day": "Sunday",
  },
     {
    "heure1": "14:00",
    "heure2": "16:00",
    "day": "Monday",
  },
     {
    "heure1": "08:00",
    "heure2": "18:00",
    "day": "Monday",
  }
];

console.log(getHeureByDay(heureArray));

Merge objects based on specific property within an array of objects

Answer №1

Answer №2

Answer №3

Answer №4

Similar questions

Modify the variable for each VU in K6 (refresh token)

What is the best way to invoke a custom hook that returns a value within the useEffect hook?

The timer does not stop running even after navigating to a different page

Finding an element that lacks both a class and an id, and is not consistently present - what's the trick?

The Ultimate Guide to Initializing Variables in UI Router State Access

What is the process for updating the URL for specific functions within $resource in Angular?

Keeping data external to promises in protractor

Loading a Vue.js template dynamically post fetching data from Firebase storage

What are some effective ways to integrate the WordPress API with ReactJS?

Exploring Sanity npm package with Jest for mocking tests

Having trouble persisting data with indexedDB

Retrieving elements within an object using jQuery

What is the most effective method for nesting loops in NodeJS and Mocha?

What is the appropriate response to send to the user in a web application?

What is the best way to iterate through an array containing multiple objects in order to create a graph?

React: When an array state is controlling my components, why aren't they re-rendering?

Utilize Redux in conjunction with TypeScript to seamlessly incorporate a logout feature

Uncover and control nested objects in JSON data

Dynamic Filtering with jQuery List

Disabling the authentication prompt in the browser