Change negative values in dataframe column to absolute value

Question

I have a data.frame like this:

    Col1   Col2   Col3   Col4      Col5      Col6
1   1982      0      0   -211       107         0
2   4412      0    989      0       296         0
3      0  -5051      0   -267       389       920
4      0  -2983      0   -215         0      1639
5      0  -1326      0   -861         0         0
6   3722      0     89      0       243     13349

How can I change the negative values to their absolute values?

Answer 1

abs(dat)

where dat is the name of your data frame.

Answer 2

You can just do something like the following (assuming your original data.frame is called "mydf"):

mydf[] <- lapply(mydf, abs)
mydf
#   Col1 Col2 Col3 Col4 Col5  Col6
# 1 1982    0    0  211  107     0
# 2 4412    0  989    0  296     0
# 3    0 5051    0  267  389   920
# 4    0 2983    0  215    0  1639
# 5    0 1326    0  861    0     0
# 6 3722    0   89    0  243 13349

Answer 3

If you have a dataframe that consists of a mix of both numeric and character columns:

#dataframe is your original dataframe. 

abs.dat <- data.frame %>% 
  dplyr::select(where(is.numeric)) %>%
  abs()

Only select numeric columns.