[portland] Reformatting Data Files
rshepard at appl-ecosys.com
Fri Jan 28 23:41:10 CET 2011
On Fri, 28 Jan 2011, Ethan Furman wrote:
>> 'Depth to Water':76.75:77.51:82.15:73.17:72.66:84.44:96.41:
That's close enough. The spreadsheet was created with, in this case two
locations (JCM-10B and JCM-20B) as the top row. The second row contains
dates, and succeeding rows each contain a water quality paramter and the
value measured for that parameter at that location on that date.
> I'm having a hard time understanding your description of what the second,
> third, etc, lines should look like... if I carry out your table further,
> is it correct?
> ::'JCM-10B':'2004-08-16':'Depth to water':76.75::
> If that's correct, what happens to the remaining values on lines 3, 4, etc?
Yes, this is correct. Instead of the organization above, I want each row
to be a complete record of location, date, parameter and value. Somewhat
analogous to transposing rows and columns in the spreadsheet, but that's not
In the re-written file, there will be one row for each unique set of
location, date, parameter, and value. For this file, there are 2 locations,
22 dates, and 32 parameters (each with 1 value for that parameter on that
date at that location) or 1408 distinct rows.
Does this make it clearer?
Unfortunately, no one now or before at the client's site knows anything
about databases or data storage so the spreadsheets are a horrible mess in
terms of extracting the data.
More information about the Portland