Reading a file on a network in R

Question

I am importing a csv file in to R using the read.csv method but get the following error.

The network path is "\\shared\data\abc.csv"

read.csv("\\shared/data/abc.csv",header=T)
                    or 
read.csv("\\shared\\data\\abc.csv",header=T)

If I use copy paste the address in the address bar in the file explorer, it opens the file but R somehow cannot read it. What's the reason? Is it because the network name starts with "//" instead of traditional drive name like C,D etc?

\ is a special character so needs escaping with another \. if you have two \ both need escaping to give "\\\\shared\\..." — Richard Telford, Sep 02 '16 at 16:25
https://stackoverflow.com/questions/14879204/how-to-escape-a-backslash-in-r#comment20862252_14879204 — Rich Scriven, Sep 02 '16 at 16:55

score 20 · Accepted Answer · answered Sep 02 '16 at 16:29

20

You need to escape each backslash, so for the double backslash you need four backslashes, i.e.

read.csv("\\\\shared\\data\\abc.csv",header=T)

answered Sep 02 '16 at 16:29

andyyy

986
8
8

score 2 · Answer 2 · answered Jul 31 '19 at 21:19

in addition, the below also works and should be OS agnostic:

read.csv("//shared/data/abc.csv",header=T)

when running getwd() note how the separator between folders is forward slash (/), as it is on Linux and Mac systems. If you use the Windows operating system, the forward slash will look odd, because you’re familiar with the backslash (\) of Windows folders. When working in Windows, you need to either use the forward slash or escape your backslashes using a double backslash (\\).

score 1 · Answer 3 · answered Dec 30 '16 at 00:36

1

Using R's built-in file system functions:

CSVfile <- file.path('\\\\shared', 'data', 'abc.csv')
read.csv(CSVfile, header=T)`

answered Dec 30 '16 at 00:36

Ant

790
7
18

Reading a file on a network in R

3 Answers3