Subject: CLIMATE DATA FORMAT Posted: 11/1/2021 Viewed: 1996 times
Hello colleagues, I would like to be assisted here, I want to know the format to use when creating climate data, like what headings and how to arrange your data so that WEAP may read it correctly. If possible can one of us send the example of the climate data with all the components like precipitation, wind, humididy, temperature etc in excell and in CSV.
Mr. Asavela Jack
Subject: Re: CLIMATE DATA FORMAT Posted: 11/10/2021 Viewed: 1976 times
My personal email is firstname.lastname@example.org
I am still waiting for your help good people.
Ms. Anne Hereford
Subject: Re: CLIMATE DATA FORMAT Posted: 1/19/2022 Viewed: 1790 times
The following is from the WEAP User Guide under the topic ReadFromFile. In the same section of the help you will find information about offsetting your data, aggregating daily data to monthly data, what to do about missing data, etc. Hope this helps!
Use the optional $Columns directive to describe the contents and unit for each data column. The optional unit, if included, is in square brackets after the name. This is a very good way to document your data. In addition, you can then refer to columns by their name instead of their number in the ReadFromFile expression -- not only will this make for a clearer expression, but the reference will still be correct if you later add or remove columns in the file. Here is an example from a climate file named Climate.csv with 5 data columns (rainfall, min and max temperature, humidity and wind):
$Columns = Precipitation[mm], Min Temperature[C], Max Temperature[C], Relative Humidity[%], Wind Speed[m/s]
Here's how to refer to the Max Temperature column in the ReadFromFile expression: ReadFromFile(Climate.csv, "Max Temperature[C]") Note: you must enclose the column name in quotes. The unit is optional and can be omitted, e.g., ReadFromFile(Climate.csv, "Max Temperature")
Optionally, you may list the time columns first. Some examples: