3.3 marff2csv - Conversion from arff to csv Format

Convert data from arff format (data format for WEKA) to csv format.

arff format data

The arff data format is described below.

@RELATION       Title

@ATTRIBUTE      Field name    string(character string)
@ATTRIBUTE      Field name    date(date format:format is optional.
                                If not defined, "yyyy-MM-dd'T'HH:mm:ss"）
@ATTRIBUTE      Quantity    numeric(number)
@ATTRIBUTE      Product    {A,B}(category field type)

@DATA(Actual data)
No.1,20081201,1,10,A
No.2,20081202,2,20,A
No.3,20081203,3,30,A
No.4,20081201,4,40,B
No.5,20081203,5,50,B

Format

marff2csv [i=] [o=] [-nfn] [-nfno] [--help] [--version]

Example

Example 1: Basic Example

Convert customer purchasing data in arff format to csv format.

$ more dat1.arff
@RELATION       Customer Purchase Data

@ATTRIBUTE      Customer    string
@ATTRIBUTE      Date    date yyyyMMdd
@ATTRIBUTE      Quantity    numeric
@ATTRIBUTE      Amount    numeric
@ATTRIBUTE      Product    {A,B}

@DATA
No.1,20081201,1,10,A
No.2,20081202,2,20,A
No.3,20081203,3,30,A
No.4,20081201,4,40,B
No.5,20081203,5,50,B
$ marff2csv i=dat1.arff  o=rsl1.csv
#END# kgarff2csv i=dat1.arff o=rsl1.csv
$ more rsl1.csv
Customer,Date,Quantity,Amount,Product
No.1,20081201,1,10,A
No.2,20081202,2,20,A
No.3,20081203,3,30,A
No.4,20081201,4,40,B
No.5,20081203,5,50,B

Related Command

mcsv2arff

Reference

http://weka.wikispaces.com/ARFF