R’s read.csv prepending 1st column name with junk text [duplicate]

by

You’ve got a Unicode UTF-8 BOM at the start of the file:

http://en.wikipedia.org/wiki/Byte_order_mark

A text editor or web browser interpreting the text as ISO-8859-1 or
CP1252 will display the characters  for this

R is giving you the ï and then converting the other two into dots as they are non-alphanumeric characters.

Here:

http://r.789695.n4.nabble.com/Writing-Unicode-Text-into-Text-File-from-R-in-Windows-td4684693.html

Duncan Murdoch suggests:

You can declare a file to be in encoding “UTF-8-BOM” if you want to
ignore a BOM on input

So try your read.csv with fileEncoding="UTF-8-BOM" or persuade your SQL wotsit to not output a BOM.

Otherwise you may as well test if the first name starts with ï.. and strip it with substr (as long as you know you’ll never have a column that does start like that genuinely…)

More Related Contents:

  1. Read a UTF-8 text file with BOM
  2. How to use Greek symbols in ggplot2?
  3. How to source() .R file saved using UTF-8 encoding?
  4. Force character vector encoding from “unknown” to “UTF-8” in R
  5. how to read data in utf-8 format in R?
  6. Unicode Characters in ggplot2 PDF Output
  7. Set locale to system default UTF-8
  8. How to identify/delete non-UTF-8 characters in R
  9. R tm package invalid input in ‘utf8towcs’
  10. RStudio not picking the encoding I’m telling it to use when reading a file
  11. R on Windows: character encoding hell
  12. Manipulating files with non-English names in R
  13. How to remove strange characters using gsub in R? [duplicate]
  14. Error in function syntax [closed]
  15. Aggregate / summarize multiple variables per group (e.g. sum, mean)
  16. Order Bars in ggplot2 bar graph
  17. Make the background of a graph different colours in different regions
  18. Using data.table package inside my own package
  19. Create a data.frame where a column is a list
  20. POSIX character class does not work in base R regex
  21. Add new row to dataframe, at specific row-index, not appended?
  22. Building R package and error “ld: cannot find -lgfortran”
  23. Update a Value in One Column Based on Criteria in Other Columns
  24. Append data frames together in a for loop
  25. ‘Embedded nul in string’ error when importing csv with fread
  26. Show names of everything in a package
  27. Advantages of reactive vs. observe vs. observeEvent
  28. How can I arrange an arbitrary number of ggplots using grid.arrange?
  29. How to shade a region under a curve using ggplot2
  30. Smaller gap between two legends in one plot (e.g. color and size scale)

Leave a Comment