Python Forum
Make a table from a json output
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Make a table from a json output
#11
(Jan-01-2019, 09:42 PM)snippsat Wrote: ...

Thx for input. Im using pycharm. From what i understand VS code is just another editor

Im still in doubt how i add columns and how to sum up 2 columns to the new one.

/ Carsten
Reply
#12
(Jan-04-2019, 08:58 PM)carstenlp Wrote: Thx for input. Im using pycharm. From what i understand VS code is just another editor
Sure,but in my option the best multilanguage editor out there and take how Python work in editor more seriously than others.

(Jan-04-2019, 08:58 PM)carstenlp Wrote: Im still in doubt how i add columns and how to sum up 2 columns to the new one.
Like this.
import pandas as pd
pd.set_option('display.max_columns', None)

d = {
    'date': [20110911, 20110918],
    'day': ['Sunday', 'Sunday'],
    'line': [2.0, 6.0],
    'o:points': [12, 30],
    'o:team': ['Falcons', 'Saints'],
    'points': [30, 13],
    'season': [2011, 2011],
    'site': ['home', 'away'],
    'team': ['Bears', 'Bears'],
    'total': [40.5, 47.0],
    'week': [1, 2]
}

df = pd.DataFrame.from_dict(d)
df['total_points'] = df['o:points'] + df['points']  # assigned to a new column
print(df)
Will add a new column.
Output:
week total_points 0 1 42 1 2 43
Sum it all up:
df['total_points'].sum()
85
Reply
#13
(Jan-04-2019, 10:37 PM)snippsat Wrote: ...

Thanks snippsat. Dance
Reply
#14
Hi

I got the added column now, that returns true/false wether the points is larger than o:points.
I have then added to it change the true/false to 1/0 so i get a integer back.

If points == o:points i want it to return 0.5 instead. How do i do that ?

I have added just part for the code. Hope its enough for it to make sense.
I have added the 2nd line (df['SUresult'] = df['points'] == df['o:points'])
That returns the true if points=o:points and the match is a draw. How can i change that true to 0.5 and how do i set up if so it will continue if its not a draw game.

df = pd.DataFrame.from_dict(d)
    df['SUresult'] = df['points'] == df['o:points']
    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
Thanks

/ Carsten
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  write json into a table herobpv 4 1,424 Jan-22-2023, 04:36 AM
Last Post: herobpv
  Convert Json to table format python_student 2 5,051 Sep-28-2022, 12:48 PM
Last Post: python_student
  geojson to json --missing multiple row output yoshi 9 2,643 Mar-06-2022, 08:34 PM
Last Post: snippsat
  Python script to summarize excel tables, then output a composite table? i'm a total n surfer349 1 2,289 Feb-05-2021, 04:37 PM
Last Post: nilamo
  sports Stats > table output loop problems paulfearn100 3 2,444 Jul-22-2020, 03:21 AM
Last Post: c_rutherford
  Save output into a Excel Sheet with Format Table skaailet 1 2,455 Apr-17-2020, 11:56 PM
Last Post: thirteendec
  json.dumps list output qurr 12 5,063 Apr-08-2020, 10:13 PM
Last Post: micseydel
  json.dumps output error in python3 prayuktibid 2 2,608 Jan-21-2020, 06:41 AM
Last Post: prayuktibid
  Output to a json file problem Netcode 3 3,658 Nov-22-2019, 01:44 AM
Last Post: Skaperen
  Problem Table Output Phil 4 2,572 May-19-2019, 12:17 PM
Last Post: Phil

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020