{
"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",
" Ac | \n",
" Ag | \n",
" Al | \n",
" Am | \n",
" Ar | \n",
" As | \n",
" At | \n",
" Au | \n",
" B | \n",
" Ba | \n",
" ... | \n",
" Tm | \n",
" Ts | \n",
" U | \n",
" V | \n",
" W | \n",
" Xe | \n",
" Y | \n",
" Yb | \n",
" Zn | \n",
" Zr | \n",
"
\n",
" \n",
" \n",
" \n",
" 0 | \n",
" 89 | \n",
" 47 | \n",
" 13 | \n",
" 95 | \n",
" 18 | \n",
" 33 | \n",
" 85 | \n",
" 79 | \n",
" 5 | \n",
" 56 | \n",
" ... | \n",
" 69 | \n",
" 117 | \n",
" 92 | \n",
" 23 | \n",
" 74 | \n",
" 54 | \n",
" 39 | \n",
" 70 | \n",
" 30 | \n",
" 40 | \n",
"
\n",
" \n",
" 1 | \n",
" Ac | \n",
" Ag | \n",
" Al | \n",
" Am | \n",
" Ar | \n",
" As | \n",
" At | \n",
" Au | \n",
" B | \n",
" Ba | \n",
" ... | \n",
" Tm | \n",
" Ts | \n",
" U | \n",
" V | \n",
" W | \n",
" Xe | \n",
" Y | \n",
" Yb | \n",
" Zn | \n",
" Zr | \n",
"
\n",
" \n",
" 2 | \n",
" Actinium | \n",
" Silver | \n",
" Aluminium | \n",
" Americium | \n",
" Argon | \n",
" Arsenic | \n",
" Astatine | \n",
" Gold | \n",
" Boron | \n",
" Barium | \n",
" ... | \n",
" Thulium | \n",
" Tennessine | \n",
" Uranium | \n",
" Vanadium | \n",
" Tungsten | \n",
" Xenon | \n",
" Yttrium | \n",
" Ytterbium | \n",
" Zinc | \n",
" Zirconium | \n",
"
\n",
" \n",
" 3 | \n",
" 227 | \n",
" 107.868 | \n",
" 26.9815 | \n",
" 243 | \n",
" 39.9481 | \n",
" 74.9216 | \n",
" 210 | \n",
" 196.967 | \n",
" 10.81 | \n",
" 137.328 | \n",
" ... | \n",
" 168.934 | \n",
" 294 | \n",
" 238.029 | \n",
" 50.9415 | \n",
" 183.841 | \n",
" 131.294 | \n",
" 88.9058 | \n",
" 173.045 | \n",
" 65.382 | \n",
" 91.2242 | \n",
"
\n",
" \n",
" 4 | \n",
" actinide | \n",
" transition metal | \n",
" post-transition metal | \n",
" actinide | \n",
" noble gas | \n",
" metalloid | \n",
" metalloid | \n",
" transition metal | \n",
" metalloid | \n",
" alkaline earth metal | \n",
" ... | \n",
" lanthanide | \n",
" unknown,probably metalloid | \n",
" actinide | \n",
" transition metal | \n",
" transition metal | \n",
" noble gas | \n",
" transition metal | \n",
" lanthanide | \n",
" transition metal | \n",
" transition metal | \n",
"
\n",
" \n",
" 5 | \n",
" 1493462392 | \n",
" 1493462392 | \n",
" 1493462392 | \n",
" 1493462392 | \n",
" 1493462392 | \n",
" 1493462392 | \n",
" 1493462392 | \n",
" 1493462392 | \n",
" 1493462392 | \n",
" 1493462392 | \n",
" ... | \n",
" 1493462392 | \n",
" 1493462392 | \n",
" 1493462392 | \n",
" 1493462392 | \n",
" 1493462392 | \n",
" 1493462392 | \n",
" 1493462392 | \n",
" 1493462392 | \n",
" 1493462392 | \n",
" 1493462392 | \n",
"
\n",
" \n",
" 6 | \n",
" KTU | \n",
" KTU | \n",
" KTU | \n",
" KTU | \n",
" KTU | \n",
" KTU | \n",
" KTU | \n",
" KTU | \n",
" KTU | \n",
" KTU | \n",
" ... | \n",
" KTU | \n",
" KTU | \n",
" KTU | \n",
" KTU | \n",
" KTU | \n",
" KTU | \n",
" KTU | \n",
" KTU | \n",
" KTU | \n",
" KTU | \n",
"
\n",
" \n",
"
\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",
" 0 | \n",
" 1 | \n",
" 2 | \n",
" 3 | \n",
" 4 | \n",
" 5 | \n",
" 6 | \n",
"
\n",
" \n",
" \n",
" \n",
" Ac | \n",
" 89 | \n",
" Ac | \n",
" Actinium | \n",
" 227 | \n",
" actinide | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Ag | \n",
" 47 | \n",
" Ag | \n",
" Silver | \n",
" 107.868 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Al | \n",
" 13 | \n",
" Al | \n",
" Aluminium | \n",
" 26.9815 | \n",
" post-transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Am | \n",
" 95 | \n",
" Am | \n",
" Americium | \n",
" 243 | \n",
" actinide | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Ar | \n",
" 18 | \n",
" Ar | \n",
" Argon | \n",
" 39.9481 | \n",
" noble gas | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" As | \n",
" 33 | \n",
" As | \n",
" Arsenic | \n",
" 74.9216 | \n",
" metalloid | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" At | \n",
" 85 | \n",
" At | \n",
" Astatine | \n",
" 210 | \n",
" metalloid | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Au | \n",
" 79 | \n",
" Au | \n",
" Gold | \n",
" 196.967 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" B | \n",
" 5 | \n",
" B | \n",
" Boron | \n",
" 10.81 | \n",
" metalloid | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Ba | \n",
" 56 | \n",
" Ba | \n",
" Barium | \n",
" 137.328 | \n",
" alkaline earth metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Be | \n",
" 4 | \n",
" Be | \n",
" Beryllium | \n",
" 9.01218 | \n",
" alkaline earth metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Bh | \n",
" 107 | \n",
" Bh | \n",
" Bohrium | \n",
" 270 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Bi | \n",
" 83 | \n",
" Bi | \n",
" Bismuth | \n",
" 208.98 | \n",
" post-transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Bk | \n",
" 97 | \n",
" Bk | \n",
" Berkelium | \n",
" 247 | \n",
" actinide | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Br | \n",
" 35 | \n",
" Br | \n",
" Bromine | \n",
" 79.904 | \n",
" diatomic nonmetal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" C | \n",
" 6 | \n",
" C | \n",
" Carbon | \n",
" 12.011 | \n",
" polyatomic nonmetal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Ca | \n",
" 20 | \n",
" Ca | \n",
" Calcium | \n",
" 40.0784 | \n",
" alkaline earth metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Cd | \n",
" 48 | \n",
" Cd | \n",
" Cadmium | \n",
" 112.414 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Ce | \n",
" 58 | \n",
" Ce | \n",
" Cerium | \n",
" 140.116 | \n",
" lanthanide | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Cf | \n",
" 98 | \n",
" Cf | \n",
" Californium | \n",
" 251 | \n",
" actinide | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Cl | \n",
" 17 | \n",
" Cl | \n",
" Chlorine | \n",
" 35.45 | \n",
" diatomic nonmetal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Cm | \n",
" 96 | \n",
" Cm | \n",
" Curium | \n",
" 247 | \n",
" actinide | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Cn | \n",
" 112 | \n",
" Cn | \n",
" Copernicium | \n",
" 285 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Co | \n",
" 27 | \n",
" Co | \n",
" Cobalt | \n",
" 58.9332 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Cr | \n",
" 24 | \n",
" Cr | \n",
" Chromium | \n",
" 51.9962 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Cs | \n",
" 55 | \n",
" Cs | \n",
" Cesium | \n",
" 132.905 | \n",
" alkali metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Cu | \n",
" 29 | \n",
" Cu | \n",
" Copper | \n",
" 63.5463 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Db | \n",
" 105 | \n",
" Db | \n",
" Dubnium | \n",
" 268 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Ds | \n",
" 110 | \n",
" Ds | \n",
" Darmstadtium | \n",
" 281 | \n",
" unknown, probably transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Dy | \n",
" 66 | \n",
" Dy | \n",
" Dysprosium | \n",
" 162.5 | \n",
" lanthanide | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
"
\n",
" \n",
" Rg | \n",
" 111 | \n",
" Rg | \n",
" Roentgenium | \n",
" 282 | \n",
" unknown, probably transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Rh | \n",
" 45 | \n",
" Rh | \n",
" Rhodium | \n",
" 102.906 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Rn | \n",
" 86 | \n",
" Rn | \n",
" Radon | \n",
" 222 | \n",
" noble gas | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Ru | \n",
" 44 | \n",
" Ru | \n",
" Ruthenium | \n",
" 101.072 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" S | \n",
" 16 | \n",
" S | \n",
" Sulfur | \n",
" 32.06 | \n",
" polyatomic nonmetal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Sb | \n",
" 51 | \n",
" Sb | \n",
" Antimony | \n",
" 121.76 | \n",
" metalloid | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Sc | \n",
" 21 | \n",
" Sc | \n",
" Scandium | \n",
" 44.9559 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Se | \n",
" 34 | \n",
" Se | \n",
" Selenium | \n",
" 78.9718 | \n",
" polyatomic nonmetal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Sg | \n",
" 106 | \n",
" Sg | \n",
" Seaborgium | \n",
" 269 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Si | \n",
" 14 | \n",
" Si | \n",
" Silicon | \n",
" 28.085 | \n",
" metalloid | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Sm | \n",
" 62 | \n",
" Sm | \n",
" Samarium | \n",
" 150.362 | \n",
" lanthanide | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Sn | \n",
" 50 | \n",
" Sn | \n",
" Tin | \n",
" 118.711 | \n",
" post-transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Sr | \n",
" 38 | \n",
" Sr | \n",
" Strontium | \n",
" 87.621 | \n",
" alkaline earth metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Ta | \n",
" 73 | \n",
" Ta | \n",
" Tantalum | \n",
" 180.948 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Tb | \n",
" 65 | \n",
" Tb | \n",
" Terbium | \n",
" 158.925 | \n",
" lanthanide | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Tc | \n",
" 43 | \n",
" Tc | \n",
" Technetium | \n",
" 98 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Te | \n",
" 52 | \n",
" Te | \n",
" Tellurium | \n",
" 127.603 | \n",
" metalloid | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Th | \n",
" 90 | \n",
" Th | \n",
" Thorium | \n",
" 232.038 | \n",
" actinide | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Ti | \n",
" 22 | \n",
" Ti | \n",
" Titanium | \n",
" 47.8671 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Tl | \n",
" 81 | \n",
" Tl | \n",
" Thallium | \n",
" 204.38 | \n",
" post-transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Tm | \n",
" 69 | \n",
" Tm | \n",
" Thulium | \n",
" 168.934 | \n",
" lanthanide | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Ts | \n",
" 117 | \n",
" Ts | \n",
" Tennessine | \n",
" 294 | \n",
" unknown,probably metalloid | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" U | \n",
" 92 | \n",
" U | \n",
" Uranium | \n",
" 238.029 | \n",
" actinide | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" V | \n",
" 23 | \n",
" V | \n",
" Vanadium | \n",
" 50.9415 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" W | \n",
" 74 | \n",
" W | \n",
" Tungsten | \n",
" 183.841 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Xe | \n",
" 54 | \n",
" Xe | \n",
" Xenon | \n",
" 131.294 | \n",
" noble gas | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Y | \n",
" 39 | \n",
" Y | \n",
" Yttrium | \n",
" 88.9058 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Yb | \n",
" 70 | \n",
" Yb | \n",
" Ytterbium | \n",
" 173.045 | \n",
" lanthanide | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Zn | \n",
" 30 | \n",
" Zn | \n",
" Zinc | \n",
" 65.382 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Zr | \n",
" 40 | \n",
" Zr | \n",
" Zirconium | \n",
" 91.2242 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
"
\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",
" Protons | \n",
" Symbol | \n",
" Name | \n",
" Mass | \n",
" Series | \n",
" Updated | \n",
" Initials | \n",
"
\n",
" \n",
" \n",
" \n",
" Ac | \n",
" 89 | \n",
" Ac | \n",
" Actinium | \n",
" 227 | \n",
" actinide | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Ag | \n",
" 47 | \n",
" Ag | \n",
" Silver | \n",
" 107.868 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Al | \n",
" 13 | \n",
" Al | \n",
" Aluminium | \n",
" 26.9815 | \n",
" post-transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Am | \n",
" 95 | \n",
" Am | \n",
" Americium | \n",
" 243 | \n",
" actinide | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Ar | \n",
" 18 | \n",
" Ar | \n",
" Argon | \n",
" 39.9481 | \n",
" noble gas | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" As | \n",
" 33 | \n",
" As | \n",
" Arsenic | \n",
" 74.9216 | \n",
" metalloid | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" At | \n",
" 85 | \n",
" At | \n",
" Astatine | \n",
" 210 | \n",
" metalloid | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Au | \n",
" 79 | \n",
" Au | \n",
" Gold | \n",
" 196.967 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" B | \n",
" 5 | \n",
" B | \n",
" Boron | \n",
" 10.81 | \n",
" metalloid | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Ba | \n",
" 56 | \n",
" Ba | \n",
" Barium | \n",
" 137.328 | \n",
" alkaline earth metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Be | \n",
" 4 | \n",
" Be | \n",
" Beryllium | \n",
" 9.01218 | \n",
" alkaline earth metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Bh | \n",
" 107 | \n",
" Bh | \n",
" Bohrium | \n",
" 270 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Bi | \n",
" 83 | \n",
" Bi | \n",
" Bismuth | \n",
" 208.98 | \n",
" post-transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Bk | \n",
" 97 | \n",
" Bk | \n",
" Berkelium | \n",
" 247 | \n",
" actinide | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Br | \n",
" 35 | \n",
" Br | \n",
" Bromine | \n",
" 79.904 | \n",
" diatomic nonmetal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" C | \n",
" 6 | \n",
" C | \n",
" Carbon | \n",
" 12.011 | \n",
" polyatomic nonmetal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Ca | \n",
" 20 | \n",
" Ca | \n",
" Calcium | \n",
" 40.0784 | \n",
" alkaline earth metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Cd | \n",
" 48 | \n",
" Cd | \n",
" Cadmium | \n",
" 112.414 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Ce | \n",
" 58 | \n",
" Ce | \n",
" Cerium | \n",
" 140.116 | \n",
" lanthanide | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Cf | \n",
" 98 | \n",
" Cf | \n",
" Californium | \n",
" 251 | \n",
" actinide | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Cl | \n",
" 17 | \n",
" Cl | \n",
" Chlorine | \n",
" 35.45 | \n",
" diatomic nonmetal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Cm | \n",
" 96 | \n",
" Cm | \n",
" Curium | \n",
" 247 | \n",
" actinide | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Cn | \n",
" 112 | \n",
" Cn | \n",
" Copernicium | \n",
" 285 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Co | \n",
" 27 | \n",
" Co | \n",
" Cobalt | \n",
" 58.9332 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Cr | \n",
" 24 | \n",
" Cr | \n",
" Chromium | \n",
" 51.9962 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Cs | \n",
" 55 | \n",
" Cs | \n",
" Cesium | \n",
" 132.905 | \n",
" alkali metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Cu | \n",
" 29 | \n",
" Cu | \n",
" Copper | \n",
" 63.5463 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Db | \n",
" 105 | \n",
" Db | \n",
" Dubnium | \n",
" 268 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Ds | \n",
" 110 | \n",
" Ds | \n",
" Darmstadtium | \n",
" 281 | \n",
" unknown, probably transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Dy | \n",
" 66 | \n",
" Dy | \n",
" Dysprosium | \n",
" 162.5 | \n",
" lanthanide | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
"
\n",
" \n",
" Rg | \n",
" 111 | \n",
" Rg | \n",
" Roentgenium | \n",
" 282 | \n",
" unknown, probably transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Rh | \n",
" 45 | \n",
" Rh | \n",
" Rhodium | \n",
" 102.906 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Rn | \n",
" 86 | \n",
" Rn | \n",
" Radon | \n",
" 222 | \n",
" noble gas | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Ru | \n",
" 44 | \n",
" Ru | \n",
" Ruthenium | \n",
" 101.072 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" S | \n",
" 16 | \n",
" S | \n",
" Sulfur | \n",
" 32.06 | \n",
" polyatomic nonmetal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Sb | \n",
" 51 | \n",
" Sb | \n",
" Antimony | \n",
" 121.76 | \n",
" metalloid | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Sc | \n",
" 21 | \n",
" Sc | \n",
" Scandium | \n",
" 44.9559 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Se | \n",
" 34 | \n",
" Se | \n",
" Selenium | \n",
" 78.9718 | \n",
" polyatomic nonmetal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Sg | \n",
" 106 | \n",
" Sg | \n",
" Seaborgium | \n",
" 269 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Si | \n",
" 14 | \n",
" Si | \n",
" Silicon | \n",
" 28.085 | \n",
" metalloid | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Sm | \n",
" 62 | \n",
" Sm | \n",
" Samarium | \n",
" 150.362 | \n",
" lanthanide | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Sn | \n",
" 50 | \n",
" Sn | \n",
" Tin | \n",
" 118.711 | \n",
" post-transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Sr | \n",
" 38 | \n",
" Sr | \n",
" Strontium | \n",
" 87.621 | \n",
" alkaline earth metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Ta | \n",
" 73 | \n",
" Ta | \n",
" Tantalum | \n",
" 180.948 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Tb | \n",
" 65 | \n",
" Tb | \n",
" Terbium | \n",
" 158.925 | \n",
" lanthanide | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Tc | \n",
" 43 | \n",
" Tc | \n",
" Technetium | \n",
" 98 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Te | \n",
" 52 | \n",
" Te | \n",
" Tellurium | \n",
" 127.603 | \n",
" metalloid | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Th | \n",
" 90 | \n",
" Th | \n",
" Thorium | \n",
" 232.038 | \n",
" actinide | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Ti | \n",
" 22 | \n",
" Ti | \n",
" Titanium | \n",
" 47.8671 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Tl | \n",
" 81 | \n",
" Tl | \n",
" Thallium | \n",
" 204.38 | \n",
" post-transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Tm | \n",
" 69 | \n",
" Tm | \n",
" Thulium | \n",
" 168.934 | \n",
" lanthanide | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Ts | \n",
" 117 | \n",
" Ts | \n",
" Tennessine | \n",
" 294 | \n",
" unknown,probably metalloid | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" U | \n",
" 92 | \n",
" U | \n",
" Uranium | \n",
" 238.029 | \n",
" actinide | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" V | \n",
" 23 | \n",
" V | \n",
" Vanadium | \n",
" 50.9415 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" W | \n",
" 74 | \n",
" W | \n",
" Tungsten | \n",
" 183.841 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Xe | \n",
" 54 | \n",
" Xe | \n",
" Xenon | \n",
" 131.294 | \n",
" noble gas | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Y | \n",
" 39 | \n",
" Y | \n",
" Yttrium | \n",
" 88.9058 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Yb | \n",
" 70 | \n",
" Yb | \n",
" Ytterbium | \n",
" 173.045 | \n",
" lanthanide | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Zn | \n",
" 30 | \n",
" Zn | \n",
" Zinc | \n",
" 65.382 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Zr | \n",
" 40 | \n",
" Zr | \n",
" Zirconium | \n",
" 91.2242 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
"
\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",
" Protons | \n",
" Symbol | \n",
" Name | \n",
"
\n",
" \n",
" \n",
" \n",
" Ac | \n",
" 89 | \n",
" Ac | \n",
" Actinium | \n",
"
\n",
" \n",
" Ag | \n",
" 47 | \n",
" Ag | \n",
" Silver | \n",
"
\n",
" \n",
" Al | \n",
" 13 | \n",
" Al | \n",
" Aluminium | \n",
"
\n",
" \n",
" Am | \n",
" 95 | \n",
" Am | \n",
" Americium | \n",
"
\n",
" \n",
" Ar | \n",
" 18 | \n",
" Ar | \n",
" Argon | \n",
"
\n",
" \n",
" As | \n",
" 33 | \n",
" As | \n",
" Arsenic | \n",
"
\n",
" \n",
" At | \n",
" 85 | \n",
" At | \n",
" Astatine | \n",
"
\n",
" \n",
" Au | \n",
" 79 | \n",
" Au | \n",
" Gold | \n",
"
\n",
" \n",
" B | \n",
" 5 | \n",
" B | \n",
" Boron | \n",
"
\n",
" \n",
" Ba | \n",
" 56 | \n",
" Ba | \n",
" Barium | \n",
"
\n",
" \n",
"
\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",
" Protons | \n",
" Symbol | \n",
" Name | \n",
" Mass | \n",
" Series | \n",
" Updated | \n",
" Initials | \n",
"
\n",
" \n",
" \n",
" \n",
" H | \n",
" 1 | \n",
" H | \n",
" Hydrogen | \n",
" 1.008 | \n",
" diatomic nonmetal | \n",
" 1498013115 | \n",
" KTU | \n",
"
\n",
" \n",
" He | \n",
" 2 | \n",
" He | \n",
" Helium | \n",
" 4.0026 | \n",
" noble gas | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Li | \n",
" 3 | \n",
" Li | \n",
" Lithium | \n",
" 6.94 | \n",
" alkali metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Be | \n",
" 4 | \n",
" Be | \n",
" Beryllium | \n",
" 9.01218 | \n",
" alkaline earth metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" B | \n",
" 5 | \n",
" B | \n",
" Boron | \n",
" 10.81 | \n",
" metalloid | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" C | \n",
" 6 | \n",
" C | \n",
" Carbon | \n",
" 12.011 | \n",
" polyatomic nonmetal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" N | \n",
" 7 | \n",
" N | \n",
" Nitrogen | \n",
" 14.007 | \n",
" diatomic nonmetal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" O | \n",
" 8 | \n",
" O | \n",
" Oxygen | \n",
" 15.999 | \n",
" diatomic nonmetal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" F | \n",
" 9 | \n",
" F | \n",
" Fluorine | \n",
" 18.9984 | \n",
" diatomic nonmetal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Ne | \n",
" 10 | \n",
" Ne | \n",
" Neon | \n",
" 20.1798 | \n",
" noble gas | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Na | \n",
" 11 | \n",
" Na | \n",
" Sodium | \n",
" 22.9898 | \n",
" alkali metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Mg | \n",
" 12 | \n",
" Mg | \n",
" Magnesium | \n",
" 24.305 | \n",
" alkaline earth metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Al | \n",
" 13 | \n",
" Al | \n",
" Aluminium | \n",
" 26.9815 | \n",
" post-transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Si | \n",
" 14 | \n",
" Si | \n",
" Silicon | \n",
" 28.085 | \n",
" metalloid | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" P | \n",
" 15 | \n",
" P | \n",
" Phosphorus | \n",
" 30.9738 | \n",
" polyatomic nonmetal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" S | \n",
" 16 | \n",
" S | \n",
" Sulfur | \n",
" 32.06 | \n",
" polyatomic nonmetal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Cl | \n",
" 17 | \n",
" Cl | \n",
" Chlorine | \n",
" 35.45 | \n",
" diatomic nonmetal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Ar | \n",
" 18 | \n",
" Ar | \n",
" Argon | \n",
" 39.9481 | \n",
" noble gas | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" K | \n",
" 19 | \n",
" K | \n",
" Potassium | \n",
" 39.0983 | \n",
" alkali metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Ca | \n",
" 20 | \n",
" Ca | \n",
" Calcium | \n",
" 40.0784 | \n",
" alkaline earth metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Sc | \n",
" 21 | \n",
" Sc | \n",
" Scandium | \n",
" 44.9559 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Ti | \n",
" 22 | \n",
" Ti | \n",
" Titanium | \n",
" 47.8671 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" V | \n",
" 23 | \n",
" V | \n",
" Vanadium | \n",
" 50.9415 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Cr | \n",
" 24 | \n",
" Cr | \n",
" Chromium | \n",
" 51.9962 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Mn | \n",
" 25 | \n",
" Mn | \n",
" Manganese | \n",
" 54.938 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Fe | \n",
" 26 | \n",
" Fe | \n",
" Iron | \n",
" 55.8452 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Co | \n",
" 27 | \n",
" Co | \n",
" Cobalt | \n",
" 58.9332 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Ni | \n",
" 28 | \n",
" Ni | \n",
" Nickel | \n",
" 58.6934 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Cu | \n",
" 29 | \n",
" Cu | \n",
" Copper | \n",
" 63.5463 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Zn | \n",
" 30 | \n",
" Zn | \n",
" Zinc | \n",
" 65.382 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
"
\n",
" \n",
" Ac | \n",
" 89 | \n",
" Ac | \n",
" Actinium | \n",
" 227 | \n",
" actinide | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Th | \n",
" 90 | \n",
" Th | \n",
" Thorium | \n",
" 232.038 | \n",
" actinide | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Pa | \n",
" 91 | \n",
" Pa | \n",
" Protactinium | \n",
" 231.036 | \n",
" actinide | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" U | \n",
" 92 | \n",
" U | \n",
" Uranium | \n",
" 238.029 | \n",
" actinide | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Np | \n",
" 93 | \n",
" Np | \n",
" Neptunium | \n",
" 237 | \n",
" actinide | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Pu | \n",
" 94 | \n",
" Pu | \n",
" Plutonium | \n",
" 244 | \n",
" actinide | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Am | \n",
" 95 | \n",
" Am | \n",
" Americium | \n",
" 243 | \n",
" actinide | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Cm | \n",
" 96 | \n",
" Cm | \n",
" Curium | \n",
" 247 | \n",
" actinide | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Bk | \n",
" 97 | \n",
" Bk | \n",
" Berkelium | \n",
" 247 | \n",
" actinide | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Cf | \n",
" 98 | \n",
" Cf | \n",
" Californium | \n",
" 251 | \n",
" actinide | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Es | \n",
" 99 | \n",
" Es | \n",
" Einsteinium | \n",
" 252 | \n",
" actinide | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Fm | \n",
" 100 | \n",
" Fm | \n",
" Fermium | \n",
" 257 | \n",
" actinide | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Md | \n",
" 101 | \n",
" Md | \n",
" Mendelevium | \n",
" 258 | \n",
" actinide | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" No | \n",
" 102 | \n",
" No | \n",
" Nobelium | \n",
" 259 | \n",
" actinide | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Lr | \n",
" 103 | \n",
" Lr | \n",
" Lawrencium | \n",
" 266 | \n",
" actinide | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Rf | \n",
" 104 | \n",
" Rf | \n",
" Rutherfordium | \n",
" 267 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Db | \n",
" 105 | \n",
" Db | \n",
" Dubnium | \n",
" 268 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Sg | \n",
" 106 | \n",
" Sg | \n",
" Seaborgium | \n",
" 269 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Bh | \n",
" 107 | \n",
" Bh | \n",
" Bohrium | \n",
" 270 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Hs | \n",
" 108 | \n",
" Hs | \n",
" Hassium | \n",
" 269 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Mt | \n",
" 109 | \n",
" Mt | \n",
" Meitnerium | \n",
" 278 | \n",
" unknown, probably transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Ds | \n",
" 110 | \n",
" Ds | \n",
" Darmstadtium | \n",
" 281 | \n",
" unknown, probably transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Rg | \n",
" 111 | \n",
" Rg | \n",
" Roentgenium | \n",
" 282 | \n",
" unknown, probably transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Cn | \n",
" 112 | \n",
" Cn | \n",
" Copernicium | \n",
" 285 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Nh | \n",
" 113 | \n",
" Nh | \n",
" Nihonium | \n",
" 286 | \n",
" unknown, probably transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Fl | \n",
" 114 | \n",
" Fl | \n",
" Flerovium | \n",
" 289 | \n",
" post-transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Mc | \n",
" 115 | \n",
" Mc | \n",
" Moscovium | \n",
" 289 | \n",
" unknown, probably post transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Lv | \n",
" 116 | \n",
" Lv | \n",
" Livermorium | \n",
" 293 | \n",
" unknown, probably post transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Ts | \n",
" 117 | \n",
" Ts | \n",
" Tennessine | \n",
" 294 | \n",
" unknown,probably metalloid | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Og | \n",
" 118 | \n",
" Og | \n",
" Oganesson | \n",
" 294 | \n",
" unknown, predicted to be noble gas | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
"
\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",
" Protons | \n",
" Symbol | \n",
" Name | \n",
" Mass | \n",
" Series | \n",
" Updated | \n",
" Initials | \n",
"
\n",
" \n",
" \n",
" \n",
" H | \n",
" 1 | \n",
" H | \n",
" Hydrogen | \n",
" 1.008 | \n",
" diatomic nonmetal | \n",
" 1498013115 | \n",
" KTU | \n",
"
\n",
" \n",
" He | \n",
" 2 | \n",
" He | \n",
" Helium | \n",
" 4.0026 | \n",
" noble gas | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Li | \n",
" 3 | \n",
" Li | \n",
" Lithium | \n",
" 6.94 | \n",
" alkali metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Be | \n",
" 4 | \n",
" Be | \n",
" Beryllium | \n",
" 9.01218 | \n",
" alkaline earth metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" B | \n",
" 5 | \n",
" B | \n",
" Boron | \n",
" 10.81 | \n",
" metalloid | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" C | \n",
" 6 | \n",
" C | \n",
" Carbon | \n",
" 12.011 | \n",
" polyatomic nonmetal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" N | \n",
" 7 | \n",
" N | \n",
" Nitrogen | \n",
" 14.007 | \n",
" diatomic nonmetal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" O | \n",
" 8 | \n",
" O | \n",
" Oxygen | \n",
" 15.999 | \n",
" diatomic nonmetal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" F | \n",
" 9 | \n",
" F | \n",
" Fluorine | \n",
" 18.9984 | \n",
" diatomic nonmetal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Ne | \n",
" 10 | \n",
" Ne | \n",
" Neon | \n",
" 20.1798 | \n",
" noble gas | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Na | \n",
" 11 | \n",
" Na | \n",
" Sodium | \n",
" 22.9898 | \n",
" alkali metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Mg | \n",
" 12 | \n",
" Mg | \n",
" Magnesium | \n",
" 24.305 | \n",
" alkaline earth metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Al | \n",
" 13 | \n",
" Al | \n",
" Aluminium | \n",
" 26.9815 | \n",
" post-transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Si | \n",
" 14 | \n",
" Si | \n",
" Silicon | \n",
" 28.085 | \n",
" metalloid | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" P | \n",
" 15 | \n",
" P | \n",
" Phosphorus | \n",
" 30.9738 | \n",
" polyatomic nonmetal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" S | \n",
" 16 | \n",
" S | \n",
" Sulfur | \n",
" 32.06 | \n",
" polyatomic nonmetal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Cl | \n",
" 17 | \n",
" Cl | \n",
" Chlorine | \n",
" 35.45 | \n",
" diatomic nonmetal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Ar | \n",
" 18 | \n",
" Ar | \n",
" Argon | \n",
" 39.9481 | \n",
" noble gas | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" K | \n",
" 19 | \n",
" K | \n",
" Potassium | \n",
" 39.0983 | \n",
" alkali metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Ca | \n",
" 20 | \n",
" Ca | \n",
" Calcium | \n",
" 40.0784 | \n",
" alkaline earth metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Sc | \n",
" 21 | \n",
" Sc | \n",
" Scandium | \n",
" 44.9559 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Ti | \n",
" 22 | \n",
" Ti | \n",
" Titanium | \n",
" 47.8671 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" V | \n",
" 23 | \n",
" V | \n",
" Vanadium | \n",
" 50.9415 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Cr | \n",
" 24 | \n",
" Cr | \n",
" Chromium | \n",
" 51.9962 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Mn | \n",
" 25 | \n",
" Mn | \n",
" Manganese | \n",
" 54.938 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Fe | \n",
" 26 | \n",
" Fe | \n",
" Iron | \n",
" 55.8452 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Co | \n",
" 27 | \n",
" Co | \n",
" Cobalt | \n",
" 58.9332 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Ni | \n",
" 28 | \n",
" Ni | \n",
" Nickel | \n",
" 58.6934 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Cu | \n",
" 29 | \n",
" Cu | \n",
" Copper | \n",
" 63.5463 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Zn | \n",
" 30 | \n",
" Zn | \n",
" Zinc | \n",
" 65.382 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
"
\n",
" \n",
" Ac | \n",
" 89 | \n",
" Ac | \n",
" Actinium | \n",
" 227 | \n",
" actinide | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Th | \n",
" 90 | \n",
" Th | \n",
" Thorium | \n",
" 232.038 | \n",
" actinide | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Pa | \n",
" 91 | \n",
" Pa | \n",
" Protactinium | \n",
" 231.036 | \n",
" actinide | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" U | \n",
" 92 | \n",
" U | \n",
" Uranium | \n",
" 238.029 | \n",
" actinide | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Np | \n",
" 93 | \n",
" Np | \n",
" Neptunium | \n",
" 237 | \n",
" actinide | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Pu | \n",
" 94 | \n",
" Pu | \n",
" Plutonium | \n",
" 244 | \n",
" actinide | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Am | \n",
" 95 | \n",
" Am | \n",
" Americium | \n",
" 243 | \n",
" actinide | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Cm | \n",
" 96 | \n",
" Cm | \n",
" Curium | \n",
" 247 | \n",
" actinide | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Bk | \n",
" 97 | \n",
" Bk | \n",
" Berkelium | \n",
" 247 | \n",
" actinide | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Cf | \n",
" 98 | \n",
" Cf | \n",
" Californium | \n",
" 251 | \n",
" actinide | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Es | \n",
" 99 | \n",
" Es | \n",
" Einsteinium | \n",
" 252 | \n",
" actinide | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Fm | \n",
" 100 | \n",
" Fm | \n",
" Fermium | \n",
" 257 | \n",
" actinide | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Md | \n",
" 101 | \n",
" Md | \n",
" Mendelevium | \n",
" 258 | \n",
" actinide | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" No | \n",
" 102 | \n",
" No | \n",
" Nobelium | \n",
" 259 | \n",
" actinide | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Lr | \n",
" 103 | \n",
" Lr | \n",
" Lawrencium | \n",
" 266 | \n",
" actinide | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Rf | \n",
" 104 | \n",
" Rf | \n",
" Rutherfordium | \n",
" 267 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Db | \n",
" 105 | \n",
" Db | \n",
" Dubnium | \n",
" 268 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Sg | \n",
" 106 | \n",
" Sg | \n",
" Seaborgium | \n",
" 269 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Bh | \n",
" 107 | \n",
" Bh | \n",
" Bohrium | \n",
" 270 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Hs | \n",
" 108 | \n",
" Hs | \n",
" Hassium | \n",
" 269 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Mt | \n",
" 109 | \n",
" Mt | \n",
" Meitnerium | \n",
" 278 | \n",
" unknown, probably transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Ds | \n",
" 110 | \n",
" Ds | \n",
" Darmstadtium | \n",
" 281 | \n",
" unknown, probably transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Rg | \n",
" 111 | \n",
" Rg | \n",
" Roentgenium | \n",
" 282 | \n",
" unknown, probably transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Cn | \n",
" 112 | \n",
" Cn | \n",
" Copernicium | \n",
" 285 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Nh | \n",
" 113 | \n",
" Nh | \n",
" Nihonium | \n",
" 286 | \n",
" unknown, probably transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Fl | \n",
" 114 | \n",
" Fl | \n",
" Flerovium | \n",
" 289 | \n",
" post-transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Mc | \n",
" 115 | \n",
" Mc | \n",
" Moscovium | \n",
" 289 | \n",
" unknown, probably post transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Lv | \n",
" 116 | \n",
" Lv | \n",
" Livermorium | \n",
" 293 | \n",
" unknown, probably post transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Ts | \n",
" 117 | \n",
" Ts | \n",
" Tennessine | \n",
" 294 | \n",
" unknown,probably metalloid | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Og | \n",
" 118 | \n",
" Og | \n",
" Oganesson | \n",
" 294 | \n",
" unknown, predicted to be noble gas | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
"
\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",
" Protons | \n",
" Symbol | \n",
" Name | \n",
" Mass | \n",
" Series | \n",
" Updated | \n",
" Initials | \n",
"
\n",
" \n",
" \n",
" \n",
" V | \n",
" 23 | \n",
" V | \n",
" Vanadium | \n",
" 50.9415 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Cr | \n",
" 24 | \n",
" Cr | \n",
" Chromium | \n",
" 51.9962 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Mn | \n",
" 25 | \n",
" Mn | \n",
" Manganese | \n",
" 54.938 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Fe | \n",
" 26 | \n",
" Fe | \n",
" Iron | \n",
" 55.8452 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
" Co | \n",
" 27 | \n",
" Co | \n",
" Cobalt | \n",
" 58.9332 | \n",
" transition metal | \n",
" 1493462392 | \n",
" KTU | \n",
"
\n",
" \n",
"
\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
}