Reading files with double double quotes in R

Viewed 114

I am reading a few thousand csv files where some columns have a very 'interesting' format: {""Q0"":""double double quote""}

It seems read.csv reads it fine, but both read_csv and fread are doing different things (see below). My expectation would be to have: {"Q0":"double double quote"}

Is this a bug or am I doing something wrong?

# Content of csv file
# "numbers", "simple_quote", "double_quote"
# "9", "quoted text", "{""Q0"":""double double quote""}"

library(readr)  
library(data.table)
  
read.csv("test.csv")
#>   numbers simple_quote                  double_quote
#> 1       9  quoted text  {"Q0":"double double quote"}

read_csv("test.csv")
#> # A tibble: 1 x 3
#>   numbers simple_quote double_quote                      
#>     <dbl> <chr>        <chr>                             
#> 1       9 quoted text  "{\"Q0\":\"double double quote\"}"

fread("test.csv")
#>    numbers simple_quote                     double_quote
#> 1:       9  quoted text {""Q0"":""double double quote""}

Created on 2021-04-09 by the reprex package (v2.0.0)

1 Answers
Related