inserting values for null

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.
An embedded and charset-unspecified text was scrubbed...
Name: not available
URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20080917/3c3b8328/attachment.pl>
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

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

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.
ODBC,

didn't think of that, thanks.

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

An embedded and charset-unspecified text was scrubbed...
Name: not available
URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20080918/52804630/attachment.pl>