csv_to_json.py

#!/usr/bin/python
# coding: utf-8

import csv
import json
import sys

if  __name__ == "__main__":
    # execel 导出后带有^M符号 换行符号 'rU' U通用换行符
    with open(sys.argv[1],'rU') as fd:
        line = csv.reader(fd,delimiter=',')
        collection = dict()
        for x in line:
            data = dict()
            profile = dict()
            data['home_subway'] = x[9]
            data['company_subway'] = x[10]
            profile['gender'] = x[2]
            profile['hometown'] = x[13]
            profile['edu_year'] = x[3]
            profile['edu_department'] = x[4]
            profile['edu_major'] = x[5]
            profile['job_company'] = x[6]
            profile['job_position'] = x[8]
            profile['qq'] = x[12]
            profile['phone'] = x[11]
            data['profile'] = profile
            name_key = str(x[0]+'-'+x[1])
            collection[name_key] = data
        #要输出中文需要指定ensure_ascii参数为False
        print json.dumps(collection,ensure_ascii=False,indent=2)