Introduction:

• What is Data Cleaning ?

Data Cleaning:

• Proper Appearance for the words:

LOWER Function.

PROPER Function.

UPPER Function.

Data Cleaning:

• Transpose Data.

Data Cleaning:

• Duplicates.

Data Cleaning:

• Missing Data.

Data Cleaning:

• Text to Columns.

Data Cleaning:

• Columns to Text.

Data Cleaning:

• Variables Unification: Data Validation as a Precaution.

Data Cleaning:

• Trim Function (For removing any additional spaces):

Data Cleaning:

• Right Function.

• Mid Function.

• Left Function.

Data Cleaning:

• Mixing Left & Find Function.

Data Cleaning:

• Mixing Mid & Find Function.

Data Cleaning:

• Replace Function.

Data Cleaning:

• Substitute Function.

Data Cleaning:

• Mixing more than one Substitute Function.

Keep in touch:

• Mobile: 01060612969 , 01155523721

• Mail: ahmed.essam@lge.com

• LinkedIn: www.linkedin.com/in/ahmed-essam-mohamed