How to load excel file in weka

So check your Weka Version, and whether you'll need administrative preferences to modify the directory where your Weka resides. The WekaExcel package seems to be a bit fragile when dealing with large worksheets, and sensitive to, for instance, data-Type inconsistencies in the Columns.

It creates cryptic error messages. But for small, simple worksheets, it seems to work. There are now entries for Excel. Export Excel to csv, and import to Weka csv. Attention change separation marked "," to ";" when import csv to Weka. You pass from excel to. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. You are commenting using your Twitter account. You are commenting using your Facebook account.

Notify me of new comments via email. Notify me of new posts via email. Skip to content April 26, April 26, foongminwong.

We usually get dataset in. Are you ready to start dealing with the missing values?! Steps: Open your data. Then, save it as CSV file. I think the best method may just be to manually create the arff file although you can try to inmport a csv file. Creating a. The format is fairly simple. You start with relation, then have a bunch of attribute statements, and then have a data command, followed by the data, one record per line.

Very often you will have a file with the data only. This could be a regular. Note that C4. Some things to watch out for. As I found out, the. A blank line after the relation command before the attribute commands causes an error! This may not be apparent from the documentation on the.

I suggest that beyond just looking at the. You will need to edit the file with some type of text editor. Wordpad works fine. Some text editors may not preserve the line breaks and will cause a problem. If you are familar with linux, you could always edit it on linux machine with vi or emacs but that is not necessary. On windows it may be easiest to name the file with a. Before that, let us look at how to load the data file from the Web.

You may specify any other URL where your data is stored. The Explorer will load the data from the remote site into its environment. Set the connection string to your database, set up the query for data selection, process the query and load the selected records in WEKA. Weka - Loading Data Advertisements. Previous Page.