14,959
edits
Data cleaning: Difference between revisions
Jump to navigation
Jump to search
m
→Abnormal values of time data
| Line 288: | Line 288: | ||
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 | * Time series | ||
* {{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 = 0001-01 00:00:00}} occurred in MySQL {{code | code = datetime}} type | ||
* future data: the date after today | ** {{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 | |||
* numeric | |||
* All numeric value are odd or even | * All numeric value are odd or even | ||