Raw Message

Message-ID: <CABcx46BjgGysuj68=Q88SPOC+vaXV6KSpKCXt1z_1xJtGtxf2g@mail.gmail.com>
Date: 2016-04-26T21:21:00Z
From: John
Subject: table , exclude - count the frequency in a data frame but exclude one value

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]]