Re: [R] RSQLite to input dataframe

to circulate your mail through my office so that all will be benefited. Thanks a lot sir once again. Must say that was "The Guidnace". Regards Amy   --- On Tue, 1/4/11, Michael Bedward wrote: From: Michael Bedward Subject: Re: [R] RSQLite to input dataframe To: "Amy M

Re: [R] RSQLite to input dataframe

Hi Amy, Suppose I have a dataframe as given below. DF = data.frame(X = c("US", "UK", "Canada", "Australia", "Newzealand"), Y = c(52, 36, 74, 10, 98)) drv <- dbDriver("SQLite") tfile <- tempfile() con <- dbConnect(drv, dbname = tfile) data(DF) dbWriteTable(con, ..., ...) # Didn't know

Re: [R] RSQLite to input dataframe

Hi Amy, I'm not sure if I understand your question correctly so let me know if the following is off track. Starting with your example, here is how to create a data.frame and write it to a new table in a new database file... my.data = data.frame(X = c("US", "UK", "Canada", "Australia", "Newzealan

[R] RSQLite to input dataframe

Dear r helpers, At first, I apologize for raising a query which seems to be a stupid interpretation on my part. I am trying to learn SQLite. Following is an example given in the RSQLite.zip file (Page # 4) drv <- dbDriver("SQLite") tfile <- tempfile() con <- dbConnect(drv, dbname = tfile) dat