/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 vote304 views1 answer
Get end of string python
Python
1 vote312 views1 answer
Get number of key in dictionary python
Python
3 votes362 views3 answers
AttributeError: 'Timedelta' object has no attribute 'minutes'
Python
1 vote312 views1 answer
How to download excel file from s3 using python
Python
14 votes327 views2 answers
Two groupby pandas
Python
38 votes335 views2 answers
Pickle.load python
Python
0 vote309 views1 answer
Add favicon in django admin
Python
0 vote377 views2 answers
Types of methods in oop python
Python
0 vote294 views1 answer
Python .exe long start
Python
0 vote321 views1 answer
Python why call super(class).__init__()
Python