Python3.x 我不能使用拆分来分隔数据

发布于11月04日

sas_url = 'https://telemetria2023.blob.core.windows.net/geolocalizacao/edbaa694-0988-4b38-b45f-10835fc2272f/29/2023/11/02/22/30/66jaxcmrz4gwy'
geo = pd.read_json(sas_url)
geo = pd.DataFrame.from_dict(geo)

geo[["alt", "lat", "lon"]] = (geo["telemetry"].str.split(": ", expand=True))

ValueError:列的长度必须与键相同

enter image description here个

分开纬度、经度和海拔

推荐答案

try :

import pandas as pd

sas_url = "https://telemetria2023.blob.core.windows.net/geolocalizacao/edbaa694-0988-4b38-b45f-10835fc2272f/29/2023/11/02/22/30/66jaxcmrz4gwy"
geo = pd.read_json(sas_url)

geo = pd.concat([geo, geo.pop("telemetry").apply(pd.Series)], axis=1)
print(geo)

打印:

                                    applicationId component                       deviceId              enqueuedTime  enrichments  messageProperties messageSource      schema                  templateId   alt       lat        lon
geolocation  edbaa694-0988-4b38-b45f-10835fc2272f   sensors  my-phone-as-device-4pGmUfiEco  2023-11-02T22:30:04.955Z          NaN                NaN     telemetry  default@v1  dtmi:azureiot:q9ecxa3st4ir  28.4 -3.820995 -38.556383