the consumer expenditure survey (ce) is the primo data source to understand how americans spend money. participating households keep a running diary about every little purchase over the year. those diaries are then summed up into precise expenditure categories. how else are you gonna know that the average american household spent $34 (±2) on bacon, $826 (±17) on cellular...
372 search results for "SQL"
SAP HANA and R (The way of the widget)
A real developer never stops learning that's a quote I always love to repeat...because it applies to my life...you can know a lot of things but there's always something new to learn, or to re-learn. That's why a couple of days ago I start reading wxPyt...
Which functions in plyr do people use?
This is the question that Hadley Wickham recently set out to discovering by asking frequent R and plyr users how they use it in an online survey. Once a decent number of people have responded, Hadley quickly went forward and produced a short analysis of the plyr usage survey, and published it in RPubs. With his permission, I am...
Vendor news: TIBCO’s proprietary R runtime; Teradata’s appliance integrates R
In a webinar today previewing Spotfire 5 (scheduled for release this November), TIBCO announced that it will include TERR: The Tibco Enterprise Runtime for R. TERR is a closed-source reimplementation of the R language engine, and not based on the GPL-licensed R project from the R Foundation. Here's the relevant slide from the webinar: By making the TERR engine...
analyze the current population survey (cps) annual social and economic supplement (asec) with r
the annual march cps-asec has been supplying the statistics for the census bureau's report on income, poverty, and health insurance coverage since 1948. wow. the us census bureau and the bureau of labor statistics (bls) tag-team on this one...
What lens should I buy next ?; Analysing and graphing a Digikam database using R
I use the Open Source photo management Software Digikam (along with other tools such as Gimp and DarkTable). I obviously need very little encouragement to combine my geeky hobbies, so I quickly tried to interrogate Digikam with R, which is easy, ...
Debugging parameter mismatch across RAC database instances with R, dba_hist, and gv$parameter
Did you find this post useful? Does your organization need Oracle services? We can help. Much of this morning went into investigating strange ADDM reports on a two-node Oracle RAC database. For some reason, there were statistically improbable differences…
Tips on accessing data from various sources with R
Jeffrey Breen (the man behind the Twitter airline sentiment analysis example) recently posted a collection of slides with some great tips for accessing data from R. "Tapping the Data Deluge" includes information on: Using the XLConnect package to read data from Excel spreadsheets Using the foreign package to read SPSS, SAS, Stata and dBase data files Using SQL queries...
analyze the area resource file (arf) with r
the arf is fun to say out loud. it's also a single county-level data table with about 6,000 variables, produced by the united states health services and resources administration (hrsa). the file contains health information and statistics fo...
Technical Analysis of Montana Voter Registration Files
By Earl F Glynn | Franklin Center This article shows how to analyze Montana voter registration files using R. The Montana Secretary of State sells two files of voter registration records for a fee of $1000: Statewide Voter File Voter History File The Montana Secretary of State provides information about the two files on this
Zero Inflated Models and Generalized Linear Mixed Models with R.
Zuur, Saveliev, Ieno (2012).
