Skip to main navigation Skip to search Skip to main content

ZeroED: Hybrid Zero-Shot Error Detection with Large Language Model Reasoning

  • Wei Ni
  • , Kaihang Zhang
  • , Xiaoye Miao*
  • , Xiangyu Zhao*
  • , Yangyang Wu
  • , Yaoshu Wang
  • , Jianwei Yin
  • *Corresponding author for this work

Research output: Chapters, Conference Papers, Creative and Literary WorksRGC 32 - Refereed conference paper (with host publication)peer-review

Abstract

Error detection (ED) in tabular data is crucial yet challenging due to diverse error types and the need for contextual understanding. Traditional ED methods often rely heavily on manual criteria and labels, making them labor-intensive. Large language models (LLM) can minimize human effort but struggle with errors requiring a comprehensive understanding of data context. In this paper, we propose ZeroED, a novel hybrid error detection framework, which combines LLM reasoning ability with the machine learning pipeline via zero-shot prompting. ZeroED operates in four steps, i.e., feature representation, error labeling, training data construction, and detector training. Initially, to enhance error distinction, ZeroED generates rich data representations using LLM-driven error reason-aware binary features, pre-trained embeddings, and statistical features. Then, ZeroED employs LLM to holistically label errors through in-context learning, guided by a two-step LLM reasoning process for detailed ED guidelines. To reduce token costs, LLMs are applied only to representative data selected via clustering-based sampling. High-quality training data is constructed through in-cluster label propagation and LLM augmentation with verification. Finally, a classifier is trained to detect all errors. Extensive experiments on seven datasets demonstrate that, ZeroED outperforms state-of-the-art methods by a maximum 30% improvement in F1 score and up to 90% token cost reduction. © 2025 IEEE.
Original languageEnglish
Title of host publicationProceedings - 2025 IEEE 41st International Conference on Data Engineering (ICDE 2025)
EditorsLisa O’Conner
Place of PublicationLos Alamitos, Calif.
PublisherIEEE Computer Society
Pages3126-3139
ISBN (Electronic)979-8-3315-3603-9
ISBN (Print)979-8-3315-3604-6
DOIs
Publication statusPublished - 2025
Event41st IEEE International Conference on Data Engineering (ICDE 2025) - Hong Kong SAR, China
Duration: 19 May 202523 May 2025
https://ieee-icde.org/2025
https://ieeexplore.ieee.org/xpl/conhome/11112833/proceeding

Publication series

NameData engineering
ISSN (Print)1063-6382
ISSN (Electronic)2375-026X

Conference

Conference41st IEEE International Conference on Data Engineering (ICDE 2025)
PlaceChina
CityHong Kong SAR
Period19/05/2523/05/25
Internet address

Funding

This work is partly supported by the National Key R&D Program (No. 2024YFB3908401), the National NSFC (No. 62372404), the Fundamental Research Funds for the Central Universities (No. 226-2024-00030), the Leading Goose R&D Program of Zhejiang (No. 2024C01109), Research Impact Fund (No.R1015-23), Collaborative Research Fund (No.C1043-24GF), Hong Kong ITC Innovation and Technology Fund Midstream Research Programme for Universities Project (No.ITS/034/22MS), Huawei (Huawei Innovation Research Program, Huawei Fellowship), Tencent (CCFTencent Open Fund, Tencent Rhino-Bird Focused Research Program), Ant Group (CCF-Ant Research Fund), Alibaba (CCF-Alimama Tech Kangaroo Fund No. 2024002), and Kuaishou. Xiaoye Miao and Xiangyu Zhao are the corresponding authors of the work.

Research Keywords

  • Data cleaning
  • error detection
  • large language model

RGC Funding Information

  • RGC-funded

Fingerprint

Dive into the research topics of 'ZeroED: Hybrid Zero-Shot Error Detection with Large Language Model Reasoning'. Together they form a unique fingerprint.

Cite this