[portland] Reformatting Data Files
kyle at bucebuce.com
Sat Jan 29 01:01:09 CET 2011
It isn't anything pretty, but I think this might be similar:
On Fri, Jan 28, 2011 at 2:41 PM, Rich Shepard <rshepard at appl-ecosys.com>wrote:
> 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,
> 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
> a solution.
> 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.
> Portland mailing list
> Portland at python.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Portland