Inconsistent and Incorrect conversion of text "NA" to unknown in the File widget about orange3 HOT 4 OPEN

I can confirm this.

"File" and "CSV File Import" both do this. Neither cares whether NA is put in quotation marks. The only difference is "File" still converts to ? even if "text" type is chosen, "CSV File Import" does not.

from orange3.

Thanks - hadn't noticed that. so I could CSV File Import and choose text as a workaround.

from orange3.

@Newbrie Yes, if you put an Edit Domain after import you can even convert it into categorical.

from orange3.

To sum up:

• If data is smaller, Orange's auto-detection recognizes PD as text attribute. We can tweak these rules, but it's guesswork, so it will never be correct.
• Categorical and text values use a different set of symbols for missing values. I don't think we can do anything here: we cannot prohibit value "NA" in text, and convert it to missing.
• The File widget uses rules text variables even if the user manually changes the type to categorical. I suppose this happens because the type is converted after the data is read.

I suppose the latter is why @markotoplak marked this as a bug (and I agree).

from orange3.