javascript - Count No.of unique attribute occurances with respect to another attribute in Array of objects -

-

in below data set, want count number of akey respect each bkey. such every bkey how many unique akey there. if akey occurred bkey should not counted.

var fdata2 = [   {sex: 'male', bkey: '121', userkey: '04', akey: '6e5fdb09-319f-4640-b241-2b12d350c027', date: 'fri jul 01 06:26:59 utc 2016', freq: 20, preferencelist: ['fashion','business','sports'], agegroup: 'less_than_15'},   {sex: 'male', bkey: '122', userkey: '01', akey: '6e5fdb09-319f-4640-b241-2b12d350c027', date: 'fri jul 01 11:59:28 utc 2016', freq: 22, preferencelist: ['business'], agegroup: 'between_25_35'},   {sex: 'female', bkey: '123', userkey: '01', akey: '6e5fdb09-319f-4640-b241-2b12d350c027', date: 'thu jun 30 11:59:28 utc 2016', freq: 26, preferencelist: ['housing'], agegroup: 'between_35_45'},   {sex: 'male', bkey: '121', userkey: '03', akey: '4a73c208-43a8-49d2-87ba-f44691786c96', date: 'fri jul 01 06:26:59 utc 2016', freq: 38, preferencelist: ['business','housing','sports'], agegroup: 'between_25_35'},   {sex: 'female', bkey: '124', userkey: '03', akey: '4a73c208-43a8-49d2-87ba-f44691786c96', date: 'fri jul 01 11:59:28 utc 2016', freq: 20, preferencelist: ['business','housing','sports'], agegroup: 'between_45_55'},   {sex: 'male', bkey: '125', userkey: '01', akey: '4a73c208-43a8-49d2-87ba-f44691786c96', date: 'fri jul 01 11:59:28 utc 2016', freq: 42, preferencelist: ['jewels','kids'], agegroup: 'less_than_15'},   {sex: 'female', bkey: '123', userkey: '02', akey: '4a73c208-43a8-49d2-87ba-f44691786c96', date: 'fri jul 01 06:26:59 utc 2016', freq: 34, preferencelist: ['movies'], agegroup: 'between_55_65'},   {sex: 'female', bkey: '121', userkey: '03', akey: '4a73c208-43a8-49d2-87ba-f44691786c96', date: 'fri jul 01 06:26:59 utc 2016', freq: 22, preferencelist: ['culture'], agegroup: 'between_25_35'},   {sex: 'female', bkey: '124', userkey: '01', akey: '4a73c208-43a8-49d2-87ba-f44691786c96', date: 'fri jul 01 11:59:28 utc 2016', freq: 115, preferencelist: ['kids'], agegroup: 'between_35_45'},   {sex: 'male', bkey: '122', userkey: '02', akey: '09a703f3-2273-4b25-ba33-24572ffcdf89', date: 'thu jun 30 11:59:28 utc 2016', freq: 19, preferencelist: [], agegroup: 'between_45_55'},   {sex: 'female', bkey: '121',userkey: '01', akey: '09a703f3-2273-4b25-ba33-24572ffcdf89', date: 'thu jun 30 06:26:59 utc 2016', freq: 24, preferencelist: [], agegroup: 'between_35_45'} ];

i want result in new array of objects 

[ {121: 3},{122: 2},{123: 2},{124: 2},{125: 1} ]

i trying - 

var dataset = {}; fdata2.foreach(function (item) {   dataset[ item.bkey ] = (dataset[ item.akey ] || 0) + 1; });  console.log(dataset);

you can foreach loop , object optional parameter

var data = [{"sex":"male","bkey":"121","userkey":"04","akey":"6e5fdb09-319f-4640-b241-2b12d350c027","date":"fri jul 01 06:26:59 utc 2016","freq":20,"preferencelist":["fashion","business","sports"],"agegroup":"less_than_15"},{"sex":"male","bkey":"122","userkey":"01","akey":"6e5fdb09-319f-4640-b241-2b12d350c027","date":"fri jul 01 11:59:28 utc 2016","freq":22,"preferencelist":["business"],"agegroup":"between_25_35"},{"sex":"female","bkey":"123","userkey":"01","akey":"6e5fdb09-319f-4640-b241-2b12d350c027","date":"thu jun 30 11:59:28 utc 2016","freq":26,"preferencelist":["housing"],"agegroup":"between_35_45"},{"sex":"male","bkey":"121","userkey":"03","akey":"4a73c208-43a8-49d2-87ba-f44691786c96","date":"fri jul 01 06:26:59 utc 2016","freq":38,"preferencelist":["business","housing","sports"],"agegroup":"between_25_35"},{"sex":"female","bkey":"124","userkey":"03","akey":"4a73c208-43a8-49d2-87ba-f44691786c96","date":"fri jul 01 11:59:28 utc 2016","freq":20,"preferencelist":["business","housing","sports"],"agegroup":"between_45_55"},{"sex":"male","bkey":"125","userkey":"01","akey":"4a73c208-43a8-49d2-87ba-f44691786c96","date":"fri jul 01 11:59:28 utc 2016","freq":42,"preferencelist":["jewels","kids"],"agegroup":"less_than_15"},{"sex":"female","bkey":"123","userkey":"02","akey":"4a73c208-43a8-49d2-87ba-f44691786c96","date":"fri jul 01 06:26:59 utc 2016","freq":34,"preferencelist":["movies"],"agegroup":"between_55_65"},{"sex":"female","bkey":"121","userkey":"03","akey":"4a73c208-43a8-49d2-87ba-f44691786c96","date":"fri jul 01 06:26:59 utc 2016","freq":22,"preferencelist":["culture"],"agegroup":"between_25_35"},{"sex":"female","bkey":"124","userkey":"01","akey":"4a73c208-43a8-49d2-87ba-f44691786c96","date":"fri jul 01 11:59:28 utc 2016","freq":115,"preferencelist":["kids"],"agegroup":"between_35_45"},{"sex":"male","bkey":"122","userkey":"02","akey":"09a703f3-2273-4b25-ba33-24572ffcdf89","date":"thu jun 30 11:59:28 utc 2016","freq":19,"preferencelist":[],"agegroup":"between_45_55"},{"sex":"female","bkey":"121","userkey":"01","akey":"09a703f3-2273-4b25-ba33-24572ffcdf89","date":"thu jun 30 06:26:59 utc 2016","freq":24,"preferencelist":[],"agegroup":"between_35_45"}]  var result = {}    data.foreach(function(e) {    if(!this[e.bkey + e.akey]) {      this[e.bkey + e.akey] = true;      result[e.bkey] = (result[e.bkey] || 0) +1 ;    }  }, {})    console.log(result)


Comments

Post a Comment

Popular posts from this blog

matlab - error with cyclic autocorrelation function -

-
Image
i'm trying code cyclic autocorrelation function in matlab follows: t=0:(n-1); t=t*te; i_alpha=0; tau=-n2*te:te:n2*te; alpha=-1/2:1/n:1/2; ryy_cl=zeros(length(alpha),length(tau)); alpha=alpha/te ind_tau=0; i_alpha=i_alpha+1; k=tau ind_tau=ind_tau+1; if k>0 % ryy_cl(i_alpha,ind_tau)=1/length(sig_bin_syl_mod(1:end- k))*sum((sig_bin_syl_mod(1:end-k)).*sig_bin_syl_mod(k+1:end)).*exp(1i*2*pi*alpha*t(1+k:length(sig_bin_syl_mod(1:end)))); ryy_cl(i_alpha,ind_tau)=(1/n)*sum((sig_bin_syl_mod(1:end-k)).*sig_bin_syl_mod(k+1:end)).*exp(-1i*2*pi*alpha*t(1:end-k)); else ryy_cl(i_alpha,ind_tau)=(1/n)*sum((sig_bin_syl_mod(1-k:end)).*sig_bin_syl_mod(1:end+k)).*exp(-1i*2*pi*alpha*t(1-k:end)); end end end i'm getting errors, , doesn't show expecting. according below formulae, how can fix it? the code provided incomplete, difficult confidently reproduce error. in particular, haven't de...
Read more

django - (fields.E300) Field defines a relation with model 'AbstractEmailUser' which is either not installed, or is abstract -

-
i trying create customuser django project email username , add radio button truck , company. in registration process email-id registered per truck or company. mentioned radio button 'tag' , add manytomany field tag in emailuser model. when makemigrations, raising error : (fields.e300) field defines relation model 'abstractemailuser' either not installed, or abstract. i quite new django , not sure whether have created correct code wants. please me solving this. here code, models.py: import django django.contrib.auth.models import ( abstractbaseuser, baseusermanager, permissionsmixin) django.core.mail import send_mail django.db import models django.utils import timezone django.utils.translation import ugettext_lazy _ class emailusermanager(baseusermanager): """custom manager emailuser.""" def _create_user(self, email, password, is_staff, is_superuser, **extra_fields): """create , save emailus...
Read more

c# - What is a good .Net RefEdit control to use with ExcelDna? -

-
i using exceldna , c# build suite of tools. part of forms i'd want user select cells/ranges workbook. i've got application.inputbox route working...but doesn't cool... i haven't read many things excel's refedit control, , see many have in past written workarounds, in (shudder) vba or vb.net. however, none of these seem recent... best approach/control refedit functionality on form run via exceldna (if applicable)? the refedit sample project of github explores different ways of dealing threading when showing form excel add-in, main issue making refedit control .net add-in. check page links various other implementations: https://github.com/excel-dna/exceldna/wiki/links-about-refedit
Read more