1

  1. I have loaded a csv file to R.

  2. There are 10 columns in the file.

  3. I want to save the 1st 3rd and 5th column to a new file. What is the command line to delete other columns?

  4. I want to save the new table, what is the command line should be used?

Brian Tompsett - 汤莱恩
  • 5,753
  • 72
  • 57
  • 129
Catherine
  • 5,345
  • 11
  • 30
  • 28
  • 7
    R comes with *six manuals*. One is a general introduction explaining point three about indexing. Another one is on data import/export and covers point four. – Dirk Eddelbuettel Apr 06 '11 at 14:59

1 Answers1

12

First, I'll answer your question. If d is your data frame loaded from your file, then:

d_subset = d[,c(1,3,5)]
write.csv(d_subset, file="file.csv")

Second, I'll give you some advice. Read the documentation or buy a good R book. You can even download An introduction to R for free. Many of the questions you are asking are very basic. While most people are happy to handle the odd basic question, asking three or four a day really isn't sustainable.

csgillespie
  • 59,189
  • 14
  • 150
  • 185
  • 10
    +1 for _While most people are happy to handle the odd basic question, asking three or four a day really isn't sustainable._ – Joshua Ulrich Apr 06 '11 at 15:08