There are lots of references on Hacker news to the fact that the "good old days" are gone and that the character of the site has changed since it started. The visualization above was based on a sample of users that posted on the site in recent ti...
Posts Tagged ‘ SQL ’
Analyze Online R User Conference Data
The R User Conference 2010 will be underway shortly - and what better way to commemorate the event than to blast out some R code related to the conference? HTML tables on websites for the past three years list participants an...
Make R speak SQL with sqldf
The R community is unique as programming communities go. Many users of R come from academia and have a relatively extensive mathematical background. The R community has developed in relative isolation from some other areas of programming th...
Use SQL queries to manipulate data frames in R with sqldf package
I've covered a few topics in the past including the plyr package, which is kind of like "GROUP BY" for R, and the merge function for merging datasets. I only recently found the sqldf package for R, and it's already one of the most useful packages I've ever installed. The main function in the package is sqldf(), which takes...
Eight R Video Tutorials on VCASMO
Download "Getting Started with the Social Media Analytics Research Toolkit" (pdf, 1.25 megabytes) Download the Social Media Analytics Research Toolkit Thanks to Drew Conway (@drewconway), a PhD student at New York University, there are now eight excell...
Loading Big (ish) Data into R
So for the rest of this conversation big data == 2 Gigs. Done. Don’t give me any of this ‘that’s not big, THIS is big’ shit. There now, on with the cool stuff: This week on twitter Vince Buffalo asked about loading a 2 gig comma separated file (csv) into R (OK, he asked about tab
SAS: “The query requires remerging summary statistics back with the original data”
Coming from a background writing SQL code directly for “real” RDBMS (Microsoft SQL Server, MySQL, and SQLite), I was initially confused when SAS would give me the following ‘note’ for a simple summary PROC SQL query: 429 proc sql; 430 create table undel_monthly as 431 select 432 year(date) as year, 433 month(date) as month, 434 
Zero Inflated Models and Generalized Linear Mixed Models with R.
Zuur, Saveliev, Ieno (2012).
