Study finds Jupyter, Excel, ChatGPT, OpenRefine shape data wrangling differently
40 participants tested across 4 tools — no single winner, but key trade-offs emerged.
Deep Dive
A 40-person observational study compared data cleaning in Jupyter, Excel, ChatGPT, and OpenRefine using the Technical Dimensions of Programming Systems framework. Results show tool affordances steer user strategies but don't determine outcomes, with no consistent advantage for any tool. Key tension: data-centered interfaces encourage opportunistic cleaning rather than systematic transformations found in abstraction-focused tools, but come with a cognitive burden.
Key Points
- 40 participants wrangled data across Jupyter, Excel, ChatGPT, and OpenRefine in a controlled study.
- Data-centered interfaces (Excel, ChatGPT) promoted opportunistic cleaning; abstraction-focused tools (Jupyter, OpenRefine) enabled systematic transforms.
- No single tool showed consistent performance advantage; outcomes depended on user strategy and task demands.
Why It Matters
This study helps data professionals choose wrangling tools based on task type, not just popularity.