Group Abstract Group Abstract

Message Boards Message Boards

0
|
6.7K Views
|
4 Replies
|
2 Total Likes
View groups...
Share
Share this post:

Import csv with the semicolon seperator

Posted 5 years ago

I have the following csv file (attached file)

ch1;ch2;ch3
10;1;100
20;2;200
30;3;300
40;4;400
50;5;500

I want to import it to Mathematica as a Dataset, and I tried the following command:

Import["ref.csv", "Dataset", "FieldSeparators" -> {";"}]

which gave me the following:

enter image description here

whereas what I want is obviously

enter image description here

Any help?

Reply to this discussion
Community posts can be styled and formatted using the Markdown syntax.
Reply Preview
Attachments
Remove
or Discard
Be respectful. Review our Community Guidelines to understand your role and responsibilities. Community Terms of Use