{"title":"二手车数据集缺失值的估算","authors":"Samveg Shah, Mayur Telrandhe, Prathmesh Waghmode, Sunil Ghane","doi":"10.1109/ASIANCON55314.2022.9908600","DOIUrl":null,"url":null,"abstract":"Missing values in a dataset has always been a problem for data analysis and modelling. Building a model over a dataset where the missing values are not handled properly will definitely degrade the accuracy and performance of model. This problem particularly impacts deterministic models. Knowing that majority of the models that are used today are deterministic makes dealing with missing values crucial before applying the machine learning model. In this paper we have discussed various approaches such as statistical method (using mean), MICE and KNN for imputing missing values and tested their accuracy in combination with two prediction algorithms linear regression and random forest regression. We have used dataset of used cars containing missing values in few columns to predict the price of car given the details of car and thus comparing the accuracy of the estimated price with different approaches.","PeriodicalId":429704,"journal":{"name":"2022 2nd Asian Conference on Innovation in Technology (ASIANCON)","volume":"122 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2022-08-26","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":"{\"title\":\"Imputing missing values for Dataset of Used Cars\",\"authors\":\"Samveg Shah, Mayur Telrandhe, Prathmesh Waghmode, Sunil Ghane\",\"doi\":\"10.1109/ASIANCON55314.2022.9908600\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"Missing values in a dataset has always been a problem for data analysis and modelling. Building a model over a dataset where the missing values are not handled properly will definitely degrade the accuracy and performance of model. This problem particularly impacts deterministic models. Knowing that majority of the models that are used today are deterministic makes dealing with missing values crucial before applying the machine learning model. In this paper we have discussed various approaches such as statistical method (using mean), MICE and KNN for imputing missing values and tested their accuracy in combination with two prediction algorithms linear regression and random forest regression. We have used dataset of used cars containing missing values in few columns to predict the price of car given the details of car and thus comparing the accuracy of the estimated price with different approaches.\",\"PeriodicalId\":429704,\"journal\":{\"name\":\"2022 2nd Asian Conference on Innovation in Technology (ASIANCON)\",\"volume\":\"122 1\",\"pages\":\"0\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2022-08-26\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"0\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"2022 2nd Asian Conference on Innovation in Technology (ASIANCON)\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.1109/ASIANCON55314.2022.9908600\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"2022 2nd Asian Conference on Innovation in Technology (ASIANCON)","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1109/ASIANCON55314.2022.9908600","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
Missing values in a dataset has always been a problem for data analysis and modelling. Building a model over a dataset where the missing values are not handled properly will definitely degrade the accuracy and performance of model. This problem particularly impacts deterministic models. Knowing that majority of the models that are used today are deterministic makes dealing with missing values crucial before applying the machine learning model. In this paper we have discussed various approaches such as statistical method (using mean), MICE and KNN for imputing missing values and tested their accuracy in combination with two prediction algorithms linear regression and random forest regression. We have used dataset of used cars containing missing values in few columns to predict the price of car given the details of car and thus comparing the accuracy of the estimated price with different approaches.