Missing Values ​​at Weka -

Question

I use adult data from UCI Here , when I converted it to an excel ==> file, then import it into weka weka did not recognize the missing values ​​(which says Missing: 0 (0%)), but the adult data contains missing values ​​with help ?? value...

I checked the value in weka, it also contains "?" so how can i replace all the "?" to "" !!! thanks

Answer 1

In the Explorer, on the preprocess tab, find the filter and select an option. Then expand the filter in the filter, then control, then the attribute. Below you will find the option "Replace the missing value". Double-click on it and click "Apply." Voila! Missing values ​​are replaced.

Answer 2

I can tell the method.

• chose a filter
• selected uncontrolled attribute-ReplaceMissingValues
• To apply

ReplaceMissingValues ​​uses "average" or "median" instead of missing values.

Answer 3

• Do not convert to excel.
• Open the raw file in any text editor.
• Replace all spaces with nothing (e.g. Ctrl-H in notepad).
• Add a title bar.
• Save as adult.csv (select all files in the drop-down list of file types, if in notepad)
• Open in Weka.

Answer 4

I think the solution is simpler. Replace all your missing "?" on "?" (without spaces). Use notepad ++ or another text editor. Most of them have such a tool.

I checked this in Weka explorer. For values ​​with a space, it does not recognize missing values.

Answer 5

Open the file using notepad, replace (ctrl + H) replace all "?" from "?" (just remove the space). It worked for me

Answer 6

put "NaN" instead of the missing values ​​.... it will work