Data Cleansing, also known as data cleaning, is correcting errors, duplications, or otherwise erroneous or discrepancy data in a data set. It also involves identifying errors in data and then modifying, updating, or eliminating data to correct them. Data cleaning enhances data quality and provides more correct, coherent, accurate, persistent, and steady information for the organization, especially for decision-making purposes. The researchers used the data result of the physical and chemical analysis of one of the bureaus in Region III. The researchers identified some discrepancies, inconsistencies, and duplications in their data. Also, the data set provided in the list was full of different data types such as locations, water source, date, time, and other parameters. As the researchers found out these data were not in the correct form, the researchers used Microsoft (MS) Excel to solve the issues. MS Excel is a spreadsheet application that can help users to sort and filter data. The said application helped the researchers to filter and sort data of the water result of physical and chemical analysis of the Bulacan. With the MS Excel Application, the researchers could utilize the functions and features to filter and sort the data manually. Moreover, with that approach, the researchers could filter the required data to its field name or classification. Also, the researchers were able to remove the data that were not needed, data that had issues with duplications and inconsistencies.
Keywords: Data Cleaning, Data Cleansing, MS Excel, Water Analysis.
Related Post