How to mount google drive to R notebook in colab?

Question

I have an R notebook in colab where I want to read a file which is saved in my google drive.

I only seem to find python code such as "from google.colab import drive drive.mount('/content/drive')" to mount the drive.

However, is there code for R to do this or another alternative? I am really struggling and would very much appreciate the help!

Answer 1

To mount google drive in an R kernel:

install.packages("googledrive")
library("googledrive")

if (file.exists("/usr/local/lib/python3.6/dist-packages/google/colab_ipython.py")){
  install.packages("R.utils")
  library("R.utils")
  library("httr")
  my_check <- function() {return(TRUE)}
  reassignInPackage("is_interactive", pkgName = "httr", my_check)
  options(rlang_interactive=TRUE)
}                                                                                    

And authenticate google drive

drive_auth(use_oob = TRUE, cache = TRUE)

Answer 2

Start using python:

from google.colab import drive
drive.mount('/content/drive')

Then load the R Magic:

%load_ext rpy2.ipython

and then activate the R Magic and load your data:

%%R
url = ('/content/drive/myDrive/folder1/myfile.csv')
dataset = read.csv(url)