40

There is a dataframe named cnbd, for example:

cnbd = data.frame(1,2,3,NA,NA,5)

Thus the expression:

dim(cnbd)[1]

give 1.

I want to write a dataframe like cnbd to a csv with: 

write(file = filename, cnbd, append = TRUE)

The problem comes:

  1. The values of csv file show cnbd with 6 rows not 1 row as 1,2,3,NA,NA,5.
  2. I need output cnbd show as 1,2,3,,,5 in csv file, no NAs.
zx8754
  • 52,746
  • 12
  • 114
  • 209
Lawes
  • 609
  • 1
  • 8
  • 14

2 Answers2

63

Try this:

write.table(df, "cnbd.csv",
            na = "",
            row.names = FALSE,
            col.names = FALSE,
            append = TRUE,
            sep = ",")
zx8754
  • 52,746
  • 12
  • 114
  • 209
38

You can try the write.csv command:

write.csv(cnbd, file="cnbd.csv", na="")
rfsaldanha
  • 493
  • 4
  • 7
  • this kind of write mode will erase the former content,and add the row names and column name in the file,that's not my expected.could you give me details how to do?thanks very much – Lawes Jan 07 '14 at 10:50