{"id":"https://openalex.org/W2064766209","doi":"https://doi.org/10.1145/1978942.1979444","title":"Wrangler","display_name":"Wrangler","publication_year":2011,"publication_date":"2011-05-07","ids":{"openalex":"https://openalex.org/W2064766209","doi":"https://doi.org/10.1145/1978942.1979444","mag":"2064766209"},"language":"en","primary_location":{"id":"doi:10.1145/1978942.1979444","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1978942.1979444","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the SIGCHI Conference on Human Factors in Computing Systems","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5111792512","display_name":"Sean Kandel","orcid":null},"institutions":[{"id":"https://openalex.org/I97018004","display_name":"Stanford University","ror":"https://ror.org/00f54p054","country_code":"US","type":"education","lineage":["https://openalex.org/I97018004"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Sean Kandel","raw_affiliation_strings":["Stanford University, Stanford, California, USA"],"affiliations":[{"raw_affiliation_string":"Stanford University, Stanford, California, USA","institution_ids":["https://openalex.org/I97018004"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5071755113","display_name":"Andreas Paepcke","orcid":null},"institutions":[{"id":"https://openalex.org/I97018004","display_name":"Stanford University","ror":"https://ror.org/00f54p054","country_code":"US","type":"education","lineage":["https://openalex.org/I97018004"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Andreas Paepcke","raw_affiliation_strings":["Stanford University, Stanford, California, USA"],"affiliations":[{"raw_affiliation_string":"Stanford University, Stanford, California, USA","institution_ids":["https://openalex.org/I97018004"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5043626252","display_name":"Joseph M. Hellerstein","orcid":"https://orcid.org/0000-0002-7712-4306"},"institutions":[{"id":"https://openalex.org/I95457486","display_name":"University of California, Berkeley","ror":"https://ror.org/01an7q238","country_code":"US","type":"education","lineage":["https://openalex.org/I95457486"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Joseph Hellerstein","raw_affiliation_strings":["University of California, Berkeley, Berkeley, California, USA"],"affiliations":[{"raw_affiliation_string":"University of California, Berkeley, Berkeley, California, USA","institution_ids":["https://openalex.org/I95457486"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5090570042","display_name":"Jeffrey Heer","orcid":"https://orcid.org/0000-0002-6175-1655"},"institutions":[{"id":"https://openalex.org/I97018004","display_name":"Stanford University","ror":"https://ror.org/00f54p054","country_code":"US","type":"education","lineage":["https://openalex.org/I97018004"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Jeffrey Heer","raw_affiliation_strings":["Stanford University, Stanford, California, USA"],"affiliations":[{"raw_affiliation_string":"Stanford University, Stanford, California, USA","institution_ids":["https://openalex.org/I97018004"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5111792512"],"corresponding_institution_ids":["https://openalex.org/I97018004"],"apc_list":null,"apc_paid":null,"fwci":25.8239,"has_fulltext":false,"cited_by_count":575,"citation_normalized_percentile":{"value":0.99740688,"is_in_top_1_percent":true,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":99,"max":100},"biblio":{"volume":null,"issue":null,"first_page":"3363","last_page":"3372"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9994999766349792,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},"topics":[{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9994999766349792,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9965000152587891,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T12205","display_name":"Time Series Analysis and Forecasting","score":0.9955000281333923,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8561633825302124},{"id":"https://openalex.org/keywords/scripting-language","display_name":"Scripting language","score":0.7414883375167847},{"id":"https://openalex.org/keywords/data-transformation","display_name":"Data transformation","score":0.6030518412590027},{"id":"https://openalex.org/keywords/reuse","display_name":"Reuse","score":0.5910062789916992},{"id":"https://openalex.org/keywords/data-type","display_name":"Data type","score":0.5080265998840332},{"id":"https://openalex.org/keywords/transformation","display_name":"Transformation (genetics)","score":0.505434513092041},{"id":"https://openalex.org/keywords/data-exploration","display_name":"Data exploration","score":0.47828492522239685},{"id":"https://openalex.org/keywords/annotation","display_name":"Annotation","score":0.4728788733482361},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.4642978310585022},{"id":"https://openalex.org/keywords/inference","display_name":"Inference","score":0.4584921896457672},{"id":"https://openalex.org/keywords/data-modeling","display_name":"Data modeling","score":0.43269088864326477},{"id":"https://openalex.org/keywords/data-manipulation-language","display_name":"Data manipulation language","score":0.4100337624549866},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.38922229409217834},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.3491514325141907},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.31072360277175903},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.28571850061416626},{"id":"https://openalex.org/keywords/visualization","display_name":"Visualization","score":0.25465285778045654},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.20122548937797546},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.19333875179290771}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8561633825302124},{"id":"https://openalex.org/C61423126","wikidata":"https://www.wikidata.org/wiki/Q187432","display_name":"Scripting language","level":2,"score":0.7414883375167847},{"id":"https://openalex.org/C150670458","wikidata":"https://www.wikidata.org/wiki/Q4272815","display_name":"Data transformation","level":3,"score":0.6030518412590027},{"id":"https://openalex.org/C206588197","wikidata":"https://www.wikidata.org/wiki/Q846574","display_name":"Reuse","level":2,"score":0.5910062789916992},{"id":"https://openalex.org/C138958017","wikidata":"https://www.wikidata.org/wiki/Q190087","display_name":"Data type","level":2,"score":0.5080265998840332},{"id":"https://openalex.org/C204241405","wikidata":"https://www.wikidata.org/wiki/Q461499","display_name":"Transformation (genetics)","level":3,"score":0.505434513092041},{"id":"https://openalex.org/C2780977526","wikidata":"https://www.wikidata.org/wiki/Q42417149","display_name":"Data exploration","level":3,"score":0.47828492522239685},{"id":"https://openalex.org/C2776321320","wikidata":"https://www.wikidata.org/wiki/Q857525","display_name":"Annotation","level":2,"score":0.4728788733482361},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4642978310585022},{"id":"https://openalex.org/C2776214188","wikidata":"https://www.wikidata.org/wiki/Q408386","display_name":"Inference","level":2,"score":0.4584921896457672},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.43269088864326477},{"id":"https://openalex.org/C56288433","wikidata":"https://www.wikidata.org/wiki/Q58673","display_name":"Data manipulation language","level":2,"score":0.4100337624549866},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.38922229409217834},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.3491514325141907},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.31072360277175903},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.28571850061416626},{"id":"https://openalex.org/C36464697","wikidata":"https://www.wikidata.org/wiki/Q451553","display_name":"Visualization","level":2,"score":0.25465285778045654},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.20122548937797546},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.19333875179290771},{"id":"https://openalex.org/C104317684","wikidata":"https://www.wikidata.org/wiki/Q7187","display_name":"Gene","level":2,"score":0.0},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0},{"id":"https://openalex.org/C55493867","wikidata":"https://www.wikidata.org/wiki/Q7094","display_name":"Biochemistry","level":1,"score":0.0},{"id":"https://openalex.org/C185592680","wikidata":"https://www.wikidata.org/wiki/Q2329","display_name":"Chemistry","level":0,"score":0.0},{"id":"https://openalex.org/C18903297","wikidata":"https://www.wikidata.org/wiki/Q7150","display_name":"Ecology","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/1978942.1979444","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1978942.1979444","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the SIGCHI Conference on Human Factors in Computing Systems","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[{"id":"https://openalex.org/F4320306077","display_name":"Boeing","ror":"https://ror.org/04sm5zn07"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":27,"referenced_works":["https://openalex.org/W1528027857","https://openalex.org/W1551385575","https://openalex.org/W1713170780","https://openalex.org/W1732744741","https://openalex.org/W1984566373","https://openalex.org/W1990751139","https://openalex.org/W1997533292","https://openalex.org/W2008896880","https://openalex.org/W2017666497","https://openalex.org/W2059216172","https://openalex.org/W2086512465","https://openalex.org/W2102480769","https://openalex.org/W2106039833","https://openalex.org/W2106895292","https://openalex.org/W2108991785","https://openalex.org/W2119803607","https://openalex.org/W2121932026","https://openalex.org/W2123390832","https://openalex.org/W2126650630","https://openalex.org/W2137130182","https://openalex.org/W2138591041","https://openalex.org/W2149263361","https://openalex.org/W2150721933","https://openalex.org/W2151763080","https://openalex.org/W2162340487","https://openalex.org/W4246839229","https://openalex.org/W4250102289"],"related_works":["https://openalex.org/W4205595170","https://openalex.org/W4387885925","https://openalex.org/W4235215226","https://openalex.org/W2080666752","https://openalex.org/W2354685366","https://openalex.org/W2495476782","https://openalex.org/W2062907001","https://openalex.org/W4206881509","https://openalex.org/W1010365724","https://openalex.org/W2064766209"],"abstract_inverted_index":{"Though":[0],"data":[1,18,21,30,42,71,79,103],"analysis":[2,56],"tools":[3],"continue":[4],"to":[5,49,53,88,111],"improve,":[6],"analysts":[7,87],"still":[8],"expend":[9],"an":[10,66],"inordinate":[11],"amount":[12],"of":[13,77,83,93,124,141,146],"time":[14,136],"and":[15,19,39,51,59,96,114,122,137],"effort":[16],"manipulating":[17],"assessing":[20],"quality":[22],"issues.":[23],"Such":[24],"\"data":[25],"wrangling\"":[26],"regularly":[27],"involves":[28],"reformatting":[29],"values":[31],"or":[32,36],"layout,":[33],"correcting":[34],"erroneous":[35],"missing":[37],"values,":[38],"integrating":[40],"multiple":[41],"sources.":[43],"These":[44],"transforms":[45,144],"are":[46],"often":[47],"difficult":[48,52],"specify":[50],"reuse":[54],"across":[55],"tasks,":[57],"teams,":[58],"tools.":[60],"In":[61],"response,":[62],"we":[63],"introduce":[64],"Wrangler,":[65],"interactive":[67],"system":[68],"for":[69],"creating":[70],"transformations.":[72],"Wrangler":[73,100,132],"combines":[74],"direct":[75],"manipulation":[76],"visualized":[78],"with":[80],"automatic":[81],"inference":[82],"relevant":[84],"transforms,":[85],"enabling":[86],"iteratively":[89],"explore":[90],"the":[91,139],"space":[92],"applicable":[94],"operations":[95],"preview":[97],"their":[98],"effects.":[99],"leverages":[101],"semantic":[102],"types":[104],"(e.g.,":[105],"geographic":[106],"locations,":[107],"dates,":[108],"classification":[109],"codes)":[110],"aid":[112],"validation":[113],"type":[115],"conversion.":[116],"Interactive":[117],"histories":[118],"support":[119],"review,":[120],"refinement,":[121],"annotation":[123],"transformation":[125],"scripts.":[126],"User":[127],"study":[128],"results":[129],"show":[130],"that":[131],"significantly":[133],"reduces":[134],"specification":[135],"promotes":[138],"use":[140],"robust,":[142],"auditable":[143],"instead":[145],"manual":[147],"editing.":[148]},"counts_by_year":[{"year":2026,"cited_by_count":7},{"year":2025,"cited_by_count":43},{"year":2024,"cited_by_count":34},{"year":2023,"cited_by_count":39},{"year":2022,"cited_by_count":44},{"year":2021,"cited_by_count":50},{"year":2020,"cited_by_count":58},{"year":2019,"cited_by_count":67},{"year":2018,"cited_by_count":63},{"year":2017,"cited_by_count":37},{"year":2016,"cited_by_count":37},{"year":2015,"cited_by_count":35},{"year":2014,"cited_by_count":25},{"year":2013,"cited_by_count":16},{"year":2012,"cited_by_count":14}],"updated_date":"2026-04-14T08:04:32.555800","created_date":"2016-06-24T00:00:00"}