回答此问题可获得 20 贡献值,回答如果被采纳可获得 50 分。
<p>我需要找到一种将json文件中的数据解析为csv或xlsx的方法。
但是,<strong>我在线使用的每个</strong>JSON验证器都会给我一个错误,说JSON文件无效。在</p>
<p>JSON文件示例如下:</p>
<pre><code>{"id": "someID1.docx",
"language": {"detected": "cs"},
"title": "Name - Title - FileName",
"text": "Long string of text",
"entities": [
{"standardForm": "Svářečský průkaz", "type": "car"},
{"standardForm": "email1@gmail.com", "type": "email"},
{"standardForm": "english", "type": "languages"},
{"standardForm": "Práce na PC", "type": "abilities"},
{"standardForm": "MS Office", "type": "abilities"},
{"standardForm": "Automechanik", "type": "education"},
{"standardForm": "Střední průmyslová škola", "type": "education"},
{"standardForm": "Angličtina-Němčina", "type": "languages"},
{"standardForm": "mechanic", "type": "position"},
{"standardForm": "Praha", "type": "region"},
{"standardForm": "B2 - středně pokročilý", "type": "en_level"},
{"standardForm": "Skupina B", "type": "drivinglicense"}
]}
{"id": "someID2.pdf",
"language": {"detected": "cs"},
"title": "Name - Title - FileName2",
"text": "Long string of text2",
"entities": [
{"standardForm": "german", "type": "languages"},
{"standardForm": "high school", "type": "education"},
{"standardForm": "Angličtina-Němčina", "type": "languages"},
{"standardForm": "driver", "type": "position"},
{"standardForm": "english", "type": "languages"},
{"standardForm": "university", "type": "education"},
{"standardForm": "email2@seznam.cz", "type": "email"},
{"standardForm": "Středočeský", "type": "region"},
{"standardForm": "Střední", "type": "edulevel"},
{"standardForm": "manager", "type": "lastposition"},
{"standardForm": "? – nerozpoznáno", "type": "de_level"},
{"standardForm": "? – nerozpoznáno", "type": "en_level"},
{"standardForm": "Skupina C", "type": "drivinglicense"}
]}
...
</code></pre>
<p>我可以用Python加载这个JSON:</p>
^{pr2}$
<p>但我无法将其转换成csv。我需要能够存储所有与所有id相关的实体,最好是csv。有什么办法吗?我需要JSON不同吗?在</p>
<p>谢谢</p>
<p>编辑:
我需要上面例子的csv输出如下:</p>
<pre><code>ID;title;languages;education
someID1.docx;Name-Title-FileName;english,Angličtina-Němčina;Automechanik;Střední Prům. škola
seomeID2.pdf;Name-Title-FileName2; german,Angličtina-Němčina,english;high school, university
</code></pre>