Write a code to load the stream parameters and precipitation data collected at the Cameo station of the Colorado River: Cameo_river_data.csv and cameo_precip.csv. Use pandas to analyze the data.

a) Plot precipitation and stream flow (on one plot) around the storm beginning September 13, 2022. Ensure the analysis period is long enough to capture the full stream response. What is the time lag between peak precipitation and peak streamflow? What is the total amount of precipitation for this 5-day storm event?

Next, write a code to load the files CORiver_data.xls. Download CORiver_data.xls CORiver_data is yearly flow at 5 different USGS gages along the Colorado River (compiled by me from https://waterdata.usgs.gov/nwis).

b) What is the minimum, mean, and maximum flow at the Cisco, UT station? How about the Yuma, AZ station? What years do these maximum and minimum values occur? Write these answers in a comment, and show the commands you used to obtain the answers.

c) Plot the timeseries of the flow rates (either plot 5 subplots, or plot all on the same axis using different line colors). In a comment in the code, describe how flows have changed over the past 100 years (e.g. have they been increasing, decreasing, and where?). To help you understand this issue more, check out this article in National Geographic: https://www.nationalgeographic.com/science/2020/03/partner-content-colorado-river-preserving-stressed-water-resources/