Hi @ms10 and welcome to the RStudio Community 
Data-related questions and coding questions need not be hypothetical/theoretical in general. In fact, it is better to make them as practical as possible in order for the readers of your questions to have all the tools needed to help you better.
In your case, rather than describe what your dataset looks like, you could fire up excel and create/simulate a small dataset that contains the features of interest (i.e. those described in your question), upload it and share it with a link. Even better, you could use the dput() function, copy and paste your result in order to share your dataset with other users.
Your question seems rather simple. Go ahead and share an example dataset and the community will help you 
. I also strongly encourage you to take a look at this for your future R questions: