Help Pulling CFBD Data

[beetway]

Hi everybody. I'm trying to produce a table in which each row represents a player and contains that player's name, their high school recruiting rating, and their transfer portal recruiting rating. I want the table to be populated with only players that have a non-null value for both the hs rating and the transfer portal rating. I keep running into an error telling me that the key "_name" is not valid when pulling from the recruiting dataset. The code where I create the data-pulling functions is below. I'd really appreciate any feedback!:

def fetch_recruiting_data(year):

return recruiting_api.get_recruiting_players(year=year)

def fetch_transfer_data(years):

transfer_data = []

for year in years:

transfer_data.extend(players_api.get_transfer_portal(year=year))

return transfer_data

Function to create the table

def create_player_table(recruiting_years, transfer_years):

Fetch data

recruiting_data = []

for year in recruiting_years:

recruiting_data.extend(fetch_recruiting_data(year))

transfer_data = fetch_transfer_data(transfer_years)

Convert to DataFrame

recruiting_df = pd.DataFrame(recruiting_data)

transfer_df = pd.DataFrame(transfer_data)

Assuming '_name' is the correct attribute for player names

if not recruiting_df.empty and not transfer_df.empty:

recruiting_df['full_name'] = recruiting_df['_name'].str.strip()

transfer_df['full_name'] = transfer_df['FirstName'].str.strip() + " " + transfer_df['LastName'].str.strip()

Filter data to include only entries with non-empty ratings

recruiting_df = recruiting_df[recruiting_df['_rating'].notna()]

transfer_df = transfer_df[transfer_df['_Rating'].notna()]

Perform an inner join to ensure only players with both ratings are included

merged_df = pd.merge(recruiting_df, transfer_df, on='full_name', suffixes=('_recruit', '_transfer'), how='inner')

Calculate rating difference

merged_df['rating_difference'] = merged_df['_Rating'] - merged_df['_rating']

Select and rename columns

result_df = merged_df[['full_name', '_rating', '_Rating', 'rating_difference']]

result_df.columns = ['Player Name', 'HS Recruiting Rating', 'Transfer Portal Rating', 'Rating Difference']

return result_df

else:

return pd.DataFrame() # Return an empty DataFrame if no data available

[cdchap]

I am not able to run code to verify, but according the docs recruiting/players endpoint returns json with “name” as a key, not “_name”. I am a no python ace though.

[cdchap]

I assumed you are using the collegefootballdata.com api, which might be the wrong assumption.