import simplejson as json
import requests
url = 'https://spreadsheets.google.com/feeds/list/' + "15V7p0YcKunYobOrOhn_VsTdCFKadwrfFy_0pchWCOv4" + '/' + "2" + '/public/values?alt=json'
s = requests.get(url).json()



rows = []
columns = []
responsobj = {}
query = "about_bi"

for i,v in enumerate(s['feed']['entry']):
    entry = s['feed']['entry'][i]
    keys = entry.keys()
    newrow = {}
    queried = False
    for j,vv in enumerate(keys):
        try:
            gsxcheck = vv.index("gsx$")
            if gsxcheck == 0 :
                key = vv
                name  = key[4:]
                print(name)
                content = entry[vv]
                value = content['$t']
                print("###################print values")
                print(value)
                print("#"*20)
                if (value.lower().index(query.lower()) == 0):
                    queried = True
                if (value != None):
                    value = int(value)
                    
                newrow[name] = value
                print("#newrow"*10)
                print(newrow)
                print("#newrow"*10)
            
                if (queried == True): 
                    if (name not in columns):
                        columns[name] = [value]
                    else: 
                        columns[name].append(value)


        except ValueError:
            print("I am in error")
    if(queried == True):
            rows.append(newrow)
            
responsobj['columns'] = columns
responsobj['rows'] = rows
    

url = 'https://spreadsheets.google.com/feeds/list/' + "15V7p0YcKunYobOrOhn_VsTdCFKadwrfFy_0pchWCOv4" + '/' + "2" + '/public/values?alt=json';

s = requests.get(url).json()

for i in s:
    print(i)

for i in s['feed']:
    print(i)