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 vote187 views3 answers
How to sort values in python
Python
3 votes199 views2 answers
Find frequency of numbers in list python
Python
4 votes206 views4 answers
Count unique elements in list python
Python
0 vote188 views1 answer
Python create pairs from list
Python
0 vote171 views1 answer
Django template date format yyyy-mm-dd
Python Django
9 votes186 views4 answers
Change column order pandas
Python
1 vote171 views2 answers
Clear anaconda cache
Python
46 votes195 views4 answers
How to get the type of a variable in python
Python
6 votes191 views3 answers
Pandas create dataframe from multiple dictionaries
Python
1 vote171 views1 answer
Run a loop in tkinter
Python