def getSheets(s_id, s_key): global sheets_url, sheets_tab, sheets_tab_name try: sheets_url = os.environ['sheets_url'] except Exception as e: print("\"sheets_url\" not set as an environ, the default url \"" + str(sheets_url) + "\" will be used.") try: sheets_tab = int(os.environ['sheets_tab']) except Exception as e: print("\"sheets_tab\" not set as an environ, the default tab \"" + str(sheets_tab) + "\" will be used.") sheets = Sheets.from_developer_key(s_key) s = sheets.get(sheets_url) print("Sheet loaded: " + str(s)) print(s.sheets[sheets_tab]) print("monday sample: " + s.sheets[sheets_tab]['B' + str(sheet_split_num_start)]) sheets_tab_name = str(s.sheets[sheets_tab]) return s
import pandas as pd from gsheets import Sheets import json import numpy as np import sys import os data = sys.argv[1] sheets = Sheets.from_developer_key(data) joss_reviews_id = '1PAPRJ63yq9aPC1COLjaQp8mHmEq3rZUzwUYxTulyu78' s = sheets[joss_reviews_id] s.sheets[0].to_csv('test.csv') joss_table = pd.read_csv('test.csv') my_username = '******' review_col = 'Review count(all time)' num_reviews = int( joss_table[joss_table.username == my_username][review_col].values[0]) np.savetxt('../data/num_joss_reviews.txt', [num_reviews])