def write_data_to_csv(d):
directory = 'data'
for key,val in d.iteritems():
auth.data_to_csv(
target_dir=directory,
data_to_write=val,
desired_name=key
)
return
k['date_captured'] = last_day
k['season'] = this_league['season']
k['full_name'] = k['name']['full']
k['first_name'] = k['name']['ascii_first']
k['last_name'] = k['name']['ascii_last']
k['image_url'] = k['headshot']['url']
k['eligible_positions'] = k['eligible_positions']['position']
k['selected_position'] = k['selected_position']['position']
if "status" not in k: k["status"] = None
if "starting_status" not in k: k["starting_status"] = None
if "has_player_notes" not in k: k["has_player_notes"] = None
if "has_recent_player_notes" not in k:
k["has_recent_player_notes"] = None
if "on_disabled_list" not in k: k["on_disabled_list"] = None
if "is_editable" not in k: k["is_editable"] = None
k.pop("headshot", None)
k.pop("name", None)
k.pop("editorial_player_key", None)
k.pop("editorial_team_key", None)
rosters.append(k)
#write data
auth.data_to_csv(target_dir="data",
data_to_write=leagues,
desired_name='leagues')
auth.data_to_csv(target_dir="data", data_to_write=teams, desired_name='teams')
auth.data_to_csv(target_dir="data",
data_to_write=rosters,
desired_name='rosters')
if 'error' in p.keys():
print 'errored on:'
print players.iloc[i]
continue
print players.iloc[i]['year']
print p['fantasy_content']['player']['name']['full']
#process the response and pull out some fields
p = p['fantasy_content']['player']
p['full_name'] = p['name']['full']
p['first_name'] = p['name']['first']
p['last_name'] = p['name']['last']
p.pop('name', None)
p['elig_positions'] = p['eligible_positions']['position']
p.pop('eligible_positions', None)
#these fields are inconsistent - don't need them
p.pop("headshot", None)
p.pop("position", None)
p.pop("has_player_notes", None)
p.pop("has_recent_player_notes", None)
p.pop("status", None)
p.pop("on_disabled_list", None)
player_data.append(p)
#write data
auth.data_to_csv(target_dir="data",
data_to_write=player_data,
desired_name='player_data')
print query[i]
p = auth.api_query(y, query[i])
#some players dont exist in a given year. skip them
if 'error' in p.keys():
continue
#just player pos
elig_pos = p['fantasy_content']['player']['eligible_positions']['position']
playerid = p['fantasy_content']['player']['player_id']
#if it's a string, not a list, make it a list
if not hasattr(elig_pos, '__iter__'):
elig_pos = [elig_pos]
for j in range(0, len(elig_pos)):
print j
player_pos.append({'playerid': playerid, 'pos': elig_pos[j]})
p_data = data_prep.process_player_dict(p)
yahoo_resp.append(p_data)
#write data
auth.data_to_csv(
target_dir="data",
data_to_write=yahoo_resp,
desired_name='yahoo_cur_yr'
)
#write data
auth.data_to_csv(
target_dir="data",
data_to_write=player_pos,
desired_name='player_pos'
)
#yahoo session
y = auth.yahoo_session()
prev_auction = pd.read_csv('input/2014_auctioned_players.csv')
query = data_prep.basic_player_req(prev_auction['player_key'])
player_pos = []
for i in range(0, len(query)):
print query[i]
p = auth.api_query(y, query[i])
#some players dont exist in a given year. skip them
if 'error' in p.keys():
continue
#just player pos
elig_pos = p['fantasy_content']['player']['eligible_positions']['position']
playerid = p['fantasy_content']['player']['player_id']
#if it's a string, not a list, make it a list
if not hasattr(elig_pos, '__iter__'):
elig_pos = [elig_pos]
for j in range(0, len(elig_pos)):
print j
player_pos.append({'playerid': playerid, 'pos': elig_pos[j]})
#write data
auth.data_to_csv(
target_dir="data",
data_to_write=player_pos,
desired_name='2014_auction_pos'
)
print query[i]
p = auth.api_query(y, query[i])
#some players dont exist in a given year. skip them
if 'error' in p.keys():
continue
#just player pos
elig_pos = p['fantasy_content']['player']['eligible_positions']['position']
playerid = p['fantasy_content']['player']['player_id']
#if it's a string, not a list, make it a list
if not hasattr(elig_pos, '__iter__'):
elig_pos = [elig_pos]
for j in range(0, len(elig_pos)):
print j
player_pos.append({'playerid': playerid, 'pos': elig_pos[j]})
p_data = data_prep.process_player_dict(p)
yahoo_resp.append(p_data)
#write data
auth.data_to_csv(
target_dir="data",
data_to_write=yahoo_resp,
desired_name='yahoo_cur_yr'
)
#write data
auth.data_to_csv(
target_dir="data",
data_to_write=player_pos,
desired_name='player_pos'
)
#yahoo session
y = auth.yahoo_session()
prev_auction = pd.read_csv('input/2014_auctioned_players.csv')
query = data_prep.basic_player_req(prev_auction['player_key'])
player_pos = []
for i in range(0, len(query)):
print query[i]
p = auth.api_query(y, query[i])
#some players dont exist in a given year. skip them
if 'error' in p.keys():
continue
#just player pos
elig_pos = p['fantasy_content']['player']['eligible_positions']['position']
playerid = p['fantasy_content']['player']['player_id']
#if it's a string, not a list, make it a list
if not hasattr(elig_pos, '__iter__'):
elig_pos = [elig_pos]
for j in range(0, len(elig_pos)):
print j
player_pos.append({'playerid': playerid, 'pos': elig_pos[j]})
#write data
auth.data_to_csv(
target_dir="data",
data_to_write=player_pos,
desired_name='2014_auction_pos'
)
print players.iloc[i]
continue
print players.iloc[i]['year']
print p['fantasy_content']['player']['name']['full']
#process the response and pull out some fields
p = p['fantasy_content']['player']
p['full_name'] = p['name']['full']
p['first_name'] = p['name']['first']
p['last_name'] = p['name']['last']
p.pop('name', None)
p['elig_positions'] = p['eligible_positions']['position']
p.pop('eligible_positions', None)
#these fields are inconsistent - don't need them
p.pop("headshot", None)
p.pop("position", None)
p.pop("has_player_notes", None)
p.pop("has_recent_player_notes", None)
p.pop("status", None)
p.pop("on_disabled_list", None)
player_data.append(p)
#write data
auth.data_to_csv(
target_dir="data",
data_to_write=player_data,
desired_name='player_data'
)
