Re: [R] summing columns with NAs present

2011-08-05 Thread Jorge Ivan Velez
Try test$Sum <- rowSums(test, na.rm = TRUE) test HTH, Jorge On Fri, Aug 5, 2011 at 2:01 PM, Dimitri Liakhovitski <> wrote: > Hello! > > I have a data frame with some NAs. > test<-data.frame(a=c(1,2,NA),b=c(10,NA,20)) > > I need to sum up values in 2 variables. However: > test$a+test$b > procud

Re: [R] summing columns with NAs present

2011-08-05 Thread Dimitri Liakhovitski
Sorry, never mind - I have to use rowSums with na.rm=T Dimitri On Fri, Aug 5, 2011 at 2:01 PM, Dimitri Liakhovitski wrote: > Hello! > > I have a data frame with some NAs. > test<-data.frame(a=c(1,2,NA),b=c(10,NA,20)) > > I need to sum up values in 2 variables. However: > test$a+test$b > procudes

[R] summing columns with NAs present

2011-08-05 Thread Dimitri Liakhovitski
Hello! I have a data frame with some NAs. test<-data.frame(a=c(1,2,NA),b=c(10,NA,20)) I need to sum up values in 2 variables. However: test$a+test$b procudes NAs in rows that have NAs. How could I sum up columns while ignoring NAs (the way the function sum(..., na.rm=T) works? Thank you! -- Dim