回答此问题可获得 20 贡献值,回答如果被采纳可获得 50 分。
<p>我使用以下Python行从特定的<strong>API</strong>读取了数据</p>
<pre><code>import requests
import json
# read all Measurement from one sensor for several days.
r = requests.get('https://wastemanagement.post-iot.lu/measurement/measurements?source=83512 pageSize=1000000000&dateFrom=2019-10-26&dateTo=2019-10-28', auth=('xxxxx', 'xxxxx'))
text=r.text # data is stored in json format
</code></pre>
<p><strong>这是一个输出示例,但实际输出包含几行:</strong>
实际输出可以从这里下载<a href="https://filebin.net/c0cxryxe6rjspqxf" rel="nofollow noreferrer">actual output</a></p>
<pre><code>enter code here
Valid JSON (RFC 8259)
Formatted JSON Data
{
"next":"https://wastemanagement.post-iot.lu/measurement/measurements?dateTo=2019-10-28&
pageSize=2000&source=83512&dateFrom=2019-10-26&currentPage=2",
"self":"https://wastemanagement.post-iot.lu/measurement/measurements?dateTo=2019-10-28&
pageSize=2000&source=83512&dateFrom=2019-10-26&currentPage=1",
"statistics":{
"totalPages":null,
"currentPage":1,
"pageSize":2000
},
"measurements":[
{
"self":"https://wastemanagement.post-iot.lu/measurement/measurements/108451",
"time":"2019-10-26T00:00:06.494Z",
"id":"108451",
"source":{
"self":"https://wastemanagement.post-iot.lu/inventory/managedObjects/83512",
"id":"83512"
},
"type":"c8y_Measurement",
"battery":{
"percent":{
"unit":"%",
"value":98
}
}
},
{
"self":"https://wastemanagement.post-iot.lu/measurement/measurements/108452",
"time":"2019-10-26T00:00:06.538Z",
"id":"108452",
"source":{
"self":"https://wastemanagement.post-iot.lu/inventory/managedObjects/83512",
"id":"83512"
},
"type":"TemperatureMeasurement",
"c8y_TemperatureMeasurement":{
"T":{
"unit":"C",
"value":23
}
}
},
{
"self":"https://wastemanagement.post-iot.lu/measurement/measurements/108537",
"time":"2019-10-26T00:00:06.577Z",
"id":"108537",
"source":{
"self":"https://wastemanagement.post-iot.lu/inventory/managedObjects/83512",
"id":"83512"
},
"type":"c8y_Measurement",
"c8y_DistanceMeasurement":{
"distance":{
"unit":"cm",
"value":21
}
}
},
</code></pre>
<p>所附图像显示(文本)中的输出
<a href="https://i.stack.imgur.com/idPw0.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/idPw0.png" alt="enter image description here"/></a></p>
<p>我尝试使用以下代码将<strong>JSON</strong>格式(存储在文本中)转换为<strong>pandas DataFrame</strong>,但没有成功</p>
<pre><code>data = json.loads(text)
</code></pre>
<p>我想把JSON格式转换成pandas DataFrame,这个DataFrame应该包含<strong>五列(id、battery、T或Temperature、time和distance)和<strong>几行<strong></p>
<p><a href="https://i.stack.imgur.com/8wgQR.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/8wgQR.png" alt="enter image description here"/></a></p>