14,959
edits
Data cleaning: Difference between revisions
Jump to navigation
Jump to search
→Verify the format of field value
| Line 257: | Line 257: | ||
=== Numeric only === | === Numeric only === | ||
* All numeric value are odd or even if the data were generated by user naturally. | |||
PHP: | PHP: | ||
* [http://php.net/manual/en/function.is-numeric.php is_numeric] | * [http://php.net/manual/en/function.is-numeric.php is_numeric] | ||
| Line 288: | Line 290: | ||
List of the possible abnormal values: | List of the possible abnormal values: | ||
* {{code | code = 0001-01 00:00:00}} occurred in MySQL {{code | code = datetime}} type | |||
* {{code | code = 1900/1/0}} (converted time formatted value from 0), {{code | code = 1900/1/1}} (converted time formatted value from 1), {{code | code = 1900/1/2}} ... occurred in MS Excel | |||
* future data: the date after today | |||
Find the normal values: | Find the normal values: | ||