File size: 503 Bytes
474c69d
 
 
 
 
 
 
 
 
 
 
 
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
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