Creating Unique ID number for repeated individuals in a dataset (i.e. Panel data id)

Question

EM 2017-7-23

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/349937-creating-unique-id-number-for-repeated-individuals-in-a-dataset-i-e-panel-data-id

回答： Walter Roberson 2017-7-23

Hi,

I'm trying to create an id number which is unique to the names of individuals. Some individuals appear two, three or four times in the sample if there is an observation for that individual in multiple years. i.e. this is panel data that does not yet have an identifier for each panel observation.

So I have N individuals with T time periods. The number of T time periods for each individual ranges from 1 to 4. I need a unique id number for each individual where the id number would simply repeat itself for each N over the range of T-time periods.

The names are string values. For example...set the attached photo

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Walter Roberson 2017-7-23

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/349937-creating-unique-id-number-for-repeated-individuals-in-a-dataset-i-e-panel-data-id#answer_275254

You can use the three-output version of unique() on the cell array of character vectors containing the names (or on the array of string objects if you happen to have one of those instead.) The third output will be the index number into the first output, and so serves as the corresponding unique ID.

In some cases, someone with a similar need might want to use categorical arrays; with your relatively low repetitions, I think unique() is better suited for your particular purpose.