Selecting a Maximum from a subset dataset

[laurengamber]

Business.Max.Jobs <- MT_PPP %>% group_by(BusinessName, JobsRetained) %>%  tally(JobsRetained, sort =TRUE) 

This is the code that I have , so far I have it to where it lists the number of jobs retained for every single business name in my dataset. Is there a way to only display the business names that have the maximum number of jobs retained?

[M_AcostaCH]

Hi, remember put a reproducible example of data for all community could help you.

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.…

Other way is copy and paste the result of this:

dput(MT_PPP [ 1:30, ])

[dvetsch75]

Happy to help - can you please post a reproducible example of your dataset? A good option would be posting the output of dput(head(mydata, 100)).