The sub_missing() function
Use exibble to create a gt table. The NA values in different columns will be given replacement text with two calls of sub_missing().
exibble |>
dplyr::select(-row, -group) |>
gt() |>
sub_missing(
columns = 1:2,
missing_text = "missing"
) |>
sub_missing(
columns = 4:7,
missing_text = "nothing"
)
| num |
char |
fctr |
date |
time |
datetime |
currency |
| 1.111e-01 |
apricot |
one |
2015-01-15 |
13:35 |
2018-01-01 02:22 |
49.950 |
| 2.222e+00 |
banana |
two |
2015-02-15 |
14:40 |
2018-02-02 14:33 |
17.950 |
| 3.333e+01 |
coconut |
three |
2015-03-15 |
15:45 |
2018-03-03 03:44 |
1.390 |
| 4.444e+02 |
durian |
four |
2015-04-15 |
16:50 |
2018-04-04 15:55 |
65100.000 |
| 5.550e+03 |
missing |
five |
2015-05-15 |
17:55 |
2018-05-05 04:00 |
1325.810 |
| missing |
fig |
six |
2015-06-15 |
nothing |
2018-06-06 16:11 |
13.255 |
| 7.770e+05 |
grapefruit |
seven |
nothing |
19:10 |
2018-07-07 05:22 |
nothing |
| 8.880e+06 |
honeydew |
eight |
2015-08-15 |
20:20 |
nothing |
0.440 |