/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 votes147 views1 answer
Pycharm why won't os work
Python
0 vote124 views1 answer
Np.conjugate
Python
1 vote169 views1 answer
Random oversampling python
Python
18 votes188 views3 answers
Django-admin startproject
Python Django
0 vote125 views1 answer
Django rest framework multiple user registration
Python Django
0 vote144 views2 answers
Dictionary changed size during iteration after pop function
Python
0 vote134 views2 answers
How to add percentage in pie chart in python
Python
1 vote133 views1 answer
Set the root directory when starting jupyter notebooks
Python
26 votes133 views6 answers
Python push to list
Python
1 vote134 views1 answer
How to make pyautogui faster
Python