how to remove multiple columns in r dataframe

Question

I am trying to remove some columns in a dataframe  I want to know why it worked for a single column but not with multible columns e g  this works   album2  5  lt - NULL   this doesn t work  album2  c 5 7   lt - NULL Error in    lt - data frame    tmp      5 7  value   NULL     replacement has 0 items  need 600   This also doesn t work  for  i in 5   length album2 -1     album2  i  lt - NULL   Error in    lt - data frame    tmp      i  value   NULL     new columns would leave holes after existing columns

User · Answer

Ahmed Elmahy following approach should help you out  when you have got a vector of column names you want to remove from your dataframe   test df  lt - data frame col1   c  a    b    c    d    e    col2   seq 1  5   col3   rep 3  5   rm col  lt - c  col2   test df     colnames test df   in  rm col   drop   FALSE    All the best  ExploreR

User · Answer

Adding answer as this was the top hit when searching for  drop multiple columns in r    The general version of the single column removal  e g df column1  lt - NULL  is to use list NULL    df   c  column1    column2     lt - list NULL   This also works for position index as well   df   c 1 2    lt - list NULL   This is a more general drop and as some comments have mentioned  removing by indices isn t recommended  Plus the familiar negative subset  used in other answers  doesn t work for columns given as strings    gt  iris   -c  Species    Error in - Species    invalid argument to unary operator

User · Answer

x  lt -dplyr  select dataset df  -c  coloumn1    column2     This works for me

User · Answer

Basic subsetting   album2  lt - album2   -5   delete column 5 album2  lt - album2   -c 5 7     delete columns 5 through 7

User · Answer

If you only want to remove columns 5 and 7 but not 6 try   album2  lt - album2  -c 5 7    deletes columns 5 and 7

[r] how to remove multiple columns in r dataframe?

Examples related to r

Examples related to dataframe

Examples related to subset