Wrong number of values when importing csv in Weka

Question

I want to open a csv file (saved from openoffice calc) in weka.

I keep getting an error: "wrong number of values. 140 read, 139 expected on line 3."

The csv was already fixed with quotes around the labels. And I count 140 values on the first lines.

What is wrong here?

Link to the file.

Sauder

The question contains a link that is dead. Please, fix it and put the right link to the file which gives a point to this question. – Mistrot

Answer 1

Turns out there was an value somewhere for beyond sight in the excel file I was exporting.

I noticed it because all the rows ended with a comma instead of nothing.

Carefully selected only the right reach, copied in a document and works.

Hope this helps somebody else as well.

Sauder

Answer 2

I had the same error.!!!! I found the solution.

Just remove all the double-quote, single-quote from the .csv, .xls file.

i,e for eg. under the Name column if the value is "john" it throws an error. Make it to john by removing the quotes.

To remove all the quotes, go to the excel file FInd and replace box.

Find what - "

Replace with - (empty space)

Upbringing

There are no double/single quotes on my dataset, but still the same error occurs. – Lafferty

Answer 3

I also went through the same problem when I was using Weka and importing a csv file.

The problem is with the wrong formatting of the file

In my file there was a word in one of the columns GOV'T what I just did was removed the "'" and wrote a whole word GOVERNMENT and it worked.

Hope this helps !!

Deyoung

Answer 4

I had the same error. Problem was a sigle quote character in a string value. Solution for me was to eclose the whole string value in double quotes.

So I have to convert

              this: ...,Uncharted 3: Drake's Deception,...

           to this: ...,"Uncharted 3: Drake's Deception",...

using weka v. 3.8.0

Intreat

Answer 5

This is because of addition of extra column. So to get rid of that error, select whole of that column and delete that column. That should work fine. :)

Pereira

Answer 6

I also encountered with that error. My csv file contains floating numbers. I have solved that problem by replacing "," with "." .

Clinton

Answer 7

For me all of the above worked. I replaced " ' , with space.

Burgener

Answer 8

I had the same error before. I changed my .xls files without any blank ranks. Sometimes the Weka loaded too many "," . But if I clear the blank ranks than the Weka could be work.

Kultur

Answer 9

If you have copied data from another file using Conrol+A, Control+C and control+V, you copied extra columns. if you open csv file in Nodepad you will see comma in the end of each row. you got this error because of the comma in the end of each row.

To avoid this error, press Control and select columns one by one then Control+C now copy it to new File which you will use in weka. or you can use another method to avoid comma in the end of each row.

Astri

Answer 10

I encountered the same problem. Replacing/ erasing all " and ' with space worked for me!

Goldarn

This does not really answer the question. If you have a different question, you can ask it by clicking Ask Question. To get notified when this question gets new answers, you can follow this question. Once you have enough reputation, you can also add a bounty to draw more attention to this question. - From Review – Shinberg