Hi Rich, Your request is a bit open-ended but here's a suggestion that might help get you an answer. Provide dummy data (e.g. 5-10 lines), say like the contents of a csv file, and calculate by hand what you'd like to see in the plot. (And describe what the plot would look like.) It sounds like what you want could be done in a few lines of R code which would work both on the dummy data and the real data. HTH, Eric On Sun, Aug 29, 2021 at 6:09 PM Rich Shepard <rshepard at appl-ecosys.com> wrote:> I have a year's hydraulic data (discharge, stage height, velocity, etc.) > from a USGS monitoring gauge recording values every 5 minutes. The data > files contain 90K-93K lines and plotting all these data would produce a > solid block of color. > > What I want are the daily means and standard deviation from these data. > > As an occasional R user (depending on project needs) I've no idea what > packages could be applied to these data frames. There likely are multiple > paths to extracting these daily values so summary statistics can be > calculated and plotted. I'd appreciate suggestions on where to start to > learn how I can do this. > > TIA, > > Rich > > ______________________________________________ > R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see > 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. >[[alternative HTML version deleted]]
On Sun, 29 Aug 2021, Eric Berger wrote:> Provide dummy data (e.g. 5-10 lines), say like the contents of a csv file, > and calculate by hand what you'd like to see in the plot. (And describe > what the plot would look like.)Eric, Mea culpa! I extracted a set of sample data and forgot to include it in the message. Here it is: date,time,cfs 2020-08-26,09:30,136000 2020-08-26,09:35,126000 2020-08-26,09:40,130000 2020-08-26,09:45,128000 2020-08-26,09:50,126000 2020-08-26,09:55,125000 2020-08-26,10:00,121000 2020-08-26,10:05,117000 2020-08-26,10:10,120000 ... 2020-08-26,23:10,108000 2020-08-26,23:15,96200 2020-08-26,23:20,86700 2020-08-26,23:25,103000 2020-08-26,23:30,103000 2020-08-26,23:35,99500 2020-08-26,23:40,85200 2020-08-26,23:45,103000 2020-08-26,23:50,95800 2020-08-26,23:55,88200 Rich