Prevent write csv from converting reals to strings
GaryKG
New Altair Community Member
I've used 'Score Test Data' operator to produce a scored dataset. I now want to export this to a csv. I used 'Write CSV' operator, chose ',' as the separator, and UTF-8 encoding. I only checked the box for 'write attribute names'.
After running, the scored dataset does have the scores as 'reals' (type of data), as confirmed in the 'Statistics' tab.
However, when I open the csv file that was created, the scored variable values have been converted to string (the operator added an apostrophe in front of every real value).
How to stop 'Write CSV' from doing this?
(I know how to manipulate the csv file and reconvert strings to reals. But this is a pain to do every time, much better to use 'Write CSV' correctly; if it is a bug in 'Write CSV', better to fix it.)
After running, the scored dataset does have the scores as 'reals' (type of data), as confirmed in the 'Statistics' tab.
However, when I open the csv file that was created, the scored variable values have been converted to string (the operator added an apostrophe in front of every real value).
How to stop 'Write CSV' from doing this?
(I know how to manipulate the csv file and reconvert strings to reals. But this is a pain to do every time, much better to use 'Write CSV' correctly; if it is a bug in 'Write CSV', better to fix it.)
0
Answers
-
Hi @GaryKG,
I've just tested this from my side, and it appears to be working as expected (writes out without adding apostrophes). Could you possibly share your process and example data and I can take a look? Also could I just confirm which version you are using?
Best,
Roland
0 -
Hi @rjones13
I've attached the scored data file and process.0
Altair Employee