importpandasaspdurl_all="https://sc.hkex.com.hk/TuniS/www.hkex.com.hk/chi/services/trading/securities/securitieslists/ListOfSecurities_c.xlsx"stocks=pd.read_excel(url_all,skiprows=2,dtype=str)很簡單的三句話,從一個網(wǎng)頁,下載股票數(shù)據(jù),并讀取成一個dataframe.上面的那三句話在我本機上執(zhí)行,沒有任何問題。我在騰訊云上,每次執(zhí)行都有下面的報錯:Traceback(mostrecentcalllast):File"",line1,inFile"/usr/local/lib/python3.7/site-packages/pandas/util/_decorators.py",line188,inwrapperreturnfunc(*args,**kwargs)File"/usr/local/lib/python3.7/site-packages/pandas/util/_decorators.py",line188,inwrapperreturnfunc(*args,**kwargs)File"/usr/local/lib/python3.7/site-packages/pandas/io/excel.py",line350,inread_excelio=ExcelFile(io,engine=engine)File"/usr/local/lib/python3.7/site-packages/pandas/io/excel.py",line653,in__init__self._reader=self._engines[engine](self._io)File"/usr/local/lib/python3.7/site-packages/pandas/io/excel.py",line421,in__init__data=filepath_or_buffer.read()File"/usr/local/lib/python3.7/http/client.py",line460,inreads=self._safe_read(self.length)File"/usr/local/lib/python3.7/http/client.py",line610,in_safe_readchunk=self.fp.read(min(amt,MAXAMOUNT))File"/usr/local/lib/python3.7/socket.py",line589,inreadintoreturnself._sock.recv_into(b)File"/usr/local/lib/python3.7/ssl.py",line1049,inrecv_intoreturnself.read(nbytes,buffer)File"/usr/local/lib/python3.7/ssl.py",line908,inreadreturnself._sslobj.read(len,buffer)ConnectionResetError:[Errno104]Connectionresetbypeer有騰訊云的朋友可以測試一下
有大佬遇到過這個問題嗎:為何這個語句無法在騰訊云上運行?求解答!
繁華開滿天機
2019-10-08 09:22:24