no sci format of very small numbers

[mkapplebee]

I am very new to R markdown, but I am trying to write a report with it in HTML format with tables. Some of my tables include pvalues, some of which are very small - so the exponent associated with them is important. I would like to use knitr/kable, but my padj values are only showing as "0". Here is some code with a modified 'iris' table that shows the problem - compare column 'sml' between the kable version and regular "print" version -

library(knitr)
options(scipen=-20)
sml<-iris[,1]*10^-12  #these are very small, but not 0
lrg<-iris[,2]*10^12  # these are analogously large
y<-cbind(sml,lrg,iris[,3:5])

kable(y[1:10,])    #sml is converted to 0, in scientific format, but lrg retains its correct reported value
y[1:10,]              # sml is correctly reported in scientific format

screenshot of the output I get:

I am using R 3.2.3, Rstudio Version 0.99.451, and I just checked that I have the latest update to knitr - but I still get this problem.

[yihui]

That is because the numbers are rounded to 7 decimal places by default. You can use a larger digits value, e.g.

kable(y[1:10,], digits = 20)

But I think a P-value as small as 10^-12 is basically 0.

[github-actions]

This old thread has been automatically locked. If you think you have found something related to this, please open a new issue by following the issue guide (https://yihui.org/issue/), and link to this old issue if necessary.