List all column except for one in R

Question

Possible Duplicate    Drop Columns R Data frame       Let s say I have a dataframe with column c1  c2  c3   I want to list just c1 and c2  How do I do that   I ve tried   head data column   c3    head data   2  head data   c3

User · Accepted Answer

You can index and use a negative sign to drop the 3rd column:

data[,-3]

Or you can list only the first 2 columns:

data[,c("c1", "c2")]
data[,1:2]

Don't forget the comma and referencing data frames works like this: data[row,column]

User · Answer

In addition to tcash21 s numeric indexing if OP may have been looking for negative indexing by name   Here s a few ways I know  some are risky than others to use   mtcars   -which names mtcars      carb      only works on a single column mtcars   names mtcars      carb             only works on a single column mtcars    names mtcars   in  c  carb    mpg     mtcars   -match c  carb    mpg    names mtcars     mtcars2  lt - mtcars  mtcars2 hp  lt - NULL          lost column  risky    library gdata   remove vars mtcars2  names c  mpg    carb    info TRUE     Generally I use   mtcars    names mtcars   in  c  carb    mpg       because I feel it s safe and efficient

[r] List all column except for one in R

Examples related to r

Examples related to dataframe