Re: [R] zero fill empty cell in data.frame

From: Dimitris Rizopoulos <d.rizopoulos_at_erasmusmc.nl>
Date: Tue, 19 Apr 2011 11:51:37 +0200

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/

______________________________________________
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.
Received on Tue 19 Apr 2011 - 09:53:23 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Tue 19 Apr 2011 - 10:10:32 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive