Quartz/bad-data-guide

Text incorrectly converted to date

krobison13 opened this issue · 1 comments

Excel import will convert text that looks somewhat like a date to a date; this has been noted as a common problem with human genetic data, as several gene symbols resemble dates (DEC1, SEPT9, MARCH1). Best defense: be suspicious of columns which have mix of numeric (or date) and text data, particularly if the fraction of numerics (or dates) is very low

Yes, this is a good addition. I'll add.