Xavier: Toward Better Coding Assistance in Authoring Tabular Data Wrangling Scripts

Fuente: arXiv
Enregistré dans:
Détails bibliographiques
Auteurs principaux: Zhou, Yunfan, Cai, Xiwen, Shi, Qiming, Huang, Yanwei, Li, Haotian, Qu, Huamin, Weng, Di, Wu, Yingcai
Format: Preprint
Publié: 2025
Sujets:
Accès en ligne:
Tags: Ajouter un tag
Pas de tags, Soyez le premier à ajouter un tag!
_version_ 1866910858091692032
author Zhou, Yunfan
Cai, Xiwen
Shi, Qiming
Huang, Yanwei
Li, Haotian
Qu, Huamin
Weng, Di
Wu, Yingcai
author_facet Zhou, Yunfan
Cai, Xiwen
Shi, Qiming
Huang, Yanwei
Li, Haotian
Qu, Huamin
Weng, Di
Wu, Yingcai
contents Data analysts frequently employ code completion tools in writing custom scripts to tackle complex tabular data wrangling tasks. However, existing tools do not sufficiently link the data contexts such as schemas and values with the code being edited. This not only leads to poor code suggestions, but also frequent interruptions in coding processes as users need additional code to locate and understand relevant data. We introduce Xavier, a tool designed to enhance data wrangling script authoring in computational notebooks. Xavier maintains users' awareness of data contexts while providing data-aware code suggestions. It automatically highlights the most relevant data based on the user's code, integrates both code and data contexts for more accurate suggestions, and instantly previews data transformation results for easy verification. To evaluate the effectiveness and usability of Xavier, we conducted a user study with 16 data analysts, showing its potential to streamline data wrangling scripts authoring.
format Preprint
id arxiv_https___arxiv_org_abs_2503_02639
institution arXiv
publishDate 2025
record_format arxiv
spellingShingle Xavier: Toward Better Coding Assistance in Authoring Tabular Data Wrangling Scripts
Zhou, Yunfan
Cai, Xiwen
Shi, Qiming
Huang, Yanwei
Li, Haotian
Qu, Huamin
Weng, Di
Wu, Yingcai
Human-Computer Interaction
Data analysts frequently employ code completion tools in writing custom scripts to tackle complex tabular data wrangling tasks. However, existing tools do not sufficiently link the data contexts such as schemas and values with the code being edited. This not only leads to poor code suggestions, but also frequent interruptions in coding processes as users need additional code to locate and understand relevant data. We introduce Xavier, a tool designed to enhance data wrangling script authoring in computational notebooks. Xavier maintains users' awareness of data contexts while providing data-aware code suggestions. It automatically highlights the most relevant data based on the user's code, integrates both code and data contexts for more accurate suggestions, and instantly previews data transformation results for easy verification. To evaluate the effectiveness and usability of Xavier, we conducted a user study with 16 data analysts, showing its potential to streamline data wrangling scripts authoring.
title Xavier: Toward Better Coding Assistance in Authoring Tabular Data Wrangling Scripts
topic Human-Computer Interaction
url https://arxiv.org/abs/2503.02639