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

4 votes340 views2 answers
Get stock data in python
Python
15 votes349 views4 answers
How to install package in python shell
Python
2 votes377 views3 answers
Python split string size
Python
0 vote369 views1 answer
Get os environment python
Python
1 vote315 views1 answer
Convert dictionary keys to int python
Python
3 votes327 views1 answer
PIL image example
Python
2 votes368 views1 answer
Scikit learn decision tree12
Python
0 vote340 views1 answer
Django post request 403 forbidden
Python
0 vote333 views2 answers
Remove nans and infs python
Python
11 votes344 views9 answers
Trump
Python