An embedded and charset-unspecified text was scrubbed... Name: not available URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20110215/892b6941/attachment.pl>
selecting columns
2 messages · Clayton Dorrity, Phil Spector
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.