/Python/Dataframe how to find columns that start with prefix

Dataframe how to find columns that start with prefix

In [28]:

filter_col = [col for col in df if col.startswith('foo')]
filter_col
Out[28]:
['foo.aa', 'foo.bars', 'foo.fighters', 'foo.fox', 'foo.manchu']
In [29]:

df[filter_col]
Out[29]:
   foo.aa  foo.bars  foo.fighters  foo.fox foo.manchu
0     1.0         0             0        2         NA
1     2.1         0             1        4          0
2     NaN         0           NaN        1          0
3     4.7         0             0        0          0
4     5.6         0             0        0          0
5     6.8         1             0        5          0

Source: stackoverflow.com

Similar codes

0 vote190 views1 answer
Change one value based on another value in pandas
Python
0 vote156 views1 answer
Python split space or tab
Python
0 vote182 views1 answer
Cite pandas python
Python
0 vote162 views1 answer
K and M to int in pandas
Python
0 vote152 views1 answer
Drf serializer general validate method
Python
1 vote152 views1 answer
Program to tell if a number is a perfect square
Python
1 vote181 views1 answer
Barplot syntax in python
Python
45 votes176 views6 answers
Replace in python
Python
34 votes173 views3 answers
How to install pyaudio in python
Python
61 votes163 views6 answers
Python classes
Python