Skip to content

Instantly share code, notes, and snippets.

@timbledum
Last active April 23, 2019 01:46
Show Gist options
  • Save timbledum/73dc4aadaff098c57f57224e6e219887 to your computer and use it in GitHub Desktop.
Save timbledum/73dc4aadaff098c57f57224e6e219887 to your computer and use it in GitHub Desktop.
Display the source blob
Display the rendered blob
Raw
{
"cells": [
{
"cell_type": "code",
"execution_count": 1,
"metadata": {},
"outputs": [],
"source": [
"from pandas import read_excel"
]
},
{
"cell_type": "code",
"execution_count": 2,
"metadata": {},
"outputs": [],
"source": [
"class Card:\n",
" def __init__(self, name, rating):\n",
" self.name = name\n",
" self.rating = rating\n",
"\n",
" def __repr__(self):\n",
" return f'rating: {self.rating}, name: {self.name}'"
]
},
{
"cell_type": "code",
"execution_count": 3,
"metadata": {},
"outputs": [],
"source": [
"file_name = 'war.xlsx'\n",
"df = read_excel(file_name, skiprows=3)"
]
},
{
"cell_type": "code",
"execution_count": 4,
"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>Unnamed: 0</th>\n",
" <th>Unnamed: 1</th>\n",
" <th>White</th>\n",
" <th>Blue</th>\n",
" <th>Black</th>\n",
" <th>Red</th>\n",
" <th>Green</th>\n",
" <th>Gold</th>\n",
" <th>Unnamed: 8</th>\n",
" <th>Colorless</th>\n",
" <th>Lands</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>NaN</td>\n",
" <td>10.00</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>NaN</td>\n",
" <td>9.00</td>\n",
" <td>God-Eternal Oketra</td>\n",
" <td>NaN</td>\n",
" <td>Liana, Dreadhorde General</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>God-Eternal Bontu</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Nicol Bolas, Dragon-God</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>God-Eternal Kefnet</td>\n",
" <td>Finale of Eternity</td>\n",
" <td>Illharg, the Raze-Boar</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>NaN</td>\n",
" <td>8.00</td>\n",
" <td>Finale of Glory</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Kenko, Tin Street Kingpin</td>\n",
" <td>God-Eternal Rhonas</td>\n",
" <td>Ajani, the Greathearted</td>\n",
" <td>Tolsimir, Friend to Wolves</td>\n",
" <td>Ugin, the Ineffable</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>NaN</td>\n",
" <td>7.00</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Neheb, Dreadhorde Champion</td>\n",
" <td>NaN</td>\n",
" <td>Roalesk, Apex Hybrid</td>\n",
" <td>Feather, the Redeemed</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>NaN</td>\n",
" <td>6.50</td>\n",
" <td>NaN</td>\n",
" <td>Commence the Endgame</td>\n",
" <td>NaN</td>\n",
" <td>Sarkhan the Masterless</td>\n",
" <td>NaN</td>\n",
" <td>Storrev, Devkarin Lich</td>\n",
" <td>Time Wipe</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Gideon Blackblade</td>\n",
" <td>Jace Wielder of Mysteries</td>\n",
" <td>NaN</td>\n",
" <td>Chandra, Fire Artisan</td>\n",
" <td>Nissa, Who Shakes the World</td>\n",
" <td>Domri, Anarch of Bolas</td>\n",
" <td>Enter the God-Eternals</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Awakening of Vitu-Ghazi</td>\n",
" <td>Ral, Storm Conduit</td>\n",
" <td>Widespread Brutality</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Sorin, Vengeful Bloodlord</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Teferi, Time Raveler</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Casualties of War</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Finale of Revelation</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Niv-Mizzet Reborn</td>\n",
" <td>Kaya, Bane of the Dead</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>NaN</td>\n",
" <td>6.25</td>\n",
" <td>Prison Realm</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Vivien, Champion of the Wilds</td>\n",
" <td>Living Twister</td>\n",
" <td>Deathsprout</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Massacre Girl</td>\n",
" <td>NaN</td>\n",
" <td>Planewide Celebration</td>\n",
" <td>Oath of Kaya</td>\n",
" <td>Elite Guardmage</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Ral's Outburst</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Trusted Pegasus</td>\n",
" <td>Kasmina Enigmatic Mentor</td>\n",
" <td>NaN</td>\n",
" <td>Jaya, Venerated Firemage</td>\n",
" <td>NaN</td>\n",
" <td>Bioessence Hydra</td>\n",
" <td>Despark</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>NaN</td>\n",
" <td>5.80</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Saheeli, Sublime Artificer</td>\n",
" <td>Soul Diviner</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>NaN</td>\n",
" <td>5.70</td>\n",
" <td>Law-Rune Enforcer</td>\n",
" <td>Tamiyo's Epiphany</td>\n",
" <td>Ob Nixilis's Cruelty</td>\n",
" <td>NaN</td>\n",
" <td>Band Together</td>\n",
" <td>Leyline Prowler</td>\n",
" <td>Angrath, Captain of Chaos</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Dreadhorde Invasion</td>\n",
" <td>Cyclops Electromancer</td>\n",
" <td>Arlinn, Voice of the Pack</td>\n",
" <td>Merfolk Skydiver</td>\n",
" <td>Invade the City</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>NaN</td>\n",
" <td>5.60</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Bleeding Edge</td>\n",
" <td>Chandra's Triumph</td>\n",
" <td>NaN</td>\n",
" <td>Heartwarming Redemption</td>\n",
" <td>Samut, Tyrant Smasher</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Ob Nixlis, the Hate-Twisted</td>\n",
" <td>Tibalt, Rakish Instigator</td>\n",
" <td>NaN</td>\n",
" <td>Domri's Ambush</td>\n",
" <td>Tyrant's Scorn</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>NaN</td>\n",
" <td>5.50</td>\n",
" <td>Grateful Apparition</td>\n",
" <td>Aven Eternal</td>\n",
" <td>Spark Harvest</td>\n",
" <td>Jaya's Greeting</td>\n",
" <td>NaN</td>\n",
" <td>Pledge of Unity</td>\n",
" <td>Gleaming Overseer</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Tomik, Distinguished Advokist</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Rising Populace</td>\n",
" <td>Rescuer Sphinx</td>\n",
" <td>NaN</td>\n",
" <td>Spellgorger Weird</td>\n",
" <td>NaN</td>\n",
" <td>Mayhem Devil</td>\n",
" <td>Angrath's Rampage</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td>NaN</td>\n",
" <td>5.40</td>\n",
" <td>Wanderer's Strike</td>\n",
" <td>Thunder Drake</td>\n",
" <td>Command the Dreadhorde</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Nahiri, Storm of Stone</td>\n",
" <td>Kiora, Behemoth Beckoner</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Callous Dismissal</td>\n",
" <td>NaN</td>\n",
" <td>Mizzium Tank</td>\n",
" <td>Jiang Yanggu, Wildcrafter</td>\n",
" <td>Vraska, Swarm's Eminence</td>\n",
" <td>Role Reversal</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Paradise Druid</td>\n",
" <td>Solar Blaze</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Gateway Plaza</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Eternal Skylord</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Bloom Hulk</td>\n",
" <td>Tamiyo, Collector of Tales</td>\n",
" <td>Tenth District Legionnaire</td>\n",
" <td>Mana Geode</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Angur of Bolas</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>New Horizons</td>\n",
" <td>Hualti's Raptor</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\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",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>39</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Spellkeeper Weird</td>\n",
" <td>NaN</td>\n",
" <td>Raging Kronch</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Mobilized District</td>\n",
" </tr>\n",
" <tr>\n",
" <th>40</th>\n",
" <td>NaN</td>\n",
" <td>5.00</td>\n",
" <td>Bond of Discipline</td>\n",
" <td>No Escape</td>\n",
" <td>Lazotep Reaver</td>\n",
" <td>Ahn-Crop Invader</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Prismite</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>41</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Battlefield Promotion</td>\n",
" <td>Narset's Reversal</td>\n",
" <td>Toll of the Invasion</td>\n",
" <td>Tibalt's Rager</td>\n",
" <td>Wardscale Crocodile</td>\n",
" <td>Ashiok, Dream Render</td>\n",
" <td>NaN</td>\n",
" <td>Ugin's Conjurant</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>42</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Defiant Strike</td>\n",
" <td>Kasmina's Transmutation</td>\n",
" <td>Herald of the Dreadhorde</td>\n",
" <td>Burning Prophet</td>\n",
" <td>Vivien's Grizzly</td>\n",
" <td>Huatli, the Sun's Heart</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>43</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Enforcer Griffin</td>\n",
" <td>NaN</td>\n",
" <td>Spark Reaper</td>\n",
" <td>Honor the God-Pharaoh</td>\n",
" <td>Giant Growth</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>44</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Martyr for the Cause</td>\n",
" <td>Narset, Parter of Veils</td>\n",
" <td>Shriekdiver</td>\n",
" <td>Chainwip Cyclops</td>\n",
" <td>Kronch Wrangler</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>45</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Rally of Wings</td>\n",
" <td>Ashiok's Skulker</td>\n",
" <td>Dreadmalkin</td>\n",
" <td>Dreadhorde Arcanist</td>\n",
" <td>Snarespinner</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>46</th>\n",
" <td>NaN</td>\n",
" <td>4.90</td>\n",
" <td>The Wanderer</td>\n",
" <td>Sky Theater Strix</td>\n",
" <td>Sorin's Thirst</td>\n",
" <td>Bolt Bend</td>\n",
" <td>Forced Landing</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Saheeli's Silverwing</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>47</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Teyo's Lightshield</td>\n",
" <td>Jace's Triumph</td>\n",
" <td>Price of Betrayal</td>\n",
" <td>Grim Intiate</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>48</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Pouncing Lynx</td>\n",
" <td>Silent Submersive</td>\n",
" <td>Vraska's Finisher</td>\n",
" <td>Nahiri's Stoneblades</td>\n",
" <td>Arlinn's Wolf</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>49</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Gideon's Triumph</td>\n",
" <td>Kiora's Dambreaker</td>\n",
" <td>Aid the Fallen</td>\n",
" <td>NaN</td>\n",
" <td>Return to Nature</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>50</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Topple the Statue</td>\n",
" <td>Teferi's Time Twist</td>\n",
" <td>Unlikely Aid</td>\n",
" <td>Sarkhan's Catharsis</td>\n",
" <td>Kraul Stinger</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>51</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Ravnica at War</td>\n",
" <td>NaN</td>\n",
" <td>Deliver Unto Evil</td>\n",
" <td>Heartfire</td>\n",
" <td>Thundering Ceratok</td>\n",
" <td>Dovin's Veto</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Interplanar Beacon</td>\n",
" </tr>\n",
" <tr>\n",
" <th>52</th>\n",
" <td>NaN</td>\n",
" <td>4.80</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Duskmantle Operative</td>\n",
" <td>Devouring Hellion</td>\n",
" <td>Finale of Devastation</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>53</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Makeshift Battalion</td>\n",
" <td>Crush Dissent</td>\n",
" <td>Tithebearer Giant</td>\n",
" <td>Finale of Promise</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>God-Pharaoh's Statue</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>54</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Baulwark Giant</td>\n",
" <td>Relentless Advance</td>\n",
" <td>Bond of Revival</td>\n",
" <td>NaN</td>\n",
" <td>Steady Aim</td>\n",
" <td>NaN</td>\n",
" <td>Neoform</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>55</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Loxodon Sergeant</td>\n",
" <td>Bond of Insight</td>\n",
" <td>Vampire Opportunist</td>\n",
" <td>Invading Manticore</td>\n",
" <td>Courage in Crisis</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>56</th>\n",
" <td>NaN</td>\n",
" <td>4.70</td>\n",
" <td>Ignite the Beacon</td>\n",
" <td>Stealth Mission</td>\n",
" <td>Lazotep Behemoth</td>\n",
" <td>Samut's Sprint</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Karn, the Great Creator</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>57</th>\n",
" <td>NaN</td>\n",
" <td>4.60</td>\n",
" <td>NaN</td>\n",
" <td>Lazotep Plating</td>\n",
" <td>NaN</td>\n",
" <td>Bond of Passion</td>\n",
" <td>Bond of Flourishing</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>58</th>\n",
" <td>NaN</td>\n",
" <td>4.50</td>\n",
" <td>Single Combat</td>\n",
" <td>Totally Lost</td>\n",
" <td>Liliana's Triumph</td>\n",
" <td>Goblin Assault Team</td>\n",
" <td>Primordial Wurm</td>\n",
" <td>Dovin, Hando of Control</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>59</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Gideon's Sacrifice</td>\n",
" <td>Wall of Runes</td>\n",
" <td>Charity Extractor</td>\n",
" <td>Goblin Assailant</td>\n",
" <td>Storm the Citadel</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>60</th>\n",
" <td>NaN</td>\n",
" <td>4.40</td>\n",
" <td>Ironclad Krovod</td>\n",
" <td>NaN</td>\n",
" <td>Davriel's Shadowfugue</td>\n",
" <td>NaN</td>\n",
" <td>Nissa's Triumph</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>61</th>\n",
" <td>NaN</td>\n",
" <td>4.20</td>\n",
" <td>NaN</td>\n",
" <td>Naga Eternal</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Arboreal Grazer</td>\n",
" <td>Tezzeret, Master of the Bridge</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>62</th>\n",
" <td>NaN</td>\n",
" <td>4.00</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>63</th>\n",
" <td>NaN</td>\n",
" <td>3.75</td>\n",
" <td>Charmed Stray</td>\n",
" <td>NaN</td>\n",
" <td>Banehound</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>64</th>\n",
" <td>NaN</td>\n",
" <td>3.50</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Kaya's Ghostform</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>65</th>\n",
" <td>NaN</td>\n",
" <td>3.00</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Demolish</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>66</th>\n",
" <td>NaN</td>\n",
" <td>2.00</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>67</th>\n",
" <td>NaN</td>\n",
" <td>1.00</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Emergence Zone</td>\n",
" </tr>\n",
" <tr>\n",
" <th>68</th>\n",
" <td>NaN</td>\n",
" <td>0.00</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>69 rows × 11 columns</p>\n",
"</div>"
],
"text/plain": [
" Unnamed: 0 Unnamed: 1 White \\\n",
"0 NaN 10.00 NaN \n",
"1 NaN 9.00 God-Eternal Oketra \n",
"2 NaN NaN NaN \n",
"3 NaN NaN NaN \n",
"4 NaN 8.00 Finale of Glory \n",
"5 NaN 7.00 NaN \n",
"6 NaN 6.50 NaN \n",
"7 NaN NaN Gideon Blackblade \n",
"8 NaN NaN NaN \n",
"9 NaN NaN NaN \n",
"10 NaN NaN NaN \n",
"11 NaN NaN NaN \n",
"12 NaN NaN NaN \n",
"13 NaN 6.25 Prison Realm \n",
"14 NaN NaN NaN \n",
"15 NaN NaN NaN \n",
"16 NaN NaN Trusted Pegasus \n",
"17 NaN 5.80 NaN \n",
"18 NaN 5.70 Law-Rune Enforcer \n",
"19 NaN NaN NaN \n",
"20 NaN 5.60 NaN \n",
"21 NaN NaN NaN \n",
"22 NaN 5.50 Grateful Apparition \n",
"23 NaN NaN Tomik, Distinguished Advokist \n",
"24 NaN NaN Rising Populace \n",
"25 NaN 5.40 Wanderer's Strike \n",
"26 NaN NaN NaN \n",
"27 NaN NaN NaN \n",
"28 NaN NaN NaN \n",
"29 NaN NaN NaN \n",
".. ... ... ... \n",
"39 NaN NaN NaN \n",
"40 NaN 5.00 Bond of Discipline \n",
"41 NaN NaN Battlefield Promotion \n",
"42 NaN NaN Defiant Strike \n",
"43 NaN NaN Enforcer Griffin \n",
"44 NaN NaN Martyr for the Cause \n",
"45 NaN NaN Rally of Wings \n",
"46 NaN 4.90 The Wanderer \n",
"47 NaN NaN Teyo's Lightshield \n",
"48 NaN NaN Pouncing Lynx \n",
"49 NaN NaN Gideon's Triumph \n",
"50 NaN NaN Topple the Statue \n",
"51 NaN NaN Ravnica at War \n",
"52 NaN 4.80 NaN \n",
"53 NaN NaN Makeshift Battalion \n",
"54 NaN NaN Baulwark Giant \n",
"55 NaN NaN Loxodon Sergeant \n",
"56 NaN 4.70 Ignite the Beacon \n",
"57 NaN 4.60 NaN \n",
"58 NaN 4.50 Single Combat \n",
"59 NaN NaN Gideon's Sacrifice \n",
"60 NaN 4.40 Ironclad Krovod \n",
"61 NaN 4.20 NaN \n",
"62 NaN 4.00 NaN \n",
"63 NaN 3.75 Charmed Stray \n",
"64 NaN 3.50 NaN \n",
"65 NaN 3.00 NaN \n",
"66 NaN 2.00 NaN \n",
"67 NaN 1.00 NaN \n",
"68 NaN 0.00 NaN \n",
"\n",
" Blue Black \\\n",
"0 NaN NaN \n",
"1 NaN Liana, Dreadhorde General \n",
"2 NaN God-Eternal Bontu \n",
"3 God-Eternal Kefnet Finale of Eternity \n",
"4 NaN NaN \n",
"5 NaN NaN \n",
"6 Commence the Endgame NaN \n",
"7 Jace Wielder of Mysteries NaN \n",
"8 NaN NaN \n",
"9 NaN NaN \n",
"10 NaN NaN \n",
"11 NaN NaN \n",
"12 Finale of Revelation NaN \n",
"13 NaN NaN \n",
"14 NaN Massacre Girl \n",
"15 NaN NaN \n",
"16 Kasmina Enigmatic Mentor NaN \n",
"17 NaN NaN \n",
"18 Tamiyo's Epiphany Ob Nixilis's Cruelty \n",
"19 NaN Dreadhorde Invasion \n",
"20 NaN Bleeding Edge \n",
"21 NaN Ob Nixlis, the Hate-Twisted \n",
"22 Aven Eternal Spark Harvest \n",
"23 NaN NaN \n",
"24 Rescuer Sphinx NaN \n",
"25 Thunder Drake Command the Dreadhorde \n",
"26 Callous Dismissal NaN \n",
"27 NaN NaN \n",
"28 Eternal Skylord NaN \n",
"29 Angur of Bolas NaN \n",
".. ... ... \n",
"39 Spellkeeper Weird NaN \n",
"40 No Escape Lazotep Reaver \n",
"41 Narset's Reversal Toll of the Invasion \n",
"42 Kasmina's Transmutation Herald of the Dreadhorde \n",
"43 NaN Spark Reaper \n",
"44 Narset, Parter of Veils Shriekdiver \n",
"45 Ashiok's Skulker Dreadmalkin \n",
"46 Sky Theater Strix Sorin's Thirst \n",
"47 Jace's Triumph Price of Betrayal \n",
"48 Silent Submersive Vraska's Finisher \n",
"49 Kiora's Dambreaker Aid the Fallen \n",
"50 Teferi's Time Twist Unlikely Aid \n",
"51 NaN Deliver Unto Evil \n",
"52 NaN Duskmantle Operative \n",
"53 Crush Dissent Tithebearer Giant \n",
"54 Relentless Advance Bond of Revival \n",
"55 Bond of Insight Vampire Opportunist \n",
"56 Stealth Mission Lazotep Behemoth \n",
"57 Lazotep Plating NaN \n",
"58 Totally Lost Liliana's Triumph \n",
"59 Wall of Runes Charity Extractor \n",
"60 NaN Davriel's Shadowfugue \n",
"61 Naga Eternal NaN \n",
"62 NaN NaN \n",
"63 NaN Banehound \n",
"64 NaN Kaya's Ghostform \n",
"65 NaN NaN \n",
"66 NaN NaN \n",
"67 NaN NaN \n",
"68 NaN NaN \n",
"\n",
" Red Green \\\n",
"0 NaN NaN \n",
"1 NaN NaN \n",
"2 NaN NaN \n",
"3 Illharg, the Raze-Boar NaN \n",
"4 Kenko, Tin Street Kingpin God-Eternal Rhonas \n",
"5 Neheb, Dreadhorde Champion NaN \n",
"6 Sarkhan the Masterless NaN \n",
"7 Chandra, Fire Artisan Nissa, Who Shakes the World \n",
"8 NaN Awakening of Vitu-Ghazi \n",
"9 NaN NaN \n",
"10 NaN NaN \n",
"11 NaN NaN \n",
"12 NaN NaN \n",
"13 NaN Vivien, Champion of the Wilds \n",
"14 NaN Planewide Celebration \n",
"15 NaN NaN \n",
"16 Jaya, Venerated Firemage NaN \n",
"17 NaN NaN \n",
"18 NaN Band Together \n",
"19 Cyclops Electromancer Arlinn, Voice of the Pack \n",
"20 Chandra's Triumph NaN \n",
"21 Tibalt, Rakish Instigator NaN \n",
"22 Jaya's Greeting NaN \n",
"23 NaN NaN \n",
"24 Spellgorger Weird NaN \n",
"25 NaN NaN \n",
"26 Mizzium Tank Jiang Yanggu, Wildcrafter \n",
"27 NaN Paradise Druid \n",
"28 NaN Bloom Hulk \n",
"29 NaN New Horizons \n",
".. ... ... \n",
"39 Raging Kronch NaN \n",
"40 Ahn-Crop Invader NaN \n",
"41 Tibalt's Rager Wardscale Crocodile \n",
"42 Burning Prophet Vivien's Grizzly \n",
"43 Honor the God-Pharaoh Giant Growth \n",
"44 Chainwip Cyclops Kronch Wrangler \n",
"45 Dreadhorde Arcanist Snarespinner \n",
"46 Bolt Bend Forced Landing \n",
"47 Grim Intiate NaN \n",
"48 Nahiri's Stoneblades Arlinn's Wolf \n",
"49 NaN Return to Nature \n",
"50 Sarkhan's Catharsis Kraul Stinger \n",
"51 Heartfire Thundering Ceratok \n",
"52 Devouring Hellion Finale of Devastation \n",
"53 Finale of Promise NaN \n",
"54 NaN Steady Aim \n",
"55 Invading Manticore Courage in Crisis \n",
"56 Samut's Sprint NaN \n",
"57 Bond of Passion Bond of Flourishing \n",
"58 Goblin Assault Team Primordial Wurm \n",
"59 Goblin Assailant Storm the Citadel \n",
"60 NaN Nissa's Triumph \n",
"61 NaN Arboreal Grazer \n",
"62 NaN NaN \n",
"63 NaN NaN \n",
"64 NaN NaN \n",
"65 Demolish NaN \n",
"66 NaN NaN \n",
"67 NaN NaN \n",
"68 NaN NaN \n",
"\n",
" Gold Unnamed: 8 \\\n",
"0 NaN NaN \n",
"1 NaN NaN \n",
"2 Nicol Bolas, Dragon-God NaN \n",
"3 NaN NaN \n",
"4 Ajani, the Greathearted Tolsimir, Friend to Wolves \n",
"5 Roalesk, Apex Hybrid Feather, the Redeemed \n",
"6 Storrev, Devkarin Lich Time Wipe \n",
"7 Domri, Anarch of Bolas Enter the God-Eternals \n",
"8 Ral, Storm Conduit Widespread Brutality \n",
"9 Sorin, Vengeful Bloodlord NaN \n",
"10 Teferi, Time Raveler NaN \n",
"11 Casualties of War NaN \n",
"12 Niv-Mizzet Reborn Kaya, Bane of the Dead \n",
"13 Living Twister Deathsprout \n",
"14 Oath of Kaya Elite Guardmage \n",
"15 NaN Ral's Outburst \n",
"16 Bioessence Hydra Despark \n",
"17 Saheeli, Sublime Artificer Soul Diviner \n",
"18 Leyline Prowler Angrath, Captain of Chaos \n",
"19 Merfolk Skydiver Invade the City \n",
"20 Heartwarming Redemption Samut, Tyrant Smasher \n",
"21 Domri's Ambush Tyrant's Scorn \n",
"22 Pledge of Unity Gleaming Overseer \n",
"23 NaN NaN \n",
"24 Mayhem Devil Angrath's Rampage \n",
"25 Nahiri, Storm of Stone Kiora, Behemoth Beckoner \n",
"26 Vraska, Swarm's Eminence Role Reversal \n",
"27 Solar Blaze NaN \n",
"28 Tamiyo, Collector of Tales Tenth District Legionnaire \n",
"29 Hualti's Raptor NaN \n",
".. ... ... \n",
"39 NaN NaN \n",
"40 NaN NaN \n",
"41 Ashiok, Dream Render NaN \n",
"42 Huatli, the Sun's Heart NaN \n",
"43 NaN NaN \n",
"44 NaN NaN \n",
"45 NaN NaN \n",
"46 NaN NaN \n",
"47 NaN NaN \n",
"48 NaN NaN \n",
"49 NaN NaN \n",
"50 NaN NaN \n",
"51 Dovin's Veto NaN \n",
"52 NaN NaN \n",
"53 NaN NaN \n",
"54 NaN Neoform \n",
"55 NaN NaN \n",
"56 NaN NaN \n",
"57 NaN NaN \n",
"58 Dovin, Hando of Control NaN \n",
"59 NaN NaN \n",
"60 NaN NaN \n",
"61 Tezzeret, Master of the Bridge NaN \n",
"62 NaN NaN \n",
"63 NaN NaN \n",
"64 NaN NaN \n",
"65 NaN NaN \n",
"66 NaN NaN \n",
"67 NaN NaN \n",
"68 NaN NaN \n",
"\n",
" Colorless Lands \n",
"0 NaN NaN \n",
"1 NaN NaN \n",
"2 NaN NaN \n",
"3 NaN NaN \n",
"4 Ugin, the Ineffable NaN \n",
"5 NaN NaN \n",
"6 NaN NaN \n",
"7 NaN NaN \n",
"8 NaN NaN \n",
"9 NaN NaN \n",
"10 NaN NaN \n",
"11 NaN NaN \n",
"12 NaN NaN \n",
"13 NaN NaN \n",
"14 NaN NaN \n",
"15 NaN NaN \n",
"16 NaN NaN \n",
"17 NaN NaN \n",
"18 NaN NaN \n",
"19 NaN NaN \n",
"20 NaN NaN \n",
"21 NaN NaN \n",
"22 NaN NaN \n",
"23 NaN NaN \n",
"24 NaN NaN \n",
"25 NaN NaN \n",
"26 NaN NaN \n",
"27 NaN Gateway Plaza \n",
"28 Mana Geode NaN \n",
"29 NaN NaN \n",
".. ... ... \n",
"39 NaN Mobilized District \n",
"40 Prismite NaN \n",
"41 Ugin's Conjurant NaN \n",
"42 NaN NaN \n",
"43 NaN NaN \n",
"44 NaN NaN \n",
"45 NaN NaN \n",
"46 Saheeli's Silverwing NaN \n",
"47 NaN NaN \n",
"48 NaN NaN \n",
"49 NaN NaN \n",
"50 NaN NaN \n",
"51 NaN Interplanar Beacon \n",
"52 NaN NaN \n",
"53 God-Pharaoh's Statue NaN \n",
"54 NaN NaN \n",
"55 NaN NaN \n",
"56 Karn, the Great Creator NaN \n",
"57 NaN NaN \n",
"58 NaN NaN \n",
"59 NaN NaN \n",
"60 NaN NaN \n",
"61 NaN NaN \n",
"62 NaN NaN \n",
"63 NaN NaN \n",
"64 NaN NaN \n",
"65 NaN NaN \n",
"66 NaN NaN \n",
"67 NaN Emergence Zone \n",
"68 NaN NaN \n",
"\n",
"[69 rows x 11 columns]"
]
},
"execution_count": 4,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df"
]
},
{
"cell_type": "code",
"execution_count": 5,
"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>Unnamed: 0</th>\n",
" <th>Ranking</th>\n",
" <th>White</th>\n",
" <th>Blue</th>\n",
" <th>Black</th>\n",
" <th>Red</th>\n",
" <th>Green</th>\n",
" <th>Gold</th>\n",
" <th>Gold2</th>\n",
" <th>Colorless</th>\n",
" <th>Lands</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>NaN</td>\n",
" <td>10.00</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>NaN</td>\n",
" <td>9.00</td>\n",
" <td>God-Eternal Oketra</td>\n",
" <td>NaN</td>\n",
" <td>Liana, Dreadhorde General</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>God-Eternal Bontu</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Nicol Bolas, Dragon-God</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>God-Eternal Kefnet</td>\n",
" <td>Finale of Eternity</td>\n",
" <td>Illharg, the Raze-Boar</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>NaN</td>\n",
" <td>8.00</td>\n",
" <td>Finale of Glory</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Kenko, Tin Street Kingpin</td>\n",
" <td>God-Eternal Rhonas</td>\n",
" <td>Ajani, the Greathearted</td>\n",
" <td>Tolsimir, Friend to Wolves</td>\n",
" <td>Ugin, the Ineffable</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>NaN</td>\n",
" <td>7.00</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Neheb, Dreadhorde Champion</td>\n",
" <td>NaN</td>\n",
" <td>Roalesk, Apex Hybrid</td>\n",
" <td>Feather, the Redeemed</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>NaN</td>\n",
" <td>6.50</td>\n",
" <td>NaN</td>\n",
" <td>Commence the Endgame</td>\n",
" <td>NaN</td>\n",
" <td>Sarkhan the Masterless</td>\n",
" <td>NaN</td>\n",
" <td>Storrev, Devkarin Lich</td>\n",
" <td>Time Wipe</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Gideon Blackblade</td>\n",
" <td>Jace Wielder of Mysteries</td>\n",
" <td>NaN</td>\n",
" <td>Chandra, Fire Artisan</td>\n",
" <td>Nissa, Who Shakes the World</td>\n",
" <td>Domri, Anarch of Bolas</td>\n",
" <td>Enter the God-Eternals</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Awakening of Vitu-Ghazi</td>\n",
" <td>Ral, Storm Conduit</td>\n",
" <td>Widespread Brutality</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Sorin, Vengeful Bloodlord</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Teferi, Time Raveler</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Casualties of War</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Finale of Revelation</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Niv-Mizzet Reborn</td>\n",
" <td>Kaya, Bane of the Dead</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>NaN</td>\n",
" <td>6.25</td>\n",
" <td>Prison Realm</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Vivien, Champion of the Wilds</td>\n",
" <td>Living Twister</td>\n",
" <td>Deathsprout</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Massacre Girl</td>\n",
" <td>NaN</td>\n",
" <td>Planewide Celebration</td>\n",
" <td>Oath of Kaya</td>\n",
" <td>Elite Guardmage</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Ral's Outburst</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Trusted Pegasus</td>\n",
" <td>Kasmina Enigmatic Mentor</td>\n",
" <td>NaN</td>\n",
" <td>Jaya, Venerated Firemage</td>\n",
" <td>NaN</td>\n",
" <td>Bioessence Hydra</td>\n",
" <td>Despark</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>NaN</td>\n",
" <td>5.80</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Saheeli, Sublime Artificer</td>\n",
" <td>Soul Diviner</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>NaN</td>\n",
" <td>5.70</td>\n",
" <td>Law-Rune Enforcer</td>\n",
" <td>Tamiyo's Epiphany</td>\n",
" <td>Ob Nixilis's Cruelty</td>\n",
" <td>NaN</td>\n",
" <td>Band Together</td>\n",
" <td>Leyline Prowler</td>\n",
" <td>Angrath, Captain of Chaos</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Dreadhorde Invasion</td>\n",
" <td>Cyclops Electromancer</td>\n",
" <td>Arlinn, Voice of the Pack</td>\n",
" <td>Merfolk Skydiver</td>\n",
" <td>Invade the City</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>NaN</td>\n",
" <td>5.60</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Bleeding Edge</td>\n",
" <td>Chandra's Triumph</td>\n",
" <td>NaN</td>\n",
" <td>Heartwarming Redemption</td>\n",
" <td>Samut, Tyrant Smasher</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Ob Nixlis, the Hate-Twisted</td>\n",
" <td>Tibalt, Rakish Instigator</td>\n",
" <td>NaN</td>\n",
" <td>Domri's Ambush</td>\n",
" <td>Tyrant's Scorn</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>NaN</td>\n",
" <td>5.50</td>\n",
" <td>Grateful Apparition</td>\n",
" <td>Aven Eternal</td>\n",
" <td>Spark Harvest</td>\n",
" <td>Jaya's Greeting</td>\n",
" <td>NaN</td>\n",
" <td>Pledge of Unity</td>\n",
" <td>Gleaming Overseer</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Tomik, Distinguished Advokist</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Rising Populace</td>\n",
" <td>Rescuer Sphinx</td>\n",
" <td>NaN</td>\n",
" <td>Spellgorger Weird</td>\n",
" <td>NaN</td>\n",
" <td>Mayhem Devil</td>\n",
" <td>Angrath's Rampage</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td>NaN</td>\n",
" <td>5.40</td>\n",
" <td>Wanderer's Strike</td>\n",
" <td>Thunder Drake</td>\n",
" <td>Command the Dreadhorde</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Nahiri, Storm of Stone</td>\n",
" <td>Kiora, Behemoth Beckoner</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Callous Dismissal</td>\n",
" <td>NaN</td>\n",
" <td>Mizzium Tank</td>\n",
" <td>Jiang Yanggu, Wildcrafter</td>\n",
" <td>Vraska, Swarm's Eminence</td>\n",
" <td>Role Reversal</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Paradise Druid</td>\n",
" <td>Solar Blaze</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Gateway Plaza</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Eternal Skylord</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Bloom Hulk</td>\n",
" <td>Tamiyo, Collector of Tales</td>\n",
" <td>Tenth District Legionnaire</td>\n",
" <td>Mana Geode</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Angur of Bolas</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>New Horizons</td>\n",
" <td>Hualti's Raptor</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\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",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>39</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Spellkeeper Weird</td>\n",
" <td>NaN</td>\n",
" <td>Raging Kronch</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Mobilized District</td>\n",
" </tr>\n",
" <tr>\n",
" <th>40</th>\n",
" <td>NaN</td>\n",
" <td>5.00</td>\n",
" <td>Bond of Discipline</td>\n",
" <td>No Escape</td>\n",
" <td>Lazotep Reaver</td>\n",
" <td>Ahn-Crop Invader</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Prismite</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>41</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Battlefield Promotion</td>\n",
" <td>Narset's Reversal</td>\n",
" <td>Toll of the Invasion</td>\n",
" <td>Tibalt's Rager</td>\n",
" <td>Wardscale Crocodile</td>\n",
" <td>Ashiok, Dream Render</td>\n",
" <td>NaN</td>\n",
" <td>Ugin's Conjurant</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>42</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Defiant Strike</td>\n",
" <td>Kasmina's Transmutation</td>\n",
" <td>Herald of the Dreadhorde</td>\n",
" <td>Burning Prophet</td>\n",
" <td>Vivien's Grizzly</td>\n",
" <td>Huatli, the Sun's Heart</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>43</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Enforcer Griffin</td>\n",
" <td>NaN</td>\n",
" <td>Spark Reaper</td>\n",
" <td>Honor the God-Pharaoh</td>\n",
" <td>Giant Growth</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>44</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Martyr for the Cause</td>\n",
" <td>Narset, Parter of Veils</td>\n",
" <td>Shriekdiver</td>\n",
" <td>Chainwip Cyclops</td>\n",
" <td>Kronch Wrangler</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>45</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Rally of Wings</td>\n",
" <td>Ashiok's Skulker</td>\n",
" <td>Dreadmalkin</td>\n",
" <td>Dreadhorde Arcanist</td>\n",
" <td>Snarespinner</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>46</th>\n",
" <td>NaN</td>\n",
" <td>4.90</td>\n",
" <td>The Wanderer</td>\n",
" <td>Sky Theater Strix</td>\n",
" <td>Sorin's Thirst</td>\n",
" <td>Bolt Bend</td>\n",
" <td>Forced Landing</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Saheeli's Silverwing</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>47</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Teyo's Lightshield</td>\n",
" <td>Jace's Triumph</td>\n",
" <td>Price of Betrayal</td>\n",
" <td>Grim Intiate</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>48</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Pouncing Lynx</td>\n",
" <td>Silent Submersive</td>\n",
" <td>Vraska's Finisher</td>\n",
" <td>Nahiri's Stoneblades</td>\n",
" <td>Arlinn's Wolf</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>49</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Gideon's Triumph</td>\n",
" <td>Kiora's Dambreaker</td>\n",
" <td>Aid the Fallen</td>\n",
" <td>NaN</td>\n",
" <td>Return to Nature</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>50</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Topple the Statue</td>\n",
" <td>Teferi's Time Twist</td>\n",
" <td>Unlikely Aid</td>\n",
" <td>Sarkhan's Catharsis</td>\n",
" <td>Kraul Stinger</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>51</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Ravnica at War</td>\n",
" <td>NaN</td>\n",
" <td>Deliver Unto Evil</td>\n",
" <td>Heartfire</td>\n",
" <td>Thundering Ceratok</td>\n",
" <td>Dovin's Veto</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Interplanar Beacon</td>\n",
" </tr>\n",
" <tr>\n",
" <th>52</th>\n",
" <td>NaN</td>\n",
" <td>4.80</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Duskmantle Operative</td>\n",
" <td>Devouring Hellion</td>\n",
" <td>Finale of Devastation</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>53</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Makeshift Battalion</td>\n",
" <td>Crush Dissent</td>\n",
" <td>Tithebearer Giant</td>\n",
" <td>Finale of Promise</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>God-Pharaoh's Statue</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>54</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Baulwark Giant</td>\n",
" <td>Relentless Advance</td>\n",
" <td>Bond of Revival</td>\n",
" <td>NaN</td>\n",
" <td>Steady Aim</td>\n",
" <td>NaN</td>\n",
" <td>Neoform</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>55</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Loxodon Sergeant</td>\n",
" <td>Bond of Insight</td>\n",
" <td>Vampire Opportunist</td>\n",
" <td>Invading Manticore</td>\n",
" <td>Courage in Crisis</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>56</th>\n",
" <td>NaN</td>\n",
" <td>4.70</td>\n",
" <td>Ignite the Beacon</td>\n",
" <td>Stealth Mission</td>\n",
" <td>Lazotep Behemoth</td>\n",
" <td>Samut's Sprint</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Karn, the Great Creator</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>57</th>\n",
" <td>NaN</td>\n",
" <td>4.60</td>\n",
" <td>NaN</td>\n",
" <td>Lazotep Plating</td>\n",
" <td>NaN</td>\n",
" <td>Bond of Passion</td>\n",
" <td>Bond of Flourishing</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>58</th>\n",
" <td>NaN</td>\n",
" <td>4.50</td>\n",
" <td>Single Combat</td>\n",
" <td>Totally Lost</td>\n",
" <td>Liliana's Triumph</td>\n",
" <td>Goblin Assault Team</td>\n",
" <td>Primordial Wurm</td>\n",
" <td>Dovin, Hando of Control</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>59</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Gideon's Sacrifice</td>\n",
" <td>Wall of Runes</td>\n",
" <td>Charity Extractor</td>\n",
" <td>Goblin Assailant</td>\n",
" <td>Storm the Citadel</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>60</th>\n",
" <td>NaN</td>\n",
" <td>4.40</td>\n",
" <td>Ironclad Krovod</td>\n",
" <td>NaN</td>\n",
" <td>Davriel's Shadowfugue</td>\n",
" <td>NaN</td>\n",
" <td>Nissa's Triumph</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>61</th>\n",
" <td>NaN</td>\n",
" <td>4.20</td>\n",
" <td>NaN</td>\n",
" <td>Naga Eternal</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Arboreal Grazer</td>\n",
" <td>Tezzeret, Master of the Bridge</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>62</th>\n",
" <td>NaN</td>\n",
" <td>4.00</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>63</th>\n",
" <td>NaN</td>\n",
" <td>3.75</td>\n",
" <td>Charmed Stray</td>\n",
" <td>NaN</td>\n",
" <td>Banehound</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>64</th>\n",
" <td>NaN</td>\n",
" <td>3.50</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Kaya's Ghostform</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>65</th>\n",
" <td>NaN</td>\n",
" <td>3.00</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Demolish</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>66</th>\n",
" <td>NaN</td>\n",
" <td>2.00</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>67</th>\n",
" <td>NaN</td>\n",
" <td>1.00</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Emergence Zone</td>\n",
" </tr>\n",
" <tr>\n",
" <th>68</th>\n",
" <td>NaN</td>\n",
" <td>0.00</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>69 rows × 11 columns</p>\n",
"</div>"
],
"text/plain": [
" Unnamed: 0 Ranking White \\\n",
"0 NaN 10.00 NaN \n",
"1 NaN 9.00 God-Eternal Oketra \n",
"2 NaN NaN NaN \n",
"3 NaN NaN NaN \n",
"4 NaN 8.00 Finale of Glory \n",
"5 NaN 7.00 NaN \n",
"6 NaN 6.50 NaN \n",
"7 NaN NaN Gideon Blackblade \n",
"8 NaN NaN NaN \n",
"9 NaN NaN NaN \n",
"10 NaN NaN NaN \n",
"11 NaN NaN NaN \n",
"12 NaN NaN NaN \n",
"13 NaN 6.25 Prison Realm \n",
"14 NaN NaN NaN \n",
"15 NaN NaN NaN \n",
"16 NaN NaN Trusted Pegasus \n",
"17 NaN 5.80 NaN \n",
"18 NaN 5.70 Law-Rune Enforcer \n",
"19 NaN NaN NaN \n",
"20 NaN 5.60 NaN \n",
"21 NaN NaN NaN \n",
"22 NaN 5.50 Grateful Apparition \n",
"23 NaN NaN Tomik, Distinguished Advokist \n",
"24 NaN NaN Rising Populace \n",
"25 NaN 5.40 Wanderer's Strike \n",
"26 NaN NaN NaN \n",
"27 NaN NaN NaN \n",
"28 NaN NaN NaN \n",
"29 NaN NaN NaN \n",
".. ... ... ... \n",
"39 NaN NaN NaN \n",
"40 NaN 5.00 Bond of Discipline \n",
"41 NaN NaN Battlefield Promotion \n",
"42 NaN NaN Defiant Strike \n",
"43 NaN NaN Enforcer Griffin \n",
"44 NaN NaN Martyr for the Cause \n",
"45 NaN NaN Rally of Wings \n",
"46 NaN 4.90 The Wanderer \n",
"47 NaN NaN Teyo's Lightshield \n",
"48 NaN NaN Pouncing Lynx \n",
"49 NaN NaN Gideon's Triumph \n",
"50 NaN NaN Topple the Statue \n",
"51 NaN NaN Ravnica at War \n",
"52 NaN 4.80 NaN \n",
"53 NaN NaN Makeshift Battalion \n",
"54 NaN NaN Baulwark Giant \n",
"55 NaN NaN Loxodon Sergeant \n",
"56 NaN 4.70 Ignite the Beacon \n",
"57 NaN 4.60 NaN \n",
"58 NaN 4.50 Single Combat \n",
"59 NaN NaN Gideon's Sacrifice \n",
"60 NaN 4.40 Ironclad Krovod \n",
"61 NaN 4.20 NaN \n",
"62 NaN 4.00 NaN \n",
"63 NaN 3.75 Charmed Stray \n",
"64 NaN 3.50 NaN \n",
"65 NaN 3.00 NaN \n",
"66 NaN 2.00 NaN \n",
"67 NaN 1.00 NaN \n",
"68 NaN 0.00 NaN \n",
"\n",
" Blue Black \\\n",
"0 NaN NaN \n",
"1 NaN Liana, Dreadhorde General \n",
"2 NaN God-Eternal Bontu \n",
"3 God-Eternal Kefnet Finale of Eternity \n",
"4 NaN NaN \n",
"5 NaN NaN \n",
"6 Commence the Endgame NaN \n",
"7 Jace Wielder of Mysteries NaN \n",
"8 NaN NaN \n",
"9 NaN NaN \n",
"10 NaN NaN \n",
"11 NaN NaN \n",
"12 Finale of Revelation NaN \n",
"13 NaN NaN \n",
"14 NaN Massacre Girl \n",
"15 NaN NaN \n",
"16 Kasmina Enigmatic Mentor NaN \n",
"17 NaN NaN \n",
"18 Tamiyo's Epiphany Ob Nixilis's Cruelty \n",
"19 NaN Dreadhorde Invasion \n",
"20 NaN Bleeding Edge \n",
"21 NaN Ob Nixlis, the Hate-Twisted \n",
"22 Aven Eternal Spark Harvest \n",
"23 NaN NaN \n",
"24 Rescuer Sphinx NaN \n",
"25 Thunder Drake Command the Dreadhorde \n",
"26 Callous Dismissal NaN \n",
"27 NaN NaN \n",
"28 Eternal Skylord NaN \n",
"29 Angur of Bolas NaN \n",
".. ... ... \n",
"39 Spellkeeper Weird NaN \n",
"40 No Escape Lazotep Reaver \n",
"41 Narset's Reversal Toll of the Invasion \n",
"42 Kasmina's Transmutation Herald of the Dreadhorde \n",
"43 NaN Spark Reaper \n",
"44 Narset, Parter of Veils Shriekdiver \n",
"45 Ashiok's Skulker Dreadmalkin \n",
"46 Sky Theater Strix Sorin's Thirst \n",
"47 Jace's Triumph Price of Betrayal \n",
"48 Silent Submersive Vraska's Finisher \n",
"49 Kiora's Dambreaker Aid the Fallen \n",
"50 Teferi's Time Twist Unlikely Aid \n",
"51 NaN Deliver Unto Evil \n",
"52 NaN Duskmantle Operative \n",
"53 Crush Dissent Tithebearer Giant \n",
"54 Relentless Advance Bond of Revival \n",
"55 Bond of Insight Vampire Opportunist \n",
"56 Stealth Mission Lazotep Behemoth \n",
"57 Lazotep Plating NaN \n",
"58 Totally Lost Liliana's Triumph \n",
"59 Wall of Runes Charity Extractor \n",
"60 NaN Davriel's Shadowfugue \n",
"61 Naga Eternal NaN \n",
"62 NaN NaN \n",
"63 NaN Banehound \n",
"64 NaN Kaya's Ghostform \n",
"65 NaN NaN \n",
"66 NaN NaN \n",
"67 NaN NaN \n",
"68 NaN NaN \n",
"\n",
" Red Green \\\n",
"0 NaN NaN \n",
"1 NaN NaN \n",
"2 NaN NaN \n",
"3 Illharg, the Raze-Boar NaN \n",
"4 Kenko, Tin Street Kingpin God-Eternal Rhonas \n",
"5 Neheb, Dreadhorde Champion NaN \n",
"6 Sarkhan the Masterless NaN \n",
"7 Chandra, Fire Artisan Nissa, Who Shakes the World \n",
"8 NaN Awakening of Vitu-Ghazi \n",
"9 NaN NaN \n",
"10 NaN NaN \n",
"11 NaN NaN \n",
"12 NaN NaN \n",
"13 NaN Vivien, Champion of the Wilds \n",
"14 NaN Planewide Celebration \n",
"15 NaN NaN \n",
"16 Jaya, Venerated Firemage NaN \n",
"17 NaN NaN \n",
"18 NaN Band Together \n",
"19 Cyclops Electromancer Arlinn, Voice of the Pack \n",
"20 Chandra's Triumph NaN \n",
"21 Tibalt, Rakish Instigator NaN \n",
"22 Jaya's Greeting NaN \n",
"23 NaN NaN \n",
"24 Spellgorger Weird NaN \n",
"25 NaN NaN \n",
"26 Mizzium Tank Jiang Yanggu, Wildcrafter \n",
"27 NaN Paradise Druid \n",
"28 NaN Bloom Hulk \n",
"29 NaN New Horizons \n",
".. ... ... \n",
"39 Raging Kronch NaN \n",
"40 Ahn-Crop Invader NaN \n",
"41 Tibalt's Rager Wardscale Crocodile \n",
"42 Burning Prophet Vivien's Grizzly \n",
"43 Honor the God-Pharaoh Giant Growth \n",
"44 Chainwip Cyclops Kronch Wrangler \n",
"45 Dreadhorde Arcanist Snarespinner \n",
"46 Bolt Bend Forced Landing \n",
"47 Grim Intiate NaN \n",
"48 Nahiri's Stoneblades Arlinn's Wolf \n",
"49 NaN Return to Nature \n",
"50 Sarkhan's Catharsis Kraul Stinger \n",
"51 Heartfire Thundering Ceratok \n",
"52 Devouring Hellion Finale of Devastation \n",
"53 Finale of Promise NaN \n",
"54 NaN Steady Aim \n",
"55 Invading Manticore Courage in Crisis \n",
"56 Samut's Sprint NaN \n",
"57 Bond of Passion Bond of Flourishing \n",
"58 Goblin Assault Team Primordial Wurm \n",
"59 Goblin Assailant Storm the Citadel \n",
"60 NaN Nissa's Triumph \n",
"61 NaN Arboreal Grazer \n",
"62 NaN NaN \n",
"63 NaN NaN \n",
"64 NaN NaN \n",
"65 Demolish NaN \n",
"66 NaN NaN \n",
"67 NaN NaN \n",
"68 NaN NaN \n",
"\n",
" Gold Gold2 \\\n",
"0 NaN NaN \n",
"1 NaN NaN \n",
"2 Nicol Bolas, Dragon-God NaN \n",
"3 NaN NaN \n",
"4 Ajani, the Greathearted Tolsimir, Friend to Wolves \n",
"5 Roalesk, Apex Hybrid Feather, the Redeemed \n",
"6 Storrev, Devkarin Lich Time Wipe \n",
"7 Domri, Anarch of Bolas Enter the God-Eternals \n",
"8 Ral, Storm Conduit Widespread Brutality \n",
"9 Sorin, Vengeful Bloodlord NaN \n",
"10 Teferi, Time Raveler NaN \n",
"11 Casualties of War NaN \n",
"12 Niv-Mizzet Reborn Kaya, Bane of the Dead \n",
"13 Living Twister Deathsprout \n",
"14 Oath of Kaya Elite Guardmage \n",
"15 NaN Ral's Outburst \n",
"16 Bioessence Hydra Despark \n",
"17 Saheeli, Sublime Artificer Soul Diviner \n",
"18 Leyline Prowler Angrath, Captain of Chaos \n",
"19 Merfolk Skydiver Invade the City \n",
"20 Heartwarming Redemption Samut, Tyrant Smasher \n",
"21 Domri's Ambush Tyrant's Scorn \n",
"22 Pledge of Unity Gleaming Overseer \n",
"23 NaN NaN \n",
"24 Mayhem Devil Angrath's Rampage \n",
"25 Nahiri, Storm of Stone Kiora, Behemoth Beckoner \n",
"26 Vraska, Swarm's Eminence Role Reversal \n",
"27 Solar Blaze NaN \n",
"28 Tamiyo, Collector of Tales Tenth District Legionnaire \n",
"29 Hualti's Raptor NaN \n",
".. ... ... \n",
"39 NaN NaN \n",
"40 NaN NaN \n",
"41 Ashiok, Dream Render NaN \n",
"42 Huatli, the Sun's Heart NaN \n",
"43 NaN NaN \n",
"44 NaN NaN \n",
"45 NaN NaN \n",
"46 NaN NaN \n",
"47 NaN NaN \n",
"48 NaN NaN \n",
"49 NaN NaN \n",
"50 NaN NaN \n",
"51 Dovin's Veto NaN \n",
"52 NaN NaN \n",
"53 NaN NaN \n",
"54 NaN Neoform \n",
"55 NaN NaN \n",
"56 NaN NaN \n",
"57 NaN NaN \n",
"58 Dovin, Hando of Control NaN \n",
"59 NaN NaN \n",
"60 NaN NaN \n",
"61 Tezzeret, Master of the Bridge NaN \n",
"62 NaN NaN \n",
"63 NaN NaN \n",
"64 NaN NaN \n",
"65 NaN NaN \n",
"66 NaN NaN \n",
"67 NaN NaN \n",
"68 NaN NaN \n",
"\n",
" Colorless Lands \n",
"0 NaN NaN \n",
"1 NaN NaN \n",
"2 NaN NaN \n",
"3 NaN NaN \n",
"4 Ugin, the Ineffable NaN \n",
"5 NaN NaN \n",
"6 NaN NaN \n",
"7 NaN NaN \n",
"8 NaN NaN \n",
"9 NaN NaN \n",
"10 NaN NaN \n",
"11 NaN NaN \n",
"12 NaN NaN \n",
"13 NaN NaN \n",
"14 NaN NaN \n",
"15 NaN NaN \n",
"16 NaN NaN \n",
"17 NaN NaN \n",
"18 NaN NaN \n",
"19 NaN NaN \n",
"20 NaN NaN \n",
"21 NaN NaN \n",
"22 NaN NaN \n",
"23 NaN NaN \n",
"24 NaN NaN \n",
"25 NaN NaN \n",
"26 NaN NaN \n",
"27 NaN Gateway Plaza \n",
"28 Mana Geode NaN \n",
"29 NaN NaN \n",
".. ... ... \n",
"39 NaN Mobilized District \n",
"40 Prismite NaN \n",
"41 Ugin's Conjurant NaN \n",
"42 NaN NaN \n",
"43 NaN NaN \n",
"44 NaN NaN \n",
"45 NaN NaN \n",
"46 Saheeli's Silverwing NaN \n",
"47 NaN NaN \n",
"48 NaN NaN \n",
"49 NaN NaN \n",
"50 NaN NaN \n",
"51 NaN Interplanar Beacon \n",
"52 NaN NaN \n",
"53 God-Pharaoh's Statue NaN \n",
"54 NaN NaN \n",
"55 NaN NaN \n",
"56 Karn, the Great Creator NaN \n",
"57 NaN NaN \n",
"58 NaN NaN \n",
"59 NaN NaN \n",
"60 NaN NaN \n",
"61 NaN NaN \n",
"62 NaN NaN \n",
"63 NaN NaN \n",
"64 NaN NaN \n",
"65 NaN NaN \n",
"66 NaN NaN \n",
"67 NaN Emergence Zone \n",
"68 NaN NaN \n",
"\n",
"[69 rows x 11 columns]"
]
},
"execution_count": 5,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"mapping = {\"Unnamed: 1\": \"Ranking\", \"Unnamed: 8\": \"Gold2\"}\n",
"df_renamed = df.rename(columns=mapping)\n",
"df_renamed"
]
},
{
"cell_type": "code",
"execution_count": 6,
"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>Unnamed: 0</th>\n",
" <th>Ranking</th>\n",
" <th>White</th>\n",
" <th>Blue</th>\n",
" <th>Black</th>\n",
" <th>Red</th>\n",
" <th>Green</th>\n",
" <th>Gold</th>\n",
" <th>Gold2</th>\n",
" <th>Colorless</th>\n",
" <th>Lands</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>NaN</td>\n",
" <td>10.00</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>NaN</td>\n",
" <td>9.00</td>\n",
" <td>God-Eternal Oketra</td>\n",
" <td>NaN</td>\n",
" <td>Liana, Dreadhorde General</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>NaN</td>\n",
" <td>9.00</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>God-Eternal Bontu</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Nicol Bolas, Dragon-God</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>NaN</td>\n",
" <td>9.00</td>\n",
" <td>NaN</td>\n",
" <td>God-Eternal Kefnet</td>\n",
" <td>Finale of Eternity</td>\n",
" <td>Illharg, the Raze-Boar</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>NaN</td>\n",
" <td>8.00</td>\n",
" <td>Finale of Glory</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Kenko, Tin Street Kingpin</td>\n",
" <td>God-Eternal Rhonas</td>\n",
" <td>Ajani, the Greathearted</td>\n",
" <td>Tolsimir, Friend to Wolves</td>\n",
" <td>Ugin, the Ineffable</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>NaN</td>\n",
" <td>7.00</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Neheb, Dreadhorde Champion</td>\n",
" <td>NaN</td>\n",
" <td>Roalesk, Apex Hybrid</td>\n",
" <td>Feather, the Redeemed</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>NaN</td>\n",
" <td>6.50</td>\n",
" <td>NaN</td>\n",
" <td>Commence the Endgame</td>\n",
" <td>NaN</td>\n",
" <td>Sarkhan the Masterless</td>\n",
" <td>NaN</td>\n",
" <td>Storrev, Devkarin Lich</td>\n",
" <td>Time Wipe</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>NaN</td>\n",
" <td>6.50</td>\n",
" <td>Gideon Blackblade</td>\n",
" <td>Jace Wielder of Mysteries</td>\n",
" <td>NaN</td>\n",
" <td>Chandra, Fire Artisan</td>\n",
" <td>Nissa, Who Shakes the World</td>\n",
" <td>Domri, Anarch of Bolas</td>\n",
" <td>Enter the God-Eternals</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>NaN</td>\n",
" <td>6.50</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Awakening of Vitu-Ghazi</td>\n",
" <td>Ral, Storm Conduit</td>\n",
" <td>Widespread Brutality</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>NaN</td>\n",
" <td>6.50</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Sorin, Vengeful Bloodlord</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>NaN</td>\n",
" <td>6.50</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Teferi, Time Raveler</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>NaN</td>\n",
" <td>6.50</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Casualties of War</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>NaN</td>\n",
" <td>6.50</td>\n",
" <td>NaN</td>\n",
" <td>Finale of Revelation</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Niv-Mizzet Reborn</td>\n",
" <td>Kaya, Bane of the Dead</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>NaN</td>\n",
" <td>6.25</td>\n",
" <td>Prison Realm</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Vivien, Champion of the Wilds</td>\n",
" <td>Living Twister</td>\n",
" <td>Deathsprout</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>NaN</td>\n",
" <td>6.25</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Massacre Girl</td>\n",
" <td>NaN</td>\n",
" <td>Planewide Celebration</td>\n",
" <td>Oath of Kaya</td>\n",
" <td>Elite Guardmage</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>NaN</td>\n",
" <td>6.25</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Ral's Outburst</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>NaN</td>\n",
" <td>6.25</td>\n",
" <td>Trusted Pegasus</td>\n",
" <td>Kasmina Enigmatic Mentor</td>\n",
" <td>NaN</td>\n",
" <td>Jaya, Venerated Firemage</td>\n",
" <td>NaN</td>\n",
" <td>Bioessence Hydra</td>\n",
" <td>Despark</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>NaN</td>\n",
" <td>5.80</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Saheeli, Sublime Artificer</td>\n",
" <td>Soul Diviner</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>NaN</td>\n",
" <td>5.70</td>\n",
" <td>Law-Rune Enforcer</td>\n",
" <td>Tamiyo's Epiphany</td>\n",
" <td>Ob Nixilis's Cruelty</td>\n",
" <td>NaN</td>\n",
" <td>Band Together</td>\n",
" <td>Leyline Prowler</td>\n",
" <td>Angrath, Captain of Chaos</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>NaN</td>\n",
" <td>5.70</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Dreadhorde Invasion</td>\n",
" <td>Cyclops Electromancer</td>\n",
" <td>Arlinn, Voice of the Pack</td>\n",
" <td>Merfolk Skydiver</td>\n",
" <td>Invade the City</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>NaN</td>\n",
" <td>5.60</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Bleeding Edge</td>\n",
" <td>Chandra's Triumph</td>\n",
" <td>NaN</td>\n",
" <td>Heartwarming Redemption</td>\n",
" <td>Samut, Tyrant Smasher</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>NaN</td>\n",
" <td>5.60</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Ob Nixlis, the Hate-Twisted</td>\n",
" <td>Tibalt, Rakish Instigator</td>\n",
" <td>NaN</td>\n",
" <td>Domri's Ambush</td>\n",
" <td>Tyrant's Scorn</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>NaN</td>\n",
" <td>5.50</td>\n",
" <td>Grateful Apparition</td>\n",
" <td>Aven Eternal</td>\n",
" <td>Spark Harvest</td>\n",
" <td>Jaya's Greeting</td>\n",
" <td>NaN</td>\n",
" <td>Pledge of Unity</td>\n",
" <td>Gleaming Overseer</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>NaN</td>\n",
" <td>5.50</td>\n",
" <td>Tomik, Distinguished Advokist</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>NaN</td>\n",
" <td>5.50</td>\n",
" <td>Rising Populace</td>\n",
" <td>Rescuer Sphinx</td>\n",
" <td>NaN</td>\n",
" <td>Spellgorger Weird</td>\n",
" <td>NaN</td>\n",
" <td>Mayhem Devil</td>\n",
" <td>Angrath's Rampage</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td>NaN</td>\n",
" <td>5.40</td>\n",
" <td>Wanderer's Strike</td>\n",
" <td>Thunder Drake</td>\n",
" <td>Command the Dreadhorde</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Nahiri, Storm of Stone</td>\n",
" <td>Kiora, Behemoth Beckoner</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td>NaN</td>\n",
" <td>5.40</td>\n",
" <td>NaN</td>\n",
" <td>Callous Dismissal</td>\n",
" <td>NaN</td>\n",
" <td>Mizzium Tank</td>\n",
" <td>Jiang Yanggu, Wildcrafter</td>\n",
" <td>Vraska, Swarm's Eminence</td>\n",
" <td>Role Reversal</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td>NaN</td>\n",
" <td>5.40</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Paradise Druid</td>\n",
" <td>Solar Blaze</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Gateway Plaza</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td>NaN</td>\n",
" <td>5.40</td>\n",
" <td>NaN</td>\n",
" <td>Eternal Skylord</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Bloom Hulk</td>\n",
" <td>Tamiyo, Collector of Tales</td>\n",
" <td>Tenth District Legionnaire</td>\n",
" <td>Mana Geode</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td>NaN</td>\n",
" <td>5.40</td>\n",
" <td>NaN</td>\n",
" <td>Angur of Bolas</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>New Horizons</td>\n",
" <td>Hualti's Raptor</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\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",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>39</th>\n",
" <td>NaN</td>\n",
" <td>5.10</td>\n",
" <td>NaN</td>\n",
" <td>Spellkeeper Weird</td>\n",
" <td>NaN</td>\n",
" <td>Raging Kronch</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Mobilized District</td>\n",
" </tr>\n",
" <tr>\n",
" <th>40</th>\n",
" <td>NaN</td>\n",
" <td>5.00</td>\n",
" <td>Bond of Discipline</td>\n",
" <td>No Escape</td>\n",
" <td>Lazotep Reaver</td>\n",
" <td>Ahn-Crop Invader</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Prismite</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>41</th>\n",
" <td>NaN</td>\n",
" <td>5.00</td>\n",
" <td>Battlefield Promotion</td>\n",
" <td>Narset's Reversal</td>\n",
" <td>Toll of the Invasion</td>\n",
" <td>Tibalt's Rager</td>\n",
" <td>Wardscale Crocodile</td>\n",
" <td>Ashiok, Dream Render</td>\n",
" <td>NaN</td>\n",
" <td>Ugin's Conjurant</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>42</th>\n",
" <td>NaN</td>\n",
" <td>5.00</td>\n",
" <td>Defiant Strike</td>\n",
" <td>Kasmina's Transmutation</td>\n",
" <td>Herald of the Dreadhorde</td>\n",
" <td>Burning Prophet</td>\n",
" <td>Vivien's Grizzly</td>\n",
" <td>Huatli, the Sun's Heart</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>43</th>\n",
" <td>NaN</td>\n",
" <td>5.00</td>\n",
" <td>Enforcer Griffin</td>\n",
" <td>NaN</td>\n",
" <td>Spark Reaper</td>\n",
" <td>Honor the God-Pharaoh</td>\n",
" <td>Giant Growth</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>44</th>\n",
" <td>NaN</td>\n",
" <td>5.00</td>\n",
" <td>Martyr for the Cause</td>\n",
" <td>Narset, Parter of Veils</td>\n",
" <td>Shriekdiver</td>\n",
" <td>Chainwip Cyclops</td>\n",
" <td>Kronch Wrangler</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>45</th>\n",
" <td>NaN</td>\n",
" <td>5.00</td>\n",
" <td>Rally of Wings</td>\n",
" <td>Ashiok's Skulker</td>\n",
" <td>Dreadmalkin</td>\n",
" <td>Dreadhorde Arcanist</td>\n",
" <td>Snarespinner</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>46</th>\n",
" <td>NaN</td>\n",
" <td>4.90</td>\n",
" <td>The Wanderer</td>\n",
" <td>Sky Theater Strix</td>\n",
" <td>Sorin's Thirst</td>\n",
" <td>Bolt Bend</td>\n",
" <td>Forced Landing</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Saheeli's Silverwing</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>47</th>\n",
" <td>NaN</td>\n",
" <td>4.90</td>\n",
" <td>Teyo's Lightshield</td>\n",
" <td>Jace's Triumph</td>\n",
" <td>Price of Betrayal</td>\n",
" <td>Grim Intiate</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>48</th>\n",
" <td>NaN</td>\n",
" <td>4.90</td>\n",
" <td>Pouncing Lynx</td>\n",
" <td>Silent Submersive</td>\n",
" <td>Vraska's Finisher</td>\n",
" <td>Nahiri's Stoneblades</td>\n",
" <td>Arlinn's Wolf</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>49</th>\n",
" <td>NaN</td>\n",
" <td>4.90</td>\n",
" <td>Gideon's Triumph</td>\n",
" <td>Kiora's Dambreaker</td>\n",
" <td>Aid the Fallen</td>\n",
" <td>NaN</td>\n",
" <td>Return to Nature</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>50</th>\n",
" <td>NaN</td>\n",
" <td>4.90</td>\n",
" <td>Topple the Statue</td>\n",
" <td>Teferi's Time Twist</td>\n",
" <td>Unlikely Aid</td>\n",
" <td>Sarkhan's Catharsis</td>\n",
" <td>Kraul Stinger</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>51</th>\n",
" <td>NaN</td>\n",
" <td>4.90</td>\n",
" <td>Ravnica at War</td>\n",
" <td>NaN</td>\n",
" <td>Deliver Unto Evil</td>\n",
" <td>Heartfire</td>\n",
" <td>Thundering Ceratok</td>\n",
" <td>Dovin's Veto</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Interplanar Beacon</td>\n",
" </tr>\n",
" <tr>\n",
" <th>52</th>\n",
" <td>NaN</td>\n",
" <td>4.80</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Duskmantle Operative</td>\n",
" <td>Devouring Hellion</td>\n",
" <td>Finale of Devastation</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>53</th>\n",
" <td>NaN</td>\n",
" <td>4.80</td>\n",
" <td>Makeshift Battalion</td>\n",
" <td>Crush Dissent</td>\n",
" <td>Tithebearer Giant</td>\n",
" <td>Finale of Promise</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>God-Pharaoh's Statue</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>54</th>\n",
" <td>NaN</td>\n",
" <td>4.80</td>\n",
" <td>Baulwark Giant</td>\n",
" <td>Relentless Advance</td>\n",
" <td>Bond of Revival</td>\n",
" <td>NaN</td>\n",
" <td>Steady Aim</td>\n",
" <td>NaN</td>\n",
" <td>Neoform</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>55</th>\n",
" <td>NaN</td>\n",
" <td>4.80</td>\n",
" <td>Loxodon Sergeant</td>\n",
" <td>Bond of Insight</td>\n",
" <td>Vampire Opportunist</td>\n",
" <td>Invading Manticore</td>\n",
" <td>Courage in Crisis</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>56</th>\n",
" <td>NaN</td>\n",
" <td>4.70</td>\n",
" <td>Ignite the Beacon</td>\n",
" <td>Stealth Mission</td>\n",
" <td>Lazotep Behemoth</td>\n",
" <td>Samut's Sprint</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Karn, the Great Creator</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>57</th>\n",
" <td>NaN</td>\n",
" <td>4.60</td>\n",
" <td>NaN</td>\n",
" <td>Lazotep Plating</td>\n",
" <td>NaN</td>\n",
" <td>Bond of Passion</td>\n",
" <td>Bond of Flourishing</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>58</th>\n",
" <td>NaN</td>\n",
" <td>4.50</td>\n",
" <td>Single Combat</td>\n",
" <td>Totally Lost</td>\n",
" <td>Liliana's Triumph</td>\n",
" <td>Goblin Assault Team</td>\n",
" <td>Primordial Wurm</td>\n",
" <td>Dovin, Hando of Control</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>59</th>\n",
" <td>NaN</td>\n",
" <td>4.50</td>\n",
" <td>Gideon's Sacrifice</td>\n",
" <td>Wall of Runes</td>\n",
" <td>Charity Extractor</td>\n",
" <td>Goblin Assailant</td>\n",
" <td>Storm the Citadel</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>60</th>\n",
" <td>NaN</td>\n",
" <td>4.40</td>\n",
" <td>Ironclad Krovod</td>\n",
" <td>NaN</td>\n",
" <td>Davriel's Shadowfugue</td>\n",
" <td>NaN</td>\n",
" <td>Nissa's Triumph</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>61</th>\n",
" <td>NaN</td>\n",
" <td>4.20</td>\n",
" <td>NaN</td>\n",
" <td>Naga Eternal</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Arboreal Grazer</td>\n",
" <td>Tezzeret, Master of the Bridge</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>62</th>\n",
" <td>NaN</td>\n",
" <td>4.00</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>63</th>\n",
" <td>NaN</td>\n",
" <td>3.75</td>\n",
" <td>Charmed Stray</td>\n",
" <td>NaN</td>\n",
" <td>Banehound</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>64</th>\n",
" <td>NaN</td>\n",
" <td>3.50</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Kaya's Ghostform</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>65</th>\n",
" <td>NaN</td>\n",
" <td>3.00</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Demolish</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>66</th>\n",
" <td>NaN</td>\n",
" <td>2.00</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>67</th>\n",
" <td>NaN</td>\n",
" <td>1.00</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Emergence Zone</td>\n",
" </tr>\n",
" <tr>\n",
" <th>68</th>\n",
" <td>NaN</td>\n",
" <td>0.00</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>69 rows × 11 columns</p>\n",
"</div>"
],
"text/plain": [
" Unnamed: 0 Ranking White \\\n",
"0 NaN 10.00 NaN \n",
"1 NaN 9.00 God-Eternal Oketra \n",
"2 NaN 9.00 NaN \n",
"3 NaN 9.00 NaN \n",
"4 NaN 8.00 Finale of Glory \n",
"5 NaN 7.00 NaN \n",
"6 NaN 6.50 NaN \n",
"7 NaN 6.50 Gideon Blackblade \n",
"8 NaN 6.50 NaN \n",
"9 NaN 6.50 NaN \n",
"10 NaN 6.50 NaN \n",
"11 NaN 6.50 NaN \n",
"12 NaN 6.50 NaN \n",
"13 NaN 6.25 Prison Realm \n",
"14 NaN 6.25 NaN \n",
"15 NaN 6.25 NaN \n",
"16 NaN 6.25 Trusted Pegasus \n",
"17 NaN 5.80 NaN \n",
"18 NaN 5.70 Law-Rune Enforcer \n",
"19 NaN 5.70 NaN \n",
"20 NaN 5.60 NaN \n",
"21 NaN 5.60 NaN \n",
"22 NaN 5.50 Grateful Apparition \n",
"23 NaN 5.50 Tomik, Distinguished Advokist \n",
"24 NaN 5.50 Rising Populace \n",
"25 NaN 5.40 Wanderer's Strike \n",
"26 NaN 5.40 NaN \n",
"27 NaN 5.40 NaN \n",
"28 NaN 5.40 NaN \n",
"29 NaN 5.40 NaN \n",
".. ... ... ... \n",
"39 NaN 5.10 NaN \n",
"40 NaN 5.00 Bond of Discipline \n",
"41 NaN 5.00 Battlefield Promotion \n",
"42 NaN 5.00 Defiant Strike \n",
"43 NaN 5.00 Enforcer Griffin \n",
"44 NaN 5.00 Martyr for the Cause \n",
"45 NaN 5.00 Rally of Wings \n",
"46 NaN 4.90 The Wanderer \n",
"47 NaN 4.90 Teyo's Lightshield \n",
"48 NaN 4.90 Pouncing Lynx \n",
"49 NaN 4.90 Gideon's Triumph \n",
"50 NaN 4.90 Topple the Statue \n",
"51 NaN 4.90 Ravnica at War \n",
"52 NaN 4.80 NaN \n",
"53 NaN 4.80 Makeshift Battalion \n",
"54 NaN 4.80 Baulwark Giant \n",
"55 NaN 4.80 Loxodon Sergeant \n",
"56 NaN 4.70 Ignite the Beacon \n",
"57 NaN 4.60 NaN \n",
"58 NaN 4.50 Single Combat \n",
"59 NaN 4.50 Gideon's Sacrifice \n",
"60 NaN 4.40 Ironclad Krovod \n",
"61 NaN 4.20 NaN \n",
"62 NaN 4.00 NaN \n",
"63 NaN 3.75 Charmed Stray \n",
"64 NaN 3.50 NaN \n",
"65 NaN 3.00 NaN \n",
"66 NaN 2.00 NaN \n",
"67 NaN 1.00 NaN \n",
"68 NaN 0.00 NaN \n",
"\n",
" Blue Black \\\n",
"0 NaN NaN \n",
"1 NaN Liana, Dreadhorde General \n",
"2 NaN God-Eternal Bontu \n",
"3 God-Eternal Kefnet Finale of Eternity \n",
"4 NaN NaN \n",
"5 NaN NaN \n",
"6 Commence the Endgame NaN \n",
"7 Jace Wielder of Mysteries NaN \n",
"8 NaN NaN \n",
"9 NaN NaN \n",
"10 NaN NaN \n",
"11 NaN NaN \n",
"12 Finale of Revelation NaN \n",
"13 NaN NaN \n",
"14 NaN Massacre Girl \n",
"15 NaN NaN \n",
"16 Kasmina Enigmatic Mentor NaN \n",
"17 NaN NaN \n",
"18 Tamiyo's Epiphany Ob Nixilis's Cruelty \n",
"19 NaN Dreadhorde Invasion \n",
"20 NaN Bleeding Edge \n",
"21 NaN Ob Nixlis, the Hate-Twisted \n",
"22 Aven Eternal Spark Harvest \n",
"23 NaN NaN \n",
"24 Rescuer Sphinx NaN \n",
"25 Thunder Drake Command the Dreadhorde \n",
"26 Callous Dismissal NaN \n",
"27 NaN NaN \n",
"28 Eternal Skylord NaN \n",
"29 Angur of Bolas NaN \n",
".. ... ... \n",
"39 Spellkeeper Weird NaN \n",
"40 No Escape Lazotep Reaver \n",
"41 Narset's Reversal Toll of the Invasion \n",
"42 Kasmina's Transmutation Herald of the Dreadhorde \n",
"43 NaN Spark Reaper \n",
"44 Narset, Parter of Veils Shriekdiver \n",
"45 Ashiok's Skulker Dreadmalkin \n",
"46 Sky Theater Strix Sorin's Thirst \n",
"47 Jace's Triumph Price of Betrayal \n",
"48 Silent Submersive Vraska's Finisher \n",
"49 Kiora's Dambreaker Aid the Fallen \n",
"50 Teferi's Time Twist Unlikely Aid \n",
"51 NaN Deliver Unto Evil \n",
"52 NaN Duskmantle Operative \n",
"53 Crush Dissent Tithebearer Giant \n",
"54 Relentless Advance Bond of Revival \n",
"55 Bond of Insight Vampire Opportunist \n",
"56 Stealth Mission Lazotep Behemoth \n",
"57 Lazotep Plating NaN \n",
"58 Totally Lost Liliana's Triumph \n",
"59 Wall of Runes Charity Extractor \n",
"60 NaN Davriel's Shadowfugue \n",
"61 Naga Eternal NaN \n",
"62 NaN NaN \n",
"63 NaN Banehound \n",
"64 NaN Kaya's Ghostform \n",
"65 NaN NaN \n",
"66 NaN NaN \n",
"67 NaN NaN \n",
"68 NaN NaN \n",
"\n",
" Red Green \\\n",
"0 NaN NaN \n",
"1 NaN NaN \n",
"2 NaN NaN \n",
"3 Illharg, the Raze-Boar NaN \n",
"4 Kenko, Tin Street Kingpin God-Eternal Rhonas \n",
"5 Neheb, Dreadhorde Champion NaN \n",
"6 Sarkhan the Masterless NaN \n",
"7 Chandra, Fire Artisan Nissa, Who Shakes the World \n",
"8 NaN Awakening of Vitu-Ghazi \n",
"9 NaN NaN \n",
"10 NaN NaN \n",
"11 NaN NaN \n",
"12 NaN NaN \n",
"13 NaN Vivien, Champion of the Wilds \n",
"14 NaN Planewide Celebration \n",
"15 NaN NaN \n",
"16 Jaya, Venerated Firemage NaN \n",
"17 NaN NaN \n",
"18 NaN Band Together \n",
"19 Cyclops Electromancer Arlinn, Voice of the Pack \n",
"20 Chandra's Triumph NaN \n",
"21 Tibalt, Rakish Instigator NaN \n",
"22 Jaya's Greeting NaN \n",
"23 NaN NaN \n",
"24 Spellgorger Weird NaN \n",
"25 NaN NaN \n",
"26 Mizzium Tank Jiang Yanggu, Wildcrafter \n",
"27 NaN Paradise Druid \n",
"28 NaN Bloom Hulk \n",
"29 NaN New Horizons \n",
".. ... ... \n",
"39 Raging Kronch NaN \n",
"40 Ahn-Crop Invader NaN \n",
"41 Tibalt's Rager Wardscale Crocodile \n",
"42 Burning Prophet Vivien's Grizzly \n",
"43 Honor the God-Pharaoh Giant Growth \n",
"44 Chainwip Cyclops Kronch Wrangler \n",
"45 Dreadhorde Arcanist Snarespinner \n",
"46 Bolt Bend Forced Landing \n",
"47 Grim Intiate NaN \n",
"48 Nahiri's Stoneblades Arlinn's Wolf \n",
"49 NaN Return to Nature \n",
"50 Sarkhan's Catharsis Kraul Stinger \n",
"51 Heartfire Thundering Ceratok \n",
"52 Devouring Hellion Finale of Devastation \n",
"53 Finale of Promise NaN \n",
"54 NaN Steady Aim \n",
"55 Invading Manticore Courage in Crisis \n",
"56 Samut's Sprint NaN \n",
"57 Bond of Passion Bond of Flourishing \n",
"58 Goblin Assault Team Primordial Wurm \n",
"59 Goblin Assailant Storm the Citadel \n",
"60 NaN Nissa's Triumph \n",
"61 NaN Arboreal Grazer \n",
"62 NaN NaN \n",
"63 NaN NaN \n",
"64 NaN NaN \n",
"65 Demolish NaN \n",
"66 NaN NaN \n",
"67 NaN NaN \n",
"68 NaN NaN \n",
"\n",
" Gold Gold2 \\\n",
"0 NaN NaN \n",
"1 NaN NaN \n",
"2 Nicol Bolas, Dragon-God NaN \n",
"3 NaN NaN \n",
"4 Ajani, the Greathearted Tolsimir, Friend to Wolves \n",
"5 Roalesk, Apex Hybrid Feather, the Redeemed \n",
"6 Storrev, Devkarin Lich Time Wipe \n",
"7 Domri, Anarch of Bolas Enter the God-Eternals \n",
"8 Ral, Storm Conduit Widespread Brutality \n",
"9 Sorin, Vengeful Bloodlord NaN \n",
"10 Teferi, Time Raveler NaN \n",
"11 Casualties of War NaN \n",
"12 Niv-Mizzet Reborn Kaya, Bane of the Dead \n",
"13 Living Twister Deathsprout \n",
"14 Oath of Kaya Elite Guardmage \n",
"15 NaN Ral's Outburst \n",
"16 Bioessence Hydra Despark \n",
"17 Saheeli, Sublime Artificer Soul Diviner \n",
"18 Leyline Prowler Angrath, Captain of Chaos \n",
"19 Merfolk Skydiver Invade the City \n",
"20 Heartwarming Redemption Samut, Tyrant Smasher \n",
"21 Domri's Ambush Tyrant's Scorn \n",
"22 Pledge of Unity Gleaming Overseer \n",
"23 NaN NaN \n",
"24 Mayhem Devil Angrath's Rampage \n",
"25 Nahiri, Storm of Stone Kiora, Behemoth Beckoner \n",
"26 Vraska, Swarm's Eminence Role Reversal \n",
"27 Solar Blaze NaN \n",
"28 Tamiyo, Collector of Tales Tenth District Legionnaire \n",
"29 Hualti's Raptor NaN \n",
".. ... ... \n",
"39 NaN NaN \n",
"40 NaN NaN \n",
"41 Ashiok, Dream Render NaN \n",
"42 Huatli, the Sun's Heart NaN \n",
"43 NaN NaN \n",
"44 NaN NaN \n",
"45 NaN NaN \n",
"46 NaN NaN \n",
"47 NaN NaN \n",
"48 NaN NaN \n",
"49 NaN NaN \n",
"50 NaN NaN \n",
"51 Dovin's Veto NaN \n",
"52 NaN NaN \n",
"53 NaN NaN \n",
"54 NaN Neoform \n",
"55 NaN NaN \n",
"56 NaN NaN \n",
"57 NaN NaN \n",
"58 Dovin, Hando of Control NaN \n",
"59 NaN NaN \n",
"60 NaN NaN \n",
"61 Tezzeret, Master of the Bridge NaN \n",
"62 NaN NaN \n",
"63 NaN NaN \n",
"64 NaN NaN \n",
"65 NaN NaN \n",
"66 NaN NaN \n",
"67 NaN NaN \n",
"68 NaN NaN \n",
"\n",
" Colorless Lands \n",
"0 NaN NaN \n",
"1 NaN NaN \n",
"2 NaN NaN \n",
"3 NaN NaN \n",
"4 Ugin, the Ineffable NaN \n",
"5 NaN NaN \n",
"6 NaN NaN \n",
"7 NaN NaN \n",
"8 NaN NaN \n",
"9 NaN NaN \n",
"10 NaN NaN \n",
"11 NaN NaN \n",
"12 NaN NaN \n",
"13 NaN NaN \n",
"14 NaN NaN \n",
"15 NaN NaN \n",
"16 NaN NaN \n",
"17 NaN NaN \n",
"18 NaN NaN \n",
"19 NaN NaN \n",
"20 NaN NaN \n",
"21 NaN NaN \n",
"22 NaN NaN \n",
"23 NaN NaN \n",
"24 NaN NaN \n",
"25 NaN NaN \n",
"26 NaN NaN \n",
"27 NaN Gateway Plaza \n",
"28 Mana Geode NaN \n",
"29 NaN NaN \n",
".. ... ... \n",
"39 NaN Mobilized District \n",
"40 Prismite NaN \n",
"41 Ugin's Conjurant NaN \n",
"42 NaN NaN \n",
"43 NaN NaN \n",
"44 NaN NaN \n",
"45 NaN NaN \n",
"46 Saheeli's Silverwing NaN \n",
"47 NaN NaN \n",
"48 NaN NaN \n",
"49 NaN NaN \n",
"50 NaN NaN \n",
"51 NaN Interplanar Beacon \n",
"52 NaN NaN \n",
"53 God-Pharaoh's Statue NaN \n",
"54 NaN NaN \n",
"55 NaN NaN \n",
"56 Karn, the Great Creator NaN \n",
"57 NaN NaN \n",
"58 NaN NaN \n",
"59 NaN NaN \n",
"60 NaN NaN \n",
"61 NaN NaN \n",
"62 NaN NaN \n",
"63 NaN NaN \n",
"64 NaN NaN \n",
"65 NaN NaN \n",
"66 NaN NaN \n",
"67 NaN Emergence Zone \n",
"68 NaN NaN \n",
"\n",
"[69 rows x 11 columns]"
]
},
"execution_count": 6,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df_renamed[\"Ranking\"] = df_renamed[\"Ranking\"].ffill()\n",
"df_renamed"
]
},
{
"cell_type": "code",
"execution_count": 7,
"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>Ranking</th>\n",
" <th>White</th>\n",
" <th>Blue</th>\n",
" <th>Black</th>\n",
" <th>Red</th>\n",
" <th>Green</th>\n",
" <th>Gold</th>\n",
" <th>Gold2</th>\n",
" <th>Colorless</th>\n",
" <th>Lands</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>10.00</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>9.00</td>\n",
" <td>God-Eternal Oketra</td>\n",
" <td>NaN</td>\n",
" <td>Liana, Dreadhorde General</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>9.00</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>God-Eternal Bontu</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Nicol Bolas, Dragon-God</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>9.00</td>\n",
" <td>NaN</td>\n",
" <td>God-Eternal Kefnet</td>\n",
" <td>Finale of Eternity</td>\n",
" <td>Illharg, the Raze-Boar</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>8.00</td>\n",
" <td>Finale of Glory</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Kenko, Tin Street Kingpin</td>\n",
" <td>God-Eternal Rhonas</td>\n",
" <td>Ajani, the Greathearted</td>\n",
" <td>Tolsimir, Friend to Wolves</td>\n",
" <td>Ugin, the Ineffable</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>7.00</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Neheb, Dreadhorde Champion</td>\n",
" <td>NaN</td>\n",
" <td>Roalesk, Apex Hybrid</td>\n",
" <td>Feather, the Redeemed</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>6.50</td>\n",
" <td>NaN</td>\n",
" <td>Commence the Endgame</td>\n",
" <td>NaN</td>\n",
" <td>Sarkhan the Masterless</td>\n",
" <td>NaN</td>\n",
" <td>Storrev, Devkarin Lich</td>\n",
" <td>Time Wipe</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>6.50</td>\n",
" <td>Gideon Blackblade</td>\n",
" <td>Jace Wielder of Mysteries</td>\n",
" <td>NaN</td>\n",
" <td>Chandra, Fire Artisan</td>\n",
" <td>Nissa, Who Shakes the World</td>\n",
" <td>Domri, Anarch of Bolas</td>\n",
" <td>Enter the God-Eternals</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>6.50</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Awakening of Vitu-Ghazi</td>\n",
" <td>Ral, Storm Conduit</td>\n",
" <td>Widespread Brutality</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>6.50</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Sorin, Vengeful Bloodlord</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>6.50</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Teferi, Time Raveler</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>6.50</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Casualties of War</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>6.50</td>\n",
" <td>NaN</td>\n",
" <td>Finale of Revelation</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Niv-Mizzet Reborn</td>\n",
" <td>Kaya, Bane of the Dead</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>6.25</td>\n",
" <td>Prison Realm</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Vivien, Champion of the Wilds</td>\n",
" <td>Living Twister</td>\n",
" <td>Deathsprout</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>6.25</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Massacre Girl</td>\n",
" <td>NaN</td>\n",
" <td>Planewide Celebration</td>\n",
" <td>Oath of Kaya</td>\n",
" <td>Elite Guardmage</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>6.25</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Ral's Outburst</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>6.25</td>\n",
" <td>Trusted Pegasus</td>\n",
" <td>Kasmina Enigmatic Mentor</td>\n",
" <td>NaN</td>\n",
" <td>Jaya, Venerated Firemage</td>\n",
" <td>NaN</td>\n",
" <td>Bioessence Hydra</td>\n",
" <td>Despark</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>5.80</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Saheeli, Sublime Artificer</td>\n",
" <td>Soul Diviner</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>5.70</td>\n",
" <td>Law-Rune Enforcer</td>\n",
" <td>Tamiyo's Epiphany</td>\n",
" <td>Ob Nixilis's Cruelty</td>\n",
" <td>NaN</td>\n",
" <td>Band Together</td>\n",
" <td>Leyline Prowler</td>\n",
" <td>Angrath, Captain of Chaos</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>5.70</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Dreadhorde Invasion</td>\n",
" <td>Cyclops Electromancer</td>\n",
" <td>Arlinn, Voice of the Pack</td>\n",
" <td>Merfolk Skydiver</td>\n",
" <td>Invade the City</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>5.60</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Bleeding Edge</td>\n",
" <td>Chandra's Triumph</td>\n",
" <td>NaN</td>\n",
" <td>Heartwarming Redemption</td>\n",
" <td>Samut, Tyrant Smasher</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>5.60</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Ob Nixlis, the Hate-Twisted</td>\n",
" <td>Tibalt, Rakish Instigator</td>\n",
" <td>NaN</td>\n",
" <td>Domri's Ambush</td>\n",
" <td>Tyrant's Scorn</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>5.50</td>\n",
" <td>Grateful Apparition</td>\n",
" <td>Aven Eternal</td>\n",
" <td>Spark Harvest</td>\n",
" <td>Jaya's Greeting</td>\n",
" <td>NaN</td>\n",
" <td>Pledge of Unity</td>\n",
" <td>Gleaming Overseer</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>5.50</td>\n",
" <td>Tomik, Distinguished Advokist</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>5.50</td>\n",
" <td>Rising Populace</td>\n",
" <td>Rescuer Sphinx</td>\n",
" <td>NaN</td>\n",
" <td>Spellgorger Weird</td>\n",
" <td>NaN</td>\n",
" <td>Mayhem Devil</td>\n",
" <td>Angrath's Rampage</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td>5.40</td>\n",
" <td>Wanderer's Strike</td>\n",
" <td>Thunder Drake</td>\n",
" <td>Command the Dreadhorde</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Nahiri, Storm of Stone</td>\n",
" <td>Kiora, Behemoth Beckoner</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td>5.40</td>\n",
" <td>NaN</td>\n",
" <td>Callous Dismissal</td>\n",
" <td>NaN</td>\n",
" <td>Mizzium Tank</td>\n",
" <td>Jiang Yanggu, Wildcrafter</td>\n",
" <td>Vraska, Swarm's Eminence</td>\n",
" <td>Role Reversal</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td>5.40</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Paradise Druid</td>\n",
" <td>Solar Blaze</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Gateway Plaza</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td>5.40</td>\n",
" <td>NaN</td>\n",
" <td>Eternal Skylord</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Bloom Hulk</td>\n",
" <td>Tamiyo, Collector of Tales</td>\n",
" <td>Tenth District Legionnaire</td>\n",
" <td>Mana Geode</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td>5.40</td>\n",
" <td>NaN</td>\n",
" <td>Angur of Bolas</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>New Horizons</td>\n",
" <td>Hualti's Raptor</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\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",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>39</th>\n",
" <td>5.10</td>\n",
" <td>NaN</td>\n",
" <td>Spellkeeper Weird</td>\n",
" <td>NaN</td>\n",
" <td>Raging Kronch</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Mobilized District</td>\n",
" </tr>\n",
" <tr>\n",
" <th>40</th>\n",
" <td>5.00</td>\n",
" <td>Bond of Discipline</td>\n",
" <td>No Escape</td>\n",
" <td>Lazotep Reaver</td>\n",
" <td>Ahn-Crop Invader</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Prismite</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>41</th>\n",
" <td>5.00</td>\n",
" <td>Battlefield Promotion</td>\n",
" <td>Narset's Reversal</td>\n",
" <td>Toll of the Invasion</td>\n",
" <td>Tibalt's Rager</td>\n",
" <td>Wardscale Crocodile</td>\n",
" <td>Ashiok, Dream Render</td>\n",
" <td>NaN</td>\n",
" <td>Ugin's Conjurant</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>42</th>\n",
" <td>5.00</td>\n",
" <td>Defiant Strike</td>\n",
" <td>Kasmina's Transmutation</td>\n",
" <td>Herald of the Dreadhorde</td>\n",
" <td>Burning Prophet</td>\n",
" <td>Vivien's Grizzly</td>\n",
" <td>Huatli, the Sun's Heart</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>43</th>\n",
" <td>5.00</td>\n",
" <td>Enforcer Griffin</td>\n",
" <td>NaN</td>\n",
" <td>Spark Reaper</td>\n",
" <td>Honor the God-Pharaoh</td>\n",
" <td>Giant Growth</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>44</th>\n",
" <td>5.00</td>\n",
" <td>Martyr for the Cause</td>\n",
" <td>Narset, Parter of Veils</td>\n",
" <td>Shriekdiver</td>\n",
" <td>Chainwip Cyclops</td>\n",
" <td>Kronch Wrangler</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>45</th>\n",
" <td>5.00</td>\n",
" <td>Rally of Wings</td>\n",
" <td>Ashiok's Skulker</td>\n",
" <td>Dreadmalkin</td>\n",
" <td>Dreadhorde Arcanist</td>\n",
" <td>Snarespinner</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>46</th>\n",
" <td>4.90</td>\n",
" <td>The Wanderer</td>\n",
" <td>Sky Theater Strix</td>\n",
" <td>Sorin's Thirst</td>\n",
" <td>Bolt Bend</td>\n",
" <td>Forced Landing</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Saheeli's Silverwing</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>47</th>\n",
" <td>4.90</td>\n",
" <td>Teyo's Lightshield</td>\n",
" <td>Jace's Triumph</td>\n",
" <td>Price of Betrayal</td>\n",
" <td>Grim Intiate</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>48</th>\n",
" <td>4.90</td>\n",
" <td>Pouncing Lynx</td>\n",
" <td>Silent Submersive</td>\n",
" <td>Vraska's Finisher</td>\n",
" <td>Nahiri's Stoneblades</td>\n",
" <td>Arlinn's Wolf</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>49</th>\n",
" <td>4.90</td>\n",
" <td>Gideon's Triumph</td>\n",
" <td>Kiora's Dambreaker</td>\n",
" <td>Aid the Fallen</td>\n",
" <td>NaN</td>\n",
" <td>Return to Nature</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>50</th>\n",
" <td>4.90</td>\n",
" <td>Topple the Statue</td>\n",
" <td>Teferi's Time Twist</td>\n",
" <td>Unlikely Aid</td>\n",
" <td>Sarkhan's Catharsis</td>\n",
" <td>Kraul Stinger</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>51</th>\n",
" <td>4.90</td>\n",
" <td>Ravnica at War</td>\n",
" <td>NaN</td>\n",
" <td>Deliver Unto Evil</td>\n",
" <td>Heartfire</td>\n",
" <td>Thundering Ceratok</td>\n",
" <td>Dovin's Veto</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Interplanar Beacon</td>\n",
" </tr>\n",
" <tr>\n",
" <th>52</th>\n",
" <td>4.80</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Duskmantle Operative</td>\n",
" <td>Devouring Hellion</td>\n",
" <td>Finale of Devastation</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>53</th>\n",
" <td>4.80</td>\n",
" <td>Makeshift Battalion</td>\n",
" <td>Crush Dissent</td>\n",
" <td>Tithebearer Giant</td>\n",
" <td>Finale of Promise</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>God-Pharaoh's Statue</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>54</th>\n",
" <td>4.80</td>\n",
" <td>Baulwark Giant</td>\n",
" <td>Relentless Advance</td>\n",
" <td>Bond of Revival</td>\n",
" <td>NaN</td>\n",
" <td>Steady Aim</td>\n",
" <td>NaN</td>\n",
" <td>Neoform</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>55</th>\n",
" <td>4.80</td>\n",
" <td>Loxodon Sergeant</td>\n",
" <td>Bond of Insight</td>\n",
" <td>Vampire Opportunist</td>\n",
" <td>Invading Manticore</td>\n",
" <td>Courage in Crisis</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>56</th>\n",
" <td>4.70</td>\n",
" <td>Ignite the Beacon</td>\n",
" <td>Stealth Mission</td>\n",
" <td>Lazotep Behemoth</td>\n",
" <td>Samut's Sprint</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Karn, the Great Creator</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>57</th>\n",
" <td>4.60</td>\n",
" <td>NaN</td>\n",
" <td>Lazotep Plating</td>\n",
" <td>NaN</td>\n",
" <td>Bond of Passion</td>\n",
" <td>Bond of Flourishing</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>58</th>\n",
" <td>4.50</td>\n",
" <td>Single Combat</td>\n",
" <td>Totally Lost</td>\n",
" <td>Liliana's Triumph</td>\n",
" <td>Goblin Assault Team</td>\n",
" <td>Primordial Wurm</td>\n",
" <td>Dovin, Hando of Control</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>59</th>\n",
" <td>4.50</td>\n",
" <td>Gideon's Sacrifice</td>\n",
" <td>Wall of Runes</td>\n",
" <td>Charity Extractor</td>\n",
" <td>Goblin Assailant</td>\n",
" <td>Storm the Citadel</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>60</th>\n",
" <td>4.40</td>\n",
" <td>Ironclad Krovod</td>\n",
" <td>NaN</td>\n",
" <td>Davriel's Shadowfugue</td>\n",
" <td>NaN</td>\n",
" <td>Nissa's Triumph</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>61</th>\n",
" <td>4.20</td>\n",
" <td>NaN</td>\n",
" <td>Naga Eternal</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Arboreal Grazer</td>\n",
" <td>Tezzeret, Master of the Bridge</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>62</th>\n",
" <td>4.00</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>63</th>\n",
" <td>3.75</td>\n",
" <td>Charmed Stray</td>\n",
" <td>NaN</td>\n",
" <td>Banehound</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>64</th>\n",
" <td>3.50</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Kaya's Ghostform</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>65</th>\n",
" <td>3.00</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Demolish</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>66</th>\n",
" <td>2.00</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>67</th>\n",
" <td>1.00</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Emergence Zone</td>\n",
" </tr>\n",
" <tr>\n",
" <th>68</th>\n",
" <td>0.00</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>69 rows × 10 columns</p>\n",
"</div>"
],
"text/plain": [
" Ranking White Blue \\\n",
"0 10.00 NaN NaN \n",
"1 9.00 God-Eternal Oketra NaN \n",
"2 9.00 NaN NaN \n",
"3 9.00 NaN God-Eternal Kefnet \n",
"4 8.00 Finale of Glory NaN \n",
"5 7.00 NaN NaN \n",
"6 6.50 NaN Commence the Endgame \n",
"7 6.50 Gideon Blackblade Jace Wielder of Mysteries \n",
"8 6.50 NaN NaN \n",
"9 6.50 NaN NaN \n",
"10 6.50 NaN NaN \n",
"11 6.50 NaN NaN \n",
"12 6.50 NaN Finale of Revelation \n",
"13 6.25 Prison Realm NaN \n",
"14 6.25 NaN NaN \n",
"15 6.25 NaN NaN \n",
"16 6.25 Trusted Pegasus Kasmina Enigmatic Mentor \n",
"17 5.80 NaN NaN \n",
"18 5.70 Law-Rune Enforcer Tamiyo's Epiphany \n",
"19 5.70 NaN NaN \n",
"20 5.60 NaN NaN \n",
"21 5.60 NaN NaN \n",
"22 5.50 Grateful Apparition Aven Eternal \n",
"23 5.50 Tomik, Distinguished Advokist NaN \n",
"24 5.50 Rising Populace Rescuer Sphinx \n",
"25 5.40 Wanderer's Strike Thunder Drake \n",
"26 5.40 NaN Callous Dismissal \n",
"27 5.40 NaN NaN \n",
"28 5.40 NaN Eternal Skylord \n",
"29 5.40 NaN Angur of Bolas \n",
".. ... ... ... \n",
"39 5.10 NaN Spellkeeper Weird \n",
"40 5.00 Bond of Discipline No Escape \n",
"41 5.00 Battlefield Promotion Narset's Reversal \n",
"42 5.00 Defiant Strike Kasmina's Transmutation \n",
"43 5.00 Enforcer Griffin NaN \n",
"44 5.00 Martyr for the Cause Narset, Parter of Veils \n",
"45 5.00 Rally of Wings Ashiok's Skulker \n",
"46 4.90 The Wanderer Sky Theater Strix \n",
"47 4.90 Teyo's Lightshield Jace's Triumph \n",
"48 4.90 Pouncing Lynx Silent Submersive \n",
"49 4.90 Gideon's Triumph Kiora's Dambreaker \n",
"50 4.90 Topple the Statue Teferi's Time Twist \n",
"51 4.90 Ravnica at War NaN \n",
"52 4.80 NaN NaN \n",
"53 4.80 Makeshift Battalion Crush Dissent \n",
"54 4.80 Baulwark Giant Relentless Advance \n",
"55 4.80 Loxodon Sergeant Bond of Insight \n",
"56 4.70 Ignite the Beacon Stealth Mission \n",
"57 4.60 NaN Lazotep Plating \n",
"58 4.50 Single Combat Totally Lost \n",
"59 4.50 Gideon's Sacrifice Wall of Runes \n",
"60 4.40 Ironclad Krovod NaN \n",
"61 4.20 NaN Naga Eternal \n",
"62 4.00 NaN NaN \n",
"63 3.75 Charmed Stray NaN \n",
"64 3.50 NaN NaN \n",
"65 3.00 NaN NaN \n",
"66 2.00 NaN NaN \n",
"67 1.00 NaN NaN \n",
"68 0.00 NaN NaN \n",
"\n",
" Black Red \\\n",
"0 NaN NaN \n",
"1 Liana, Dreadhorde General NaN \n",
"2 God-Eternal Bontu NaN \n",
"3 Finale of Eternity Illharg, the Raze-Boar \n",
"4 NaN Kenko, Tin Street Kingpin \n",
"5 NaN Neheb, Dreadhorde Champion \n",
"6 NaN Sarkhan the Masterless \n",
"7 NaN Chandra, Fire Artisan \n",
"8 NaN NaN \n",
"9 NaN NaN \n",
"10 NaN NaN \n",
"11 NaN NaN \n",
"12 NaN NaN \n",
"13 NaN NaN \n",
"14 Massacre Girl NaN \n",
"15 NaN NaN \n",
"16 NaN Jaya, Venerated Firemage \n",
"17 NaN NaN \n",
"18 Ob Nixilis's Cruelty NaN \n",
"19 Dreadhorde Invasion Cyclops Electromancer \n",
"20 Bleeding Edge Chandra's Triumph \n",
"21 Ob Nixlis, the Hate-Twisted Tibalt, Rakish Instigator \n",
"22 Spark Harvest Jaya's Greeting \n",
"23 NaN NaN \n",
"24 NaN Spellgorger Weird \n",
"25 Command the Dreadhorde NaN \n",
"26 NaN Mizzium Tank \n",
"27 NaN NaN \n",
"28 NaN NaN \n",
"29 NaN NaN \n",
".. ... ... \n",
"39 NaN Raging Kronch \n",
"40 Lazotep Reaver Ahn-Crop Invader \n",
"41 Toll of the Invasion Tibalt's Rager \n",
"42 Herald of the Dreadhorde Burning Prophet \n",
"43 Spark Reaper Honor the God-Pharaoh \n",
"44 Shriekdiver Chainwip Cyclops \n",
"45 Dreadmalkin Dreadhorde Arcanist \n",
"46 Sorin's Thirst Bolt Bend \n",
"47 Price of Betrayal Grim Intiate \n",
"48 Vraska's Finisher Nahiri's Stoneblades \n",
"49 Aid the Fallen NaN \n",
"50 Unlikely Aid Sarkhan's Catharsis \n",
"51 Deliver Unto Evil Heartfire \n",
"52 Duskmantle Operative Devouring Hellion \n",
"53 Tithebearer Giant Finale of Promise \n",
"54 Bond of Revival NaN \n",
"55 Vampire Opportunist Invading Manticore \n",
"56 Lazotep Behemoth Samut's Sprint \n",
"57 NaN Bond of Passion \n",
"58 Liliana's Triumph Goblin Assault Team \n",
"59 Charity Extractor Goblin Assailant \n",
"60 Davriel's Shadowfugue NaN \n",
"61 NaN NaN \n",
"62 NaN NaN \n",
"63 Banehound NaN \n",
"64 Kaya's Ghostform NaN \n",
"65 NaN Demolish \n",
"66 NaN NaN \n",
"67 NaN NaN \n",
"68 NaN NaN \n",
"\n",
" Green Gold \\\n",
"0 NaN NaN \n",
"1 NaN NaN \n",
"2 NaN Nicol Bolas, Dragon-God \n",
"3 NaN NaN \n",
"4 God-Eternal Rhonas Ajani, the Greathearted \n",
"5 NaN Roalesk, Apex Hybrid \n",
"6 NaN Storrev, Devkarin Lich \n",
"7 Nissa, Who Shakes the World Domri, Anarch of Bolas \n",
"8 Awakening of Vitu-Ghazi Ral, Storm Conduit \n",
"9 NaN Sorin, Vengeful Bloodlord \n",
"10 NaN Teferi, Time Raveler \n",
"11 NaN Casualties of War \n",
"12 NaN Niv-Mizzet Reborn \n",
"13 Vivien, Champion of the Wilds Living Twister \n",
"14 Planewide Celebration Oath of Kaya \n",
"15 NaN NaN \n",
"16 NaN Bioessence Hydra \n",
"17 NaN Saheeli, Sublime Artificer \n",
"18 Band Together Leyline Prowler \n",
"19 Arlinn, Voice of the Pack Merfolk Skydiver \n",
"20 NaN Heartwarming Redemption \n",
"21 NaN Domri's Ambush \n",
"22 NaN Pledge of Unity \n",
"23 NaN NaN \n",
"24 NaN Mayhem Devil \n",
"25 NaN Nahiri, Storm of Stone \n",
"26 Jiang Yanggu, Wildcrafter Vraska, Swarm's Eminence \n",
"27 Paradise Druid Solar Blaze \n",
"28 Bloom Hulk Tamiyo, Collector of Tales \n",
"29 New Horizons Hualti's Raptor \n",
".. ... ... \n",
"39 NaN NaN \n",
"40 NaN NaN \n",
"41 Wardscale Crocodile Ashiok, Dream Render \n",
"42 Vivien's Grizzly Huatli, the Sun's Heart \n",
"43 Giant Growth NaN \n",
"44 Kronch Wrangler NaN \n",
"45 Snarespinner NaN \n",
"46 Forced Landing NaN \n",
"47 NaN NaN \n",
"48 Arlinn's Wolf NaN \n",
"49 Return to Nature NaN \n",
"50 Kraul Stinger NaN \n",
"51 Thundering Ceratok Dovin's Veto \n",
"52 Finale of Devastation NaN \n",
"53 NaN NaN \n",
"54 Steady Aim NaN \n",
"55 Courage in Crisis NaN \n",
"56 NaN NaN \n",
"57 Bond of Flourishing NaN \n",
"58 Primordial Wurm Dovin, Hando of Control \n",
"59 Storm the Citadel NaN \n",
"60 Nissa's Triumph NaN \n",
"61 Arboreal Grazer Tezzeret, Master of the Bridge \n",
"62 NaN NaN \n",
"63 NaN NaN \n",
"64 NaN NaN \n",
"65 NaN NaN \n",
"66 NaN NaN \n",
"67 NaN NaN \n",
"68 NaN NaN \n",
"\n",
" Gold2 Colorless Lands \n",
"0 NaN NaN NaN \n",
"1 NaN NaN NaN \n",
"2 NaN NaN NaN \n",
"3 NaN NaN NaN \n",
"4 Tolsimir, Friend to Wolves Ugin, the Ineffable NaN \n",
"5 Feather, the Redeemed NaN NaN \n",
"6 Time Wipe NaN NaN \n",
"7 Enter the God-Eternals NaN NaN \n",
"8 Widespread Brutality NaN NaN \n",
"9 NaN NaN NaN \n",
"10 NaN NaN NaN \n",
"11 NaN NaN NaN \n",
"12 Kaya, Bane of the Dead NaN NaN \n",
"13 Deathsprout NaN NaN \n",
"14 Elite Guardmage NaN NaN \n",
"15 Ral's Outburst NaN NaN \n",
"16 Despark NaN NaN \n",
"17 Soul Diviner NaN NaN \n",
"18 Angrath, Captain of Chaos NaN NaN \n",
"19 Invade the City NaN NaN \n",
"20 Samut, Tyrant Smasher NaN NaN \n",
"21 Tyrant's Scorn NaN NaN \n",
"22 Gleaming Overseer NaN NaN \n",
"23 NaN NaN NaN \n",
"24 Angrath's Rampage NaN NaN \n",
"25 Kiora, Behemoth Beckoner NaN NaN \n",
"26 Role Reversal NaN NaN \n",
"27 NaN NaN Gateway Plaza \n",
"28 Tenth District Legionnaire Mana Geode NaN \n",
"29 NaN NaN NaN \n",
".. ... ... ... \n",
"39 NaN NaN Mobilized District \n",
"40 NaN Prismite NaN \n",
"41 NaN Ugin's Conjurant NaN \n",
"42 NaN NaN NaN \n",
"43 NaN NaN NaN \n",
"44 NaN NaN NaN \n",
"45 NaN NaN NaN \n",
"46 NaN Saheeli's Silverwing NaN \n",
"47 NaN NaN NaN \n",
"48 NaN NaN NaN \n",
"49 NaN NaN NaN \n",
"50 NaN NaN NaN \n",
"51 NaN NaN Interplanar Beacon \n",
"52 NaN NaN NaN \n",
"53 NaN God-Pharaoh's Statue NaN \n",
"54 Neoform NaN NaN \n",
"55 NaN NaN NaN \n",
"56 NaN Karn, the Great Creator NaN \n",
"57 NaN NaN NaN \n",
"58 NaN NaN NaN \n",
"59 NaN NaN NaN \n",
"60 NaN NaN NaN \n",
"61 NaN NaN NaN \n",
"62 NaN NaN NaN \n",
"63 NaN NaN NaN \n",
"64 NaN NaN NaN \n",
"65 NaN NaN NaN \n",
"66 NaN NaN NaN \n",
"67 NaN NaN Emergence Zone \n",
"68 NaN NaN NaN \n",
"\n",
"[69 rows x 10 columns]"
]
},
"execution_count": 7,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df_dropped = df_renamed.drop(columns=\"Unnamed: 0\")\n",
"df_dropped"
]
},
{
"cell_type": "code",
"execution_count": 8,
"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>White</th>\n",
" <th>Blue</th>\n",
" <th>Black</th>\n",
" <th>Red</th>\n",
" <th>Green</th>\n",
" <th>Gold</th>\n",
" <th>Gold2</th>\n",
" <th>Colorless</th>\n",
" <th>Lands</th>\n",
" </tr>\n",
" <tr>\n",
" <th>Ranking</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>10.00</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9.00</th>\n",
" <td>God-Eternal Oketra</td>\n",
" <td>NaN</td>\n",
" <td>Liana, Dreadhorde General</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9.00</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>God-Eternal Bontu</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Nicol Bolas, Dragon-God</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9.00</th>\n",
" <td>NaN</td>\n",
" <td>God-Eternal Kefnet</td>\n",
" <td>Finale of Eternity</td>\n",
" <td>Illharg, the Raze-Boar</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8.00</th>\n",
" <td>Finale of Glory</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Kenko, Tin Street Kingpin</td>\n",
" <td>God-Eternal Rhonas</td>\n",
" <td>Ajani, the Greathearted</td>\n",
" <td>Tolsimir, Friend to Wolves</td>\n",
" <td>Ugin, the Ineffable</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7.00</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Neheb, Dreadhorde Champion</td>\n",
" <td>NaN</td>\n",
" <td>Roalesk, Apex Hybrid</td>\n",
" <td>Feather, the Redeemed</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6.50</th>\n",
" <td>NaN</td>\n",
" <td>Commence the Endgame</td>\n",
" <td>NaN</td>\n",
" <td>Sarkhan the Masterless</td>\n",
" <td>NaN</td>\n",
" <td>Storrev, Devkarin Lich</td>\n",
" <td>Time Wipe</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6.50</th>\n",
" <td>Gideon Blackblade</td>\n",
" <td>Jace Wielder of Mysteries</td>\n",
" <td>NaN</td>\n",
" <td>Chandra, Fire Artisan</td>\n",
" <td>Nissa, Who Shakes the World</td>\n",
" <td>Domri, Anarch of Bolas</td>\n",
" <td>Enter the God-Eternals</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6.50</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Awakening of Vitu-Ghazi</td>\n",
" <td>Ral, Storm Conduit</td>\n",
" <td>Widespread Brutality</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6.50</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Sorin, Vengeful Bloodlord</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6.50</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Teferi, Time Raveler</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6.50</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Casualties of War</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6.50</th>\n",
" <td>NaN</td>\n",
" <td>Finale of Revelation</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Niv-Mizzet Reborn</td>\n",
" <td>Kaya, Bane of the Dead</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6.25</th>\n",
" <td>Prison Realm</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Vivien, Champion of the Wilds</td>\n",
" <td>Living Twister</td>\n",
" <td>Deathsprout</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6.25</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Massacre Girl</td>\n",
" <td>NaN</td>\n",
" <td>Planewide Celebration</td>\n",
" <td>Oath of Kaya</td>\n",
" <td>Elite Guardmage</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6.25</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Ral's Outburst</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6.25</th>\n",
" <td>Trusted Pegasus</td>\n",
" <td>Kasmina Enigmatic Mentor</td>\n",
" <td>NaN</td>\n",
" <td>Jaya, Venerated Firemage</td>\n",
" <td>NaN</td>\n",
" <td>Bioessence Hydra</td>\n",
" <td>Despark</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5.80</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Saheeli, Sublime Artificer</td>\n",
" <td>Soul Diviner</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5.70</th>\n",
" <td>Law-Rune Enforcer</td>\n",
" <td>Tamiyo's Epiphany</td>\n",
" <td>Ob Nixilis's Cruelty</td>\n",
" <td>NaN</td>\n",
" <td>Band Together</td>\n",
" <td>Leyline Prowler</td>\n",
" <td>Angrath, Captain of Chaos</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5.70</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Dreadhorde Invasion</td>\n",
" <td>Cyclops Electromancer</td>\n",
" <td>Arlinn, Voice of the Pack</td>\n",
" <td>Merfolk Skydiver</td>\n",
" <td>Invade the City</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5.60</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Bleeding Edge</td>\n",
" <td>Chandra's Triumph</td>\n",
" <td>NaN</td>\n",
" <td>Heartwarming Redemption</td>\n",
" <td>Samut, Tyrant Smasher</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5.60</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Ob Nixlis, the Hate-Twisted</td>\n",
" <td>Tibalt, Rakish Instigator</td>\n",
" <td>NaN</td>\n",
" <td>Domri's Ambush</td>\n",
" <td>Tyrant's Scorn</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5.50</th>\n",
" <td>Grateful Apparition</td>\n",
" <td>Aven Eternal</td>\n",
" <td>Spark Harvest</td>\n",
" <td>Jaya's Greeting</td>\n",
" <td>NaN</td>\n",
" <td>Pledge of Unity</td>\n",
" <td>Gleaming Overseer</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5.50</th>\n",
" <td>Tomik, Distinguished Advokist</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5.50</th>\n",
" <td>Rising Populace</td>\n",
" <td>Rescuer Sphinx</td>\n",
" <td>NaN</td>\n",
" <td>Spellgorger Weird</td>\n",
" <td>NaN</td>\n",
" <td>Mayhem Devil</td>\n",
" <td>Angrath's Rampage</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5.40</th>\n",
" <td>Wanderer's Strike</td>\n",
" <td>Thunder Drake</td>\n",
" <td>Command the Dreadhorde</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Nahiri, Storm of Stone</td>\n",
" <td>Kiora, Behemoth Beckoner</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5.40</th>\n",
" <td>NaN</td>\n",
" <td>Callous Dismissal</td>\n",
" <td>NaN</td>\n",
" <td>Mizzium Tank</td>\n",
" <td>Jiang Yanggu, Wildcrafter</td>\n",
" <td>Vraska, Swarm's Eminence</td>\n",
" <td>Role Reversal</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5.40</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Paradise Druid</td>\n",
" <td>Solar Blaze</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Gateway Plaza</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5.40</th>\n",
" <td>NaN</td>\n",
" <td>Eternal Skylord</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Bloom Hulk</td>\n",
" <td>Tamiyo, Collector of Tales</td>\n",
" <td>Tenth District Legionnaire</td>\n",
" <td>Mana Geode</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5.40</th>\n",
" <td>NaN</td>\n",
" <td>Angur of Bolas</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>New Horizons</td>\n",
" <td>Hualti's Raptor</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\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",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5.10</th>\n",
" <td>NaN</td>\n",
" <td>Spellkeeper Weird</td>\n",
" <td>NaN</td>\n",
" <td>Raging Kronch</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Mobilized District</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5.00</th>\n",
" <td>Bond of Discipline</td>\n",
" <td>No Escape</td>\n",
" <td>Lazotep Reaver</td>\n",
" <td>Ahn-Crop Invader</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Prismite</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5.00</th>\n",
" <td>Battlefield Promotion</td>\n",
" <td>Narset's Reversal</td>\n",
" <td>Toll of the Invasion</td>\n",
" <td>Tibalt's Rager</td>\n",
" <td>Wardscale Crocodile</td>\n",
" <td>Ashiok, Dream Render</td>\n",
" <td>NaN</td>\n",
" <td>Ugin's Conjurant</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5.00</th>\n",
" <td>Defiant Strike</td>\n",
" <td>Kasmina's Transmutation</td>\n",
" <td>Herald of the Dreadhorde</td>\n",
" <td>Burning Prophet</td>\n",
" <td>Vivien's Grizzly</td>\n",
" <td>Huatli, the Sun's Heart</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5.00</th>\n",
" <td>Enforcer Griffin</td>\n",
" <td>NaN</td>\n",
" <td>Spark Reaper</td>\n",
" <td>Honor the God-Pharaoh</td>\n",
" <td>Giant Growth</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5.00</th>\n",
" <td>Martyr for the Cause</td>\n",
" <td>Narset, Parter of Veils</td>\n",
" <td>Shriekdiver</td>\n",
" <td>Chainwip Cyclops</td>\n",
" <td>Kronch Wrangler</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5.00</th>\n",
" <td>Rally of Wings</td>\n",
" <td>Ashiok's Skulker</td>\n",
" <td>Dreadmalkin</td>\n",
" <td>Dreadhorde Arcanist</td>\n",
" <td>Snarespinner</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4.90</th>\n",
" <td>The Wanderer</td>\n",
" <td>Sky Theater Strix</td>\n",
" <td>Sorin's Thirst</td>\n",
" <td>Bolt Bend</td>\n",
" <td>Forced Landing</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Saheeli's Silverwing</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4.90</th>\n",
" <td>Teyo's Lightshield</td>\n",
" <td>Jace's Triumph</td>\n",
" <td>Price of Betrayal</td>\n",
" <td>Grim Intiate</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4.90</th>\n",
" <td>Pouncing Lynx</td>\n",
" <td>Silent Submersive</td>\n",
" <td>Vraska's Finisher</td>\n",
" <td>Nahiri's Stoneblades</td>\n",
" <td>Arlinn's Wolf</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4.90</th>\n",
" <td>Gideon's Triumph</td>\n",
" <td>Kiora's Dambreaker</td>\n",
" <td>Aid the Fallen</td>\n",
" <td>NaN</td>\n",
" <td>Return to Nature</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4.90</th>\n",
" <td>Topple the Statue</td>\n",
" <td>Teferi's Time Twist</td>\n",
" <td>Unlikely Aid</td>\n",
" <td>Sarkhan's Catharsis</td>\n",
" <td>Kraul Stinger</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4.90</th>\n",
" <td>Ravnica at War</td>\n",
" <td>NaN</td>\n",
" <td>Deliver Unto Evil</td>\n",
" <td>Heartfire</td>\n",
" <td>Thundering Ceratok</td>\n",
" <td>Dovin's Veto</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Interplanar Beacon</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4.80</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Duskmantle Operative</td>\n",
" <td>Devouring Hellion</td>\n",
" <td>Finale of Devastation</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4.80</th>\n",
" <td>Makeshift Battalion</td>\n",
" <td>Crush Dissent</td>\n",
" <td>Tithebearer Giant</td>\n",
" <td>Finale of Promise</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>God-Pharaoh's Statue</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4.80</th>\n",
" <td>Baulwark Giant</td>\n",
" <td>Relentless Advance</td>\n",
" <td>Bond of Revival</td>\n",
" <td>NaN</td>\n",
" <td>Steady Aim</td>\n",
" <td>NaN</td>\n",
" <td>Neoform</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4.80</th>\n",
" <td>Loxodon Sergeant</td>\n",
" <td>Bond of Insight</td>\n",
" <td>Vampire Opportunist</td>\n",
" <td>Invading Manticore</td>\n",
" <td>Courage in Crisis</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4.70</th>\n",
" <td>Ignite the Beacon</td>\n",
" <td>Stealth Mission</td>\n",
" <td>Lazotep Behemoth</td>\n",
" <td>Samut's Sprint</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Karn, the Great Creator</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4.60</th>\n",
" <td>NaN</td>\n",
" <td>Lazotep Plating</td>\n",
" <td>NaN</td>\n",
" <td>Bond of Passion</td>\n",
" <td>Bond of Flourishing</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4.50</th>\n",
" <td>Single Combat</td>\n",
" <td>Totally Lost</td>\n",
" <td>Liliana's Triumph</td>\n",
" <td>Goblin Assault Team</td>\n",
" <td>Primordial Wurm</td>\n",
" <td>Dovin, Hando of Control</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4.50</th>\n",
" <td>Gideon's Sacrifice</td>\n",
" <td>Wall of Runes</td>\n",
" <td>Charity Extractor</td>\n",
" <td>Goblin Assailant</td>\n",
" <td>Storm the Citadel</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4.40</th>\n",
" <td>Ironclad Krovod</td>\n",
" <td>NaN</td>\n",
" <td>Davriel's Shadowfugue</td>\n",
" <td>NaN</td>\n",
" <td>Nissa's Triumph</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4.20</th>\n",
" <td>NaN</td>\n",
" <td>Naga Eternal</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Arboreal Grazer</td>\n",
" <td>Tezzeret, Master of the Bridge</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4.00</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3.75</th>\n",
" <td>Charmed Stray</td>\n",
" <td>NaN</td>\n",
" <td>Banehound</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3.50</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Kaya's Ghostform</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3.00</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Demolish</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2.00</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1.00</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Emergence Zone</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0.00</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>69 rows × 9 columns</p>\n",
"</div>"
],
"text/plain": [
" White Blue \\\n",
"Ranking \n",
"10.00 NaN NaN \n",
"9.00 God-Eternal Oketra NaN \n",
"9.00 NaN NaN \n",
"9.00 NaN God-Eternal Kefnet \n",
"8.00 Finale of Glory NaN \n",
"7.00 NaN NaN \n",
"6.50 NaN Commence the Endgame \n",
"6.50 Gideon Blackblade Jace Wielder of Mysteries \n",
"6.50 NaN NaN \n",
"6.50 NaN NaN \n",
"6.50 NaN NaN \n",
"6.50 NaN NaN \n",
"6.50 NaN Finale of Revelation \n",
"6.25 Prison Realm NaN \n",
"6.25 NaN NaN \n",
"6.25 NaN NaN \n",
"6.25 Trusted Pegasus Kasmina Enigmatic Mentor \n",
"5.80 NaN NaN \n",
"5.70 Law-Rune Enforcer Tamiyo's Epiphany \n",
"5.70 NaN NaN \n",
"5.60 NaN NaN \n",
"5.60 NaN NaN \n",
"5.50 Grateful Apparition Aven Eternal \n",
"5.50 Tomik, Distinguished Advokist NaN \n",
"5.50 Rising Populace Rescuer Sphinx \n",
"5.40 Wanderer's Strike Thunder Drake \n",
"5.40 NaN Callous Dismissal \n",
"5.40 NaN NaN \n",
"5.40 NaN Eternal Skylord \n",
"5.40 NaN Angur of Bolas \n",
"... ... ... \n",
"5.10 NaN Spellkeeper Weird \n",
"5.00 Bond of Discipline No Escape \n",
"5.00 Battlefield Promotion Narset's Reversal \n",
"5.00 Defiant Strike Kasmina's Transmutation \n",
"5.00 Enforcer Griffin NaN \n",
"5.00 Martyr for the Cause Narset, Parter of Veils \n",
"5.00 Rally of Wings Ashiok's Skulker \n",
"4.90 The Wanderer Sky Theater Strix \n",
"4.90 Teyo's Lightshield Jace's Triumph \n",
"4.90 Pouncing Lynx Silent Submersive \n",
"4.90 Gideon's Triumph Kiora's Dambreaker \n",
"4.90 Topple the Statue Teferi's Time Twist \n",
"4.90 Ravnica at War NaN \n",
"4.80 NaN NaN \n",
"4.80 Makeshift Battalion Crush Dissent \n",
"4.80 Baulwark Giant Relentless Advance \n",
"4.80 Loxodon Sergeant Bond of Insight \n",
"4.70 Ignite the Beacon Stealth Mission \n",
"4.60 NaN Lazotep Plating \n",
"4.50 Single Combat Totally Lost \n",
"4.50 Gideon's Sacrifice Wall of Runes \n",
"4.40 Ironclad Krovod NaN \n",
"4.20 NaN Naga Eternal \n",
"4.00 NaN NaN \n",
"3.75 Charmed Stray NaN \n",
"3.50 NaN NaN \n",
"3.00 NaN NaN \n",
"2.00 NaN NaN \n",
"1.00 NaN NaN \n",
"0.00 NaN NaN \n",
"\n",
" Black Red \\\n",
"Ranking \n",
"10.00 NaN NaN \n",
"9.00 Liana, Dreadhorde General NaN \n",
"9.00 God-Eternal Bontu NaN \n",
"9.00 Finale of Eternity Illharg, the Raze-Boar \n",
"8.00 NaN Kenko, Tin Street Kingpin \n",
"7.00 NaN Neheb, Dreadhorde Champion \n",
"6.50 NaN Sarkhan the Masterless \n",
"6.50 NaN Chandra, Fire Artisan \n",
"6.50 NaN NaN \n",
"6.50 NaN NaN \n",
"6.50 NaN NaN \n",
"6.50 NaN NaN \n",
"6.50 NaN NaN \n",
"6.25 NaN NaN \n",
"6.25 Massacre Girl NaN \n",
"6.25 NaN NaN \n",
"6.25 NaN Jaya, Venerated Firemage \n",
"5.80 NaN NaN \n",
"5.70 Ob Nixilis's Cruelty NaN \n",
"5.70 Dreadhorde Invasion Cyclops Electromancer \n",
"5.60 Bleeding Edge Chandra's Triumph \n",
"5.60 Ob Nixlis, the Hate-Twisted Tibalt, Rakish Instigator \n",
"5.50 Spark Harvest Jaya's Greeting \n",
"5.50 NaN NaN \n",
"5.50 NaN Spellgorger Weird \n",
"5.40 Command the Dreadhorde NaN \n",
"5.40 NaN Mizzium Tank \n",
"5.40 NaN NaN \n",
"5.40 NaN NaN \n",
"5.40 NaN NaN \n",
"... ... ... \n",
"5.10 NaN Raging Kronch \n",
"5.00 Lazotep Reaver Ahn-Crop Invader \n",
"5.00 Toll of the Invasion Tibalt's Rager \n",
"5.00 Herald of the Dreadhorde Burning Prophet \n",
"5.00 Spark Reaper Honor the God-Pharaoh \n",
"5.00 Shriekdiver Chainwip Cyclops \n",
"5.00 Dreadmalkin Dreadhorde Arcanist \n",
"4.90 Sorin's Thirst Bolt Bend \n",
"4.90 Price of Betrayal Grim Intiate \n",
"4.90 Vraska's Finisher Nahiri's Stoneblades \n",
"4.90 Aid the Fallen NaN \n",
"4.90 Unlikely Aid Sarkhan's Catharsis \n",
"4.90 Deliver Unto Evil Heartfire \n",
"4.80 Duskmantle Operative Devouring Hellion \n",
"4.80 Tithebearer Giant Finale of Promise \n",
"4.80 Bond of Revival NaN \n",
"4.80 Vampire Opportunist Invading Manticore \n",
"4.70 Lazotep Behemoth Samut's Sprint \n",
"4.60 NaN Bond of Passion \n",
"4.50 Liliana's Triumph Goblin Assault Team \n",
"4.50 Charity Extractor Goblin Assailant \n",
"4.40 Davriel's Shadowfugue NaN \n",
"4.20 NaN NaN \n",
"4.00 NaN NaN \n",
"3.75 Banehound NaN \n",
"3.50 Kaya's Ghostform NaN \n",
"3.00 NaN Demolish \n",
"2.00 NaN NaN \n",
"1.00 NaN NaN \n",
"0.00 NaN NaN \n",
"\n",
" Green Gold \\\n",
"Ranking \n",
"10.00 NaN NaN \n",
"9.00 NaN NaN \n",
"9.00 NaN Nicol Bolas, Dragon-God \n",
"9.00 NaN NaN \n",
"8.00 God-Eternal Rhonas Ajani, the Greathearted \n",
"7.00 NaN Roalesk, Apex Hybrid \n",
"6.50 NaN Storrev, Devkarin Lich \n",
"6.50 Nissa, Who Shakes the World Domri, Anarch of Bolas \n",
"6.50 Awakening of Vitu-Ghazi Ral, Storm Conduit \n",
"6.50 NaN Sorin, Vengeful Bloodlord \n",
"6.50 NaN Teferi, Time Raveler \n",
"6.50 NaN Casualties of War \n",
"6.50 NaN Niv-Mizzet Reborn \n",
"6.25 Vivien, Champion of the Wilds Living Twister \n",
"6.25 Planewide Celebration Oath of Kaya \n",
"6.25 NaN NaN \n",
"6.25 NaN Bioessence Hydra \n",
"5.80 NaN Saheeli, Sublime Artificer \n",
"5.70 Band Together Leyline Prowler \n",
"5.70 Arlinn, Voice of the Pack Merfolk Skydiver \n",
"5.60 NaN Heartwarming Redemption \n",
"5.60 NaN Domri's Ambush \n",
"5.50 NaN Pledge of Unity \n",
"5.50 NaN NaN \n",
"5.50 NaN Mayhem Devil \n",
"5.40 NaN Nahiri, Storm of Stone \n",
"5.40 Jiang Yanggu, Wildcrafter Vraska, Swarm's Eminence \n",
"5.40 Paradise Druid Solar Blaze \n",
"5.40 Bloom Hulk Tamiyo, Collector of Tales \n",
"5.40 New Horizons Hualti's Raptor \n",
"... ... ... \n",
"5.10 NaN NaN \n",
"5.00 NaN NaN \n",
"5.00 Wardscale Crocodile Ashiok, Dream Render \n",
"5.00 Vivien's Grizzly Huatli, the Sun's Heart \n",
"5.00 Giant Growth NaN \n",
"5.00 Kronch Wrangler NaN \n",
"5.00 Snarespinner NaN \n",
"4.90 Forced Landing NaN \n",
"4.90 NaN NaN \n",
"4.90 Arlinn's Wolf NaN \n",
"4.90 Return to Nature NaN \n",
"4.90 Kraul Stinger NaN \n",
"4.90 Thundering Ceratok Dovin's Veto \n",
"4.80 Finale of Devastation NaN \n",
"4.80 NaN NaN \n",
"4.80 Steady Aim NaN \n",
"4.80 Courage in Crisis NaN \n",
"4.70 NaN NaN \n",
"4.60 Bond of Flourishing NaN \n",
"4.50 Primordial Wurm Dovin, Hando of Control \n",
"4.50 Storm the Citadel NaN \n",
"4.40 Nissa's Triumph NaN \n",
"4.20 Arboreal Grazer Tezzeret, Master of the Bridge \n",
"4.00 NaN NaN \n",
"3.75 NaN NaN \n",
"3.50 NaN NaN \n",
"3.00 NaN NaN \n",
"2.00 NaN NaN \n",
"1.00 NaN NaN \n",
"0.00 NaN NaN \n",
"\n",
" Gold2 Colorless \\\n",
"Ranking \n",
"10.00 NaN NaN \n",
"9.00 NaN NaN \n",
"9.00 NaN NaN \n",
"9.00 NaN NaN \n",
"8.00 Tolsimir, Friend to Wolves Ugin, the Ineffable \n",
"7.00 Feather, the Redeemed NaN \n",
"6.50 Time Wipe NaN \n",
"6.50 Enter the God-Eternals NaN \n",
"6.50 Widespread Brutality NaN \n",
"6.50 NaN NaN \n",
"6.50 NaN NaN \n",
"6.50 NaN NaN \n",
"6.50 Kaya, Bane of the Dead NaN \n",
"6.25 Deathsprout NaN \n",
"6.25 Elite Guardmage NaN \n",
"6.25 Ral's Outburst NaN \n",
"6.25 Despark NaN \n",
"5.80 Soul Diviner NaN \n",
"5.70 Angrath, Captain of Chaos NaN \n",
"5.70 Invade the City NaN \n",
"5.60 Samut, Tyrant Smasher NaN \n",
"5.60 Tyrant's Scorn NaN \n",
"5.50 Gleaming Overseer NaN \n",
"5.50 NaN NaN \n",
"5.50 Angrath's Rampage NaN \n",
"5.40 Kiora, Behemoth Beckoner NaN \n",
"5.40 Role Reversal NaN \n",
"5.40 NaN NaN \n",
"5.40 Tenth District Legionnaire Mana Geode \n",
"5.40 NaN NaN \n",
"... ... ... \n",
"5.10 NaN NaN \n",
"5.00 NaN Prismite \n",
"5.00 NaN Ugin's Conjurant \n",
"5.00 NaN NaN \n",
"5.00 NaN NaN \n",
"5.00 NaN NaN \n",
"5.00 NaN NaN \n",
"4.90 NaN Saheeli's Silverwing \n",
"4.90 NaN NaN \n",
"4.90 NaN NaN \n",
"4.90 NaN NaN \n",
"4.90 NaN NaN \n",
"4.90 NaN NaN \n",
"4.80 NaN NaN \n",
"4.80 NaN God-Pharaoh's Statue \n",
"4.80 Neoform NaN \n",
"4.80 NaN NaN \n",
"4.70 NaN Karn, the Great Creator \n",
"4.60 NaN NaN \n",
"4.50 NaN NaN \n",
"4.50 NaN NaN \n",
"4.40 NaN NaN \n",
"4.20 NaN NaN \n",
"4.00 NaN NaN \n",
"3.75 NaN NaN \n",
"3.50 NaN NaN \n",
"3.00 NaN NaN \n",
"2.00 NaN NaN \n",
"1.00 NaN NaN \n",
"0.00 NaN NaN \n",
"\n",
" Lands \n",
"Ranking \n",
"10.00 NaN \n",
"9.00 NaN \n",
"9.00 NaN \n",
"9.00 NaN \n",
"8.00 NaN \n",
"7.00 NaN \n",
"6.50 NaN \n",
"6.50 NaN \n",
"6.50 NaN \n",
"6.50 NaN \n",
"6.50 NaN \n",
"6.50 NaN \n",
"6.50 NaN \n",
"6.25 NaN \n",
"6.25 NaN \n",
"6.25 NaN \n",
"6.25 NaN \n",
"5.80 NaN \n",
"5.70 NaN \n",
"5.70 NaN \n",
"5.60 NaN \n",
"5.60 NaN \n",
"5.50 NaN \n",
"5.50 NaN \n",
"5.50 NaN \n",
"5.40 NaN \n",
"5.40 NaN \n",
"5.40 Gateway Plaza \n",
"5.40 NaN \n",
"5.40 NaN \n",
"... ... \n",
"5.10 Mobilized District \n",
"5.00 NaN \n",
"5.00 NaN \n",
"5.00 NaN \n",
"5.00 NaN \n",
"5.00 NaN \n",
"5.00 NaN \n",
"4.90 NaN \n",
"4.90 NaN \n",
"4.90 NaN \n",
"4.90 NaN \n",
"4.90 NaN \n",
"4.90 Interplanar Beacon \n",
"4.80 NaN \n",
"4.80 NaN \n",
"4.80 NaN \n",
"4.80 NaN \n",
"4.70 NaN \n",
"4.60 NaN \n",
"4.50 NaN \n",
"4.50 NaN \n",
"4.40 NaN \n",
"4.20 NaN \n",
"4.00 NaN \n",
"3.75 NaN \n",
"3.50 NaN \n",
"3.00 NaN \n",
"2.00 NaN \n",
"1.00 Emergence Zone \n",
"0.00 NaN \n",
"\n",
"[69 rows x 9 columns]"
]
},
"execution_count": 8,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df_reset_index = df_dropped.set_index(\"Ranking\")\n",
"df_reset_index"
]
},
{
"cell_type": "code",
"execution_count": 9,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
" Ranking\n",
"White 10.00 NaN\n",
" 9.00 God-Eternal Oketra\n",
" 9.00 NaN\n",
" 9.00 NaN\n",
" 8.00 Finale of Glory\n",
" 7.00 NaN\n",
" 6.50 NaN\n",
" 6.50 Gideon Blackblade\n",
" 6.50 NaN\n",
" 6.50 NaN\n",
" 6.50 NaN\n",
" 6.50 NaN\n",
" 6.50 NaN\n",
" 6.25 Prison Realm\n",
" 6.25 NaN\n",
" 6.25 NaN\n",
" 6.25 Trusted Pegasus\n",
" 5.80 NaN\n",
" 5.70 Law-Rune Enforcer\n",
" 5.70 NaN\n",
" 5.60 NaN\n",
" 5.60 NaN\n",
" 5.50 Grateful Apparition\n",
" 5.50 Tomik, Distinguished Advokist\n",
" 5.50 Rising Populace\n",
" 5.40 Wanderer's Strike\n",
" 5.40 NaN\n",
" 5.40 NaN\n",
" 5.40 NaN\n",
" 5.40 NaN\n",
" ... \n",
"Lands 5.10 Mobilized District\n",
" 5.00 NaN\n",
" 5.00 NaN\n",
" 5.00 NaN\n",
" 5.00 NaN\n",
" 5.00 NaN\n",
" 5.00 NaN\n",
" 4.90 NaN\n",
" 4.90 NaN\n",
" 4.90 NaN\n",
" 4.90 NaN\n",
" 4.90 NaN\n",
" 4.90 Interplanar Beacon\n",
" 4.80 NaN\n",
" 4.80 NaN\n",
" 4.80 NaN\n",
" 4.80 NaN\n",
" 4.70 NaN\n",
" 4.60 NaN\n",
" 4.50 NaN\n",
" 4.50 NaN\n",
" 4.40 NaN\n",
" 4.20 NaN\n",
" 4.00 NaN\n",
" 3.75 NaN\n",
" 3.50 NaN\n",
" 3.00 NaN\n",
" 2.00 NaN\n",
" 1.00 Emergence Zone\n",
" 0.00 NaN\n",
"Length: 621, dtype: object"
]
},
"execution_count": 9,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df_unstacked = df_reset_index.unstack()\n",
"df_unstacked"
]
},
{
"cell_type": "code",
"execution_count": 10,
"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>level_0</th>\n",
" <th>Ranking</th>\n",
" <th>Name</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>White</td>\n",
" <td>10.00</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>White</td>\n",
" <td>9.00</td>\n",
" <td>God-Eternal Oketra</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>White</td>\n",
" <td>9.00</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>White</td>\n",
" <td>9.00</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>White</td>\n",
" <td>8.00</td>\n",
" <td>Finale of Glory</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>White</td>\n",
" <td>7.00</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>White</td>\n",
" <td>6.50</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>White</td>\n",
" <td>6.50</td>\n",
" <td>Gideon Blackblade</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>White</td>\n",
" <td>6.50</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>White</td>\n",
" <td>6.50</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>White</td>\n",
" <td>6.50</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>White</td>\n",
" <td>6.50</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>White</td>\n",
" <td>6.50</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>White</td>\n",
" <td>6.25</td>\n",
" <td>Prison Realm</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>White</td>\n",
" <td>6.25</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>White</td>\n",
" <td>6.25</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>White</td>\n",
" <td>6.25</td>\n",
" <td>Trusted Pegasus</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>White</td>\n",
" <td>5.80</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>White</td>\n",
" <td>5.70</td>\n",
" <td>Law-Rune Enforcer</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>White</td>\n",
" <td>5.70</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>White</td>\n",
" <td>5.60</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>White</td>\n",
" <td>5.60</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>White</td>\n",
" <td>5.50</td>\n",
" <td>Grateful Apparition</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>White</td>\n",
" <td>5.50</td>\n",
" <td>Tomik, Distinguished Advokist</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>White</td>\n",
" <td>5.50</td>\n",
" <td>Rising Populace</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td>White</td>\n",
" <td>5.40</td>\n",
" <td>Wanderer's Strike</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td>White</td>\n",
" <td>5.40</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td>White</td>\n",
" <td>5.40</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td>White</td>\n",
" <td>5.40</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td>White</td>\n",
" <td>5.40</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>591</th>\n",
" <td>Lands</td>\n",
" <td>5.10</td>\n",
" <td>Mobilized District</td>\n",
" </tr>\n",
" <tr>\n",
" <th>592</th>\n",
" <td>Lands</td>\n",
" <td>5.00</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>593</th>\n",
" <td>Lands</td>\n",
" <td>5.00</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>594</th>\n",
" <td>Lands</td>\n",
" <td>5.00</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>595</th>\n",
" <td>Lands</td>\n",
" <td>5.00</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>596</th>\n",
" <td>Lands</td>\n",
" <td>5.00</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>597</th>\n",
" <td>Lands</td>\n",
" <td>5.00</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>598</th>\n",
" <td>Lands</td>\n",
" <td>4.90</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>599</th>\n",
" <td>Lands</td>\n",
" <td>4.90</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>600</th>\n",
" <td>Lands</td>\n",
" <td>4.90</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>601</th>\n",
" <td>Lands</td>\n",
" <td>4.90</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>602</th>\n",
" <td>Lands</td>\n",
" <td>4.90</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>603</th>\n",
" <td>Lands</td>\n",
" <td>4.90</td>\n",
" <td>Interplanar Beacon</td>\n",
" </tr>\n",
" <tr>\n",
" <th>604</th>\n",
" <td>Lands</td>\n",
" <td>4.80</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>605</th>\n",
" <td>Lands</td>\n",
" <td>4.80</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>606</th>\n",
" <td>Lands</td>\n",
" <td>4.80</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>607</th>\n",
" <td>Lands</td>\n",
" <td>4.80</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>608</th>\n",
" <td>Lands</td>\n",
" <td>4.70</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>609</th>\n",
" <td>Lands</td>\n",
" <td>4.60</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>610</th>\n",
" <td>Lands</td>\n",
" <td>4.50</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>611</th>\n",
" <td>Lands</td>\n",
" <td>4.50</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>612</th>\n",
" <td>Lands</td>\n",
" <td>4.40</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>613</th>\n",
" <td>Lands</td>\n",
" <td>4.20</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>614</th>\n",
" <td>Lands</td>\n",
" <td>4.00</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>615</th>\n",
" <td>Lands</td>\n",
" <td>3.75</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>616</th>\n",
" <td>Lands</td>\n",
" <td>3.50</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>617</th>\n",
" <td>Lands</td>\n",
" <td>3.00</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>618</th>\n",
" <td>Lands</td>\n",
" <td>2.00</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>619</th>\n",
" <td>Lands</td>\n",
" <td>1.00</td>\n",
" <td>Emergence Zone</td>\n",
" </tr>\n",
" <tr>\n",
" <th>620</th>\n",
" <td>Lands</td>\n",
" <td>0.00</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>621 rows × 3 columns</p>\n",
"</div>"
],
"text/plain": [
" level_0 Ranking Name\n",
"0 White 10.00 NaN\n",
"1 White 9.00 God-Eternal Oketra\n",
"2 White 9.00 NaN\n",
"3 White 9.00 NaN\n",
"4 White 8.00 Finale of Glory\n",
"5 White 7.00 NaN\n",
"6 White 6.50 NaN\n",
"7 White 6.50 Gideon Blackblade\n",
"8 White 6.50 NaN\n",
"9 White 6.50 NaN\n",
"10 White 6.50 NaN\n",
"11 White 6.50 NaN\n",
"12 White 6.50 NaN\n",
"13 White 6.25 Prison Realm\n",
"14 White 6.25 NaN\n",
"15 White 6.25 NaN\n",
"16 White 6.25 Trusted Pegasus\n",
"17 White 5.80 NaN\n",
"18 White 5.70 Law-Rune Enforcer\n",
"19 White 5.70 NaN\n",
"20 White 5.60 NaN\n",
"21 White 5.60 NaN\n",
"22 White 5.50 Grateful Apparition\n",
"23 White 5.50 Tomik, Distinguished Advokist\n",
"24 White 5.50 Rising Populace\n",
"25 White 5.40 Wanderer's Strike\n",
"26 White 5.40 NaN\n",
"27 White 5.40 NaN\n",
"28 White 5.40 NaN\n",
"29 White 5.40 NaN\n",
".. ... ... ...\n",
"591 Lands 5.10 Mobilized District\n",
"592 Lands 5.00 NaN\n",
"593 Lands 5.00 NaN\n",
"594 Lands 5.00 NaN\n",
"595 Lands 5.00 NaN\n",
"596 Lands 5.00 NaN\n",
"597 Lands 5.00 NaN\n",
"598 Lands 4.90 NaN\n",
"599 Lands 4.90 NaN\n",
"600 Lands 4.90 NaN\n",
"601 Lands 4.90 NaN\n",
"602 Lands 4.90 NaN\n",
"603 Lands 4.90 Interplanar Beacon\n",
"604 Lands 4.80 NaN\n",
"605 Lands 4.80 NaN\n",
"606 Lands 4.80 NaN\n",
"607 Lands 4.80 NaN\n",
"608 Lands 4.70 NaN\n",
"609 Lands 4.60 NaN\n",
"610 Lands 4.50 NaN\n",
"611 Lands 4.50 NaN\n",
"612 Lands 4.40 NaN\n",
"613 Lands 4.20 NaN\n",
"614 Lands 4.00 NaN\n",
"615 Lands 3.75 NaN\n",
"616 Lands 3.50 NaN\n",
"617 Lands 3.00 NaN\n",
"618 Lands 2.00 NaN\n",
"619 Lands 1.00 Emergence Zone\n",
"620 Lands 0.00 NaN\n",
"\n",
"[621 rows x 3 columns]"
]
},
"execution_count": 10,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df_demote_index = df_unstacked.reset_index(name=\"Name\")\n",
"df_demote_index"
]
},
{
"cell_type": "code",
"execution_count": 11,
"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>level_0</th>\n",
" <th>Ranking</th>\n",
" <th>Name</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>White</td>\n",
" <td>9.00</td>\n",
" <td>God-Eternal Oketra</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>White</td>\n",
" <td>8.00</td>\n",
" <td>Finale of Glory</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>White</td>\n",
" <td>6.50</td>\n",
" <td>Gideon Blackblade</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>White</td>\n",
" <td>6.25</td>\n",
" <td>Prison Realm</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>White</td>\n",
" <td>6.25</td>\n",
" <td>Trusted Pegasus</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>White</td>\n",
" <td>5.70</td>\n",
" <td>Law-Rune Enforcer</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>White</td>\n",
" <td>5.50</td>\n",
" <td>Grateful Apparition</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>White</td>\n",
" <td>5.50</td>\n",
" <td>Tomik, Distinguished Advokist</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>White</td>\n",
" <td>5.50</td>\n",
" <td>Rising Populace</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td>White</td>\n",
" <td>5.40</td>\n",
" <td>Wanderer's Strike</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31</th>\n",
" <td>White</td>\n",
" <td>5.30</td>\n",
" <td>Parhelion II</td>\n",
" </tr>\n",
" <tr>\n",
" <th>32</th>\n",
" <td>White</td>\n",
" <td>5.30</td>\n",
" <td>Devine Arrow</td>\n",
" </tr>\n",
" <tr>\n",
" <th>33</th>\n",
" <td>White</td>\n",
" <td>5.30</td>\n",
" <td>Sunblade Angel</td>\n",
" </tr>\n",
" <tr>\n",
" <th>34</th>\n",
" <td>White</td>\n",
" <td>5.20</td>\n",
" <td>Teyo the Shieldmage</td>\n",
" </tr>\n",
" <tr>\n",
" <th>36</th>\n",
" <td>White</td>\n",
" <td>5.20</td>\n",
" <td>Ajani's Pridemate</td>\n",
" </tr>\n",
" <tr>\n",
" <th>37</th>\n",
" <td>White</td>\n",
" <td>5.20</td>\n",
" <td>War Screecher</td>\n",
" </tr>\n",
" <tr>\n",
" <th>40</th>\n",
" <td>White</td>\n",
" <td>5.00</td>\n",
" <td>Bond of Discipline</td>\n",
" </tr>\n",
" <tr>\n",
" <th>41</th>\n",
" <td>White</td>\n",
" <td>5.00</td>\n",
" <td>Battlefield Promotion</td>\n",
" </tr>\n",
" <tr>\n",
" <th>42</th>\n",
" <td>White</td>\n",
" <td>5.00</td>\n",
" <td>Defiant Strike</td>\n",
" </tr>\n",
" <tr>\n",
" <th>43</th>\n",
" <td>White</td>\n",
" <td>5.00</td>\n",
" <td>Enforcer Griffin</td>\n",
" </tr>\n",
" <tr>\n",
" <th>44</th>\n",
" <td>White</td>\n",
" <td>5.00</td>\n",
" <td>Martyr for the Cause</td>\n",
" </tr>\n",
" <tr>\n",
" <th>45</th>\n",
" <td>White</td>\n",
" <td>5.00</td>\n",
" <td>Rally of Wings</td>\n",
" </tr>\n",
" <tr>\n",
" <th>46</th>\n",
" <td>White</td>\n",
" <td>4.90</td>\n",
" <td>The Wanderer</td>\n",
" </tr>\n",
" <tr>\n",
" <th>47</th>\n",
" <td>White</td>\n",
" <td>4.90</td>\n",
" <td>Teyo's Lightshield</td>\n",
" </tr>\n",
" <tr>\n",
" <th>48</th>\n",
" <td>White</td>\n",
" <td>4.90</td>\n",
" <td>Pouncing Lynx</td>\n",
" </tr>\n",
" <tr>\n",
" <th>49</th>\n",
" <td>White</td>\n",
" <td>4.90</td>\n",
" <td>Gideon's Triumph</td>\n",
" </tr>\n",
" <tr>\n",
" <th>50</th>\n",
" <td>White</td>\n",
" <td>4.90</td>\n",
" <td>Topple the Statue</td>\n",
" </tr>\n",
" <tr>\n",
" <th>51</th>\n",
" <td>White</td>\n",
" <td>4.90</td>\n",
" <td>Ravnica at War</td>\n",
" </tr>\n",
" <tr>\n",
" <th>53</th>\n",
" <td>White</td>\n",
" <td>4.80</td>\n",
" <td>Makeshift Battalion</td>\n",
" </tr>\n",
" <tr>\n",
" <th>54</th>\n",
" <td>White</td>\n",
" <td>4.80</td>\n",
" <td>Baulwark Giant</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>429</th>\n",
" <td>Gold2</td>\n",
" <td>6.25</td>\n",
" <td>Ral's Outburst</td>\n",
" </tr>\n",
" <tr>\n",
" <th>430</th>\n",
" <td>Gold2</td>\n",
" <td>6.25</td>\n",
" <td>Despark</td>\n",
" </tr>\n",
" <tr>\n",
" <th>431</th>\n",
" <td>Gold2</td>\n",
" <td>5.80</td>\n",
" <td>Soul Diviner</td>\n",
" </tr>\n",
" <tr>\n",
" <th>432</th>\n",
" <td>Gold2</td>\n",
" <td>5.70</td>\n",
" <td>Angrath, Captain of Chaos</td>\n",
" </tr>\n",
" <tr>\n",
" <th>433</th>\n",
" <td>Gold2</td>\n",
" <td>5.70</td>\n",
" <td>Invade the City</td>\n",
" </tr>\n",
" <tr>\n",
" <th>434</th>\n",
" <td>Gold2</td>\n",
" <td>5.60</td>\n",
" <td>Samut, Tyrant Smasher</td>\n",
" </tr>\n",
" <tr>\n",
" <th>435</th>\n",
" <td>Gold2</td>\n",
" <td>5.60</td>\n",
" <td>Tyrant's Scorn</td>\n",
" </tr>\n",
" <tr>\n",
" <th>436</th>\n",
" <td>Gold2</td>\n",
" <td>5.50</td>\n",
" <td>Gleaming Overseer</td>\n",
" </tr>\n",
" <tr>\n",
" <th>438</th>\n",
" <td>Gold2</td>\n",
" <td>5.50</td>\n",
" <td>Angrath's Rampage</td>\n",
" </tr>\n",
" <tr>\n",
" <th>439</th>\n",
" <td>Gold2</td>\n",
" <td>5.40</td>\n",
" <td>Kiora, Behemoth Beckoner</td>\n",
" </tr>\n",
" <tr>\n",
" <th>440</th>\n",
" <td>Gold2</td>\n",
" <td>5.40</td>\n",
" <td>Role Reversal</td>\n",
" </tr>\n",
" <tr>\n",
" <th>442</th>\n",
" <td>Gold2</td>\n",
" <td>5.40</td>\n",
" <td>Tenth District Legionnaire</td>\n",
" </tr>\n",
" <tr>\n",
" <th>445</th>\n",
" <td>Gold2</td>\n",
" <td>5.30</td>\n",
" <td>Cruel Celebrant</td>\n",
" </tr>\n",
" <tr>\n",
" <th>468</th>\n",
" <td>Gold2</td>\n",
" <td>4.80</td>\n",
" <td>Neoform</td>\n",
" </tr>\n",
" <tr>\n",
" <th>487</th>\n",
" <td>Colorless</td>\n",
" <td>8.00</td>\n",
" <td>Ugin, the Ineffable</td>\n",
" </tr>\n",
" <tr>\n",
" <th>511</th>\n",
" <td>Colorless</td>\n",
" <td>5.40</td>\n",
" <td>Mana Geode</td>\n",
" </tr>\n",
" <tr>\n",
" <th>513</th>\n",
" <td>Colorless</td>\n",
" <td>5.40</td>\n",
" <td>Firemind Vessel</td>\n",
" </tr>\n",
" <tr>\n",
" <th>519</th>\n",
" <td>Colorless</td>\n",
" <td>5.20</td>\n",
" <td>Guild Globe</td>\n",
" </tr>\n",
" <tr>\n",
" <th>520</th>\n",
" <td>Colorless</td>\n",
" <td>5.20</td>\n",
" <td>Iron Bully</td>\n",
" </tr>\n",
" <tr>\n",
" <th>523</th>\n",
" <td>Colorless</td>\n",
" <td>5.00</td>\n",
" <td>Prismite</td>\n",
" </tr>\n",
" <tr>\n",
" <th>524</th>\n",
" <td>Colorless</td>\n",
" <td>5.00</td>\n",
" <td>Ugin's Conjurant</td>\n",
" </tr>\n",
" <tr>\n",
" <th>529</th>\n",
" <td>Colorless</td>\n",
" <td>4.90</td>\n",
" <td>Saheeli's Silverwing</td>\n",
" </tr>\n",
" <tr>\n",
" <th>536</th>\n",
" <td>Colorless</td>\n",
" <td>4.80</td>\n",
" <td>God-Pharaoh's Statue</td>\n",
" </tr>\n",
" <tr>\n",
" <th>539</th>\n",
" <td>Colorless</td>\n",
" <td>4.70</td>\n",
" <td>Karn, the Great Creator</td>\n",
" </tr>\n",
" <tr>\n",
" <th>579</th>\n",
" <td>Lands</td>\n",
" <td>5.40</td>\n",
" <td>Gateway Plaza</td>\n",
" </tr>\n",
" <tr>\n",
" <th>589</th>\n",
" <td>Lands</td>\n",
" <td>5.20</td>\n",
" <td>Karn's Bastion</td>\n",
" </tr>\n",
" <tr>\n",
" <th>590</th>\n",
" <td>Lands</td>\n",
" <td>5.10</td>\n",
" <td>Blast Zone</td>\n",
" </tr>\n",
" <tr>\n",
" <th>591</th>\n",
" <td>Lands</td>\n",
" <td>5.10</td>\n",
" <td>Mobilized District</td>\n",
" </tr>\n",
" <tr>\n",
" <th>603</th>\n",
" <td>Lands</td>\n",
" <td>4.90</td>\n",
" <td>Interplanar Beacon</td>\n",
" </tr>\n",
" <tr>\n",
" <th>619</th>\n",
" <td>Lands</td>\n",
" <td>1.00</td>\n",
" <td>Emergence Zone</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>249 rows × 3 columns</p>\n",
"</div>"
],
"text/plain": [
" level_0 Ranking Name\n",
"1 White 9.00 God-Eternal Oketra\n",
"4 White 8.00 Finale of Glory\n",
"7 White 6.50 Gideon Blackblade\n",
"13 White 6.25 Prison Realm\n",
"16 White 6.25 Trusted Pegasus\n",
"18 White 5.70 Law-Rune Enforcer\n",
"22 White 5.50 Grateful Apparition\n",
"23 White 5.50 Tomik, Distinguished Advokist\n",
"24 White 5.50 Rising Populace\n",
"25 White 5.40 Wanderer's Strike\n",
"31 White 5.30 Parhelion II\n",
"32 White 5.30 Devine Arrow\n",
"33 White 5.30 Sunblade Angel\n",
"34 White 5.20 Teyo the Shieldmage\n",
"36 White 5.20 Ajani's Pridemate\n",
"37 White 5.20 War Screecher\n",
"40 White 5.00 Bond of Discipline\n",
"41 White 5.00 Battlefield Promotion\n",
"42 White 5.00 Defiant Strike\n",
"43 White 5.00 Enforcer Griffin\n",
"44 White 5.00 Martyr for the Cause\n",
"45 White 5.00 Rally of Wings\n",
"46 White 4.90 The Wanderer\n",
"47 White 4.90 Teyo's Lightshield\n",
"48 White 4.90 Pouncing Lynx\n",
"49 White 4.90 Gideon's Triumph\n",
"50 White 4.90 Topple the Statue\n",
"51 White 4.90 Ravnica at War\n",
"53 White 4.80 Makeshift Battalion\n",
"54 White 4.80 Baulwark Giant\n",
".. ... ... ...\n",
"429 Gold2 6.25 Ral's Outburst\n",
"430 Gold2 6.25 Despark\n",
"431 Gold2 5.80 Soul Diviner\n",
"432 Gold2 5.70 Angrath, Captain of Chaos\n",
"433 Gold2 5.70 Invade the City\n",
"434 Gold2 5.60 Samut, Tyrant Smasher\n",
"435 Gold2 5.60 Tyrant's Scorn\n",
"436 Gold2 5.50 Gleaming Overseer\n",
"438 Gold2 5.50 Angrath's Rampage\n",
"439 Gold2 5.40 Kiora, Behemoth Beckoner\n",
"440 Gold2 5.40 Role Reversal\n",
"442 Gold2 5.40 Tenth District Legionnaire\n",
"445 Gold2 5.30 Cruel Celebrant\n",
"468 Gold2 4.80 Neoform\n",
"487 Colorless 8.00 Ugin, the Ineffable\n",
"511 Colorless 5.40 Mana Geode\n",
"513 Colorless 5.40 Firemind Vessel\n",
"519 Colorless 5.20 Guild Globe\n",
"520 Colorless 5.20 Iron Bully\n",
"523 Colorless 5.00 Prismite\n",
"524 Colorless 5.00 Ugin's Conjurant\n",
"529 Colorless 4.90 Saheeli's Silverwing\n",
"536 Colorless 4.80 God-Pharaoh's Statue\n",
"539 Colorless 4.70 Karn, the Great Creator\n",
"579 Lands 5.40 Gateway Plaza\n",
"589 Lands 5.20 Karn's Bastion\n",
"590 Lands 5.10 Blast Zone\n",
"591 Lands 5.10 Mobilized District\n",
"603 Lands 4.90 Interplanar Beacon\n",
"619 Lands 1.00 Emergence Zone\n",
"\n",
"[249 rows x 3 columns]"
]
},
"execution_count": 11,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df_filtered = df_demote_index.dropna()\n",
"df_filtered"
]
},
{
"cell_type": "code",
"execution_count": 12,
"metadata": {},
"outputs": [],
"source": [
"cards = []\n",
"for index, row in df_filtered.iterrows():\n",
" cards.append(Card(name=row[\"Name\"], rating=row[\"Ranking\"]))"
]
},
{
"cell_type": "code",
"execution_count": 13,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"[rating: 9.0, name: God-Eternal Oketra,\n",
" rating: 8.0, name: Finale of Glory,\n",
" rating: 6.5, name: Gideon Blackblade,\n",
" rating: 6.25, name: Prison Realm,\n",
" rating: 6.25, name: Trusted Pegasus,\n",
" rating: 5.7, name: Law-Rune Enforcer,\n",
" rating: 5.5, name: Grateful Apparition,\n",
" rating: 5.5, name: Tomik, Distinguished Advokist,\n",
" rating: 5.5, name: Rising Populace,\n",
" rating: 5.4, name: Wanderer's Strike,\n",
" rating: 5.3, name: Parhelion II,\n",
" rating: 5.3, name: Devine Arrow,\n",
" rating: 5.3, name: Sunblade Angel,\n",
" rating: 5.2, name: Teyo the Shieldmage,\n",
" rating: 5.2, name: Ajani's Pridemate,\n",
" rating: 5.2, name: War Screecher,\n",
" rating: 5.0, name: Bond of Discipline,\n",
" rating: 5.0, name: Battlefield Promotion,\n",
" rating: 5.0, name: Defiant Strike,\n",
" rating: 5.0, name: Enforcer Griffin,\n",
" rating: 5.0, name: Martyr for the Cause,\n",
" rating: 5.0, name: Rally of Wings,\n",
" rating: 4.9, name: The Wanderer,\n",
" rating: 4.9, name: Teyo's Lightshield,\n",
" rating: 4.9, name: Pouncing Lynx,\n",
" rating: 4.9, name: Gideon's Triumph,\n",
" rating: 4.9, name: Topple the Statue,\n",
" rating: 4.9, name: Ravnica at War,\n",
" rating: 4.8, name: Makeshift Battalion,\n",
" rating: 4.8, name: Baulwark Giant,\n",
" rating: 4.8, name: Loxodon Sergeant,\n",
" rating: 4.7, name: Ignite the Beacon,\n",
" rating: 4.5, name: Single Combat,\n",
" rating: 4.5, name: Gideon's Sacrifice,\n",
" rating: 4.4, name: Ironclad Krovod,\n",
" rating: 3.75, name: Charmed Stray,\n",
" rating: 9.0, name: God-Eternal Kefnet,\n",
" rating: 6.5, name: Commence the Endgame,\n",
" rating: 6.5, name: Jace Wielder of Mysteries,\n",
" rating: 6.5, name: Finale of Revelation,\n",
" rating: 6.25, name: Kasmina Enigmatic Mentor,\n",
" rating: 5.7, name: Tamiyo's Epiphany,\n",
" rating: 5.5, name: Aven Eternal,\n",
" rating: 5.5, name: Rescuer Sphinx,\n",
" rating: 5.4, name: Thunder Drake,\n",
" rating: 5.4, name: Callous Dismissal,\n",
" rating: 5.4, name: Eternal Skylord,\n",
" rating: 5.4, name: Angur of Bolas,\n",
" rating: 5.3, name: Erratic Visionary,\n",
" rating: 5.3, name: Fblthp, the Lost,\n",
" rating: 5.3, name: Contentious Plan,\n",
" rating: 5.2, name: Spark Double,\n",
" rating: 5.2, name: Flux Channeler,\n",
" rating: 5.1, name: Spellkeeper Weird,\n",
" rating: 5.0, name: No Escape,\n",
" rating: 5.0, name: Narset's Reversal,\n",
" rating: 5.0, name: Kasmina's Transmutation,\n",
" rating: 5.0, name: Narset, Parter of Veils,\n",
" rating: 5.0, name: Ashiok's Skulker,\n",
" rating: 4.9, name: Sky Theater Strix,\n",
" rating: 4.9, name: Jace's Triumph,\n",
" rating: 4.9, name: Silent Submersive,\n",
" rating: 4.9, name: Kiora's Dambreaker ,\n",
" rating: 4.9, name: Teferi's Time Twist,\n",
" rating: 4.8, name: Crush Dissent,\n",
" rating: 4.8, name: Relentless Advance,\n",
" rating: 4.8, name: Bond of Insight,\n",
" rating: 4.7, name: Stealth Mission,\n",
" rating: 4.6, name: Lazotep Plating,\n",
" rating: 4.5, name: Totally Lost,\n",
" rating: 4.5, name: Wall of Runes,\n",
" rating: 4.2, name: Naga Eternal,\n",
" rating: 9.0, name: Liana, Dreadhorde General,\n",
" rating: 9.0, name: God-Eternal Bontu,\n",
" rating: 9.0, name: Finale of Eternity,\n",
" rating: 6.25, name: Massacre Girl,\n",
" rating: 5.7, name: Ob Nixilis's Cruelty,\n",
" rating: 5.7, name: Dreadhorde Invasion,\n",
" rating: 5.6, name: Bleeding Edge,\n",
" rating: 5.6, name: Ob Nixlis, the Hate-Twisted,\n",
" rating: 5.5, name: Spark Harvest,\n",
" rating: 5.4, name: Command the Dreadhorde,\n",
" rating: 5.4, name: Eternal Taskmaster,\n",
" rating: 5.3, name: Vizier of the Scorpion,\n",
" rating: 5.3, name: The Elderspell,\n",
" rating: 5.2, name: Davriel, Rougue Shadowmage,\n",
" rating: 5.0, name: Lazotep Reaver,\n",
" rating: 5.0, name: Toll of the Invasion,\n",
" rating: 5.0, name: Herald of the Dreadhorde,\n",
" rating: 5.0, name: Spark Reaper,\n",
" rating: 5.0, name: Shriekdiver,\n",
" rating: 5.0, name: Dreadmalkin,\n",
" rating: 4.9, name: Sorin's Thirst,\n",
" rating: 4.9, name: Price of Betrayal,\n",
" rating: 4.9, name: Vraska's Finisher,\n",
" rating: 4.9, name: Aid the Fallen,\n",
" rating: 4.9, name: Unlikely Aid,\n",
" rating: 4.9, name: Deliver Unto Evil,\n",
" rating: 4.8, name: Duskmantle Operative,\n",
" rating: 4.8, name: Tithebearer Giant,\n",
" rating: 4.8, name: Bond of Revival,\n",
" rating: 4.8, name: Vampire Opportunist,\n",
" rating: 4.7, name: Lazotep Behemoth,\n",
" rating: 4.5, name: Liliana's Triumph,\n",
" rating: 4.5, name: Charity Extractor,\n",
" rating: 4.4, name: Davriel's Shadowfugue,\n",
" rating: 3.75, name: Banehound,\n",
" rating: 3.5, name: Kaya's Ghostform,\n",
" rating: 9.0, name: Illharg, the Raze-Boar,\n",
" rating: 8.0, name: Kenko, Tin Street Kingpin,\n",
" rating: 7.0, name: Neheb, Dreadhorde Champion,\n",
" rating: 6.5, name: Sarkhan the Masterless,\n",
" rating: 6.5, name: Chandra, Fire Artisan,\n",
" rating: 6.25, name: Jaya, Venerated Firemage,\n",
" rating: 5.7, name: Cyclops Electromancer,\n",
" rating: 5.6, name: Chandra's Triumph,\n",
" rating: 5.6, name: Tibalt, Rakish Instigator,\n",
" rating: 5.5, name: Jaya's Greeting,\n",
" rating: 5.5, name: Spellgorger Weird,\n",
" rating: 5.4, name: Mizzium Tank,\n",
" rating: 5.2, name: Turret Ogre,\n",
" rating: 5.2, name: Blindblast,\n",
" rating: 5.2, name: Dreadhorde Twins,\n",
" rating: 5.1, name: Chandra's Pyrohelix,\n",
" rating: 5.1, name: Raging Kronch,\n",
" rating: 5.0, name: Ahn-Crop Invader,\n",
" rating: 5.0, name: Tibalt's Rager,\n",
" rating: 5.0, name: Burning Prophet,\n",
" rating: 5.0, name: Honor the God-Pharaoh,\n",
" rating: 5.0, name: Chainwip Cyclops,\n",
" rating: 5.0, name: Dreadhorde Arcanist,\n",
" rating: 4.9, name: Bolt Bend,\n",
" rating: 4.9, name: Grim Intiate,\n",
" rating: 4.9, name: Nahiri's Stoneblades,\n",
" rating: 4.9, name: Sarkhan's Catharsis,\n",
" rating: 4.9, name: Heartfire,\n",
" rating: 4.8, name: Devouring Hellion,\n",
" rating: 4.8, name: Finale of Promise,\n",
" rating: 4.8, name: Invading Manticore,\n",
" rating: 4.7, name: Samut's Sprint,\n",
" rating: 4.6, name: Bond of Passion,\n",
" rating: 4.5, name: Goblin Assault Team,\n",
" rating: 4.5, name: Goblin Assailant,\n",
" rating: 3.0, name: Demolish,\n",
" rating: 8.0, name: God-Eternal Rhonas,\n",
" rating: 6.5, name: Nissa, Who Shakes the World,\n",
" rating: 6.5, name: Awakening of Vitu-Ghazi,\n",
" rating: 6.25, name: Vivien, Champion of the Wilds,\n",
" rating: 6.25, name: Planewide Celebration,\n",
" rating: 5.7, name: Band Together,\n",
" rating: 5.7, name: Arlinn, Voice of the Pack,\n",
" rating: 5.4, name: Jiang Yanggu, Wildcrafter,\n",
" rating: 5.4, name: Paradise Druid,\n",
" rating: 5.4, name: Bloom Hulk,\n",
" rating: 5.4, name: New Horizons,\n",
" rating: 5.4, name: Evolution Sage,\n",
" rating: 5.3, name: Centaur Nurturer,\n",
" rating: 5.2, name: Pollenbright Druid,\n",
" rating: 5.2, name: Mowa, Loyal Companion,\n",
" rating: 5.2, name: Vivien's Arkbow,\n",
" rating: 5.2, name: Challenger Troll,\n",
" rating: 5.0, name: Wardscale Crocodile,\n",
" rating: 5.0, name: Vivien's Grizzly,\n",
" rating: 5.0, name: Giant Growth,\n",
" rating: 5.0, name: Kronch Wrangler,\n",
" rating: 5.0, name: Snarespinner,\n",
" rating: 4.9, name: Forced Landing,\n",
" rating: 4.9, name: Arlinn's Wolf,\n",
" rating: 4.9, name: Return to Nature,\n",
" rating: 4.9, name: Kraul Stinger,\n",
" rating: 4.9, name: Thundering Ceratok,\n",
" rating: 4.8, name: Finale of Devastation,\n",
" rating: 4.8, name: Steady Aim,\n",
" rating: 4.8, name: Courage in Crisis,\n",
" rating: 4.6, name: Bond of Flourishing,\n",
" rating: 4.5, name: Primordial Wurm,\n",
" rating: 4.5, name: Storm the Citadel,\n",
" rating: 4.4, name: Nissa's Triumph,\n",
" rating: 4.2, name: Arboreal Grazer,\n",
" rating: 9.0, name: Nicol Bolas, Dragon-God,\n",
" rating: 8.0, name: Ajani, the Greathearted,\n",
" rating: 7.0, name: Roalesk, Apex Hybrid,\n",
" rating: 6.5, name: Storrev, Devkarin Lich,\n",
" rating: 6.5, name: Domri, Anarch of Bolas,\n",
" rating: 6.5, name: Ral, Storm Conduit,\n",
" rating: 6.5, name: Sorin, Vengeful Bloodlord,\n",
" rating: 6.5, name: Teferi, Time Raveler,\n",
" rating: 6.5, name: Casualties of War,\n",
" rating: 6.5, name: Niv-Mizzet Reborn,\n",
" rating: 6.25, name: Living Twister,\n",
" rating: 6.25, name: Oath of Kaya,\n",
" rating: 6.25, name: Bioessence Hydra,\n",
" rating: 5.8, name: Saheeli, Sublime Artificer,\n",
" rating: 5.7, name: Leyline Prowler,\n",
" rating: 5.7, name: Merfolk Skydiver,\n",
" rating: 5.6, name: Heartwarming Redemption,\n",
" rating: 5.6, name: Domri's Ambush,\n",
" rating: 5.5, name: Pledge of Unity,\n",
" rating: 5.5, name: Mayhem Devil,\n",
" rating: 5.4, name: Nahiri, Storm of Stone,\n",
" rating: 5.4, name: Vraska, Swarm's Eminence,\n",
" rating: 5.4, name: Solar Blaze,\n",
" rating: 5.4, name: Tamiyo, Collector of Tales,\n",
" rating: 5.4, name: Hualti's Raptor,\n",
" rating: 5.4, name: Rubblebelt Rioters,\n",
" rating: 5.3, name: Dreadhorde Butcher,\n",
" rating: 5.0, name: Ashiok, Dream Render,\n",
" rating: 5.0, name: Huatli, the Sun's Heart,\n",
" rating: 4.9, name: Dovin's Veto,\n",
" rating: 4.5, name: Dovin, Hando of Control,\n",
" rating: 4.2, name: Tezzeret, Master of the Bridge,\n",
" rating: 8.0, name: Tolsimir, Friend to Wolves,\n",
" rating: 7.0, name: Feather, the Redeemed,\n",
" rating: 6.5, name: Time Wipe,\n",
" rating: 6.5, name: Enter the God-Eternals,\n",
" rating: 6.5, name: Widespread Brutality,\n",
" rating: 6.5, name: Kaya, Bane of the Dead,\n",
" rating: 6.25, name: Deathsprout,\n",
" rating: 6.25, name: Elite Guardmage,\n",
" rating: 6.25, name: Ral's Outburst,\n",
" rating: 6.25, name: Despark,\n",
" rating: 5.8, name: Soul Diviner,\n",
" rating: 5.7, name: Angrath, Captain of Chaos,\n",
" rating: 5.7, name: Invade the City,\n",
" rating: 5.6, name: Samut, Tyrant Smasher,\n",
" rating: 5.6, name: Tyrant's Scorn,\n",
" rating: 5.5, name: Gleaming Overseer,\n",
" rating: 5.5, name: Angrath's Rampage,\n",
" rating: 5.4, name: Kiora, Behemoth Beckoner,\n",
" rating: 5.4, name: Role Reversal,\n",
" rating: 5.4, name: Tenth District Legionnaire,\n",
" rating: 5.3, name: Cruel Celebrant,\n",
" rating: 4.8, name: Neoform,\n",
" rating: 8.0, name: Ugin, the Ineffable,\n",
" rating: 5.4, name: Mana Geode,\n",
" rating: 5.4, name: Firemind Vessel,\n",
" rating: 5.2, name: Guild Globe,\n",
" rating: 5.2, name: Iron Bully,\n",
" rating: 5.0, name: Prismite,\n",
" rating: 5.0, name: Ugin's Conjurant,\n",
" rating: 4.9, name: Saheeli's Silverwing,\n",
" rating: 4.8, name: God-Pharaoh's Statue,\n",
" rating: 4.7, name: Karn, the Great Creator,\n",
" rating: 5.4, name: Gateway Plaza,\n",
" rating: 5.2, name: Karn's Bastion,\n",
" rating: 5.1, name: Blast Zone,\n",
" rating: 5.1, name: Mobilized District,\n",
" rating: 4.9, name: Interplanar Beacon,\n",
" rating: 1.0, name: Emergence Zone]"
]
},
"execution_count": 13,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"cards"
]
},
{
"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.2"
}
},
"nbformat": 4,
"nbformat_minor": 2
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment