/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 vote243 views1 answer
How to change a kivy button text in kivy lang from python file
Python
0 vote232 views1 answer
Python is instance numpy arrya
Python
0 vote237 views1 answer
Numpy diff
Python
1 vote240 views1 answer
Generate valid sudoku board python
Python
23 votes234 views6 answers
Pygame setup
Python
11 votes247 views1 answer
How to upgrade 3.6 to 3.7 on linux
Python
0 vote256 views1 answer
Randian angle to degrees using numpy
Python
0 vote235 views1 answer
Ssl server python
Python
0 vote248 views1 answer
Change form type flask from text to selection flask admin
Python
21 votes241 views6 answers
Remove columns from dataframe
Python