search

DOI-BOR / PyForecast

PyForecast is a statistical modeling tool used by Reclamation water managers and reservoir operators to train and build predictive models for seasonal inflows and streamflows. PyForecast allows users to make current water-year forecasts using models developed with the program.
Other
28 stars 12 forks source link

Expert Data Import Mode #37

Closed tjrocha closed 5 years ago

tjrocha commented 5 years ago

Allow the Import feature on the Data tab to import data arrays instead of a single series at a time.

PN needs to import custom data arrays that do not currently fit the current data acquisition scheme in PyForecast (monthly data, custom indices, etc). A parallel development effort for an Excel (sigh, i know...) data pre-processor that will generate daily data arrays for PyForecast is under development. Need PyForecast to accept the output array from this tool.

I'm thinking we define the inputs that the current Import feature needs (Dataset Name, Parameter Name, Units, and Resampling) as headers in the input data array. and have the code loop through the columns and add each one of the entries in the array.

tjrocha commented 5 years ago

Excel tool now in development.

tjrocha commented 5 years ago

Working custom data processor for PN Hydromet monthly data. Downloads monthly data and copies the monthly values into daily time-steps and sets the PyForecast-Array-Import required variables. The intent is to get PyForecast to resample the data array using the Mean method thereby preserving the original monthly value in the PyForecast-chunked predictor dataset.

PyForecast.DataProcessor.xlsm.zip

tjrocha commented 5 years ago

tested working. updated installer file. closing issue.