tbl 20200308 01

lobsters.py

from tbl import *

pets_url = "https://docs.google.com/spreadsheets/d/e/2PACX-1vSK2rd47ogfI2CpQi2L6HDo9AOEhnhqBN4zR4kLPUO28vBzmlc8XQWrvTfBYCU0ePf478yxcNKdOy5m/pub?gid=0&single=true&output=csv"
pets_tbl = tbl_from_sheet(pets_url)

tbl.py

import csv
import requests

def tbl_from_sheet(csv_url):
  with requests.Session() as s:
    download = s.get(csv_url)
    content = download.content.decode('utf-8')
    reader = csv.reader(content.splitlines(), delimiter=',')
    for row in list(reader):
      print (row)