Filter pandas datafram by column, then by value within column

Asked Feb 07 '21 at 01:12

Active Feb 07 '21 at 01:19

Viewed 13 times

I have a pandas dataframe that looks like this:

   COLOR   SHAPE   
0  red     square
1  red     oval
2  blue    circle
3  green   oval
4  red     square
5  purple  circle
6  red     triangle
7  violet  square
8  red     oval
9  yellow  circle

How can I filter a row (red) of a single column (color), so I get a new dataframe that looks like this?

   COLOR   SHAPE   
0  red     square
1  red     oval
4  red     square
6  red     triangle
8  red     oval
``

edited Feb 07 '21 at 01:19

asked Feb 07 '21 at 01:12

itstaylorham

1

`df.loc[df.COLOR.eq('red')]`? Doesn't sound like you want a sort, just a filter. – user3483203 Feb 07 '21 at 01:17
1

That sounds about right. I just changed it. Thanks. – itstaylorham Feb 07 '21 at 01:20
In that case, my comment should do it, there are some more options in the linked duplicate that might be helpful as well. – user3483203 Feb 07 '21 at 01:21

Filter pandas datafram by column, then by value within column

0 Answers0