Skip to content

Instantly share code, notes, and snippets.

@seumasmorrison

seumasmorrison/import_seadarq_wave_report.ipynb

Last active June 23, 2017 10:52
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save seumasmorrison/89b25e20718c04fe984e367bdcce7fda to your computer and use it in GitHub Desktop.
Save seumasmorrison/89b25e20718c04fe984e367bdcce7fda to your computer and use it in GitHub Desktop.
Download ZIP
IPython Notebook for importing wave report files produced by Nortek B.V.'s SeaDarQ software ( tested with version 4.4.3756 ), importing all point spectral data into a single time indexed pandas DataFrame, Location values are converted to decimal degrees. Metadata including CubeSize, RangeCell, RotationTime & creation DateTime are stored along wi…
Display the source blob
Display the rendered blob
Raw
import_seadarq_wave_report.ipynb
{
"cells": [
{
"cell_type": "code",
"execution_count": null,
"metadata": {},
"outputs": [],
"source": [
"import pandas as pd"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {},
"outputs": [],
"source": [
"cd spectra_logs"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {},
"outputs": [],
"source": [
"seadarq_spectra = !ls"
]
},
{
"cell_type": "code",
"execution_count": 69,
"metadata": {},
"outputs": [],
"source": [
"def get_spectra(spectra_report_lines):\n",
" range_cell = spectra_report_lines[24].split()[-2]\n",
" rotation_time = spectra_report_lines[29].split()[-2]\n",
" cube_size = spectra_report_lines[25].split()[-3]\n",
" creation_time = spectra_report_lines[22].split()[-1]\n",
" creation_date = spectra_report_lines[21].split()[-1]\n",
" creation_datetime = pd.to_datetime(creation_date + 'T' + creation_time)\n",
" extra_cols = ['RangeCell','RotationTime','CreationDateTime','CubeSize']\n",
" headers = spectra_report_lines[33][1:-1].split() + extra_cols\n",
" points = []\n",
" for data in spectra_report_lines[34:-2]:\n",
" data = data.split()\n",
" #Assumes North & West hemisphere locations \n",
" lat = int(data[0][0:2]) + float(data[0][3:])/60.0\n",
" long = int(data[2][0:3]) + float(data[2][4:])/60.0\n",
" data = [lat] + [long] + data[4:] + [range_cell, rotation_time, \n",
" creation_datetime, cube_size]\n",
" index = pd.DatetimeIndex([pd.to_datetime(data[2]+'T'+data[3])])\n",
" points.append(pd.DataFrame([data], index = index, columns=headers))\n",
" spectra = pd.concat(points)\n",
" spectra.drop(['Date','Time'],axis=1, inplace=True)\n",
" spectra = spectra.apply(pd.to_numeric, errors='ignore')\n",
" return spectra"
]
},
{
"cell_type": "code",
"execution_count": 72,
"metadata": {},
"outputs": [],
"source": [
"concated_spectra_report = pd.concat([get_spectra(open(seadarq_spectrum).readlines()) for seadarq_spectrum in seadarq_spectra[474:]])\n",
"concated_spectra_report.sort_index(inplace=True)"
]
},
{
"cell_type": "code",
"execution_count": 73,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style>\n",
" .dataframe thead tr:only-child th {\n",
" text-align: right;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: left;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>Lat</th>\n",
" <th>Lon</th>\n",
" <th>Status</th>\n",
" <th>Depth</th>\n",
" <th>Current</th>\n",
" <th>CAngle</th>\n",
" <th>WaveLgth</th>\n",
" <th>Period</th>\n",
" <th>WAngle</th>\n",
" <th>WaveHght</th>\n",
" <th>Sigma</th>\n",
" <th>RangeCell</th>\n",
" <th>RotationTime</th>\n",
" <th>CreationDateTime</th>\n",
" <th>CubeSize</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>2016-12-03 00:33:17</th>\n",
" <td>58.520550</td>\n",
" <td>6.275233</td>\n",
" <td>0000000f</td>\n",
" <td>21.67</td>\n",
" <td>0.256</td>\n",
" <td>133.525</td>\n",
" <td>173.2</td>\n",
" <td>12.8</td>\n",
" <td>285.0</td>\n",
" <td>0.4</td>\n",
" <td>0.1</td>\n",
" <td>5.99585</td>\n",
" <td>1.31954</td>\n",
" <td>1498136031000000000</td>\n",
" <td>256</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2016-12-03 00:33:17</th>\n",
" <td>58.527317</td>\n",
" <td>6.286800</td>\n",
" <td>0000000f</td>\n",
" <td>27.44</td>\n",
" <td>0.735</td>\n",
" <td>109.768</td>\n",
" <td>143.7</td>\n",
" <td>11.5</td>\n",
" <td>286.6</td>\n",
" <td>0.4</td>\n",
" <td>0.1</td>\n",
" <td>5.99585</td>\n",
" <td>1.31954</td>\n",
" <td>1498136031000000000</td>\n",
" <td>256</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2016-12-03 00:33:17</th>\n",
" <td>58.524450</td>\n",
" <td>6.277600</td>\n",
" <td>0000000f</td>\n",
" <td>27.77</td>\n",
" <td>0.971</td>\n",
" <td>115.934</td>\n",
" <td>167.4</td>\n",
" <td>12.7</td>\n",
" <td>284.5</td>\n",
" <td>0.4</td>\n",
" <td>0.1</td>\n",
" <td>5.99585</td>\n",
" <td>1.31954</td>\n",
" <td>1498136031000000000</td>\n",
" <td>256</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2016-12-03 00:35:08</th>\n",
" <td>58.527317</td>\n",
" <td>6.286800</td>\n",
" <td>0000000f</td>\n",
" <td>28.60</td>\n",
" <td>0.799</td>\n",
" <td>109.016</td>\n",
" <td>167.7</td>\n",
" <td>12.7</td>\n",
" <td>280.4</td>\n",
" <td>0.4</td>\n",
" <td>0.1</td>\n",
" <td>5.99585</td>\n",
" <td>1.31918</td>\n",
" <td>1498136065000000000</td>\n",
" <td>256</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2016-12-03 00:35:08</th>\n",
" <td>58.520550</td>\n",
" <td>6.275233</td>\n",
" <td>0000000f</td>\n",
" <td>20.99</td>\n",
" <td>0.321</td>\n",
" <td>138.320</td>\n",
" <td>112.0</td>\n",
" <td>9.2</td>\n",
" <td>278.1</td>\n",
" <td>0.4</td>\n",
" <td>0.1</td>\n",
" <td>5.99585</td>\n",
" <td>1.31918</td>\n",
" <td>1498136065000000000</td>\n",
" <td>256</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2016-12-03 00:35:08</th>\n",
" <td>58.524450</td>\n",
" <td>6.277600</td>\n",
" <td>0000000f</td>\n",
" <td>26.71</td>\n",
" <td>0.842</td>\n",
" <td>116.182</td>\n",
" <td>133.6</td>\n",
" <td>11.1</td>\n",
" <td>280.8</td>\n",
" <td>0.4</td>\n",
" <td>0.1</td>\n",
" <td>5.99585</td>\n",
" <td>1.31918</td>\n",
" <td>1498136065000000000</td>\n",
" <td>256</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2016-12-03 00:50:35</th>\n",
" <td>58.527317</td>\n",
" <td>6.286800</td>\n",
" <td>0000000f</td>\n",
" <td>30.08</td>\n",
" <td>0.911</td>\n",
" <td>107.517</td>\n",
" <td>170.5</td>\n",
" <td>12.6</td>\n",
" <td>283.0</td>\n",
" <td>0.4</td>\n",
" <td>0.1</td>\n",
" <td>5.99585</td>\n",
" <td>1.31855</td>\n",
" <td>1498136116000000000</td>\n",
" <td>256</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2016-12-03 00:50:35</th>\n",
" <td>58.520550</td>\n",
" <td>6.275233</td>\n",
" <td>0000000f</td>\n",
" <td>20.71</td>\n",
" <td>0.397</td>\n",
" <td>153.162</td>\n",
" <td>165.7</td>\n",
" <td>13.3</td>\n",
" <td>278.3</td>\n",
" <td>0.4</td>\n",
" <td>0.1</td>\n",
" <td>5.99585</td>\n",
" <td>1.31855</td>\n",
" <td>1498136116000000000</td>\n",
" <td>256</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2016-12-03 00:50:35</th>\n",
" <td>58.524450</td>\n",
" <td>6.277600</td>\n",
" <td>0000000f</td>\n",
" <td>27.08</td>\n",
" <td>0.849</td>\n",
" <td>116.841</td>\n",
" <td>154.4</td>\n",
" <td>12.2</td>\n",
" <td>276.0</td>\n",
" <td>0.4</td>\n",
" <td>0.1</td>\n",
" <td>5.99585</td>\n",
" <td>1.31855</td>\n",
" <td>1498136116000000000</td>\n",
" <td>256</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2016-12-03 00:52:25</th>\n",
" <td>58.527317</td>\n",
" <td>6.286800</td>\n",
" <td>0000000f</td>\n",
" <td>30.12</td>\n",
" <td>0.914</td>\n",
" <td>106.732</td>\n",
" <td>162.7</td>\n",
" <td>12.5</td>\n",
" <td>269.4</td>\n",
" <td>0.4</td>\n",
" <td>0.1</td>\n",
" <td>5.99585</td>\n",
" <td>1.31859</td>\n",
" <td>1498136150000000000</td>\n",
" <td>256</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2016-12-03 00:52:25</th>\n",
" <td>58.520550</td>\n",
" <td>6.275233</td>\n",
" <td>0000000f</td>\n",
" <td>20.40</td>\n",
" <td>0.451</td>\n",
" <td>151.722</td>\n",
" <td>175.6</td>\n",
" <td>13.1</td>\n",
" <td>279.4</td>\n",
" <td>0.4</td>\n",
" <td>0.1</td>\n",
" <td>5.99585</td>\n",
" <td>1.31859</td>\n",
" <td>1498136150000000000</td>\n",
" <td>256</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2016-12-03 00:52:25</th>\n",
" <td>58.524450</td>\n",
" <td>6.277600</td>\n",
" <td>0000000f</td>\n",
" <td>26.77</td>\n",
" <td>0.868</td>\n",
" <td>116.506</td>\n",
" <td>173.1</td>\n",
" <td>12.7</td>\n",
" <td>282.6</td>\n",
" <td>0.4</td>\n",
" <td>0.1</td>\n",
" <td>5.99585</td>\n",
" <td>1.31859</td>\n",
" <td>1498136150000000000</td>\n",
" <td>256</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2016-12-03 01:07:24</th>\n",
" <td>58.527317</td>\n",
" <td>6.286800</td>\n",
" <td>0000000f</td>\n",
" <td>29.23</td>\n",
" <td>0.942</td>\n",
" <td>110.023</td>\n",
" <td>146.4</td>\n",
" <td>11.7</td>\n",
" <td>281.7</td>\n",
" <td>0.4</td>\n",
" <td>0.1</td>\n",
" <td>5.99585</td>\n",
" <td>1.31991</td>\n",
" <td>1498136194000000000</td>\n",
" <td>256</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2016-12-03 01:07:24</th>\n",
" <td>58.520550</td>\n",
" <td>6.275233</td>\n",
" <td>0000000f</td>\n",
" <td>20.65</td>\n",
" <td>0.380</td>\n",
" <td>164.499</td>\n",
" <td>136.1</td>\n",
" <td>11.0</td>\n",
" <td>275.1</td>\n",
" <td>0.4</td>\n",
" <td>0.1</td>\n",
" <td>5.99585</td>\n",
" <td>1.31991</td>\n",
" <td>1498136194000000000</td>\n",
" <td>256</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2016-12-03 01:07:24</th>\n",
" <td>58.524450</td>\n",
" <td>6.277600</td>\n",
" <td>0000000f</td>\n",
" <td>25.80</td>\n",
" <td>1.021</td>\n",
" <td>121.082</td>\n",
" <td>156.5</td>\n",
" <td>12.6</td>\n",
" <td>288.4</td>\n",
" <td>0.4</td>\n",
" <td>0.1</td>\n",
" <td>5.99585</td>\n",
" <td>1.31991</td>\n",
" <td>1498136194000000000</td>\n",
" <td>256</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2016-12-03 01:24:27</th>\n",
" <td>58.520550</td>\n",
" <td>6.275233</td>\n",
" <td>0000000f</td>\n",
" <td>20.74</td>\n",
" <td>0.440</td>\n",
" <td>157.633</td>\n",
" <td>145.9</td>\n",
" <td>11.2</td>\n",
" <td>272.0</td>\n",
" <td>0.4</td>\n",
" <td>0.1</td>\n",
" <td>5.99585</td>\n",
" <td>1.32097</td>\n",
" <td>1498136275000000000</td>\n",
" <td>256</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2016-12-03 01:24:27</th>\n",
" <td>58.527317</td>\n",
" <td>6.286800</td>\n",
" <td>0000000f</td>\n",
" <td>28.67</td>\n",
" <td>1.077</td>\n",
" <td>112.159</td>\n",
" <td>149.4</td>\n",
" <td>11.8</td>\n",
" <td>275.7</td>\n",
" <td>0.4</td>\n",
" <td>0.1</td>\n",
" <td>5.99585</td>\n",
" <td>1.32097</td>\n",
" <td>1498136275000000000</td>\n",
" <td>256</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2016-12-03 01:24:27</th>\n",
" <td>58.524450</td>\n",
" <td>6.277600</td>\n",
" <td>0000000f</td>\n",
" <td>23.92</td>\n",
" <td>0.763</td>\n",
" <td>135.066</td>\n",
" <td>139.2</td>\n",
" <td>11.0</td>\n",
" <td>268.0</td>\n",
" <td>0.4</td>\n",
" <td>0.1</td>\n",
" <td>5.99585</td>\n",
" <td>1.32097</td>\n",
" <td>1498136275000000000</td>\n",
" <td>256</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2016-12-03 01:41:31</th>\n",
" <td>58.520550</td>\n",
" <td>6.275233</td>\n",
" <td>0000000f</td>\n",
" <td>19.71</td>\n",
" <td>0.432</td>\n",
" <td>158.659</td>\n",
" <td>170.0</td>\n",
" <td>12.3</td>\n",
" <td>18.4</td>\n",
" <td>0.4</td>\n",
" <td>0.1</td>\n",
" <td>5.99585</td>\n",
" <td>1.32092</td>\n",
" <td>1498136360000000000</td>\n",
" <td>256</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2016-12-03 01:41:31</th>\n",
" <td>58.524450</td>\n",
" <td>6.277600</td>\n",
" <td>0000000f</td>\n",
" <td>22.11</td>\n",
" <td>0.692</td>\n",
" <td>141.015</td>\n",
" <td>157.3</td>\n",
" <td>12.3</td>\n",
" <td>278.3</td>\n",
" <td>0.4</td>\n",
" <td>0.1</td>\n",
" <td>5.99585</td>\n",
" <td>1.32092</td>\n",
" <td>1498136360000000000</td>\n",
" <td>256</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2016-12-03 01:41:31</th>\n",
" <td>58.527317</td>\n",
" <td>6.286800</td>\n",
" <td>0000000f</td>\n",
" <td>26.34</td>\n",
" <td>0.796</td>\n",
" <td>126.823</td>\n",
" <td>128.8</td>\n",
" <td>10.0</td>\n",
" <td>277.9</td>\n",
" <td>0.4</td>\n",
" <td>0.1</td>\n",
" <td>5.99585</td>\n",
" <td>1.32092</td>\n",
" <td>1498136360000000000</td>\n",
" <td>256</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2016-12-03 01:58:35</th>\n",
" <td>58.520550</td>\n",
" <td>6.275233</td>\n",
" <td>0000000f</td>\n",
" <td>20.29</td>\n",
" <td>0.405</td>\n",
" <td>167.467</td>\n",
" <td>157.8</td>\n",
" <td>12.2</td>\n",
" <td>276.6</td>\n",
" <td>0.4</td>\n",
" <td>0.1</td>\n",
" <td>5.99585</td>\n",
" <td>1.32080</td>\n",
" <td>1498136445000000000</td>\n",
" <td>256</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2016-12-03 01:58:35</th>\n",
" <td>58.527317</td>\n",
" <td>6.286800</td>\n",
" <td>0000000f</td>\n",
" <td>25.87</td>\n",
" <td>0.696</td>\n",
" <td>133.567</td>\n",
" <td>143.7</td>\n",
" <td>10.8</td>\n",
" <td>267.8</td>\n",
" <td>0.4</td>\n",
" <td>0.1</td>\n",
" <td>5.99585</td>\n",
" <td>1.32080</td>\n",
" <td>1498136445000000000</td>\n",
" <td>256</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2016-12-03 01:58:35</th>\n",
" <td>58.524450</td>\n",
" <td>6.277600</td>\n",
" <td>0000000f</td>\n",
" <td>22.04</td>\n",
" <td>0.498</td>\n",
" <td>158.712</td>\n",
" <td>156.0</td>\n",
" <td>12.0</td>\n",
" <td>273.5</td>\n",
" <td>0.4</td>\n",
" <td>0.1</td>\n",
" <td>5.99585</td>\n",
" <td>1.32080</td>\n",
" <td>1498136445000000000</td>\n",
" <td>256</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2016-12-03 02:15:37</th>\n",
" <td>58.527317</td>\n",
" <td>6.286800</td>\n",
" <td>0000000f</td>\n",
" <td>24.89</td>\n",
" <td>0.600</td>\n",
" <td>148.608</td>\n",
" <td>147.9</td>\n",
" <td>11.4</td>\n",
" <td>272.2</td>\n",
" <td>0.4</td>\n",
" <td>0.1</td>\n",
" <td>5.99585</td>\n",
" <td>1.32116</td>\n",
" <td>1498136532000000000</td>\n",
" <td>256</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2016-12-03 02:15:37</th>\n",
" <td>58.524450</td>\n",
" <td>6.277600</td>\n",
" <td>0000000f</td>\n",
" <td>21.84</td>\n",
" <td>0.515</td>\n",
" <td>158.520</td>\n",
" <td>118.5</td>\n",
" <td>9.5</td>\n",
" <td>296.5</td>\n",
" <td>0.4</td>\n",
" <td>0.1</td>\n",
" <td>5.99585</td>\n",
" <td>1.32116</td>\n",
" <td>1498136532000000000</td>\n",
" <td>256</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2016-12-03 02:15:37</th>\n",
" <td>58.520550</td>\n",
" <td>6.275233</td>\n",
" <td>0000000f</td>\n",
" <td>20.77</td>\n",
" <td>0.410</td>\n",
" <td>177.821</td>\n",
" <td>149.4</td>\n",
" <td>12.2</td>\n",
" <td>278.8</td>\n",
" <td>0.4</td>\n",
" <td>0.1</td>\n",
" <td>5.99585</td>\n",
" <td>1.32116</td>\n",
" <td>1498136532000000000</td>\n",
" <td>256</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2016-12-03 02:32:42</th>\n",
" <td>58.520550</td>\n",
" <td>6.275233</td>\n",
" <td>0000000f</td>\n",
" <td>20.35</td>\n",
" <td>0.430</td>\n",
" <td>193.190</td>\n",
" <td>151.4</td>\n",
" <td>11.7</td>\n",
" <td>286.8</td>\n",
" <td>0.4</td>\n",
" <td>0.1</td>\n",
" <td>5.99585</td>\n",
" <td>1.31977</td>\n",
" <td>1498136627000000000</td>\n",
" <td>256</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2016-12-03 02:32:42</th>\n",
" <td>58.524450</td>\n",
" <td>6.277600</td>\n",
" <td>0000000f</td>\n",
" <td>21.89</td>\n",
" <td>0.422</td>\n",
" <td>181.565</td>\n",
" <td>151.5</td>\n",
" <td>11.5</td>\n",
" <td>287.1</td>\n",
" <td>0.4</td>\n",
" <td>0.1</td>\n",
" <td>5.99585</td>\n",
" <td>1.31977</td>\n",
" <td>1498136627000000000</td>\n",
" <td>256</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2016-12-03 02:32:42</th>\n",
" <td>58.527317</td>\n",
" <td>6.286800</td>\n",
" <td>0000000f</td>\n",
" <td>24.83</td>\n",
" <td>0.491</td>\n",
" <td>164.899</td>\n",
" <td>144.3</td>\n",
" <td>10.6</td>\n",
" <td>291.6</td>\n",
" <td>0.4</td>\n",
" <td>0.1</td>\n",
" <td>5.99585</td>\n",
" <td>1.31977</td>\n",
" <td>1498136627000000000</td>\n",
" <td>256</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2016-12-25 07:08:49</th>\n",
" <td>58.524450</td>\n",
" <td>6.277600</td>\n",
" <td>0000000f</td>\n",
" <td>24.33</td>\n",
" <td>0.579</td>\n",
" <td>214.735</td>\n",
" <td>213.7</td>\n",
" <td>15.5</td>\n",
" <td>293.6</td>\n",
" <td>0.4</td>\n",
" <td>0.1</td>\n",
" <td>5.99585</td>\n",
" <td>1.31710</td>\n",
" <td>1497540732000000000</td>\n",
" <td>256</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2016-12-25 07:08:49</th>\n",
" <td>58.527317</td>\n",
" <td>6.286800</td>\n",
" <td>0000000f</td>\n",
" <td>25.61</td>\n",
" <td>0.513</td>\n",
" <td>208.205</td>\n",
" <td>210.5</td>\n",
" <td>14.4</td>\n",
" <td>291.1</td>\n",
" <td>0.4</td>\n",
" <td>0.1</td>\n",
" <td>5.99585</td>\n",
" <td>1.31710</td>\n",
" <td>1497540732000000000</td>\n",
" <td>256</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2016-12-25 07:25:53</th>\n",
" <td>58.520550</td>\n",
" <td>6.275233</td>\n",
" <td>0000000f</td>\n",
" <td>21.87</td>\n",
" <td>0.481</td>\n",
" <td>185.178</td>\n",
" <td>192.0</td>\n",
" <td>13.8</td>\n",
" <td>287.5</td>\n",
" <td>0.4</td>\n",
" <td>0.1</td>\n",
" <td>5.99585</td>\n",
" <td>1.31817</td>\n",
" <td>1497540866000000000</td>\n",
" <td>256</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2016-12-25 08:03:06</th>\n",
" <td>58.524450</td>\n",
" <td>6.277600</td>\n",
" <td>0000000f</td>\n",
" <td>23.82</td>\n",
" <td>0.518</td>\n",
" <td>205.898</td>\n",
" <td>185.0</td>\n",
" <td>13.5</td>\n",
" <td>280.3</td>\n",
" <td>0.4</td>\n",
" <td>0.1</td>\n",
" <td>5.99585</td>\n",
" <td>1.31798</td>\n",
" <td>1497541192000000000</td>\n",
" <td>256</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2016-12-25 08:03:06</th>\n",
" <td>58.524450</td>\n",
" <td>6.277600</td>\n",
" <td>0000000f</td>\n",
" <td>23.82</td>\n",
" <td>0.518</td>\n",
" <td>205.898</td>\n",
" <td>185.0</td>\n",
" <td>13.5</td>\n",
" <td>280.3</td>\n",
" <td>0.4</td>\n",
" <td>0.1</td>\n",
" <td>5.99585</td>\n",
" <td>1.31798</td>\n",
" <td>1497541192000000000</td>\n",
" <td>256</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2016-12-25 08:03:06</th>\n",
" <td>58.524450</td>\n",
" <td>6.277600</td>\n",
" <td>0000000f</td>\n",
" <td>23.82</td>\n",
" <td>0.518</td>\n",
" <td>205.898</td>\n",
" <td>185.0</td>\n",
" <td>13.5</td>\n",
" <td>280.3</td>\n",
" <td>0.4</td>\n",
" <td>0.1</td>\n",
" <td>5.99585</td>\n",
" <td>1.31798</td>\n",
" <td>1497541192000000000</td>\n",
" <td>256</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2016-12-25 08:03:06</th>\n",
" <td>58.527317</td>\n",
" <td>6.286800</td>\n",
" <td>0000000f</td>\n",
" <td>23.21</td>\n",
" <td>0.428</td>\n",
" <td>200.452</td>\n",
" <td>208.3</td>\n",
" <td>14.6</td>\n",
" <td>296.5</td>\n",
" <td>0.4</td>\n",
" <td>0.1</td>\n",
" <td>5.99585</td>\n",
" <td>1.31798</td>\n",
" <td>1497541192000000000</td>\n",
" <td>256</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2016-12-25 08:03:06</th>\n",
" <td>58.527317</td>\n",
" <td>6.286800</td>\n",
" <td>0000000f</td>\n",
" <td>23.21</td>\n",
" <td>0.428</td>\n",
" <td>200.452</td>\n",
" <td>208.3</td>\n",
" <td>14.6</td>\n",
" <td>296.5</td>\n",
" <td>0.4</td>\n",
" <td>0.1</td>\n",
" <td>5.99585</td>\n",
" <td>1.31798</td>\n",
" <td>1497541192000000000</td>\n",
" <td>256</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2016-12-25 08:03:06</th>\n",
" <td>58.527317</td>\n",
" <td>6.286800</td>\n",
" <td>0000000f</td>\n",
" <td>23.21</td>\n",
" <td>0.428</td>\n",
" <td>200.452</td>\n",
" <td>208.3</td>\n",
" <td>14.6</td>\n",
" <td>296.5</td>\n",
" <td>0.4</td>\n",
" <td>0.1</td>\n",
" <td>5.99585</td>\n",
" <td>1.31798</td>\n",
" <td>1497541192000000000</td>\n",
" <td>256</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2016-12-25 08:17:04</th>\n",
" <td>58.524450</td>\n",
" <td>6.277600</td>\n",
" <td>0000000f</td>\n",
" <td>22.21</td>\n",
" <td>0.499</td>\n",
" <td>204.213</td>\n",
" <td>206.8</td>\n",
" <td>14.6</td>\n",
" <td>295.1</td>\n",
" <td>0.4</td>\n",
" <td>0.1</td>\n",
" <td>5.99585</td>\n",
" <td>1.31784</td>\n",
" <td>1497541279000000000</td>\n",
" <td>256</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2016-12-25 08:17:04</th>\n",
" <td>58.527317</td>\n",
" <td>6.286800</td>\n",
" <td>0000000f</td>\n",
" <td>22.86</td>\n",
" <td>0.403</td>\n",
" <td>202.483</td>\n",
" <td>205.9</td>\n",
" <td>14.5</td>\n",
" <td>294.6</td>\n",
" <td>0.4</td>\n",
" <td>0.1</td>\n",
" <td>5.99585</td>\n",
" <td>1.31784</td>\n",
" <td>1497541279000000000</td>\n",
" <td>256</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2016-12-25 08:17:04</th>\n",
" <td>58.520550</td>\n",
" <td>6.275233</td>\n",
" <td>0000000f</td>\n",
" <td>21.00</td>\n",
" <td>0.453</td>\n",
" <td>185.929</td>\n",
" <td>206.9</td>\n",
" <td>15.0</td>\n",
" <td>294.9</td>\n",
" <td>0.4</td>\n",
" <td>0.1</td>\n",
" <td>5.99585</td>\n",
" <td>1.31784</td>\n",
" <td>1497541279000000000</td>\n",
" <td>256</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2016-12-25 08:18:56</th>\n",
" <td>58.527317</td>\n",
" <td>6.286800</td>\n",
" <td>0000000f</td>\n",
" <td>21.16</td>\n",
" <td>0.444</td>\n",
" <td>201.162</td>\n",
" <td>228.2</td>\n",
" <td>16.6</td>\n",
" <td>297.6</td>\n",
" <td>0.4</td>\n",
" <td>0.1</td>\n",
" <td>5.99585</td>\n",
" <td>1.31924</td>\n",
" <td>1497541311000000000</td>\n",
" <td>256</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2016-12-25 08:18:56</th>\n",
" <td>58.524450</td>\n",
" <td>6.277600</td>\n",
" <td>0000000f</td>\n",
" <td>23.60</td>\n",
" <td>0.550</td>\n",
" <td>208.037</td>\n",
" <td>214.3</td>\n",
" <td>15.0</td>\n",
" <td>290.3</td>\n",
" <td>0.4</td>\n",
" <td>0.1</td>\n",
" <td>5.99585</td>\n",
" <td>1.31924</td>\n",
" <td>1497541311000000000</td>\n",
" <td>256</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2016-12-25 08:18:56</th>\n",
" <td>58.520550</td>\n",
" <td>6.275233</td>\n",
" <td>0000000f</td>\n",
" <td>21.83</td>\n",
" <td>0.445</td>\n",
" <td>190.203</td>\n",
" <td>194.2</td>\n",
" <td>14.1</td>\n",
" <td>287.9</td>\n",
" <td>0.4</td>\n",
" <td>0.1</td>\n",
" <td>5.99585</td>\n",
" <td>1.31924</td>\n",
" <td>1497541311000000000</td>\n",
" <td>256</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2016-12-25 08:34:08</th>\n",
" <td>58.527317</td>\n",
" <td>6.286800</td>\n",
" <td>0000000f</td>\n",
" <td>23.39</td>\n",
" <td>0.436</td>\n",
" <td>201.308</td>\n",
" <td>219.4</td>\n",
" <td>15.1</td>\n",
" <td>287.0</td>\n",
" <td>0.4</td>\n",
" <td>0.1</td>\n",
" <td>5.99585</td>\n",
" <td>1.31780</td>\n",
" <td>1497541421000000000</td>\n",
" <td>256</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2016-12-25 08:34:08</th>\n",
" <td>58.520550</td>\n",
" <td>6.275233</td>\n",
" <td>0000000f</td>\n",
" <td>21.08</td>\n",
" <td>0.459</td>\n",
" <td>189.587</td>\n",
" <td>194.2</td>\n",
" <td>15.3</td>\n",
" <td>289.1</td>\n",
" <td>0.4</td>\n",
" <td>0.1</td>\n",
" <td>5.99585</td>\n",
" <td>1.31780</td>\n",
" <td>1497541421000000000</td>\n",
" <td>256</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2016-12-25 08:34:08</th>\n",
" <td>58.524450</td>\n",
" <td>6.277600</td>\n",
" <td>0000000f</td>\n",
" <td>24.33</td>\n",
" <td>0.550</td>\n",
" <td>211.248</td>\n",
" <td>204.0</td>\n",
" <td>14.8</td>\n",
" <td>291.0</td>\n",
" <td>0.4</td>\n",
" <td>0.1</td>\n",
" <td>5.99585</td>\n",
" <td>1.31780</td>\n",
" <td>1497541421000000000</td>\n",
" <td>256</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2016-12-25 08:35:58</th>\n",
" <td>58.524450</td>\n",
" <td>6.277600</td>\n",
" <td>0000000f</td>\n",
" <td>24.43</td>\n",
" <td>0.516</td>\n",
" <td>207.098</td>\n",
" <td>207.1</td>\n",
" <td>15.0</td>\n",
" <td>298.9</td>\n",
" <td>0.4</td>\n",
" <td>0.1</td>\n",
" <td>5.99585</td>\n",
" <td>1.31857</td>\n",
" <td>1497541454000000000</td>\n",
" <td>256</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2016-12-25 08:35:58</th>\n",
" <td>58.527317</td>\n",
" <td>6.286800</td>\n",
" <td>0000000f</td>\n",
" <td>22.62</td>\n",
" <td>0.416</td>\n",
" <td>199.502</td>\n",
" <td>177.1</td>\n",
" <td>13.0</td>\n",
" <td>288.9</td>\n",
" <td>0.4</td>\n",
" <td>0.1</td>\n",
" <td>5.99585</td>\n",
" <td>1.31857</td>\n",
" <td>1497541454000000000</td>\n",
" <td>256</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2016-12-25 08:51:11</th>\n",
" <td>58.520550</td>\n",
" <td>6.275233</td>\n",
" <td>0000000f</td>\n",
" <td>21.94</td>\n",
" <td>0.453</td>\n",
" <td>197.264</td>\n",
" <td>200.3</td>\n",
" <td>14.5</td>\n",
" <td>300.3</td>\n",
" <td>0.4</td>\n",
" <td>0.1</td>\n",
" <td>5.99585</td>\n",
" <td>1.31711</td>\n",
" <td>1497541563000000000</td>\n",
" <td>256</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2016-12-25 08:51:11</th>\n",
" <td>58.524450</td>\n",
" <td>6.277600</td>\n",
" <td>0000000f</td>\n",
" <td>24.04</td>\n",
" <td>0.531</td>\n",
" <td>213.064</td>\n",
" <td>211.7</td>\n",
" <td>15.1</td>\n",
" <td>302.5</td>\n",
" <td>0.4</td>\n",
" <td>0.1</td>\n",
" <td>5.99585</td>\n",
" <td>1.31711</td>\n",
" <td>1497541563000000000</td>\n",
" <td>256</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2016-12-25 09:08:15</th>\n",
" <td>58.527317</td>\n",
" <td>6.286800</td>\n",
" <td>0000000f</td>\n",
" <td>22.11</td>\n",
" <td>0.447</td>\n",
" <td>208.415</td>\n",
" <td>220.3</td>\n",
" <td>16.9</td>\n",
" <td>296.9</td>\n",
" <td>0.4</td>\n",
" <td>0.1</td>\n",
" <td>5.99585</td>\n",
" <td>1.31691</td>\n",
" <td>1497541707000000000</td>\n",
" <td>256</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2016-12-25 09:08:15</th>\n",
" <td>58.524450</td>\n",
" <td>6.277600</td>\n",
" <td>0000000f</td>\n",
" <td>22.75</td>\n",
" <td>0.522</td>\n",
" <td>213.661</td>\n",
" <td>201.5</td>\n",
" <td>15.5</td>\n",
" <td>292.1</td>\n",
" <td>0.4</td>\n",
" <td>0.1</td>\n",
" <td>5.99585</td>\n",
" <td>1.31691</td>\n",
" <td>1497541707000000000</td>\n",
" <td>256</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2016-12-25 09:28:48</th>\n",
" <td>58.520550</td>\n",
" <td>6.275233</td>\n",
" <td>0000000f</td>\n",
" <td>22.42</td>\n",
" <td>0.510</td>\n",
" <td>206.823</td>\n",
" <td>188.8</td>\n",
" <td>14.0</td>\n",
" <td>303.1</td>\n",
" <td>0.4</td>\n",
" <td>0.1</td>\n",
" <td>5.99585</td>\n",
" <td>1.31861</td>\n",
" <td>1497541910000000000</td>\n",
" <td>256</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2016-12-25 09:28:48</th>\n",
" <td>58.524450</td>\n",
" <td>6.277600</td>\n",
" <td>0000000f</td>\n",
" <td>23.12</td>\n",
" <td>0.543</td>\n",
" <td>221.257</td>\n",
" <td>197.4</td>\n",
" <td>14.4</td>\n",
" <td>287.6</td>\n",
" <td>0.4</td>\n",
" <td>0.1</td>\n",
" <td>5.99585</td>\n",
" <td>1.31861</td>\n",
" <td>1497541910000000000</td>\n",
" <td>256</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2016-12-25 09:28:48</th>\n",
" <td>58.524450</td>\n",
" <td>6.277600</td>\n",
" <td>0000000f</td>\n",
" <td>23.12</td>\n",
" <td>0.543</td>\n",
" <td>221.257</td>\n",
" <td>197.4</td>\n",
" <td>14.4</td>\n",
" <td>287.6</td>\n",
" <td>0.4</td>\n",
" <td>0.1</td>\n",
" <td>5.99585</td>\n",
" <td>1.31861</td>\n",
" <td>1497541910000000000</td>\n",
" <td>256</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2016-12-25 09:28:48</th>\n",
" <td>58.520550</td>\n",
" <td>6.275233</td>\n",
" <td>0000000f</td>\n",
" <td>22.42</td>\n",
" <td>0.510</td>\n",
" <td>206.823</td>\n",
" <td>188.8</td>\n",
" <td>14.0</td>\n",
" <td>303.1</td>\n",
" <td>0.4</td>\n",
" <td>0.1</td>\n",
" <td>5.99585</td>\n",
" <td>1.31861</td>\n",
" <td>1497541910000000000</td>\n",
" <td>256</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2016-12-25 09:42:22</th>\n",
" <td>58.527317</td>\n",
" <td>6.286800</td>\n",
" <td>0000000f</td>\n",
" <td>25.56</td>\n",
" <td>0.507</td>\n",
" <td>222.027</td>\n",
" <td>203.3</td>\n",
" <td>13.9</td>\n",
" <td>291.1</td>\n",
" <td>0.4</td>\n",
" <td>0.1</td>\n",
" <td>5.99585</td>\n",
" <td>1.31706</td>\n",
" <td>1497541989000000000</td>\n",
" <td>256</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2016-12-25 09:42:22</th>\n",
" <td>58.520550</td>\n",
" <td>6.275233</td>\n",
" <td>0000000f</td>\n",
" <td>22.47</td>\n",
" <td>0.593</td>\n",
" <td>211.687</td>\n",
" <td>207.1</td>\n",
" <td>15.4</td>\n",
" <td>288.8</td>\n",
" <td>0.4</td>\n",
" <td>0.1</td>\n",
" <td>5.99585</td>\n",
" <td>1.31706</td>\n",
" <td>1497541989000000000</td>\n",
" <td>256</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>825 rows × 15 columns</p>\n",
"</div>"
],
"text/plain": [
" Lat Lon Status Depth Current CAngle \\\n",
"2016-12-03 00:33:17 58.520550 6.275233 0000000f 21.67 0.256 133.525 \n",
"2016-12-03 00:33:17 58.527317 6.286800 0000000f 27.44 0.735 109.768 \n",
"2016-12-03 00:33:17 58.524450 6.277600 0000000f 27.77 0.971 115.934 \n",
"2016-12-03 00:35:08 58.527317 6.286800 0000000f 28.60 0.799 109.016 \n",
"2016-12-03 00:35:08 58.520550 6.275233 0000000f 20.99 0.321 138.320 \n",
"2016-12-03 00:35:08 58.524450 6.277600 0000000f 26.71 0.842 116.182 \n",
"2016-12-03 00:50:35 58.527317 6.286800 0000000f 30.08 0.911 107.517 \n",
"2016-12-03 00:50:35 58.520550 6.275233 0000000f 20.71 0.397 153.162 \n",
"2016-12-03 00:50:35 58.524450 6.277600 0000000f 27.08 0.849 116.841 \n",
"2016-12-03 00:52:25 58.527317 6.286800 0000000f 30.12 0.914 106.732 \n",
"2016-12-03 00:52:25 58.520550 6.275233 0000000f 20.40 0.451 151.722 \n",
"2016-12-03 00:52:25 58.524450 6.277600 0000000f 26.77 0.868 116.506 \n",
"2016-12-03 01:07:24 58.527317 6.286800 0000000f 29.23 0.942 110.023 \n",
"2016-12-03 01:07:24 58.520550 6.275233 0000000f 20.65 0.380 164.499 \n",
"2016-12-03 01:07:24 58.524450 6.277600 0000000f 25.80 1.021 121.082 \n",
"2016-12-03 01:24:27 58.520550 6.275233 0000000f 20.74 0.440 157.633 \n",
"2016-12-03 01:24:27 58.527317 6.286800 0000000f 28.67 1.077 112.159 \n",
"2016-12-03 01:24:27 58.524450 6.277600 0000000f 23.92 0.763 135.066 \n",
"2016-12-03 01:41:31 58.520550 6.275233 0000000f 19.71 0.432 158.659 \n",
"2016-12-03 01:41:31 58.524450 6.277600 0000000f 22.11 0.692 141.015 \n",
"2016-12-03 01:41:31 58.527317 6.286800 0000000f 26.34 0.796 126.823 \n",
"2016-12-03 01:58:35 58.520550 6.275233 0000000f 20.29 0.405 167.467 \n",
"2016-12-03 01:58:35 58.527317 6.286800 0000000f 25.87 0.696 133.567 \n",
"2016-12-03 01:58:35 58.524450 6.277600 0000000f 22.04 0.498 158.712 \n",
"2016-12-03 02:15:37 58.527317 6.286800 0000000f 24.89 0.600 148.608 \n",
"2016-12-03 02:15:37 58.524450 6.277600 0000000f 21.84 0.515 158.520 \n",
"2016-12-03 02:15:37 58.520550 6.275233 0000000f 20.77 0.410 177.821 \n",
"2016-12-03 02:32:42 58.520550 6.275233 0000000f 20.35 0.430 193.190 \n",
"2016-12-03 02:32:42 58.524450 6.277600 0000000f 21.89 0.422 181.565 \n",
"2016-12-03 02:32:42 58.527317 6.286800 0000000f 24.83 0.491 164.899 \n",
"... ... ... ... ... ... ... \n",
"2016-12-25 07:08:49 58.524450 6.277600 0000000f 24.33 0.579 214.735 \n",
"2016-12-25 07:08:49 58.527317 6.286800 0000000f 25.61 0.513 208.205 \n",
"2016-12-25 07:25:53 58.520550 6.275233 0000000f 21.87 0.481 185.178 \n",
"2016-12-25 08:03:06 58.524450 6.277600 0000000f 23.82 0.518 205.898 \n",
"2016-12-25 08:03:06 58.524450 6.277600 0000000f 23.82 0.518 205.898 \n",
"2016-12-25 08:03:06 58.524450 6.277600 0000000f 23.82 0.518 205.898 \n",
"2016-12-25 08:03:06 58.527317 6.286800 0000000f 23.21 0.428 200.452 \n",
"2016-12-25 08:03:06 58.527317 6.286800 0000000f 23.21 0.428 200.452 \n",
"2016-12-25 08:03:06 58.527317 6.286800 0000000f 23.21 0.428 200.452 \n",
"2016-12-25 08:17:04 58.524450 6.277600 0000000f 22.21 0.499 204.213 \n",
"2016-12-25 08:17:04 58.527317 6.286800 0000000f 22.86 0.403 202.483 \n",
"2016-12-25 08:17:04 58.520550 6.275233 0000000f 21.00 0.453 185.929 \n",
"2016-12-25 08:18:56 58.527317 6.286800 0000000f 21.16 0.444 201.162 \n",
"2016-12-25 08:18:56 58.524450 6.277600 0000000f 23.60 0.550 208.037 \n",
"2016-12-25 08:18:56 58.520550 6.275233 0000000f 21.83 0.445 190.203 \n",
"2016-12-25 08:34:08 58.527317 6.286800 0000000f 23.39 0.436 201.308 \n",
"2016-12-25 08:34:08 58.520550 6.275233 0000000f 21.08 0.459 189.587 \n",
"2016-12-25 08:34:08 58.524450 6.277600 0000000f 24.33 0.550 211.248 \n",
"2016-12-25 08:35:58 58.524450 6.277600 0000000f 24.43 0.516 207.098 \n",
"2016-12-25 08:35:58 58.527317 6.286800 0000000f 22.62 0.416 199.502 \n",
"2016-12-25 08:51:11 58.520550 6.275233 0000000f 21.94 0.453 197.264 \n",
"2016-12-25 08:51:11 58.524450 6.277600 0000000f 24.04 0.531 213.064 \n",
"2016-12-25 09:08:15 58.527317 6.286800 0000000f 22.11 0.447 208.415 \n",
"2016-12-25 09:08:15 58.524450 6.277600 0000000f 22.75 0.522 213.661 \n",
"2016-12-25 09:28:48 58.520550 6.275233 0000000f 22.42 0.510 206.823 \n",
"2016-12-25 09:28:48 58.524450 6.277600 0000000f 23.12 0.543 221.257 \n",
"2016-12-25 09:28:48 58.524450 6.277600 0000000f 23.12 0.543 221.257 \n",
"2016-12-25 09:28:48 58.520550 6.275233 0000000f 22.42 0.510 206.823 \n",
"2016-12-25 09:42:22 58.527317 6.286800 0000000f 25.56 0.507 222.027 \n",
"2016-12-25 09:42:22 58.520550 6.275233 0000000f 22.47 0.593 211.687 \n",
"\n",
" WaveLgth Period WAngle WaveHght Sigma RangeCell \\\n",
"2016-12-03 00:33:17 173.2 12.8 285.0 0.4 0.1 5.99585 \n",
"2016-12-03 00:33:17 143.7 11.5 286.6 0.4 0.1 5.99585 \n",
"2016-12-03 00:33:17 167.4 12.7 284.5 0.4 0.1 5.99585 \n",
"2016-12-03 00:35:08 167.7 12.7 280.4 0.4 0.1 5.99585 \n",
"2016-12-03 00:35:08 112.0 9.2 278.1 0.4 0.1 5.99585 \n",
"2016-12-03 00:35:08 133.6 11.1 280.8 0.4 0.1 5.99585 \n",
"2016-12-03 00:50:35 170.5 12.6 283.0 0.4 0.1 5.99585 \n",
"2016-12-03 00:50:35 165.7 13.3 278.3 0.4 0.1 5.99585 \n",
"2016-12-03 00:50:35 154.4 12.2 276.0 0.4 0.1 5.99585 \n",
"2016-12-03 00:52:25 162.7 12.5 269.4 0.4 0.1 5.99585 \n",
"2016-12-03 00:52:25 175.6 13.1 279.4 0.4 0.1 5.99585 \n",
"2016-12-03 00:52:25 173.1 12.7 282.6 0.4 0.1 5.99585 \n",
"2016-12-03 01:07:24 146.4 11.7 281.7 0.4 0.1 5.99585 \n",
"2016-12-03 01:07:24 136.1 11.0 275.1 0.4 0.1 5.99585 \n",
"2016-12-03 01:07:24 156.5 12.6 288.4 0.4 0.1 5.99585 \n",
"2016-12-03 01:24:27 145.9 11.2 272.0 0.4 0.1 5.99585 \n",
"2016-12-03 01:24:27 149.4 11.8 275.7 0.4 0.1 5.99585 \n",
"2016-12-03 01:24:27 139.2 11.0 268.0 0.4 0.1 5.99585 \n",
"2016-12-03 01:41:31 170.0 12.3 18.4 0.4 0.1 5.99585 \n",
"2016-12-03 01:41:31 157.3 12.3 278.3 0.4 0.1 5.99585 \n",
"2016-12-03 01:41:31 128.8 10.0 277.9 0.4 0.1 5.99585 \n",
"2016-12-03 01:58:35 157.8 12.2 276.6 0.4 0.1 5.99585 \n",
"2016-12-03 01:58:35 143.7 10.8 267.8 0.4 0.1 5.99585 \n",
"2016-12-03 01:58:35 156.0 12.0 273.5 0.4 0.1 5.99585 \n",
"2016-12-03 02:15:37 147.9 11.4 272.2 0.4 0.1 5.99585 \n",
"2016-12-03 02:15:37 118.5 9.5 296.5 0.4 0.1 5.99585 \n",
"2016-12-03 02:15:37 149.4 12.2 278.8 0.4 0.1 5.99585 \n",
"2016-12-03 02:32:42 151.4 11.7 286.8 0.4 0.1 5.99585 \n",
"2016-12-03 02:32:42 151.5 11.5 287.1 0.4 0.1 5.99585 \n",
"2016-12-03 02:32:42 144.3 10.6 291.6 0.4 0.1 5.99585 \n",
"... ... ... ... ... ... ... \n",
"2016-12-25 07:08:49 213.7 15.5 293.6 0.4 0.1 5.99585 \n",
"2016-12-25 07:08:49 210.5 14.4 291.1 0.4 0.1 5.99585 \n",
"2016-12-25 07:25:53 192.0 13.8 287.5 0.4 0.1 5.99585 \n",
"2016-12-25 08:03:06 185.0 13.5 280.3 0.4 0.1 5.99585 \n",
"2016-12-25 08:03:06 185.0 13.5 280.3 0.4 0.1 5.99585 \n",
"2016-12-25 08:03:06 185.0 13.5 280.3 0.4 0.1 5.99585 \n",
"2016-12-25 08:03:06 208.3 14.6 296.5 0.4 0.1 5.99585 \n",
"2016-12-25 08:03:06 208.3 14.6 296.5 0.4 0.1 5.99585 \n",
"2016-12-25 08:03:06 208.3 14.6 296.5 0.4 0.1 5.99585 \n",
"2016-12-25 08:17:04 206.8 14.6 295.1 0.4 0.1 5.99585 \n",
"2016-12-25 08:17:04 205.9 14.5 294.6 0.4 0.1 5.99585 \n",
"2016-12-25 08:17:04 206.9 15.0 294.9 0.4 0.1 5.99585 \n",
"2016-12-25 08:18:56 228.2 16.6 297.6 0.4 0.1 5.99585 \n",
"2016-12-25 08:18:56 214.3 15.0 290.3 0.4 0.1 5.99585 \n",
"2016-12-25 08:18:56 194.2 14.1 287.9 0.4 0.1 5.99585 \n",
"2016-12-25 08:34:08 219.4 15.1 287.0 0.4 0.1 5.99585 \n",
"2016-12-25 08:34:08 194.2 15.3 289.1 0.4 0.1 5.99585 \n",
"2016-12-25 08:34:08 204.0 14.8 291.0 0.4 0.1 5.99585 \n",
"2016-12-25 08:35:58 207.1 15.0 298.9 0.4 0.1 5.99585 \n",
"2016-12-25 08:35:58 177.1 13.0 288.9 0.4 0.1 5.99585 \n",
"2016-12-25 08:51:11 200.3 14.5 300.3 0.4 0.1 5.99585 \n",
"2016-12-25 08:51:11 211.7 15.1 302.5 0.4 0.1 5.99585 \n",
"2016-12-25 09:08:15 220.3 16.9 296.9 0.4 0.1 5.99585 \n",
"2016-12-25 09:08:15 201.5 15.5 292.1 0.4 0.1 5.99585 \n",
"2016-12-25 09:28:48 188.8 14.0 303.1 0.4 0.1 5.99585 \n",
"2016-12-25 09:28:48 197.4 14.4 287.6 0.4 0.1 5.99585 \n",
"2016-12-25 09:28:48 197.4 14.4 287.6 0.4 0.1 5.99585 \n",
"2016-12-25 09:28:48 188.8 14.0 303.1 0.4 0.1 5.99585 \n",
"2016-12-25 09:42:22 203.3 13.9 291.1 0.4 0.1 5.99585 \n",
"2016-12-25 09:42:22 207.1 15.4 288.8 0.4 0.1 5.99585 \n",
"\n",
" RotationTime CreationDateTime CubeSize \n",
"2016-12-03 00:33:17 1.31954 1498136031000000000 256 \n",
"2016-12-03 00:33:17 1.31954 1498136031000000000 256 \n",
"2016-12-03 00:33:17 1.31954 1498136031000000000 256 \n",
"2016-12-03 00:35:08 1.31918 1498136065000000000 256 \n",
"2016-12-03 00:35:08 1.31918 1498136065000000000 256 \n",
"2016-12-03 00:35:08 1.31918 1498136065000000000 256 \n",
"2016-12-03 00:50:35 1.31855 1498136116000000000 256 \n",
"2016-12-03 00:50:35 1.31855 1498136116000000000 256 \n",
"2016-12-03 00:50:35 1.31855 1498136116000000000 256 \n",
"2016-12-03 00:52:25 1.31859 1498136150000000000 256 \n",
"2016-12-03 00:52:25 1.31859 1498136150000000000 256 \n",
"2016-12-03 00:52:25 1.31859 1498136150000000000 256 \n",
"2016-12-03 01:07:24 1.31991 1498136194000000000 256 \n",
"2016-12-03 01:07:24 1.31991 1498136194000000000 256 \n",
"2016-12-03 01:07:24 1.31991 1498136194000000000 256 \n",
"2016-12-03 01:24:27 1.32097 1498136275000000000 256 \n",
"2016-12-03 01:24:27 1.32097 1498136275000000000 256 \n",
"2016-12-03 01:24:27 1.32097 1498136275000000000 256 \n",
"2016-12-03 01:41:31 1.32092 1498136360000000000 256 \n",
"2016-12-03 01:41:31 1.32092 1498136360000000000 256 \n",
"2016-12-03 01:41:31 1.32092 1498136360000000000 256 \n",
"2016-12-03 01:58:35 1.32080 1498136445000000000 256 \n",
"2016-12-03 01:58:35 1.32080 1498136445000000000 256 \n",
"2016-12-03 01:58:35 1.32080 1498136445000000000 256 \n",
"2016-12-03 02:15:37 1.32116 1498136532000000000 256 \n",
"2016-12-03 02:15:37 1.32116 1498136532000000000 256 \n",
"2016-12-03 02:15:37 1.32116 1498136532000000000 256 \n",
"2016-12-03 02:32:42 1.31977 1498136627000000000 256 \n",
"2016-12-03 02:32:42 1.31977 1498136627000000000 256 \n",
"2016-12-03 02:32:42 1.31977 1498136627000000000 256 \n",
"... ... ... ... \n",
"2016-12-25 07:08:49 1.31710 1497540732000000000 256 \n",
"2016-12-25 07:08:49 1.31710 1497540732000000000 256 \n",
"2016-12-25 07:25:53 1.31817 1497540866000000000 256 \n",
"2016-12-25 08:03:06 1.31798 1497541192000000000 256 \n",
"2016-12-25 08:03:06 1.31798 1497541192000000000 256 \n",
"2016-12-25 08:03:06 1.31798 1497541192000000000 256 \n",
"2016-12-25 08:03:06 1.31798 1497541192000000000 256 \n",
"2016-12-25 08:03:06 1.31798 1497541192000000000 256 \n",
"2016-12-25 08:03:06 1.31798 1497541192000000000 256 \n",
"2016-12-25 08:17:04 1.31784 1497541279000000000 256 \n",
"2016-12-25 08:17:04 1.31784 1497541279000000000 256 \n",
"2016-12-25 08:17:04 1.31784 1497541279000000000 256 \n",
"2016-12-25 08:18:56 1.31924 1497541311000000000 256 \n",
"2016-12-25 08:18:56 1.31924 1497541311000000000 256 \n",
"2016-12-25 08:18:56 1.31924 1497541311000000000 256 \n",
"2016-12-25 08:34:08 1.31780 1497541421000000000 256 \n",
"2016-12-25 08:34:08 1.31780 1497541421000000000 256 \n",
"2016-12-25 08:34:08 1.31780 1497541421000000000 256 \n",
"2016-12-25 08:35:58 1.31857 1497541454000000000 256 \n",
"2016-12-25 08:35:58 1.31857 1497541454000000000 256 \n",
"2016-12-25 08:51:11 1.31711 1497541563000000000 256 \n",
"2016-12-25 08:51:11 1.31711 1497541563000000000 256 \n",
"2016-12-25 09:08:15 1.31691 1497541707000000000 256 \n",
"2016-12-25 09:08:15 1.31691 1497541707000000000 256 \n",
"2016-12-25 09:28:48 1.31861 1497541910000000000 256 \n",
"2016-12-25 09:28:48 1.31861 1497541910000000000 256 \n",
"2016-12-25 09:28:48 1.31861 1497541910000000000 256 \n",
"2016-12-25 09:28:48 1.31861 1497541910000000000 256 \n",
"2016-12-25 09:42:22 1.31706 1497541989000000000 256 \n",
"2016-12-25 09:42:22 1.31706 1497541989000000000 256 \n",
"\n",
"[825 rows x 15 columns]"
]
},
"execution_count": 73,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"#Filter DataFrame for good quality data\n",
"concated_spectra_report[concated_spectra_report.Status=='0000000f']"
]
}
],
"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.6.1"
}
},
"nbformat": 4,
"nbformat_minor": 2
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment