Data Cleansing and Visualization of Retail Sales Data Using Python
Advances in Engineering Technology Research · 10.03.2026 · 16 (1) · 512
DOI: 10.56028/aetr.16.1.512.2026 ↗Kurz gefasst
Fachartikel in der Zeitschrift Advances in Engineering Technology Research, online erschienen am 10.03.2026. Verfasst von Lin Tan.
Abstract (Originalsprache)
As retail businesses undergo digital transformation, sales data has become central to strategic planning. Data collected from multiple channels—both offline stores and e-commerce platforms—often contain missing values, outliers, inconsistent formats, and varying spatial and temporal resolutions. These quality issues limit the accuracy and reliability of retail analytics. This study examines theoretical developments and practical techniques in retail data cleaning and visualization, building a data quality management framework centered on Python tools. Evidence shows that pandas, scikit-learn modules, and the missingno package excel at data cleaning tasks, while matplotlib and plotly offer distinct advantages for visualization. The research systematizes cleaning methods for typical problems in retail data and explores how visualization reveals temporal and spatial sales patterns. The findings provide both theoretical foundations and practical guidance for enhancing data quality and informed decision-making in retail enterprises. The unique value of this review lies in systematically synthesizing the application literature on Python tools in retail data cleaning and visualization since 2015 and constructing a comparative framework for method selection, thereby filling the gap in existing literature that lacks a systematic evaluation of tool effectiveness for retail scenarios.
Zitieren
APA
Tan, L. (2026). Data Cleansing and Visualization of Retail Sales Data Using Python. Advances in Engineering Technology Research, 16(1), 512. https://doi.org/10.56028/aetr.16.1.512.2026
Vancouver
Tan L. Data Cleansing and Visualization of Retail Sales Data Using Python. Advances in Engineering Technology Research. 2026;16(1):512. doi:10.56028/aetr.16.1.512.2026
BibTeX
@article{Tan2026,
author = {Tan, Lin},
title = {Data Cleansing and Visualization of Retail Sales Data Using Python},
journal = {Advances in Engineering Technology Research},
year = {2026},
volume = {16},
number = {1},
pages = {512},
doi = {10.56028/aetr.16.1.512.2026}
}
EUVIMED