The K Nearest Neighbor Algorithm for Imputation of Missing Longitudinal Prenatal Alcohol Data

29 Pages Posted: 24 Mar 2022

See all articles by Ayesha Sania

Ayesha Sania

Columbia University - Department of Psychiatry

Nicolo Pini

Columbia University

Morgan Nelson

affiliation not provided to SSRN

Michael M. Myers

Columbia University - Irving Medical Center

Lauren C. Shuffrey

Columbia University - Department of Psychiatry

Maristella Lucchini

Columbia University - Department of Psychiatry

Amy J. Elliott

University of South Dakota - Department of Pediatrics

Hein J. Odendaal

Stellenbosch University

William Fifer

Columbia University - Department of Psychiatry

Abstract

Background: Missing data are a source of bias in many epidemiologic studies. This is problematic in alcohol research where data missingness is linked to patterns of drinking behavior.

Methods: The Safe Passage Study was a prospective investigation of prenatal alcohol consumption and fetal/infant outcomes (n=11,083). Daily alcohol consumption for the last reported drinking day and 30 days prior was recorded using the Timeline Follow back method. Of the 3.2 million person-days of observation, data were missing for 0.36 million (11.4%). We imputed missing exposure data using a machine learning algorithm; 'K Nearest Neighbor' (k-NN). k-NN imputes missing values for a participant using data of other participants closest to it. Imputed values were weighted for the distances from nearest neighbors and matched for the day of the week. Validation was done on 500 iterations after randomly deleting data for 5-15 consecutive days from first trimester.

Results: We found that data from 5 nearest neighbors (i.e., K=5) and segments of 55 days provided imputed values with least imputation error. After deleting data segments from a first trimester data set with no missing days, there was no difference between actual and predicted values for 64% of deleted segments. For 31% of the segments, imputed data were within +/-1 drink/day of the actual.

Conclusions: k-NN can be used to impute missing data from longitudinal studies of alcohol during pregnancy with high accuracy.

Note:
Funding Information: This research was supported by grants UH3OD023279, U01HD055154, U01HD045935, U01HD055155, and U01AA016501, issued by the Office of the Director, National Institutes of Health of the National Institutes of Health, National Institute on Alcohol Abuse and Alcoholism, Eunice Kennedy Shriver National Institute of Child Health and Human Development, and the National Institute on Deafness and Other Communication Disorders. Ayesha Sania is supported by UH3OD023279-05S1, re-entry supplement from Office of the Director, NIH, and Office of Research on Women Health (ORWH).

Declaration of Interests: The authors declare that they have no competing interests.

Ethics Approval Statement: Ethical approval was obtained for each participating PASS network site from their institutional review boards including Stellenbosch University, Sanford Health, the Indian Health Service and from participating Tribal Nations. Written informed consent was obtained from all participants.

Keywords: k Nearest Neighbor, k-NN, Machine Learning, Data Missingness, Data Imputation, Prenatal Alcohol Consumption, Longitudinal Alcohol Consumption

Suggested Citation

Sania, Ayesha and Pini, Nicolo and Nelson, Morgan and Myers, Michael M. and Shuffrey, Lauren C. and Lucchini, Maristella and Elliott, Amy J. and Odendaal, Hein J. and Fifer, William, The K Nearest Neighbor Algorithm for Imputation of Missing Longitudinal Prenatal Alcohol Data. Available at SSRN: https://ssrn.com/abstract=4065215 or http://dx.doi.org/10.2139/ssrn.4065215

Ayesha Sania (Contact Author)

Columbia University - Department of Psychiatry ( email )

United States

Nicolo Pini

Columbia University ( email )

3022 Broadway
New York, NY 10027
United States

Morgan Nelson

affiliation not provided to SSRN

Michael M. Myers

Columbia University - Irving Medical Center ( email )

Department of Medicine
William Black Building, 8th Floor BB8-801C
New York, NY NY 10032
United States

Lauren C. Shuffrey

Columbia University - Department of Psychiatry ( email )

United States

Maristella Lucchini

Columbia University - Department of Psychiatry ( email )

United States

Amy J. Elliott

University of South Dakota - Department of Pediatrics ( email )

414 East Clark Street
Vermillion, SD 57069
United States

Hein J. Odendaal

Stellenbosch University ( email )

Private Bag X1
Stellenbosch, 7602
South Africa

William Fifer

Columbia University - Department of Psychiatry ( email )

United States

Do you have a job opening that you would like to promote on SSRN?

Paper statistics

Downloads
155
Abstract Views
1,182
Rank
485,678
PlumX Metrics