14,959
edits
Data cleaning: Difference between revisions
Jump to navigation
Jump to search
m
→Abnormal values of time data
| Line 292: | Line 292: | ||
** {{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 | ** All numeric value are odd or even if the data were generated by user naturally. | ||
Find the normal values: | Find the normal values: | ||