csv2json

2.csv

csv2json

#! /usr/bin/env python2.7
#coding=utf-8
import csv
import json
import io
import os

if __name__ == '__main__':
    filenames = '2.csv'
    collum_names = ['id' ,'long','high','isLiuhai','liuhaiType','maweiType','pianfen','fajibianyuan','fajidingbu','toufaquzhi']
    rows = []
    json_data = {}
    with open(filenames, 'rb') as csvfile:
        spamreader = csv.reader(csvfile, delimiter=',', quotechar='|')
        for row in spamreader:
            rows.append(row)

    for row in rows:
        row_dict = {}
        row_id = row[0]
        for i in xrange(1, len(collum_names)):
            collum_key = collum_names[i]
            row_dict[collum_key] = row[i]
        json_data[row_id] = row_dict


    base_name = os.path.basename(filenames)
    base_name = os.path.splitext(base_name)[0]
    output_json_name = base_name + ".json"
    a = [{'name':1, 'child' : [{'name': 11, 'child': [{'name': 111, 'child': ['empty']}, {'name':112, 'child': ['empty']}]}, {'name':22, 'child': ['empty']}]}]
    print json.dumps(a, indent=4)
    #print json.dumps(json_data, indent=4)
    with io.open(output_json_name, 'w', encoding='utf-8') as f:
        f.write(json.dumps(json_data, indent=4, ensure_ascii=False).decode('utf-8'))