TY - GEN
T1 - A Rule Based Data Cleansing Pipeline for Automated Data Import in the Context of Social Clubs
AU - Pointner, Andreas
AU - Harrer, Martin
N1 - Publisher Copyright:
© 2023 IEEE.
PY - 2023
Y1 - 2023
N2 - Managing the member data of social clubs can be a tedious task. However, there are software solutions available that can help streamline this process. This although means, that existing member data, that is often in the form of text-based data formats like CSV, or semi-structured formats like XML, or Excel needs to be imported in those tools. Unfortunately, the data in these formats may contain errors, inconsistencies, and missing values, which can compromise the usability of this data. In this work, a rule-based data cleansing pipeline designed to clean, enrich, and transform social club member data into a suitable format for import into software solutions is presented. The approach is evaluated on a small data sample and shows promising results for such an application scenario.
AB - Managing the member data of social clubs can be a tedious task. However, there are software solutions available that can help streamline this process. This although means, that existing member data, that is often in the form of text-based data formats like CSV, or semi-structured formats like XML, or Excel needs to be imported in those tools. Unfortunately, the data in these formats may contain errors, inconsistencies, and missing values, which can compromise the usability of this data. In this work, a rule-based data cleansing pipeline designed to clean, enrich, and transform social club member data into a suitable format for import into software solutions is presented. The approach is evaluated on a small data sample and shows promising results for such an application scenario.
KW - Data Cleansing
KW - Data Import
KW - Pipeline
UR - http://www.scopus.com/inward/record.url?scp=85174062414&partnerID=8YFLogxK
U2 - 10.1109/ICECCME57830.2023.10253136
DO - 10.1109/ICECCME57830.2023.10253136
M3 - Conference contribution
AN - SCOPUS:85174062414
T3 - International Conference on Electrical, Computer, Communications and Mechatronics Engineering, ICECCME 2023
BT - International Conference on Electrical, Computer, Communications and Mechatronics Engineering, ICECCME 2023
PB - Institute of Electrical and Electronics Engineers Inc.
T2 - 2023 International Conference on Electrical, Computer, Communications and Mechatronics Engineering, ICECCME 2023
Y2 - 19 July 2023 through 21 July 2023
ER -