Dear r-users, Suppose I have two data sets data set-1 Date height ------------------------ 1/11/2005 10 2/11/2005 23 3/11/2005 54 4/11/2005 21 5/11/2005 22 data set-2 weight -------- 32 45 11 Now I want to combine this two data sets. i.e. i want to see: Date height weight ------------------------------------------- 3/11/2005 54 32 4/11/2005 21 45 5/11/2005 22 11 Can any one give me the required r-code to perform this? Thanks and regards, Arun [[alternative HTML version deleted]]
?merge maybe is what you want. 2006/5/11, Arun Kumar Saha <arun.kumar.saha at gmail.com>:> Dear r-users, > > Suppose I have two data sets > > data set-1 > > Date height > ------------------------ > 1/11/2005 10 > 2/11/2005 23 > 3/11/2005 54 > 4/11/2005 21 > 5/11/2005 22 > > data set-2 > > weight > -------- > 32 > 45 > 11 > > > Now I want to combine this two data sets. i.e. i want to see: > > > Date height weight > ------------------------------------------- > 3/11/2005 54 32 > 4/11/2005 21 45 > 5/11/2005 22 11 > > Can any one give me the required r-code to perform this? > > Thanks and regards, > Arun > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help at stat.math.ethz.ch mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html >-- ?????? Deparment of Sociology Fudan University
merge(data.set.1, data.set.2) but how do I know which rows to drop in ds1? if data.set.2 had dates, you could say merge(data.set.1, data.set.2, by.x=Date, by.y=Date, all=T) or do you just want to drop the first length(data.set.1)-length(data.set.2) from data.set.1? do you have NA values? cheers, Sean On 11/05/06, Arun Kumar Saha <arun.kumar.saha at gmail.com> wrote:> Dear r-users, > > Suppose I have two data sets > > data set-1 > > Date height > ------------------------ > 1/11/2005 10 > 2/11/2005 23 > 3/11/2005 54 > 4/11/2005 21 > 5/11/2005 22 > > data set-2 > > weight > -------- > 32 > 45 > 11 > > > Now I want to combine this two data sets. i.e. i want to see: > > > Date height weight > ------------------------------------------- > 3/11/2005 54 32 > 4/11/2005 21 45 > 5/11/2005 22 11 > > Can any one give me the required r-code to perform this? > > Thanks and regards, > Arun > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help at stat.math.ethz.ch mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html >
Hi Arun, so to clarify: you want to drop the first length(data.set.1)-length(data.set.2) rows... so you might say... new.ds1 <- data.set.1[(-(length(data.set.1)-length(data.set.2)),] and then add a new column... new.ds.combined <- cbind(new.ds1, data.set.2) cheers, Sean On 11/05/06, Arun Kumar Saha <arun.kumar.saha at gmail.com> wrote:> > Dear Sean, > > Thanks for this reply. But my problem is not solved. Actually I want to drop > first two rows from dataset-1 and then combine them. Can you give me any > idea? > > Thanks and regards, > Arun > > > > On 5/11/06, Sean O'Riordain <sean.oriordain at gmail.com> wrote: > > merge(data.set.1, data.set.2) > > > > but how do I know which rows to drop in ds1? > > > > if data.set.2 had dates, you could say > > > > merge(data.set.1, data.set.2, by.x=Date, by.y=Date, all=T) > > > > or do you just want to drop the first > > length(data.set.1)-length(data.set.2) from data.set.1? > > > > do you have NA values? > > > > cheers, > > Sean > > > > On 11/05/06, Arun Kumar Saha <arun.kumar.saha at gmail.com> wrote: > > > Dear r-users, > > > > > > Suppose I have two data sets > > > > > > data set-1 > > > > > > Date height > > > ------------------------ > > > 1/11/2005 10 > > > 2/11/2005 23 > > > 3/11/2005 54 > > > 4/11/2005 21 > > > 5/11/2005 22 > > > > > > data set-2 > > > > > > weight > > > -------- > > > 32 > > > 45 > > > 11 > > > > > > > > > Now I want to combine this two data sets. i.e. i want to see: > > > > > > > > > Date height weight > > > ------------------------------------------- > > > 3/11/2005 54 32 > > > 4/11/2005 21 45 > > > 5/11/2005 22 11 > > > > > > Can any one give me the required r-code to perform this? > > > > > > Thanks and regards, > > > Arun > > > > > > [[alternative HTML version deleted]] > > > > > > ______________________________________________ > > > R-help at stat.math.ethz.ch mailing list > > > https://stat.ethz.ch/mailman/listinfo/r-help > > > PLEASE do read the posting guide! > http://www.R-project.org/posting-guide.html > > > > > > > > > -- > Arun Kumar Saha, M.Sc.[C.U.] > S T A T I S T I C I A N [Analyst] > RISK MANAGEMENT DIVISION > Transgraph Consulting [ www.transgraph.com] > Hyderabad, INDIA > Contact # Home: (91-033) 25558038 > Office: (91-040) 30685012 Ext. 17 > FAX: (91-040) 55755003 > Mobile: 919849957010 > E-Mail: arun.kumar.saha at gmail.com