"Order of Attributes in the CSV file"

Shubha
Shubha New Altair Community Member
edited November 5 in Community Q&A
Hi,
<operator name="Root" class="Process" expanded="yes">
    <operator name="ExampleSetGenerator" class="ExampleSetGenerator">
        <parameter key="target_function" value="random"/>
        <parameter key="number_examples" value="10"/>
    </operator>
    <operator name="ChangeAttributeRole" class="ChangeAttributeRole" activated="no">
        <parameter key="name" value="label"/>
    </operator>
    <operator name="CSVExampleSetWriter" class="CSVExampleSetWriter" breakpoints="before">
        <parameter key="csv_file" value="check.csv"/>
        <parameter key="column_separator" value=","/>
    </operator>
</operator>
I want to write the data generated to a CSV file. While writing, the special attribute, 'label' is written as the last attribute in the CSV file, check.csv. But I need to write the data as the order appears in the Exampleset like (label,att1,att2,att3,att4,att5). Any hints on this?

Thanks and Regards,
Shubha
Tagged:

Answers

  • haddock
    haddock New Altair Community Member
    Hi Shubha,

    You get that column order control using the special format option on the ExampleSetWriter, like this..
    <operator name="Root" class="Process" expanded="yes">
        <operator name="ExampleSetGenerator" class="ExampleSetGenerator">
            <parameter key="target_function" value="random"/>
        </operator>
        <operator name="IdTagging" class="IdTagging">
        </operator>
        <operator name="ExampleSetWriter" class="ExampleSetWriter">
            <parameter key="example_set_file" value="C:\Users\CJFP\Documents\rm_workspace\bla.dat"/>
            <parameter key="format" value="special_format"/>
            <parameter key="special_format" value="$l,$i,$a[,]$n"/>
        </operator>
        <operator name="CSVExampleSource" class="CSVExampleSource">
            <parameter key="filename" value="C:\Users\CJFP\Documents\rm_workspace\bla.dat"/>
            <parameter key="read_attribute_names" value="false"/>
        </operator>
    </operator>
  • Shubha
    Shubha New Altair Community Member
    Wonderful...

    Thanks