/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

2 votes157 views1 answer
Python install gimp
Python
0 vote161 views1 answer
RuntimeError: cuda runtime error (711) : peer mapping resources exhausted at /pytorch/aten/src/THC/THCGeneral.cpp:139
Python
0 vote140 views1 answer
Pydrive set parents
Python
0 vote181 views1 answer
App = Flask(_name_) NameError: name '_name_' is not defined
Python Flask
0 vote171 views1 answer
Boston data set to pandas df
Python
9 votes172 views1 answer
How to read csv from local files
Python
0 vote154 views1 answer
What are data types in python
Python
0 vote169 views2 answers
PHP echo multiple lines example
Python
4 votes149 views1 answer
Np.random.float
Python
0 vote159 views2 answers
Python convert string to list of dictionaries
Python