time_kernel.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {
    "_uuid": "5829966057ac4dfb9536083174567bb31dfd7e05"
   },
   "source": [
    "# Strategies for Flux Time Series Preprocessing\n",
    "### From simple to advanced methods"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "_cell_guid": "b1076dfc-b9ad-4769-8c92-a6c4dae69d19",
    "_uuid": "8f2839f25d086af736a60e9eeb907d3b93b6e0e5"
   },
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns\n",
    "import warnings\n",
    "from itertools import chain\n",
    "sns.set_style('whitegrid')\n",
    "warnings.simplefilter('ignore', FutureWarning)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "%run -i \"load\\train.py\" #run script for loading"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "_cell_guid": "79c7e3d0-c299-4dcb-8224-4455121ee9b0",
    "_uuid": "d629ff2d2480ee46fbb7e2d37f6b5fab8052498a",
    "collapsed": true
   },
   "source": [
    "One of the first major challenges in this competition is to properly preprocess the light curve time series data. Unlike many other \"well-behaved\" time series, the light curves here are not only irregular in terms of observation intervals, but also unsynchronised across different light bands. This makes applying many existing tools and techniques difficult because they often require a regular time series, preferably without missing values. Let us first look at what we have:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "_uuid": "bab1c32e45589927cf5f2b5b8c6d22503013f0d5"
   },
   "outputs": [],
   "source": [
    "train_series = training_set\n",
    "train_metadata = training_set_metadata"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "_uuid": "ea2cebe13bb8c9f55108371545c8f7fff8e7fa5d"
   },
   "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>object_id</th>\n",
       "      <th>mjd</th>\n",
       "      <th>passband</th>\n",
       "      <th>flux</th>\n",
       "      <th>flux_err</th>\n",
       "      <th>detected</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>615</td>\n",
       "      <td>59750.4229</td>\n",
       "      <td>2</td>\n",
       "      <td>-544.810303</td>\n",
       "      <td>3.622952</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>615</td>\n",
       "      <td>59750.4306</td>\n",
       "      <td>1</td>\n",
       "      <td>-816.434326</td>\n",
       "      <td>5.553370</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>615</td>\n",
       "      <td>59750.4383</td>\n",
       "      <td>3</td>\n",
       "      <td>-471.385529</td>\n",
       "      <td>3.801213</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>615</td>\n",
       "      <td>59750.4450</td>\n",
       "      <td>4</td>\n",
       "      <td>-388.984985</td>\n",
       "      <td>11.395031</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>615</td>\n",
       "      <td>59752.4070</td>\n",
       "      <td>2</td>\n",
       "      <td>-681.858887</td>\n",
       "      <td>4.041204</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>615</td>\n",
       "      <td>59752.4147</td>\n",
       "      <td>1</td>\n",
       "      <td>-1061.457031</td>\n",
       "      <td>6.472994</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>615</td>\n",
       "      <td>59752.4224</td>\n",
       "      <td>3</td>\n",
       "      <td>-524.954590</td>\n",
       "      <td>3.552751</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>615</td>\n",
       "      <td>59752.4334</td>\n",
       "      <td>4</td>\n",
       "      <td>-393.480225</td>\n",
       "      <td>3.599346</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>615</td>\n",
       "      <td>59752.4435</td>\n",
       "      <td>5</td>\n",
       "      <td>-355.886780</td>\n",
       "      <td>10.421921</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>615</td>\n",
       "      <td>59767.2968</td>\n",
       "      <td>2</td>\n",
       "      <td>-548.013550</td>\n",
       "      <td>3.462291</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   object_id         mjd  passband         flux   flux_err  detected\n",
       "0        615  59750.4229         2  -544.810303   3.622952         1\n",
       "1        615  59750.4306         1  -816.434326   5.553370         1\n",
       "2        615  59750.4383         3  -471.385529   3.801213         1\n",
       "3        615  59750.4450         4  -388.984985  11.395031         1\n",
       "4        615  59752.4070         2  -681.858887   4.041204         1\n",
       "5        615  59752.4147         1 -1061.457031   6.472994         1\n",
       "6        615  59752.4224         3  -524.954590   3.552751         1\n",
       "7        615  59752.4334         4  -393.480225   3.599346         1\n",
       "8        615  59752.4435         5  -355.886780  10.421921         1\n",
       "9        615  59767.2968         2  -548.013550   3.462291         1"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "train_series.head(10)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "_uuid": "703d1e3fa4f3a25d41f962147b596b343d0bcc02"
   },
   "source": [
    "There are actually 3 time series (flux, flux_err, detected) per band per object. However, as a first step, here we will only focus on the \"flux\" time series. Even so, we still have 6 passbands for each object."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "_uuid": "ff0d32326a26ef32c414da2f130f99cbc199077b"
   },
   "source": [
    "We first look at the distribution of time series lengths."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "_uuid": "5542d5016c2b7300ab25410280063dfc4955669a"
   },
   "outputs": [],
   "source": [
    "ts_lens = train_series.groupby(['object_id', 'passband']).size()\n",
    "f, ax = plt.subplots(figsize=(12, 6))\n",
    "sns.distplot(ts_lens, ax=ax)\n",
    "ax.set_title('distribution of time series lengths')\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "_uuid": "a1b147f71e15b123ec560356283356f1af41f1c6"
   },
   "source": [
    "As we see here, the lengths of light curve time series have a large range, so we may face difficulties trying to convert them all into the same length."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "_uuid": "b23049ea27eb242726bafac07bd2e3ff9e452593"
   },
   "source": [
    "Let us also look at the times at which observations happen, and count the number of observations made at each point in time:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "_uuid": "d755a3eb284d3b309c0e0c00465fb737ee766516"
   },
   "outputs": [],
   "source": [
    "f, ax = plt.subplots(figsize=(12, 6))\n",
    "sns.distplot(train_series['mjd'], ax=ax, bins=200)\n",
    "ax.set_title('number of observations made at each time point')\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "_uuid": "57c377af9d6a59a78baa08141d1240b3582e612c"
   },
   "source": [
    "What we see here shows that the observations are not taken evenly through the entire sampling period. There are periods where more samples than usual are taken, but also periods with few observations.\n",
    "\n",
    "As for each individual object:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "_uuid": "95e73d35dfc78193f25948712178ac6a36561720"
   },
   "outputs": [],
   "source": [
    "f, ax = plt.subplots(figsize=(12, 6))\n",
    "sns.distplot(train_series[train_series['object_id'] == 615]['mjd'], ax=ax, bins=200)\n",
    "ax.set_title('number of observations made at each time point')\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "_uuid": "47ae311530ca0162078d1a978da8ce5ed54ee1c4"
   },
   "source": [
    "What about for a single light band?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "_uuid": "cb41eabdaa29c879536d33e694480165d9dccabe"
   },
   "outputs": [],
   "source": [
    "f, ax = plt.subplots(figsize=(12, 6))\n",
    "sns.distplot(train_series[(train_series['object_id'] == 615) \n",
    "                          & (train_series['passband'] == 2)]['mjd'], ax=ax, bins=200)\n",
    "ax.set_title('number of observations made at each time point')\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "_uuid": "6a57677fcf3eedb153247d01966f5350c5feb4e5"
   },
   "source": [
    "We see that even for individual objects, observations are not taken evenly. There can be large gaps between periods of rich observations."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "_uuid": "28a0eb78f56c5c49bef6dd2637f0991cf25de95e"
   },
   "source": [
    "Let us also look at the number of observations for each object:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "_uuid": "9dad88fcfbcae3bf4cb157d0a43e6884b79332ab"
   },
   "outputs": [],
   "source": [
    "obj_obs_count = train_series['object_id'].value_counts().reset_index()\n",
    "obj_obs_count.columns = ['object_id', 'count']\n",
    "\n",
    "obj_obs_count_w_ddf = pd.merge(\n",
    "    obj_obs_count, train_metadata[['object_id', 'ddf']], on='object_id')\n",
    "\n",
    "selected = obj_obs_count_w_ddf.groupby('ddf')['count'].value_counts()\n",
    "selected.index.names = ['ddf', 'count_val']\n",
    "selected = selected.reset_index().pivot('count_val', 'ddf',\n",
    "                                        'count').rename(columns={\n",
    "                                            0: 'nonddf',\n",
    "                                            1: 'ddf'\n",
    "                                        }).fillna(0)\n",
    "selected['total'] = selected['nonddf'] + selected['ddf']\n",
    "\n",
    "f, ax = plt.subplots(figsize=(12, 6))\n",
    "ax.vlines(x=selected.index, ymin=0, ymax=selected['total'], \n",
    "          colors='red', label='ddf')\n",
    "ax.vlines(x=selected.index, ymin=0, ymax=selected['nonddf'], \n",
    "          colors='blue', label='non-ddf')\n",
    "ax.set_title('number of observations per object')\n",
    "plt.legend()\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "_uuid": "ed40c2ba5e0109f2b1a5f37a759a9063b6e29506"
   },
   "source": [
    "As can be seen above, there is a large gap between the number of observations for an average DDF object and non-DDF object."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "_uuid": "1307ca1ef66c2e3021f2f75a27727cee6128652f"
   },
   "source": [
    "Judging by the observations we made so far, the processing of the light curve time series is indeed a challenging task. We have the following difficulties to overcome:\n",
    "1. The observations, even for one object in one band, are not evenly spaced, so adjacent observations in the time series are not equally \"close\" to each other.\n",
    "2. The length of the time series vary quite a lot, even among the colour bands of the same object. At no point do we have multiple colour band observations simultaneously, so we cannot naively treat the multiple light bands' time series as a multivariate series.\n",
    "3. There are some large gaps between periods where data is avaiable for an object, so we may miss characteristics of the time series at a certain period if we only look at global features.\n",
    "4. The time series for different objects are not synchronised, making comparisons between objects difficult. We will have to disocover features that are invariant with time shifting or slight stretching."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "_uuid": "7171764829d0c1f2b1383e64ead2266e06890d89"
   },
   "source": [
    "#### Ignore time values"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "_uuid": "e63a385c3c33ad8a6f8e68b1dda1c2484f063bb2"
   },
   "source": [
    "There are multiple strategies to approach this problem, with varying degrees of complexity.\n",
    "* We may completely ignore the time values and simply treat the time series as sequences. Many sequence features such as min, max, range, std, monotonicity etc. are invariant with the loss of time interval information, so we can still build many useful features. However, it comes with two major disadvantages:\n",
    "    1. We will not able to align observations that occur close together, so we will have to analyse the time series for each passband individually without exploiting their relationships.\n",
    "    2. We will lose access to many useful feature extraction techniques, or at least the form of these techniques that are typically implemented in common tools if we throw out time interval information. Features like autocorrelation do not make sense if we do not know the actual time gaps between observations.\n",
    "    \n",
    "Performing time-less analysis is simple. We do not even need much preprocessing, which makes it a good starting point. In the following example, we extract four very basic features from the time-less time series:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "_uuid": "083197d2abf306cc32006e47d444a8f5be0d7842"
   },
   "outputs": [],
   "source": [
    "simple_features = train_series.groupby(\n",
    "    ['object_id', 'passband'])['flux'].agg(\n",
    "    ['mean', 'max', 'min', 'std']).unstack('passband')\n",
    "simple_features.head().T"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "_uuid": "d0f40e7f07b5f50678a8adddfb99302e3fbc09f0"
   },
   "source": [
    "Even if we cannot extract interaction features from multiple bands directly, we may still be able to discover their relationships from the features we have in downstream analysis and learning tasks.\n",
    "\n",
    "**What not to do here:** grab cesium or tsfresh, spin up a few cores and extract all the fancy features you can get. Be aware that many of the features in these libraries do not work well with unevenly-spaced time series. I wasted many CPU hours here myself :("
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "_uuid": "42445da7488bde4a1fabf3a7b6e6a2f0b8cde747"
   },
   "source": [
    "However, we cannot simply ignore the rich information we just threw out. The time-less approach won't even allow us to discover periodicity! Plus, we know from some astronomy background that it is the composition of light at different frequencies (and by extension, bands) that allow us to identify objects in the first place. We really do not want to ignore the relationship between passbands. So we can come up with a different approach:"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "_uuid": "f36e6f5cf66ecf37ace6bd5ec3687ff1afd68c83"
   },
   "source": [
    "#### Convert to regular TS"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "_uuid": "3a5d6c153543596b44951ef75ee1f0edbe4ebe1e"
   },
   "source": [
    "* We may take all **mjd** values in the dataset and declare them 'valid observation timestamps', then construct a time series for each object and each passband that include all these observation timestamps, filling in NA if obseration is not available. Now that all objects and all passband have time series of the same length, they are comparable, and many time series analysis techniques can be applied as long as they can deal with missing values. One immediate drawback of this method is that none of the objects will have multiple passband data at a given timestamp, and there will be a huge number of NAs. The time series will also be really long due to the large number of possible timestamps. Also, we will face more issues when we want to build a model and apply it to new data, as the new timestamps will not match the timestamps in our current dataset. We can make a compromise by binning **mjd** and averaging the observations within a bin, and use all bins within the range of **mjd** as possible time steps in the time series. By doing so, we will be able to obtain a collection of time series that are equally spaced, not overwhemingly NA, and have the same length."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "_uuid": "ce10139e65ecb7a60686be29845bf2300feb83ba"
   },
   "outputs": [],
   "source": [
    "print(f'mjd unique values: {train_series[\"mjd\"].nunique()}')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "_uuid": "c2fd4f1362b75564beb538444b0d563e09cb4376"
   },
   "outputs": [],
   "source": [
    "print(f'int (1day) mjd unique values: {train_series[\"mjd\"].astype(int).nunique()}')\n",
    "print(f'''int mjd bins: {train_series[\"mjd\"].astype(int).max()\n",
    "      - train_series[\"mjd\"].astype(int).min() + 1}''')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "_uuid": "ec7a2e1409943b5d7ace338f214ba6698d94a3fd"
   },
   "outputs": [],
   "source": [
    "print(f'5day mjd unique values: {(train_series[\"mjd\"]/5).astype(int).nunique()}')\n",
    "print(f'''5day mjd bins: {int((train_series[\"mjd\"].astype(int).max()\n",
    "      - train_series[\"mjd\"].astype(int).min()) / 5 + 1)}''')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "_uuid": "5452661d6488b4b669a4066c19b575d8233eb4ba"
   },
   "source": [
    "As we see above, while using each unique **mjd** value as time steps is really bad, binning by day or even by 5 days greatly reduces time series length. Here is an example of constructing the resulting time series using binned observations:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "_uuid": "a8159c6777d0e4baa3d64c5f98ffd8bcc7b94cb5"
   },
   "outputs": [],
   "source": [
    "# binning\n",
    "ts_mod = train_series[['object_id', 'mjd', 'passband', 'flux']].copy()\n",
    "ts_mod['mjd_d5'] = (ts_mod['mjd'] / 5).astype(int)\n",
    "ts_mod = ts_mod.groupby(['object_id', 'mjd_d5', 'passband'])['flux'].mean().reset_index()\n",
    "ts_mod.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "_uuid": "c4e6f3fc6d52f64839bdefd472b506d4b2a2c97e"
   },
   "outputs": [],
   "source": [
    "# pivotting\n",
    "ts_piv = pd.pivot_table(ts_mod, \n",
    "                        index='object_id', \n",
    "                        columns=['mjd_d5', 'passband'], \n",
    "                        values='flux',\n",
    "                        dropna=False)\n",
    "ts_piv.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "_uuid": "9208e742a5ae59a02e7c10165b1413b744ba3a0b"
   },
   "outputs": [],
   "source": [
    "# resetting column index to fill mjd_d5 gaps \n",
    "t_min, t_max = ts_piv.columns.levels[0].min(), ts_piv.columns.levels[0].max()\n",
    "t_range = range(t_min, t_max + 1)\n",
    "mux = pd.MultiIndex.from_product([list(t_range), list(range(6))], \n",
    "                                 names=['mjd_d5', 'passband'])\n",
    "ts_piv = ts_piv.reindex(columns=mux).stack('passband')\n",
    "ts_piv.head(10)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "_uuid": "ef9a4d95b9d173a87a0f1d387ee11d5f5242c4c2"
   },
   "source": [
    "We have now converted the unaligned time series into aligned, equally spaced time series using binning-and-averaging. We can see below that despite our efforts, nearly 90% of the values in our new time series are NaN, so there will be major challenges trying to make use of the converted data with tools that cannot cope well with NAs. Normal procedures like mean imputation or interpolation won't work well here due to the prevalance of missing values. However, some algorithms like LSTM may learn to ignore padded values and data gaps and still manage to extract valuable information from the time series. It is even possible to build multiple time series collections with different bins to look for features at different time scales."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "_uuid": "4420f30c9098c92196988e99ce7820e8ed7422fc"
   },
   "outputs": [],
   "source": [
    "np.mean(np.ravel(pd.isna(ts_piv).values))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "_uuid": "c1925a410c655d9e9d956a84a330e5456ab4ef00"
   },
   "source": [
    "One of the drawbacks of the method above is that binning appears to be quite arbitrary. What we are effectively doing is sampling at different time points and averaging flux values around these points. So why not do it properly?"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "_uuid": "73cfeecc39ffff7d31c582ba99f8a0b9877e9995"
   },
   "source": [
    "#### Sample with a distance kernel"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "_uuid": "06ce7f495cec36066fe17f02af5dfb4d8425cf5f"
   },
   "source": [
    "* We may sample the time series data at evenly-spaced time steps, using a time kernel to determine how much weight we put on each observation when taking the moving average."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "_uuid": "cbdc51e621fc882e83d659d75ef7966b69a89ba4"
   },
   "outputs": [],
   "source": [
    "def time_kernel(diff, tau):\n",
    "    return np.exp(-diff ** 2 / (2 * tau ** 2))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "_uuid": "5e138e18129b61392f8543644d01267aebaa1f29"
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(59580.0343, 60674.363)"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "t_min, t_max = train_series['mjd'].min(), train_series['mjd'].max()\n",
    "t_min, t_max"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "_uuid": "3c4dadd6df784520475913b150c2ca85443d3359"
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([59580.0343, 59600.0343, 59620.0343, 59640.0343, 59660.0343,\n",
       "       59680.0343, 59700.0343, 59720.0343, 59740.0343, 59760.0343,\n",
       "       59780.0343, 59800.0343, 59820.0343, 59840.0343, 59860.0343,\n",
       "       59880.0343, 59900.0343, 59920.0343, 59940.0343, 59960.0343,\n",
       "       59980.0343, 60000.0343, 60020.0343, 60040.0343, 60060.0343,\n",
       "       60080.0343, 60100.0343, 60120.0343, 60140.0343, 60160.0343,\n",
       "       60180.0343, 60200.0343, 60220.0343, 60240.0343, 60260.0343,\n",
       "       60280.0343, 60300.0343, 60320.0343, 60340.0343, 60360.0343,\n",
       "       60380.0343, 60400.0343, 60420.0343, 60440.0343, 60460.0343,\n",
       "       60480.0343, 60500.0343, 60520.0343, 60540.0343, 60560.0343,\n",
       "       60580.0343, 60600.0343, 60620.0343, 60640.0343, 60660.0343])"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sample_points = np.array(np.arange(t_min, t_max, 20))\n",
    "sample_points"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "_uuid": "4ef9bfefba08e3d169b60adc36b780b54e99ef67"
   },
   "outputs": [],
   "source": [
    "weights = time_kernel(np.expand_dims(sample_points, 0) \n",
    "                      - np.expand_dims(train_series['mjd'].values, 1), 5)\n",
    "ts_mod = train_series[['object_id', 'mjd', 'passband', 'flux']].copy()\n",
    "for i in range(len(sample_points)):\n",
    "    ts_mod[f'sw_{i}'] = weights[:, i]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "_uuid": "ddf36ab5bb37b8f55f74e5240c6bd864ba38f21c"
   },
   "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>object_id</th>\n",
       "      <th>mjd</th>\n",
       "      <th>passband</th>\n",
       "      <th>flux</th>\n",
       "      <th>sw_0</th>\n",
       "      <th>sw_1</th>\n",
       "      <th>sw_2</th>\n",
       "      <th>sw_3</th>\n",
       "      <th>sw_4</th>\n",
       "      <th>sw_5</th>\n",
       "      <th>...</th>\n",
       "      <th>sw_45</th>\n",
       "      <th>sw_46</th>\n",
       "      <th>sw_47</th>\n",
       "      <th>sw_48</th>\n",
       "      <th>sw_49</th>\n",
       "      <th>sw_50</th>\n",
       "      <th>sw_51</th>\n",
       "      <th>sw_52</th>\n",
       "      <th>sw_53</th>\n",
       "      <th>sw_54</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>615</td>\n",
       "      <td>59750.4229</td>\n",
       "      <td>2</td>\n",
       "      <td>-544.810303</td>\n",
       "      <td>6.743158e-253</td>\n",
       "      <td>3.577424e-197</td>\n",
       "      <td>2.135826e-148</td>\n",
       "      <td>1.434993e-106</td>\n",
       "      <td>1.084980e-71</td>\n",
       "      <td>9.231706e-44</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>615</td>\n",
       "      <td>59750.4306</td>\n",
       "      <td>1</td>\n",
       "      <td>-816.434326</td>\n",
       "      <td>6.398397e-253</td>\n",
       "      <td>3.415494e-197</td>\n",
       "      <td>2.051749e-148</td>\n",
       "      <td>1.387022e-106</td>\n",
       "      <td>1.055190e-71</td>\n",
       "      <td>9.033709e-44</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>615</td>\n",
       "      <td>59750.4383</td>\n",
       "      <td>3</td>\n",
       "      <td>-471.385529</td>\n",
       "      <td>6.071248e-253</td>\n",
       "      <td>3.260886e-197</td>\n",
       "      <td>1.970977e-148</td>\n",
       "      <td>1.340651e-106</td>\n",
       "      <td>1.026215e-71</td>\n",
       "      <td>8.839937e-44</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>615</td>\n",
       "      <td>59750.4450</td>\n",
       "      <td>4</td>\n",
       "      <td>-388.984985</td>\n",
       "      <td>5.800215e-253</td>\n",
       "      <td>3.132057e-197</td>\n",
       "      <td>1.903283e-148</td>\n",
       "      <td>1.301564e-106</td>\n",
       "      <td>1.001649e-71</td>\n",
       "      <td>8.674699e-44</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>615</td>\n",
       "      <td>59752.4070</td>\n",
       "      <td>2</td>\n",
       "      <td>-681.858887</td>\n",
       "      <td>8.352701e-259</td>\n",
       "      <td>2.167110e-202</td>\n",
       "      <td>6.327373e-153</td>\n",
       "      <td>2.078998e-110</td>\n",
       "      <td>7.687287e-75</td>\n",
       "      <td>3.198750e-46</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>615</td>\n",
       "      <td>59752.4147</td>\n",
       "      <td>1</td>\n",
       "      <td>-1061.457031</td>\n",
       "      <td>7.920806e-259</td>\n",
       "      <td>2.067753e-202</td>\n",
       "      <td>6.074582e-153</td>\n",
       "      <td>2.008271e-110</td>\n",
       "      <td>7.471650e-75</td>\n",
       "      <td>3.128233e-46</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>615</td>\n",
       "      <td>59752.4224</td>\n",
       "      <td>3</td>\n",
       "      <td>-524.954590</td>\n",
       "      <td>7.511226e-259</td>\n",
       "      <td>1.972947e-202</td>\n",
       "      <td>5.831876e-153</td>\n",
       "      <td>1.939945e-110</td>\n",
       "      <td>7.262046e-75</td>\n",
       "      <td>3.059262e-46</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>615</td>\n",
       "      <td>59752.4334</td>\n",
       "      <td>4</td>\n",
       "      <td>-393.480225</td>\n",
       "      <td>6.962548e-259</td>\n",
       "      <td>1.844992e-202</td>\n",
       "      <td>5.501857e-153</td>\n",
       "      <td>1.846342e-110</td>\n",
       "      <td>6.972741e-75</td>\n",
       "      <td>2.963351e-46</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>615</td>\n",
       "      <td>59752.4435</td>\n",
       "      <td>5</td>\n",
       "      <td>-355.886780</td>\n",
       "      <td>6.494101e-259</td>\n",
       "      <td>1.734820e-202</td>\n",
       "      <td>5.215288e-153</td>\n",
       "      <td>1.764373e-110</td>\n",
       "      <td>6.717238e-75</td>\n",
       "      <td>2.877925e-46</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>615</td>\n",
       "      <td>59767.2968</td>\n",
       "      <td>2</td>\n",
       "      <td>-548.013550</td>\n",
       "      <td>2.569150e-305</td>\n",
       "      <td>9.933219e-244</td>\n",
       "      <td>4.321940e-189</td>\n",
       "      <td>2.116196e-141</td>\n",
       "      <td>1.166061e-100</td>\n",
       "      <td>7.230608e-67</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>615</td>\n",
       "      <td>59767.3045</td>\n",
       "      <td>1</td>\n",
       "      <td>-815.188599</td>\n",
       "      <td>2.425159e-305</td>\n",
       "      <td>9.434437e-244</td>\n",
       "      <td>4.130285e-189</td>\n",
       "      <td>2.034850e-141</td>\n",
       "      <td>1.128166e-100</td>\n",
       "      <td>7.038852e-67</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>615</td>\n",
       "      <td>59767.3122</td>\n",
       "      <td>3</td>\n",
       "      <td>-475.516052</td>\n",
       "      <td>2.289233e-305</td>\n",
       "      <td>8.960680e-244</td>\n",
       "      <td>3.947119e-189</td>\n",
       "      <td>1.956626e-141</td>\n",
       "      <td>1.091500e-100</td>\n",
       "      <td>6.852165e-67</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>615</td>\n",
       "      <td>59767.3233</td>\n",
       "      <td>4</td>\n",
       "      <td>-405.663818</td>\n",
       "      <td>2.106574e-305</td>\n",
       "      <td>8.319251e-244</td>\n",
       "      <td>3.697261e-189</td>\n",
       "      <td>1.849116e-141</td>\n",
       "      <td>1.040726e-100</td>\n",
       "      <td>6.591697e-67</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>615</td>\n",
       "      <td>59767.3343</td>\n",
       "      <td>5</td>\n",
       "      <td>-421.199066</td>\n",
       "      <td>1.939933e-305</td>\n",
       "      <td>7.728870e-244</td>\n",
       "      <td>3.465242e-189</td>\n",
       "      <td>1.748395e-141</td>\n",
       "      <td>9.927358e-101</td>\n",
       "      <td>6.343313e-67</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>615</td>\n",
       "      <td>59770.2179</td>\n",
       "      <td>2</td>\n",
       "      <td>-554.903198</td>\n",
       "      <td>6.809169e-315</td>\n",
       "      <td>2.724512e-252</td>\n",
       "      <td>1.226794e-196</td>\n",
       "      <td>6.216454e-148</td>\n",
       "      <td>3.544885e-106</td>\n",
       "      <td>2.274835e-71</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>615</td>\n",
       "      <td>59770.2256</td>\n",
       "      <td>1</td>\n",
       "      <td>-820.042786</td>\n",
       "      <td>6.421761e-315</td>\n",
       "      <td>2.585377e-252</td>\n",
       "      <td>1.171338e-196</td>\n",
       "      <td>5.972119e-148</td>\n",
       "      <td>3.426598e-106</td>\n",
       "      <td>2.212515e-71</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>615</td>\n",
       "      <td>59770.2334</td>\n",
       "      <td>3</td>\n",
       "      <td>-477.004730</td>\n",
       "      <td>6.051774e-315</td>\n",
       "      <td>2.451673e-252</td>\n",
       "      <td>1.117714e-196</td>\n",
       "      <td>5.734388e-148</td>\n",
       "      <td>3.310791e-106</td>\n",
       "      <td>2.151120e-71</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>615</td>\n",
       "      <td>59770.2445</td>\n",
       "      <td>4</td>\n",
       "      <td>-400.270386</td>\n",
       "      <td>5.561682e-315</td>\n",
       "      <td>2.273226e-252</td>\n",
       "      <td>1.045604e-196</td>\n",
       "      <td>5.412278e-148</td>\n",
       "      <td>3.152690e-106</td>\n",
       "      <td>2.066669e-71</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>615</td>\n",
       "      <td>59770.2557</td>\n",
       "      <td>5</td>\n",
       "      <td>-415.286896</td>\n",
       "      <td>5.107367e-315</td>\n",
       "      <td>2.106322e-252</td>\n",
       "      <td>9.775536e-197</td>\n",
       "      <td>5.105577e-148</td>\n",
       "      <td>3.000802e-106</td>\n",
       "      <td>1.984806e-71</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>615</td>\n",
       "      <td>59779.3188</td>\n",
       "      <td>2</td>\n",
       "      <td>-630.523682</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>6.457145e-280</td>\n",
       "      <td>4.221822e-221</td>\n",
       "      <td>3.106330e-169</td>\n",
       "      <td>2.572074e-124</td>\n",
       "      <td>2.396667e-86</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>615</td>\n",
       "      <td>59779.3265</td>\n",
       "      <td>1</td>\n",
       "      <td>-921.002502</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>6.110242e-280</td>\n",
       "      <td>4.019695e-221</td>\n",
       "      <td>2.975884e-169</td>\n",
       "      <td>2.479289e-124</td>\n",
       "      <td>2.324485e-86</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>615</td>\n",
       "      <td>59779.3342</td>\n",
       "      <td>3</td>\n",
       "      <td>-518.533997</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>5.781963e-280</td>\n",
       "      <td>3.827236e-221</td>\n",
       "      <td>2.850909e-169</td>\n",
       "      <td>2.389846e-124</td>\n",
       "      <td>2.254471e-86</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>615</td>\n",
       "      <td>59779.3452</td>\n",
       "      <td>4</td>\n",
       "      <td>-422.184509</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>5.343329e-280</td>\n",
       "      <td>3.568154e-221</td>\n",
       "      <td>2.681412e-169</td>\n",
       "      <td>2.267628e-124</td>\n",
       "      <td>2.158084e-86</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>615</td>\n",
       "      <td>59779.3562</td>\n",
       "      <td>5</td>\n",
       "      <td>-422.815094</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>4.937947e-280</td>\n",
       "      <td>3.326595e-221</td>\n",
       "      <td>2.521980e-169</td>\n",
       "      <td>2.151650e-124</td>\n",
       "      <td>2.065808e-86</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>615</td>\n",
       "      <td>59782.1897</td>\n",
       "      <td>2</td>\n",
       "      <td>-280.039520</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>6.266994e-289</td>\n",
       "      <td>4.073536e-229</td>\n",
       "      <td>2.979696e-176</td>\n",
       "      <td>2.452792e-130</td>\n",
       "      <td>2.272154e-91</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>615</td>\n",
       "      <td>59782.1974</td>\n",
       "      <td>1</td>\n",
       "      <td>-449.095612</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>5.925066e-289</td>\n",
       "      <td>3.875080e-229</td>\n",
       "      <td>2.852045e-176</td>\n",
       "      <td>2.362220e-130</td>\n",
       "      <td>2.201774e-91</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>615</td>\n",
       "      <td>59782.2051</td>\n",
       "      <td>3</td>\n",
       "      <td>-316.704865</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>5.601780e-289</td>\n",
       "      <td>3.686284e-229</td>\n",
       "      <td>2.729856e-176</td>\n",
       "      <td>2.274988e-130</td>\n",
       "      <td>2.133569e-91</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>615</td>\n",
       "      <td>59782.2162</td>\n",
       "      <td>4</td>\n",
       "      <td>-332.885437</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>5.166514e-289</td>\n",
       "      <td>3.430179e-229</td>\n",
       "      <td>2.562857e-176</td>\n",
       "      <td>2.154866e-130</td>\n",
       "      <td>2.038939e-91</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>615</td>\n",
       "      <td>59782.2274</td>\n",
       "      <td>5</td>\n",
       "      <td>-365.075775</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>4.761573e-289</td>\n",
       "      <td>3.189782e-229</td>\n",
       "      <td>2.404694e-176</td>\n",
       "      <td>2.040079e-130</td>\n",
       "      <td>1.947701e-91</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>615</td>\n",
       "      <td>59797.2861</td>\n",
       "      <td>2</td>\n",
       "      <td>391.399231</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>1.273435e-273</td>\n",
       "      <td>1.637586e-215</td>\n",
       "      <td>2.369842e-164</td>\n",
       "      <td>3.859428e-120</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1421675</th>\n",
       "      <td>130779836</td>\n",
       "      <td>60464.2127</td>\n",
       "      <td>2</td>\n",
       "      <td>3.294472</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>6.694557e-03</td>\n",
       "      <td>7.151203e-12</td>\n",
       "      <td>8.596560e-28</td>\n",
       "      <td>1.162943e-50</td>\n",
       "      <td>1.770438e-80</td>\n",
       "      <td>3.033131e-117</td>\n",
       "      <td>5.847764e-161</td>\n",
       "      <td>1.268752e-211</td>\n",
       "      <td>3.097792e-269</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1421676</th>\n",
       "      <td>130779836</td>\n",
       "      <td>60466.2566</td>\n",
       "      <td>0</td>\n",
       "      <td>113.988297</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>2.244920e-02</td>\n",
       "      <td>1.230217e-10</td>\n",
       "      <td>7.586665e-26</td>\n",
       "      <td>5.265121e-48</td>\n",
       "      <td>4.112009e-77</td>\n",
       "      <td>3.614000e-113</td>\n",
       "      <td>3.574460e-156</td>\n",
       "      <td>3.978516e-206</td>\n",
       "      <td>4.983334e-263</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1421677</th>\n",
       "      <td>130779836</td>\n",
       "      <td>60490.1588</td>\n",
       "      <td>2</td>\n",
       "      <td>12.464979</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>1.287207e-01</td>\n",
       "      <td>1.422015e-01</td>\n",
       "      <td>1.767862e-08</td>\n",
       "      <td>2.473322e-22</td>\n",
       "      <td>3.894047e-43</td>\n",
       "      <td>6.899380e-71</td>\n",
       "      <td>1.375648e-105</td>\n",
       "      <td>3.086688e-147</td>\n",
       "      <td>7.794109e-196</td>\n",
       "      <td>2.214770e-251</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1421678</th>\n",
       "      <td>130779836</td>\n",
       "      <td>60491.1907</td>\n",
       "      <td>1</td>\n",
       "      <td>-13.734149</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>8.296759e-02</td>\n",
       "      <td>2.092584e-01</td>\n",
       "      <td>5.939444e-08</td>\n",
       "      <td>1.897129e-21</td>\n",
       "      <td>6.819244e-42</td>\n",
       "      <td>2.758442e-69</td>\n",
       "      <td>1.255683e-103</td>\n",
       "      <td>6.432564e-145</td>\n",
       "      <td>3.708315e-193</td>\n",
       "      <td>2.405789e-248</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1421679</th>\n",
       "      <td>130779836</td>\n",
       "      <td>60496.1248</td>\n",
       "      <td>2</td>\n",
       "      <td>-14.478923</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>5.638801e-03</td>\n",
       "      <td>7.366195e-01</td>\n",
       "      <td>1.082899e-05</td>\n",
       "      <td>1.791517e-17</td>\n",
       "      <td>3.335356e-36</td>\n",
       "      <td>6.987983e-62</td>\n",
       "      <td>1.647592e-94</td>\n",
       "      <td>4.371554e-134</td>\n",
       "      <td>1.305300e-180</td>\n",
       "      <td>4.386045e-234</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1421680</th>\n",
       "      <td>130779836</td>\n",
       "      <td>60497.1472</td>\n",
       "      <td>3</td>\n",
       "      <td>12.178056</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>2.859733e-03</td>\n",
       "      <td>8.464476e-01</td>\n",
       "      <td>2.819441e-05</td>\n",
       "      <td>1.056852e-16</td>\n",
       "      <td>4.458139e-35</td>\n",
       "      <td>2.116320e-60</td>\n",
       "      <td>1.130570e-92</td>\n",
       "      <td>6.796755e-132</td>\n",
       "      <td>4.598268e-178</td>\n",
       "      <td>3.500863e-231</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1421681</th>\n",
       "      <td>130779836</td>\n",
       "      <td>60498.1867</td>\n",
       "      <td>3</td>\n",
       "      <td>-20.815857</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>1.373775e-03</td>\n",
       "      <td>9.340059e-01</td>\n",
       "      <td>7.146144e-05</td>\n",
       "      <td>6.152934e-16</td>\n",
       "      <td>5.961849e-34</td>\n",
       "      <td>6.500818e-59</td>\n",
       "      <td>7.977068e-91</td>\n",
       "      <td>1.101557e-129</td>\n",
       "      <td>1.711823e-175</td>\n",
       "      <td>2.993636e-228</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1421682</th>\n",
       "      <td>130779836</td>\n",
       "      <td>60499.1367</td>\n",
       "      <td>0</td>\n",
       "      <td>54.361107</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>6.768684e-04</td>\n",
       "      <td>9.840154e-01</td>\n",
       "      <td>1.609859e-04</td>\n",
       "      <td>2.963890e-15</td>\n",
       "      <td>6.140796e-33</td>\n",
       "      <td>1.431777e-57</td>\n",
       "      <td>3.756770e-89</td>\n",
       "      <td>1.109282e-127</td>\n",
       "      <td>3.686020e-173</td>\n",
       "      <td>1.378357e-225</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1421683</th>\n",
       "      <td>130779836</td>\n",
       "      <td>60503.1145</td>\n",
       "      <td>3</td>\n",
       "      <td>9.912425</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>2.360829e-05</td>\n",
       "      <td>8.271637e-01</td>\n",
       "      <td>3.261420e-03</td>\n",
       "      <td>1.447139e-12</td>\n",
       "      <td>7.226068e-29</td>\n",
       "      <td>4.060525e-52</td>\n",
       "      <td>2.567737e-82</td>\n",
       "      <td>1.827289e-119</td>\n",
       "      <td>1.463363e-163</td>\n",
       "      <td>1.318820e-214</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1421684</th>\n",
       "      <td>130779836</td>\n",
       "      <td>60505.1075</td>\n",
       "      <td>2</td>\n",
       "      <td>17.719660</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>3.463236e-06</td>\n",
       "      <td>5.976517e-01</td>\n",
       "      <td>1.160653e-02</td>\n",
       "      <td>2.536560e-11</td>\n",
       "      <td>6.238441e-27</td>\n",
       "      <td>1.726614e-49</td>\n",
       "      <td>5.377777e-79</td>\n",
       "      <td>1.884945e-115</td>\n",
       "      <td>7.435030e-159</td>\n",
       "      <td>3.300313e-209</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1421685</th>\n",
       "      <td>130779836</td>\n",
       "      <td>60506.0962</td>\n",
       "      <td>5</td>\n",
       "      <td>-86.457382</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>1.259932e-06</td>\n",
       "      <td>4.795378e-01</td>\n",
       "      <td>2.053935e-02</td>\n",
       "      <td>9.900085e-11</td>\n",
       "      <td>5.370064e-26</td>\n",
       "      <td>3.277995e-48</td>\n",
       "      <td>2.251777e-77</td>\n",
       "      <td>1.740727e-113</td>\n",
       "      <td>1.514343e-156</td>\n",
       "      <td>1.482540e-206</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1421686</th>\n",
       "      <td>130779836</td>\n",
       "      <td>60510.2053</td>\n",
       "      <td>4</td>\n",
       "      <td>-39.215195</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>1.239733e-08</td>\n",
       "      <td>1.263139e-01</td>\n",
       "      <td>1.448314e-01</td>\n",
       "      <td>1.868799e-08</td>\n",
       "      <td>2.713630e-22</td>\n",
       "      <td>4.434320e-43</td>\n",
       "      <td>8.154393e-71</td>\n",
       "      <td>1.687503e-105</td>\n",
       "      <td>3.929939e-147</td>\n",
       "      <td>1.029948e-195</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1421687</th>\n",
       "      <td>130779836</td>\n",
       "      <td>60515.2731</td>\n",
       "      <td>5</td>\n",
       "      <td>-81.113083</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>1.637180e-11</td>\n",
       "      <td>9.615100e-03</td>\n",
       "      <td>6.354763e-01</td>\n",
       "      <td>4.726429e-06</td>\n",
       "      <td>3.955991e-18</td>\n",
       "      <td>3.726196e-37</td>\n",
       "      <td>3.949703e-63</td>\n",
       "      <td>4.711416e-96</td>\n",
       "      <td>6.324507e-136</td>\n",
       "      <td>9.554111e-183</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1421688</th>\n",
       "      <td>130779836</td>\n",
       "      <td>60524.0372</td>\n",
       "      <td>0</td>\n",
       "      <td>136.082718</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>1.520201e-17</td>\n",
       "      <td>9.901897e-06</td>\n",
       "      <td>7.258121e-01</td>\n",
       "      <td>5.987124e-03</td>\n",
       "      <td>5.557770e-12</td>\n",
       "      <td>5.805922e-28</td>\n",
       "      <td>6.825432e-51</td>\n",
       "      <td>9.029783e-81</td>\n",
       "      <td>1.344351e-117</td>\n",
       "      <td>2.252354e-161</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1421689</th>\n",
       "      <td>130779836</td>\n",
       "      <td>60525.0621</td>\n",
       "      <td>0</td>\n",
       "      <td>43.910740</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>2.450951e-18</td>\n",
       "      <td>3.624423e-06</td>\n",
       "      <td>6.031584e-01</td>\n",
       "      <td>1.129567e-02</td>\n",
       "      <td>2.380571e-11</td>\n",
       "      <td>5.645970e-27</td>\n",
       "      <td>1.506899e-49</td>\n",
       "      <td>4.526038e-79</td>\n",
       "      <td>1.529820e-115</td>\n",
       "      <td>5.819034e-159</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1421690</th>\n",
       "      <td>130779836</td>\n",
       "      <td>60526.1904</td>\n",
       "      <td>3</td>\n",
       "      <td>59.376686</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>3.131166e-19</td>\n",
       "      <td>1.141884e-06</td>\n",
       "      <td>4.686255e-01</td>\n",
       "      <td>2.164304e-02</td>\n",
       "      <td>1.124861e-10</td>\n",
       "      <td>6.579120e-26</td>\n",
       "      <td>4.330371e-48</td>\n",
       "      <td>3.207529e-77</td>\n",
       "      <td>2.673649e-113</td>\n",
       "      <td>2.507994e-156</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1421691</th>\n",
       "      <td>130779836</td>\n",
       "      <td>60528.0336</td>\n",
       "      <td>3</td>\n",
       "      <td>5.993599</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>9.734059e-21</td>\n",
       "      <td>1.550969e-07</td>\n",
       "      <td>2.780996e-01</td>\n",
       "      <td>5.611590e-02</td>\n",
       "      <td>1.274265e-09</td>\n",
       "      <td>3.256283e-24</td>\n",
       "      <td>9.364241e-46</td>\n",
       "      <td>3.030480e-74</td>\n",
       "      <td>1.103668e-109</td>\n",
       "      <td>4.523283e-152</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1421692</th>\n",
       "      <td>130779836</td>\n",
       "      <td>60530.0978</td>\n",
       "      <td>1</td>\n",
       "      <td>2.986908</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>1.698578e-22</td>\n",
       "      <td>1.411143e-08</td>\n",
       "      <td>1.319304e-01</td>\n",
       "      <td>1.388056e-01</td>\n",
       "      <td>1.643454e-08</td>\n",
       "      <td>2.189759e-22</td>\n",
       "      <td>3.283396e-43</td>\n",
       "      <td>5.540368e-71</td>\n",
       "      <td>1.052064e-105</td>\n",
       "      <td>2.248196e-147</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1421693</th>\n",
       "      <td>130779836</td>\n",
       "      <td>60536.0451</td>\n",
       "      <td>5</td>\n",
       "      <td>5.653964</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>5.630444e-28</td>\n",
       "      <td>5.449189e-12</td>\n",
       "      <td>5.934845e-03</td>\n",
       "      <td>7.274032e-01</td>\n",
       "      <td>1.003297e-05</td>\n",
       "      <td>1.557298e-17</td>\n",
       "      <td>2.720210e-36</td>\n",
       "      <td>5.347138e-62</td>\n",
       "      <td>1.182847e-94</td>\n",
       "      <td>2.944586e-134</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1421694</th>\n",
       "      <td>130779836</td>\n",
       "      <td>60537.1470</td>\n",
       "      <td>3</td>\n",
       "      <td>-41.850040</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>4.654142e-29</td>\n",
       "      <td>1.087597e-12</td>\n",
       "      <td>2.860125e-03</td>\n",
       "      <td>8.464281e-01</td>\n",
       "      <td>2.818925e-05</td>\n",
       "      <td>1.056489e-16</td>\n",
       "      <td>4.455896e-35</td>\n",
       "      <td>2.114917e-60</td>\n",
       "      <td>1.129639e-92</td>\n",
       "      <td>6.790077e-132</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1421695</th>\n",
       "      <td>130779836</td>\n",
       "      <td>60542.0489</td>\n",
       "      <td>4</td>\n",
       "      <td>-60.500492</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>3.941971e-34</td>\n",
       "      <td>4.649823e-16</td>\n",
       "      <td>6.172310e-05</td>\n",
       "      <td>9.220348e-01</td>\n",
       "      <td>1.550013e-03</td>\n",
       "      <td>2.932320e-13</td>\n",
       "      <td>6.242748e-30</td>\n",
       "      <td>1.495645e-53</td>\n",
       "      <td>4.032456e-84</td>\n",
       "      <td>1.223486e-121</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1421696</th>\n",
       "      <td>130779836</td>\n",
       "      <td>60543.0247</td>\n",
       "      <td>4</td>\n",
       "      <td>-48.527161</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>3.437239e-35</td>\n",
       "      <td>8.850348e-17</td>\n",
       "      <td>2.564480e-05</td>\n",
       "      <td>8.362315e-01</td>\n",
       "      <td>3.068612e-03</td>\n",
       "      <td>1.267202e-12</td>\n",
       "      <td>5.888951e-29</td>\n",
       "      <td>3.079770e-52</td>\n",
       "      <td>1.812537e-82</td>\n",
       "      <td>1.200450e-119</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1421697</th>\n",
       "      <td>130779836</td>\n",
       "      <td>60545.9844</td>\n",
       "      <td>5</td>\n",
       "      <td>32.006413</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>1.665158e-38</td>\n",
       "      <td>4.576264e-19</td>\n",
       "      <td>1.415322e-06</td>\n",
       "      <td>4.925921e-01</td>\n",
       "      <td>1.929337e-02</td>\n",
       "      <td>8.503877e-11</td>\n",
       "      <td>4.218074e-26</td>\n",
       "      <td>2.354505e-48</td>\n",
       "      <td>1.479018e-77</td>\n",
       "      <td>1.045528e-113</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1421698</th>\n",
       "      <td>130779836</td>\n",
       "      <td>60546.9804</td>\n",
       "      <td>5</td>\n",
       "      <td>68.152985</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>1.179644e-39</td>\n",
       "      <td>7.192046e-20</td>\n",
       "      <td>4.934491e-07</td>\n",
       "      <td>3.809961e-01</td>\n",
       "      <td>3.310450e-02</td>\n",
       "      <td>3.236993e-10</td>\n",
       "      <td>3.561925e-25</td>\n",
       "      <td>4.410788e-47</td>\n",
       "      <td>6.146612e-76</td>\n",
       "      <td>9.639260e-112</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1421699</th>\n",
       "      <td>130779836</td>\n",
       "      <td>60548.9789</td>\n",
       "      <td>4</td>\n",
       "      <td>-60.066154</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>5.162477e-42</td>\n",
       "      <td>1.557076e-21</td>\n",
       "      <td>5.285057e-08</td>\n",
       "      <td>2.018728e-01</td>\n",
       "      <td>8.677494e-02</td>\n",
       "      <td>4.197581e-09</td>\n",
       "      <td>2.285031e-23</td>\n",
       "      <td>1.399824e-44</td>\n",
       "      <td>9.650352e-73</td>\n",
       "      <td>7.486884e-108</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1421700</th>\n",
       "      <td>130779836</td>\n",
       "      <td>60555.9838</td>\n",
       "      <td>4</td>\n",
       "      <td>-39.881969</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>7.887733e-51</td>\n",
       "      <td>6.458852e-28</td>\n",
       "      <td>5.951779e-12</td>\n",
       "      <td>6.172008e-03</td>\n",
       "      <td>7.202687e-01</td>\n",
       "      <td>9.459122e-06</td>\n",
       "      <td>1.397962e-17</td>\n",
       "      <td>2.325029e-36</td>\n",
       "      <td>4.351605e-62</td>\n",
       "      <td>9.165559e-95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1421701</th>\n",
       "      <td>130779836</td>\n",
       "      <td>60560.0459</td>\n",
       "      <td>1</td>\n",
       "      <td>14.894439</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>2.478473e-56</td>\n",
       "      <td>5.232453e-32</td>\n",
       "      <td>1.243125e-14</td>\n",
       "      <td>3.323630e-04</td>\n",
       "      <td>9.999973e-01</td>\n",
       "      <td>3.385893e-04</td>\n",
       "      <td>1.290137e-14</td>\n",
       "      <td>5.532060e-32</td>\n",
       "      <td>2.669477e-56</td>\n",
       "      <td>1.449618e-87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1421702</th>\n",
       "      <td>130779836</td>\n",
       "      <td>60571.0225</td>\n",
       "      <td>5</td>\n",
       "      <td>30.593130</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>1.232539e-72</td>\n",
       "      <td>1.694272e-44</td>\n",
       "      <td>2.620922e-23</td>\n",
       "      <td>4.562611e-09</td>\n",
       "      <td>8.938425e-02</td>\n",
       "      <td>1.970593e-01</td>\n",
       "      <td>4.889011e-08</td>\n",
       "      <td>1.365002e-21</td>\n",
       "      <td>4.288783e-42</td>\n",
       "      <td>1.516433e-69</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1421703</th>\n",
       "      <td>130779836</td>\n",
       "      <td>60585.9974</td>\n",
       "      <td>4</td>\n",
       "      <td>-23.471439</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>2.973584e-98</td>\n",
       "      <td>6.520427e-65</td>\n",
       "      <td>1.609015e-38</td>\n",
       "      <td>4.468200e-19</td>\n",
       "      <td>1.396347e-06</td>\n",
       "      <td>4.910687e-01</td>\n",
       "      <td>1.943478e-02</td>\n",
       "      <td>8.655758e-11</td>\n",
       "      <td>4.338294e-26</td>\n",
       "      <td>2.446928e-48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1421704</th>\n",
       "      <td>130779836</td>\n",
       "      <td>60588.0372</td>\n",
       "      <td>0</td>\n",
       "      <td>-41.214264</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>4.812185e-102</td>\n",
       "      <td>5.395570e-68</td>\n",
       "      <td>6.808015e-41</td>\n",
       "      <td>9.667007e-21</td>\n",
       "      <td>1.544727e-07</td>\n",
       "      <td>2.777794e-01</td>\n",
       "      <td>5.621295e-02</td>\n",
       "      <td>1.280151e-09</td>\n",
       "      <td>3.280757e-24</td>\n",
       "      <td>9.461833e-46</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1421705 rows × 59 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         object_id         mjd  passband         flux           sw_0  \\\n",
       "0              615  59750.4229         2  -544.810303  6.743158e-253   \n",
       "1              615  59750.4306         1  -816.434326  6.398397e-253   \n",
       "2              615  59750.4383         3  -471.385529  6.071248e-253   \n",
       "3              615  59750.4450         4  -388.984985  5.800215e-253   \n",
       "4              615  59752.4070         2  -681.858887  8.352701e-259   \n",
       "5              615  59752.4147         1 -1061.457031  7.920806e-259   \n",
       "6              615  59752.4224         3  -524.954590  7.511226e-259   \n",
       "7              615  59752.4334         4  -393.480225  6.962548e-259   \n",
       "8              615  59752.4435         5  -355.886780  6.494101e-259   \n",
       "9              615  59767.2968         2  -548.013550  2.569150e-305   \n",
       "10             615  59767.3045         1  -815.188599  2.425159e-305   \n",
       "11             615  59767.3122         3  -475.516052  2.289233e-305   \n",
       "12             615  59767.3233         4  -405.663818  2.106574e-305   \n",
       "13             615  59767.3343         5  -421.199066  1.939933e-305   \n",
       "14             615  59770.2179         2  -554.903198  6.809169e-315   \n",
       "15             615  59770.2256         1  -820.042786  6.421761e-315   \n",
       "16             615  59770.2334         3  -477.004730  6.051774e-315   \n",
       "17             615  59770.2445         4  -400.270386  5.561682e-315   \n",
       "18             615  59770.2557         5  -415.286896  5.107367e-315   \n",
       "19             615  59779.3188         2  -630.523682   0.000000e+00   \n",
       "20             615  59779.3265         1  -921.002502   0.000000e+00   \n",
       "21             615  59779.3342         3  -518.533997   0.000000e+00   \n",
       "22             615  59779.3452         4  -422.184509   0.000000e+00   \n",
       "23             615  59779.3562         5  -422.815094   0.000000e+00   \n",
       "24             615  59782.1897         2  -280.039520   0.000000e+00   \n",
       "25             615  59782.1974         1  -449.095612   0.000000e+00   \n",
       "26             615  59782.2051         3  -316.704865   0.000000e+00   \n",
       "27             615  59782.2162         4  -332.885437   0.000000e+00   \n",
       "28             615  59782.2274         5  -365.075775   0.000000e+00   \n",
       "29             615  59797.2861         2   391.399231   0.000000e+00   \n",
       "...            ...         ...       ...          ...            ...   \n",
       "1421675  130779836  60464.2127         2     3.294472   0.000000e+00   \n",
       "1421676  130779836  60466.2566         0   113.988297   0.000000e+00   \n",
       "1421677  130779836  60490.1588         2    12.464979   0.000000e+00   \n",
       "1421678  130779836  60491.1907         1   -13.734149   0.000000e+00   \n",
       "1421679  130779836  60496.1248         2   -14.478923   0.000000e+00   \n",
       "1421680  130779836  60497.1472         3    12.178056   0.000000e+00   \n",
       "1421681  130779836  60498.1867         3   -20.815857   0.000000e+00   \n",
       "1421682  130779836  60499.1367         0    54.361107   0.000000e+00   \n",
       "1421683  130779836  60503.1145         3     9.912425   0.000000e+00   \n",
       "1421684  130779836  60505.1075         2    17.719660   0.000000e+00   \n",
       "1421685  130779836  60506.0962         5   -86.457382   0.000000e+00   \n",
       "1421686  130779836  60510.2053         4   -39.215195   0.000000e+00   \n",
       "1421687  130779836  60515.2731         5   -81.113083   0.000000e+00   \n",
       "1421688  130779836  60524.0372         0   136.082718   0.000000e+00   \n",
       "1421689  130779836  60525.0621         0    43.910740   0.000000e+00   \n",
       "1421690  130779836  60526.1904         3    59.376686   0.000000e+00   \n",
       "1421691  130779836  60528.0336         3     5.993599   0.000000e+00   \n",
       "1421692  130779836  60530.0978         1     2.986908   0.000000e+00   \n",
       "1421693  130779836  60536.0451         5     5.653964   0.000000e+00   \n",
       "1421694  130779836  60537.1470         3   -41.850040   0.000000e+00   \n",
       "1421695  130779836  60542.0489         4   -60.500492   0.000000e+00   \n",
       "1421696  130779836  60543.0247         4   -48.527161   0.000000e+00   \n",
       "1421697  130779836  60545.9844         5    32.006413   0.000000e+00   \n",
       "1421698  130779836  60546.9804         5    68.152985   0.000000e+00   \n",
       "1421699  130779836  60548.9789         4   -60.066154   0.000000e+00   \n",
       "1421700  130779836  60555.9838         4   -39.881969   0.000000e+00   \n",
       "1421701  130779836  60560.0459         1    14.894439   0.000000e+00   \n",
       "1421702  130779836  60571.0225         5    30.593130   0.000000e+00   \n",
       "1421703  130779836  60585.9974         4   -23.471439   0.000000e+00   \n",
       "1421704  130779836  60588.0372         0   -41.214264   0.000000e+00   \n",
       "\n",
       "                  sw_1           sw_2           sw_3           sw_4  \\\n",
       "0        3.577424e-197  2.135826e-148  1.434993e-106   1.084980e-71   \n",
       "1        3.415494e-197  2.051749e-148  1.387022e-106   1.055190e-71   \n",
       "2        3.260886e-197  1.970977e-148  1.340651e-106   1.026215e-71   \n",
       "3        3.132057e-197  1.903283e-148  1.301564e-106   1.001649e-71   \n",
       "4        2.167110e-202  6.327373e-153  2.078998e-110   7.687287e-75   \n",
       "5        2.067753e-202  6.074582e-153  2.008271e-110   7.471650e-75   \n",
       "6        1.972947e-202  5.831876e-153  1.939945e-110   7.262046e-75   \n",
       "7        1.844992e-202  5.501857e-153  1.846342e-110   6.972741e-75   \n",
       "8        1.734820e-202  5.215288e-153  1.764373e-110   6.717238e-75   \n",
       "9        9.933219e-244  4.321940e-189  2.116196e-141  1.166061e-100   \n",
       "10       9.434437e-244  4.130285e-189  2.034850e-141  1.128166e-100   \n",
       "11       8.960680e-244  3.947119e-189  1.956626e-141  1.091500e-100   \n",
       "12       8.319251e-244  3.697261e-189  1.849116e-141  1.040726e-100   \n",
       "13       7.728870e-244  3.465242e-189  1.748395e-141  9.927358e-101   \n",
       "14       2.724512e-252  1.226794e-196  6.216454e-148  3.544885e-106   \n",
       "15       2.585377e-252  1.171338e-196  5.972119e-148  3.426598e-106   \n",
       "16       2.451673e-252  1.117714e-196  5.734388e-148  3.310791e-106   \n",
       "17       2.273226e-252  1.045604e-196  5.412278e-148  3.152690e-106   \n",
       "18       2.106322e-252  9.775536e-197  5.105577e-148  3.000802e-106   \n",
       "19       6.457145e-280  4.221822e-221  3.106330e-169  2.572074e-124   \n",
       "20       6.110242e-280  4.019695e-221  2.975884e-169  2.479289e-124   \n",
       "21       5.781963e-280  3.827236e-221  2.850909e-169  2.389846e-124   \n",
       "22       5.343329e-280  3.568154e-221  2.681412e-169  2.267628e-124   \n",
       "23       4.937947e-280  3.326595e-221  2.521980e-169  2.151650e-124   \n",
       "24       6.266994e-289  4.073536e-229  2.979696e-176  2.452792e-130   \n",
       "25       5.925066e-289  3.875080e-229  2.852045e-176  2.362220e-130   \n",
       "26       5.601780e-289  3.686284e-229  2.729856e-176  2.274988e-130   \n",
       "27       5.166514e-289  3.430179e-229  2.562857e-176  2.154866e-130   \n",
       "28       4.761573e-289  3.189782e-229  2.404694e-176  2.040079e-130   \n",
       "29        0.000000e+00  1.273435e-273  1.637586e-215  2.369842e-164   \n",
       "...                ...            ...            ...            ...   \n",
       "1421675   0.000000e+00   0.000000e+00   0.000000e+00   0.000000e+00   \n",
       "1421676   0.000000e+00   0.000000e+00   0.000000e+00   0.000000e+00   \n",
       "1421677   0.000000e+00   0.000000e+00   0.000000e+00   0.000000e+00   \n",
       "1421678   0.000000e+00   0.000000e+00   0.000000e+00   0.000000e+00   \n",
       "1421679   0.000000e+00   0.000000e+00   0.000000e+00   0.000000e+00   \n",
       "1421680   0.000000e+00   0.000000e+00   0.000000e+00   0.000000e+00   \n",
       "1421681   0.000000e+00   0.000000e+00   0.000000e+00   0.000000e+00   \n",
       "1421682   0.000000e+00   0.000000e+00   0.000000e+00   0.000000e+00   \n",
       "1421683   0.000000e+00   0.000000e+00   0.000000e+00   0.000000e+00   \n",
       "1421684   0.000000e+00   0.000000e+00   0.000000e+00   0.000000e+00   \n",
       "1421685   0.000000e+00   0.000000e+00   0.000000e+00   0.000000e+00   \n",
       "1421686   0.000000e+00   0.000000e+00   0.000000e+00   0.000000e+00   \n",
       "1421687   0.000000e+00   0.000000e+00   0.000000e+00   0.000000e+00   \n",
       "1421688   0.000000e+00   0.000000e+00   0.000000e+00   0.000000e+00   \n",
       "1421689   0.000000e+00   0.000000e+00   0.000000e+00   0.000000e+00   \n",
       "1421690   0.000000e+00   0.000000e+00   0.000000e+00   0.000000e+00   \n",
       "1421691   0.000000e+00   0.000000e+00   0.000000e+00   0.000000e+00   \n",
       "1421692   0.000000e+00   0.000000e+00   0.000000e+00   0.000000e+00   \n",
       "1421693   0.000000e+00   0.000000e+00   0.000000e+00   0.000000e+00   \n",
       "1421694   0.000000e+00   0.000000e+00   0.000000e+00   0.000000e+00   \n",
       "1421695   0.000000e+00   0.000000e+00   0.000000e+00   0.000000e+00   \n",
       "1421696   0.000000e+00   0.000000e+00   0.000000e+00   0.000000e+00   \n",
       "1421697   0.000000e+00   0.000000e+00   0.000000e+00   0.000000e+00   \n",
       "1421698   0.000000e+00   0.000000e+00   0.000000e+00   0.000000e+00   \n",
       "1421699   0.000000e+00   0.000000e+00   0.000000e+00   0.000000e+00   \n",
       "1421700   0.000000e+00   0.000000e+00   0.000000e+00   0.000000e+00   \n",
       "1421701   0.000000e+00   0.000000e+00   0.000000e+00   0.000000e+00   \n",
       "1421702   0.000000e+00   0.000000e+00   0.000000e+00   0.000000e+00   \n",
       "1421703   0.000000e+00   0.000000e+00   0.000000e+00   0.000000e+00   \n",
       "1421704   0.000000e+00   0.000000e+00   0.000000e+00   0.000000e+00   \n",
       "\n",
       "                  sw_5      ...                sw_45         sw_46  \\\n",
       "0         9.231706e-44      ...         0.000000e+00  0.000000e+00   \n",
       "1         9.033709e-44      ...         0.000000e+00  0.000000e+00   \n",
       "2         8.839937e-44      ...         0.000000e+00  0.000000e+00   \n",
       "3         8.674699e-44      ...         0.000000e+00  0.000000e+00   \n",
       "4         3.198750e-46      ...         0.000000e+00  0.000000e+00   \n",
       "5         3.128233e-46      ...         0.000000e+00  0.000000e+00   \n",
       "6         3.059262e-46      ...         0.000000e+00  0.000000e+00   \n",
       "7         2.963351e-46      ...         0.000000e+00  0.000000e+00   \n",
       "8         2.877925e-46      ...         0.000000e+00  0.000000e+00   \n",
       "9         7.230608e-67      ...         0.000000e+00  0.000000e+00   \n",
       "10        7.038852e-67      ...         0.000000e+00  0.000000e+00   \n",
       "11        6.852165e-67      ...         0.000000e+00  0.000000e+00   \n",
       "12        6.591697e-67      ...         0.000000e+00  0.000000e+00   \n",
       "13        6.343313e-67      ...         0.000000e+00  0.000000e+00   \n",
       "14        2.274835e-71      ...         0.000000e+00  0.000000e+00   \n",
       "15        2.212515e-71      ...         0.000000e+00  0.000000e+00   \n",
       "16        2.151120e-71      ...         0.000000e+00  0.000000e+00   \n",
       "17        2.066669e-71      ...         0.000000e+00  0.000000e+00   \n",
       "18        1.984806e-71      ...         0.000000e+00  0.000000e+00   \n",
       "19        2.396667e-86      ...         0.000000e+00  0.000000e+00   \n",
       "20        2.324485e-86      ...         0.000000e+00  0.000000e+00   \n",
       "21        2.254471e-86      ...         0.000000e+00  0.000000e+00   \n",
       "22        2.158084e-86      ...         0.000000e+00  0.000000e+00   \n",
       "23        2.065808e-86      ...         0.000000e+00  0.000000e+00   \n",
       "24        2.272154e-91      ...         0.000000e+00  0.000000e+00   \n",
       "25        2.201774e-91      ...         0.000000e+00  0.000000e+00   \n",
       "26        2.133569e-91      ...         0.000000e+00  0.000000e+00   \n",
       "27        2.038939e-91      ...         0.000000e+00  0.000000e+00   \n",
       "28        1.947701e-91      ...         0.000000e+00  0.000000e+00   \n",
       "29       3.859428e-120      ...         0.000000e+00  0.000000e+00   \n",
       "...                ...      ...                  ...           ...   \n",
       "1421675   0.000000e+00      ...         6.694557e-03  7.151203e-12   \n",
       "1421676   0.000000e+00      ...         2.244920e-02  1.230217e-10   \n",
       "1421677   0.000000e+00      ...         1.287207e-01  1.422015e-01   \n",
       "1421678   0.000000e+00      ...         8.296759e-02  2.092584e-01   \n",
       "1421679   0.000000e+00      ...         5.638801e-03  7.366195e-01   \n",
       "1421680   0.000000e+00      ...         2.859733e-03  8.464476e-01   \n",
       "1421681   0.000000e+00      ...         1.373775e-03  9.340059e-01   \n",
       "1421682   0.000000e+00      ...         6.768684e-04  9.840154e-01   \n",
       "1421683   0.000000e+00      ...         2.360829e-05  8.271637e-01   \n",
       "1421684   0.000000e+00      ...         3.463236e-06  5.976517e-01   \n",
       "1421685   0.000000e+00      ...         1.259932e-06  4.795378e-01   \n",
       "1421686   0.000000e+00      ...         1.239733e-08  1.263139e-01   \n",
       "1421687   0.000000e+00      ...         1.637180e-11  9.615100e-03   \n",
       "1421688   0.000000e+00      ...         1.520201e-17  9.901897e-06   \n",
       "1421689   0.000000e+00      ...         2.450951e-18  3.624423e-06   \n",
       "1421690   0.000000e+00      ...         3.131166e-19  1.141884e-06   \n",
       "1421691   0.000000e+00      ...         9.734059e-21  1.550969e-07   \n",
       "1421692   0.000000e+00      ...         1.698578e-22  1.411143e-08   \n",
       "1421693   0.000000e+00      ...         5.630444e-28  5.449189e-12   \n",
       "1421694   0.000000e+00      ...         4.654142e-29  1.087597e-12   \n",
       "1421695   0.000000e+00      ...         3.941971e-34  4.649823e-16   \n",
       "1421696   0.000000e+00      ...         3.437239e-35  8.850348e-17   \n",
       "1421697   0.000000e+00      ...         1.665158e-38  4.576264e-19   \n",
       "1421698   0.000000e+00      ...         1.179644e-39  7.192046e-20   \n",
       "1421699   0.000000e+00      ...         5.162477e-42  1.557076e-21   \n",
       "1421700   0.000000e+00      ...         7.887733e-51  6.458852e-28   \n",
       "1421701   0.000000e+00      ...         2.478473e-56  5.232453e-32   \n",
       "1421702   0.000000e+00      ...         1.232539e-72  1.694272e-44   \n",
       "1421703   0.000000e+00      ...         2.973584e-98  6.520427e-65   \n",
       "1421704   0.000000e+00      ...        4.812185e-102  5.395570e-68   \n",
       "\n",
       "                sw_47         sw_48         sw_49          sw_50  \\\n",
       "0        0.000000e+00  0.000000e+00  0.000000e+00   0.000000e+00   \n",
       "1        0.000000e+00  0.000000e+00  0.000000e+00   0.000000e+00   \n",
       "2        0.000000e+00  0.000000e+00  0.000000e+00   0.000000e+00   \n",
       "3        0.000000e+00  0.000000e+00  0.000000e+00   0.000000e+00   \n",
       "4        0.000000e+00  0.000000e+00  0.000000e+00   0.000000e+00   \n",
       "5        0.000000e+00  0.000000e+00  0.000000e+00   0.000000e+00   \n",
       "6        0.000000e+00  0.000000e+00  0.000000e+00   0.000000e+00   \n",
       "7        0.000000e+00  0.000000e+00  0.000000e+00   0.000000e+00   \n",
       "8        0.000000e+00  0.000000e+00  0.000000e+00   0.000000e+00   \n",
       "9        0.000000e+00  0.000000e+00  0.000000e+00   0.000000e+00   \n",
       "10       0.000000e+00  0.000000e+00  0.000000e+00   0.000000e+00   \n",
       "11       0.000000e+00  0.000000e+00  0.000000e+00   0.000000e+00   \n",
       "12       0.000000e+00  0.000000e+00  0.000000e+00   0.000000e+00   \n",
       "13       0.000000e+00  0.000000e+00  0.000000e+00   0.000000e+00   \n",
       "14       0.000000e+00  0.000000e+00  0.000000e+00   0.000000e+00   \n",
       "15       0.000000e+00  0.000000e+00  0.000000e+00   0.000000e+00   \n",
       "16       0.000000e+00  0.000000e+00  0.000000e+00   0.000000e+00   \n",
       "17       0.000000e+00  0.000000e+00  0.000000e+00   0.000000e+00   \n",
       "18       0.000000e+00  0.000000e+00  0.000000e+00   0.000000e+00   \n",
       "19       0.000000e+00  0.000000e+00  0.000000e+00   0.000000e+00   \n",
       "20       0.000000e+00  0.000000e+00  0.000000e+00   0.000000e+00   \n",
       "21       0.000000e+00  0.000000e+00  0.000000e+00   0.000000e+00   \n",
       "22       0.000000e+00  0.000000e+00  0.000000e+00   0.000000e+00   \n",
       "23       0.000000e+00  0.000000e+00  0.000000e+00   0.000000e+00   \n",
       "24       0.000000e+00  0.000000e+00  0.000000e+00   0.000000e+00   \n",
       "25       0.000000e+00  0.000000e+00  0.000000e+00   0.000000e+00   \n",
       "26       0.000000e+00  0.000000e+00  0.000000e+00   0.000000e+00   \n",
       "27       0.000000e+00  0.000000e+00  0.000000e+00   0.000000e+00   \n",
       "28       0.000000e+00  0.000000e+00  0.000000e+00   0.000000e+00   \n",
       "29       0.000000e+00  0.000000e+00  0.000000e+00   0.000000e+00   \n",
       "...               ...           ...           ...            ...   \n",
       "1421675  8.596560e-28  1.162943e-50  1.770438e-80  3.033131e-117   \n",
       "1421676  7.586665e-26  5.265121e-48  4.112009e-77  3.614000e-113   \n",
       "1421677  1.767862e-08  2.473322e-22  3.894047e-43   6.899380e-71   \n",
       "1421678  5.939444e-08  1.897129e-21  6.819244e-42   2.758442e-69   \n",
       "1421679  1.082899e-05  1.791517e-17  3.335356e-36   6.987983e-62   \n",
       "1421680  2.819441e-05  1.056852e-16  4.458139e-35   2.116320e-60   \n",
       "1421681  7.146144e-05  6.152934e-16  5.961849e-34   6.500818e-59   \n",
       "1421682  1.609859e-04  2.963890e-15  6.140796e-33   1.431777e-57   \n",
       "1421683  3.261420e-03  1.447139e-12  7.226068e-29   4.060525e-52   \n",
       "1421684  1.160653e-02  2.536560e-11  6.238441e-27   1.726614e-49   \n",
       "1421685  2.053935e-02  9.900085e-11  5.370064e-26   3.277995e-48   \n",
       "1421686  1.448314e-01  1.868799e-08  2.713630e-22   4.434320e-43   \n",
       "1421687  6.354763e-01  4.726429e-06  3.955991e-18   3.726196e-37   \n",
       "1421688  7.258121e-01  5.987124e-03  5.557770e-12   5.805922e-28   \n",
       "1421689  6.031584e-01  1.129567e-02  2.380571e-11   5.645970e-27   \n",
       "1421690  4.686255e-01  2.164304e-02  1.124861e-10   6.579120e-26   \n",
       "1421691  2.780996e-01  5.611590e-02  1.274265e-09   3.256283e-24   \n",
       "1421692  1.319304e-01  1.388056e-01  1.643454e-08   2.189759e-22   \n",
       "1421693  5.934845e-03  7.274032e-01  1.003297e-05   1.557298e-17   \n",
       "1421694  2.860125e-03  8.464281e-01  2.818925e-05   1.056489e-16   \n",
       "1421695  6.172310e-05  9.220348e-01  1.550013e-03   2.932320e-13   \n",
       "1421696  2.564480e-05  8.362315e-01  3.068612e-03   1.267202e-12   \n",
       "1421697  1.415322e-06  4.925921e-01  1.929337e-02   8.503877e-11   \n",
       "1421698  4.934491e-07  3.809961e-01  3.310450e-02   3.236993e-10   \n",
       "1421699  5.285057e-08  2.018728e-01  8.677494e-02   4.197581e-09   \n",
       "1421700  5.951779e-12  6.172008e-03  7.202687e-01   9.459122e-06   \n",
       "1421701  1.243125e-14  3.323630e-04  9.999973e-01   3.385893e-04   \n",
       "1421702  2.620922e-23  4.562611e-09  8.938425e-02   1.970593e-01   \n",
       "1421703  1.609015e-38  4.468200e-19  1.396347e-06   4.910687e-01   \n",
       "1421704  6.808015e-41  9.667007e-21  1.544727e-07   2.777794e-01   \n",
       "\n",
       "                 sw_51          sw_52          sw_53          sw_54  \n",
       "0         0.000000e+00   0.000000e+00   0.000000e+00   0.000000e+00  \n",
       "1         0.000000e+00   0.000000e+00   0.000000e+00   0.000000e+00  \n",
       "2         0.000000e+00   0.000000e+00   0.000000e+00   0.000000e+00  \n",
       "3         0.000000e+00   0.000000e+00   0.000000e+00   0.000000e+00  \n",
       "4         0.000000e+00   0.000000e+00   0.000000e+00   0.000000e+00  \n",
       "5         0.000000e+00   0.000000e+00   0.000000e+00   0.000000e+00  \n",
       "6         0.000000e+00   0.000000e+00   0.000000e+00   0.000000e+00  \n",
       "7         0.000000e+00   0.000000e+00   0.000000e+00   0.000000e+00  \n",
       "8         0.000000e+00   0.000000e+00   0.000000e+00   0.000000e+00  \n",
       "9         0.000000e+00   0.000000e+00   0.000000e+00   0.000000e+00  \n",
       "10        0.000000e+00   0.000000e+00   0.000000e+00   0.000000e+00  \n",
       "11        0.000000e+00   0.000000e+00   0.000000e+00   0.000000e+00  \n",
       "12        0.000000e+00   0.000000e+00   0.000000e+00   0.000000e+00  \n",
       "13        0.000000e+00   0.000000e+00   0.000000e+00   0.000000e+00  \n",
       "14        0.000000e+00   0.000000e+00   0.000000e+00   0.000000e+00  \n",
       "15        0.000000e+00   0.000000e+00   0.000000e+00   0.000000e+00  \n",
       "16        0.000000e+00   0.000000e+00   0.000000e+00   0.000000e+00  \n",
       "17        0.000000e+00   0.000000e+00   0.000000e+00   0.000000e+00  \n",
       "18        0.000000e+00   0.000000e+00   0.000000e+00   0.000000e+00  \n",
       "19        0.000000e+00   0.000000e+00   0.000000e+00   0.000000e+00  \n",
       "20        0.000000e+00   0.000000e+00   0.000000e+00   0.000000e+00  \n",
       "21        0.000000e+00   0.000000e+00   0.000000e+00   0.000000e+00  \n",
       "22        0.000000e+00   0.000000e+00   0.000000e+00   0.000000e+00  \n",
       "23        0.000000e+00   0.000000e+00   0.000000e+00   0.000000e+00  \n",
       "24        0.000000e+00   0.000000e+00   0.000000e+00   0.000000e+00  \n",
       "25        0.000000e+00   0.000000e+00   0.000000e+00   0.000000e+00  \n",
       "26        0.000000e+00   0.000000e+00   0.000000e+00   0.000000e+00  \n",
       "27        0.000000e+00   0.000000e+00   0.000000e+00   0.000000e+00  \n",
       "28        0.000000e+00   0.000000e+00   0.000000e+00   0.000000e+00  \n",
       "29        0.000000e+00   0.000000e+00   0.000000e+00   0.000000e+00  \n",
       "...                ...            ...            ...            ...  \n",
       "1421675  5.847764e-161  1.268752e-211  3.097792e-269   0.000000e+00  \n",
       "1421676  3.574460e-156  3.978516e-206  4.983334e-263   0.000000e+00  \n",
       "1421677  1.375648e-105  3.086688e-147  7.794109e-196  2.214770e-251  \n",
       "1421678  1.255683e-103  6.432564e-145  3.708315e-193  2.405789e-248  \n",
       "1421679   1.647592e-94  4.371554e-134  1.305300e-180  4.386045e-234  \n",
       "1421680   1.130570e-92  6.796755e-132  4.598268e-178  3.500863e-231  \n",
       "1421681   7.977068e-91  1.101557e-129  1.711823e-175  2.993636e-228  \n",
       "1421682   3.756770e-89  1.109282e-127  3.686020e-173  1.378357e-225  \n",
       "1421683   2.567737e-82  1.827289e-119  1.463363e-163  1.318820e-214  \n",
       "1421684   5.377777e-79  1.884945e-115  7.435030e-159  3.300313e-209  \n",
       "1421685   2.251777e-77  1.740727e-113  1.514343e-156  1.482540e-206  \n",
       "1421686   8.154393e-71  1.687503e-105  3.929939e-147  1.029948e-195  \n",
       "1421687   3.949703e-63   4.711416e-96  6.324507e-136  9.554111e-183  \n",
       "1421688   6.825432e-51   9.029783e-81  1.344351e-117  2.252354e-161  \n",
       "1421689   1.506899e-49   4.526038e-79  1.529820e-115  5.819034e-159  \n",
       "1421690   4.330371e-48   3.207529e-77  2.673649e-113  2.507994e-156  \n",
       "1421691   9.364241e-46   3.030480e-74  1.103668e-109  4.523283e-152  \n",
       "1421692   3.283396e-43   5.540368e-71  1.052064e-105  2.248196e-147  \n",
       "1421693   2.720210e-36   5.347138e-62   1.182847e-94  2.944586e-134  \n",
       "1421694   4.455896e-35   2.114917e-60   1.129639e-92  6.790077e-132  \n",
       "1421695   6.242748e-30   1.495645e-53   4.032456e-84  1.223486e-121  \n",
       "1421696   5.888951e-29   3.079770e-52   1.812537e-82  1.200450e-119  \n",
       "1421697   4.218074e-26   2.354505e-48   1.479018e-77  1.045528e-113  \n",
       "1421698   3.561925e-25   4.410788e-47   6.146612e-76  9.639260e-112  \n",
       "1421699   2.285031e-23   1.399824e-44   9.650352e-73  7.486884e-108  \n",
       "1421700   1.397962e-17   2.325029e-36   4.351605e-62   9.165559e-95  \n",
       "1421701   1.290137e-14   5.532060e-32   2.669477e-56   1.449618e-87  \n",
       "1421702   4.889011e-08   1.365002e-21   4.288783e-42   1.516433e-69  \n",
       "1421703   1.943478e-02   8.655758e-11   4.338294e-26   2.446928e-48  \n",
       "1421704   5.621295e-02   1.280151e-09   3.280757e-24   9.461833e-46  \n",
       "\n",
       "[1421705 rows x 59 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ts_mod"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "_uuid": "59ede54c0cbf62ebf6b3ea360c465fab5f2d28ed"
   },
   "outputs": [],
   "source": [
    "def group_transform(chunk):\n",
    "    sample_weights = chunk[[f'sw_{i}' for i in range(len(sample_points))]]\n",
    "    sample_weights /= np.sum(sample_weights, axis=0)\n",
    "    weighted_flux = np.expand_dims(chunk['flux'].values, 1) * sample_weights.fillna(0)\n",
    "    return np.sum(weighted_flux, axis=0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "_uuid": "62c85ebb3260823c9a68b31e0e876734d10c6587"
   },
   "outputs": [],
   "source": [
    "# only using a small sample as this step is slower than the other steps\n",
    "ts_samp = ts_mod[ts_mod['object_id'].isin([615, 713])].groupby(\n",
    "    ['object_id', 'passband']).apply(group_transform)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "_uuid": "3a5ac08dd672c8f5bb284b552b27416afc3382ad"
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Wall time: 3min\n"
     ]
    }
   ],
   "source": [
    "%%time\n",
    "ts_samp_all = ts_mod.groupby(['object_id', 'passband']).apply(group_transform)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {
    "_uuid": "a8377c24188c2114dee5b38e01ce201c4f758499"
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Int64Index([      615,       713,       730,       745,      1124,      1227,\n",
       "                 1598,      1632,      1920,      1926,\n",
       "            ...\n",
       "            130684460, 130695262, 130698059, 130716752, 130727624, 130739978,\n",
       "            130755807, 130762946, 130772921, 130779836],\n",
       "           dtype='int64', name='object_id', length=7848)"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ts_samp_all.index.levels[0]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "_uuid": "a1994a7c8631a4dede992012e7e2074439761256"
   },
   "source": [
    "We can see above that we have managed to sample from the time series, using the time difference from the sample point to determine moving average weights.\n",
    "\n",
    "There are still many issues with this method. For example, it still does not solve the problem of long gaps between available data, and the use of 0 as a filler value for NA is questionable (however we cannot retain NA, as that will make calculating moving average difficult). Overall, this is still a better approach than simple binning, and still relatively cheap to compute."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "_uuid": "8885d8648606d0b5f761e5aecde38f8dd830573e"
   },
   "source": [
    "#### Use time / time difference as a feature"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "_uuid": "00c0025a1f59c77b1841a3b49489205e44c94f6d"
   },
   "source": [
    "This idea is quite simple. Why not just concatenate the flux values with the timestamp at which they are observed, or the time elapsed since last observation, and pass the whole sequence to a learning algorithm? Indeed, some algorithms have been shown to be able to cope with that. This is not so different from \"given (x, y), fit the curve and extract features from the curve\". An LSTM or even a regular MLP might be able to deal with that. There is an [example](https://arxiv.org/pdf/1711.10609.pdf) of this being applied to a very similar problem.\n",
    "\n",
    "Also, some time series feature extractors accept (t, x) pairs instead of (x) sequences.\n",
    "\n",
    "(WIP)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "_uuid": "963bda5a526e6cb7fd95d9ae112212b5df8fd411"
   },
   "source": [
    "#### Convert time series to phase series"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "_uuid": "e578121e488648d094c49d5b6dd3665858744223"
   },
   "source": [
    "If we know that some of the time series will be periodic, we can attempt to find the optimal period and convert the time series to phase domain, so that we can avoid the issues of observation gap, alleviate the problem of sparse observations and make better use of the periodic property. We may also assume that for most objects that exhibit period behaviour, the period is the same for all colour bands and the phases should all be in sync, because they are likely driven by the same physical event.\n",
    "To discover the period of the time series, we first normalise all series then extract features about the most prominent frequencies / periods."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "_uuid": "a79c416e18b9cf27707b1189c5ef9bc3c4a72793"
   },
   "outputs": [],
   "source": [
    "groups = train_series.groupby(['object_id', 'passband'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "_uuid": "519d8d02b498769b72c742138edcdf02fcce0a19"
   },
   "outputs": [],
   "source": [
    "def normalise(ts):\n",
    "    return (ts - ts.mean()) / ts.std()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "_uuid": "59c625e9457e442d8d1b384944cff573fecef4a6"
   },
   "outputs": [],
   "source": [
    "times = groups.apply(\n",
    "    lambda block: block['mjd'].values).reset_index().rename(columns={0: 'seq'})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "_uuid": "66a0d8a0dcb14d7010140e8eb6e11c624ca96b70"
   },
   "outputs": [],
   "source": [
    "flux = groups.apply(\n",
    "    lambda block: normalise(block['flux']).values\n",
    ").reset_index().rename(columns={0: 'seq'})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "_uuid": "cd32fe6d05f7f5c8ef4b87c1b99ce2c067e96126"
   },
   "outputs": [],
   "source": [
    "times_list = times.groupby('object_id').apply(lambda x: x['seq'].tolist()).tolist()\n",
    "flux_list = flux.groupby('object_id').apply(lambda x: x['seq'].tolist()).tolist()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "_uuid": "a79b1049a6f7d108fa3f7734122e45521c626657"
   },
   "outputs": [],
   "source": [
    "import cesium.featurize as featurize\n",
    "from scipy import signal\n",
    "import warnings"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "_uuid": "43ded3de908cef55df1fa8627e637d75dafb3e14"
   },
   "source": [
    "To save some kernel time, we will only extract features from a small subset of objects.\n",
    "\n",
    "([**FIXED - See below**]For some reason, the frequencies features of the cesium package are not working properly for me, so I have to revert to the method used by Michal Haltuf in his notebook [Feature extraction using period analysis](https://www.kaggle.com/rejpalcz/feature-extraction-using-period-analysis). It takes quite some time even for just 20 objects as you can see below:\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "_uuid": "9b60234c7b6ae2a37136bdd27565eb3b9d689575"
   },
   "outputs": [],
   "source": [
    "# def extract_freq(t, m, e):\n",
    "#     fs = np.linspace(2*np.pi/0.1, 2*np.pi/500, 10000)\n",
    "#     pgram = signal.lombscargle(t, m, fs, normalize=True)\n",
    "#     return fs[np.argmax(pgram)]\n",
    "\n",
    "# N = 20\n",
    "# warnings.simplefilter('ignore', RuntimeWarning)\n",
    "# feats = featurize.featurize_time_series(times=times_list[:N],\n",
    "#                                         values=flux_list[:N],\n",
    "#                                         features_to_use=['freq1'],\n",
    "#                                         custom_functions={'freq1': extract_freq},\n",
    "#                                         scheduler=None)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "_uuid": "1af560d13b3fafe77308c5507af9e1c2448ba7fe"
   },
   "source": [
    "**EDIT:** I found why the features from the cesium package is acting weird. The frequency features extracted by cesium are oscilation frequencies (cycles per unit time) rather than angular frequencies (rad per unit time), so they differ by $2\\pi$. We can now use cesium's 'freqN_freq' feature extractor to extract features slightly faster:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "_uuid": "bf6d8999ffcd12704995fa0a24d8727840376b2b"
   },
   "outputs": [],
   "source": [
    "warnings.simplefilter('ignore', RuntimeWarning)\n",
    "N = 100\n",
    "cfeats = featurize.featurize_time_series(times=times_list[:N],\n",
    "                                        values=flux_list[:N],\n",
    "                                        features_to_use=['freq1_freq',\n",
    "                                                        'freq1_signif',\n",
    "                                                        'freq1_amplitude1'],\n",
    "                                        scheduler=None)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "_uuid": "463bc1851e3d81253d1c0afbac7f36caa34fbaba"
   },
   "outputs": [],
   "source": [
    "cfeats.stack('channel').iloc[:24]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "_uuid": "7a536ac3cbb5f2ecd66a029cfeacd2bac69b3c7d"
   },
   "source": [
    "We can see that for some objects, there appears to be a common frequency / period for all its observed passbands, whereas for others the calculated frequencies are all different and seemingly random. We may assume that the objects with completely mismatching frequencies or very low frequencies (very long periods) actually do not exhibit periodic behaviour. Let us look at a few examples where the periods do match up between most bands:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "_uuid": "b224e1f1ee83b215233c5d4870c66fb8f63852c5"
   },
   "outputs": [],
   "source": [
    "def plot_phase(n, fr):\n",
    "    selected_times = times_list[n]\n",
    "    selected_flux = flux_list[n]\n",
    "    colors = ['red', 'orange', 'yellow', 'green', 'blue', 'purple']\n",
    "    f, ax = plt.subplots(figsize=(12, 6))\n",
    "    for band in range(6):\n",
    "        ax.scatter(x=(selected_times[band] * fr) % 1, \n",
    "                   y=selected_flux[band], \n",
    "                   c=colors[band])\n",
    "    ax.set_xlabel('phase')\n",
    "    ax.set_ylabel('relative flux')\n",
    "    ax.set_title(\n",
    "        f'object {train_metadata[\"object_id\"][n]}, class {train_metadata[\"target\"][n]}')\n",
    "    plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "_uuid": "8faff52441f8d6e577fedcc07f22c77874b14ee9",
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "plot_phase(0, 3.081631)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "_uuid": "34533ba26c7f6c25d5745d3c74413ee221ebff22"
   },
   "outputs": [],
   "source": [
    "plot_phase(3, 0.001921)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "_uuid": "fa31d2508163bdf4ec562b278e114befed8bc0d7"
   },
   "outputs": [],
   "source": [
    "plot_phase(6, 1.005547)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "_uuid": "e04e3d6e5365b1a30d3aa9f6c3f7728df45ef066"
   },
   "source": [
    "For periodic objects, observations made in the same phase should have similar relative flux values. As we see, Object 615 is clearly periodically changing its magnitude,  whereas object 745 and 1598's 'periodicity' are more like staying stationary most of the time with sudden bursts.\n",
    "\n",
    "We kind of found a pattern here. If all colour bands agree in frequency, an object is likely to have periodic behaviours. When the colour bands have wildly different frequencies, the object is likely aperiodic. When most bands have very small frequencies (longer period than the observation window) and a few bands have larger detected frequencies, it is likely a burst event.\n",
    "\n",
    "It appears that calculated periods alone cannot tell us the full picture, as there are plenty of objects in the dataset without clear periodic patterns. However, determining whether an object has a periodic pattern can be very important in determining the object class, and for objects that are actually periodic, the time series in phase space can tell us a lot more than in time space. Therefore, for a large portion of the dataset, conversion to phase space is actually a very powerful preprocessing step to use.\n",
    "\n",
    "We will plot below a few more examples of where phase conversion works well:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "_uuid": "24f62f7b33ec23b74856a01f898c431d590ddb67"
   },
   "outputs": [],
   "source": [
    "plot_phase(46, 1.781711)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "_uuid": "c0928a08a845fbde0044a2d37941d7ce91ff1ffa"
   },
   "outputs": [],
   "source": [
    "plot_phase(62, 4.771011)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "_uuid": "5701d06e34e319fd4df16eea33688262345173df"
   },
   "outputs": [],
   "source": [
    "plot_phase(69, 1.597659)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "_uuid": "d049d51c7ca33a6344b177a0238badf6518ee4b9"
   },
   "outputs": [],
   "source": [
    "plot_phase(91, 2.668811)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "_uuid": "1eeb02000a9d895f46ee5b185f8c6c2d99d867dc"
   },
   "source": [
    "It appears that we are onto something. The classes 16 and 92 appear to be quite periodic where class 90 is what appears to be a group of burst events. So by just calculating a few frequency features and comparing these features between bands, we can already roughly tell them apart. We might still have trouble distinguishing between class 16 and 92, but with frequency divided out through phase-space conversion, we essentially have higher density data for these two classes to work with, and building a model on top of that should be easier."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "_uuid": "95a3b31f2945ff672b1093effb899d568ff2cd52"
   },
   "source": [
    "One more thing... We have to figure out if the same procedure can work well on non-DDF objects."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "_uuid": "9b69e1a9eddce7ae7d7b13d995b6dea61336a3d1"
   },
   "outputs": [],
   "source": [
    "nonddf_pos = train_metadata[train_metadata['ddf'] == 0].index\n",
    "nonddf_times_list = [v for i, v in enumerate(times_list) if i in set(nonddf_pos)]\n",
    "nonddf_flux_list = [v for i, v in enumerate(flux_list) if i in set(nonddf_pos)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "_uuid": "5233e394101f0b816c1dd1cfbb63d9d6414992c6"
   },
   "outputs": [],
   "source": [
    "warnings.simplefilter('ignore', RuntimeWarning)\n",
    "N = 50\n",
    "cfeats = featurize.featurize_time_series(times=nonddf_times_list[:N],\n",
    "                                        values=nonddf_flux_list[:N],\n",
    "                                        features_to_use=['freq1_freq',\n",
    "                                                        'freq1_signif',\n",
    "                                                        'freq1_amplitude1'],\n",
    "                                        scheduler=None)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "_uuid": "1b4a26d3d9dabcf0362c87a3f264f132032a583b"
   },
   "outputs": [],
   "source": [
    "cfeats.stack('channel').iloc[:24]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "_uuid": "5f7f81ecf14cc2435ce366087c30ba9d40e3271e"
   },
   "outputs": [],
   "source": [
    "plot_phase(nonddf_pos[15], 4.440506)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "_uuid": "dcaadbf6821a08d02007a6605df71cb6c70707d3"
   },
   "outputs": [],
   "source": [
    "plot_phase(nonddf_pos[20], 0.831637)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "_uuid": "865706fe5ce8d2d99314dc062e9e51144d2356e8"
   },
   "outputs": [],
   "source": [
    "plot_phase(nonddf_pos[39], 0.817696)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "_uuid": "5a9ac3c6f50e4a854ea79270e68ecd47386e7e74"
   },
   "outputs": [],
   "source": [
    "plot_phase(nonddf_pos[46], 2.514430)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "_uuid": "6462ca4672dd99ce81125d7bb8558eb67a2b2f7c"
   },
   "source": [
    "Generally, we found that we are still able to use frequency analysis to find the most apparent periodic classes like 16 and 92, but we have to be much more lenient on how different bands agree with each other (sometimes only 3-4 bands will strongly agree in terms of frequency), and we might have to pay much more attention to the significance level of these frequencies. This could be evidence to support the case that DDF and non-DDF objects should be dealt with using different models, or at least treated differently in model."
   ]
  }
 ],
 "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.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 1
}