Use this tag for questions related to the R googlesheets-package.
Access and manage Google spreadsheets from R with
googlesheets.
References
- GitHub repository, including Readme.md.
Questions tagged [r-googlesheets]
65 questions
0
votes
0 answers
How to Translate REGEXMATCH formula from Google Sheets to R
I've got columns in Google Sheets with headers like the following:
Complete_Fall11 Complete_Spr12 Complete_Fall12 Complete_Spr13 Complete_Fall13 Complete_Spr14
And below each of them I've got a Cell with the following formula:…
Josh
- 311
- 3
- 11
0
votes
1 answer
How to write rownames into a spreadsheet with the googlesheets package in R?
I would like to write a data frame in a Google spreadsheet with the googlessheets package but the rownames isn't written in the first column.
My data frame looks like this :
> str(stats)
'data.frame': 4 obs. of 2 variables:
$ Offensive: num …
Florent
- 1,791
- 22
- 40
0
votes
1 answer
Extract name of Google Sheet with googlesheets package
I'm using the googlesheets package to get data from a Google Sheet and want to append the sheet name as a column in the data.frame.
For instance, with the public Gapminder sheet:
library(googlesheets)
library(dplyr)
my_dat <- gs_gap() %>% # register…
Sam Firke
- 21,571
- 9
- 87
- 105
0
votes
0 answers
Can't enable dplyr and tidyr: libstdc++.so.6: version `GLIBCXX_3.4.21' not found
After trying to install googlesheets package I can't enable tidyr and dplyr packages, as I get the following error:
require(dplyr)
Loading required package: dplyr
Error in dyn.load(file, DLLpath = DLLpath, ...) :
unable to load shared object…
ccamara
- 1,141
- 1
- 12
- 32
-1
votes
1 answer
Google Sheet connect with database
I have a very big file in google sheet with many records, rows and columns.
I want to make a database from this. Can I, in some way, personalize the display? I want to reference row to field and search by name.
Is there some software of access to…
Maciek
- 21
- 1