| import pandas as pd | |
| import os | |
| URL = "https://docs.google.com/spreadsheets/d/1tAUaQrEHYgRsm1Lvrnj14HFHDwJWl0Bd9x0QePewNco/edit#gid=1977693859" | |
| csv_url = URL.replace('/edit#gid=', '/export?format=csv&gid=') | |
| if os.path.exists("spreadsheet.csv"): | |
| cached_data = pd.read_csv("spreadsheet.csv") | |
| else: | |
| cached_data = pd.read_csv(csv_url) | |
| cached_data.to_csv("spreadsheet.csv", index=False) | |
| models = {} | |
| for url, filename in zip(cached_data['URL'], cached_data['Filename']): | |
| models[filename] = url |