{"id":"https://openalex.org/W4381546658","doi":"https://doi.org/10.1145/3596673.3596972","title":"Teaching Data Science by Visualizing Data Table Transformations: Pandas Tutor for Python, Tidy Data Tutor for R, and SQL Tutor","display_name":"Teaching Data Science by Visualizing Data Table Transformations: Pandas Tutor for Python, Tidy Data Tutor for R, and SQL Tutor","publication_year":2023,"publication_date":"2023-06-21","ids":{"openalex":"https://openalex.org/W4381546658","doi":"https://doi.org/10.1145/3596673.3596972"},"language":"en","primary_location":{"id":"doi:10.1145/3596673.3596972","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3596673.3596972","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3596673.3596972","source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2nd International Workshop on Data Systems Education: Bridging education practice with education research","raw_type":"proceedings-article"},"type":"conference-paper","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://dl.acm.org/doi/pdf/10.1145/3596673.3596972","any_repository_has_fulltext":null},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5038302086","display_name":"Sam Lau","orcid":"https://orcid.org/0000-0002-3160-0151"},"institutions":[{"id":"https://openalex.org/I36258959","display_name":"University of California San Diego","ror":"https://ror.org/0168r3w48","country_code":"US","type":"education","lineage":["https://openalex.org/I36258959"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Sam Lau","raw_affiliation_strings":["UC San Diego, La Jolla, CA, United States of America"],"raw_orcid":"https://orcid.org/0000-0002-3160-0151","affiliations":[{"raw_affiliation_string":"UC San Diego, La Jolla, CA, United States of America","institution_ids":["https://openalex.org/I36258959"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5031432466","display_name":"Sean Kross","orcid":"https://orcid.org/0000-0001-5215-0316"},"institutions":[{"id":"https://openalex.org/I4210089486","display_name":"Fred Hutch Cancer Center","ror":"https://ror.org/007ps6h72","country_code":"US","type":"nonprofit","lineage":["https://openalex.org/I4210089486"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Sean Kross","raw_affiliation_strings":["Fred Hutchinson Cancer Center, Seattle, WA, USA"],"raw_orcid":"https://orcid.org/0000-0001-5215-0316","affiliations":[{"raw_affiliation_string":"Fred Hutchinson Cancer Center, Seattle, WA, USA","institution_ids":["https://openalex.org/I4210089486"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5049016095","display_name":"Eugene Wu","orcid":"https://orcid.org/0000-0003-4254-6688"},"institutions":[{"id":"https://openalex.org/I78577930","display_name":"Columbia University","ror":"https://ror.org/00hj8s172","country_code":"US","type":"education","lineage":["https://openalex.org/I78577930"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Eugene Wu","raw_affiliation_strings":["Columbia University, New York, NY, United States of America"],"raw_orcid":"https://orcid.org/0000-0003-4254-6688","affiliations":[{"raw_affiliation_string":"Columbia University, New York, NY, United States of America","institution_ids":["https://openalex.org/I78577930"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5060695800","display_name":"Philip J. Guo","orcid":"https://orcid.org/0000-0002-4579-5754"},"institutions":[{"id":"https://openalex.org/I36258959","display_name":"University of California San Diego","ror":"https://ror.org/0168r3w48","country_code":"US","type":"education","lineage":["https://openalex.org/I36258959"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Philip J. Guo","raw_affiliation_strings":["UC San Diego, La Jolla, CA, USA"],"raw_orcid":"https://orcid.org/0000-0002-4579-5754","affiliations":[{"raw_affiliation_string":"UC San Diego, La Jolla, CA, USA","institution_ids":["https://openalex.org/I36258959"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":true,"cited_by_count":9,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"50","last_page":"55"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10799","display_name":"Data Visualization and Analytics","score":0.9944999814033508,"subfield":{"id":"https://openalex.org/subfields/1707","display_name":"Computer Vision and Pattern Recognition"},"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/T10799","display_name":"Data Visualization and Analytics","score":0.9944999814033508,"subfield":{"id":"https://openalex.org/subfields/1707","display_name":"Computer Vision and Pattern Recognition"},"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/T13650","display_name":"Computational Physics and Python Applications","score":0.9883999824523926,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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/T11986","display_name":"Scientific Computing and Data Management","score":0.9797999858856201,"subfield":{"id":"https://openalex.org/subfields/1802","display_name":"Information Systems and Management"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/python","display_name":"Python (programming language)","score":0.8288875818252563},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8232231140136719},{"id":"https://openalex.org/keywords/tutor","display_name":"TUTOR","score":0.7446739077568054},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.5899957418441772},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.5836212635040283},{"id":"https://openalex.org/keywords/visualization","display_name":"Visualization","score":0.5344139337539673},{"id":"https://openalex.org/keywords/scripting-language","display_name":"Scripting language","score":0.5024325847625732},{"id":"https://openalex.org/keywords/data-visualization","display_name":"Data visualization","score":0.4828417897224426},{"id":"https://openalex.org/keywords/computer-graphics","display_name":"Computer graphics (images)","score":0.3537817597389221},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.28754723072052}],"concepts":[{"id":"https://openalex.org/C519991488","wikidata":"https://www.wikidata.org/wiki/Q28865","display_name":"Python (programming language)","level":2,"score":0.8288875818252563},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8232231140136719},{"id":"https://openalex.org/C2778371403","wikidata":"https://www.wikidata.org/wiki/Q7672049","display_name":"TUTOR","level":2,"score":0.7446739077568054},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5899957418441772},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.5836212635040283},{"id":"https://openalex.org/C36464697","wikidata":"https://www.wikidata.org/wiki/Q451553","display_name":"Visualization","level":2,"score":0.5344139337539673},{"id":"https://openalex.org/C61423126","wikidata":"https://www.wikidata.org/wiki/Q187432","display_name":"Scripting language","level":2,"score":0.5024325847625732},{"id":"https://openalex.org/C172367668","wikidata":"https://www.wikidata.org/wiki/Q6504956","display_name":"Data visualization","level":3,"score":0.4828417897224426},{"id":"https://openalex.org/C121684516","wikidata":"https://www.wikidata.org/wiki/Q7600677","display_name":"Computer graphics (images)","level":1,"score":0.3537817597389221},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.28754723072052}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3596673.3596972","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3596673.3596972","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3596673.3596972","source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2nd International Workshop on Data Systems Education: Bridging education practice with education research","raw_type":"proceedings-article"}],"best_oa_location":{"id":"doi:10.1145/3596673.3596972","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3596673.3596972","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3596673.3596972","source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2nd International Workshop on Data Systems Education: Bridging education practice with education research","raw_type":"proceedings-article"},"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G2554194520","display_name":"Collaborative Research: CNS CORE: Medium: A Unified Prefetch Framework for Approximation Tolerant Interactive Applications","funder_award_id":"2106197","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G2968948865","display_name":"CAREER: Visual Database Interfaces","funder_award_id":"1845638","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G3486720790","display_name":"III: Small: Bringing database query optimization to data intensive applications","funder_award_id":"2008295","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G3506836683","display_name":null,"funder_award_id":"IIS-1845900","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G5704097577","display_name":"Elements: Open-Source Cyberinfrastructure as a Decision Engine for Socioeconomic Disaster Risk (DESDR)","funder_award_id":"2103794","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G582452355","display_name":null,"funder_award_id":"1845638, 1740305, 2008295, 2106197, 2103794","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G6502487888","display_name":"SI2-SSE: Improving Scikit-Learn Usability and Automation","funder_award_id":"1740305","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G7238130111","display_name":null,"funder_award_id":"NSF IIS-1845900","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G7790866075","display_name":"CAREER: Interactive Systems for Learning Programming at Scale","funder_award_id":"1845900","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"}],"funders":[{"id":"https://openalex.org/F4320306076","display_name":"National Science Foundation","ror":"https://ror.org/021nxhr62"},{"id":"https://openalex.org/F4320306151","display_name":"Alfred P. Sloan Foundation","ror":"https://ror.org/052csg198"},{"id":"https://openalex.org/F4320332603","display_name":"University of California, San Diego","ror":"https://ror.org/0168r3w48"}],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4381546658.pdf","grobid_xml":"https://content.openalex.org/works/W4381546658.grobid-xml"},"referenced_works_count":17,"referenced_works":["https://openalex.org/W2064766209","https://openalex.org/W2079404256","https://openalex.org/W2114566476","https://openalex.org/W2122312470","https://openalex.org/W2132667707","https://openalex.org/W2167759247","https://openalex.org/W2593083061","https://openalex.org/W2949054050","https://openalex.org/W3019871180","https://openalex.org/W3082494217","https://openalex.org/W3104030782","https://openalex.org/W3160042174","https://openalex.org/W3203841973","https://openalex.org/W3205344510","https://openalex.org/W3209496184","https://openalex.org/W4233502048","https://openalex.org/W4235243453"],"related_works":["https://openalex.org/W3023169329","https://openalex.org/W4389470870","https://openalex.org/W2782165897","https://openalex.org/W1582950852","https://openalex.org/W4300438041","https://openalex.org/W2054104202","https://openalex.org/W2139703748","https://openalex.org/W2761254753","https://openalex.org/W1024825291","https://openalex.org/W2188981919"],"abstract_inverted_index":{"Data":[0,139],"science":[1],"instructors":[2,90],"often":[3],"find":[4],"it":[5],"hard":[6],"to":[7,9,25,32,39,58,91,165,183],"explain":[8,92],"students":[10,70],"how":[11,157],"a":[12,80,100,126],"piece":[13],"of":[14,43,84,121,128,156],"code":[15,66,151],"written":[16],"in":[17,23,169],"Python,":[18,137],"R,":[19],"or":[20,35,67],"SQL":[21,145],"executes":[22],"order":[24],"transform":[26],"tabular":[27,85],"data.":[28],"They":[29],"currently":[30],"resort":[31],"hand-drawing":[33],"diagrams":[34,55,155],"making":[36],"presentation":[37],"slides":[38],"illustrate":[40],"the":[41,106],"semantics":[42],"operations":[44],"such":[45],"as":[46],"filtering,":[47],"sorting,":[48],"reshaping,":[49],"pivoting,":[50],"grouping,":[51],"and":[52,60,109,116,144,152],"joining.":[53],"These":[54],"are":[56,71],"time-consuming":[57],"create":[59],"do":[61,96],"not":[62],"synchronize":[63],"with":[64],"real":[65],"data":[68,86,160],"that":[69,79,104,148],"learning":[72],"about.":[73],"In":[74],"this":[75,122],"paper":[76],"we":[77,98,124],"show":[78],"step-by-step":[81,162],"visual":[82],"representation":[83],"transforms":[87,159],"can":[88],"help":[89],"these":[93,186],"operations.":[94],"To":[95],"so,":[97],"created":[99],"table":[101],"visualization":[102,131],"library":[103,123],"illustrates":[105],"row-,":[107],"column-,":[108],"cell-wise":[110],"relationships":[111],"between":[112],"an":[113],"operation's":[114],"input":[115,164],"output":[117],"tables.":[118],"On":[119],"top":[120],"built":[125],"trio":[127],"free":[129],"web-based":[130],"tools":[132],"-":[133,147],"Pandas":[134],"Tutor":[135,140,146],"for":[136,141],"Tidy":[138],"R":[142],"tidyverse,":[143],"run":[149],"users'":[150],"automatically":[153],"produce":[154],"Python/R/SQL":[158],"tables":[161],"from":[163,175],"output.":[166],"Since":[167],"launching":[168],"Dec":[170],"2021,":[171],"over":[172,176],"61,000":[173],"people":[174],"160":[177],"countries":[178],"have":[179],"visited":[180],"our":[181],"website":[182],"try":[184],"out":[185],"tools.":[187]},"counts_by_year":[{"year":2026,"cited_by_count":2},{"year":2025,"cited_by_count":2},{"year":2024,"cited_by_count":4},{"year":2023,"cited_by_count":1}],"updated_date":"2026-07-14T23:27:15.235271","created_date":"2025-10-10T00:00:00"}