python-3.x 我不能使用拆分来分离数据

bogh5gae 于 6个月前发布在 Python

关注(0)|答案(1)|浏览(41)

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
单独的纬度、经度和高度

python-3.x

来源：https://stackoverflow.com/questions/77419157/i-cant-use-split-to-separate-the-data

1条答案

按热度按时间

rm5edbpk1#

试试看：

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

型

赞(0）回复(0）举报 7个月前

我来回答

python-3.x 我不能使用拆分来分离数据

1条答案

相关问题

热门标签

最新问答