datasmells
datasmells copied to clipboard
A general page to cover issues with implicit type coercion
This is the classic case where there might not be something wrong within the data but the number of rows suggests very strongly that the data was truncated by Excel...
Description of Error: Is your data shooting blanks? This can be an import issue. Things to look for: Search for null or blank values in numeric fields. Pay close attention...
Description of Error: Data can have legit outliers, but sometimes it's more nefarious. Check yourself before you wreck yourself. Things to look for: Sort or order all applicable fields. Double-check...
Description of Error : Latitude and longitude are reversed, resulting in the points being in completely the wrong place. Things to look for : pick something not near the equator...
Description of Error : Things to look for : Examples :