Pandas get all columns without one [duplicate]

Question

In pandas, if I have a dataframe called df, I can get one column with

df.column_one

and, I can get some specific columns with

df[['column_one', 'column_two']]

how I can get all columns without one specific?

Example: if I have a dataframe with n columns col_1, col_2, ... col_n, How I can get all columns without col_n?

There is a little known method that does this: df[df.columns.difference('col_n')]. — IanS
– IanS, Commented May 25, 2016 at 15:09

MaxU - stand with Ukraine · Accepted Answer · 2016-05-25 15:23:44Z

11

try this:

df.drop(['col_n'], axis=1)

or

df.loc[:, df.columns != 'col_n']

or

df.loc[:, df.columns - ['col_n']]

or as @IanS posted in the comment:

df[df.columns.difference('col_n')]

or using filter() function in junction with negative look ahead RegEx:

df.filter(regex=r'^((?!col_n).*)$')

answered May 25, 2016 at 14:57

212k37 gold badges402 silver badges436 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

There is also a little known method that does this: df[df.columns.difference('col_n')].

@IanS, thanks! I've added it to the answer

Jan van der Vegt · Accepted Answer · 2016-05-25 14:57:30Z

1

You can use df.drop:

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

answered May 25, 2016 at 14:57

Jan van der Vegt

1,51114 silver badges34 bronze badges