Data cleaning: Difference between revisions

Jump to navigation Jump to search
163 bytes removed ,  13 February 2023
m
Line 353: Line 353:
** {{code | code = 1900/1/0}} (converted time formatted value from 0),  
** {{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/1}} (converted time formatted value from 1)
* Verfiy the value of data were not {{kbd | key=0000-00-00 00:00:00}}
** {{code | code = SELECT * FROM `my_table` WHERE  `my_time_column` LIKE '%0000-00-00%';}}


* Verfiy the diversity of data values e.g. [https://en.wikipedia.org/wiki/Variance Variance]
* Verfiy the diversity of data values e.g. [https://en.wikipedia.org/wiki/Variance Variance]
Anonymous user

Navigation menu