clickR:利用变化跟踪对杂乱数据进行半自动预处理,实现数据集整体清理

IF 2.4 4区 计算机科学 Q2 COMPUTER SCIENCE, SOFTWARE ENGINEERING SoftwareX Pub Date : 2024-08-26 DOI:10.1016/j.softx.2024.101865
David Hervas , David Fuente
{"title":"clickR:利用变化跟踪对杂乱数据进行半自动预处理,实现数据集整体清理","authors":"David Hervas ,&nbsp;David Fuente","doi":"10.1016/j.softx.2024.101865","DOIUrl":null,"url":null,"abstract":"<div><p>In this contribution, we present <em>clickR</em>, an <strong>R</strong> package intended for data cleaning following a semi-automatic and supervised procedure. Few packages and commercial software with cleaning capacities are available. In all cases, their functionalities just cover part of the overall data pre-processing and do not follow an integral approach to cleaning up the data. In contrast, <em>clickR</em> brings together all functions needed for correcting the main structural, variable-assignment and typographical errors found in databases and allows researchers to have a strict control on the suggested changes. This is possible because the package creates a data frame that keeps track of all the implemented data modifications. To prove its capacity for detecting and fixing errors, we clean a messy database that exhibits multiple types of errors within date, numeric and factor variables.</p></div>","PeriodicalId":21905,"journal":{"name":"SoftwareX","volume":"27 ","pages":"Article 101865"},"PeriodicalIF":2.4000,"publicationDate":"2024-08-26","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"https://www.sciencedirect.com/science/article/pii/S2352711024002358/pdfft?md5=f478aa00c2254dab4baa13c22b076de0&pid=1-s2.0-S2352711024002358-main.pdf","citationCount":"0","resultStr":"{\"title\":\"clickR: Semi-automatic pre-processing of messy data with change tracking for integral dataset cleaning\",\"authors\":\"David Hervas ,&nbsp;David Fuente\",\"doi\":\"10.1016/j.softx.2024.101865\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"<div><p>In this contribution, we present <em>clickR</em>, an <strong>R</strong> package intended for data cleaning following a semi-automatic and supervised procedure. Few packages and commercial software with cleaning capacities are available. In all cases, their functionalities just cover part of the overall data pre-processing and do not follow an integral approach to cleaning up the data. In contrast, <em>clickR</em> brings together all functions needed for correcting the main structural, variable-assignment and typographical errors found in databases and allows researchers to have a strict control on the suggested changes. This is possible because the package creates a data frame that keeps track of all the implemented data modifications. To prove its capacity for detecting and fixing errors, we clean a messy database that exhibits multiple types of errors within date, numeric and factor variables.</p></div>\",\"PeriodicalId\":21905,\"journal\":{\"name\":\"SoftwareX\",\"volume\":\"27 \",\"pages\":\"Article 101865\"},\"PeriodicalIF\":2.4000,\"publicationDate\":\"2024-08-26\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"https://www.sciencedirect.com/science/article/pii/S2352711024002358/pdfft?md5=f478aa00c2254dab4baa13c22b076de0&pid=1-s2.0-S2352711024002358-main.pdf\",\"citationCount\":\"0\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"SoftwareX\",\"FirstCategoryId\":\"94\",\"ListUrlMain\":\"https://www.sciencedirect.com/science/article/pii/S2352711024002358\",\"RegionNum\":4,\"RegionCategory\":\"计算机科学\",\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"Q2\",\"JCRName\":\"COMPUTER SCIENCE, SOFTWARE ENGINEERING\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"SoftwareX","FirstCategoryId":"94","ListUrlMain":"https://www.sciencedirect.com/science/article/pii/S2352711024002358","RegionNum":4,"RegionCategory":"计算机科学","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"Q2","JCRName":"COMPUTER SCIENCE, SOFTWARE ENGINEERING","Score":null,"Total":0}
引用次数: 0

摘要

在这篇论文中,我们介绍了 clickR,这是一个 R 软件包,用于按照半自动和监督程序进行数据清理。目前,具有数据清理功能的软件包和商业软件屈指可数。在所有情况下,它们的功能都只是涵盖了整体数据预处理的一部分,并没有采用整体方法来清理数据。相比之下,clickR 汇集了纠正数据库中主要结构、变量分配和排版错误所需的所有功能,并允许研究人员严格控制建议的更改。之所以能做到这一点,是因为该软件包创建了一个数据框架,可跟踪所有已实施的数据修改。为了证明该软件包检测和修复错误的能力,我们清理了一个凌乱的数据库,该数据库在日期、数字和因素变量方面存在多种类型的错误。
本文章由计算机程序翻译,如有差异,请以英文原文为准。
查看原文
分享 分享
微信好友 朋友圈 QQ好友 复制链接
本刊更多论文
clickR: Semi-automatic pre-processing of messy data with change tracking for integral dataset cleaning

In this contribution, we present clickR, an R package intended for data cleaning following a semi-automatic and supervised procedure. Few packages and commercial software with cleaning capacities are available. In all cases, their functionalities just cover part of the overall data pre-processing and do not follow an integral approach to cleaning up the data. In contrast, clickR brings together all functions needed for correcting the main structural, variable-assignment and typographical errors found in databases and allows researchers to have a strict control on the suggested changes. This is possible because the package creates a data frame that keeps track of all the implemented data modifications. To prove its capacity for detecting and fixing errors, we clean a messy database that exhibits multiple types of errors within date, numeric and factor variables.

求助全文
通过发布文献求助,成功后即可免费获取论文全文。 去求助
来源期刊
SoftwareX
SoftwareX COMPUTER SCIENCE, SOFTWARE ENGINEERING-
CiteScore
5.50
自引率
2.90%
发文量
184
审稿时长
9 weeks
期刊介绍: SoftwareX aims to acknowledge the impact of software on today''s research practice, and on new scientific discoveries in almost all research domains. SoftwareX also aims to stress the importance of the software developers who are, in part, responsible for this impact. To this end, SoftwareX aims to support publication of research software in such a way that: The software is given a stamp of scientific relevance, and provided with a peer-reviewed recognition of scientific impact; The software developers are given the credits they deserve; The software is citable, allowing traditional metrics of scientific excellence to apply; The academic career paths of software developers are supported rather than hindered; The software is publicly available for inspection, validation, and re-use. Above all, SoftwareX aims to inform researchers about software applications, tools and libraries with a (proven) potential to impact the process of scientific discovery in various domains. The journal is multidisciplinary and accepts submissions from within and across subject domains such as those represented within the broad thematic areas below: Mathematical and Physical Sciences; Environmental Sciences; Medical and Biological Sciences; Humanities, Arts and Social Sciences. Originating from these broad thematic areas, the journal also welcomes submissions of software that works in cross cutting thematic areas, such as citizen science, cybersecurity, digital economy, energy, global resource stewardship, health and wellbeing, etcetera. SoftwareX specifically aims to accept submissions representing domain-independent software that may impact more than one research domain.
期刊最新文献
CARLA-GymDrive: Autonomous driving episode generation for the Carla simulator in a gym environment Version [1.0]- HAT-VIS — A MATLAB-based hypergraph visualization tool The pymcdm-reidentify tool: Advanced methods for MCDA model re-identification COMBEAMS: A numerical tool for the structural verification of steel-concrete composite beams QMol-grid : A MATLAB package for quantum-mechanical simulations in atomic and molecular systems
×
引用
GB/T 7714-2015
复制
MLA
复制
APA
复制
导出至
BibTeX EndNote RefMan NoteFirst NoteExpress
×
×
提示
您的信息不完整,为了账户安全,请先补充。
现在去补充
×
提示
您因"违规操作"
具体请查看互助需知
我知道了
×
提示
现在去查看 取消
×
提示
确定
0
微信
客服QQ
Book学术公众号 扫码关注我们
反馈
×
意见反馈
请填写您的意见或建议
请填写您的手机或邮箱
已复制链接
已复制链接
快去分享给好友吧!
我知道了
×
扫码分享
扫码分享
Book学术官方微信
Book学术文献互助
Book学术文献互助群
群 号:481959085
Book学术
文献互助 智能选刊 最新文献 互助须知 联系我们:info@booksci.cn
Book学术提供免费学术资源搜索服务,方便国内外学者检索中英文文献。致力于提供最便捷和优质的服务体验。
Copyright © 2023 Book学术 All rights reserved.
ghs 京公网安备 11010802042870号 京ICP备2023020795号-1