headers = ["team1", "team1_id", "team2", "team2_id", "win_toss", "bat_or_bowl", "outcome", "win_game", "date", "day_n_night", "ground", "rain", "duckworth_lewis", "match_id", "type_of_match", "match_type_id", "home_team_id", "umpire_1_id", "umpire_1_name", "umpire_1_country", "umpire_2_id", "umpire_2_name", "umpire_2_country", "tv_umpire_id", "tv_umpire_name", "tv_umpire_country", "referree_id", "referee_name", "referee_country", "url"]
matches = simplejson.loads(open('all_matches.json').read())
matches = list(set(matches)) # dedupe
##################################START PROCESSING DATA#########################################
with open("final_output.csv", "wb") as csvfile:
writer = csv.writer(csvfile)
writer.writerow(headers)
for match in matches:
time.sleep(1)
try:
m = Match(int(match))
if m.match_json()['match_status'] == 'forthcoming':
continue
if m.result() == '':
continue
if m.rain_rule() == 'D/L method':
duckworth_lewis = 1
else:
duckworth_lewis = 0
try:
m.team_2()['team_name']
except KeyError:
continue
try:
m.team_1()['team_name']
except KeyError:
continue
if m.match_json()['international_class_card'] != "":
match_type_id = m.match_json()['international_class_id']
]
matches = simplejson.loads(open('all_matches.json').read())
matches = list(set(matches)) # dedupe
##################################START PROCESSING DATA#########################################
with open("final_output.csv", "wb") as csvfile:
writer = csv.writer(csvfile)
writer.writerow(headers)
for match in matches:
time.sleep(1)
try:
m = Match(int(match))
if m.match_json()['match_status'] == 'forthcoming':
continue
if m.result() == '':
continue
if m.rain_rule() == 'D/L method':
duckworth_lewis = 1
else:
duckworth_lewis = 0
try:
m.team_2()['team_name']
except KeyError:
continue
try:
m.team_1()['team_name']
except KeyError:
continue
if m.match_json()['international_class_card'] != "":
match_type_id = m.match_json()['international_class_id']
