Seeking help for using filter and mutate command to break down a current variable into separate variables

[mishabalyasin]

Hi Allen, I would say that the first step you need to try to do is to put your data into reprex (reproducible example).

FAQ: What's a reproducible example (`reprex`) and how do I create one?

Why reprex? Getting unstuck is hard. Your first step here is usually to create a reprex, or reproducible example. The goal of a reprex is to package your code, and information about your problem so that others can run it and feel your pain. Then, hopefully, folks can more easily provide a solution. What's in a Reproducible Example? Parts of a reproducible example: background information - Describe what you are trying to do. What have you already done? complete set up - include any library() calls and data to reproduce your issue. data for a reprex: Here's a discussion on setting up data for a reprex make it run - include the minimal code required to reproduce your error on the data…

Another thing I would suggest that you shouldn't use group_by before you use mutate to create new columns.

Also, take a look at dplyr::case_when function. It'll probably be easier than what you are doing now with mutate.

Finally, you should try to isolate your error to as small of subset of variables as possible. For example, right now you use select to choose multiple columns and then you use mutate to create a column with multiple states. Will this error appear when you use just, e.g., 2 columns in select and only one state in mutate? If yes, then it'll be easier to troubleshoot what is going wrong.