dat1 is wrong also. It should read: dat1 <-read.table(text="ID, x, y, z A, 10, 34, 12 B, 25, 42, 18 C, 14, 20, 8 ",sep=",",header=TRUE,stringsAsFactors=F)
Is this a homework problem? This list has a no homework policy. Cheers, Bert Bert Gunter "The trouble with having an open mind is that people keep coming along and sticking things into it." -- Opus (aka Berkeley Breathed in his "Bloom County" comic strip ) On Sat, Sep 7, 2019 at 12:24 PM Val <valkr...@gmail.com> wrote: > Hi all > > Correction for my previous posting. > dat2 should be read as > dat2 <-read.table(text="ID, weight > A, 0.25 > B, 0.42 > C, 0.65 ",sep=",",header=TRUE,stringsAsFactors=F) > > On Sat, Sep 7, 2019 at 1:46 PM Val <valkr...@gmail.com> wrote: > > > > Hi All, > > > > I have two data frames with thousand rows and several columns. My > > samples of the data frames are shown below > > > > dat1 <-read.table(text="ID, x, y, z > > ID , x, y, z > > A, 10, 34, 12 > > B, 25, 42, 18 > > C, 14, 20, 8 ",sep=",",header=TRUE,stringsAsFactors=F) > > > > dat2 <-read.table(text="ID, x, y, z > > ID, weight > > A, 0.25 > > B, 0.42 > > C, 0.65 ",sep=",",header=TRUE,stringsAsFactors=F) > > > > My goal is to create an index value for each ID by mutliplying the > > first row of dat1 by the second column of dat2. > > > > (10*0.25 ) + (34*0.42) + (12*0.65)= 24.58 > > (25*0.25 ) + (42*0.42) + (18*0.65)= 35.59 > > (14*0.25 ) + (20*0.42) + ( 8*0.65)= 19.03 > > > > The desired out put is > > dat3 > > ID, Index > > A 24.58 > > B 35.59 > > C 19.03 > > > > How do I do it in an efficent way? > > > > 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. > [[alternative HTML version deleted]] ______________________________________________ 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.