arXivDaily arXiv每日学术速递 周一至周五更新
arXiv 2407.21040cs.AIcs.CLcs.DBcs.SE
收藏

借助自然语言与SageCopilot迈向自动化数据科学:实践与经验教训

Towards Automated Data Sciences with Natural Language and SageCopilot: Practices and Lessons Learned

Baidu Inc.(百度公司);Beihang University(北京航空航天大学);Beijing University of Posts and Telecommunications(北京邮电大学)

Yuan Liao, Jiang Bian, Yuhui Yun, Shuo Wang, Yubo Zhang, Jiaming Chu, Tao Wang, Kewei Li, Yuchen Li, Xuhong Li, Shilei Ji, Haoyi Xiong

AI总结:

本文提出工业级系统SageCopilot,通过结合LLM、AutoAgents和LUI及两阶段设计,自动化数据查询、分析、可视化与报告全流程,并在真实数据集上验证了其优越的端到端性能。

摘要:

尽管NL2SQL领域在将自然语言指令翻译为用于数据查询和处理的可执行SQL脚本方面已取得显著进展,但在更广泛的数据科学流水线中实现完全自动化——涵盖数据查询、分析、可视化和报告——仍然是一项复杂挑战。本研究介绍了SageCopilot,这是一个先进的工业级系统,通过集成Large Language Models(LLMs)、Autonomous Agents(AutoAgents)和Language User Interfaces(LUIs)来自动化数据科学流水线。具体而言,SageCopilot采用两阶段设计:在线组件通过In-Context Learning(ICL)将用户输入细化为可执行脚本,并运行脚本以进行结果报告与可视化;离线组件则准备在线阶段ICL所需的演示示例。一系列主流策略,如Chain-of-Thought和prompt-tuning,已被用于增强SageCopilot以提升性能。通过在真实世界数据集上进行严格测试并与基于提示的解决方案进行对比分析,SageCopilot已被实证验证能够在脚本生成或执行以及提供带可视化结果方面取得优越的端到端性能。我们深入的消融研究揭示了SageCopilot所采用的各种组件和策略对数据科学端到端正确性的各自贡献。

英文摘要:

While the field of NL2SQL has made significant advancements in translating natural language instructions into executable SQL scripts for data querying and processing, achieving full automation within the broader data science pipeline - encompassing data querying, analysis, visualization, and reporting - remains a complex challenge. This study introduces SageCopilot, an advanced, industry-grade system system that automates the data science pipeline by integrating Large Language Models (LLMs), Autonomous Agents (AutoAgents), and Language User Interfaces (LUIs). Specifically, SageCopilot incorporates a two-phase design: an online component refining users' inputs into executable scripts through In-Context Learning (ICL) and running the scripts for results reporting & visualization, and an offline preparing demonstrations requested by ICL in the online phase. A list of trending strategies such as Chain-of-Thought and prompt-tuning have been used to augment SageCopilot for enhanced performance. Through rigorous testing and comparative analysis against prompt-based solutions, SageCopilot has been empirically validated to achieve superior end-to-end performance in generating or executing scripts and offering results with visualization, backed by real-world datasets. Our in-depth ablation studies highlight the individual contributions of various components and strategies used by SageCopilot to the end-to-end correctness for data sciences.

机构、总结、中文摘要均由AI分析而来,可能存在错误,请以论文正文为准。

↑