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

79 votes199 views6 answers
Get current directory python
Python
10 votes191 views3 answers
Enter selenium in python
Python
0 vote188 views1 answer
How to make a new column with explode pyspark
Python
0 vote208 views1 answer
Affinity propagation python
Python
1 vote200 views2 answers
Python tkinter button click show label event
Python
0 vote199 views1 answer
Import stock data from yahoo finance
Python
1 vote199 views2 answers
Python dataframe remove header
Python
0 vote200 views1 answer
Get every second elemnt of array matlab
Python
1 vote205 views1 answer
Print(int())
Python
0 vote227 views1 answer
Mypy clear cache
Python