R: select subsets from a dataframe using multiple conditions

Question

I would like to ask a data manipulation question by R.

This is the original data frame:

group<-c(rep("a",3), rep("b",4), rep("c",3))
interval<-c(c("1st", "2nd", "3rd"),c("1st", "2nd", "3rd","4th"),c("1st", "2nd", "3rd"))
age<-c(c(10, 20, 23),c(12, 22, 24,30),c(17, 24, 25))

data1<-data.frame(group, interval, age)

I would like to set a R code to get the subsets of matrix: first subset, if the age is less than 15 and another subset, if age is more than 20. later on, I have to apply some functions on each subset (my original matrix is long and many conditions have to apply).

So how can I get the subsets of a matrix using different conditions for each subset using loop:

[![enter image description here][2]][2]

I want to use subset() function in loop:

Can anyone help me out?

Thank you!

I appreciate any replies!

HubertL · Accepted Answer · 2017-07-12 21:02:08Z

2

Without using subset, you can do:

data1[ group %in% data1[data1$interval=="1st" & data1$age<15, "group"] & 
       data1$interval=="2nd",]

answered Jul 12, 2017 at 21:02

HubertL

19.6k3 gold badges38 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Joanna Over a year ago

Wow! This is exactly what I want. Thank you so much! I appreciate your answer! Awesome!

Collectives™ on Stack Overflow

R: select subsets from a dataframe using multiple conditions

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related