擅长:python、mysql、java
<p>下面是Python pandas包的版本:</p>
<pre><code>import json
import pandas as pd
in_file = '/Elastic Search/Converted Detection/Converted CSV'
out_file = '/Elastic Search/Converted Detection/Converted JSON'
index_line = '{"index": {"_index": "test", "_type": "_doc", "_id": "1"}}\n'
</code></pre>
<p>阅读:</p>
^{pr2}$
<p>或直接从字符串:</p>
<pre><code>text = "L1-CR109 Security Counter,has been forced,2019-02-26\n"*4
df = pd.read_csv(StringIO(text),header=None)
</code></pre>
<p>现在编写所需的格式(请注意,我添加了“date”,因此它是一个有效的JSON):</p>
<pre><code>with open('outfile.json', 'w+') as outfile:
for row in df.to_dict('records'):
data = json.dumps(dict(list(zip(title,row.values()))))
outfile.write(index_line+data)
</code></pre>