Scribd
Upload
7 views36 pages

Data Cleaning With An ExampleA

Data Cleaning with an ExampleA

Uploaded by

noorulathar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
7 views36 pages

Data Cleaning With An ExampleA

Data Cleaning with an ExampleA

Uploaded by

noorulathar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
You are on page 1/ 36

Data Cleaning Explained with an Example

 Introduction
 Key Steps in Data Cleaning
1. Removing duplicates:
2. Fixing structural errors:
3. Handling missing data:
4. Validating accuracy:
5. Standardizing data:
6. Filtering outliers: Noorul Athar (PMP, CPHIMS, ITIL)
Data Cleaning Explained with an Example
 Introduction

Noorul Athar (PMP, CPHIMS, ITIL)


Data Cleaning Explained with an Example
 Introduction
 Key Steps in Data Cleaning

Noorul Athar (PMP, CPHIMS, ITIL)


Data Cleaning Explained with an Example
 Introduction
 Key Steps in Data Cleaning
1. Removing duplicates:

Noorul Athar (PMP, CPHIMS, ITIL)


Data Cleaning Explained with an Example
 Introduction
 Key Steps in Data Cleaning
1. Removing duplicates:
2. Fixing structural errors:

Noorul Athar (PMP, CPHIMS, ITIL)


Data Cleaning Explained with an Example
 Introduction
 Key Steps in Data Cleaning
1. Removing duplicates:
2. Fixing structural errors:
3. Handling missing data:

Noorul Athar (PMP, CPHIMS, ITIL)


Data Cleaning Explained with an Example
 Introduction
 Key Steps in Data Cleaning
1. Removing duplicates:
2. Fixing structural errors:
3. Handling missing data:
4. Validating accuracy:

Noorul Athar (PMP, CPHIMS, ITIL)


Data Cleaning Explained with an Example
 Introduction
 Key Steps in Data Cleaning
1. Removing duplicates:
2. Fixing structural errors:
3. Handling missing data:
4. Validating accuracy:
5. Standardizing data:
Noorul Athar (PMP, CPHIMS, ITIL)
Data Cleaning Explained with an Example
 Introduction
 Key Steps in Data Cleaning
1. Removing duplicates:
2. Fixing structural errors:
3. Handling missing data:
4. Validating accuracy:
5. Standardizing data:
6. Filtering outliers: Noorul Athar (PMP, CPHIMS, ITIL)
Data Cleaning Explained with an Example
 Example of Data Cleaning

Noorul Athar (PMP, CPHIMS, ITIL)


Data Cleaning Explained with an Example
 Example of Data Cleaning

Patient ID Name Age Diagnosis

Noorul Athar (PMP, CPHIMS, ITIL)


Data Cleaning Explained with an Example
 Example of Data Cleaning
 Removing duplicates:

Noorul Athar (PMP, CPHIMS, ITIL)


Data Cleaning Explained with an Example
 Example of Data Cleaning
 Removing duplicates:

Patient ID Name Age Diagnosis


101 Alice 25 Flu
102 Bob 30 Cold
103 Charlie 35 Allergy
101 Alice 25 Flu
104 Eve 28 Cold
102 Bob 30 Cold

Noorul Athar (PMP, CPHIMS, ITIL)


Data Cleaning Explained with an Example
 Example of Data Cleaning
 Removing duplicates:

Patient ID Name Age Diagnosis


101 Alice 25 Flu
102 Bob 30 Cold
103 Charlie 35 Allergy
101 Alice 25 Flu
104 Eve 28 Cold
102 Bob 30 Cold

Noorul Athar (PMP, CPHIMS, ITIL)


Data Cleaning Explained with an Example
 Example of Data Cleaning
 Fixing structural errors:

Noorul Athar (PMP, CPHIMS, ITIL)


Data Cleaning Explained with an Example
 Example of Data Cleaning
 Fixing structural errors:

Patient ID Name Age Gender


101 Alice 25 Male
102 Bob 30 male
103 Charlie 35 M
104 Diana 28 Female
105 Eve 22 female

Noorul Athar (PMP, CPHIMS, ITIL)


Data Cleaning Explained with an Example
 Example of Data Cleaning
 Fixing structural errors:

Patient ID Name Age Gender


101 Alice 25 Male
102 Bob 30 male
103 Charlie 35 M
104 Diana 28 Female
105 Eve 22 female

Noorul Athar (PMP, CPHIMS, ITIL)


Data Cleaning Explained with an Example
 Example of Data Cleaning
 Handling missing data:

Noorul Athar (PMP, CPHIMS, ITIL)


Data Cleaning Explained with an Example
 Example of Data Cleaning
 Handling missing data:

Patient ID Name Age Gender


101 Alice 25 Female
102 Bob 30 Male
103 Charlie NaN Male
104 Diana 28 Female
105 Eve NaN Female

Noorul Athar (PMP, CPHIMS, ITIL)


Data Cleaning Explained with an Example
 Example of Data Cleaning
 Handling missing data:

Patient ID Name Age Gender


101 Alice 25 Female
102 Bob 30 Male
103 Charlie NaN Male
104 Diana 28 Female
105 Eve NaN Female

Noorul Athar (PMP, CPHIMS, ITIL)


Data Cleaning Explained with an Example
 Example of Data Cleaning
 Validating accuracy

Noorul Athar (PMP, CPHIMS, ITIL)


Data Cleaning Explained with an Example
 Example of Data Cleaning
 Validating accuracy

Patient ID Name Age Gender


101 Alice 25 Female
102 Bob 200 Male
103 Charlie 35 Male
104 Diana 0 Female
105 Eve 122 Female

Noorul Athar (PMP, CPHIMS, ITIL)


Data Cleaning Explained with an Example
 Example of Data Cleaning
 Validating accuracy

Patient ID Name Age Gender


101 Alice 25 Female
102 Bob 200 Male
103 Charlie 35 Male
104 Diana 0 Female
105 Eve 122 Female

Noorul Athar (PMP, CPHIMS, ITIL)


Data Cleaning Explained with an Example
 Example of Data Cleaning
 Standardizing data:

Noorul Athar (PMP, CPHIMS, ITIL)


Data Cleaning Explained with an Example
 Example of Data Cleaning
 Standardizing data:

Patient ID Name Visit Date


101 Alice 2023-04-01
102 Bob 01-04-2023
103 Charlie 2023/04/01
104 Diana April 1, 2023
105 Eve 2023-04-01

Noorul Athar (PMP, CPHIMS, ITIL)


Data Cleaning Explained with an Example
 Example of Data Cleaning
 Standardizing data:

Patient ID Name Visit Date


101 Alice 2023-04-01
102 Bob 01-04-2023
103 Charlie 2023/04/01
104 Diana April 1, 2023
105 Eve 2023-04-01

Noorul Athar (PMP, CPHIMS, ITIL)


Data Cleaning Explained with an Example
 Example of Data Cleaning
 Filtering outliers:

Noorul Athar (PMP, CPHIMS, ITIL)


Data Cleaning Explained with an Example
 Example of Data Cleaning
 Filtering outliers:

Patient ID Name Age Diagnosis


101 Alice 25 Flu
102 Bob 200 Unknown
103 Charlie 35 Allergy
104 Diana 28 Cold
105 Eve 22 Flu

Noorul Athar (PMP, CPHIMS, ITIL)


Data Cleaning Explained with an Example
 Example of Data Cleaning
 Filtering outliers:

Patient ID Name Age Diagnosis


101 Alice 25 Flu
102 Bob 200 Unknown
103 Charlie 35 Allergy
104 Diana 28 Cold
105 Eve 22 Flu

Noorul Athar (PMP, CPHIMS, ITIL)

You might also like