/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 vote129 views2 answers
Turtle.write("Sun", move=False, align="left", font=("Arial", 8, "normal"))
Python
6 votes124 views10 answers
Array
Python
28 votes118 views3 answers
Seaborn size
Python
5 votes118 views4 answers
Yticks matplotlib
Python
7 votes111 views4 answers
How to use lambda function in python
Python
1 vote107 views1 answer
String to bits python
Python
1 vote109 views1 answer
Make python look good
Python
1 vote104 views1 answer
Color name to hex python
Python
38 votes102 views4 answers
Python color text console
Python
87 votes183 views2 answers
How to write a while statement in python
Python