Dango : A Mixed-Initiative Data Wrangling System using Large Language Model Conference: CHI Conference on Human Factors in Computing Systems; April 26-May 1, 2025; Yokohama, Japan CHI Conference on Human Factors in Computing Systems (CHI ’25), April 26-May 1, 2025, Yokohama, Japan DOI: 10.1145/37065
Wei-Hao Chen, Weixi Tong, Amanda Case, Tianyi Zhang · 2025
Read Dango : A Mixed-Initiative Data Wrangling System using Large Language Model Conference: CHI Conference on Human Factors in Computing Systems; April 26-May 1, 2025; Yokohama, Japan CHI Conference on Human Factors in Computing Systems (CHI ’25), April 26-May 1, 2025, Yokohama, Japan DOI: 10.1145/37065 by Wei-Hao Chen, Weixi Tong, Amanda Case, Tianyi Zhang (2025) in the Tower of Babel, a free online library of public-domain works preserved in clean, searchable text. No sign-up. The full text is served as a plain-text file at a predictable URL, where text is present: https://antarctic-labs.com/tower-of-babel/arxiv-2503-03154.txt.
Introduction
Cleaning and reshaping raw data tables takes much of a data worker's time, and tools that guess at the task often guess wrong. Wei-Hao Chen, Weixi Tong, Amanda Case, and Tianyi Zhang present Dango in this 2025 paper, a system that mixes machine help with user guidance. It is built on large language models and several cooperating agents.
Users show what they want on sample tables, type prompts in a chat view, and answer multiple-choice questions the system poses to clear up doubt. Dango explains each step in plain words and shows where each value came from. In a study with 38 users, these features raised accuracy and speed, and tests on more tasks showed the system could stretch to new kinds of work.
Catalog record
| CREATOR | Wei-Hao Chen, Weixi Tong, Amanda Case, Tianyi Zhang |
|---|---|
| YEAR | 2025 |
| COLLECTION | PAPERS |
| FORMAT | TXT |
| FILE SIZE | 100 KB |
| VERSION | 1.0 |
| LICENSE | http://creativecommons.org/licenses/by/4.0/ |
| RIGHTS | CC BY |
| SOURCE | arXiv |
Source: https://arxiv.org/abs/2503-03154
Browse the full library · About the Tower of Babel
Full text
The opening of the work, from the library's hosted text:
Dango : A Mixed-Initiative Data Wrangling System using Large Language Model Conference: CHI Conference on Human Factors in Computing Systems; April 26-May 1, 2025; Yokohama, Japan CHI Conference on Human Factors in Computing Systems (CHI ’25), April 26-May 1, 2025, Yokohama, Japan DOI: 10.1145/3706598.3714135 ISBN: 979-8-4007-1394-1/25/04 CCS: Human-centered computing Interactive systems and tools Wei-Hao Chen, Weixi Tong, Amanda Case, Tianyi Zhang Abstract . Data wrangling is a time-consuming and challenging task in a data science pipeline. While many tools have been proposed to automate or facilitate data wrangling, they often misinterpret user intent, especially in complex tasks. We propose Dango , a mixed-initiative multi-agent system for data wrangling. Compared to existing tools, Dango enhances user communication of intent by: (1) allowing users to demonstrate on multiple tables and use natural language prompts in a conversation interface, (2) enabling users to clarify their intent by answering LLM-posed multiple-choice clarification questions, and (3) providing multiple forms of feedback such as step-by-step NL explanations and data provenance to help users evaluate the data wrangling scripts. We conducted a within-subjects user study (n=38) and demonstrated that Dango ’s features can significantly improve intent clarification, accuracy, and efficiency in data wrangling. Furthermore, we demonstrated the generalizability of Dango by applying it to a broader set of data wrangling tasks. Figure 1 . To create a data wrangling script, users can first demonstrate their desired actions on the tables in Dango ( Step1 ). They can edit table cells, add/delete/move columns and rows, and copy/cut content across multiple tables. For complex demonstrations, users can also describe their intent in natural language in a chatroom. When ambiguity is detected in a demonstration or a NL description, Dango will generate a multiple-choice question about each unclear part and prompt users for clarification ( Step2 ). Once the ambiguity is resolved, Dango synthesizes a data wrangling script to automate the desired actions. To make it easier for users to understand and validate the synthesized script, Dango explains the script in natural language step by step ( Step3 ). When users notice a wrong step in the script, they can easily fix it by directly editing the NL explanation of that step. They can also add missing steps or delete redundant steps. Dango will update the script based on user edits. † † cc-license: by 1. INTRODUCTION Data wrangling is a time-consuming and challenging task in the early stages of a data science pipeline ( Biswas et al. 2022 ; Press 2016 ) . It is reported that data scientists spend up to 80% of their time changing table layouts, transforming data formats, and filling in missing or incorrect values ( Muller et al. 2019 ) . To address this challenge, many interactive systems have been developed to help users clean data ( Kandel et al. 2011 ; Jin et al. 2017 ; Gulwani et al. 2012 ; Gulwani et al. 2011 ) . However, they have two major limitations. First, they are limited to single-table tasks, while a recent study by Kasica et al. ( Kasica et al. 2020 ) has shown that many data wrangling tasks involve multiple tables. Second, existing systems primarily rely on user demonstration to interpret user intent, in which the user demonstrates desired data transformations on a few data points and the system generates a generalizable script for automation. However, demonstration is not convenient to specify certain transformations, such as deleting a row only if more than a quarter of the values are missing. It is difficult to precisely communicate the criterion “more than a quarter of the values are missing” via demonstration alone. The rise of Large Language Models (LLMs) provides new opportunities for augmenting or re-designing data wrangling tools. LLM systems have shown their ability to engage in natural language (NL) conversation with humans ( Achiam et al. 2023 ; Floridi and Chiriatti 2020 ) , lowering the entry points for novice users to interact with more complex systems. More recently, several systems have been proposed to leverage LLMs for data wrangling ( Li et al. 2024a ; Srinivasa Ragavan et al. 2022 ; Chen et al. 2024 ) . Despite their potential, these systems have several usability issues. First, they only allow NL interaction. While convenient, NL is inherently ambiguous and can be cumbersome when specifying certain operations compared with demonstrations, such as moving a specific row from one table to a target position in another table. Second, these systems do not handle the hallucination problem ( Ji et al. 2023 ) and provide little support for users, especially end-users, in identifying and rectifying the errors in LLM-generated data transformations. Moreover, though LLMs are likely to misinterpret user intent, these systems do not provide effective ways for users to clarify their intent or provide feedback. To address these issues, we propose Dango , a mixed-initiative system that enhances the communication between LLM agents and users for data wrangling. Dango supports both direct demonstration and NL interaction to enable rich intent expression. When user intent is ambiguous, Dango generates clarification questions (CQs). Users can refine their intent by answering these CQs. The Q&A history is then incorporated into a feedback loop to continuously improve the results. To help users understand the script’s behavior, Dango renders the synthesized scripts as step-by-step explanations in NL. Users can read these NL explanations easily and make direct edits to them. Given the complexity of multi-table tasks, Dango automatically visualizes data provenance, helping users understand the interrelationships between tables. We conducted a within-subjects user study with 38 participants to evaluate the usability and efficiency of Dango . Participants using Dango finished the assigned tasks in 3 min and 30 sec on average, reducing the task completion time by 32% and 45% compared with using the other two conditions. In the post-task survey, participants felt more confident about the generated scripts when using Dango . To understand the generalizability of Dango , we conducted a quantitative experiment on 24 additional data wrangling tasks. The result shows Dango can solve all of the tasks with an average task completion time of 62.67 and 75.90 seconds by the first two authors, respectively. This provides quantitative evidence about Dango ’s effectiveness on a variety of data wrangling tasks. 2. RELATED WORK 2.1. Data Wrangling Data wrangling is a critical but time-consuming process in data science. A recent study by Muller et al. ( Muller et al. 2019 ) points out that even professional data scientists may take weeks, if not months, to wrangle data to achieve high data quality. This process has been reported to be one of the most time-consuming and laborious stages in a data science pipeline ( Dasu and Johnson 2003 ; Kandel et al. 2011 ; Press 2016 ; Muller et al. 2019 ) . To help end-users wrangle data, researchers have developed a variety of interactive data wrangling systems to reduce manual efforts. One of the earliest systems is Nix’s Editing by Example system ( Nix 1985 ) , which can automatically generate a replayable editing program by inferring users’ input/output example text. Later, Witten and Mo ( Mo and Witten 1992 ; Witten and Mo 1993 ) introduced the TELS system, which allows users to