How to unzip files from an online source and then use them without saving on 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)

I'm stuck on reading part. When I convert the "a" to a dataframe, it gives me just one column. How do I get rid of this?

see: https://stackoverflow.com/a/10909949/11728401 – Mensch Jul 07 '20 at 13:21 — Mensch, Jul 07 '20 at 13:21

score 1 · Accepted Answer · answered Jul 07 '20 at 14:13

1

You can read the CSV with df2 = pd.read_csv(a)

answered Jul 07 '20 at 14:13

rbanffy

2,319
1
16
27

How to unzip files from an online source and then use them without saving on python

1 Answers1