{"id":33109,"date":"2025-03-20T08:27:44","date_gmt":"2025-03-20T07:27:44","guid":{"rendered":"https:\/\/www.graviton.at\/letterswaplibrary\/how-to-handle-missing-values-in-a-dataset\/"},"modified":"2025-03-20T08:27:44","modified_gmt":"2025-03-20T07:27:44","slug":"how-to-handle-missing-values-in-a-dataset","status":"publish","type":"post","link":"https:\/\/www.graviton.at\/letterswaplibrary\/how-to-handle-missing-values-in-a-dataset\/","title":{"rendered":"How To Handle Missing Values In A Dataset?"},"content":{"rendered":"<p><!-- SC_OFF --><\/p>\n<div class=\"md\">\n<p>I am working on a diabetes prediction model for my project and I need help on how should I handle missing values in the smoking history column in my structured tabular dataset. <\/p>\n<p>My dataset has 100,000 rows, with around 35% of rows having &#8220;No Info&#8221; for smoking history. Since smoking history has a significant impact on diabetes, this column cannot be ignored. <\/p>\n<p>Other entries in this column are: &#8220;Never&#8221;, &#8220;Current&#8221;, &#8220;Not current&#8221; and &#8220;Former&#8221;<\/p>\n<p>Key concerns:<\/p>\n<p>Encoding: If I am encoding this column, then how should &#8220;No Info&#8221; be treated in this case? One hot encoding will lead to unneccessary high dimensionality whereas there is no clear order that I can choose between the values if I go with ordinal encoding.<\/p>\n<p>Data Loss: Would dropping these rows (35%) lead to bias, or is it a valid approach?<\/p>\n<p>I would appreciate your personal insights on the best approach for this since I have already searched this thing enough on the internet.<\/p>\n<\/div>\n<p><!-- SC_ON -->   submitted by   <a href=\"https:\/\/www.reddit.com\/user\/shaitaanbaluck\"> \/u\/shaitaanbaluck <\/a> <br \/> <span><a href=\"https:\/\/www.reddit.com\/r\/datasets\/comments\/1jfj6sm\/how_to_handle_missing_values_in_a_dataset\/\">[link]<\/a><\/span>   <span><a href=\"https:\/\/www.reddit.com\/r\/datasets\/comments\/1jfj6sm\/how_to_handle_missing_values_in_a_dataset\/\">[comments]<\/a><\/span><\/p><div class='watch-action'><div class='watch-position align-right'><div class='action-like'><a class='lbg-style1 like-33109 jlk' href='javascript:void(0)' data-task='like' data-post_id='33109' data-nonce='614a020375' rel='nofollow'><img class='wti-pixel' src='https:\/\/www.graviton.at\/letterswaplibrary\/wp-content\/plugins\/wti-like-post\/images\/pixel.gif' title='Like' \/><span class='lc-33109 lc'>0<\/span><\/a><\/div><\/div> <div class='status-33109 status align-right'><\/div><\/div><div class='wti-clear'><\/div>","protected":false},"excerpt":{"rendered":"<p>I am working on a diabetes prediction model for my project and I need help on how&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[85],"tags":[],"class_list":["post-33109","post","type-post","status-publish","format-standard","hentry","category-datatards","wpcat-85-id"],"_links":{"self":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts\/33109","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/comments?post=33109"}],"version-history":[{"count":0,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts\/33109\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/media?parent=33109"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/categories?post=33109"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/tags?post=33109"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}