[R] Handling "NA" in summation
ce
zadig_1 at excite.com
Mon Sep 7 01:30:36 CEST 2015
Sorry I misunderstood questions .
I think original poster wants result to be 0 , right ?
Then
dataframe$A[ is.na(dataframe$B) ] <- 0
dataframe$B[ is.na(dataframe$B) ] <- 0
is this case you would lose dataframe$A data or
dataframe$A + ( dataframe$B[ is.na(dataframe$B) ] <- -1*dataframe$A )
-----Original Message-----
From: "Sarah Goslee" [sarah.goslee at gmail.com]
Date: 09/06/2015 07:00 PM
CC: "r-help" <r-help at r-project.org>
Subject: Re: [R] Handling "NA" in summation
I'm not quite sure how you get zero from that situation. Do you expect
the answer to be 20?
How about:
> dataframe <- data.frame(A=20, B=NA)
> dataframe$A + dataframe$B
[1] NA
> ?sum
> sum(dataframe$A, dataframe$B, na.rm=TRUE)
[1] 20
Sarah
On Sun, Sep 6, 2015 at 6:48 PM, ce <zadig_1 at excite.com> wrote:
>
>
> I use something like :
>
> dataframe[ is.na(dataframe) ] <- 0
> dataframe[ is.nan(dataframe) ] <- 0
> dataframe[ is.infinite(dataframe) ] <- 0
>
> -----Original Message-----
> From: "Olu Ola via R-help" [r-help at r-project.org]
> Date: 09/06/2015 06:24 PM
> To: r-help at r-project.org
> Subject: [R] Handling "NA" in summation
>
> Hello,
> I am currently working with a dataframe which has some missing values represented by "NA". whenever, I add two columns in which at least one of the pair of an observation is "NA", the sum returns zero. That is for the same observation, if
>
> dataframe$A = 20
> dataframe$B = NA
>
> dataframe$A + dataframe$B returns zero.
>
> I do not want to delete the observations with the NA's. How do I go about carrying out the necessary operations without deleting the observations with the NA's
>
> Thank you
>
--
Sarah Goslee
http://www.functionaldiversity.org
______________________________________________
R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
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