我正在尝试下载一个csv文件并使用python3进行自定义。你知道吗
from urllib import request
google_url= "https://query1.finance.yahoo.com/v7/finance/download/GOOG?period1=1510328010&period2=1512920010&interval=1d&events=history&crumb=IpXue1sAr6r"
def download_stock_data (csv_url):
response = request.urlopen (csv_url)
csv = response.read()
csv_str = str(csv)
lines = csv_str.split("\\n")
dest_url = r'goog.csv'
fx = open(dest_url, "w")
for line in lines:
fx.write(line + "\n")
fx.close()
download_stock_data (google_url)
C:\Users\ihsan.iyigun\AppData\Local\Programs\Python\Python36\python.exe C:/Users/ihsan.iyigun/PycharmProjects/untitled3/new.py
Traceback (most recent call last):
File "C:/Users/ihsan.iyigun/PycharmProjects/untitled3/new.py", line 17, in <module>
download_stock_data (google_url)
File "C:/Users/ihsan.iyigun/PycharmProjects/untitled3/new.py", line 6, in download_stock_data
response = request.urlopen (csv_url)
File "C:\Users\ihsan.iyigun\AppData\Local\Programs\Python\Python36\lib\urllib\request.py", line 223, in urlopen
return opener.open(url, data, timeout)
File "C:\Users\ihsan.iyigun\AppData\Local\Programs\Python\Python36\lib\urllib\request.py", line 532, in open
response = meth(req, response)
File "C:\Users\ihsan.iyigun\AppData\Local\Programs\Python\Python36\lib\urllib\request.py", line 642, in http_response
'http', request, response, code, msg, hdrs)
File "C:\Users\ihsan.iyigun\AppData\Local\Programs\Python\Python36\lib\urllib\request.py", line 570, in error
return self._call_chain(*args)
File "C:\Users\ihsan.iyigun\AppData\Local\Programs\Python\Python36\lib\urllib\request.py", line 504, in _call_chain
result = func(*args)
File "C:\Users\ihsan.iyigun\AppData\Local\Programs\Python\Python36\lib\urllib\request.py", line 650, in http_error_default
raise HTTPError(req.full_url, code, msg, hdrs, fp)
urllib.error.HTTPError: HTTP Error 401: Unauthorized
Process finished with exit code 1
如何调试或修复此问题?你知道吗
在我看来,您尝试访问的网页需要身份验证。如果是这样的话,在转到所需的页面之前,您必须弄清楚如何以编程方式登录到该站点。你知道吗
尝试手动转到该URL时,我的浏览器中出现以下内容:
首先下载您的CSV文件并将其放在我的计算机上的本地驱动器上,然后转到运行这些代码以加载您的CSV文件:
然后按以下命令打开cmd->
现在你可以得到结果了。你知道吗
相关问题 更多 >
编程相关推荐