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:
Post a Comment