Pandas_read_csv.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'0.21.0'"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.__version__"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [],
   "source": [
    "Yeast_10_6_order_10ul_x5 = pd.read_csv('Yeast_10_6_order_10ul_x10.csv',low_memory=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(4098, 3599)"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Yeast_10_6_order_10ul_x5.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "tempSample = Yeast_10_6_order_10ul_x5.loc[1:, ['Unnamed: 1','Unnamed: 4','Unnamed: 7','Unnamed: 10']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 1</th>\n",
       "      <th>Unnamed: 4</th>\n",
       "      <th>Unnamed: 7</th>\n",
       "      <th>Unnamed: 10</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Terahertz signal (a.u.)</td>\n",
       "      <td>Electric field (a.u.)</td>\n",
       "      <td>Transmittance</td>\n",
       "      <td>Absorbance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>-0.01804322</td>\n",
       "      <td>6.88203</td>\n",
       "      <td>2.673557</td>\n",
       "      <td>-0.4270894</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>-0.02111875</td>\n",
       "      <td>0.6927925</td>\n",
       "      <td>0.2033236</td>\n",
       "      <td>0.6918122</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>-0.01681809</td>\n",
       "      <td>0.8349739</td>\n",
       "      <td>1.401699</td>\n",
       "      <td>-0.1466547</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>-0.02208075</td>\n",
       "      <td>1.920209</td>\n",
       "      <td>0.8537656</td>\n",
       "      <td>0.06866135</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>-0.02494478</td>\n",
       "      <td>3.712943</td>\n",
       "      <td>0.7183219</td>\n",
       "      <td>0.1436809</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>-0.02022591</td>\n",
       "      <td>5.51333</td>\n",
       "      <td>0.7679713</td>\n",
       "      <td>0.114655</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>-0.02351194</td>\n",
       "      <td>6.496024</td>\n",
       "      <td>0.8877195</td>\n",
       "      <td>0.05172426</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>-0.02092568</td>\n",
       "      <td>6.40656</td>\n",
       "      <td>0.9930028</td>\n",
       "      <td>0.003049539</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>-0.02455329</td>\n",
       "      <td>5.740438</td>\n",
       "      <td>0.9894645</td>\n",
       "      <td>0.004599799</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>-0.02123577</td>\n",
       "      <td>5.192579</td>\n",
       "      <td>0.9435052</td>\n",
       "      <td>0.02525569</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>-0.02220568</td>\n",
       "      <td>4.995144</td>\n",
       "      <td>0.9972789</td>\n",
       "      <td>0.001183383</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>-0.02519521</td>\n",
       "      <td>4.863997</td>\n",
       "      <td>1.146931</td>\n",
       "      <td>-0.05953745</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>-0.02504743</td>\n",
       "      <td>4.512341</td>\n",
       "      <td>1.232338</td>\n",
       "      <td>-0.09072999</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>-0.02777996</td>\n",
       "      <td>4.030838</td>\n",
       "      <td>1.165307</td>\n",
       "      <td>-0.06644046</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>-0.02969043</td>\n",
       "      <td>3.702827</td>\n",
       "      <td>1.108804</td>\n",
       "      <td>-0.04485478</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>-0.02968067</td>\n",
       "      <td>3.599897</td>\n",
       "      <td>1.154027</td>\n",
       "      <td>-0.06221614</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>-0.0292097</td>\n",
       "      <td>3.525848</td>\n",
       "      <td>1.181751</td>\n",
       "      <td>-0.07252603</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>-0.02725679</td>\n",
       "      <td>3.321596</td>\n",
       "      <td>1.092012</td>\n",
       "      <td>-0.03822729</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>-0.02839914</td>\n",
       "      <td>3.060353</td>\n",
       "      <td>0.9945492</td>\n",
       "      <td>0.002373721</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>-0.02548743</td>\n",
       "      <td>2.896707</td>\n",
       "      <td>0.984663</td>\n",
       "      <td>0.006712403</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>-0.02620553</td>\n",
       "      <td>2.849893</td>\n",
       "      <td>0.9978882</td>\n",
       "      <td>0.0009181096</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>-0.02717838</td>\n",
       "      <td>2.833083</td>\n",
       "      <td>0.9262491</td>\n",
       "      <td>0.03327218</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>-0.03002304</td>\n",
       "      <td>2.824488</td>\n",
       "      <td>0.8256204</td>\n",
       "      <td>0.08321961</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>-0.02735112</td>\n",
       "      <td>2.890148</td>\n",
       "      <td>0.7839248</td>\n",
       "      <td>0.1057256</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>-0.03242309</td>\n",
       "      <td>3.049514</td>\n",
       "      <td>0.7809075</td>\n",
       "      <td>0.1074004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>-0.02514157</td>\n",
       "      <td>3.227363</td>\n",
       "      <td>0.7485204</td>\n",
       "      <td>0.1257963</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>-0.0271321</td>\n",
       "      <td>3.371491</td>\n",
       "      <td>0.6883949</td>\n",
       "      <td>0.1621623</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>-0.0328542</td>\n",
       "      <td>3.53616</td>\n",
       "      <td>0.6510038</td>\n",
       "      <td>0.1864164</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>-0.03128776</td>\n",
       "      <td>3.790514</td>\n",
       "      <td>0.6450443</td>\n",
       "      <td>0.1904105</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4068</th>\n",
       "      <td>-0.007898049</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4069</th>\n",
       "      <td>-0.0118013</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4070</th>\n",
       "      <td>-0.009110876</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4071</th>\n",
       "      <td>-0.01109779</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4072</th>\n",
       "      <td>-0.009834031</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4073</th>\n",
       "      <td>-0.01050237</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4074</th>\n",
       "      <td>-0.01577201</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4075</th>\n",
       "      <td>-0.008814468</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4076</th>\n",
       "      <td>-0.01551837</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4077</th>\n",
       "      <td>-0.01195459</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4078</th>\n",
       "      <td>-0.01381432</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4079</th>\n",
       "      <td>-0.01382722</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4080</th>\n",
       "      <td>-0.00920059</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4081</th>\n",
       "      <td>-0.0133783</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4082</th>\n",
       "      <td>-0.0159682</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4083</th>\n",
       "      <td>-0.0112609</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4084</th>\n",
       "      <td>-0.008915353</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4085</th>\n",
       "      <td>-0.01721862</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4086</th>\n",
       "      <td>-0.008181388</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4087</th>\n",
       "      <td>-0.008577848</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4088</th>\n",
       "      <td>-0.007860034</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4089</th>\n",
       "      <td>-0.009088007</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4090</th>\n",
       "      <td>-0.01273255</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4091</th>\n",
       "      <td>-0.00594209</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4092</th>\n",
       "      <td>-0.01000044</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4093</th>\n",
       "      <td>-0.009542199</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4094</th>\n",
       "      <td>-0.006516503</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4095</th>\n",
       "      <td>-0.01306289</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4096</th>\n",
       "      <td>-0.01023504</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4097</th>\n",
       "      <td>-0.005849344</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4097 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                   Unnamed: 1             Unnamed: 4     Unnamed: 7  \\\n",
       "1     Terahertz signal (a.u.)  Electric field (a.u.)  Transmittance   \n",
       "2                 -0.01804322                6.88203       2.673557   \n",
       "3                 -0.02111875              0.6927925      0.2033236   \n",
       "4                 -0.01681809              0.8349739       1.401699   \n",
       "5                 -0.02208075               1.920209      0.8537656   \n",
       "6                 -0.02494478               3.712943      0.7183219   \n",
       "7                 -0.02022591                5.51333      0.7679713   \n",
       "8                 -0.02351194               6.496024      0.8877195   \n",
       "9                 -0.02092568                6.40656      0.9930028   \n",
       "10                -0.02455329               5.740438      0.9894645   \n",
       "11                -0.02123577               5.192579      0.9435052   \n",
       "12                -0.02220568               4.995144      0.9972789   \n",
       "13                -0.02519521               4.863997       1.146931   \n",
       "14                -0.02504743               4.512341       1.232338   \n",
       "15                -0.02777996               4.030838       1.165307   \n",
       "16                -0.02969043               3.702827       1.108804   \n",
       "17                -0.02968067               3.599897       1.154027   \n",
       "18                 -0.0292097               3.525848       1.181751   \n",
       "19                -0.02725679               3.321596       1.092012   \n",
       "20                -0.02839914               3.060353      0.9945492   \n",
       "21                -0.02548743               2.896707       0.984663   \n",
       "22                -0.02620553               2.849893      0.9978882   \n",
       "23                -0.02717838               2.833083      0.9262491   \n",
       "24                -0.03002304               2.824488      0.8256204   \n",
       "25                -0.02735112               2.890148      0.7839248   \n",
       "26                -0.03242309               3.049514      0.7809075   \n",
       "27                -0.02514157               3.227363      0.7485204   \n",
       "28                 -0.0271321               3.371491      0.6883949   \n",
       "29                 -0.0328542                3.53616      0.6510038   \n",
       "30                -0.03128776               3.790514      0.6450443   \n",
       "...                       ...                    ...            ...   \n",
       "4068             -0.007898049                    NaN            NaN   \n",
       "4069               -0.0118013                    NaN            NaN   \n",
       "4070             -0.009110876                    NaN            NaN   \n",
       "4071              -0.01109779                    NaN            NaN   \n",
       "4072             -0.009834031                    NaN            NaN   \n",
       "4073              -0.01050237                    NaN            NaN   \n",
       "4074              -0.01577201                    NaN            NaN   \n",
       "4075             -0.008814468                    NaN            NaN   \n",
       "4076              -0.01551837                    NaN            NaN   \n",
       "4077              -0.01195459                    NaN            NaN   \n",
       "4078              -0.01381432                    NaN            NaN   \n",
       "4079              -0.01382722                    NaN            NaN   \n",
       "4080              -0.00920059                    NaN            NaN   \n",
       "4081               -0.0133783                    NaN            NaN   \n",
       "4082               -0.0159682                    NaN            NaN   \n",
       "4083               -0.0112609                    NaN            NaN   \n",
       "4084             -0.008915353                    NaN            NaN   \n",
       "4085              -0.01721862                    NaN            NaN   \n",
       "4086             -0.008181388                    NaN            NaN   \n",
       "4087             -0.008577848                    NaN            NaN   \n",
       "4088             -0.007860034                    NaN            NaN   \n",
       "4089             -0.009088007                    NaN            NaN   \n",
       "4090              -0.01273255                    NaN            NaN   \n",
       "4091              -0.00594209                    NaN            NaN   \n",
       "4092              -0.01000044                    NaN            NaN   \n",
       "4093             -0.009542199                    NaN            NaN   \n",
       "4094             -0.006516503                    NaN            NaN   \n",
       "4095              -0.01306289                    NaN            NaN   \n",
       "4096              -0.01023504                    NaN            NaN   \n",
       "4097             -0.005849344                    NaN            NaN   \n",
       "\n",
       "       Unnamed: 10  \n",
       "1       Absorbance  \n",
       "2       -0.4270894  \n",
       "3        0.6918122  \n",
       "4       -0.1466547  \n",
       "5       0.06866135  \n",
       "6        0.1436809  \n",
       "7         0.114655  \n",
       "8       0.05172426  \n",
       "9      0.003049539  \n",
       "10     0.004599799  \n",
       "11      0.02525569  \n",
       "12     0.001183383  \n",
       "13     -0.05953745  \n",
       "14     -0.09072999  \n",
       "15     -0.06644046  \n",
       "16     -0.04485478  \n",
       "17     -0.06221614  \n",
       "18     -0.07252603  \n",
       "19     -0.03822729  \n",
       "20     0.002373721  \n",
       "21     0.006712403  \n",
       "22    0.0009181096  \n",
       "23      0.03327218  \n",
       "24      0.08321961  \n",
       "25       0.1057256  \n",
       "26       0.1074004  \n",
       "27       0.1257963  \n",
       "28       0.1621623  \n",
       "29       0.1864164  \n",
       "30       0.1904105  \n",
       "...            ...  \n",
       "4068           NaN  \n",
       "4069           NaN  \n",
       "4070           NaN  \n",
       "4071           NaN  \n",
       "4072           NaN  \n",
       "4073           NaN  \n",
       "4074           NaN  \n",
       "4075           NaN  \n",
       "4076           NaN  \n",
       "4077           NaN  \n",
       "4078           NaN  \n",
       "4079           NaN  \n",
       "4080           NaN  \n",
       "4081           NaN  \n",
       "4082           NaN  \n",
       "4083           NaN  \n",
       "4084           NaN  \n",
       "4085           NaN  \n",
       "4086           NaN  \n",
       "4087           NaN  \n",
       "4088           NaN  \n",
       "4089           NaN  \n",
       "4090           NaN  \n",
       "4091           NaN  \n",
       "4092           NaN  \n",
       "4093           NaN  \n",
       "4094           NaN  \n",
       "4095           NaN  \n",
       "4096           NaN  \n",
       "4097           NaN  \n",
       "\n",
       "[4097 rows x 4 columns]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tempSample"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "tempSample2 = Yeast_10_6_order_10ul_x5.loc[1:, ['Unnamed: '+str(12+1),'Unnamed: '+str(12+4),'Unnamed: '+str(12+7),'Unnamed: '+str(12+10)]]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 13</th>\n",
       "      <th>Unnamed: 16</th>\n",
       "      <th>Unnamed: 19</th>\n",
       "      <th>Unnamed: 22</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Terahertz signal (a.u.)</td>\n",
       "      <td>Electric field (a.u.)</td>\n",
       "      <td>Transmittance</td>\n",
       "      <td>Absorbance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>-0.01692473</td>\n",
       "      <td>8.243268</td>\n",
       "      <td>3.202376</td>\n",
       "      <td>-0.5054723</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>-0.01896029</td>\n",
       "      <td>0.4981646</td>\n",
       "      <td>0.1462034</td>\n",
       "      <td>0.8350426</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>-0.02148728</td>\n",
       "      <td>0.9074199</td>\n",
       "      <td>1.523316</td>\n",
       "      <td>-0.1827901</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>-0.02227795</td>\n",
       "      <td>1.951185</td>\n",
       "      <td>0.8675381</td>\n",
       "      <td>0.06171145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>-0.02154227</td>\n",
       "      <td>3.586228</td>\n",
       "      <td>0.6938072</td>\n",
       "      <td>0.1587612</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>-0.019872</td>\n",
       "      <td>5.357868</td>\n",
       "      <td>0.7463164</td>\n",
       "      <td>0.127077</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>-0.02207304</td>\n",
       "      <td>6.485383</td>\n",
       "      <td>0.8862653</td>\n",
       "      <td>0.05243627</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>-0.02153404</td>\n",
       "      <td>6.511393</td>\n",
       "      <td>1.009252</td>\n",
       "      <td>-0.003999444</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>-0.0218951</td>\n",
       "      <td>5.792629</td>\n",
       "      <td>0.9984605</td>\n",
       "      <td>0.0006691239</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>-0.02695641</td>\n",
       "      <td>5.137562</td>\n",
       "      <td>0.9335086</td>\n",
       "      <td>0.02988169</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>-0.02353733</td>\n",
       "      <td>4.943969</td>\n",
       "      <td>0.9870619</td>\n",
       "      <td>0.00565563</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>-0.02693465</td>\n",
       "      <td>4.899297</td>\n",
       "      <td>1.155255</td>\n",
       "      <td>-0.06267798</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>-0.02767124</td>\n",
       "      <td>4.572535</td>\n",
       "      <td>1.248778</td>\n",
       "      <td>-0.09648515</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>-0.02891693</td>\n",
       "      <td>4.030618</td>\n",
       "      <td>1.165244</td>\n",
       "      <td>-0.06641669</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>-0.02465658</td>\n",
       "      <td>3.66709</td>\n",
       "      <td>1.098103</td>\n",
       "      <td>-0.04064295</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>-0.02016068</td>\n",
       "      <td>3.604658</td>\n",
       "      <td>1.155554</td>\n",
       "      <td>-0.06279013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>-0.02750373</td>\n",
       "      <td>3.571234</td>\n",
       "      <td>1.196963</td>\n",
       "      <td>-0.07808071</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>-0.0269972</td>\n",
       "      <td>3.347324</td>\n",
       "      <td>1.10047</td>\n",
       "      <td>-0.04157828</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>-0.02471616</td>\n",
       "      <td>3.054952</td>\n",
       "      <td>0.992794</td>\n",
       "      <td>0.003140866</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>-0.02687373</td>\n",
       "      <td>2.908876</td>\n",
       "      <td>0.9887996</td>\n",
       "      <td>0.00489173</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>-0.02790506</td>\n",
       "      <td>2.897199</td>\n",
       "      <td>1.014452</td>\n",
       "      <td>-0.006231699</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>-0.03004761</td>\n",
       "      <td>2.873446</td>\n",
       "      <td>0.9394456</td>\n",
       "      <td>0.02712838</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>-0.03130407</td>\n",
       "      <td>2.832266</td>\n",
       "      <td>0.827894</td>\n",
       "      <td>0.08202528</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>-0.03102396</td>\n",
       "      <td>2.898217</td>\n",
       "      <td>0.7861135</td>\n",
       "      <td>0.1045147</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>-0.03466211</td>\n",
       "      <td>3.088258</td>\n",
       "      <td>0.7908289</td>\n",
       "      <td>0.1019175</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>-0.03127083</td>\n",
       "      <td>3.271802</td>\n",
       "      <td>0.7588271</td>\n",
       "      <td>0.1198571</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>-0.02792052</td>\n",
       "      <td>3.385932</td>\n",
       "      <td>0.6913435</td>\n",
       "      <td>0.1603061</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>-0.02997017</td>\n",
       "      <td>3.533348</td>\n",
       "      <td>0.6504861</td>\n",
       "      <td>0.186762</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>-0.02883119</td>\n",
       "      <td>3.8023</td>\n",
       "      <td>0.6470498</td>\n",
       "      <td>0.1890623</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4068</th>\n",
       "      <td>-0.008380928</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4069</th>\n",
       "      <td>-0.01288034</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4070</th>\n",
       "      <td>-0.008613342</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4071</th>\n",
       "      <td>-0.009516522</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4072</th>\n",
       "      <td>-0.006512431</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4073</th>\n",
       "      <td>-0.01383828</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4074</th>\n",
       "      <td>-0.009673131</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4075</th>\n",
       "      <td>-0.01349092</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4076</th>\n",
       "      <td>-0.01443065</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4077</th>\n",
       "      <td>-0.01536855</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4078</th>\n",
       "      <td>-0.01260915</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4079</th>\n",
       "      <td>-0.009029053</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4080</th>\n",
       "      <td>-0.01225477</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4081</th>\n",
       "      <td>-0.01494316</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4082</th>\n",
       "      <td>-0.01490566</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4083</th>\n",
       "      <td>-0.008136652</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4084</th>\n",
       "      <td>-0.01592652</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4085</th>\n",
       "      <td>-0.01062831</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4086</th>\n",
       "      <td>-0.01121095</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4087</th>\n",
       "      <td>-0.0132284</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4088</th>\n",
       "      <td>-0.008167427</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4089</th>\n",
       "      <td>-0.01218508</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4090</th>\n",
       "      <td>-0.008921511</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4091</th>\n",
       "      <td>-0.008595582</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4092</th>\n",
       "      <td>-0.009316836</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4093</th>\n",
       "      <td>-0.01131708</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4094</th>\n",
       "      <td>-0.01044279</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4095</th>\n",
       "      <td>-0.002572295</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4096</th>\n",
       "      <td>-0.005436766</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4097</th>\n",
       "      <td>-0.009769049</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4097 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                  Unnamed: 13            Unnamed: 16    Unnamed: 19  \\\n",
       "1     Terahertz signal (a.u.)  Electric field (a.u.)  Transmittance   \n",
       "2                 -0.01692473               8.243268       3.202376   \n",
       "3                 -0.01896029              0.4981646      0.1462034   \n",
       "4                 -0.02148728              0.9074199       1.523316   \n",
       "5                 -0.02227795               1.951185      0.8675381   \n",
       "6                 -0.02154227               3.586228      0.6938072   \n",
       "7                   -0.019872               5.357868      0.7463164   \n",
       "8                 -0.02207304               6.485383      0.8862653   \n",
       "9                 -0.02153404               6.511393       1.009252   \n",
       "10                 -0.0218951               5.792629      0.9984605   \n",
       "11                -0.02695641               5.137562      0.9335086   \n",
       "12                -0.02353733               4.943969      0.9870619   \n",
       "13                -0.02693465               4.899297       1.155255   \n",
       "14                -0.02767124               4.572535       1.248778   \n",
       "15                -0.02891693               4.030618       1.165244   \n",
       "16                -0.02465658                3.66709       1.098103   \n",
       "17                -0.02016068               3.604658       1.155554   \n",
       "18                -0.02750373               3.571234       1.196963   \n",
       "19                 -0.0269972               3.347324        1.10047   \n",
       "20                -0.02471616               3.054952       0.992794   \n",
       "21                -0.02687373               2.908876      0.9887996   \n",
       "22                -0.02790506               2.897199       1.014452   \n",
       "23                -0.03004761               2.873446      0.9394456   \n",
       "24                -0.03130407               2.832266       0.827894   \n",
       "25                -0.03102396               2.898217      0.7861135   \n",
       "26                -0.03466211               3.088258      0.7908289   \n",
       "27                -0.03127083               3.271802      0.7588271   \n",
       "28                -0.02792052               3.385932      0.6913435   \n",
       "29                -0.02997017               3.533348      0.6504861   \n",
       "30                -0.02883119                 3.8023      0.6470498   \n",
       "...                       ...                    ...            ...   \n",
       "4068             -0.008380928                    NaN            NaN   \n",
       "4069              -0.01288034                    NaN            NaN   \n",
       "4070             -0.008613342                    NaN            NaN   \n",
       "4071             -0.009516522                    NaN            NaN   \n",
       "4072             -0.006512431                    NaN            NaN   \n",
       "4073              -0.01383828                    NaN            NaN   \n",
       "4074             -0.009673131                    NaN            NaN   \n",
       "4075              -0.01349092                    NaN            NaN   \n",
       "4076              -0.01443065                    NaN            NaN   \n",
       "4077              -0.01536855                    NaN            NaN   \n",
       "4078              -0.01260915                    NaN            NaN   \n",
       "4079             -0.009029053                    NaN            NaN   \n",
       "4080              -0.01225477                    NaN            NaN   \n",
       "4081              -0.01494316                    NaN            NaN   \n",
       "4082              -0.01490566                    NaN            NaN   \n",
       "4083             -0.008136652                    NaN            NaN   \n",
       "4084              -0.01592652                    NaN            NaN   \n",
       "4085              -0.01062831                    NaN            NaN   \n",
       "4086              -0.01121095                    NaN            NaN   \n",
       "4087               -0.0132284                    NaN            NaN   \n",
       "4088             -0.008167427                    NaN            NaN   \n",
       "4089              -0.01218508                    NaN            NaN   \n",
       "4090             -0.008921511                    NaN            NaN   \n",
       "4091             -0.008595582                    NaN            NaN   \n",
       "4092             -0.009316836                    NaN            NaN   \n",
       "4093              -0.01131708                    NaN            NaN   \n",
       "4094              -0.01044279                    NaN            NaN   \n",
       "4095             -0.002572295                    NaN            NaN   \n",
       "4096             -0.005436766                    NaN            NaN   \n",
       "4097             -0.009769049                    NaN            NaN   \n",
       "\n",
       "       Unnamed: 22  \n",
       "1       Absorbance  \n",
       "2       -0.5054723  \n",
       "3        0.8350426  \n",
       "4       -0.1827901  \n",
       "5       0.06171145  \n",
       "6        0.1587612  \n",
       "7         0.127077  \n",
       "8       0.05243627  \n",
       "9     -0.003999444  \n",
       "10    0.0006691239  \n",
       "11      0.02988169  \n",
       "12      0.00565563  \n",
       "13     -0.06267798  \n",
       "14     -0.09648515  \n",
       "15     -0.06641669  \n",
       "16     -0.04064295  \n",
       "17     -0.06279013  \n",
       "18     -0.07808071  \n",
       "19     -0.04157828  \n",
       "20     0.003140866  \n",
       "21      0.00489173  \n",
       "22    -0.006231699  \n",
       "23      0.02712838  \n",
       "24      0.08202528  \n",
       "25       0.1045147  \n",
       "26       0.1019175  \n",
       "27       0.1198571  \n",
       "28       0.1603061  \n",
       "29        0.186762  \n",
       "30       0.1890623  \n",
       "...            ...  \n",
       "4068           NaN  \n",
       "4069           NaN  \n",
       "4070           NaN  \n",
       "4071           NaN  \n",
       "4072           NaN  \n",
       "4073           NaN  \n",
       "4074           NaN  \n",
       "4075           NaN  \n",
       "4076           NaN  \n",
       "4077           NaN  \n",
       "4078           NaN  \n",
       "4079           NaN  \n",
       "4080           NaN  \n",
       "4081           NaN  \n",
       "4082           NaN  \n",
       "4083           NaN  \n",
       "4084           NaN  \n",
       "4085           NaN  \n",
       "4086           NaN  \n",
       "4087           NaN  \n",
       "4088           NaN  \n",
       "4089           NaN  \n",
       "4090           NaN  \n",
       "4091           NaN  \n",
       "4092           NaN  \n",
       "4093           NaN  \n",
       "4094           NaN  \n",
       "4095           NaN  \n",
       "4096           NaN  \n",
       "4097           NaN  \n",
       "\n",
       "[4097 rows x 4 columns]"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tempSample2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "ser1 = pd.Series([1, 2, 3], [\"a\",\"b\",\"c\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "a    1\n",
       "b    2\n",
       "c    3\n",
       "dtype: int64"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ser1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<bound method NDFrame.last of a    1\n",
       "b    2\n",
       "c    3\n",
       "dtype: int64>"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ser1.last"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy.random as rd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.DataFrame(rd.randn(3,3), ['A', 'B', 'C'], ['X', 'Y', 'Z'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>X</th>\n",
       "      <th>Y</th>\n",
       "      <th>Z</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>A</th>\n",
       "      <td>-0.079689</td>\n",
       "      <td>0.330638</td>\n",
       "      <td>0.391180</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>B</th>\n",
       "      <td>1.047661</td>\n",
       "      <td>-0.144868</td>\n",
       "      <td>0.201546</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>C</th>\n",
       "      <td>0.204755</td>\n",
       "      <td>1.294356</td>\n",
       "      <td>1.425724</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          X         Y         Z\n",
       "A -0.079689  0.330638  0.391180\n",
       "B  1.047661 -0.144868  0.201546\n",
       "C  0.204755  1.294356  1.425724"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Y</th>\n",
       "      <th>Z</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>A</th>\n",
       "      <td>0.330638</td>\n",
       "      <td>0.391180</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>B</th>\n",
       "      <td>-0.144868</td>\n",
       "      <td>0.201546</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>C</th>\n",
       "      <td>1.294356</td>\n",
       "      <td>1.425724</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          Y         Z\n",
       "A  0.330638  0.391180\n",
       "B -0.144868  0.201546\n",
       "C  1.294356  1.425724"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[['Y', 'Z']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['new'] = df['X'] + df['Y']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>X</th>\n",
       "      <th>Y</th>\n",
       "      <th>Z</th>\n",
       "      <th>new</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>A</th>\n",
       "      <td>-0.079689</td>\n",
       "      <td>0.330638</td>\n",
       "      <td>0.391180</td>\n",
       "      <td>0.250949</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>B</th>\n",
       "      <td>1.047661</td>\n",
       "      <td>-0.144868</td>\n",
       "      <td>0.201546</td>\n",
       "      <td>0.902793</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>C</th>\n",
       "      <td>0.204755</td>\n",
       "      <td>1.294356</td>\n",
       "      <td>1.425724</td>\n",
       "      <td>1.499111</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          X         Y         Z       new\n",
       "A -0.079689  0.330638  0.391180  0.250949\n",
       "B  1.047661 -0.144868  0.201546  0.902793\n",
       "C  0.204755  1.294356  1.425724  1.499111"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>X</th>\n",
       "      <th>Y</th>\n",
       "      <th>Z</th>\n",
       "      <th>new</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>A</th>\n",
       "      <td>-0.079689</td>\n",
       "      <td>0.330638</td>\n",
       "      <td>0.391180</td>\n",
       "      <td>0.250949</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>C</th>\n",
       "      <td>0.204755</td>\n",
       "      <td>1.294356</td>\n",
       "      <td>1.425724</td>\n",
       "      <td>1.499111</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          X         Y         Z       new\n",
       "A -0.079689  0.330638  0.391180  0.250949\n",
       "C  0.204755  1.294356  1.425724  1.499111"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.drop('B')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [],
   "source": [
    "df2 = pd.DataFrame(rd.randn(10,3), columns = ['X', 'Y', 'Z'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>X</th>\n",
       "      <th>Y</th>\n",
       "      <th>Z</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0.403753</td>\n",
       "      <td>1.194072</td>\n",
       "      <td>0.091188</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>-1.386241</td>\n",
       "      <td>2.024403</td>\n",
       "      <td>0.581746</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>-0.445336</td>\n",
       "      <td>0.546302</td>\n",
       "      <td>-1.824941</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0.148486</td>\n",
       "      <td>-1.982062</td>\n",
       "      <td>-0.469432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0.596770</td>\n",
       "      <td>0.093637</td>\n",
       "      <td>1.235817</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1.517109</td>\n",
       "      <td>1.332685</td>\n",
       "      <td>0.845896</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>-0.474046</td>\n",
       "      <td>-0.358245</td>\n",
       "      <td>-1.823163</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>-1.050213</td>\n",
       "      <td>-0.129483</td>\n",
       "      <td>0.941938</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>0.105148</td>\n",
       "      <td>-1.017748</td>\n",
       "      <td>1.269999</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>-0.754582</td>\n",
       "      <td>-0.404445</td>\n",
       "      <td>1.328423</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          X         Y         Z\n",
       "0  0.403753  1.194072  0.091188\n",
       "1 -1.386241  2.024403  0.581746\n",
       "2 -0.445336  0.546302 -1.824941\n",
       "3  0.148486 -1.982062 -0.469432\n",
       "4  0.596770  0.093637  1.235817\n",
       "5  1.517109  1.332685  0.845896\n",
       "6 -0.474046 -0.358245 -1.823163\n",
       "7 -1.050213 -0.129483  0.941938\n",
       "8  0.105148 -1.017748  1.269999\n",
       "9 -0.754582 -0.404445  1.328423"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>X</th>\n",
       "      <th>Z</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>-0.445336</td>\n",
       "      <td>-1.824941</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0.148486</td>\n",
       "      <td>-0.469432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0.596770</td>\n",
       "      <td>1.235817</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1.517109</td>\n",
       "      <td>0.845896</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          X         Z\n",
       "2 -0.445336 -1.824941\n",
       "3  0.148486 -0.469432\n",
       "4  0.596770  1.235817\n",
       "5  1.517109  0.845896"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2.loc[range(2,6), ['X', 'Z']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "range"
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "a = range(20)\n",
    "a\n",
    "type(a)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>X</th>\n",
       "      <th>Y</th>\n",
       "      <th>Z</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0.403753</td>\n",
       "      <td>1.194072</td>\n",
       "      <td>0.091188</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>-1.386241</td>\n",
       "      <td>2.024403</td>\n",
       "      <td>0.581746</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>-0.445336</td>\n",
       "      <td>0.546302</td>\n",
       "      <td>-1.824941</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0.148486</td>\n",
       "      <td>-1.982062</td>\n",
       "      <td>-0.469432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0.596770</td>\n",
       "      <td>0.093637</td>\n",
       "      <td>1.235817</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1.517109</td>\n",
       "      <td>1.332685</td>\n",
       "      <td>0.845896</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>-0.474046</td>\n",
       "      <td>-0.358245</td>\n",
       "      <td>-1.823163</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>-1.050213</td>\n",
       "      <td>-0.129483</td>\n",
       "      <td>0.941938</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>0.105148</td>\n",
       "      <td>-1.017748</td>\n",
       "      <td>1.269999</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>-0.754582</td>\n",
       "      <td>-0.404445</td>\n",
       "      <td>1.328423</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          X         Y         Z\n",
       "0  0.403753  1.194072  0.091188\n",
       "1 -1.386241  2.024403  0.581746\n",
       "2 -0.445336  0.546302 -1.824941\n",
       "3  0.148486 -1.982062 -0.469432\n",
       "4  0.596770  0.093637  1.235817\n",
       "5  1.517109  1.332685  0.845896\n",
       "6 -0.474046 -0.358245 -1.823163\n",
       "7 -1.050213 -0.129483  0.941938\n",
       "8  0.105148 -1.017748  1.269999\n",
       "9 -0.754582 -0.404445  1.328423"
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2 "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {},
   "outputs": [],
   "source": [
    "temp = df2[df2['Y'] > 0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "pandas.core.frame.DataFrame"
      ]
     },
     "execution_count": 51,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "type(temp)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {},
   "outputs": [],
   "source": [
    "temp.to_excel('temp.xlsx')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {},
   "outputs": [],
   "source": [
    "temp.to_csv('temp.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "metadata": {},
   "outputs": [],
   "source": [
    "from numpy import genfromtxt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {},
   "outputs": [],
   "source": [
    "np_csv = genfromtxt('temp.csv', delimiter=',')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([[        nan,         nan,         nan,         nan],\n",
       "       [ 0.        ,  0.40375337,  1.19407213,  0.09118775],\n",
       "       [ 1.        , -1.38624113,  2.02440308,  0.58174631],\n",
       "       [ 2.        , -0.44533551,  0.5463019 , -1.82494075],\n",
       "       [ 4.        ,  0.5967697 ,  0.09363737,  1.23581652],\n",
       "       [ 5.        ,  1.51710883,  1.33268451,  0.84589557]])"
      ]
     },
     "execution_count": 66,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "np_csv"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "numpy.ndarray"
      ]
     },
     "execution_count": 59,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "type(np_csv)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([[ 0.        ,  0.40375337,  1.19407213,  0.09118775],\n",
       "       [ 1.        , -1.38624113,  2.02440308,  0.58174631],\n",
       "       [ 2.        , -0.44533551,  0.5463019 , -1.82494075],\n",
       "       [ 4.        ,  0.5967697 ,  0.09363737,  1.23581652],\n",
       "       [ 5.        ,  1.51710883,  1.33268451,  0.84589557]])"
      ]
     },
     "execution_count": 68,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "np.delete(np_csv, 0, 0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "metadata": {},
   "outputs": [],
   "source": [
    "np_csv = np.delete(np.delete(np_csv, 0, 0), 0, 1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([[ 0.40375337,  1.19407213,  0.09118775],\n",
       "       [-1.38624113,  2.02440308,  0.58174631],\n",
       "       [-0.44533551,  0.5463019 , -1.82494075],\n",
       "       [ 0.5967697 ,  0.09363737,  1.23581652],\n",
       "       [ 1.51710883,  1.33268451,  0.84589557]])"
      ]
     },
     "execution_count": 70,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "np_csv"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}