Chapter02/Exercise2.01/Exercise_2_01.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import json\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "import missingno as msno\n",
    "from sklearn.impute import SimpleImputer\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "scrolled": false
   },
   "outputs": [],
   "source": [
    "with open('..\\dtypes.json', 'r') as jsonfile:\n",
    "    dtyp = json.load(jsonfile)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'id': 'float',\n",
       " 'flag_tsunami': 'str',\n",
       " 'year': 'float',\n",
       " 'month': 'float',\n",
       " 'day': 'float',\n",
       " 'hour': 'float',\n",
       " 'minute': 'float',\n",
       " 'second': 'float',\n",
       " 'focal_depth': 'float',\n",
       " 'eq_primary': 'float',\n",
       " 'eq_mag_mw': 'float',\n",
       " 'eq_mag_ms': 'float',\n",
       " 'eq_mag_mb': 'float',\n",
       " 'intensity': 'float',\n",
       " 'country': 'str',\n",
       " 'state': 'str',\n",
       " 'location_name': 'str',\n",
       " 'latitude': 'float',\n",
       " 'longitude': 'float',\n",
       " 'region_code': 'str',\n",
       " 'injuries': 'float',\n",
       " 'injuries_description': 'str',\n",
       " 'damage_millions_dollars': 'float',\n",
       " 'damage_description': 'str',\n",
       " 'total_injuries': 'float',\n",
       " 'total_injuries_description': 'str',\n",
       " 'total_damage_millions_dollars': 'float',\n",
       " 'total_damage_description': 'str'}"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dtyp"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "data = pd.read_csv('..\\Datasets\\earthquake_data.csv', dtype = dtyp)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 6072 entries, 0 to 6071\n",
      "Data columns (total 28 columns):\n",
      "id                               6072 non-null float64\n",
      "flag_tsunami                     6072 non-null object\n",
      "year                             6072 non-null float64\n",
      "month                            5667 non-null float64\n",
      "day                              5515 non-null float64\n",
      "hour                             4044 non-null float64\n",
      "minute                           3838 non-null float64\n",
      "second                           2721 non-null float64\n",
      "focal_depth                      3120 non-null float64\n",
      "eq_primary                       4286 non-null float64\n",
      "eq_mag_mw                        1216 non-null float64\n",
      "eq_mag_ms                        2916 non-null float64\n",
      "eq_mag_mb                        1786 non-null float64\n",
      "intensity                        2748 non-null float64\n",
      "country                          6072 non-null object\n",
      "state                            308 non-null object\n",
      "location_name                    6071 non-null object\n",
      "latitude                         6018 non-null float64\n",
      "longitude                        6022 non-null float64\n",
      "region_code                      6072 non-null object\n",
      "injuries                         1169 non-null float64\n",
      "injuries_description             1349 non-null object\n",
      "damage_millions_dollars          478 non-null float64\n",
      "damage_description               4327 non-null object\n",
      "total_injuries                   1184 non-null float64\n",
      "total_injuries_description       1357 non-null object\n",
      "total_damage_millions_dollars    418 non-null float64\n",
      "total_damage_description         3148 non-null object\n",
      "dtypes: float64(19), object(9)\n",
      "memory usage: 1.3+ MB\n"
     ]
    }
   ],
   "source": [
    "data.info()"
   ]
  },
  {
   "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>id</th>\n",
       "      <th>flag_tsunami</th>\n",
       "      <th>year</th>\n",
       "      <th>month</th>\n",
       "      <th>day</th>\n",
       "      <th>hour</th>\n",
       "      <th>minute</th>\n",
       "      <th>second</th>\n",
       "      <th>focal_depth</th>\n",
       "      <th>eq_primary</th>\n",
       "      <th>...</th>\n",
       "      <th>longitude</th>\n",
       "      <th>region_code</th>\n",
       "      <th>injuries</th>\n",
       "      <th>injuries_description</th>\n",
       "      <th>damage_millions_dollars</th>\n",
       "      <th>damage_description</th>\n",
       "      <th>total_injuries</th>\n",
       "      <th>total_injuries_description</th>\n",
       "      <th>total_damage_millions_dollars</th>\n",
       "      <th>total_damage_description</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>338.0</td>\n",
       "      <td>No</td>\n",
       "      <td>1048.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>120</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>771.0</td>\n",
       "      <td>Tsu</td>\n",
       "      <td>1580.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>33.0</td>\n",
       "      <td>6.2</td>\n",
       "      <td>...</td>\n",
       "      <td>1.309</td>\n",
       "      <td>120</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>7889.0</td>\n",
       "      <td>Tsu</td>\n",
       "      <td>1757.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>-6.320</td>\n",
       "      <td>120</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>6697.0</td>\n",
       "      <td>Tsu</td>\n",
       "      <td>1500.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>150</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>6013.0</td>\n",
       "      <td>Tsu</td>\n",
       "      <td>1668.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>-71.050</td>\n",
       "      <td>150</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 28 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       id flag_tsunami    year  month   day  hour  minute  second  \\\n",
       "0   338.0           No  1048.0    NaN   NaN   NaN     NaN     NaN   \n",
       "1   771.0          Tsu  1580.0    4.0   6.0   NaN     NaN     NaN   \n",
       "2  7889.0          Tsu  1757.0    7.0  15.0   NaN     NaN     NaN   \n",
       "3  6697.0          Tsu  1500.0    NaN   NaN   NaN     NaN     NaN   \n",
       "4  6013.0          Tsu  1668.0    4.0  13.0   NaN     NaN     NaN   \n",
       "\n",
       "   focal_depth  eq_primary  ...  longitude  region_code  injuries  \\\n",
       "0          NaN         NaN  ...        NaN          120       NaN   \n",
       "1         33.0         6.2  ...      1.309          120       NaN   \n",
       "2          NaN         NaN  ...     -6.320          120       NaN   \n",
       "3          NaN         NaN  ...        NaN          150       NaN   \n",
       "4          NaN         NaN  ...    -71.050          150       NaN   \n",
       "\n",
       "   injuries_description damage_millions_dollars damage_description  \\\n",
       "0                   NaN                     NaN                NaN   \n",
       "1                   NaN                     NaN                  2   \n",
       "2                   NaN                     NaN                NaN   \n",
       "3                   NaN                     NaN                NaN   \n",
       "4                   NaN                     NaN                NaN   \n",
       "\n",
       "  total_injuries  total_injuries_description  total_damage_millions_dollars  \\\n",
       "0            NaN                         NaN                            NaN   \n",
       "1            NaN                         NaN                            NaN   \n",
       "2            NaN                         NaN                            NaN   \n",
       "3            NaN                         NaN                            NaN   \n",
       "4            NaN                         NaN                            NaN   \n",
       "\n",
       "  total_damage_description  \n",
       "0                      NaN  \n",
       "1                      NaN  \n",
       "2                      NaN  \n",
       "3                      NaN  \n",
       "4                      NaN  \n",
       "\n",
       "[5 rows x 28 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.head()"
   ]
  },
  {
   "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>id</th>\n",
       "      <th>flag_tsunami</th>\n",
       "      <th>year</th>\n",
       "      <th>month</th>\n",
       "      <th>day</th>\n",
       "      <th>hour</th>\n",
       "      <th>minute</th>\n",
       "      <th>second</th>\n",
       "      <th>focal_depth</th>\n",
       "      <th>eq_primary</th>\n",
       "      <th>...</th>\n",
       "      <th>longitude</th>\n",
       "      <th>region_code</th>\n",
       "      <th>injuries</th>\n",
       "      <th>injuries_description</th>\n",
       "      <th>damage_millions_dollars</th>\n",
       "      <th>damage_description</th>\n",
       "      <th>total_injuries</th>\n",
       "      <th>total_injuries_description</th>\n",
       "      <th>total_damage_millions_dollars</th>\n",
       "      <th>total_damage_description</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>6067</th>\n",
       "      <td>5360.0</td>\n",
       "      <td>Tsu</td>\n",
       "      <td>1993.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>24.9</td>\n",
       "      <td>59.0</td>\n",
       "      <td>7.8</td>\n",
       "      <td>...</td>\n",
       "      <td>144.801</td>\n",
       "      <td>170</td>\n",
       "      <td>48.0</td>\n",
       "      <td>1</td>\n",
       "      <td>250.0</td>\n",
       "      <td>4</td>\n",
       "      <td>48.0</td>\n",
       "      <td>1</td>\n",
       "      <td>250.0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6068</th>\n",
       "      <td>5009.0</td>\n",
       "      <td>No</td>\n",
       "      <td>1983.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.4</td>\n",
       "      <td>26.0</td>\n",
       "      <td>6.4</td>\n",
       "      <td>...</td>\n",
       "      <td>151.868</td>\n",
       "      <td>170</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>25.0</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>25.0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6069</th>\n",
       "      <td>10307.0</td>\n",
       "      <td>No</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>44.0</td>\n",
       "      <td>43.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>7.5</td>\n",
       "      <td>...</td>\n",
       "      <td>142.768</td>\n",
       "      <td>170</td>\n",
       "      <td>300.0</td>\n",
       "      <td>3</td>\n",
       "      <td>61.0</td>\n",
       "      <td>4</td>\n",
       "      <td>300.0</td>\n",
       "      <td>3</td>\n",
       "      <td>61.0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6070</th>\n",
       "      <td>5498.0</td>\n",
       "      <td>No</td>\n",
       "      <td>1998.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>7.3</td>\n",
       "      <td>10.0</td>\n",
       "      <td>6.2</td>\n",
       "      <td>...</td>\n",
       "      <td>-28.626</td>\n",
       "      <td>130</td>\n",
       "      <td>100.0</td>\n",
       "      <td>2</td>\n",
       "      <td>72.0</td>\n",
       "      <td>4</td>\n",
       "      <td>100.0</td>\n",
       "      <td>2</td>\n",
       "      <td>72.0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6071</th>\n",
       "      <td>5459.0</td>\n",
       "      <td>No</td>\n",
       "      <td>1997.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>23.2</td>\n",
       "      <td>5.0</td>\n",
       "      <td>6.7</td>\n",
       "      <td>...</td>\n",
       "      <td>-60.892</td>\n",
       "      <td>90</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1</td>\n",
       "      <td>25.0</td>\n",
       "      <td>4</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1</td>\n",
       "      <td>25.0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 28 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           id flag_tsunami    year  month   day  hour  minute  second  \\\n",
       "6067   5360.0          Tsu  1993.0    8.0   8.0   8.0    34.0    24.9   \n",
       "6068   5009.0           No  1983.0   12.0  22.0   1.0     2.0     2.4   \n",
       "6069  10307.0           No  2018.0    2.0  25.0  17.0    44.0    43.0   \n",
       "6070   5498.0           No  1998.0    7.0   9.0   5.0    19.0     7.3   \n",
       "6071   5459.0           No  1997.0    4.0  22.0   9.0    31.0    23.2   \n",
       "\n",
       "      focal_depth  eq_primary  ...  longitude  region_code  injuries  \\\n",
       "6067         59.0         7.8  ...    144.801          170      48.0   \n",
       "6068         26.0         6.4  ...    151.868          170       NaN   \n",
       "6069         23.0         7.5  ...    142.768          170     300.0   \n",
       "6070         10.0         6.2  ...    -28.626          130     100.0   \n",
       "6071          5.0         6.7  ...    -60.892           90       2.0   \n",
       "\n",
       "      injuries_description damage_millions_dollars damage_description  \\\n",
       "6067                     1                   250.0                  4   \n",
       "6068                   NaN                    25.0                  4   \n",
       "6069                     3                    61.0                  4   \n",
       "6070                     2                    72.0                  4   \n",
       "6071                     1                    25.0                  4   \n",
       "\n",
       "     total_injuries  total_injuries_description  \\\n",
       "6067           48.0                           1   \n",
       "6068            NaN                         NaN   \n",
       "6069          300.0                           3   \n",
       "6070          100.0                           2   \n",
       "6071            2.0                           1   \n",
       "\n",
       "      total_damage_millions_dollars total_damage_description  \n",
       "6067                          250.0                        4  \n",
       "6068                           25.0                        4  \n",
       "6069                           61.0                        4  \n",
       "6070                           72.0                        4  \n",
       "6071                           25.0                        4  \n",
       "\n",
       "[5 rows x 28 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "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>count</th>\n",
       "      <th>mean</th>\n",
       "      <th>std</th>\n",
       "      <th>min</th>\n",
       "      <th>25%</th>\n",
       "      <th>50%</th>\n",
       "      <th>75%</th>\n",
       "      <th>max</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>id</th>\n",
       "      <td>6072.0</td>\n",
       "      <td>4658.426219</td>\n",
       "      <td>2924.650010</td>\n",
       "      <td>1.000</td>\n",
       "      <td>2142.75000</td>\n",
       "      <td>4608.5</td>\n",
       "      <td>6475.25000</td>\n",
       "      <td>10378.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>year</th>\n",
       "      <td>6072.0</td>\n",
       "      <td>1802.307477</td>\n",
       "      <td>377.924931</td>\n",
       "      <td>-2150.000</td>\n",
       "      <td>1818.00000</td>\n",
       "      <td>1927.0</td>\n",
       "      <td>1986.00000</td>\n",
       "      <td>2018.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>month</th>\n",
       "      <td>5667.0</td>\n",
       "      <td>6.510852</td>\n",
       "      <td>3.450167</td>\n",
       "      <td>1.000</td>\n",
       "      <td>4.00000</td>\n",
       "      <td>7.0</td>\n",
       "      <td>9.00000</td>\n",
       "      <td>12.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>day</th>\n",
       "      <td>5515.0</td>\n",
       "      <td>15.734361</td>\n",
       "      <td>8.752862</td>\n",
       "      <td>1.000</td>\n",
       "      <td>8.00000</td>\n",
       "      <td>16.0</td>\n",
       "      <td>23.00000</td>\n",
       "      <td>31.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>hour</th>\n",
       "      <td>4044.0</td>\n",
       "      <td>11.308605</td>\n",
       "      <td>7.033485</td>\n",
       "      <td>0.000</td>\n",
       "      <td>5.00000</td>\n",
       "      <td>11.0</td>\n",
       "      <td>17.00000</td>\n",
       "      <td>23.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>minute</th>\n",
       "      <td>3838.0</td>\n",
       "      <td>28.855915</td>\n",
       "      <td>17.151545</td>\n",
       "      <td>0.000</td>\n",
       "      <td>14.00000</td>\n",
       "      <td>30.0</td>\n",
       "      <td>44.00000</td>\n",
       "      <td>59.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>second</th>\n",
       "      <td>2721.0</td>\n",
       "      <td>29.740243</td>\n",
       "      <td>17.132196</td>\n",
       "      <td>0.100</td>\n",
       "      <td>14.80000</td>\n",
       "      <td>29.7</td>\n",
       "      <td>44.50000</td>\n",
       "      <td>59.900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>focal_depth</th>\n",
       "      <td>3120.0</td>\n",
       "      <td>41.680769</td>\n",
       "      <td>71.258782</td>\n",
       "      <td>0.000</td>\n",
       "      <td>11.00000</td>\n",
       "      <td>26.0</td>\n",
       "      <td>40.00000</td>\n",
       "      <td>675.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>eq_primary</th>\n",
       "      <td>4286.0</td>\n",
       "      <td>6.471419</td>\n",
       "      <td>1.043968</td>\n",
       "      <td>1.600</td>\n",
       "      <td>5.70000</td>\n",
       "      <td>6.5</td>\n",
       "      <td>7.30000</td>\n",
       "      <td>9.500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>eq_mag_mw</th>\n",
       "      <td>1216.0</td>\n",
       "      <td>6.526562</td>\n",
       "      <td>0.937869</td>\n",
       "      <td>3.600</td>\n",
       "      <td>5.80000</td>\n",
       "      <td>6.5</td>\n",
       "      <td>7.20000</td>\n",
       "      <td>9.500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>eq_mag_ms</th>\n",
       "      <td>2916.0</td>\n",
       "      <td>6.574451</td>\n",
       "      <td>0.989850</td>\n",
       "      <td>2.100</td>\n",
       "      <td>5.80000</td>\n",
       "      <td>6.6</td>\n",
       "      <td>7.30000</td>\n",
       "      <td>9.100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>eq_mag_mb</th>\n",
       "      <td>1786.0</td>\n",
       "      <td>5.797592</td>\n",
       "      <td>0.716809</td>\n",
       "      <td>2.100</td>\n",
       "      <td>5.30000</td>\n",
       "      <td>5.8</td>\n",
       "      <td>6.30000</td>\n",
       "      <td>8.200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>intensity</th>\n",
       "      <td>2748.0</td>\n",
       "      <td>8.325328</td>\n",
       "      <td>1.800089</td>\n",
       "      <td>2.000</td>\n",
       "      <td>7.00000</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.00000</td>\n",
       "      <td>12.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>latitude</th>\n",
       "      <td>6018.0</td>\n",
       "      <td>22.537909</td>\n",
       "      <td>22.787934</td>\n",
       "      <td>-62.877</td>\n",
       "      <td>9.87175</td>\n",
       "      <td>32.2</td>\n",
       "      <td>38.77825</td>\n",
       "      <td>73.122</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>longitude</th>\n",
       "      <td>6022.0</td>\n",
       "      <td>37.985633</td>\n",
       "      <td>86.726852</td>\n",
       "      <td>-179.984</td>\n",
       "      <td>-8.00000</td>\n",
       "      <td>43.3</td>\n",
       "      <td>115.50000</td>\n",
       "      <td>180.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>injuries</th>\n",
       "      <td>1169.0</td>\n",
       "      <td>2293.579127</td>\n",
       "      <td>27095.202227</td>\n",
       "      <td>1.000</td>\n",
       "      <td>10.00000</td>\n",
       "      <td>42.0</td>\n",
       "      <td>200.00000</td>\n",
       "      <td>799000.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>damage_millions_dollars</th>\n",
       "      <td>478.0</td>\n",
       "      <td>1715.606259</td>\n",
       "      <td>12157.409978</td>\n",
       "      <td>0.013</td>\n",
       "      <td>3.62500</td>\n",
       "      <td>20.9</td>\n",
       "      <td>204.35000</td>\n",
       "      <td>220000.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>total_injuries</th>\n",
       "      <td>1184.0</td>\n",
       "      <td>2510.967061</td>\n",
       "      <td>28273.298405</td>\n",
       "      <td>1.000</td>\n",
       "      <td>10.00000</td>\n",
       "      <td>42.5</td>\n",
       "      <td>200.00000</td>\n",
       "      <td>799000.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>total_damage_millions_dollars</th>\n",
       "      <td>418.0</td>\n",
       "      <td>1978.743206</td>\n",
       "      <td>12988.187606</td>\n",
       "      <td>0.010</td>\n",
       "      <td>4.31000</td>\n",
       "      <td>28.0</td>\n",
       "      <td>300.00000</td>\n",
       "      <td>220085.456</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                count         mean           std       min  \\\n",
       "id                             6072.0  4658.426219   2924.650010     1.000   \n",
       "year                           6072.0  1802.307477    377.924931 -2150.000   \n",
       "month                          5667.0     6.510852      3.450167     1.000   \n",
       "day                            5515.0    15.734361      8.752862     1.000   \n",
       "hour                           4044.0    11.308605      7.033485     0.000   \n",
       "minute                         3838.0    28.855915     17.151545     0.000   \n",
       "second                         2721.0    29.740243     17.132196     0.100   \n",
       "focal_depth                    3120.0    41.680769     71.258782     0.000   \n",
       "eq_primary                     4286.0     6.471419      1.043968     1.600   \n",
       "eq_mag_mw                      1216.0     6.526562      0.937869     3.600   \n",
       "eq_mag_ms                      2916.0     6.574451      0.989850     2.100   \n",
       "eq_mag_mb                      1786.0     5.797592      0.716809     2.100   \n",
       "intensity                      2748.0     8.325328      1.800089     2.000   \n",
       "latitude                       6018.0    22.537909     22.787934   -62.877   \n",
       "longitude                      6022.0    37.985633     86.726852  -179.984   \n",
       "injuries                       1169.0  2293.579127  27095.202227     1.000   \n",
       "damage_millions_dollars         478.0  1715.606259  12157.409978     0.013   \n",
       "total_injuries                 1184.0  2510.967061  28273.298405     1.000   \n",
       "total_damage_millions_dollars   418.0  1978.743206  12988.187606     0.010   \n",
       "\n",
       "                                      25%     50%         75%         max  \n",
       "id                             2142.75000  4608.5  6475.25000   10378.000  \n",
       "year                           1818.00000  1927.0  1986.00000    2018.000  \n",
       "month                             4.00000     7.0     9.00000      12.000  \n",
       "day                               8.00000    16.0    23.00000      31.000  \n",
       "hour                              5.00000    11.0    17.00000      23.000  \n",
       "minute                           14.00000    30.0    44.00000      59.000  \n",
       "second                           14.80000    29.7    44.50000      59.900  \n",
       "focal_depth                      11.00000    26.0    40.00000     675.000  \n",
       "eq_primary                        5.70000     6.5     7.30000       9.500  \n",
       "eq_mag_mw                         5.80000     6.5     7.20000       9.500  \n",
       "eq_mag_ms                         5.80000     6.6     7.30000       9.100  \n",
       "eq_mag_mb                         5.30000     5.8     6.30000       8.200  \n",
       "intensity                         7.00000     8.0    10.00000      12.000  \n",
       "latitude                          9.87175    32.2    38.77825      73.122  \n",
       "longitude                        -8.00000    43.3   115.50000     180.000  \n",
       "injuries                         10.00000    42.0   200.00000  799000.000  \n",
       "damage_millions_dollars           3.62500    20.9   204.35000  220000.000  \n",
       "total_injuries                   10.00000    42.5   200.00000  799000.000  \n",
       "total_damage_millions_dollars     4.31000    28.0   300.00000  220085.456  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.describe().T"
   ]
  },
  {
   "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.7.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}