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

-1 vote173 views1 answer
How split text in python by space or newline with regex
Python
0 vote161 views1 answer
Python cut string after character
Python
1 vote183 views2 answers
Split dataframe into multiple parts
Python
0 vote171 views1 answer
ValueError: Tried to convert 'shape' to a tensor and failed. Error: None values not supported.
Python
1 vote163 views2 answers
Changing default python version ubuntu
Python
12 votes165 views4 answers
Get index of all element in list python
Python
0 vote155 views1 answer
How to get what type of file a file is in python
Python
8 votes110 views4 answers
Python gui
Python
0 vote189 views1 answer
Pyttsx3 NameError: name 'voices' is not defined
Python
0 vote157 views1 answer
How to open cmd at specific size using python
Python