Python - Normalizing /game/players endpoint

game_players.py

import pandas as pd
import requests

response = requests.get(
    "https://api.collegefootballdata.com/games/players",
    params={"year": 2019, "week": "1"}
)

records = pd.io.json.json_normalize(
    response.json(),
    ['teams', 'categories', 'types', 'athletes'],
    [
        'id',
        ['teams', 'school'],
        ['teams', 'conference'],
        ['teams', 'categories', 'name'],
        ['teams', 'categories', 'types', 'name']
    ], 
    meta_prefix='game.'
)

records.head()