usa today battery update.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import altair as alt\n",
    "\n",
    "# Load the data into a DataFrame\n",
    "data = {\n",
    "    \"player\": [\"Caitlin Clark\", \"Aliyah Boston\", \"Rhyne Howard\", \"Charli Collier\", \"Sabrina Ionescu\",\n",
    "               \"Jackie Young\", \"A'ja Wilson\", \"Kelsey Plum\", \"Breanna Stewart\", \"Jewell Loyd\"],\n",
    "    \"college\": [34.8, 26.2, 35.2, 32.5, 33.7, 32.2, 29.4, 37.2, 29.1, 32],\n",
    "    \"wnba\": [33.4, 28.9, 30.2, 13.5, 31.9, 20.9, 30.8, 14.5, 34.7, 22]\n",
    "}\n",
    "\n",
    "df = pd.DataFrame(data)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "<style>\n",
       "  #altair-viz-4dc4f6527c49441f9b8bbd21b83db709.vega-embed {\n",
       "    width: 100%;\n",
       "    display: flex;\n",
       "  }\n",
       "\n",
       "  #altair-viz-4dc4f6527c49441f9b8bbd21b83db709.vega-embed details,\n",
       "  #altair-viz-4dc4f6527c49441f9b8bbd21b83db709.vega-embed details summary {\n",
       "    position: relative;\n",
       "  }\n",
       "</style>\n",
       "<div id=\"altair-viz-4dc4f6527c49441f9b8bbd21b83db709\"></div>\n",
       "<script type=\"text/javascript\">\n",
       "  var VEGA_DEBUG = (typeof VEGA_DEBUG == \"undefined\") ? {} : VEGA_DEBUG;\n",
       "  (function(spec, embedOpt){\n",
       "    let outputDiv = document.currentScript.previousElementSibling;\n",
       "    if (outputDiv.id !== \"altair-viz-4dc4f6527c49441f9b8bbd21b83db709\") {\n",
       "      outputDiv = document.getElementById(\"altair-viz-4dc4f6527c49441f9b8bbd21b83db709\");\n",
       "    }\n",
       "    const paths = {\n",
       "      \"vega\": \"https://cdn.jsdelivr.net/npm/vega@5?noext\",\n",
       "      \"vega-lib\": \"https://cdn.jsdelivr.net/npm/vega-lib?noext\",\n",
       "      \"vega-lite\": \"https://cdn.jsdelivr.net/npm/vega-lite@5.8.0?noext\",\n",
       "      \"vega-embed\": \"https://cdn.jsdelivr.net/npm/vega-embed@6?noext\",\n",
       "    };\n",
       "\n",
       "    function maybeLoadScript(lib, version) {\n",
       "      var key = `${lib.replace(\"-\", \"\")}_version`;\n",
       "      return (VEGA_DEBUG[key] == version) ?\n",
       "        Promise.resolve(paths[lib]) :\n",
       "        new Promise(function(resolve, reject) {\n",
       "          var s = document.createElement('script');\n",
       "          document.getElementsByTagName(\"head\")[0].appendChild(s);\n",
       "          s.async = true;\n",
       "          s.onload = () => {\n",
       "            VEGA_DEBUG[key] = version;\n",
       "            return resolve(paths[lib]);\n",
       "          };\n",
       "          s.onerror = () => reject(`Error loading script: ${paths[lib]}`);\n",
       "          s.src = paths[lib];\n",
       "        });\n",
       "    }\n",
       "\n",
       "    function showError(err) {\n",
       "      outputDiv.innerHTML = `<div class=\"error\" style=\"color:red;\">${err}</div>`;\n",
       "      throw err;\n",
       "    }\n",
       "\n",
       "    function displayChart(vegaEmbed) {\n",
       "      vegaEmbed(outputDiv, spec, embedOpt)\n",
       "        .catch(err => showError(`Javascript Error: ${err.message}<br>This usually means there's a typo in your chart specification. See the javascript console for the full traceback.`));\n",
       "    }\n",
       "\n",
       "    if(typeof define === \"function\" && define.amd) {\n",
       "      requirejs.config({paths});\n",
       "      require([\"vega-embed\"], displayChart, err => showError(`Error loading script: ${err.message}`));\n",
       "    } else {\n",
       "      maybeLoadScript(\"vega\", \"5\")\n",
       "        .then(() => maybeLoadScript(\"vega-lite\", \"5.8.0\"))\n",
       "        .then(() => maybeLoadScript(\"vega-embed\", \"6\"))\n",
       "        .catch(showError)\n",
       "        .then(() => displayChart(vegaEmbed));\n",
       "    }\n",
       "  })({\"config\": {\"view\": {\"continuousWidth\": 300, \"continuousHeight\": 300}, \"axis\": {\"labelAngle\": -45}}, \"data\": {\"name\": \"data-d97de5ed3c249d07d9f20f306b11de2b\"}, \"mark\": {\"type\": \"circle\", \"size\": 100}, \"encoding\": {\"color\": {\"field\": \"league\", \"scale\": {\"domain\": [\"college\", \"wnba\"], \"range\": [\"#1f77b4\", \"#ff7f0e\"]}, \"title\": \"League\", \"type\": \"nominal\"}, \"tooltip\": [{\"field\": \"player\", \"type\": \"nominal\"}, {\"field\": \"league\", \"type\": \"nominal\"}, {\"field\": \"minutes\", \"type\": \"quantitative\"}], \"x\": {\"field\": \"player\", \"sort\": null, \"title\": \"Player\", \"type\": \"nominal\"}, \"y\": {\"field\": \"minutes\", \"title\": \"Minutes per Game\", \"type\": \"quantitative\"}}, \"height\": 400, \"title\": \"Comparison of College and WNBA Minutes per Game\", \"width\": 800, \"$schema\": \"https://vega.github.io/schema/vega-lite/v5.8.0.json\", \"datasets\": {\"data-d97de5ed3c249d07d9f20f306b11de2b\": [{\"player\": \"Caitlin Clark\", \"league\": \"college\", \"minutes\": 34.8}, {\"player\": \"Aliyah Boston\", \"league\": \"college\", \"minutes\": 26.2}, {\"player\": \"Rhyne Howard\", \"league\": \"college\", \"minutes\": 35.2}, {\"player\": \"Charli Collier\", \"league\": \"college\", \"minutes\": 32.5}, {\"player\": \"Sabrina Ionescu\", \"league\": \"college\", \"minutes\": 33.7}, {\"player\": \"Jackie Young\", \"league\": \"college\", \"minutes\": 32.2}, {\"player\": \"A'ja Wilson\", \"league\": \"college\", \"minutes\": 29.4}, {\"player\": \"Kelsey Plum\", \"league\": \"college\", \"minutes\": 37.2}, {\"player\": \"Breanna Stewart\", \"league\": \"college\", \"minutes\": 29.1}, {\"player\": \"Jewell Loyd\", \"league\": \"college\", \"minutes\": 32.0}, {\"player\": \"Caitlin Clark\", \"league\": \"wnba\", \"minutes\": 33.4}, {\"player\": \"Aliyah Boston\", \"league\": \"wnba\", \"minutes\": 28.9}, {\"player\": \"Rhyne Howard\", \"league\": \"wnba\", \"minutes\": 30.2}, {\"player\": \"Charli Collier\", \"league\": \"wnba\", \"minutes\": 13.5}, {\"player\": \"Sabrina Ionescu\", \"league\": \"wnba\", \"minutes\": 31.9}, {\"player\": \"Jackie Young\", \"league\": \"wnba\", \"minutes\": 20.9}, {\"player\": \"A'ja Wilson\", \"league\": \"wnba\", \"minutes\": 30.8}, {\"player\": \"Kelsey Plum\", \"league\": \"wnba\", \"minutes\": 14.5}, {\"player\": \"Breanna Stewart\", \"league\": \"wnba\", \"minutes\": 34.7}, {\"player\": \"Jewell Loyd\", \"league\": \"wnba\", \"minutes\": 22.0}]}}, {\"mode\": \"vega-lite\"});\n",
       "</script>"
      ],
      "text/plain": [
       "alt.Chart(...)"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Melt the DataFrame to long format\n",
    "df_melted = df.melt(id_vars='player', var_name='league', value_name='minutes')\n",
    "\n",
    "# Create the Altair scatter plot\n",
    "scatter_plot = alt.Chart(df_melted).mark_circle(size=100).encode(\n",
    "    x=alt.X('player:N', title='Player', sort=None),\n",
    "    y=alt.Y('minutes:Q', title='Minutes per Game'),\n",
    "    color=alt.Color('league:N', title='League', scale=alt.Scale(domain=['college', 'wnba'], range=['#1f77b4', '#ff7f0e'])),\n",
    "    tooltip=['player', 'league', 'minutes']\n",
    ").properties(\n",
    "    width=800,\n",
    "    height=400,\n",
    "    title='Comparison of College and WNBA Minutes per Game'\n",
    ").configure_axis(\n",
    "    labelAngle=-45\n",
    ")\n",
    "\n",
    "scatter_plot"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "<style>\n",
       "  #altair-viz-8cc699083b954aed9ce05e02890ed540.vega-embed {\n",
       "    width: 100%;\n",
       "    display: flex;\n",
       "  }\n",
       "\n",
       "  #altair-viz-8cc699083b954aed9ce05e02890ed540.vega-embed details,\n",
       "  #altair-viz-8cc699083b954aed9ce05e02890ed540.vega-embed details summary {\n",
       "    position: relative;\n",
       "  }\n",
       "</style>\n",
       "<div id=\"altair-viz-8cc699083b954aed9ce05e02890ed540\"></div>\n",
       "<script type=\"text/javascript\">\n",
       "  var VEGA_DEBUG = (typeof VEGA_DEBUG == \"undefined\") ? {} : VEGA_DEBUG;\n",
       "  (function(spec, embedOpt){\n",
       "    let outputDiv = document.currentScript.previousElementSibling;\n",
       "    if (outputDiv.id !== \"altair-viz-8cc699083b954aed9ce05e02890ed540\") {\n",
       "      outputDiv = document.getElementById(\"altair-viz-8cc699083b954aed9ce05e02890ed540\");\n",
       "    }\n",
       "    const paths = {\n",
       "      \"vega\": \"https://cdn.jsdelivr.net/npm/vega@5?noext\",\n",
       "      \"vega-lib\": \"https://cdn.jsdelivr.net/npm/vega-lib?noext\",\n",
       "      \"vega-lite\": \"https://cdn.jsdelivr.net/npm/vega-lite@5.8.0?noext\",\n",
       "      \"vega-embed\": \"https://cdn.jsdelivr.net/npm/vega-embed@6?noext\",\n",
       "    };\n",
       "\n",
       "    function maybeLoadScript(lib, version) {\n",
       "      var key = `${lib.replace(\"-\", \"\")}_version`;\n",
       "      return (VEGA_DEBUG[key] == version) ?\n",
       "        Promise.resolve(paths[lib]) :\n",
       "        new Promise(function(resolve, reject) {\n",
       "          var s = document.createElement('script');\n",
       "          document.getElementsByTagName(\"head\")[0].appendChild(s);\n",
       "          s.async = true;\n",
       "          s.onload = () => {\n",
       "            VEGA_DEBUG[key] = version;\n",
       "            return resolve(paths[lib]);\n",
       "          };\n",
       "          s.onerror = () => reject(`Error loading script: ${paths[lib]}`);\n",
       "          s.src = paths[lib];\n",
       "        });\n",
       "    }\n",
       "\n",
       "    function showError(err) {\n",
       "      outputDiv.innerHTML = `<div class=\"error\" style=\"color:red;\">${err}</div>`;\n",
       "      throw err;\n",
       "    }\n",
       "\n",
       "    function displayChart(vegaEmbed) {\n",
       "      vegaEmbed(outputDiv, spec, embedOpt)\n",
       "        .catch(err => showError(`Javascript Error: ${err.message}<br>This usually means there's a typo in your chart specification. See the javascript console for the full traceback.`));\n",
       "    }\n",
       "\n",
       "    if(typeof define === \"function\" && define.amd) {\n",
       "      requirejs.config({paths});\n",
       "      require([\"vega-embed\"], displayChart, err => showError(`Error loading script: ${err.message}`));\n",
       "    } else {\n",
       "      maybeLoadScript(\"vega\", \"5\")\n",
       "        .then(() => maybeLoadScript(\"vega-lite\", \"5.8.0\"))\n",
       "        .then(() => maybeLoadScript(\"vega-embed\", \"6\"))\n",
       "        .catch(showError)\n",
       "        .then(() => displayChart(vegaEmbed));\n",
       "    }\n",
       "  })({\"config\": {\"view\": {\"continuousWidth\": 300, \"continuousHeight\": 300}, \"axis\": {\"labelAngle\": -45, \"labelFontSize\": 14, \"titleFontSize\": 16}}, \"layer\": [{\"mark\": {\"type\": \"line\"}, \"encoding\": {\"color\": {\"value\": \"gray\"}, \"detail\": {\"field\": \"player\", \"type\": \"nominal\"}, \"x\": {\"field\": \"player\", \"sort\": null, \"title\": \"Player\", \"type\": \"nominal\"}, \"y\": {\"field\": \"minutes\", \"title\": \"Minutes per Game\", \"type\": \"quantitative\"}}}, {\"mark\": {\"type\": \"circle\", \"size\": 100}, \"encoding\": {\"color\": {\"field\": \"league\", \"scale\": {\"domain\": [\"college\", \"wnba\"], \"range\": [\"#1f77b4\", \"#ff7f0e\"]}, \"title\": \"League\", \"type\": \"nominal\"}, \"tooltip\": [{\"field\": \"player\", \"type\": \"nominal\"}, {\"field\": \"league\", \"type\": \"nominal\"}, {\"field\": \"minutes\", \"type\": \"quantitative\"}], \"x\": {\"field\": \"player\", \"sort\": null, \"title\": \"Player\", \"type\": \"nominal\"}, \"y\": {\"field\": \"minutes\", \"title\": \"Minutes per Game\", \"type\": \"quantitative\"}}}], \"data\": {\"name\": \"data-d97de5ed3c249d07d9f20f306b11de2b\"}, \"height\": 400, \"title\": \"Comparison of Senior Year and WNBA (first 10 games) Minutes per Game\", \"width\": 500, \"$schema\": \"https://vega.github.io/schema/vega-lite/v5.8.0.json\", \"datasets\": {\"data-d97de5ed3c249d07d9f20f306b11de2b\": [{\"player\": \"Caitlin Clark\", \"league\": \"college\", \"minutes\": 34.8}, {\"player\": \"Aliyah Boston\", \"league\": \"college\", \"minutes\": 26.2}, {\"player\": \"Rhyne Howard\", \"league\": \"college\", \"minutes\": 35.2}, {\"player\": \"Charli Collier\", \"league\": \"college\", \"minutes\": 32.5}, {\"player\": \"Sabrina Ionescu\", \"league\": \"college\", \"minutes\": 33.7}, {\"player\": \"Jackie Young\", \"league\": \"college\", \"minutes\": 32.2}, {\"player\": \"A'ja Wilson\", \"league\": \"college\", \"minutes\": 29.4}, {\"player\": \"Kelsey Plum\", \"league\": \"college\", \"minutes\": 37.2}, {\"player\": \"Breanna Stewart\", \"league\": \"college\", \"minutes\": 29.1}, {\"player\": \"Jewell Loyd\", \"league\": \"college\", \"minutes\": 32.0}, {\"player\": \"Caitlin Clark\", \"league\": \"wnba\", \"minutes\": 33.4}, {\"player\": \"Aliyah Boston\", \"league\": \"wnba\", \"minutes\": 28.9}, {\"player\": \"Rhyne Howard\", \"league\": \"wnba\", \"minutes\": 30.2}, {\"player\": \"Charli Collier\", \"league\": \"wnba\", \"minutes\": 13.5}, {\"player\": \"Sabrina Ionescu\", \"league\": \"wnba\", \"minutes\": 31.9}, {\"player\": \"Jackie Young\", \"league\": \"wnba\", \"minutes\": 20.9}, {\"player\": \"A'ja Wilson\", \"league\": \"wnba\", \"minutes\": 30.8}, {\"player\": \"Kelsey Plum\", \"league\": \"wnba\", \"minutes\": 14.5}, {\"player\": \"Breanna Stewart\", \"league\": \"wnba\", \"minutes\": 34.7}, {\"player\": \"Jewell Loyd\", \"league\": \"wnba\", \"minutes\": 22.0}]}}, {\"mode\": \"vega-lite\"});\n",
       "</script>"
      ],
      "text/plain": [
       "alt.LayerChart(...)"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Melt the DataFrame to long format\n",
    "df_melted = df.melt(id_vars='player', var_name='league', value_name='minutes')\n",
    "\n",
    "# Create the points for the scatter plot\n",
    "points = alt.Chart(df_melted).mark_circle(size=100).encode(\n",
    "    x=alt.X('player:N', title='Player', sort=None),\n",
    "    y=alt.Y('minutes:Q', title='Minutes per Game'),\n",
    "    color=alt.Color('league:N', title='League', scale=alt.Scale(domain=['college', 'wnba'], range=['#1f77b4', '#ff7f0e'])),\n",
    "    tooltip=['player', 'league', 'minutes']\n",
    ")\n",
    "\n",
    "# Create the lines connecting the points\n",
    "lines = alt.Chart(df_melted).mark_line().encode(\n",
    "    x=alt.X('player:N', title='Player', sort=None),\n",
    "    y=alt.Y('minutes:Q', title='Minutes per Game'),\n",
    "    detail='player:N',\n",
    "    color=alt.value('gray')\n",
    ")\n",
    "\n",
    "# Combine the points and lines into a single chart\n",
    "chart = alt.layer(lines, points).properties(\n",
    "    width=500,\n",
    "    height=400,\n",
    "    title='No.1 Picks Senior Year vs WNBA (first 10 games) Minutes per Game'\n",
    ").configure_axis(\n",
    "    labelFontSize=14,\n",
    "    titleFontSize=16,\n",
    "    labelAngle=-45\n",
    ")\n",
    "\n",
    "chart"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}