In a previous post we have looked at opening and closing connections from R to a MySQL database and some basic operations for creating and deleting tables. In this post we will consider using SQL queries to extract parts of a table from the database based on different search criteria. Read the rest of this entry »

Posted by Ralph at 11:04 pm
Comments Off on Using SQL to Access Data in MySQL Databases

The R import/export manual discusses various approaches to handling data and mentions that R is not suitable for working with large data sets because data objects are stored in memory during a session. There are situations where using a database to hold the data and making use of one of the R libraries for database connectivity to access the data or to save the data. Read the rest of this entry »

This book by Deepayan Sarkar, who is the author of the lattice package for R, provides an introduction to this implementation of the trellis graphics system followed up with a large range of examples of frequently used graphics. The book is divided into three parts starting with the basics leading into taking greater control of the graphics systems and finishing with a brief discussion of extending the lattice library. Read the rest of this entry »

Posted by Ralph at 10:17 am
Comments Off on Book Review – Lattice: Multivariate Data Visualization with R by Deepayan Sarkar (Springer 2008)

The LaTeX system is very handy for creating technical documents, but there are situations where we want to present some knowledge orally and the layout for doing this effectively is naturally different to that which appears in printed text. There are various approaches to creating a presentation in LaTeX and the package beamer is an excellent system for creating professional looking presentations and hopefully avoiding some of the clutter that appears in many presentations. Read the rest of this entry »

Posted by Ralph at 2:38 pm
Comments Off on Creating a Basic Presentation using LaTeX Beamer