536 search results for "SQL"

Visualizing iPhone location tracking with R and Google Maps

April 22, 2011
By
Visualizing iPhone location tracking with R and Google Maps

Visualize location logs created by the iPhone using R and Google Maps.

Read more »

iPhone geo-tracking database

April 20, 2011
By
iPhone geo-tracking database

So the web lit up a little today with news that iPhones are collecting time-stamped location data, and in a form that isn’t particularly hard to look at (and even with some nice apps to make animated maps of your travels etc): The database is SQLite, and I used R (and the RSQLite package) to

Read more »

Aggregate Function in R: Making your life easier, one mean at a time

April 20, 2011
By
Aggregate Function in R: Making your life easier, one mean at a time

I previously posted about calculating medians using R. I used tapply to do it, but I’ve since found something that feels easier to use (at least to me). ?Download download.txt1 2 3 aggregated_output = aggregate(DV ~ IV1 * IV2, data=data_to_aggregate, FUN=median) aggregated_output The above code saves an aggregated dataset to aggregated_output and gives you the

Read more »

New versions of GGobi and rggobi for Windows users

April 8, 2011
By

or those who have been struggling with the installation of GGobi and the rggobi package under Windows: a major update of GGobi 2.1.9 is that GTK+ has been bundled with GGobi, so the installation of GTK+ is no longer required (I recommend you to uninstall it if it is not used elsewhere in your system);

Read more »

Keep an Eye on the emerging Open-Source Analytics Stack

March 3, 2011
By

This post is contributed by Revolution Analytics CEO Norman Nie, and cross-posted from the Future of Open Source Forum. A lot of attention has been focused recently on Big Data, and rightly so: Big Data is a Big Deal. (See this LinuxInsider article, Big Data, Big Open Source Tools, for a compehensive overview of Big Data issues.) But what,...

Read more »

Why learn R?

March 1, 2011
By
Why learn R?

I'm introducing R to a few colleagues this week and want to share why learning a software like R is important... Here are a few articles that explain it well... Other reasons?Importance of data science- Couple years ago Google's Chief Economist Hal Var...

Read more »

Why learn R?

March 1, 2011
By
Why learn R?

I'm introducing R to a few colleagues this week and want to share why learning a software like R is important... Here are a few articles that explain it well... Other reasons?Importance of data science- Couple years ago Google's Chief Economist Hal Var...

Read more »

Access all UCSC wiggle tracks from R and your terminal

February 21, 2011
By

rtracklayer package allows you to access most of the UCSC wiggle tracks from R. However, there is another way which might more practical in situations where you need to summarize the wig track scores over a given set of genomic coordinates. Although yo...

Read more »

Access all UCSC wiggle tracks from R and your terminal

February 21, 2011
By

rtracklayer package allows you to access most of the UCSC wiggle tracks from R. However, there is another way which might more practical in situations where you need to summarize the wig track scores over a given set of genomic coordinates. Although yo...

Read more »

Stata or R

February 10, 2011
By
Stata or R

Recently I came across a complex model written in Access with complex SQL queries all over the place. The engineer who was maintaining it and I did some analysis and agreed that the model was using SQL in an unnatural way (things SQL isn't good at) - c...

Read more »