Menu
Short and sweet: how can I export TSV/CSV from R?
write.table / write.csv almost works:
test <- data.frame(a = 2 : 4, b = 3 : 5)
write.table(test, file='test.tsv', quote=FALSE, sep='\t')
$ more test.tsv
a b
1 2 3
2 3 4
3 4 5
… but produces a format that is different from what’s expected by most other programs:
a b
1 2 3
2 3 4
3 4 5
– note the different handling of the header row.
How can I export the second rather than the first format? Manually specifying the col.names as c('', colnames(test)) doesn’t work – R complains about an invalid argument.
898
From the File menu, select Download as then select Tab-separated values (. tsv, current sheet). This will download the currently selected sheet as a tab-separated . TSV file, inheriting the name of your spreadsheet.
CSV uses an escape syntax to represent comma and newlines in the data. TSV takes a different approach, disallowing TABs and newlines in the data. The escape syntax enables CSV to fully represent common written text. This is a good fit for human edited documents, notably spreadsheets.
You can use col.names = NA:
write.table(test, file='test.tsv', quote=FALSE, sep='\t', col.names = NA)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
