🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

Association analysis Transform Numerical to Binominal

User: "SunnyLotusFlowe"
New Altair Community Member
Updated by Jocelyn
Hi,

i have found the Numerical to binominal Operator. The problem is, that this Operator is only usefull when applying to a numerical column that have 2 numerical values otherwise many information will get lost.

I am looking for an solution that do the following:

have a column with many different numerical values -> discretize to 10 bins and then -> replace this column by 10 columns which have only the values 1 or 0. 


greetings

Lotus

Find more posts tagged with

Sort by:
1 - 2 of 21
    User: "haddock"
    New Altair Community Member
    Hi there,

    Is this what you had in mind?
    <?xml version="1.0" encoding="UTF-8" standalone="no"?>
    <process version="5.0">
      <context>
        <input/>
        <output/>
        <macros/>
      </context>
      <operator activated="true" class="process" expanded="true" name="Process">
        <process expanded="true" height="335" width="790">
          <operator activated="true" class="generate_data" expanded="true" height="60" name="Generate Data" width="90" x="45" y="75">
            <parameter key="number_of_attributes" value="1"/>
          </operator>
          <operator activated="true" class="discretize_by_bins" expanded="true" height="94" name="Discretize" width="90" x="179" y="75">
            <parameter key="number_of_bins" value="10"/>
            <parameter key="range_name_type" value="short"/>
          </operator>
          <operator activated="true" class="nominal_to_binominal" expanded="true" height="94" name="Nominal to Binominal" width="90" x="367" y="72">
            <parameter key="transform_binominal" value="true"/>
          </operator>
          <connect from_op="Generate Data" from_port="output" to_op="Discretize" to_port="example set input"/>
          <connect from_op="Discretize" from_port="example set output" to_op="Nominal to Binominal" to_port="example set input"/>
          <connect from_op="Nominal to Binominal" from_port="example set output" to_port="result 1"/>
          <portSpacing port="source_input 1" spacing="0"/>
          <portSpacing port="sink_result 1" spacing="0"/>
          <portSpacing port="sink_result 2" spacing="0"/>
        </process>
      </operator>
    </process>
    Good weekend!

    User: "SunnyLotusFlowe"
    New Altair Community Member
    OP
    u r a genius!!  ;D    u saved my life  ;)

    thankx a lot!!!!!


    greeetings

    Lotus