how to write data to csv using DictWriter

[sushanth Reddy]

Hi,


How to write  below data to csv in below output format ?


list of dict


    data=[{'date': datetime.date(2011, 2, 8), 'user': u'xxx', 'status': 
u'P'}, {'date': datetime.date(2011, 2, 8), 'user': u'yyy', 'status': u'P'}, 
{'date': datetime.date(2011, 2, 8), 'user': u'zzz', 'status': u'P'}, 
{'date': datetime.date(2011, 2, 9), 'user': u'xxx, 'status': u'P'}, {'date': 
datetime.date(2011, 2, 9), 'user': u'yyy', 'status': u'E'}, {'date': 
datetime.date(2011, 2, 9), 'user': u'zzz', 'status': u'E'}, {'date': 
datetime.date(2011, 2, 10), 'user': u'xxx', 'status': u'P'}, {'date': 
datetime.date(2011, 2, 10), 'user': u'yyy', 'status': u'P'}, {'date': 
datetime.date(2011, 2, 10), 'user': u'zzz', 'status': u'P'}]


Output format should be :

    S.no  user  2011-02-08 2011-02-09 2011-02-10  p-total E-total total 
     1    xxx      p          p         p           3       0       3
     2    yyy      p          E         p           2       1       3
     3    zzz      p          E         E           1       2       3




 code :

     import csv
     from datetime import datetime,date
     
      d=28
      for i in xrange(1,d):
           date_format = now.replace( year = 2011 , month = 02 , day = i )
           writer = csv.DictWriter(f, ['S.no', 'user', 
'date_format','p-total','E-total','Total'])
   how to write to items to csv  ?

Please need help 
   

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To post to this group, send email to django-users@googlegroups.com.
To unsubscribe from this group, send email to 
django-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/django-users?hl=en.