擅长:python、mysql、java
<p>这是一种方法。注意-你没有给你的日期字段起一个名字,所以我做了,使它成为有效的json)。在</p>
<pre><code>import json
import csv
import sys
from collections import OrderedDict
index_line = { "index" : { "_index" : "test", "_type" : "_doc", "_id" : "1" } }
with open('input.csv', 'r') as infile, open('outfile.json', 'w+') as outfile:
inreader = csv.reader(infile, delimiter=',', quotechar='"')
for line in inreader:
document = OrderedDict()
document['location'] = line[0]
document['door_activity'] = line[1]
document['date'] = line[2]
json.dump(index_line, outfile)
outfile.write("\n")
json.dump(document, outfile)
outfile.write("\n")
sys.exit()
</code></pre>