Clean, Transform, Enrich the data in excel files
This tool is created to help clean the data in a project named "The Analysis of Campus Crime Rate" in class APANS5200 - Applied Analytics Frameworks and Methods.
The tool addressed the following problems:
- Filter the data that is out of scope
- Uniform all string values in all data file
- Add new values in data file for analysis