{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "## Playing with Pandas\n", "\n", "Pandas is able to read both .csv files and .json files. Once the data is on-board in a pandas.Dataframe object, you may want to reshape or transform it in some way. In the example below, Dataframe.transpose() is used." ] }, { "cell_type": "code", "execution_count": 1, "metadata": { "collapsed": false }, "outputs": [], "source": [ "import pandas\n", "url = \"http://thekirbster.pythonanywhere.com/api/elements?elem=all\"\n", "df = pandas.read_json(url)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "The website above is all open source. If you dig into the code at Github, you'll see how the HTTP request gets routed, by Flask, to the appropriate handler which, in this case, selects all rows from the Periodic_Table database, Elements table, and returns them in JSON format.\n", "\n", "Pandas has taken that JSON data and turned it into a Dataframe object." ] }, { "cell_type": "code", "execution_count": 2, "metadata": { "collapsed": false }, "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", "
AcAgAlAmArAsAtAuBBa...TmTsUVWXeYYbZnZr
08947139518338579556...691179223745439703040
1AcAgAlAmArAsAtAuBBa...TmTsUVWXeYYbZnZr
2ActiniumSilverAluminiumAmericiumArgonArsenicAstatineGoldBoronBarium...ThuliumTennessineUraniumVanadiumTungstenXenonYttriumYtterbiumZincZirconium
3227107.86826.981524339.948174.9216210196.96710.81137.328...168.934294238.02950.9415183.841131.29488.9058173.04565.38291.2242
4actinidetransition metalpost-transition metalactinidenoble gasmetalloidmetalloidtransition metalmetalloidalkaline earth metal...lanthanideunknown,probably metalloidactinidetransition metaltransition metalnoble gastransition metallanthanidetransition metaltransition metal
51493462392149346239214934623921493462392149346239214934623921493462392149346239214934623921493462392...1493462392149346239214934623921493462392149346239214934623921493462392149346239214934623921493462392
6KTUKTUKTUKTUKTUKTUKTUKTUKTUKTU...KTUKTUKTUKTUKTUKTUKTUKTUKTUKTU
\n", "

7 rows × 118 columns

\n", "
" ], "text/plain": [ " Ac Ag Al Am \\\n", "0 89 47 13 95 \n", "1 Ac Ag Al Am \n", "2 Actinium Silver Aluminium Americium \n", "3 227 107.868 26.9815 243 \n", "4 actinide transition metal post-transition metal actinide \n", "5 1493462392 1493462392 1493462392 1493462392 \n", "6 KTU KTU KTU KTU \n", "\n", " Ar As At Au B \\\n", "0 18 33 85 79 5 \n", "1 Ar As At Au B \n", "2 Argon Arsenic Astatine Gold Boron \n", "3 39.9481 74.9216 210 196.967 10.81 \n", "4 noble gas metalloid metalloid transition metal metalloid \n", "5 1493462392 1493462392 1493462392 1493462392 1493462392 \n", "6 KTU KTU KTU KTU KTU \n", "\n", " Ba ... Tm \\\n", "0 56 ... 69 \n", "1 Ba ... Tm \n", "2 Barium ... Thulium \n", "3 137.328 ... 168.934 \n", "4 alkaline earth metal ... lanthanide \n", "5 1493462392 ... 1493462392 \n", "6 KTU ... KTU \n", "\n", " Ts U V W \\\n", "0 117 92 23 74 \n", "1 Ts U V W \n", "2 Tennessine Uranium Vanadium Tungsten \n", "3 294 238.029 50.9415 183.841 \n", "4 unknown,probably metalloid actinide transition metal transition metal \n", "5 1493462392 1493462392 1493462392 1493462392 \n", "6 KTU KTU KTU KTU \n", "\n", " Xe Y Yb Zn \\\n", "0 54 39 70 30 \n", "1 Xe Y Yb Zn \n", "2 Xenon Yttrium Ytterbium Zinc \n", "3 131.294 88.9058 173.045 65.382 \n", "4 noble gas transition metal lanthanide transition metal \n", "5 1493462392 1493462392 1493462392 1493462392 \n", "6 KTU KTU KTU KTU \n", "\n", " Zr \n", "0 40 \n", "1 Zr \n", "2 Zirconium \n", "3 91.2242 \n", "4 transition metal \n", "5 1493462392 \n", "6 KTU \n", "\n", "[7 rows x 118 columns]" ] }, "execution_count": 2, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df # lets look at the data" ] }, { "cell_type": "code", "execution_count": 3, "metadata": { "collapsed": true }, "outputs": [], "source": [ "newdf = df.transpose() # lets reshape the data some" ] }, { "cell_type": "code", "execution_count": 4, "metadata": { "collapsed": false }, "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", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
0123456
Ac89AcActinium227actinide1493462392KTU
Ag47AgSilver107.868transition metal1493462392KTU
Al13AlAluminium26.9815post-transition metal1493462392KTU
Am95AmAmericium243actinide1493462392KTU
Ar18ArArgon39.9481noble gas1493462392KTU
As33AsArsenic74.9216metalloid1493462392KTU
At85AtAstatine210metalloid1493462392KTU
Au79AuGold196.967transition metal1493462392KTU
B5BBoron10.81metalloid1493462392KTU
Ba56BaBarium137.328alkaline earth metal1493462392KTU
Be4BeBeryllium9.01218alkaline earth metal1493462392KTU
Bh107BhBohrium270transition metal1493462392KTU
Bi83BiBismuth208.98post-transition metal1493462392KTU
Bk97BkBerkelium247actinide1493462392KTU
Br35BrBromine79.904diatomic nonmetal1493462392KTU
C6CCarbon12.011polyatomic nonmetal1493462392KTU
Ca20CaCalcium40.0784alkaline earth metal1493462392KTU
Cd48CdCadmium112.414transition metal1493462392KTU
Ce58CeCerium140.116lanthanide1493462392KTU
Cf98CfCalifornium251actinide1493462392KTU
Cl17ClChlorine35.45diatomic nonmetal1493462392KTU
Cm96CmCurium247actinide1493462392KTU
Cn112CnCopernicium285transition metal1493462392KTU
Co27CoCobalt58.9332transition metal1493462392KTU
Cr24CrChromium51.9962transition metal1493462392KTU
Cs55CsCesium132.905alkali metal1493462392KTU
Cu29CuCopper63.5463transition metal1493462392KTU
Db105DbDubnium268transition metal1493462392KTU
Ds110DsDarmstadtium281unknown, probably transition metal1493462392KTU
Dy66DyDysprosium162.5lanthanide1493462392KTU
........................
Rg111RgRoentgenium282unknown, probably transition metal1493462392KTU
Rh45RhRhodium102.906transition metal1493462392KTU
Rn86RnRadon222noble gas1493462392KTU
Ru44RuRuthenium101.072transition metal1493462392KTU
S16SSulfur32.06polyatomic nonmetal1493462392KTU
Sb51SbAntimony121.76metalloid1493462392KTU
Sc21ScScandium44.9559transition metal1493462392KTU
Se34SeSelenium78.9718polyatomic nonmetal1493462392KTU
Sg106SgSeaborgium269transition metal1493462392KTU
Si14SiSilicon28.085metalloid1493462392KTU
Sm62SmSamarium150.362lanthanide1493462392KTU
Sn50SnTin118.711post-transition metal1493462392KTU
Sr38SrStrontium87.621alkaline earth metal1493462392KTU
Ta73TaTantalum180.948transition metal1493462392KTU
Tb65TbTerbium158.925lanthanide1493462392KTU
Tc43TcTechnetium98transition metal1493462392KTU
Te52TeTellurium127.603metalloid1493462392KTU
Th90ThThorium232.038actinide1493462392KTU
Ti22TiTitanium47.8671transition metal1493462392KTU
Tl81TlThallium204.38post-transition metal1493462392KTU
Tm69TmThulium168.934lanthanide1493462392KTU
Ts117TsTennessine294unknown,probably metalloid1493462392KTU
U92UUranium238.029actinide1493462392KTU
V23VVanadium50.9415transition metal1493462392KTU
W74WTungsten183.841transition metal1493462392KTU
Xe54XeXenon131.294noble gas1493462392KTU
Y39YYttrium88.9058transition metal1493462392KTU
Yb70YbYtterbium173.045lanthanide1493462392KTU
Zn30ZnZinc65.382transition metal1493462392KTU
Zr40ZrZirconium91.2242transition metal1493462392KTU
\n", "

118 rows × 7 columns

\n", "
" ], "text/plain": [ " 0 1 2 3 4 \\\n", "Ac 89 Ac Actinium 227 actinide \n", "Ag 47 Ag Silver 107.868 transition metal \n", "Al 13 Al Aluminium 26.9815 post-transition metal \n", "Am 95 Am Americium 243 actinide \n", "Ar 18 Ar Argon 39.9481 noble gas \n", "As 33 As Arsenic 74.9216 metalloid \n", "At 85 At Astatine 210 metalloid \n", "Au 79 Au Gold 196.967 transition metal \n", "B 5 B Boron 10.81 metalloid \n", "Ba 56 Ba Barium 137.328 alkaline earth metal \n", "Be 4 Be Beryllium 9.01218 alkaline earth metal \n", "Bh 107 Bh Bohrium 270 transition metal \n", "Bi 83 Bi Bismuth 208.98 post-transition metal \n", "Bk 97 Bk Berkelium 247 actinide \n", "Br 35 Br Bromine 79.904 diatomic nonmetal \n", "C 6 C Carbon 12.011 polyatomic nonmetal \n", "Ca 20 Ca Calcium 40.0784 alkaline earth metal \n", "Cd 48 Cd Cadmium 112.414 transition metal \n", "Ce 58 Ce Cerium 140.116 lanthanide \n", "Cf 98 Cf Californium 251 actinide \n", "Cl 17 Cl Chlorine 35.45 diatomic nonmetal \n", "Cm 96 Cm Curium 247 actinide \n", "Cn 112 Cn Copernicium 285 transition metal \n", "Co 27 Co Cobalt 58.9332 transition metal \n", "Cr 24 Cr Chromium 51.9962 transition metal \n", "Cs 55 Cs Cesium 132.905 alkali metal \n", "Cu 29 Cu Copper 63.5463 transition metal \n", "Db 105 Db Dubnium 268 transition metal \n", "Ds 110 Ds Darmstadtium 281 unknown, probably transition metal \n", "Dy 66 Dy Dysprosium 162.5 lanthanide \n", ".. ... .. ... ... ... \n", "Rg 111 Rg Roentgenium 282 unknown, probably transition metal \n", "Rh 45 Rh Rhodium 102.906 transition metal \n", "Rn 86 Rn Radon 222 noble gas \n", "Ru 44 Ru Ruthenium 101.072 transition metal \n", "S 16 S Sulfur 32.06 polyatomic nonmetal \n", "Sb 51 Sb Antimony 121.76 metalloid \n", "Sc 21 Sc Scandium 44.9559 transition metal \n", "Se 34 Se Selenium 78.9718 polyatomic nonmetal \n", "Sg 106 Sg Seaborgium 269 transition metal \n", "Si 14 Si Silicon 28.085 metalloid \n", "Sm 62 Sm Samarium 150.362 lanthanide \n", "Sn 50 Sn Tin 118.711 post-transition metal \n", "Sr 38 Sr Strontium 87.621 alkaline earth metal \n", "Ta 73 Ta Tantalum 180.948 transition metal \n", "Tb 65 Tb Terbium 158.925 lanthanide \n", "Tc 43 Tc Technetium 98 transition metal \n", "Te 52 Te Tellurium 127.603 metalloid \n", "Th 90 Th Thorium 232.038 actinide \n", "Ti 22 Ti Titanium 47.8671 transition metal \n", "Tl 81 Tl Thallium 204.38 post-transition metal \n", "Tm 69 Tm Thulium 168.934 lanthanide \n", "Ts 117 Ts Tennessine 294 unknown,probably metalloid \n", "U 92 U Uranium 238.029 actinide \n", "V 23 V Vanadium 50.9415 transition metal \n", "W 74 W Tungsten 183.841 transition metal \n", "Xe 54 Xe Xenon 131.294 noble gas \n", "Y 39 Y Yttrium 88.9058 transition metal \n", "Yb 70 Yb Ytterbium 173.045 lanthanide \n", "Zn 30 Zn Zinc 65.382 transition metal \n", "Zr 40 Zr Zirconium 91.2242 transition metal \n", "\n", " 5 6 \n", "Ac 1493462392 KTU \n", "Ag 1493462392 KTU \n", "Al 1493462392 KTU \n", "Am 1493462392 KTU \n", "Ar 1493462392 KTU \n", "As 1493462392 KTU \n", "At 1493462392 KTU \n", "Au 1493462392 KTU \n", "B 1493462392 KTU \n", "Ba 1493462392 KTU \n", "Be 1493462392 KTU \n", "Bh 1493462392 KTU \n", "Bi 1493462392 KTU \n", "Bk 1493462392 KTU \n", "Br 1493462392 KTU \n", "C 1493462392 KTU \n", "Ca 1493462392 KTU \n", "Cd 1493462392 KTU \n", "Ce 1493462392 KTU \n", "Cf 1493462392 KTU \n", "Cl 1493462392 KTU \n", "Cm 1493462392 KTU \n", "Cn 1493462392 KTU \n", "Co 1493462392 KTU \n", "Cr 1493462392 KTU \n", "Cs 1493462392 KTU \n", "Cu 1493462392 KTU \n", "Db 1493462392 KTU \n", "Ds 1493462392 KTU \n", "Dy 1493462392 KTU \n", ".. ... ... \n", "Rg 1493462392 KTU \n", "Rh 1493462392 KTU \n", "Rn 1493462392 KTU \n", "Ru 1493462392 KTU \n", "S 1493462392 KTU \n", "Sb 1493462392 KTU \n", "Sc 1493462392 KTU \n", "Se 1493462392 KTU \n", "Sg 1493462392 KTU \n", "Si 1493462392 KTU \n", "Sm 1493462392 KTU \n", "Sn 1493462392 KTU \n", "Sr 1493462392 KTU \n", "Ta 1493462392 KTU \n", "Tb 1493462392 KTU \n", "Tc 1493462392 KTU \n", "Te 1493462392 KTU \n", "Th 1493462392 KTU \n", "Ti 1493462392 KTU \n", "Tl 1493462392 KTU \n", "Tm 1493462392 KTU \n", "Ts 1493462392 KTU \n", "U 1493462392 KTU \n", "V 1493462392 KTU \n", "W 1493462392 KTU \n", "Xe 1493462392 KTU \n", "Y 1493462392 KTU \n", "Yb 1493462392 KTU \n", "Zn 1493462392 KTU \n", "Zr 1493462392 KTU \n", "\n", "[118 rows x 7 columns]" ] }, "execution_count": 4, "metadata": {}, "output_type": "execute_result" } ], "source": [ "newdf" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "The raw JSON data did not include column names, so the default numeric indexing is used. We have the ability to change those column names. Lets do it \"in place\" without creating a new Dataframe..." ] }, { "cell_type": "code", "execution_count": 5, "metadata": { "collapsed": true }, "outputs": [], "source": [ "newdf.rename(columns={0: 'Protons', 1: 'Symbol', 2: \"Name\", 3:'Mass', \n", " 4:'Series', 5:'Updated', 6:'Initials'}, \n", " inplace=True)" ] }, { "cell_type": "code", "execution_count": 6, "metadata": { "collapsed": false }, "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", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
ProtonsSymbolNameMassSeriesUpdatedInitials
Ac89AcActinium227actinide1493462392KTU
Ag47AgSilver107.868transition metal1493462392KTU
Al13AlAluminium26.9815post-transition metal1493462392KTU
Am95AmAmericium243actinide1493462392KTU
Ar18ArArgon39.9481noble gas1493462392KTU
As33AsArsenic74.9216metalloid1493462392KTU
At85AtAstatine210metalloid1493462392KTU
Au79AuGold196.967transition metal1493462392KTU
B5BBoron10.81metalloid1493462392KTU
Ba56BaBarium137.328alkaline earth metal1493462392KTU
Be4BeBeryllium9.01218alkaline earth metal1493462392KTU
Bh107BhBohrium270transition metal1493462392KTU
Bi83BiBismuth208.98post-transition metal1493462392KTU
Bk97BkBerkelium247actinide1493462392KTU
Br35BrBromine79.904diatomic nonmetal1493462392KTU
C6CCarbon12.011polyatomic nonmetal1493462392KTU
Ca20CaCalcium40.0784alkaline earth metal1493462392KTU
Cd48CdCadmium112.414transition metal1493462392KTU
Ce58CeCerium140.116lanthanide1493462392KTU
Cf98CfCalifornium251actinide1493462392KTU
Cl17ClChlorine35.45diatomic nonmetal1493462392KTU
Cm96CmCurium247actinide1493462392KTU
Cn112CnCopernicium285transition metal1493462392KTU
Co27CoCobalt58.9332transition metal1493462392KTU
Cr24CrChromium51.9962transition metal1493462392KTU
Cs55CsCesium132.905alkali metal1493462392KTU
Cu29CuCopper63.5463transition metal1493462392KTU
Db105DbDubnium268transition metal1493462392KTU
Ds110DsDarmstadtium281unknown, probably transition metal1493462392KTU
Dy66DyDysprosium162.5lanthanide1493462392KTU
........................
Rg111RgRoentgenium282unknown, probably transition metal1493462392KTU
Rh45RhRhodium102.906transition metal1493462392KTU
Rn86RnRadon222noble gas1493462392KTU
Ru44RuRuthenium101.072transition metal1493462392KTU
S16SSulfur32.06polyatomic nonmetal1493462392KTU
Sb51SbAntimony121.76metalloid1493462392KTU
Sc21ScScandium44.9559transition metal1493462392KTU
Se34SeSelenium78.9718polyatomic nonmetal1493462392KTU
Sg106SgSeaborgium269transition metal1493462392KTU
Si14SiSilicon28.085metalloid1493462392KTU
Sm62SmSamarium150.362lanthanide1493462392KTU
Sn50SnTin118.711post-transition metal1493462392KTU
Sr38SrStrontium87.621alkaline earth metal1493462392KTU
Ta73TaTantalum180.948transition metal1493462392KTU
Tb65TbTerbium158.925lanthanide1493462392KTU
Tc43TcTechnetium98transition metal1493462392KTU
Te52TeTellurium127.603metalloid1493462392KTU
Th90ThThorium232.038actinide1493462392KTU
Ti22TiTitanium47.8671transition metal1493462392KTU
Tl81TlThallium204.38post-transition metal1493462392KTU
Tm69TmThulium168.934lanthanide1493462392KTU
Ts117TsTennessine294unknown,probably metalloid1493462392KTU
U92UUranium238.029actinide1493462392KTU
V23VVanadium50.9415transition metal1493462392KTU
W74WTungsten183.841transition metal1493462392KTU
Xe54XeXenon131.294noble gas1493462392KTU
Y39YYttrium88.9058transition metal1493462392KTU
Yb70YbYtterbium173.045lanthanide1493462392KTU
Zn30ZnZinc65.382transition metal1493462392KTU
Zr40ZrZirconium91.2242transition metal1493462392KTU
\n", "

118 rows × 7 columns

\n", "
" ], "text/plain": [ " Protons Symbol Name Mass Series \\\n", "Ac 89 Ac Actinium 227 actinide \n", "Ag 47 Ag Silver 107.868 transition metal \n", "Al 13 Al Aluminium 26.9815 post-transition metal \n", "Am 95 Am Americium 243 actinide \n", "Ar 18 Ar Argon 39.9481 noble gas \n", "As 33 As Arsenic 74.9216 metalloid \n", "At 85 At Astatine 210 metalloid \n", "Au 79 Au Gold 196.967 transition metal \n", "B 5 B Boron 10.81 metalloid \n", "Ba 56 Ba Barium 137.328 alkaline earth metal \n", "Be 4 Be Beryllium 9.01218 alkaline earth metal \n", "Bh 107 Bh Bohrium 270 transition metal \n", "Bi 83 Bi Bismuth 208.98 post-transition metal \n", "Bk 97 Bk Berkelium 247 actinide \n", "Br 35 Br Bromine 79.904 diatomic nonmetal \n", "C 6 C Carbon 12.011 polyatomic nonmetal \n", "Ca 20 Ca Calcium 40.0784 alkaline earth metal \n", "Cd 48 Cd Cadmium 112.414 transition metal \n", "Ce 58 Ce Cerium 140.116 lanthanide \n", "Cf 98 Cf Californium 251 actinide \n", "Cl 17 Cl Chlorine 35.45 diatomic nonmetal \n", "Cm 96 Cm Curium 247 actinide \n", "Cn 112 Cn Copernicium 285 transition metal \n", "Co 27 Co Cobalt 58.9332 transition metal \n", "Cr 24 Cr Chromium 51.9962 transition metal \n", "Cs 55 Cs Cesium 132.905 alkali metal \n", "Cu 29 Cu Copper 63.5463 transition metal \n", "Db 105 Db Dubnium 268 transition metal \n", "Ds 110 Ds Darmstadtium 281 unknown, probably transition metal \n", "Dy 66 Dy Dysprosium 162.5 lanthanide \n", ".. ... ... ... ... ... \n", "Rg 111 Rg Roentgenium 282 unknown, probably transition metal \n", "Rh 45 Rh Rhodium 102.906 transition metal \n", "Rn 86 Rn Radon 222 noble gas \n", "Ru 44 Ru Ruthenium 101.072 transition metal \n", "S 16 S Sulfur 32.06 polyatomic nonmetal \n", "Sb 51 Sb Antimony 121.76 metalloid \n", "Sc 21 Sc Scandium 44.9559 transition metal \n", "Se 34 Se Selenium 78.9718 polyatomic nonmetal \n", "Sg 106 Sg Seaborgium 269 transition metal \n", "Si 14 Si Silicon 28.085 metalloid \n", "Sm 62 Sm Samarium 150.362 lanthanide \n", "Sn 50 Sn Tin 118.711 post-transition metal \n", "Sr 38 Sr Strontium 87.621 alkaline earth metal \n", "Ta 73 Ta Tantalum 180.948 transition metal \n", "Tb 65 Tb Terbium 158.925 lanthanide \n", "Tc 43 Tc Technetium 98 transition metal \n", "Te 52 Te Tellurium 127.603 metalloid \n", "Th 90 Th Thorium 232.038 actinide \n", "Ti 22 Ti Titanium 47.8671 transition metal \n", "Tl 81 Tl Thallium 204.38 post-transition metal \n", "Tm 69 Tm Thulium 168.934 lanthanide \n", "Ts 117 Ts Tennessine 294 unknown,probably metalloid \n", "U 92 U Uranium 238.029 actinide \n", "V 23 V Vanadium 50.9415 transition metal \n", "W 74 W Tungsten 183.841 transition metal \n", "Xe 54 Xe Xenon 131.294 noble gas \n", "Y 39 Y Yttrium 88.9058 transition metal \n", "Yb 70 Yb Ytterbium 173.045 lanthanide \n", "Zn 30 Zn Zinc 65.382 transition metal \n", "Zr 40 Zr Zirconium 91.2242 transition metal \n", "\n", " Updated Initials \n", "Ac 1493462392 KTU \n", "Ag 1493462392 KTU \n", "Al 1493462392 KTU \n", "Am 1493462392 KTU \n", "Ar 1493462392 KTU \n", "As 1493462392 KTU \n", "At 1493462392 KTU \n", "Au 1493462392 KTU \n", "B 1493462392 KTU \n", "Ba 1493462392 KTU \n", "Be 1493462392 KTU \n", "Bh 1493462392 KTU \n", "Bi 1493462392 KTU \n", "Bk 1493462392 KTU \n", "Br 1493462392 KTU \n", "C 1493462392 KTU \n", "Ca 1493462392 KTU \n", "Cd 1493462392 KTU \n", "Ce 1493462392 KTU \n", "Cf 1493462392 KTU \n", "Cl 1493462392 KTU \n", "Cm 1493462392 KTU \n", "Cn 1493462392 KTU \n", "Co 1493462392 KTU \n", "Cr 1493462392 KTU \n", "Cs 1493462392 KTU \n", "Cu 1493462392 KTU \n", "Db 1493462392 KTU \n", "Ds 1493462392 KTU \n", "Dy 1493462392 KTU \n", ".. ... ... \n", "Rg 1493462392 KTU \n", "Rh 1493462392 KTU \n", "Rn 1493462392 KTU \n", "Ru 1493462392 KTU \n", "S 1493462392 KTU \n", "Sb 1493462392 KTU \n", "Sc 1493462392 KTU \n", "Se 1493462392 KTU \n", "Sg 1493462392 KTU \n", "Si 1493462392 KTU \n", "Sm 1493462392 KTU \n", "Sn 1493462392 KTU \n", "Sr 1493462392 KTU \n", "Ta 1493462392 KTU \n", "Tb 1493462392 KTU \n", "Tc 1493462392 KTU \n", "Te 1493462392 KTU \n", "Th 1493462392 KTU \n", "Ti 1493462392 KTU \n", "Tl 1493462392 KTU \n", "Tm 1493462392 KTU \n", "Ts 1493462392 KTU \n", "U 1493462392 KTU \n", "V 1493462392 KTU \n", "W 1493462392 KTU \n", "Xe 1493462392 KTU \n", "Y 1493462392 KTU \n", "Yb 1493462392 KTU \n", "Zn 1493462392 KTU \n", "Zr 1493462392 KTU \n", "\n", "[118 rows x 7 columns]" ] }, "execution_count": 6, "metadata": {}, "output_type": "execute_result" } ], "source": [ "newdf # now lets take another look" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Now is your chance to practice retrieving \"slices\" of the data using df.loc or df.iloc." ] }, { "cell_type": "code", "execution_count": 7, "metadata": { "collapsed": false }, "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", "
ProtonsSymbolName
Ac89AcActinium
Ag47AgSilver
Al13AlAluminium
Am95AmAmericium
Ar18ArArgon
As33AsArsenic
At85AtAstatine
Au79AuGold
B5BBoron
Ba56BaBarium
\n", "
" ], "text/plain": [ " Protons Symbol Name\n", "Ac 89 Ac Actinium\n", "Ag 47 Ag Silver\n", "Al 13 Al Aluminium\n", "Am 95 Am Americium\n", "Ar 18 Ar Argon\n", "As 33 As Arsenic\n", "At 85 At Astatine\n", "Au 79 Au Gold\n", "B 5 B Boron\n", "Ba 56 Ba Barium" ] }, "execution_count": 7, "metadata": {}, "output_type": "execute_result" } ], "source": [ "newdf.iloc[0:10, 0:3] # you may need to do some data cleaning as well" ] }, { "cell_type": "code", "execution_count": 8, "metadata": { "collapsed": false }, "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", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
ProtonsSymbolNameMassSeriesUpdatedInitials
H1HHydrogen1.008diatomic nonmetal1498013115KTU
He2HeHelium4.0026noble gas1493462392KTU
Li3LiLithium6.94alkali metal1493462392KTU
Be4BeBeryllium9.01218alkaline earth metal1493462392KTU
B5BBoron10.81metalloid1493462392KTU
C6CCarbon12.011polyatomic nonmetal1493462392KTU
N7NNitrogen14.007diatomic nonmetal1493462392KTU
O8OOxygen15.999diatomic nonmetal1493462392KTU
F9FFluorine18.9984diatomic nonmetal1493462392KTU
Ne10NeNeon20.1798noble gas1493462392KTU
Na11NaSodium22.9898alkali metal1493462392KTU
Mg12MgMagnesium24.305alkaline earth metal1493462392KTU
Al13AlAluminium26.9815post-transition metal1493462392KTU
Si14SiSilicon28.085metalloid1493462392KTU
P15PPhosphorus30.9738polyatomic nonmetal1493462392KTU
S16SSulfur32.06polyatomic nonmetal1493462392KTU
Cl17ClChlorine35.45diatomic nonmetal1493462392KTU
Ar18ArArgon39.9481noble gas1493462392KTU
K19KPotassium39.0983alkali metal1493462392KTU
Ca20CaCalcium40.0784alkaline earth metal1493462392KTU
Sc21ScScandium44.9559transition metal1493462392KTU
Ti22TiTitanium47.8671transition metal1493462392KTU
V23VVanadium50.9415transition metal1493462392KTU
Cr24CrChromium51.9962transition metal1493462392KTU
Mn25MnManganese54.938transition metal1493462392KTU
Fe26FeIron55.8452transition metal1493462392KTU
Co27CoCobalt58.9332transition metal1493462392KTU
Ni28NiNickel58.6934transition metal1493462392KTU
Cu29CuCopper63.5463transition metal1493462392KTU
Zn30ZnZinc65.382transition metal1493462392KTU
........................
Ac89AcActinium227actinide1493462392KTU
Th90ThThorium232.038actinide1493462392KTU
Pa91PaProtactinium231.036actinide1493462392KTU
U92UUranium238.029actinide1493462392KTU
Np93NpNeptunium237actinide1493462392KTU
Pu94PuPlutonium244actinide1493462392KTU
Am95AmAmericium243actinide1493462392KTU
Cm96CmCurium247actinide1493462392KTU
Bk97BkBerkelium247actinide1493462392KTU
Cf98CfCalifornium251actinide1493462392KTU
Es99EsEinsteinium252actinide1493462392KTU
Fm100FmFermium257actinide1493462392KTU
Md101MdMendelevium258actinide1493462392KTU
No102NoNobelium259actinide1493462392KTU
Lr103LrLawrencium266actinide1493462392KTU
Rf104RfRutherfordium267transition metal1493462392KTU
Db105DbDubnium268transition metal1493462392KTU
Sg106SgSeaborgium269transition metal1493462392KTU
Bh107BhBohrium270transition metal1493462392KTU
Hs108HsHassium269transition metal1493462392KTU
Mt109MtMeitnerium278unknown, probably transition metal1493462392KTU
Ds110DsDarmstadtium281unknown, probably transition metal1493462392KTU
Rg111RgRoentgenium282unknown, probably transition metal1493462392KTU
Cn112CnCopernicium285transition metal1493462392KTU
Nh113NhNihonium286unknown, probably transition metal1493462392KTU
Fl114FlFlerovium289post-transition metal1493462392KTU
Mc115McMoscovium289unknown, probably post transition metal1493462392KTU
Lv116LvLivermorium293unknown, probably post transition metal1493462392KTU
Ts117TsTennessine294unknown,probably metalloid1493462392KTU
Og118OgOganesson294unknown, predicted to be noble gas1493462392KTU
\n", "

118 rows × 7 columns

\n", "
" ], "text/plain": [ " Protons Symbol Name Mass \\\n", "H 1 H Hydrogen 1.008 \n", "He 2 He Helium 4.0026 \n", "Li 3 Li Lithium 6.94 \n", "Be 4 Be Beryllium 9.01218 \n", "B 5 B Boron 10.81 \n", "C 6 C Carbon 12.011 \n", "N 7 N Nitrogen 14.007 \n", "O 8 O Oxygen 15.999 \n", "F 9 F Fluorine 18.9984 \n", "Ne 10 Ne Neon 20.1798 \n", "Na 11 Na Sodium 22.9898 \n", "Mg 12 Mg Magnesium 24.305 \n", "Al 13 Al Aluminium 26.9815 \n", "Si 14 Si Silicon 28.085 \n", "P 15 P Phosphorus 30.9738 \n", "S 16 S Sulfur 32.06 \n", "Cl 17 Cl Chlorine 35.45 \n", "Ar 18 Ar Argon 39.9481 \n", "K 19 K Potassium 39.0983 \n", "Ca 20 Ca Calcium 40.0784 \n", "Sc 21 Sc Scandium 44.9559 \n", "Ti 22 Ti Titanium 47.8671 \n", "V 23 V Vanadium 50.9415 \n", "Cr 24 Cr Chromium 51.9962 \n", "Mn 25 Mn Manganese 54.938 \n", "Fe 26 Fe Iron 55.8452 \n", "Co 27 Co Cobalt 58.9332 \n", "Ni 28 Ni Nickel 58.6934 \n", "Cu 29 Cu Copper 63.5463 \n", "Zn 30 Zn Zinc 65.382 \n", ".. ... ... ... ... \n", "Ac 89 Ac Actinium 227 \n", "Th 90 Th Thorium 232.038 \n", "Pa 91 Pa Protactinium 231.036 \n", "U 92 U Uranium 238.029 \n", "Np 93 Np Neptunium 237 \n", "Pu 94 Pu Plutonium 244 \n", "Am 95 Am Americium 243 \n", "Cm 96 Cm Curium 247 \n", "Bk 97 Bk Berkelium 247 \n", "Cf 98 Cf Californium 251 \n", "Es 99 Es Einsteinium 252 \n", "Fm 100 Fm Fermium 257 \n", "Md 101 Md Mendelevium 258 \n", "No 102 No Nobelium 259 \n", "Lr 103 Lr Lawrencium 266 \n", "Rf 104 Rf Rutherfordium 267 \n", "Db 105 Db Dubnium 268 \n", "Sg 106 Sg Seaborgium 269 \n", "Bh 107 Bh Bohrium 270 \n", "Hs 108 Hs Hassium 269 \n", "Mt 109 Mt Meitnerium 278 \n", "Ds 110 Ds Darmstadtium 281 \n", "Rg 111 Rg Roentgenium 282 \n", "Cn 112 Cn Copernicium 285 \n", "Nh 113 Nh Nihonium 286 \n", "Fl 114 Fl Flerovium 289 \n", "Mc 115 Mc Moscovium 289 \n", "Lv 116 Lv Livermorium 293 \n", "Ts 117 Ts Tennessine 294 \n", "Og 118 Og Oganesson 294 \n", "\n", " Series Updated Initials \n", "H diatomic nonmetal 1498013115 KTU \n", "He noble gas 1493462392 KTU \n", "Li alkali metal 1493462392 KTU \n", "Be alkaline earth metal 1493462392 KTU \n", "B metalloid 1493462392 KTU \n", "C polyatomic nonmetal 1493462392 KTU \n", "N diatomic nonmetal 1493462392 KTU \n", "O diatomic nonmetal 1493462392 KTU \n", "F diatomic nonmetal 1493462392 KTU \n", "Ne noble gas 1493462392 KTU \n", "Na alkali metal 1493462392 KTU \n", "Mg alkaline earth metal 1493462392 KTU \n", "Al post-transition metal 1493462392 KTU \n", "Si metalloid 1493462392 KTU \n", "P polyatomic nonmetal 1493462392 KTU \n", "S polyatomic nonmetal 1493462392 KTU \n", "Cl diatomic nonmetal 1493462392 KTU \n", "Ar noble gas 1493462392 KTU \n", "K alkali metal 1493462392 KTU \n", "Ca alkaline earth metal 1493462392 KTU \n", "Sc transition metal 1493462392 KTU \n", "Ti transition metal 1493462392 KTU \n", "V transition metal 1493462392 KTU \n", "Cr transition metal 1493462392 KTU \n", "Mn transition metal 1493462392 KTU \n", "Fe transition metal 1493462392 KTU \n", "Co transition metal 1493462392 KTU \n", "Ni transition metal 1493462392 KTU \n", "Cu transition metal 1493462392 KTU \n", "Zn transition metal 1493462392 KTU \n", ".. ... ... ... \n", "Ac actinide 1493462392 KTU \n", "Th actinide 1493462392 KTU \n", "Pa actinide 1493462392 KTU \n", "U actinide 1493462392 KTU \n", "Np actinide 1493462392 KTU \n", "Pu actinide 1493462392 KTU \n", "Am actinide 1493462392 KTU \n", "Cm actinide 1493462392 KTU \n", "Bk actinide 1493462392 KTU \n", "Cf actinide 1493462392 KTU \n", "Es actinide 1493462392 KTU \n", "Fm actinide 1493462392 KTU \n", "Md actinide 1493462392 KTU \n", "No actinide 1493462392 KTU \n", "Lr actinide 1493462392 KTU \n", "Rf transition metal 1493462392 KTU \n", "Db transition metal 1493462392 KTU \n", "Sg transition metal 1493462392 KTU \n", "Bh transition metal 1493462392 KTU \n", "Hs transition metal 1493462392 KTU \n", "Mt unknown, probably transition metal 1493462392 KTU \n", "Ds unknown, probably transition metal 1493462392 KTU \n", "Rg unknown, probably transition metal 1493462392 KTU \n", "Cn transition metal 1493462392 KTU \n", "Nh unknown, probably transition metal 1493462392 KTU \n", "Fl post-transition metal 1493462392 KTU \n", "Mc unknown, probably post transition metal 1493462392 KTU \n", "Lv unknown, probably post transition metal 1493462392 KTU \n", "Ts unknown,probably metalloid 1493462392 KTU \n", "Og unknown, predicted to be noble gas 1493462392 KTU \n", "\n", "[118 rows x 7 columns]" ] }, "execution_count": 8, "metadata": {}, "output_type": "execute_result" } ], "source": [ "newdf.sort_values('Protons')" ] }, { "cell_type": "code", "execution_count": 9, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "pandas.core.series.Series" ] }, "execution_count": 9, "metadata": {}, "output_type": "execute_result" } ], "source": [ "type(newdf.Protons)" ] }, { "cell_type": "code", "execution_count": 10, "metadata": { "collapsed": false }, "outputs": [ { "data": { "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYgAAAEWCAYAAAB8LwAVAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAIABJREFUeJzt3XuYXXV97/H3h2GECagDkmImBIM10gYQqCm1YiuCLXjh\nIk+LoFastPQ8tVV7fNCAtoRqDngQrD1e2igWkGtaIMYrIKBWj4AJiUDAHKPcMkkgKiMIAybhe/5Y\nv52s7Ow9s/Zk1t57zf68nmee2Xtd9v6tmWR/5ndZv58iAjMzs3q7dLoAZmbWnRwQZmbWkAPCzMwa\nckCYmVlDDggzM2vIAWFmZg05IMx6mKRVko7qdDmsOzkgbCtJD0oalfRrSY9KulTSnhN8rQWSrpjs\nMk5Vkr4t6XFJu9Vtv1TSx8p634g4KCK+3co5kmZLCkkr6rbvI+k3kh6czDJa5zggrN7xEbEn8HvA\nPOAj9QcoM6X/7UjatY3vNRv4IyCAE9r1vpNgmqSDc8/fBjzQqcLY5JvS/8lt4iJiGPgGcDBs/Qt3\noaTvA08DL5U0JGmppF9KWiPpr9OxxwHnAG9NtZEfpe0Nj0/7FkhaLOlySU+mpo95uf0fkjSc9q2W\ndEx9mSX9gaQNkvpy294i6e70eBdJ8yX9VNIv0vvtnfbV/io+Q9LDwK2Sdpd0RTp2RNIPJe2bjn9Q\n0uvryn9Fetz0vCbeCdwOXAqcnnvNM4G3Ax9MP8evpO2/m34fI+nndELunEslfVbSN9I535f0Ykn/\nkmooP5Z0eO74rdchqU/SOenn86Sk5ZJmjVHuL+XLm67j8rrfyfzc690n6S25fS+T9B1Jv5L0c0nX\npu2S9ElJj0l6QtI9dUFk7RIR/vIXEQHwIPD69HgWsAr4aHr+beBh4CBgV6Af+C7wWWB34DBgI3B0\nOn4BcEXd6493/DPAG4E+4Hzg9rTvQOARYCg9nw38dpNr+CnwJ7nn/wnMT4/fR/ZBvB+wG/DvwNW5\n1wyyD7g9gAHgb4CvANNSmV4JvKD+Z1V/vWOd16TMa4C/TcdtAvbN7bsU+FjueX86/hzgecDRwJPA\ngbnjf55ea3fgVrK/6t+ZyvIx4LYmv/OzgHvSz1vAocCLGpS39rOanX4vfcBc4MfA64EHc8f+OTBE\n9sfoW4GngBlp39XAh9O+3YHXpO3HAsuBwVSO362d46/2frkGYfWWSBoBvgd8B/hfuX2XRsSqiNgM\nvBg4EvhQRDwTESuBL5B9EO0g/SU63vHfi4ivR8QWsr9OD03bt5B9oM+V1B8RD0bET5uU/2rgtPSe\nzycLnKvTvv8BfDgi1kbEs2Qf6n9W15y0ICKeiohRsg/rFwEvi4gtEbE8Ip5o/qPbqvB5kl4DvARY\nHBHLyQLubWO89quAPYELIuI3EXEr8NXaNSc3pPd8BrgBeCYiLk8/12uBw3d41cxfAR+JiNWR+VFE\n/GKMsqwFVpOFwjvJfmfbiYj/jIh1EfFcRFwL/AQ4Iu3elK59KP2b+F5u+/OB3wEUEfdHxPoxymEl\ncUBYvZMiYjAiXhIRf5s+KGseyT0eAn4ZEU/mtj0EzGzyukWO35B7/DSwu6RdI2IN8H6yD/THJF0j\naajJ+1wFnKyss/dk4K6IeCjtewlwQ2qaGQHuJwuffPNP/hq/BNwIXCNpnaT/Lam/yfvmtXLe6cBN\nEfHzXPlPb3IsZD/HRyLiudy2+p/jo7nHow2eNxt4MIssoFpxOfAusoDaISAkvVPSytzP/GBgn7T7\ng2Q1hDtTU9m7AVLofRr4DNnve5GkF7RYLpsEDghrRX7q33XA3umv9Jr9geEGxxY5fuw3jrgqImp/\nbQfw8SbH3Uf2gfkGsr/Er8rtfgR4QwrA2tfukfW37HCNEbEpIs6LiLnAq4E3s63G8xRZE1LNiwue\nt5WkAeAU4LWp72QD8A/AoZJqtadGP8dZ2n6QQOGf4zgeAX67xXOuA94E/CwiHs7vkPQS4PPA35E1\nVQ0C95KFAhGxISL+OiKGyJrlPivpZWnfv0bEK8marl5O1vxlbeaAsAmJiEeA/wucnzplXwGcAdSG\ntj4KzK59kBU4vilJB0o6OtUKniH7K/i5MU65iqy/4Y/J+iBq/g1YmD64kDRd0oljvO/rJB2SOr2f\nIGv6qL3vSuBUSf3KOtP/rOB5eSeR1WDmkvXJHEbW3v7fbAuUR4GX5s65g6x29cH03kcBxwPXjPHz\nKOoLwEclzUkdxa+Q9KKxToiIp8j6Qf6qwe49yAJuI4CkvyQNekjP/1zSfunp4+nY5yT9vrIBB/1k\nQfwMY/++rSQOCNsZp5F1VK4ja+s+NyK+lfbVPph/IemuAsePZTfgArLO1w3AbwFnj3H81cBrgVtz\nTTcAnwKWAjdJepKsw/oPxnidFwP/RfYhfz9Zn0ytGeUfyf7afhw4j+1rKmOdl3c68B8R8XD6a3pD\nRGwga155e+obuYSs72VE0pKI+A1ZILwh/Tw+C7wzIn48xnUUdTGwGLgplf0Sss76MUXEskZ9Qqk2\ndxHwA7KgOwT4fu6Q3wfukPRrst/L+yLiZ8ALyGoej5PVBn8BXDjxy7KJUoQXDDIzsx25BmFmZg05\nIMzMrCEHhJmZNeSAMDOzhto2IVkZ9tlnn5g9e3ani2FmVinLly//eURMH++4SgfE7NmzWbZsWaeL\nYWZWKZIeGv8oNzGZmVkTpQVEulv2Tkk/SvOsnJe27y3pZkk/Sd/3yp1ztrJpoFdLOrasspmZ2fjK\nrEE8SzaV86FkUwgcJ+lVwHzgloiYA9ySniNpLnAq2XTSx5HNy9LX8JXNzKx0pQVEmi741+lpf/oK\n4ETgsrT9MrL5aEjbr4mIZyPiAbI574/AzMw6otQ+iLRC1UrgMeDmiLiDbDGU2tzuG9g21fJMtp9q\neS0Npo6WdKakZZKWbdy4scTSm5n1tlJHMaUFSg6TNEg2D//BdftDUkuTQUXEImARwLx58zyRlJlN\neUtWDHPhjatZNzLK4LR+IuBXo5sYGhzgrGMP5KTDmy3DsnPaMsw1IkYk3UbWt/CopBkRsV7SDLLa\nBWTz2efXv92PyZnj3syskpasGGbB0lWMjG7auu3xp7c9Hh4Z5ezr7wEoJSTKHMU0PdUcaguj/AnZ\nmrVL2bZi1unAl9PjpWTz6+8m6QBgDnBnWeUzM+tmS1YMc/b192wXDo2MbtrChTeuLqUMZdYgZgCX\npZFIu5CtuftVST8AFks6g2yu91MAImKVpMXAfcBm4D2picrMrOdceONqRjcV+whcNzI6/kETUFpA\nRMTdNFgcPS2CfkyTcxYCC8sqk5lZN8r3MbxwoB9p+6ak8QwNjruu04RUeqoNM7OqqzUl1WoL4zUp\n1Rvo7+OsYw8so2gOCDOzdqqvLTzxzCaea2E85h7P66O/b5epM4rJzMx2rrYws+QwaMQBYWbWBktW\nDPOBxT9iS7R++9bMwQG+P//oEko1NgeEmVlJas1JwyOjiGyuoVaV2ccwHgeEmVkJ6puTioaDBIMD\n/Yw8XX4fw3gcEGZmkyhfa2jVQH8f5598SMcCoZ4DwsxsktTXGsbTTbWFRhwQZmaTpJW7n7utttCI\nA8LMbJKMN+VFraO6E0NWJ8IBYWY2SYYGB5r2PVQlFPIcEGZmE5S/K3pocIDX/c50rls+vF0zUxWa\nkppxQJiZtWjJimHO+8qqHdZmuPL2hwmgT2JLRCVrDXkOCDOzJhqt5DYyuqnpTW+1bVsitt7gVtVw\nAAeEmdkOxlvJrchNb7WFfBwQZmZTRKv3MoylrIV82qW0JUfNzKqolXsZxlPWQj7t4oAwM8uZrL/6\nOznJ3mRxE5OZWc5Y9zLk1d/0Bmw35LXqHdTggDAzA8afmrvISm5VD4R6Dggz6zn1y37+ZvMWnt70\n3Nb9QfWmxSiDA8LMekrRZT9r4dCJldy6hTupzayntDJKqerDVHeWA8LMekorH/pVH6a6s9zEZGZT\nWr7zuU8qvPTnVBimurNKq0FImiXpNkn3SVol6X1p+wJJw5JWpq835s45W9IaSaslHVtW2cysN9T6\nG2rDVrdEsXjYa1p/ZWdgnUxl1iA2Ax+IiLskPR9YLunmtO+TEfGJ/MGS5gKnAgcBQ8C3JL08Iibn\nlkYz6zlF+hsGB/qR6NplPzuptICIiPXA+vT4SUn3A2P91E8EromIZ4EHJK0BjgB+UFYZzWxqqW9O\nGq/GIGDluX/ansJVUFs6qSXNBg4H7kib/l7S3ZK+KGmvtG0m8EjutLU0CBRJZ0paJmnZxo0bSyy1\nmVXJRJqTer0TejylB4SkPYHrgPdHxBPA54CXAoeR1TAuauX1ImJRRMyLiHnTp0+f9PKaWfdbsmKY\nIy+4lQPmf40jL7h1a82hlUn23Ak9vlJHMUnqJwuHKyPieoCIeDS3//PAV9PTYWBW7vT90jYzs63q\nb3QbHhnlH65dWWh00lRZ6a1dSgsISQIuAe6PiItz22ek/gmAtwD3psdLgaskXUzWST0HuLOs8plZ\nNTWqKRQJh16/K3oiyqxBHAn8BXCPpJVp2znAaZIOI/udPgj8DUBErJK0GLiPbATUezyCyczqTeTu\nZjcnTUyZo5i+RzZIoN7XxzhnIbCwrDKZWfXkJ9YbGhzghQP9TedPynNz0s7zndRm1rUa9TcU4eak\nyeG5mMysa01k+U83J00e1yDMrGsV6W/Ya1o/056365Raya1bOCDMrGvU9zcMTuvn8afH7m8YeXoT\nK/7Jd0OXwQFhZl1hov0Nvhu6PO6DMLOu4P6G7uMahJl1VH6CvfG4v6G9HBBm1hFLVgxz3ldWjdvH\nkOf+hvZyQJhZ29X3NxTl/ob2ckCYWdu00pwktp9jyf0N7eeAMLPStdqcVJseIz/k1f0N7eeAMLNS\ntdqcVKspnHT4TAdCh3mYq5mVqpXhq4MD/Zx/8iEOhi7hGoSZlarIdBmecbU7OSDMrFRDgwNNO6UH\n+vtcY+hibmIys1KddeyBDPT37bDdzUndzzUIMytVLQA8Iql6HBBmVjqPSKomB4SZlaJ+6m7XGqrH\nAWFmOy1/h3RtLej8ndDDI6Ocff09AA6JCnFAmNmE5EMhHwZbInsUdcePbtrChTeudkBUiAPCzFpW\nf3d0fRg0U+SeCOseDggza8mSFcN8YPGPttYUWuHZWKvF90GYWWG1msNEwsGzsVaPaxBmNq5WpunO\nq/VNeCqNaiotICTNAi4H9iX7N7IoIj4laW/gWmA28CBwSkQ8ns45GzgD2AK8NyJuLKt8ZlZM0dlY\na2FQG8XkUKi+MmsQm4EPRMRdkp4PLJd0M/Au4JaIuEDSfGA+8CFJc4FTgYOAIeBbkl4eEa0tOWVm\nk6rIbKx9EhedcqjDYIoprQ8iItZHxF3p8ZPA/cBM4ETgsnTYZcBJ6fGJwDUR8WxEPACsAY4oq3xm\nNrYlK4Y58oJbx21WGujvczhMUW3pg5A0GzgcuAPYNyLWp10byJqgIAuP23OnrU3b6l/rTOBMgP33\n37+cApv1sFZWf3Mz0tRWekBI2hO4Dnh/RDwhaeu+iAhJLQ2HiIhFwCKAefPmtT6UwsyaKtrf4Gm6\ne0OpASGpnywcroyI69PmRyXNiIj1kmYAj6Xtw8Cs3On7pW1mVrJWRim51tA7yhzFJOAS4P6IuDi3\naylwOnBB+v7l3ParJF1M1kk9B7izrPKZWWvNSZCFw/fnH11yqaxblFmDOBL4C+AeSSvTtnPIgmGx\npDOAh4BTACJilaTFwH1kI6De4xFMZuUp2pxU4xvdek9pARER3yMbGt3IMU3OWQgsLKtMZrZNkeGr\nNYMD/Sw44SA3K/UY30lt1mPc32BFOSDMeohHKVkrHBBmPaCVWoObk6zGAWE2xRWtNbg5yeo5IMym\nsKJrN3j4qjXigDCbYpotBdqMh69aMw4Isymk1aVA3axkY3FAmE0hRe9t8CglK8JLjppNEUtWDBca\npdQnORysENcgzCqsvr9hPK45WCscEGYVVbS/wetC20Q5IMwqqmh/wyffephDwSbEAWFWMa3OpeRw\nsIlyQJhVxJIVwyxYuoqR0WJrN/j+BttZDgizLtbqTW/ub7DJ5IAw61K+6c06zQFh1oWKzqFU47mU\nrAy+Uc6sy9RqDkXDwX0NVhbXIMy6RCujk2r2mtbPucd77QYrhwPCrAsUXbPBndDWToUCQtKfA9+M\niCclfQT4PeBjEXFXqaUzm+JaqTX0SVx0yqEOBWubon0Q/5jC4TXA64FLgM+VVyyzqa9WaygSDgP9\nfQ4Ha7uiAVGr974JWBQRXwOeV06RzHpD0akyZg4OeII964iifRDDkv4d+BPg45J2wyOgzCasyNTc\nnnnVOq1oQJwCHAd8IiJGJM0AzhrrBElfBN4MPBYRB6dtC4C/Bjamw86JiK+nfWcDZ5DVVt4bETe2\neC1mXa2VqbndCW3doGhAzAC+FhHPSjoKeAVw+TjnXAp8usFxn4yIT+Q3SJoLnAocBAwB35L08ogY\nv/5tVgFF74p2rcG6SdFmouuALZJeBiwCZgFXjXVCRHwX+GXB1z8RuCYino2IB4A1wBEFzzXrekX7\nGxwO1k2KBsRzEbEZOBn4PxFxFlmtYiL+XtLdkr4oaa+0bSbwSO6YtWnbDiSdKWmZpGUbN25sdIhZ\n11nnqbmtgoo2MW2SdBrwTuD4tK1/Au/3OeCjZDXsjwIXAe9u5QUiYhFZLYZ58+YVm4vArM1q/Q3r\nRkZ54UA/Eow1c4any7BuVLQG8ZfAHwILI+IBSQcAX2r1zSLi0YjYEhHPAZ9nWzPSMFmzVc1+aZtZ\n5eTvbwhgZHQTzzUIh1pHtYexWrcqVIOIiPuA9+aePwB8vNU3kzQjItanp28B7k2PlwJXSbqYrJN6\nDnBnq69v1g2K9Df4rmirgqJTbcwBzgfmArvXtkfES8c452rgKGAfSWuBc4GjJB1G1sT0IPA36XVW\nSVoM3AdsBt7jEUxWFfnhq31SoVlYn4twOFjXK9oH8R9kH/CfBF5H1uQ0ZvNURJzWYPMlYxy/EFhY\nsDxmHdVspbeiU3QPDQ6UVjazyVI0IAYi4hZJioiHgAWSlgP/VGLZzLpOo3WhWx0p4Q5pq4qiAfGs\npF2An0j6O7IO5D3LK5ZZ9yk6JXe9wTSKaeTpTQz5DmmrkKIB8T5gGllH9UeBo4HTyyqUWTcqerNb\nnpcCtSorOorph+nhr8n6H8x6xkRWegM3JVn1jRkQkpaOtT8iTpjc4ph1h2ad0M3UjqmNYvJkezYV\njFeD+EOyKTCuBu6AcSehNKu8ohPr1XhdaJuqxguIF5OtAXEa8Dbga8DVEbGq7IKZdUorC/m4lmBT\n2ZgBkW5W+ybwzbRI0GnAtyWdFxGfbkcBzcqWnzdpcFo/jz+9adxz3PlsvWDcTuoUDG8iC4fZwL8C\nN5RbLLP2qG9OKhIO7ny2XjFeJ/XlwMHA14HzIuLesY43q5qizUm1Tmg3K1kvGa8G8Q7gKbL7IN4r\nbe2jFhAR8YISy2ZWqiLrQtd88q2HORSs54zXB1F0OnCzSqk1LRXhhXysVzkArCcVbVpyf4P1sqJT\nbZhNCUXuih4c6OdXo543ycwBYT2jyGR7Hr5qto0Dwqa8onMpuTnJbHsOCJvSik7R7eGrZjtyQNiU\ntWTFMB9Y/KNxV3lzs5JZYx7FZFNSreYwXji4WcmsOdcgbEoqMozVzUpmY3NA2JRSpEN6oL+P808+\nxMFgNg4HhE0JS1YMc95XVo072V6f5HAwK8gBYZVXdKSSaw5mrXFAWGW1sla0+xvMWueAsEppda1o\n8DBWs4kqbZirpC9KekzSvblte0u6WdJP0ve9cvvOlrRG0mpJx5ZVLquuWlNSrcZQJBw8jNVs4sq8\nD+JS4Li6bfOBWyJiDnBLeo6kucCpwEHpnM9K6iuxbFYxtZveiszAWjM40O8+B7OdUFoTU0R8V9Ls\nus0nAkelx5cB3wY+lLZfExHPAg9IWgMcAfygrPJZdRS96a3G/Q1mk6PdfRD7RsT69HgDsG96PBO4\nPXfc2rRtB5LOBM4E2H///UsqpnWDVjqhwaOUzCZbx6baiIigWDNy/XmLImJeRMybPn16CSWzblDf\n39BMbRHcmYMDDgezSdbuGsSjkmZExHpJM4DH0vZhYFbuuP3SNutBRSfZ65O46JRDHQpmJWl3QCwF\nTgcuSN+/nNt+laSLgSFgDnBnm8tmHdTq8FU3J5mVr7SAkHQ1WYf0PpLWAueSBcNiSWcADwGnAETE\nKkmLgfuAzcB7IqL4cBWrtPo7occLB3dCm7VHmaOYTmuy65gmxy8EFpZVHuse+dpCn1R4dJJrDWbt\n5Tupra3qawtFw8GT7Jm1nwPC2qLVIat5rjmYdYYDwkq1ZMUwC5auYmR07Gm469U6qt3fYNY5Dggr\nTdFpuOs5FMy6gwPCSlNk2c88NyWZdRcHhE2KWh/DupFRBqf1E0GhZqXaKCbXGsy6jwPCdlp9U9J4\ny36CawtmVeCAsJ3WalPSXtP6Off4gxwOZl3OAWE7ZcmK4cJDV92MZFYtDgibsFrTUhFe9tOsehwQ\n1rKJrNPgZT/NqscBYS0pem/D4EA/vxrdxJCblcwqywFhhRVdp8HNSWZTQ8dWlLNqKboutJuTzKYO\n1yBsTK30N3iUktnU4oCwpor2N/imN7OpyQFhO2il1uB1GsymLgeEbaeVGVhdczCb2hwQtp2i02a4\nv8Fs6nNA9Lj8LKwvHOgfdwZW1xrMeocDoofVNyeNFw6uNZj1FgdEjyp60xu41mDWqxwQPSQ/Oqm2\n5nMRDgez3uSA6BH1zUlFw2Hm4IDDwaxHOSCmqHxtobasZ6s8bYZZb+tIQEh6EHgS2AJsjoh5kvYG\nrgVmAw8Cp0TE450oX9XV1xaKhoOAwWn9jDztWVjNrLM1iNdFxM9zz+cDt0TEBZLmp+cf6kzRqqnV\ndRry3BFtZvW6aTbXE4HL0uPLgJM6WJbKqdUaWgkHpe8zBwccDma2g07VIAL4lqQtwL9HxCJg34hY\nn/ZvAPZtdKKkM4EzAfbff/92lLXrtTJktcb3NJjZeDoVEK+JiGFJvwXcLOnH+Z0REZIaftqlMFkE\nMG/evNZ7XqeYous01LgpycyK6kgTU0QMp++PATcARwCPSpoBkL4/1omyVU2RuZP6lDUmuSnJzFrR\n9hqEpD2AXSLiyfT4T4F/BpYCpwMXpO9fbnfZqmjdGH0Ori2Y2c7oRBPTvsANyv6q3RW4KiK+KemH\nwGJJZwAPAad0oGxdqdE9DXtN6yei+Q1vXqfBzHZW2wMiIn4GHNpg+y+AY9pdnm7X7J6Gx59uPrGe\naw5mNhl8J3WXK7o+Q41HJ5nZZHFAdKmJ3PQm4Pvzjy6vUGbWUxwQXaiVZT/zhgYHSiqRmfUiB0SX\nmchNb+CJ9cxs8jkgukAr6zTUj2L61agn1jOzcjggOqyVdRpmDg64j8HM2sYB0WYTXafBTUhm1m4O\niDaa6DoNvunNzDrBAdEGXqfBzKrIAVGiJSuGOe8rq8a867mRWke1b3ozs05yQJRkovcyOBTMrFs4\nICbZRJuT3JRkZt3GATEJWrmPIa82ism1BjPrRg6IndTKfQw1ri2YWRU4IHbCRKbFGBzoZ8EJBzkc\nzKzrOSBaNNHmJDcjmVnVOCAKWrJimAVLVzEyum3IqpuTzGwqc0CMYaK1Bd/HYGZTgQOiiYl0PkM2\nMumiUw51KJhZ5Tkg6nhaDDOzjAMi8bQYZmbbc0Aw8Wkx9prWz7nHe8iqmU1NPR0QrTYnubZgZr2k\nZwOi1VqDQ8HMek3XBYSk44BPAX3AFyLigsl+j1bugHbHs5n1ql06XYA8SX3AZ4A3AHOB0yTNncz3\nqNUcioTD4EC/w8HMela31SCOANZExM8AJF0DnAjcN1lvcOGNq8dtVnJzkplZ9wXETOCR3PO1wB9M\n5husG6ND2s1JZmbbdFUTUxGSzpS0TNKyjRs3tnz+0OBAw+19ksPBzCyn2wJiGJiVe75f2rZVRCyK\niHkRMW/69Oktv8FZxx7IQH/fdtsG+vs8PYaZWZ1ua2L6ITBH0gFkwXAq8LbJfINaCFx442rWjYwy\n5P4GM7OGuiogImKzpL8DbiQb5vrFiFg12e9z0uEzHQhmZuPoqoAAiIivA1/vdDnMzHpdt/VBmJlZ\nl3BAmJlZQw4IMzNryAFhZmYNKQrMSdStJG0EHmrxtH2An5dQnE7x9XQ3X09369XreUlEjHsjWaUD\nYiIkLYuIeZ0ux2Tx9XQ3X0938/WMzU1MZmbWkAPCzMwa6sWAWNTpAkwyX0938/V0N1/PGHquD8LM\nzIrpxRqEmZkV4IAwM7OGeiYgJB0nabWkNZLmd7o8rZI0S9Jtku6TtErS+9L2vSXdLOkn6ftenS5r\nKyT1SVoh6avpeWWvR9KgpP+S9GNJ90v6w4pfzz+kf2v3Srpa0u5Vux5JX5T0mKR7c9uaXoOks9Nn\nxGpJx3am1M01uZ4L07+5uyXdIGkwt2+nrqcnAkJSH/AZ4A3AXOA0SXM7W6qWbQY+EBFzgVcB70nX\nMB+4JSLmALek51XyPuD+3PMqX8+ngG9GxO8Ah5JdVyWvR9JM4L3AvIg4mGz6/VOp3vVcChxXt63h\nNaT/T6cCB6VzPps+O7rJpex4PTcDB0fEK4D/B5wNk3M9PREQwBHAmoj4WUT8BrgGOLHDZWpJRKyP\niLvS4yfJPnxmkl3HZemwy4CTOlPC1knaD3gT8IXc5kpej6QXAn8MXAIQEb+JiBEqej3JrsCApF2B\nacA6KnY9EfFd4Jd1m5tdw4nANRHxbEQ8AKwh++zoGo2uJyJuiojN6entZCtxwiRcT68ExEzgkdzz\ntWlbJUmaDRwO3AHsGxHr064NwL4dKtZE/AvwQeC53LaqXs8BwEbgP1KT2Rck7UFFrycihoFPAA8D\n64FfRcRNVPR66jS7hqnwOfFu4Bvp8U5fT68ExJQhaU/gOuD9EfFEfl9kY5YrMW5Z0puBxyJiebNj\nqnQ9ZH9t/x7wuYg4HHiKuuaXKl1Papc/kSz4hoA9JL0jf0yVrqeZqXANNZI+TNYUfeVkvWavBMQw\nMCv3fL8D2SuMAAADV0lEQVS0rVIk9ZOFw5URcX3a/KikGWn/DOCxTpWvRUcCJ0h6kKzJ72hJV1Dd\n61kLrI2IO9Lz/yILjKpez+uBByJiY0RsAq4HXk11ryev2TVU9nNC0ruANwNvj203t+309fRKQPwQ\nmCPpAEnPI+u4WdrhMrVEksjat++PiItzu5YCp6fHpwNfbnfZJiIizo6I/SJiNtnv49aIeAfVvZ4N\nwCOSDkybjgHuo6LXQ9a09CpJ09K/vWPI+r2qej15za5hKXCqpN0kHQDMAe7sQPlaIuk4sqbaEyLi\n6dyunb+eiOiJL+CNZD38PwU+3OnyTKD8ryGrCt8NrExfbwReRDYS4yfAt4C9O13WCVzbUcBX0+PK\nXg9wGLAs/Y6WAHtV/HrOA34M3At8CditatcDXE3Wh7KJrJZ3xljXAHw4fUasBt7Q6fIXvJ41ZH0N\ntc+Ff5us6/FUG2Zm1lCvNDGZmVmLHBBmZtaQA8LMzBpyQJiZWUMOCDMza8gBYVZH0hZJK9Mspv8p\naVqL559TVtnM2snDXM3qSPp1ROyZHl8JLI/czYnpxjFFxHPjnW9WZa5BmI3tv4GXSZqd5tS/nOzG\nsVmSTpN0T6ppfBxA0gVkM6CuTOGCpP+ZjrlX0vvTttlpzYjPpzUXbpI0kPa9V9m6H3dLuqYzl23m\nGoTZDmo1gDTN9XXAN8lmyPwZ8OqIuF3SENnUyq8EHgduAv41IpbU1UBeSTaH/6sAkc3A+450zhqy\n9RZWSloMLI2IKyStAw6IiGclDUY2bbhZ27kGYbajAUkryabNeJi0xgPwUETcnh7/PvDtyCazq82g\n+ccNXus1wA0R8VRE/Jps0rs/SvseiIiV6fFyYHZ6fDdwZZo9dTNmHbJrpwtg1oVGI+Kw/Ias24Gn\nJvl9ns093gIMpMdvIgub44EPSzokti0IY9Y2rkGYTcydwGsl7ZOWcTwN+E7atylNzQ5ZH8ZJaVbU\nPYC3pG0NSdoFmBURtwEfAl4IuMPbOsI1CLMJiIj1kuYDt5H1LXwtImrTRi8C7pZ0V0S8XdKlbJtm\n+QsRsSKtCthIH3BFWsJUZP0a7oOwjnAntZmZNeQmJjMza8gBYWZmDTkgzMysIQeEmZk15IAwM7OG\nHBBmZtaQA8LMzBr6/y3sDBpOFh50AAAAAElFTkSuQmCC\n", "text/plain": [ "" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "%matplotlib inline\n", "from matplotlib import pyplot as plt\n", "x_axis = newdf.Protons\n", "y_axis = newdf.Mass\n", "plt.scatter(x_axis, y_axis)\n", "plt.title('Protons versus Atomic Mass')\n", "plt.xlabel('Protons')\n", "plt.ylabel('Mass')\n", "plt.show()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "That's right, atoms get heavier the more protons they have. They have at least as many neutrons as protons, usually, and sometimes more. Remember some elements have isotopes, meaning differing numbers of neutrons for the same atomic number (number of protons, or positive charges in the nucleus)." ] }, { "cell_type": "code", "execution_count": 16, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "Ag KTU\n", "Al KTU\n", "Am KTU\n", "Ar KTU\n", "Name: Initials, dtype: object" ] }, "execution_count": 16, "metadata": {}, "output_type": "execute_result" } ], "source": [ "newdf.Initials[1:5]" ] }, { "cell_type": "code", "execution_count": 24, "metadata": { "collapsed": false }, "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", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
ProtonsSymbolNameMassSeriesUpdatedInitials
H1HHydrogen1.008diatomic nonmetal1498013115KTU
He2HeHelium4.0026noble gas1493462392KTU
Li3LiLithium6.94alkali metal1493462392KTU
Be4BeBeryllium9.01218alkaline earth metal1493462392KTU
B5BBoron10.81metalloid1493462392KTU
C6CCarbon12.011polyatomic nonmetal1493462392KTU
N7NNitrogen14.007diatomic nonmetal1493462392KTU
O8OOxygen15.999diatomic nonmetal1493462392KTU
F9FFluorine18.9984diatomic nonmetal1493462392KTU
Ne10NeNeon20.1798noble gas1493462392KTU
Na11NaSodium22.9898alkali metal1493462392KTU
Mg12MgMagnesium24.305alkaline earth metal1493462392KTU
Al13AlAluminium26.9815post-transition metal1493462392KTU
Si14SiSilicon28.085metalloid1493462392KTU
P15PPhosphorus30.9738polyatomic nonmetal1493462392KTU
S16SSulfur32.06polyatomic nonmetal1493462392KTU
Cl17ClChlorine35.45diatomic nonmetal1493462392KTU
Ar18ArArgon39.9481noble gas1493462392KTU
K19KPotassium39.0983alkali metal1493462392KTU
Ca20CaCalcium40.0784alkaline earth metal1493462392KTU
Sc21ScScandium44.9559transition metal1493462392KTU
Ti22TiTitanium47.8671transition metal1493462392KTU
V23VVanadium50.9415transition metal1493462392KTU
Cr24CrChromium51.9962transition metal1493462392KTU
Mn25MnManganese54.938transition metal1493462392KTU
Fe26FeIron55.8452transition metal1493462392KTU
Co27CoCobalt58.9332transition metal1493462392KTU
Ni28NiNickel58.6934transition metal1493462392KTU
Cu29CuCopper63.5463transition metal1493462392KTU
Zn30ZnZinc65.382transition metal1493462392KTU
........................
Ac89AcActinium227actinide1493462392KTU
Th90ThThorium232.038actinide1493462392KTU
Pa91PaProtactinium231.036actinide1493462392KTU
U92UUranium238.029actinide1493462392KTU
Np93NpNeptunium237actinide1493462392KTU
Pu94PuPlutonium244actinide1493462392KTU
Am95AmAmericium243actinide1493462392KTU
Cm96CmCurium247actinide1493462392KTU
Bk97BkBerkelium247actinide1493462392KTU
Cf98CfCalifornium251actinide1493462392KTU
Es99EsEinsteinium252actinide1493462392KTU
Fm100FmFermium257actinide1493462392KTU
Md101MdMendelevium258actinide1493462392KTU
No102NoNobelium259actinide1493462392KTU
Lr103LrLawrencium266actinide1493462392KTU
Rf104RfRutherfordium267transition metal1493462392KTU
Db105DbDubnium268transition metal1493462392KTU
Sg106SgSeaborgium269transition metal1493462392KTU
Bh107BhBohrium270transition metal1493462392KTU
Hs108HsHassium269transition metal1493462392KTU
Mt109MtMeitnerium278unknown, probably transition metal1493462392KTU
Ds110DsDarmstadtium281unknown, probably transition metal1493462392KTU
Rg111RgRoentgenium282unknown, probably transition metal1493462392KTU
Cn112CnCopernicium285transition metal1493462392KTU
Nh113NhNihonium286unknown, probably transition metal1493462392KTU
Fl114FlFlerovium289post-transition metal1493462392KTU
Mc115McMoscovium289unknown, probably post transition metal1493462392KTU
Lv116LvLivermorium293unknown, probably post transition metal1493462392KTU
Ts117TsTennessine294unknown,probably metalloid1493462392KTU
Og118OgOganesson294unknown, predicted to be noble gas1493462392KTU
\n", "

118 rows × 7 columns

\n", "
" ], "text/plain": [ " Protons Symbol Name Mass \\\n", "H 1 H Hydrogen 1.008 \n", "He 2 He Helium 4.0026 \n", "Li 3 Li Lithium 6.94 \n", "Be 4 Be Beryllium 9.01218 \n", "B 5 B Boron 10.81 \n", "C 6 C Carbon 12.011 \n", "N 7 N Nitrogen 14.007 \n", "O 8 O Oxygen 15.999 \n", "F 9 F Fluorine 18.9984 \n", "Ne 10 Ne Neon 20.1798 \n", "Na 11 Na Sodium 22.9898 \n", "Mg 12 Mg Magnesium 24.305 \n", "Al 13 Al Aluminium 26.9815 \n", "Si 14 Si Silicon 28.085 \n", "P 15 P Phosphorus 30.9738 \n", "S 16 S Sulfur 32.06 \n", "Cl 17 Cl Chlorine 35.45 \n", "Ar 18 Ar Argon 39.9481 \n", "K 19 K Potassium 39.0983 \n", "Ca 20 Ca Calcium 40.0784 \n", "Sc 21 Sc Scandium 44.9559 \n", "Ti 22 Ti Titanium 47.8671 \n", "V 23 V Vanadium 50.9415 \n", "Cr 24 Cr Chromium 51.9962 \n", "Mn 25 Mn Manganese 54.938 \n", "Fe 26 Fe Iron 55.8452 \n", "Co 27 Co Cobalt 58.9332 \n", "Ni 28 Ni Nickel 58.6934 \n", "Cu 29 Cu Copper 63.5463 \n", "Zn 30 Zn Zinc 65.382 \n", ".. ... ... ... ... \n", "Ac 89 Ac Actinium 227 \n", "Th 90 Th Thorium 232.038 \n", "Pa 91 Pa Protactinium 231.036 \n", "U 92 U Uranium 238.029 \n", "Np 93 Np Neptunium 237 \n", "Pu 94 Pu Plutonium 244 \n", "Am 95 Am Americium 243 \n", "Cm 96 Cm Curium 247 \n", "Bk 97 Bk Berkelium 247 \n", "Cf 98 Cf Californium 251 \n", "Es 99 Es Einsteinium 252 \n", "Fm 100 Fm Fermium 257 \n", "Md 101 Md Mendelevium 258 \n", "No 102 No Nobelium 259 \n", "Lr 103 Lr Lawrencium 266 \n", "Rf 104 Rf Rutherfordium 267 \n", "Db 105 Db Dubnium 268 \n", "Sg 106 Sg Seaborgium 269 \n", "Bh 107 Bh Bohrium 270 \n", "Hs 108 Hs Hassium 269 \n", "Mt 109 Mt Meitnerium 278 \n", "Ds 110 Ds Darmstadtium 281 \n", "Rg 111 Rg Roentgenium 282 \n", "Cn 112 Cn Copernicium 285 \n", "Nh 113 Nh Nihonium 286 \n", "Fl 114 Fl Flerovium 289 \n", "Mc 115 Mc Moscovium 289 \n", "Lv 116 Lv Livermorium 293 \n", "Ts 117 Ts Tennessine 294 \n", "Og 118 Og Oganesson 294 \n", "\n", " Series Updated Initials \n", "H diatomic nonmetal 1498013115 KTU \n", "He noble gas 1493462392 KTU \n", "Li alkali metal 1493462392 KTU \n", "Be alkaline earth metal 1493462392 KTU \n", "B metalloid 1493462392 KTU \n", "C polyatomic nonmetal 1493462392 KTU \n", "N diatomic nonmetal 1493462392 KTU \n", "O diatomic nonmetal 1493462392 KTU \n", "F diatomic nonmetal 1493462392 KTU \n", "Ne noble gas 1493462392 KTU \n", "Na alkali metal 1493462392 KTU \n", "Mg alkaline earth metal 1493462392 KTU \n", "Al post-transition metal 1493462392 KTU \n", "Si metalloid 1493462392 KTU \n", "P polyatomic nonmetal 1493462392 KTU \n", "S polyatomic nonmetal 1493462392 KTU \n", "Cl diatomic nonmetal 1493462392 KTU \n", "Ar noble gas 1493462392 KTU \n", "K alkali metal 1493462392 KTU \n", "Ca alkaline earth metal 1493462392 KTU \n", "Sc transition metal 1493462392 KTU \n", "Ti transition metal 1493462392 KTU \n", "V transition metal 1493462392 KTU \n", "Cr transition metal 1493462392 KTU \n", "Mn transition metal 1493462392 KTU \n", "Fe transition metal 1493462392 KTU \n", "Co transition metal 1493462392 KTU \n", "Ni transition metal 1493462392 KTU \n", "Cu transition metal 1493462392 KTU \n", "Zn transition metal 1493462392 KTU \n", ".. ... ... ... \n", "Ac actinide 1493462392 KTU \n", "Th actinide 1493462392 KTU \n", "Pa actinide 1493462392 KTU \n", "U actinide 1493462392 KTU \n", "Np actinide 1493462392 KTU \n", "Pu actinide 1493462392 KTU \n", "Am actinide 1493462392 KTU \n", "Cm actinide 1493462392 KTU \n", "Bk actinide 1493462392 KTU \n", "Cf actinide 1493462392 KTU \n", "Es actinide 1493462392 KTU \n", "Fm actinide 1493462392 KTU \n", "Md actinide 1493462392 KTU \n", "No actinide 1493462392 KTU \n", "Lr actinide 1493462392 KTU \n", "Rf transition metal 1493462392 KTU \n", "Db transition metal 1493462392 KTU \n", "Sg transition metal 1493462392 KTU \n", "Bh transition metal 1493462392 KTU \n", "Hs transition metal 1493462392 KTU \n", "Mt unknown, probably transition metal 1493462392 KTU \n", "Ds unknown, probably transition metal 1493462392 KTU \n", "Rg unknown, probably transition metal 1493462392 KTU \n", "Cn transition metal 1493462392 KTU \n", "Nh unknown, probably transition metal 1493462392 KTU \n", "Fl post-transition metal 1493462392 KTU \n", "Mc unknown, probably post transition metal 1493462392 KTU \n", "Lv unknown, probably post transition metal 1493462392 KTU \n", "Ts unknown,probably metalloid 1493462392 KTU \n", "Og unknown, predicted to be noble gas 1493462392 KTU \n", "\n", "[118 rows x 7 columns]" ] }, "execution_count": 24, "metadata": {}, "output_type": "execute_result" } ], "source": [ "sorted = newdf.sort_values('Protons')\n", "sorted" ] }, { "cell_type": "code", "execution_count": 26, "metadata": { "collapsed": false }, "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", "
ProtonsSymbolNameMassSeriesUpdatedInitials
V23VVanadium50.9415transition metal1493462392KTU
Cr24CrChromium51.9962transition metal1493462392KTU
Mn25MnManganese54.938transition metal1493462392KTU
Fe26FeIron55.8452transition metal1493462392KTU
Co27CoCobalt58.9332transition metal1493462392KTU
\n", "
" ], "text/plain": [ " Protons Symbol Name Mass Series Updated Initials\n", "V 23 V Vanadium 50.9415 transition metal 1493462392 KTU\n", "Cr 24 Cr Chromium 51.9962 transition metal 1493462392 KTU\n", "Mn 25 Mn Manganese 54.938 transition metal 1493462392 KTU\n", "Fe 26 Fe Iron 55.8452 transition metal 1493462392 KTU\n", "Co 27 Co Cobalt 58.9332 transition metal 1493462392 KTU" ] }, "execution_count": 26, "metadata": {}, "output_type": "execute_result" } ], "source": [ "sorted[sorted[\"Protons\"] > 22].head()" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": true }, "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.6.0" } }, "nbformat": 4, "nbformat_minor": 2 }