擅长:python、mysql、java
<p>您可以创建JSON模板并向其发送数据:</p>
<pre class="lang-py prettyprint-override"><code>d = """{
"Ord" : "%s",
"MOT" : "%s",
"MVT" : "%s",
"CUST" : "%s",
"milestone" : {
"creation" : {
"sla" : "%s",
"plan" : "%s",
"proposed" : "%s"
},
"Pickup" : {
"sla" : "%s",
"plan" : "%s",
"proposed" : "%s"
}
}
}
"""
js = []
for item in df.values:
js.append(json.loads(d%tuple(item.tolist())))
print(json.dumps(js))
</code></pre>
<h2>输出:</h2>
<pre><code>[{"Ord": "a", "MOT": "TR", "MVT": "TT", "CUST": "DEA", "milestone": {"creation": {"sla": "12-3-2020", "plan": "12-3-2020", "proposed": "12-3-2020"}, "Pickup": {"sla": "14-3-2020", "plan": "14-3-2020", "proposed": "14-3-2020"}}}, {"Ord": "b", "MOT": "ZR", "MVT": "TD", "CUST": "DET", "milestone": {"creation": {"sla": "15-3-2020", "plan": "15-3-2020", "proposed": "15-3-2020"}, "Pickup": {"sla": "16-3-2020", "plan": "16-3-2020", "proposed": "16-3-2020"}}}]
</code></pre>