Get columns containing string

df2 = df.filter(regex='spike')
print(df2)

Get certain columns pandas with string

import pandas as pd

data = {'spike-2': [1,2,3], 'hey spke': [4,5,6], 'spiked-in': [7,8,9], 'no': [10,11,12]}
df = pd.DataFrame(data)

spike_cols = [col for col in df.columns if 'spike' in col]
print(list(df.columns))
print(spike_cols)

Similar codes

0 vote141 views1 answer
Python max function with lambda
Python
0 vote143 views1 answer
Python valueerror "invalid syntax for number"
Python
0 vote158 views1 answer
Python interseciton of 2 sets
Python
2 votes161 views1 answer
All alphanumeric characters for python python
Python
0 vote172 views1 answer
ParserWarning: Falling back to the 'python' engine because the 'c' engine does not support regex separators (separators > 1 char and different from '\s+' are interpreted as regex); you can avoid this warning by specifying engine='python'.
Python
1 vote174 views1 answer
How to scroll by in selenium python
Python
-2 votes157 views1 answer
Ipython install
Python
32 votes162 views4 answers
Python check if list contains value
Python
3 votes149 views5 answers
Nltk python
Python
0 vote162 views1 answer
RemoveStopWords
Python