Read csv file separated by semicolons (";") using the {arrow} package in R

Question

I have a semicolon-separated csv file that has millions of rows of data. I want to use arrow to read it faster, but arrow doesn't provide a function like readr::read_csv2 or read.csv2 in base. How can I read a semicolon-separated csv file using arrow's implementation for R?

`arrow::read_delim_arrow("your/path", delim = ";")` – alistaire Jun 30 '23 at 23:05 — alistaire, Jun 30 '23 at 23:05

score 3 · Accepted Answer · answered Jun 30 '23 at 17:55

In order to read a csv file that's separated by semicolons using the arrow package, use the argument parse_options = CsvParseOptions$create(delimiter = ";") inside your reading function, like this:

library(arrow)
data <- arrow::read_csv_arrow("data/AtencionesUrgencia2022.csv",
                                    parse_options = CsvParseOptions$create(delimiter = ";"))

Read csv file separated by semicolons (";") using the {arrow} package in R

1 Answers1