New 504 Gateway Time-out error? #57
Unanswered
emilydegrey
asked this question in
Q&A
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
I've been using this script since October 2021, and it has been a game changer for our community for making and communicating decisions related to COVID-19! Recently started getting a 504 Gateway Time-out error. Any ideas on how to get this working again?
from tableauscraper import TableauScraper as TS
import pandas as pd
#Get Ada County Daily Case Data
url = "https://public.tableau.com/views/DPHIdahoCOVID-19Dashboard/HotSpots"
ts = TS()
ts.loads(url)
#show original data for worksheet
ws = ts.getWorksheet("ReportDate(EPIDATE)")
#Get data as CSV
wb = ts.getWorkbook()
caseDataCSV = wb.getCsvData(sheetName="ReportDate(EPIDATE)")
#Select only Ada County Data
adaCaseDataCSV = caseDataCSV[caseDataCSV['County1'] == 'Ada']
#Group by date to get a daily count (not every record)
adaDailyCases = adaCaseDataCSV.groupby("Epidate")["Number of Records"].sum()
adaDailyCases.to_csv('//datamart/COVIDDashboards/scrapedData/AdaDailyCases.csv')
Beta Was this translation helpful? Give feedback.
All reactions