CODEWITHSUNDEEP
pythonpandasdataframe
user13641081
user13641081

Reputation:

dataframe delete row with value of a categorical field above threshold

I have the following dataframe:

   id    speed    mode
0   3    21        car
1   2    17        walk
2   4    34        car
3   5    7         walk
4   3    10        car

How do I delete rows for which the speed of walk mode is above 10?

Upvotes: 0

Views: 69

Answers (1)

jezrael
jezrael

Reputation: 862661

Change thinking - select all rows not walk or less equal like 10 in boolean indexing:

df = df[df['mode'].ne('walk') | df['speed'].le(10)]
print (df)
   id  speed  mode
0   3     21   car
2   4     34   car
3   5      7  walk
4   3     10   car

Upvotes: 2

Related Questions