Filter Pandas dataframe by column name on regex patterns using str.contains

PHOTO EMBED

Mon Oct 24 2022 00:41:15 GMT+0000 (Coordinated Universal Time)

Saved by @thiago3442 #python #pandas

df[df.columns[df.columns.str.contains(pat = 'WORDABC9')]]
   WORDABC9N123  WORDABC99N123
0            13             16
1            14             17
2            15             18

df[df.columns[df.columns.str.contains(pat = 'WORDABC9\\b')]]
Empty DataFrame
Columns: []
Index: [0, 1, 2]
content_copyCOPY

https://stackoverflow.com/questions/68868162/filter-pandas-dataframe-by-column-name-on-regex-patterns-using-str-contains