{"id":"https://openalex.org/W7052841223","doi":null,"title":"Tools and Techniques for Building Programming Assistants for Data Analysis","display_name":"Tools and Techniques for Building Programming Assistants for Data Analysis","alternate_titles":[],"publication_year":2022,"publication_date":"2022-01-01","ids":{"openalex":"https://openalex.org/W7052841223"},"language":"en","primary_location":{"id":"pmh:oai:escholarship.org:ark:/13030/qt7376p3tm","doi":null,"is_oa":false,"landing_page_url":"https://escholarship.org/uc/item/7376p3tm","pdf_url":null,"source":{"id":"https://openalex.org/S4306400115","display_name":"eScholarship (California Digital Library)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I2801248553","host_organization_name":"California Digital Library","host_organization_lineage":["https://openalex.org/I2801248553"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"etd"},"parent_works":[],"lineage":["https://openalex.org/W7052841223"],"child_works_count":0,"type":"dissertation","is_traditional":true,"indexed_in":[],"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/A5053047136","display_name":"Rohan Bavishi","orcid":"https://orcid.org/0000-0002-0307-0384","observed_orcids":["https://orcid.org/0000-0002-0307-0384"]},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Bavishi, Rohan Jayesh","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":["https://openalex.org/A5053047136"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":true,"primary_topic":{"id":"https://openalex.org/T10260","display_name":"Software Engineering Research","score":0.7476000189781189,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10260","display_name":"Software Engineering Research","score":0.7476000189781189,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/T13197","display_name":"Spreadsheets and End-User Computing","score":0.10189999639987946,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"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/T10533","display_name":"Teaching and Learning Programming","score":0.024000000208616257,"subfield":{"id":"https://openalex.org/subfields/1706","display_name":"Computer Science Applications"},"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/automatic-code-generation","display_name":"automatic code generation","score":0.8510000109672546},{"id":"https://openalex.org/keywords/data-processing","display_name":"data processing","score":0.4699999988079071},{"id":"https://openalex.org/keywords/data-visualization","display_name":"data visualization","score":0.9750000238418579},{"id":"https://openalex.org/keywords/data-wrangling","display_name":"data wrangling","score":0.6759999990463257},{"id":"https://openalex.org/keywords/data-profiling","display_name":"data profiling","score":0.6809999942779541},{"id":"https://openalex.org/keywords/natural-language-specifications","display_name":"natural language specifications","score":0.6190000176429749},{"id":"https://openalex.org/keywords/input-output-examples","display_name":"input-output examples","score":0.7409999966621399},{"id":"https://openalex.org/keywords/demonstration-based-learning","display_name":"demonstration-based learning","score":0.4620000123977661},{"id":"https://openalex.org/keywords/semantic-parsing","display_name":"semantic parsing","score":0.5559999942779541},{"id":"https://openalex.org/keywords/program-synthesis","display_name":"program synthesis","score":0.5270000100135803},{"id":"https://openalex.org/keywords/large-language-models","display_name":"large language models","score":0.5839999914169312},{"id":"https://openalex.org/keywords/self-service-analytics","display_name":"self-service analytics","score":0.5379999876022339},{"id":"https://openalex.org/keywords/pandas","display_name":"PANDAS","score":0.3310000002384186},{"id":"https://openalex.org/keywords/matplotlib","display_name":"Matplotlib","score":0.8859999775886536},{"id":"https://openalex.org/keywords/scikit-learn","display_name":"scikit-learn","score":0.9580000042915344}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8129000067710876},{"id":"https://openalex.org/C2778514511","wikidata":"https://www.wikidata.org/wiki/Q1374194","display_name":"Programmer","level":2,"score":0.6807000041007996},{"id":"https://openalex.org/C79158427","wikidata":"https://www.wikidata.org/wiki/Q485396","display_name":"Analytics","level":2,"score":0.654699981212616},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.613099992275238},{"id":"https://openalex.org/C56666940","wikidata":"https://www.wikidata.org/wiki/Q788790","display_name":"Documentation","level":2,"score":0.5534999966621399},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.5491999983787537},{"id":"https://openalex.org/C172367668","wikidata":"https://www.wikidata.org/wiki/Q6504956","display_name":"Data visualization","level":3,"score":0.4887999892234802},{"id":"https://openalex.org/C36464697","wikidata":"https://www.wikidata.org/wiki/Q451553","display_name":"Visualization","level":2,"score":0.4587000012397766},{"id":"https://openalex.org/C175801342","wikidata":"https://www.wikidata.org/wiki/Q1988917","display_name":"Data analysis","level":2,"score":0.44350001215934753},{"id":"https://openalex.org/C177212765","wikidata":"https://www.wikidata.org/wiki/Q627335","display_name":"Workflow","level":2,"score":0.4426000118255615},{"id":"https://openalex.org/C2777648619","wikidata":"https://www.wikidata.org/wiki/Q2845208","display_name":"Learning analytics","level":2,"score":0.41909998655319214},{"id":"https://openalex.org/C2767350","wikidata":"https://www.wikidata.org/wiki/Q6662173","display_name":"Business intelligence","level":2,"score":0.4032000005245209},{"id":"https://openalex.org/C2779038628","wikidata":"https://www.wikidata.org/wiki/Q7248497","display_name":"Programming by demonstration","level":3,"score":0.38089999556541443},{"id":"https://openalex.org/C34165917","wikidata":"https://www.wikidata.org/wiki/Q188267","display_name":"Programming paradigm","level":2,"score":0.3564999997615814},{"id":"https://openalex.org/C14036430","wikidata":"https://www.wikidata.org/wiki/Q3736076","display_name":"Function (biology)","level":2,"score":0.3407999873161316},{"id":"https://openalex.org/C107457646","wikidata":"https://www.wikidata.org/wiki/Q207434","display_name":"Human\u2013computer interaction","level":1,"score":0.3400000035762787},{"id":"https://openalex.org/C517642484","wikidata":"https://www.wikidata.org/wiki/Q2388514","display_name":"Intelligence analysis","level":2,"score":0.33570000529289246},{"id":"https://openalex.org/C2780625559","wikidata":"https://www.wikidata.org/wiki/Q5152592","display_name":"Commercialization","level":2,"score":0.33399999141693115},{"id":"https://openalex.org/C99613125","wikidata":"https://www.wikidata.org/wiki/Q165194","display_name":"Application programming interface","level":2,"score":0.3314000070095062},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.3203999996185303},{"id":"https://openalex.org/C70388272","wikidata":"https://www.wikidata.org/wiki/Q5968558","display_name":"IBM","level":2,"score":0.31779998540878296},{"id":"https://openalex.org/C37952496","wikidata":"https://www.wikidata.org/wiki/Q5001829","display_name":"Business analytics","level":4,"score":0.3133000135421753},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.31040000915527344},{"id":"https://openalex.org/C75684735","wikidata":"https://www.wikidata.org/wiki/Q858810","display_name":"Big data","level":2,"score":0.303600013256073},{"id":"https://openalex.org/C98184364","wikidata":"https://www.wikidata.org/wiki/Q1780131","display_name":"Argument (complex analysis)","level":2,"score":0.2992999851703644},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.2883000075817108},{"id":"https://openalex.org/C171981572","wikidata":"https://www.wikidata.org/wiki/Q7554239","display_name":"Software analytics","level":5,"score":0.2863999903202057},{"id":"https://openalex.org/C3913047","wikidata":"https://www.wikidata.org/wiki/Q1956265","display_name":"sync","level":3,"score":0.28349998593330383},{"id":"https://openalex.org/C162319229","wikidata":"https://www.wikidata.org/wiki/Q175263","display_name":"Data structure","level":2,"score":0.28130000829696655},{"id":"https://openalex.org/C98183937","wikidata":"https://www.wikidata.org/wiki/Q2112188","display_name":"Program analysis","level":2,"score":0.2809000015258789},{"id":"https://openalex.org/C79974875","wikidata":"https://www.wikidata.org/wiki/Q483639","display_name":"Cloud computing","level":2,"score":0.275299996137619},{"id":"https://openalex.org/C132964779","wikidata":"https://www.wikidata.org/wiki/Q2110223","display_name":"Raw data","level":2,"score":0.2712000012397766},{"id":"https://openalex.org/C168065819","wikidata":"https://www.wikidata.org/wiki/Q845566","display_name":"Debugging","level":2,"score":0.27079999446868896},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.262800008058548},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.2583000063896179},{"id":"https://openalex.org/C64073096","wikidata":"https://www.wikidata.org/wiki/Q451553","display_name":"Interactive visualization","level":3,"score":0.2558000087738037},{"id":"https://openalex.org/C34585555","wikidata":"https://www.wikidata.org/wiki/Q1368723","display_name":"Learning curve","level":2,"score":0.2540999948978424},{"id":"https://openalex.org/C2778519782","wikidata":"https://www.wikidata.org/wiki/Q1974060","display_name":"Need to know","level":2,"score":0.2524000108242035}],"mesh":[],"locations_count":1,"locations":[{"id":"pmh:oai:escholarship.org:ark:/13030/qt7376p3tm","doi":null,"is_oa":false,"landing_page_url":"https://escholarship.org/uc/item/7376p3tm","pdf_url":null,"source":{"id":"https://openalex.org/S4306400115","display_name":"eScholarship (California Digital Library)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I2801248553","host_organization_name":"California Digital Library","host_organization_lineage":["https://openalex.org/I2801248553"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"etd"}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W2937941150","https://openalex.org/W7149464663","https://openalex.org/W7096745844","https://openalex.org/W7084113779","https://openalex.org/W2770408320","https://openalex.org/W83531673","https://openalex.org/W2882998885","https://openalex.org/W2111326680","https://openalex.org/W3139685436","https://openalex.org/W4396832182"],"abstract_inverted_index":{"We":[0],"live":[1],"in":[2,29,45,148,217,264,361,417,484],"the":[3,26,42,55,58,158,180,183,189,247,251,331,346,350,395,415,517,532,538],"data":[4,7,31,46,103,308,315],"age.":[5],"Today,":[6],"analytics":[8,32,120],"drives":[9],"much":[10,92,201,355],"of":[11,25,41,62,73,110,162,185,191,342,348,383,388,397,419,520,534,540],"business":[12],"decision-making,":[13],"logistics,":[14],"advertising,":[15],"and":[16,21,49,99,105,146,193,234,282,291,304,310,323,336,364,437,446,461,469,476,479,487,494,499,507,537],"recommendations.":[17],"Data":[18],"wrangling,":[19],"profiling,":[20],"visualization":[22,106,311],"are":[23,166,177,431],"some":[24],"key":[27],"tasks":[28,35,344],"a":[30,39,116,124,149,155,167,215,240,339,378,409],"workflow.":[33],"These":[34,269],"also":[36],"account":[37],"for":[38,69,102,157,242,254,377,490],"majority":[40],"time":[43,202],"spent":[44],"analysis.":[47],"Academics":[48],"industry":[50],"leaders":[51],"have":[52,127,198],"long":[53,329],"attributed":[54],"disparity":[56],"to":[57,115,141,179,199,221,226,249,260,372,413,502,514,526],"inherent":[59],"domain-specific":[60],"nature":[61],"data,":[63],"which":[64,511],"necessitates":[65],"highly":[66],"custom":[67,77],"treatment":[68],"every":[70],"new":[71],"source":[72],"data.":[74],"Specifying":[75],"these":[76,204,529],"analysis":[78,164,343],"steps":[79],"using":[80],"low-level":[81],"tools":[82,101,131,145,205],"such":[83,130,230,318],"as":[84,132,134,152,154,231,319],"Excel":[85],"can":[86,425],"be":[87],"prohibitively":[88],"cumbersome.":[89],"In":[90],"response,":[91],"research":[93,112,360],"has":[94,113,328,367],"focused":[95],"on":[96],"smarter":[97],"interactive":[98],"graphical":[100],"processing":[104,309,392],"tasks.":[107,384],"Successful":[108],"commercialization":[109],"this":[111,421,440],"contributed":[114],"$3":[117],"billion":[118],"self-service":[119],"industry.However,":[121],"analysts":[122,256],"with":[123,257,262],"programming":[125,186,243,428],"background":[126],"not":[128,173],"adopted":[129],"widely":[133],"their":[135,258,265,405],"non-programmer":[136],"colleagues":[137],"have.":[138],"The":[139,385],"desire":[140,259],"avoid":[142],"shuffling":[143],"between":[144,334],"work":[147,261,445],"single":[150],"environment,":[151],"well":[153],"need":[156,241,248],"full,":[159],"unbounded":[160,402],"expressivity":[161,184,335,371,533],"programming-based":[163],"tools,":[165],"few":[168],"major":[169],"reasons.":[170],"This":[171],"does":[172],"mean":[174],"that":[175,245,295,354,430,452],"programmers":[176],"immune":[178],"specification":[181,252],"burden;":[182],"comes":[187],"at":[188],"cost":[190],"complexity":[192],"steep":[194],"learning":[195,203],"curves.":[196],"Novices":[197],"spend":[200],"from":[206,219,285,455],"books":[207],"or":[208,300],"fragmented":[209],"resources":[210],"online.":[211],"Even":[212],"experts":[213],"report":[214],"loss":[216],"productivity":[218],"having":[220],"constantly":[222],"look":[223],"up":[224],"documentation":[225],"get":[227],"uninteresting":[228],"details":[229],"function":[232],"names":[233],"argument":[235],"values":[236],"right.Thus,":[237],"there":[238],"is":[239],"assistants":[244,270,294,530],"reconcile":[246],"reduce":[250],"burden":[253],"programmer":[255],"code":[263,275,284,312,326,352,375,449,506],"preferred":[266],"development":[267],"environments.":[268],"should":[271],"help":[272],"programmer-analysts":[273],"write":[274],"more":[276,356],"efficiently":[277],"by":[278],"automatically":[279,305,503],"generating":[280,349],"human-readable":[281],"readily-integrable":[283],"high-level":[286],"specifications.This":[287],"dissertation":[288,411,441],"introduces":[289,447],"techniques":[290,451,468,501],"corresponding":[292,470],"prototypical":[293],"accept":[296],"input-output":[297],"examples,":[298],"demonstrations,":[299],"natural":[301,390,508],"language":[302,391,399,509,523],"specifications":[303],"generate":[306],"suitable":[307],"utilizing":[313],"popular":[314],"science":[316],"libraries":[317],"pandas,":[320],"matplotlib,":[321],"seaborn,":[322],"scikit-learn.":[324],"Automatic":[325],"generation":[327,376,450],"faced":[330],"tradeoff":[332,422],"barrier":[333,423],"performance/accuracy:":[337],"supporting":[338],"large":[340,398,522],"number":[341],"makes":[345],"problem":[347],"right":[351],"quickly":[353],"difficult.":[357],"Accordingly,":[358],"prior":[359,444,527],"program":[362,459],"synthesis":[363],"semantic":[365],"parsing":[366],"largely":[368],"sacrificed":[369],"full":[370],"support":[373],"efficient":[374],"small":[379],"but":[380,404],"useful":[381],"subset":[382],"code-as-text":[386],"approach":[387],"modern":[389,521],"systems,":[393],"including":[394],"use":[396],"models,":[400],"promises":[401],"expressivity,":[403],"sub-optimal":[406],"accuracy":[407,539],"remains":[408],"concern.This":[410],"tries":[412],"push":[414],"boundaries":[416],"terms":[418],"breaking":[420],"---":[424],"we":[426],"build":[427,504],"systems":[429,536],"fully":[432],"expressive":[433],"while":[434],"remaining":[435],"fast":[436],"accurate?":[438],"Specifically,":[439],"builds":[442],"upon":[443],"novel":[448,497],"combine":[453],"insights":[454],"synthesis,":[456],"automated":[457],"testing,":[458],"analysis,":[460],"machine":[462],"learning.":[463],"It":[464],"contributes":[465],"four":[466],"core":[467,482],"assistants,":[471],"namely":[472],"AutoPandas,":[473],"Gauss,":[474],"VizSmith,":[475],"Datana.":[477],"AutoPandas":[478],"Gauss":[480],"constitute":[481],"advances":[483],"search":[485],"space":[486],"algorithm":[488],"design":[489],"example-based":[491],"synthesis.":[492],"VizSmith":[493],"Datana":[495,512],"introduce":[496],"mining":[498],"auto-summarization":[500],"aligned":[505],"corpora,":[510],"uses":[513],"greatly":[515],"improve":[516,531],"code-generation":[518],"capabilities":[519],"models.":[524],"Compared":[525],"work,":[528],"synthesis-based":[535],"machine-learning-based":[541],"systems.":[542]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W7052841223","counts_by_year":[{"year":2023,"cited_by_count":1}],"updated_date":"2026-11-16T12:05:36.265796","created_date":"2025-10-10T00:00:00"}
