search for: observation2

...1,181 27.56512,42.52641,177 27.57800,42.52641,181 27.59087,42.52641,181 27.60375,42.52641,180 27.61662,42.52641,181 ..., ..., ... with approximately 1000000 observations for each. All these tables have the same xcoord and ycoord and I would like to get a table of the form XCOORD,YCOORD,OBSERVATION1,OBSERVATION2,... 27.47500,42.52641,177,233,... 27.48788,42.52641,177,345,... 27.50075,42.52641,179,233,... 27.51362,42.52641,178,123,... 27.52650,42.52641,180,178,... 27.53937,42.52641,178,...,... 27.55225,42.52641,181,... 27.56512,42.52641,177,... 27.57800,42.52641,181,... 27.59087,42.52641,181,... 27.60375,4...

...C=1, D=6, E=1:2, Ob1=1:10, Ob2=2:11, Ob3=3:12, Ob4=4:13, Ob5=3:12, Ob6=2:11, Ob7=1:10, Ob8=3:12) Each row in the data.frame is a unique experiment. The fields Ob1:Ob6 (in the case of the first data.frame) represent observations taken at fixed intervals for specific that experiment. (Observation 1, Observation2, etc.) IMPORTANT - Different data files have different numbers of both experiments and observations as well as different observation rates. Some data.frames might have 50 observations/experiment at 10 minute intervals (a work day) while others might have 2000 observations/experiment at daily interv...