文本形式如下,具体结果附图,求解:
data=[{"lng":"111.64697372992015","odometer":0,"busSpeed":"0.00","relativeLocation":0,"realTimeStatus":"0","driverUuid":"9d8d234506295047450b0f3094bc650f2d21","posUuid":"a963d44dc54648a18b3e","cursorOverGround":"0","posIsInStation":"","sationName":"","distanceToPrePosition":0,"lineUuid":"fb4962160e28404c170abe30a63783f600a5","drvIcCard":"4044958050","lineType":"0","isOffset":"1","driverName":"张志勇","gatherTime":1506505729000,"allAlarms":"7","busUuid":"6a7beac30a1060406c0ac6509d4fc53029e4","lat":"40.855565926305694","devUuid":"b6c9806a9bf94faea7fd","sationUuid":"‘’}]
两个代码如下:
df=pd.DataFrame(data)
df=pd.read_csv('..txt')