583 search results for "sql"

Extracting all Crime Data for England and Wales using R and MYSQL

February 14, 2011
By
Extracting all Crime Data for England and Wales using R and MYSQL

Last week I started creating some data extraction code for the new England and Wales crime maps website using the R software / language. Although there is an API, a more efficient way of accessing all of the data (and without causing stress to their API server) is to download the CSV files located here

Read more »

Extracting all Crime Data for England and Wales using R and MYSQL

February 14, 2011
By
Extracting all Crime Data for England and Wales using R and MYSQL

Last week I started creating some data extraction code for the new England and Wales crime maps website using the R software / language. Although there is an API, a more efficient way of accessing all of the data (and without causing stress to their AP...

Read more »

sqldf and grouping rows in R

February 8, 2011
By

In R, you can treat tables (or data.frames as they are called in R) as SQL tables. That means you can query them as you would query a database with SQL commands. This is particularly useful 1) if you know SQL, hahah:)  2) if you have large tabl...

Read more »

sqldf and grouping rows in R

February 8, 2011
By

In R, you can treat tables (or data.frames as they are called in R) as SQL tables. That means you can query them as you would query a database with SQL commands. This is particularly useful 1) if you know SQL, hahah:)  2) if you have large tabl...

Read more »

Databases (SQL, noSQL); Interfacing R with Excel

December 15, 2010
By
Databases (SQL, noSQL); Interfacing R with Excel

Los Angeles R users group Dec. 14 2010 meeting (see meetup info here): 1. A SQL primer for R users – Neal Fultz Video and slides will be available soon 2. R Database Access – Shrikrishna Bhogaonker 3. NoSQL data … Continue reading →

Read more »

RPostgreSQL 0.1-7

October 17, 2010
By

After a somewhat long hiatus, RPostgreSQL version 0.1-7 has now been released to CRAN. RPostgreSQL connects R to PostgreSQL database systems using the standard DBI interface. This version fixes a number of issues that had been compiled in the issu...

Read more »

Connecting to SQL Server from R using RJDBC

September 22, 2010
By
Connecting to SQL Server from R using RJDBC

A few months ago I switched my laptop from Windows to Ubuntu Linux. I had been connecting to my corporate SQL Server database using RODBC on Windows so I attempted to get ODBC connectivity up and running on Ubuntu. ODBC on Ubuntu turned into an exercise in futility. I spent many hours over many days

Read more »

R SQL-ish aggregation

September 10, 2010
By
R SQL-ish aggregation

I came to R from SQL. I’ve heard that packages such as reshape and plyr are quite beautiful, but to me they are somewhat non-intuitive. I’m always looking for SELECT mean(sodium) as mean, variance(sodium) as var FROM texas GROUP BY … Continue reading →

Read more »

Make R speak SQL with sqldf

July 5, 2010
By
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...

Read more »

Connecting Revolution R to MySQL on Windows

June 4, 2010
By

My colleague Saar Golde was having some troubles connecting Revolution R to MySQL on Windows (64-bit). Turned out the problem was the lack of an environment variable. He documented the instructions for fixing the problem on Windows 7, below. Thanks, Saar! The Problem: A client is about to send me a couple of large MySQL tables, so I needed...

Read more »