How to create a new column with numerical number based on the unique grouping of column AI have a table with Column A (char). I want to add a new column in number value which represents the grouping of column A. How to do this automatically? Column A has too many characters for me to manually group them.
| column A | new column |
| kkk | 1 |
| dd | 2 |
| kkk | 1 |
| cc | 3 |
Basic Data Analysis and Modeling
