What does the “More Columns than Column Names” error mean?

by

I’m trying to read in a .csv file from the IRS and it doesn’t appear to be formatted in any weird way.

I’m using the read.table() function, which I have used several times in the past but it isn’t working this time; instead, I get this error:

data_0910<-read.table("/Users/blahblahblah/countyinflow0910.csv",header=T,stringsAsFactors=FALSE,colClasses="character")

Error in read.table("/Users/blahblahblah/countyinflow0910.csv",  : 
  more columns than column names

Why is it doing this?

For reference, the .csv files can be found at:

http://www.irs.gov/uac/SOI-Tax-Stats-County-to-County-Migration-Data-Files

(The ones I need are under the county to county migration .csv section – either inflow or outflow.)

Leave a Comment