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

2 votes328 views1 answer
Ln in python
Python
4 votes305 views2 answers
Print \\ in python
Python
0 vote299 views1 answer
Simple example of printing a C version of a SymPy expression:
Python
0 vote289 views1 answer
Explode function in python
Python
0 vote323 views1 answer
Python string remove accent
Python
0 vote260 views1 answer
Gurobi get feasible solution when timelimit reached
Python
1 vote268 views1 answer
Python get newest file in directory
Python
0 vote266 views1 answer
Pycaw , Python Audio Control Lib
Python
0 vote312 views1 answer
Django never_cache example
Python
0 vote279 views1 answer
Matplotlib show percentage y axis
Python