Lecture_1.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Data Analysis with Python\n",
    "## Lecture 01: Importing Data with Pandas\n",
    "<br>Instructor: Md Shahidullah Kawsar\n",
    "<br>Data Scientist, IDARE, Houston, TX, USA\n",
    "\n",
    "**Objectives:**\n",
    "- challenges of reading a .csv file\n",
    "- How to deal with UnicodeDecodeError?\n",
    "- reading a csv file by changing the engine\n",
    "- choose columns by name before reading a csv file\n",
    "- choose columns by number before reading a csv file\n",
    "- reading only the first n number of rows\n",
    "\n",
    "**References:**\n",
    "<br>[1] Data Source: https://stats.espncricinfo.com/ci/content/records/223646.html\n",
    "<br>[2] https://pandas.pydata.org/docs/reference/api/pandas.read_csv.html\n",
    "<br>[3] https://docs.python.org/3/library/codecs.html#standard-encodings\n",
    "<br>[4] https://stackoverflow.com/questions/22216076/unicodedecodeerror-utf8-codec-cant-decode-byte-0xa5-in-position-0-invalid-s"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Import required libraries"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### How to read a csv file?\n",
    "#### How to deal with UnicodeDecodeError?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "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>Player</th>\n",
       "      <th>Span</th>\n",
       "      <th>Mat</th>\n",
       "      <th>Inns</th>\n",
       "      <th>NO</th>\n",
       "      <th>Runs</th>\n",
       "      <th>HS</th>\n",
       "      <th>Ave</th>\n",
       "      <th>100</th>\n",
       "      <th>50</th>\n",
       "      <th>0</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>SR Tendulkar (INDIA)</td>\n",
       "      <td>1989-2013</td>\n",
       "      <td>200</td>\n",
       "      <td>329</td>\n",
       "      <td>33</td>\n",
       "      <td>15921</td>\n",
       "      <td>248*</td>\n",
       "      <td>53.78</td>\n",
       "      <td>51</td>\n",
       "      <td>68</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>RT Ponting (AUS)</td>\n",
       "      <td>1995-2012</td>\n",
       "      <td>168</td>\n",
       "      <td>287</td>\n",
       "      <td>29</td>\n",
       "      <td>13378</td>\n",
       "      <td>257</td>\n",
       "      <td>51.85</td>\n",
       "      <td>41</td>\n",
       "      <td>62</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>JH Kallis (ICC/SA)</td>\n",
       "      <td>1995-2013</td>\n",
       "      <td>166</td>\n",
       "      <td>280</td>\n",
       "      <td>40</td>\n",
       "      <td>13289</td>\n",
       "      <td>224</td>\n",
       "      <td>55.37</td>\n",
       "      <td>45</td>\n",
       "      <td>58</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>R Dravid (ICC/INDIA)</td>\n",
       "      <td>1996-2012</td>\n",
       "      <td>164</td>\n",
       "      <td>286</td>\n",
       "      <td>32</td>\n",
       "      <td>13288</td>\n",
       "      <td>270</td>\n",
       "      <td>52.31</td>\n",
       "      <td>36</td>\n",
       "      <td>63</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>AN Cook (ENG)</td>\n",
       "      <td>2006-2018</td>\n",
       "      <td>161</td>\n",
       "      <td>291</td>\n",
       "      <td>16</td>\n",
       "      <td>12472</td>\n",
       "      <td>294</td>\n",
       "      <td>45.35</td>\n",
       "      <td>33</td>\n",
       "      <td>57</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 Player       Span  Mat  Inns  NO   Runs    HS    Ave  100  \\\n",
       "0  SR Tendulkar (INDIA)  1989-2013  200   329  33  15921  248*  53.78   51   \n",
       "1      RT Ponting (AUS)  1995-2012  168   287  29  13378   257  51.85   41   \n",
       "2    JH Kallis (ICC/SA)  1995-2013  166   280  40  13289   224  55.37   45   \n",
       "3  R Dravid (ICC/INDIA)  1996-2012  164   286  32  13288   270  52.31   36   \n",
       "4         AN Cook (ENG)  2006-2018  161   291  16  12472   294  45.35   33   \n",
       "\n",
       "   50   0  \n",
       "0  68  14  \n",
       "1  62  17  \n",
       "2  58  16  \n",
       "3  63   8  \n",
       "4  57   9  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(97, 11)\n"
     ]
    }
   ],
   "source": [
    "# method 1\n",
    "# reading a csv file \n",
    "df = pd.read_csv(\"most_runs_in_test_cricket.csv\", encoding = \"ISO-8859-1\")\n",
    "\n",
    "display(df.head())\n",
    "# print(df.tail())\n",
    "print(df.shape)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "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>Player</th>\n",
       "      <th>Span</th>\n",
       "      <th>Mat</th>\n",
       "      <th>Inns</th>\n",
       "      <th>NO</th>\n",
       "      <th>Runs</th>\n",
       "      <th>HS</th>\n",
       "      <th>Ave</th>\n",
       "      <th>100</th>\n",
       "      <th>50</th>\n",
       "      <th>0</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>SR Tendulkar (INDIA)</td>\n",
       "      <td>1989-2013</td>\n",
       "      <td>200</td>\n",
       "      <td>329</td>\n",
       "      <td>33</td>\n",
       "      <td>15921</td>\n",
       "      <td>248*</td>\n",
       "      <td>53.78</td>\n",
       "      <td>51</td>\n",
       "      <td>68</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>RT Ponting (AUS)</td>\n",
       "      <td>1995-2012</td>\n",
       "      <td>168</td>\n",
       "      <td>287</td>\n",
       "      <td>29</td>\n",
       "      <td>13378</td>\n",
       "      <td>257</td>\n",
       "      <td>51.85</td>\n",
       "      <td>41</td>\n",
       "      <td>62</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>JH Kallis (ICC/SA)</td>\n",
       "      <td>1995-2013</td>\n",
       "      <td>166</td>\n",
       "      <td>280</td>\n",
       "      <td>40</td>\n",
       "      <td>13289</td>\n",
       "      <td>224</td>\n",
       "      <td>55.37</td>\n",
       "      <td>45</td>\n",
       "      <td>58</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>R Dravid (ICC/INDIA)</td>\n",
       "      <td>1996-2012</td>\n",
       "      <td>164</td>\n",
       "      <td>286</td>\n",
       "      <td>32</td>\n",
       "      <td>13288</td>\n",
       "      <td>270</td>\n",
       "      <td>52.31</td>\n",
       "      <td>36</td>\n",
       "      <td>63</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>AN Cook (ENG)</td>\n",
       "      <td>2006-2018</td>\n",
       "      <td>161</td>\n",
       "      <td>291</td>\n",
       "      <td>16</td>\n",
       "      <td>12472</td>\n",
       "      <td>294</td>\n",
       "      <td>45.35</td>\n",
       "      <td>33</td>\n",
       "      <td>57</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 Player       Span  Mat  Inns  NO   Runs    HS    Ave  100  \\\n",
       "0  SR Tendulkar (INDIA)  1989-2013  200   329  33  15921  248*  53.78   51   \n",
       "1      RT Ponting (AUS)  1995-2012  168   287  29  13378   257  51.85   41   \n",
       "2    JH Kallis (ICC/SA)  1995-2013  166   280  40  13289   224  55.37   45   \n",
       "3  R Dravid (ICC/INDIA)  1996-2012  164   286  32  13288   270  52.31   36   \n",
       "4         AN Cook (ENG)  2006-2018  161   291  16  12472   294  45.35   33   \n",
       "\n",
       "   50   0  \n",
       "0  68  14  \n",
       "1  62  17  \n",
       "2  58  16  \n",
       "3  63   8  \n",
       "4  57   9  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# method 2\n",
    "df = pd.read_csv(\"most_runs_in_test_cricket.csv\", encoding = 'unicode_escape')\n",
    "\n",
    "display(df.head())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "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>Player</th>\n",
       "      <th>Span</th>\n",
       "      <th>Mat</th>\n",
       "      <th>Inns</th>\n",
       "      <th>NO</th>\n",
       "      <th>Runs</th>\n",
       "      <th>HS</th>\n",
       "      <th>Ave</th>\n",
       "      <th>100</th>\n",
       "      <th>50</th>\n",
       "      <th>0</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>SR Tendulkar (INDIA)</td>\n",
       "      <td>1989-2013</td>\n",
       "      <td>200</td>\n",
       "      <td>329</td>\n",
       "      <td>33</td>\n",
       "      <td>15921</td>\n",
       "      <td>248*</td>\n",
       "      <td>53.78</td>\n",
       "      <td>51</td>\n",
       "      <td>68</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>RT Ponting (AUS)</td>\n",
       "      <td>1995-2012</td>\n",
       "      <td>168</td>\n",
       "      <td>287</td>\n",
       "      <td>29</td>\n",
       "      <td>13378</td>\n",
       "      <td>257</td>\n",
       "      <td>51.85</td>\n",
       "      <td>41</td>\n",
       "      <td>62</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>JH Kallis (ICC/SA)</td>\n",
       "      <td>1995-2013</td>\n",
       "      <td>166</td>\n",
       "      <td>280</td>\n",
       "      <td>40</td>\n",
       "      <td>13289</td>\n",
       "      <td>224</td>\n",
       "      <td>55.37</td>\n",
       "      <td>45</td>\n",
       "      <td>58</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>R Dravid (ICC/INDIA)</td>\n",
       "      <td>1996-2012</td>\n",
       "      <td>164</td>\n",
       "      <td>286</td>\n",
       "      <td>32</td>\n",
       "      <td>13288</td>\n",
       "      <td>270</td>\n",
       "      <td>52.31</td>\n",
       "      <td>36</td>\n",
       "      <td>63</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>AN Cook (ENG)</td>\n",
       "      <td>2006-2018</td>\n",
       "      <td>161</td>\n",
       "      <td>291</td>\n",
       "      <td>16</td>\n",
       "      <td>12472</td>\n",
       "      <td>294</td>\n",
       "      <td>45.35</td>\n",
       "      <td>33</td>\n",
       "      <td>57</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 Player       Span  Mat  Inns  NO   Runs    HS    Ave  100  \\\n",
       "0  SR Tendulkar (INDIA)  1989-2013  200   329  33  15921  248*  53.78   51   \n",
       "1      RT Ponting (AUS)  1995-2012  168   287  29  13378   257  51.85   41   \n",
       "2    JH Kallis (ICC/SA)  1995-2013  166   280  40  13289   224  55.37   45   \n",
       "3  R Dravid (ICC/INDIA)  1996-2012  164   286  32  13288   270  52.31   36   \n",
       "4         AN Cook (ENG)  2006-2018  161   291  16  12472   294  45.35   33   \n",
       "\n",
       "   50   0  \n",
       "0  68  14  \n",
       "1  62  17  \n",
       "2  58  16  \n",
       "3  63   8  \n",
       "4  57   9  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# method 3\n",
    "# reading a csv file by changing the engine\n",
    "df = pd.read_csv(\"most_runs_in_test_cricket.csv\", engine = 'python')\n",
    "\n",
    "# removing the weird \"�\" symbol from the 'Player' column\n",
    "df['Player'] = df['Player'].str.replace(\"�\", \" \")\n",
    "display(df.head())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "number of rows =  97\n",
      "number of columns =  11\n"
     ]
    }
   ],
   "source": [
    "# number of rows\n",
    "print(\"number of rows = \", df.shape[0])\n",
    "\n",
    "# number of columns\n",
    "print(\"number of columns = \", df.shape[1])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 97 entries, 0 to 96\n",
      "Data columns (total 11 columns):\n",
      " #   Column  Non-Null Count  Dtype  \n",
      "---  ------  --------------  -----  \n",
      " 0   Player  97 non-null     object \n",
      " 1   Span    97 non-null     object \n",
      " 2   Mat     97 non-null     int64  \n",
      " 3   Inns    97 non-null     int64  \n",
      " 4   NO      97 non-null     int64  \n",
      " 5   Runs    97 non-null     int64  \n",
      " 6   HS      97 non-null     object \n",
      " 7   Ave     97 non-null     float64\n",
      " 8   100     97 non-null     int64  \n",
      " 9   50      97 non-null     int64  \n",
      " 10  0       97 non-null     int64  \n",
      "dtypes: float64(1), int64(7), object(3)\n",
      "memory usage: 8.5+ KB\n",
      "None\n"
     ]
    }
   ],
   "source": [
    "# checking for missing values and data types of each column\n",
    "print(df.info())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "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>Mat</th>\n",
       "      <th>Inns</th>\n",
       "      <th>NO</th>\n",
       "      <th>Runs</th>\n",
       "      <th>Ave</th>\n",
       "      <th>100</th>\n",
       "      <th>50</th>\n",
       "      <th>0</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>97.000000</td>\n",
       "      <td>97.000000</td>\n",
       "      <td>97.000000</td>\n",
       "      <td>97.000000</td>\n",
       "      <td>97.000000</td>\n",
       "      <td>97.000000</td>\n",
       "      <td>97.000000</td>\n",
       "      <td>97.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>104.979381</td>\n",
       "      <td>178.752577</td>\n",
       "      <td>16.051546</td>\n",
       "      <td>7574.175258</td>\n",
       "      <td>46.781031</td>\n",
       "      <td>20.546392</td>\n",
       "      <td>35.474227</td>\n",
       "      <td>11.329897</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>27.064729</td>\n",
       "      <td>44.963418</td>\n",
       "      <td>8.754012</td>\n",
       "      <td>2224.255278</td>\n",
       "      <td>8.168268</td>\n",
       "      <td>8.226001</td>\n",
       "      <td>11.499178</td>\n",
       "      <td>4.147594</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>52.000000</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>5062.000000</td>\n",
       "      <td>30.300000</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>13.000000</td>\n",
       "      <td>2.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>86.000000</td>\n",
       "      <td>146.000000</td>\n",
       "      <td>10.000000</td>\n",
       "      <td>5825.000000</td>\n",
       "      <td>42.290000</td>\n",
       "      <td>15.000000</td>\n",
       "      <td>27.000000</td>\n",
       "      <td>9.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>102.000000</td>\n",
       "      <td>176.000000</td>\n",
       "      <td>15.000000</td>\n",
       "      <td>7214.000000</td>\n",
       "      <td>45.840000</td>\n",
       "      <td>19.000000</td>\n",
       "      <td>33.000000</td>\n",
       "      <td>11.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>117.000000</td>\n",
       "      <td>200.000000</td>\n",
       "      <td>20.000000</td>\n",
       "      <td>8540.000000</td>\n",
       "      <td>50.660000</td>\n",
       "      <td>24.000000</td>\n",
       "      <td>42.000000</td>\n",
       "      <td>14.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>200.000000</td>\n",
       "      <td>329.000000</td>\n",
       "      <td>49.000000</td>\n",
       "      <td>15921.000000</td>\n",
       "      <td>99.940000</td>\n",
       "      <td>51.000000</td>\n",
       "      <td>68.000000</td>\n",
       "      <td>22.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              Mat        Inns         NO          Runs        Ave        100  \\\n",
       "count   97.000000   97.000000  97.000000     97.000000  97.000000  97.000000   \n",
       "mean   104.979381  178.752577  16.051546   7574.175258  46.781031  20.546392   \n",
       "std     27.064729   44.963418   8.754012   2224.255278   8.168268   8.226001   \n",
       "min     52.000000   80.000000   5.000000   5062.000000  30.300000   4.000000   \n",
       "25%     86.000000  146.000000  10.000000   5825.000000  42.290000  15.000000   \n",
       "50%    102.000000  176.000000  15.000000   7214.000000  45.840000  19.000000   \n",
       "75%    117.000000  200.000000  20.000000   8540.000000  50.660000  24.000000   \n",
       "max    200.000000  329.000000  49.000000  15921.000000  99.940000  51.000000   \n",
       "\n",
       "              50          0  \n",
       "count  97.000000  97.000000  \n",
       "mean   35.474227  11.329897  \n",
       "std    11.499178   4.147594  \n",
       "min    13.000000   2.000000  \n",
       "25%    27.000000   9.000000  \n",
       "50%    33.000000  11.000000  \n",
       "75%    42.000000  14.000000  \n",
       "max    68.000000  22.000000  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# checking data statistics\n",
    "display(df.describe())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Index(['Player', 'Span', 'Mat', 'Inns', 'NO', 'Runs', 'HS', 'Ave', '100', '50',\n",
      "       '0'],\n",
      "      dtype='object')\n"
     ]
    }
   ],
   "source": [
    "# column names\n",
    "print(df.columns)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### choose columns by name to read a csv file"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "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>Player</th>\n",
       "      <th>Mat</th>\n",
       "      <th>Runs</th>\n",
       "      <th>100</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>SR Tendulkar (INDIA)</td>\n",
       "      <td>200</td>\n",
       "      <td>15921</td>\n",
       "      <td>51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>RT Ponting (AUS)</td>\n",
       "      <td>168</td>\n",
       "      <td>13378</td>\n",
       "      <td>41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>JH Kallis (ICC/SA)</td>\n",
       "      <td>166</td>\n",
       "      <td>13289</td>\n",
       "      <td>45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>R Dravid (ICC/INDIA)</td>\n",
       "      <td>164</td>\n",
       "      <td>13288</td>\n",
       "      <td>36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>AN Cook (ENG)</td>\n",
       "      <td>161</td>\n",
       "      <td>12472</td>\n",
       "      <td>33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>KC Sangakkara (SL)</td>\n",
       "      <td>134</td>\n",
       "      <td>12400</td>\n",
       "      <td>38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>BC Lara (ICC/WI)</td>\n",
       "      <td>131</td>\n",
       "      <td>11953</td>\n",
       "      <td>34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>S Chanderpaul (WI)</td>\n",
       "      <td>164</td>\n",
       "      <td>11867</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>DPMD Jayawardene (SL)</td>\n",
       "      <td>149</td>\n",
       "      <td>11814</td>\n",
       "      <td>34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>AR Border (AUS)</td>\n",
       "      <td>156</td>\n",
       "      <td>11174</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  Player  Mat   Runs  100\n",
       "0   SR Tendulkar (INDIA)  200  15921   51\n",
       "1       RT Ponting (AUS)  168  13378   41\n",
       "2     JH Kallis (ICC/SA)  166  13289   45\n",
       "3   R Dravid (ICC/INDIA)  164  13288   36\n",
       "4          AN Cook (ENG)  161  12472   33\n",
       "5     KC Sangakkara (SL)  134  12400   38\n",
       "6       BC Lara (ICC/WI)  131  11953   34\n",
       "7     S Chanderpaul (WI)  164  11867   30\n",
       "8  DPMD Jayawardene (SL)  149  11814   34\n",
       "9        AR Border (AUS)  156  11174   27"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "col_names = ['Player', 'Mat', 'Runs', '100']\n",
    "df_usecols = pd.read_csv(\"most_runs_in_test_cricket.csv\", encoding = 'unicode_escape', usecols=col_names)\n",
    "\n",
    "display(df_usecols.head(10))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(97, 11)\n",
      "(97, 4)\n"
     ]
    }
   ],
   "source": [
    "print(df.shape)\n",
    "\n",
    "# selecting columns after data importing\n",
    "df = df[col_names]\n",
    "\n",
    "print(df.shape)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### choose columns by number to read a csv file"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "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>Player</th>\n",
       "      <th>Mat</th>\n",
       "      <th>Runs</th>\n",
       "      <th>100</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>SR Tendulkar (INDIA)</td>\n",
       "      <td>200</td>\n",
       "      <td>15921</td>\n",
       "      <td>51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>RT Ponting (AUS)</td>\n",
       "      <td>168</td>\n",
       "      <td>13378</td>\n",
       "      <td>41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>JH Kallis (ICC/SA)</td>\n",
       "      <td>166</td>\n",
       "      <td>13289</td>\n",
       "      <td>45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>R Dravid (ICC/INDIA)</td>\n",
       "      <td>164</td>\n",
       "      <td>13288</td>\n",
       "      <td>36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>AN Cook (ENG)</td>\n",
       "      <td>161</td>\n",
       "      <td>12472</td>\n",
       "      <td>33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>KC Sangakkara (SL)</td>\n",
       "      <td>134</td>\n",
       "      <td>12400</td>\n",
       "      <td>38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>BC Lara (ICC/WI)</td>\n",
       "      <td>131</td>\n",
       "      <td>11953</td>\n",
       "      <td>34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>S Chanderpaul (WI)</td>\n",
       "      <td>164</td>\n",
       "      <td>11867</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>DPMD Jayawardene (SL)</td>\n",
       "      <td>149</td>\n",
       "      <td>11814</td>\n",
       "      <td>34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>AR Border (AUS)</td>\n",
       "      <td>156</td>\n",
       "      <td>11174</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  Player  Mat   Runs  100\n",
       "0   SR Tendulkar (INDIA)  200  15921   51\n",
       "1       RT Ponting (AUS)  168  13378   41\n",
       "2     JH Kallis (ICC/SA)  166  13289   45\n",
       "3   R Dravid (ICC/INDIA)  164  13288   36\n",
       "4          AN Cook (ENG)  161  12472   33\n",
       "5     KC Sangakkara (SL)  134  12400   38\n",
       "6       BC Lara (ICC/WI)  131  11953   34\n",
       "7     S Chanderpaul (WI)  164  11867   30\n",
       "8  DPMD Jayawardene (SL)  149  11814   34\n",
       "9        AR Border (AUS)  156  11174   27"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(97, 4)\n"
     ]
    }
   ],
   "source": [
    "col_nums = [0, 2, 5, 8]\n",
    "df_usecols_index = pd.read_csv(\"most_runs_in_test_cricket.csv\", encoding = 'unicode_escape', usecols=col_nums)\n",
    "\n",
    "display(df_usecols_index.head(10))\n",
    "print(df_usecols_index.shape)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### reading only the first n number of rows"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "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>Player</th>\n",
       "      <th>Span</th>\n",
       "      <th>Mat</th>\n",
       "      <th>Inns</th>\n",
       "      <th>NO</th>\n",
       "      <th>Runs</th>\n",
       "      <th>HS</th>\n",
       "      <th>Ave</th>\n",
       "      <th>100</th>\n",
       "      <th>50</th>\n",
       "      <th>0</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>SR Tendulkar (INDIA)</td>\n",
       "      <td>1989-2013</td>\n",
       "      <td>200</td>\n",
       "      <td>329</td>\n",
       "      <td>33</td>\n",
       "      <td>15921</td>\n",
       "      <td>248*</td>\n",
       "      <td>53.78</td>\n",
       "      <td>51</td>\n",
       "      <td>68</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>RT Ponting (AUS)</td>\n",
       "      <td>1995-2012</td>\n",
       "      <td>168</td>\n",
       "      <td>287</td>\n",
       "      <td>29</td>\n",
       "      <td>13378</td>\n",
       "      <td>257</td>\n",
       "      <td>51.85</td>\n",
       "      <td>41</td>\n",
       "      <td>62</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>JH Kallis (ICC/SA)</td>\n",
       "      <td>1995-2013</td>\n",
       "      <td>166</td>\n",
       "      <td>280</td>\n",
       "      <td>40</td>\n",
       "      <td>13289</td>\n",
       "      <td>224</td>\n",
       "      <td>55.37</td>\n",
       "      <td>45</td>\n",
       "      <td>58</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>R Dravid (ICC/INDIA)</td>\n",
       "      <td>1996-2012</td>\n",
       "      <td>164</td>\n",
       "      <td>286</td>\n",
       "      <td>32</td>\n",
       "      <td>13288</td>\n",
       "      <td>270</td>\n",
       "      <td>52.31</td>\n",
       "      <td>36</td>\n",
       "      <td>63</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>AN Cook (ENG)</td>\n",
       "      <td>2006-2018</td>\n",
       "      <td>161</td>\n",
       "      <td>291</td>\n",
       "      <td>16</td>\n",
       "      <td>12472</td>\n",
       "      <td>294</td>\n",
       "      <td>45.35</td>\n",
       "      <td>33</td>\n",
       "      <td>57</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>KC Sangakkara (SL)</td>\n",
       "      <td>2000-2015</td>\n",
       "      <td>134</td>\n",
       "      <td>233</td>\n",
       "      <td>17</td>\n",
       "      <td>12400</td>\n",
       "      <td>319</td>\n",
       "      <td>57.40</td>\n",
       "      <td>38</td>\n",
       "      <td>52</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>BC Lara (ICC/WI)</td>\n",
       "      <td>1990-2006</td>\n",
       "      <td>131</td>\n",
       "      <td>232</td>\n",
       "      <td>6</td>\n",
       "      <td>11953</td>\n",
       "      <td>400*</td>\n",
       "      <td>52.88</td>\n",
       "      <td>34</td>\n",
       "      <td>48</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>S Chanderpaul (WI)</td>\n",
       "      <td>1994-2015</td>\n",
       "      <td>164</td>\n",
       "      <td>280</td>\n",
       "      <td>49</td>\n",
       "      <td>11867</td>\n",
       "      <td>203*</td>\n",
       "      <td>51.37</td>\n",
       "      <td>30</td>\n",
       "      <td>66</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>DPMD Jayawardene (SL)</td>\n",
       "      <td>1997-2014</td>\n",
       "      <td>149</td>\n",
       "      <td>252</td>\n",
       "      <td>15</td>\n",
       "      <td>11814</td>\n",
       "      <td>374</td>\n",
       "      <td>49.84</td>\n",
       "      <td>34</td>\n",
       "      <td>50</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>AR Border (AUS)</td>\n",
       "      <td>1978-1994</td>\n",
       "      <td>156</td>\n",
       "      <td>265</td>\n",
       "      <td>44</td>\n",
       "      <td>11174</td>\n",
       "      <td>205</td>\n",
       "      <td>50.56</td>\n",
       "      <td>27</td>\n",
       "      <td>63</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>SR Waugh (AUS)</td>\n",
       "      <td>1985-2004</td>\n",
       "      <td>168</td>\n",
       "      <td>260</td>\n",
       "      <td>46</td>\n",
       "      <td>10927</td>\n",
       "      <td>200</td>\n",
       "      <td>51.06</td>\n",
       "      <td>32</td>\n",
       "      <td>50</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>SM Gavaskar (INDIA)</td>\n",
       "      <td>1971-1987</td>\n",
       "      <td>125</td>\n",
       "      <td>214</td>\n",
       "      <td>16</td>\n",
       "      <td>10122</td>\n",
       "      <td>236*</td>\n",
       "      <td>51.12</td>\n",
       "      <td>34</td>\n",
       "      <td>45</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Younis Khan (PAK)</td>\n",
       "      <td>2000-2017</td>\n",
       "      <td>118</td>\n",
       "      <td>213</td>\n",
       "      <td>19</td>\n",
       "      <td>10099</td>\n",
       "      <td>313</td>\n",
       "      <td>52.05</td>\n",
       "      <td>34</td>\n",
       "      <td>33</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>HM Amla (SA)</td>\n",
       "      <td>2004-2019</td>\n",
       "      <td>124</td>\n",
       "      <td>215</td>\n",
       "      <td>16</td>\n",
       "      <td>9282</td>\n",
       "      <td>311*</td>\n",
       "      <td>46.64</td>\n",
       "      <td>28</td>\n",
       "      <td>41</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>GC Smith (ICC/SA)</td>\n",
       "      <td>2002-2014</td>\n",
       "      <td>117</td>\n",
       "      <td>205</td>\n",
       "      <td>13</td>\n",
       "      <td>9265</td>\n",
       "      <td>277</td>\n",
       "      <td>48.25</td>\n",
       "      <td>27</td>\n",
       "      <td>38</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                   Player       Span  Mat  Inns  NO   Runs    HS    Ave  100  \\\n",
       "0    SR Tendulkar (INDIA)  1989-2013  200   329  33  15921  248*  53.78   51   \n",
       "1        RT Ponting (AUS)  1995-2012  168   287  29  13378   257  51.85   41   \n",
       "2      JH Kallis (ICC/SA)  1995-2013  166   280  40  13289   224  55.37   45   \n",
       "3    R Dravid (ICC/INDIA)  1996-2012  164   286  32  13288   270  52.31   36   \n",
       "4           AN Cook (ENG)  2006-2018  161   291  16  12472   294  45.35   33   \n",
       "5      KC Sangakkara (SL)  2000-2015  134   233  17  12400   319  57.40   38   \n",
       "6        BC Lara (ICC/WI)  1990-2006  131   232   6  11953  400*  52.88   34   \n",
       "7      S Chanderpaul (WI)  1994-2015  164   280  49  11867  203*  51.37   30   \n",
       "8   DPMD Jayawardene (SL)  1997-2014  149   252  15  11814   374  49.84   34   \n",
       "9         AR Border (AUS)  1978-1994  156   265  44  11174   205  50.56   27   \n",
       "10         SR Waugh (AUS)  1985-2004  168   260  46  10927   200  51.06   32   \n",
       "11    SM Gavaskar (INDIA)  1971-1987  125   214  16  10122  236*  51.12   34   \n",
       "12      Younis Khan (PAK)  2000-2017  118   213  19  10099   313  52.05   34   \n",
       "13           HM Amla (SA)  2004-2019  124   215  16   9282  311*  46.64   28   \n",
       "14      GC Smith (ICC/SA)  2002-2014  117   205  13   9265   277  48.25   27   \n",
       "\n",
       "    50   0  \n",
       "0   68  14  \n",
       "1   62  17  \n",
       "2   58  16  \n",
       "3   63   8  \n",
       "4   57   9  \n",
       "5   52  11  \n",
       "6   48  17  \n",
       "7   66  15  \n",
       "8   50  15  \n",
       "9   63  11  \n",
       "10  50  22  \n",
       "11  45  12  \n",
       "12  33  19  \n",
       "13  41  13  \n",
       "14  38  11  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(50, 11)\n"
     ]
    }
   ],
   "source": [
    "df = pd.read_csv(\"most_runs_in_test_cricket.csv\", encoding = 'unicode_escape', nrows=50)\n",
    "\n",
    "display(df.head(15))\n",
    "print(df.shape)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "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>Player</th>\n",
       "      <th>Span</th>\n",
       "      <th>Mat</th>\n",
       "      <th>Inns</th>\n",
       "      <th>NO</th>\n",
       "      <th>Runs</th>\n",
       "      <th>HS</th>\n",
       "      <th>Ave</th>\n",
       "      <th>100</th>\n",
       "      <th>50</th>\n",
       "      <th>0</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>SPD Smith (AUS)</td>\n",
       "      <td>2010-2021</td>\n",
       "      <td>77</td>\n",
       "      <td>139</td>\n",
       "      <td>17</td>\n",
       "      <td>7540</td>\n",
       "      <td>239</td>\n",
       "      <td>61.80</td>\n",
       "      <td>27</td>\n",
       "      <td>31</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>MC Cowdrey (ENG)</td>\n",
       "      <td>1954-1975</td>\n",
       "      <td>114</td>\n",
       "      <td>188</td>\n",
       "      <td>15</td>\n",
       "      <td>7624</td>\n",
       "      <td>182</td>\n",
       "      <td>44.06</td>\n",
       "      <td>22</td>\n",
       "      <td>38</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              Player       Span  Mat  Inns  NO  Runs   HS    Ave  100  50  0\n",
       "38   SPD Smith (AUS)  2010-2021   77   139  17  7540  239  61.80   27  31  5\n",
       "34  MC Cowdrey (ENG)  1954-1975  114   188  15  7624  182  44.06   22  38  9"
      ]
     },
     "execution_count": 61,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# showing randomly 2 different rows\n",
    "df.sample(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "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.8.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}