"Order of Attributes in the CSV file"
Shubha
New Altair Community Member
Hi,
Thanks and Regards,
Shubha
<operator name="Root" class="Process" expanded="yes">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?
<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>
Thanks and Regards,
Shubha
0
Answers
-
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>0 -
Wonderful...
Thanks0