Read data from text file and sort into a vector

Question

I have a data file like so ...

Control,3
Test,3
Control,3
Control,3
Test,1
Control,3
Control,1

I want to load them into 2 vectors test and control. Any ideas?

What have you tried? Can you provide a [reproducible example](http://stackoverflow.com/q/5963269)? — Jilber Urbina, Jan 09 '13 at 15:56
Ive used mydata = read.csv("c:/Users/james/Desktop/4sec_vs_2sec_Data_Rate.txt") — user1962843, Jan 09 '13 at 16:02

score 3 · Accepted Answer · answered Jan 09 '13 at 16:01

Try read.csv()

dat <- read.csv(text = "Control,3
Test,3
Control,3
Control,3
Test,1
Control,3
Control,1", header = FALSE)

> dat
       V1 V2
1 Control  3
2    Test  3
3 Control  3
4 Control  3
5    Test  1
6 Control  3
7 Control  1

However, you'll need read.csv(file = "foo.csv", header = FALSE) and replace foo.csv with the path to and name of your file.

Then

test <- with(dat, V2[V1 == "Test"])
control <- with(dat, V2[V1 == "Control"])

> test
[1] 3 1
> control
[1] 3 3 3 3 1

Presuming I have understood what you want?

Err, that's what `test` and `control` are; 2 vectors. To get mean or SD of them do `mean(control)`, `sd(test)` etc. — Gavin Simpson, Jan 09 '13 at 16:12

Read data from text file and sort into a vector

1 Answers1