My very first plot of BLS data extracted using SQLand R on my local computer
In the software world, quit re-inventing.
So, my database system has arrived, and nothing but a few SQL scripts. It returns the proper code to grab the data from the bowels of the BLS, I suppose libertarians would fire the crew at BLS, but I would still find data sources anyway.
I keep the key words simple, simple and simple; the the few key words have to be entered in simple but proper order. So I have used SQLite to make a little file system manager, with the files being at the BLS.
Something like:
"All consumer energy USA" ; might lead to the proper series code.
And the data can be had from the source with this code. The next part is getting R Project statistical to read the resulting BLS files.
Simple, even simpler would be to integrate SQLite into the R Project code base.
Access to the BLS files? Why not load the whole bunch. The SQL macros can pick through then locally. SQLite can read local downloads, temporarily for search, extract the data and pass off a complete dataframe to R Project. When SQlite is integrated into R project, then R commands might include an sql(Rtext) from the user interface. The Rtext being a R string of test, entered by user.
Got it, data delivered from Big Government via SQLite, right into R; where I can work it and plot it.
No comments:
Post a Comment