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

2 votes135 views2 answers
Int' object is not subscriptable in python
Python
4 votes244 views6 answers
Python variables
Python
2 votes352 views1 answer
Django empty queryset
Python Django
0 vote192 views1 answer
Conda install pypy
Python
12 votes167 views3 answers
Delete all files in a directory python
Python
39 votes184 views6 answers
Pandas drop rows with nan in a particular column
Python
0 vote195 views1 answer
Python set timezone windows
Python
0 vote229 views3 answers
How to find a word in list python
Python
0 vote183 views1 answer
Gene wilder pure imagination
Python
0 vote206 views1 answer
Pandas save csv list as columns
Python