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 votes193 views1 answer
Best python framework
Python
1 vote281 views1 answer
Pyton count number of character in a word
Python
1 vote211 views1 answer
Time date in pandas to csv file
Python
1 vote199 views1 answer
How to hit enter in selenium python
Python
0 vote164 views1 answer
Assigning a value to a character in string or text file in python
Python
2 votes219 views3 answers
Matplotlib show plot
Python
0 vote153 views1 answer
Parallel run of a function with multiple arguments partial
Python
1 vote263 views2 answers
Add element to array list python
Python
2 votes264 views2 answers
Python exception element not found
Python
2 votes229 views2 answers
Pd.dataframe initial columns
Python