Data cleaning: Difference between revisions

Data cleaning (edit)

26 bytes removed , 17 August 2017

14,959

edits

@@ Line 257: / Line 257: @@
 === Numeric only ===
+* All numeric value are odd or even if the data were generated by user naturally.
 PHP:
 * [http://php.net/manual/en/function.is-numeric.php is_numeric]
@@ Line 288: / Line 290: @@
 List of the possible abnormal values:
-* Time series
+* {{code | code = 0001-01 00:00:00}} occurred in MySQL {{code | code = datetime}} type
-** {{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
-** {{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
-** future data: the date after today
-* Numeric
-** All numeric value are odd or even if the data were generated by user naturally.
 Find the normal values: