Invalid multibyte string in read.csv

by

Encoding sets the encoding of a character string. It doesn’t set the encoding of the file represented by the character string, which is what you want.

This worked for me, after trying "UTF-8":

x <- read.csv(url, header=FALSE, stringsAsFactors=FALSE, fileEncoding="latin1")

And you may want to skip the first 16 lines, and read in the headers separately. Either way, there’s still quite a bit of cleaning up to do.

x <- read.csv(url, header=FALSE, stringsAsFactors=FALSE,
  fileEncoding="latin1", skip=16)
# get started with the clean-up
x[,1] <- gsub("\u0081|`", "", x[,1])    # get rid of odd characters
x[,-1] <- as.data.frame(lapply(x[,-1],  # convert to numbers
  function(d) type.convert(gsub(d, pattern=",", replace=""))))

More Related Contents:

  1. Specify custom Date format for colClasses argument in read.table/read.csv
  2. ‘Incomplete final line’ warning when trying to read a .csv file into R
  3. How to read only lines that fulfil a condition from a csv into R?
  4. Specifying colClasses in the read.csv
  5. Why am I getting X. in my column names when reading a data frame?
  6. read.csv doesn’t seem to detect factors in R 4.0.0
  7. How to check if CSV file has a comma or a semicolon as separator?
  8. read.csv, header on first line, skip second line [duplicate]
  9. How to detect the right encoding for read.csv?
  10. Combine several data frames in the global environment by row (rbind)
  11. Imported a csv-dataset to R but the values becomes factors
  12. How can I read the header but also skip lines – read.table()?
  13. Weird error in R when importing (64-bit) integer with many digits
  14. Compare two data.frames to find the rows in data.frame 1 that are not present in data.frame 2
  15. Scatterplot with marginal histograms in ggplot2
  16. How to perform natural (lexicographic) sorting in R? [duplicate]
  17. Unlist data frame column preserving information from other column
  18. Calculate the Area under a Curve
  19. How do I change the default library path for R packages
  20. Putting mathematical symbols and subscripts mixed with regular letters [duplicate]
  21. Read a text file in R line by line
  22. Increase distance between text and title on the y-axis
  23. Creating a comma separated vector
  24. the condition has length > 1 and only the first element will be used in if else statement
  25. Setting Defaults for geoms and scales ggplot2
  26. Create new column based on 4 values in another column
  27. What does “not run” mean in R help pages?
  28. How to align multiple ggplot2 plots and add shadows over all of them
  29. Legends for multiple fills in ggplot
  30. R: What are operators like %in% called and how can I learn about them?

Leave a Comment