PDA

View Full Version : xls CSV WEKA



taoufiq1983
12-31-2008, 08:12 AM
Hello,

I work with WEKA on a project that will integrate WEKA in our busness .

My first goal is to load data, but data that I have are in. xls, and when I do the conversion. csv, WEKA do not know the data and get back loading errors.

thank you for your help .is urgent


:)

Mark
12-31-2008, 03:17 PM
Hi,

When you export CSV from Excel, make sure that each row has exactly the same number of fields. Note that Weka's CSV reader can't handle nested quotes - e.g. something like

,...,'here is Mark's text',...

will cause problems. In this case the outer quotes need to be double quotes.

If you continue to experience problems, then another option is to use Pentaho Data Integration (PDI) with the ARFF output plugin. PDI has more sophisticated CSV reading capabilities than Weka does.

Cheers,
Mark.