I'm dealing with a dataset and unfortunately for this issue I can't make a sample dataset to replicate the issue. Basically I'm organizing the data and had to deal with reducing two variable types into one and I did that with
When I tried then grouping it appears it did not group by this new renamed industry. As seen in the screen shot "TECH JOBS" appears twice instead of grouping.
I'm basically trying to determine in the end the percentage of "Tech Jobs" per zip_code given all jobs per zip_code.
Any ideas are welcome.