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