R help - Feb 2011 - selecting columns

I need help.

I have very big .csv files with many unnecessary columns.  From the original
.csv files I would like to create a new .csv file with just the columns I
need.

For example:

The original column heading are: Date, Time, Location, Sensor Name, Sensor
Serial, Ambient Temp, IR Temp, Sensor Name.1, Sensor Serial.1, Ambient
Temp.1, IR Temp.1, Sensor Name.2, Sensor Serial.2, Ambient
Temp.2,..........Sensor Name.45

I would like to create a new .csv file with only Date, Time, Sensor Serial,
IR Temp, Sensor Serial.1, IR Temp.1, Sensor Serial.2, IR Temp.2,.....Sensor
Serial.45, IR Temp.45, etc


Any help on this matter would be greatly appreciated.

	[[alternative HTML version deleted]]

Clayton -
    From your explanation, it sounds like you want to create 
a new file removing the "Location" variable, and all the 
variables that have the string "Ambient" or "Name" in their
names.
Suppose that your data frame is called mydata, and you wish to 
create a reduced csv file called "mydata.csv"

write.csv(mydata[,grep('Location|Ambient|Name',names(mydata),invert=TRUE)],
           file='mydata.csv')

should do what you want, but without a more concrete example, it's
just a guess.

 					- Phil Spector
 					 Statistical Computing Facility
 					 Department of Statistics
 					 UC Berkeley
 					 spector at stat.berkeley.edu

On Tue, 15 Feb 2011, Clayton Dorrity wrote:
> I need help.
>
> I have very big .csv files with many unnecessary columns.  From the
original
> .csv files I would like to create a new .csv file with just the columns I
> need.
>
> For example:
>
> The original column heading are: Date, Time, Location, Sensor Name, Sensor
> Serial, Ambient Temp, IR Temp, Sensor Name.1, Sensor Serial.1, Ambient
> Temp.1, IR Temp.1, Sensor Name.2, Sensor Serial.2, Ambient
> Temp.2,..........Sensor Name.45
>
> I would like to create a new .csv file with only Date, Time, Sensor Serial,
> IR Temp, Sensor Serial.1, IR Temp.1, Sensor Serial.2, IR Temp.2,.....Sensor
> Serial.45, IR Temp.45, etc
>
>
> Any help on this matter would be greatly appreciated.
>
> 	[[alternative HTML version deleted]]
>
> ______________________________________________
> R-help at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>