Questions tagged [data-cleansing]

Data cleansing is the process of removing or correcting incorrect data from a dataset

Filter by
Sorted by
Tagged with
1
vote
0answers
21 views

Selecting Duplicates on All Fields

I have an MS Access (no laughing at the back) database I've used to import a bunch of IIS logs into. Having looked at the Excel files I pulled these in from, I'm worried going by the dates that some ...
4
votes
2answers
7k views

Find rows with similar string values

I have a Microsoft SQL Server 2012 database table with around 7 million crowd-sourced records, primarily containing a string name value with some related details. For nearly every record it seems ...
1
vote
1answer
1k views

How to compare two tables that have no primary key?

So I got two sets of tables at work that I have to compare the data. The fields are identical, but there is no column that has unique entries. (Employee ID, Assignment ID, Employee's last name, ...
2
votes
2answers
50 views

How should I handle measurement errors in a timeseries database?

I have a table used to record measurements sampled at regular intervals on different sensors. Each row records the time, the identifier of the quantity being measured, and the value itself. Now and ...