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 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' )