一种利用数据挖掘填补数据缺失值的方法

Niyaz Sharifyanov, V. Latypova
{"title":"一种利用数据挖掘填补数据缺失值的方法","authors":"Niyaz Sharifyanov, V. Latypova","doi":"10.1109/ITNT57377.2023.10139280","DOIUrl":null,"url":null,"abstract":"Organizations are now using information systems that interact with large amounts of data everywhere. The collected data is subjected to statistical and intellectual analysis. To improve the quality of input data, intelligent methods are actively used for data recovery, including for filling missing values in data. However, the task of improving the quality of the obtained data remains relevant. Also acute is the issue associated with resource intensity and high time costs when using existing solutions to fill in missing values in data. The article proposes a modified method of filling missing values in data, based on the k-nearest neighbors’ method, and its implementation that solves these problems. The method has been successfully tested on two data sets: on the generated data and on the data of the OpenWeatherMap service that provides weather data, on the example of the city of Ufa. The proposed method showed better results compared to existing methods: simple data recovery (based on the calculation of the mean, median, mode), k-nearest neighbors-based methods, random forest, predictive mean matching and the method of building regression models.","PeriodicalId":296438,"journal":{"name":"2023 IX International Conference on Information Technology and Nanotechnology (ITNT)","volume":"21 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2023-04-17","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":"{\"title\":\"A Method of Filling Missing Values in Data using Data Mining\",\"authors\":\"Niyaz Sharifyanov, V. Latypova\",\"doi\":\"10.1109/ITNT57377.2023.10139280\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"Organizations are now using information systems that interact with large amounts of data everywhere. The collected data is subjected to statistical and intellectual analysis. To improve the quality of input data, intelligent methods are actively used for data recovery, including for filling missing values in data. However, the task of improving the quality of the obtained data remains relevant. Also acute is the issue associated with resource intensity and high time costs when using existing solutions to fill in missing values in data. The article proposes a modified method of filling missing values in data, based on the k-nearest neighbors’ method, and its implementation that solves these problems. The method has been successfully tested on two data sets: on the generated data and on the data of the OpenWeatherMap service that provides weather data, on the example of the city of Ufa. The proposed method showed better results compared to existing methods: simple data recovery (based on the calculation of the mean, median, mode), k-nearest neighbors-based methods, random forest, predictive mean matching and the method of building regression models.\",\"PeriodicalId\":296438,\"journal\":{\"name\":\"2023 IX International Conference on Information Technology and Nanotechnology (ITNT)\",\"volume\":\"21 1\",\"pages\":\"0\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2023-04-17\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"0\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"2023 IX International Conference on Information Technology and Nanotechnology (ITNT)\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.1109/ITNT57377.2023.10139280\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"2023 IX International Conference on Information Technology and Nanotechnology (ITNT)","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1109/ITNT57377.2023.10139280","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
引用次数: 0

摘要

组织现在使用的信息系统与无处不在的大量数据进行交互。收集到的数据要进行统计和智力分析。为了提高输入数据的质量,积极采用智能方法进行数据恢复,包括填充数据中的缺失值。然而,提高所获数据质量的任务仍然具有现实意义。在使用现有解决方案填充数据中的缺失值时,与资源强度和高时间成本相关的问题也很严重。本文提出了一种基于k近邻法的数据缺失值填充改进方法及其实现,解决了这些问题。该方法已经成功地在两个数据集上进行了测试:生成的数据和提供天气数据的OpenWeatherMap服务的数据,以Ufa市为例。与简单的数据恢复方法(基于均值、中位数、众数的计算)、基于k近邻的方法、随机森林方法、预测均值匹配方法和建立回归模型的方法相比,该方法取得了更好的效果。
本文章由计算机程序翻译,如有差异,请以英文原文为准。
A Method of Filling Missing Values in Data using Data Mining
Organizations are now using information systems that interact with large amounts of data everywhere. The collected data is subjected to statistical and intellectual analysis. To improve the quality of input data, intelligent methods are actively used for data recovery, including for filling missing values in data. However, the task of improving the quality of the obtained data remains relevant. Also acute is the issue associated with resource intensity and high time costs when using existing solutions to fill in missing values in data. The article proposes a modified method of filling missing values in data, based on the k-nearest neighbors’ method, and its implementation that solves these problems. The method has been successfully tested on two data sets: on the generated data and on the data of the OpenWeatherMap service that provides weather data, on the example of the city of Ufa. The proposed method showed better results compared to existing methods: simple data recovery (based on the calculation of the mean, median, mode), k-nearest neighbors-based methods, random forest, predictive mean matching and the method of building regression models.
求助全文
通过发布文献求助,成功后即可免费获取论文全文。 去求助
来源期刊
自引率
0.00%
发文量
0
×
引用
GB/T 7714-2015
复制
MLA
复制
APA
复制
导出至
BibTeX EndNote RefMan NoteFirst NoteExpress
×
提示
您的信息不完整,为了账户安全,请先补充。
现在去补充
×
提示
您因"违规操作"
具体请查看互助需知
我知道了
×
提示
确定
请完成安全验证×
copy
已复制链接
快去分享给好友吧!
我知道了
右上角分享
点击右上角分享
0
联系我们:info@booksci.cn Book学术提供免费学术资源搜索服务,方便国内外学者检索中英文文献。致力于提供最便捷和优质的服务体验。 Copyright © 2023 布克学术 All rights reserved.
京ICP备2023020795号-1
ghs 京公网安备 11010802042870号
Book学术文献互助
Book学术文献互助群
群 号:481959085
Book学术官方微信