How to read a csv-file from an url in R?

Question

I'm rather new to R and I could use your assistance.

I am currently trying to import a csv file from an URL. I have found many examples. Unfortunately, none of them work for my problem.

Specifically, I wanted to import the file from this url: https://www.bfs.admin.ch/bfsstatic/dam/assets/15324797/master

I tried these few lines of code:

temp <- tempfile()

download.file("https://www.bfs.admin.ch/bfsstatic/dam/assets/15324797/master",temp, mode =  "w")

data<- read_csv2("je-b-03.03.02.05.csv")

and also this:

data <- read_csv2(url("https://www.bfs.admin.ch/bfsstatic/dam/assets/15324797/master"))

But that didn't work either. On the other hand, when I paste the url into my browser, the file is downloaded automatically.

I would appreciate any help. Thanks

In your first example, you should do read.csv2(temp), since that's the destination of your download. — Duccio A
– Duccio A, Commented Jan 11, 2021 at 21:48

GWD · Accepted Answer · 2021-01-11 21:52:12Z

2

df <- read.csv2(file = url("https://www.bfs.admin.ch/bfsstatic/dam/assets/15324797/master"))

answered Jan 11, 2021 at 21:52

GWD

1,47413 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

user14692575 · Accepted Answer · 2021-01-11 21:52:48Z

0

Maybe this helps to begin with:

data <- read.csv(url("https://www.bfs.admin.ch/bfsstatic/dam/assets/15324797/master"))

Check ?read.csvfor details.

answered Jan 11, 2021 at 21:52

user14692575

Comments

jared_mamrot · Accepted Answer · 2021-01-11 21:56:31Z

0

I've found vroom to be the best option for this type of task:

install.packages("vroom")
library(vroom)
data <- vroom("https://www.bfs.admin.ch/bfsstatic/dam/assets/15324797/master")

answered Jan 11, 2021 at 21:56

jared_mamrot

26.7k5 gold badges27 silver badges56 bronze badges

Comments

chrisAR · Accepted Answer · 2021-01-11 21:57:17Z

0

loc.url <- "https://www.bfs.admin.ch/bfsstatic/dam/assets/15324797/master"

data <- read.csv2(loc.url)

answered Jan 11, 2021 at 21:57

chrisAR

577 bronze badges

4 Comments

sjaustirni Over a year ago

I am not saying your answer is wrong, but please provide a bit more context to why it is correct.

Yes Barry Over a year ago

@chrisAR Please provide some context in your answer

chrisAR Over a year ago

stat.ethz.ch/R-manual/R-devel/library/utils/html/…

chrisAR Over a year ago

Look on that line:"file can also be a complete URL. (For the supported URL schemes, see the ‘URLs’ section of the help for url."

Collectives™ on Stack Overflow

How to read a csv-file from an url in R?

4 Answers 4

Comments

Comments

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related