"Order of Attributes in the CSV file"

Shubha
Shubha New Altair Community Member
edited November 2024 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

Welcome!

It looks like you're new here. Sign in or register to get started.

Welcome!

It looks like you're new here. Sign in or register to get started.