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
image243×301 2.63 KB

I then open it with R using
read.csv(file.choose())
The result is:
image
image152×185 1.48 KB

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.

3

Works! Thank you very much.