Create simple array from a array of objects & another simple array

Question

I have a json array and a simple array. Each object in this json has three keys & another simple array with unique values.

 var jsonArr=[{
      amount: "2",
      club: "xyz",
      member: "tmm"
    },
    {
      amount: "3",
      club: "xyz",
      member: "tsj"
    },
    {
      amount: "4",
      club: "xyz",
      member: "tsj"
    },
    {
      amount: "5",
      club: "ama",
      member: "vbr"
    },
    {
     amount: "6",
     club: "ama",
     member: "vbr"
    },
    {
     amount: "7",
     club: "crm",
     member: "vbr"
    },
    {
     amount: "8",
     club: "mic",
     member: "wjr"
    }]

simple Array of members

var smpMember =['tmm','tsj','vbr','wjr']

simple Array of clubs

var smpClub=['xyz','ama','crm','mic']

I intend to create a simple array of amount value for each of the member.If the member has subscribe to a club it will add its amount value, if not it will assign a zero to it. For example member tmm has subscribe to club xyz so the array for it will be like

var tmm =[2,0,0,0];

Again member vbr has subscribe to club ama twice. So array for it will be

var vbr =[0,11,0,0]; // 11 is sum of 6 & 5

So there will be array for each of the member

What I tried?

I am looping taking each of the member from smpMember array and checking if that member exist in each of the json object.

for(var i=0,j=smapMember.length;i<j;i++){  // Loop through array of members & pick each member
      for(var x=0,y=jsonArr.length;x<y;x++){ // Loop through jsaon array of objects
          var _sAmt =0;
          if(smapMember[i]==jsonArr[x].member){ // check if member exist
               _sAmt =jsonArr[x].amount;
              if(y > (x+1)){ // Check for last element
                  if(jsonArr[x].club ==jsonArr[x+1].club){
                     _sAmt +=jsonArr[x+1].amount;
               }
              else{
                  _sAmt =0
               }
           }
      }
    var tempArr.push(_sAmt);

}

But I am not able to sucessfuly get the result. Also I feel using too much if -else is an overhead. Can I have a better solution of it.

Would you be averse to programming this in an object oriented way? Strikes me as the type of structure that would benefit from being object oriented. — OliverRadini
– OliverRadini, Commented Nov 27, 2015 at 11:30
@user2181397 what should be in result? for each member should be separated array or should be one array = [2, 11, .... ] ? — Oleksandr T.
– Oleksandr T., Commented Nov 27, 2015 at 11:36
Well, often for this kind of data it helps to separate things into objects. I'm not suggesting it would be 100% better, but it may be a useful way to handle this kind of data. I can try and make a fiddle as a quick example — OliverRadini
– OliverRadini, Commented Nov 27, 2015 at 11:41
This won;t be too useful too you as it is: jsfiddle.net/f3y9zuh8 but it might illustrate what I was getting at. The code in that fiddle takes each item in the Json array and creates a membership object. Each membership has a member, a club, and an amount. Each club has an array of memberships. You can go through the array of clubs and extract any data you need eg clubs['ama'].memberships[0].member.name gives you the name of the first member at the club ama. I can elaborate later when I have more time. — OliverRadini
– OliverRadini, Commented Nov 27, 2015 at 12:19

Isabek Tashiev · Accepted Answer · 2015-11-27 12:01:19Z

I think you can create adjacency matrix between member and club.

var result = [];

for (var i = 0; i < smpMember.length; i++) {
  var amt = [];
  for (var j = 0; j < smpClub.length; j++) {
    var club = smpClub[j];
    var member = smpMember[i];
    var amount = 0;

    jsonArr.forEach(function (obj) {
       if (obj.member == member && club == obj.club) {
         amount += +obj.amount;
       }
    });
    amt[j] = amount;
  }
 result[i] = amt;
}

console.log(result);

Result will be:

[ [ 2, 0, 0, 0 ],
  [ 7, 0, 0, 0 ],
  [ 0, 11, 7, 0 ],
  [ 0, 0, 0, 8 ] ]

Here using by member and club indexes, you can get amount.

Examples:

 tmm -> 0
 xyz -> 0
 amount = 2

 tsj -> 1
 xyz -> 0
 amount = 7

Another version like this

 var result = {};

 for (var i = 0; i < smpMember.length; i++) {
   var amt = [];
   for (var j = 0; j < smpClub.length; j++) {
      var club = smpClub[j];
      var member = smpMember[i];
      var amount = 0;

      jsonArr.forEach(function (obj) {
        if (obj.member == member && club == obj.club) {
          amount += +obj.amount;
        }
      });
     amt[club] = amount;
   }
   result[member] = amt;
}

console.log(result);

Result will be:

 { tmm: [ xyz: 2, ama: 0, crm: 0, mic: 0 ],
   tsj: [ xyz: 7, ama: 0, crm: 0, mic: 0 ],
   vbr: [ xyz: 0, ama: 11, crm: 7, mic: 0 ],
   wjr: [ xyz: 0, ama: 0, crm: 0, mic: 8 ] }

Using by member and club you can get amount.

Example:

 console.log(result['tmm']['xyz']); //2

Rajesh Dixit · Accepted Answer · 2015-11-27 11:36:33Z

You can use array.map

 var jsonArr = [{
   amount: "2",
   club: "xyz",
   member: "tmm"
 }, {
   amount: "3",
   club: "xyz",
   member: "tsj"
 }, {
   amount: "4",
   club: "xyz",
   member: "tsj"
 }, {
   amount: "5",
   club: "ama",
   member: "vbr"
 }, {
   amount: "6",
   club: "ama",
   member: "vbr"
 }, {
   amount: "7",
   club: "crm",
   member: "vbr"
 }, {
   amount: "8",
   club: "mic",
   member: "wjr"
 }];

 function getUniqueElements(array, key) {
   // create value array
   var temp = array.map(function(item) {
     return item[key]
   });

   // remove duplicate values
   var result = temp.filter(function(item, index) {
     return temp.indexOf(item) == index;
   });

   return result;
 }

 var clubArr = getUniqueElements(jsonArr, "club");

 var memberArr = getUniqueElements(jsonArr, "member");

 console.log(clubArr, memberArr);

Przemek · Accepted Answer · 2015-11-27 11:38:04Z

0

This works for me

    var arr = [];
    for(var i = 0; i < smpMember.length; i++ ){
        arr[i] = {};
        arr[i].name = smpMember[i];
        arr[i].values = Array.apply(null, {length: smpClub.length}).map(function(){return 0;}, function(){return 0});



        for(var j = 0; j < jsonArr.length; j++ ){
            if(jsonArr[j].member === smpMember[i]){
                var index = smpClub.indexOf(jsonArr[j].club);
                arr[i].values[index] += parseInt(jsonArr[j].amount);
            }
        }

    }

I arr array you will have objects with member name and his amount array

answered Nov 27, 2015 at 11:38

Przemek

8034 silver badges15 bronze badges

Collectives™ on Stack Overflow

Create simple array from a array of objects & another simple array

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related