Saturday, May 29, 2010

Database update

I am releasing the 150 Essential R Lines for SQLite Integration. I swear not to inflate more.
The new release maps R dataframe column names to SQL column names and defaults to .headers on to swap names, and extract R names on table create. Our other default is to map table names to file names of their csv sources.

So, if I remember, this began as an odyssey to digest reams of government data, and it is working better. BLS data is the toughest to swallow, but FRED is a snap.
The new call: qframe(tb,db,x="",mode="w and or or c or r")
allows creation, read, and write of a SQL table to match a dataframe.

No comments: