2024-7-25 wnba 2023 vs 2024 stats.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "from io import StringIO"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Define the data as a string\n",
    "data1 = \"\"\"\n",
    "Cecilia Zandalasini,5.1,0.8,25,zandace01\n",
    "Li Yueru,4.6,0.4,22,yueruli01\n",
    "Jackie Young,18.5,3.2,23,youngja04\n",
    "A'ja Wilson,27.2,7.0,24,wilsoa01\n",
    "Kiana Williams,0.8,-0.1,13,williki02\n",
    "Elizabeth Williams,10.0,0.8,9,williel02\n",
    "Courtney Williams,9.8,0.9,25,willico03\n",
    "Sami Whitcomb,5.3,0.7,25,whitcsa01\n",
    "Erica Wheeler,4.2,-0.3,25,wheeler01\n",
    "Kristy Wallace,4.8,0.2,22,wallakr01\n",
    "Shatori Walker-Kimbrough,8.0,0.8,25,walkesh01\n",
    "Victoria Vivians,3.7,0.7,24,viviavi01\n",
    "Julie Vanloo,8.5,-0.9,25,vanloju01\n",
    "Courtney Vandersloot,6.6,0.7,16,vandeco01\n",
    "Sevgi Uzun,5.4,-1.1,25,uzunse01\n",
    "Brianna Turner,0.7,0.2,16,turnebr01\n",
    "Kayla Thornton,6.1,1.7,25,thornka01\n",
    "Alyssa Thomas,11.4,3.7,24,thomaal01\n",
    "Celeste Taylor,0.9,0.0,8,tayloce01\n",
    "Diana Taurasi,16.1,1.4,21,tauradi01\n",
    "Stephanie Talbot,3.8,0.6,22,talbost01\n",
    "Brittney Sykes,11.3,0.2,3,sykesbr01\n",
    "Sug Sutton,3.0,-0.5,20,suttosu01\n",
    "Kiah Stokes,1.9,1.0,23,stokeki01\n",
    "Breanna Stewart,19.3,5.1,23,stewabr01\n",
    "Azura Stevens,14.8,0.6,4,steveaz01\n",
    "Taylor Soule,0.0,0.0,2,souleta01\n",
    "Stephanie Soares,1.3,-0.2,19,soarest01\n",
    "NaLyssa Smith,11.6,1.6,26,smithna01\n",
    "Alanna Smith,11.5,3.6,25,smithal03\n",
    "Odyssey Sims,17.2,1.2,9,simsod01\n",
    "Maddy Siegrist,14.6,0.9,13,siegrma01\n",
    "Jaylyn Sherrod,0.0,0.0,1,sherrja01\n",
    "Jacy Sheldon,5.3,-0.1,25,sheldja01\n",
    "Victaria Saxton,0.5,-0.1,6,saxtovi01\n",
    "Katie Lou Samuelson,5.4,0.6,26,samueka02\n",
    "Karlie Samuelson,9.9,0.9,17,samueka01\n",
    "Nyara Sabally,3.1,0.7,11,sabalny01\n",
    "Mercedes Russell,3.8,0.9,23,russeme01\n",
    "DiDi Richards,2.4,0.0,19,richadi01\n",
    "Angel Reese,13.5,2.7,24,reesean01\n",
    "Aerial Powers,8.6,0.4,17,powerae01\n",
    "Kelsey Plum,18.4,2.2,24,plumke01\n",
    "Alissa Pili,2.4,0.0,16,pilial01\n",
    "Cheyenne Parker,10.0,0.8,23,parkech02\n",
    "Charisma Osborne,1.0,-0.1,2,osborch02\n",
    "Michaela Onyenwere,3.6,0.1,18,onyenmi01\n",
    "Nneka Ogwumike,17.4,4.5,22,ogwumnn01\n",
    "Arike Ogunbowale,22.3,1.8,24,ogunbar01\n",
    "Kia Nurse,7.5,-0.4,24,nurseki01\n",
    "Olivia Nelson-Ododa,2.8,0.7,21,nelsool01\n",
    "Astou Ndour-Fall,1.3,0.1,14,ndouras01\n",
    "Nika Mühl,0.0,-0.2,12,muhlni01\n",
    "Tiffany Mitchell,4.9,0.7,24,mitchti01\n",
    "Kelsey Mitchell,16.9,1.3,26,mitchke01\n",
    "Diamond Miller,3.2,-0.2,11,milledi03\n",
    "Jade Melbourne,5.6,-0.2,22,melboja01\n",
    "Aari McDonald,9.3,0.7,24,mcdonaa01\n",
    "Teaira McCowan,11.4,1.6,25,mccowte01\n",
    "Kayla McBride,16.4,4.3,25,mcbrika01\n",
    "Kate Martin,3.4,0.4,23,martika01\n",
    "Ezi Magbegor,13.0,4.5,25,magbeez01\n",
    "Natasha Mack,3.7,1.6,25,mackna01\n",
    "Marina Mabrey,14.0,1.0,24,mabrema01\n",
    "Jewell Loyd,20.1,3.0,25,loydje01\n",
    "Lou Lopez Sénéchal,1.1,-0.2,19,lopezlo01\n",
    "Betnijah Laney,12.7,1.8,18,laneybe01\n",
    "Sika Koné,1.3,0.1,16,konesi01\n",
    "Dorka Juhász,5.7,1.5,22,juhasdo01\n",
    "Jonquel Jones,15.3,4.5,25,jonesjo04\n",
    "Haley Jones,5.5,-0.7,24,jonesha01\n",
    "Brionna Jones,13.3,3.8,24,jonesbr02\n",
    "Moriah Jefferson,2.1,0.3,9,jeffemo01\n",
    "Rickea Jackson,11.4,0.3,24,jacksri02\n",
    "Sabrina Ionescu,19.8,3.8,25,ionessa01\n",
    "Lexie Hull,3.6,-0.1,20,hullle01\n",
    "Rhyne Howard,15.4,1.5,14,howarrh01\n",
    "Natasha Howard,16.6,0.9,13,howarna01\n",
    "Jordan Horston,8.0,1.8,25,horstjo02\n",
    "Joyner Holmes,2.9,0.3,15,holmejo03\n",
    "Myisha Hines-Allen,8.4,1.5,25,hinesmy01\n",
    "Naz Hillmon,4.2,1.6,24,hillmna01\n",
    "Natisha Hiedeman,4.5,0.7,25,hiedena01\n",
    "Destanni Henderson,4.0,-0.3,6,hendede01\n",
    "Tiffany Hayes,8.6,1.5,17,hayesti01\n",
    "Isabelle Harrison,5.9,0.4,20,harriis01\n",
    "Tyasha Harris,11.0,2.0,23,harrity01\n",
    "Mikiah Herbert Harrigan,2.9,0.0,19,harrimi03\n",
    "Dearica Hamby,19.2,2.5,24,hambyde01\n",
    "Megan Gustafson,2.8,0.5,22,gustame01\n",
    "Brittney Griner,18.6,2.0,15,grinebr01\n",
    "Chelsea Gray,7.3,0.2,12,graych01\n",
    "Allisha Gray,15.5,1.7,24,grayal01\n",
    "Kysre Gondrezick,1.0,0.0,5,gondrky01\n",
    "Leonie Fiebich,5.8,1.4,25,fiebile01\n",
    "Dulcy Fankam Mendjiadeu,0.9,0.0,7,fankadu01\n",
    "Dyaisha Fair,0.0,0.0,1,fairdy01\n",
    "Temi Fagbenle,8.5,0.8,11,fagbete01\n",
    "Dana Evans,7.5,0.8,24,evansda03\n",
    "Olivia Époupa,0.9,0.2,15,epoupol01\n",
    "Emily Engstler,4.5,0.9,18,engstem01\n",
    "Queen Egbo,0.8,0.0,5,egboqu01\n",
    "Aaliyah Edwards,8.7,1.0,22,edwaraa01\n",
    "Stefanie Dolson,10.3,1.7,24,dolsost01\n",
    "Ivana Dojkić,3.7,0.3,18,dojkiiv01\n",
    "Liz Dixon,1.8,0.1,17,dixonli01\n",
    "Skylar Diggins-Smith,13.1,2.0,25,diggisk01\n",
    "Diamond DeShields,4.5,0.0,21,deshidi01\n",
    "Marquesha Davis,1.1,0.1,13,davisma05\n",
    "Damiris Dantas,3.3,0.1,6,dantada01\n",
    "Crystal Dangerfield,2.7,-0.2,18,dangecr01\n",
    "Sophie Cunningham,8.0,1.8,25,cunniso01\n",
    "Lorela Cubaj,0.8,0.0,13,cubajlo01\n",
    "Kahleah Copper,23.2,1.4,25,coppeka01\n",
    "Zia Cooke,3.4,-0.5,20,cookezi01\n",
    "Sydney Colson,1.9,0.3,18,colsosy01\n",
    "Napheesa Collier,20.0,3.9,20,collina01\n",
    "Nia Coffey,3.5,-0.1,24,coffeni01\n",
    "Natasha Cloud,12.4,1.7,24,cloudna02\n",
    "Caitlin Clark,17.1,1.2,26,clarkca02\n",
    "Alysha Clark,6.3,1.0,24,clarkal01\n",
    "Layshia Clarendon,4.6,0.4,20,clarela01\n",
    "Tina Charles,13.6,1.4,24,charlti01\n",
    "Jessika Carter,0.0,-0.1,2,carteje02\n",
    "Chennedy Carter,17.2,2.6,24,cartech01\n",
    "DiJonai Carrington,12.9,2.4,24,carridi01\n",
    "Bridget Carleton,8.9,2.5,24,carlebr01\n",
    "Kamilla Cardoso,8.1,0.9,18,cardoka01\n",
    "Emma Cannon,0.8,0.0,5,cannoem01\n",
    "Jordin Canada,8.8,0.3,4,canadjo02\n",
    "Maya Caldwell,8.1,0.0,9,caldwma01\n",
    "Veronica Burton,2.9,0.8,15,burtove01\n",
    "Rae Burrell,5.0,0.5,21,burrera01\n",
    "Kennedy Burke,3.1,0.4,24,burkeke01\n",
    "Jakia Brown-Turner,1.0,0.0,2,brownja07\n",
    "Lexie Brown,8.1,-0.3,16,brownle04\n",
    "Kalani Brown,6.0,0.3,24,brownka01\n",
    "Jaelyn Brown,0.0,-0.1,1,brownja06\n",
    "Cameron Brink,7.5,0.2,15,brinkca01\n",
    "Aliyah Boston,14.2,2.6,26,bostoal01\n",
    "DeWanna Bonner,16.7,3.5,24,bonnede01\n",
    "Monique Billings,8.8,0.3,24,billimo01\n",
    "Morgan Bertsch,2.0,-0.6,11,bertsmo01\n",
    "Grace Berger,3.6,0.0,8,bergegr01\n",
    "Kierstan Bell,1.7,0.0,3,bellki01\n",
    "Rachel Banham,4.8,0.6,21,banhara01\n",
    "Shakira Austin,11.7,0.0,6,austish01\n",
    "Ariel Atkins,15.8,1.3,25,atkinar01\n",
    "Laeticia Amihere,1.2,-0.3,11,amihela01\n",
    "Rebecca Allen,7.4,0.4,18,allenre01\n",
    "Lindsay Allen,5.2,0.9,24,allenli01\"\"\"\n",
    "\n",
    "# Use StringIO to simulate a file object\n",
    "data_io = StringIO(data1)\n",
    "\n",
    "# Define the column names\n",
    "column_names = ['Player', 'PTS/G', 'WS', 'G', 'id']\n",
    "\n",
    "# Read the data into a DataFrame\n",
    "df24 = pd.read_csv(data_io, names=column_names)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Player</th>\n",
       "      <th>PTS/G</th>\n",
       "      <th>WS</th>\n",
       "      <th>G</th>\n",
       "      <th>id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>Cecilia Zandalasini</td>\n",
       "      <td>5.1</td>\n",
       "      <td>0.8</td>\n",
       "      <td>25</td>\n",
       "      <td>zandace01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>Li Yueru</td>\n",
       "      <td>4.6</td>\n",
       "      <td>0.4</td>\n",
       "      <td>22</td>\n",
       "      <td>yueruli01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>Jackie Young</td>\n",
       "      <td>18.5</td>\n",
       "      <td>3.2</td>\n",
       "      <td>23</td>\n",
       "      <td>youngja04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>A'ja Wilson</td>\n",
       "      <td>27.2</td>\n",
       "      <td>7.0</td>\n",
       "      <td>24</td>\n",
       "      <td>wilsoa01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>Kiana Williams</td>\n",
       "      <td>0.8</td>\n",
       "      <td>-0.1</td>\n",
       "      <td>13</td>\n",
       "      <td>williki02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>146</td>\n",
       "      <td>Shakira Austin</td>\n",
       "      <td>11.7</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6</td>\n",
       "      <td>austish01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>147</td>\n",
       "      <td>Ariel Atkins</td>\n",
       "      <td>15.8</td>\n",
       "      <td>1.3</td>\n",
       "      <td>25</td>\n",
       "      <td>atkinar01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>148</td>\n",
       "      <td>Laeticia Amihere</td>\n",
       "      <td>1.2</td>\n",
       "      <td>-0.3</td>\n",
       "      <td>11</td>\n",
       "      <td>amihela01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>149</td>\n",
       "      <td>Rebecca Allen</td>\n",
       "      <td>7.4</td>\n",
       "      <td>0.4</td>\n",
       "      <td>18</td>\n",
       "      <td>allenre01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>150</td>\n",
       "      <td>Lindsay Allen</td>\n",
       "      <td>5.2</td>\n",
       "      <td>0.9</td>\n",
       "      <td>24</td>\n",
       "      <td>allenli01</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>151 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                  Player  PTS/G   WS   G         id\n",
       "0    Cecilia Zandalasini    5.1  0.8  25  zandace01\n",
       "1               Li Yueru    4.6  0.4  22  yueruli01\n",
       "2           Jackie Young   18.5  3.2  23  youngja04\n",
       "3            A'ja Wilson   27.2  7.0  24   wilsoa01\n",
       "4         Kiana Williams    0.8 -0.1  13  williki02\n",
       "..                   ...    ...  ...  ..        ...\n",
       "146       Shakira Austin   11.7  0.0   6  austish01\n",
       "147         Ariel Atkins   15.8  1.3  25  atkinar01\n",
       "148     Laeticia Amihere    1.2 -0.3  11  amihela01\n",
       "149        Rebecca Allen    7.4  0.4  18  allenre01\n",
       "150        Lindsay Allen    5.2  0.9  24  allenli01\n",
       "\n",
       "[151 rows x 5 columns]"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df24"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "from io import StringIO\n",
    "\n",
    "# Define the data as a string\n",
    "data2 = \"\"\"\n",
    "Amanda Zahui B.,1.7,-0.4,34,zahuiam01\n",
    "Jackie Young,17.6,7.5,40,youngja04\n",
    "Han Xu,1.5,-0.2,8,xuha01\n",
    "A'ja Wilson,22.8,10.4,40,wilsoa01\n",
    "Jocelyn Willoughby,1.2,0.3,29,willojo01\n",
    "Madi Williams,2.0,-0.3,5,willima10\n",
    "Gabby Williams,8.4,-0.1,10,williga02\n",
    "Elizabeth Williams,9.8,3.7,40,williel02\n",
    "Courtney Williams,10.4,2.4,40,willico03\n",
    "Sami Whitcomb,9.7,1.5,40,whitcsa01\n",
    "Erica Wheeler,9.9,1.4,40,wheeler01\n",
    "Evina Westbrook,1.1,-0.4,18,westbev01\n",
    "Kristy Wallace,6.6,0.3,37,wallakr01\n",
    "Shatori Walker-Kimbrough,6.3,2.2,40,walkesh01\n",
    "Victoria Vivians,5.2,0.6,38,viviavi01\n",
    "Courtney Vandersloot,10.5,4.5,39,vandeco01\n",
    "Yvonne Turner,2.5,0.2,21,turneyv01\n",
    "Brianna Turner,3.5,1.1,40,turnebr01\n",
    "Kayana Traylor,1.0,-0.1,8,traylka01\n",
    "Kristi Toliver,3.6,0.0,11,tolivkr01\n",
    "Kayla Thornton,4.5,2.3,40,thornka01\n",
    "Sam Thomas,0.0,-0.1,1,thomasa01\n",
    "Jasmine Thomas,2.7,-0.4,32,thomaja03\n",
    "Alyssa Thomas,15.5,6.1,40,thomaal01\n",
    "Diana Taurasi,16.0,1.1,26,tauradi01\n",
    "Brittney Sykes,15.9,3.9,40,sykesbr01\n",
    "Sug Sutton,8.2,-1.0,40,suttosu01\n",
    "Kiah Stokes,2.2,2.4,40,stokeki01\n",
    "Breanna Stewart,23.0,10.3,40,stewabr01\n",
    "Azura Stevens,10.8,1.2,35,steveaz01\n",
    "Taylor Soule,0.6,-0.2,15,souleta01\n",
    "NaLyssa Smith,15.5,1.2,31,smithna01\n",
    "Alanna Smith,9.2,3.5,38,smithal03\n",
    "Kadi Sissoko,1.5,-0.8,40,sissoka01\n",
    "Odyssey Sims,2.0,0.1,28,simsod01\n",
    "Jennie Simms,2.2,-0.2,6,simmsje01\n",
    "Maddy Siegrist,3.7,1.4,39,siegrma01\n",
    "Jessica Shepard,8.1,1.7,21,shepaje01\n",
    "Victaria Saxton,1.3,-0.1,15,saxtovi01\n",
    "Karlie Samuelson,7.7,2.8,34,samueka01\n",
    "Satou Sabally,18.6,5.9,38,sabalsa01\n",
    "Nyara Sabally,2.3,0.5,33,sabalny01\n",
    "Mercedes Russell,5.0,0.4,37,russeme01\n",
    "Iliana Rupert,1.8,0.2,20,ruperil01\n",
    "Danielle Robinson,5.8,1.2,32,robinda04\n",
    "Epiphanny Prince,1.8,0.1,10,princep01\n",
    "Aerial Powers,5.2,0.0,20,powerae01\n",
    "Kelsey Plum,18.7,6.3,39,plumke01\n",
    "Shey Peddy,5.2,0.5,18,peddysh01\n",
    "Robyn Parks,3.9,0.3,37,parksro01\n",
    "Cheyenne Parker,15.0,3.7,40,parkech02\n",
    "Candace Parker,9.0,2.1,18,parkeca01\n",
    "Michaela Onyenwere,8.9,-0.7,40,onyenmi01\n",
    "Nneka Ogwumike,19.1,5.6,36,ogwumnn01\n",
    "Chiney Ogwumike,8.4,0.3,10,ogwumch01\n",
    "Arike Ogunbowale,21.2,4.2,40,ogunbar01\n",
    "Kia Nurse,5.9,0.5,40,nurseki01\n",
    "Olivia Nelson-Ododa,4.5,2.3,39,nelsool01\n",
    "Tiffany Mitchell,7.3,-0.6,33,mitchti01\n",
    "Kelsey Mitchell,18.2,3.3,40,mitchke01\n",
    "Diamond Miller,12.1,0.2,32,milledi03\n",
    "Nikolina Milic,5.9,0.3,39,milicni01\n",
    "Taylor Mikesell,2.8,0.2,6,mikesta01\n",
    "Abby Meyers,1.4,0.0,9,meyerab01\n",
    "Li Meng,5.6,0.5,34,mengli01\n",
    "Jade Melbourne,2.6,0.0,29,melboja01\n",
    "Aari McDonald,7.9,0.6,24,mcdonaa01\n",
    "Teaira McCowan,11.9,3.2,30,mccowte01\n",
    "Kayla McBride,14.3,2.2,38,mcbrika01\n",
    "Ezi Magbegor,13.8,3.8,40,magbeez01\n",
    "Marina Mabrey,15.0,2.6,39,mabrema01\n",
    "Jewell Loyd,24.7,3.4,38,loydje01\n",
    "Betnijah Laney,12.8,3.4,40,laneybe01\n",
    "Awak Kuier,2.6,0.4,37,kuieraw01\n",
    "Sika Koné,3.6,0.4,20,konesi01\n",
    "Dorka Juhász,6.0,2.1,38,juhasdo01\n",
    "Jonquel Jones,11.3,4.7,40,jonesjo04\n",
    "Haley Jones,3.7,-0.4,40,jonesha01\n",
    "Brionna Jones,15.9,2.3,13,jonesbr02\n",
    "Marine Johannes,7.1,1.0,35,johanma01\n",
    "Ashley Joens,2.1,-0.1,19,joensas01\n",
    "Moriah Jefferson,10.5,0.8,39,jeffemo01\n",
    "Sabrina Ionescu,17.0,5.6,36,ionessa01\n",
    "Lexie Hull,4.6,0.2,30,hullle01\n",
    "Rhyne Howard,17.5,3.5,39,howarrh01\n",
    "Natasha Howard,16.5,3.7,39,howarna01\n",
    "Jordan Horston,6.9,-0.7,36,horstjo02\n",
    "Joyner Holmes,3.3,0.5,34,holmejo03\n",
    "Myisha Hines-Allen,5.6,0.0,35,hinesmy01\n",
    "Khaalia Hillsman,0.0,0.0,1,hillskh01\n",
    "Naz Hillmon,4.1,1.2,40,hillmna01\n",
    "Natisha Hiedeman,8.5,1.5,40,hiedena01\n",
    "Destanni Henderson,3.8,-0.1,15,hendede01\n",
    "Ruthy Hebard,3.9,0.9,19,hebarru01\n",
    "Tiffany Hayes,12.1,4.2,40,hayesti01\n",
    "Tianna Hawkins,8.2,2.8,40,hawkiti01\n",
    "Bernadett Hatar,2.0,0.0,6,hatarbe01\n",
    "Tyasha Harris,5.8,0.9,40,harrity01\n",
    "Linnae Harper,1.4,-0.1,14,harpeli01\n",
    "Dearica Hamby,8.9,1.6,40,hambyde01\n",
    "Megan Gustafson,7.9,1.6,34,gustame01\n",
    "Arella Guirantes,1.3,-0.1,9,guiraar01\n",
    "Brittney Griner,17.5,3.1,31,grinebr01\n",
    "Chelsea Gray,15.3,7.0,40,graych01\n",
    "Allisha Gray,17.1,5.0,38,grayal01\n",
    "Cyesha Goree,3.9,0.2,10,goreecy01\n",
    "Cayla George,2.3,-0.7,32,francca01\n",
    "Rebekah Gardner,7.0,0.2,3,gardnre01\n",
    "Dulcy Fankam Mendjiadeu,3.9,0.9,34,fankadu01\n",
    "Dana Evans,9.0,0.6,39,evansda03\n",
    "Emily Engstler,1.8,-0.1,12,engstem01\n",
    "Queen Egbo,4.8,0.9,37,egboqu01\n",
    "AD Durr,4.8,-0.1,36,durras01\n",
    "Stefanie Dolson,4.0,0.7,23,dolsost01\n",
    "Ivana Dojkić,6.5,0.6,23,dojkiiv01\n",
    "Liz Dixon,1.9,0.2,14,dixonli01\n",
    "Jasmine Dickey,2.1,-0.1,14,dickeja01\n",
    "Elena Delle Donne,16.7,2.9,23,delleel01\n",
    "Crystal Dangerfield,8.2,1.6,35,dangecr01\n",
    "Sophie Cunningham,11.3,1.3,31,cunniso01\n",
    "Lorela Cubaj,0.0,0.0,3,cubajlo01\n",
    "Lauren Cox,0.0,0.0,1,coxla01\n",
    "Kahleah Copper,18.7,2.1,38,coppeka01\n",
    "Zia Cooke,4.8,-1.2,39,cookezi01\n",
    "Sydney Colson,1.3,0.6,28,colsosy01\n",
    "Napheesa Collier,21.5,5.2,37,collina01\n",
    "Nia Coffey,6.9,1.0,31,coffeni01\n",
    "Alaina Coates,0.9,0.0,12,coateal01\n",
    "Nia Clouden,1.6,-0.2,5,cloudni01\n",
    "Natasha Cloud,12.7,2.6,37,cloudna02\n",
    "Alysha Clark,6.7,2.6,39,clarkal01\n",
    "Layshia Clarendon,11.1,1.9,24,clarela01\n",
    "Kaila Charles,1.5,-0.1,4,charlka01\n",
    "DiJonai Carrington,8.3,1.3,32,carridi01\n",
    "Bridget Carleton,3.2,0.5,38,carlebr01\n",
    "Emma Cannon,5.8,0.6,30,cannoem01\n",
    "Jordin Canada,13.3,3.4,38,canadjo02\n",
    "Maya Caldwell,1.9,-0.7,30,caldwma01\n",
    "Veronica Burton,2.4,1.6,40,burtove01\n",
    "Rae Burrell,3.6,0.5,29,burrera01\n",
    "Lexie Brown,12.4,1.1,12,brownle04\n",
    "Leigha Brown,0.8,-0.1,25,brownle05\n",
    "Kalani Brown,7.8,2.5,32,brownka01\n",
    "Aliyah Boston,14.5,6.0,40,bostoal01\n",
    "DeWanna Bonner,17.4,5.4,40,bonnede01\n",
    "Monique Billings,4.8,1.1,39,billimo01\n",
    "Morgan Bertsch,4.4,0.1,28,bertsmo01\n",
    "Grace Berger,4.2,0.6,36,bergegr01\n",
    "Kierstan Bell,3.7,0.1,36,bellki01\n",
    "Rachel Banham,5.5,0.0,32,banhara01\n",
    "Shakira Austin,10.0,0.9,19,austish01\n",
    "Ariel Atkins,11.5,2.1,27,atkinar01\n",
    "Kristine Anigwe,1.9,0.0,13,anigwkr01\n",
    "Laeticia Amihere,2.7,0.0,21,amihela01\n",
    "Rebecca Allen,6.4,1.9,40,allenre01\n",
    "Lindsay Allen,6.2,0.9,29,allenli01\"\"\"\n",
    "\n",
    "# Use StringIO to simulate a file object\n",
    "data_io2 = StringIO(data2)\n",
    "\n",
    "# Read the data into a DataFrame\n",
    "df23 = pd.read_csv(data_io2, names=column_names)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Player</th>\n",
       "      <th>PTS/G</th>\n",
       "      <th>WS</th>\n",
       "      <th>G</th>\n",
       "      <th>id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>Amanda Zahui B.</td>\n",
       "      <td>1.7</td>\n",
       "      <td>-0.4</td>\n",
       "      <td>34</td>\n",
       "      <td>zahuiam01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>Jackie Young</td>\n",
       "      <td>17.6</td>\n",
       "      <td>7.5</td>\n",
       "      <td>40</td>\n",
       "      <td>youngja04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>Han Xu</td>\n",
       "      <td>1.5</td>\n",
       "      <td>-0.2</td>\n",
       "      <td>8</td>\n",
       "      <td>xuha01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>A'ja Wilson</td>\n",
       "      <td>22.8</td>\n",
       "      <td>10.4</td>\n",
       "      <td>40</td>\n",
       "      <td>wilsoa01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>Jocelyn Willoughby</td>\n",
       "      <td>1.2</td>\n",
       "      <td>0.3</td>\n",
       "      <td>29</td>\n",
       "      <td>willojo01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>151</td>\n",
       "      <td>Ariel Atkins</td>\n",
       "      <td>11.5</td>\n",
       "      <td>2.1</td>\n",
       "      <td>27</td>\n",
       "      <td>atkinar01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>152</td>\n",
       "      <td>Kristine Anigwe</td>\n",
       "      <td>1.9</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13</td>\n",
       "      <td>anigwkr01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>153</td>\n",
       "      <td>Laeticia Amihere</td>\n",
       "      <td>2.7</td>\n",
       "      <td>0.0</td>\n",
       "      <td>21</td>\n",
       "      <td>amihela01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>154</td>\n",
       "      <td>Rebecca Allen</td>\n",
       "      <td>6.4</td>\n",
       "      <td>1.9</td>\n",
       "      <td>40</td>\n",
       "      <td>allenre01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>155</td>\n",
       "      <td>Lindsay Allen</td>\n",
       "      <td>6.2</td>\n",
       "      <td>0.9</td>\n",
       "      <td>29</td>\n",
       "      <td>allenli01</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>156 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 Player  PTS/G    WS   G         id\n",
       "0       Amanda Zahui B.    1.7  -0.4  34  zahuiam01\n",
       "1          Jackie Young   17.6   7.5  40  youngja04\n",
       "2                Han Xu    1.5  -0.2   8     xuha01\n",
       "3           A'ja Wilson   22.8  10.4  40   wilsoa01\n",
       "4    Jocelyn Willoughby    1.2   0.3  29  willojo01\n",
       "..                  ...    ...   ...  ..        ...\n",
       "151        Ariel Atkins   11.5   2.1  27  atkinar01\n",
       "152     Kristine Anigwe    1.9   0.0  13  anigwkr01\n",
       "153    Laeticia Amihere    2.7   0.0  21  amihela01\n",
       "154       Rebecca Allen    6.4   1.9  40  allenre01\n",
       "155       Lindsay Allen    6.2   0.9  29  allenli01\n",
       "\n",
       "[156 rows x 5 columns]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df23"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Player</th>\n",
       "      <th>ppg_23</th>\n",
       "      <th>ws_23</th>\n",
       "      <th>G_23</th>\n",
       "      <th>ppg_24</th>\n",
       "      <th>ws_24</th>\n",
       "      <th>G_24</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>Jackie Young</td>\n",
       "      <td>17.6</td>\n",
       "      <td>7.5</td>\n",
       "      <td>40</td>\n",
       "      <td>18.5</td>\n",
       "      <td>3.2</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>A'ja Wilson</td>\n",
       "      <td>22.8</td>\n",
       "      <td>10.4</td>\n",
       "      <td>40</td>\n",
       "      <td>27.2</td>\n",
       "      <td>7.0</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>Elizabeth Williams</td>\n",
       "      <td>9.8</td>\n",
       "      <td>3.7</td>\n",
       "      <td>40</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.8</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>Courtney Williams</td>\n",
       "      <td>10.4</td>\n",
       "      <td>2.4</td>\n",
       "      <td>40</td>\n",
       "      <td>9.8</td>\n",
       "      <td>0.9</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>Sami Whitcomb</td>\n",
       "      <td>9.7</td>\n",
       "      <td>1.5</td>\n",
       "      <td>40</td>\n",
       "      <td>5.3</td>\n",
       "      <td>0.7</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>104</td>\n",
       "      <td>Shakira Austin</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.9</td>\n",
       "      <td>19</td>\n",
       "      <td>11.7</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>105</td>\n",
       "      <td>Ariel Atkins</td>\n",
       "      <td>11.5</td>\n",
       "      <td>2.1</td>\n",
       "      <td>27</td>\n",
       "      <td>15.8</td>\n",
       "      <td>1.3</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>106</td>\n",
       "      <td>Laeticia Amihere</td>\n",
       "      <td>2.7</td>\n",
       "      <td>0.0</td>\n",
       "      <td>21</td>\n",
       "      <td>1.2</td>\n",
       "      <td>-0.3</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>107</td>\n",
       "      <td>Rebecca Allen</td>\n",
       "      <td>6.4</td>\n",
       "      <td>1.9</td>\n",
       "      <td>40</td>\n",
       "      <td>7.4</td>\n",
       "      <td>0.4</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>108</td>\n",
       "      <td>Lindsay Allen</td>\n",
       "      <td>6.2</td>\n",
       "      <td>0.9</td>\n",
       "      <td>29</td>\n",
       "      <td>5.2</td>\n",
       "      <td>0.9</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>109 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 Player  ppg_23  ws_23  G_23  ppg_24  ws_24  G_24\n",
       "0          Jackie Young    17.6    7.5    40    18.5    3.2    23\n",
       "1           A'ja Wilson    22.8   10.4    40    27.2    7.0    24\n",
       "2    Elizabeth Williams     9.8    3.7    40    10.0    0.8     9\n",
       "3     Courtney Williams    10.4    2.4    40     9.8    0.9    25\n",
       "4         Sami Whitcomb     9.7    1.5    40     5.3    0.7    25\n",
       "..                  ...     ...    ...   ...     ...    ...   ...\n",
       "104      Shakira Austin    10.0    0.9    19    11.7    0.0     6\n",
       "105        Ariel Atkins    11.5    2.1    27    15.8    1.3    25\n",
       "106    Laeticia Amihere     2.7    0.0    21     1.2   -0.3    11\n",
       "107       Rebecca Allen     6.4    1.9    40     7.4    0.4    18\n",
       "108       Lindsay Allen     6.2    0.9    29     5.2    0.9    24\n",
       "\n",
       "[109 rows x 7 columns]"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#merge 2023 and 2024 stats together\n",
    "result_df = pd.merge(df23, df24, on='id', how='inner')\n",
    "\n",
    "# renaming the columns\n",
    "result_df.rename(columns={\n",
    "    'Player_x': 'Player',\n",
    "    'PTS/G_x': 'ppg_23',\n",
    "    'WS_x': 'ws_23',\n",
    "    'G_x': 'G_23',\n",
    "    'Player_y': 'Player_24',\n",
    "    'PTS/G_y': 'ppg_24',\n",
    "    'WS_y': 'ws_24',\n",
    "    'G_y': 'G_24',\n",
    "}, inplace=True)\n",
    "\n",
    "# Dropping the 'Player_23' column as it is redundant\n",
    "result_df.drop(columns=['Player_24', 'id'], inplace=True)\n",
    "\n",
    "result_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                       Player  ppg_23  ppg_24  ppg_diff\n",
      "22               Odyssey Sims     2.0    17.2      15.2\n",
      "23             Maddy Siegrist     3.7    14.6      10.9\n",
      "65              Dearica Hamby     8.9    19.2      10.3\n",
      "74            Stefanie Dolson     4.0    10.3       6.3\n",
      "92              Maya Caldwell     1.9     8.1       6.2\n",
      "89           Bridget Carleton     3.2     8.9       5.7\n",
      "64              Tyasha Harris     5.8    11.0       5.2\n",
      "88         DiJonai Carrington     8.3    12.9       4.6\n",
      "80             Kahleah Copper    18.7    23.2       4.5\n",
      "1                 A'ja Wilson    22.8    27.2       4.4\n",
      "105              Ariel Atkins    11.5    15.8       4.3\n",
      "99           Monique Billings     4.8     8.8       4.0\n",
      "18              Azura Stevens    10.8    14.8       4.0\n",
      "49              Jonquel Jones    11.3    15.3       4.0\n",
      "28              Aerial Powers     5.2     8.6       3.4\n",
      "39             Jade Melbourne     2.6     5.6       3.0\n",
      "53            Sabrina Ionescu    17.0    19.8       2.8\n",
      "59         Myisha Hines-Allen     5.6     8.4       2.8\n",
      "72             Emily Engstler     1.8     4.5       2.7\n",
      "21               Alanna Smith     9.2    11.5       2.3\n",
      "25           Karlie Samuelson     7.7     9.9       2.2\n",
      "42              Kayla McBride    14.3    16.4       2.1\n",
      "50                Haley Jones     3.7     5.5       1.8\n",
      "7    Shatori Walker-Kimbrough     6.3     8.0       1.7\n",
      "104            Shakira Austin    10.0    11.7       1.7\n",
      "34                  Kia Nurse     5.9     7.5       1.6\n",
      "11             Kayla Thornton     4.5     6.1       1.6\n",
      "40              Aari McDonald     7.9     9.3       1.4\n",
      "94                Rae Burrell     3.6     5.0       1.4\n",
      "67            Brittney Griner    17.5    18.6       1.1\n",
      "33           Arike Ogunbowale    21.2    22.3       1.1\n",
      "57             Jordan Horston     6.9     8.0       1.1\n",
      "107             Rebecca Allen     6.4     7.4       1.0\n",
      "0                Jackie Young    17.6    18.5       0.9\n",
      "26              Nyara Sabally     2.3     3.1       0.8\n",
      "79               Lorela Cubaj     0.0     0.8       0.8\n",
      "82              Sydney Colson     1.3     1.9       0.6\n",
      "93            Veronica Burton     2.4     2.9       0.5\n",
      "62         Destanni Henderson     3.8     4.0       0.2\n",
      "2          Elizabeth Williams     9.8    10.0       0.2\n",
      "13              Diana Taurasi    16.0    16.1       0.1\n",
      "56             Natasha Howard    16.5    16.6       0.1\n",
      "60                Naz Hillmon     4.1     4.2       0.1\n"
     ]
    }
   ],
   "source": [
    "# Calculate the difference in ppg between 2024 and 2023\n",
    "result_df['ppg_diff'] = result_df['ppg_24'] - result_df['ppg_23']\n",
    "\n",
    "# Filter the players who had an increase in ppg\n",
    "result_df_increased = result_df[result_df['ppg_diff'] > 0]\n",
    "\n",
    "# Sort the DataFrame by the ppg difference in descending order\n",
    "result_df_increased_sorted = result_df_increased.sort_values(by='ppg_diff', ascending=False)\n",
    "\n",
    "# Display the resulting DataFrame\n",
    "print(result_df_increased_sorted[['Player', 'ppg_23', 'ppg_24', 'ppg_diff']])\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                 Player  G_23   ws/g_23  G_24   ws/g_24  ws/g_diff\n",
      "22         Odyssey Sims    28  0.003571     9  0.133333   0.129762\n",
      "18        Azura Stevens    35  0.034286     4  0.150000   0.115714\n",
      "42        Kayla McBride    38  0.057895    25  0.172000   0.114105\n",
      "57       Jordan Horston    36 -0.019444    25  0.072000   0.091444\n",
      "89     Bridget Carleton    38  0.013158    24  0.104167   0.091009\n",
      "43         Ezi Magbegor    40  0.095000    25  0.180000   0.085000\n",
      "64        Tyasha Harris    40  0.022500    23  0.086957   0.064457\n",
      "65        Dearica Hamby    40  0.040000    24  0.104167   0.064167\n",
      "49        Jonquel Jones    40  0.117500    25  0.180000   0.062500\n",
      "59   Myisha Hines-Allen    35  0.000000    25  0.060000   0.060000\n",
      "88   DiJonai Carrington    32  0.040625    24  0.100000   0.059375\n",
      "72       Emily Engstler    12 -0.008333    18  0.050000   0.058333\n",
      "83     Napheesa Collier    37  0.140541    20  0.195000   0.054459\n",
      "21         Alanna Smith    38  0.092105    25  0.144000   0.051895\n",
      "32       Nneka Ogwumike    36  0.155556    22  0.204545   0.048990\n",
      "26        Nyara Sabally    33  0.015152    11  0.063636   0.048485\n",
      "36     Tiffany Mitchell    33 -0.018182    24  0.029167   0.047348\n",
      "74      Stefanie Dolson    23  0.030435    24  0.070833   0.040399\n",
      "60          Naz Hillmon    40  0.030000    24  0.066667   0.036667\n",
      "23       Maddy Siegrist    39  0.035897    13  0.069231   0.033333\n",
      "67      Brittney Griner    31  0.100000    15  0.133333   0.033333\n",
      "1           A'ja Wilson    40  0.260000    24  0.291667   0.031667\n",
      "45          Jewell Loyd    38  0.089474    25  0.120000   0.030526\n",
      "78    Sophie Cunningham    31  0.041935    25  0.072000   0.030065\n",
      "103       Rachel Banham    32  0.000000    21  0.028571   0.028571\n",
      "27     Mercedes Russell    37  0.010811    23  0.039130   0.028320\n",
      "13        Diana Taurasi    26  0.042308    21  0.066667   0.024359\n",
      "28        Aerial Powers    20  0.000000    17  0.023529   0.023529\n",
      "92        Maya Caldwell    30 -0.023333     9  0.000000   0.023333\n",
      "31   Michaela Onyenwere    40 -0.017500    18  0.005556   0.023056\n",
      "20        NaLyssa Smith    31  0.038710    26  0.061538   0.022829\n",
      "71           Dana Evans    39  0.015385    24  0.033333   0.017949\n",
      "55         Rhyne Howard    39  0.089744    14  0.107143   0.017399\n",
      "46       Betnijah Laney    40  0.085000    18  0.100000   0.015000\n",
      "8      Victoria Vivians    38  0.015789    24  0.029167   0.013377\n",
      "93      Veronica Burton    40  0.040000    15  0.053333   0.013333\n",
      "19         Taylor Soule    15 -0.013333     2  0.000000   0.013333\n",
      "48         Dorka Juhász    38  0.055263    22  0.068182   0.012919\n",
      "52     Moriah Jefferson    39  0.020513     9  0.033333   0.012821\n",
      "98       DeWanna Bonner    40  0.135000    24  0.145833   0.010833\n",
      "11       Kayla Thornton    40  0.057500    25  0.068000   0.010500\n",
      "94          Rae Burrell    29  0.017241    21  0.023810   0.006568\n",
      "108       Lindsay Allen    29  0.031034    24  0.037500   0.006466\n",
      "81            Zia Cooke    39 -0.030769    20 -0.025000   0.005769\n",
      "58        Joyner Holmes    34  0.014706    15  0.020000   0.005294\n",
      "40        Aari McDonald    24  0.025000    24  0.029167   0.004167\n",
      "12        Alyssa Thomas    40  0.152500    24  0.154167   0.001667\n",
      "6        Kristy Wallace    37  0.008108    22  0.009091   0.000983\n",
      "80       Kahleah Copper    38  0.055263    25  0.056000   0.000737\n",
      "85        Natasha Cloud    37  0.070270    24  0.070833   0.000563\n"
     ]
    }
   ],
   "source": [
    "# Calculate ws/g for each player in 2023 and 2024\n",
    "result_df['ws/g_23'] = result_df['ws_23'] / result_df['G_23']\n",
    "result_df['ws/g_24'] = result_df['ws_24'] / result_df['G_24']\n",
    "\n",
    "# Calculate the difference in ws/g between 2024 and 2023\n",
    "result_df['ws/g_diff'] = result_df['ws/g_24'] - result_df['ws/g_23']\n",
    "\n",
    "# Filter the players who had an increase in ws/g\n",
    "result_df_increased_ws = result_df[result_df['ws/g_diff'] > 0]\n",
    "\n",
    "# Sort the DataFrame by the ws/g difference in descending order\n",
    "result_df_increased_ws_sorted = result_df_increased_ws.sort_values(by='ws/g_diff', ascending=False)\n",
    "\n",
    "# Display the resulting DataFrame\n",
    "print(result_df_increased_ws_sorted[['Player', 'G_23', 'ws/g_23', 'G_24', 'ws/g_24', 'ws/g_diff']])"
   ]
  },
  {
   "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
}