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])