3
$\begingroup$

I wonder how Orange decides which attribute is declared as a string? I have few discrete attributes in Excel, which I can't use as Orange does not recognize them as discrete. Have tried export excel to csv format as well, no difference. Where in Orange I can enforce change from meta to discrete attribute?

Many thanks in advance, Marko

$\endgroup$
1
$\begingroup$

As far as I know, Orange supports advanced annotation with a three-line header in both CSV and Excel files. So if you have a discrete attribute that gets marked as string, you should annote it as discrete on the second header line, or prefix the attribute name on the first line with D#.

When no advanced annotation is provided, it seems Orange's heuristic treats attributes containing general strings (as opposed to numbers) as discrete only if they contain fewer than approximately $\sqrt{|data|}$ unique values.

$\endgroup$
1
  • $\begingroup$ What about data retrieved from SQL? $\endgroup$ – Daddy32 Mar 9 '18 at 10:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.