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

9 votes119 views3 answers
SettingWithCopyWarning: A value is trying to be set on a copy of a slice from a DataFrame. Try using .loc[row_indexer,col_indexer] = value instead
Python
5 votes114 views3 answers
Python sys
Python
5 votes131 views2 answers
Tkfiledialog python 3 example
Python
2 votes117 views1 answer
What does float mean in python
Python
1 vote137 views2 answers
Valeur absolue python
Python
0 vote124 views1 answer
Python read from stdin pipe
Python
29 votes268 views4 answers
Basic flask app python
Python Flask
0 vote125 views1 answer
Finding the rows in a dataframe where column contains any of these values python
Python
2 votes120 views1 answer
Pygityb
Python
1 vote119 views1 answer
Python dictionary dot product
Python