Title |
Harmonisation of variables names prior to conducting statistical analyses with multiple datasets: an automated approach
|
---|---|
Published in |
BMC Medical Informatics and Decision Making, May 2011
|
DOI | 10.1186/1472-6947-11-33 |
Pubmed ID | |
Authors |
Xavier Bosch-Capblanch |
Abstract |
Data requirements by governments, donors and the international community to measure health and development achievements have increased in the last decade. Datasets produced in surveys conducted in several countries and years are often combined to analyse time trends and geographical patterns of demographic and health related indicators. However, since not all datasets have the same structure, variables definitions and codes, they have to be harmonised prior to submitting them to the statistical analyses. Manually searching, renaming and recoding variables are extremely tedious and prone to errors tasks, overall when the number of datasets and variables are large. This article presents an automated approach to harmonise variables names across several datasets, which optimises the search of variables, minimises manual inputs and reduces the risk of error. |
X Demographics
Geographical breakdown
Country | Count | As % |
---|---|---|
India | 2 | 67% |
Spain | 1 | 33% |
Demographic breakdown
Type | Count | As % |
---|---|---|
Practitioners (doctors, other healthcare professionals) | 2 | 67% |
Members of the public | 1 | 33% |
Mendeley readers
Geographical breakdown
Country | Count | As % |
---|---|---|
Unknown | 14 | 100% |
Demographic breakdown
Readers by professional status | Count | As % |
---|---|---|
Student > Ph. D. Student | 4 | 29% |
Lecturer > Senior Lecturer | 2 | 14% |
Student > Doctoral Student | 2 | 14% |
Lecturer | 1 | 7% |
Other | 1 | 7% |
Other | 1 | 7% |
Unknown | 3 | 21% |
Readers by discipline | Count | As % |
---|---|---|
Medicine and Dentistry | 5 | 36% |
Social Sciences | 4 | 29% |
Nursing and Health Professions | 1 | 7% |
Agricultural and Biological Sciences | 1 | 7% |
Unknown | 3 | 21% |