Reading OneDrive files to R

r csv dropbox onedrive
hgeop picture hgeop · Apr 11, 2015 · Viewed 12.8k times · Source

When I read in csv files from Dropbox into R, I right-click the file and click share Dropbox link. I then have a URL something like:

https://www.dropbox.com/blahhhhhhhhhh.csv?dl=0

So I change it to: read.csv("http://dl.dropbox.com/blahhhhhhhhhh.csv?dl=0", ...) and it works without the need to use any packages etc.

Is there a way to read files from OneDrive in a similar manner?

https://onedrive.live.com/blahhhhhhhhhhhhhhhhccsv

As when I try to read it into R it doesn't give me the data frame I'm expecting from the file.

Answer

Phuong Doan picture Phuong Doan · Sep 11, 2017

I tested this with public OneDrive link:

  • download the file
  • get the URL in download page (Ctrl+J in Chrome):

[enter image description here]

  • paste the URL in read.csv("url...")

This works for me even when the public link changes.

Related questions

How to import multiple .csv files at once?

Suppose we have a folder containing multiple data.csv files, each containing the same number of variables but each from different times. Is there a way in R to import them all simultaneously rather than having to import them all …

Read More
How do I import a CSV file in R?

I have a .csv file in my workstation. How can I open that file in R and do statistical calculation?

Read More
Subset of rows containing NA (missing) values in a chosen column of a data frame

We have a data frame from a CSV file. The data frame DF has columns that contain observed values and a column (VaR2) that contains the date at which a measurement has been taken. If the date was not recorded, …

Read More