Due to recent updates, all users are required to create an Altair One account to login to the RapidMiner community. Click the Register button to create your account using the same email that you have previously used to login to the RapidMiner community. This will ensure that any previously created content will be synced to your Altair One account. Once you login, you will be asked to provide a username that identifies you to other Community users. Email us at Community with questions.

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

juan7710juan7710 Member Posts: 11 Contributor II
edited November 2018 in Help
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
Tagged:

Answers

  • Marco_BoeckMarco_Boeck Administrator, Moderator, Employee, Member, University Professor Posts: 1,996 RM Engineering
    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
  • juan7710juan7710 Member Posts: 11 Contributor II
    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
  • MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,529 RM Data Scientist
    Hi Juan,

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

    ~Martin
    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany
  • juan7710juan7710 Member Posts: 11 Contributor II
    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_ADavid_A Administrator, Moderator, Employee, RMResearcher, Member Posts: 297 RM Research
    Hi,

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

    Best,
    David
  • juan7710juan7710 Member Posts: 11 Contributor II
    Sorry, but that's not my problem. My problem is to convert a polynomial attribute into either nominal or numerical.
  • MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,529 RM Data Scientist
    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
    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany
  • juan7710juan7710 Member Posts: 11 Contributor II
    Hi Martin,

    it works beautifully!!!!!

    Thanks so much for the great tip, much appreciated
Sign In or Register to comment.