[R] Creating subset using selected columns

[Rainer Schuermann]

Supposed your data.frame is called x, try
x[ which( substr( colnames( x ), 1, 4 ) == "Peak" ) ]


On Sunday 16 June 2013 15:20:37 Suparna Mitra wrote:
> Hello R experts,
>  I need a help to create a subset file. I know with subset comand, its very
> easy to select many different columns, or threshold. But here I have a bit
> problem as in my data file is big. And I don't want to identify the column
> numbers  
> 
> or names manually. I am trying to find any way to automatise this.
> 
> For example I have a file with about 1500 columns from TRFLP intensity
> data.
> 
> 
> And the column names are like:
>  [1] "Sample.Name"    "Marker"         "RE"             "Dye"
>  "Allele.1"       "Size.1"         "Height.1"       "Peak.Area.1"
>  "Data.Point.1"
>   [10] "Allele.2"       "Size.2"         "Height.2"       "Peak.Area.2"
>  "Data.Point.2"   "Allele.3"       "Size.3"         "Height.3"
> "Peak.Area.3"
>   [19] "Data.Point.3"   "Allele.4"       "Size.4"         "Height.4"
> "Peak.Area.4"    "Data.Point.4"   "Allele.5"       "Size.5"
> "Height.5"
>   [28] "Peak.Area.5"    "Data.Point.5"   "Allele.6"       "Size.6"
> "Height.6"       "Peak.Area.6"    "Data.Point.6"   "Allele.7"
> "Size.7"
>   [37] "Height.7"       "Peak.Area.7"    "Data.Point.7"   "Allele.8"
> "Size.8"         "Height.8"       "Peak.Area.8"    "Data.Point.8"
> "Allele.9"
>   [46] "Size.9"         "Height.9"       "Peak.Area.9"    "Data.Point.9"
> "Allele.10"      "Size.10"        "Height.10"      "Peak.Area.10"
> "Data.Point.10"
> .....
> 
> Suppose I want to create a subset selecting all the columns with
> name Peak.Area
> (as in unix Peak.Area.*)
> How can I do that in R? 
> Thanks a lot for the help.
> Best wishes,
> Mitra
> 
> 	[[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.