You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I was using readr to open a CSV file which had a cell that ended with a quote. readr::read_delim did not recognize it being dirty, and does not give a warning. It did not return the full dataframe, only the rows before the line with the extra quote.
Example of CSV where read_delim will only return the first row (and also the header), without giving warnings that something may be off:
"a" "b" "c"
"1" "test 1" "A"
"2" "test 2, this cell ends with an extra quote"" "B"
"3" "test 3" "C"
"4" "test 4" "D"
I was using readr to open a CSV file which had a cell that ended with a quote. readr::read_delim did not recognize it being dirty, and does not give a warning. It did not return the full dataframe, only the rows before the line with the extra quote.
Example of CSV where read_delim will only return the first row (and also the header), without giving warnings that something may be off:
Download csv here:
dirty_csv.csv
utils:read.delim() does give a warning
data.table::fread() also gives a warning, tries to fix the cell and returned the complete data set
readr should give a warning at the very least.
The text was updated successfully, but these errors were encountered: