jupyter / declarativewidgets

[RETIRED] Jupyter Declarative Widget Extension
http://jupyter.org/declarativewidgets/docs.html
Other
120 stars 38 forks source link

Changing DataFrame Limit #558

Open vkhombal opened 7 years ago

vkhombal commented 7 years ago

I'm trying to use the dataframe and table combination to use as a data selector. The sdf has 16000 rows. I tried to set the limit to dataframe but it seems to cut-off at 200 rows.

%%html
<template is="dom-bind">
    <urth-core-dataframe id="f1" ref="sdf" value="{{df}}" limit="2000"></urth-core-dataframe>
    <urth-core-function id="f1a" ref="show_rep" arg-idx="{{sel.2}}" auto></urth-core-function>
    <urth-viz-table datarows="{{ df.data }}" selection="{{sel}}" columns="{{ df.columns }}">
    </urth-viz-table>
</template>

Then on the javascript console

> f1.value.data.length
< 200

Am i doing this right?

lbustelo commented 7 years ago

That looks fine to me. Print out f1.limit to verify that it is set to 2000.

On May 9, 2017, at 1:47 PM, vkhombal notifications@github.com wrote:

I'm trying to use the dataframe and table combination to use as a data selector. The sdf has 16000 rows. I tried to set the limit to dataframe but it seems to cut-off at 200 rows.

%%html

Then on the javascript console

f1.value.data.length < 200 Am i doing this right?

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub, or mute the thread.

vkhombal commented 7 years ago

Thanks Bustelo, f1.limit is set to 2000. I had to close the tab and open again, and i even get this warning from handsontable.

handsontable.full.js?v=20170509120655:3581 Performance tip: Handsontable rendered more than 1000 visible rows. Consider limiting the number of rendered rows by specifying the table height and/or turning off the "renderAllRows" option.

Is the pagination feature of the handsontable exposed?

lbustelo commented 7 years ago

I thought handson would use a virtual paging of rows. Other than that, there is no pagination support on the dataframe element. All the data within the limit will be sent to the browser at once.