如何从联机源解压缩文件，然后在不保存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