python - Drop columns whose name contains a specific string from pandas DataFrame

Question

I have a pandas dataframe with the following column names:

Result1, Test1, Result2, Test2, Result3, Test3, etc...

I want to drop all the columns whose name contains the word "Test". The numbers of such columns is not static but depends on a previous function.

How can I do that?

Answer 1

Here is one way to do this:

df = df[df.columns.drop(list(df.filter(regex='Test')))]