14,970
edits
Data cleaning: Difference between revisions
Jump to navigation
Jump to search
m
→duplicate data
m (→duplicate data) |
|||
| Line 188: | Line 188: | ||
** two columns data: [https://support.microsoft.com/en-us/kb/213367 How to compare data in two columns to find duplicates in Excel] {{access | date = 2016-06-16}} | ** two columns data: [https://support.microsoft.com/en-us/kb/213367 How to compare data in two columns to find duplicates in Excel] {{access | date = 2016-06-16}} | ||
* PHP: [http://php.net/manual/en/function.array-unique.php PHP: array_unique], [http://php.net/manual/en/function.array-intersect.php PHP: array_intersect] | * PHP: [http://php.net/manual/en/function.array-unique.php PHP: array_unique], [http://php.net/manual/en/function.array-intersect.php PHP: array_intersect] | ||
* MySQL: [http://www.mysqltutorial.org/mysql-distinct.aspx MySQL DISTINCT - Eliminate Duplicate Rows in a Result Set] | * MySQL: | ||
** [http://www.mysqltutorial.org/mysql-distinct.aspx MySQL DISTINCT - Eliminate Duplicate Rows in a Result Set] | |||
** [http://www.w3schools.com/sql/sql_unique.asp SQL UNIQUE Constraint] | |||
== outlier == | == outlier == | ||