{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "3ee5cf2b-f2d5-4a3f-908f-10a39cfcc4cd",
   "metadata": {},
   "source": [
    "# Pandas\n",
    "\n",
    "In this notebook, we’re going to show how to:\n",
    "* create data frames\n",
    "* inspect data frames"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "6250ca82-6708-4f07-948f-c90ef1495f84",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "62424fc8",
   "metadata": {},
   "source": [
    "## Create a dataframe with random data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "7d78f4fd-83eb-4815-a1b3-d4b9522c9519",
   "metadata": {},
   "outputs": [],
   "source": [
    "from numpy.random import default_rng\n",
    "rng = default_rng(42)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "98788698-8af6-42ce-8a57-e04dae0441f0",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(['A', 'B', 'C', 'D', 'E', 'F', 'G'], ['0', '1', '2', '3'])"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "index_list = list('ABCDEFG')\n",
    "column_list= list('0123')\n",
    "\n",
    "n_rows, n_cols = len(index_list), len(column_list)\n",
    "index_list, column_list"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "da06c825-ea6c-46d8-a1c1-f13d6d74675a",
   "metadata": {},
   "outputs": [],
   "source": [
    "data = rng.normal(size=(n_rows, n_cols))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "ff491935-e2de-45ff-b89a-85c18bef8092",
   "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>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>A</th>\n",
       "      <td>0.304717</td>\n",
       "      <td>-1.039984</td>\n",
       "      <td>0.750451</td>\n",
       "      <td>0.940565</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>B</th>\n",
       "      <td>-1.951035</td>\n",
       "      <td>-1.302180</td>\n",
       "      <td>0.127840</td>\n",
       "      <td>-0.316243</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>C</th>\n",
       "      <td>-0.016801</td>\n",
       "      <td>-0.853044</td>\n",
       "      <td>0.879398</td>\n",
       "      <td>0.777792</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>D</th>\n",
       "      <td>0.066031</td>\n",
       "      <td>1.127241</td>\n",
       "      <td>0.467509</td>\n",
       "      <td>-0.859292</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>E</th>\n",
       "      <td>0.368751</td>\n",
       "      <td>-0.958883</td>\n",
       "      <td>0.878450</td>\n",
       "      <td>-0.049926</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>F</th>\n",
       "      <td>-0.184862</td>\n",
       "      <td>-0.680930</td>\n",
       "      <td>1.222541</td>\n",
       "      <td>-0.154529</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>G</th>\n",
       "      <td>-0.428328</td>\n",
       "      <td>-0.352134</td>\n",
       "      <td>0.532309</td>\n",
       "      <td>0.365444</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          0         1         2         3\n",
       "A  0.304717 -1.039984  0.750451  0.940565\n",
       "B -1.951035 -1.302180  0.127840 -0.316243\n",
       "C -0.016801 -0.853044  0.879398  0.777792\n",
       "D  0.066031  1.127241  0.467509 -0.859292\n",
       "E  0.368751 -0.958883  0.878450 -0.049926\n",
       "F -0.184862 -0.680930  1.222541 -0.154529\n",
       "G -0.428328 -0.352134  0.532309  0.365444"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.DataFrame(data=data, index=index_list, columns=column_list)\n",
    "df"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "5ee86614-db29-43bd-8344-2b6465fdab3a",
   "metadata": {},
   "source": [
    "### Another way to get list of letters and digits to use as index/columns "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "f5d36527-619f-48ad-bba4-e311873c8143",
   "metadata": {},
   "outputs": [],
   "source": [
    "import string\n",
    "\n",
    "index_list = list(string.ascii_uppercase)\n",
    "column_list = list(string.digits)\n",
    "\n",
    "n_rows, n_cols = len(index_list), len(column_list)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d6b55365-0d3b-4aea-a438-7886d5654636",
   "metadata": {},
   "source": [
    "see [string doc](https://docs.python.org/3/library/string.html) for info on the `string` module"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "75f28162-5bcb-4645-a073-9463385b8b9d",
   "metadata": {},
   "outputs": [],
   "source": [
    "data = rng.normal(size=(n_rows, n_cols))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "377e2646-d390-4e96-8caa-75327a257bc2",
   "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>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>9</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>A</th>\n",
       "      <td>0.412733</td>\n",
       "      <td>0.430821</td>\n",
       "      <td>2.141648</td>\n",
       "      <td>-0.406415</td>\n",
       "      <td>-0.512243</td>\n",
       "      <td>-0.813773</td>\n",
       "      <td>0.615979</td>\n",
       "      <td>1.128972</td>\n",
       "      <td>-0.113947</td>\n",
       "      <td>-0.840156</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>B</th>\n",
       "      <td>-0.824481</td>\n",
       "      <td>0.650593</td>\n",
       "      <td>0.743254</td>\n",
       "      <td>0.543154</td>\n",
       "      <td>-0.665510</td>\n",
       "      <td>0.232161</td>\n",
       "      <td>0.116686</td>\n",
       "      <td>0.218689</td>\n",
       "      <td>0.871429</td>\n",
       "      <td>0.223596</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>C</th>\n",
       "      <td>0.678914</td>\n",
       "      <td>0.067579</td>\n",
       "      <td>0.289119</td>\n",
       "      <td>0.631288</td>\n",
       "      <td>-1.457156</td>\n",
       "      <td>-0.319671</td>\n",
       "      <td>-0.470373</td>\n",
       "      <td>-0.638878</td>\n",
       "      <td>-0.275142</td>\n",
       "      <td>1.494941</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>D</th>\n",
       "      <td>-0.865831</td>\n",
       "      <td>0.968278</td>\n",
       "      <td>-1.682870</td>\n",
       "      <td>-0.334885</td>\n",
       "      <td>0.162753</td>\n",
       "      <td>0.586222</td>\n",
       "      <td>0.711227</td>\n",
       "      <td>0.793347</td>\n",
       "      <td>-0.348725</td>\n",
       "      <td>-0.462352</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>E</th>\n",
       "      <td>0.857976</td>\n",
       "      <td>-0.191304</td>\n",
       "      <td>-1.275686</td>\n",
       "      <td>-1.133287</td>\n",
       "      <td>-0.919452</td>\n",
       "      <td>0.497161</td>\n",
       "      <td>0.142426</td>\n",
       "      <td>0.690485</td>\n",
       "      <td>-0.427253</td>\n",
       "      <td>0.158540</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>F</th>\n",
       "      <td>0.625590</td>\n",
       "      <td>-0.309347</td>\n",
       "      <td>0.456775</td>\n",
       "      <td>-0.661926</td>\n",
       "      <td>-0.363054</td>\n",
       "      <td>-0.381738</td>\n",
       "      <td>-1.195840</td>\n",
       "      <td>0.486972</td>\n",
       "      <td>-0.469402</td>\n",
       "      <td>0.012494</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>G</th>\n",
       "      <td>0.480747</td>\n",
       "      <td>0.446531</td>\n",
       "      <td>0.665385</td>\n",
       "      <td>-0.098485</td>\n",
       "      <td>-0.423298</td>\n",
       "      <td>-0.079718</td>\n",
       "      <td>-1.687334</td>\n",
       "      <td>-1.447112</td>\n",
       "      <td>-1.322700</td>\n",
       "      <td>-0.997247</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>H</th>\n",
       "      <td>0.399774</td>\n",
       "      <td>-0.905479</td>\n",
       "      <td>-0.378163</td>\n",
       "      <td>1.299228</td>\n",
       "      <td>-0.356264</td>\n",
       "      <td>0.737516</td>\n",
       "      <td>-0.933618</td>\n",
       "      <td>-0.205438</td>\n",
       "      <td>-0.950022</td>\n",
       "      <td>-0.339033</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>I</th>\n",
       "      <td>0.840308</td>\n",
       "      <td>-1.727320</td>\n",
       "      <td>0.434424</td>\n",
       "      <td>0.237736</td>\n",
       "      <td>-0.594150</td>\n",
       "      <td>-1.446058</td>\n",
       "      <td>0.072130</td>\n",
       "      <td>-0.529493</td>\n",
       "      <td>0.232676</td>\n",
       "      <td>0.021852</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>J</th>\n",
       "      <td>1.601779</td>\n",
       "      <td>-0.239356</td>\n",
       "      <td>-1.023497</td>\n",
       "      <td>0.179276</td>\n",
       "      <td>0.219997</td>\n",
       "      <td>1.359188</td>\n",
       "      <td>0.835111</td>\n",
       "      <td>0.356871</td>\n",
       "      <td>1.463303</td>\n",
       "      <td>-1.188763</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>K</th>\n",
       "      <td>-0.639752</td>\n",
       "      <td>-0.926576</td>\n",
       "      <td>-0.389810</td>\n",
       "      <td>-1.376686</td>\n",
       "      <td>0.635151</td>\n",
       "      <td>-0.222223</td>\n",
       "      <td>-1.470806</td>\n",
       "      <td>-1.015579</td>\n",
       "      <td>0.313514</td>\n",
       "      <td>0.838127</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>L</th>\n",
       "      <td>1.996731</td>\n",
       "      <td>2.913862</td>\n",
       "      <td>0.414409</td>\n",
       "      <td>-0.989538</td>\n",
       "      <td>-2.132046</td>\n",
       "      <td>0.267711</td>\n",
       "      <td>-0.812941</td>\n",
       "      <td>-0.415357</td>\n",
       "      <td>-0.612097</td>\n",
       "      <td>-0.140791</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M</th>\n",
       "      <td>1.065980</td>\n",
       "      <td>0.157049</td>\n",
       "      <td>-0.158635</td>\n",
       "      <td>-1.035654</td>\n",
       "      <td>-1.674683</td>\n",
       "      <td>-0.486308</td>\n",
       "      <td>-0.053783</td>\n",
       "      <td>1.767930</td>\n",
       "      <td>0.130275</td>\n",
       "      <td>0.982740</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>N</th>\n",
       "      <td>-0.499296</td>\n",
       "      <td>-1.184944</td>\n",
       "      <td>-0.965117</td>\n",
       "      <td>-0.725226</td>\n",
       "      <td>2.128470</td>\n",
       "      <td>-0.821387</td>\n",
       "      <td>0.838489</td>\n",
       "      <td>-0.902927</td>\n",
       "      <td>0.931573</td>\n",
       "      <td>0.384951</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>O</th>\n",
       "      <td>-0.156638</td>\n",
       "      <td>-0.040763</td>\n",
       "      <td>-0.654788</td>\n",
       "      <td>0.446072</td>\n",
       "      <td>-0.454983</td>\n",
       "      <td>-1.225606</td>\n",
       "      <td>-1.277938</td>\n",
       "      <td>0.172588</td>\n",
       "      <td>1.579091</td>\n",
       "      <td>0.159992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P</th>\n",
       "      <td>-0.118638</td>\n",
       "      <td>0.285826</td>\n",
       "      <td>1.306002</td>\n",
       "      <td>0.219383</td>\n",
       "      <td>-0.410927</td>\n",
       "      <td>1.106289</td>\n",
       "      <td>0.428756</td>\n",
       "      <td>1.535756</td>\n",
       "      <td>0.183234</td>\n",
       "      <td>-1.224469</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q</th>\n",
       "      <td>-1.368159</td>\n",
       "      <td>1.650928</td>\n",
       "      <td>1.723666</td>\n",
       "      <td>-0.179519</td>\n",
       "      <td>-0.383187</td>\n",
       "      <td>1.461444</td>\n",
       "      <td>-1.107046</td>\n",
       "      <td>-0.894727</td>\n",
       "      <td>0.643327</td>\n",
       "      <td>-0.394605</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>R</th>\n",
       "      <td>-0.005122</td>\n",
       "      <td>-0.163443</td>\n",
       "      <td>0.337575</td>\n",
       "      <td>1.407482</td>\n",
       "      <td>0.090585</td>\n",
       "      <td>0.643939</td>\n",
       "      <td>-2.050172</td>\n",
       "      <td>-0.048718</td>\n",
       "      <td>-0.843230</td>\n",
       "      <td>-1.218813</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>S</th>\n",
       "      <td>-0.878152</td>\n",
       "      <td>-0.334123</td>\n",
       "      <td>0.915903</td>\n",
       "      <td>-1.326393</td>\n",
       "      <td>0.030631</td>\n",
       "      <td>-0.484169</td>\n",
       "      <td>-0.327673</td>\n",
       "      <td>1.002758</td>\n",
       "      <td>0.538115</td>\n",
       "      <td>1.337398</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>T</th>\n",
       "      <td>-0.154506</td>\n",
       "      <td>-0.695943</td>\n",
       "      <td>-0.223859</td>\n",
       "      <td>0.242497</td>\n",
       "      <td>0.176573</td>\n",
       "      <td>-1.084388</td>\n",
       "      <td>0.090490</td>\n",
       "      <td>0.228228</td>\n",
       "      <td>2.517474</td>\n",
       "      <td>1.876845</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>U</th>\n",
       "      <td>-0.853243</td>\n",
       "      <td>-0.287383</td>\n",
       "      <td>-1.463442</td>\n",
       "      <td>-0.590707</td>\n",
       "      <td>0.315605</td>\n",
       "      <td>1.205854</td>\n",
       "      <td>-0.729084</td>\n",
       "      <td>-0.654146</td>\n",
       "      <td>-2.147289</td>\n",
       "      <td>-0.162666</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>V</th>\n",
       "      <td>-1.062414</td>\n",
       "      <td>-0.529439</td>\n",
       "      <td>-0.876861</td>\n",
       "      <td>-0.094263</td>\n",
       "      <td>-1.757728</td>\n",
       "      <td>-1.467045</td>\n",
       "      <td>2.129247</td>\n",
       "      <td>-1.287423</td>\n",
       "      <td>-1.096786</td>\n",
       "      <td>1.836914</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>W</th>\n",
       "      <td>2.905067</td>\n",
       "      <td>-1.171567</td>\n",
       "      <td>-0.368249</td>\n",
       "      <td>0.341556</td>\n",
       "      <td>1.728698</td>\n",
       "      <td>-0.986857</td>\n",
       "      <td>-0.245278</td>\n",
       "      <td>0.777338</td>\n",
       "      <td>0.434766</td>\n",
       "      <td>-0.376156</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>X</th>\n",
       "      <td>-0.133823</td>\n",
       "      <td>-1.374896</td>\n",
       "      <td>-0.238174</td>\n",
       "      <td>-0.266387</td>\n",
       "      <td>0.232170</td>\n",
       "      <td>-0.555327</td>\n",
       "      <td>0.471539</td>\n",
       "      <td>1.012716</td>\n",
       "      <td>0.155429</td>\n",
       "      <td>0.351756</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Y</th>\n",
       "      <td>0.053155</td>\n",
       "      <td>0.000084</td>\n",
       "      <td>-0.721558</td>\n",
       "      <td>0.316494</td>\n",
       "      <td>-0.097287</td>\n",
       "      <td>2.093168</td>\n",
       "      <td>1.573355</td>\n",
       "      <td>0.385847</td>\n",
       "      <td>-0.763057</td>\n",
       "      <td>-1.112411</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Z</th>\n",
       "      <td>1.191143</td>\n",
       "      <td>0.262749</td>\n",
       "      <td>0.480143</td>\n",
       "      <td>-1.744586</td>\n",
       "      <td>0.927438</td>\n",
       "      <td>0.454420</td>\n",
       "      <td>-1.110431</td>\n",
       "      <td>-0.471525</td>\n",
       "      <td>0.263717</td>\n",
       "      <td>0.052467</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          0         1         2         3         4         5         6  \\\n",
       "A  0.412733  0.430821  2.141648 -0.406415 -0.512243 -0.813773  0.615979   \n",
       "B -0.824481  0.650593  0.743254  0.543154 -0.665510  0.232161  0.116686   \n",
       "C  0.678914  0.067579  0.289119  0.631288 -1.457156 -0.319671 -0.470373   \n",
       "D -0.865831  0.968278 -1.682870 -0.334885  0.162753  0.586222  0.711227   \n",
       "E  0.857976 -0.191304 -1.275686 -1.133287 -0.919452  0.497161  0.142426   \n",
       "F  0.625590 -0.309347  0.456775 -0.661926 -0.363054 -0.381738 -1.195840   \n",
       "G  0.480747  0.446531  0.665385 -0.098485 -0.423298 -0.079718 -1.687334   \n",
       "H  0.399774 -0.905479 -0.378163  1.299228 -0.356264  0.737516 -0.933618   \n",
       "I  0.840308 -1.727320  0.434424  0.237736 -0.594150 -1.446058  0.072130   \n",
       "J  1.601779 -0.239356 -1.023497  0.179276  0.219997  1.359188  0.835111   \n",
       "K -0.639752 -0.926576 -0.389810 -1.376686  0.635151 -0.222223 -1.470806   \n",
       "L  1.996731  2.913862  0.414409 -0.989538 -2.132046  0.267711 -0.812941   \n",
       "M  1.065980  0.157049 -0.158635 -1.035654 -1.674683 -0.486308 -0.053783   \n",
       "N -0.499296 -1.184944 -0.965117 -0.725226  2.128470 -0.821387  0.838489   \n",
       "O -0.156638 -0.040763 -0.654788  0.446072 -0.454983 -1.225606 -1.277938   \n",
       "P -0.118638  0.285826  1.306002  0.219383 -0.410927  1.106289  0.428756   \n",
       "Q -1.368159  1.650928  1.723666 -0.179519 -0.383187  1.461444 -1.107046   \n",
       "R -0.005122 -0.163443  0.337575  1.407482  0.090585  0.643939 -2.050172   \n",
       "S -0.878152 -0.334123  0.915903 -1.326393  0.030631 -0.484169 -0.327673   \n",
       "T -0.154506 -0.695943 -0.223859  0.242497  0.176573 -1.084388  0.090490   \n",
       "U -0.853243 -0.287383 -1.463442 -0.590707  0.315605  1.205854 -0.729084   \n",
       "V -1.062414 -0.529439 -0.876861 -0.094263 -1.757728 -1.467045  2.129247   \n",
       "W  2.905067 -1.171567 -0.368249  0.341556  1.728698 -0.986857 -0.245278   \n",
       "X -0.133823 -1.374896 -0.238174 -0.266387  0.232170 -0.555327  0.471539   \n",
       "Y  0.053155  0.000084 -0.721558  0.316494 -0.097287  2.093168  1.573355   \n",
       "Z  1.191143  0.262749  0.480143 -1.744586  0.927438  0.454420 -1.110431   \n",
       "\n",
       "          7         8         9  \n",
       "A  1.128972 -0.113947 -0.840156  \n",
       "B  0.218689  0.871429  0.223596  \n",
       "C -0.638878 -0.275142  1.494941  \n",
       "D  0.793347 -0.348725 -0.462352  \n",
       "E  0.690485 -0.427253  0.158540  \n",
       "F  0.486972 -0.469402  0.012494  \n",
       "G -1.447112 -1.322700 -0.997247  \n",
       "H -0.205438 -0.950022 -0.339033  \n",
       "I -0.529493  0.232676  0.021852  \n",
       "J  0.356871  1.463303 -1.188763  \n",
       "K -1.015579  0.313514  0.838127  \n",
       "L -0.415357 -0.612097 -0.140791  \n",
       "M  1.767930  0.130275  0.982740  \n",
       "N -0.902927  0.931573  0.384951  \n",
       "O  0.172588  1.579091  0.159992  \n",
       "P  1.535756  0.183234 -1.224469  \n",
       "Q -0.894727  0.643327 -0.394605  \n",
       "R -0.048718 -0.843230 -1.218813  \n",
       "S  1.002758  0.538115  1.337398  \n",
       "T  0.228228  2.517474  1.876845  \n",
       "U -0.654146 -2.147289 -0.162666  \n",
       "V -1.287423 -1.096786  1.836914  \n",
       "W  0.777338  0.434766 -0.376156  \n",
       "X  1.012716  0.155429  0.351756  \n",
       "Y  0.385847 -0.763057 -1.112411  \n",
       "Z -0.471525  0.263717  0.052467  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.DataFrame(data=data, index=index_list, columns=column_list)\n",
    "df"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "c430c3af",
   "metadata": {},
   "source": [
    "## Inspect the dataframe"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "c0fba470-cbfd-4014-a3c1-80a5805ab6b2",
   "metadata": {},
   "source": [
    "### see the first/last 5 rows"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "67c9e6cc-087e-430f-893f-5fd8cd32dcb8",
   "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>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>9</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>A</th>\n",
       "      <td>0.412733</td>\n",
       "      <td>0.430821</td>\n",
       "      <td>2.141648</td>\n",
       "      <td>-0.406415</td>\n",
       "      <td>-0.512243</td>\n",
       "      <td>-0.813773</td>\n",
       "      <td>0.615979</td>\n",
       "      <td>1.128972</td>\n",
       "      <td>-0.113947</td>\n",
       "      <td>-0.840156</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>B</th>\n",
       "      <td>-0.824481</td>\n",
       "      <td>0.650593</td>\n",
       "      <td>0.743254</td>\n",
       "      <td>0.543154</td>\n",
       "      <td>-0.665510</td>\n",
       "      <td>0.232161</td>\n",
       "      <td>0.116686</td>\n",
       "      <td>0.218689</td>\n",
       "      <td>0.871429</td>\n",
       "      <td>0.223596</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>C</th>\n",
       "      <td>0.678914</td>\n",
       "      <td>0.067579</td>\n",
       "      <td>0.289119</td>\n",
       "      <td>0.631288</td>\n",
       "      <td>-1.457156</td>\n",
       "      <td>-0.319671</td>\n",
       "      <td>-0.470373</td>\n",
       "      <td>-0.638878</td>\n",
       "      <td>-0.275142</td>\n",
       "      <td>1.494941</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>D</th>\n",
       "      <td>-0.865831</td>\n",
       "      <td>0.968278</td>\n",
       "      <td>-1.682870</td>\n",
       "      <td>-0.334885</td>\n",
       "      <td>0.162753</td>\n",
       "      <td>0.586222</td>\n",
       "      <td>0.711227</td>\n",
       "      <td>0.793347</td>\n",
       "      <td>-0.348725</td>\n",
       "      <td>-0.462352</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>E</th>\n",
       "      <td>0.857976</td>\n",
       "      <td>-0.191304</td>\n",
       "      <td>-1.275686</td>\n",
       "      <td>-1.133287</td>\n",
       "      <td>-0.919452</td>\n",
       "      <td>0.497161</td>\n",
       "      <td>0.142426</td>\n",
       "      <td>0.690485</td>\n",
       "      <td>-0.427253</td>\n",
       "      <td>0.158540</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          0         1         2         3         4         5         6  \\\n",
       "A  0.412733  0.430821  2.141648 -0.406415 -0.512243 -0.813773  0.615979   \n",
       "B -0.824481  0.650593  0.743254  0.543154 -0.665510  0.232161  0.116686   \n",
       "C  0.678914  0.067579  0.289119  0.631288 -1.457156 -0.319671 -0.470373   \n",
       "D -0.865831  0.968278 -1.682870 -0.334885  0.162753  0.586222  0.711227   \n",
       "E  0.857976 -0.191304 -1.275686 -1.133287 -0.919452  0.497161  0.142426   \n",
       "\n",
       "          7         8         9  \n",
       "A  1.128972 -0.113947 -0.840156  \n",
       "B  0.218689  0.871429  0.223596  \n",
       "C -0.638878 -0.275142  1.494941  \n",
       "D  0.793347 -0.348725 -0.462352  \n",
       "E  0.690485 -0.427253  0.158540  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "0478ee54-57a9-4209-8fb8-c248d64253d9",
   "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>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>9</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>V</th>\n",
       "      <td>-1.062414</td>\n",
       "      <td>-0.529439</td>\n",
       "      <td>-0.876861</td>\n",
       "      <td>-0.094263</td>\n",
       "      <td>-1.757728</td>\n",
       "      <td>-1.467045</td>\n",
       "      <td>2.129247</td>\n",
       "      <td>-1.287423</td>\n",
       "      <td>-1.096786</td>\n",
       "      <td>1.836914</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>W</th>\n",
       "      <td>2.905067</td>\n",
       "      <td>-1.171567</td>\n",
       "      <td>-0.368249</td>\n",
       "      <td>0.341556</td>\n",
       "      <td>1.728698</td>\n",
       "      <td>-0.986857</td>\n",
       "      <td>-0.245278</td>\n",
       "      <td>0.777338</td>\n",
       "      <td>0.434766</td>\n",
       "      <td>-0.376156</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>X</th>\n",
       "      <td>-0.133823</td>\n",
       "      <td>-1.374896</td>\n",
       "      <td>-0.238174</td>\n",
       "      <td>-0.266387</td>\n",
       "      <td>0.232170</td>\n",
       "      <td>-0.555327</td>\n",
       "      <td>0.471539</td>\n",
       "      <td>1.012716</td>\n",
       "      <td>0.155429</td>\n",
       "      <td>0.351756</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Y</th>\n",
       "      <td>0.053155</td>\n",
       "      <td>0.000084</td>\n",
       "      <td>-0.721558</td>\n",
       "      <td>0.316494</td>\n",
       "      <td>-0.097287</td>\n",
       "      <td>2.093168</td>\n",
       "      <td>1.573355</td>\n",
       "      <td>0.385847</td>\n",
       "      <td>-0.763057</td>\n",
       "      <td>-1.112411</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Z</th>\n",
       "      <td>1.191143</td>\n",
       "      <td>0.262749</td>\n",
       "      <td>0.480143</td>\n",
       "      <td>-1.744586</td>\n",
       "      <td>0.927438</td>\n",
       "      <td>0.454420</td>\n",
       "      <td>-1.110431</td>\n",
       "      <td>-0.471525</td>\n",
       "      <td>0.263717</td>\n",
       "      <td>0.052467</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          0         1         2         3         4         5         6  \\\n",
       "V -1.062414 -0.529439 -0.876861 -0.094263 -1.757728 -1.467045  2.129247   \n",
       "W  2.905067 -1.171567 -0.368249  0.341556  1.728698 -0.986857 -0.245278   \n",
       "X -0.133823 -1.374896 -0.238174 -0.266387  0.232170 -0.555327  0.471539   \n",
       "Y  0.053155  0.000084 -0.721558  0.316494 -0.097287  2.093168  1.573355   \n",
       "Z  1.191143  0.262749  0.480143 -1.744586  0.927438  0.454420 -1.110431   \n",
       "\n",
       "          7         8         9  \n",
       "V -1.287423 -1.096786  1.836914  \n",
       "W  0.777338  0.434766 -0.376156  \n",
       "X  1.012716  0.155429  0.351756  \n",
       "Y  0.385847 -0.763057 -1.112411  \n",
       "Z -0.471525  0.263717  0.052467  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.tail()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "09f36b39-ead5-4b39-9df3-70c4418d2317",
   "metadata": {},
   "source": [
    "### see different number of top/bottom rows"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "25316eb0-2fef-4385-b38c-ebda70cd7ed0",
   "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>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>9</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>A</th>\n",
       "      <td>0.412733</td>\n",
       "      <td>0.430821</td>\n",
       "      <td>2.141648</td>\n",
       "      <td>-0.406415</td>\n",
       "      <td>-0.512243</td>\n",
       "      <td>-0.813773</td>\n",
       "      <td>0.615979</td>\n",
       "      <td>1.128972</td>\n",
       "      <td>-0.113947</td>\n",
       "      <td>-0.840156</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>B</th>\n",
       "      <td>-0.824481</td>\n",
       "      <td>0.650593</td>\n",
       "      <td>0.743254</td>\n",
       "      <td>0.543154</td>\n",
       "      <td>-0.665510</td>\n",
       "      <td>0.232161</td>\n",
       "      <td>0.116686</td>\n",
       "      <td>0.218689</td>\n",
       "      <td>0.871429</td>\n",
       "      <td>0.223596</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          0         1         2         3         4         5         6  \\\n",
       "A  0.412733  0.430821  2.141648 -0.406415 -0.512243 -0.813773  0.615979   \n",
       "B -0.824481  0.650593  0.743254  0.543154 -0.665510  0.232161  0.116686   \n",
       "\n",
       "          7         8         9  \n",
       "A  1.128972 -0.113947 -0.840156  \n",
       "B  0.218689  0.871429  0.223596  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head(2)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "8a686617-6ffd-4ae8-a950-bd474ad624e4",
   "metadata": {},
   "source": [
    "### see a random sample of rows"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "20d08d61-a321-469c-9e61-24b5917bc8bc",
   "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>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>9</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>G</th>\n",
       "      <td>0.480747</td>\n",
       "      <td>0.446531</td>\n",
       "      <td>0.665385</td>\n",
       "      <td>-0.098485</td>\n",
       "      <td>-0.423298</td>\n",
       "      <td>-0.079718</td>\n",
       "      <td>-1.687334</td>\n",
       "      <td>-1.447112</td>\n",
       "      <td>-1.322700</td>\n",
       "      <td>-0.997247</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>I</th>\n",
       "      <td>0.840308</td>\n",
       "      <td>-1.727320</td>\n",
       "      <td>0.434424</td>\n",
       "      <td>0.237736</td>\n",
       "      <td>-0.594150</td>\n",
       "      <td>-1.446058</td>\n",
       "      <td>0.072130</td>\n",
       "      <td>-0.529493</td>\n",
       "      <td>0.232676</td>\n",
       "      <td>0.021852</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>N</th>\n",
       "      <td>-0.499296</td>\n",
       "      <td>-1.184944</td>\n",
       "      <td>-0.965117</td>\n",
       "      <td>-0.725226</td>\n",
       "      <td>2.128470</td>\n",
       "      <td>-0.821387</td>\n",
       "      <td>0.838489</td>\n",
       "      <td>-0.902927</td>\n",
       "      <td>0.931573</td>\n",
       "      <td>0.384951</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>R</th>\n",
       "      <td>-0.005122</td>\n",
       "      <td>-0.163443</td>\n",
       "      <td>0.337575</td>\n",
       "      <td>1.407482</td>\n",
       "      <td>0.090585</td>\n",
       "      <td>0.643939</td>\n",
       "      <td>-2.050172</td>\n",
       "      <td>-0.048718</td>\n",
       "      <td>-0.843230</td>\n",
       "      <td>-1.218813</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>F</th>\n",
       "      <td>0.625590</td>\n",
       "      <td>-0.309347</td>\n",
       "      <td>0.456775</td>\n",
       "      <td>-0.661926</td>\n",
       "      <td>-0.363054</td>\n",
       "      <td>-0.381738</td>\n",
       "      <td>-1.195840</td>\n",
       "      <td>0.486972</td>\n",
       "      <td>-0.469402</td>\n",
       "      <td>0.012494</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          0         1         2         3         4         5         6  \\\n",
       "G  0.480747  0.446531  0.665385 -0.098485 -0.423298 -0.079718 -1.687334   \n",
       "I  0.840308 -1.727320  0.434424  0.237736 -0.594150 -1.446058  0.072130   \n",
       "N -0.499296 -1.184944 -0.965117 -0.725226  2.128470 -0.821387  0.838489   \n",
       "R -0.005122 -0.163443  0.337575  1.407482  0.090585  0.643939 -2.050172   \n",
       "F  0.625590 -0.309347  0.456775 -0.661926 -0.363054 -0.381738 -1.195840   \n",
       "\n",
       "          7         8         9  \n",
       "G -1.447112 -1.322700 -0.997247  \n",
       "I -0.529493  0.232676  0.021852  \n",
       "N -0.902927  0.931573  0.384951  \n",
       "R -0.048718 -0.843230 -1.218813  \n",
       "F  0.486972 -0.469402  0.012494  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.sample(5)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "f36a95d5-46c6-46cd-a167-d0ca46a4f8f8",
   "metadata": {},
   "source": [
    "### get basic information about the dataframe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "ebe1ac22-0ad3-45ba-93e3-0f2d99539be8",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Index: 26 entries, A to Z\n",
      "Data columns (total 10 columns):\n",
      " #   Column  Non-Null Count  Dtype  \n",
      "---  ------  --------------  -----  \n",
      " 0   0       26 non-null     float64\n",
      " 1   1       26 non-null     float64\n",
      " 2   2       26 non-null     float64\n",
      " 3   3       26 non-null     float64\n",
      " 4   4       26 non-null     float64\n",
      " 5   5       26 non-null     float64\n",
      " 6   6       26 non-null     float64\n",
      " 7   7       26 non-null     float64\n",
      " 8   8       26 non-null     float64\n",
      " 9   9       26 non-null     float64\n",
      "dtypes: float64(10)\n",
      "memory usage: 2.2+ KB\n"
     ]
    }
   ],
   "source": [
    "df.info()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "e2be7115-e45c-4f8d-ad29-709a327bcaf6",
   "metadata": {},
   "source": [
    "### get summary statistics"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "e02181ac-f543-4153-8a4e-dc06d7d1ed27",
   "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>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>9</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>26.000000</td>\n",
       "      <td>26.000000</td>\n",
       "      <td>26.000000</td>\n",
       "      <td>26.000000</td>\n",
       "      <td>26.000000</td>\n",
       "      <td>26.000000</td>\n",
       "      <td>26.000000</td>\n",
       "      <td>26.000000</td>\n",
       "      <td>26.000000</td>\n",
       "      <td>26.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>0.213455</td>\n",
       "      <td>-0.086445</td>\n",
       "      <td>-0.019708</td>\n",
       "      <td>-0.196146</td>\n",
       "      <td>-0.213611</td>\n",
       "      <td>0.010416</td>\n",
       "      <td>-0.209495</td>\n",
       "      <td>0.078737</td>\n",
       "      <td>0.034164</td>\n",
       "      <td>0.049044</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>1.017632</td>\n",
       "      <td>0.968577</td>\n",
       "      <td>0.958027</td>\n",
       "      <td>0.792970</td>\n",
       "      <td>0.965434</td>\n",
       "      <td>0.964080</td>\n",
       "      <td>1.015842</td>\n",
       "      <td>0.870329</td>\n",
       "      <td>0.990060</td>\n",
       "      <td>0.914550</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>-1.368159</td>\n",
       "      <td>-1.727320</td>\n",
       "      <td>-1.682870</td>\n",
       "      <td>-1.744586</td>\n",
       "      <td>-2.132046</td>\n",
       "      <td>-1.467045</td>\n",
       "      <td>-2.050172</td>\n",
       "      <td>-1.447112</td>\n",
       "      <td>-2.147289</td>\n",
       "      <td>-1.224469</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>-0.604638</td>\n",
       "      <td>-0.654317</td>\n",
       "      <td>-0.704865</td>\n",
       "      <td>-0.709401</td>\n",
       "      <td>-0.573673</td>\n",
       "      <td>-0.749161</td>\n",
       "      <td>-1.063689</td>\n",
       "      <td>-0.611532</td>\n",
       "      <td>-0.576423</td>\n",
       "      <td>-0.445415</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>0.024017</td>\n",
       "      <td>-0.177374</td>\n",
       "      <td>-0.191247</td>\n",
       "      <td>-0.139002</td>\n",
       "      <td>-0.359659</td>\n",
       "      <td>-0.150970</td>\n",
       "      <td>-0.149530</td>\n",
       "      <td>0.195638</td>\n",
       "      <td>0.142852</td>\n",
       "      <td>0.017173</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>0.799959</td>\n",
       "      <td>0.280057</td>\n",
       "      <td>0.474301</td>\n",
       "      <td>0.297995</td>\n",
       "      <td>0.209141</td>\n",
       "      <td>0.629510</td>\n",
       "      <td>0.460843</td>\n",
       "      <td>0.755625</td>\n",
       "      <td>0.512278</td>\n",
       "      <td>0.376652</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>2.905067</td>\n",
       "      <td>2.913862</td>\n",
       "      <td>2.141648</td>\n",
       "      <td>1.407482</td>\n",
       "      <td>2.128470</td>\n",
       "      <td>2.093168</td>\n",
       "      <td>2.129247</td>\n",
       "      <td>1.767930</td>\n",
       "      <td>2.517474</td>\n",
       "      <td>1.876845</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "               0          1          2          3          4          5  \\\n",
       "count  26.000000  26.000000  26.000000  26.000000  26.000000  26.000000   \n",
       "mean    0.213455  -0.086445  -0.019708  -0.196146  -0.213611   0.010416   \n",
       "std     1.017632   0.968577   0.958027   0.792970   0.965434   0.964080   \n",
       "min    -1.368159  -1.727320  -1.682870  -1.744586  -2.132046  -1.467045   \n",
       "25%    -0.604638  -0.654317  -0.704865  -0.709401  -0.573673  -0.749161   \n",
       "50%     0.024017  -0.177374  -0.191247  -0.139002  -0.359659  -0.150970   \n",
       "75%     0.799959   0.280057   0.474301   0.297995   0.209141   0.629510   \n",
       "max     2.905067   2.913862   2.141648   1.407482   2.128470   2.093168   \n",
       "\n",
       "               6          7          8          9  \n",
       "count  26.000000  26.000000  26.000000  26.000000  \n",
       "mean   -0.209495   0.078737   0.034164   0.049044  \n",
       "std     1.015842   0.870329   0.990060   0.914550  \n",
       "min    -2.050172  -1.447112  -2.147289  -1.224469  \n",
       "25%    -1.063689  -0.611532  -0.576423  -0.445415  \n",
       "50%    -0.149530   0.195638   0.142852   0.017173  \n",
       "75%     0.460843   0.755625   0.512278   0.376652  \n",
       "max     2.129247   1.767930   2.517474   1.876845  "
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.describe()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "f8be8831-c48e-4d31-8aaa-cf4aec0bd779",
   "metadata": {},
   "source": [
    "### see only the datatypes by column"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "087f0807-ac74-4e6b-9672-4bf3971bd75d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'0': dtype('float64'),\n",
       " '1': dtype('float64'),\n",
       " '2': dtype('float64'),\n",
       " '3': dtype('float64'),\n",
       " '4': dtype('float64'),\n",
       " '5': dtype('float64'),\n",
       " '6': dtype('float64'),\n",
       " '7': dtype('float64'),\n",
       " '8': dtype('float64'),\n",
       " '9': dtype('float64')}"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dict(zip(df.columns, df.dtypes))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "bdbfb946-e6c9-4368-9072-36a63d39d1ee",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.10.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}