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 vote148 views2 answers
Python youtube view bot
Python
84 votes346 views2 answers
Python with statement file does not exist exception
Python
-2 votes130 views1 answer
Python multiplayer
Python
0 vote137 views1 answer
Remove multiple strings from list python
Python
0 vote143 views1 answer
Pandas add two string columns
Python
16 votes135 views5 answers
Convert pandas dataframe/ table to python dictionary
Python
2 votes121 views1 answer
What is not equals in python
Python
2 votes97 views1 answer
Sqlalchemy check if db exists
Python
0 vote135 views1 answer
Pprint dic without sorting
Python
5 votes145 views2 answers
Filter dataframe with list
Python