Importing a CSV file
In this exercise, you will import the file sample.csv
using both read.csv()
and fread()
to compare these functions. Here are the contents of this file:
id,"name",val
29192,"Robert Whitaker", 200
49301 ,"Elisa Waters,190
The values in the file are separated by a comma. Note the unwanted spaces between entries, and the imbalanced quote in the second row.
This exercise is part of the course
Data Manipulation with data.table in R
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Import using read.csv()
csv_file <- ___(___, fill = NA, quote = "",
strip.white = TRUE,
header = TRUE)
csv_file