Pandas: Subset a data frame by column names NOT wanted

Question

To subset a dataframe by column names I usually do:

df[['A', 'B']]

where list(df.columns.values) = ['A', 'B', 'C', 'D']

Say I instead wanted to get all the columns except 'B'. How would I do this? This apparently does not work:

df[!['B']]

Answer 1

Use the drop method:

df.drop('B', axis=1)

drop can also accept a list of columns, if you wish to drop more than one.