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

57 votes150 views11 answers
Python print color
Python
0 vote177 views1 answer
Restaurant management system in django
Python
0 vote170 views1 answer
Optimize images using pillow
Python
24 votes293 views5 answers
Remove a part of a string python
Python
7 votes171 views4 answers
How to use lambda function in python
Python
0 vote167 views1 answer
Trim string to max length python
Python
0 vote204 views1 answer
FIND MISSING NUMBER IN AN ARRAY IN PYTHON
Python
8 votes190 views1 answer
Python CSV Has No Attribute 'Writer
Python
0 vote182 views2 answers
How to print aligned dictionary python
Python
31 votes129 views1 answer
Sort_values pandas series
Python