Jan-16-2019, 09:44 AM
Hi everyone
I got a bit further on my project that i got some help to in here: https://python-forum.io/Thread-Make-a-ta...son-output
Now i got my head bumped into the wall with the next set of task, so hope i can be guided in the right direction again in here :)
Not necessary to do the task in this order. All help is appreciated. I just have a small playbook with the stuff i would like to have, and ideas i come up with along the way. Then im sure im getting there at some point :)
What im trying to do is make it look a bit like the attached picture (not 100% like it, but some of it), it was just a api project that was interesting for me to begin with, and try and do my self. :) Since i will both work on api, and learn python. And learn a lot of stuff i can use for other projects.
Task1: I Want to make the tables easier to read. With all columns next to each other and results center aligned.
Task1.1: I want to put the table to some web output, so i got it in my localhost browser. (I have no idea how im going to do this, since i know nothing about it, but if its easier to just let it be as is, and then make it look pretty in browser i can live with that solution)
Task2: I got the extra columns added (SUresults) where i get return True/False, and then i have changed that to 1/0 instead. But what if the game ends draw. As it does in the first one 21-21. Then i want it to return 0.5 instead of the True(1)/False(0). How is that done ?
Task3: Add a new table to the program that looks at the SUresults column and give me output (in this case) 2-2-1 (for 2wins, 2loss, 1push) and also an output with the hit%. So it returns 40% wins in this case.
Got a few more task, but thats problably for a new thread later on. Think there is enough here to confuse, and enough i need to learn :)
The code:
I got a bit further on my project that i got some help to in here: https://python-forum.io/Thread-Make-a-ta...son-output
Now i got my head bumped into the wall with the next set of task, so hope i can be guided in the right direction again in here :)
Not necessary to do the task in this order. All help is appreciated. I just have a small playbook with the stuff i would like to have, and ideas i come up with along the way. Then im sure im getting there at some point :)
What im trying to do is make it look a bit like the attached picture (not 100% like it, but some of it), it was just a api project that was interesting for me to begin with, and try and do my self. :) Since i will both work on api, and learn python. And learn a lot of stuff i can use for other projects.
Task1: I Want to make the tables easier to read. With all columns next to each other and results center aligned.
Task1.1: I want to put the table to some web output, so i got it in my localhost browser. (I have no idea how im going to do this, since i know nothing about it, but if its easier to just let it be as is, and then make it look pretty in browser i can live with that solution)
Task2: I got the extra columns added (SUresults) where i get return True/False, and then i have changed that to 1/0 instead. But what if the game ends draw. As it does in the first one 21-21. Then i want it to return 0.5 instead of the True(1)/False(0). How is that done ?
Task3: Add a new table to the program that looks at the SUresults column and give me output (in this case) 2-2-1 (for 2wins, 2loss, 1push) and also an output with the hit%. So it returns 40% wins in this case.
Got a few more task, but thats problably for a new thread later on. Think there is enough here to confuse, and enough i need to learn :)
The code:
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
print(df)The Output:date day week season team o:team site points o:points \ 0 20180909 Sunday 1 2018 Browns Steelers home 21 21 1 20180916 Sunday 2 2018 Browns Saints away 18 21 2 20180920 Thursday 3 2018 Browns Jets home 21 17 3 20180930 Sunday 4 2018 Browns Raiders away 42 45 4 20181007 Sunday 5 2018 Browns Ravens home 12 9 line total OT SUresult 0 4.0 41.0 1 0 1 9.0 49.0 0 0 2 -3.0 39.5 0 1 3 2.5 45.0 1 0 4 2.5 45.5 1 1 Process finished with exit code 0Thanks all
![[Image: d4RUGP.jpg]](https://imageshack.com/a/img924/3342/d4RUGP.jpg)