14,970
edits
Data cleaning: Difference between revisions
Jump to navigation
Jump to search
→verify the format of field value
(→duplicate data: +counting number of duplicate occurrence) |
|||
| Line 151: | Line 151: | ||
** "Returns the filtered data, or '''FALSE''' if the filter fails." quoted from [http://php.net/manual/en/function.filter-var.php PHP.net] | ** "Returns the filtered data, or '''FALSE''' if the filter fails." quoted from [http://php.net/manual/en/function.filter-var.php PHP.net] | ||
=== number precision | === number precision in Excel === | ||
Number precision: 15 digits (Excel中最多的有效位數為15位)<ref>[https://support.office.com/en-nz/article/Excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3 Excel specifications and limits]</ref><ref>[http://isvincent.pixnet.net/blog/post/30267208-excel-%E9%A1%AF%E7%A4%BApi%E8%BC%83%E5%A4%9A%E7%9A%84%E6%9C%89%E6%95%88%E4%BD%8D%E6%95%B8 A2]</ref> | Number precision: 15 digits (Excel中最多的有效位數為15位)<ref>[https://support.office.com/en-nz/article/Excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3 Excel specifications and limits]</ref><ref>[http://isvincent.pixnet.net/blog/post/30267208-excel-%E9%A1%AF%E7%A4%BApi%E8%BC%83%E5%A4%9A%E7%9A%84%E6%9C%89%E6%95%88%E4%BD%8D%E6%95%B8 A2]</ref> | ||
| Line 159: | Line 159: | ||
* (general format 通用格式) 1.23457E+15 {{exclaim}} losing precision | * (general format 通用格式) 1.23457E+15 {{exclaim}} losing precision | ||
* (text format 文字格式) 1234567890123456 | * (text format 文字格式) 1234567890123456 | ||
large numbers | |||
* If the data was imported from Excel, you sholud notice the 15 digit precision issue in Microsoft Excel | |||
=== numeric only === | === numeric only === | ||