Wrong number of values when importing csv in Weka

csv dataset weka
dorien picture dorien · Nov 18, 2013 · Viewed 26.8k times · Source

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.

Answer

dorien picture dorien · Nov 18, 2013

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.

Related questions

Populating a dataset from a CSV file

I would like to read the contents of a CSV file and create a dataset. I am trying like this: var lines = File.ReadAllLines("test.csv").Select(a => a.Split(';')); DataSet ds = new DataSet(); ds.load(lines); …

Read More
How to view a DataTable while debugging

I'm just getting started using ADO.NET and DataSets and DataTables. One problem I'm having is it seems pretty hard to tell what values are in the data table when trying to debug. What are some of the easiest ways …

Read More
JMeter CSV Dataset Config: how to move through variables in the same thread?

I'm using a CSV dataset config element, which is reading from a file like this: abd sds ase sdd ssd cvv Which, basically, has a number of 3 letter random string. I'm assigning them to a variable called ${random_3}. Now, I …

Read More