Replace -Inf in dataframe with NA in R

Question

I have a problem in my dataframe.

I have several values with -Inf entries. When I want to use the cor-function, I always get NA because of that. So I want to replace the -Inf with NA before I use the cor-function, but I cant find a way to replace them successfully.

I tried

dat[mapply(is.infinite, dat)] <- NA

but it did not work.

Any ideas how to solve this?

Do not use external files. Cut your file down to a small size and include it in the question itself. — G. Grothendieck, May 08 '19 at 13:00

score 12 · Accepted Answer · answered May 08 '19 at 12:53

12

We need to do

dat[] <- Map(function(x) replace(x, is.infinite(x), NA), dat)

Or with lapply

dat[sapply(dat, is.infinite)] <- NA

answered May 08 '19 at 12:53

akrun

789,025
32
460
575

Replace -Inf in dataframe with NA in R

1 Answers1