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 vote136 views1 answer
Pandas typr of each cell in series
Python
0 vote131 views1 answer
For i in range without i
Python
8 votes138 views1 answer
Python CSV Has No Attribute 'Writer
Python
1 vote134 views2 answers
Np.argsort reverse
Python
-1 vote132 views1 answer
How to make an action repeat in python
Python
25 votes93 views7 answers
Remove space from start and end of string in python
Python
0 vote127 views1 answer
For lopp python
Python
-1 vote141 views2 answers
How to measure how much your of cpu your program is using in python
Python
2 votes141 views2 answers
Python - Count the Number of Keys in a Python Dictionary
Python
2 votes128 views1 answer
Auto datetime in django models
Python