Transform-Data-by-Example (TDE): Extensible Data Transformation in Excel
Transform-Data-by-Example (TDE): Extensible Data Transformation in Excel
复制标题
示例数据转换 (TDE)：Excel 中的可扩展数据转换
DOI：
--
复制
发表时间：
2018
期刊：
影响因子：
--
通讯作者：
Yudian Zheng
中科院分区：
文献类型：
--
作者：
Yeye He;Kris Ganjam;Kukjin Lee;Yue Wang;Vivek R. Narasayya;S. Chaudhuri;Xu Chu;Yudian Zheng
当今的业务分析师和数据科学家越来越需要清洁，标准化和改变各种数据集，例如名称，地址，日期时间，电话号码等，然后才能执行分析。这些临时转换问题通常通过一次性脚本解决，这既困难又耗时。我们的观察结果是，这些特定领域的转换问题长期以来已经由具有代码库的开发人员解决，这些问题通常在Github之类的地方共享。因此，我们开发了一个可扩展的数据转换系统，称为“ transform-data-example”（TDE），该系统可以利用源代码，DLL，Web服务和映射表中的丰富转换逻辑，因此最终用户只需要提供一些（通常3）输入/输出示例，TDE可以使用来自这些来源的相关转换逻辑合成所需的程序。 TDE的Beta版本在Office Store for Excel上发布。
Business analysts and data scientists today increasingly need to clean, standardize and transform diverse data sets, such as name, address, date time, phone number, etc., before they can perform analysis. These ad-hoc transformation problems are typically solved by one-off scripts, which is both difficult and time-consuming. Our observation is that these domain-specific transformation problems have long been solved by developers with code libraries, which are often shared in places like GitHub. We thus develop an extensible data transformation system called Transform-Data-by-Example (TDE) that can leverage rich transformation logic in source code, DLLs, web services and mapping tables, so that end-users only need to provide a few (typically 3) input/output examples, and TDE can synthesize desired programs using relevant transformation logic from these sources. The beta version of TDE was released in Office Store for Excel.