/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 vote228 views1 answer
Input date args python datetime
Python
0 vote226 views1 answer
Spacy nlp load
Python
0 vote231 views1 answer
Id
Python
14 votes216 views3 answers
Python remove first and last character from string
Python
10 votes223 views2 answers
Python copy dir
Python
80 votes242 views21 answers
Python syntax cheat sheet
Python
0 vote223 views1 answer
Oversampling using smote
Python
0 vote228 views1 answer
Root.iconbitmap
Python
26 votes210 views3 answers
Python string generator
Python
28 votes227 views4 answers
Seaborn figure size
Python