Re: [R] First attempt to use R

From: Roland Rau <roland.rproject_at_gmail.com>
Date: Thu, 03 Jul 2008 18:07:46 -0400

Hi Ted,

hopefully the following information gets you started:

Ted wrote:
> What I want to do is extract time series data from a database(say, PostgreSQL
> or MySQL - I routinely use both), analyse it, and put a selection of the
> statistical results into specific tables.

Check the following document:
http://cran.r-project.org/doc/manuals/R-data.html The R Data Import/Export Manual. There is a section on Relational Databases. Please check also the available packages here: http://cran.wustl.edu/web/packages/index.html (or from any other CRAN mirror).
There is, for example, a package called RMySQL which will probably help you (but there are also others RODBC, DBI, RSQLite, DBI, ...) There is even a special interest group for databases (R-SIG-DB).

>
> For example, suppose I have daily values for several variates. One thing I
> might try is to fit a cubic spline to the data,
Please check also the listing of available packages (URL given above). There seem to be quite a few spline-related packages. Please note that there is a function
smooth.spline
included in the packages 'stats' (part of the standard installation of R)

I hope this helps,
Roland



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. Received on Thu 03 Jul 2008 - 22:10:13 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Thu 03 Jul 2008 - 22:31:22 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive