如何从在线源中解压缩文件，然后在不保存在python上的情况下使用它们

Question

url = 'https://ihmecovid19storage.blob.core.windows.net/latest/ihme-covid19.zip'
from io import BytesIO
from zipfile import ZipFile
from urllib.request import urlopen
import pandas as pd
resp = urlopen(url)
zipfile = ZipFile(BytesIO(resp.read()))
print(zipfile.namelist()[-2])
print(zipfile.namelist()[-1])
a = zipfile.open(zipfile.namelist()[-2])
df2  = pd.DataFrame(a)
print(df2)

我被困在阅读部分。当我将"a"转换为数据帧时，它只给我一列。我该如何摆脱它？

Answer 1

您可以使用df2 = pd.read_csv(a)阅读 CSV