I have this JSON file containing a wealth of information about football players and I am trying to convert it into a .csv format. However, as a beginner in this field, I am facing some challenges!
You can access the raw data file at: https://raw.githubusercontent.com/llimllib/fantasypl_stats/8ba3e796fc3e73c43921da44d4344c08ce1d7031/data/players.1440000356.json
Previously, I used the code below to extract data from the JSON file into a .csv using Python script via command prompt:
import csv
import json
json_data = open("file.json")
data = json.load(json_data)
f = csv.writer(open("fix_hists.csv","wb+"))
arr = []
for i in data:
fh = data[i]["fixture_history"]
array = fh["all"]
for j in array:
try:
j.insert(0,str(data[i]["first_name"]))
except:
j.insert(0,'error')
try:
j.insert(1,data[i]["web_name"])
except:
j.insert(1,'error')
try:
f.writerow(j)
except:
f.writerow(['error','error'])
json_data.close()
Unfortunately, running this code now results in an error message:
Traceback (most recent call last): <br/>
File "fix_hist.py", line 12 (module) <br/>
fh = data[i]["fixture_history"] <br/>
TypeError: list indices must be integers, not str
Is there a way to resolve this issue or perhaps another method to extract specific data such as 'Fixture History', 'First Name', and 'Web Name' into a .csv file?