{"id":138489,"date":"2026-02-20T08:03:25","date_gmt":"2026-02-20T02:33:25","guid":{"rendered":"https:\/\/www.vskills.in\/certification\/tutorial\/?page_id=138489"},"modified":"2026-02-20T09:19:04","modified_gmt":"2026-02-20T03:49:04","slug":"data-cleaning-2","status":"publish","type":"page","link":"https:\/\/www.vskills.in\/certification\/tutorial\/data-cleaning-2\/","title":{"rendered":"Data Cleaning"},"content":{"rendered":"\n<p>Data cleaning is the process of preparing raw data so it becomes accurate, consistent, and ready for analysis. In real projects, datasets often contain missing values, duplicates, inconsistent labels, wrong data types, and invalid or extreme values. If these issues are not fixed early, your charts and summaries can give incorrect results.<\/p>\n\n\n\n<p>A typical data cleaning workflow starts with checking the dataset structure. You review column names, remove unnecessary columns, and standardise naming so it is easy to work with. Next, you handle missing values based on the meaning of the data. Sometimes you remove rows with missing critical fields, and sometimes you fill missing values using sensible rules (for example, median for numeric columns or a placeholder category for text fields).<\/p>\n\n\n\n<p>Duplicates are another common problem. You identify duplicate rows and decide whether to drop them completely or keep the most relevant record (for example, the latest entry based on a timestamp). Data type correction is also essential. Many datasets store numbers as text or dates as strings, so you convert them into the correct formats to ensure calculations and filtering work properly.<\/p>\n\n\n\n<p>Text cleaning is important for category columns. You may remove extra spaces, standardise case, and fix spelling variations so categories do not get split into multiple versions of the same value. Finally, you validate the cleaned dataset by re-checking missing values, duplicates, and summary statistics, and then save a clean version for analysis.<\/p>\n\n\n\n<p>Data cleaning is not a one-time step. It is an ongoing habit that makes your analysis reliable and your results trustworthy.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.vskills.in\/certification\/data-analysis-with-python-certification-course\" target=\"_blank\" rel=\" noreferrer noopener\"><img loading=\"lazy\" decoding=\"async\" width=\"960\" height=\"150\" src=\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2026\/02\/Vskills-banner-anandita-2.png\" alt=\"\" class=\"wp-image-138496\" srcset=\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2026\/02\/Vskills-banner-anandita-2.png 960w, https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2026\/02\/Vskills-banner-anandita-2-300x47.png 300w\" sizes=\"auto, (max-width: 960px) 100vw, 960px\" \/><\/a><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Data cleaning is the process of preparing raw data so it becomes accurate, consistent, and ready for analysis. In real projects, datasets often contain missing values, duplicates, inconsistent labels, wrong data types, and invalid or extreme values. If these issues are not fixed early, your charts and summaries can give incorrect results. A typical data&#8230;<\/p>\n","protected":false},"author":21,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-138489","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Data Cleaning - Tutorial<\/title>\n<meta name=\"description\" content=\"Data cleaning is the process of preparing raw data so it becomes accurate, consistent, and ready for analysis.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.vskills.in\/certification\/tutorial\/data-cleaning-2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Data Cleaning - Tutorial\" \/>\n<meta property=\"og:description\" content=\"Data cleaning is the process of preparing raw data so it becomes accurate, consistent, and ready for analysis.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.vskills.in\/certification\/tutorial\/data-cleaning-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutorial\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/vskills.in\/\" \/>\n<meta property=\"article:modified_time\" content=\"2026-02-20T03:49:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2026\/02\/Vskills-banner-anandita-2.png\" \/>\n\t<meta property=\"og:image:width\" content=\"960\" \/>\n\t<meta property=\"og:image:height\" content=\"150\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/data-cleaning-2\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/data-cleaning-2\/\",\"name\":\"Data Cleaning - Tutorial\",\"isPartOf\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/data-cleaning-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/data-cleaning-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2026\/02\/Vskills-banner-anandita-2.png\",\"datePublished\":\"2026-02-20T02:33:25+00:00\",\"dateModified\":\"2026-02-20T03:49:04+00:00\",\"description\":\"Data cleaning is the process of preparing raw data so it becomes accurate, consistent, and ready for analysis.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/data-cleaning-2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.vskills.in\/certification\/tutorial\/data-cleaning-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/data-cleaning-2\/#primaryimage\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2026\/02\/Vskills-banner-anandita-2.png\",\"contentUrl\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2026\/02\/Vskills-banner-anandita-2.png\",\"width\":960,\"height\":150},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/data-cleaning-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Data Cleaning\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\",\"name\":\"Tutorial\",\"description\":\"Vskills - A initiative in elearning and certification\",\"publisher\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.vskills.in\/certification\/tutorial\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#organization\",\"name\":\"Vskills\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg\",\"contentUrl\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg\",\"width\":73,\"height\":55,\"caption\":\"Vskills\"},\"image\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/vskills.in\/\",\"https:\/\/x.com\/vskills_in\",\"https:\/\/www.linkedin.com\/company-beta\/1371554\/\",\"https:\/\/www.youtube.com\/channel\/UCMWnscxPwRF_PqXo9B7q_Tw\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Data Cleaning - Tutorial","description":"Data cleaning is the process of preparing raw data so it becomes accurate, consistent, and ready for analysis.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.vskills.in\/certification\/tutorial\/data-cleaning-2\/","og_locale":"en_US","og_type":"article","og_title":"Data Cleaning - Tutorial","og_description":"Data cleaning is the process of preparing raw data so it becomes accurate, consistent, and ready for analysis.","og_url":"https:\/\/www.vskills.in\/certification\/tutorial\/data-cleaning-2\/","og_site_name":"Tutorial","article_publisher":"https:\/\/www.facebook.com\/vskills.in\/","article_modified_time":"2026-02-20T03:49:04+00:00","og_image":[{"width":960,"height":150,"url":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2026\/02\/Vskills-banner-anandita-2.png","type":"image\/png"}],"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/data-cleaning-2\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/data-cleaning-2\/","name":"Data Cleaning - Tutorial","isPartOf":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/data-cleaning-2\/#primaryimage"},"image":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/data-cleaning-2\/#primaryimage"},"thumbnailUrl":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2026\/02\/Vskills-banner-anandita-2.png","datePublished":"2026-02-20T02:33:25+00:00","dateModified":"2026-02-20T03:49:04+00:00","description":"Data cleaning is the process of preparing raw data so it becomes accurate, consistent, and ready for analysis.","breadcrumb":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/data-cleaning-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.vskills.in\/certification\/tutorial\/data-cleaning-2\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/data-cleaning-2\/#primaryimage","url":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2026\/02\/Vskills-banner-anandita-2.png","contentUrl":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2026\/02\/Vskills-banner-anandita-2.png","width":960,"height":150},{"@type":"BreadcrumbList","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/data-cleaning-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.vskills.in\/certification\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Data Cleaning"}]},{"@type":"WebSite","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website","url":"https:\/\/www.vskills.in\/certification\/tutorial\/","name":"Tutorial","description":"Vskills - A initiative in elearning and certification","publisher":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.vskills.in\/certification\/tutorial\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#organization","name":"Vskills","url":"https:\/\/www.vskills.in\/certification\/tutorial\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg","contentUrl":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg","width":73,"height":55,"caption":"Vskills"},"image":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/vskills.in\/","https:\/\/x.com\/vskills_in","https:\/\/www.linkedin.com\/company-beta\/1371554\/","https:\/\/www.youtube.com\/channel\/UCMWnscxPwRF_PqXo9B7q_Tw"]}]}},"_links":{"self":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/138489","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/users\/21"}],"replies":[{"embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/comments?post=138489"}],"version-history":[{"count":2,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/138489\/revisions"}],"predecessor-version":[{"id":138580,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/138489\/revisions\/138580"}],"wp:attachment":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/media?parent=138489"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/categories?post=138489"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/tags?post=138489"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}