import requests
import json
import pandas as pd
url = "http://api.sportsdatabase.com/nfl/query.json"
sdql = "date,day,week,season,team,o:team,site,points,o:points,line,total,OT@"
query = "season = 2018 and team = Browns and week < 6"
output = ''"json"''
api_key = ''"guest"''
string = sdql+query
querystring = {"sdql":string,"output":output,"api_key":api_key}
payload = ""
headers = {'User-Agent': 'curl/7.58.0',
'Accept': '*/*'}
response = requests.request("GET", url, data=payload, headers=headers, params=querystring)
temp = response.text[14:-3].replace("\t", "")
temp = temp.replace("\'", "\"""")
data = json.loads(temp)
d = data
record = {}
for i in zip(d['headers'], d['groups'][0]['columns']):
record[i[0]] = i[1]
d = record
pd.set_option('display.max_columns', None)
df = pd.DataFrame.from_dict(d)
df['SUresult'] = df['points'] > df['o:points'] # Add Straight Up results Column and see if team Won SU
df['SUresult'] = df['SUresult'].astype(int) # Change the Dataframe boolan to interger 0 or 1
df