Filter DataFrame columns with regex

Question

I count statistics for the dataset, and I want to filter columns that contain specific strings. How I could do it with regex?

Here in volumes_c I filtered some structures, that have Volume in there names

Select_list = ["Amygdala", "Hippocampus", "Lateral-Ventricle", "Pallidum", "Putamen", "Thalamus", "Caudate"]
Side = ["Left", "Right"]
#Selected columns
if(Select_list):
    for s in Side:
        for struct in Select_list:
            volumes_c = group_c.filter(regex="^(?=.*"+s+")(?=.*"+struct+")(?=.*Volume)")

Now i want to filter columns that contain SurfArea in:

duplicate of stackoverflow.com/questions/21285380/…

VnC
– VnC

2019-05-23 12:39:44 +00:00
Commented May 23, 2019 at 12:39 — VnC
– VnC, Commented May 23, 2019 at 12:39

Dmitry Sorokin · Accepted Answer · 2020-09-18 00:54:47Z

1

Suppose DataFrame data is in the variable df, so the filter will be:

 df.filter(like="SurfArea", axis=1)

Actually, 'axis' arg has a default value 1 and you can omit it, but if you want to filter by rows set it up as 0.

edited Sep 18, 2020 at 0:54

Dmitry Sorokin

341 silver badge5 bronze badges

answered May 23, 2019 at 12:37

greg

1,41610 silver badges28 bronze badges

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

Collectives™ on Stack Overflow

Filter DataFrame columns with regex

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related