Thanks Michael! dbBuildTableDefinition is something I was looking for
but it does not seem to support SQL Server table definitions (CREATE
TABLE statements may vary between different RDBMS).
Thanks anyway,
-J
2010/10/9 Michael Bedward :
> Package RSQLite has a dbBuildTableDefinition that create
as I understand it.
--
David.
-J
2010/10/5 Eric Lecoutre :
Hi,
You can have a look at RODBC and its function sqlSave.
HTH,
Eric
2010/10/3 johannes rara
Hi,
R contains many good datasets which would be valuable in other
platforms as well. My intention is to use R datasets on SQL Se
Have you considered the DBI and RODBC packages? I'm trying to
do something like this myself right now, and a post of my own (to
R-SIG-DB) produced recommendations for these two packages. Both have
vignettes.
Hope this helps.
Spencer
On 10/9/2010 6:52 AM, Michael Bedward
Package RSQLite has a dbBuildTableDefinition that creates the CREATE
TABLE statement for a given a data.frame. I think other db related
packages for MySQL and PostgreSQL also have such a function.
Michael
On 10 October 2010 00:39, Gabor Grothendieck wrote:
> On Sat, Oct 9, 2010 at 9:02 AM, joha
On Sat, Oct 9, 2010 at 9:02 AM, johannes rara wrote:
> Thanks, but I'm not looking for a function to save dataframes into a
> RDBMS. I'm looking for a function which creates CREATE TABLE and
> INSERT statements from a dataframe.
>
If the reason you want that is so you can manipulate R data frames
H,
>
> Eric
>
>
> 2010/10/3 johannes rara
>>
>> Hi,
>>
>> R contains many good datasets which would be valuable in other
>> platforms as well. My intention is to use R datasets on SQL Server as
>> a sample tables. Is there a package that would d
Hi,
You can have a look at RODBC and its function sqlSave.
HTH,
Eric
2010/10/3 johannes rara
> Hi,
>
> R contains many good datasets which would be valuable in other
> platforms as well. My intention is to use R datasets on SQL Server as
> a sample tables. Is there a packag
Hi,
R contains many good datasets which would be valuable in other
platforms as well. My intention is to use R datasets on SQL Server as
a sample tables. Is there a package that would do automatic conversion
from the dataset "schema" into a SQL Server CREATE TABLE statement
(and I
t; Joris
>>
>> On Thu, Jun 24, 2010 at 12:39 AM, Geun Seop Lee
>> wrote:
>> >>
>> >> Dear all,
>> >>>
>> >>> While I was trying to build R source, I found an error at datasets
>> package
>> >>> (there was no
,
> >>>
> >>> While I was trying to build R source, I found an error at datasets
> package
> >>> (there was no error before that)
> >>>
> >>> ../../../library/datasets/R/datasets is unchanged
> >>> Error in dir.create(R
datasets package
>>> (there was no error before that)
>>>
>>> ../../../library/datasets/R/datasets is unchanged
>>> Error in dir.create(Rdatadir, showWarnings = FALSE) :
>>> file name conversion problem
>>> Calls: -> -> dir.create
>
>
> Dear all,
>>
>> While I was trying to build R source, I found an error at datasets package
>> (there was no error before that)
>>
>> ../../../library/datasets/R/datasets is unchanged
>> Error in dir.create(Rdatadir, showWarnings = FALSE) :
Dear all,
While I was trying to build R source, I found an error at datasets package
(there was no error before that)
../../../library/datasets/R/datasets is unchanged
Error in dir.create(Rdatadir, showWarnings = FALSE) :
file name conversion problem
Calls: -> -> dir.create
Execution
On Sun, Oct 25, 2009 at 5:48 AM, Yihui Xie wrote:
> Hi everyone,
>
> I wonder if there already exists any R packages containing all the
> data sets for the book "The Statistical Sleuth"
> (http://www.proaxis.com/~panorama/home.htm; also available at StatLib
> http://lib.stat.cmu.edu/datasets/sleut
Hi everyone,
I wonder if there already exists any R packages containing all the
data sets for the book "The Statistical Sleuth"
(http://www.proaxis.com/~panorama/home.htm; also available at StatLib
http://lib.stat.cmu.edu/datasets/sleuth).
I'm writing an R package with a friend for one of our sta
: socserv.mcmaster.ca/jfox
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On
> Behalf Of Roland Rau
> Sent: May-30-08 10:35 AM
> To: Carlos López
> Cc: r-help@r-project.org
> Subject: Re: [R] Datasets in R
>
> Hi Carlos,
>
> Carlos Ló
Hi Carlos,
Carlos López wrote:
I´m trying to find datasets that will give me residuals, after applying
the lm function, with no normality, non linearity, and heteroscedacity
so I can try to exemplify
those cases in the linear regression model. Can you give any advice on
what datasets would be
D]>
> Cc: r-help@r-project.org
> Subject: Re: [R] Datasets in R
>
>
> Carlos López wrote:
>> I´m trying to find datasets that will give me residuals, after
>> applying the lm function, with no normality, non linearity, and
>> heteroscedacity so I can try to e
Carlos López wrote:
I´m trying to find datasets that will give me residuals, after applying
the lm function, with no normality, non linearity, and heteroscedacity
so I can try to exemplify
those cases in the linear regression model. Can you give any advice on
what datasets would be appropiate?
I´m trying to find datasets that will give me residuals, after applying
the lm function, with no normality, non linearity, and heteroscedacity
so I can try to exemplify
those cases in the linear regression model. Can you give any advice on
what datasets would be appropiate? I can´t use the ones
Hi, my name is Luis, and I have a problem with a dataset.
Its name is algae and count the collection of data in a lake and respective
proliferation of algae.
The parameters that it has are: "mxPH", "mnO2", "Cl", "NO3" "NH4", "oPO4",
"PO4", "Chla" and "a1" all numerics.
a1 - algae1
If I try to do S
21 matches
Mail list logo
