Unable to read in csv with read.csv function

Question

Ive used the read.csv function for years and never seen this error.

zError in make.names(col.names, unique = TRUE) : invalid multibyte string 10

I have a fairly standard .csv file I am trying to read in (download a copy here). Any ideas on what is going on?

I Think the responses in this link might help [QUestion that might be similar to this][1] [1]: stackoverflow.com/questions/18444769/… — Lunalo John
– Lunalo John, Commented Mar 1, 2019 at 18:15
read.csv(file, sep=",", check.names =F) as mentioned by @Douglas Mesquita will work and you will see you have a wierd character in Cavity_Nester<ca>. <ca> is what's throwing you off. also have a look at package janitor and clean_names function from it — infominer
– infominer, Commented Mar 1, 2019 at 18:20

Douglas Mesquita · Accepted Answer · 2019-03-01 18:00:34Z

3

It means that something is strange in your column names. Try to use the argument check.names = FALSE in your call. Also be sure you are giving the right sep argument.

answered Mar 1, 2019 at 18:00

Douglas Mesquita

1,0217 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Sonny · Accepted Answer · 2019-03-01 18:05:24Z

2

Some on your columns might have special characters. read_csv from readr package should be able to deal with that well and it is very fast too.

answered Mar 1, 2019 at 18:05

Sonny

3,1651 gold badge13 silver badges19 bronze badges

Collectives™ on Stack Overflow

Unable to read in csv with read.csv function

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related