14,962
edits
Data cleaning: Difference between revisions
Jump to navigation
Jump to search
→duplicate data
Tags: Mobile edit Mobile web edit |
|||
| Line 358: | Line 358: | ||
** {{kbd | key = SELECT count(DISTINCT(`id`)) FROM `list_a` WHERE `id` IN (SELECT DISTINCT(`id`) FROM `list_b`) ; }} | ** {{kbd | key = SELECT count(DISTINCT(`id`)) FROM `list_a` WHERE `id` IN (SELECT DISTINCT(`id`) FROM `list_b`) ; }} | ||
* Excel: [http://superuser.com/questions/307837/how-to-count-number-of-repeat-occurrences microsoft excel - How to count number of repeat occurrences - Super User] ''un-tested'' | * Excel: [http://superuser.com/questions/307837/how-to-count-number-of-repeat-occurrences microsoft excel - How to count number of repeat occurrences - Super User] ''un-tested'' | ||
=== other === | |||
* symbol e.g. data-mining or data_mining | |||
== outlier == | == outlier == | ||