Characteristics of a good CSV file for R

| No Comments

Edited by cswitzer. 25 July 2011


Characteristics of a good CSV file:
1. Use database format in Excel

See this example: http://blog.lib.umn.edu/wage0005/echinacea/2011/07/preliminary-analysis-for-calli.html
2. Don't mix text, integer, or numeric fields (you may enter NA in a numeric field to signify missing data)
3. Remove spaces from excel cells
4. No punctuation in each column name
5. Don't start a column with a number
6. Column names should be in easily typable format -- use capitals at new words and use no spaces (called camelback format)

Leave a comment