DinoDataLab.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt\n",
    "\n",
    "dinos = pd.read_json(\"dino_hash.json\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "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>sha256</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Aachenosaurus</th>\n",
       "      <td>986d800628ddd3c618c4efa09e31a0dac113379cffd237...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Aardonyx</th>\n",
       "      <td>efb992d905e9c5d72ccc748803dac9b5983cfba7e101bf...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Abdallahsaurus</th>\n",
       "      <td>1f59e4db18ae3d34c6201b8694b3b3b3c17729ad6ccc9c...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Abelisaurus</th>\n",
       "      <td>d187f165c20c6d658a3f3a4ec9214fca9cdaf456c7a6f0...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Abrictosaurus</th>\n",
       "      <td>a7b2b5638ad7a94b45a40b4565acccb0691e0bd3db5fc8...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                           sha256\n",
       "Aachenosaurus   986d800628ddd3c618c4efa09e31a0dac113379cffd237...\n",
       "Aardonyx        efb992d905e9c5d72ccc748803dac9b5983cfba7e101bf...\n",
       "Abdallahsaurus  1f59e4db18ae3d34c6201b8694b3b3b3c17729ad6ccc9c...\n",
       "Abelisaurus     d187f165c20c6d658a3f3a4ec9214fca9cdaf456c7a6f0...\n",
       "Abrictosaurus   a7b2b5638ad7a94b45a40b4565acccb0691e0bd3db5fc8..."
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dinos.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "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>sha256</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Moabosaurus</th>\n",
       "      <td>ac3fb2382fcc80ba710c8ef5622a0a5107a20d9d0a0fe5...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mochlodon</th>\n",
       "      <td>8c50523a215283623278a95c24e59621cafb7d38b1ce31...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mohammadisaurus</th>\n",
       "      <td>570daefe4c3f5b98cb6d8d038730dedf0d81f11965072d...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mojoceratops</th>\n",
       "      <td>af84e7ce23d22a05fa3f091f5ec868857c026c4477fb0c...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mollusc</th>\n",
       "      <td>260f9022308318a9bcbaa848fb4fa81e6aa90b3c239045...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mongolosaurus</th>\n",
       "      <td>3b8301f977ee7c6f274c3d19b94b1a70f51ca78c958f2e...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Monkonosaurus</th>\n",
       "      <td>0cd7f663d622ebd3a7786fe4665fa30762af04a2ddd7d3...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Monoclonius</th>\n",
       "      <td>46e526931fa4b7cbc212e78b93ae7d55b4e5bd6663ec68...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Monolophosaurus</th>\n",
       "      <td>cf270f9583f8e2d01daf7d25d6ac0592d5dc605630edb6...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mononychus</th>\n",
       "      <td>30f6c752269f811eeffd7e495a4572dc83ef624f489704...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mononykus</th>\n",
       "      <td>abb17ca61ff339e9f020e7d41e14ddd1727b7808472178...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Montanoceratops</th>\n",
       "      <td>724c3d481433f2e0e9e487816ddadfa0c48afb406d68e2...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Morinosaurus</th>\n",
       "      <td>d34559476b9daeaffe8ccacc08a5a1794f9d2244770bbc...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Morosaurus</th>\n",
       "      <td>0692a0b8f3d71202a81e230d44cf1c0422f08007c93a0f...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Moshisaurus</th>\n",
       "      <td>b9552df547b59337dc8ecb48611782baaebc9f83aa1ad8...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mtapaiasaurus</th>\n",
       "      <td>afe4c2b017ed3996bf5f4f3b937f0ae22e649df2f62078...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mtotosaurus</th>\n",
       "      <td>61cfe000856807b74755e3427025cfe4273451ae6dafaf...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mussaurus</th>\n",
       "      <td>202baec3895818232e347b0f2677f5b2197be8602b0420...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Muttaburrasaurus</th>\n",
       "      <td>0d54c8cbce58279fdcc7607142496e328d688b1bb05535...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Muyelensaurus</th>\n",
       "      <td>6550539e24a9ccecabe477b16fc28c58ab9e992133794f...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mymoorapelta</th>\n",
       "      <td>5644e5d07e1e540c4781572e204fe5da1c94157ac53e32...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                             sha256\n",
       "Moabosaurus       ac3fb2382fcc80ba710c8ef5622a0a5107a20d9d0a0fe5...\n",
       "Mochlodon         8c50523a215283623278a95c24e59621cafb7d38b1ce31...\n",
       "Mohammadisaurus   570daefe4c3f5b98cb6d8d038730dedf0d81f11965072d...\n",
       "Mojoceratops      af84e7ce23d22a05fa3f091f5ec868857c026c4477fb0c...\n",
       "Mollusc           260f9022308318a9bcbaa848fb4fa81e6aa90b3c239045...\n",
       "Mongolosaurus     3b8301f977ee7c6f274c3d19b94b1a70f51ca78c958f2e...\n",
       "Monkonosaurus     0cd7f663d622ebd3a7786fe4665fa30762af04a2ddd7d3...\n",
       "Monoclonius       46e526931fa4b7cbc212e78b93ae7d55b4e5bd6663ec68...\n",
       "Monolophosaurus   cf270f9583f8e2d01daf7d25d6ac0592d5dc605630edb6...\n",
       "Mononychus        30f6c752269f811eeffd7e495a4572dc83ef624f489704...\n",
       "Mononykus         abb17ca61ff339e9f020e7d41e14ddd1727b7808472178...\n",
       "Montanoceratops   724c3d481433f2e0e9e487816ddadfa0c48afb406d68e2...\n",
       "Morinosaurus      d34559476b9daeaffe8ccacc08a5a1794f9d2244770bbc...\n",
       "Morosaurus        0692a0b8f3d71202a81e230d44cf1c0422f08007c93a0f...\n",
       "Moshisaurus       b9552df547b59337dc8ecb48611782baaebc9f83aa1ad8...\n",
       "Mtapaiasaurus     afe4c2b017ed3996bf5f4f3b937f0ae22e649df2f62078...\n",
       "Mtotosaurus       61cfe000856807b74755e3427025cfe4273451ae6dafaf...\n",
       "Mussaurus         202baec3895818232e347b0f2677f5b2197be8602b0420...\n",
       "Muttaburrasaurus  0d54c8cbce58279fdcc7607142496e328d688b1bb05535...\n",
       "Muyelensaurus     6550539e24a9ccecabe477b16fc28c58ab9e992133794f...\n",
       "Mymoorapelta      5644e5d07e1e540c4781572e204fe5da1c94157ac53e32..."
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dinos.loc[\"Mo\":\"N\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "sha256    object\n",
       "dtype: object"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dinos.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "True"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dinos.index.is_unique"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "code = dinos.loc['Mtapaiasaurus'][0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'afe4c2b017ed3996bf5f4f3b937f0ae22e649df2f620787e136ed6bd3ea32e2d'"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "code"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "64"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(code)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Index: 1449 entries, Aachenosaurus to Zupaysaurus\n",
      "Data columns (total 1 columns):\n",
      "sha256    1449 non-null object\n",
      "dtypes: object(1)\n",
      "memory usage: 62.6+ KB\n"
     ]
    }
   ],
   "source": [
    "dinos.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "79558933319102751775488401099621501352054498959766483830843801156598693572141"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "int(code, base=16)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "79558933319102751775488401099621501352054498959766483830843801156598693572141"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "0xafe4c2b017ed3996bf5f4f3b937f0ae22e649df2f620787e136ed6bd3ea32e2d"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### LAB\n",
    "\n",
    "Add a column to dinos that contains the decimal equivalent of the sha256 hash.  [Hint](https://stackoverflow.com/questions/12555323/adding-new-column-to-existing-dataframe-in-python-pandas)."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "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>sha256</th>\n",
       "      <th>Decimal</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Aachenosaurus</th>\n",
       "      <td>986d800628ddd3c618c4efa09e31a0dac113379cffd237...</td>\n",
       "      <td>6894502290431315022067358956182627531339279740...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Aardonyx</th>\n",
       "      <td>efb992d905e9c5d72ccc748803dac9b5983cfba7e101bf...</td>\n",
       "      <td>1084306510242824561324759833333105726121749006...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Abdallahsaurus</th>\n",
       "      <td>1f59e4db18ae3d34c6201b8694b3b3b3c17729ad6ccc9c...</td>\n",
       "      <td>1418052719984109540221646874510714834789312475...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Abelisaurus</th>\n",
       "      <td>d187f165c20c6d658a3f3a4ec9214fca9cdaf456c7a6f0...</td>\n",
       "      <td>9477357577190764385360184919234382318008492011...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Abrictosaurus</th>\n",
       "      <td>a7b2b5638ad7a94b45a40b4565acccb0691e0bd3db5fc8...</td>\n",
       "      <td>7585199639068134257420643095559770092125481753...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Abrosaurus</th>\n",
       "      <td>aeeab7541293f1cff181a1b097eb52e34e3edffb8e0da8...</td>\n",
       "      <td>7911714315281995834377376717114968921922305931...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Abydosaurus</th>\n",
       "      <td>597c6b22f5bd9e180eea771b05c45e8203c2c54b9ae90b...</td>\n",
       "      <td>4047567198932003709189829629191863771750773805...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Acanthopholis</th>\n",
       "      <td>f24fed14ee30e7746a40c0197528b7270a58711ac2c266...</td>\n",
       "      <td>1096009265534355244602537495296894988536680712...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Achelousaurus</th>\n",
       "      <td>5f2bd4bc7953216204592bdffd07990048c00399f899f4...</td>\n",
       "      <td>4304716329066825560115898044326888394670157146...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Achillesaurus</th>\n",
       "      <td>4747c387a97aa06cce0ce092ca7c847a2ac2d877d282a7...</td>\n",
       "      <td>3224100788898982606123222044717043958863151461...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Achillobator</th>\n",
       "      <td>e7268d8d264328ac9494d5c149a6a66175d5eeec2ac59f...</td>\n",
       "      <td>1045523851628129865020630627992092658466065877...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Acracanthus</th>\n",
       "      <td>ec148fd3893a4a413ec5d65306cad133dcfd3193bf819c...</td>\n",
       "      <td>1067821618596745362597423322465031543566440479...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Acristavus</th>\n",
       "      <td>45deda1a1775281b59e6fcbb457c03a52fff860d4cd2f0...</td>\n",
       "      <td>3160333188475877397363553015392885154738144315...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Acrocanthosaurus</th>\n",
       "      <td>df97fe604383342a81d5eb2fc5a30e809b89cdac31d44d...</td>\n",
       "      <td>1011343147796868031343275298584147410018705165...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Acrotholus</th>\n",
       "      <td>092d071a907ebc057293674fa8c8cf8c67260130146ddc...</td>\n",
       "      <td>4150372783564571202429385098430304819597938642...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Actiosaurus</th>\n",
       "      <td>742da9458f01b348b01b10f20739b6e39aa3a3fc11a101...</td>\n",
       "      <td>5254896682400321316773342845111196607313327287...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Adamantisaurus</th>\n",
       "      <td>5998723cd713f5bdae734eb4d675156986cbd841e1d864...</td>\n",
       "      <td>4052519271708771088249032087371150026066414795...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Adasaurus</th>\n",
       "      <td>2d77883495da22251d3d6dc28190a55b12ef42a7fee719...</td>\n",
       "      <td>2056527304215727174638061725911668631667389789...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Adeopapposaurus</th>\n",
       "      <td>277693a2af74b36f6def0ce7ffaafb5ac10e5404055389...</td>\n",
       "      <td>1784970799109323580425447733642350557181521606...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Aegyptosaurus</th>\n",
       "      <td>ed11f41584fb3f3ad4aa279e021775b2da56eb83edc691...</td>\n",
       "      <td>1072298661206074430034129775454102836835825064...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Aeolosaurus</th>\n",
       "      <td>f71128d404c1cc7afd943f3915a0f3b783cc14f201cf39...</td>\n",
       "      <td>1117515917860315688692512761613530617861680941...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Aepisaurus</th>\n",
       "      <td>549745663908373c762424df141339d640d970bc93b4b5...</td>\n",
       "      <td>3826155216419458165073065334565988435418616862...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Aerosteon</th>\n",
       "      <td>bb9f867a58e5312baed7e8f53bc53efaf9580274f3fffa...</td>\n",
       "      <td>8486435950085630687904729590684083244936895859...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Aetonyx</th>\n",
       "      <td>60e8a392607287450090d1398aa614f8476a0b73fa5684...</td>\n",
       "      <td>4383307091398599296402821602573832910657397504...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Afrovenator</th>\n",
       "      <td>d577b42bc19baa79439cafc18559ec848a11f79cbe4fbf...</td>\n",
       "      <td>9655413504295380698198011853623817054159544125...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Agathaumas</th>\n",
       "      <td>db41558168c8db257f58922e8ddec0e49ef155ad71a0be...</td>\n",
       "      <td>9917194903625363701173834988999972445085760466...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Aggiosaurus</th>\n",
       "      <td>f361eae2a0b93f85d93e6374f9fc5e5060258d5e1759f6...</td>\n",
       "      <td>1100850274895365047526815790347032476928411979...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Agilisaurus</th>\n",
       "      <td>b1f313d23b36d26e7cddf75ebd065bce6d1531519d1e18...</td>\n",
       "      <td>8048885483698466492701436266388516833661968834...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Agnosphitys</th>\n",
       "      <td>8989758a20e5b048f8fe033216fa8c66f99c8dc03dc3f0...</td>\n",
       "      <td>6220972953204183017150259865302426322383012942...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Agrosaurus</th>\n",
       "      <td>037827c40c51cea5d04aea093b1d0042fda38462dfd436...</td>\n",
       "      <td>1569234647077677915557742759564297100000340418...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Yezosaurus</th>\n",
       "      <td>f0df33d2e84955f8f73db8825ca96c01cdfd4babbc8f05...</td>\n",
       "      <td>1089494482305446196132760956050381769951059258...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Yibinosaurus</th>\n",
       "      <td>e7174d0e6fa7e270b5fdee0e1e1518f454900dd5907aca...</td>\n",
       "      <td>1045254373288911228333127201579213905302475127...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Yimenosaurus</th>\n",
       "      <td>4dd2e9c11f016365013bff4db5a1ddc5cc206ac58b4afa...</td>\n",
       "      <td>3520074053794873371414293200824852370752475298...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Yingshanosaurus</th>\n",
       "      <td>67c113890af980ef85635dc9e90b2d84feb37bd319e152...</td>\n",
       "      <td>4692935971542771136535804281589538189907284140...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Yinlong</th>\n",
       "      <td>f60de1d305b881097d7fbede81a16a3012ef33bfe68453...</td>\n",
       "      <td>1112934883454048872043179088864797440455568358...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Yixianosaurus</th>\n",
       "      <td>5065f959f803635f54d5b707a057956b4649810a84dbe9...</td>\n",
       "      <td>3636520040059837426143522238313743462432963609...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Yizhousaurus</th>\n",
       "      <td>8614a57ef8dbb5721b0b176ef73a4d13f5c2fd938d24bc...</td>\n",
       "      <td>6064640086276159551297687175331089828585935556...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Yuanmouraptor</th>\n",
       "      <td>dbbf70080ebd6787cf91a2684f6df9a53fd687d889308f...</td>\n",
       "      <td>9939475484193071288186780674278099293785094176...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Yuanmousaurus</th>\n",
       "      <td>8f584124795f418088c655ebaf38bfd5107b11a75f8f08...</td>\n",
       "      <td>6483666948596018604538530522818928042368695736...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Yubasaurus</th>\n",
       "      <td>747dd255d790e5b0875c543ccf171322d1d1f3940d1900...</td>\n",
       "      <td>5269059799978624178840769164411468389174646262...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Yueosaurus</th>\n",
       "      <td>a516f454b4f40317b119a392fa697b90c3cf65efe6d7ac...</td>\n",
       "      <td>7467217696146480872293403877028202934453134199...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Yunnanosaurus</th>\n",
       "      <td>c12c5db2c952c2fd43e748a0632344595ce859e21f0249...</td>\n",
       "      <td>8737476772990323694635673523383597447046022237...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Yunxiansaurus</th>\n",
       "      <td>08c65069d6eb07587f321dbbfc9bcbb476f9e2f3ec4674...</td>\n",
       "      <td>3968893500627910114048211855000853484035815972...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Yutyrannus</th>\n",
       "      <td>734f6da8ecc6374962b465ad3773dbb8c445f2ce430d98...</td>\n",
       "      <td>5215631534975120942933766312902106184378537114...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zalmoxes</th>\n",
       "      <td>e03010a7c4ecb91e3da98a6f7e5834ef560367b950b38f...</td>\n",
       "      <td>1014030016927522669159044089791166989715622066...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zanclodon</th>\n",
       "      <td>3c0859943a21db2ecde573ac42226f6a9be489e92f2085...</td>\n",
       "      <td>2715352394313322201810903911522463466731075545...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zapalasaurus</th>\n",
       "      <td>eab0a15c58db5d699b38dd96953ed35821de58ce1efe01...</td>\n",
       "      <td>1061532853227199803294793542933499905362287420...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zapsalis</th>\n",
       "      <td>a54e3b1f7c1179d8202d7ba4cd6c0dab18859c368855be...</td>\n",
       "      <td>7476984213915038874165530650053414539745609908...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zatomus</th>\n",
       "      <td>d083a73ac3c56cfdb35eff176932ce8e30627df7fe8ab2...</td>\n",
       "      <td>9431368364673931096434685289590675464870795276...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zephyrosaurus</th>\n",
       "      <td>15a24168c5405a625f3c4224dcc2930ebc880e825528e5...</td>\n",
       "      <td>9785250482862681961083046744599182949890360514...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zhejiangosaurus</th>\n",
       "      <td>243b6c9486339fa9c7992ee6175d22aa875db141598988...</td>\n",
       "      <td>1638825591863015861163469357575184161778418903...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zhongyuansaurus</th>\n",
       "      <td>c1e0693238304a0382c48f3d3a44cc6f604d1719a29043...</td>\n",
       "      <td>8769287955636187073618794662613137776834847667...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zhuchengceratops</th>\n",
       "      <td>00ade1605d501f61d2a79c50074de40b38d55ba3a06141...</td>\n",
       "      <td>3072200331165720577772253436954311096286676205...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zhuchengosaurus</th>\n",
       "      <td>d533147fd57f3ab253a82cd1c99b1b92cd26e66e222957...</td>\n",
       "      <td>9643288742986345808061336394004427232887909074...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zhuchengtyrannus</th>\n",
       "      <td>e2e96ff09821b33c507255ecbdebdfc79f2f0110653576...</td>\n",
       "      <td>1026351517261645929566252887803424951976051758...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zigongosaurus</th>\n",
       "      <td>8acff7697952e1eb9ae8efc2b3abd8bdec5a257d34a083...</td>\n",
       "      <td>6278661802181882764711290181973775397101364274...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zizhongosaurus</th>\n",
       "      <td>bd26005122ef0350719ba58e783a2006f6916338d02d9e...</td>\n",
       "      <td>8555427075813354818608307289614151634287821883...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zuniceratops</th>\n",
       "      <td>a207158a914fa78bff188af9164edcdc01fa4f037eb972...</td>\n",
       "      <td>7328719807239157651978677573390725647215758894...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zuolong</th>\n",
       "      <td>dc1921e1ddb07fa7f58c2023cb360c123bd3c1266f991e...</td>\n",
       "      <td>9955323171190213304257152273492793923932632434...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zupaysaurus</th>\n",
       "      <td>0ce18b6abf96c6e06939fe0899e50f6618767d8052c8b8...</td>\n",
       "      <td>5826256993247557452948070487564151831330643392...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1449 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                             sha256  \\\n",
       "Aachenosaurus     986d800628ddd3c618c4efa09e31a0dac113379cffd237...   \n",
       "Aardonyx          efb992d905e9c5d72ccc748803dac9b5983cfba7e101bf...   \n",
       "Abdallahsaurus    1f59e4db18ae3d34c6201b8694b3b3b3c17729ad6ccc9c...   \n",
       "Abelisaurus       d187f165c20c6d658a3f3a4ec9214fca9cdaf456c7a6f0...   \n",
       "Abrictosaurus     a7b2b5638ad7a94b45a40b4565acccb0691e0bd3db5fc8...   \n",
       "Abrosaurus        aeeab7541293f1cff181a1b097eb52e34e3edffb8e0da8...   \n",
       "Abydosaurus       597c6b22f5bd9e180eea771b05c45e8203c2c54b9ae90b...   \n",
       "Acanthopholis     f24fed14ee30e7746a40c0197528b7270a58711ac2c266...   \n",
       "Achelousaurus     5f2bd4bc7953216204592bdffd07990048c00399f899f4...   \n",
       "Achillesaurus     4747c387a97aa06cce0ce092ca7c847a2ac2d877d282a7...   \n",
       "Achillobator      e7268d8d264328ac9494d5c149a6a66175d5eeec2ac59f...   \n",
       "Acracanthus       ec148fd3893a4a413ec5d65306cad133dcfd3193bf819c...   \n",
       "Acristavus        45deda1a1775281b59e6fcbb457c03a52fff860d4cd2f0...   \n",
       "Acrocanthosaurus  df97fe604383342a81d5eb2fc5a30e809b89cdac31d44d...   \n",
       "Acrotholus        092d071a907ebc057293674fa8c8cf8c67260130146ddc...   \n",
       "Actiosaurus       742da9458f01b348b01b10f20739b6e39aa3a3fc11a101...   \n",
       "Adamantisaurus    5998723cd713f5bdae734eb4d675156986cbd841e1d864...   \n",
       "Adasaurus         2d77883495da22251d3d6dc28190a55b12ef42a7fee719...   \n",
       "Adeopapposaurus   277693a2af74b36f6def0ce7ffaafb5ac10e5404055389...   \n",
       "Aegyptosaurus     ed11f41584fb3f3ad4aa279e021775b2da56eb83edc691...   \n",
       "Aeolosaurus       f71128d404c1cc7afd943f3915a0f3b783cc14f201cf39...   \n",
       "Aepisaurus        549745663908373c762424df141339d640d970bc93b4b5...   \n",
       "Aerosteon         bb9f867a58e5312baed7e8f53bc53efaf9580274f3fffa...   \n",
       "Aetonyx           60e8a392607287450090d1398aa614f8476a0b73fa5684...   \n",
       "Afrovenator       d577b42bc19baa79439cafc18559ec848a11f79cbe4fbf...   \n",
       "Agathaumas        db41558168c8db257f58922e8ddec0e49ef155ad71a0be...   \n",
       "Aggiosaurus       f361eae2a0b93f85d93e6374f9fc5e5060258d5e1759f6...   \n",
       "Agilisaurus       b1f313d23b36d26e7cddf75ebd065bce6d1531519d1e18...   \n",
       "Agnosphitys       8989758a20e5b048f8fe033216fa8c66f99c8dc03dc3f0...   \n",
       "Agrosaurus        037827c40c51cea5d04aea093b1d0042fda38462dfd436...   \n",
       "...                                                             ...   \n",
       "Yezosaurus        f0df33d2e84955f8f73db8825ca96c01cdfd4babbc8f05...   \n",
       "Yibinosaurus      e7174d0e6fa7e270b5fdee0e1e1518f454900dd5907aca...   \n",
       "Yimenosaurus      4dd2e9c11f016365013bff4db5a1ddc5cc206ac58b4afa...   \n",
       "Yingshanosaurus   67c113890af980ef85635dc9e90b2d84feb37bd319e152...   \n",
       "Yinlong           f60de1d305b881097d7fbede81a16a3012ef33bfe68453...   \n",
       "Yixianosaurus     5065f959f803635f54d5b707a057956b4649810a84dbe9...   \n",
       "Yizhousaurus      8614a57ef8dbb5721b0b176ef73a4d13f5c2fd938d24bc...   \n",
       "Yuanmouraptor     dbbf70080ebd6787cf91a2684f6df9a53fd687d889308f...   \n",
       "Yuanmousaurus     8f584124795f418088c655ebaf38bfd5107b11a75f8f08...   \n",
       "Yubasaurus        747dd255d790e5b0875c543ccf171322d1d1f3940d1900...   \n",
       "Yueosaurus        a516f454b4f40317b119a392fa697b90c3cf65efe6d7ac...   \n",
       "Yunnanosaurus     c12c5db2c952c2fd43e748a0632344595ce859e21f0249...   \n",
       "Yunxiansaurus     08c65069d6eb07587f321dbbfc9bcbb476f9e2f3ec4674...   \n",
       "Yutyrannus        734f6da8ecc6374962b465ad3773dbb8c445f2ce430d98...   \n",
       "Zalmoxes          e03010a7c4ecb91e3da98a6f7e5834ef560367b950b38f...   \n",
       "Zanclodon         3c0859943a21db2ecde573ac42226f6a9be489e92f2085...   \n",
       "Zapalasaurus      eab0a15c58db5d699b38dd96953ed35821de58ce1efe01...   \n",
       "Zapsalis          a54e3b1f7c1179d8202d7ba4cd6c0dab18859c368855be...   \n",
       "Zatomus           d083a73ac3c56cfdb35eff176932ce8e30627df7fe8ab2...   \n",
       "Zephyrosaurus     15a24168c5405a625f3c4224dcc2930ebc880e825528e5...   \n",
       "Zhejiangosaurus   243b6c9486339fa9c7992ee6175d22aa875db141598988...   \n",
       "Zhongyuansaurus   c1e0693238304a0382c48f3d3a44cc6f604d1719a29043...   \n",
       "Zhuchengceratops  00ade1605d501f61d2a79c50074de40b38d55ba3a06141...   \n",
       "Zhuchengosaurus   d533147fd57f3ab253a82cd1c99b1b92cd26e66e222957...   \n",
       "Zhuchengtyrannus  e2e96ff09821b33c507255ecbdebdfc79f2f0110653576...   \n",
       "Zigongosaurus     8acff7697952e1eb9ae8efc2b3abd8bdec5a257d34a083...   \n",
       "Zizhongosaurus    bd26005122ef0350719ba58e783a2006f6916338d02d9e...   \n",
       "Zuniceratops      a207158a914fa78bff188af9164edcdc01fa4f037eb972...   \n",
       "Zuolong           dc1921e1ddb07fa7f58c2023cb360c123bd3c1266f991e...   \n",
       "Zupaysaurus       0ce18b6abf96c6e06939fe0899e50f6618767d8052c8b8...   \n",
       "\n",
       "                                                            Decimal  \n",
       "Aachenosaurus     6894502290431315022067358956182627531339279740...  \n",
       "Aardonyx          1084306510242824561324759833333105726121749006...  \n",
       "Abdallahsaurus    1418052719984109540221646874510714834789312475...  \n",
       "Abelisaurus       9477357577190764385360184919234382318008492011...  \n",
       "Abrictosaurus     7585199639068134257420643095559770092125481753...  \n",
       "Abrosaurus        7911714315281995834377376717114968921922305931...  \n",
       "Abydosaurus       4047567198932003709189829629191863771750773805...  \n",
       "Acanthopholis     1096009265534355244602537495296894988536680712...  \n",
       "Achelousaurus     4304716329066825560115898044326888394670157146...  \n",
       "Achillesaurus     3224100788898982606123222044717043958863151461...  \n",
       "Achillobator      1045523851628129865020630627992092658466065877...  \n",
       "Acracanthus       1067821618596745362597423322465031543566440479...  \n",
       "Acristavus        3160333188475877397363553015392885154738144315...  \n",
       "Acrocanthosaurus  1011343147796868031343275298584147410018705165...  \n",
       "Acrotholus        4150372783564571202429385098430304819597938642...  \n",
       "Actiosaurus       5254896682400321316773342845111196607313327287...  \n",
       "Adamantisaurus    4052519271708771088249032087371150026066414795...  \n",
       "Adasaurus         2056527304215727174638061725911668631667389789...  \n",
       "Adeopapposaurus   1784970799109323580425447733642350557181521606...  \n",
       "Aegyptosaurus     1072298661206074430034129775454102836835825064...  \n",
       "Aeolosaurus       1117515917860315688692512761613530617861680941...  \n",
       "Aepisaurus        3826155216419458165073065334565988435418616862...  \n",
       "Aerosteon         8486435950085630687904729590684083244936895859...  \n",
       "Aetonyx           4383307091398599296402821602573832910657397504...  \n",
       "Afrovenator       9655413504295380698198011853623817054159544125...  \n",
       "Agathaumas        9917194903625363701173834988999972445085760466...  \n",
       "Aggiosaurus       1100850274895365047526815790347032476928411979...  \n",
       "Agilisaurus       8048885483698466492701436266388516833661968834...  \n",
       "Agnosphitys       6220972953204183017150259865302426322383012942...  \n",
       "Agrosaurus        1569234647077677915557742759564297100000340418...  \n",
       "...                                                             ...  \n",
       "Yezosaurus        1089494482305446196132760956050381769951059258...  \n",
       "Yibinosaurus      1045254373288911228333127201579213905302475127...  \n",
       "Yimenosaurus      3520074053794873371414293200824852370752475298...  \n",
       "Yingshanosaurus   4692935971542771136535804281589538189907284140...  \n",
       "Yinlong           1112934883454048872043179088864797440455568358...  \n",
       "Yixianosaurus     3636520040059837426143522238313743462432963609...  \n",
       "Yizhousaurus      6064640086276159551297687175331089828585935556...  \n",
       "Yuanmouraptor     9939475484193071288186780674278099293785094176...  \n",
       "Yuanmousaurus     6483666948596018604538530522818928042368695736...  \n",
       "Yubasaurus        5269059799978624178840769164411468389174646262...  \n",
       "Yueosaurus        7467217696146480872293403877028202934453134199...  \n",
       "Yunnanosaurus     8737476772990323694635673523383597447046022237...  \n",
       "Yunxiansaurus     3968893500627910114048211855000853484035815972...  \n",
       "Yutyrannus        5215631534975120942933766312902106184378537114...  \n",
       "Zalmoxes          1014030016927522669159044089791166989715622066...  \n",
       "Zanclodon         2715352394313322201810903911522463466731075545...  \n",
       "Zapalasaurus      1061532853227199803294793542933499905362287420...  \n",
       "Zapsalis          7476984213915038874165530650053414539745609908...  \n",
       "Zatomus           9431368364673931096434685289590675464870795276...  \n",
       "Zephyrosaurus     9785250482862681961083046744599182949890360514...  \n",
       "Zhejiangosaurus   1638825591863015861163469357575184161778418903...  \n",
       "Zhongyuansaurus   8769287955636187073618794662613137776834847667...  \n",
       "Zhuchengceratops  3072200331165720577772253436954311096286676205...  \n",
       "Zhuchengosaurus   9643288742986345808061336394004427232887909074...  \n",
       "Zhuchengtyrannus  1026351517261645929566252887803424951976051758...  \n",
       "Zigongosaurus     6278661802181882764711290181973775397101364274...  \n",
       "Zizhongosaurus    8555427075813354818608307289614151634287821883...  \n",
       "Zuniceratops      7328719807239157651978677573390725647215758894...  \n",
       "Zuolong           9955323171190213304257152273492793923932632434...  \n",
       "Zupaysaurus       5826256993247557452948070487564151831330643392...  \n",
       "\n",
       "[1449 rows x 2 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dinos.assign(Decimal = dinos.sha256.apply(lambda x: int(x, base=16)))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "#### LAB\n",
    "\n",
    "Sort ```dinos``` by the column ```sha256``` -- this will be an alphabetical sort.  "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "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>sha256</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Protoceratops</th>\n",
       "      <td>001f5f55f762964016733ec2d9c0e3322e18c7533a331a...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Pellegrinisaurus</th>\n",
       "      <td>003d42e5e023c4b09009e7e5bd4b793cf5cd634a67c85a...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Shixinggia</th>\n",
       "      <td>006d15f1daa8904ee8e46a608b4d0aeaa779895d0613ef...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Lurdusaurus</th>\n",
       "      <td>00953f91c34086eb4b503010dcfb83460013bd1cbb792f...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kryptops</th>\n",
       "      <td>00a9babe086ea3ac6a652dc1c3334fc9bc485cc6d1f9db...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zhuchengceratops</th>\n",
       "      <td>00ade1605d501f61d2a79c50074de40b38d55ba3a06141...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Lapampasaurus</th>\n",
       "      <td>00baa9900d4f8f715f181ce732b7488ddeb0709556c5e8...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tylocephale</th>\n",
       "      <td>00dad483f84b437d6e320eabb28e3b4e8f8e7525fff33a...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Gilmoreosaurus</th>\n",
       "      <td>01140e7356306eec7a90f4ba669feca7fb386af59fcb89...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Orodromeus</th>\n",
       "      <td>014f16f3abeeb6b3cf4b9dcaadfd357bfb697e93ae0e49...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                             sha256\n",
       "Protoceratops     001f5f55f762964016733ec2d9c0e3322e18c7533a331a...\n",
       "Pellegrinisaurus  003d42e5e023c4b09009e7e5bd4b793cf5cd634a67c85a...\n",
       "Shixinggia        006d15f1daa8904ee8e46a608b4d0aeaa779895d0613ef...\n",
       "Lurdusaurus       00953f91c34086eb4b503010dcfb83460013bd1cbb792f...\n",
       "Kryptops          00a9babe086ea3ac6a652dc1c3334fc9bc485cc6d1f9db...\n",
       "Zhuchengceratops  00ade1605d501f61d2a79c50074de40b38d55ba3a06141...\n",
       "Lapampasaurus     00baa9900d4f8f715f181ce732b7488ddeb0709556c5e8...\n",
       "Tylocephale       00dad483f84b437d6e320eabb28e3b4e8f8e7525fff33a...\n",
       "Gilmoreosaurus    01140e7356306eec7a90f4ba669feca7fb386af59fcb89...\n",
       "Orodromeus        014f16f3abeeb6b3cf4b9dcaadfd357bfb697e93ae0e49..."
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dinos.sort_values(by='sha256').head(10)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "How about in descending order?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "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>sha256</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Avalonianus</th>\n",
       "      <td>ffad0cfe78a1db7e3801f44a02307f1a4c23fcf7188bc2...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Platyceratops</th>\n",
       "      <td>ff9a4f20e25679ab5e3f64fa69f5b25345d931a5fd847b...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Prenocephale</th>\n",
       "      <td>fef1c818898fa33532cd527822e92e410fbf17483cb8c2...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Lourinhasaurus</th>\n",
       "      <td>fee621f912181ce090a23cc321ac7487f06a1818f223e1...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Cryptodraco</th>\n",
       "      <td>fee506e91a222211e23c19d98dd62f35a64460033c8c79...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kentrosaurus</th>\n",
       "      <td>feb25f28e47006a524509a5bbfe7f06ffde1d513f9f2fb...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Gasparinisaura</th>\n",
       "      <td>fe7d197b0f2baf237eb567d10c48f11041884f5a8834ca...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Palaeosauriscus</th>\n",
       "      <td>fe7ae756a5f48f4fdd196ea85cae80b28d0690ca3c32e4...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Pantydraco</th>\n",
       "      <td>fe3bfa57375ccec196c5732c31d047dbb9878d8d5f40c2...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Australovenator</th>\n",
       "      <td>fe1f43bfa5f74884c60cf592159ad0acdb0a91b8713569...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                            sha256\n",
       "Avalonianus      ffad0cfe78a1db7e3801f44a02307f1a4c23fcf7188bc2...\n",
       "Platyceratops    ff9a4f20e25679ab5e3f64fa69f5b25345d931a5fd847b...\n",
       "Prenocephale     fef1c818898fa33532cd527822e92e410fbf17483cb8c2...\n",
       "Lourinhasaurus   fee621f912181ce090a23cc321ac7487f06a1818f223e1...\n",
       "Cryptodraco      fee506e91a222211e23c19d98dd62f35a64460033c8c79...\n",
       "Kentrosaurus     feb25f28e47006a524509a5bbfe7f06ffde1d513f9f2fb...\n",
       "Gasparinisaura   fe7d197b0f2baf237eb567d10c48f11041884f5a8834ca...\n",
       "Palaeosauriscus  fe7ae756a5f48f4fdd196ea85cae80b28d0690ca3c32e4...\n",
       "Pantydraco       fe3bfa57375ccec196c5732c31d047dbb9878d8d5f40c2...\n",
       "Australovenator  fe1f43bfa5f74884c60cf592159ad0acdb0a91b8713569..."
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dinos.sort_values(by='sha256', ascending=False).head(10)"
   ]
  }
 ],
 "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.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}