pandas DataFrame  4.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "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>Longitude</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Epicentre</th>\n",
       "      <th>Time</th>\n",
       "      <th>Magnitude</th>\n",
       "      <th>Date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>85.39</td>\n",
       "      <td>27.58</td>\n",
       "      <td>Lalitpur</td>\n",
       "      <td>14:45</td>\n",
       "      <td>4.1</td>\n",
       "      <td>2015/06/26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>85.49</td>\n",
       "      <td>27.94</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>23:51</td>\n",
       "      <td>4.2</td>\n",
       "      <td>2015/06/25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>86.21</td>\n",
       "      <td>27.66</td>\n",
       "      <td>Dolakha</td>\n",
       "      <td>23:49</td>\n",
       "      <td>4.1</td>\n",
       "      <td>2015/06/25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>85.17</td>\n",
       "      <td>27.78</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>21:07</td>\n",
       "      <td>4.3</td>\n",
       "      <td>2015/06/25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>85.75</td>\n",
       "      <td>27.85</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>14:59</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/06/24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>438</th>\n",
       "      <td>85.35</td>\n",
       "      <td>28.05</td>\n",
       "      <td>Rasuwa</td>\n",
       "      <td>01:49</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/04/26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>439</th>\n",
       "      <td>85.56</td>\n",
       "      <td>27.93</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>01:29</td>\n",
       "      <td>4.1</td>\n",
       "      <td>2015/04/26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>440</th>\n",
       "      <td>85.43</td>\n",
       "      <td>27.71</td>\n",
       "      <td>Kathmandu</td>\n",
       "      <td>00:43</td>\n",
       "      <td>4.6</td>\n",
       "      <td>2015/04/26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>441</th>\n",
       "      <td>85.55</td>\n",
       "      <td>27.94</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>00:14</td>\n",
       "      <td>4.1</td>\n",
       "      <td>2015/04/26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>442</th>\n",
       "      <td>85.98</td>\n",
       "      <td>27.78</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>23:46</td>\n",
       "      <td>4.1</td>\n",
       "      <td>2015/04/25</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>443 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Longitude Latitude       Epicentre   Time  Magnitude        Date\n",
       "0       85.39    27.58        Lalitpur  14:45        4.1  2015/06/26\n",
       "1       85.49    27.94  Sindhupalchowk  23:51        4.2  2015/06/25\n",
       "2       86.21    27.66         Dolakha  23:49        4.1  2015/06/25\n",
       "3       85.17    27.78         Nuwakot  21:07        4.3  2015/06/25\n",
       "4       85.75    27.85  Sindhupalchowk  14:59        4.0  2015/06/24\n",
       "..        ...      ...             ...    ...        ...         ...\n",
       "438     85.35    28.05          Rasuwa  01:49        4.0  2015/04/26\n",
       "439     85.56    27.93  Sindhupalchowk  01:29        4.1  2015/04/26\n",
       "440     85.43    27.71       Kathmandu  00:43        4.6  2015/04/26\n",
       "441     85.55    27.94  Sindhupalchowk  00:14        4.1  2015/04/26\n",
       "442     85.98    27.78  Sindhupalchowk  23:46        4.1  2015/04/25\n",
       "\n",
       "[443 rows x 6 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "import csv\n",
    "data=pd.read_csv(\"earthquake.csv\")\n",
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "upper 5 data:\n",
      "  Longitude Latitude       Epicentre   Time  Magnitude        Date\n",
      "0     85.39    27.58        Lalitpur  14:45        4.1  2015/06/26\n",
      "1     85.49    27.94  Sindhupalchowk  23:51        4.2  2015/06/25\n",
      "2     86.21    27.66         Dolakha  23:49        4.1  2015/06/25\n",
      "3     85.17    27.78         Nuwakot  21:07        4.3  2015/06/25\n",
      "4     85.75    27.85  Sindhupalchowk  14:59        4.0  2015/06/24\n",
      "lower 5 data:\n",
      "    Longitude Latitude       Epicentre   Time  Magnitude        Date\n",
      "438     85.35    28.05          Rasuwa  01:49        4.0  2015/04/26\n",
      "439     85.56    27.93  Sindhupalchowk  01:29        4.1  2015/04/26\n",
      "440     85.43    27.71       Kathmandu  00:43        4.6  2015/04/26\n",
      "441     85.55    27.94  Sindhupalchowk  00:14        4.1  2015/04/26\n",
      "442     85.98    27.78  Sindhupalchowk  23:46        4.1  2015/04/25\n"
     ]
    }
   ],
   "source": [
    "print(\"upper 5 data:\")\n",
    "print(data.head())#defult as 5\n",
    "print(\"lower 5 data:\")\n",
    "print(data.tail())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "443\n",
      "  Longitude Latitude       Epicentre   Time  Magnitude        Date\n",
      "0     85.39    27.58        Lalitpur  14:45        4.1  2015/06/26\n",
      "1     85.49    27.94  Sindhupalchowk  23:51        4.2  2015/06/25\n",
      "2     86.21    27.66         Dolakha  23:49        4.1  2015/06/25\n",
      "3     85.17    27.78         Nuwakot  21:07        4.3  2015/06/25\n",
      "4     85.75    27.85  Sindhupalchowk  14:59        4.0  2015/06/24\n",
      "5     86.17    27.67         Dolakha  13:19        4.0  2015/06/22\n",
      "6     86.00    27.80  Sindhupalchowk  19:26        4.3  2015/06/21\n",
      "data in range are:\n",
      "  Longitude Latitude       Epicentre   Time  Magnitude        Date\n",
      "5     86.17    27.67         Dolakha  13:19        4.0  2015/06/22\n",
      "6     86.00    27.80  Sindhupalchowk  19:26        4.3  2015/06/21\n",
      "7     84.94    28.17          Gorkha   2:40        4.2  2015/06/20\n",
      "8     82.76    28.65           Rukum  12:23        5.4  2015/06/20\n"
     ]
    }
   ],
   "source": [
    "print(len(data))\n",
    "print(data.head(7))#accessing top 5 data.\n",
    "print(\"data in range are:\")\n",
    "print(data.iloc[5:9])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "pandas.core.frame.DataFrame"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#checking a type of data\n",
    "type(data)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Longitude     object\n",
       "Latitude      object\n",
       "Epicentre     object\n",
       "Time          object\n",
       "Magnitude    float64\n",
       "Date          object\n",
       "dtype: object"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Longitude            object\n",
       "Latitude             object\n",
       "Epicentre            object\n",
       "Time                 object\n",
       "Magnitude           float64\n",
       "Date         datetime64[ns]\n",
       "dtype: object"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#set data has higher priority\n",
    "x=pd.read_csv(\"earthquake.csv\",parse_dates=['Date'])\n",
    "x.dtypes#change only in date tye"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "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>Magnitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>443.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>4.397968</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>0.479838</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>4.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>4.100000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>4.200000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>4.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>7.600000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        Magnitude\n",
       "count  443.000000\n",
       "mean     4.397968\n",
       "std      0.479838\n",
       "min      4.000000\n",
       "25%      4.100000\n",
       "50%      4.200000\n",
       "75%      4.500000\n",
       "max      7.600000"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.describe()#it shows only magnitude data because it has only pure mathematics value."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "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>Longitude</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Epicentre</th>\n",
       "      <th>Time</th>\n",
       "      <th>Magnitude</th>\n",
       "      <th>Date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>85.39</td>\n",
       "      <td>27.58</td>\n",
       "      <td>Lalitpur</td>\n",
       "      <td>14:45</td>\n",
       "      <td>4.1</td>\n",
       "      <td>2015/06/26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>86.26</td>\n",
       "      <td>27.70</td>\n",
       "      <td>Dolakha</td>\n",
       "      <td>17:38</td>\n",
       "      <td>4.5</td>\n",
       "      <td>2015/06/03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>200</th>\n",
       "      <td>86.24</td>\n",
       "      <td>27.76</td>\n",
       "      <td>Dolakha</td>\n",
       "      <td>16:26</td>\n",
       "      <td>4.4</td>\n",
       "      <td>2015/05/12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300</th>\n",
       "      <td>85.91</td>\n",
       "      <td>28.34</td>\n",
       "      <td>Tibet</td>\n",
       "      <td>23:27</td>\n",
       "      <td>5.6</td>\n",
       "      <td>2015/04/25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>400</th>\n",
       "      <td>85.74</td>\n",
       "      <td>27.57</td>\n",
       "      <td>Kavrepalanchowk</td>\n",
       "      <td>04:17</td>\n",
       "      <td>4.5</td>\n",
       "      <td>2015/04/27</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Longitude Latitude        Epicentre   Time  Magnitude        Date\n",
       "0       85.39    27.58         Lalitpur  14:45        4.1  2015/06/26\n",
       "100     86.26    27.70          Dolakha  17:38        4.5  2015/06/03\n",
       "200     86.24    27.76          Dolakha  16:26        4.4  2015/05/12\n",
       "300     85.91    28.34            Tibet  23:27        5.6  2015/04/25\n",
       "400     85.74    27.57  Kavrepalanchowk  04:17        4.5  2015/04/27"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[::100]#[start,stop,step]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "        Magnitude\n",
      "count  443.000000\n",
      "mean     4.397968\n",
      "std      0.479838\n",
      "min      4.000000\n",
      "25%      4.100000\n",
      "50%      4.200000\n",
      "75%      4.500000\n",
      "max      7.600000\n",
      "       Longitude Latitude Epicentre   Time   Magnitude        Date\n",
      "count        443      443       443    443  443.000000         443\n",
      "unique       188      114        28    390         NaN         139\n",
      "top        86.17    27.80   Dolakha  16:44         NaN  2015/04/26\n",
      "freq           9       16       143      4         NaN          38\n",
      "mean         NaN      NaN       NaN    NaN    4.397968         NaN\n",
      "std          NaN      NaN       NaN    NaN    0.479838         NaN\n",
      "min          NaN      NaN       NaN    NaN    4.000000         NaN\n",
      "25%          NaN      NaN       NaN    NaN    4.100000         NaN\n",
      "50%          NaN      NaN       NaN    NaN    4.200000         NaN\n",
      "75%          NaN      NaN       NaN    NaN    4.500000         NaN\n",
      "max          NaN      NaN       NaN    NaN    7.600000         NaN\n",
      "        Magnitude\n",
      "count  443.000000\n",
      "mean     4.397968\n",
      "std      0.479838\n",
      "min      4.000000\n",
      "25%      4.100000\n",
      "50%      4.200000\n",
      "75%      4.500000\n",
      "max      7.600000\n"
     ]
    }
   ],
   "source": [
    "print(data.describe())\n",
    "print(data.describe(include='all'))\n",
    "print(data.describe(include=[np.number]))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Longitude', 'Latitude', 'Epicentre', 'Time', 'Magnitude', 'Date'], dtype='object')"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.columns"
   ]
  },
  {
   "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>Longitude</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Epicentre</th>\n",
       "      <th>Time</th>\n",
       "      <th>Date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>443</td>\n",
       "      <td>443</td>\n",
       "      <td>443</td>\n",
       "      <td>443</td>\n",
       "      <td>443</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>unique</th>\n",
       "      <td>188</td>\n",
       "      <td>114</td>\n",
       "      <td>28</td>\n",
       "      <td>390</td>\n",
       "      <td>139</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>top</th>\n",
       "      <td>86.17</td>\n",
       "      <td>27.80</td>\n",
       "      <td>Dolakha</td>\n",
       "      <td>16:44</td>\n",
       "      <td>2015/04/26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>freq</th>\n",
       "      <td>9</td>\n",
       "      <td>16</td>\n",
       "      <td>143</td>\n",
       "      <td>4</td>\n",
       "      <td>38</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       Longitude Latitude Epicentre   Time        Date\n",
       "count        443      443       443    443         443\n",
       "unique       188      114        28    390         139\n",
       "top        86.17    27.80   Dolakha  16:44  2015/04/26\n",
       "freq           9       16       143      4          38"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#data[['Longitude','Latitude','Epicentre','Time','Date']]\n",
    "#it will provide new value that is not involved in mathematics.\n",
    "data[['Longitude','Latitude','Epicentre','Time','Date']].describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "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>Longitude</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Epicentre</th>\n",
       "      <th>Time</th>\n",
       "      <th>Date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>85.48</td>\n",
       "      <td>27.97</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>06:11</td>\n",
       "      <td>2015/05/16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>85.73</td>\n",
       "      <td>27.96</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>21:57</td>\n",
       "      <td>2015/06/11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>85.22</td>\n",
       "      <td>27.70</td>\n",
       "      <td>Kathmandu</td>\n",
       "      <td>14:16</td>\n",
       "      <td>2015/06/05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>86.01</td>\n",
       "      <td>27.75</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>5:10</td>\n",
       "      <td>2015/09/03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>86.09</td>\n",
       "      <td>27.62</td>\n",
       "      <td>Dolakha</td>\n",
       "      <td>15:20</td>\n",
       "      <td>2015/05/14</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Longitude Latitude       Epicentre   Time        Date\n",
       "50     85.48    27.97         Nuwakot  06:11  2015/05/16\n",
       "60     85.73    27.96  Sindhupalchowk  21:57  2015/06/11\n",
       "70     85.22    27.70       Kathmandu  14:16  2015/06/05\n",
       "80     86.01    27.75  Sindhupalchowk   5:10  2015/09/03\n",
       "90     86.09    27.62         Dolakha  15:20  2015/05/14"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[['Longitude','Latitude','Epicentre','Time','Date']][50:100:10]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "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",
       "      <th>...</th>\n",
       "      <th>433</th>\n",
       "      <th>434</th>\n",
       "      <th>435</th>\n",
       "      <th>436</th>\n",
       "      <th>437</th>\n",
       "      <th>438</th>\n",
       "      <th>439</th>\n",
       "      <th>440</th>\n",
       "      <th>441</th>\n",
       "      <th>442</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Longitude</th>\n",
       "      <td>85.39</td>\n",
       "      <td>85.49</td>\n",
       "      <td>86.21</td>\n",
       "      <td>85.17</td>\n",
       "      <td>85.75</td>\n",
       "      <td>86.17</td>\n",
       "      <td>86.00</td>\n",
       "      <td>84.94</td>\n",
       "      <td>82.76</td>\n",
       "      <td>84.92</td>\n",
       "      <td>...</td>\n",
       "      <td>85.96</td>\n",
       "      <td>84.82</td>\n",
       "      <td>85.83</td>\n",
       "      <td>85.56</td>\n",
       "      <td>84.71</td>\n",
       "      <td>85.35</td>\n",
       "      <td>85.56</td>\n",
       "      <td>85.43</td>\n",
       "      <td>85.55</td>\n",
       "      <td>85.98</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Latitude</th>\n",
       "      <td>27.58</td>\n",
       "      <td>27.94</td>\n",
       "      <td>27.66</td>\n",
       "      <td>27.78</td>\n",
       "      <td>27.85</td>\n",
       "      <td>27.67</td>\n",
       "      <td>27.80</td>\n",
       "      <td>28.17</td>\n",
       "      <td>28.65</td>\n",
       "      <td>28.26</td>\n",
       "      <td>...</td>\n",
       "      <td>27.6</td>\n",
       "      <td>28.24</td>\n",
       "      <td>28.25</td>\n",
       "      <td>27.93</td>\n",
       "      <td>28.14</td>\n",
       "      <td>28.05</td>\n",
       "      <td>27.93</td>\n",
       "      <td>27.71</td>\n",
       "      <td>27.94</td>\n",
       "      <td>27.78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Epicentre</th>\n",
       "      <td>Lalitpur</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>Dolakha</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>Dolakha</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>Gorkha</td>\n",
       "      <td>Rukum</td>\n",
       "      <td>Gorkha</td>\n",
       "      <td>...</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>Gorkha</td>\n",
       "      <td>Rasuwa</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>Gorkha</td>\n",
       "      <td>Rasuwa</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>Kathmandu</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Time</th>\n",
       "      <td>14:45</td>\n",
       "      <td>23:51</td>\n",
       "      <td>23:49</td>\n",
       "      <td>21:07</td>\n",
       "      <td>14:59</td>\n",
       "      <td>13:19</td>\n",
       "      <td>19:26</td>\n",
       "      <td>2:40</td>\n",
       "      <td>12:23</td>\n",
       "      <td>13:50</td>\n",
       "      <td>...</td>\n",
       "      <td>02:17</td>\n",
       "      <td>02:14</td>\n",
       "      <td>02:08</td>\n",
       "      <td>01:56</td>\n",
       "      <td>01:52</td>\n",
       "      <td>01:49</td>\n",
       "      <td>01:29</td>\n",
       "      <td>00:43</td>\n",
       "      <td>00:14</td>\n",
       "      <td>23:46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Magnitude</th>\n",
       "      <td>4.1</td>\n",
       "      <td>4.2</td>\n",
       "      <td>4.1</td>\n",
       "      <td>4.3</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4.3</td>\n",
       "      <td>4.2</td>\n",
       "      <td>5.4</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>4.8</td>\n",
       "      <td>4.3</td>\n",
       "      <td>4</td>\n",
       "      <td>4.4</td>\n",
       "      <td>4.2</td>\n",
       "      <td>4</td>\n",
       "      <td>4.1</td>\n",
       "      <td>4.6</td>\n",
       "      <td>4.1</td>\n",
       "      <td>4.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Date</th>\n",
       "      <td>2015/06/26</td>\n",
       "      <td>2015/06/25</td>\n",
       "      <td>2015/06/25</td>\n",
       "      <td>2015/06/25</td>\n",
       "      <td>2015/06/24</td>\n",
       "      <td>2015/06/22</td>\n",
       "      <td>2015/06/21</td>\n",
       "      <td>2015/06/20</td>\n",
       "      <td>2015/06/20</td>\n",
       "      <td>2015/06/19</td>\n",
       "      <td>...</td>\n",
       "      <td>2015/04/26</td>\n",
       "      <td>2015/04/26</td>\n",
       "      <td>2015/04/26</td>\n",
       "      <td>2015/04/26</td>\n",
       "      <td>2015/04/26</td>\n",
       "      <td>2015/04/26</td>\n",
       "      <td>2015/04/26</td>\n",
       "      <td>2015/04/26</td>\n",
       "      <td>2015/04/26</td>\n",
       "      <td>2015/04/25</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>6 rows × 443 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                  0               1           2           3               4    \\\n",
       "Longitude       85.39           85.49       86.21       85.17           85.75   \n",
       "Latitude        27.58           27.94       27.66       27.78           27.85   \n",
       "Epicentre    Lalitpur  Sindhupalchowk     Dolakha     Nuwakot  Sindhupalchowk   \n",
       "Time            14:45           23:51       23:49       21:07           14:59   \n",
       "Magnitude         4.1             4.2         4.1         4.3               4   \n",
       "Date       2015/06/26      2015/06/25  2015/06/25  2015/06/25      2015/06/24   \n",
       "\n",
       "                  5               6           7           8           9    \\\n",
       "Longitude       86.17           86.00       84.94       82.76       84.92   \n",
       "Latitude        27.67           27.80       28.17       28.65       28.26   \n",
       "Epicentre     Dolakha  Sindhupalchowk      Gorkha       Rukum      Gorkha   \n",
       "Time            13:19           19:26        2:40       12:23       13:50   \n",
       "Magnitude           4             4.3         4.2         5.4           4   \n",
       "Date       2015/06/22      2015/06/21  2015/06/20  2015/06/20  2015/06/19   \n",
       "\n",
       "           ...             433         434         435             436  \\\n",
       "Longitude  ...           85.96       84.82       85.83           85.56   \n",
       "Latitude   ...            27.6       28.24       28.25           27.93   \n",
       "Epicentre  ...  Sindhupalchowk      Gorkha      Rasuwa  Sindhupalchowk   \n",
       "Time       ...           02:17       02:14       02:08           01:56   \n",
       "Magnitude  ...             4.8         4.3           4             4.4   \n",
       "Date       ...      2015/04/26  2015/04/26  2015/04/26      2015/04/26   \n",
       "\n",
       "                  437         438             439         440             441  \\\n",
       "Longitude       84.71       85.35           85.56       85.43           85.55   \n",
       "Latitude        28.14       28.05           27.93       27.71           27.94   \n",
       "Epicentre      Gorkha      Rasuwa  Sindhupalchowk   Kathmandu  Sindhupalchowk   \n",
       "Time            01:52       01:49           01:29       00:43           00:14   \n",
       "Magnitude         4.2           4             4.1         4.6             4.1   \n",
       "Date       2015/04/26  2015/04/26      2015/04/26  2015/04/26      2015/04/26   \n",
       "\n",
       "                      442  \n",
       "Longitude           85.98  \n",
       "Latitude            27.78  \n",
       "Epicentre  Sindhupalchowk  \n",
       "Time                23:46  \n",
       "Magnitude             4.1  \n",
       "Date           2015/04/25  \n",
       "\n",
       "[6 rows x 443 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#it transpose the data value\n",
    "data.T"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "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>Longitude</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Epicentre</th>\n",
       "      <th>Time</th>\n",
       "      <th>Magnitude</th>\n",
       "      <th>Date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>85.73</td>\n",
       "      <td>27.96</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>21:57</td>\n",
       "      <td>5.3</td>\n",
       "      <td>2015/06/11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>85.22</td>\n",
       "      <td>27.70</td>\n",
       "      <td>Kathmandu</td>\n",
       "      <td>14:16</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/06/05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>86.01</td>\n",
       "      <td>27.75</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>5:10</td>\n",
       "      <td>4.3</td>\n",
       "      <td>2015/09/03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>86.09</td>\n",
       "      <td>27.62</td>\n",
       "      <td>Dolakha</td>\n",
       "      <td>15:20</td>\n",
       "      <td>4.2</td>\n",
       "      <td>2015/05/14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>86.26</td>\n",
       "      <td>27.70</td>\n",
       "      <td>Dolakha</td>\n",
       "      <td>17:38</td>\n",
       "      <td>4.5</td>\n",
       "      <td>2015/06/03</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Longitude Latitude       Epicentre   Time  Magnitude        Date\n",
       "60      85.73    27.96  Sindhupalchowk  21:57        5.3  2015/06/11\n",
       "70      85.22    27.70       Kathmandu  14:16        4.0  2015/06/05\n",
       "80      86.01    27.75  Sindhupalchowk   5:10        4.3  2015/09/03\n",
       "90      86.09    27.62         Dolakha  15:20        4.2  2015/05/14\n",
       "100     86.26    27.70         Dolakha  17:38        4.5  2015/06/03"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[data.columns][60:110:10]"
   ]
  },
  {
   "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>Longitude</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Epicentre</th>\n",
       "      <th>Time</th>\n",
       "      <th>Magnitude</th>\n",
       "      <th>Date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>85.48</td>\n",
       "      <td>27.97</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>06:11</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/05/16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>85.73</td>\n",
       "      <td>27.96</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>21:57</td>\n",
       "      <td>5.3</td>\n",
       "      <td>2015/06/11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>85.22</td>\n",
       "      <td>27.70</td>\n",
       "      <td>Kathmandu</td>\n",
       "      <td>14:16</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/06/05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>86.01</td>\n",
       "      <td>27.75</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>5:10</td>\n",
       "      <td>4.3</td>\n",
       "      <td>2015/09/03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>86.09</td>\n",
       "      <td>27.62</td>\n",
       "      <td>Dolakha</td>\n",
       "      <td>15:20</td>\n",
       "      <td>4.2</td>\n",
       "      <td>2015/05/14</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Longitude Latitude       Epicentre   Time  Magnitude        Date\n",
       "50     85.48    27.97         Nuwakot  06:11        4.0  2015/05/16\n",
       "60     85.73    27.96  Sindhupalchowk  21:57        5.3  2015/06/11\n",
       "70     85.22    27.70       Kathmandu  14:16        4.0  2015/06/05\n",
       "80     86.01    27.75  Sindhupalchowk   5:10        4.3  2015/09/03\n",
       "90     86.09    27.62         Dolakha  15:20        4.2  2015/05/14"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.iloc[50:100:10]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "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>Longitude</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Epicentre</th>\n",
       "      <th>Time</th>\n",
       "      <th>Magnitude</th>\n",
       "      <th>Date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>226</th>\n",
       "      <td>83.13</td>\n",
       "      <td>28.48</td>\n",
       "      <td>Baglung</td>\n",
       "      <td>15:21</td>\n",
       "      <td>4.2</td>\n",
       "      <td>2015/07/07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>83.36</td>\n",
       "      <td>28.35</td>\n",
       "      <td>Baglung</td>\n",
       "      <td>08:00</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/11/20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>81.69</td>\n",
       "      <td>29.44</td>\n",
       "      <td>Bajura</td>\n",
       "      <td>22:16</td>\n",
       "      <td>5.5</td>\n",
       "      <td>2015/12/18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>81.29</td>\n",
       "      <td>29.35</td>\n",
       "      <td>Bajura</td>\n",
       "      <td>04:48</td>\n",
       "      <td>4.1</td>\n",
       "      <td>2015/12/26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>227</th>\n",
       "      <td>81.74</td>\n",
       "      <td>29.69</td>\n",
       "      <td>Bajura</td>\n",
       "      <td>09:31</td>\n",
       "      <td>4.6</td>\n",
       "      <td>2015/07/07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>353</th>\n",
       "      <td>87.01</td>\n",
       "      <td>27.42</td>\n",
       "      <td>Bhojpur</td>\n",
       "      <td>22:51</td>\n",
       "      <td>4.5</td>\n",
       "      <td>2015/02/14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>356</th>\n",
       "      <td>81.51</td>\n",
       "      <td>29.07</td>\n",
       "      <td>Dailekh</td>\n",
       "      <td>01:26</td>\n",
       "      <td>4.5</td>\n",
       "      <td>2015/01/06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219</th>\n",
       "      <td>80.73</td>\n",
       "      <td>29.80</td>\n",
       "      <td>Darchula</td>\n",
       "      <td>02:29</td>\n",
       "      <td>4.1</td>\n",
       "      <td>2015/07/15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>80.60</td>\n",
       "      <td>29.83</td>\n",
       "      <td>Darchula</td>\n",
       "      <td>09:27</td>\n",
       "      <td>4.6</td>\n",
       "      <td>2015/09/29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>249</th>\n",
       "      <td>84.88</td>\n",
       "      <td>28.11</td>\n",
       "      <td>Dhading</td>\n",
       "      <td>18:27</td>\n",
       "      <td>4.1</td>\n",
       "      <td>2015/05/18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>84.84</td>\n",
       "      <td>27.92</td>\n",
       "      <td>Dhading</td>\n",
       "      <td>10:51</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/05/15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>328</th>\n",
       "      <td>84.86</td>\n",
       "      <td>27.9</td>\n",
       "      <td>Dhading</td>\n",
       "      <td>14:05</td>\n",
       "      <td>5.1</td>\n",
       "      <td>2015/04/25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>85.07</td>\n",
       "      <td>27.74</td>\n",
       "      <td>Dhading</td>\n",
       "      <td>12:17</td>\n",
       "      <td>4.5</td>\n",
       "      <td>2015/09/22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>372</th>\n",
       "      <td>84.83</td>\n",
       "      <td>27.93</td>\n",
       "      <td>Dhading</td>\n",
       "      <td>06:22</td>\n",
       "      <td>4.7</td>\n",
       "      <td>2015/04/30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>148</th>\n",
       "      <td>84.79</td>\n",
       "      <td>27.99</td>\n",
       "      <td>Dhading</td>\n",
       "      <td>03:07</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/05/28</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Longitude Latitude Epicentre   Time  Magnitude        Date\n",
       "226     83.13    28.48   Baglung  15:21        4.2  2015/07/07\n",
       "35      83.36    28.35   Baglung  08:00        4.0  2015/11/20\n",
       "19      81.69    29.44    Bajura  22:16        5.5  2015/12/18\n",
       "17      81.29    29.35    Bajura  04:48        4.1  2015/12/26\n",
       "227     81.74    29.69    Bajura  09:31        4.6  2015/07/07\n",
       "353     87.01    27.42   Bhojpur  22:51        4.5  2015/02/14\n",
       "356     81.51    29.07   Dailekh  01:26        4.5  2015/01/06\n",
       "219     80.73    29.80  Darchula  02:29        4.1  2015/07/15\n",
       "75      80.60    29.83  Darchula  09:27        4.6  2015/09/29\n",
       "249     84.88    28.11   Dhading  18:27        4.1  2015/05/18\n",
       "56      84.84    27.92   Dhading  10:51        4.0  2015/05/15\n",
       "328     84.86     27.9   Dhading  14:05        5.1  2015/04/25\n",
       "76      85.07    27.74   Dhading  12:17        4.5  2015/09/22\n",
       "372     84.83    27.93   Dhading  06:22        4.7  2015/04/30\n",
       "148     84.79    27.99   Dhading  03:07        4.0  2015/05/28"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# y=data.sort_values(by='Epicentre',ascending=True)\n",
    "# y[0:20]\n",
    "data.sort_values(by='Epicentre',ascending=True).head(15)"
   ]
  },
  {
   "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>Longitude</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Epicentre</th>\n",
       "      <th>Time</th>\n",
       "      <th>Magnitude</th>\n",
       "      <th>Date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>441</th>\n",
       "      <td>85.55</td>\n",
       "      <td>27.94</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>00:14</td>\n",
       "      <td>4.1</td>\n",
       "      <td>2015/04/26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189</th>\n",
       "      <td>85.75</td>\n",
       "      <td>27.85</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>10:03</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/07/26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223</th>\n",
       "      <td>85.73</td>\n",
       "      <td>27.89</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>17:59</td>\n",
       "      <td>4.4</td>\n",
       "      <td>2015/07/09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225</th>\n",
       "      <td>85.68</td>\n",
       "      <td>27.92</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>09:55</td>\n",
       "      <td>4.2</td>\n",
       "      <td>2015/07/08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123</th>\n",
       "      <td>87.87</td>\n",
       "      <td>27.33</td>\n",
       "      <td>Taplejung</td>\n",
       "      <td>05:42</td>\n",
       "      <td>4.5</td>\n",
       "      <td>2015/08/15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>344</th>\n",
       "      <td>85.71</td>\n",
       "      <td>27.99</td>\n",
       "      <td>Tibet</td>\n",
       "      <td>13:32</td>\n",
       "      <td>5.1</td>\n",
       "      <td>2015/04/25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300</th>\n",
       "      <td>85.91</td>\n",
       "      <td>28.34</td>\n",
       "      <td>Tibet</td>\n",
       "      <td>23:27</td>\n",
       "      <td>5.6</td>\n",
       "      <td>2015/04/25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>168</th>\n",
       "      <td>86.45</td>\n",
       "      <td>27.97</td>\n",
       "      <td>Tibet</td>\n",
       "      <td>21:13</td>\n",
       "      <td>4.8</td>\n",
       "      <td>2015/05/12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>348</th>\n",
       "      <td>85.80</td>\n",
       "      <td>28.41</td>\n",
       "      <td>Tibet</td>\n",
       "      <td>12:23</td>\n",
       "      <td>5.5</td>\n",
       "      <td>2015/04/25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>169</th>\n",
       "      <td>86.36</td>\n",
       "      <td>28.03</td>\n",
       "      <td>Tibet</td>\n",
       "      <td>20:44</td>\n",
       "      <td>4.1</td>\n",
       "      <td>2015/05/12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>417</th>\n",
       "      <td>86.05</td>\n",
       "      <td>27.94</td>\n",
       "      <td>Tibet</td>\n",
       "      <td>13:22</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2015/04/26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>85.86</td>\n",
       "      <td>28.26</td>\n",
       "      <td>Tibet</td>\n",
       "      <td>02:33</td>\n",
       "      <td>4.2</td>\n",
       "      <td>2015/06/06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>276</th>\n",
       "      <td>85.96</td>\n",
       "      <td>28.04</td>\n",
       "      <td>Tibet</td>\n",
       "      <td>01:50</td>\n",
       "      <td>4.2</td>\n",
       "      <td>2015/05/10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>85.94</td>\n",
       "      <td>28.27</td>\n",
       "      <td>Tibet</td>\n",
       "      <td>08:00</td>\n",
       "      <td>5.1</td>\n",
       "      <td>2015/06/17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>275</th>\n",
       "      <td>86.67</td>\n",
       "      <td>26.94</td>\n",
       "      <td>Udayapur</td>\n",
       "      <td>02:44</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/05/10</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Longitude Latitude       Epicentre   Time  Magnitude        Date\n",
       "441     85.55    27.94  Sindhupalchowk  00:14        4.1  2015/04/26\n",
       "189     85.75    27.85  Sindhupalchowk  10:03        4.0  2015/07/26\n",
       "223     85.73    27.89  Sindhupalchowk  17:59        4.4  2015/07/09\n",
       "225     85.68    27.92  Sindhupalchowk  09:55        4.2  2015/07/08\n",
       "123     87.87    27.33       Taplejung  05:42        4.5  2015/08/15\n",
       "344     85.71    27.99           Tibet  13:32        5.1  2015/04/25\n",
       "300     85.91    28.34           Tibet  23:27        5.6  2015/04/25\n",
       "168     86.45    27.97           Tibet  21:13        4.8  2015/05/12\n",
       "348     85.80    28.41           Tibet  12:23        5.5  2015/04/25\n",
       "169     86.36    28.03           Tibet  20:44        4.1  2015/05/12\n",
       "417     86.05    27.94           Tibet  13:22        5.0  2015/04/26\n",
       "69      85.86    28.26           Tibet  02:33        4.2  2015/06/06\n",
       "276     85.96    28.04           Tibet  01:50        4.2  2015/05/10\n",
       "11      85.94    28.27           Tibet  08:00        5.1  2015/06/17\n",
       "275     86.67    26.94        Udayapur  02:44        4.0  2015/05/10"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.sort_values(by='Epicentre',ascending=True).tail(15)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "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>Longitude</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Epicentre</th>\n",
       "      <th>Time</th>\n",
       "      <th>Magnitude</th>\n",
       "      <th>Date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>83.36</td>\n",
       "      <td>28.35</td>\n",
       "      <td>Baglung</td>\n",
       "      <td>08:00</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/11/20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>226</th>\n",
       "      <td>83.13</td>\n",
       "      <td>28.48</td>\n",
       "      <td>Baglung</td>\n",
       "      <td>15:21</td>\n",
       "      <td>4.2</td>\n",
       "      <td>2015/07/07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>81.29</td>\n",
       "      <td>29.35</td>\n",
       "      <td>Bajura</td>\n",
       "      <td>04:48</td>\n",
       "      <td>4.1</td>\n",
       "      <td>2015/12/26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>227</th>\n",
       "      <td>81.74</td>\n",
       "      <td>29.69</td>\n",
       "      <td>Bajura</td>\n",
       "      <td>09:31</td>\n",
       "      <td>4.6</td>\n",
       "      <td>2015/07/07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>81.69</td>\n",
       "      <td>29.44</td>\n",
       "      <td>Bajura</td>\n",
       "      <td>22:16</td>\n",
       "      <td>5.5</td>\n",
       "      <td>2015/12/18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>353</th>\n",
       "      <td>87.01</td>\n",
       "      <td>27.42</td>\n",
       "      <td>Bhojpur</td>\n",
       "      <td>22:51</td>\n",
       "      <td>4.5</td>\n",
       "      <td>2015/02/14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>356</th>\n",
       "      <td>81.51</td>\n",
       "      <td>29.07</td>\n",
       "      <td>Dailekh</td>\n",
       "      <td>01:26</td>\n",
       "      <td>4.5</td>\n",
       "      <td>2015/01/06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219</th>\n",
       "      <td>80.73</td>\n",
       "      <td>29.80</td>\n",
       "      <td>Darchula</td>\n",
       "      <td>02:29</td>\n",
       "      <td>4.1</td>\n",
       "      <td>2015/07/15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>80.60</td>\n",
       "      <td>29.83</td>\n",
       "      <td>Darchula</td>\n",
       "      <td>09:27</td>\n",
       "      <td>4.6</td>\n",
       "      <td>2015/09/29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>84.84</td>\n",
       "      <td>27.92</td>\n",
       "      <td>Dhading</td>\n",
       "      <td>10:51</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/05/15</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Longitude Latitude Epicentre   Time  Magnitude        Date\n",
       "35      83.36    28.35   Baglung  08:00        4.0  2015/11/20\n",
       "226     83.13    28.48   Baglung  15:21        4.2  2015/07/07\n",
       "17      81.29    29.35    Bajura  04:48        4.1  2015/12/26\n",
       "227     81.74    29.69    Bajura  09:31        4.6  2015/07/07\n",
       "19      81.69    29.44    Bajura  22:16        5.5  2015/12/18\n",
       "353     87.01    27.42   Bhojpur  22:51        4.5  2015/02/14\n",
       "356     81.51    29.07   Dailekh  01:26        4.5  2015/01/06\n",
       "219     80.73    29.80  Darchula  02:29        4.1  2015/07/15\n",
       "75      80.60    29.83  Darchula  09:27        4.6  2015/09/29\n",
       "56      84.84    27.92   Dhading  10:51        4.0  2015/05/15"
      ]
     },
     "execution_count": 70,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.sort_values(by=['Epicentre','Magnitude'],ascending=True).head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "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>Longitude</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Epicentre</th>\n",
       "      <th>Time</th>\n",
       "      <th>Magnitude</th>\n",
       "      <th>Date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>85.39</td>\n",
       "      <td>27.58</td>\n",
       "      <td>Lalitpur</td>\n",
       "      <td>14:45</td>\n",
       "      <td>4.1</td>\n",
       "      <td>2015/06/26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>85.49</td>\n",
       "      <td>27.94</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>23:51</td>\n",
       "      <td>4.2</td>\n",
       "      <td>2015/06/25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>86.21</td>\n",
       "      <td>27.66</td>\n",
       "      <td>Dolakha</td>\n",
       "      <td>23:49</td>\n",
       "      <td>4.1</td>\n",
       "      <td>2015/06/25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>85.17</td>\n",
       "      <td>27.78</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>21:07</td>\n",
       "      <td>4.3</td>\n",
       "      <td>2015/06/25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>85.75</td>\n",
       "      <td>27.85</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>14:59</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/06/24</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Longitude Latitude       Epicentre   Time  Magnitude        Date\n",
       "0     85.39    27.58        Lalitpur  14:45        4.1  2015/06/26\n",
       "1     85.49    27.94  Sindhupalchowk  23:51        4.2  2015/06/25\n",
       "2     86.21    27.66         Dolakha  23:49        4.1  2015/06/25\n",
       "3     85.17    27.78         Nuwakot  21:07        4.3  2015/06/25\n",
       "4     85.75    27.85  Sindhupalchowk  14:59        4.0  2015/06/24"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{'Kathmandu', 'Dailekh', 'Lamjung', 'Baglung', 'Bajura', 'Rasuwa', 'Kavre', 'Kavrepalanchowk', 'Nuwakot', 'Tibet', 'Humla', 'Taplejung', 'Sindhupalchowk', 'Dolakha', 'Lalitpur', 'Darchula', 'Dhading', 'Gorkha', 'Doti', 'Udayapur', 'Bhojpur', 'Panchthar', 'Kaski', 'Myagdi', 'Rukum', 'Ramechhap', 'Lalitput', 'Jajarkot'}\n"
     ]
    }
   ],
   "source": [
    "print(set(data['Epicentre']))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "28\n"
     ]
    }
   ],
   "source": [
    "print(len(set(data['Epicentre'])))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Dolakha            143\n",
      "Sindhupalchowk     116\n",
      "Nuwakot             34\n",
      "Gorkha              30\n",
      "Rasuwa              26\n",
      "Dhading             25\n",
      "Kathmandu           16\n",
      "Tibet                9\n",
      "Kavre                6\n",
      "Kavrepalanchowk      5\n",
      "Ramechhap            4\n",
      "Humla                4\n",
      "Lalitpur             4\n",
      "Bajura               3\n",
      "Baglung              2\n",
      "Darchula             2\n",
      "Kaski                2\n",
      "Jajarkot             2\n",
      "Lamjung              1\n",
      "Doti                 1\n",
      "Lalitput             1\n",
      "Udayapur             1\n",
      "Bhojpur              1\n",
      "Panchthar            1\n",
      "Myagdi               1\n",
      "Rukum                1\n",
      "Taplejung            1\n",
      "Dailekh              1\n",
      "Name: Epicentre, dtype: int64\n"
     ]
    }
   ],
   "source": [
    "#value_countS() used for to calculate the repeating value in a table:\n",
    "print(data['Epicentre'].value_counts())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Doti                 1\n",
      "Rukum                1\n",
      "Panchthar            1\n",
      "Dailekh              1\n",
      "Lamjung              1\n",
      "Lalitput             1\n",
      "Taplejung            1\n",
      "Myagdi               1\n",
      "Bhojpur              1\n",
      "Udayapur             1\n",
      "Kaski                2\n",
      "Darchula             2\n",
      "Baglung              2\n",
      "Jajarkot             2\n",
      "Bajura               3\n",
      "Ramechhap            4\n",
      "Lalitpur             4\n",
      "Humla                4\n",
      "Kavrepalanchowk      5\n",
      "Kavre                6\n",
      "Tibet                9\n",
      "Kathmandu           16\n",
      "Dhading             25\n",
      "Rasuwa              26\n",
      "Gorkha              30\n",
      "Nuwakot             34\n",
      "Sindhupalchowk     116\n",
      "Dolakha            143\n",
      "Name: Epicentre, dtype: int64\n"
     ]
    }
   ],
   "source": [
    "print(data.sort_values(by='Epicentre',ascending=True)['Epicentre'].value_counts(ascending=True))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Dolakha           15\n",
       "Sindhupalchowk    14\n",
       "Gorkha             6\n",
       "Tibet              5\n",
       "Dhading            4\n",
       "Rasuwa             3\n",
       "Nuwakot            3\n",
       "Kavre              2\n",
       "Jajarkot           1\n",
       "Bajura             1\n",
       "Kaski              1\n",
       "Rukum              1\n",
       "Ramechhap          1\n",
       "Name: Epicentre, dtype: int64"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[data['Magnitude']>=5]['Epicentre'].value_counts()"
   ]
  },
  {
   "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>Longitude</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Epicentre</th>\n",
       "      <th>Time</th>\n",
       "      <th>Magnitude</th>\n",
       "      <th>Date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>85.49</td>\n",
       "      <td>27.94</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>23:51</td>\n",
       "      <td>4.2</td>\n",
       "      <td>2015/06/25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>85.17</td>\n",
       "      <td>27.78</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>21:07</td>\n",
       "      <td>4.3</td>\n",
       "      <td>2015/06/25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>85.75</td>\n",
       "      <td>27.85</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>14:59</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/06/24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>86.00</td>\n",
       "      <td>27.80</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>19:26</td>\n",
       "      <td>4.3</td>\n",
       "      <td>2015/06/21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>84.94</td>\n",
       "      <td>28.17</td>\n",
       "      <td>Gorkha</td>\n",
       "      <td>2:40</td>\n",
       "      <td>4.2</td>\n",
       "      <td>2015/06/20</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Longitude Latitude       Epicentre   Time  Magnitude        Date\n",
       "1     85.49    27.94  Sindhupalchowk  23:51        4.2  2015/06/25\n",
       "3     85.17    27.78         Nuwakot  21:07        4.3  2015/06/25\n",
       "4     85.75    27.85  Sindhupalchowk  14:59        4.0  2015/06/24\n",
       "6     86.00    27.80  Sindhupalchowk  19:26        4.3  2015/06/21\n",
       "7     84.94    28.17          Gorkha   2:40        4.2  2015/06/20"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[data.Epicentre.isin(['Sindhupalchowk','Nuwakot','Gorkha'])].head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "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>Longitude</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Epicentre</th>\n",
       "      <th>Time</th>\n",
       "      <th>Magnitude</th>\n",
       "      <th>Date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>85.17</td>\n",
       "      <td>27.78</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>21:07</td>\n",
       "      <td>4.3</td>\n",
       "      <td>2015/06/25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>85.29</td>\n",
       "      <td>27.87</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>17:00</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/11/24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>85.15</td>\n",
       "      <td>27.80</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>05:59</td>\n",
       "      <td>4.2</td>\n",
       "      <td>2015/06/14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>85.48</td>\n",
       "      <td>27.97</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>06:11</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/05/16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>108</th>\n",
       "      <td>85.17</td>\n",
       "      <td>27.79</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>22:13</td>\n",
       "      <td>4.5</td>\n",
       "      <td>2015/05/30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118</th>\n",
       "      <td>85.48</td>\n",
       "      <td>27.96</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>12:21</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/08/21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>149</th>\n",
       "      <td>85.13</td>\n",
       "      <td>28.04</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>22:29</td>\n",
       "      <td>4.2</td>\n",
       "      <td>2015/05/27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>188</th>\n",
       "      <td>85.48</td>\n",
       "      <td>27.94</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>18:23</td>\n",
       "      <td>4.2</td>\n",
       "      <td>2015/07/27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>213</th>\n",
       "      <td>85.08</td>\n",
       "      <td>28.05</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>16:44</td>\n",
       "      <td>4.8</td>\n",
       "      <td>2015/05/22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>214</th>\n",
       "      <td>85.14</td>\n",
       "      <td>27.79</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>14:45</td>\n",
       "      <td>4.2</td>\n",
       "      <td>2015/05/22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>216</th>\n",
       "      <td>85.46</td>\n",
       "      <td>27.93</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>14:56</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/05/21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>262</th>\n",
       "      <td>85.14</td>\n",
       "      <td>28.06</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>15:34</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/07/01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>278</th>\n",
       "      <td>85.41</td>\n",
       "      <td>28.01</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>15:05</td>\n",
       "      <td>4.2</td>\n",
       "      <td>2015/05/08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>287</th>\n",
       "      <td>85.46</td>\n",
       "      <td>27.92</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>22:15</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/05/07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>288</th>\n",
       "      <td>85.16</td>\n",
       "      <td>27.79</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>07:56</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/05/07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>289</th>\n",
       "      <td>85.19</td>\n",
       "      <td>27.75</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>03:41</td>\n",
       "      <td>4.2</td>\n",
       "      <td>2015/05/07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>301</th>\n",
       "      <td>85.17</td>\n",
       "      <td>27.78</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>23:25</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/04/25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>304</th>\n",
       "      <td>85.29</td>\n",
       "      <td>27.8</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>22:31</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/04/25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>313</th>\n",
       "      <td>85.16</td>\n",
       "      <td>27.79</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>19:38</td>\n",
       "      <td>4.1</td>\n",
       "      <td>2015/04/25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>318</th>\n",
       "      <td>85.4</td>\n",
       "      <td>28</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>18:02</td>\n",
       "      <td>4.9</td>\n",
       "      <td>2015/04/25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>325</th>\n",
       "      <td>85.33</td>\n",
       "      <td>27.91</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>14:48</td>\n",
       "      <td>5.3</td>\n",
       "      <td>2015/04/25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>330</th>\n",
       "      <td>85.16</td>\n",
       "      <td>27.80</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>10:36</td>\n",
       "      <td>4.1</td>\n",
       "      <td>2015/05/04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>331</th>\n",
       "      <td>85.16</td>\n",
       "      <td>27.79</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>10:33</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/05/04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>332</th>\n",
       "      <td>85.21</td>\n",
       "      <td>27.97</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>09:54</td>\n",
       "      <td>4.2</td>\n",
       "      <td>2015/05/04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>338</th>\n",
       "      <td>85.11</td>\n",
       "      <td>27.80</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>17:20</td>\n",
       "      <td>4.9</td>\n",
       "      <td>2015/05/03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>351</th>\n",
       "      <td>81.92</td>\n",
       "      <td>28.80</td>\n",
       "      <td>Jajarkot</td>\n",
       "      <td>07:14</td>\n",
       "      <td>4.5</td>\n",
       "      <td>2015/04/22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>352</th>\n",
       "      <td>82.18</td>\n",
       "      <td>28.85</td>\n",
       "      <td>Jajarkot</td>\n",
       "      <td>19:52</td>\n",
       "      <td>5.1</td>\n",
       "      <td>2015/04/21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>355</th>\n",
       "      <td>81.03</td>\n",
       "      <td>29.36</td>\n",
       "      <td>Doti</td>\n",
       "      <td>09:27</td>\n",
       "      <td>4.4</td>\n",
       "      <td>2015/01/22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>376</th>\n",
       "      <td>85.37</td>\n",
       "      <td>28.04</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>13:17</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/04/29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>377</th>\n",
       "      <td>85.14</td>\n",
       "      <td>27.79</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>05:54</td>\n",
       "      <td>4.2</td>\n",
       "      <td>2015/04/29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>381</th>\n",
       "      <td>85.17</td>\n",
       "      <td>27.78</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>16:44</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/04/28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>394</th>\n",
       "      <td>85.12</td>\n",
       "      <td>27.80</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>15:17</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/04/27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>398</th>\n",
       "      <td>85.12</td>\n",
       "      <td>27.77</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>06:24</td>\n",
       "      <td>4.7</td>\n",
       "      <td>2015/04/27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>411</th>\n",
       "      <td>85.15</td>\n",
       "      <td>27.79</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>20:17</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/04/26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>423</th>\n",
       "      <td>85.16</td>\n",
       "      <td>27.8</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>08:55</td>\n",
       "      <td>5.1</td>\n",
       "      <td>2015/04/26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>425</th>\n",
       "      <td>85.12</td>\n",
       "      <td>27.84</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>06:16</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/04/26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>430</th>\n",
       "      <td>85.02</td>\n",
       "      <td>27.99</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>05:01</td>\n",
       "      <td>5.5</td>\n",
       "      <td>2015/04/26</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Longitude Latitude Epicentre   Time  Magnitude        Date\n",
       "3       85.17    27.78   Nuwakot  21:07        4.3  2015/06/25\n",
       "27      85.29    27.87   Nuwakot  17:00        4.0  2015/11/24\n",
       "31      85.15    27.80   Nuwakot  05:59        4.2  2015/06/14\n",
       "50      85.48    27.97   Nuwakot  06:11        4.0  2015/05/16\n",
       "108     85.17    27.79   Nuwakot  22:13        4.5  2015/05/30\n",
       "118     85.48    27.96   Nuwakot  12:21        4.0  2015/08/21\n",
       "149     85.13    28.04   Nuwakot  22:29        4.2  2015/05/27\n",
       "188     85.48    27.94   Nuwakot  18:23        4.2  2015/07/27\n",
       "213     85.08    28.05   Nuwakot  16:44        4.8  2015/05/22\n",
       "214     85.14    27.79   Nuwakot  14:45        4.2  2015/05/22\n",
       "216     85.46    27.93   Nuwakot  14:56        4.0  2015/05/21\n",
       "262     85.14    28.06   Nuwakot  15:34        4.0  2015/07/01\n",
       "278     85.41    28.01   Nuwakot  15:05        4.2  2015/05/08\n",
       "287     85.46    27.92   Nuwakot  22:15        4.0  2015/05/07\n",
       "288     85.16    27.79   Nuwakot  07:56        4.0  2015/05/07\n",
       "289     85.19    27.75   Nuwakot  03:41        4.2  2015/05/07\n",
       "301     85.17    27.78   Nuwakot  23:25        4.0  2015/04/25\n",
       "304     85.29     27.8   Nuwakot  22:31        4.0  2015/04/25\n",
       "313     85.16    27.79   Nuwakot  19:38        4.1  2015/04/25\n",
       "318      85.4       28   Nuwakot  18:02        4.9  2015/04/25\n",
       "325     85.33    27.91   Nuwakot  14:48        5.3  2015/04/25\n",
       "330     85.16    27.80   Nuwakot  10:36        4.1  2015/05/04\n",
       "331     85.16    27.79   Nuwakot  10:33        4.0  2015/05/04\n",
       "332     85.21    27.97   Nuwakot  09:54        4.2  2015/05/04\n",
       "338     85.11    27.80   Nuwakot  17:20        4.9  2015/05/03\n",
       "351     81.92    28.80  Jajarkot  07:14        4.5  2015/04/22\n",
       "352     82.18    28.85  Jajarkot  19:52        5.1  2015/04/21\n",
       "355     81.03    29.36      Doti  09:27        4.4  2015/01/22\n",
       "376     85.37    28.04   Nuwakot  13:17        4.0  2015/04/29\n",
       "377     85.14    27.79   Nuwakot  05:54        4.2  2015/04/29\n",
       "381     85.17    27.78   Nuwakot  16:44        4.0  2015/04/28\n",
       "394     85.12    27.80   Nuwakot  15:17        4.0  2015/04/27\n",
       "398     85.12    27.77   Nuwakot  06:24        4.7  2015/04/27\n",
       "411     85.15    27.79   Nuwakot  20:17        4.0  2015/04/26\n",
       "423     85.16     27.8   Nuwakot  08:55        5.1  2015/04/26\n",
       "425     85.12    27.84   Nuwakot  06:16        4.0  2015/04/26\n",
       "430     85.02    27.99   Nuwakot  05:01        5.5  2015/04/26"
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[data.Epicentre.str.contains(r'ot')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "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>Longitude</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Epicentre</th>\n",
       "      <th>Time</th>\n",
       "      <th>Magnitude</th>\n",
       "      <th>Date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>81.29</td>\n",
       "      <td>29.35</td>\n",
       "      <td>Bajura</td>\n",
       "      <td>04:48</td>\n",
       "      <td>4.1</td>\n",
       "      <td>2015/12/26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>81.69</td>\n",
       "      <td>29.44</td>\n",
       "      <td>Bajura</td>\n",
       "      <td>22:16</td>\n",
       "      <td>5.5</td>\n",
       "      <td>2015/12/18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>83.36</td>\n",
       "      <td>28.35</td>\n",
       "      <td>Baglung</td>\n",
       "      <td>08:00</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/11/20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>85.28</td>\n",
       "      <td>28.02</td>\n",
       "      <td>Rasuwa</td>\n",
       "      <td>18:55</td>\n",
       "      <td>4.3</td>\n",
       "      <td>2015/11/17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>85.23</td>\n",
       "      <td>28.03</td>\n",
       "      <td>Rasuwa</td>\n",
       "      <td>09:28</td>\n",
       "      <td>4.3</td>\n",
       "      <td>2015/10/31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>85.35</td>\n",
       "      <td>28.06</td>\n",
       "      <td>Rasuwa</td>\n",
       "      <td>20:21</td>\n",
       "      <td>4.5</td>\n",
       "      <td>2015/05/14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109</th>\n",
       "      <td>85.19</td>\n",
       "      <td>28.01</td>\n",
       "      <td>Rasuwa</td>\n",
       "      <td>20:35</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/05/30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119</th>\n",
       "      <td>85.29</td>\n",
       "      <td>28.00</td>\n",
       "      <td>Rasuwa</td>\n",
       "      <td>11:47</td>\n",
       "      <td>4.6</td>\n",
       "      <td>2015/08/20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>166</th>\n",
       "      <td>86.41</td>\n",
       "      <td>27.58</td>\n",
       "      <td>Ramechhap</td>\n",
       "      <td>23:13</td>\n",
       "      <td>4.3</td>\n",
       "      <td>2015/05/12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>173</th>\n",
       "      <td>85.26</td>\n",
       "      <td>28.02</td>\n",
       "      <td>Rasuwa</td>\n",
       "      <td>22:52</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2015/05/26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203</th>\n",
       "      <td>86.29</td>\n",
       "      <td>27.57</td>\n",
       "      <td>Ramechhap</td>\n",
       "      <td>16:00</td>\n",
       "      <td>4.8</td>\n",
       "      <td>2015/05/12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>221</th>\n",
       "      <td>85.34</td>\n",
       "      <td>28.06</td>\n",
       "      <td>Rasuwa</td>\n",
       "      <td>16:01</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/07/13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>226</th>\n",
       "      <td>83.13</td>\n",
       "      <td>28.48</td>\n",
       "      <td>Baglung</td>\n",
       "      <td>15:21</td>\n",
       "      <td>4.2</td>\n",
       "      <td>2015/07/07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>227</th>\n",
       "      <td>81.74</td>\n",
       "      <td>29.69</td>\n",
       "      <td>Bajura</td>\n",
       "      <td>09:31</td>\n",
       "      <td>4.6</td>\n",
       "      <td>2015/07/07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>253</th>\n",
       "      <td>85.87</td>\n",
       "      <td>27.48</td>\n",
       "      <td>Ramechhap</td>\n",
       "      <td>11:30</td>\n",
       "      <td>4.6</td>\n",
       "      <td>2015/05/17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>273</th>\n",
       "      <td>85.25</td>\n",
       "      <td>28.02</td>\n",
       "      <td>Rasuwa</td>\n",
       "      <td>11:08</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/05/10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>277</th>\n",
       "      <td>85.20</td>\n",
       "      <td>28.04</td>\n",
       "      <td>Rasuwa</td>\n",
       "      <td>03:08</td>\n",
       "      <td>4.1</td>\n",
       "      <td>2015/05/09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>281</th>\n",
       "      <td>86.2</td>\n",
       "      <td>27.35</td>\n",
       "      <td>Ramechhap</td>\n",
       "      <td>05:42</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2015/06/29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>290</th>\n",
       "      <td>85.26</td>\n",
       "      <td>28.04</td>\n",
       "      <td>Rasuwa</td>\n",
       "      <td>22:19</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/05/06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299</th>\n",
       "      <td>85.27</td>\n",
       "      <td>28.1</td>\n",
       "      <td>Rasuwa</td>\n",
       "      <td>23:40</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/04/25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>307</th>\n",
       "      <td>85.16</td>\n",
       "      <td>28.14</td>\n",
       "      <td>Rasuwa</td>\n",
       "      <td>20:36</td>\n",
       "      <td>4.4</td>\n",
       "      <td>2015/04/25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>310</th>\n",
       "      <td>85.25</td>\n",
       "      <td>28.05</td>\n",
       "      <td>Rasuwa</td>\n",
       "      <td>20:08</td>\n",
       "      <td>4.1</td>\n",
       "      <td>2015/04/25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>315</th>\n",
       "      <td>85.2</td>\n",
       "      <td>28.1</td>\n",
       "      <td>Rasuwa</td>\n",
       "      <td>19:15</td>\n",
       "      <td>4.7</td>\n",
       "      <td>2015/04/25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>319</th>\n",
       "      <td>85.28</td>\n",
       "      <td>28.14</td>\n",
       "      <td>Rasuwa</td>\n",
       "      <td>17:26</td>\n",
       "      <td>4.1</td>\n",
       "      <td>2015/04/25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>323</th>\n",
       "      <td>85.16</td>\n",
       "      <td>28.29</td>\n",
       "      <td>Rasuwa</td>\n",
       "      <td>15:28</td>\n",
       "      <td>4.6</td>\n",
       "      <td>2015/04/25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>345</th>\n",
       "      <td>85.75</td>\n",
       "      <td>28.2</td>\n",
       "      <td>Rasuwa</td>\n",
       "      <td>12:53</td>\n",
       "      <td>5.3</td>\n",
       "      <td>2015/04/25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>346</th>\n",
       "      <td>85.65</td>\n",
       "      <td>28.13</td>\n",
       "      <td>Rasuwa</td>\n",
       "      <td>12:41</td>\n",
       "      <td>5.7</td>\n",
       "      <td>2015/04/25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>362</th>\n",
       "      <td>85.32</td>\n",
       "      <td>28.04</td>\n",
       "      <td>Rasuwa</td>\n",
       "      <td>23:59</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/05/01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>365</th>\n",
       "      <td>85.33</td>\n",
       "      <td>28.04</td>\n",
       "      <td>Rasuwa</td>\n",
       "      <td>11:28</td>\n",
       "      <td>4.5</td>\n",
       "      <td>2015/05/01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>371</th>\n",
       "      <td>85.34</td>\n",
       "      <td>28.05</td>\n",
       "      <td>Rasuwa</td>\n",
       "      <td>08:31</td>\n",
       "      <td>4.7</td>\n",
       "      <td>2015/04/30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>396</th>\n",
       "      <td>85.23</td>\n",
       "      <td>28.24</td>\n",
       "      <td>Rasuwa</td>\n",
       "      <td>09:59</td>\n",
       "      <td>4.3</td>\n",
       "      <td>2015/04/27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>403</th>\n",
       "      <td>85.10</td>\n",
       "      <td>28.26</td>\n",
       "      <td>Rasuwa</td>\n",
       "      <td>00:39</td>\n",
       "      <td>4.5</td>\n",
       "      <td>2015/04/27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>427</th>\n",
       "      <td>85.34</td>\n",
       "      <td>28.05</td>\n",
       "      <td>Rasuwa</td>\n",
       "      <td>05:32</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/04/26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>435</th>\n",
       "      <td>85.83</td>\n",
       "      <td>28.25</td>\n",
       "      <td>Rasuwa</td>\n",
       "      <td>02:08</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/04/26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>438</th>\n",
       "      <td>85.35</td>\n",
       "      <td>28.05</td>\n",
       "      <td>Rasuwa</td>\n",
       "      <td>01:49</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/04/26</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Longitude Latitude  Epicentre   Time  Magnitude        Date\n",
       "17      81.29    29.35     Bajura  04:48        4.1  2015/12/26\n",
       "19      81.69    29.44     Bajura  22:16        5.5  2015/12/18\n",
       "35      83.36    28.35    Baglung  08:00        4.0  2015/11/20\n",
       "38      85.28    28.02     Rasuwa  18:55        4.3  2015/11/17\n",
       "40      85.23    28.03     Rasuwa  09:28        4.3  2015/10/31\n",
       "88      85.35    28.06     Rasuwa  20:21        4.5  2015/05/14\n",
       "109     85.19    28.01     Rasuwa  20:35        4.0  2015/05/30\n",
       "119     85.29    28.00     Rasuwa  11:47        4.6  2015/08/20\n",
       "166     86.41    27.58  Ramechhap  23:13        4.3  2015/05/12\n",
       "173     85.26    28.02     Rasuwa  22:52        5.0  2015/05/26\n",
       "203     86.29    27.57  Ramechhap  16:00        4.8  2015/05/12\n",
       "221     85.34    28.06     Rasuwa  16:01        4.0  2015/07/13\n",
       "226     83.13    28.48    Baglung  15:21        4.2  2015/07/07\n",
       "227     81.74    29.69     Bajura  09:31        4.6  2015/07/07\n",
       "253     85.87    27.48  Ramechhap  11:30        4.6  2015/05/17\n",
       "273     85.25    28.02     Rasuwa  11:08        4.0  2015/05/10\n",
       "277     85.20    28.04     Rasuwa  03:08        4.1  2015/05/09\n",
       "281      86.2    27.35  Ramechhap  05:42        5.0  2015/06/29\n",
       "290     85.26    28.04     Rasuwa  22:19        4.0  2015/05/06\n",
       "299     85.27     28.1     Rasuwa  23:40        4.0  2015/04/25\n",
       "307     85.16    28.14     Rasuwa  20:36        4.4  2015/04/25\n",
       "310     85.25    28.05     Rasuwa  20:08        4.1  2015/04/25\n",
       "315      85.2     28.1     Rasuwa  19:15        4.7  2015/04/25\n",
       "319     85.28    28.14     Rasuwa  17:26        4.1  2015/04/25\n",
       "323     85.16    28.29     Rasuwa  15:28        4.6  2015/04/25\n",
       "345     85.75     28.2     Rasuwa  12:53        5.3  2015/04/25\n",
       "346     85.65    28.13     Rasuwa  12:41        5.7  2015/04/25\n",
       "362     85.32    28.04     Rasuwa  23:59        4.0  2015/05/01\n",
       "365     85.33    28.04     Rasuwa  11:28        4.5  2015/05/01\n",
       "371     85.34    28.05     Rasuwa  08:31        4.7  2015/04/30\n",
       "396     85.23    28.24     Rasuwa  09:59        4.3  2015/04/27\n",
       "403     85.10    28.26     Rasuwa  00:39        4.5  2015/04/27\n",
       "427     85.34    28.05     Rasuwa  05:32        4.0  2015/04/26\n",
       "435     85.83    28.25     Rasuwa  02:08        4.0  2015/04/26\n",
       "438     85.35    28.05     Rasuwa  01:49        4.0  2015/04/26"
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[data.Epicentre.str.contains(r'Ba|Ra')]"
   ]
  },
  {
   "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>Longitude</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Epicentre</th>\n",
       "      <th>Time</th>\n",
       "      <th>Magnitude</th>\n",
       "      <th>Date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>85.17</td>\n",
       "      <td>27.78</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>21:07</td>\n",
       "      <td>4.3</td>\n",
       "      <td>2015/06/25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>85.29</td>\n",
       "      <td>27.87</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>17:00</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/11/24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>85.15</td>\n",
       "      <td>27.80</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>05:59</td>\n",
       "      <td>4.2</td>\n",
       "      <td>2015/06/14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>85.48</td>\n",
       "      <td>27.97</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>06:11</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/05/16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>108</th>\n",
       "      <td>85.17</td>\n",
       "      <td>27.79</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>22:13</td>\n",
       "      <td>4.5</td>\n",
       "      <td>2015/05/30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118</th>\n",
       "      <td>85.48</td>\n",
       "      <td>27.96</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>12:21</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/08/21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>149</th>\n",
       "      <td>85.13</td>\n",
       "      <td>28.04</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>22:29</td>\n",
       "      <td>4.2</td>\n",
       "      <td>2015/05/27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>188</th>\n",
       "      <td>85.48</td>\n",
       "      <td>27.94</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>18:23</td>\n",
       "      <td>4.2</td>\n",
       "      <td>2015/07/27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>213</th>\n",
       "      <td>85.08</td>\n",
       "      <td>28.05</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>16:44</td>\n",
       "      <td>4.8</td>\n",
       "      <td>2015/05/22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>214</th>\n",
       "      <td>85.14</td>\n",
       "      <td>27.79</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>14:45</td>\n",
       "      <td>4.2</td>\n",
       "      <td>2015/05/22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>216</th>\n",
       "      <td>85.46</td>\n",
       "      <td>27.93</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>14:56</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/05/21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>262</th>\n",
       "      <td>85.14</td>\n",
       "      <td>28.06</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>15:34</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/07/01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>278</th>\n",
       "      <td>85.41</td>\n",
       "      <td>28.01</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>15:05</td>\n",
       "      <td>4.2</td>\n",
       "      <td>2015/05/08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>287</th>\n",
       "      <td>85.46</td>\n",
       "      <td>27.92</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>22:15</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/05/07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>288</th>\n",
       "      <td>85.16</td>\n",
       "      <td>27.79</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>07:56</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/05/07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>289</th>\n",
       "      <td>85.19</td>\n",
       "      <td>27.75</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>03:41</td>\n",
       "      <td>4.2</td>\n",
       "      <td>2015/05/07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>301</th>\n",
       "      <td>85.17</td>\n",
       "      <td>27.78</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>23:25</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/04/25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>304</th>\n",
       "      <td>85.29</td>\n",
       "      <td>27.8</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>22:31</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/04/25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>313</th>\n",
       "      <td>85.16</td>\n",
       "      <td>27.79</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>19:38</td>\n",
       "      <td>4.1</td>\n",
       "      <td>2015/04/25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>318</th>\n",
       "      <td>85.4</td>\n",
       "      <td>28</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>18:02</td>\n",
       "      <td>4.9</td>\n",
       "      <td>2015/04/25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>325</th>\n",
       "      <td>85.33</td>\n",
       "      <td>27.91</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>14:48</td>\n",
       "      <td>5.3</td>\n",
       "      <td>2015/04/25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>330</th>\n",
       "      <td>85.16</td>\n",
       "      <td>27.80</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>10:36</td>\n",
       "      <td>4.1</td>\n",
       "      <td>2015/05/04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>331</th>\n",
       "      <td>85.16</td>\n",
       "      <td>27.79</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>10:33</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/05/04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>332</th>\n",
       "      <td>85.21</td>\n",
       "      <td>27.97</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>09:54</td>\n",
       "      <td>4.2</td>\n",
       "      <td>2015/05/04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>338</th>\n",
       "      <td>85.11</td>\n",
       "      <td>27.80</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>17:20</td>\n",
       "      <td>4.9</td>\n",
       "      <td>2015/05/03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>351</th>\n",
       "      <td>81.92</td>\n",
       "      <td>28.80</td>\n",
       "      <td>Jajarkot</td>\n",
       "      <td>07:14</td>\n",
       "      <td>4.5</td>\n",
       "      <td>2015/04/22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>352</th>\n",
       "      <td>82.18</td>\n",
       "      <td>28.85</td>\n",
       "      <td>Jajarkot</td>\n",
       "      <td>19:52</td>\n",
       "      <td>5.1</td>\n",
       "      <td>2015/04/21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>376</th>\n",
       "      <td>85.37</td>\n",
       "      <td>28.04</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>13:17</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/04/29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>377</th>\n",
       "      <td>85.14</td>\n",
       "      <td>27.79</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>05:54</td>\n",
       "      <td>4.2</td>\n",
       "      <td>2015/04/29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>381</th>\n",
       "      <td>85.17</td>\n",
       "      <td>27.78</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>16:44</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/04/28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>394</th>\n",
       "      <td>85.12</td>\n",
       "      <td>27.80</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>15:17</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/04/27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>398</th>\n",
       "      <td>85.12</td>\n",
       "      <td>27.77</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>06:24</td>\n",
       "      <td>4.7</td>\n",
       "      <td>2015/04/27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>411</th>\n",
       "      <td>85.15</td>\n",
       "      <td>27.79</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>20:17</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/04/26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>423</th>\n",
       "      <td>85.16</td>\n",
       "      <td>27.8</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>08:55</td>\n",
       "      <td>5.1</td>\n",
       "      <td>2015/04/26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>425</th>\n",
       "      <td>85.12</td>\n",
       "      <td>27.84</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>06:16</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/04/26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>430</th>\n",
       "      <td>85.02</td>\n",
       "      <td>27.99</td>\n",
       "      <td>Nuwakot</td>\n",
       "      <td>05:01</td>\n",
       "      <td>5.5</td>\n",
       "      <td>2015/04/26</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Longitude Latitude Epicentre   Time  Magnitude        Date\n",
       "3       85.17    27.78   Nuwakot  21:07        4.3  2015/06/25\n",
       "27      85.29    27.87   Nuwakot  17:00        4.0  2015/11/24\n",
       "31      85.15    27.80   Nuwakot  05:59        4.2  2015/06/14\n",
       "50      85.48    27.97   Nuwakot  06:11        4.0  2015/05/16\n",
       "108     85.17    27.79   Nuwakot  22:13        4.5  2015/05/30\n",
       "118     85.48    27.96   Nuwakot  12:21        4.0  2015/08/21\n",
       "149     85.13    28.04   Nuwakot  22:29        4.2  2015/05/27\n",
       "188     85.48    27.94   Nuwakot  18:23        4.2  2015/07/27\n",
       "213     85.08    28.05   Nuwakot  16:44        4.8  2015/05/22\n",
       "214     85.14    27.79   Nuwakot  14:45        4.2  2015/05/22\n",
       "216     85.46    27.93   Nuwakot  14:56        4.0  2015/05/21\n",
       "262     85.14    28.06   Nuwakot  15:34        4.0  2015/07/01\n",
       "278     85.41    28.01   Nuwakot  15:05        4.2  2015/05/08\n",
       "287     85.46    27.92   Nuwakot  22:15        4.0  2015/05/07\n",
       "288     85.16    27.79   Nuwakot  07:56        4.0  2015/05/07\n",
       "289     85.19    27.75   Nuwakot  03:41        4.2  2015/05/07\n",
       "301     85.17    27.78   Nuwakot  23:25        4.0  2015/04/25\n",
       "304     85.29     27.8   Nuwakot  22:31        4.0  2015/04/25\n",
       "313     85.16    27.79   Nuwakot  19:38        4.1  2015/04/25\n",
       "318      85.4       28   Nuwakot  18:02        4.9  2015/04/25\n",
       "325     85.33    27.91   Nuwakot  14:48        5.3  2015/04/25\n",
       "330     85.16    27.80   Nuwakot  10:36        4.1  2015/05/04\n",
       "331     85.16    27.79   Nuwakot  10:33        4.0  2015/05/04\n",
       "332     85.21    27.97   Nuwakot  09:54        4.2  2015/05/04\n",
       "338     85.11    27.80   Nuwakot  17:20        4.9  2015/05/03\n",
       "351     81.92    28.80  Jajarkot  07:14        4.5  2015/04/22\n",
       "352     82.18    28.85  Jajarkot  19:52        5.1  2015/04/21\n",
       "376     85.37    28.04   Nuwakot  13:17        4.0  2015/04/29\n",
       "377     85.14    27.79   Nuwakot  05:54        4.2  2015/04/29\n",
       "381     85.17    27.78   Nuwakot  16:44        4.0  2015/04/28\n",
       "394     85.12    27.80   Nuwakot  15:17        4.0  2015/04/27\n",
       "398     85.12    27.77   Nuwakot  06:24        4.7  2015/04/27\n",
       "411     85.15    27.79   Nuwakot  20:17        4.0  2015/04/26\n",
       "423     85.16     27.8   Nuwakot  08:55        5.1  2015/04/26\n",
       "425     85.12    27.84   Nuwakot  06:16        4.0  2015/04/26\n",
       "430     85.02    27.99   Nuwakot  05:01        5.5  2015/04/26"
      ]
     },
     "execution_count": 52,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[data.Epicentre.str.contains(r'^.*ot$')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "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>Longitude</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Epicentre</th>\n",
       "      <th>Time</th>\n",
       "      <th>Magnitude</th>\n",
       "      <th>Date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>85.49</td>\n",
       "      <td>27.94</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>23:51</td>\n",
       "      <td>4.2</td>\n",
       "      <td>2015/06/25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>85.75</td>\n",
       "      <td>27.85</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>14:59</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/06/24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>86.00</td>\n",
       "      <td>27.80</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>19:26</td>\n",
       "      <td>4.3</td>\n",
       "      <td>2015/06/21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>85.58</td>\n",
       "      <td>27.90</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>06:26</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/06/17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>85.59</td>\n",
       "      <td>27.91</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>06:14</td>\n",
       "      <td>5.2</td>\n",
       "      <td>2015/06/17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>85.28</td>\n",
       "      <td>27.68</td>\n",
       "      <td>Kathmandu</td>\n",
       "      <td>05:58</td>\n",
       "      <td>4.4</td>\n",
       "      <td>2015/06/17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>85.72</td>\n",
       "      <td>27.86</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>07:41</td>\n",
       "      <td>4.3</td>\n",
       "      <td>2015/12/31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>85.39</td>\n",
       "      <td>27.78</td>\n",
       "      <td>Kathmandu</td>\n",
       "      <td>6:10</td>\n",
       "      <td>4.1</td>\n",
       "      <td>2015/11/30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>85.53</td>\n",
       "      <td>27.63</td>\n",
       "      <td>Kavrepalanchowk</td>\n",
       "      <td>15:23</td>\n",
       "      <td>4.1</td>\n",
       "      <td>2015/11/27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>85.77</td>\n",
       "      <td>27.87</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>00:42</td>\n",
       "      <td>4.1</td>\n",
       "      <td>2015/11/25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>85.72</td>\n",
       "      <td>27.87</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>15:52</td>\n",
       "      <td>4.1</td>\n",
       "      <td>2015/06/15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>85.88</td>\n",
       "      <td>27.77</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>17:44</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/11/19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>85.75</td>\n",
       "      <td>27.89</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>10:00</td>\n",
       "      <td>5.3</td>\n",
       "      <td>2015/11/19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>85.65</td>\n",
       "      <td>27.99</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>15.45</td>\n",
       "      <td>4.2</td>\n",
       "      <td>2015/11/12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>85.54</td>\n",
       "      <td>27.96</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>21:58</td>\n",
       "      <td>4.1</td>\n",
       "      <td>2015/10/08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>85.85</td>\n",
       "      <td>27.70</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>09:24</td>\n",
       "      <td>4.2</td>\n",
       "      <td>2015/05/16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>85.73</td>\n",
       "      <td>27.96</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>21:57</td>\n",
       "      <td>5.3</td>\n",
       "      <td>2015/06/11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>85.78</td>\n",
       "      <td>27.80</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>10:02</td>\n",
       "      <td>4.6</td>\n",
       "      <td>2015/06/11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>85.61</td>\n",
       "      <td>27.80</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>13:36</td>\n",
       "      <td>4.3</td>\n",
       "      <td>2015/06/10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>85.81</td>\n",
       "      <td>27.87</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>02:50</td>\n",
       "      <td>4.1</td>\n",
       "      <td>2015/06/10</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Longitude Latitude        Epicentre   Time  Magnitude        Date\n",
       "1      85.49    27.94   Sindhupalchowk  23:51        4.2  2015/06/25\n",
       "4      85.75    27.85   Sindhupalchowk  14:59        4.0  2015/06/24\n",
       "6      86.00    27.80   Sindhupalchowk  19:26        4.3  2015/06/21\n",
       "12     85.58    27.90   Sindhupalchowk  06:26        4.0  2015/06/17\n",
       "13     85.59    27.91   Sindhupalchowk  06:14        5.2  2015/06/17\n",
       "14     85.28    27.68        Kathmandu  05:58        4.4  2015/06/17\n",
       "15     85.72    27.86   Sindhupalchowk  07:41        4.3  2015/12/31\n",
       "22     85.39    27.78        Kathmandu   6:10        4.1  2015/11/30\n",
       "23     85.53    27.63  Kavrepalanchowk  15:23        4.1  2015/11/27\n",
       "25     85.77    27.87   Sindhupalchowk  00:42        4.1  2015/11/25\n",
       "29     85.72    27.87   Sindhupalchowk  15:52        4.1  2015/06/15\n",
       "36     85.88    27.77   Sindhupalchowk  17:44        4.0  2015/11/19\n",
       "37     85.75    27.89   Sindhupalchowk  10:00        5.3  2015/11/19\n",
       "39     85.65    27.99   Sindhupalchowk  15.45        4.2  2015/11/12\n",
       "43     85.54    27.96   Sindhupalchowk  21:58        4.1  2015/10/08\n",
       "48     85.85    27.70   Sindhupalchowk  09:24        4.2  2015/05/16\n",
       "60     85.73    27.96   Sindhupalchowk  21:57        5.3  2015/06/11\n",
       "61     85.78    27.80   Sindhupalchowk  10:02        4.6  2015/06/11\n",
       "64     85.61    27.80   Sindhupalchowk  13:36        4.3  2015/06/10\n",
       "65     85.81    27.87   Sindhupalchowk  02:50        4.1  2015/06/10"
      ]
     },
     "execution_count": 54,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[data.Epicentre.str.contains(r'^[KSA]+.*[a-z]+$')].head(20)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "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>Longitude</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Epicentre</th>\n",
       "      <th>Time</th>\n",
       "      <th>Magnitude</th>\n",
       "      <th>Date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>302</th>\n",
       "      <td>85.53</td>\n",
       "      <td>27.9</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>23:24</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/04/25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>303</th>\n",
       "      <td>85.83</td>\n",
       "      <td>27.77</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>23:19</td>\n",
       "      <td>4.1</td>\n",
       "      <td>2015/04/25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>305</th>\n",
       "      <td>85.64</td>\n",
       "      <td>27.92</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>22:12</td>\n",
       "      <td>5.3</td>\n",
       "      <td>2015/04/25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>306</th>\n",
       "      <td>85.56</td>\n",
       "      <td>27.95</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>21:02</td>\n",
       "      <td>4.2</td>\n",
       "      <td>2015/04/25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>308</th>\n",
       "      <td>85.9</td>\n",
       "      <td>27.73</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>20:25</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2015/04/25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>311</th>\n",
       "      <td>85.9</td>\n",
       "      <td>27.73</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>19:55</td>\n",
       "      <td>4.7</td>\n",
       "      <td>2015/04/25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>320</th>\n",
       "      <td>85.50</td>\n",
       "      <td>27.91</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>16:50</td>\n",
       "      <td>4.6</td>\n",
       "      <td>2015/04/25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>321</th>\n",
       "      <td>85.85</td>\n",
       "      <td>27.86</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>16:25</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/04/25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>322</th>\n",
       "      <td>85.8</td>\n",
       "      <td>27.87</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>16:08</td>\n",
       "      <td>4.1</td>\n",
       "      <td>2015/04/25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324</th>\n",
       "      <td>85.6</td>\n",
       "      <td>28</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>15:15</td>\n",
       "      <td>5.5</td>\n",
       "      <td>2015/04/25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>329</th>\n",
       "      <td>85.84</td>\n",
       "      <td>27.78</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>14:02</td>\n",
       "      <td>5.2</td>\n",
       "      <td>2015/04/25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>369</th>\n",
       "      <td>85.87</td>\n",
       "      <td>27.92</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>23:19</td>\n",
       "      <td>4.3</td>\n",
       "      <td>2015/04/30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>374</th>\n",
       "      <td>85.52</td>\n",
       "      <td>27.95</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>17:12</td>\n",
       "      <td>4.5</td>\n",
       "      <td>2015/04/29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>378</th>\n",
       "      <td>85.63</td>\n",
       "      <td>27.93</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>04:49</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/04/29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>380</th>\n",
       "      <td>85.88</td>\n",
       "      <td>27.88</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>17:03</td>\n",
       "      <td>4.2</td>\n",
       "      <td>2015/04/28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>382</th>\n",
       "      <td>85.83</td>\n",
       "      <td>27.83</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>15:10</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/04/28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>383</th>\n",
       "      <td>85.55</td>\n",
       "      <td>27.96</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>12:08</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/04/28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>384</th>\n",
       "      <td>85.80</td>\n",
       "      <td>27.76</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>08:40</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/04/28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>386</th>\n",
       "      <td>85.49</td>\n",
       "      <td>28.10</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>05:05</td>\n",
       "      <td>4.9</td>\n",
       "      <td>2015/04/28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>388</th>\n",
       "      <td>85.76</td>\n",
       "      <td>27.89</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>03:12</td>\n",
       "      <td>4.2</td>\n",
       "      <td>2015/04/28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>389</th>\n",
       "      <td>85.51</td>\n",
       "      <td>27.92</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>02:59</td>\n",
       "      <td>4.2</td>\n",
       "      <td>2015/04/28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>392</th>\n",
       "      <td>85.89</td>\n",
       "      <td>27.82</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>22:39</td>\n",
       "      <td>4.2</td>\n",
       "      <td>2015/04/27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>395</th>\n",
       "      <td>85.86</td>\n",
       "      <td>27.93</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>10:05</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/04/27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>399</th>\n",
       "      <td>85.76</td>\n",
       "      <td>27.82</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>04:27</td>\n",
       "      <td>4.4</td>\n",
       "      <td>2015/04/27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>404</th>\n",
       "      <td>85.55</td>\n",
       "      <td>27.91</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>23:51</td>\n",
       "      <td>4.2</td>\n",
       "      <td>2015/04/26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>406</th>\n",
       "      <td>85.87</td>\n",
       "      <td>27.95</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>22:10</td>\n",
       "      <td>5.3</td>\n",
       "      <td>2015/04/26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>410</th>\n",
       "      <td>85.97</td>\n",
       "      <td>27.72</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>20:29</td>\n",
       "      <td>4.5</td>\n",
       "      <td>2015/04/26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>413</th>\n",
       "      <td>85.6</td>\n",
       "      <td>27.89</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>18:56</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2015/04/26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>414</th>\n",
       "      <td>85.91</td>\n",
       "      <td>27.77</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>15:27</td>\n",
       "      <td>4.5</td>\n",
       "      <td>2015/04/26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>415</th>\n",
       "      <td>85.81</td>\n",
       "      <td>27.97</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>14:31</td>\n",
       "      <td>4.5</td>\n",
       "      <td>2015/04/26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>416</th>\n",
       "      <td>86</td>\n",
       "      <td>27.79</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>14:25</td>\n",
       "      <td>4.8</td>\n",
       "      <td>2015/04/26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>418</th>\n",
       "      <td>85.94</td>\n",
       "      <td>27.75</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>13:12</td>\n",
       "      <td>5.3</td>\n",
       "      <td>2015/04/26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>421</th>\n",
       "      <td>85.5</td>\n",
       "      <td>28.04</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>10:35</td>\n",
       "      <td>4.5</td>\n",
       "      <td>2015/04/26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>431</th>\n",
       "      <td>85.8</td>\n",
       "      <td>27.82</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>02:52</td>\n",
       "      <td>4.8</td>\n",
       "      <td>2015/04/26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>433</th>\n",
       "      <td>85.96</td>\n",
       "      <td>27.6</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>02:17</td>\n",
       "      <td>4.8</td>\n",
       "      <td>2015/04/26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>436</th>\n",
       "      <td>85.56</td>\n",
       "      <td>27.93</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>01:56</td>\n",
       "      <td>4.4</td>\n",
       "      <td>2015/04/26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>439</th>\n",
       "      <td>85.56</td>\n",
       "      <td>27.93</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>01:29</td>\n",
       "      <td>4.1</td>\n",
       "      <td>2015/04/26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>441</th>\n",
       "      <td>85.55</td>\n",
       "      <td>27.94</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>00:14</td>\n",
       "      <td>4.1</td>\n",
       "      <td>2015/04/26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>442</th>\n",
       "      <td>85.98</td>\n",
       "      <td>27.78</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>23:46</td>\n",
       "      <td>4.1</td>\n",
       "      <td>2015/04/25</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Longitude Latitude       Epicentre   Time  Magnitude        Date\n",
       "302     85.53     27.9  Sindhupalchowk  23:24        4.0  2015/04/25\n",
       "303     85.83    27.77  Sindhupalchowk  23:19        4.1  2015/04/25\n",
       "305     85.64    27.92  Sindhupalchowk  22:12        5.3  2015/04/25\n",
       "306     85.56    27.95  Sindhupalchowk  21:02        4.2  2015/04/25\n",
       "308      85.9    27.73  Sindhupalchowk  20:25        5.0  2015/04/25\n",
       "311      85.9    27.73  Sindhupalchowk  19:55        4.7  2015/04/25\n",
       "320     85.50    27.91  Sindhupalchowk  16:50        4.6  2015/04/25\n",
       "321     85.85    27.86  Sindhupalchowk  16:25        4.0  2015/04/25\n",
       "322      85.8    27.87  Sindhupalchowk  16:08        4.1  2015/04/25\n",
       "324      85.6       28  Sindhupalchowk  15:15        5.5  2015/04/25\n",
       "329     85.84    27.78  Sindhupalchowk  14:02        5.2  2015/04/25\n",
       "369     85.87    27.92  Sindhupalchowk  23:19        4.3  2015/04/30\n",
       "374     85.52    27.95  Sindhupalchowk  17:12        4.5  2015/04/29\n",
       "378     85.63    27.93  Sindhupalchowk  04:49        4.0  2015/04/29\n",
       "380     85.88    27.88  Sindhupalchowk  17:03        4.2  2015/04/28\n",
       "382     85.83    27.83  Sindhupalchowk  15:10        4.0  2015/04/28\n",
       "383     85.55    27.96  Sindhupalchowk  12:08        4.0  2015/04/28\n",
       "384     85.80    27.76  Sindhupalchowk  08:40        4.0  2015/04/28\n",
       "386     85.49    28.10  Sindhupalchowk  05:05        4.9  2015/04/28\n",
       "388     85.76    27.89  Sindhupalchowk  03:12        4.2  2015/04/28\n",
       "389     85.51    27.92  Sindhupalchowk  02:59        4.2  2015/04/28\n",
       "392     85.89    27.82  Sindhupalchowk  22:39        4.2  2015/04/27\n",
       "395     85.86    27.93  Sindhupalchowk  10:05        4.0  2015/04/27\n",
       "399     85.76    27.82  Sindhupalchowk  04:27        4.4  2015/04/27\n",
       "404     85.55    27.91  Sindhupalchowk  23:51        4.2  2015/04/26\n",
       "406     85.87    27.95  Sindhupalchowk  22:10        5.3  2015/04/26\n",
       "410     85.97    27.72  Sindhupalchowk  20:29        4.5  2015/04/26\n",
       "413      85.6    27.89  Sindhupalchowk  18:56        5.0  2015/04/26\n",
       "414     85.91    27.77  Sindhupalchowk  15:27        4.5  2015/04/26\n",
       "415     85.81    27.97  Sindhupalchowk  14:31        4.5  2015/04/26\n",
       "416        86    27.79  Sindhupalchowk  14:25        4.8  2015/04/26\n",
       "418     85.94    27.75  Sindhupalchowk  13:12        5.3  2015/04/26\n",
       "421      85.5    28.04  Sindhupalchowk  10:35        4.5  2015/04/26\n",
       "431      85.8    27.82  Sindhupalchowk  02:52        4.8  2015/04/26\n",
       "433     85.96     27.6  Sindhupalchowk  02:17        4.8  2015/04/26\n",
       "436     85.56    27.93  Sindhupalchowk  01:56        4.4  2015/04/26\n",
       "439     85.56    27.93  Sindhupalchowk  01:29        4.1  2015/04/26\n",
       "441     85.55    27.94  Sindhupalchowk  00:14        4.1  2015/04/26\n",
       "442     85.98    27.78  Sindhupalchowk  23:46        4.1  2015/04/25"
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[data.Date.between('2015/04/25','2015/04/31')&data.Epicentre.str.contains(r'Sindhu')]"
   ]
  },
  {
   "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>Longitude</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Epicentre</th>\n",
       "      <th>Time</th>\n",
       "      <th>Magnitude</th>\n",
       "      <th>Date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>302</th>\n",
       "      <td>85.53</td>\n",
       "      <td>27.9</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>23:24</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2015/04/25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>329</th>\n",
       "      <td>85.84</td>\n",
       "      <td>27.78</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>14:02</td>\n",
       "      <td>5.2</td>\n",
       "      <td>2015/04/25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>389</th>\n",
       "      <td>85.51</td>\n",
       "      <td>27.92</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>02:59</td>\n",
       "      <td>4.2</td>\n",
       "      <td>2015/04/28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>416</th>\n",
       "      <td>86</td>\n",
       "      <td>27.79</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "      <td>14:25</td>\n",
       "      <td>4.8</td>\n",
       "      <td>2015/04/26</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Longitude Latitude       Epicentre   Time  Magnitude        Date\n",
       "302     85.53     27.9  Sindhupalchowk  23:24        4.0  2015/04/25\n",
       "329     85.84    27.78  Sindhupalchowk  14:02        5.2  2015/04/25\n",
       "389     85.51    27.92  Sindhupalchowk  02:59        4.2  2015/04/28\n",
       "416        86    27.79  Sindhupalchowk  14:25        4.8  2015/04/26"
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[data.Date.str.contains(r'/04/')&data.Epicentre.str.contains(r'Sindhu')][::10]"
   ]
  },
  {
   "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.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}