How to convert the arff object loaded from a .arff file into a dataframe format?

Question

I was able to load the .arff file using the following commands. But I was not able to extract the data from the object and convert the object into a dataframe format. I need this to do apply machine learning algorithms on this dataframe.

Command:-

import arff
dataset = pd.DataFrame(arff.load(open('Training Dataset.arff')))
print(dataset)

Please help me to convert the data from here into a dataframe.

score 17 · Answer 1 · answered Nov 18 '17 at 14:02

17

import numpy as np
import pandas as pd
from scipy.io.arff import loadarff 

raw_data = loadarff('Training Dataset.arff')
df_data = pd.DataFrame(raw_data[0])

Try this. Hope it helps

answered Nov 18 '17 at 14:02

Sagar Dawda

1,126
9
17

score 0 · Answer 2 · edited Oct 12 '22 at 23:45

0

from scipy.io.arff import loadarff
import pandas as pd

data = loadarff('Training Dataset.arff')
df = pd.DataFrame(data[0])

Similar to answer above, but no need to import numpy

edited Oct 12 '22 at 23:45

Peej1226

132
12

answered Feb 06 '21 at 17:56

Adilius

308
2
10

The import statement is incorrect. This will not run b/c in line 4 `arff` is not defined. – Devon Feb 05 '22 at 21:57

How to convert the arff object loaded from a .arff file into a dataframe format?

2 Answers2