Wide, long, or nested data? Reconciling the machine and human viewpoints

Hall, Alan Geoffrey; Wermelinger, Michel; Hirst, Tony and Phithakkitnukoon, Santi (2018). Wide, long, or nested data? Reconciling the machine and human viewpoints. In: Proceedings of the 2018 Conference of the Psychology of Programming Interest Group (PPIG), 5-7 Sep 2018, London.

Full text available as:

Preview

PDF - Requires a PDF viewer such as GSview, Xpdf or Adobe Acrobat Reader Download (1MB) | Preview

URL:	http://www.ppig.org/node/1088
Google Scholar:	Look up in Google Scholar

Abstract

Data expressed in tables may be re-arranged in various forms, while conveying the same information. This can create a tension when one form is easier to comprehend by a human reader, but another form is more convenient for processing by machine. This problem has received considerable attention for data scientists writing code, but rather less for end user analysts using spreadsheets. We propose a new data model, the “lish”, which supports a spreadsheet-like flexibility of layout, while capturing sufficient structure to facilitate processing. Using a typical example in a prototype editor, we demonstrate how it might help users resolve the tension between the two forms. A user study is in preparation.

Item Type:	Conference or Workshop Item
Academic Unit/School:	Faculty of Science, Technology, Engineering and Mathematics (STEM) Faculty of Science, Technology, Engineering and Mathematics (STEM) > Computing and Communications
Research Group:	Centre for Research in Computing (CRC)
Item ID:	56529
Depositing User:	Alan Geoffrey Hall
Date Deposited:	28 Sep 2018 15:08
Last Modified:	07 Dec 2018 22:42
URI:	http://oro.open.ac.uk/id/eprint/56529
Share this page:

Actions (login may be required)

RDF+XMLBibTeXRIOXX2 XMLRDF+N-TriplesJSONDublin CoreAtomSimple MetadataReferMETSHTML CitationASCII CitationRefMan RIS Format (UTF-8)OpenURL ContextObjectEndNoteMODSOpenURL ContextObject in SpanMPEG-21 DIDLEP3 XMLRefMan RIS FormatRDF+N3