How to apply multiple column filter(String) in python [duplicate]

Question

I would like to apply mutiply keyword filter for filtering down on columns.I tried this code:

df = df.filter(regex='AMP','amp','date')

Error I get :

df = df.filter(regex='AMP','amp','date')
                                ^
SyntaxError: positional argument follows keyword argument.

Basically,I want all the columns with these keywords contained in their column name. Thank you in advance

error message says: never use positional erguments behind keyword arguments in python - simply because position is meaningless after an arbitrary list of kwargs is provided — SpghttCd
– SpghttCd, Commented May 11, 2018 at 7:11

SpghttCd · Accepted Answer · 2018-05-11 07:18:31Z

3

The regex has to be one valid regex string. You separated three strings by comma, so python interpreted the last two strings as separate arguments (without keyword). the proper 'or' - operator in regex is '|', so your desired filter would look like this:

df.filter(regex='AMP|amp|date')

answered May 11, 2018 at 7:18

SpghttCd

10.9k2 gold badges23 silver badges28 bronze badges

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

1 Comment

Unknown Over a year ago

Thanks! It worked!

Collectives™ on Stack Overflow

How to apply multiple column filter(String) in python [duplicate]

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related