The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here
Data import wizard should automatically estimate the column separator
yzan
Member Posts: 66 
Unicorn
Comments
hello @yzan - can you give us an example of this?
Scott
RapidMiner has multiple wizards. I am specifically talking about the wizard provided by "Read CSV" operator after clicking on "Import Configuration Wizard", step 2 of 4, section "Column Separation".
The desired functionality is implemented, for reference, in: https://docs.python.org/3/library/csv.html#csv.Sniffer, which is, I think, used behind https://github.com/okfn/messytables. Also, Calc automatically estimates the column separator in their import wizard.
Of course, csv.Sniffer provides additional related estimates like whether the CSV file contains a header, or not. Currently, this has to be set manually in the 3rd step of the wizard.
ok got it. Good suggestion. Thank you.