从HTTP响应到csv

Question

我需要将数据从URL导出到csv，这段代码有效，但位于该URL上的数据写入一个没有分隔符的字符串，如何解决？

import urllib
import pandas as pd
URL="https://www.star.nesdis.noaa.gov/smcd/emb/vci/NPP_VH/4km/ts_L1_v1/ByWeek/VHP_L1_Mean_198135.txt"
vhi_url = urllib.request.urlopen(URL)
out = open('vhi_id_16.csv','wb')
out.write(vhi_url.read())
out.close()

Answer 1

使用代码的这个细微变化：

from urllib import request
with open('vhi_id_16.csv', 'w') as out:
with request.urlopen('PUT_URL_HERE') as response:
encoding = response.headers.get_content_charset('utf-8')
out.write(response.read().decode(encoding))
out.close()