Regarding your last question, read ?cut --------------------------------------------------------------------------- Jeff Newmiller The ..... ..... Go Live... DCN:<jdnew...@dcn.davis.ca.us> Basics: ##.#. ##.#. Live Go... Live: OO#.. Dead: OO#.. Playing Research Engineer (Solar/Batteries O.O#. #.O#. with /Software/Embedded Controllers) .OO#. .OO#. rocks...1k --------------------------------------------------------------------------- Sent from my phone. Please excuse my brevity.
doggysaywhat <chwh...@ucsd.edu> wrote: >Hello all. > >I have two data frames. >Group Start End >G1 200 700 >G2 500 1000 >G3 2000 3000 >G4 4000 6000 >G5 7000 8000 > > >and > >Pos C0 C1 >200 0.9 0.6 >500 0.8 0.8 >800 0.9 0.7 >1000 0.7 0.6 >2000 0.6 0.4 >2500 1.2 0.8 >3000 0.6 1.5 >3500 0.7 0.7 >4000 0.8 0.8 >4500 0.6 0.6 >5000 0.9 0.9 >5500 0.7 0.8 >6000 0.8 0.7 >6500 0.4 0.4 >7000 0.5 0.8 >7500 0.7 0.9 >8000 0.9 0.5 >8500 0.8 0.6 >9000 0.9 0.8 > > >I need to conditionally average all values in columns C0 and C1 based >upon >the bins I defined in the first data frame. For example, for the bin >G1 in >the first dataframe, the values are 200 to 700 so i would average the >value >at pos 200 (0.9) and 500 (0.8) for C0 and then perform the same thing >for >C1. > >I can do this in excel with array formulas but I'm relatively new to R >and >would like know if there is a function that will perform the same >action. I >don't know if this will help, but the excel array function I used was >average(if(range>=start)*(range<=end),range)). Where the range is the >entire pos column. > >Initially I looked at the aggregate function. I can use aggregate >when I >give a single vector to be used for grouping such as (A,B,C) but I'm >not >sure how to define grouping as the bin 200-500 and the second bin as >500-1000 etc. and use that as my grouping vector. > >Any help would be greatly appreciated. > > >-- >View this message in context: >http://r.789695.n4.nabble.com/Averaging-within-a-range-of-values-tp4291958p4291958.html >Sent from the R help mailing list archive at Nabble.com. > >______________________________________________ >R-help@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. ______________________________________________ R-help@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.