{"id":"https://openalex.org/W4409076703","doi":"https://doi.org/10.1109/access.2025.3556973","title":"Exploring the Potential of Offline LLMs in Data Science: A Study on Code Generation for Data Analysis","display_name":"Exploring the Potential of Offline LLMs in Data Science: A Study on Code Generation for Data Analysis","publication_year":2025,"publication_date":"2025-01-01","ids":{"openalex":"https://openalex.org/W4409076703","doi":"https://doi.org/10.1109/access.2025.3556973"},"language":"en","primary_location":{"id":"doi:10.1109/access.2025.3556973","is_oa":true,"landing_page_url":"https://doi.org/10.1109/access.2025.3556973","pdf_url":null,"source":{"id":"https://openalex.org/S2485537415","display_name":"IEEE Access","issn_l":"2169-3536","issn":["2169-3536"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Access","raw_type":"journal-article"},"type":"article","indexed_in":["crossref","doaj"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://doi.org/10.1109/access.2025.3556973","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5045505855","display_name":"\u0391\u03bd\u03b1\u03c3\u03c4\u03ac\u03c3\u03b9\u03bf\u03c2 \u039d\u03b9\u03ba\u03bf\u03bb\u03b1\u03ba\u03cc\u03c0\u03bf\u03c5\u03bb\u03bf\u03c2","orcid":"https://orcid.org/0000-0002-8054-5670"},"institutions":[{"id":"https://openalex.org/I174458059","display_name":"National Technical University of Athens","ror":"https://ror.org/03cx6bg69","country_code":"GR","type":"education","lineage":["https://openalex.org/I174458059"]},{"id":"https://openalex.org/I4210144519","display_name":"Institute of Communication and Computer Systems","ror":"https://ror.org/0483fn738","country_code":"GR","type":"nonprofit","lineage":["https://openalex.org/I4210144519"]}],"countries":["GR"],"is_corresponding":true,"raw_author_name":"Anastasios Nikolakopoulos","raw_affiliation_strings":["School of Electrical and Computer Engineering, Institute of Communication and Computer Systems, National Technical University of Athens, Zografou, Greece","Institute of Communication and Computer Systems, School of Electrical and Computer Engineering, National Technical University of Athens, Athens, Greece"],"raw_orcid":"https://orcid.org/0000-0002-8054-5670","affiliations":[{"raw_affiliation_string":"School of Electrical and Computer Engineering, Institute of Communication and Computer Systems, National Technical University of Athens, Zografou, Greece","institution_ids":["https://openalex.org/I174458059","https://openalex.org/I4210144519"]},{"raw_affiliation_string":"Institute of Communication and Computer Systems, School of Electrical and Computer Engineering, National Technical University of Athens, Athens, Greece","institution_ids":["https://openalex.org/I4210144519","https://openalex.org/I174458059"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5052912203","display_name":"\u0391\u03bd\u03c4\u03ce\u03bd\u03b9\u03bf\u03c2 \u039b\u03af\u03c4\u03ba\u03b5","orcid":"https://orcid.org/0000-0002-7658-2559"},"institutions":[{"id":"https://openalex.org/I174458059","display_name":"National Technical University of Athens","ror":"https://ror.org/03cx6bg69","country_code":"GR","type":"education","lineage":["https://openalex.org/I174458059"]},{"id":"https://openalex.org/I4210144519","display_name":"Institute of Communication and Computer Systems","ror":"https://ror.org/0483fn738","country_code":"GR","type":"nonprofit","lineage":["https://openalex.org/I4210144519"]}],"countries":["GR"],"is_corresponding":false,"raw_author_name":"Antonios Litke","raw_affiliation_strings":["School of Electrical and Computer Engineering, Institute of Communication and Computer Systems, National Technical University of Athens, Zografou, Greece","Institute of Communication and Computer Systems, School of Electrical and Computer Engineering, National Technical University of Athens, Athens, Greece"],"raw_orcid":"https://orcid.org/0000-0002-7658-2559","affiliations":[{"raw_affiliation_string":"School of Electrical and Computer Engineering, Institute of Communication and Computer Systems, National Technical University of Athens, Zografou, Greece","institution_ids":["https://openalex.org/I174458059","https://openalex.org/I4210144519"]},{"raw_affiliation_string":"Institute of Communication and Computer Systems, School of Electrical and Computer Engineering, National Technical University of Athens, Athens, Greece","institution_ids":["https://openalex.org/I4210144519","https://openalex.org/I174458059"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5039684370","display_name":"Alexandros Psychas","orcid":"https://orcid.org/0000-0003-0035-2885"},"institutions":[{"id":"https://openalex.org/I174458059","display_name":"National Technical University of Athens","ror":"https://ror.org/03cx6bg69","country_code":"GR","type":"education","lineage":["https://openalex.org/I174458059"]},{"id":"https://openalex.org/I4210144519","display_name":"Institute of Communication and Computer Systems","ror":"https://ror.org/0483fn738","country_code":"GR","type":"nonprofit","lineage":["https://openalex.org/I4210144519"]}],"countries":["GR"],"is_corresponding":false,"raw_author_name":"Alexandros Psychas","raw_affiliation_strings":["School of Electrical and Computer Engineering, Institute of Communication and Computer Systems, National Technical University of Athens, Zografou, Greece","Institute of Communication and Computer Systems, School of Electrical and Computer Engineering, National Technical University of Athens, Athens, Greece"],"raw_orcid":"https://orcid.org/0000-0003-0035-2885","affiliations":[{"raw_affiliation_string":"School of Electrical and Computer Engineering, Institute of Communication and Computer Systems, National Technical University of Athens, Zografou, Greece","institution_ids":["https://openalex.org/I174458059","https://openalex.org/I4210144519"]},{"raw_affiliation_string":"Institute of Communication and Computer Systems, School of Electrical and Computer Engineering, National Technical University of Athens, Athens, Greece","institution_ids":["https://openalex.org/I4210144519","https://openalex.org/I174458059"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5034266092","display_name":"Eleni Veroni","orcid":"https://orcid.org/0000-0002-0946-4501"},"institutions":[{"id":"https://openalex.org/I4210134421","display_name":"INTRASOFT International (Luxembourg)","ror":"https://ror.org/02zn9x324","country_code":"LU","type":"company","lineage":["https://openalex.org/I4210134421","https://openalex.org/I86100027"]}],"countries":["LU"],"is_corresponding":false,"raw_author_name":"Eleni Veroni","raw_affiliation_strings":["Research and Innovation Development Department, Netcompany-Intrasoft S.A., Luxembourg, Luxembourg","Research & Innovation Development Department, Netcompany-Intrasoft S.A. Luxembourg, Luxembourg"],"raw_orcid":"https://orcid.org/0000-0002-0946-4501","affiliations":[{"raw_affiliation_string":"Research and Innovation Development Department, Netcompany-Intrasoft S.A., Luxembourg, Luxembourg","institution_ids":["https://openalex.org/I4210134421"]},{"raw_affiliation_string":"Research & Innovation Development Department, Netcompany-Intrasoft S.A. Luxembourg, Luxembourg","institution_ids":["https://openalex.org/I4210134421"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5089215627","display_name":"Theodora Varvarigou","orcid":null},"institutions":[{"id":"https://openalex.org/I174458059","display_name":"National Technical University of Athens","ror":"https://ror.org/03cx6bg69","country_code":"GR","type":"education","lineage":["https://openalex.org/I174458059"]},{"id":"https://openalex.org/I4210144519","display_name":"Institute of Communication and Computer Systems","ror":"https://ror.org/0483fn738","country_code":"GR","type":"nonprofit","lineage":["https://openalex.org/I4210144519"]}],"countries":["GR"],"is_corresponding":false,"raw_author_name":"Theodora Varvarigou","raw_affiliation_strings":["School of Electrical and Computer Engineering, Institute of Communication and Computer Systems, National Technical University of Athens, Zografou, Greece","Institute of Communication and Computer Systems, School of Electrical and Computer Engineering, National Technical University of Athens, Athens, Greece"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"School of Electrical and Computer Engineering, Institute of Communication and Computer Systems, National Technical University of Athens, Zografou, Greece","institution_ids":["https://openalex.org/I174458059","https://openalex.org/I4210144519"]},{"raw_affiliation_string":"Institute of Communication and Computer Systems, School of Electrical and Computer Engineering, National Technical University of Athens, Athens, Greece","institution_ids":["https://openalex.org/I4210144519","https://openalex.org/I174458059"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5045505855"],"corresponding_institution_ids":["https://openalex.org/I174458059","https://openalex.org/I4210144519"],"apc_list":{"value":1850,"currency":"USD","value_usd":1850},"apc_paid":{"value":1850,"currency":"USD","value_usd":1850},"fwci":11.102,"has_fulltext":false,"cited_by_count":6,"citation_normalized_percentile":{"value":0.97960789,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":95,"max":99},"biblio":{"volume":"13","issue":null,"first_page":"64087","last_page":"64114"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10181","display_name":"Natural Language Processing Techniques","score":0.871999979019165,"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"}},"topics":[{"id":"https://openalex.org/T10181","display_name":"Natural Language Processing Techniques","score":0.871999979019165,"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/T13999","display_name":"Digital Rights Management and Security","score":0.7976999878883362,"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/T13523","display_name":"Mathematics, Computing, and Information Processing","score":0.7674999833106995,"subfield":{"id":"https://openalex.org/subfields/1703","display_name":"Computational Theory and Mathematics"},"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.6899241209030151},{"id":"https://openalex.org/keywords/code","display_name":"Code (set theory)","score":0.5384021401405334},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.42471396923065186},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.19565454125404358}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6899241209030151},{"id":"https://openalex.org/C2776760102","wikidata":"https://www.wikidata.org/wiki/Q5139990","display_name":"Code (set theory)","level":3,"score":0.5384021401405334},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.42471396923065186},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.19565454125404358},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1109/access.2025.3556973","is_oa":true,"landing_page_url":"https://doi.org/10.1109/access.2025.3556973","pdf_url":null,"source":{"id":"https://openalex.org/S2485537415","display_name":"IEEE Access","issn_l":"2169-3536","issn":["2169-3536"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Access","raw_type":"journal-article"},{"id":"pmh:oai:doaj.org/article:0899885e1a784e958e40e29daeaecb45","is_oa":true,"landing_page_url":"https://doaj.org/article/0899885e1a784e958e40e29daeaecb45","pdf_url":null,"source":{"id":"https://openalex.org/S4306401280","display_name":"DOAJ (DOAJ: Directory of Open Access Journals)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by-sa","license_id":"https://openalex.org/licenses/cc-by-sa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"IEEE Access, Vol 13, Pp 64087-64114 (2025)","raw_type":"article"}],"best_oa_location":{"id":"doi:10.1109/access.2025.3556973","is_oa":true,"landing_page_url":"https://doi.org/10.1109/access.2025.3556973","pdf_url":null,"source":{"id":"https://openalex.org/S2485537415","display_name":"IEEE Access","issn_l":"2169-3536","issn":["2169-3536"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Access","raw_type":"journal-article"},"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G3226553377","display_name":null,"funder_award_id":"101073920","funder_id":"https://openalex.org/F4320338444","funder_display_name":"HORIZON EUROPE Digital, Industry and Space"}],"funders":[{"id":"https://openalex.org/F4320338444","display_name":"HORIZON EUROPE Digital, Industry and Space","ror":null}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":53,"referenced_works":["https://openalex.org/W1963658069","https://openalex.org/W2242083635","https://openalex.org/W2788572835","https://openalex.org/W2793546227","https://openalex.org/W2795807997","https://openalex.org/W2906152891","https://openalex.org/W2948646149","https://openalex.org/W3034723486","https://openalex.org/W4254482458","https://openalex.org/W4304691967","https://openalex.org/W4321013654","https://openalex.org/W4323655724","https://openalex.org/W4367185264","https://openalex.org/W4379231174","https://openalex.org/W4383498485","https://openalex.org/W4385477851","https://openalex.org/W4385573057","https://openalex.org/W4387645451","https://openalex.org/W4387736592","https://openalex.org/W4387824566","https://openalex.org/W4387971513","https://openalex.org/W4388654530","https://openalex.org/W4389209096","https://openalex.org/W4390638022","https://openalex.org/W4391032878","https://openalex.org/W4391341739","https://openalex.org/W4391377904","https://openalex.org/W4391558462","https://openalex.org/W4391681217","https://openalex.org/W4392293733","https://openalex.org/W4392414327","https://openalex.org/W4392826078","https://openalex.org/W4393217463","https://openalex.org/W4395093940","https://openalex.org/W4396765406","https://openalex.org/W4396832834","https://openalex.org/W4396889529","https://openalex.org/W4399368136","https://openalex.org/W4399792062","https://openalex.org/W4399926319","https://openalex.org/W4399975832","https://openalex.org/W4400582230","https://openalex.org/W4402264084","https://openalex.org/W4405410572","https://openalex.org/W4405623292","https://openalex.org/W6761551260","https://openalex.org/W6769627184","https://openalex.org/W6770813465","https://openalex.org/W6853224863","https://openalex.org/W6854475153","https://openalex.org/W6854838534","https://openalex.org/W6861190020","https://openalex.org/W6874106332"],"related_works":["https://openalex.org/W4391375266","https://openalex.org/W2899084033","https://openalex.org/W2748952813","https://openalex.org/W2390279801","https://openalex.org/W4391913857","https://openalex.org/W2358668433","https://openalex.org/W4396701345","https://openalex.org/W2376932109","https://openalex.org/W2001405890","https://openalex.org/W4396696052"],"abstract_inverted_index":{"Large":[0],"Language":[1],"Models":[2],"(LLMs)":[3],"have":[4],"recently":[5],"attracted":[6],"considerable":[7],"attention":[8],"from":[9],"the":[10,45,54,73,82,103,146,167],"scientific":[11],"community,":[12],"due":[13,80],"to":[14,20,81,94,129,158],"their":[15],"advanced":[16],"capabilities":[17],"and":[18,28,50,105,143,156,180],"potential":[19,168],"serve":[21],"as":[22],"vital":[23],"tools":[24],"across":[25],"various":[26],"industries":[27],"academic":[29],"fields.":[30],"An":[31],"important":[32],"implementation":[33],"domain":[34],"for":[35,75,115,169],"LLMs":[36,57,174],"is":[37,92,133,151],"Data":[38,48,59],"Science,":[39],"in":[40,58,69,88,112,138,175],"which":[41],"they":[42],"could":[43,63],"enhance":[44],"efficiency":[46,155],"of":[47,56,85,107,122,163,172],"Analysis":[49],"Profiling":[51],"tasks.":[52],"With":[53],"utilization":[55],"Analytics":[60],"tools,":[61],"end-users":[62],"directly":[64],"issue":[65],"data":[66,87,117,177],"analysis":[67,178],"queries":[68,162],"natural":[70,123,160],"language,":[71],"bypassing":[72],"need":[74],"specialized":[76],"user":[77],"interfaces.":[78],"However,":[79],"sensitive":[83],"nature":[84],"certain":[86],"some":[89],"organizations,":[90],"it":[91],"unwise":[93],"consider":[95],"using":[96],"established,":[97],"cloud-based":[98],"LLMs.":[99],"This":[100],"article":[101],"explores":[102],"feasibility":[104],"effectiveness":[106],"a":[108,120,130],"standalone,":[109],"offline":[110,173],"LLM":[111,132],"generating":[113,139],"code":[114,142],"performing":[116],"analytics,":[118],"given":[119],"set":[121],"language":[124,161],"queries.":[125],"A":[126],"methodology":[127],"tailored":[128],"code-specific":[131],"presented,":[134],"evaluating":[135],"its":[136,154],"performance":[137],"Python":[140],"Spark":[141],"successfully":[144],"producing":[145],"desired":[147],"result.":[148],"The":[149],"model":[150],"assessed":[152],"on":[153],"ability":[157],"handle":[159],"varying":[164],"complexity,":[165],"exploring":[166],"wider":[170],"adoption":[171],"future":[176],"frameworks":[179],"software":[181],"solutions.":[182]},"counts_by_year":[{"year":2026,"cited_by_count":4},{"year":2025,"cited_by_count":2}],"updated_date":"2026-05-29T09:21:14.243279","created_date":"2025-10-10T00:00:00"}