Hello,

Thank you for sharing the code you created.
Like I said in the subject, after I convert csv file to arff file via the code, there is nothing in arff file format when I open it with text editor.
I am wondering if it happens to me only. Would you please help me to solve the issue?

Thank you,
Joon

Where is the ARFF file stored after converting CSV to ARFF ?

Hello,

As of now, the code that author created tries to add single quotes to every value. (FYI, the part of the code is below).

check for comams or blanks and adds single quotes

for j in range(0,totalCols):
for i in range(1,totalRows):
allData[i][j] = allData[i][j].lower()
if "\r" in allData[i][j] or '\r' in allData[i][j] or "\n" in allData[i][j] or '\n' in allData[i][j]:
allData[i][j] = allData[i][j].rstrip(os.linesep)
allData[i][j] = allData[i][j].rstrip("\n")
allData[i][j] = allData[i][j].rstrip("\r")
try:
if allData[i][j] == str(float(allData[i][j])) or allData[i][j] == str(int(allData[i][j])):
print
except ValueError as e:
allData[i][j] = "'" + allData[i][j] + "'"

However, I am wondering how to add single quotes to values with space only, such as Bosnia and Herzegovina.
For example,
the return should be like... {Algeria, Argentina, 'Bosnia and Herzegovina', Chile, 'Costa Rica'} .

Please feel free to leave any comment and give help.

Thank you for your help.

Sincerely,

pr.zip

Hello,

While I was looking at the code that the author created, I had a curious if there is a way to sort the attribute showing unique data of each column in alphabetical order when the csv format converted to arff format. For example, in @Attribute 'Group', it shows {'h','f','b','a','c','d','e','g'}. But, I am wondering how I can make it show as {'a','b','c','d','e','f','g','h'}.

I've tried sort() function in the code, but it did not work and was confused about where to put it.
Please help me to solve this issue.

Thank you!

Hello,

I've been looked through this code (it is really helpful to understand converting csv to arff format. Thank you so much) over the last two weeks.

While I was thinking about this code, I suddenly had a question about how to convert the arff file to sparse arff format.

I've been thinking about it but am not sure how to implement it based on this code.