Group by key in crossfilter data in table structure. I do not need the chart -

-

i have large set of records on 5 million. have managed pull data json using crossfilter in table structure. want group data using symbol key. appreciated.

here code

    d3.json("my_json_file.json", function(error, json_data) {         var data = crossfilter(json_data),         typedimension = stocks_jsoncs.dimension(function (d) {             return d.symbol;         });         typegroup = typedimension.group().all();         $('#stk_table').datatable({             "aadata": typedimension.top(infinity),                 "aocolumns": [{                 "mdataprop": "id"             }, {                 "mdataprop": "symbol"             }, {                 "mdataprop": "stock_name"             }, {                 "mdataprop": "changepercent"             }, {                 "mdataprop": "close"             }, {                 "mdataprop": "volume"             }]         });     });

here few content of json file:

    [{"id":"11","symbol":"01kg","stock_name":"scottish american investment co. plc","changepercent":"0","close":"125.00","volume":"0"},{"id":"63","symbol":"01kg","stock_name":"scottish american investment co. plc","changepercent":"0","close":"125.00","volume":"0"},{"id":"64","symbol":"01oo","stock_name":"nordic investment bank 5.25% nts 26\/11\/19","changepercent":"-0.532","close":"118.30","volume":"2000"},{"id":"65","symbol":"01oo","stock_name":"nordic investment bank 5.25% nts 26\/11\/19","changepercent":"-0.264","close":"118.93","volume":"6000"},{"id":"66","symbol":"01oo","stock_name":"nordic investment bank 5.25% nts 26\/11\/19","changepercent":"0.602","close":"119.25","volume":"7000"},{"id":"67","symbol":"01oo","stock_name":"nordic investment bank 5.25% nts 26\/11\/19","changepercent":"1.747","close":"118.53","volume":"3000"},{"id":"68","symbol":"01oo","stock_name":"nordic investment bank 5.25% nts 26\/11\/19","changepercent":"0","close":"116.50","volume":"10000000"},{"id":"69","symbol":"04ll","stock_name":"british land company plc","changepercent":"0","close":"115.00","volume":"0"},{"id":"132","symbol":"06gh","stock_name":"barclays bank plc 9% perm int brg cap bds #","changepercent":"0.8","close":"126.00","volume":"0"},{"id":"159","symbol":"06gh","stock_name":"barclays bank plc 9% perm int brg cap bds #","changepercent":"0.412","close":"122.00","volume":"0"},{"id":"160","symbol":"06gh","stock_name":"barclays bank plc 9% perm int brg cap bds #","changepercent":"0","close":"121.50","volume":"0"},{"id":"179","symbol":"06gh","stock_name":"barclays bank plc 9% perm int brg cap bds #","changepercent":"0","close":"119.50","volume":"0"},{"id":"180","symbol":"06gh","stock_name":"barclays bank plc 9% perm int brg cap bds #","changepercent":"-3.239","close":"119.50","volume":"6000"},{"id":"181","symbol":"06gh","stock_name":"barclays bank plc 9% perm int brg cap bds #","changepercent":"0","close":"123.50","volume":"0"},{"id":"191","symbol":"06gh","stock_name":"barclays bank plc 9% perm int brg cap bds #","changepercent":"0","close":"121.50","volume":"0"},{"id":"192","symbol":"06gh","stock_name":"barclays bank plc 9% perm int brg cap bds #","changepercent":"0","close":"121.50","volume":"0"},{"id":"193","symbol":"06gh","stock_name":"barclays bank plc 9% perm int brg cap bds #","changepercent":"0","close":"121.50","volume":"0"},{"id":"194","symbol":"06gh","stock_name":"barclays bank plc 9% perm int brg cap bds #","changepercent":"0","close":"121.50","volume":"0"},{"id":"195","symbol":"06hb","stock_name":"hemingway debenture ld","changepercent":"0","close":"130.00","volume":"0"},{"id":"228","symbol":"06hb","stock_name":"hemingway debenture ld","changepercent":"0","close":"130.00","volume":"0"}]


Comments

Post a Comment

Popular posts from this blog

node.js - Mongoose: Cast to ObjectId failed for value on newly created object after setting the value -

-
this question has answer here: what's mongoose error cast objectid failed value xxx @ path “_id”? 7 answers even though has been asked many times because entity has no valid objectid field. i came across situation objectid set value can casted objectid still error. the schema: var serviceschema = parammongoose.schema({ servicename:{ type: parammongoose.schema.types.objectid , ref: 'servicenames',required:true } }); pseudo code: servicefromdb=new service({servicename:'some name'}); servicefromdb.servicename='000000000000000000000001'; servicefromdb.save(function(paramerror,paramdata){ if(paramerror){ console.log('but but...',servicefromdb,paramerror) } }); the output of code is: but but... { servicename: 000000000000000000000001, _id: 55079a90286f49280364f78b } { [casterror: cast objectid faile...
Read more

gradle error "Cannot convert the provided notation to a File or URI" -

-
i have defined 2 system properties in gradle.properties: systemprop.builddir=build systemprop.cfgdir=build\\cfg and have following task defined in build.gradle: task clean(group:'clean',description:'clean project') << { ant.sequential { delete(dir: system.properties.builddir) mkdir(dir: system.properties.builddir) delete(dir: system.properties.cfgdir) mkdir(dir: system.properties.cfgdir) } } this generates following error: execution failed task ':clean'. > cannot convert provided notation file or uri: {dir=build}. following types/formats supported: - string or charsequence path, e.g 'src/main/java' or '/usr/include' - string or charsequence uri, e.g 'file:/usr/include' - file instance. - uri or url instance. but equivalent block of code not generate error , works expected: task clean(group:'clean',description:'clean project') << { ...
Read more

python - NameError: name 'subprocess' is not defined -

-
i'm trying make rng website: http://jamesdotcom.com/?p=417 . when run following code: captureimage = subprocess.popen( [ "fswebcam", "-r", "356x292", "-d", "/dev/video0", "static.jpg", "--skip", "10" ], stdout=devnull, stderr=devnull) captureimage.communicate() i following error message: nameerror: name 'subprocess' not defined what should do? thanks have imported first? import subprocess captureimage = subprocess.popen(["fswebcam", ...) subprocess included in python standard library since python 2.4. should not necessary install it.
Read more