[R] Sorting / editing a table

[Tobias Verbeke]

Jörg Groß wrote:

> I have a problem sorting a table;
> 
> When I read a table into R by x <- read.table() I get something like this:
> 
> V1    V2    V3
> yes    1    3
> no    2    6
> yes    3    9
> no    4    12
> 
> Now I want to generate a vector of V2.
> But R should only put in the numbers of V2 into the new vector when 
> there is the entry "yes" in V1.

x <- data.frame(V1 = factor(c("yes", "no", "yes", "no")), V2 = 1:4)
# vector as result
newVector <- x$V2[x$V1 == "yes"]
newVector
# subsetting a data.frame
newX <- subset(x, V1 == "yes")
newX

HTH,
Tobias