/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

8 votes195 views2 answers
Valueerror: invalid literal for int() with base 10: 'id'
Python
3 votes172 views2 answers
Reciprocal python
Python
0 vote205 views1 answer
Dobj in spacy
Python
0 vote170 views1 answer
%d%m%y python
Python
-1 vote164 views1 answer
Python __new__
Python
3 votes181 views2 answers
Python remove all occurrence of an items from list
Python
0 vote167 views1 answer
Neural network hyperparameter tuning
Python
0 vote179 views1 answer
Python format string with list
Python
0 vote161 views1 answer
Master python
Python
7 votes157 views6 answers
Hello world in python
Python