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 vote189 views1 answer
Pandas dataframe check for values more then a number
Python
4 votes188 views3 answers
Pandas dataframe add two columns int and string
Python
46 votes247 views4 answers
Python rename file
Python
8 votes221 views3 answers
Python append csv to dataframe
Python
0 vote226 views1 answer
Van first name van second name van last name
Python
0 vote190 views1 answer
How to sort the order in multiple index pandas
Python
0 vote230 views1 answer
Nested list flask
Python Flask
-1 vote202 views1 answer
Templates python
Python
0 vote194 views1 answer
Doormat pattern
Python
0 vote181 views1 answer
Load text file line in listbox python tkinter site:stackoverflow.com
Python