Re: [R] How to group by and get distinct rows of of grouped rows based on certain criteria

Thank you Bill and Sarah for your help. I was able to do the same with dplyr with the following code. But I could not post this since at that time my message was not posted yet. >> file1 <- select(file1, ATP.Group,Business.Event,Category) file1_1 <- file1 %>% group_by(ATP.Group,Business.Event) %

Re: [R] How to group by and get distinct rows of of grouped rows based on certain criteria

> txt <- "|ATP Group|Business Event|Category| |02 |A |AC | |02 |A |AD | |02 |A |EQ | |ZM |A |AU | |ZM |A |AV | |ZM |A |AW | |02 |B |AC | |

Re: [R] How to group by and get distinct rows of of grouped rows based on certain criteria

I took a wild guess as to what your data looked like (please use dput() to provide data, and please do not post in HTML), and took your request literally. Here's one way to approach the problem: mydat <- structure(list(ATP.Group = c("02", "02", "02", "ZM", "ZM", "ZM", "02", "02", "02"), Business

[R] How to group by and get distinct rows of of grouped rows based on certain criteria

Hello All: I would like to get your help on the following problem. I have the following data and the first row is the header. Spaces are not important. I want to find out distinct combinations of ATP Group and Business Event (these are the field names that you can see in the data below) that have