昨天,下面的代码毫无问题地为我提供了数据帧。但今天它开始给我以下错误:
http.client.RemoteDisconnected: Remote end closed connection without response
有解决办法吗?我知道这个问题是从网站,但我需要一些解决方案,可以帮助我继续使用相同的代码
import datetime
import pandas as pd
import sqlalchemy
from datetime import datetime
from datetime import date, timedelta
#d = datetime.today().strftime('%d-%m-%Y')
data_atual=datetime.now()
mes_atual = data_atual.month
ano_atual= data_atual.year
df = []
for j in range (2020, ano_atual+1):
for i in range (9,13):
frame = []
df1 = pd.read_html('https://www.centrodeinformacao.ren.pt/userControls/GetExcel.aspx?T=REN_MENSAL&P='+str(j)+'&PP='+str(i)+'&PPP=26&PPPP=36&PPPPP=0&variation=PT', decimal=',', thousands=',')[0]
df2 = pd.read_html('https://www.centrodeinformacao.ren.pt/userControls/GetExcel.aspx?T=REN_MENSAL&P='+str(j)+'&PP='+str(i)+'&PPP=26&PPPP=36&PPPPP=0&variation=PT', decimal=',', thousands=',')[2]
frame.append(df1)
frame.append(df2)
print(frame)
result = pd.concat(frame)
print(result)
engine = sqlalchemy.create_engine('mysql+pymysql://root:1234@localhost:3306/projeto')
result.to_sql(
name='renmensal'+str(i)+str(j), # database table name
con=engine,
if_exists='replace',
index=False
)
错误在服务器端-有时服务器返回错误。一种解决方法是重复请求直到成功,例如:
印刷品:
相关问题 更多 >
编程相关推荐