Welcome to WEAP's Website WEAP
WEAP is an initiative of the Stockholm Environment Institute.

About WEAP

What's New?
Sample Screens
History and Credits

Using WEAP
User Guide
Videos (YouTube)

User Forum
Members List
Edit Profile

Additional Support
University Courses

About Us
SEI-US Water Resources Program
Please Contact Us

Environmental News
Not acting like themselves: Antidepressants in environment alter crayf...
Expose crayfish to antidepressants, and they become more outgoing -- but that might not be such a positive thing for the...

Heat from below: How the ocean is wearing down the Arctic sea ice
The influx of warmer water masses from the North Atlantic into the European marginal seas plays a significant role in th...

Research reveals why people pick certain campsites
Those in love with the outdoors can spend their entire lives chasing that perfect campsite. New research suggests what t...
Source: Science Daily
Interested in Energy?
Read about LEAP: SEI's software for energy planning.

Link WEAP and LEAP for combined Water-Energy planning.
Watch a video demo!

User Forum

All Topics | Topic "Read format from csv text file"
Log in to post new messages or reply to existing messages.
Author Message
Mrs. Beatriz Cecilia Martinez Contreras

Subject: Read format from csv text file   
Posted: 2/25/2020 Viewed: 1700 times
Good morning everyone:

I have a problem trying to load the data with weekly resolution in csv format, from read from file wizard, leaving the following error:

"There is not column named" precipitation "in file, column names listed in the $ columns directive in this file:" year, week, precipitation "

I appreciate your help.

Ms. Anne Hereford

Subject: Re: Read format from csv text file   
Posted: 3/21/2020 Viewed: 1663 times
Dear Beatriz,
Have you seen this section (below) of the WEAP help that provides an example of how to name your columns in your CSV file?

Column Descriptions
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:

Annual: $Columns = Year, Population

Monthly: $Columns = Year, Month, Burlington Brook USGS 1188000[CFS], Weber River USGS 1932000[CFS]

Daily: $Columns = Date, Precipitation[mm], Mean Temperature[C]

If any column names include the list separator character, you must enclose the name in quotes, e.g., "Daily Temperature, Average[C]"

The ReadFromFile and FDCShift Wizards will display information from the $Columns directive.

Topic "Read format from csv text file"