This was a tortuous path to success … seems like Google has changed the way GDocs are accessed several times over the past couple of years, including https by default which meant that normal
read.csv(url) functions didn’t work.
To get the mobile internet spreadsheet I wrote up for TZCRC:
- Opened the spreadsheet in Google Docs, then selected File|Publish to web and selected CSV to get the link (below).
- Used the link with RCurl and read.csv in the code below:
Giving the data frame:
|Airtel||Handset Browsing Bundle||400||2,500||6.3||30|
|Airtel||1 Day bundle||300||3,000||10.0||1|