Stanford InfoLab Publication Server

Wrangler: Interactive Visual Specification of Data Transformation Scripts

Kandel, Sean and Paepcke, Andreas and Hellerstein, Joseph and Heer, Jeffrey (2011) Wrangler: Interactive Visual Specification of Data Transformation Scripts. In: CHI Conference on Human Factors in Computing Systems, May 7-12, 2011, Vancouver.


[img]PDF - Published Version

Official URL:


Though data analysis tools continue to improve, analysts still expend an inordinate amount of time and effort manipulating data and assessing data quality issues. Such “data wrangling” regularly involves reformatting data values or layout, correcting erroneous or missing values, and integrating multiple data sources. These transforms are often difficult to specify and difficult to reuse across analysis tasks, teams, and tools. In response, we introduce Wrangler, an interactive system for creating data transformations. Wrangler combines direct manipulation of visualized data with automatic inference of relevant transforms, enabling analysts to iteratively explore the space of applicable operations and preview their effects. Wrangler leverages semantic data types (e.g., geographic locations, dates, classification codes) to aid validation and type conversion. Interactive histories support review, refinement, and annotation of transformation scripts. User study results show that Wrangler significantly reduces specification time and promotes the use of robust, auditable transforms instead of manual editing.

Item Type:Conference or Workshop Item (Paper)
ID Code:1005
Deposited By:Andreas Paepcke
Deposited On:19 Jul 2011 12:04
Last Modified:19 Jul 2011 12:04

Download statistics

Repository Staff Only: item control page