<p>你需要<a href="https://pandas.pydata.org/pandas-docs/stable/generated/pandas.read_json.html" rel="nofollow noreferrer">^{<cd1>}</a>。完成下面的示例。你知道吗</p>
<p><strong>设置</strong></p>
<pre><code>import pandas as pd
from io import StringIO
mystr = StringIO("""[{
"lng": "111.68389897298637",
"odometer": 0,
"busSpeed": "0.00",
"relativeLocation": 0,
"realTimeStatus": "0",
"driverUuid": "28b3ea130a6ad049a10b041037e2550d80f5",
"posUuid": "8eba1ae2fd014eaf948b",
"cursorOverGround": "0",
"posIsInStation": "",
"sationName": "",
"distanceToPrePosition": 0,
"lineUuid": "c2e0313000fba04c940a4be0f9edb9c521c8",
"drvIcCard": "3168310624",
"lineType": "0",
"isOffset": "1",
"driverName": "贾爱俊",
"gatherTime": 1506468898000,
"allAlarms": "7",
"busUuid": "9d9648ff0375a04702080cc03a4c20377ea8",
"lat": "40.86856137377131",
"devUuid": "3d16fedb858842199cb3",
"sationUuid": ""
}, {
"lng": "111.68364330061954",
"odometer": 0,
"busSpeed": "11.00",
"relativeLocation": 0,
"realTimeStatus": "0",
"driverUuid": "28b3ea130a6ad049a10b041037e2550d80f5",
"posUuid": "ff42c6cca2e14583b84f",
"cursorOverGround": "280",
"posIsInStation": "",
"sationName": "",
"distanceToPrePosition": 0,
"lineUuid": "c2e0313000fba04c940a4be0f9edb9c521c8",
"drvIcCard": "3168310624",
"lineType": "0",
"isOffset": "1",
"driverName": "贾爱俊",
"gatherTime": 1506468919000,
"allAlarms": "7",
"busUuid": "9d9648ff0375a04702080cc03a4c20377ea8",
"lat": "40.868510932496115",
"devUuid": "3d16fedb858842199cb3",
"sationUuid": ""
}]""")
</code></pre>
<p><strong>解决方案</strong></p>
<pre><code># replace mystr with 'file.txt'
df = pd.read_json(mystr)
</code></pre>
<p><strong>结果</strong></p>
<pre><code>print(df)
allAlarms busSpeed busUuid cursorOverGround \
0 7 0.00 9d9648ff0375a04702080cc03a4c20377ea8 0
1 7 11.00 9d9648ff0375a04702080cc03a4c20377ea8 280
devUuid distanceToPrePosition driverName \
0 3d16fedb858842199cb3 0 贾爱俊
1 3d16fedb858842199cb3 0 贾爱俊
driverUuid drvIcCard gatherTime \
0 28b3ea130a6ad049a10b041037e2550d80f5 3168310624 1506468898000
1 28b3ea130a6ad049a10b041037e2550d80f5 3168310624 1506468919000
... lineType lineUuid \
0 ... 0 c2e0313000fba04c940a4be0f9edb9c521c8
1 ... 0 c2e0313000fba04c940a4be0f9edb9c521c8
lng odometer posIsInStation posUuid \
0 111.68389897298637 0 8eba1ae2fd014eaf948b
1 111.68364330061954 0 ff42c6cca2e14583b84f
realTimeStatus relativeLocation sationName sationUuid
0 0 0
1 0 0
</code></pre>