A Simple Example for the cleaning process that is implemented to Excel sheet. The Data is about Boba Tea Shop Location info at San Francisco which is related to the rating of the customers. Multiple cleaning techniques are used at this sheet to have clean, readable data.
Examples of the cleaning techniques:
- Removing Duplicates
- Deleting the empty cells or search for the correct data if available.
- Removing the hyphen at the customer name using CONCATENATE and PROPER functions.
- Trimming the white spaces especially at the city Name using the TRIM function.
- Splitting the Latitude-longitude column into two separate columns using LEFT and RIGHT functions and reducing the decimals to two to make it visibly appealing.