reformat-eq-catalog.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Goal is to write a new CSV file with columns:\n",
    "# id,latitude,longitude,time,magnitude\n",
    "import xarray as xr\n",
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt\n",
    "import numpy as np\n",
    "from global_land_mask import globe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Load datasets\n",
    "earthquake_catalog = pd.read_csv('eq_200204_202102.csv')\n",
    "earthquake_catalog[\"time\"] = earthquake_catalog[\"time\"].astype(\"datetime64\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    "earthquake_catalog_mini = earthquake_catalog.drop(columns=['depth', 'magType','nst','gap','dmin','net','horizontalError',\n",
    "                                                     'updated','rms','place','type','depthError','magError','status',\n",
    "                                                     'locationSource','magSource','magNst','id'])\n",
    "earthquake_catalog_mini = earthquake_catalog_mini[['latitude', 'longitude', 'time', 'mag']]\n",
    "earthquake_catalog_mini = earthquake_catalog_mini.rename(columns={\"mag\": \"magnitude\"})\n",
    "earthquake_catalog_mini.to_csv (r'eq_200204_202102_mini.csv', index = True, header=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "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>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th>time</th>\n",
       "      <th>magnitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>-23.1842</td>\n",
       "      <td>171.7786</td>\n",
       "      <td>2021-02-17 22:49:38.110</td>\n",
       "      <td>6.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>30.8390</td>\n",
       "      <td>51.3651</td>\n",
       "      <td>2021-02-17 18:35:35.180</td>\n",
       "      <td>5.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>-17.4717</td>\n",
       "      <td>167.6675</td>\n",
       "      <td>2021-02-17 12:21:42.826</td>\n",
       "      <td>5.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>38.4057</td>\n",
       "      <td>22.0190</td>\n",
       "      <td>2021-02-17 03:36:07.058</td>\n",
       "      <td>5.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>-17.8133</td>\n",
       "      <td>167.6409</td>\n",
       "      <td>2021-02-16 01:32:00.512</td>\n",
       "      <td>5.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11922</th>\n",
       "      <td>-16.3820</td>\n",
       "      <td>173.2590</td>\n",
       "      <td>2002-04-20 15:59:57.860</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11923</th>\n",
       "      <td>17.2330</td>\n",
       "      <td>-101.2500</td>\n",
       "      <td>2002-04-18 17:57:27.700</td>\n",
       "      <td>5.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11924</th>\n",
       "      <td>-27.5350</td>\n",
       "      <td>-70.5860</td>\n",
       "      <td>2002-04-18 16:08:36.780</td>\n",
       "      <td>6.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11925</th>\n",
       "      <td>-60.6570</td>\n",
       "      <td>-25.8430</td>\n",
       "      <td>2002-04-18 14:17:23.940</td>\n",
       "      <td>5.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11926</th>\n",
       "      <td>16.9850</td>\n",
       "      <td>-100.8650</td>\n",
       "      <td>2002-04-18 05:02:46.190</td>\n",
       "      <td>6.8</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>11927 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       latitude  longitude                    time  magnitude\n",
       "0      -23.1842   171.7786 2021-02-17 22:49:38.110        6.1\n",
       "1       30.8390    51.3651 2021-02-17 18:35:35.180        5.4\n",
       "2      -17.4717   167.6675 2021-02-17 12:21:42.826        5.5\n",
       "3       38.4057    22.0190 2021-02-17 03:36:07.058        5.5\n",
       "4      -17.8133   167.6409 2021-02-16 01:32:00.512        5.9\n",
       "...         ...        ...                     ...        ...\n",
       "11922  -16.3820   173.2590 2002-04-20 15:59:57.860        6.0\n",
       "11923   17.2330  -101.2500 2002-04-18 17:57:27.700        5.9\n",
       "11924  -27.5350   -70.5860 2002-04-18 16:08:36.780        6.7\n",
       "11925  -60.6570   -25.8430 2002-04-18 14:17:23.940        5.8\n",
       "11926   16.9850  -100.8650 2002-04-18 05:02:46.190        6.8\n",
       "\n",
       "[11927 rows x 4 columns]"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "earthquake_catalog_mini"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}