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 vote165 views2 answers
Sort a list of array python
Python
5 votes161 views1 answer
Python close input timeout
Python
1 vote141 views1 answer
Run code with different verions of python
Python
0 vote239 views1 answer
Response.url SSL warning python
Python
0 vote167 views1 answer
Numpy array divide each row by its sum
Python
0 vote173 views1 answer
Unindent does not match any outer indentation level
Python
9 votes169 views3 answers
Check if tensorflow gpu is installed
Python
3 votes169 views2 answers
Python get line of exception
Python
11 votes169 views1 answer
Python practice problems
Python
0 vote170 views1 answer
Python import stringIO
Python