[R] Read & Analyze Google spreadsheets

Peter Berntsen ptrber at gmail.com
Fri Jan 20 18:14:14 CET 2012


Hi,
Would like to analyze this survey:
https://docs.google.com/spreadsheet/ccc?key=0Al8vE0D1FPpldEVKWEpZalVELXRhdXo1RU5pTXJWUlE

I know how to read in the data like this:
require(RCurl)
myCsv <- getURL("https://docs.google.com/spreadsheet/pub?hl=en_US&hl=en_US&key=0Al8vE0D1FPpldEVKWEpZalVELXRhdXo1RU5pTXJWUlE&output=csv")
read.csv(textConnection(myCsv))

Q: How to read in the data column by column?
    For each column I would like to plot the data like a pie chart or
with bars meant that this made sense.

Regards
Peter



More information about the R-help mailing list