Re: [R] First attempt to use R

From: Roland Rau <>
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: The R Data Import/Export Manual. There is a section on Relational Databases. Please check also the available packages here: (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
included in the packages 'stats' (part of the standard installation of R)

I hope this helps,
Roland mailing list PLEASE do read the posting guide 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 Please read the posting guide before posting to the list.

list of date sections of archive