{"id":55210,"date":"2026-04-03T11:50:07","date_gmt":"2026-04-03T11:50:07","guid":{"rendered":"https:\/\/certifeka-edu.com\/programs\/research-for-strategic-development-module-2\/lessons\/lesson-1-what-is-data-cleaning-3-2\/"},"modified":"2026-04-03T11:50:07","modified_gmt":"2026-04-03T11:50:07","slug":"lesson-1-what-is-data-cleaning-3-2","status":"publish","type":"lesson","link":"https:\/\/certifeka-edu.com\/ar\/programs\/research-for-managers-module-ucam-university\/lessons\/lesson-1-what-is-data-cleaning-3-2\/","title":{"rendered":"Lesson 1: What is data cleaning?"},"content":{"rendered":"

\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/p>\n

Lesson 1: Introduction to Data Analysis<\/h2>\n

What is data cleaning?
\n<\/h3>\n

Data cleaning, also known as data cleansing, is the process of identifying and correcting errors, inconsistencies, and inaccuracies in datasets.<\/h5>\n
It is an essential step in data analysis and data processing, as raw data often contains errors and inconsistencies that can lead to incorrect or unreliable results if left unchecked.<\/h5>\n
The process of data cleaning typically involves several steps, including removing duplicates, correcting misspellings and typos, handling missing or null values, standardizing data formats, and identifying and dealing with outliers or anomalies. Data cleaning may also involve verifying that data conforms to a set of predefined rules or constraints, such as data integrity constraints or business rules.<\/h5>\n
The goal of data cleaning is to ensure that data is accurate, consistent, and reliable, so that it can be used effectively in analysis and decision-making. Data cleaning is often a time-consuming and labor-intensive process, but it is an important step in ensuring the quality and reliability of data.<\/h5>\n

What is dirty data?<\/h3>\n

Dirty data is essentially any data that needs to be manipulated or worked on in some way before it can be analysed.<\/h5>\n
Some types of dirty data include:<\/h5>\n
\n\n\t\t\t\t\t Incomplete data
\n\t\t\t<\/path><\/svg>
\n\t\t\t<\/path><\/svg>
\n\t\t\t\t\t\t<\/summary>\n
For example, a spreadsheet with missing values that would be relevant for your analysis.<\/h5>\n
If you’re looking at the relationship between customer age and a number of monthly purchases, you’ll need data for both of these variables.<\/h5>\n
If some customer ages are missing, you’re dealing with incomplete data.<\/h5>\n<\/details>\n
\n\n\t\t\t\t\t Duplicate data
\n\t\t\t<\/path><\/svg>
\n\t\t\t<\/path><\/svg>
\n\t\t\t\t\t\t<\/summary>\n
For example,records that appear twice (or multiple times) throughout the same dataset. This can occur if you’re combining data from multiple sources or databases.<\/h5>\n<\/details>\n
\n\n\t\t\t\t\t Inconsistent or inaccurate data
\n\t\t\t<\/path><\/svg>
\n\t\t\t<\/path><\/svg>
\n\t\t\t\t\t\t<\/summary>\n
data that is outdated or contains structural errors such as typos, inconsistent capitalization, and irregular naming conventions.<\/h5>\n
Say you have a dataset containing student test scores, with some categorized as “Pass” or “Fail” and others categorized as “P” or “F.”<\/h5>\n
Both labels mean the same thing, but the naming convention is inconsistent, leaving the data rather messy.<\/h5>\n<\/details>\n
\n\n\t\t\t\t\t Misaligned data
\n\t\t\t<\/path><\/svg>
\n\t\t\t<\/path><\/svg>
\n\t\t\t\t\t\t<\/summary>\n
Misaligned data refers to the situation where data is placed in the wrong fields or columns in a dataset.<\/h5>\n
For example, imagine a dataset that includes information about employees in a company, where the salary data is placed in the field intended for employee names.<\/h5>\n
This type of error can be caused by various reasons, such as manual data entry errors, technical issues in data import or export, or formatting problems.<\/h5>\n

\u00a0
\n\t\t\t\t\t<\/details>\n

For example, a spreadsheet with missing values that would be relevant for your analysis.<\/h5>\n
If you’re looking at the relationship between customer age and a number of monthly purchases, you’ll need data for both of these variables.<\/h5>\n
If some customer ages are missing, you’re dealing with incomplete data.<\/h5>\n
For example,records that appear twice (or multiple times) throughout the same dataset. This can occur if you’re combining data from multiple sources or databases.<\/h5>\n
data that is outdated or contains structural errors such as typos, inconsistent capitalization, and irregular naming conventions.<\/h5>\n
Say you have a dataset containing student test scores, with some categorized as “Pass” or “Fail” and others categorized as “P” or “F.”<\/h5>\n
Both labels mean the same thing, but the naming convention is inconsistent, leaving the data rather messy.<\/h5>\n
Misaligned data refers to the situation where data is placed in the wrong fields or columns in a dataset.<\/h5>\n
For example, imagine a dataset that includes information about employees in a company, where the salary data is placed in the field intended for employee names.<\/h5>\n
This type of error can be caused by various reasons, such as manual data entry errors, technical issues in data import or export, or formatting problems.<\/h5>\n

\u00a0\t\t<\/p>\n

What are some key steps in the data-cleaning process?
\n<\/h3>\n

We’ve established how important the data-cleaning stage is.<\/h5>\n
Now let’s introduce some data-cleaning techniques! To clean your data, you might do some or all of the following:<\/h5>\n
\n\n\t\t\t\t\t Delete Unnecessary Columns
\n\t\t\t<\/path><\/svg>
\n\t\t\t<\/path><\/svg>
\n\t\t\t\t\t\t<\/summary>\n
Chances are, your dataset will contain some values that aren’t relevant to your analysis<\/h5>\n
For example, in an analysis of students’ test scores compared to hours spent studying, things like student ID number and date of birth aren’t relevant.<\/h5>\n
You could simply delete the columns containing this data.<\/h5>\n

\u00a0
\n\t\t\t\t\t<\/details>\n

\n\n\t\t\t\t\t Identify and remove duplicates.
\n\t\t\t<\/path><\/svg>
\n\t\t\t<\/path><\/svg>
\n\t\t\t\t\t\t<\/summary>\n
\u00a0Duplicate data tends to occur during the data collection phase, so it’s important to filter them out.<\/h5>\n<\/details>\n
\n\n\t\t\t\t\t Deal with missing data.
\n\t\t\t<\/path><\/svg>
\n\t\t\t<\/path><\/svg>
\n\t\t\t\t\t\t<\/summary>\n
In the case of missing data, you can either delete the entire entry associated with it (i.e. delete the whole row which contains the empty cell), impute the missing value based on other data, or flag all missing data as such by entering “0” or “missing” in the respective cell.\u00a0<\/h5>\n
Each method for handling missing data has implications for your analysis, so you’ll need to choose your approach carefully.<\/h5>\n<\/details>\n
\n\n\t\t\t\t\t Remove unwanted outliers.
\n\t\t\t<\/path><\/svg>
\n\t\t\t<\/path><\/svg>
\n\t\t\t\t\t\t<\/summary>\n
Outliers are values that differ significantly from other values in your data.<\/h5>\n
For example, if you see that most student test scores fall between 50 and 80, but that one student has scored a 2, this might be considered an outlier.\u00a0<\/h5>\n
Outliers may be the result of an error, but that’s not always the case, so approach with caution when deciding whether or not to remove them.<\/h5>\n<\/details>\n
\n\n\t\t\t\t\t Fix inconsistencies.
\n\t\t\t<\/path><\/svg>
\n\t\t\t<\/path><\/svg>
\n\t\t\t\t\t\t<\/summary>\n
As already mentioned, inconsistencies in data include things like typos and irregular naming conventions.<\/h5>\n
You can fix these manually (for example, using the “Find and replace” function in Google Sheets or Microsoft Excel to locate one spelling or convention and replace it with another) or by creating a filter.<\/h5>\n

\u00a0
\n\t\t\t\t\t<\/details>\n

Chances are, your dataset will contain some values that aren’t relevant to your analysis<\/h5>\n
For example, in an analysis of students’ test scores compared to hours spent studying, things like student ID number and date of birth aren’t relevant.<\/h5>\n
You could simply delete the columns containing this data.<\/h5>\n

\u00a0<\/p>\n

\u00a0Duplicate data tends to occur during the data collection phase, so it’s important to filter them out.<\/h5>\n
In the case of missing data, you can either delete the entire entry associated with it (i.e. delete the whole row which contains the empty cell), impute the missing value based on other data, or flag all missing data as such by entering “0” or “missing” in the respective cell.\u00a0<\/h5>\n
Each method for handling missing data has implications for your analysis, so you’ll need to choose your approach carefully.<\/h5>\n
Outliers are values that differ significantly from other values in your data.<\/h5>\n
For example, if you see that most student test scores fall between 50 and 80, but that one student has scored a 2, this might be considered an outlier.\u00a0<\/h5>\n
Outliers may be the result of an error, but that’s not always the case, so approach with caution when deciding whether or not to remove them.<\/h5>\n
As already mentioned, inconsistencies in data include things like typos and irregular naming conventions.<\/h5>\n
You can fix these manually (for example, using the “Find and replace” function in Google Sheets or Microsoft Excel to locate one spelling or convention and replace it with another) or by creating a filter.<\/h5>\n

\u00a0<\/p>","protected":false},"comment_status":"open","ping_status":"closed","template":"","class_list":["post-55210","lesson","type-lesson","status-publish","hentry"],"yoast_head":"\nLesson 1: What is data cleaning? - Certifeka-edu<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/certifeka-edu.com\/ar\/programs\/research-for-managers-module-ucam-university\/lessons\/lesson-1-what-is-data-cleaning-3-2\/\" \/>\n<meta property=\"og:locale\" content=\"ar_AR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Lesson 1: What is data cleaning? - Certifeka-edu\" \/>\n<meta property=\"og:description\" content=\"Lesson 1: Introduction to Data Analysis What is data cleaning? Data cleaning, also known as data cleansing, is the process of identifying and correcting errors, inconsistencies, and inaccuracies in datasets. It is an essential step in data analysis and data processing, as raw data often contains errors and inconsistencies that can lead to incorrect or […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/certifeka-edu.com\/ar\/programs\/research-for-managers-module-ucam-university\/lessons\/lesson-1-what-is-data-cleaning-3-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Certifeka-edu\" \/>\n<meta property=\"og:image\" content=\"https:\/\/certifeka-edu.com\/wp-content\/uploads\/2025\/04\/logos-png-01-296x57-1.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u0648\u0642\u062a \u0627\u0644\u0642\u0631\u0627\u0621\u0629 \u0627\u0644\u0645\u064f\u0642\u062f\u0651\u0631\" \/>\n\t<meta name=\"twitter:data1\" content=\"6 \u062f\u0642\u0627\u0626\u0642\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":[\"WebPage\",\"webpage\"],\"@id\":\"https:\\\/\\\/certifeka-edu.com\\\/programs\\\/research-for-managers-module-ucam-university\\\/lessons\\\/lesson-1-what-is-data-cleaning-3-2\\\/\",\"url\":\"https:\\\/\\\/certifeka-edu.com\\\/programs\\\/research-for-managers-module-ucam-university\\\/lessons\\\/lesson-1-what-is-data-cleaning-3-2\\\/\",\"name\":\"Lesson 1: What is data cleaning? - Certifeka-edu\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/certifeka-edu.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/certifeka-edu.com\\\/programs\\\/research-for-managers-module-ucam-university\\\/lessons\\\/lesson-1-what-is-data-cleaning-3-2\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/certifeka-edu.com\\\/programs\\\/research-for-managers-module-ucam-university\\\/lessons\\\/lesson-1-what-is-data-cleaning-3-2\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/certifeka-edu.com\\\/wp-content\\\/uploads\\\/2025\\\/04\\\/logos-png-01-296x57-1.png\",\"datePublished\":\"2026-04-03T11:50:07+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/certifeka-edu.com\\\/programs\\\/research-for-managers-module-ucam-university\\\/lessons\\\/lesson-1-what-is-data-cleaning-3-2\\\/#breadcrumb\"},\"inLanguage\":\"ar\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/certifeka-edu.com\\\/programs\\\/research-for-managers-module-ucam-university\\\/lessons\\\/lesson-1-what-is-data-cleaning-3-2\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ar\",\"@id\":\"https:\\\/\\\/certifeka-edu.com\\\/programs\\\/research-for-managers-module-ucam-university\\\/lessons\\\/lesson-1-what-is-data-cleaning-3-2\\\/#primaryimage\",\"url\":\"https:\\\/\\\/certifeka-edu.com\\\/wp-content\\\/uploads\\\/2025\\\/04\\\/logos-png-01-296x57-1.png\",\"contentUrl\":\"https:\\\/\\\/certifeka-edu.com\\\/wp-content\\\/uploads\\\/2025\\\/04\\\/logos-png-01-296x57-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/certifeka-edu.com\\\/programs\\\/research-for-managers-module-ucam-university\\\/lessons\\\/lesson-1-what-is-data-cleaning-3-2\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"home\",\"item\":\"https:\\\/\\\/certifeka-edu.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Lessons\",\"item\":\"https:\\\/\\\/certifeka-edu.com\\\/lesson\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Lesson 1: What is data cleaning?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/certifeka-edu.com\\\/#website\",\"url\":\"https:\\\/\\\/certifeka-edu.com\\\/\",\"name\":\"certifeka\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/certifeka-edu.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/certifeka-edu.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ar\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/certifeka-edu.com\\\/#organization\",\"name\":\"certifeka\",\"url\":\"https:\\\/\\\/certifeka-edu.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ar\",\"@id\":\"https:\\\/\\\/certifeka-edu.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/certifeka-edu.com\\\/wp-content\\\/uploads\\\/2025\\\/03\\\/cropped-certifeka-removebg-preview.png\",\"contentUrl\":\"https:\\\/\\\/certifeka-edu.com\\\/wp-content\\\/uploads\\\/2025\\\/03\\\/cropped-certifeka-removebg-preview.png\",\"width\":366,\"height\":104,\"caption\":\"certifeka\"},\"image\":{\"@id\":\"https:\\\/\\\/certifeka-edu.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Lesson 1: What is data cleaning? - Certifeka-edu","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:\/\/certifeka-edu.com\/ar\/programs\/research-for-managers-module-ucam-university\/lessons\/lesson-1-what-is-data-cleaning-3-2\/","og_locale":"ar_AR","og_type":"article","og_title":"Lesson 1: What is data cleaning? - Certifeka-edu","og_description":"Lesson 1: Introduction to Data Analysis What is data cleaning? Data cleaning, also known as data cleansing, is the process of identifying and correcting errors, inconsistencies, and inaccuracies in datasets. It is an essential step in data analysis and data processing, as raw data often contains errors and inconsistencies that can lead to incorrect or […]","og_url":"https:\/\/certifeka-edu.com\/ar\/programs\/research-for-managers-module-ucam-university\/lessons\/lesson-1-what-is-data-cleaning-3-2\/","og_site_name":"Certifeka-edu","og_image":[{"url":"https:\/\/certifeka-edu.com\/wp-content\/uploads\/2025\/04\/logos-png-01-296x57-1.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"\u0648\u0642\u062a \u0627\u0644\u0642\u0631\u0627\u0621\u0629 \u0627\u0644\u0645\u064f\u0642\u062f\u0651\u0631":"6 \u062f\u0642\u0627\u0626\u0642"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":["WebPage","webpage"],"@id":"https:\/\/certifeka-edu.com\/programs\/research-for-managers-module-ucam-university\/lessons\/lesson-1-what-is-data-cleaning-3-2\/","url":"https:\/\/certifeka-edu.com\/programs\/research-for-managers-module-ucam-university\/lessons\/lesson-1-what-is-data-cleaning-3-2\/","name":"Lesson 1: What is data cleaning? - Certifeka-edu","isPartOf":{"@id":"https:\/\/certifeka-edu.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/certifeka-edu.com\/programs\/research-for-managers-module-ucam-university\/lessons\/lesson-1-what-is-data-cleaning-3-2\/#primaryimage"},"image":{"@id":"https:\/\/certifeka-edu.com\/programs\/research-for-managers-module-ucam-university\/lessons\/lesson-1-what-is-data-cleaning-3-2\/#primaryimage"},"thumbnailUrl":"https:\/\/certifeka-edu.com\/wp-content\/uploads\/2025\/04\/logos-png-01-296x57-1.png","datePublished":"2026-04-03T11:50:07+00:00","breadcrumb":{"@id":"https:\/\/certifeka-edu.com\/programs\/research-for-managers-module-ucam-university\/lessons\/lesson-1-what-is-data-cleaning-3-2\/#breadcrumb"},"inLanguage":"ar","potentialAction":[{"@type":"ReadAction","target":["https:\/\/certifeka-edu.com\/programs\/research-for-managers-module-ucam-university\/lessons\/lesson-1-what-is-data-cleaning-3-2\/"]}]},{"@type":"ImageObject","inLanguage":"ar","@id":"https:\/\/certifeka-edu.com\/programs\/research-for-managers-module-ucam-university\/lessons\/lesson-1-what-is-data-cleaning-3-2\/#primaryimage","url":"https:\/\/certifeka-edu.com\/wp-content\/uploads\/2025\/04\/logos-png-01-296x57-1.png","contentUrl":"https:\/\/certifeka-edu.com\/wp-content\/uploads\/2025\/04\/logos-png-01-296x57-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/certifeka-edu.com\/programs\/research-for-managers-module-ucam-university\/lessons\/lesson-1-what-is-data-cleaning-3-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"home","item":"https:\/\/certifeka-edu.com\/"},{"@type":"ListItem","position":2,"name":"Lessons","item":"https:\/\/certifeka-edu.com\/lesson\/"},{"@type":"ListItem","position":3,"name":"Lesson 1: What is data cleaning?"}]},{"@type":"WebSite","@id":"https:\/\/certifeka-edu.com\/#website","url":"https:\/\/certifeka-edu.com\/","name":"certifeka","description":"","publisher":{"@id":"https:\/\/certifeka-edu.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/certifeka-edu.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ar"},{"@type":"Organization","@id":"https:\/\/certifeka-edu.com\/#organization","name":"certifeka","url":"https:\/\/certifeka-edu.com\/","logo":{"@type":"ImageObject","inLanguage":"ar","@id":"https:\/\/certifeka-edu.com\/#\/schema\/logo\/image\/","url":"https:\/\/certifeka-edu.com\/wp-content\/uploads\/2025\/03\/cropped-certifeka-removebg-preview.png","contentUrl":"https:\/\/certifeka-edu.com\/wp-content\/uploads\/2025\/03\/cropped-certifeka-removebg-preview.png","width":366,"height":104,"caption":"certifeka"},"image":{"@id":"https:\/\/certifeka-edu.com\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/certifeka-edu.com\/ar\/wp-json\/wp\/v2\/lesson\/55210","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/certifeka-edu.com\/ar\/wp-json\/wp\/v2\/lesson"}],"about":[{"href":"https:\/\/certifeka-edu.com\/ar\/wp-json\/wp\/v2\/types\/lesson"}],"replies":[{"embeddable":true,"href":"https:\/\/certifeka-edu.com\/ar\/wp-json\/wp\/v2\/comments?post=55210"}],"version-history":[{"count":0,"href":"https:\/\/certifeka-edu.com\/ar\/wp-json\/wp\/v2\/lesson\/55210\/revisions"}],"wp:attachment":[{"href":"https:\/\/certifeka-edu.com\/ar\/wp-json\/wp\/v2\/media?parent=55210"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}