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 vote244 views2 answers
Np one hot encoding
Python
0 vote218 views1 answer
Str count python
Python
0 vote253 views1 answer
Codeforces 677a solution
Python
0 vote228 views1 answer
Cudf - merge dataframes
Python
9 votes230 views2 answers
Fill missing values in column pandas with mean
Python
17 votes241 views1 answer
Take off character in python string
Python
0 vote245 views1 answer
Random.choices without repetition
Python
-1 vote221 views1 answer
Python graphql client
Python
0 vote283 views1 answer
Multiplication table for number python codewars
Python
39 votes233 views5 answers
How to calculate the sum of a list in python
Python