replace -inf with 0 in data

#1
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
 
Last edited: