How to round numbers in a tibble column with dplyr::mutate

Question

I have the following tibble:

library(tidyverse)
tb <- structure(list(V2 = structure(c(2L, 1L, 4L, 3L, 2L, 1L, 4L, 3L
), .Label = c("bar", "foo", "gop", "qux"), class = "factor"), 
    V3m = c(9.394981, 6.826405, 1.074885, 1.493691, 1e-04, 2e-04, 
    3e-04, 4e-04)), class = c("tbl_df", "tbl", "data.frame"), row.names = c(NA, 
-8L), .Names = c("V2", "V3m"))

Which looks like this:

> tb
# A tibble: 8 × 2
      V2      V3m
  <fctr>    <dbl>
1    foo 9.394981
2    bar 6.826405
3    qux 1.074885
4    gop 1.493691
5    foo 0.000100
6    bar 0.000200
7    qux 0.000300
8    gop 0.000400

How can I round V3m column to 2 digits? I tried this but failed:

tb %>% mutate(V3mR=format(V3m,2))

Do we want to round it or show only X amount of digits? – zx8754 Apr 18 '17 at 07:15 — zx8754, Apr 18 '17 at 07:15
@zx8754 `9.394981` to `9.39` and `0.000100` to `0.00` – neversaint Apr 18 '17 at 07:16 — neversaint, Apr 18 '17 at 07:16
`tb %>% mutate(V3mR=round(V3m,2))` – Adam Quek Apr 18 '17 at 07:17 — Adam Quek, Apr 18 '17 at 07:17
@AdamQuek I don't think they want `round`. – zx8754 Apr 18 '17 at 07:22 — zx8754, Apr 18 '17 at 07:22
`tb %>% mutate(V3mR=formatC(V3m, format="f", digits=2))`? – chinsoon12 Apr 18 '17 at 07:27 — chinsoon12, Apr 18 '17 at 07:27

score 8 · Answer 1 · edited Jun 20 '20 at 09:12

We can use sprintf

tb %>% 
   mutate(V3mr = sprintf("%0.2f", V3m))

Using a reproducible example (edited by @Eric Fail)

titanic_4
# A tibble: 6 x 1
#   perc_survived
#           <dbl>
#1      50.00000
#2     100.00000
#3      97.14286
#4      44.44444
#5     100.00000
#6      19.23077

titanic_4 <- titanic_4 %>% 
               mutate(perc_survived_6 = sprintf("%0.6f", perc_survived))
titanic_4
# A tibble: 6 x 2
#   perc_survived perc_survived_6
#           <dbl>           <chr>
#1      50.00000       50.000000
#2     100.00000      100.000000
#3      97.14286       97.142857
#4      44.44444       44.444444
#5     100.00000      100.000000
#6      19.23077       19.230769

data

titanic_4 <- tibble(perc_survived = c(50.000000,
          100.000000, 97.142857, 44.444444, 100.000000, 19.230769))

How to round numbers in a tibble column with dplyr::mutate

1 Answers1

data