14,970
edits
Data cleaning: Difference between revisions
Jump to navigation
Jump to search
m
→time data
m (→time data) |
|||
| Line 156: | Line 156: | ||
* Excel: [http://www.techonthenet.com/excel/formulas/isnumber.php ISNUMBER Function] | * Excel: [http://www.techonthenet.com/excel/formulas/isnumber.php ISNUMBER Function] | ||
=== time data === | === abnormal values of time data === | ||
abnormal values if the data was generated in recent years | abnormal values if the data was generated in recent years | ||
* {{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 | ||