python csv文字化けの問題を書く

主にBOMを書きます

import json
import csv

f = open('d:\\brand.json')
data = json.load(f)
f.close()

file = open("d:\\brand.csv", "wb+")
file.write('\xEF\xBB\xBF');
f = csv.writer(file)
# Write CSV Header, If you dont need that, remove this line
f.writerow([u"ID", u"   ", u"   ", u"   ", u"  "])

for x in data:
#    print x.__class__
    print [x["VALUE_ID"][0],
                x["NAME_EN"][0] if x.has_key("NAME_EN") else "", 
                x["NAME_CN"][0] if x.has_key("NAME_CN") else "", 
                x["NAME"][0], 
                x["STATUS"][0] if x.has_key("STATUS") else ""
                ]
    f.writerow([x["VALUE_ID"][0],
                x["NAME_EN"][0] if x.has_key("NAME_EN") else "", 
                x["NAME_CN"][0] if x.has_key("NAME_CN") else "", 
                x["NAME"][0], 
                x["STATUS"][0] if x.has_key("STATUS") else ""
                ])