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)很簡(jiǎn)單的三句話,從一個(gè)網(wǎng)頁(yè),下載股票數(shù)據(jù),并讀取成一個(gè)dataframe.上面的那三句話在我本機(jī)上執(zhí)行,沒(méi)有任何問(wèn)題。我在騰訊云上,每次執(zhí)行都有下面的報(bào)錯(cuò):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有騰訊云的朋友可以測(cè)試一下
請(qǐng)教各位一個(gè)問(wèn)題,求解答:為何這個(gè)語(yǔ)句無(wú)法在騰訊云上運(yùn)行?求大佬指點(diǎn)!
慕尼黑8549860
2019-10-10 16:38:33