if the census bureau's budget was gutted and only one complex sample survey survived, pray it's the survey of income and program participation (sipp). it's giant. it's rich with variables. it's monthly. it follows households over three, four, now five year panels. the congressional budget office uses it for their health insurance simulation. analysts read that sipp has...
372 search results for "sql"
F1Stats – Visually Comparing Qualifying and Grid Positions with Race Classification
Following the roundabout tour of F1Stats – A Prequel to Getting Started With Rank Correlations, here’s a walk through of my attempt to replicate the first part of A Tale of Two 
A shiny app to display the human body map dataset
There was quite a lot of buzz around when the guys from Rstudio launched Shiny, a new web framework for R that promises to “make it super simple for R users like you to turn analyses into interactive web applications … Continue reading →
SPARQL with R in less than 5 minutes
In this article we’ll get up and running on the Semantic Web in less than 5 minutes using SPARQL with R. We’ll begin with a brief introduction to the Semantic Web then cover some simple steps for downloading and analyzing government data via a SPARQL query with the SPARQL R package. What is the Semantic
The post SPARQL...
In case you missed it: December 2012 Roundup
In case you missed them, here are some articles from December of particular interest to R users. The blog is.R ran an excellent series of R tips and applications in December, with posts including working with Stata files, working with graphs and networks, and text analysis. Kohske Takahashi provides R scripts to create a collection of optical illusions. Highlights...
Version 1.0 of sqlutils available on CRAN
Version 1.0 of sqlutils has been released to CRAN. The sqlutils package is designed to manage a library of SQL files. This package grew out of the needs of an Office of Institutional Research where the vast majority of analysis is conducted on data from our Student Information System (SIS) which is stored in an Oracle database. A lot...
The Social Network Ranking is Wrong
Call me old-fashioned, but I never saw the movie The Social Network until last year (at a private screening). In case you also missed it, it's the Hollywood version of how Facebook.com came into being.
Quite apart from any artistic criticisms, I have a genuine psychological problem with movies like TSN. I keep getting caught up...
analyze the health and retirement study (hrs) with r
the hrs is the one and only longitudinal survey of american seniors. with a panel starting its third decade, the current pool of respondents includes older folks who have been interviewed every two years as far back as 1992. unlike cross-se...
Interactive SQL in R
I recently taught a very basic introduction to SQL workshop and needed a way to have participants interact with SQL statements. Obviously there are lots of tools to interface with a database, but since we are all R users I thought it would be nice to be able interact without leaving R. Although this interface is fairly basic, the...
R for actuarial science
As mentioned in the Appendix of Modern Actuarial Risk Theory, “R (and S) is the ‘lingua franca’ of data analysis and statistical computing, used in academia, climate research, computer science, bioinformatics, pharmaceutical industry, customer analytics, data mining, finance and by some insurers. Apart from being stable, fast, always up-to-date and very versatile, the chief advantage of R is that...
Zero Inflated Models and Generalized Linear Mixed Models with R.
Zuur, Saveliev, Ieno (2012).
