Column that starts with

Question

I have a data frame with multiple columns, for example:

        Prod_A       Prod_B        Prod_C        State         Region
1          1           0             1             1              1

I would like to delete all columns starting with Prod_ (I cannot select or delete by name because there are 200 variables in the data frame) Can this be done?

thank

Answer 1

Use startswithfor mask and then remove columns with locand boolean indexing:

df = df.loc[:, ~df.columns.str.startswith('Prod')]
print (df)
   State  Region
1      1       1

Answer 2

First select all the columns you want to delete:

unwanted = df.columns[df.columns.str.startswith('Prod_')]

Drop all:

df.drop(unwanted, axis=1, inplace=True)

Answer 3

we can also use negative regEx:

In [269]: df.filter(regex=r'^(?!Prod_).*$')
Out[269]:
   State  Region
1      1       1