No doubt this is my base Python ignorance being the problem.
I've made some progress on my pivot problem, using this recipe
<http://code.activestate.com/recipes/334695-pivotcrosstabdenormalization-of-a-normalized-list/>
(actually, the improved one from the comments).
I'm getting what I want now (or close to it):
[ { 'FreezeTime': datetime.datetime(2010, 12, 12, 21, 0),
('S00000000',): 643.882600715039,
('S00000001',): '',
('S00000002',): 621.511925599709},
{ 'FreezeTime': datetime.datetime(2010, 12, 12, 22, 0),
('S00000000',): 159.230736027886,
('S00000001',): '',
('S00000002',): 166.628191452988}, ...
]
But when I try to convert it to json using this in my view:
var optimizerdata = {{response.write(json(optimizers), escape=False)}};
Where optimizers is a list that looks like this:
It throws the error, saying this:
TypeError: key ('S00000001',) is not a string
--
Lorin Rivers
Mosasaur: Killer Technical Marketing <http://www.mosasaur.com>
<mailto:[email protected]>
512/203.3198 (m)
