2023SoftwareXOpen access

Handling an inconsistently coded categorical variable in a longitudinal dataset with cat2cat

Maciej Nasiński, Krzysztof Gajowniczek

Open full text 1 citations

Abstract

Categorical variable levels change over time with the addition, deletion, or regrouping of categories. This study introduces cat2cat procedure, to handle an inconsistently coded categorical variable in a longitudinal dataset. Such categorical variables often represent classifications, for instance The International Standard Classification of Occupations or the International Classification of Diseases. The cat2cat procedure enables unification of an inconsistently coded categorical variable between two time points in accordance with a mapping table. Categorical variable levels from a specific period are applied to a neighboring period by replicating an observation if it can be assigned to more than one category. Then, frequencies or statistical methods are used to approximate the probabilities of being assigned to each category. The cat2cat procedure extends the scope of the available statistical analyses in a longitudinal dataset with inconsistently coded categorical variables, which are ordinarily removed or force dataset aggregation. The procedure is offered to the scientific community in the cat2cat R and Python packages.

Open-access reader

About this research paper

What this paper is about

Categorical variable levels change over time with the addition, deletion, or regrouping of categories. This study introduces cat2cat procedure, to handle an inconsistently coded categorical variable in a longitudinal dataset. Such categorical variables often represent classifications, for instance The International Standard Classification of Occupations or the International Classification of Diseases. The cat2cat procedure enables unification of an inconsistently coded categorical variable between two time points in accordance with a mapping table. Categorical variable levels from a specific period are applied to a neighboring period by replicating an observation if it can be assigned to more than one category. Then, frequencies or statistical methods are used to approximate the probabilities of being assigned to each category. The cat2cat procedure extends the scope of the available statistical analyses in a longitudinal dataset with inconsistently coded categorical variables, which are ordinarily removed or force dataset aggregation. The procedure is offered to the scientific community in the cat2cat R and Python packages.

Why it matters

OpenAlex reports 1 citations for this work. Citation counts describe recorded attention and do not establish research quality.

Key contribution

A contribution statement is not available in the OpenAlex record.

Method / approach

Method details are not available in the OpenAlex metadata.

Main findings

Findings are not separately available in the OpenAlex metadata.

Limitations

Limitations are not available in the OpenAlex metadata.

Applications

Application details are not available in the OpenAlex metadata.

Available abstract

Categorical variable levels change over time with the addition, deletion, or regrouping of categories. This study introduces cat2cat procedure, to handle an inconsistently coded categorical variable in a longitudinal dataset. Such categorical variables often represent classifications, for instance The International Standard Classification of Occupations or the International Classification of Diseases. The cat2cat procedure enables unification of an inconsistently coded categorical variable between two time points in accordance with a mapping table. Categorical variable levels from a specific period are applied to a neighboring period by replicating an observation if it can be assigned to more than one category. Then, frequencies or statistical methods are used to approximate the probabilities of being assigned to each category. The cat2cat procedure extends the scope of the available statistical analyses in a longitudinal dataset with inconsistently coded categorical variables, which are ordinarily removed or force dataset aggregation. The procedure is offered to the scientific community in the cat2cat R and Python packages.

Key concepts: Categorical variable, Variable (mathematics), Computer science, Python (programming language), Unification, Categorization, Statistics, Mathematics

Related papers

Back to paper searchBrowse research topicsOriginal source
Handling an inconsistently coded categorical variable in a longitudinal dataset with cat2cat — Research Paper | ScholarLens