read_csv() with german special character in path

Asked Jul 18 '18 at 05:20

Active Jul 18 '18 at 06:10

Viewed 807 times

I am trying to import a CSV, but my windows username has an "ö" in it.

library(tidyverse)
persons <- read_csv("./data/persons.csv")

This is the error message (anonymized)

Error in guess_header_(datasource, tokenizer, locale) : Cannot read file C:/Users/[...]Ã¶[...]/Desktop/data/persons.csv: The system cannot find the path specified.

[...] replacement to hide the real name.

read.csv works just fine: persons <- read.csv("./data/persons.csv")

I am on a company PC, probably cannot change my Username.

That's what happens if I use the RStudio GUI.

Github tidyverse bug:

This might be related, but I cannot deduce if they fixed it.

edited Jul 18 '18 at 05:36

asked Jul 18 '18 at 05:20

PalimPalim

2,892
1
18
40

Can you use file explorer to select the file you want to read from "Import Dataset" option? – Ronak Shah Jul 18 '18 at 05:22
no, see updatetd question. @RonakShah Is that what you meant? – PalimPalim Jul 18 '18 at 05:26
Not solving your real problem but a workaround could be move the csv to another path where you don't have such characters and then read it from there. – Ronak Shah Jul 18 '18 at 05:41
Thanks, that's a good start and will work as a quick workaround until there is a better solution or workaround. Thank you! – PalimPalim Jul 18 '18 at 05:43
Have you tried `Sys.setlocale(category = "LC_ALL", locale = "German")` before running the read_csv command? – Prometheus Jul 18 '18 at 07:06
@Prometheus thank you for the suggestion. I have tried it right now, but it gives me the same error. – PalimPalim Jul 18 '18 at 07:08

read_csv() with german special character in path

0 Answers0