Skip to content

Instantly share code, notes, and snippets.

@rbiswas4

rbiswas4/demo_opsimsummary.ipynb

Created February 20, 2018 16:42
Show Gist options
  • Save rbiswas4/bec537841e710b30f905c59d17ecdfab to your computer and use it in GitHub Desktop.
Save rbiswas4/bec537841e710b30f905c59d17ecdfab to your computer and use it in GitHub Desktop.
Download ZIP
Display the source blob
Display the rendered blob
Raw
demo_opsimsummary.ipynb
{
"cells": [
{
"metadata": {
"trusted": true
},
"cell_type": "code",
"source": "import opsimsummary as oss\noss.__version__",
"execution_count": 1,
"outputs": [
{
"output_type": "execute_result",
"execution_count": 1,
"data": {
"text/plain": "'1.3.7'"
},
"metadata": {}
}
]
},
{
"metadata": {
"trusted": true
},
"cell_type": "code",
"source": "opsimout = oss.OpSimOutput.fromOpSimDB('/Users/rbiswas/data/LSST/OpSimData/minion_1016_sqlite.db', subset='wfd')",
"execution_count": 2,
"outputs": [
{
"output_type": "stream",
"text": " reading from database sqlite:////Users/rbiswas/data/LSST/OpSimData/minion_1016_sqlite.db\nSELECT * FROM Summary WHERE PROPID in (54)\n",
"name": "stdout"
}
]
},
{
"metadata": {
"trusted": true
},
"cell_type": "code",
"source": "opsimout.summary.query('fieldID == 1427 and expMJD > 59860 and expMJD < 59880').fieldID.size",
"execution_count": 17,
"outputs": [
{
"output_type": "execute_result",
"execution_count": 17,
"data": {
"text/plain": "9"
},
"metadata": {}
}
]
},
{
"metadata": {
"trusted": true
},
"cell_type": "code",
"source": "from copy import deepcopy",
"execution_count": 18,
"outputs": []
},
{
"metadata": {
"trusted": true
},
"cell_type": "code",
"source": "df = opsimout.summary.query('expMJD > 59860 and expMJD < 59880').copy()",
"execution_count": 20,
"outputs": []
},
{
"metadata": {
"trusted": true
},
"cell_type": "code",
"source": "df.head()",
"execution_count": 22,
"outputs": [
{
"output_type": "execute_result",
"execution_count": 22,
"data": {
"text/plain": " sessionID propID fieldID fieldRA fieldDec filter expDate \\\nobsHistID \n206551 1016 54 966 6.089773 -0.691833 y 24192035 \n206552 1016 54 978 6.026158 -0.686154 y 24192074 \n206553 1016 54 982 5.963154 -0.678746 y 24192113 \n206554 1016 54 1008 5.900765 -0.669491 y 24192152 \n206555 1016 54 1018 5.838890 -0.658150 y 24192190 \n\n expMJD night visitTime ... moonBright \\\nobsHistID ... \n206551 59860.000413 280 34.0 ... 1410.332261 \n206552 59860.000862 280 34.0 ... 1359.284840 \n206553 59860.001311 280 34.0 ... 1306.607760 \n206554 59860.001760 280 34.0 ... 1253.003853 \n206555 59860.002209 280 34.0 ... 1199.289172 \n\n darkBright rawSeeing wind humidity slewDist slewTime \\\nobsHistID \n206551 93.333790 0.601948 0.0 0.0 0.049471 4.797452 \n206552 90.841178 0.601948 0.0 0.0 0.049429 4.796943 \n206553 88.645734 0.601948 0.0 0.0 0.049436 4.797170 \n206554 86.716303 0.601948 0.0 0.0 0.049614 4.800317 \n206555 85.026877 0.601948 0.0 0.0 0.050032 4.807406 \n\n fiveSigmaDepth ditheredRA ditheredDec \nobsHistID \n206551 21.497351 6.097210 -0.701752 \n206552 21.528248 6.033560 -0.696073 \n206553 21.555633 5.970512 -0.688665 \n206554 21.579858 5.908069 -0.679410 \n206555 21.601204 5.846129 -0.668069 \n\n[5 rows x 46 columns]",
"text/html": "<div>\n<style scoped>\n .dataframe tbody tr th:only-of-type {\n vertical-align: middle;\n }\n\n .dataframe tbody tr th {\n vertical-align: top;\n }\n\n .dataframe thead th {\n text-align: right;\n }\n</style>\n<table border=\"1\" class=\"dataframe\">\n <thead>\n <tr style=\"text-align: right;\">\n <th></th>\n <th>sessionID</th>\n <th>propID</th>\n <th>fieldID</th>\n <th>fieldRA</th>\n <th>fieldDec</th>\n <th>filter</th>\n <th>expDate</th>\n <th>expMJD</th>\n <th>night</th>\n <th>visitTime</th>\n <th>...</th>\n <th>moonBright</th>\n <th>darkBright</th>\n <th>rawSeeing</th>\n <th>wind</th>\n <th>humidity</th>\n <th>slewDist</th>\n <th>slewTime</th>\n <th>fiveSigmaDepth</th>\n <th>ditheredRA</th>\n <th>ditheredDec</th>\n </tr>\n <tr>\n <th>obsHistID</th>\n <th></th>\n <th></th>\n <th></th>\n <th></th>\n <th></th>\n <th></th>\n <th></th>\n <th></th>\n <th></th>\n <th></th>\n <th></th>\n <th></th>\n <th></th>\n <th></th>\n <th></th>\n <th></th>\n <th></th>\n <th></th>\n <th></th>\n <th></th>\n <th></th>\n </tr>\n </thead>\n <tbody>\n <tr>\n <th>206551</th>\n <td>1016</td>\n <td>54</td>\n <td>966</td>\n <td>6.089773</td>\n <td>-0.691833</td>\n <td>y</td>\n <td>24192035</td>\n <td>59860.000413</td>\n <td>280</td>\n <td>34.0</td>\n <td>...</td>\n <td>1410.332261</td>\n <td>93.333790</td>\n <td>0.601948</td>\n <td>0.0</td>\n <td>0.0</td>\n <td>0.049471</td>\n <td>4.797452</td>\n <td>21.497351</td>\n <td>6.097210</td>\n <td>-0.701752</td>\n </tr>\n <tr>\n <th>206552</th>\n <td>1016</td>\n <td>54</td>\n <td>978</td>\n <td>6.026158</td>\n <td>-0.686154</td>\n <td>y</td>\n <td>24192074</td>\n <td>59860.000862</td>\n <td>280</td>\n <td>34.0</td>\n <td>...</td>\n <td>1359.284840</td>\n <td>90.841178</td>\n <td>0.601948</td>\n <td>0.0</td>\n <td>0.0</td>\n <td>0.049429</td>\n <td>4.796943</td>\n <td>21.528248</td>\n <td>6.033560</td>\n <td>-0.696073</td>\n </tr>\n <tr>\n <th>206553</th>\n <td>1016</td>\n <td>54</td>\n <td>982</td>\n <td>5.963154</td>\n <td>-0.678746</td>\n <td>y</td>\n <td>24192113</td>\n <td>59860.001311</td>\n <td>280</td>\n <td>34.0</td>\n <td>...</td>\n <td>1306.607760</td>\n <td>88.645734</td>\n <td>0.601948</td>\n <td>0.0</td>\n <td>0.0</td>\n <td>0.049436</td>\n <td>4.797170</td>\n <td>21.555633</td>\n <td>5.970512</td>\n <td>-0.688665</td>\n </tr>\n <tr>\n <th>206554</th>\n <td>1016</td>\n <td>54</td>\n <td>1008</td>\n <td>5.900765</td>\n <td>-0.669491</td>\n <td>y</td>\n <td>24192152</td>\n <td>59860.001760</td>\n <td>280</td>\n <td>34.0</td>\n <td>...</td>\n <td>1253.003853</td>\n <td>86.716303</td>\n <td>0.601948</td>\n <td>0.0</td>\n <td>0.0</td>\n <td>0.049614</td>\n <td>4.800317</td>\n <td>21.579858</td>\n <td>5.908069</td>\n <td>-0.679410</td>\n </tr>\n <tr>\n <th>206555</th>\n <td>1016</td>\n <td>54</td>\n <td>1018</td>\n <td>5.838890</td>\n <td>-0.658150</td>\n <td>y</td>\n <td>24192190</td>\n <td>59860.002209</td>\n <td>280</td>\n <td>34.0</td>\n <td>...</td>\n <td>1199.289172</td>\n <td>85.026877</td>\n <td>0.601948</td>\n <td>0.0</td>\n <td>0.0</td>\n <td>0.050032</td>\n <td>4.807406</td>\n <td>21.601204</td>\n <td>5.846129</td>\n <td>-0.668069</td>\n </tr>\n </tbody>\n</table>\n<p>5 rows × 46 columns</p>\n</div>"
},
"metadata": {}
}
]
},
{
"metadata": {
"trusted": true
},
"cell_type": "code",
"source": "df['dist'] = dist(raObj, decObj, pointing )",
"execution_count": 21,
"outputs": [
{
"output_type": "execute_result",
"execution_count": 21,
"data": {
"text/plain": "12168"
},
"metadata": {}
}
]
},
{
"metadata": {
"trusted": true
},
"cell_type": "code",
"source": "df.query('dist < 1.75')",
"execution_count": null,
"outputs": []
},
{
"metadata": {
"trusted": true
},
"cell_type": "code",
"source": "1.75**2 * 3.14",
"execution_count": 23,
"outputs": [
{
"output_type": "execute_result",
"execution_count": 23,
"data": {
"text/plain": "9.61625"
},
"metadata": {}
}
]
},
{
"metadata": {
"trusted": true
},
"cell_type": "code",
"source": "df[['expMJD', 'filter', 'ditheredRA', 'ditheredDec', 'fiveSigmaDepth']]",
"execution_count": 24,
"outputs": [
{
"output_type": "execute_result",
"execution_count": 24,
"data": {
"text/plain": " expMJD filter ditheredRA ditheredDec fiveSigmaDepth\nobsHistID \n206551 59860.000413 y 6.097210 -0.701752 21.497351\n206552 59860.000862 y 6.033560 -0.696073 21.528248\n206553 59860.001311 y 5.970512 -0.688665 21.555633\n206554 59860.001760 y 5.908069 -0.679410 21.579858\n206555 59860.002209 y 5.846129 -0.668069 21.601204\n206556 59860.002658 y 5.784480 -0.654121 21.619938\n206557 59860.003108 y 5.722915 -0.636514 21.636244\n206558 59860.003558 y 5.661824 -0.613660 21.650093\n206559 59860.004008 y 5.602825 -0.588436 21.661017\n206560 59860.004458 y 5.661824 -0.613660 21.754238\n206561 59860.004908 y 5.722915 -0.636514 21.741804\n206562 59860.005357 y 5.784480 -0.654121 21.727344\n206563 59860.005807 y 5.846129 -0.668069 21.710915\n206564 59860.006256 y 5.908069 -0.679410 21.692365\n206565 59860.006705 y 5.970512 -0.688665 21.820052\n206566 59860.007154 y 6.033560 -0.696073 21.796619\n206567 59860.007603 y 6.097210 -0.701752 21.770374\n206568 59860.008052 y 6.161379 -0.705766 21.741054\n206569 59860.008501 y 6.225926 -0.708158 21.708352\n206570 59860.008949 y 6.259406 -0.660448 21.794783\n206571 59860.009398 y 6.197549 -0.658932 21.832232\n206572 59860.009847 y 6.135990 -0.655896 21.865528\n206573 59860.010296 y 6.074905 -0.651341 21.895053\n206574 59860.010745 y 6.014429 -0.645264 21.921148\n206575 59860.011194 y 5.954646 -0.637659 21.944098\n206576 59860.011643 y 5.895572 -0.628492 21.964161\n206577 59860.012092 y 5.837114 -0.617643 21.981572\n206578 59860.012541 y 5.778986 -0.604712 21.996538\n206579 59860.012990 y 5.720588 -0.588436 22.009265\n206580 59860.013439 y 5.778986 -0.604712 22.008476\n... ... ... ... ... ...\n221957 59879.362629 z 2.022268 -0.550489 22.099747\n221958 59879.363077 z 1.967665 -0.536371 22.109048\n221959 59879.363533 z 2.063192 -0.508895 22.091844\n221960 59879.363981 z 2.116899 -0.519872 22.081078\n221961 59879.364429 z 2.171313 -0.529624 22.068544\n221962 59879.364878 z 2.226469 -0.538114 22.054143\n221963 59879.365326 z 2.282341 -0.545295 21.970572\n221964 59879.365775 z 2.338871 -0.551117 21.952080\n221965 59879.366224 z 2.395961 -0.555535 21.931324\n221966 59879.366672 z 2.453484 -0.558507 21.908147\n221967 59879.367120 z 2.483259 -0.510815 21.890047\n221968 59879.367566 z 2.511333 -0.462852 21.869458\n221969 59879.368013 z 2.538231 -0.414728 21.846098\n221970 59879.368460 z 2.564476 -0.366553 21.819579\n221971 59879.368907 z 2.590536 -0.318450 21.789428\n221972 59879.369356 z 2.537348 -0.319209 21.825787\n221973 59879.369866 z 2.566249 -0.462852 21.852824\n221974 59879.370312 z 2.539449 -0.511569 21.877802\n221975 59879.370759 z 2.511270 -0.560000 21.899363\n221976 59879.371209 z 2.481395 -0.608061 21.917954\n221977 59879.371661 z 2.449202 -0.655626 21.933884\n221978 59879.372110 z 2.387594 -0.652591 21.957679\n221979 59879.372559 z 2.326436 -0.648036 21.978714\n221980 59879.373008 z 2.265863 -0.641958 21.997194\n221981 59879.997498 z 4.822285 -0.882981 22.293559\n221982 59879.997946 z 4.874443 -0.841216 22.319523\n221983 59879.998395 z 4.798305 -0.834326 22.284890\n221984 59879.998842 z 4.848547 -0.792345 22.309727\n221985 59879.999297 z 4.960748 -0.751690 22.359169\n221986 59879.999748 z 4.996702 -0.704852 22.374706\n\n[12168 rows x 5 columns]",
"text/html": "<div>\n<style scoped>\n .dataframe tbody tr th:only-of-type {\n vertical-align: middle;\n }\n\n .dataframe tbody tr th {\n vertical-align: top;\n }\n\n .dataframe thead th {\n text-align: right;\n }\n</style>\n<table border=\"1\" class=\"dataframe\">\n <thead>\n <tr style=\"text-align: right;\">\n <th></th>\n <th>expMJD</th>\n <th>filter</th>\n <th>ditheredRA</th>\n <th>ditheredDec</th>\n <th>fiveSigmaDepth</th>\n </tr>\n <tr>\n <th>obsHistID</th>\n <th></th>\n <th></th>\n <th></th>\n <th></th>\n <th></th>\n </tr>\n </thead>\n <tbody>\n <tr>\n <th>206551</th>\n <td>59860.000413</td>\n <td>y</td>\n <td>6.097210</td>\n <td>-0.701752</td>\n <td>21.497351</td>\n </tr>\n <tr>\n <th>206552</th>\n <td>59860.000862</td>\n <td>y</td>\n <td>6.033560</td>\n <td>-0.696073</td>\n <td>21.528248</td>\n </tr>\n <tr>\n <th>206553</th>\n <td>59860.001311</td>\n <td>y</td>\n <td>5.970512</td>\n <td>-0.688665</td>\n <td>21.555633</td>\n </tr>\n <tr>\n <th>206554</th>\n <td>59860.001760</td>\n <td>y</td>\n <td>5.908069</td>\n <td>-0.679410</td>\n <td>21.579858</td>\n </tr>\n <tr>\n <th>206555</th>\n <td>59860.002209</td>\n <td>y</td>\n <td>5.846129</td>\n <td>-0.668069</td>\n <td>21.601204</td>\n </tr>\n <tr>\n <th>206556</th>\n <td>59860.002658</td>\n <td>y</td>\n <td>5.784480</td>\n <td>-0.654121</td>\n <td>21.619938</td>\n </tr>\n <tr>\n <th>206557</th>\n <td>59860.003108</td>\n <td>y</td>\n <td>5.722915</td>\n <td>-0.636514</td>\n <td>21.636244</td>\n </tr>\n <tr>\n <th>206558</th>\n <td>59860.003558</td>\n <td>y</td>\n <td>5.661824</td>\n <td>-0.613660</td>\n <td>21.650093</td>\n </tr>\n <tr>\n <th>206559</th>\n <td>59860.004008</td>\n <td>y</td>\n <td>5.602825</td>\n <td>-0.588436</td>\n <td>21.661017</td>\n </tr>\n <tr>\n <th>206560</th>\n <td>59860.004458</td>\n <td>y</td>\n <td>5.661824</td>\n <td>-0.613660</td>\n <td>21.754238</td>\n </tr>\n <tr>\n <th>206561</th>\n <td>59860.004908</td>\n <td>y</td>\n <td>5.722915</td>\n <td>-0.636514</td>\n <td>21.741804</td>\n </tr>\n <tr>\n <th>206562</th>\n <td>59860.005357</td>\n <td>y</td>\n <td>5.784480</td>\n <td>-0.654121</td>\n <td>21.727344</td>\n </tr>\n <tr>\n <th>206563</th>\n <td>59860.005807</td>\n <td>y</td>\n <td>5.846129</td>\n <td>-0.668069</td>\n <td>21.710915</td>\n </tr>\n <tr>\n <th>206564</th>\n <td>59860.006256</td>\n <td>y</td>\n <td>5.908069</td>\n <td>-0.679410</td>\n <td>21.692365</td>\n </tr>\n <tr>\n <th>206565</th>\n <td>59860.006705</td>\n <td>y</td>\n <td>5.970512</td>\n <td>-0.688665</td>\n <td>21.820052</td>\n </tr>\n <tr>\n <th>206566</th>\n <td>59860.007154</td>\n <td>y</td>\n <td>6.033560</td>\n <td>-0.696073</td>\n <td>21.796619</td>\n </tr>\n <tr>\n <th>206567</th>\n <td>59860.007603</td>\n <td>y</td>\n <td>6.097210</td>\n <td>-0.701752</td>\n <td>21.770374</td>\n </tr>\n <tr>\n <th>206568</th>\n <td>59860.008052</td>\n <td>y</td>\n <td>6.161379</td>\n <td>-0.705766</td>\n <td>21.741054</td>\n </tr>\n <tr>\n <th>206569</th>\n <td>59860.008501</td>\n <td>y</td>\n <td>6.225926</td>\n <td>-0.708158</td>\n <td>21.708352</td>\n </tr>\n <tr>\n <th>206570</th>\n <td>59860.008949</td>\n <td>y</td>\n <td>6.259406</td>\n <td>-0.660448</td>\n <td>21.794783</td>\n </tr>\n <tr>\n <th>206571</th>\n <td>59860.009398</td>\n <td>y</td>\n <td>6.197549</td>\n <td>-0.658932</td>\n <td>21.832232</td>\n </tr>\n <tr>\n <th>206572</th>\n <td>59860.009847</td>\n <td>y</td>\n <td>6.135990</td>\n <td>-0.655896</td>\n <td>21.865528</td>\n </tr>\n <tr>\n <th>206573</th>\n <td>59860.010296</td>\n <td>y</td>\n <td>6.074905</td>\n <td>-0.651341</td>\n <td>21.895053</td>\n </tr>\n <tr>\n <th>206574</th>\n <td>59860.010745</td>\n <td>y</td>\n <td>6.014429</td>\n <td>-0.645264</td>\n <td>21.921148</td>\n </tr>\n <tr>\n <th>206575</th>\n <td>59860.011194</td>\n <td>y</td>\n <td>5.954646</td>\n <td>-0.637659</td>\n <td>21.944098</td>\n </tr>\n <tr>\n <th>206576</th>\n <td>59860.011643</td>\n <td>y</td>\n <td>5.895572</td>\n <td>-0.628492</td>\n <td>21.964161</td>\n </tr>\n <tr>\n <th>206577</th>\n <td>59860.012092</td>\n <td>y</td>\n <td>5.837114</td>\n <td>-0.617643</td>\n <td>21.981572</td>\n </tr>\n <tr>\n <th>206578</th>\n <td>59860.012541</td>\n <td>y</td>\n <td>5.778986</td>\n <td>-0.604712</td>\n <td>21.996538</td>\n </tr>\n <tr>\n <th>206579</th>\n <td>59860.012990</td>\n <td>y</td>\n <td>5.720588</td>\n <td>-0.588436</td>\n <td>22.009265</td>\n </tr>\n <tr>\n <th>206580</th>\n <td>59860.013439</td>\n <td>y</td>\n <td>5.778986</td>\n <td>-0.604712</td>\n <td>22.008476</td>\n </tr>\n <tr>\n <th>...</th>\n <td>...</td>\n <td>...</td>\n <td>...</td>\n <td>...</td>\n <td>...</td>\n </tr>\n <tr>\n <th>221957</th>\n <td>59879.362629</td>\n <td>z</td>\n <td>2.022268</td>\n <td>-0.550489</td>\n <td>22.099747</td>\n </tr>\n <tr>\n <th>221958</th>\n <td>59879.363077</td>\n <td>z</td>\n <td>1.967665</td>\n <td>-0.536371</td>\n <td>22.109048</td>\n </tr>\n <tr>\n <th>221959</th>\n <td>59879.363533</td>\n <td>z</td>\n <td>2.063192</td>\n <td>-0.508895</td>\n <td>22.091844</td>\n </tr>\n <tr>\n <th>221960</th>\n <td>59879.363981</td>\n <td>z</td>\n <td>2.116899</td>\n <td>-0.519872</td>\n <td>22.081078</td>\n </tr>\n <tr>\n <th>221961</th>\n <td>59879.364429</td>\n <td>z</td>\n <td>2.171313</td>\n <td>-0.529624</td>\n <td>22.068544</td>\n </tr>\n <tr>\n <th>221962</th>\n <td>59879.364878</td>\n <td>z</td>\n <td>2.226469</td>\n <td>-0.538114</td>\n <td>22.054143</td>\n </tr>\n <tr>\n <th>221963</th>\n <td>59879.365326</td>\n <td>z</td>\n <td>2.282341</td>\n <td>-0.545295</td>\n <td>21.970572</td>\n </tr>\n <tr>\n <th>221964</th>\n <td>59879.365775</td>\n <td>z</td>\n <td>2.338871</td>\n <td>-0.551117</td>\n <td>21.952080</td>\n </tr>\n <tr>\n <th>221965</th>\n <td>59879.366224</td>\n <td>z</td>\n <td>2.395961</td>\n <td>-0.555535</td>\n <td>21.931324</td>\n </tr>\n <tr>\n <th>221966</th>\n <td>59879.366672</td>\n <td>z</td>\n <td>2.453484</td>\n <td>-0.558507</td>\n <td>21.908147</td>\n </tr>\n <tr>\n <th>221967</th>\n <td>59879.367120</td>\n <td>z</td>\n <td>2.483259</td>\n <td>-0.510815</td>\n <td>21.890047</td>\n </tr>\n <tr>\n <th>221968</th>\n <td>59879.367566</td>\n <td>z</td>\n <td>2.511333</td>\n <td>-0.462852</td>\n <td>21.869458</td>\n </tr>\n <tr>\n <th>221969</th>\n <td>59879.368013</td>\n <td>z</td>\n <td>2.538231</td>\n <td>-0.414728</td>\n <td>21.846098</td>\n </tr>\n <tr>\n <th>221970</th>\n <td>59879.368460</td>\n <td>z</td>\n <td>2.564476</td>\n <td>-0.366553</td>\n <td>21.819579</td>\n </tr>\n <tr>\n <th>221971</th>\n <td>59879.368907</td>\n <td>z</td>\n <td>2.590536</td>\n <td>-0.318450</td>\n <td>21.789428</td>\n </tr>\n <tr>\n <th>221972</th>\n <td>59879.369356</td>\n <td>z</td>\n <td>2.537348</td>\n <td>-0.319209</td>\n <td>21.825787</td>\n </tr>\n <tr>\n <th>221973</th>\n <td>59879.369866</td>\n <td>z</td>\n <td>2.566249</td>\n <td>-0.462852</td>\n <td>21.852824</td>\n </tr>\n <tr>\n <th>221974</th>\n <td>59879.370312</td>\n <td>z</td>\n <td>2.539449</td>\n <td>-0.511569</td>\n <td>21.877802</td>\n </tr>\n <tr>\n <th>221975</th>\n <td>59879.370759</td>\n <td>z</td>\n <td>2.511270</td>\n <td>-0.560000</td>\n <td>21.899363</td>\n </tr>\n <tr>\n <th>221976</th>\n <td>59879.371209</td>\n <td>z</td>\n <td>2.481395</td>\n <td>-0.608061</td>\n <td>21.917954</td>\n </tr>\n <tr>\n <th>221977</th>\n <td>59879.371661</td>\n <td>z</td>\n <td>2.449202</td>\n <td>-0.655626</td>\n <td>21.933884</td>\n </tr>\n <tr>\n <th>221978</th>\n <td>59879.372110</td>\n <td>z</td>\n <td>2.387594</td>\n <td>-0.652591</td>\n <td>21.957679</td>\n </tr>\n <tr>\n <th>221979</th>\n <td>59879.372559</td>\n <td>z</td>\n <td>2.326436</td>\n <td>-0.648036</td>\n <td>21.978714</td>\n </tr>\n <tr>\n <th>221980</th>\n <td>59879.373008</td>\n <td>z</td>\n <td>2.265863</td>\n <td>-0.641958</td>\n <td>21.997194</td>\n </tr>\n <tr>\n <th>221981</th>\n <td>59879.997498</td>\n <td>z</td>\n <td>4.822285</td>\n <td>-0.882981</td>\n <td>22.293559</td>\n </tr>\n <tr>\n <th>221982</th>\n <td>59879.997946</td>\n <td>z</td>\n <td>4.874443</td>\n <td>-0.841216</td>\n <td>22.319523</td>\n </tr>\n <tr>\n <th>221983</th>\n <td>59879.998395</td>\n <td>z</td>\n <td>4.798305</td>\n <td>-0.834326</td>\n <td>22.284890</td>\n </tr>\n <tr>\n <th>221984</th>\n <td>59879.998842</td>\n <td>z</td>\n <td>4.848547</td>\n <td>-0.792345</td>\n <td>22.309727</td>\n </tr>\n <tr>\n <th>221985</th>\n <td>59879.999297</td>\n <td>z</td>\n <td>4.960748</td>\n <td>-0.751690</td>\n <td>22.359169</td>\n </tr>\n <tr>\n <th>221986</th>\n <td>59879.999748</td>\n <td>z</td>\n <td>4.996702</td>\n <td>-0.704852</td>\n <td>22.374706</td>\n </tr>\n </tbody>\n</table>\n<p>12168 rows × 5 columns</p>\n</div>"
},
"metadata": {}
}
]
},
{
"metadata": {
"trusted": true
},
"cell_type": "code",
"source": "",
"execution_count": null,
"outputs": []
}
],
"metadata": {
"kernelspec": {
"name": "python3",
"display_name": "Python 3",
"language": "python"
},
"language_info": {
"name": "python",
"version": "3.6.2",
"mimetype": "text/x-python",
"codemirror_mode": {
"name": "ipython",
"version": 3
},
"pygments_lexer": "ipython3",
"nbconvert_exporter": "python",
"file_extension": ".py"
}
},
"nbformat": 4,
"nbformat_minor": 2
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment