need to fetch unique values in a column

[VARMAV2]

Hi All,

I am currently struck at some issue where I need to fetch the unique column and the complete rows in a dataframe. Like for example, in the below table I need to fetch the unqiue from circuitid and fetch complete rows as well.

Ideally there are only 4 different types of circuitid here. Please help.

[jrkrideau]

we really need some sample data and any code you have available.

FAQ: How to do a minimal reproducible example ( reprex ) for beginners

A minimal reproducible example consists of the following items: A minimal dataset, necessary to reproduce the issue The minimal runnable code necessary to reproduce the issue, which can be run on the given dataset, and including the necessary information on the used packages. Let's quickly go over each one of these with examples: Minimal Dataset (Sample Data) You need to provide a data frame that is small enough to be (reasonably) pasted on a post, but big enough to reproduce your issue. Let's say, as an example, that you are working with the iris data frame head(iris) #> Sepal.Length Sepal.Width Petal.Length Petal.Width Species #> 1 5.1 3.5 1.4 0.…

Assuming that table is a data.frame, then off the top of my head you should be able to do

unique(mydata$circuitid) 

where your data.frame is mydata
to get the unique ids and then

dat1   <-  subset(mydata, circuitid ==  "SAB00001680")
```

[VARMAV2]

Thank you Sir. This is really helpful.

I somehow managed to get using subset. But this has resolved part of my query and another struggle is that while I do unique on particular circuitid, I need to pick up the max value in another column (in inboundthroughput) like below... Hope you get this....

I'm trying to obtain using this but its not giving me expected output.

df_INT <- subset(top_INT, circuitid == unique(top_INT$circuitid)) & max(top_INT$inboundthroughput)

Thanks in advance.

[jrkrideau]

I am sorry but without usable sample data and your code, I have no idea what you are doing.

Please read the link I provided above.