Now that I have turned in this semester's grades, I can focus on my manuscript and quit using it as a distraction from grading. So far I have downloaded the daily average flow data for my two watersheds and organized it in a way that is useful. To me, this looks like:
1) Extra data is out of the dataset. Robinson Forest has a hydrology record that stretches all the way back to 1973. I only need data from 2000 to 2019.
2) Each row of data has a day of year, day of water year, and year associated with it.
3) The dates for the two sites match up.
This leaves me with 13,880 individual data points.
I used a Pivot Table in Excel to get some early snapshots of what the stream's relationship looks like. Here is a graph from water year 2000.
Commentaires