convert nominal to numerical problem

sebastian_gonza
sebastian_gonza New Altair Community Member
edited November 2024 in Community Q&A

Hi

 

I want to convert nominal values into numeric, I tried the dummy coding but a column is generated for each value there is, then I use unique integers and I get like an order number but not what the number actually is, all I want is one column with the numeric values, any ideas?

 

 

Tagged:

Best Answer

Answers

  • phellinger
    phellinger New Altair Community Member

    Hi,

     

    is this a question related to Radoop. I am just asking because of your other recent question... If yes, then probably "Type Conversion" operator is the one you are looking for.

    If it is Studio, then "Parse Numbers" operator looks promising.

     

    Best,

    Peter 

  • lionelderkrikor
    lionelderkrikor New Altair Community Member

    Hi @sebastian_gonza,

     

    Have you try to : 

     - set your concerned attributes as numeric in the import configuration wizard (step 4 / 4).

        AND/OR

     - use the Parse Numbers operator on your concerned attributes.

     

    I hope it helps,

     

    Regards,

     

    Lionel

  • sebastian_gonza
    sebastian_gonza New Altair Community Member

    I am extracting a sample from a hive data set throught a retrieve and then store it in my local repository, is there a way to do it during the workflow?

  • sebastian_gonza
    sebastian_gonza New Altair Community Member

    Here is the workflow and the data I am using, if you have an idea please let me know

     

    thks

  • sebastian_gonza
    sebastian_gonza New Altair Community Member
    Answer ✓

    I used a guess type and worked, thks anyways :)