[Chicago] 2 unique keys in a python dict?

[Garrett Smith]

Or just use Django.

----- "Massimo Di Pierro" <mdipierro at cs.depaul.edu> wrote:

> Or....
> 
> edit the header of the CSV file and call your columns
> 
>      tid, paid, ttid
> 
> instead of
> 
>      id, paid, transaction
> 
> and remove the '$' signs from there
> 
> download web2py and type
> 
> python web2py.py -S welcome
>  >>> db=SQLDB()
>  >>> db.define_table('mytable',
>      SQLField('tid','integer'),
>      SQLField('paid','double'),
>      SQLField('ttid','string'))
> 
>  >>> db.import_from_csv_file(open('yourfilename.csv'))
>  >>> db.commit()
>  >>>  
> rows 
> = 
> db 
> ().select 
> (db 
> .mytable 
> .ttid 
> ,db.mytable.paid.sum(),orderby=db.mytable.ttid,groupby=db.mytable.ttid)
>  >>> for row in rows:
> ... print 'transaction',row.ttid,'total  
> amount',row[db.mytable.paid.sum()]
> 
> On Oct 9, 2008, at 11:06 AM, Lukasz Szybalski wrote:
> 
> > On Thu, Oct 9, 2008 at 10:49 AM,  <skip at pobox.com> wrote:
> >>
> >>   Lukasz> Is it possible to have multiple keys in a python  
> >> dictionary?
> >>
> >> Certainly.  Though I don't think that's really what you intended to
>  
> >> ask.
> >>
> >>   Lukasz> Normally its only 1 key, and I need to have 2  
> >> dictionaries and
> >>   Lukasz> somehow manage the uniqueness.
> >>   Lukasz> me={}
> >>   Lukasz> me['First']='Lucas'
> >>   Lukasz> me['Last']='szybalski'
> >>
> >>   Lukasz> I would like to get 2 keys? Is there something similar to
>  
> >> dict
> >>   Lukasz> that would have the property that 2 or more keys are  
> >> unique?
> >>   Lukasz> me= ?
> >>
> >> I'm unclear what you are asking.  Do you want a list of  
> >> dictionaries?, e.g.:
> >>
> >>   names = [
> >>       {
> >>           'First': 'Lucas',
> >>           'Last': 'Szybalski',
> >>       },
> >>       {
> >>           'First': 'Skip',
> >>           'Last': 'Montanaro',
> >>       }
> >>   ]
> >>
> >
> >
> > I have multiple records in a csv file for each userid. I need to
> > calculate total amount paid and last transaction.
> >
> > id,paid,transaction
> > 3,$10,20080101
> > 3,$10,20080201
> >
> >
> > Final Total
> > me={}
> > me[3]=($20,20080201)  (dictionary with a list)
> >
> > now
> > id,subid, paid,transaction
> > 3,1,$10,20080101
> > 3,2,$10,20080201
> >
> > I guess what Massimo said will work, but now I need to know which
> row
> > is the paid and which is transaction?!!
> > me[3,1]=(10,20080101)
> > me[3,2]=(10,20080201)
> >
> > I guess this could do it
> > me[3,1]={'paid':10 , 'transaction':20080101}
> >
> > Thanks,
> > Lucas
> > _______________________________________________
> > Chicago mailing list
> > Chicago at python.org
> > http://mail.python.org/mailman/listinfo/chicago
> 
> _______________________________________________
> Chicago mailing list
> Chicago at python.org
> http://mail.python.org/mailman/listinfo/chicago