Clean and error-free data
- A ZIP code column has cells that contain more than five numbers. This can happen if you created the dataset in Excel® (sometimes Excel adds an extra zero to certain ZIP codes in the northeastern United States) or if you've perhaps cut and pasted a seven-digit ZIP code into the column.
- There are unreadable characters in your dataset. Again, this might happen if you are manipulating the data in Excel before saving it as a .csv and uploading it, or it might happen if you've imported the data from another source.
- Your dataset uses inconsistent cases for the attribute values in a column. Rhiza for Research treats attribute values as case sensitive. That means that if you have both Female and female as values for an attribute, the upload can fail.
If you dataset has errors, you might notice that it either does not finish uploading or that you cannot select the expected data type for a column. In either of these cases, examine your .csv or .sav file to ensure the data is clean.
© 2016, Rhiza, Inc. All rights reserved. Last updated August 10, 2015 03:36:21 PM.