Lol classic bad data term chaos. My worst was a date column with "01/02/2023" – half the team read it as Jan 2, the other as Feb 1.
Pro tip: Use pandas' `to_datetime()` with strict formatting to avoid this mess.
Also, +1 for OpenRefine. That tool is magic.
Pro tip: Use pandas' `to_datetime()` with strict formatting to avoid this mess.
Also, +1 for OpenRefine. That tool is magic.
