/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 vote337 views6 answers
Gdal user with anaconda
Python
0 vote370 views1 answer
Date format django template filter
Python Django
0 vote342 views1 answer
A = [ int(i) for i in range(100, 104)] list python
Python
0 vote342 views1 answer
Add many instances to related field manytoamny django]
Python Django
3 votes328 views2 answers
Sort tuple by first element python
Python
-2 votes335 views4 answers
Django datepicker
Python
0 vote314 views1 answer
Two legend left and right x asix matplotlib
Python
2 votes326 views1 answer
Python divide every element in a list by a number
Python
0 vote314 views1 answer
Pandas automatic allignment of columns
Python
0 vote335 views2 answers
Dictionary get both key and value.
Python