Number of significant digits in dplyr summarise

by

Because you are using dplyr tools, the resulting output is actually a tibble, which by default prints numbers with 3 significant digits (see option pillar.sigfig). This is not the same as number of digits after the period. To obtain the latter, convert it simply to a data.frame: as.data.frame

Note that tibble’s concept of significant digits is somehow complicated, and does not indicate how many digits after the period are represented, but the minimum number of digits necessary to have a given accurate representation of the number (I think 99.9%, see discussion here).

This means the number of digits printed depends on the “size” of your number:

library(tibble)
packageVersion("tibble")
#> [1] '2.1.3'
packageVersion("pillar")
#> [1] '1.4.2'
tab <- tibble(x = c(0.1234, 1.1234, 10.1234, 100.1234, 1000.1234))

options(pillar.sigfig=3)
tab
#> # A tibble: 5 x 1
#>          x
#>      <dbl>
#> 1    0.123
#> 2    1.12 
#> 3   10.1  
#> 4  100.   
#> 5 1000.

options(pillar.sigfig=4)
tab
#> # A tibble: 5 x 1
#>           x
#>       <dbl>
#> 1    0.1234
#> 2    1.123 
#> 3   10.12  
#> 4  100.1   
#> 5 1000.

as.data.frame(tab)
#>           x
#> 1    0.1234
#> 2    1.1234
#> 3   10.1234
#> 4  100.1234
#> 5 1000.1234

Created on 2019-08-21 by the reprex package (v0.3.0)

More Related Contents:

  1. Use dynamic name for new column/variable in `dplyr`
  2. data.table vs dplyr: can one do something well the other can’t or does poorly?
  3. Extract a dplyr tbl column as a vector
  4. Pass arguments to dplyr functions
  5. dplyr::select function clashes with MASS::select
  6. Sum across multiple columns with dplyr
  7. dplyr: nonstandard column names (white space, punctuation, starts with numbers)
  8. dplyr filter: Get rows with minimum of variable, but only the first if multiple minima
  9. dplyr mutate/replace several columns on a subset of rows
  10. dplyr: How to use group_by inside a function?
  11. case_when in mutate pipe
  12. Summarize all group values and a conditional subset in the same call
  13. Concatenate unique strings after groupby in R
  14. ignore NA in dplyr row sum
  15. How to select last N observation from each group in dplyr dataframe?
  16. mutate function is not updating
  17. Use filter in dplyr conditional on an if statement in R
  18. How to do range grouping on a column using dplyr?
  19. combine two data frames with all posible combinations
  20. dplyr / R cumulative sum with reset
  21. finding close match from data frame 1 in data fame 2
  22. R: How to filter/subset a sequence of dates
  23. Add a column with count of NAs and Mean
  24. select columns based on multiple strings with dplyr contains()
  25. grouped operations that result in length not equal to 1 or length of group in dplyr
  26. Error with select function from dplyr
  27. dplyr: put count occurrences into new variable [duplicate]
  28. Add row in each group using dplyr and add_row()
  29. How to replace certain values in a specific rows and columns with NA in R?
  30. Add margin row totals in dplyr chain

Leave a Comment