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

1 vote196 views2 answers
Access element of dataframe python
Python
0 vote223 views1 answer
Pandas rename columns whitespace with underscore
Python
2 votes146 views1 answer
Python string in set
Python
2 votes200 views1 answer
How to make an empty variable in python
Python
1 vote205 views3 answers
Combination generator python
Python
31 votes285 views6 answers
Django admin create superuser
Python
0 vote216 views2 answers
Generate-thumbnails-in-django-with-pil
Python
102 votes195 views6 answers
Python contains
Python
0 vote192 views1 answer
Dictionary example of using zip()
Python
0 vote210 views1 answer
Pygame tick time
Python