unleash logo

How do you find inconsistent data?

Asked 9 months ago

Hi all, it's time to go through our data lake, and I'm dreading it because it's everything but small. I am tasked with looking for and correcting inconsistencies and duplicates, and I fear that it will take me forever in its arduousness. Is there any way to make this process easier? Thank you in advance.

Eduardo Salas

Sunday, March 27, 2022

It is difficult to find and correct the data inconsistencies manually. To find and fix data inconsistencies, you can use filters in Excel or any other spreadsheet you prefer. Deselect the correct values from all the unique values of the columns for filtering. It will show all the misspelled, incorrect and duplicate values. You can easily select and correct the misspelled values and delete identical ones.

Arjun Coleman

Sunday, July 24, 2022

If you are correcting the inconsistent data in downloaded employees, 2 or 3 inconsistencies are easy to deal with. Anything beyond this number is not easy to detect and rectify. Fortunately enough, Excel has a shortcut way to deal with inconsistencies:

  1. Create a filter.
  2. Type in the incorrect values.
  3. Deselect all the correct values and select the incorrect ones.
  4. Now only the incorrect values will show in the column.

To delete columns in Excel that go on forever, follow these steps:

  1. Select the column.
  2. Press the ctrl+shift+right to reach the end of the data set.
  3. Now manually select and delete the column.

Abeeha Qasmi

Friday, October 21, 2022

The easiest way to deal with data inconsistency is through a spreadsheet filter. Microsoft Excel is an easy fix for that. You can create a filter of misspelled words by clicking the drop-down filter arrow in your column. Deselect all the correct values from it. Now the column will be left with inconsistent data only. You can now quickly rectify it all. Once done, click select all in the filter menu to get all correct values back in the column.

Write an answer...


Please follow our  Community Guidelines

Can't find what you're looking for?

Powered By Entail.ai