Hey,

I have a dataset and I want to identify the records by groups for further
use in ggplot.

Here is a sample data:

ID  Value
AL1  1
AL2  2
CA1  3
CA4  4

I want to identify all the records that in the same state (AL1 AND A2),
group them as "AL", and do the same for CA1 and CA4. How can I have an
output like:

ID  Value State
AL1  1       AL
AL2  2      AL
CA1  3      CA
CA4  4     CA

Thanks for your help!

	[[alternative HTML version deleted]]

