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 vote306 views1 answer
Flask Upload file to local s3
Python Flask
0 vote283 views1 answer
<type 'file'> python3
Python
0 vote253 views1 answer
How to check whether a nested hash element exists in python
Python
0 vote265 views1 answer
Converting utc time string to datetime object python
Python
1 vote276 views1 answer
Backup django db from one database to another
Python
1 vote316 views1 answer
Np install python
Python
0 vote272 views1 answer
UTC to ISO 8601:
Python
1 vote299 views2 answers
Perfect number program in python
Python
97 votes261 views6 answers
Download python
Python
0 vote315 views1 answer
R sample() funciton in python
Python