Hi Val, For this particular problem, you can just replace NAs with zeros. vdat[is.na(vdat)]<-0 vdat$xy <- 2*(vdat$x1) + 5*(vdat$x2) + 3*(vdat$x3) vdat obs Year x1 x2 x3 xy 1 1 2001 25 10 10 130 2 2 2001 0 15 25 150 3 3 2001 50 10 0 150 4 4 2001 20 0 60 220
Note that this is not a general solution to the problem of NA values. Jim On Sun, Apr 14, 2019 at 12:54 PM Val <valkr...@gmail.com> wrote: > > Hi All, > I have a data frame with several columns and I want to create > another column by using the values of the other columns. My > problem is that some the row values for some columns have missing > values and I could not get the result I waned . > > Here is the sample of my data and my attempt. > > vdat<-read.table(text="obs, Year, x1, x2, x3 > 1, 2001, 25 ,10, 10 > 2, 2001, , 15, 25 > 3, 2001, 50, 10, > 4, 2001, 20, , 60",sep=",",header=TRUE,stringsAsFactors=F) > vdat$xy <- 0 > vdat$xy <- 2*(vdat$x1) + 5*(vdat$x2) + 3*(vdat$x3) > vdat > > obs Year x1 x2 x3 xy > 1 1 2001 25 10 10 130 > 2 2 2001 NA 15 25 NA > 3 3 2001 50 10 NA NA > 4 4 2001 20 NA 60 NA > > The desired result si this, > > obs Year x1 x2 x3 xy > 1 1 2001 25 10 10 130 > 2 2 2001 NA 15 25 150 > 3 3 2001 50 10 NA 150 > 4 4 2001 20 NA 60 220 > > How do I get my desired result? > Thank you > > ______________________________________________ > R-help@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. ______________________________________________ R-help@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.
