[R] converting null to some values

Bill.Venables at csiro.au Bill.Venables at csiro.au
Wed Mar 18 00:45:06 CET 2009


> temp
   type1 type2  a  b  c
1   male   low  1  5  0
2 female   med  2 NA  0
3   male  high  4  5  1
4 female   low NA  1  1
5 female   med  3  2 NA

> temp[is.na(temp)] <- 0  ## the magic words...

> temp
   type1 type2 a b c
1   male   low 1 5 0
2 female   med 2 0 0
3   male  high 4 5 1
4 female   low 0 1 1
5 female   med 3 2 0
> 

You are in a spot of bother, though, if your factors have missing values also.


Bill Venables
http://www.cmis.csiro.au/bill.venables/ 


-----Original Message-----
From: r-help-bounces at r-project.org [mailto:r-help-bounces at r-project.org] On Behalf Of Ferry
Sent: Wednesday, 18 March 2009 9:29 AM
To: r-help at r-project.org
Subject: [R] converting null to some values

Hi,

I have newbie question. Suppose I have the following data:

temp <- data.frame(type1 = c("male", "female", "male", "female", "female"),
type2 = c("low", "med", "high", "low", "med"), a = c(1,2,4, NA, 3), b =
 .... [TRUNCATED]

temp
   type1 type2  a  b  c
1   male   low  1  5  0
2 female   med  2 NA  0
3   male  high  4  5  1
4 female   low NA  1  1
5 female   med  3  2 NA

how to change all NA into 0 (zero) ? so I would have the following:

temp
   type1 type2  a  b  c
1   male   low  1  5  0
2 female   med  2  0  0
3   male  high  4  5  1
4 female   low  0  1  1
5 female   med  3  2  0

I've been trying with which() but without success.

Any pointer is appreciated.

Thank you,

Ferry

	[[alternative HTML version deleted]]

______________________________________________
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.




More information about the R-help mailing list