14,970
edits
Data cleaning: Difference between revisions
Jump to navigation
Jump to search
m
→abnormal values of time data
| Line 157: | Line 157: | ||
=== abnormal values of time data === | === abnormal values of time data === | ||
Definition of abnormal values | Definition of abnormal values of the time data ([http://en.wikipedia.org/wiki/Time_series time series]) if they | ||
* 10 years before | * were generated 10 years before or | ||
* newer than today | * newer than today | ||
List of the possible | List of the possible abnormal values: | ||
* {{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 | ||