Create columns from read.csv? How?

General
1

Hi

This is how my raw data looks like in excel. This file is saved as .csv.
image
I then open it with R using
read.csv(file.choose())
The result is:
image
But I want it to simply create two columns, just like in the excel file. Is there any quick way to do that when opening the .csv file?

2

Try

read.csv(file.choose(),  sep = ";")

It looks like the separator is a semicolon and not a comma.

1 Like
3

Works! Thank you very much.

4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.