I have 3 columns of values that are collected observed data from a streamflow gage. The data was collected on a daily basis for 40+ years. The data collected is streamflow and specific conductance. Specific conductance values can vasry for a given value of streamflow during the 40+ years of daily data collected. I would like to generate a summary that tells me the minimum/maximum/average value of specific conductance for a given value of streamflow. A sample of my data is below:
Date Streamflow Specific Conductance
----------------------------------------------------------------
01/23/1980 2000 231
01/21/1988 2010 223
02/11/1971 2010 239
03/02/1992 2010 254
01/16/1972 2030 220
02/19/1989 2030 240
What I want generated is something like this:
Streamflow Count Min Max Avg Date1 Date2 Date3
----------------------------------------------------------------------------------------------------------------------
2000 1 231 231 231.00 01/23/1980
2010 3 223 254 238.67 01/21/1988 02/11/1971 03/02/1992
2030 2 220 240 230.00 01/16/1972 02/19/1989
The summary of date(s) collected is optional but it might be useful to me down the road during my data analysis.
Thanks
Rob
Date Streamflow Specific Conductance
----------------------------------------------------------------
01/23/1980 2000 231
01/21/1988 2010 223
02/11/1971 2010 239
03/02/1992 2010 254
01/16/1972 2030 220
02/19/1989 2030 240
What I want generated is something like this:
Streamflow Count Min Max Avg Date1 Date2 Date3
----------------------------------------------------------------------------------------------------------------------
2000 1 231 231 231.00 01/23/1980
2010 3 223 254 238.67 01/21/1988 02/11/1971 03/02/1992
2030 2 220 240 230.00 01/16/1972 02/19/1989
The summary of date(s) collected is optional but it might be useful to me down the road during my data analysis.
Thanks
Rob
Last edited: