R read.csv, adding a 1st column with unwanted text

Question

I exported data from the result grid in SQL Server Management Studio to a csv file. The csv file looks correct.

But when I read the data in the R framework using read.csv, the first column name is added to " ï .. ". How to get rid of this unwanted text?

Example:

str(trainData)

'data.frame':   64169 obs. of  20 variables:    
 $ ï..Column1             : int  3232...   
 $ Column2                : int  4242...

The data looks something like this (nothing special):

Column1, Column2
100116577,100116577
100116698,100116702

+3

Daniel PP Cabral Jul 04 '14 at 6:33

1 answer

Spacedman · Accepted Answer · 2014-07-04T07:07:22+0000

You have the Unicode UTF-8 specification at the beginning of the file:

-, ISO-8859-1 CP1252 ï "¿

R ï, , - .

:

:

"UTF-8-BOM",

, read.csv fileEncoding="UTF-8-BOM" , SQL- .

, ï.. substr ( , , , )