Tuesday, May 11, 2010

More R and Sqlite

Example from the R environment. I search on Mechanical, and the full text search generates that table below. Those columns to the left are more specific, short codes for a large class of datalists. These code for a specific data series ID. The system can match these against a known ID set and recover the actual data series. In are, then, these data chunks can be listed and reselected, plotted directly, or some attempt made to recover official text about the data.

> q4("match Mechanical")
V1 V2 V3 V4
1 17 215 6.24 Mechanical engineering technicians
2 24 539 9.02 Mechanical controls and valve repairers
3 6 57 5.56 Mechanical engineers
>
Perfect for the economist wanting to vary the sets of data at hand, rapidly and as accurately as needed. Great tool for blog fights among them.

No comments: