RVC_PlayGround / tools /useftools.py
Rejekts's picture
Upload useftools.py
474c69d verified
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