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

58 votes134 views6 answers
Sum of list in python
Python
0 vote127 views1 answer
Merge two list of dictionaries python with string
Python
0 vote126 views1 answer
What does -> none do in python
Python
0 vote136 views1 answer
Split a string into N equal parts.
Python
88 votes121 views6 answers
Save dataframe to csv
Python
0 vote207 views2 answers
Initialize empty dictionary python
Python
3 votes120 views1 answer
Flask give port number
Python
2 votes134 views2 answers
Dice rolling app in python
Python
8 votes122 views2 answers
Python count files directory
Python
11 votes125 views3 answers
How to convert small letters to capital letters in python
Python