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:lriv...@mosasaur.com>
512/203.3198 (m)


Reply via email to