{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "## Test and overview of the `mdf_reader` tool " ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "First clone the [gitlab repository](https://git.noc.ac.uk/brecinosrivas/mdf_reader) and modify the path in `sys.path.append()` with the directory path where you store the `mdf_reader` repository." ] }, { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "2020-12-10 09:49:38,429 - root - INFO - init basic configure of logging success\n" ] } ], "source": [ "import os\n", "import sys\n", "sys.path.append('/home/bea/')\n", "import mdf_reader\n", "import json" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "The `mdf_reader` is a python3 tool designed to read data files compliant with a user specified [data\n", "model](https://cds.climate.copernicus.eu/toolbox/doc/how-to/15_how_to_understand_the_common_data_model/15_how_to_understand_the_common_data_model.html). \n", "\n", "It was developed with the initial idea to read the [IMMA](https://icoads.noaa.gov/e-doc/imma/R3.0-imma1.pdf) data format, but it was further enhanced to account for other meteorological data formats. \n", "\n", "Lets see an example for a typical file from [ICOADSv3.0.](https://icoads.noaa.gov/r3.html). We pick an specific montly output for a Source/Deck. In this case data from the Marine Meterological Journals data set SID/DCK: **125-704 for Oct 1878.**\n", "\n", "The `.imma` file looks like this:" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "/home/bea/.virtualenvs/c3s/lib/python3.6/site-packages/ipykernel_launcher.py:4: FutureWarning: read_table is deprecated, use read_csv instead, passing sep='\\t'.\n", " after removing the cwd from sys.path.\n" ] } ], "source": [ "import pandas as pd\n", "\n", "data_path = os.path.join('~/c3s_work','mdf_reader/tests/data/125-704_1878-10_subset.imma')\n", "data_ori = pd.read_table(data_path)" ] }, { "cell_type": "code", "execution_count": 3, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
18781020 600 4228 29159 130623 10Panay 12325123 9961 4 165 17128704125 5 0 1 1FF111F11AAA1AAAA1AAA 9815020N163002199 0 100200180003Panay 78011118737S.P.Bray,Jr 013231190214 Bulkhead of cabin 1- .1022200200180014Boston Rio de Janeiro 300200180014001518781020 4220N 6630W 10 E 400200180014001518781020102 85 EXS WSW 0629601 58 BOC CU05R
018781020 800 4231 29197 130623 10Panay 1...
1187810201000 4233 29236 130623 10Panay 1...
2187810201200 4235 29271 130623 10Panay 1...
3187810201400 4237 29310 130623 10Panay 1...
4187810201600 4233 29350 130423 10Panay 1...
\n", "
" ], "text/plain": [ " 18781020 600 4228 29159 130623 10Panay 12325123 9961 4 165 17128704125 5 0 1 1FF111F11AAA1AAAA1AAA 9815020N163002199 0 100200180003Panay 78011118737S.P.Bray,Jr 013231190214 Bulkhead of cabin 1- .1022200200180014Boston Rio de Janeiro 300200180014001518781020 4220N 6630W 10 E 400200180014001518781020102 85 EXS WSW 0629601 58 BOC CU05R\n", "0 18781020 800 4231 29197 130623 10Panay 1... \n", "1 187810201000 4233 29236 130623 10Panay 1... \n", "2 187810201200 4235 29271 130623 10Panay 1... \n", "3 187810201400 4237 29310 130623 10Panay 1... \n", "4 187810201600 4233 29350 130423 10Panay 1... " ] }, "execution_count": 3, "metadata": {}, "output_type": "execute_result" } ], "source": [ "data_ori.head()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Very messy to just read into python! \n", "\n", "This is why we need the `mdf_reader` tool, to helps us put those imma files in a [pandas.DataFrame](https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.html) format. For that we need need a **schema**.\n", "\n", "A **schema** file gathers a collection of descriptors that enable the `mdf_reader` tool to access the content\n", "of a `data model/ schema` and extract the sections of the raw data file that contains meaningful information. These **schema files** are the `bones` of the data model, basically `.json` files outlining the structure of the incoming raw data.\n", "\n", "The `mdf_reader` takes this information and translate the characteristics of the data to a python pandas dataframe.\n", "\n", "The tool has several **schema** templates build in." ] }, { "cell_type": "code", "execution_count": 4, "metadata": {}, "outputs": [], "source": [ "template_names = mdf_reader.schemas.templates()" ] }, { "cell_type": "code", "execution_count": 5, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "['fixed_width_complex_exc',\n", " 'delimited_sections',\n", " 'delimited_basic',\n", " 'fixed_width_complex_opt',\n", " 'fixed_width_sections',\n", " 'fixed_width_basic']" ] }, "execution_count": 5, "metadata": {}, "output_type": "execute_result" } ], "source": [ "template_names" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "As well as templates for `code_tables` which are `.json` files containing keys to describe complex metereological variables like weather forcast or sea state conditions." ] }, { "cell_type": "code", "execution_count": 6, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "['nested', 'range_keyed_nested', 'simple', 'range_keyed_simple']" ] }, "execution_count": 6, "metadata": {}, "output_type": "execute_result" } ], "source": [ "template_tables = mdf_reader.code_tables.templates()\n", "template_tables" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "**Schemas** can be desinged to be deck specific like the example below" ] }, { "cell_type": "code", "execution_count": 7, "metadata": {}, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "2020-12-10 09:54:39,637 - root - INFO - READING DATA MODEL SCHEMA FILE...\n", "2020-12-10 09:54:39,650 - root - INFO - EXTRACTING DATA FROM MODEL: imma1_d704\n", "2020-12-10 09:54:39,652 - root - INFO - Getting data string from source...\n", "2020-12-10 09:54:39,672 - root - INFO - Extracting and reading sections\n", "2020-12-10 09:54:39,678 - root - INFO - Processing section partitioning threads\n", "2020-12-10 09:54:39,679 - root - INFO - 1000 ...\n", "2020-12-10 09:54:39,713 - root - INFO - done\n", "2020-12-10 09:54:39,718 - root - INFO - 211000 ...\n", "2020-12-10 09:54:39,761 - root - INFO - done\n", "2020-12-10 09:54:39,762 - root - INFO - 29211000 ...\n", "2020-12-10 09:54:39,793 - root - INFO - done\n", "2020-12-10 09:54:39,794 - root - INFO - 3029211000 ...\n", "2020-12-10 09:54:39,802 - root - INFO - done\n", "2020-12-10 09:54:39,803 - root - INFO - 303029211000 ...\n", "2020-12-10 09:54:39,809 - root - INFO - done\n", "2020-12-10 09:54:39,813 - root - INFO - 30303029211000 ...\n", "2020-12-10 09:54:39,821 - root - INFO - done\n", "2020-12-10 09:54:39,822 - root - INFO - 3030303029211000 ...\n", "2020-12-10 09:54:39,851 - root - INFO - done\n", "2020-12-10 09:54:39,854 - root - INFO - 413030303029211000 ...\n", "2020-12-10 09:54:39,863 - root - INFO - done\n" ] }, { "name": "stdout", "output_type": "stream", "text": [ "Reading section core\n", "Reading section c1\n", "Reading section c5\n", "Reading section c6\n", "Reading section c7\n", "Reading section c8\n", "Reading section c9\n", "Reading section c95\n", "Reading section c96\n", "Reading section c97\n", "Reading section c98\n", "Reading section c99_sentinal\n", "Reading section c99_journal\n", "Reading section c99_voyage\n", "Reading section c99_daily\n", "Reading section c99_data4\n", "Reading section c99_data5\n" ] }, { "name": "stderr", "output_type": "stream", "text": [ "2020-12-10 09:54:43,137 - root - WARNING - Data numeric elements with missing upper or lower threshold: ('c1', 'BSI'),('c1', 'AQZ'),('c1', 'AQA'),('c1', 'UQZ'),('c1', 'UQA'),('c1', 'VQZ'),('c1', 'VQA'),('c1', 'PQZ'),('c1', 'PQA'),('c1', 'DQZ'),('c1', 'DQA'),('c5', 'OS'),('c5', 'OP'),('c5', 'FM'),('c5', 'IMMV'),('c5', 'IX'),('c5', 'W2'),('c5', 'WMI'),('c5', 'SD2'),('c5', 'SP2'),('c5', 'IS'),('c5', 'RS'),('c5', 'IC1'),('c5', 'IC2'),('c5', 'IC3'),('c5', 'IC4'),('c5', 'IC5'),('c5', 'IR'),('c5', 'RRR'),('c5', 'TR'),('c5', 'NU'),('c5', 'QCI'),('c5', 'QI1'),('c5', 'QI2'),('c5', 'QI3'),('c5', 'QI4'),('c5', 'QI5'),('c5', 'QI6'),('c5', 'QI7'),('c5', 'QI8'),('c5', 'QI9'),('c5', 'QI10'),('c5', 'QI11'),('c5', 'QI12'),('c5', 'QI13'),('c5', 'QI14'),('c5', 'QI15'),('c5', 'QI16'),('c5', 'QI17'),('c5', 'QI18'),('c5', 'QI19'),('c5', 'QI20'),('c5', 'QI21'),('c5', 'QI22'),('c5', 'QI23'),('c5', 'QI24'),('c5', 'QI25'),('c5', 'QI26'),('c5', 'QI27'),('c5', 'QI28'),('c5', 'QI29'),('c5', 'RHI'),('c5', 'AWSI'),('c6', 'FBSRC'),('c6', 'MST'),('c7', 'OPM'),('c7', 'LOT'),('c9', 'CCe'),('c9', 'WWe'),('c9', 'Ne'),('c9', 'NHe'),('c9', 'He'),('c9', 'CLe'),('c9', 'CMe'),('c9', 'CHe'),('c9', 'SBI'),('c95', 'DPRO'),('c95', 'DPRP'),('c95', 'UFR'),('c95', 'ASIR'),('c96', 'ASII'),('c97', 'ASIE'),('c99_journal', 'vessel_length'),('c99_journal', 'vessel_beam'),('c99_journal', 'hold_depth'),('c99_journal', 'tonnage'),('c99_journal', 'baro_height'),('c99_daily', 'year'),('c99_daily', 'month'),('c99_daily', 'day'),('c99_daily', 'distance'),('c99_daily', 'lat_deg_an'),('c99_daily', 'lat_min_an'),('c99_daily', 'lon_deg_an'),('c99_daily', 'lon_min_an'),('c99_daily', 'lat_deg_on'),('c99_daily', 'lat_min_on'),('c99_daily', 'lon_deg_of'),('c99_daily', 'lon_min_of'),('c99_daily', 'current_speed'),('c99_data4', 'year'),('c99_data4', 'month'),('c99_data4', 'day'),('c99_data4', 'hour'),('c99_data4', 'ship_speed'),('c99_data4', 'compass_correction'),('c99_data4', 'attached_thermometer'),('c99_data4', 'air_temperature'),('c99_data4', 'wet_bulb_temperature'),('c99_data4', 'sea_temperature'),('c99_data4', 'sky_clear'),('c99_data5', 'year'),('c99_data5', 'month'),('c99_data5', 'day'),('c99_data5', 'hour'),('c99_data5', 'ship_speed'),('c99_data5', 'attached_thermometer'),('c99_data5', 'air_temperature'),('c99_data5', 'wet_bulb_temperature'),('c99_data5', 'sea_temperature'),('c99_data5', 'sky_clear'),('c99_data5', 'compass_correction')\n", "2020-12-10 09:54:43,138 - root - WARNING - Corresponding upper and/or lower bounds set to +/-inf for validation\n", "2020-12-10 09:54:44,849 - root - ERROR - Code table not defined for element ('c99_data4', 'present_weather')\n", "2020-12-10 09:54:44,851 - root - WARNING - Element mask set to False\n", "2020-12-10 09:54:44,853 - root - ERROR - Code table not defined for element ('c99_data4', 'clouds')\n", "2020-12-10 09:54:44,862 - root - WARNING - Element mask set to False\n", "2020-12-10 09:54:44,875 - root - ERROR - Code table not defined for element ('c99_data4', 'sea_state')\n", "2020-12-10 09:54:44,880 - root - WARNING - Element mask set to False\n", "2020-12-10 09:54:44,883 - root - ERROR - Code table not defined for element ('c99_data5', 'time_ind')\n", "2020-12-10 09:54:44,885 - root - WARNING - Element mask set to False\n", "2020-12-10 09:54:44,889 - root - ERROR - Code table not defined for element ('c99_data5', 'compass_ind')\n", "2020-12-10 09:54:44,891 - root - WARNING - Element mask set to False\n", "2020-12-10 09:54:44,893 - root - ERROR - Code table not defined for element ('c99_data5', 'ship_course_compass')\n", "2020-12-10 09:54:44,895 - root - WARNING - Element mask set to False\n", "2020-12-10 09:54:44,902 - root - ERROR - Code table not defined for element ('c99_data5', 'ship_course_true')\n", "2020-12-10 09:54:44,908 - root - WARNING - Element mask set to False\n", "2020-12-10 09:54:44,912 - root - ERROR - Code table not defined for element ('c99_data5', 'wind_dir_mag')\n", "2020-12-10 09:54:44,916 - root - WARNING - Element mask set to False\n", "2020-12-10 09:54:44,918 - root - ERROR - Code table not defined for element ('c99_data5', 'wind_force')\n", "2020-12-10 09:54:44,920 - root - WARNING - Element mask set to False\n", "2020-12-10 09:54:44,922 - root - ERROR - Code table not defined for element ('c99_data5', 'temp_ind')\n", "2020-12-10 09:54:44,926 - root - WARNING - Element mask set to False\n", "2020-12-10 09:54:44,928 - root - ERROR - Code table not defined for element ('c99_data5', 'present_weather')\n", "2020-12-10 09:54:44,932 - root - WARNING - Element mask set to False\n", "2020-12-10 09:54:44,936 - root - ERROR - Code table not defined for element ('c99_data5', 'clouds')\n", "2020-12-10 09:54:44,938 - root - WARNING - Element mask set to False\n", "2020-12-10 09:54:44,940 - root - ERROR - Code table not defined for element ('c99_data5', 'sea_state')\n", "2020-12-10 09:54:44,942 - root - WARNING - Element mask set to False\n", "2020-12-10 09:54:44,947 - root - ERROR - Code table not defined for element ('c99_data5', 'compass_correction_ind')\n", "2020-12-10 09:54:44,949 - root - WARNING - Element mask set to False\n", "2020-12-10 09:54:44,954 - root - ERROR - Code table not defined for element ('c99_data5', 'compass_correction_dir')\n", "2020-12-10 09:54:44,960 - root - WARNING - Element mask set to False\n", "2020-12-10 09:54:46,245 - root - INFO - Wrapping output....\n", "2020-12-10 09:54:46,490 - root - INFO - CREATING OUTPUT DATA ATTRIBUTES FROM DATA MODEL\n" ] } ], "source": [ "schema = 'imma1_d704'\n", "\n", "data_file_path = '/home/bea/c3s_work/mdf_reader/tests/data/125-704_1878-10_subset.imma'\n", "\n", "data = mdf_reader.read(data_file_path, data_model = schema)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "A new **schema** can be build for a particular deck and source as shown in this notebook. The `imma1_d704` schema was build upon the `imma1` schema/data model but extra sections have been added to the `.json` files to include suplemental data from ICOADS documentation. This is a snapshot of the data inside the `imma1_d704.json`.\n", "```\n", "\"c99_journal\": {\n", " \"header\": {\"sentinal\": \"1\", \"field_layout\":\"fixed_width\",\"length\": 117},\n", " \"elements\": {\n", " \"sentinal\":{\n", " \"description\": \"Journal header record identifier\",\n", " \"field_length\": 1,\n", " \"column_type\": \"str\"\n", " },\n", " \"reel_no\":{\n", " \"description\": \"Microfilm reel number. See if we want the zero padding or not...\",\n", " \"field_length\": 3,\n", " \"column_type\": \"str\",\n", " \"LMR6\": true\n", " }\n", "\n", "```\n", "\n" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Now metadata information can be extracted as a component of the padas dataframe. " ] }, { "cell_type": "code", "execution_count": 8, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
sentinalreel_nojournal_noframe_noship_namejournal_edrigship_materialvessel_typevessel_length...hold_depthtonnagebaro_typebaro_heightbaro_cdatebaro_locbaro_unitsbaro_corthermo_mountSST_I
0100200180003Panay780111187...231190214NaNBulkhead of cabin1- .1022NaN
1100200180003Panay780111187...231190214NaNBulkhead of cabin1- .1022NaN
2100200180003Panay780111187...231190214NaNBulkhead of cabin1- .1022NaN
3100200180003Panay780111187...231190214NaNBulkhead of cabin1- .1022NaN
4100200180003Panay780111187...231190214NaNBulkhead of cabin1- .1022NaN
5100200180003Panay780111187...231190214NaNBulkhead of cabin1- .1022NaN
6100701290410Emma780211136...19468110NaNIn the after cabin1- .5611NaN
7100200180003Panay780111187...231190214NaNBulkhead of cabin1- .1022NaN
8100701290410Emma780211136...19468110NaNIn the after cabin1- .5611NaN
9100200330416Emma C.Litchfield780211128...1748311701101878After Cabin1+ .0011NaN
10100200180003Panay780111187...231190214NaNBulkhead of cabin1- .1022NaN
11100701290410Emma780211136...19468110NaNIn the after cabin1- .5611NaN
12100200330416Emma C.Litchfield780211128...1748311701101878After Cabin1+ .0011NaN
13100200180003Panay780111187...231190214NaNBulkhead of cabin1- .1022NaN
14100701290410Emma780211136...19468110NaNIn the after cabin1- .5611NaN
15100200330416Emma C.Litchfield780211128...1748311701101878After Cabin1+ .0011NaN
16100200180003Panay780111187...231190214NaNBulkhead of cabin1- .1022NaN
17100701290410Emma780211136...19468110NaNIn the after cabin1- .5611NaN
18100200330416Emma C.Litchfield780211128...1748311701101878After Cabin1+ .0011NaN
19100200180003Panay780111187...231190214NaNBulkhead of cabin1- .1022NaN
20100701290410Emma780211136...19468110NaNIn the after cabin1- .5611NaN
21100200330416Emma C.Litchfield780211128...1748311701101878After Cabin1+ .0011NaN
22100200180003Panay780111187...231190214NaNBulkhead of cabin1- .1022NaN
23100701290410Emma780211136...19468110NaNIn the after cabin1- .5611NaN
24100200330416Emma C.Litchfield780211128...1748311701101878After Cabin1+ .0011NaN
25100200180003Panay780111187...231190214NaNBulkhead of cabin1- .1022NaN
26100701290410Emma780211136...19468110NaNIn the after cabin1- .5611NaN
27100200330416Emma C.Litchfield780211128...1748311701101878After Cabin1+ .0011NaN
28100200180003Panay780111187...231190214NaNBulkhead of cabin1- .1022NaN
29100701290410Emma780211136...19468110NaNIn the after cabin1- .5611NaN
..................................................................
435100701290410Emma780211136...19468110NaNIn the after cabin1- .5611NaN
436100200180003Panay780111187...231190214NaNBulkhead of cabin1- .1022NaN
437100100140437Jermiah Thompson780111217...281904115101878After Bulk Head Capt Room1+ .0034NaN
438100200330416Emma C.Litchfield780211128...1748311701101878After Cabin1+ .0011NaN
439100701290410Emma780211136...19468110NaNIn the after cabin1- .5611NaN
440100200180003Panay780111187...231190214NaNBulkhead of cabin1- .1022NaN
441100100140437Jermiah Thompson780111217...281904115101878After Bulk Head Capt Room1+ .0034NaN
442100200330416Emma C.Litchfield780211128...1748311701101878After Cabin1+ .0011NaN
443100701290410Emma780211136...19468110NaNIn the after cabin1- .5611NaN
444100200180003Panay780111187...231190214NaNBulkhead of cabin1- .1022NaN
445100100140437Jermiah Thompson780111217...281904115101878After Bulk Head Capt Room1+ .0034NaN
446100200330416Emma C.Litchfield780211128...1748311701101878After Cabin1+ .0011NaN
447100701290410Emma780211136...19468110NaNIn the after cabin1- .5611NaN
448100200180003Panay780111187...231190214NaNBulkhead of cabin1- .1022NaN
449100100140437Jermiah Thompson780111217...281904115101878After Bulk Head Capt Room1+ .0034NaN
450100200330416Emma C.Litchfield780211128...1748311701101878After Cabin1+ .0011NaN
451100701290410Emma780211136...19468110NaNIn the after cabin1- .5611NaN
452100200180003Panay780111187...231190214NaNBulkhead of cabin1- .1022NaN
453100100140437Jermiah Thompson780111217...281904115101878After Bulk Head Capt Room1+ .0034NaN
454100200330416Emma C.Litchfield780211128...1748311701101878After Cabin1+ .0011NaN
455100701290410Emma780211136...19468110NaNIn the after cabin1- .5611NaN
456100200180003Panay780111187...231190214NaNBulkhead of cabin1- .1022NaN
457100100140437Jermiah Thompson780111217...281904115101878After Bulk Head Capt Room1+ .0034NaN
458100200330416Emma C.Litchfield780211128...1748311701101878After Cabin1+ .0011NaN
459100701290410Emma780211136...19468110NaNIn the after cabin1- .5611NaN
460100200180003Panay780111187...231190214NaNBulkhead of cabin1- .1022NaN
461100100140437Jermiah Thompson780111217...281904115101878After Bulk Head Capt Room1+ .0034NaN
462100200330416Emma C.Litchfield780211128...1748311701101878After Cabin1+ .0011NaN
463100701290410Emma780211136...19468110NaNIn the after cabin1- .5611NaN
464100200180003Panay780111187...231190214NaNBulkhead of cabin1- .1022NaN
\n", "

465 rows × 24 columns

\n", "
" ], "text/plain": [ " sentinal reel_no journal_no frame_no ship_name journal_ed rig \\\n", "0 1 002 0018 0003 Panay 78 01 \n", "1 1 002 0018 0003 Panay 78 01 \n", "2 1 002 0018 0003 Panay 78 01 \n", "3 1 002 0018 0003 Panay 78 01 \n", "4 1 002 0018 0003 Panay 78 01 \n", "5 1 002 0018 0003 Panay 78 01 \n", "6 1 007 0129 0410 Emma 78 02 \n", "7 1 002 0018 0003 Panay 78 01 \n", "8 1 007 0129 0410 Emma 78 02 \n", "9 1 002 0033 0416 Emma C.Litchfield 78 02 \n", "10 1 002 0018 0003 Panay 78 01 \n", "11 1 007 0129 0410 Emma 78 02 \n", "12 1 002 0033 0416 Emma C.Litchfield 78 02 \n", "13 1 002 0018 0003 Panay 78 01 \n", "14 1 007 0129 0410 Emma 78 02 \n", "15 1 002 0033 0416 Emma C.Litchfield 78 02 \n", "16 1 002 0018 0003 Panay 78 01 \n", "17 1 007 0129 0410 Emma 78 02 \n", "18 1 002 0033 0416 Emma C.Litchfield 78 02 \n", "19 1 002 0018 0003 Panay 78 01 \n", "20 1 007 0129 0410 Emma 78 02 \n", "21 1 002 0033 0416 Emma C.Litchfield 78 02 \n", "22 1 002 0018 0003 Panay 78 01 \n", "23 1 007 0129 0410 Emma 78 02 \n", "24 1 002 0033 0416 Emma C.Litchfield 78 02 \n", "25 1 002 0018 0003 Panay 78 01 \n", "26 1 007 0129 0410 Emma 78 02 \n", "27 1 002 0033 0416 Emma C.Litchfield 78 02 \n", "28 1 002 0018 0003 Panay 78 01 \n", "29 1 007 0129 0410 Emma 78 02 \n", ".. ... ... ... ... ... ... .. \n", "435 1 007 0129 0410 Emma 78 02 \n", "436 1 002 0018 0003 Panay 78 01 \n", "437 1 001 0014 0437 Jermiah Thompson 78 01 \n", "438 1 002 0033 0416 Emma C.Litchfield 78 02 \n", "439 1 007 0129 0410 Emma 78 02 \n", "440 1 002 0018 0003 Panay 78 01 \n", "441 1 001 0014 0437 Jermiah Thompson 78 01 \n", "442 1 002 0033 0416 Emma C.Litchfield 78 02 \n", "443 1 007 0129 0410 Emma 78 02 \n", "444 1 002 0018 0003 Panay 78 01 \n", "445 1 001 0014 0437 Jermiah Thompson 78 01 \n", "446 1 002 0033 0416 Emma C.Litchfield 78 02 \n", "447 1 007 0129 0410 Emma 78 02 \n", "448 1 002 0018 0003 Panay 78 01 \n", "449 1 001 0014 0437 Jermiah Thompson 78 01 \n", "450 1 002 0033 0416 Emma C.Litchfield 78 02 \n", "451 1 007 0129 0410 Emma 78 02 \n", "452 1 002 0018 0003 Panay 78 01 \n", "453 1 001 0014 0437 Jermiah Thompson 78 01 \n", "454 1 002 0033 0416 Emma C.Litchfield 78 02 \n", "455 1 007 0129 0410 Emma 78 02 \n", "456 1 002 0018 0003 Panay 78 01 \n", "457 1 001 0014 0437 Jermiah Thompson 78 01 \n", "458 1 002 0033 0416 Emma C.Litchfield 78 02 \n", "459 1 007 0129 0410 Emma 78 02 \n", "460 1 002 0018 0003 Panay 78 01 \n", "461 1 001 0014 0437 Jermiah Thompson 78 01 \n", "462 1 002 0033 0416 Emma C.Litchfield 78 02 \n", "463 1 007 0129 0410 Emma 78 02 \n", "464 1 002 0018 0003 Panay 78 01 \n", "\n", " ship_material vessel_type vessel_length ... hold_depth tonnage \\\n", "0 1 1 187 ... 23 1190 \n", "1 1 1 187 ... 23 1190 \n", "2 1 1 187 ... 23 1190 \n", "3 1 1 187 ... 23 1190 \n", "4 1 1 187 ... 23 1190 \n", "5 1 1 187 ... 23 1190 \n", "6 1 1 136 ... 19 468 \n", "7 1 1 187 ... 23 1190 \n", "8 1 1 136 ... 19 468 \n", "9 1 1 128 ... 17 483 \n", "10 1 1 187 ... 23 1190 \n", "11 1 1 136 ... 19 468 \n", "12 1 1 128 ... 17 483 \n", "13 1 1 187 ... 23 1190 \n", "14 1 1 136 ... 19 468 \n", "15 1 1 128 ... 17 483 \n", "16 1 1 187 ... 23 1190 \n", "17 1 1 136 ... 19 468 \n", "18 1 1 128 ... 17 483 \n", "19 1 1 187 ... 23 1190 \n", "20 1 1 136 ... 19 468 \n", "21 1 1 128 ... 17 483 \n", "22 1 1 187 ... 23 1190 \n", "23 1 1 136 ... 19 468 \n", "24 1 1 128 ... 17 483 \n", "25 1 1 187 ... 23 1190 \n", "26 1 1 136 ... 19 468 \n", "27 1 1 128 ... 17 483 \n", "28 1 1 187 ... 23 1190 \n", "29 1 1 136 ... 19 468 \n", ".. ... ... ... ... ... ... \n", "435 1 1 136 ... 19 468 \n", "436 1 1 187 ... 23 1190 \n", "437 1 1 217 ... 28 1904 \n", "438 1 1 128 ... 17 483 \n", "439 1 1 136 ... 19 468 \n", "440 1 1 187 ... 23 1190 \n", "441 1 1 217 ... 28 1904 \n", "442 1 1 128 ... 17 483 \n", "443 1 1 136 ... 19 468 \n", "444 1 1 187 ... 23 1190 \n", "445 1 1 217 ... 28 1904 \n", "446 1 1 128 ... 17 483 \n", "447 1 1 136 ... 19 468 \n", "448 1 1 187 ... 23 1190 \n", "449 1 1 217 ... 28 1904 \n", "450 1 1 128 ... 17 483 \n", "451 1 1 136 ... 19 468 \n", "452 1 1 187 ... 23 1190 \n", "453 1 1 217 ... 28 1904 \n", "454 1 1 128 ... 17 483 \n", "455 1 1 136 ... 19 468 \n", "456 1 1 187 ... 23 1190 \n", "457 1 1 217 ... 28 1904 \n", "458 1 1 128 ... 17 483 \n", "459 1 1 136 ... 19 468 \n", "460 1 1 187 ... 23 1190 \n", "461 1 1 217 ... 28 1904 \n", "462 1 1 128 ... 17 483 \n", "463 1 1 136 ... 19 468 \n", "464 1 1 187 ... 23 1190 \n", "\n", " baro_type baro_height baro_cdate baro_loc baro_units \\\n", "0 2 14 NaN Bulkhead of cabin 1 \n", "1 2 14 NaN Bulkhead of cabin 1 \n", "2 2 14 NaN Bulkhead of cabin 1 \n", "3 2 14 NaN Bulkhead of cabin 1 \n", "4 2 14 NaN Bulkhead of cabin 1 \n", "5 2 14 NaN Bulkhead of cabin 1 \n", "6 1 10 NaN In the after cabin 1 \n", "7 2 14 NaN Bulkhead of cabin 1 \n", "8 1 10 NaN In the after cabin 1 \n", "9 1 17 01101878 After Cabin 1 \n", "10 2 14 NaN Bulkhead of cabin 1 \n", "11 1 10 NaN In the after cabin 1 \n", "12 1 17 01101878 After Cabin 1 \n", "13 2 14 NaN Bulkhead of cabin 1 \n", "14 1 10 NaN In the after cabin 1 \n", "15 1 17 01101878 After Cabin 1 \n", "16 2 14 NaN Bulkhead of cabin 1 \n", "17 1 10 NaN In the after cabin 1 \n", "18 1 17 01101878 After Cabin 1 \n", "19 2 14 NaN Bulkhead of cabin 1 \n", "20 1 10 NaN In the after cabin 1 \n", "21 1 17 01101878 After Cabin 1 \n", "22 2 14 NaN Bulkhead of cabin 1 \n", "23 1 10 NaN In the after cabin 1 \n", "24 1 17 01101878 After Cabin 1 \n", "25 2 14 NaN Bulkhead of cabin 1 \n", "26 1 10 NaN In the after cabin 1 \n", "27 1 17 01101878 After Cabin 1 \n", "28 2 14 NaN Bulkhead of cabin 1 \n", "29 1 10 NaN In the after cabin 1 \n", ".. ... ... ... ... ... \n", "435 1 10 NaN In the after cabin 1 \n", "436 2 14 NaN Bulkhead of cabin 1 \n", "437 1 15 101878 After Bulk Head Capt Room 1 \n", "438 1 17 01101878 After Cabin 1 \n", "439 1 10 NaN In the after cabin 1 \n", "440 2 14 NaN Bulkhead of cabin 1 \n", "441 1 15 101878 After Bulk Head Capt Room 1 \n", "442 1 17 01101878 After Cabin 1 \n", "443 1 10 NaN In the after cabin 1 \n", "444 2 14 NaN Bulkhead of cabin 1 \n", "445 1 15 101878 After Bulk Head Capt Room 1 \n", "446 1 17 01101878 After Cabin 1 \n", "447 1 10 NaN In the after cabin 1 \n", "448 2 14 NaN Bulkhead of cabin 1 \n", "449 1 15 101878 After Bulk Head Capt Room 1 \n", "450 1 17 01101878 After Cabin 1 \n", "451 1 10 NaN In the after cabin 1 \n", "452 2 14 NaN Bulkhead of cabin 1 \n", "453 1 15 101878 After Bulk Head Capt Room 1 \n", "454 1 17 01101878 After Cabin 1 \n", "455 1 10 NaN In the after cabin 1 \n", "456 2 14 NaN Bulkhead of cabin 1 \n", "457 1 15 101878 After Bulk Head Capt Room 1 \n", "458 1 17 01101878 After Cabin 1 \n", "459 1 10 NaN In the after cabin 1 \n", "460 2 14 NaN Bulkhead of cabin 1 \n", "461 1 15 101878 After Bulk Head Capt Room 1 \n", "462 1 17 01101878 After Cabin 1 \n", "463 1 10 NaN In the after cabin 1 \n", "464 2 14 NaN Bulkhead of cabin 1 \n", "\n", " baro_cor thermo_mount SST_I \n", "0 - .102 2 NaN \n", "1 - .102 2 NaN \n", "2 - .102 2 NaN \n", "3 - .102 2 NaN \n", "4 - .102 2 NaN \n", "5 - .102 2 NaN \n", "6 - .561 1 NaN \n", "7 - .102 2 NaN \n", "8 - .561 1 NaN \n", "9 + .001 1 NaN \n", "10 - .102 2 NaN \n", "11 - .561 1 NaN \n", "12 + .001 1 NaN \n", "13 - .102 2 NaN \n", "14 - .561 1 NaN \n", "15 + .001 1 NaN \n", "16 - .102 2 NaN \n", "17 - .561 1 NaN \n", "18 + .001 1 NaN \n", "19 - .102 2 NaN \n", "20 - .561 1 NaN \n", "21 + .001 1 NaN \n", "22 - .102 2 NaN \n", "23 - .561 1 NaN \n", "24 + .001 1 NaN \n", "25 - .102 2 NaN \n", "26 - .561 1 NaN \n", "27 + .001 1 NaN \n", "28 - .102 2 NaN \n", "29 - .561 1 NaN \n", ".. ... ... ... \n", "435 - .561 1 NaN \n", "436 - .102 2 NaN \n", "437 + .003 4 NaN \n", "438 + .001 1 NaN \n", "439 - .561 1 NaN \n", "440 - .102 2 NaN \n", "441 + .003 4 NaN \n", "442 + .001 1 NaN \n", "443 - .561 1 NaN \n", "444 - .102 2 NaN \n", "445 + .003 4 NaN \n", "446 + .001 1 NaN \n", "447 - .561 1 NaN \n", "448 - .102 2 NaN \n", "449 + .003 4 NaN \n", "450 + .001 1 NaN \n", "451 - .561 1 NaN \n", "452 - .102 2 NaN \n", "453 + .003 4 NaN \n", "454 + .001 1 NaN \n", "455 - .561 1 NaN \n", "456 - .102 2 NaN \n", "457 + .003 4 NaN \n", "458 + .001 1 NaN \n", "459 - .561 1 NaN \n", "460 - .102 2 NaN \n", "461 + .003 4 NaN \n", "462 + .001 1 NaN \n", "463 - .561 1 NaN \n", "464 - .102 2 NaN \n", "\n", "[465 rows x 24 columns]" ] }, "execution_count": 8, "metadata": {}, "output_type": "execute_result" } ], "source": [ "data.data.c99_journal" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "To learn how to construc a schema or data model for a particular deck/source, visit this other tutorial: [create_data_model.ipynb](https://git.noc.ac.uk/brecinosrivas/mdf_reader/-/blob/master/docs/notebooks/create_data_model.ipynb)" ] } ], "metadata": { "kernelspec": { "display_name": "Python (c3s)", "language": "python", "name": "c3s" }, "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.6.5" } }, "nbformat": 4, "nbformat_minor": 4 }