/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

-1 vote139 views1 answer
How to access dictionary inside an array python
Python
16 votes146 views1 answer
Python reload function from file
Python
15 votes155 views6 answers
How to append list in python
Python
0 vote155 views1 answer
Python monitor directory for files count
Python
0 vote167 views1 answer
Random pick between given things python
Python
0 vote168 views1 answer
Tkinter get child in frame
Python
3 votes136 views1 answer
Iteration
Python
0 vote136 views1 answer
Bebražole
Python
-1 vote175 views2 answers
Python increment
Python
0 vote135 views1 answer
Python namedtuple typename
Python