Categories

Authors

Characteristics of a good CSV file for R

Edited by cswitzer. 25 July 2011

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

See this example: http://echinaceaproject.org/wp-content/uploads/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)

Facebooktwitterpinterestmail

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>