{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# Events to DataFrame\n", "ObsPlus provides a way to extract useful summary information from ObsPy objects in order to create dataframes. This transformation is lossy but very useful when the full complexity of the `Catalog` object isn't warranted. By default the `events_to_df` function collects information the authors of ObsPlus have found useful, but it is fully extensible/customizable using the functionality of the [DataFrameExtractor](../utils/dataframeextractor.ipynb)." ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "To demonstrate how the `Catalog` can be flattened into a table, let's again use the Crandall catalog." ] }, { "cell_type": "code", "execution_count": 1, "metadata": { "execution": { "iopub.execute_input": "2024-02-28T22:20:15.805599Z", "iopub.status.busy": "2024-02-28T22:20:15.805424Z", "iopub.status.idle": "2024-02-28T22:20:17.904093Z", "shell.execute_reply": "2024-02-28T22:20:17.903568Z" } }, "outputs": [], "source": [ "import obspy\n", "import numpy as np\n", "from matplotlib import pyplot as plt\n", "from obspy.clients.fdsn import Client\n", "\n", "import obsplus" ] }, { "cell_type": "code", "execution_count": 2, "metadata": { "execution": { "iopub.execute_input": "2024-02-28T22:20:17.907084Z", "iopub.status.busy": "2024-02-28T22:20:17.906476Z", "iopub.status.idle": "2024-02-28T22:20:18.736812Z", "shell.execute_reply": "2024-02-28T22:20:18.736140Z" } }, "outputs": [ { "data": { "text/html": [ "
\n", " | time | \n", "latitude | \n", "longitude | \n", "depth | \n", "magnitude | \n", "event_description | \n", "associated_phase_count | \n", "azimuthal_gap | \n", "event_id | \n", "horizontal_uncertainty | \n", "... | \n", "standard_error | \n", "used_phase_count | \n", "station_count | \n", "vertical_uncertainty | \n", "updated | \n", "author | \n", "agency_id | \n", "creation_time | \n", "version | \n", "stations | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "2007-08-06 08:48:40.010 | \n", "39.4635 | \n", "-111.2277 | \n", "410.0 | \n", "4.37 | \n", "LR | \n", "0.0 | \n", "NaN | \n", "smi:local/248839 | \n", "NaN | \n", "... | \n", "1.7356 | \n", "0.0 | \n", "134.0 | \n", "NaN | \n", "2018-10-10 20:33:13.618110976 | \n", "DC | \n", "NIOSH | \n", "2018-10-10 20:33:13.618111 | \n", "\n", " | DUG, GMR, H13A, HLID, I11A, I13A, J11A, J12A, ... | \n", "
1 | \n", "2007-08-07 02:14:24.080 | \n", "39.4632 | \n", "-111.2230 | \n", "4180.0 | \n", "1.26 | \n", "LR | \n", "0.0 | \n", "NaN | \n", "smi:local/248883 | \n", "NaN | \n", "... | \n", "0.8834 | \n", "0.0 | \n", "14.0 | \n", "NaN | \n", "2018-10-10 21:10:26.864045056 | \n", "DC | \n", "NIOSH | \n", "2018-10-10 21:10:26.864045 | \n", "\n", " | DUG, P14A, P15A, P16A, P18A, Q14A, Q16A, Q18A,... | \n", "
2 | \n", "2007-08-07 03:44:18.470 | \n", "39.4625 | \n", "-111.2152 | \n", "4160.0 | \n", "1.45 | \n", "LR | \n", "0.0 | \n", "NaN | \n", "smi:local/248887 | \n", "NaN | \n", "... | \n", "0.5716 | \n", "0.0 | \n", "15.0 | \n", "NaN | \n", "2018-10-10 21:10:27.576204032 | \n", "DC | \n", "NIOSH | \n", "2018-10-10 21:10:27.576204 | \n", "\n", " | DUG, N17A, P14A, P16A, P18A, Q14A, Q16A, Q18A,... | \n", "
3 | \n", "2007-08-07 07:13:05.760 | \n", "39.4605 | \n", "-111.2242 | \n", "3240.0 | \n", "2.24 | \n", "\n", " | 0.0 | \n", "NaN | \n", "smi:local/248891 | \n", "NaN | \n", "... | \n", "0.9901 | \n", "0.0 | \n", "35.0 | \n", "NaN | \n", "2012-04-12 10:19:26.228029952 | \n", "\n", " | \n", " | NaT | \n", "\n", " | DUG, L15A, M14A, M15A, M16A, N14A, N15A, N16A,... | \n", "
4 | \n", "2007-08-07 02:05:04.490 | \n", "39.4648 | \n", "-111.2255 | \n", "1790.0 | \n", "2.08 | \n", "LR | \n", "0.0 | \n", "NaN | \n", "smi:local/248882 | \n", "NaN | \n", "... | \n", "0.9935 | \n", "0.0 | \n", "35.0 | \n", "NaN | \n", "2018-10-10 21:15:19.190404096 | \n", "DC | \n", "NIOSH | \n", "2018-10-10 21:15:19.190404 | \n", "\n", " | DUG, L15A, M14A, M15A, N14A, N15A, N16A, N17A,... | \n", "
5 rows × 28 columns
\n", "\n", " | time | \n", "latitude | \n", "longitude | \n", "depth | \n", "magnitude | \n", "event_description | \n", "associated_phase_count | \n", "azimuthal_gap | \n", "event_id | \n", "horizontal_uncertainty | \n", "... | \n", "standard_error | \n", "used_phase_count | \n", "station_count | \n", "vertical_uncertainty | \n", "updated | \n", "author | \n", "agency_id | \n", "creation_time | \n", "version | \n", "stations | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "2007-08-06 08:48:40.010 | \n", "39.4635 | \n", "-111.2277 | \n", "410.0 | \n", "4.37 | \n", "LR | \n", "0.0 | \n", "NaN | \n", "smi:local/248839 | \n", "NaN | \n", "... | \n", "1.7356 | \n", "0.0 | \n", "134.0 | \n", "NaN | \n", "2018-10-10 20:33:13.618110976 | \n", "DC | \n", "NIOSH | \n", "2018-10-10 20:33:13.618111 | \n", "\n", " | DUG, GMR, H13A, HLID, I11A, I13A, J11A, J12A, ... | \n", "
1 | \n", "2007-08-07 02:14:24.080 | \n", "39.4632 | \n", "-111.2230 | \n", "4180.0 | \n", "1.26 | \n", "LR | \n", "0.0 | \n", "NaN | \n", "smi:local/248883 | \n", "NaN | \n", "... | \n", "0.8834 | \n", "0.0 | \n", "14.0 | \n", "NaN | \n", "2018-10-10 21:10:26.864045056 | \n", "DC | \n", "NIOSH | \n", "2018-10-10 21:10:26.864045 | \n", "\n", " | DUG, P14A, P15A, P16A, P18A, Q14A, Q16A, Q18A,... | \n", "
2 | \n", "2007-08-07 03:44:18.470 | \n", "39.4625 | \n", "-111.2152 | \n", "4160.0 | \n", "1.45 | \n", "LR | \n", "0.0 | \n", "NaN | \n", "smi:local/248887 | \n", "NaN | \n", "... | \n", "0.5716 | \n", "0.0 | \n", "15.0 | \n", "NaN | \n", "2018-10-10 21:10:27.576204032 | \n", "DC | \n", "NIOSH | \n", "2018-10-10 21:10:27.576204 | \n", "\n", " | DUG, N17A, P14A, P16A, P18A, Q14A, Q16A, Q18A,... | \n", "
3 | \n", "2007-08-07 07:13:05.760 | \n", "39.4605 | \n", "-111.2242 | \n", "3240.0 | \n", "2.24 | \n", "\n", " | 0.0 | \n", "NaN | \n", "smi:local/248891 | \n", "NaN | \n", "... | \n", "0.9901 | \n", "0.0 | \n", "35.0 | \n", "NaN | \n", "2012-04-12 10:19:26.228029952 | \n", "\n", " | \n", " | NaT | \n", "\n", " | DUG, L15A, M14A, M15A, M16A, N14A, N15A, N16A,... | \n", "
4 | \n", "2007-08-07 02:05:04.490 | \n", "39.4648 | \n", "-111.2255 | \n", "1790.0 | \n", "2.08 | \n", "LR | \n", "0.0 | \n", "NaN | \n", "smi:local/248882 | \n", "NaN | \n", "... | \n", "0.9935 | \n", "0.0 | \n", "35.0 | \n", "NaN | \n", "2018-10-10 21:15:19.190404096 | \n", "DC | \n", "NIOSH | \n", "2018-10-10 21:15:19.190404 | \n", "\n", " | DUG, L15A, M14A, M15A, N14A, N15A, N16A, N17A,... | \n", "
5 rows × 28 columns
\n", "\n", " | count | \n", "mean | \n", "std | \n", "min | \n", "25% | \n", "50% | \n", "75% | \n", "max | \n", "
---|---|---|---|---|---|---|---|---|
station | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
DUG | \n", "6 | \n", "0 days 00:00:26.450391666 | \n", "0 days 00:00:00.271624748 | \n", "0 days 00:00:26.071740 | \n", "0 days 00:00:26.329110 | \n", "0 days 00:00:26.405940 | \n", "0 days 00:00:26.613517500 | \n", "0 days 00:00:26.832520 | \n", "
L15A | \n", "4 | \n", "0 days 00:00:44.281470 | \n", "0 days 00:00:00.395213333 | \n", "0 days 00:00:43.904210 | \n", "0 days 00:00:43.958120 | \n", "0 days 00:00:44.299440 | \n", "0 days 00:00:44.622790 | \n", "0 days 00:00:44.622790 | \n", "
M14A | \n", "3 | \n", "0 days 00:00:42.733800 | \n", "0 days 00:00:00.232198731 | \n", "0 days 00:00:42.465680 | \n", "0 days 00:00:42.666770 | \n", "0 days 00:00:42.867860 | \n", "0 days 00:00:42.867860 | \n", "0 days 00:00:42.867860 | \n", "
M15A | \n", "6 | \n", "0 days 00:00:37.389573333 | \n", "0 days 00:00:00.395734547 | \n", "0 days 00:00:36.924550 | \n", "0 days 00:00:37.155292500 | \n", "0 days 00:00:37.276860 | \n", "0 days 00:00:37.723365 | \n", "0 days 00:00:37.872200 | \n", "
N14A | \n", "4 | \n", "0 days 00:00:34.753022500 | \n", "0 days 00:00:00.309191321 | \n", "0 days 00:00:34.382170 | \n", "0 days 00:00:34.556087500 | \n", "0 days 00:00:34.810995 | \n", "0 days 00:00:35.007930 | \n", "0 days 00:00:35.007930 | \n", "
N15A | \n", "4 | \n", "0 days 00:00:30.787567500 | \n", "0 days 00:00:00.678323974 | \n", "0 days 00:00:30.187990 | \n", "0 days 00:00:30.206282500 | \n", "0 days 00:00:30.793665 | \n", "0 days 00:00:31.374950 | \n", "0 days 00:00:31.374950 | \n", "
N16A | \n", "3 | \n", "0 days 00:00:27.035340 | \n", "0 days 00:00:00.319788540 | \n", "0 days 00:00:26.666080 | \n", "0 days 00:00:26.943025 | \n", "0 days 00:00:27.219970 | \n", "0 days 00:00:27.219970 | \n", "0 days 00:00:27.219970 | \n", "
N17A | \n", "3 | \n", "0 days 00:00:28.347476666 | \n", "0 days 00:00:00.111948217 | \n", "0 days 00:00:28.218210 | \n", "0 days 00:00:28.315160 | \n", "0 days 00:00:28.412110 | \n", "0 days 00:00:28.412110 | \n", "0 days 00:00:28.412110 | \n", "
N18A | \n", "3 | \n", "0 days 00:00:34.095483333 | \n", "0 days 00:00:00.503778524 | \n", "0 days 00:00:33.513770 | \n", "0 days 00:00:33.950055 | \n", "0 days 00:00:34.386340 | \n", "0 days 00:00:34.386340 | \n", "0 days 00:00:34.386340 | \n", "
O15A | \n", "5 | \n", "0 days 00:00:24.222288400 | \n", "0 days 00:00:00.158953507 | \n", "0 days 00:00:24.049170 | \n", "0 days 00:00:24.049170 | \n", "0 days 00:00:24.314742 | \n", "0 days 00:00:24.335500 | \n", "0 days 00:00:24.362860 | \n", "
O16A | \n", "3 | \n", "0 days 00:00:14.805791333 | \n", "0 days 00:00:00.214392546 | \n", "0 days 00:00:14.558760 | \n", "0 days 00:00:14.737037 | \n", "0 days 00:00:14.915314 | \n", "0 days 00:00:14.929307 | \n", "0 days 00:00:14.943300 | \n", "
O18A | \n", "5 | \n", "0 days 00:00:23.389030200 | \n", "0 days 00:00:00.425951696 | \n", "0 days 00:00:22.925160 | \n", "0 days 00:00:23.116750 | \n", "0 days 00:00:23.224960 | \n", "0 days 00:00:23.792720 | \n", "0 days 00:00:23.885561 | \n", "
P14A | \n", "8 | \n", "0 days 00:00:26.757380 | \n", "0 days 00:00:00.369050089 | \n", "0 days 00:00:26.272320 | \n", "0 days 00:00:26.410845 | \n", "0 days 00:00:26.791710 | \n", "0 days 00:00:27.140000 | \n", "0 days 00:00:27.143660 | \n", "
P15A | \n", "9 | \n", "0 days 00:00:16.204747666 | \n", "0 days 00:00:00.692561976 | \n", "0 days 00:00:15.271110 | \n", "0 days 00:00:15.920450 | \n", "0 days 00:00:16.195300 | \n", "0 days 00:00:16.614280 | \n", "0 days 00:00:17.513850 | \n", "
P16A | \n", "11 | \n", "0 days 00:00:07.927102 | \n", "0 days 00:00:00.215584258 | \n", "0 days 00:00:07.682190 | \n", "0 days 00:00:07.795410 | \n", "0 days 00:00:07.859270 | \n", "0 days 00:00:08.034686 | \n", "0 days 00:00:08.397620 | \n", "
P17A | \n", "6 | \n", "0 days 00:00:07.174232666 | \n", "0 days 00:00:00.289962934 | \n", "0 days 00:00:06.905530 | \n", "0 days 00:00:06.943467500 | \n", "0 days 00:00:07.091821500 | \n", "0 days 00:00:07.364075500 | \n", "0 days 00:00:07.607380 | \n", "
P18A | \n", "11 | \n", "0 days 00:00:14.736734454 | \n", "0 days 00:00:00.293448302 | \n", "0 days 00:00:14.258420 | \n", "0 days 00:00:14.580390 | \n", "0 days 00:00:14.690940 | \n", "0 days 00:00:14.856656 | \n", "0 days 00:00:15.265000 | \n", "
Q14A | \n", "6 | \n", "0 days 00:00:30.549576666 | \n", "0 days 00:00:00.335974466 | \n", "0 days 00:00:30.212890 | \n", "0 days 00:00:30.306100 | \n", "0 days 00:00:30.498545 | \n", "0 days 00:00:30.690990 | \n", "0 days 00:00:31.090390 | \n", "
Q15A | \n", "7 | \n", "0 days 00:00:18.810036142 | \n", "0 days 00:00:00.297412245 | \n", "0 days 00:00:18.382690 | \n", "0 days 00:00:18.592790 | \n", "0 days 00:00:18.931850 | \n", "0 days 00:00:18.977141500 | \n", "0 days 00:00:19.215850 | \n", "
Q16A | \n", "10 | \n", "0 days 00:00:10.165477800 | \n", "0 days 00:00:00.328986240 | \n", "0 days 00:00:09.618000 | \n", "0 days 00:00:10.006930 | \n", "0 days 00:00:10.153105 | \n", "0 days 00:00:10.248371250 | \n", "0 days 00:00:10.690000 | \n", "
Q18A | \n", "11 | \n", "0 days 00:00:17.135285636 | \n", "0 days 00:00:00.256429698 | \n", "0 days 00:00:16.894450 | \n", "0 days 00:00:16.975725 | \n", "0 days 00:00:17.010560 | \n", "0 days 00:00:17.186767 | \n", "0 days 00:00:17.665000 | \n", "
Q19A | \n", "3 | \n", "0 days 00:00:29.604353333 | \n", "0 days 00:00:00.383435634 | \n", "0 days 00:00:29.161600 | \n", "0 days 00:00:29.493665 | \n", "0 days 00:00:29.825730 | \n", "0 days 00:00:29.825730 | \n", "0 days 00:00:29.825730 | \n", "
R15A | \n", "4 | \n", "0 days 00:00:27.445802500 | \n", "0 days 00:00:00.545923743 | \n", "0 days 00:00:26.713610 | \n", "0 days 00:00:27.186507500 | \n", "0 days 00:00:27.603435 | \n", "0 days 00:00:27.862730 | \n", "0 days 00:00:27.862730 | \n", "
R17A | \n", "11 | \n", "0 days 00:00:20.501155545 | \n", "0 days 00:00:00.236867827 | \n", "0 days 00:00:20.280000 | \n", "0 days 00:00:20.351515 | \n", "0 days 00:00:20.397810 | \n", "0 days 00:00:20.510261 | \n", "0 days 00:00:20.965000 | \n", "
R18A | \n", "8 | \n", "0 days 00:00:27.290727500 | \n", "0 days 00:00:00.298790493 | \n", "0 days 00:00:26.900100 | \n", "0 days 00:00:27.151197500 | \n", "0 days 00:00:27.153725 | \n", "0 days 00:00:27.449397500 | \n", "0 days 00:00:27.732590 | \n", "
SRU | \n", "14 | \n", "0 days 00:00:12.069393500 | \n", "0 days 00:00:00.243053585 | \n", "0 days 00:00:11.719920 | \n", "0 days 00:00:11.960260250 | \n", "0 days 00:00:12.020410 | \n", "0 days 00:00:12.112279500 | \n", "0 days 00:00:12.505000 | \n", "