zero fill empty cell in data.frame
you could try something along these lines:
DF <- data.frame(V1 = c(0, 0.9, " ", 0.8, 0.1, 0),
V2 = c(0.9, " ", 0.8, 0.7, " ", 1))
DF
sapply(DF, function (x)
as.numeric(gsub("(^ +)|( +$)", "0", x)))
I hope it helps.
Best,
Dimitris
On 4/19/2011 11:39 AM, Simone Gabbriellini wrote:
Hello List, I have a data frame like: V130 V131 V132 V133 V134 V135 V136 1 0 0 0.9 0 0.9 0 0 2 0 0 0 0 0 0.8 3 0 0 0 0 0.9 0 0 4 0.9 0 0 0 0 0 0.9 5 0 0 0 6 0 0 0 0.9 0 0 0.9 7 0 0 0.8 0 0 0 0 8 0.9 0 0 0.9 0.8 0 9 0 0 0 0.9 0.9 0 0 10 0 0 0 0 0 0 0.9 I would like to fill the empty cells with a 0... how to address those empty cells? thanks for your help! best, Simone
______________________________________________ R-help at r-project.org mailing list 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.
Dimitris Rizopoulos Assistant Professor Department of Biostatistics Erasmus University Medical Center Address: PO Box 2040, 3000 CA Rotterdam, the Netherlands Tel: +31/(0)10/7043478 Fax: +31/(0)10/7043014 Web: http://www.erasmusmc.nl/biostatistiek/