{ "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": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
sha256
Aachenosaurus986d800628ddd3c618c4efa09e31a0dac113379cffd237...
Aardonyxefb992d905e9c5d72ccc748803dac9b5983cfba7e101bf...
Abdallahsaurus1f59e4db18ae3d34c6201b8694b3b3b3c17729ad6ccc9c...
Abelisaurusd187f165c20c6d658a3f3a4ec9214fca9cdaf456c7a6f0...
Abrictosaurusa7b2b5638ad7a94b45a40b4565acccb0691e0bd3db5fc8...
\n", "
" ], "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": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
sha256
Moabosaurusac3fb2382fcc80ba710c8ef5622a0a5107a20d9d0a0fe5...
Mochlodon8c50523a215283623278a95c24e59621cafb7d38b1ce31...
Mohammadisaurus570daefe4c3f5b98cb6d8d038730dedf0d81f11965072d...
Mojoceratopsaf84e7ce23d22a05fa3f091f5ec868857c026c4477fb0c...
Mollusc260f9022308318a9bcbaa848fb4fa81e6aa90b3c239045...
Mongolosaurus3b8301f977ee7c6f274c3d19b94b1a70f51ca78c958f2e...
Monkonosaurus0cd7f663d622ebd3a7786fe4665fa30762af04a2ddd7d3...
Monoclonius46e526931fa4b7cbc212e78b93ae7d55b4e5bd6663ec68...
Monolophosauruscf270f9583f8e2d01daf7d25d6ac0592d5dc605630edb6...
Mononychus30f6c752269f811eeffd7e495a4572dc83ef624f489704...
Mononykusabb17ca61ff339e9f020e7d41e14ddd1727b7808472178...
Montanoceratops724c3d481433f2e0e9e487816ddadfa0c48afb406d68e2...
Morinosaurusd34559476b9daeaffe8ccacc08a5a1794f9d2244770bbc...
Morosaurus0692a0b8f3d71202a81e230d44cf1c0422f08007c93a0f...
Moshisaurusb9552df547b59337dc8ecb48611782baaebc9f83aa1ad8...
Mtapaiasaurusafe4c2b017ed3996bf5f4f3b937f0ae22e649df2f62078...
Mtotosaurus61cfe000856807b74755e3427025cfe4273451ae6dafaf...
Mussaurus202baec3895818232e347b0f2677f5b2197be8602b0420...
Muttaburrasaurus0d54c8cbce58279fdcc7607142496e328d688b1bb05535...
Muyelensaurus6550539e24a9ccecabe477b16fc28c58ab9e992133794f...
Mymoorapelta5644e5d07e1e540c4781572e204fe5da1c94157ac53e32...
\n", "
" ], "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": [ "\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": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
sha256Decimal
Aachenosaurus986d800628ddd3c618c4efa09e31a0dac113379cffd237...6894502290431315022067358956182627531339279740...
Aardonyxefb992d905e9c5d72ccc748803dac9b5983cfba7e101bf...1084306510242824561324759833333105726121749006...
Abdallahsaurus1f59e4db18ae3d34c6201b8694b3b3b3c17729ad6ccc9c...1418052719984109540221646874510714834789312475...
Abelisaurusd187f165c20c6d658a3f3a4ec9214fca9cdaf456c7a6f0...9477357577190764385360184919234382318008492011...
Abrictosaurusa7b2b5638ad7a94b45a40b4565acccb0691e0bd3db5fc8...7585199639068134257420643095559770092125481753...
Abrosaurusaeeab7541293f1cff181a1b097eb52e34e3edffb8e0da8...7911714315281995834377376717114968921922305931...
Abydosaurus597c6b22f5bd9e180eea771b05c45e8203c2c54b9ae90b...4047567198932003709189829629191863771750773805...
Acanthopholisf24fed14ee30e7746a40c0197528b7270a58711ac2c266...1096009265534355244602537495296894988536680712...
Achelousaurus5f2bd4bc7953216204592bdffd07990048c00399f899f4...4304716329066825560115898044326888394670157146...
Achillesaurus4747c387a97aa06cce0ce092ca7c847a2ac2d877d282a7...3224100788898982606123222044717043958863151461...
Achillobatore7268d8d264328ac9494d5c149a6a66175d5eeec2ac59f...1045523851628129865020630627992092658466065877...
Acracanthusec148fd3893a4a413ec5d65306cad133dcfd3193bf819c...1067821618596745362597423322465031543566440479...
Acristavus45deda1a1775281b59e6fcbb457c03a52fff860d4cd2f0...3160333188475877397363553015392885154738144315...
Acrocanthosaurusdf97fe604383342a81d5eb2fc5a30e809b89cdac31d44d...1011343147796868031343275298584147410018705165...
Acrotholus092d071a907ebc057293674fa8c8cf8c67260130146ddc...4150372783564571202429385098430304819597938642...
Actiosaurus742da9458f01b348b01b10f20739b6e39aa3a3fc11a101...5254896682400321316773342845111196607313327287...
Adamantisaurus5998723cd713f5bdae734eb4d675156986cbd841e1d864...4052519271708771088249032087371150026066414795...
Adasaurus2d77883495da22251d3d6dc28190a55b12ef42a7fee719...2056527304215727174638061725911668631667389789...
Adeopapposaurus277693a2af74b36f6def0ce7ffaafb5ac10e5404055389...1784970799109323580425447733642350557181521606...
Aegyptosaurused11f41584fb3f3ad4aa279e021775b2da56eb83edc691...1072298661206074430034129775454102836835825064...
Aeolosaurusf71128d404c1cc7afd943f3915a0f3b783cc14f201cf39...1117515917860315688692512761613530617861680941...
Aepisaurus549745663908373c762424df141339d640d970bc93b4b5...3826155216419458165073065334565988435418616862...
Aerosteonbb9f867a58e5312baed7e8f53bc53efaf9580274f3fffa...8486435950085630687904729590684083244936895859...
Aetonyx60e8a392607287450090d1398aa614f8476a0b73fa5684...4383307091398599296402821602573832910657397504...
Afrovenatord577b42bc19baa79439cafc18559ec848a11f79cbe4fbf...9655413504295380698198011853623817054159544125...
Agathaumasdb41558168c8db257f58922e8ddec0e49ef155ad71a0be...9917194903625363701173834988999972445085760466...
Aggiosaurusf361eae2a0b93f85d93e6374f9fc5e5060258d5e1759f6...1100850274895365047526815790347032476928411979...
Agilisaurusb1f313d23b36d26e7cddf75ebd065bce6d1531519d1e18...8048885483698466492701436266388516833661968834...
Agnosphitys8989758a20e5b048f8fe033216fa8c66f99c8dc03dc3f0...6220972953204183017150259865302426322383012942...
Agrosaurus037827c40c51cea5d04aea093b1d0042fda38462dfd436...1569234647077677915557742759564297100000340418...
.........
Yezosaurusf0df33d2e84955f8f73db8825ca96c01cdfd4babbc8f05...1089494482305446196132760956050381769951059258...
Yibinosauruse7174d0e6fa7e270b5fdee0e1e1518f454900dd5907aca...1045254373288911228333127201579213905302475127...
Yimenosaurus4dd2e9c11f016365013bff4db5a1ddc5cc206ac58b4afa...3520074053794873371414293200824852370752475298...
Yingshanosaurus67c113890af980ef85635dc9e90b2d84feb37bd319e152...4692935971542771136535804281589538189907284140...
Yinlongf60de1d305b881097d7fbede81a16a3012ef33bfe68453...1112934883454048872043179088864797440455568358...
Yixianosaurus5065f959f803635f54d5b707a057956b4649810a84dbe9...3636520040059837426143522238313743462432963609...
Yizhousaurus8614a57ef8dbb5721b0b176ef73a4d13f5c2fd938d24bc...6064640086276159551297687175331089828585935556...
Yuanmouraptordbbf70080ebd6787cf91a2684f6df9a53fd687d889308f...9939475484193071288186780674278099293785094176...
Yuanmousaurus8f584124795f418088c655ebaf38bfd5107b11a75f8f08...6483666948596018604538530522818928042368695736...
Yubasaurus747dd255d790e5b0875c543ccf171322d1d1f3940d1900...5269059799978624178840769164411468389174646262...
Yueosaurusa516f454b4f40317b119a392fa697b90c3cf65efe6d7ac...7467217696146480872293403877028202934453134199...
Yunnanosaurusc12c5db2c952c2fd43e748a0632344595ce859e21f0249...8737476772990323694635673523383597447046022237...
Yunxiansaurus08c65069d6eb07587f321dbbfc9bcbb476f9e2f3ec4674...3968893500627910114048211855000853484035815972...
Yutyrannus734f6da8ecc6374962b465ad3773dbb8c445f2ce430d98...5215631534975120942933766312902106184378537114...
Zalmoxese03010a7c4ecb91e3da98a6f7e5834ef560367b950b38f...1014030016927522669159044089791166989715622066...
Zanclodon3c0859943a21db2ecde573ac42226f6a9be489e92f2085...2715352394313322201810903911522463466731075545...
Zapalasauruseab0a15c58db5d699b38dd96953ed35821de58ce1efe01...1061532853227199803294793542933499905362287420...
Zapsalisa54e3b1f7c1179d8202d7ba4cd6c0dab18859c368855be...7476984213915038874165530650053414539745609908...
Zatomusd083a73ac3c56cfdb35eff176932ce8e30627df7fe8ab2...9431368364673931096434685289590675464870795276...
Zephyrosaurus15a24168c5405a625f3c4224dcc2930ebc880e825528e5...9785250482862681961083046744599182949890360514...
Zhejiangosaurus243b6c9486339fa9c7992ee6175d22aa875db141598988...1638825591863015861163469357575184161778418903...
Zhongyuansaurusc1e0693238304a0382c48f3d3a44cc6f604d1719a29043...8769287955636187073618794662613137776834847667...
Zhuchengceratops00ade1605d501f61d2a79c50074de40b38d55ba3a06141...3072200331165720577772253436954311096286676205...
Zhuchengosaurusd533147fd57f3ab253a82cd1c99b1b92cd26e66e222957...9643288742986345808061336394004427232887909074...
Zhuchengtyrannuse2e96ff09821b33c507255ecbdebdfc79f2f0110653576...1026351517261645929566252887803424951976051758...
Zigongosaurus8acff7697952e1eb9ae8efc2b3abd8bdec5a257d34a083...6278661802181882764711290181973775397101364274...
Zizhongosaurusbd26005122ef0350719ba58e783a2006f6916338d02d9e...8555427075813354818608307289614151634287821883...
Zuniceratopsa207158a914fa78bff188af9164edcdc01fa4f037eb972...7328719807239157651978677573390725647215758894...
Zuolongdc1921e1ddb07fa7f58c2023cb360c123bd3c1266f991e...9955323171190213304257152273492793923932632434...
Zupaysaurus0ce18b6abf96c6e06939fe0899e50f6618767d8052c8b8...5826256993247557452948070487564151831330643392...
\n", "

1449 rows × 2 columns

\n", "
" ], "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": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
sha256
Protoceratops001f5f55f762964016733ec2d9c0e3322e18c7533a331a...
Pellegrinisaurus003d42e5e023c4b09009e7e5bd4b793cf5cd634a67c85a...
Shixinggia006d15f1daa8904ee8e46a608b4d0aeaa779895d0613ef...
Lurdusaurus00953f91c34086eb4b503010dcfb83460013bd1cbb792f...
Kryptops00a9babe086ea3ac6a652dc1c3334fc9bc485cc6d1f9db...
Zhuchengceratops00ade1605d501f61d2a79c50074de40b38d55ba3a06141...
Lapampasaurus00baa9900d4f8f715f181ce732b7488ddeb0709556c5e8...
Tylocephale00dad483f84b437d6e320eabb28e3b4e8f8e7525fff33a...
Gilmoreosaurus01140e7356306eec7a90f4ba669feca7fb386af59fcb89...
Orodromeus014f16f3abeeb6b3cf4b9dcaadfd357bfb697e93ae0e49...
\n", "
" ], "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": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
sha256
Avalonianusffad0cfe78a1db7e3801f44a02307f1a4c23fcf7188bc2...
Platyceratopsff9a4f20e25679ab5e3f64fa69f5b25345d931a5fd847b...
Prenocephalefef1c818898fa33532cd527822e92e410fbf17483cb8c2...
Lourinhasaurusfee621f912181ce090a23cc321ac7487f06a1818f223e1...
Cryptodracofee506e91a222211e23c19d98dd62f35a64460033c8c79...
Kentrosaurusfeb25f28e47006a524509a5bbfe7f06ffde1d513f9f2fb...
Gasparinisaurafe7d197b0f2baf237eb567d10c48f11041884f5a8834ca...
Palaeosauriscusfe7ae756a5f48f4fdd196ea85cae80b28d0690ca3c32e4...
Pantydracofe3bfa57375ccec196c5732c31d047dbb9878d8d5f40c2...
Australovenatorfe1f43bfa5f74884c60cf592159ad0acdb0a91b8713569...
\n", "
" ], "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 }