How to globally convert NaN to NA in dataframe?
Hi what about data[sapply(data, is.nan)] <- NA Cheers Petr
-----Original Message----- From: R-help <r-help-bounces at r-project.org> On Behalf Of Luigi Marongiu Sent: Thursday, September 2, 2021 3:18 PM To: r-help <r-help at r-project.org> Subject: [R] How to globally convert NaN to NA in dataframe? Hello, I have some NaN values in some elements of a dataframe that I would like
to
convert to NA. The command `df1$col[is.nan(df1$col)]<-NA` allows to work column-wise. Is there an alternative for the global modification at once of all
instances?
I have seen from https://stackoverflow.com/questions/18142117/how-to-replace-nan-value- with-zero-in-a-huge-data-frame/18143097#18143097 that once could use: ``` is.nan.data.frame <- function(x) do.call(cbind, lapply(x, is.nan)) data123[is.nan(data123)] <- 0 ``` replacing o with NA, but I got ``` str(df)
logi NA
``` when modifying my dataframe df. What would be the correct syntax? Thank you -- Best regards, Luigi
______________________________________________ R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting- guide.html and provide commented, minimal, self-contained, reproducible code.