I have a data frame in R Studio cloud that is 85 rows by 207 columns (ultimately it may be as wide as 366 columns). The actual data is created using the code in this thread:
Now that I have the data frame set up, I'm trying to use the googlesheets library to transfer it to an existing sheet (and will periodically update it as I get more data). I'm using this code to edit the google sheet:
I let it think for a long time (more than an hour) and it sat there with "Range affected by the update" and it never went through. If I slice it into several segments (doing say 30 or 60 or 90 columns at a time) then it does transfer but is prohibitively slow. This isn't a huge dataset, is there something I could improve in my code? I have loaded the sheet in advance and it does recognize it.
I'm not sure this problem is specific to RStudio Cloud — it may be an problem with googlesheets and the APIs it relies on. This discussion on the googlesheets GitHub issue tracker might have some things you can try:
This also sounds similar:
But most significant for you are probably these comments from the package author:
Hmm ... interesting re: tibble vs. data frame. In any case, the reboot googlesheets4 is well underway, with reading public Sheets already available for use. Writing will come soon!
What I'm saying: I will not be troubleshooting this any further here and, I hope, it will simply not be a problem in googlesheets4, with the new API.