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 vote377 views1 answer
Django fixtures. To dump data
Python Django
0 vote304 views1 answer
Python to postgresql
Python
0 vote308 views1 answer
Lowering the time.countdown python
Python
1 vote338 views2 answers
How to append to an empty dataframe pandas
Python
0 vote294 views1 answer
Python on_mouse_down/collidepoint
Python
0 vote300 views1 answer
Python not equal to symbol
Python
-1 vote309 views2 answers
Dd-mm-yy to yyyy-mm-dd in python
Python
5 votes310 views3 answers
Series change index pandas
Python
3 votes276 views2 answers
Elon musk wikipedia
Python
0 vote315 views2 answers
Turn list to string with commas python
Python