web scraping (1).ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\msi\\anaconda3\\lib\\site-packages\\bs4\\__init__.py:414: MarkupResemblesLocatorWarning: \"http://seismonepal.gov.np/earthquakes/2019\" looks like a URL. Beautiful Soup is not an HTTP client. You should probably use an HTTP client like requests to get the document behind the URL, and feed that document to Beautiful Soup.\n",
      "  warnings.warn(\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "48\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "[['Date',\n",
       "  'Time',\n",
       "  'Latitude',\n",
       "  'Longitude',\n",
       "  'Magnitude(ML)',\n",
       "  'Remarks',\n",
       "  'Epicenter'],\n",
       " ['B.S:2076-8-26',\n",
       "  'Local:19:11',\n",
       "  '27.95',\n",
       "  '85.59',\n",
       "  '4.8',\n",
       "  'NSC',\n",
       "  'Sindhupalchowk'],\n",
       " ['B.S:2076-8-11',\n",
       "  'Local:22:08',\n",
       "  '27.79',\n",
       "  '85.79',\n",
       "  '5.0',\n",
       "  'NSC',\n",
       "  'Sindhupalchowk'],\n",
       " ['B.S:2076-8-3',\n",
       "  'Local:19:15',\n",
       "  '29.42',\n",
       "  '81.10',\n",
       "  '5.7',\n",
       "  'NSC/RSC',\n",
       "  'Bajhang'],\n",
       " ['B.S:2076-7-26', 'Local:07:45', '30.20', '80.10', '4.6', 'NSC/RSC', 'India'],\n",
       " ['B.S:2076-7-15', 'Local:03:51', '28.45', '83.23', '4.5', 'NSC', 'Baglung'],\n",
       " ['B.S:2076-7-11', 'Local:19:27', '29.66', '82.04', '4.1', 'NSC/RSC', 'Mugu'],\n",
       " ['B.S:2076-7-5', 'Local:11:06', '26.88 ', '86.59', '4.1', 'NSC', 'Udayapur'],\n",
       " ['B.S:2076-7-4', 'Local:01:09', '27.82', '87.98', '4.2', 'NSC', 'Taplejung'],\n",
       " ['B.S:2076-6-12',\n",
       "  'Local:07:27',\n",
       "  '28.66',\n",
       "  '83.06',\n",
       "  '4.4',\n",
       "  'NSC',\n",
       "  'Rukum/Baglung border'],\n",
       " ['B.S:2076-6-11',\n",
       "  'Local:10:43',\n",
       "  '30.0',\n",
       "  '81.45',\n",
       "  '4.3',\n",
       "  'RSC/NSC',\n",
       "  'Bajhang/Humla border'],\n",
       " ['B.S:2076-6-9',\n",
       "  'Local:18:49',\n",
       "  '28.28',\n",
       "  '84.65',\n",
       "  '4.7',\n",
       "  'NSC',\n",
       "  'Gorkha/Lamjung border'],\n",
       " ['B.S:2076-6-9', 'Local:01:18', '27.71', '86.32', '4.0', 'NSC', 'Dolakha'],\n",
       " ['B.S:2076-6-5', 'Local:22:01', '28.25', '84.49', '4.4', 'NSC', 'Lamjung'],\n",
       " ['B.S:2076-6-4', 'Local:06:19', '28.15', '84.61', '4.0', 'NSC', 'Gorkha'],\n",
       " ['B.S:2076-5-31', 'Local:09:53', '28.21', '84.49', '4.5', 'NSC', 'Lamjung'],\n",
       " ['B.S:2076-5-30',\n",
       "  'Local:20:18',\n",
       "  '29.80',\n",
       "  '80.48',\n",
       "  '4.4',\n",
       "  'NSC/RSC',\n",
       "  'Darchula(Nepal-India Border)'],\n",
       " ['B.S:2076-5-29', 'Local:10:54', '30.30', '81.74', '5.0', 'RSC/NSC', 'Humla'],\n",
       " ['B.S:2076-5-5', 'Local:07:07', '27.52', '86.39', '4.0', 'NSC', 'Solukhumbu'],\n",
       " ['B.S:2076-4-29', 'Local:23:09', '27.69', '86.26', '4.3', 'NSC', 'Dolakha'],\n",
       " ['B.S:2076-4-24', 'Local:18:26', '28.5', '83.22', '4.7', 'NSC', 'Myagdi'],\n",
       " ['B.S:2076-4-8', 'Local:17:58', '27.80', '86.15', '4.2', 'NSC', 'Dolakha'],\n",
       " ['B.S:2076-3-21', 'Local:16:15', '27.67', '85.42', '4.6', 'NSC', 'Bhaktapur'],\n",
       " ['B.S:2076-3-12', 'Local:22:21', '27.95', '84.8', '4.0', 'NSC', 'Dhading'],\n",
       " ['B.S:2076-2-32',\n",
       "  'Local:21:32',\n",
       "  '28.95',\n",
       "  '81.98',\n",
       "  '4.5',\n",
       "  'NSC/RSC',\n",
       "  'Jajarkot'],\n",
       " ['B.S:2076-2-31',\n",
       "  'Local:12:22',\n",
       "  '29.52',\n",
       "  '81.05',\n",
       "  '4.0',\n",
       "  'RSC/NSC',\n",
       "  'Bajhang'],\n",
       " ['B.S:2076-2-16', 'Local:10:01', '29.62', '82.11', '4.6', 'RSC/NSC', 'Mugu'],\n",
       " ['B.S:2076-2-11',\n",
       "  'Local:21:08',\n",
       "  '29.50',\n",
       "  '81.28',\n",
       "  '4.3',\n",
       "  'RSC/NSC',\n",
       "  'Bajhang'],\n",
       " ['B.S:2076-2-11', 'Local:11:02', '27.70', '86.47', '4.9', 'NSC', 'Ramechhap'],\n",
       " ['B.S:2076-2-7', 'Local:23:47', '28.21', '84.37', '4.1', 'NSC', 'Lamjung'],\n",
       " ['B.S:2076-2-3', 'Local:14:08', '27.85', '84.87', '5.0', 'NSC', 'Dhading'],\n",
       " ['B.S:2076-1-29',\n",
       "  'Local:00:36',\n",
       "  '28.98',\n",
       "  '81.78',\n",
       "  '5.1',\n",
       "  'RSC/NSC',\n",
       "  'Dailekh'],\n",
       " ['B.S:2076-1-21',\n",
       "  'Local:08:37',\n",
       "  '27.94',\n",
       "  '85.72',\n",
       "  '4.0',\n",
       "  'NSC',\n",
       "  'Sindhupalchowk'],\n",
       " ['B.S:2076-1-16',\n",
       "  'Local:11:35',\n",
       "  '27.93',\n",
       "  '85.94',\n",
       "  '4.0',\n",
       "  'NSC',\n",
       "  'Sindhupalchowk'],\n",
       " ['B.S:2076-1-11', 'Local:06:40', '27.70', '85.14', '4.3', 'NSC', 'Dhading'],\n",
       " ['B.S:2076-1-11', 'Local:06:29', '27.69', '85.17', '5.2', 'NSC', 'Dhading'],\n",
       " ['B.S:2076-1-3', 'Local:12:35', '28.00', '84.76', '4.5', 'NSC', 'Gorkha'],\n",
       " ['B.S:2076-1-2',\n",
       "  'Local:04:27',\n",
       "  '29.49',\n",
       "  '81.24',\n",
       "  '4.8',\n",
       "  'RSC/NSC',\n",
       "  'Bajhang'],\n",
       " ['B.S:2075-12-30', 'Local:10:25', '28.03', '85.38', '4.6', 'NSC', 'Rasuwa'],\n",
       " ['B.S:2075-12-26', 'Local:13:05', '27.76', '86.27', '4.2', 'NSC', 'Dolakha'],\n",
       " ['B.S:2075-12-18',\n",
       "  'Local:20:47',\n",
       "  '28.98',\n",
       "  '81.69',\n",
       "  '4.1',\n",
       "  'RSC/NSC',\n",
       "  'Dailekh'],\n",
       " ['B.S:2075-12-4',\n",
       "  'Local:09:01',\n",
       "  '27.63',\n",
       "  '85.16',\n",
       "  '4.1',\n",
       "  'NSC',\n",
       "  'Makawanpur'],\n",
       " ['B.S:2075-11-14', 'Local:16:15', '27.66', '86.00', '4.4', 'NSC', 'Dolakha'],\n",
       " ['B.S:2075-11-14',\n",
       "  'Local:16:20',\n",
       "  '27.84',\n",
       "  '85.95',\n",
       "  '4.1',\n",
       "  'NSC',\n",
       "  'Sindhupalchok'],\n",
       " ['B.S:2075-11-4', 'Local:20:34', '27.68', '85.27', '4.0', 'NSC', 'Kathmandu'],\n",
       " ['B.S:2075-11-2', 'Local:17:11', '27.81', '88.18', '4.6', 'NSC', 'Taplejung'],\n",
       " ['B.S:2075-10-8', 'Local:22:30', '27.09', '86.96', '4.5', 'NSC', 'Bhojpur'],\n",
       " ['B.S:2075-9-26', 'Local:11:34', '27.60', '86.31', '4.5', 'NSC', 'Ramechhap']]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from bs4 import BeautifulSoup\n",
    "import requests\n",
    "url=BeautifulSoup(\"http://seismonepal.gov.np/earthquakes/2019\",\"html.parser\")\n",
    "start=requests.get(url)\n",
    "s1=start.text\n",
    "soup=BeautifulSoup(s1,\"lxml\")\n",
    "tags=soup.table\n",
    "tag=tags.find_all(\"tr\")\n",
    "list1=[]\n",
    "for i in range(len(tag)):\n",
    "    x=tag[i].get_text()\n",
    "    list1.append(x)\n",
    "list2=[]\n",
    "for i in list1:\n",
    "    y=i.split(\"\\n\")[1:-2]\n",
    "    list2.append(y)\n",
    "for j in range(len(list2)-1):\n",
    "    del list2[j+1][0]\n",
    "print(len(list2))\n",
    "for k in range(len(list2)-1):\n",
    "    del list2[k+1][1:3]\n",
    "for l in range(len(list2)-1):\n",
    "    del list2[l+1][2]\n",
    "list2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "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>Date</th>\n",
       "      <th>Time</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Longitude</th>\n",
       "      <th>Magnitude(ML)</th>\n",
       "      <th>Remarks</th>\n",
       "      <th>Epicenter</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>B.S:2076-8-26</td>\n",
       "      <td>Local:19:11</td>\n",
       "      <td>27.95</td>\n",
       "      <td>85.59</td>\n",
       "      <td>4.8</td>\n",
       "      <td>NSC</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>B.S:2076-8-11</td>\n",
       "      <td>Local:22:08</td>\n",
       "      <td>27.79</td>\n",
       "      <td>85.79</td>\n",
       "      <td>5.0</td>\n",
       "      <td>NSC</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>B.S:2076-8-3</td>\n",
       "      <td>Local:19:15</td>\n",
       "      <td>29.42</td>\n",
       "      <td>81.10</td>\n",
       "      <td>5.7</td>\n",
       "      <td>NSC/RSC</td>\n",
       "      <td>Bajhang</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>B.S:2076-7-26</td>\n",
       "      <td>Local:07:45</td>\n",
       "      <td>30.20</td>\n",
       "      <td>80.10</td>\n",
       "      <td>4.6</td>\n",
       "      <td>NSC/RSC</td>\n",
       "      <td>India</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>B.S:2076-7-15</td>\n",
       "      <td>Local:03:51</td>\n",
       "      <td>28.45</td>\n",
       "      <td>83.23</td>\n",
       "      <td>4.5</td>\n",
       "      <td>NSC</td>\n",
       "      <td>Baglung</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>B.S:2076-7-11</td>\n",
       "      <td>Local:19:27</td>\n",
       "      <td>29.66</td>\n",
       "      <td>82.04</td>\n",
       "      <td>4.1</td>\n",
       "      <td>NSC/RSC</td>\n",
       "      <td>Mugu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>B.S:2076-7-5</td>\n",
       "      <td>Local:11:06</td>\n",
       "      <td>26.88</td>\n",
       "      <td>86.59</td>\n",
       "      <td>4.1</td>\n",
       "      <td>NSC</td>\n",
       "      <td>Udayapur</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>B.S:2076-7-4</td>\n",
       "      <td>Local:01:09</td>\n",
       "      <td>27.82</td>\n",
       "      <td>87.98</td>\n",
       "      <td>4.2</td>\n",
       "      <td>NSC</td>\n",
       "      <td>Taplejung</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>B.S:2076-6-12</td>\n",
       "      <td>Local:07:27</td>\n",
       "      <td>28.66</td>\n",
       "      <td>83.06</td>\n",
       "      <td>4.4</td>\n",
       "      <td>NSC</td>\n",
       "      <td>Rukum/Baglung border</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>B.S:2076-6-11</td>\n",
       "      <td>Local:10:43</td>\n",
       "      <td>30.00</td>\n",
       "      <td>81.45</td>\n",
       "      <td>4.3</td>\n",
       "      <td>RSC/NSC</td>\n",
       "      <td>Bajhang/Humla border</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>B.S:2076-6-9</td>\n",
       "      <td>Local:18:49</td>\n",
       "      <td>28.28</td>\n",
       "      <td>84.65</td>\n",
       "      <td>4.7</td>\n",
       "      <td>NSC</td>\n",
       "      <td>Gorkha/Lamjung border</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>B.S:2076-6-9</td>\n",
       "      <td>Local:01:18</td>\n",
       "      <td>27.71</td>\n",
       "      <td>86.32</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NSC</td>\n",
       "      <td>Dolakha</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>B.S:2076-6-5</td>\n",
       "      <td>Local:22:01</td>\n",
       "      <td>28.25</td>\n",
       "      <td>84.49</td>\n",
       "      <td>4.4</td>\n",
       "      <td>NSC</td>\n",
       "      <td>Lamjung</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>B.S:2076-6-4</td>\n",
       "      <td>Local:06:19</td>\n",
       "      <td>28.15</td>\n",
       "      <td>84.61</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NSC</td>\n",
       "      <td>Gorkha</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>B.S:2076-5-31</td>\n",
       "      <td>Local:09:53</td>\n",
       "      <td>28.21</td>\n",
       "      <td>84.49</td>\n",
       "      <td>4.5</td>\n",
       "      <td>NSC</td>\n",
       "      <td>Lamjung</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>B.S:2076-5-30</td>\n",
       "      <td>Local:20:18</td>\n",
       "      <td>29.80</td>\n",
       "      <td>80.48</td>\n",
       "      <td>4.4</td>\n",
       "      <td>NSC/RSC</td>\n",
       "      <td>Darchula(Nepal-India Border)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>B.S:2076-5-29</td>\n",
       "      <td>Local:10:54</td>\n",
       "      <td>30.30</td>\n",
       "      <td>81.74</td>\n",
       "      <td>5.0</td>\n",
       "      <td>RSC/NSC</td>\n",
       "      <td>Humla</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>B.S:2076-5-5</td>\n",
       "      <td>Local:07:07</td>\n",
       "      <td>27.52</td>\n",
       "      <td>86.39</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NSC</td>\n",
       "      <td>Solukhumbu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>B.S:2076-4-29</td>\n",
       "      <td>Local:23:09</td>\n",
       "      <td>27.69</td>\n",
       "      <td>86.26</td>\n",
       "      <td>4.3</td>\n",
       "      <td>NSC</td>\n",
       "      <td>Dolakha</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>B.S:2076-4-24</td>\n",
       "      <td>Local:18:26</td>\n",
       "      <td>28.50</td>\n",
       "      <td>83.22</td>\n",
       "      <td>4.7</td>\n",
       "      <td>NSC</td>\n",
       "      <td>Myagdi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>B.S:2076-4-8</td>\n",
       "      <td>Local:17:58</td>\n",
       "      <td>27.80</td>\n",
       "      <td>86.15</td>\n",
       "      <td>4.2</td>\n",
       "      <td>NSC</td>\n",
       "      <td>Dolakha</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>B.S:2076-3-21</td>\n",
       "      <td>Local:16:15</td>\n",
       "      <td>27.67</td>\n",
       "      <td>85.42</td>\n",
       "      <td>4.6</td>\n",
       "      <td>NSC</td>\n",
       "      <td>Bhaktapur</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>B.S:2076-3-12</td>\n",
       "      <td>Local:22:21</td>\n",
       "      <td>27.95</td>\n",
       "      <td>84.80</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NSC</td>\n",
       "      <td>Dhading</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>B.S:2076-2-32</td>\n",
       "      <td>Local:21:32</td>\n",
       "      <td>28.95</td>\n",
       "      <td>81.98</td>\n",
       "      <td>4.5</td>\n",
       "      <td>NSC/RSC</td>\n",
       "      <td>Jajarkot</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>B.S:2076-2-31</td>\n",
       "      <td>Local:12:22</td>\n",
       "      <td>29.52</td>\n",
       "      <td>81.05</td>\n",
       "      <td>4.0</td>\n",
       "      <td>RSC/NSC</td>\n",
       "      <td>Bajhang</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>B.S:2076-2-16</td>\n",
       "      <td>Local:10:01</td>\n",
       "      <td>29.62</td>\n",
       "      <td>82.11</td>\n",
       "      <td>4.6</td>\n",
       "      <td>RSC/NSC</td>\n",
       "      <td>Mugu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>B.S:2076-2-11</td>\n",
       "      <td>Local:21:08</td>\n",
       "      <td>29.50</td>\n",
       "      <td>81.28</td>\n",
       "      <td>4.3</td>\n",
       "      <td>RSC/NSC</td>\n",
       "      <td>Bajhang</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>B.S:2076-2-11</td>\n",
       "      <td>Local:11:02</td>\n",
       "      <td>27.70</td>\n",
       "      <td>86.47</td>\n",
       "      <td>4.9</td>\n",
       "      <td>NSC</td>\n",
       "      <td>Ramechhap</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>B.S:2076-2-7</td>\n",
       "      <td>Local:23:47</td>\n",
       "      <td>28.21</td>\n",
       "      <td>84.37</td>\n",
       "      <td>4.1</td>\n",
       "      <td>NSC</td>\n",
       "      <td>Lamjung</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>B.S:2076-2-3</td>\n",
       "      <td>Local:14:08</td>\n",
       "      <td>27.85</td>\n",
       "      <td>84.87</td>\n",
       "      <td>5.0</td>\n",
       "      <td>NSC</td>\n",
       "      <td>Dhading</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>B.S:2076-1-29</td>\n",
       "      <td>Local:00:36</td>\n",
       "      <td>28.98</td>\n",
       "      <td>81.78</td>\n",
       "      <td>5.1</td>\n",
       "      <td>RSC/NSC</td>\n",
       "      <td>Dailekh</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>B.S:2076-1-21</td>\n",
       "      <td>Local:08:37</td>\n",
       "      <td>27.94</td>\n",
       "      <td>85.72</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NSC</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>B.S:2076-1-16</td>\n",
       "      <td>Local:11:35</td>\n",
       "      <td>27.93</td>\n",
       "      <td>85.94</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NSC</td>\n",
       "      <td>Sindhupalchowk</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>B.S:2076-1-11</td>\n",
       "      <td>Local:06:40</td>\n",
       "      <td>27.70</td>\n",
       "      <td>85.14</td>\n",
       "      <td>4.3</td>\n",
       "      <td>NSC</td>\n",
       "      <td>Dhading</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>B.S:2076-1-11</td>\n",
       "      <td>Local:06:29</td>\n",
       "      <td>27.69</td>\n",
       "      <td>85.17</td>\n",
       "      <td>5.2</td>\n",
       "      <td>NSC</td>\n",
       "      <td>Dhading</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>B.S:2076-1-3</td>\n",
       "      <td>Local:12:35</td>\n",
       "      <td>28.00</td>\n",
       "      <td>84.76</td>\n",
       "      <td>4.5</td>\n",
       "      <td>NSC</td>\n",
       "      <td>Gorkha</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>B.S:2076-1-2</td>\n",
       "      <td>Local:04:27</td>\n",
       "      <td>29.49</td>\n",
       "      <td>81.24</td>\n",
       "      <td>4.8</td>\n",
       "      <td>RSC/NSC</td>\n",
       "      <td>Bajhang</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>B.S:2075-12-30</td>\n",
       "      <td>Local:10:25</td>\n",
       "      <td>28.03</td>\n",
       "      <td>85.38</td>\n",
       "      <td>4.6</td>\n",
       "      <td>NSC</td>\n",
       "      <td>Rasuwa</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>B.S:2075-12-26</td>\n",
       "      <td>Local:13:05</td>\n",
       "      <td>27.76</td>\n",
       "      <td>86.27</td>\n",
       "      <td>4.2</td>\n",
       "      <td>NSC</td>\n",
       "      <td>Dolakha</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>B.S:2075-12-18</td>\n",
       "      <td>Local:20:47</td>\n",
       "      <td>28.98</td>\n",
       "      <td>81.69</td>\n",
       "      <td>4.1</td>\n",
       "      <td>RSC/NSC</td>\n",
       "      <td>Dailekh</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>B.S:2075-12-4</td>\n",
       "      <td>Local:09:01</td>\n",
       "      <td>27.63</td>\n",
       "      <td>85.16</td>\n",
       "      <td>4.1</td>\n",
       "      <td>NSC</td>\n",
       "      <td>Makawanpur</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>B.S:2075-11-14</td>\n",
       "      <td>Local:16:15</td>\n",
       "      <td>27.66</td>\n",
       "      <td>86.00</td>\n",
       "      <td>4.4</td>\n",
       "      <td>NSC</td>\n",
       "      <td>Dolakha</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>B.S:2075-11-14</td>\n",
       "      <td>Local:16:20</td>\n",
       "      <td>27.84</td>\n",
       "      <td>85.95</td>\n",
       "      <td>4.1</td>\n",
       "      <td>NSC</td>\n",
       "      <td>Sindhupalchok</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>B.S:2075-11-4</td>\n",
       "      <td>Local:20:34</td>\n",
       "      <td>27.68</td>\n",
       "      <td>85.27</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NSC</td>\n",
       "      <td>Kathmandu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>B.S:2075-11-2</td>\n",
       "      <td>Local:17:11</td>\n",
       "      <td>27.81</td>\n",
       "      <td>88.18</td>\n",
       "      <td>4.6</td>\n",
       "      <td>NSC</td>\n",
       "      <td>Taplejung</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>B.S:2075-10-8</td>\n",
       "      <td>Local:22:30</td>\n",
       "      <td>27.09</td>\n",
       "      <td>86.96</td>\n",
       "      <td>4.5</td>\n",
       "      <td>NSC</td>\n",
       "      <td>Bhojpur</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>B.S:2075-9-26</td>\n",
       "      <td>Local:11:34</td>\n",
       "      <td>27.60</td>\n",
       "      <td>86.31</td>\n",
       "      <td>4.5</td>\n",
       "      <td>NSC</td>\n",
       "      <td>Ramechhap</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              Date         Time  Latitude  Longitude  Magnitude(ML)  Remarks  \\\n",
       "0    B.S:2076-8-26  Local:19:11     27.95      85.59            4.8      NSC   \n",
       "1    B.S:2076-8-11  Local:22:08     27.79      85.79            5.0      NSC   \n",
       "2     B.S:2076-8-3  Local:19:15     29.42      81.10            5.7  NSC/RSC   \n",
       "3    B.S:2076-7-26  Local:07:45     30.20      80.10            4.6  NSC/RSC   \n",
       "4    B.S:2076-7-15  Local:03:51     28.45      83.23            4.5      NSC   \n",
       "5    B.S:2076-7-11  Local:19:27     29.66      82.04            4.1  NSC/RSC   \n",
       "6     B.S:2076-7-5  Local:11:06     26.88      86.59            4.1      NSC   \n",
       "7     B.S:2076-7-4  Local:01:09     27.82      87.98            4.2      NSC   \n",
       "8    B.S:2076-6-12  Local:07:27     28.66      83.06            4.4      NSC   \n",
       "9    B.S:2076-6-11  Local:10:43     30.00      81.45            4.3  RSC/NSC   \n",
       "10    B.S:2076-6-9  Local:18:49     28.28      84.65            4.7      NSC   \n",
       "11    B.S:2076-6-9  Local:01:18     27.71      86.32            4.0      NSC   \n",
       "12    B.S:2076-6-5  Local:22:01     28.25      84.49            4.4      NSC   \n",
       "13    B.S:2076-6-4  Local:06:19     28.15      84.61            4.0      NSC   \n",
       "14   B.S:2076-5-31  Local:09:53     28.21      84.49            4.5      NSC   \n",
       "15   B.S:2076-5-30  Local:20:18     29.80      80.48            4.4  NSC/RSC   \n",
       "16   B.S:2076-5-29  Local:10:54     30.30      81.74            5.0  RSC/NSC   \n",
       "17    B.S:2076-5-5  Local:07:07     27.52      86.39            4.0      NSC   \n",
       "18   B.S:2076-4-29  Local:23:09     27.69      86.26            4.3      NSC   \n",
       "19   B.S:2076-4-24  Local:18:26     28.50      83.22            4.7      NSC   \n",
       "20    B.S:2076-4-8  Local:17:58     27.80      86.15            4.2      NSC   \n",
       "21   B.S:2076-3-21  Local:16:15     27.67      85.42            4.6      NSC   \n",
       "22   B.S:2076-3-12  Local:22:21     27.95      84.80            4.0      NSC   \n",
       "23   B.S:2076-2-32  Local:21:32     28.95      81.98            4.5  NSC/RSC   \n",
       "24   B.S:2076-2-31  Local:12:22     29.52      81.05            4.0  RSC/NSC   \n",
       "25   B.S:2076-2-16  Local:10:01     29.62      82.11            4.6  RSC/NSC   \n",
       "26   B.S:2076-2-11  Local:21:08     29.50      81.28            4.3  RSC/NSC   \n",
       "27   B.S:2076-2-11  Local:11:02     27.70      86.47            4.9      NSC   \n",
       "28    B.S:2076-2-7  Local:23:47     28.21      84.37            4.1      NSC   \n",
       "29    B.S:2076-2-3  Local:14:08     27.85      84.87            5.0      NSC   \n",
       "30   B.S:2076-1-29  Local:00:36     28.98      81.78            5.1  RSC/NSC   \n",
       "31   B.S:2076-1-21  Local:08:37     27.94      85.72            4.0      NSC   \n",
       "32   B.S:2076-1-16  Local:11:35     27.93      85.94            4.0      NSC   \n",
       "33   B.S:2076-1-11  Local:06:40     27.70      85.14            4.3      NSC   \n",
       "34   B.S:2076-1-11  Local:06:29     27.69      85.17            5.2      NSC   \n",
       "35    B.S:2076-1-3  Local:12:35     28.00      84.76            4.5      NSC   \n",
       "36    B.S:2076-1-2  Local:04:27     29.49      81.24            4.8  RSC/NSC   \n",
       "37  B.S:2075-12-30  Local:10:25     28.03      85.38            4.6      NSC   \n",
       "38  B.S:2075-12-26  Local:13:05     27.76      86.27            4.2      NSC   \n",
       "39  B.S:2075-12-18  Local:20:47     28.98      81.69            4.1  RSC/NSC   \n",
       "40   B.S:2075-12-4  Local:09:01     27.63      85.16            4.1      NSC   \n",
       "41  B.S:2075-11-14  Local:16:15     27.66      86.00            4.4      NSC   \n",
       "42  B.S:2075-11-14  Local:16:20     27.84      85.95            4.1      NSC   \n",
       "43   B.S:2075-11-4  Local:20:34     27.68      85.27            4.0      NSC   \n",
       "44   B.S:2075-11-2  Local:17:11     27.81      88.18            4.6      NSC   \n",
       "45   B.S:2075-10-8  Local:22:30     27.09      86.96            4.5      NSC   \n",
       "46   B.S:2075-9-26  Local:11:34     27.60      86.31            4.5      NSC   \n",
       "\n",
       "                       Epicenter  \n",
       "0                 Sindhupalchowk  \n",
       "1                 Sindhupalchowk  \n",
       "2                        Bajhang  \n",
       "3                          India  \n",
       "4                        Baglung  \n",
       "5                           Mugu  \n",
       "6                       Udayapur  \n",
       "7                      Taplejung  \n",
       "8           Rukum/Baglung border  \n",
       "9           Bajhang/Humla border  \n",
       "10         Gorkha/Lamjung border  \n",
       "11                       Dolakha  \n",
       "12                       Lamjung  \n",
       "13                        Gorkha  \n",
       "14                       Lamjung  \n",
       "15  Darchula(Nepal-India Border)  \n",
       "16                         Humla  \n",
       "17                    Solukhumbu  \n",
       "18                       Dolakha  \n",
       "19                        Myagdi  \n",
       "20                       Dolakha  \n",
       "21                     Bhaktapur  \n",
       "22                       Dhading  \n",
       "23                      Jajarkot  \n",
       "24                       Bajhang  \n",
       "25                          Mugu  \n",
       "26                       Bajhang  \n",
       "27                     Ramechhap  \n",
       "28                       Lamjung  \n",
       "29                       Dhading  \n",
       "30                       Dailekh  \n",
       "31                Sindhupalchowk  \n",
       "32                Sindhupalchowk  \n",
       "33                       Dhading  \n",
       "34                       Dhading  \n",
       "35                        Gorkha  \n",
       "36                       Bajhang  \n",
       "37                        Rasuwa  \n",
       "38                       Dolakha  \n",
       "39                       Dailekh  \n",
       "40                    Makawanpur  \n",
       "41                       Dolakha  \n",
       "42                 Sindhupalchok  \n",
       "43                     Kathmandu  \n",
       "44                     Taplejung  \n",
       "45                       Bhojpur  \n",
       "46                     Ramechhap  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import csv\n",
    "import pandas as pd\n",
    "with open(\"carlos.csv\",\"w+\") as f:\n",
    "    x=csv.writer(f)\n",
    "    x.writerows(list2)\n",
    "df=pd.read_csv(\"carlos.csv\")\n",
    "df\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[[2, 3, 4], [5, 7], [7, 9, 0], [45, 8, 2]]\n"
     ]
    }
   ],
   "source": [
    "x=[[2,3,4],[5,6,7],[7,8,9,0],[45,7,8,2]]\n",
    "for i in range(len(x)-1):\n",
    "    del x[i+1][1]\n",
    "print(x)"
   ]
  },
  {
   "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
}