From the course: R Programming in Data Science: High Variety Data

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Google Docs with R

Google Docs with R

From the course: R Programming in Data Science: High Variety Data

Start my 1-month free trial

Google Docs with R

“

- [Narrator] You can use R to read from and write to Google Sheets. And to do that we'll use the Google Sheets package. The first step I need to do is create some sample data that we're going to write back and forth. You'll need to install the Google Sheets package if you haven't done so already, and incidentally when you do so, you will probably have to recompile a certain amount of information, that'll happen automatically. And when you're done installing the package, use library Google Sheets to being that package in to play. Now, I know that the file that I want to work on is called HighVarietyData_LinkedIn_Learning, and so I'm going to put that into a vector called nameOfGoogleSheet, and I'm ready now to write data to that Google Sheet. To do that, I'll use the gs_title command and get a reference. I'm going to put the reference into a vector called workingGS, and I'm going to use the gs_title command, and give it the name of an existing Google Sheet. I hit command return and in…

Contents