[SOLVED] Type 'text' no longer available when importing data

juanm_encinas
juanm_encinas New Altair Community Member
edited November 5 in Community Q&A
Hi,
I am importing a csv file into my local repository. One of the fields is type 'text', but after upgrading to Rapidminer 7 I only find 'polynomial' as option, 'text' seems to have disappeared. However, I still need the 'text' option, as I have to map those text strings into nominal values, and the 'Text to Nominal' operator does exist, but 'Polynomial to Nominal' does not.
How can I change the type of the attribute to text when importing the data? Or, alternatively, how can I have a 'Polynomial to Nominal' conversion?
Thanks

Answers

  • Marco_Boeck
    Marco_Boeck New Altair Community Member
    Hi,

    If you want nominal as a result you can just stick with polynominal. Polynominal simply describes a string attribute with a nominal mapping and possibly n different strings where n = number of examples.
    There should be nothing that requires "nominal" input but denies polynominal.

    Cheers,
    Marco
  • juanm_encinas
    juanm_encinas New Altair Community Member
    Hi Marco,
    actually, I am using the data set as input for a linear regression model, but the linear regression model does not accept polynominal inputs. So, I have to convert any text/polynominal attributes to nominal.
    Thanks
  • MartinLiebig
    MartinLiebig
    Altair Employee
    Hi Juan,

    linear regression is only excepting numerical input. So you need to transform polynominal inputs into numericals (integer, reals).

    ~Martin
  • juanm_encinas
    juanm_encinas New Altair Community Member
    Right. That's the problem. The process to import my csv file only allows me to define this attribute as polynominal. But there's no 'polynominal to numerical' operator. I could use a chain of 'polynominal to nominal' followed by 'nominal to numerical', but there's no  'polynominal to nominal'  operator either.

    With RapidMiner 6 I had the option to import my csv using attribute type 'text'. Then I could chain 'text to nominal' followed by 'nominal to numerical'.

    So, is there an option to transform a polynominal attribute into numerical or nominal with RapidMiner 7?

    Thanks
  • David_A
    David_A New Altair Community Member
    Hi,

    the  'nominal to numerical'  Operator is called "Parse Numbers", that should do the trick.

    Best,
    David
  • juanm_encinas
    juanm_encinas New Altair Community Member
    Sorry, but that's not my problem. My problem is to convert a polynomial attribute into either nominal or numerical.
  • MartinLiebig
    MartinLiebig
    Altair Employee
    Hi,

    A polynominal attribute is always nominal. It is "nominal with many classes". Same as all reals are numericals.

    To convert (Poly)nominals to numeric, you can use Nominal to Numerical.

    Best,
    Martin
  • juanm_encinas
    juanm_encinas New Altair Community Member
    Hi Martin,

    it works beautifully!!!!!

    Thanks so much for the great tip, much appreciated