divyang4481 / accord

Automatically exported from code.google.com/p/accord
0 stars 0 forks source link

Need support for generic .xls file instead of example.xls that contain only three column #48

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1. Instead of example.xls file i want to attach my excel file to the SVM 
Classifier, When i try to attach my file (attached), the problem i had faced is 
the dataTable object is unable to typecast or read it properly to store in type 
double Matrix. Please suggest me is there any specific file format for 
example.xls as both sheet include 3 column X, Y and G.

What is the expected output? What do you see instead?
I need that SVM will read a generic xls file, with a specified file format of 
column.

What version of the product are you using? On what operating system?
Window 7 , Latest Version.

Please provide any additional information below.

Original issue reported on code.google.com by chaurasi...@gmail.com on 12 May 2013 at 12:28

Attachments:

GoogleCodeExporter commented 9 years ago
Hi there,

The sample application is just what it says, a sample application. The SVM 
works with as many inputs you would like, but the sample application was 
created to handle specifically 2D problems for demonstration purposes.

If you need to read generic XLS files, take a look on the ExcelReader class[1]. 
You can extract a Excel Worksheet as a DataTable[2] and then create a matrix 
from it using Matrix.ToMatrix[3] (an extension method for DataTable objects).

Hope it helps
Cesar

 [1]: http://accord.googlecode.com/svn/docs/html/T_Accord_Statistics_Formats_ExcelReader.htm 
 [2]: http://accord.googlecode.com/svn/docs/html/M_Accord_Statistics_Formats_ExcelReader_GetWorksheet_1.htm
 [3]: http://accord.googlecode.com/svn/docs/html/M_Accord_Math_Matrix_ToMatrix.htm

Original comment by cesarso...@gmail.com on 12 May 2013 at 1:30

GoogleCodeExporter commented 9 years ago

Original comment by cesarso...@gmail.com on 1 Jun 2013 at 10:49