Hi, I'm trying to replace all values equal to 1 in one file (a) with the value in the corresponding column in a separate file (b). Example below. Any help (and brief notes if poss) much appreciated. Thanks!! file a: 0,0,1,1,0 1,0,0,0,1 0,0,0,0,0 1,0,1,1,0 file b: 3,4,6,8,11 output request: 0,0,6,8,0 3,0,0,0,11 0,0,0,0,0 3,0,6,8,0 -- View this message in context: r.789695.n4.nabble.com/Replace-query-tp2122706p2122706.html Sent from the R help mailing list archive at Nabble.com.
The following code might work: a[a==1] <- b[a==1] But it depends on what a and b are exactly (vector, matrix, list, data.frame). Tal ----------------Contact Details:------------------------------------------------------- Contact me: Tal.Galili@gmail.com | 972-52-7275845 Read me: talgalili.com (Hebrew) | biostatistics.co.il (Hebrew) | r-statistics.com (English) ---------------------------------------------------------------------------------------------- On Sun, May 2, 2010 at 2:01 PM, burgundy <sauburn@yahoo.com> wrote:> > Hi, > > I'm trying to replace all values equal to 1 in one file (a) with the value > in the corresponding column in a separate file (b). Example below. > Any help (and brief notes if poss) much appreciated. Thanks!! > > file a: > 0,0,1,1,0 > 1,0,0,0,1 > 0,0,0,0,0 > 1,0,1,1,0 > > file b: > 3,4,6,8,11 > > output request: > 0,0,6,8,0 > 3,0,0,0,11 > 0,0,0,0,0 > 3,0,6,8,0 > > > > -- > View this message in context: > r.789695.n4.nabble.com/Replace-query-tp2122706p2122706.html > Sent from the R help mailing list archive at Nabble.com. > > ______________________________________________ > R-help@r-project.org mailing list > stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide > R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. >[[alternative HTML version deleted]]
On May 2, 2010, at 7:01 AM, burgundy wrote:> > Hi, > > I'm trying to replace all values equal to 1 in one file (a) with the > value > in the corresponding column in a separate file (b). Example below. > Any help (and brief notes if poss) much appreciated. Thanks!! > > file a: > 0,0,1,1,0 > 1,0,0,0,1 > 0,0,0,0,0 > 1,0,1,1,0You need to read the introductory material on reading files, and then you need to read the Posting Guide about how to present copy-pastable versions of r objects. Also look at: ?dput> > file b: > 3,4,6,8,11Once that is done: t( t(a)*b)> > output request: > 0,0,6,8,0 > 3,0,0,0,11 > 0,0,0,0,0 > 3,0,6,8,0 >-- David Winsemius, MD West Hartford, CT