[R] table , exclude - count the frequency in a data frame but exclude one value
jpm miao
miaojpm at gmail.com
Tue Apr 26 23:21:00 CEST 2016
Hi,
I have a data frame with two variables x, y, both of which take values
in the set {1,2,3}. I'd like to count the frequency by the command "table",
but exclude the value "1" in variable x, but keep "1" in variable y. Is it
possible? When I use "exclude", value 1 in both x and y are excluded.
Thanks,
> df <- data.frame(x = 1:3, y = 3:1, z = letters[1:3])
> table(df[,c("y","x")])
x
y 1 2 3
1 0 0 1
2 0 1 0
3 1 0 0
> table(df[,c("y","x")], exclude = 1)
x
y 2 3
2 1 0
3 0 0
> table(df[,c("y","x")], exclude = c(NULL, 1))
x
y 2 3
2 1 0
3 0 0
> table(df[,c("y","x")], exclude = c(1, NULL))
x
y 2 3
2 1 0
3 0 0
> table(df[,c("y","x")], exclude = c(1, 0))
x
y 2 3
2 1 0
3 0 0
> table(df[,c("y","x")], exclude = list(1 , NULL))
Error in as.vector(exclude, typeof(x)) :
(list) object cannot be coerced to type 'integer'
[[alternative HTML version deleted]]
More information about the R-help
mailing list