Comments (3)
Unfortunately I think this is just a natural consequence of floating point imprecision. (I couldn't reproduce DT::datatable(signif(data.frame(3.23e-127), 3))
looking "correct"--on my machine it looked the same as the first case.)
> print(signif(3.23e-127, 3), digits=16)
[1] 3.229999999999999e-127
R defaults to precision of digits=7
when printing, while htmlwidgets defaults to digits=16
when serializing to the browser. The idea in theory is that the value should be transmitted with max precision, but when actually displayed in the web page you can use less precision. Unfortunately I can't think of a single htmlwidget that goes out of its way to display with fewer digits.
I don't know if it's a good idea to do so, but you can use options(shiny.json.digits = xxx)
to set the precision to whatever you want. This gets passed to the jsonlite::toJSON()
function's digits
argument.
from dt.
I see, thanks for the response. The strange thing, it doesn't happen when directly running DT::datatable(signif(data.frame(3.23e-127), 3))
. Anyway, I switched to using %>% DT::formatSignif(...
which solves my issue.
from dt.
I think this is a problem on htmltools or htmlwidgets's side. The data is correct on DT's side:
> x = DT::datatable(signif(data.frame(3.234866680561728e-127), 3))
> str(x)
List of 8
$ x :List of 6
..$ filter : chr "none"
..$ vertical : logi FALSE
..$ data :'data.frame': 1 obs. of 2 variables:
.. ..$ : chr "1"
.. ..$ X3.23486668056173e.127: num 3.23e-127
[...]
but 3.23e-127
is converted to 3.229999999999999e-127
when the widget is rendered to HTML:
> str(htmlwidgets:::toHTML(x))
List of 3
$ :List of 3
..$ : NULL
..$ :List of 3
.. ..$ name : chr "div"
[...]
$ :List of 3
..$ name : chr "script"
..$ attribs :List of 2
.. ..$ type : chr "application/json"
.. ..$ data-for: chr "htmlwidget-6b6194a1b92c04b274c8"
..$ children:List of 1
.. ..$ : 'html' chr "{\"x\":{\"filter\":\"none\",\"vertical\":false,\"data\":[[\"1\"],[3.229999999999999e-127]],\"container\":\"<tab"| __truncated__
.. .. ..- attr(*, "html")= logi TRUE
from dt.
Related Issues (20)
- Selection of multiple levels HOT 2
- [Accessibility] Trigger custom row select from Javascript callback HOT 11
- R shiny DT table with pagination and drop down list inside table and being able to save the entire updated table as csv file HOT 5
- DT 0.31 breaks previous 'ignore colnames' behavior during `replaceData()` HOT 1
- RowGroup extension with rownames = TRUE HOT 6
- updateSearch does not update numeric slider values
- datatable column filters clash with shiny::selectizeInput when invoked first HOT 4
- DateTime date picker CSS is broken in SearchBuilder
- Disabling editable table by row (and not just by column)
- autoFill extension returns `NaN` instead of incrementing HOT 5
- Docs do not state whether shift+click works for multi-row selection
- #828 breaks maintaining selected columns upon re-render HOT 3
- `renderDT()` evaluates `...` in `expr`'s `env`
- Unable to test `renderDT()` in a `MockShinySession`
- First option entry ignored for default search values per column HOT 3
- "locked" proxy structure not accommodating new data HOT 4
- Extract search functionality
- upgrade to datatables v2 HOT 2
- R Shiny application designed to navigate through multiple sections within a single page
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from dt.