回答此问题可获得 20 贡献值,回答如果被采纳可获得 50 分。
<p>我想提取json文件的所有值。
例如,我有这个对象,我想得到所有的“文本”值。
我怎么能做到呢?在</p>
<pre><code> list= [
{
"text": "contact solution - COUPON",
"listId": "1",
"id": "4",
"leaf": "true"
},
{
"text": "Falafel (bulk)",
"listId": "1",
"id": "161",
"leaf": "true"
},
{
"text": "brita filters",
"listId": "1",
"id": "166",
"leaf": "false"
}
</code></pre>
<p>输出:</p>
^{pr2}$
<p><strong>更新:</strong></p>
<p>我从CSV文件中获取这些数据。在</p>
<pre><code>text,listId,id,leaf, jsonfile
"1","is","an","example","{ "text": "contact solution - COUPON", "listId": "1", "id": "4","leaf": "true"}"
"2","is","an","example"," { "text": "Falafel (bulk)","listId": "1", "id": "161", "leaf": "true" }"
"3","is","an","example"," { "text": "Falafel (bulk)","listId": "1","id": "161","leaf": "true" }"
"4","is","an","example"," { "text": "brita filters","listId": "1","id": "166","leaf":"false" }"
"5","is","an","example"
"6","is","an","example"
"7","is","an","example"
</code></pre>
<p>使用Pandas,我将列中的项目转换为一个列表。在</p>
<pre><code>with open("data/output.csv", "rb") as csvfile:
df = pd.read_csv(csvfile)
addData = df.Address
listfiels= df.jsonfile
</code></pre>
<p>现在,我想在Json文件中获取一个“text”列表,以这种方式将其存储到另一个Json文件中。
我需要YYY列表,每次选择XXX。在</p>
<pre><code>output = [ {
"type": "User",
"name": {
"status": "Single",
"adress":coordinates
"details": XXXX }
}
for da,coordinates in zip(textData, addData,YYYY )]
</code></pre>
<p>这有意义吗
我用JS做了这个没有问题。在</p>
<pre><code> var globalData = data.map(function(d) {
return JSON.parse(d.Jsonfile);
});
</code></pre>
<p>我可以访问文本字段没有问题。在</p>
<p>更新2:
j=json.loads(列表字段[0])
打印(j[“文本”])</p>
<p>我可以成功打印:“联系解决方案-优惠券”</p>