存储数据到CSV文件中

import csv

headers = ['ID','UserName','Password','Age','Country']
rows = [{'ID':1001,'UserName':'qiye','Password':'qiey_pass','Age':24,'Country':'China'},
        {'ID':1002,'UserName':'Mary','Password':'Mary_pass','Age':20,'Country':'USA'},
        {'ID':1003,'UserName':'Jack','Password':'Jack_pass','Age':20,'Country':'USA'},
        ]

with open('qiye.csv','w') as f:
    f_csv = csv.DictWriter(f,headers)
    f_csv.writeheader()
    f_csv.writerows(rows)

with open('qiye.csv') as f:
    f_csv = csv.reader(f)
    # headers = next(f_csv)
    # print headers
    for row in f_csv:
        print row

通过命名元祖来获取CSV中的单个数据，避免单个索引引起的混淆

from collections import namedtuple
import csv

with open('qiye.csv')  as f:
    f_csv = csv.reader(f)
    headers = next(f_csv)
    Row = namedtuple('Row',headers)
    for r in f_csv:
        row = Row(*r)
        print row.UserName,row.Password
        print row

通过字典列表获取单个数据

import csv
with open('qiye.csv') as f:
    f_csv = csv.DictReader(f)
    for row in f_csv:
        print row.get('UserName'),row.get('Password')

Python爬虫开发与项目实战的例子，没有网站记录一下