Last active
January 4, 2018 02:47
-
-
Save Kelvinrr/37462917da96119b12bdf3f30f8d0d77 to your computer and use it in GitHub Desktop.
Spectral Profiler Spectral Garbage
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "cells": [ | |
| { | |
| "cell_type": "code", | |
| "execution_count": 19, | |
| "metadata": { | |
| "scrolled": false | |
| }, | |
| "outputs": [], | |
| "source": [ | |
| "from plio.io import io_spectral_profiler\n", | |
| "from libpysat.examples import get_path\n", | |
| "import pandas as pd\n", | |
| "from matplotlib import pyplot as plt\n", | |
| "from libpysat.spectral.spectra import *\n", | |
| "from libpysat.utils.utils import *" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 30, | |
| "metadata": { | |
| "scrolled": false | |
| }, | |
| "outputs": [ | |
| { | |
| "data": { | |
| "text/html": [ | |
| "<div>\n", | |
| "<style scoped>\n", | |
| " .dataframe tbody tr th:only-of-type {\n", | |
| " vertical-align: middle;\n", | |
| " }\n", | |
| "\n", | |
| " .dataframe tbody tr th {\n", | |
| " vertical-align: top;\n", | |
| " }\n", | |
| "\n", | |
| " .dataframe thead th {\n", | |
| " text-align: right;\n", | |
| " }\n", | |
| "</style>\n", | |
| "<table border=\"1\" class=\"dataframe\">\n", | |
| " <thead>\n", | |
| " <tr style=\"text-align: right;\">\n", | |
| " <th></th>\n", | |
| " <th></th>\n", | |
| " <th>512.6</th>\n", | |
| " <th>518.4</th>\n", | |
| " <th>524.7</th>\n", | |
| " <th>530.4</th>\n", | |
| " <th>536.5</th>\n", | |
| " <th>542.8000000000001</th>\n", | |
| " <th>548.7</th>\n", | |
| " <th>554.5</th>\n", | |
| " <th>560.5</th>\n", | |
| " <th>566.7</th>\n", | |
| " <th>...</th>\n", | |
| " <th>CALIBRATION</th>\n", | |
| " <th>SP_PELTIER</th>\n", | |
| " <th>TC_MI_STATUS</th>\n", | |
| " <th>CLOCK_COUNT_ERR_FLAG</th>\n", | |
| " <th>SPATIAL_RESOLUTION_FLAG</th>\n", | |
| " <th>GEOMETRIC_INFO_RECAL_FLAG</th>\n", | |
| " <th>SUPPORT_IMAGE_LINE_POSITION</th>\n", | |
| " <th>SUPPORT_IMAGE_COLUMN_POSITION</th>\n", | |
| " <th>THUMBNAIL_LINE_POSITION</th>\n", | |
| " <th>THUMBNAIL_COLUMN_POSITION</th>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>minor</th>\n", | |
| " <th>id</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>RAW</th>\n", | |
| " <th>0</th>\n", | |
| " <td>5123.0000</td>\n", | |
| " <td>5887.0000</td>\n", | |
| " <td>6375.0000</td>\n", | |
| " <td>6806.0000</td>\n", | |
| " <td>7494.0000</td>\n", | |
| " <td>7585.0000</td>\n", | |
| " <td>7525.0000</td>\n", | |
| " <td>7860.0000</td>\n", | |
| " <td>8582.0000</td>\n", | |
| " <td>9196.0000</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0</td>\n", | |
| " <td>1</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>65</td>\n", | |
| " <td>67</td>\n", | |
| " <td>27</td>\n", | |
| " <td>480</td>\n", | |
| " <td>13</td>\n", | |
| " <td>228</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>REF1</th>\n", | |
| " <th>0</th>\n", | |
| " <td>0.0402</td>\n", | |
| " <td>0.0487</td>\n", | |
| " <td>0.0497</td>\n", | |
| " <td>0.0520</td>\n", | |
| " <td>0.0532</td>\n", | |
| " <td>0.0551</td>\n", | |
| " <td>0.0559</td>\n", | |
| " <td>0.0571</td>\n", | |
| " <td>0.0594</td>\n", | |
| " <td>0.0612</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0</td>\n", | |
| " <td>1</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>65</td>\n", | |
| " <td>67</td>\n", | |
| " <td>27</td>\n", | |
| " <td>480</td>\n", | |
| " <td>13</td>\n", | |
| " <td>228</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>REF2</th>\n", | |
| " <th>0</th>\n", | |
| " <td>0.0397</td>\n", | |
| " <td>0.0482</td>\n", | |
| " <td>0.0492</td>\n", | |
| " <td>0.0515</td>\n", | |
| " <td>0.0527</td>\n", | |
| " <td>0.0545</td>\n", | |
| " <td>0.0553</td>\n", | |
| " <td>0.0565</td>\n", | |
| " <td>0.0588</td>\n", | |
| " <td>0.0605</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0</td>\n", | |
| " <td>1</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>65</td>\n", | |
| " <td>67</td>\n", | |
| " <td>27</td>\n", | |
| " <td>480</td>\n", | |
| " <td>13</td>\n", | |
| " <td>228</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>QA</th>\n", | |
| " <th>0</th>\n", | |
| " <td>288.0000</td>\n", | |
| " <td>288.0000</td>\n", | |
| " <td>288.0000</td>\n", | |
| " <td>288.0000</td>\n", | |
| " <td>288.0000</td>\n", | |
| " <td>288.0000</td>\n", | |
| " <td>288.0000</td>\n", | |
| " <td>288.0000</td>\n", | |
| " <td>288.0000</td>\n", | |
| " <td>288.0000</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0</td>\n", | |
| " <td>1</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>65</td>\n", | |
| " <td>67</td>\n", | |
| " <td>27</td>\n", | |
| " <td>480</td>\n", | |
| " <td>13</td>\n", | |
| " <td>228</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>RAW</th>\n", | |
| " <th>1</th>\n", | |
| " <td>5164.0000</td>\n", | |
| " <td>5955.0000</td>\n", | |
| " <td>6461.0000</td>\n", | |
| " <td>6905.0000</td>\n", | |
| " <td>7614.0000</td>\n", | |
| " <td>7709.0000</td>\n", | |
| " <td>7642.0000</td>\n", | |
| " <td>7986.0000</td>\n", | |
| " <td>8730.0000</td>\n", | |
| " <td>9366.0000</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0</td>\n", | |
| " <td>1</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>65</td>\n", | |
| " <td>67</td>\n", | |
| " <td>55</td>\n", | |
| " <td>480</td>\n", | |
| " <td>27</td>\n", | |
| " <td>228</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>REF1</th>\n", | |
| " <th>1</th>\n", | |
| " <td>0.0414</td>\n", | |
| " <td>0.0502</td>\n", | |
| " <td>0.0513</td>\n", | |
| " <td>0.0537</td>\n", | |
| " <td>0.0549</td>\n", | |
| " <td>0.0568</td>\n", | |
| " <td>0.0576</td>\n", | |
| " <td>0.0588</td>\n", | |
| " <td>0.0612</td>\n", | |
| " <td>0.0631</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0</td>\n", | |
| " <td>1</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>65</td>\n", | |
| " <td>67</td>\n", | |
| " <td>55</td>\n", | |
| " <td>480</td>\n", | |
| " <td>27</td>\n", | |
| " <td>228</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>REF2</th>\n", | |
| " <th>1</th>\n", | |
| " <td>0.0409</td>\n", | |
| " <td>0.0497</td>\n", | |
| " <td>0.0507</td>\n", | |
| " <td>0.0531</td>\n", | |
| " <td>0.0544</td>\n", | |
| " <td>0.0562</td>\n", | |
| " <td>0.0570</td>\n", | |
| " <td>0.0582</td>\n", | |
| " <td>0.0606</td>\n", | |
| " <td>0.0624</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0</td>\n", | |
| " <td>1</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>65</td>\n", | |
| " <td>67</td>\n", | |
| " <td>55</td>\n", | |
| " <td>480</td>\n", | |
| " <td>27</td>\n", | |
| " <td>228</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>QA</th>\n", | |
| " <th>1</th>\n", | |
| " <td>288.0000</td>\n", | |
| " <td>288.0000</td>\n", | |
| " <td>288.0000</td>\n", | |
| " <td>288.0000</td>\n", | |
| " <td>288.0000</td>\n", | |
| " <td>288.0000</td>\n", | |
| " <td>288.0000</td>\n", | |
| " <td>288.0000</td>\n", | |
| " <td>288.0000</td>\n", | |
| " <td>288.0000</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0</td>\n", | |
| " <td>1</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>65</td>\n", | |
| " <td>67</td>\n", | |
| " <td>55</td>\n", | |
| " <td>480</td>\n", | |
| " <td>27</td>\n", | |
| " <td>228</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>RAW</th>\n", | |
| " <th>2</th>\n", | |
| " <td>5080.0000</td>\n", | |
| " <td>5820.0000</td>\n", | |
| " <td>6296.0000</td>\n", | |
| " <td>6711.0000</td>\n", | |
| " <td>7375.0000</td>\n", | |
| " <td>7473.0000</td>\n", | |
| " <td>7416.0000</td>\n", | |
| " <td>7741.0000</td>\n", | |
| " <td>8445.0000</td>\n", | |
| " <td>9038.0000</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0</td>\n", | |
| " <td>1</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>65</td>\n", | |
| " <td>67</td>\n", | |
| " <td>83</td>\n", | |
| " <td>480</td>\n", | |
| " <td>40</td>\n", | |
| " <td>228</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>REF1</th>\n", | |
| " <th>2</th>\n", | |
| " <td>0.0391</td>\n", | |
| " <td>0.0474</td>\n", | |
| " <td>0.0484</td>\n", | |
| " <td>0.0506</td>\n", | |
| " <td>0.0518</td>\n", | |
| " <td>0.0537</td>\n", | |
| " <td>0.0545</td>\n", | |
| " <td>0.0556</td>\n", | |
| " <td>0.0579</td>\n", | |
| " <td>0.0596</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0</td>\n", | |
| " <td>1</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>65</td>\n", | |
| " <td>67</td>\n", | |
| " <td>83</td>\n", | |
| " <td>480</td>\n", | |
| " <td>40</td>\n", | |
| " <td>228</td>\n", | |
| " </tr>\n", | |
| " </tbody>\n", | |
| "</table>\n", | |
| "<p>10 rows × 312 columns</p>\n", | |
| "</div>" | |
| ], | |
| "text/plain": [ | |
| " 512.6 518.4 524.7 530.4 536.5 \\\n", | |
| "minor id \n", | |
| "RAW 0 5123.0000 5887.0000 6375.0000 6806.0000 7494.0000 \n", | |
| "REF1 0 0.0402 0.0487 0.0497 0.0520 0.0532 \n", | |
| "REF2 0 0.0397 0.0482 0.0492 0.0515 0.0527 \n", | |
| "QA 0 288.0000 288.0000 288.0000 288.0000 288.0000 \n", | |
| "RAW 1 5164.0000 5955.0000 6461.0000 6905.0000 7614.0000 \n", | |
| "REF1 1 0.0414 0.0502 0.0513 0.0537 0.0549 \n", | |
| "REF2 1 0.0409 0.0497 0.0507 0.0531 0.0544 \n", | |
| "QA 1 288.0000 288.0000 288.0000 288.0000 288.0000 \n", | |
| "RAW 2 5080.0000 5820.0000 6296.0000 6711.0000 7375.0000 \n", | |
| "REF1 2 0.0391 0.0474 0.0484 0.0506 0.0518 \n", | |
| "\n", | |
| " 542.8000000000001 548.7 554.5 560.5 566.7 \\\n", | |
| "minor id \n", | |
| "RAW 0 7585.0000 7525.0000 7860.0000 8582.0000 9196.0000 \n", | |
| "REF1 0 0.0551 0.0559 0.0571 0.0594 0.0612 \n", | |
| "REF2 0 0.0545 0.0553 0.0565 0.0588 0.0605 \n", | |
| "QA 0 288.0000 288.0000 288.0000 288.0000 288.0000 \n", | |
| "RAW 1 7709.0000 7642.0000 7986.0000 8730.0000 9366.0000 \n", | |
| "REF1 1 0.0568 0.0576 0.0588 0.0612 0.0631 \n", | |
| "REF2 1 0.0562 0.0570 0.0582 0.0606 0.0624 \n", | |
| "QA 1 288.0000 288.0000 288.0000 288.0000 288.0000 \n", | |
| "RAW 2 7473.0000 7416.0000 7741.0000 8445.0000 9038.0000 \n", | |
| "REF1 2 0.0537 0.0545 0.0556 0.0579 0.0596 \n", | |
| "\n", | |
| " ... CALIBRATION SP_PELTIER TC_MI_STATUS \\\n", | |
| "minor id ... \n", | |
| "RAW 0 ... 0 1 1 \n", | |
| "REF1 0 ... 0 1 1 \n", | |
| "REF2 0 ... 0 1 1 \n", | |
| "QA 0 ... 0 1 1 \n", | |
| "RAW 1 ... 0 1 1 \n", | |
| "REF1 1 ... 0 1 1 \n", | |
| "REF2 1 ... 0 1 1 \n", | |
| "QA 1 ... 0 1 1 \n", | |
| "RAW 2 ... 0 1 1 \n", | |
| "REF1 2 ... 0 1 1 \n", | |
| "\n", | |
| " CLOCK_COUNT_ERR_FLAG SPATIAL_RESOLUTION_FLAG \\\n", | |
| "minor id \n", | |
| "RAW 0 0 65 \n", | |
| "REF1 0 0 65 \n", | |
| "REF2 0 0 65 \n", | |
| "QA 0 0 65 \n", | |
| "RAW 1 0 65 \n", | |
| "REF1 1 0 65 \n", | |
| "REF2 1 0 65 \n", | |
| "QA 1 0 65 \n", | |
| "RAW 2 0 65 \n", | |
| "REF1 2 0 65 \n", | |
| "\n", | |
| " GEOMETRIC_INFO_RECAL_FLAG SUPPORT_IMAGE_LINE_POSITION \\\n", | |
| "minor id \n", | |
| "RAW 0 67 27 \n", | |
| "REF1 0 67 27 \n", | |
| "REF2 0 67 27 \n", | |
| "QA 0 67 27 \n", | |
| "RAW 1 67 55 \n", | |
| "REF1 1 67 55 \n", | |
| "REF2 1 67 55 \n", | |
| "QA 1 67 55 \n", | |
| "RAW 2 67 83 \n", | |
| "REF1 2 67 83 \n", | |
| "\n", | |
| " SUPPORT_IMAGE_COLUMN_POSITION THUMBNAIL_LINE_POSITION \\\n", | |
| "minor id \n", | |
| "RAW 0 480 13 \n", | |
| "REF1 0 480 13 \n", | |
| "REF2 0 480 13 \n", | |
| "QA 0 480 13 \n", | |
| "RAW 1 480 27 \n", | |
| "REF1 1 480 27 \n", | |
| "REF2 1 480 27 \n", | |
| "QA 1 480 27 \n", | |
| "RAW 2 480 40 \n", | |
| "REF1 2 480 40 \n", | |
| "\n", | |
| " THUMBNAIL_COLUMN_POSITION \n", | |
| "minor id \n", | |
| "RAW 0 228 \n", | |
| "REF1 0 228 \n", | |
| "REF2 0 228 \n", | |
| "QA 0 228 \n", | |
| "RAW 1 228 \n", | |
| "REF1 1 228 \n", | |
| "REF2 1 228 \n", | |
| "QA 1 228 \n", | |
| "RAW 2 228 \n", | |
| "REF1 2 228 \n", | |
| "\n", | |
| "[10 rows x 312 columns]" | |
| ] | |
| }, | |
| "execution_count": 30, | |
| "metadata": {}, | |
| "output_type": "execute_result" | |
| } | |
| ], | |
| "source": [ | |
| "s = Spectra.from_spectral_profiler(get_path('SP_2C_02_02358_S138_E3586.spc'))\n", | |
| "s.head(10)" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 21, | |
| "metadata": {}, | |
| "outputs": [ | |
| { | |
| "data": { | |
| "text/html": [ | |
| "<div>\n", | |
| "<style scoped>\n", | |
| " .dataframe tbody tr th:only-of-type {\n", | |
| " vertical-align: middle;\n", | |
| " }\n", | |
| "\n", | |
| " .dataframe tbody tr th {\n", | |
| " vertical-align: top;\n", | |
| " }\n", | |
| "\n", | |
| " .dataframe thead th {\n", | |
| " text-align: right;\n", | |
| " }\n", | |
| "</style>\n", | |
| "<table border=\"1\" class=\"dataframe\">\n", | |
| " <thead>\n", | |
| " <tr style=\"text-align: right;\">\n", | |
| " <th></th>\n", | |
| " <th>512.6</th>\n", | |
| " <th>518.4</th>\n", | |
| " <th>524.7</th>\n", | |
| " <th>530.4</th>\n", | |
| " <th>536.5</th>\n", | |
| " <th>542.8000000000001</th>\n", | |
| " <th>548.7</th>\n", | |
| " <th>554.5</th>\n", | |
| " <th>560.5</th>\n", | |
| " <th>566.7</th>\n", | |
| " <th>...</th>\n", | |
| " <th>CALIBRATION</th>\n", | |
| " <th>SP_PELTIER</th>\n", | |
| " <th>TC_MI_STATUS</th>\n", | |
| " <th>CLOCK_COUNT_ERR_FLAG</th>\n", | |
| " <th>SPATIAL_RESOLUTION_FLAG</th>\n", | |
| " <th>GEOMETRIC_INFO_RECAL_FLAG</th>\n", | |
| " <th>SUPPORT_IMAGE_LINE_POSITION</th>\n", | |
| " <th>SUPPORT_IMAGE_COLUMN_POSITION</th>\n", | |
| " <th>THUMBNAIL_LINE_POSITION</th>\n", | |
| " <th>THUMBNAIL_COLUMN_POSITION</th>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>id</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>0</th>\n", | |
| " <td>5123.0</td>\n", | |
| " <td>5887.0</td>\n", | |
| " <td>6375.0</td>\n", | |
| " <td>6806.0</td>\n", | |
| " <td>7494.0</td>\n", | |
| " <td>7585.0</td>\n", | |
| " <td>7525.0</td>\n", | |
| " <td>7860.0</td>\n", | |
| " <td>8582.0</td>\n", | |
| " <td>9196.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0</td>\n", | |
| " <td>1</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>65</td>\n", | |
| " <td>67</td>\n", | |
| " <td>27</td>\n", | |
| " <td>480</td>\n", | |
| " <td>13</td>\n", | |
| " <td>228</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>1</th>\n", | |
| " <td>5164.0</td>\n", | |
| " <td>5955.0</td>\n", | |
| " <td>6461.0</td>\n", | |
| " <td>6905.0</td>\n", | |
| " <td>7614.0</td>\n", | |
| " <td>7709.0</td>\n", | |
| " <td>7642.0</td>\n", | |
| " <td>7986.0</td>\n", | |
| " <td>8730.0</td>\n", | |
| " <td>9366.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0</td>\n", | |
| " <td>1</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>65</td>\n", | |
| " <td>67</td>\n", | |
| " <td>55</td>\n", | |
| " <td>480</td>\n", | |
| " <td>27</td>\n", | |
| " <td>228</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2</th>\n", | |
| " <td>5080.0</td>\n", | |
| " <td>5820.0</td>\n", | |
| " <td>6296.0</td>\n", | |
| " <td>6711.0</td>\n", | |
| " <td>7375.0</td>\n", | |
| " <td>7473.0</td>\n", | |
| " <td>7416.0</td>\n", | |
| " <td>7741.0</td>\n", | |
| " <td>8445.0</td>\n", | |
| " <td>9038.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0</td>\n", | |
| " <td>1</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>65</td>\n", | |
| " <td>67</td>\n", | |
| " <td>83</td>\n", | |
| " <td>480</td>\n", | |
| " <td>40</td>\n", | |
| " <td>228</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>3</th>\n", | |
| " <td>5078.0</td>\n", | |
| " <td>5810.0</td>\n", | |
| " <td>6287.0</td>\n", | |
| " <td>6702.0</td>\n", | |
| " <td>7368.0</td>\n", | |
| " <td>7458.0</td>\n", | |
| " <td>7402.0</td>\n", | |
| " <td>7728.0</td>\n", | |
| " <td>8436.0</td>\n", | |
| " <td>9025.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0</td>\n", | |
| " <td>1</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>65</td>\n", | |
| " <td>67</td>\n", | |
| " <td>112</td>\n", | |
| " <td>480</td>\n", | |
| " <td>53</td>\n", | |
| " <td>228</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>4</th>\n", | |
| " <td>5098.0</td>\n", | |
| " <td>5845.0</td>\n", | |
| " <td>6326.0</td>\n", | |
| " <td>6747.0</td>\n", | |
| " <td>7420.0</td>\n", | |
| " <td>7516.0</td>\n", | |
| " <td>7454.0</td>\n", | |
| " <td>7785.0</td>\n", | |
| " <td>8501.0</td>\n", | |
| " <td>9102.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0</td>\n", | |
| " <td>1</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>65</td>\n", | |
| " <td>67</td>\n", | |
| " <td>140</td>\n", | |
| " <td>480</td>\n", | |
| " <td>66</td>\n", | |
| " <td>228</td>\n", | |
| " </tr>\n", | |
| " </tbody>\n", | |
| "</table>\n", | |
| "<p>5 rows × 312 columns</p>\n", | |
| "</div>" | |
| ], | |
| "text/plain": [ | |
| " 512.6 518.4 524.7 530.4 536.5 542.8000000000001 548.7 554.5 \\\n", | |
| "id \n", | |
| "0 5123.0 5887.0 6375.0 6806.0 7494.0 7585.0 7525.0 7860.0 \n", | |
| "1 5164.0 5955.0 6461.0 6905.0 7614.0 7709.0 7642.0 7986.0 \n", | |
| "2 5080.0 5820.0 6296.0 6711.0 7375.0 7473.0 7416.0 7741.0 \n", | |
| "3 5078.0 5810.0 6287.0 6702.0 7368.0 7458.0 7402.0 7728.0 \n", | |
| "4 5098.0 5845.0 6326.0 6747.0 7420.0 7516.0 7454.0 7785.0 \n", | |
| "\n", | |
| " 560.5 566.7 ... CALIBRATION SP_PELTIER \\\n", | |
| "id ... \n", | |
| "0 8582.0 9196.0 ... 0 1 \n", | |
| "1 8730.0 9366.0 ... 0 1 \n", | |
| "2 8445.0 9038.0 ... 0 1 \n", | |
| "3 8436.0 9025.0 ... 0 1 \n", | |
| "4 8501.0 9102.0 ... 0 1 \n", | |
| "\n", | |
| " TC_MI_STATUS CLOCK_COUNT_ERR_FLAG SPATIAL_RESOLUTION_FLAG \\\n", | |
| "id \n", | |
| "0 1 0 65 \n", | |
| "1 1 0 65 \n", | |
| "2 1 0 65 \n", | |
| "3 1 0 65 \n", | |
| "4 1 0 65 \n", | |
| "\n", | |
| " GEOMETRIC_INFO_RECAL_FLAG SUPPORT_IMAGE_LINE_POSITION \\\n", | |
| "id \n", | |
| "0 67 27 \n", | |
| "1 67 55 \n", | |
| "2 67 83 \n", | |
| "3 67 112 \n", | |
| "4 67 140 \n", | |
| "\n", | |
| " SUPPORT_IMAGE_COLUMN_POSITION THUMBNAIL_LINE_POSITION \\\n", | |
| "id \n", | |
| "0 480 13 \n", | |
| "1 480 27 \n", | |
| "2 480 40 \n", | |
| "3 480 53 \n", | |
| "4 480 66 \n", | |
| "\n", | |
| " THUMBNAIL_COLUMN_POSITION \n", | |
| "id \n", | |
| "0 228 \n", | |
| "1 228 \n", | |
| "2 228 \n", | |
| "3 228 \n", | |
| "4 228 \n", | |
| "\n", | |
| "[5 rows x 312 columns]" | |
| ] | |
| }, | |
| "execution_count": 21, | |
| "metadata": {}, | |
| "output_type": "execute_result" | |
| } | |
| ], | |
| "source": [ | |
| "s.loc['RAW'].head()" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 22, | |
| "metadata": { | |
| "scrolled": false | |
| }, | |
| "outputs": [ | |
| { | |
| "data": { | |
| "text/html": [ | |
| "<div>\n", | |
| "<style scoped>\n", | |
| " .dataframe tbody tr th:only-of-type {\n", | |
| " vertical-align: middle;\n", | |
| " }\n", | |
| "\n", | |
| " .dataframe tbody tr th {\n", | |
| " vertical-align: top;\n", | |
| " }\n", | |
| "\n", | |
| " .dataframe thead th {\n", | |
| " text-align: right;\n", | |
| " }\n", | |
| "</style>\n", | |
| "<table border=\"1\" class=\"dataframe\">\n", | |
| " <thead>\n", | |
| " <tr style=\"text-align: right;\">\n", | |
| " <th></th>\n", | |
| " <th></th>\n", | |
| " <th>512.6</th>\n", | |
| " <th>518.4</th>\n", | |
| " <th>524.7</th>\n", | |
| " <th>530.4</th>\n", | |
| " <th>536.5</th>\n", | |
| " <th>542.8000000000001</th>\n", | |
| " <th>548.7</th>\n", | |
| " <th>554.5</th>\n", | |
| " <th>560.5</th>\n", | |
| " <th>566.7</th>\n", | |
| " <th>...</th>\n", | |
| " <th>CALIBRATION</th>\n", | |
| " <th>SP_PELTIER</th>\n", | |
| " <th>TC_MI_STATUS</th>\n", | |
| " <th>CLOCK_COUNT_ERR_FLAG</th>\n", | |
| " <th>SPATIAL_RESOLUTION_FLAG</th>\n", | |
| " <th>GEOMETRIC_INFO_RECAL_FLAG</th>\n", | |
| " <th>SUPPORT_IMAGE_LINE_POSITION</th>\n", | |
| " <th>SUPPORT_IMAGE_COLUMN_POSITION</th>\n", | |
| " <th>THUMBNAIL_LINE_POSITION</th>\n", | |
| " <th>THUMBNAIL_COLUMN_POSITION</th>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>minor</th>\n", | |
| " <th>id</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 rowspan=\"10\" valign=\"top\">REF1</th>\n", | |
| " <th>5</th>\n", | |
| " <td>0.0392</td>\n", | |
| " <td>0.0475</td>\n", | |
| " <td>0.0484</td>\n", | |
| " <td>0.0507</td>\n", | |
| " <td>0.0519</td>\n", | |
| " <td>0.0537</td>\n", | |
| " <td>0.0545</td>\n", | |
| " <td>0.0556</td>\n", | |
| " <td>0.0579</td>\n", | |
| " <td>0.0596</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0</td>\n", | |
| " <td>1</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>65</td>\n", | |
| " <td>67</td>\n", | |
| " <td>168</td>\n", | |
| " <td>480</td>\n", | |
| " <td>80</td>\n", | |
| " <td>228</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>6</th>\n", | |
| " <td>0.0392</td>\n", | |
| " <td>0.0476</td>\n", | |
| " <td>0.0485</td>\n", | |
| " <td>0.0507</td>\n", | |
| " <td>0.0519</td>\n", | |
| " <td>0.0538</td>\n", | |
| " <td>0.0546</td>\n", | |
| " <td>0.0558</td>\n", | |
| " <td>0.0581</td>\n", | |
| " <td>0.0598</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0</td>\n", | |
| " <td>1</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>65</td>\n", | |
| " <td>67</td>\n", | |
| " <td>196</td>\n", | |
| " <td>480</td>\n", | |
| " <td>93</td>\n", | |
| " <td>228</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>7</th>\n", | |
| " <td>0.0393</td>\n", | |
| " <td>0.0476</td>\n", | |
| " <td>0.0485</td>\n", | |
| " <td>0.0508</td>\n", | |
| " <td>0.0520</td>\n", | |
| " <td>0.0539</td>\n", | |
| " <td>0.0547</td>\n", | |
| " <td>0.0558</td>\n", | |
| " <td>0.0582</td>\n", | |
| " <td>0.0600</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0</td>\n", | |
| " <td>1</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>65</td>\n", | |
| " <td>67</td>\n", | |
| " <td>224</td>\n", | |
| " <td>480</td>\n", | |
| " <td>106</td>\n", | |
| " <td>228</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>8</th>\n", | |
| " <td>0.0406</td>\n", | |
| " <td>0.0492</td>\n", | |
| " <td>0.0501</td>\n", | |
| " <td>0.0525</td>\n", | |
| " <td>0.0537</td>\n", | |
| " <td>0.0557</td>\n", | |
| " <td>0.0565</td>\n", | |
| " <td>0.0576</td>\n", | |
| " <td>0.0600</td>\n", | |
| " <td>0.0618</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0</td>\n", | |
| " <td>1</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>65</td>\n", | |
| " <td>67</td>\n", | |
| " <td>252</td>\n", | |
| " <td>480</td>\n", | |
| " <td>120</td>\n", | |
| " <td>228</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>9</th>\n", | |
| " <td>0.0394</td>\n", | |
| " <td>0.0478</td>\n", | |
| " <td>0.0488</td>\n", | |
| " <td>0.0511</td>\n", | |
| " <td>0.0523</td>\n", | |
| " <td>0.0541</td>\n", | |
| " <td>0.0550</td>\n", | |
| " <td>0.0561</td>\n", | |
| " <td>0.0584</td>\n", | |
| " <td>0.0602</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0</td>\n", | |
| " <td>1</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>65</td>\n", | |
| " <td>67</td>\n", | |
| " <td>280</td>\n", | |
| " <td>480</td>\n", | |
| " <td>133</td>\n", | |
| " <td>228</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>10</th>\n", | |
| " <td>0.0422</td>\n", | |
| " <td>0.0513</td>\n", | |
| " <td>0.0523</td>\n", | |
| " <td>0.0547</td>\n", | |
| " <td>0.0559</td>\n", | |
| " <td>0.0579</td>\n", | |
| " <td>0.0588</td>\n", | |
| " <td>0.0600</td>\n", | |
| " <td>0.0625</td>\n", | |
| " <td>0.0643</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0</td>\n", | |
| " <td>1</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>65</td>\n", | |
| " <td>67</td>\n", | |
| " <td>308</td>\n", | |
| " <td>480</td>\n", | |
| " <td>146</td>\n", | |
| " <td>228</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>11</th>\n", | |
| " <td>0.0408</td>\n", | |
| " <td>0.0495</td>\n", | |
| " <td>0.0504</td>\n", | |
| " <td>0.0528</td>\n", | |
| " <td>0.0541</td>\n", | |
| " <td>0.0560</td>\n", | |
| " <td>0.0568</td>\n", | |
| " <td>0.0580</td>\n", | |
| " <td>0.0604</td>\n", | |
| " <td>0.0622</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0</td>\n", | |
| " <td>1</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>65</td>\n", | |
| " <td>67</td>\n", | |
| " <td>336</td>\n", | |
| " <td>480</td>\n", | |
| " <td>159</td>\n", | |
| " <td>228</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>12</th>\n", | |
| " <td>0.0412</td>\n", | |
| " <td>0.0500</td>\n", | |
| " <td>0.0509</td>\n", | |
| " <td>0.0533</td>\n", | |
| " <td>0.0546</td>\n", | |
| " <td>0.0565</td>\n", | |
| " <td>0.0574</td>\n", | |
| " <td>0.0586</td>\n", | |
| " <td>0.0610</td>\n", | |
| " <td>0.0628</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0</td>\n", | |
| " <td>1</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>65</td>\n", | |
| " <td>67</td>\n", | |
| " <td>364</td>\n", | |
| " <td>480</td>\n", | |
| " <td>173</td>\n", | |
| " <td>228</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>13</th>\n", | |
| " <td>0.0412</td>\n", | |
| " <td>0.0499</td>\n", | |
| " <td>0.0509</td>\n", | |
| " <td>0.0534</td>\n", | |
| " <td>0.0546</td>\n", | |
| " <td>0.0565</td>\n", | |
| " <td>0.0574</td>\n", | |
| " <td>0.0586</td>\n", | |
| " <td>0.0610</td>\n", | |
| " <td>0.0629</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0</td>\n", | |
| " <td>1</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>65</td>\n", | |
| " <td>67</td>\n", | |
| " <td>392</td>\n", | |
| " <td>480</td>\n", | |
| " <td>186</td>\n", | |
| " <td>228</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>14</th>\n", | |
| " <td>0.0417</td>\n", | |
| " <td>0.0507</td>\n", | |
| " <td>0.0517</td>\n", | |
| " <td>0.0541</td>\n", | |
| " <td>0.0554</td>\n", | |
| " <td>0.0573</td>\n", | |
| " <td>0.0583</td>\n", | |
| " <td>0.0594</td>\n", | |
| " <td>0.0618</td>\n", | |
| " <td>0.0636</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0</td>\n", | |
| " <td>1</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>65</td>\n", | |
| " <td>67</td>\n", | |
| " <td>420</td>\n", | |
| " <td>480</td>\n", | |
| " <td>199</td>\n", | |
| " <td>228</td>\n", | |
| " </tr>\n", | |
| " </tbody>\n", | |
| "</table>\n", | |
| "<p>10 rows × 312 columns</p>\n", | |
| "</div>" | |
| ], | |
| "text/plain": [ | |
| " 512.6 518.4 524.7 530.4 536.5 542.8000000000001 548.7 \\\n", | |
| "minor id \n", | |
| "REF1 5 0.0392 0.0475 0.0484 0.0507 0.0519 0.0537 0.0545 \n", | |
| " 6 0.0392 0.0476 0.0485 0.0507 0.0519 0.0538 0.0546 \n", | |
| " 7 0.0393 0.0476 0.0485 0.0508 0.0520 0.0539 0.0547 \n", | |
| " 8 0.0406 0.0492 0.0501 0.0525 0.0537 0.0557 0.0565 \n", | |
| " 9 0.0394 0.0478 0.0488 0.0511 0.0523 0.0541 0.0550 \n", | |
| " 10 0.0422 0.0513 0.0523 0.0547 0.0559 0.0579 0.0588 \n", | |
| " 11 0.0408 0.0495 0.0504 0.0528 0.0541 0.0560 0.0568 \n", | |
| " 12 0.0412 0.0500 0.0509 0.0533 0.0546 0.0565 0.0574 \n", | |
| " 13 0.0412 0.0499 0.0509 0.0534 0.0546 0.0565 0.0574 \n", | |
| " 14 0.0417 0.0507 0.0517 0.0541 0.0554 0.0573 0.0583 \n", | |
| "\n", | |
| " 554.5 560.5 566.7 ... CALIBRATION \\\n", | |
| "minor id ... \n", | |
| "REF1 5 0.0556 0.0579 0.0596 ... 0 \n", | |
| " 6 0.0558 0.0581 0.0598 ... 0 \n", | |
| " 7 0.0558 0.0582 0.0600 ... 0 \n", | |
| " 8 0.0576 0.0600 0.0618 ... 0 \n", | |
| " 9 0.0561 0.0584 0.0602 ... 0 \n", | |
| " 10 0.0600 0.0625 0.0643 ... 0 \n", | |
| " 11 0.0580 0.0604 0.0622 ... 0 \n", | |
| " 12 0.0586 0.0610 0.0628 ... 0 \n", | |
| " 13 0.0586 0.0610 0.0629 ... 0 \n", | |
| " 14 0.0594 0.0618 0.0636 ... 0 \n", | |
| "\n", | |
| " SP_PELTIER TC_MI_STATUS CLOCK_COUNT_ERR_FLAG \\\n", | |
| "minor id \n", | |
| "REF1 5 1 1 0 \n", | |
| " 6 1 1 0 \n", | |
| " 7 1 1 0 \n", | |
| " 8 1 1 0 \n", | |
| " 9 1 1 0 \n", | |
| " 10 1 1 0 \n", | |
| " 11 1 1 0 \n", | |
| " 12 1 1 0 \n", | |
| " 13 1 1 0 \n", | |
| " 14 1 1 0 \n", | |
| "\n", | |
| " SPATIAL_RESOLUTION_FLAG GEOMETRIC_INFO_RECAL_FLAG \\\n", | |
| "minor id \n", | |
| "REF1 5 65 67 \n", | |
| " 6 65 67 \n", | |
| " 7 65 67 \n", | |
| " 8 65 67 \n", | |
| " 9 65 67 \n", | |
| " 10 65 67 \n", | |
| " 11 65 67 \n", | |
| " 12 65 67 \n", | |
| " 13 65 67 \n", | |
| " 14 65 67 \n", | |
| "\n", | |
| " SUPPORT_IMAGE_LINE_POSITION SUPPORT_IMAGE_COLUMN_POSITION \\\n", | |
| "minor id \n", | |
| "REF1 5 168 480 \n", | |
| " 6 196 480 \n", | |
| " 7 224 480 \n", | |
| " 8 252 480 \n", | |
| " 9 280 480 \n", | |
| " 10 308 480 \n", | |
| " 11 336 480 \n", | |
| " 12 364 480 \n", | |
| " 13 392 480 \n", | |
| " 14 420 480 \n", | |
| "\n", | |
| " THUMBNAIL_LINE_POSITION THUMBNAIL_COLUMN_POSITION \n", | |
| "minor id \n", | |
| "REF1 5 80 228 \n", | |
| " 6 93 228 \n", | |
| " 7 106 228 \n", | |
| " 8 120 228 \n", | |
| " 9 133 228 \n", | |
| " 10 146 228 \n", | |
| " 11 159 228 \n", | |
| " 12 173 228 \n", | |
| " 13 186 228 \n", | |
| " 14 199 228 \n", | |
| "\n", | |
| "[10 rows x 312 columns]" | |
| ] | |
| }, | |
| "execution_count": 22, | |
| "metadata": {}, | |
| "output_type": "execute_result" | |
| } | |
| ], | |
| "source": [ | |
| "s.loc['REF1', list(range(5,100))].head(10)" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 23, | |
| "metadata": {}, | |
| "outputs": [ | |
| { | |
| "data": { | |
| "text/html": [ | |
| "<div>\n", | |
| "<style scoped>\n", | |
| " .dataframe tbody tr th:only-of-type {\n", | |
| " vertical-align: middle;\n", | |
| " }\n", | |
| "\n", | |
| " .dataframe tbody tr th {\n", | |
| " vertical-align: top;\n", | |
| " }\n", | |
| "\n", | |
| " .dataframe thead th {\n", | |
| " text-align: right;\n", | |
| " }\n", | |
| "</style>\n", | |
| "<table border=\"1\" class=\"dataframe\">\n", | |
| " <thead>\n", | |
| " <tr style=\"text-align: right;\">\n", | |
| " <th></th>\n", | |
| " <th>512.6</th>\n", | |
| " <th>518.4</th>\n", | |
| " <th>524.7</th>\n", | |
| " <th>530.4</th>\n", | |
| " <th>536.5</th>\n", | |
| " <th>542.8000000000001</th>\n", | |
| " <th>548.7</th>\n", | |
| " <th>554.5</th>\n", | |
| " <th>560.5</th>\n", | |
| " <th>566.7</th>\n", | |
| " <th>...</th>\n", | |
| " <th>CALIBRATION</th>\n", | |
| " <th>SP_PELTIER</th>\n", | |
| " <th>TC_MI_STATUS</th>\n", | |
| " <th>CLOCK_COUNT_ERR_FLAG</th>\n", | |
| " <th>SPATIAL_RESOLUTION_FLAG</th>\n", | |
| " <th>GEOMETRIC_INFO_RECAL_FLAG</th>\n", | |
| " <th>SUPPORT_IMAGE_LINE_POSITION</th>\n", | |
| " <th>SUPPORT_IMAGE_COLUMN_POSITION</th>\n", | |
| " <th>THUMBNAIL_LINE_POSITION</th>\n", | |
| " <th>THUMBNAIL_COLUMN_POSITION</th>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>id</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>0</th>\n", | |
| " <td>0.0402</td>\n", | |
| " <td>0.0487</td>\n", | |
| " <td>0.0497</td>\n", | |
| " <td>0.0520</td>\n", | |
| " <td>0.0532</td>\n", | |
| " <td>0.0551</td>\n", | |
| " <td>0.0559</td>\n", | |
| " <td>0.0571</td>\n", | |
| " <td>0.0594</td>\n", | |
| " <td>0.0612</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0</td>\n", | |
| " <td>1</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>65</td>\n", | |
| " <td>67</td>\n", | |
| " <td>27</td>\n", | |
| " <td>480</td>\n", | |
| " <td>13</td>\n", | |
| " <td>228</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>1</th>\n", | |
| " <td>0.0414</td>\n", | |
| " <td>0.0502</td>\n", | |
| " <td>0.0513</td>\n", | |
| " <td>0.0537</td>\n", | |
| " <td>0.0549</td>\n", | |
| " <td>0.0568</td>\n", | |
| " <td>0.0576</td>\n", | |
| " <td>0.0588</td>\n", | |
| " <td>0.0612</td>\n", | |
| " <td>0.0631</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0</td>\n", | |
| " <td>1</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>65</td>\n", | |
| " <td>67</td>\n", | |
| " <td>55</td>\n", | |
| " <td>480</td>\n", | |
| " <td>27</td>\n", | |
| " <td>228</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2</th>\n", | |
| " <td>0.0391</td>\n", | |
| " <td>0.0474</td>\n", | |
| " <td>0.0484</td>\n", | |
| " <td>0.0506</td>\n", | |
| " <td>0.0518</td>\n", | |
| " <td>0.0537</td>\n", | |
| " <td>0.0545</td>\n", | |
| " <td>0.0556</td>\n", | |
| " <td>0.0579</td>\n", | |
| " <td>0.0596</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0</td>\n", | |
| " <td>1</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>65</td>\n", | |
| " <td>67</td>\n", | |
| " <td>83</td>\n", | |
| " <td>480</td>\n", | |
| " <td>40</td>\n", | |
| " <td>228</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>3</th>\n", | |
| " <td>0.0393</td>\n", | |
| " <td>0.0476</td>\n", | |
| " <td>0.0486</td>\n", | |
| " <td>0.0508</td>\n", | |
| " <td>0.0521</td>\n", | |
| " <td>0.0539</td>\n", | |
| " <td>0.0548</td>\n", | |
| " <td>0.0559</td>\n", | |
| " <td>0.0582</td>\n", | |
| " <td>0.0600</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0</td>\n", | |
| " <td>1</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>65</td>\n", | |
| " <td>67</td>\n", | |
| " <td>112</td>\n", | |
| " <td>480</td>\n", | |
| " <td>53</td>\n", | |
| " <td>228</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>4</th>\n", | |
| " <td>0.0393</td>\n", | |
| " <td>0.0477</td>\n", | |
| " <td>0.0487</td>\n", | |
| " <td>0.0509</td>\n", | |
| " <td>0.0522</td>\n", | |
| " <td>0.0540</td>\n", | |
| " <td>0.0548</td>\n", | |
| " <td>0.0560</td>\n", | |
| " <td>0.0582</td>\n", | |
| " <td>0.0599</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0</td>\n", | |
| " <td>1</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>65</td>\n", | |
| " <td>67</td>\n", | |
| " <td>140</td>\n", | |
| " <td>480</td>\n", | |
| " <td>66</td>\n", | |
| " <td>228</td>\n", | |
| " </tr>\n", | |
| " </tbody>\n", | |
| "</table>\n", | |
| "<p>5 rows × 312 columns</p>\n", | |
| "</div>" | |
| ], | |
| "text/plain": [ | |
| " 512.6 518.4 524.7 530.4 536.5 542.8000000000001 548.7 554.5 \\\n", | |
| "id \n", | |
| "0 0.0402 0.0487 0.0497 0.0520 0.0532 0.0551 0.0559 0.0571 \n", | |
| "1 0.0414 0.0502 0.0513 0.0537 0.0549 0.0568 0.0576 0.0588 \n", | |
| "2 0.0391 0.0474 0.0484 0.0506 0.0518 0.0537 0.0545 0.0556 \n", | |
| "3 0.0393 0.0476 0.0486 0.0508 0.0521 0.0539 0.0548 0.0559 \n", | |
| "4 0.0393 0.0477 0.0487 0.0509 0.0522 0.0540 0.0548 0.0560 \n", | |
| "\n", | |
| " 560.5 566.7 ... CALIBRATION SP_PELTIER \\\n", | |
| "id ... \n", | |
| "0 0.0594 0.0612 ... 0 1 \n", | |
| "1 0.0612 0.0631 ... 0 1 \n", | |
| "2 0.0579 0.0596 ... 0 1 \n", | |
| "3 0.0582 0.0600 ... 0 1 \n", | |
| "4 0.0582 0.0599 ... 0 1 \n", | |
| "\n", | |
| " TC_MI_STATUS CLOCK_COUNT_ERR_FLAG SPATIAL_RESOLUTION_FLAG \\\n", | |
| "id \n", | |
| "0 1 0 65 \n", | |
| "1 1 0 65 \n", | |
| "2 1 0 65 \n", | |
| "3 1 0 65 \n", | |
| "4 1 0 65 \n", | |
| "\n", | |
| " GEOMETRIC_INFO_RECAL_FLAG SUPPORT_IMAGE_LINE_POSITION \\\n", | |
| "id \n", | |
| "0 67 27 \n", | |
| "1 67 55 \n", | |
| "2 67 83 \n", | |
| "3 67 112 \n", | |
| "4 67 140 \n", | |
| "\n", | |
| " SUPPORT_IMAGE_COLUMN_POSITION THUMBNAIL_LINE_POSITION \\\n", | |
| "id \n", | |
| "0 480 13 \n", | |
| "1 480 27 \n", | |
| "2 480 40 \n", | |
| "3 480 53 \n", | |
| "4 480 66 \n", | |
| "\n", | |
| " THUMBNAIL_COLUMN_POSITION \n", | |
| "id \n", | |
| "0 228 \n", | |
| "1 228 \n", | |
| "2 228 \n", | |
| "3 228 \n", | |
| "4 228 \n", | |
| "\n", | |
| "[5 rows x 312 columns]" | |
| ] | |
| }, | |
| "execution_count": 23, | |
| "metadata": {}, | |
| "output_type": "execute_result" | |
| } | |
| ], | |
| "source": [ | |
| "ref1 = s.loc['REF1']\n", | |
| "ref1.head()" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 24, | |
| "metadata": {}, | |
| "outputs": [ | |
| { | |
| "name": "stderr", | |
| "output_type": "stream", | |
| "text": [ | |
| "/Users/krodriguez/repos/PySAT/libpysat/utils/utils.py:276: RuntimeWarning: invalid value encountered in true_divide\n", | |
| " corrected = ref_array / y\n" | |
| ] | |
| }, | |
| { | |
| "data": { | |
| "text/html": [ | |
| "<div>\n", | |
| "<style scoped>\n", | |
| " .dataframe tbody tr th:only-of-type {\n", | |
| " vertical-align: middle;\n", | |
| " }\n", | |
| "\n", | |
| " .dataframe tbody tr th {\n", | |
| " vertical-align: top;\n", | |
| " }\n", | |
| "\n", | |
| " .dataframe thead th {\n", | |
| " text-align: right;\n", | |
| " }\n", | |
| "</style>\n", | |
| "<table border=\"1\" class=\"dataframe\">\n", | |
| " <thead>\n", | |
| " <tr style=\"text-align: right;\">\n", | |
| " <th></th>\n", | |
| " <th>512.6</th>\n", | |
| " <th>518.4</th>\n", | |
| " <th>524.7</th>\n", | |
| " <th>530.4</th>\n", | |
| " <th>536.5</th>\n", | |
| " <th>542.8000000000001</th>\n", | |
| " <th>548.7</th>\n", | |
| " <th>554.5</th>\n", | |
| " <th>560.5</th>\n", | |
| " <th>566.7</th>\n", | |
| " <th>...</th>\n", | |
| " <th>2516.1000000000004</th>\n", | |
| " <th>2524.1000000000004</th>\n", | |
| " <th>2532.1000000000004</th>\n", | |
| " <th>2540.0</th>\n", | |
| " <th>2548.0</th>\n", | |
| " <th>2556.0</th>\n", | |
| " <th>2564.0</th>\n", | |
| " <th>2572.0</th>\n", | |
| " <th>2579.9</th>\n", | |
| " <th>2587.9</th>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>id</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>0</th>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.000000</td>\n", | |
| " <td>0.000000</td>\n", | |
| " <td>0.000000</td>\n", | |
| " <td>0.000000</td>\n", | |
| " <td>0.000000</td>\n", | |
| " <td>0.000000</td>\n", | |
| " <td>0.000000</td>\n", | |
| " <td>0.000000</td>\n", | |
| " <td>0.000000</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.000000</td>\n", | |
| " <td>0.000000</td>\n", | |
| " <td>0.000000</td>\n", | |
| " <td>0.000000</td>\n", | |
| " <td>0.000000</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.000000</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.000000</td>\n", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>1</th>\n", | |
| " <td>1.0</td>\n", | |
| " <td>1.215959</td>\n", | |
| " <td>1.246398</td>\n", | |
| " <td>1.308323</td>\n", | |
| " <td>1.341537</td>\n", | |
| " <td>1.392241</td>\n", | |
| " <td>1.415935</td>\n", | |
| " <td>1.449556</td>\n", | |
| " <td>1.513187</td>\n", | |
| " <td>1.564951</td>\n", | |
| " <td>...</td>\n", | |
| " <td>77.216698</td>\n", | |
| " <td>95.070381</td>\n", | |
| " <td>50.217854</td>\n", | |
| " <td>19.360509</td>\n", | |
| " <td>0.000000</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.000000</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>78.325030</td>\n", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2</th>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.000000</td>\n", | |
| " <td>0.000000</td>\n", | |
| " <td>0.000000</td>\n", | |
| " <td>0.000000</td>\n", | |
| " <td>0.000000</td>\n", | |
| " <td>0.000000</td>\n", | |
| " <td>0.000000</td>\n", | |
| " <td>0.000000</td>\n", | |
| " <td>0.000000</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.000000</td>\n", | |
| " <td>0.000000</td>\n", | |
| " <td>0.000000</td>\n", | |
| " <td>0.000000</td>\n", | |
| " <td>0.000000</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.000000</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.000000</td>\n", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>3</th>\n", | |
| " <td>1.0</td>\n", | |
| " <td>1.214590</td>\n", | |
| " <td>1.243894</td>\n", | |
| " <td>1.303804</td>\n", | |
| " <td>1.341145</td>\n", | |
| " <td>1.391754</td>\n", | |
| " <td>1.419087</td>\n", | |
| " <td>1.451701</td>\n", | |
| " <td>1.515905</td>\n", | |
| " <td>1.567582</td>\n", | |
| " <td>...</td>\n", | |
| " <td>77.150613</td>\n", | |
| " <td>92.121886</td>\n", | |
| " <td>73.342522</td>\n", | |
| " <td>0.000000</td>\n", | |
| " <td>17.469858</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>21.652922</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>417.832347</td>\n", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>4</th>\n", | |
| " <td>1.0</td>\n", | |
| " <td>1.217142</td>\n", | |
| " <td>1.246453</td>\n", | |
| " <td>1.306370</td>\n", | |
| " <td>1.343719</td>\n", | |
| " <td>1.394336</td>\n", | |
| " <td>1.419087</td>\n", | |
| " <td>1.454298</td>\n", | |
| " <td>1.515905</td>\n", | |
| " <td>1.564969</td>\n", | |
| " <td>...</td>\n", | |
| " <td>81.416328</td>\n", | |
| " <td>97.336333</td>\n", | |
| " <td>57.349120</td>\n", | |
| " <td>0.000000</td>\n", | |
| " <td>0.000000</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.000000</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>111.553976</td>\n", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " </tbody>\n", | |
| "</table>\n", | |
| "<p>5 rows × 269 columns</p>\n", | |
| "</div>" | |
| ], | |
| "text/plain": [ | |
| " 512.6 518.4 524.7 530.4 536.5 542.8 548.7 \\\n", | |
| "id \n", | |
| "0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 \n", | |
| "1 1.0 1.215959 1.246398 1.308323 1.341537 1.392241 1.415935 \n", | |
| "2 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 \n", | |
| "3 1.0 1.214590 1.243894 1.303804 1.341145 1.391754 1.419087 \n", | |
| "4 1.0 1.217142 1.246453 1.306370 1.343719 1.394336 1.419087 \n", | |
| "\n", | |
| " 554.5 560.5 566.7 ... 2516.1 2524.1 2532.1 \\\n", | |
| "id ... \n", | |
| "0 0.000000 0.000000 0.000000 ... 0.000000 0.000000 0.000000 \n", | |
| "1 1.449556 1.513187 1.564951 ... 77.216698 95.070381 50.217854 \n", | |
| "2 0.000000 0.000000 0.000000 ... 0.000000 0.000000 0.000000 \n", | |
| "3 1.451701 1.515905 1.567582 ... 77.150613 92.121886 73.342522 \n", | |
| "4 1.454298 1.515905 1.564969 ... 81.416328 97.336333 57.349120 \n", | |
| "\n", | |
| " 2540.0 2548.0 2556.0 2564.0 2572.0 2579.9 2587.9 \n", | |
| "id \n", | |
| "0 0.000000 0.000000 0.0 0.000000 0.0 0.000000 0.0 \n", | |
| "1 19.360509 0.000000 0.0 0.000000 0.0 78.325030 0.0 \n", | |
| "2 0.000000 0.000000 0.0 0.000000 0.0 0.000000 0.0 \n", | |
| "3 0.000000 17.469858 0.0 21.652922 0.0 417.832347 0.0 \n", | |
| "4 0.000000 0.000000 0.0 0.000000 0.0 111.553976 0.0 \n", | |
| "\n", | |
| "[5 rows x 269 columns]" | |
| ] | |
| }, | |
| "execution_count": 24, | |
| "metadata": {}, | |
| "output_type": "execute_result" | |
| } | |
| ], | |
| "source": [ | |
| "ref1corr = ref1.linear_correction()\n", | |
| "ref1corr.head()" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 28, | |
| "metadata": { | |
| "scrolled": false | |
| }, | |
| "outputs": [ | |
| { | |
| "data": { | |
| "text/plain": [ | |
| "<matplotlib.axes._subplots.AxesSubplot at 0x1a2782b550>" | |
| ] | |
| }, | |
| "execution_count": 28, | |
| "metadata": {}, | |
| "output_type": "execute_result" | |
| }, | |
| { | |
| "data": { | |
| "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXcAAAD2CAYAAAAtW8c3AAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMS4xLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvAOZPmwAAD1hJREFUeJzt3X+s3Xddx/Hnq20KCkPDemfi2q6LFrBZUOLNNPKHEDHp+GNVAbNFEkkW+tfwD8BkRLOQqUHRhH8oiU0kRBKZgz+0McUlwgjEMLIuCLEdNaWIu9S48mP80MGs5+0f5+f39Pbes+6055zPno+E3HPO/fT2c/vHc18+38/3+01VIUlqy45FT0CSNH/GXZIaZNwlqUHGXZIaZNwlqUHGXZIatNC4J/lwkqeS/OsMY29J8qkkX07ymSR7r8ccJWkVLfrI/SPA4RnH/gXw11X1auAB4H3XalKStOoWGveq+izw7cnPkvxMkn9M8niSzyV51eBbh4BPDV4/Ahy5jlOVpJWy6CP3zRwH3lFVvwi8G/jQ4PMvAW8avP5N4IYkNy5gfpK09HYtegKTkrwU+BXg40mGH79o8PXdwAeTvA34LPAN4NL1nqMkrYKlijv9/yfxdFX9wvQ3quoC8Fsw+o/Am6rqu9d5fpK0EpZqWaaqvgd8LclbANL384PXe5IM5/se4MMLmqYkLb1Fb4X8GPB54JVJNpLcA/wOcE+SLwGnGZ84fR1wNsm/AT8F/MkCpixJKyHe8leS2rNUyzKSpPkw7pLUoIXtltmzZ08dOHBgUX+9JK2kxx9//JtVtbbduIXF/cCBA5w6dWpRf70kraQkX59lnMsyktQg4y5JDTLuktQg4y5JDTLuktQg4y5JDTLuktQg4y6pCd/8wY947Z9+mnNPfX/RU1kKxl1SEy48/QzfePoZzl/870VPZSkYd0lNGN7g1vvc9hl3SU0YRt27mPcZd0lN6A2q7jMq+oy7pCa4LNNl3CU1YnjkvuBpLAnjLqkJ4yN36w7GXVIjetX9+kJn3CU1oTyh2mHcJTXBpHcZd0lNGG+FXPBEloRxl9SG0Zq7dQfjLqkRXqHaZdwlNcGLmLqMu6QmDJdjXJbpM+6SmlCXvXhhM+6SmjDa527dgRnjnuRwkrNJziW5b5Pv70/ySJIvJvlykjfOf6qSdGWeUO3aNu5JdgLHgDuAQ8DdSQ5NDftD4KGqeg1wF/CheU9UkrZSozX3BU9kScxy5H47cK6qzlfVs8CDwJGpMQW8bPD6J4AL85uiJG3PG4d1zRL3m4EnJ95vDD6b9F7grUk2gJPAOzb7QUmOJjmV5NTFixevYrqStLlR3G07MFvcs8ln0/98dwMfqaq9wBuBjya57GdX1fGqWq+q9bW1tec+W0m6gpr6+kI3S9w3gH0T7/dy+bLLPcBDAFX1eeDFwJ55TFCSZuFj9rpmiftjwMEktybZTf+E6YmpMf8B/BpAkp+jH3fXXSRdNy7LdG0b96q6BNwLPAw8QX9XzOkkDyS5czDsXcDbk3wJ+BjwtvI/n5KuK4/cJ+2aZVBVnaR/onTys/snXp8BXjvfqUnS7HreW6bDK1QlNWF4wO4+9z7jLqkJ5bJMh3GX1ASb3mXcJTXBx+x1GXdJTfF+7n3GXVITfBJTl3GX1ITxCdUFT2RJGHdJTej1Bl+tO2DcJTXCpHcZd0lNKG8c1mHcJTXBG4d1GXdJTRieUPX2A33GXVITfMxel3GX1ITRk5hsO2DcJTVidPuBBc9jWRh3SU0Yn1A172DcJTXCZZku4y6pDaNlGesOxl1SI3ruc+8w7pKaMFxrd597n3GX1ITRmrvLMoBxl9SIGtddGHdJjeiNlmWsOxh3SY2x7X3GXVITfMxel3GX1ITR7QesO2DcJTVi2HTX3PuMu6Qm2PQu4y6pCcP97d44rM+4S2qCJ1S7jLukJpT73DuMu6Qm+IDsLuMuqQnefaDLuEtqgvvcu4y7pCb4mL2umeKe5HCSs0nOJbnvCmN+O8mZJKeT/M18pylJW/Mxe127thuQZCdwDPh1YAN4LMmJqjozMeYg8B7gtVX1nSQ3XasJS9Jmysfsdcxy5H47cK6qzlfVs8CDwJGpMW8HjlXVdwCq6qn5TlOStuZuma5Z4n4z8OTE+43BZ5NeAbwiyT8neTTJ4XlNUJJmMTxi9zF7fdsuywDZ5LPpf75dwEHgdcBe4HNJbquqpzs/KDkKHAXYv3//c56sJF3J+ApV6w6zHblvAPsm3u8FLmwy5u+r6n+r6mvAWfqx76iq41W1XlXra2trVztnSbpMz43uHbPE/THgYJJbk+wG7gJOTI35O+D1AEn20F+mOT/PiUrSVsbLMtYdZoh7VV0C7gUeBp4AHqqq00keSHLnYNjDwLeSnAEeAX6/qr51rSYtSZfxxmEds6y5U1UngZNTn90/8bqAdw7+J0nXnfvcu7xCVVITer3hPneBcZfUCB+z12XcJTWh3C3TYdwlNaHn7Qc6jLukprgq02fcJTXBx+x1GXdJTXArZJdxl9SE8Zq7wLhLaoS3/O0y7pKaMF6Wse5g3CU1ory3TIdxl9SE0WP2PHIHjLukRgyb7pOY+oy7pCYMr0y17X3GXVITxrtlzDsYd0mNcDmmy7hLaoKP2esy7pLa4EVMHcZdUhNGtx8w7oBxl9SI8bM6rDsYd0mNcJ97l3GX1IS67MULm3GX1AQfs9dl3CW1wd0yHcZdUhPc595l3CU1wVv+dhl3SU1wn3uXcZfUBI/cu4y7pCb4mL0u4y6pCeWyTIdxl9SE8bKMdQfjLqkRw6T3egudxtIw7pKaMFqWWfA8loVxl9SE3ugKVfMOxl1SI0x610xxT3I4ydkk55Lct8W4NyepJOvzm6IkbW94xO7tB/q2jXuSncAx4A7gEHB3kkObjLsB+D3gC/OepCTNyrb3zXLkfjtwrqrOV9WzwIPAkU3G/RHwfuCHc5yfJM2k5wnVjlnifjPw5MT7jcFnI0leA+yrqn+Y49wkaWblCdWOWeKeTT4b/esl2QF8AHjXtj8oOZrkVJJTFy9enH2WkrSN8n7uHbPEfQPYN/F+L3Bh4v0NwG3AZ5L8O/DLwInNTqpW1fGqWq+q9bW1tauftSRNGV6Zatv7Zon7Y8DBJLcm2Q3cBZwYfrOqvltVe6rqQFUdAB4F7qyqU9dkxpK0Cfe5d20b96q6BNwLPAw8ATxUVaeTPJDkzms9QUmaibf87dg1y6CqOgmcnPrs/iuMfd3zn5YkPTc+Zq/LK1QlNaHnCdUO4y6pCd7Pvcu4S2qCT2LqMu6SmuAzVLuMu6QmuCzTZdwlNWG0LOOxO2DcJTVieMTes+2AcZfUiNHtB4w7YNwlNWL8YGzrDsZdUiPGWyEXOo2lYdwlNcHH7HUZd0lNcJ97l3GX1ARPqHYZd0lN8DF7XcZdUhM8odpl3CU1YXgi1bb3GXdJbXBZpsO4S2pCTX19oTPukprgPvcu4y6pCT5mr8u4S2rCaJ/7guexLIy7pCa4z73LuEtqQrks02HcJTWh3OfeYdwlNWF8hap5B+MuqRE+Zq/LuEtqgvvbu4y7pCZMpt2lGeMuqRGTPbftxl1SM8ZFd4nGuEtqxOSJVNNu3CU1YnKd3QN34y6pEZ0Tqh67G3dJbfCEapdxl9SEnssyHTPFPcnhJGeTnEty3ybff2eSM0m+nORTSW6Z/1QlaQudE6rWfdu4J9kJHAPuAA4Bdyc5NDXsi8B6Vb0a+ATw/nlPVJK20r2IaWHTWBqzHLnfDpyrqvNV9SzwIHBkckBVPVJV/zN4+yiwd77TlKStTS7LuM99trjfDDw58X5j8NmV3AN88vlMSpKeqyrYkcHrxU5lKeyaYUw2+WzTf7skbwXWgV+9wvePAkcB9u/fP+MUJWl7RbFzR+j9X7ksw2xH7hvAvon3e4EL04OSvAH4A+DOqvrRZj+oqo5X1XpVra+trV3NfCVpU1WQZPDaus8S98eAg0luTbIbuAs4MTkgyWuAv6Qf9qfmP01J2lpnWca2bx/3qroE3As8DDwBPFRVp5M8kOTOwbA/B14KfDzJvyQ5cYUfJ0nXRFHsHB65L3guy2CWNXeq6iRwcuqz+ydev2HO85Kk56QKduxwWWbIK1QlNaGAHYMjdx+1Z9wlNaJX/d0y4BWqYNwlNaJ/QtWN7kPGXVIzvIhpzLhLWnnDE6jjNXfzbtwlrbzhCdTRmrttN+6SVt/oyH1QNNtu3CU1YBjzHd5+YMS4S1p5vak1d9tu3CU1YBhz7y0zZtwlNcOLmMaMu6SVNz5y9/YDQ8Zd0sobrrl7P/cx4y5p5Q1TvtOtkCPGXdLKGx6p73S3zIhxl7Tyhi13WWbMuEtaedXrfx3vlpFxl7Tyhlsf3ec+ZtwlrbzprZDuczfukhowffuBXm+Rs1kOxl3SyhtvhfTIfci4S1p5w2WZuOY+YtwlrbzhkfrwyF3GXVIDhkfqO33M3ohxl7TyxssyXqE6ZNwlrbzL9rkvcC7LwrhLWnmjZZkd3n5gyLhLWnmjfe47vJ/7kHGXtPKmr1B1Yca4S2qI95YZM+6SVt7lWyEXOJklYdwlrbzpNXdPqBp3SQ0YptytkGPGXdLKGz1mb4cXMQ0Zd0krrzd9P3frbtwltaB7P3fTPmPckxxOcjbJuST3bfL9FyX528H3v5DkwLwnKklXMt7n3n3/QrZt3JPsBI4BdwCHgLuTHJoadg/wnar6WeADwJ/Ne6KSdCWjE6o+rGNk1wxjbgfOVdV5gCQPAkeAMxNjjgDvHbz+BPDBJKlrsPD11Ys/4Cv/+f15/1hJK+zC088A433uj57/Ft975tIip7Sl225+Gbfc+JJr+nfMEvebgScn3m8Av3SlMVV1Kcl3gRuBb04OSnIUOAqwf//+q5rwP535L973ya9c1Z+V1LZb1/rBPPbIVxc8k6398W/cthRx3+zRJtNH5LOMoaqOA8cB1tfXr+qo/i3r+3j9q266mj8qqWEv3rWT/Tf+OK9/5U384EfLe9QOcNMNL7rmf8cscd8A9k283wtcuMKYjSS7gJ8Avj2XGU55+Ut28/KX7L4WP1pSA376J39s0VNYCrPslnkMOJjk1iS7gbuAE1NjTgC/O3j9ZuDT12K9XZI0m22P3Adr6PcCDwM7gQ9X1ekkDwCnquoE8FfAR5Oco3/Efte1nLQkaWuzLMtQVSeBk1Of3T/x+ofAW+Y7NUnS1fIKVUlqkHGXpAYZd0lqkHGXpAZlUTsWk1wEvn6Vf3wPU1e/riB/h+Xg77Ac/B1md0tVrW03aGFxfz6SnKqq9UXP4/nwd1gO/g7Lwd9h/lyWkaQGGXdJatCqxv34oicwB/4Oy8HfYTn4O8zZSq65S5K2tqpH7pKkLRh3SWqQcZekBhl3SWqQcZekBv0/oM5uZvF3KnIAAAAASUVORK5CYII=\n", | |
| "text/plain": [ | |
| "<matplotlib.figure.Figure at 0x1a277f65f8>" | |
| ] | |
| }, | |
| "metadata": {}, | |
| "output_type": "display_data" | |
| } | |
| ], | |
| "source": [ | |
| "ref1.iloc[4].plot()" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 29, | |
| "metadata": {}, | |
| "outputs": [ | |
| { | |
| "data": { | |
| "text/plain": [ | |
| "<matplotlib.axes._subplots.AxesSubplot at 0x1a277f64a8>" | |
| ] | |
| }, | |
| "execution_count": 29, | |
| "metadata": {}, | |
| "output_type": "execute_result" | |
| }, | |
| { | |
| "data": { | |
| "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXoAAAD8CAYAAAB5Pm/hAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMS4xLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvAOZPmwAAIABJREFUeJzt3XmUnGd15/Hvrb33Ta2tW7JkIVte5UXBxhACNtgYiO0QJyEhwRAznjMhJITMgElmTjJn5iSQk0BIwnHGxhCTMMTEkNhhnBjHeEkMNpa8yLvc1tpqSd3qfav9mT/qreqtelN3rf37nKNTVW+96nr6pXy5us/z3secc4iISPXylXoAIiJSWAr0IiJVToFeRKTKKdCLiFQ5BXoRkSqnQC8iUuUU6EVEqpwCvYhIlVOgFxGpcoFSDwBg3bp1btu2baUehohIRdm3b99p51z7YueVRaDftm0be/fuLfUwREQqipkdWcp5Kt2IiFQ5BXoRkSqnQC8iUuUU6EVEqpwCvYhIlVOgFxGpcgr0IiJVToFeRKTIkqk039l7jHS6OFu5KtCLiBTZTw4P8Nn79vPcsaGifJ4CvYhIkSVSmUw+mUoX5fMU6EVEisy5TKAvTuFGgV5EpOi8OE/aqUYvIlKVXDaXL1JKr0AvIlJkaa80X6RFNwr0IiLF5nKPKt2IiFSlbG1eGb2ISJXKzsE6TcaKiFSn3PJKZfQiItVJNXoRkSqXq9EX58ZYBXoRkWJzxV1Gr0AvIlJsU6tuVLoREalqmowVEalS6dyqG2X0IiJVqexq9Gb2dTPrNbOXph1rNbOHzewN77HFO25m9hdm1mVm+83sskIOXkSkEqXLsHvl3wDvm3XsduAR59xO4BHvNcD1wE7vz23AHaszTBGR6lF2N0w5554ABmYdvhG4x3t+D3DTtOPfdBlPAc1mtmm1BisiUg0qpR/9BufcCQDvcb13vAM4Nu28bu+YiIh4inVHbNZqT8ZanmN5fyMzu83M9prZ3r6+vlUehohI8X310S7+7qkji55XjjX6fE5lSzLeY693vBvYMu28TqAn3w9wzt3pnNvjnNvT3t5+hsMQESkf//xCDw+9fHLR83KlmzJvgfAAcIv3/Bbg/mnHP+qtvrkSGM6WeEREql0ilSaaSC16XrrcNgc3s28DPwbONbNuM7sV+ALwXjN7A3iv9xrgQeAg0AXcBfxGQUYtIlKG4qk0k4kU0USKrt7Rec/LBvhilW4Ci53gnPvled66Js+5DvjkSgclIlKJEklHNJHmH/Z187++/wr7/+BaIkH/nPNcke+Y0p2xIiKrJJFKMxlP0T8WI55ME0vkL8IXe3nlohm9iIgsTTyZxgwm45k6fXKe2dayq9GLiMhcL/cM86UfvE5q2g7fcS+jn8gF+vyhXBm9iEgFuOuJg/zT8z0E/T4+dc1OnHPEU2mSaWMysXCgT5dbCwQREZmrLpzJk7/8bwfo6h0jlXY4B6m0Y2QyAUAqtXAkV5tiEZEyNh5LUhvyY2b8w75jxFNT9fjBiTigGr2ISEUbiyXZ1lbHu85p55+eO0502gqbgfFsoF+kRj/P+6tNgV5E5AyMRJPURwLcfHknp0ZiPPpab+69wYlM6SY5T+kmXdxl9Ar0IiJnYiyapCEc4Kod6wB4qWc49162dJOaL6Mnuzl4gQfpUaAXETkDY7EkDZEAkVAmjI5Gk7n3sqWZ+Wr0uRtjNRkrIlK+xmKZ0k3I78Msk+HPNn+NXssrRUTK3lg0SX04iJkRDvgYi+UJ9IvW6JXRi4iUpVgyRTyVpiGSWUsfDvgZjSbmnDdvjT53Z2zBhjiDAr2IyDJlyzT14Wyg9zGaL6NfbB29Ar2ISHkanR3og74Zk7FZ86+6ySj3rQRFRNasbD1+sdJNYp4afbFW22Qp0IuILFMuo/cCfSTom3FnbNaiNXrdGSsiUp5yGX04CGQy+nzU60ZEpEKNxTJlmvrI1GRsPqrRi4hUqHyrbvKZfx29Vt2IiJS10TyTsVkh/1RYne/OWNQCQUSkvI1FkwR8lsvkI8GpUNpYM7VxX0o1ehGRyjQazTQ0MzNgZkbfGAnmnpfLnrEK9CIiy5RtaJYVnpbRN9RMC/SL9bpRjV5EpDyNTCaoD08F9GwJJ+AzaoNT2f28Gb360YuIlJ902vHJ//ssP36zn57hKJuaIrn3sqWboN9HJOjD78uUdOar0VdUP3oz+x0ze9nMXjKzb5tZxMy2m9nTZvaGmd1rZqHVGqyISKmMRBP8v/0n+OW7nuL44ASdLTW597KTsaGAj5qQP7fsctF+9AUec9YZB3oz6wB+C9jjnLsQ8AMfBr4IfNk5txMYBG5djYGKiJRSLDmVnY9Ek3Q0TwX66Rl9U02QltogPpv/hql0hbVACAA1ZhYAaoETwNXAfd779wA3rfAzRERKLppIzXjd2VKbe56djA0HfHz6Pefw1792OQGfb/6mZlRIRu+cOw78KXCUTIAfBvYBQ865bL/ObqBjpYMUESm12U3LOlqmZ/SZUBr0GxsaI+za2IjfZwuso88+lnlGb2YtwI3AdmAzUAdcn+fUvL+Jmd1mZnvNbG9fX9+ZDkNEpCjmZvRzSzehaa0QAn5bdB19JSyvfA9wyDnX55xLAN8DrgKavVIOQCfQk+8vO+fudM7tcc7taW9vX8EwREQKb3qgjwR9tNWFZryGTI0+K+CzBdoUuxmPhbaSQH8UuNLMai1ze9g1wCvAo8DN3jm3APevbIgiIqUXnTYZ29Fck7srFmZOxmb5F6rR5zYHL46V1OifJjPp+izwovez7gQ+B3zGzLqANuDuVRiniEhJTc/oO6ZNxMJUjX5G6WbBGr2b8VhogcVPmZ9z7g+AP5h1+CDw1pX8XBGRcpMN9J+6+i1ceXbbjPeyq26md65csEaffSxSSr+iQC8islZkA/0v/dSWGUsrYZ7J2AVq9FMZfSFGOpdaIIiILEF2eWUkOHfbwKnJ2Km6vd9n8zY1myrOl/9krIjImpHN6PMF+nyTsQGfb9E9Y+d5e9Up0IuILEEuo8+zbWDeyVj/Assrc4/K6EVEykY0mSLoNwL+fIHeq9HPWkc/32Ts1J2xqz/OfBToRUSWIJpIEQnMLdvAtFU3genr6Oev0TttDi4iUn6iiTThPPV5mN7rZmk1+orqRy8islbEEqkZm4BPZ2ZsborM2Ixk4Rp9cbtXah29iMgSRJOpvCtusn7wmZ+ZMVHr9xmTiXlq9F6iX/bdK0VEqt3wRILXT44CMBmfP6MHqA8HZkzULtjUDNXoRUTKwh2Pv8nNd/wI5xzRRHreydh8FmpqVjH96EVEqt2xwQlGY0lGJpNEkylqQksP9As1NauY7pUiItWubyQGQO9oNLPqZhkZ/cIbj1ROP3oRkap2ajQKQO9obMFVN/ksXKP3HlWjFxEpHeccvTMy+oVX3czm9/nmvWGq2P3oFehFRPIYjSWZ9BqZ9Y7EiCbTy87oF79hasXDXBIFehGRPLLZPGRKNwu1QMhnoRum1I9eRKQM9Hr1+czz2LJLNws1NZui0o2ISMlkM/q2uhDHBydIO5ZVullajX7l41wKBXoRkTyyGf2FHU0cHZgE8m86Mp/M8ko1NRMRKVunRmLUBP1sX1fH6bFMdr/c0o1q9CIiZezkSJT1jWHWN4Zzx1arRu/UAkFEpLSSqTQ/frOfizub2dAw1Xr44s6mJf8Mv8+Hc5DOE+yLtawyS22KRURm+dGb/QyMx/nZizfxth1t/M7gOXzosg62tNYu+WcE/AZAIp0m7Jv5L4Fs98piZfQK9CIis/zzCz00hAP8zLnthAN+fvs9O5f9MwK+TKDPV6dP64YpEZHS+tGb/bkgf6b8XqDPV6d3aoEgIlI66bTj1EiUrcso0+STy+jzrKWvqIzezJrN7D4ze83MXjWzt5lZq5k9bGZveI8tqzVYEZFCG5iIk0w7NjRGFj95AX5vt6lEnrX0lda98ivAvzrndgG7gVeB24FHnHM7gUe81yIiFeHUSOZGqfUN4UXOXFhwgRp9rh99ubdAMLNG4J3A3QDOubhzbgi4EbjHO+0e4KaVDlJEpFh6RzM3R61faUafrdHnKd1MraNf0Ucs2Uoy+rOBPuAbZvacmX3NzOqADc65EwDe4/pVGKeISFH0ehn9hsaVZfTZ5ZX5V91Uzg5TAeAy4A7n3KXAOMso05jZbWa218z29vX1rWAYIiKrJ9vMrH2FpRu/LxNe8/W7qaSMvhvods497b2+j0zgP2VmmwC8x958f9k5d6dzbo9zbk97e/sKhiEisnpOjUZpqQ2uaGklTK26ybe8MpfRr+gTlu6MA71z7iRwzMzO9Q5dA7wCPADc4h27Bbh/RSMUESmiUyOxFa+4gWmBfp5WxVC80s1K74z9FPAtMwsBB4GPk/k/j++Y2a3AUeAXVvgZIiIFl0ilCfp99I7GVjwRC0ut0a/4Y5Y2lpX8Zefc88CePG9ds5KfKyJSTI++3svHv/EMD336nfSORNm5vn7FP3NpNfryn4wVEakKT73ZD8B39h6jbzS24hU3AH7LZvRz3yt2Rq9ALyJrXiiQCYV/99QRkmnHpVtWfkO/V6LPm7VnjyijFxEpkj7vJqlYMs0Fmxu55ryV3/7j8yK9+tGLiJSBvtEYIb8PDP7bdediXtllJbJ3xqbyZfRF7l6pQC8ia17fWIyr3tLGXR/dQ9C/OoUOn6kfvYhI2egbjdFeH161IA9TGX3+Gr360YuIFE067Tg9Fltxy4PZFlx14x0r+ztjRUSqwfBkgkTKsa5+dQO9t4w+b+kmS6UbEZEi6BtbnSZmsy1Uuqmk7pUiIhXv9GiBAv0Ck7GV1L1SRKTiFSqj9y0loy/3HaZERCrV8aHJXKbdV4qM3nvM0wanIBToRWRNGYkmePefPsa9zxwDMnvEhgM+GsKre1uRfwl7xhaLAr2IrCmnR2PEk2n2HRkE4PVTY+xor1+Vu2GnW6h0o+6VIiIFNDSZAOCVEyOZx54Rzt/cuOqfM9XUbO576SK3QFCgF5E1ZXgiE+i7ekfpHpzg9FiMCwoQ6JdSo9c6ehGRAhiajAOQSDnuf74HgPM3FSCjX2jVTTqb0a/6x+YfS3E+RkSkPAyOJ3LP79vXDcB5Jcroi9UEQYFeRNaUbI2+NuTn0OlxtrbW0hgJrvrn+BZcdZN5LFZGrzbFIrKmDE/EaYwE+NhV23j26BA3XLK5IJ+zYPfKIrdAUKAXkTVlaDJBc22Iz1x7bkE/Z+E9Y2c+FppKNyKypgxNJGipXf1SzWzZ7pVqaiYiUmRDkwmaakMF/xwtrxQRKaIHXzzBf/7bvTjnGJ6I01xT+Ix+KS0QitUIQTV6Eal633r6CE929fPKiRGvRl/4QG9mmKkFgohIwXznmWMcG5hgIp7kmUOZvjY/ePkUw5OJomT0kCnf5N8cPFujL8owVh7ozcxvZs+Z2fe919vN7Gkze8PM7jWzwhfDRESm6R2N8tnv7uevftjF04cGiKfS1IX8/NPzx3GOotToIbOWPpV3c/CMSsrofxt4ddrrLwJfds7tBAaBW1fhM0RElmz/sWEAHj/QxxMH+ggHfHzip8/mSP8EQNEyep/lz9qzxypic3Az6wQ+AHzNe23A1cB93in3ADet5DNERJZrf/cQACdHonznmWNceXYbH7tqW+79phKWbqYvqayU5ZV/DnwWyN4S0AYMOeeS3utuoGOFnyEisiz7jw+zoTGzY1Qi7fj8+3fRUhfiJ793DZ94x3Z+antrUcbh880N9NNfFqtGf8arbszsg0Cvc26fmb0rezjPqXl/FTO7DbgNYOvWrWc6DBGRGZxz7O8e5ppd62mqCXJRZxO7Nmaalq1vjPDfP3h+0cbi99mcOvz0LL5YNfqVLK98O3CDmb0fiACNZDL8ZjMLeFl9J9CT7y875+4E7gTYs2dPcffVEpGq85NDAzx9sJ+bLu1gYDzOxVua+bUrzyrpmPKVbrIvfVYBNXrn3Oedc53OuW3Ah4EfOuc+AjwK3Oyddgtw/4pHKSKyiH98rps/e/gAT3adBmB3Z1OJR5Qp3czJ6L3w7vdZ5SyvzONzwGfMrItMzf7uAnyGiMgM2T7z33r6KCG/j3M3NpR4RPNNxmYefV6LhGJMyK7KnbHOuceAx7znB4G3rsbPFRFZqoGJzM5RLx4f5uLOJsIBf4lHlMnaZ3evzMb1qTbG4F/dfcnn0J2xIlIVhrxAD3BxGZRtINPBcnbpJvvaX8SMXoFeRKrCwLQtAi/ubC7hSKbkLd14j75pGX2hKdCLSMVzzjE0Eac+nKlGX7KlPAJ9vhYIuYzeC/SuCGtv1L1SRCraVx/torEmSDLt+MRPb+fcDQ2cs6H0E7GQyejTi07GFn4cCvQiUrFSacdXH+2itS7TpKyjuYbrL9pU4lFN8ee5M9blMvrs68KPQ4FeRCpWV+8YE/EUE/FJAFqK1JVyqcxsTg0+t+rG5t88fLWpRi8iFeuFY0MzXrfUlVeg9y+w6saXq9EXngK9iFSs57tnBfoi7By1HAutuplaR6+MXkRkXvu7hwgHpsJYa5ll9PlaIMxZR5+e89dWfxyF/wgRkdXxwrEhvvX0EQCO9k/w2olRrt61Hsg0CWuMlH9Gn03pfVpeKSIy1x2Pvcm/vnySTU0RPvfdF6mPBPjku9/Cv7x0kubaUC54louF+tFPTcYWfhwK9CJSMbI7R/2nb+6jNujne79xFTs3NNDeEKYhUn7hzG9GMj2zNpPN4HMZfaU0NRMRKaQv/eB11jWE6RmO0hgJMBJN8tn3nctO78aos1prc5Ob5cTvM2LJeTJ638zXhaRALyJlrat3lL/4YVcukH/pFy9hLJbkht2bc+f88YcuKtXwFpRpgTDzmJs9GasavYisZT1Dk3zjycNA5i5YM7hyR1uup03WzjJpeTCb35i/BYJPLRBEZI176mA/H77zKQCuu2ADTxw4TUdLzZwgX87yt0Dw3lOvGxFZ617sHgbg1nds52NXbePxnX3Uhkq/mchy+Gz+dfS+It4wpUAvImXja/9+kL7RGL977bkcPD1GS22Q//HB8wH41RJv9H0m8mb02feseC0QFOhFpCykvU6UgxMJXj05SjSR4uz2+lIPa0UWyuhzLRCKsOxGgV5ESmp4IsHH/uYn3Lh7M4MTCc7b1MgTB/oIB3wzVtZUokwLhJnHZk/GFmUcRfskEZE87n7yEM8dHeKPHnwNgN997zkAxJLpis/o/cb8/ei9OK+mZiJSlWLJFP1jMYYnEnzjPw4R8vuIp9JsbIxwzXnrWVefaU52dntdiUe6MvlaIMzuXlmMVTcK9CJSdF/4l9d475ef4Bs/OsRoLMmf3HwxAG/d3oqZceXZbQDsqPBA719o1U0RNx5RjV5EiiqVdvzzCz0MjMf5yx92seesFm66tIMTw1He8ZZ1APz8ZZ2cGI5yVluFB/qF1tEXceMRBXoRKaqnD/VzeixOOOAjlkzz4bduBeC/vGtH7px371rPu732w5VsoX70xWxqptKNiBTF0f4JUmnHgy+eoCbo549+7iIu7GjkA2W0mfdqy7vDlO6MFZFqEUumSKYcdeEAew8PcPNf/5g9Z7XwQvcQH7hoEz9/eSc/f3lnqYdZUEsp3ZR190oz2wJ8E9gIpIE7nXNfMbNW4F5gG3AY+EXn3ODKhyoileQz977AD1/r5SNXbOWN3jHqQn6eOzbEzvX1/M8bLiz18Ioic8PUzGPZbpX+CtlhKgn8rnPuWTNrAPaZ2cPAx4BHnHNfMLPbgduBz618qCJSCZxz9I/Heejlk2xtq+XuJw/hHPzWNTu56ZLN3iYh5bXlX6H4fXPX0c/ZYaoIe8aecaB3zp0ATnjPR83sVaADuBF4l3faPcBjKNCLVL1oIkU8leb6P/93QgEfybTj//zq5fSNxbj3mWN8/KpttJTZ5t2FlulHn/+GqYrbM9bMtgGXAk8DG7z/E8A5d8LM8k6dm9ltwG0AW7duXY1hiEiRxZNpRqIJnj0yyG9++zneubOd40OThPw+LtnSzM4NDezc0MBVO9aVeqgl4Teb08tm9g5TFTEZa2b1wHeBTzvnRsyW1r/BOXcncCfAnj17irGUVERW2ae+/SxPHRygo7mGeDLNv716iiu2t/LlX7qEUECL+nw2N6PPrpyvmFU3ZhYkE+S/5Zz7nnf4lJlt8rL5TUDvSgcpIuXBOceTXf3s2tTAyeEoD718CoDhyQQfuWIrzx4d4jPvPYfNzTUlHml58PkM5zLXzWzmKpuK6EdvmVHfDbzqnPvStLceAG4BvuA93r+iEYpI2Xjk1V4+8c29BHxGXThAYyTAB3dv5vsv9PDZ63bRVLs2JlmXyj8tuGebmM1ZR1+Ecawko3878GvAi2b2vHfs98gE+O+Y2a3AUeAXVjZEESmlV0+McODUKFfvWs9fPtpFZ0sNN+zezOH+ca67YCM/e/Fmbr9+F41rZCXNcmTr8Km0m7ZuflY/+nLO6J1z/wHMV5C/5kx/roiU3sB4nF+56yne/pZ1fO/ZbgYnErmbf/74Qxfxy2+duYBCQT6/fOUZbQ4uIkXVOxLlJ4cHOHBqjEu3NvPuc9fjnOPPfvA6r50c5bWTozREAtzxkcvYf3yY4ckEH7qso9TDrhjZ8sz0tfRT/eiL1+tGgV5kjTo5HOXaLz/OSDSZO/ZT21p47ugQybTjY1dt49KtzWxrq2P3lmaur+KeNIWSLc9MX3mTfearhBYIIlKZRqMJfvxmP/ft6yaWTHPvbVdy3uZG/vf3X+Gx1/v4yBVbaYgEue1nzlZJZoVyPeenRfO0MnoRWU3OOQbG4/z4YD9PHOgjlkyzv3uYQ6fHgcy2fVd4m3z8yc27SznUqpTL6NNza/TZiVpl9CKybMOTCbp6x3jo5ZP83VNHmIinAGiMBGiIBAn4jb/6lUuZiKe46RLV2wvJl6d0M6cffaW0QBCR0ogn0zz2ei9DkwmODUzw0MsnOXBqLPf+Dbs3c3FnE5dubWF3ZxMBv+5WLaZ8jcvcrPe06kZEZugenGAynuLxA3280D3MS8enyjAAl5/Vwmffdy7nrG/gvM2NdOgO1ZLKraN3eVbdaHmliEQTKY4PTfL80SG++dQRRicTHJwW1Le01tBWF+auj+5h18YG2hvCRIL+Eo5YZrM8k7G5dfTaHFxkbekZmuQfnzvOyeEorXUhRqIJHni+h/7xOAC7NjawY309v3LFVtobwuxor+fCjqYSj1oWk28d/VT3yspogSAiy5RIpTk+OMmRgQmO9o9zuH+CI/0T/EdXH9FEmsZIgNFYkpDfx1U72rj+ok201oa4etf63OSdVI58bQ5m96NXRi9SgZKpNG/2jXOkf5wj/RMcGfAe+yc4PjQ5I7uLBH2c1VrHDbs386mrd7KltZZEKk3AZyy15beUr3zBfPYOU8VI6RXoRVYomkhx4NQo0USaB188wQMv9DDglVwAmmqCbGurZfeWZm7YvZmz2mo5q62Os9pqWd8QnhPQg1oZUzWmSjfTj2YnYzOvlNGLlJloIsUDL/RwcjjKeDzJM4cGePH4MIlU5j/WgM+4/qJNXL2rnR3t9ZzVWqfWvWvY9O6VWelZk7FadSNSIieHo3QPTnDo9DhdvWMMTSToG4vxzOEBRr3eMAGfcXFnE7/+9u1csqWZmpCfXRsb2dgUKfHopVzkW1njZk3GKqMXKYDsbj/ptGMkmuBHb/bzzOEBJuMpjvRngvvJkWju/FDAR0ttkJbaENdfuJGbLung8m0tOIeWM8qC8rVAmN2PXqtuRFZgMp7i+NAE3YOTHB+aZP+xYX508DTHBycJBXzEk+ncP6Nrgn7qwgG2tNZw1Y42Lups4uz2ejY3RdjRXq8VL3JG8rVAyHWvVFMzkYU55xiZTNI9NMFxL5BnH7OBffqEKEB9OMBP71zHz168mUQqTSTop7k2xM719bz9LetyGZbIavHnvWFKd8aKzDA8meDlnmFe6RnJLU/MBvSxWHLGuZGgj47mGjpaarmwo4nOlhrvdeZxQ2NEwVyKaqHulb5Zm4UXkgK9lNTR/gkef6MP5xw9Q1GODWTWnQ+OJ5iIJxmcSOTObYwE6GipZUtrLW/b0TYjiHe01NBWF9Lacykr2WCer3ulX90rpVI55xiJJhkYjzMwHqN/LM7gRJzTY3FODE9yYihKz3CUk8OZjDy7LBEg6De2eIH83A2NhIM+trTUcv7mRi7Y3Mi6+nAJfzOR5cutrJnevVL96KUcTcZTjEYTxFNpJuIpTo/G6BuLcXoszumxGKdHYxwdyKxWGRiPk5znm9tcG2RTUw2bmyJctrWZxpogLbVBrrtgI7WhAK11IZVWpKpkv855+9FrMlYKLZ12DE0m6B/LBO1+L2j3j8XpGZrkcP84/eNxBsbijM6qhU8X9Bvr6sNsaorwrnPbWVcfprUulPvTVhempS5IW12YmpCWIsrakmuBkJ676kaTsbJs6bRjPJ5kJJqkZ2jSy8KTnBie5NRIlFMjMfq9Ukr/eJyB8fiMCaIsv89Y3xDObAjd2UxrXYj2hjBNNUFCfh+RkJ919SHWN4RZV585rrq4SH7+vDdMzdozVjX6tSOeTGMGI5MJWmpDDE8mGIsliSVTDE0kGJxIMDieqXcPTMQZHI8zMJ6gdzTK4dPjjMaS82YG4YCPjU0R1tWH6WypZXdnM+saQqyrD9NWH2Zdfeb5uvowzTVBrRkXWSULrrrJU78vFAX6FXLOMRFPMR5LMhZLMh5LeY+Z19nnmdcpxmIJxmMpJuJJook0k4kUw5MJDvePUxcKMBZL4vdZ3mw7K+T30VoXoqUuRFtdiBsv6aC5NkhjJEhDJMDGpgh14QD14QCbmiLKukVKJF8LBPWjL6J4Ms3J4SgTiUxwHp8WnKeC9Kzj8SRj0amAPu4dW8qsuRnUhwLUhQPUhf3UhgLUBP00RAJsaAxz7QUbGBpPsL29juHJBOvqwzREAoQDPpprQ7lb8FvqQtSF/ArcIhVgKqOfOpYt1VT8DlNm9j7gK4Af+Jpz7guF+JysWDLFwHic/rG4t6wv82dwIlOPHhyPMxZL0j04ychkgngyvaQAHfRbLjPhSetcAAAFbUlEQVSuD2eCdFNtiM6WWurC/tx7s8+pC/tzr7PHaoJ+lURE1ph8e8bOzugrsh+9mfmBrwLvBbqBZ8zsAefcK6v9WU92neZLDx9g35HBvO/7jFwWXB8OcN6mBlrrQoT8furDfjpba6kLBaj1AnNdKEBDZCpYhwNaJSIiZ86XpwUCsyZjKzWjfyvQ5Zw7CGBmfw/cCKx6oD8xHKVvNMZvXbOTTU0Rbznf1NK+xogmFkWkdPJ3r8w8+rxsv1Jr9B3AsWmvu4ErCvA53HTJZn7u0g7dZCMiZSmb0X/xX1/jrx9/EyDX1qPS+9Hni7pzfhMzuw24DWDr1q1n9EEBbbkmImVsc3MNt7ztLPrGYjOOb2qqYVNjDR+4aBNbW2sLPg5b7dtvzextwB86567zXn8ewDn3x/P9nT179ri9e/eu6jhERKqdme1zzu1Z7LxCpMTPADvNbLuZhYAPAw8U4HNERGQJVr1045xLmtlvAg+RWV75defcy6v9OSIisjQFWUfvnHsQeLAQP1tERJZHs5kiIlVOgV5EpMop0IuIVDkFehGRKqdALyJS5Vb9hqkzGoRZH3BkmX9tHXC6AMOpNrpOi9M1Wpyu0dIU+zqd5ZxrX+yksgj0Z8LM9i7ljrC1TtdpcbpGi9M1WppyvU4q3YiIVDkFehGRKlfJgf7OUg+gQug6LU7XaHG6RktTltepYmv0IiKyNJWc0YuIyBKUdaA3s8Nm9qKZPW9me71jrWb2sJm94T22eMfNzP7CzLrMbL+ZXVba0ReGmX3dzHrN7KVpx5Z9TczsFu/8N8zsllL8LoU0z3X6QzM77n2fnjez90977/PedXrdzK6bdvx93rEuM7u92L9HIZnZFjN71MxeNbOXzey3veP6PnkWuEaV9V1yzpXtH+AwsG7WsT8Bbvee3w580Xv+fuBfyOxwdSXwdKnHX6Br8k7gMuClM70mQCtw0Hts8Z63lPp3K8J1+kPgv+Y593zgBSAMbAfeJNNi2+89PxsIeeecX+rfbRWv0SbgMu95A3DAuxb6Pi1+jSrqu1TWGf08bgTu8Z7fA9w07fg3XcZTQLOZbSrFAAvJOfcEMDDr8HKvyXXAw865AefcIPAw8L7Cj7545rlO87kR+HvnXMw5dwjoIrPJfW6je+dcHMhudF8VnHMnnHPPes9HgVfJ7Pms75NngWs0n7L8LpV7oHfAD8xsn7fHLMAG59wJyPyPAKz3jufblHyh/0GqyXKvyVq+Vr/plR2+ni1JoOuEmW0DLgWeRt+nvGZdI6ig71K5B/q3O+cuA64HPmlm71zg3CVtSr7GzHdN1uq1ugPYAVwCnAD+zDu+pq+TmdUD3wU+7ZwbWejUPMfWxHXKc40q6rtU1oHeOdfjPfYC/0jmnz+nsiUZ77HXO70b2DLtr3cCPcUbbUkt95qsyWvlnDvlnEs559LAXWS+T7CGr5OZBckEsG85577nHdb3aZp816jSvktlG+jNrM7MGrLPgWuBl8hsNJ6d1b8FuN97/gDwUW9lwJXAcPafn2vAcq/JQ8C1Ztbi/ZPzWu9YVZs1Z/NzZL5PkLlOHzazsJltB3YCP6HKN7o3MwPuBl51zn1p2lv6Pnnmu0YV910q9az2ArPdZ5OZmX4BeBn4fe94G/AI8Ib32OodN+CrZGa2XwT2lPp3KNB1+TaZfyomyGQJt57JNQF+ncxEURfw8VL/XkW6Tn/rXYf9ZP4j2zTt/N/3rtPrwPXTjr+fzEqLN7PfwWr5A7yDTPlgP/C89+f9+j4t6RpV1HdJd8aKiFS5si3diIjI6lCgFxGpcgr0IiJVToFeRKTKKdCLiFQ5BXoRkSqnQC8iUuUU6EVEqtz/B52/lTcw/+hzAAAAAElFTkSuQmCC\n", | |
| "text/plain": [ | |
| "<matplotlib.figure.Figure at 0x1a278a94a8>" | |
| ] | |
| }, | |
| "metadata": {}, | |
| "output_type": "display_data" | |
| } | |
| ], | |
| "source": [ | |
| "ref1corr.iloc[4].plot()" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": null, | |
| "metadata": {}, | |
| "outputs": [], | |
| "source": [] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": null, | |
| "metadata": {}, | |
| "outputs": [], | |
| "source": [] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": null, | |
| "metadata": {}, | |
| "outputs": [], | |
| "source": [] | |
| } | |
| ], | |
| "metadata": { | |
| "kernelspec": { | |
| "display_name": "Python 3", | |
| "language": "python", | |
| "name": "python3" | |
| }, | |
| "language_info": { | |
| "codemirror_mode": { | |
| "name": "ipython", | |
| "version": 3 | |
| }, | |
| "file_extension": ".py", | |
| "mimetype": "text/x-python", | |
| "name": "python", | |
| "nbconvert_exporter": "python", | |
| "pygments_lexer": "ipython3", | |
| "version": "3.6.3" | |
| } | |
| }, | |
| "nbformat": 4, | |
| "nbformat_minor": 2 | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment