I have a dataframe D.F1>dim (D.F1)14351 9 This dataframe has values and for some 1000 rows it holds NULL values.I hace found the missing values for about 500 and have those in another dataframe D.F.sub.2>dim(D.F.sub.2)500 9 as dataframe is a subset of D.F1 the coulmn 1 in D.F.sub.2 is a subset of D.F1.I have to insert the values in D.F1 in other fields while the coulmn 1 in both the main table and sub table matches. Ih short i have to insert a dataframe (D.F.sub.2) into the main D.F1 using the column1 that hold similar values. Kindly plz help me. Ramya -- View this message in context: http://www.nabble.com/inserting-values-for-null-tp19535742p19535742.html Sent from the R help mailing list archive at Nabble.com.
Dear Raja, Give a look on merge() function. Case you need more help, send us a short sample of your D.F1 and DF.sub.2 dataframes. Hope this helps, best wishes, miltinho astronauta brazil On Wed, Sep 17, 2008 at 2:13 PM, Rajasekaramya <ramya.victory@gmail.com>wrote:> > I have a dataframe D.F1 > > >dim (D.F1) > 14351 9 > This dataframe has values and for some 1000 rows it holds NULL values.I > hace > found the missing values for about 500 and have those in another dataframe > D.F.sub.2 > > >dim(D.F.sub.2) > 500 9 > as dataframe is a subset of D.F1 the coulmn 1 in D.F.sub.2 is a subset of > D.F1.I have to insert the values in D.F1 in other fields while the coulmn 1 > in both the main table and sub table matches. > Ih short i have to insert a dataframe (D.F.sub.2) into the main D.F1 using > the column1 that hold similar values. > > Kindly plz help me. > > Ramya > -- > View this message in context: > http://www.nabble.com/inserting-values-for-null-tp19535742p19535742.html > Sent from the R help mailing list archive at Nabble.com. > > ______________________________________________ > R-help@r-project.org mailing list > 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]]
Hi, is there a Rdbi or other package to use firebird in R? I am reviewing options for my Practice software and might have to switch to a firebird based package so I would of course like to be able to do some stats in R. greetings, el
On Sep 17, 2008, at 6:00 PM, Dr Eberhard W Lisse wrote:> Hi, > > is there a Rdbi or other package to use firebird in R? > > I am reviewing options for my Practice software and might have > to switch to a firebird based package so I would of course like > to be able to do some stats in R.Per Prof Ripley: http://tolstoy.newcastle.edu.au/R/help/04/10/6358.html -- David Winsemius
Hi Ramya, Assuming that the problem is well defined (i.e. the values in col1 of the data.frames are unique and every value in D.F.sub.2[,1] appears also in D.F1[,1]) you can do the following: ind <- match(D.F.sub.2[,1],D.F1[,1]) D.F1[ind,] <- D.F.sub.2 --- On Thu, 18/9/08, Rajasekaramya <ramya.victory at gmail.com> wrote:> From: Rajasekaramya <ramya.victory at gmail.com> > Subject: [R] inserting values for null > To: r-help at r-project.org > Received: Thursday, 18 September, 2008, 2:13 AM > I have a dataframe D.F1 > > >dim (D.F1) > 14351 9 > This dataframe has values and for some 1000 rows it holds > NULL values.I hace > found the missing values for about 500 and have those in > another dataframe > D.F.sub.2 > > >dim(D.F.sub.2) > 500 9 > as dataframe is a subset of D.F1 the coulmn 1 in D.F.sub.2 > is a subset of > D.F1.I have to insert the values in D.F1 in other fields > while the coulmn 1 > in both the main table and sub table matches. > Ih short i have to insert a dataframe (D.F.sub.2) into the > main D.F1 using > the column1 that hold similar values. > > Kindly plz help me. > > Ramya > -- > View this message in context: > http://www.nabble.com/inserting-values-for-null-tp19535742p19535742.html > Sent from the R help mailing list archive at Nabble.com. > > ______________________________________________ > R-help at r-project.org mailing list > 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.
The group would be happy to answer your question if you can show an example data frame on what is there and what is required. Cheers, Pratap --- On Wed, 17/9/08, Rajasekaramya <ramya.victory@gmail.com> wrote: From: Rajasekaramya <ramya.victory@gmail.com> Subject: [R] inserting values for null To: r-help@r-project.org Date: Wednesday, 17 September, 2008, 9:43 PM I have a dataframe D.F1>dim (D.F1)14351 9 This dataframe has values and for some 1000 rows it holds NULL values.I hace found the missing values for about 500 and have those in another dataframe D.F.sub.2>dim(D.F.sub.2)500 9 as dataframe is a subset of D.F1 the coulmn 1 in D.F.sub.2 is a subset of D.F1.I have to insert the values in D.F1 in other fields while the coulmn 1 in both the main table and sub table matches. Ih short i have to insert a dataframe (D.F.sub.2) into the main D.F1 using the column1 that hold similar values. Kindly plz help me. Ramya -- View this message in context: http://www.nabble.com/inserting-values-for-null-tp19535742p19535742.html Sent from the R help mailing list archive at Nabble.com. ______________________________________________ R-help@r-project.org mailing list 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. Get an email ID as yourname@ymail.com or yourname@rocketmail.com. Cli [[alternative HTML version deleted]]