javascript - dc.js - Selecting Columns in csv to Render Chart -

-

so assume have .csv formatted this:

agegroup    state    gender    score1    bin1     score2    bin2  18-25        tx       f        .15        1       .20       3   18-25        fl       f        .34        4       .11       7   65+         ca       m        .72        3       .33       9  46-54        tx       m        .90        6       .08       1  46-54        tx       f        .15        1       .11       7

right now, can create 2 bar charts columns, bin1 , bin2. have display sum score1 , score2.

however, add more scores , bins, don't want create more , more bar charts , displays each column added. if new csv looks this:

agegroup    state    gender    score1    bin1     score2    bin2   score3    bin3    score4    bin4  18-25        tx       f        .15        1       .20       3      .51       2       .23       6  18-25        fl       f        .34        4       .11       7      .79       1       .64       4   65+         ca       m        .72        3       .33       9      .84       7       .55       3  46-54        tx       m        .90        6       .08       1      .15       2       .47       5  46-54        tx       f        .15        1       .11       7      .76       8       .09       8

is there way can create drop-down or tell dc.js columns (in case, bin1 through bin4) create charts off of , have display reactive display correct sums?

you can update group on chart , render it. 

var groups = {   bin1: dim.group().reducesum(function(d) {     return d.bin1;   }),   bin2: dim.group().reducesum(function(d) {     return d.bin2;   }) };  var chart = dc.barchart("#chart")   .width(400)   .height(200)   .x(d3.scale.linear().domain([1, 4]))   .dimension(dim)   .group(groups.bin1);  chart.render();  function changebin (binnum) {   chart.group(groups[binnum]);   chart.render(); }

and working example using 2 buttons:

var data = [{    x: 1,    bin1: 90,    bin2: 10    }, {    x: 2,    bin1: 20,    bin2: 20    }, {    x: 3,    bin1: 50,    bin2: 30    }, {    x: 4,    bin1: 100,    bin2: 40    }];  var cf = crossfilter(data);    var dim = cf.dimension(function(d) {    return d.x;  });    var groups = {    bin1: dim.group().reducesum(function(d) {      return d.bin1;    }),    bin2: dim.group().reducesum(function(d) {      return d.bin2;    })  };    var chart = dc.barchart("#chart")    .width(400)    .height(200)    .x(d3.scale.linear().domain([1, 4]))    .dimension(dim)    .group(groups.bin1);    chart.render();    function changebin (binnum) {    chart.group(groups[binnum]);    chart.render();  }
<link href="https://cdnjs.cloudflare.com/ajax/libs/dc/1.7.3/dc.min.css" rel="stylesheet" />  <script src="https://cdnjs.cloudflare.com/ajax/libs/d3/3.2.0/d3.min.js"></script>  <script src="https://cdnjs.cloudflare.com/ajax/libs/crossfilter/1.3.11/crossfilter.min.js"></script>    <script src="https://cdnjs.cloudflare.com/ajax/libs/dc/1.7.3/dc.js"></script>    <div id="chart"></div>  <button onclick="changebin('bin1');">bin 1</button>  <button onclick="changebin('bin2');">bin 2</button>


Comments

Post a Comment

Popular posts from this blog

PHP DOM loadHTML() method unusual warning -

-
i had following code works fine on localhost: $document = new domdocument(); $document->loadhtml($p_result); $form = $document->getelementsbytagname('form')->item(0); // code continues using $form variable after same code updated on outside server, loadhtml() failed , issued warning. warning: domdocument::loadhtml() expects parameter 1 valid path, string given in path/name/to/script.php returned null instead of object code pretty gets fatal error. note contents of $p_result absolutely same on outside server , on localhost. but why displays kind of warning , why not work? doesn't loadhtml() expects argument 1 string in first place? why method expects parameter 1 valid path ? just make clear i'm not calling loadhtmlfile() , i'm calling loadhtml() . thanks. you're affected one of php bugs . issue present in php 5.6.8 , 5.6.9. have affected php version on server, , bug-free version on localhost. the bug forbids null
Read more

python - How to create jsonb index using GIN on SQLAlchemy? -

-
here's current code creating index jsonb. index("mytable_data_idx_id_key", mytable.data['id'].astext, postgresql_using='gin') but got error. sqlalchemy.exc.programmingerror: (psycopg2.programmingerror) data type text has no default operator class access method "gin" hint: must specify operator class index or define default operator class data type. [sql: "create index event_data_idx_id_key on event using gin ((data ->> 'id'))"] is there way create index on sqlalchemy? the postgresql specific sqlalchemy docs @ http://docs.sqlalchemy.org/en/latest/dialects/postgresql.html#operator-classes mention postgresql_ops dictionary provide "operator class" used postgresql, , provide example illustrating use: index('my_index', my_table.c.id, my_table.c.data, postgresql_ops={ 'data': 'text_pattern_ops',
Read more

c# - TransactionScope not rolling back although no complete() is called -

-
i'm using transactionscope rollback transaction fail bool errorreported = false; action<importerrorlog> newerrorcallback = e => { errorreported = true; errorcallback(e); }; using (var transaction = new transactionscope()) { foreach (importtaskdefinition task in taskdefinition) { loader.load(streamfile, newerrorcallback, task.destinationtable, processingtaskid); } if (!errorreported) transaction.complete(); } i'm sure there no transactionscope started ahead or after code. i'm using entity framework insert in db. regardless state of errorreported transaction never rolled in case of error. what missing ? transactionscope sets transaction.current . that's does. wants transacted must @ property. i believe ef each time connection opened reason. probably, connection open when scope installed. open connection inside of scope or enlist manually. ef has nasty "design decision": default opens
Read more