Filter rows by conditions on one particular column

Asked Nov 04 '21 at 18:24

Active Nov 04 '21 at 18:32

Viewed 21 times

How could I subset rows by any condition I want based on a single column?

Original data:

Subset all rows where num > 0

  name num
1    A   1
3    C   5
5    E   1

Subset all rows where num < 0

  name num
2    B  -1

Subset all rows where num < & = 0

  name num
2    B  -1
4    D   0

edited Nov 04 '21 at 18:32

user438383

asked Nov 04 '21 at 18:24

Nate

1

Use `subset` i.e. `subset(df1, num < 0)` and similarly create the other conditions and the last would be `num<= 0` – akrun Nov 04 '21 at 18:25
Not working at the moment. Can "num" be an integer? – Nate Nov 04 '21 at 18:28
I assumed the class as numeric/integer. Check the `str(df1)` – akrun Nov 04 '21 at 18:28
Right, ok, so that's not the problem. My new df: x<- subset(dat, num < 0) is all the variables of my original df, but no data. – Nate Nov 04 '21 at 18:31
Looks good for cols with character strings, how does it work for numbers? – Nate Nov 04 '21 at 18:33
1

Wait, got it. df[df$num >0, ]. Thanks for the quick response! – Nate Nov 04 '21 at 18:37
1

@akrun's first comment should have worked. Once again, check `str(df1)`. – Rui Barradas Nov 04 '21 at 18:42

0 Answers0