change a json array into a 2d array

Question

So i have a Json file like this:

{"matches_details": [{"MatchID": "Liverpool-Manchester United", "Date": "17/12/2020", "Time": "16:00", "Score": "5-0", "Yellow cards": "2", "Red cards": "1", "State": "FT"}, {"MatchID": "Crystal Palace-Chelsea", "Date": "20/1/2021", "Time": "11:00", "Score": "10-0", "Yellow cards": "10", "Red cards": "20", "State": "HT"}]}

The way to print out all the array is:

f = open('datngu.json',)
    data = json.load(f)
    for i in data['matches_details']:
        print(i)

    f.close()

And the way to print a single one:

print(data['matches_details']['MatchID'])

So how can i change it into a 2d array with row,col format, because i need to insert these data into a pyqt5 qtTableWidgetItem UI

stackoverflow.com/questions/48687857/…

aSaffary
– aSaffary

2021-04-27 07:18:53 +00:00
Commented Apr 27, 2021 at 7:18 — aSaffary
– aSaffary, Commented Apr 27, 2021 at 7:18

GabrielP · Accepted Answer · 2021-04-27 07:27:05Z

1

You can try the following if you would like to have it as a pd.DataFrame():

import pandas as pd

values = {"matches_details": [{"MatchID": "Liverpool-Manchester United", "Date": "17/12/2020", "Time": "16:00", "Score": "5-0", "Yellow cards": "2", "Red cards": "1", "State": "FT"}, {"MatchID": "Crystal Palace-Chelsea", "Date": "20/1/2021", "Time": "11:00", "Score": "10-0", "Yellow cards": "10", "Red cards": "20", "State": "HT"}]}

df_table = pd.DataFrame(values['matches_details'])

If you prefer it as a numpy 2D-array, just do the following:

arr_2d = df_table.values

edited Apr 27, 2021 at 7:27

answered Apr 27, 2021 at 7:20

GabrielP

7824 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Senze Over a year ago

so what is the 1st follwing about

GabrielP Over a year ago

The first part helps you to put the json in a DataFrame format (a table).

Learner · Accepted Answer · 2021-04-27 07:26:24Z

0

You can try to use numpy as follows:

m = np.zeros((len(match_details_json), 7))
for i, elem in enumerate(match_details_json):
    m[i,0] = elem['MatchID']
    m[i,1] = elem['Date']
    m[i,2] = elem['Time']
    m[i,3] = elem['Score']
    m[i,4] = elem['Yellow cards']
    m[i,5] = elem['Red cards']
    m[i,5] = elem['State']

answered Apr 27, 2021 at 7:26

Learner

212 bronze badges

2 Comments

Senze Over a year ago

what is 'match_details_json'?

Learner Over a year ago

This will be the json string that you want to convert to array

Collectives™ on Stack Overflow

change a json array into a 2d array

2 Answers 2

2 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related