Pandas Multi Index on columns: how to select all columns by part of string on column name

Question

Here is my Pandas DataFrame, I heavily use Multi Index on columns.

How to select, display and iterate over all columns that contain string “escala de 0-10” on level field_title?

This question might be useful for you to read up on: https://stackoverflow.com/questions/53927460/select-rows-in-pandas-multiindex-dataframe — cs95, Jun 19 '20 at 22:03

score 3 · Accepted Answer · answered Jun 19 '20 at 22:07

3

You can build a boolean indexing mask using Index.get_level_values and str.contains:

lvl = 'field_name'
s = "escala de 0-10"

df.loc[:, df.columns.get_level_values(lvl).str.contains(s)]

answered Jun 19 '20 at 22:07

cs95

1 Answers1