Demo of use Google Drive/Sheets in R with Google Colaboratory.ipynb

demo-of-use-google-drive-sheets-in-r-with-google-colaboratory.ipynb

This stopped working, and can be fixed by doing the same for rlang as for httr.

# Check if is running in Colab and redefine is_interactive()
if (file.exists("/usr/local/lib/python3.6/dist-packages/google/colab/_ipython.py")) {
  install.packages("R.utils")
  library(R.utils)
  library(httr)
  library(rlang)
  my_check <- function() {return(TRUE)}
  reassignInPackage("is_interactive", pkgName = "httr", my_check) 
  reassignInPackage("is_interactive", pkgName = "rlang", my_check) 
}

@nacnudus Thanks for your reply.

I saw that stop working some days ago, then
I add options(rlang_interactive=TRUE), which solve too, but I forgot to push the correction to gist.
They have change httr code in some way that now need more hacks. :(

@jobdiogenes Have been using your solution for some time. Thank you for it. I hate to say it but it's broken again.

@ClaudiuPapasteri, this stop working because Google update to python 3.7. I just update. And now are working again.
If you perhaps use the code only online in Colab, you could remove if (file.exists( .... ))

Thanks to report

seems to work in online colab if you just change 3.6 to 3.7
if (file.exists("/usr/local/lib/python3.7/dist-packages/google/colab/_ipython.py")) {

but someone with greater skill should confirm.

In my case neither /usr/local/lib/python3.6/dist-packages/google nor /usr/local/lib/python3.7/dist-packages/google folder existed.
However running the original code without if (file.exists(....)) worked for me!

Great to hear, I will make a more auspicious code to know that we are in cloud collab environment. Thanks Em ter, 13 de abr de 2021 02:20, Monica Ramirez ***@***.***> escreveu:

…

***@***.**** commented on this gist. ------------------------------ In my case neither /usr/local/lib/python3.6/dist-packages/google nor /usr/local/lib/python3.7/dist-packages/google folder existed. However running the original code without if (file.exists(....)) worked for me! — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <https://gist.github.com/235620928c84e604c6e56211ccf681f0#gistcomment-3703883>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAJAVLMWCJHIPHSOEWXL73TTIPICTANCNFSM4OJNWQBQ> .