replace -inf with 0 in data

[Marwah Soliman]

hello,

I have data set about gene expression I discovered that there was some -inf in the data
I need to replace them with zero
my data is 390989 rows * 1000 column

here is a row from my data (part of it)

A1BG 0 0 5.604860 4.487620 5.545700 -inf

I need to get

A1BG 0 0 5.604860 4.487620 5.545700 0

note: I don't know where the location of the -inf value as it is a huge data set
so I can't select certain column and then replace it with zero

 

[staassis]

If M is a matrix or data frame with your data, then you do

> M[M == -Inf] <- 0

(in R or R Studio).