How to push non exists data between two array of objects

Question

I have two arrays of objects

First, one obtained from the database

const data = [{
    count: 156,
    monthCount: 1,
    year: 2018
  },
  {
    count: 165,
    monthCount: 2,
    year: 2018
  },
  {
    count: 153,
    monthCount: 3,
    year: 2018
  },
  {
    count: 63,
    monthCount: 6,
    year: 2018
  },
  {
    count: 4,
    monthCount: 9,
    year: 2018
  },
  {
    count: 116,
    monthCount: 10,
    year: 2018
  }
]

And second is my dummy data

const dummyData = [{
    count: 0,
    monthCount: 1,
    year: 2018
  },
  {
    count: 0,
    monthCount: 2,
    year: 2018
  },
  {
    count: 0,
    monthCount: 3,
    year: 2018
  },
  {
    count: 0,
    monthCount: 4,
    year: 2018
  },
  {
    count: 0,
    monthCount: 5,
    year: 2018
  },
  {
    count: 0,
    monthCount: 6,
    year: 2018
  },
  {
    count: 0,
    monthCount: 7,
    year: 2018
  },
  {
    count: 0,
    monthCount: 8,
    year: 2018
  },
  {
    count: 0,
    monthCount: 9,
    year: 2018
  },
  {
    count: 0,
    monthCount: 10,
    year: 2018
  },
  {
    count: 0,
    monthCount: 11,
    year: 2018
  },
  {
    count: 0,
    monthCount: 12,
    year: 2018
  }
]

I need to add missing values inside my data array comparing with the month of dummy array.

I have tried using lodash but could not get what I needed.

var diffArr =  _.differenceWith(obj.data, 'monthCount', numberArr, 'monthCount', _.isEqual)

Thank you in advance.

What is missing data here ? Is it based on monthCount ?

Abito Prakash
– Abito Prakash

2019-10-19 08:31:51 +00:00
Commented Oct 19, 2019 at 8:31 — Abito Prakash
– Abito Prakash, Commented Oct 19, 2019 at 8:31

giuseppedeponte · Accepted Answer · 2019-10-19 08:35:02Z

2

You can map your dummyData items and replace them if a corresponding item exists for the same monthCount in the real data array:

const data = [{
    count: 156,
    monthCount: 1,
    year: 2018
  },
  {
    count: 165,
    monthCount: 2,
    year: 2018
  },
  {
    count: 153,
    monthCount: 3,
    year: 2018
  },
  {
    count: 63,
    monthCount: 6,
    year: 2018
  },
  {
    count: 4,
    monthCount: 9,
    year: 2018
  },
  {
    count: 116,
    monthCount: 10,
    year: 2018
  }
]

const dummyData = [{
    count: 0,
    monthCount: 1,
    year: 2018
  },
  {
    count: 0,
    monthCount: 2,
    year: 2018
  },
  {
    count: 0,
    monthCount: 3,
    year: 2018
  },
  {
    count: 0,
    monthCount: 4,
    year: 2018
  },
  {
    count: 0,
    monthCount: 5,
    year: 2018
  },
  {
    count: 0,
    monthCount: 6,
    year: 2018
  },
  {
    count: 0,
    monthCount: 7,
    year: 2018
  },
  {
    count: 0,
    monthCount: 8,
    year: 2018
  },
  {
    count: 0,
    monthCount: 9,
    year: 2018
  },
  {
    count: 0,
    monthCount: 10,
    year: 2018
  },
  {
    count: 0,
    monthCount: 11,
    year: 2018
  },
  {
    count: 0,
    monthCount: 12,
    year: 2018
  }
]

const allData = dummyData.map(dummyItem => (
  data.find(item => item.monthCount === dummyItem.monthCount) || dummyItem
))

console.log(allData);

answered Oct 19, 2019 at 8:35

giuseppedeponte

2,3711 gold badge12 silver badges20 bronze badges

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

1 Comment

Code Maniac Over a year ago

@AshishBhangade if you see a answer solved your question you should mark as correct answer, What should I do when someone answers my question?

Nina Scholz · Accepted Answer · 2019-10-19 08:43:12Z

0

You could create a new array and check if the actual mont exist or take a single dummy object with an adjusted monthCount.

var data = [{ count: 156, monthCount: 1, year: 2018 }, { count: 165, monthCount: 2, year: 2018 }, { count: 153, monthCount: 3, year: 2018 }, { count: 63, monthCount: 6, year: 2018 }, { count: 4, monthCount: 9, year: 2018 }, { count: 116, monthCount: 10, year: 2018 }],
    dummy = { count: 0, monthCount: 0, year: 2018 },
    result = Array.from(
        { length: 12 },
        (i => (_, j) => data[i] && data[i].monthCount === j + 1
            ? data[i++]
            : { ...dummy, monthCount: j + 1 }
        )(0)
    );

console.log(result);

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

edited Oct 19, 2019 at 8:43

answered Oct 19, 2019 at 8:37

Nina Scholz

388k26 gold badges367 silver badges417 bronze badges

Comments

balmukund kumar · Accepted Answer · 2019-10-19 08:48:14Z

0

Merge Object with same month count key.

Please check out this simple solution:

const data = [{
    count: 156,
    monthCount: 1,
    year: 2018
  },
  {
    count: 165,
    monthCount: 2,
    year: 2018
  },
  {
    count: 153,
    monthCount: 3,
    year: 2018
  },
  {
    count: 63,
    monthCount: 6,
    year: 2018
  },
  {
    count: 4,
    monthCount: 9,
    year: 2018
  },
  {
    count: 116,
    monthCount: 10,
    year: 2018
  }
]

const dummyData = [{
    count: 0,
    monthCount: 1,
    year: 2018
  },
  {
    count: 0,
    monthCount: 2,
    year: 2018
  },
  {
    count: 0,
    monthCount: 3,
    year: 2018
  },
  {
    count: 0,
    monthCount: 4,
    year: 2018
  },
  {
    count: 0,
    monthCount: 5,
    year: 2018
  },
  {
    count: 0,
    monthCount: 6,
    year: 2018
  },
  {
    count: 0,
    monthCount: 7,
    year: 2018
  },
  {
    count: 0,
    monthCount: 8,
    year: 2018
  },
  {
    count: 0,
    monthCount: 9,
    year: 2018
  },
  {
    count: 0,
    monthCount: 10,
    year: 2018
  },
  {
    count: 0,
    monthCount: 11,
    year: 2018
  },
  {
    count: 0,
    monthCount: 12,
    year: 2018
  }
]

const resultData = dummyData.map((d, index)=>({...d, ...data.find(k=>k.monthCount===d.monthCount)}));
    console.log(resultData);

Thanks

edited Oct 19, 2019 at 8:48

answered Oct 19, 2019 at 8:40

balmukund kumar

1395 bronze badges

2 Comments

giuseppedeponte Over a year ago

I do not think the indexes are the same. dummyData's purpose is more to fill in the holes in the real data, as I understood it.

balmukund kumar Over a year ago

Got your point. I didn't understood monthCount relevance at first instance. Thanks

Janus · Accepted Answer · 2019-10-19 08:59:01Z

Easy and simple way to do that would be to map the dummyData array, check if the object exists in the data array from your database.

Ifi it exists, we return the found object, else we return the dummy oject :)

const data=[{count:156,monthCount:1,year:2018},{count:165,monthCount:2,year:2018},{count:153,monthCount:3,year:2018},{count:63,monthCount:6,year:2018},{count:4,monthCount:9,year:2018},{count:116,monthCount:10,year:2018}];
const dummyData=[{count:0,monthCount:1,year:2018},{count:0,monthCount:2,year:2018},{count:0,monthCount:3,year:2018},{count:0,monthCount:4,year:2018},{count:0,monthCount:5,year:2018},{count:0,monthCount:6,year:2018},{count:0,monthCount:7,year:2018},{count:0,monthCount:8,year:2018},{count:0,monthCount:9,year:2018},{count:0,monthCount:10,year:2018},{count:0,monthCount:11,year:2018},{count:0,monthCount:12,year:2018}];

const myMergedData = dummyData.map(dummyDataItem=>{
    var found = false;
    for(var i = 0; i < data.length; i++) 
    {
        if(data[i].monthCount === dummyDataItem.monthCount)
        {
            found = data[i];
            break;
        }
    }
    
    //if already in original, return the original
    //else return the dummy one ;)
    if(found) return found; 
    else return dummyDataItem;
});

console.log('Your new array =>', myMergedData);

Ashh · Accepted Answer · 2019-11-26 08:13:13Z

0

Finally, I got this simplest method using lodash:-

var diffArr = _.unionBy(data, dummyData, 'monthCount')
console.log(diffArr)

edited Nov 26, 2019 at 8:13

Ashh

46.6k16 gold badges111 silver badges137 bronze badges

answered Oct 19, 2019 at 9:11

Ashish Bhangade

531 gold badge1 silver badge5 bronze badges

Collectives™ on Stack Overflow

How to push non exists data between two array of objects

5 Answers 5

1 Comment

Comments

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

1 Comment

Comments

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related