R programming: error in read.table :more columns than column names

Question

I have a data set in an .xls format and i saved it as .csv file. When I'm trying to read it with

read.table("Gene.csv", header=TRUE, sep=",") it shows:

Error in read.table("Gene.csv", header = TRUE, sep = ",") : more columns than column names

I think that maybe the csv file has some format issues because there are unfilled spaces under one Column. Any help would be grateful !!!!

user2038042 · Accepted Answer · 2015-03-12 19:20:45Z

-2

options(warn=3)

Then run your code looking for an error message.

> dat <- read.table("June2014-Feb2015.csv",header=TRUE,sep=",")
Error in scan(file, what, nmax, sep, dec, quote, skip, nlines, na.strings,  :
  line 3 did not have 10 elements

so I checked line 3 and viola , it was fixed.

answered Mar 12, 2015 at 19:20

user2038042

1351 silver badge4 bronze badges

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

Collectives™ on Stack Overflow

R programming: error in read.table :more columns than column names

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related