sec3.2-transformation_outage.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "initial_id",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-06-07T07:21:46.384534Z",
     "start_time": "2024-06-07T07:21:46.376211Z"
    },
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "from util.util_data import *"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "b2f666a5c5a5e8b3",
   "metadata": {
    "collapsed": false
   },
   "source": [
    "## Metrics\n",
    "\n",
    "- Date\n",
    "- Outage_Color\n",
    "- Service\n",
    "- partial_outage_flag\n",
    "- partial_outage_minutes\n",
    "- major_outage_flag\n",
    "- major_outage_minutes\n",
    "- total_outage_minutes\n",
    "- scaled_total_outage_minutes\n",
    "- outage_impact_level \n",
    "      (int: The outage impact level, which can be one of the following:)\n",
    "    - 0: Fully operational, no outages.\n",
    "    - 1: Increasingly degraded performance (1 <= total_minutes <= 20).\n",
    "    - 2: Increasingly partial outage (21 <= total_minutes <= 40).\n",
    "    - 3: Increasingly major outage (41 <= total_minutes <= 60).\n",
    "    - 4: Fully major outage (total_minutes > 60).\n",
    "- Incident_Title\n",
    "- incident_id\n",
    "- incident_count"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "230232072c498785",
   "metadata": {
    "collapsed": false
   },
   "source": [
    "## clean data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 91,
   "id": "a37d3d1cde2ac73a",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-06-07T07:21:46.388710Z",
     "start_time": "2024-06-07T07:21:46.386203Z"
    },
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "def parse_outages(outages_list, outage_types=None):\n",
    "    if outage_types is None:\n",
    "        outage_types = ['Partial outage', 'Major outage']\n",
    "    outages_dict ={}\n",
    "    \n",
    "    for outage_type in outage_types:\n",
    "        outage_type = outage_type.lower().replace(' ', '_')\n",
    "        outages_dict[outage_type + '_flag'] = int(0)\n",
    "        outages_dict[outage_type + '_minutes'] = int(0)\n",
    "        \n",
    "    for outage in outages_list:\n",
    "        outage_type = outage['Outage_Type'].lower().replace(' ', '_')\n",
    "        outages_dict[outage_type + '_flag'] = int(1)\n",
    "        outages_dict[outage_type + '_minutes'] = outage['Downtime (min)']\n",
    "        \n",
    "    return outages_dict\n",
    "\n",
    "def get_outage_impact_level(total_minutes):\n",
    "    \"\"\"This function calculates the outage impact level based on the scaled total outage minutes.\"\"\"\n",
    "    if total_minutes == 0:\n",
    "        return 0\n",
    "    else:\n",
    "        return min((total_minutes - 1) // 20 + 1, 4)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 92,
   "id": "79a315b33866fd2a",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-06-07T07:21:46.426151Z",
     "start_time": "2024-06-07T07:21:46.391907Z"
    },
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "loading: data/raw/uptime/2024-08-31/console.anthropic.com/uptime_history.csv\n",
      "loading: data/raw/uptime/2024-08-31/labs/uptime_history.csv\n",
      "loading: data/raw/uptime/2024-08-31/character.ai/uptime_history.csv\n",
      "loading: data/raw/uptime/2024-08-31/playground/uptime_history.csv\n",
      "loading: data/raw/uptime/2024-08-31/api/uptime_history.csv\n",
      "loading: data/raw/uptime/2024-08-31/chatgpt/uptime_history.csv\n",
      "loading: data/raw/uptime/2024-08-31/api.anthropic.com/uptime_history.csv\n",
      "loading: data/raw/uptime/2024-08-31/claude.ai/uptime_history.csv\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Date</th>\n",
       "      <th>Outages</th>\n",
       "      <th>Outage_Color</th>\n",
       "      <th>Incidents</th>\n",
       "      <th>Service</th>\n",
       "      <th>incident_count</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2024-06-01</td>\n",
       "      <td>[]</td>\n",
       "      <td>#2fcc66</td>\n",
       "      <td>[]</td>\n",
       "      <td>console.anthropic.com</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2024-06-02</td>\n",
       "      <td>[]</td>\n",
       "      <td>#2fcc66</td>\n",
       "      <td>[]</td>\n",
       "      <td>console.anthropic.com</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2024-06-03</td>\n",
       "      <td>[{'Outage_Type': 'Partial outage', 'Downtime (...</td>\n",
       "      <td>#e7c414</td>\n",
       "      <td>[{'Incident_Title': 'Haiku Partial Outage', 'I...</td>\n",
       "      <td>console.anthropic.com</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2024-06-04</td>\n",
       "      <td>[{'Outage_Type': 'Partial outage', 'Downtime (...</td>\n",
       "      <td>#f0c40f</td>\n",
       "      <td>[{'Incident_Title': 'Partial Outage on claude....</td>\n",
       "      <td>console.anthropic.com</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2024-06-05</td>\n",
       "      <td>[]</td>\n",
       "      <td>#2fcc66</td>\n",
       "      <td>[]</td>\n",
       "      <td>console.anthropic.com</td>\n",
       "      <td>0</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5238</th>\n",
       "      <td>2023-08-27</td>\n",
       "      <td>[]</td>\n",
       "      <td>#2fcc66</td>\n",
       "      <td>[]</td>\n",
       "      <td>claude.ai</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5239</th>\n",
       "      <td>2023-08-28</td>\n",
       "      <td>[]</td>\n",
       "      <td>#2fcc66</td>\n",
       "      <td>[]</td>\n",
       "      <td>claude.ai</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5240</th>\n",
       "      <td>2023-08-29</td>\n",
       "      <td>[]</td>\n",
       "      <td>#2fcc66</td>\n",
       "      <td>[]</td>\n",
       "      <td>claude.ai</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5241</th>\n",
       "      <td>2023-08-30</td>\n",
       "      <td>[]</td>\n",
       "      <td>#2fcc66</td>\n",
       "      <td>[]</td>\n",
       "      <td>claude.ai</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5242</th>\n",
       "      <td>2023-08-31</td>\n",
       "      <td>[]</td>\n",
       "      <td>#2fcc66</td>\n",
       "      <td>[]</td>\n",
       "      <td>claude.ai</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5243 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           Date                                            Outages  \\\n",
       "0    2024-06-01                                                 []   \n",
       "1    2024-06-02                                                 []   \n",
       "2    2024-06-03  [{'Outage_Type': 'Partial outage', 'Downtime (...   \n",
       "3    2024-06-04  [{'Outage_Type': 'Partial outage', 'Downtime (...   \n",
       "4    2024-06-05                                                 []   \n",
       "...         ...                                                ...   \n",
       "5238 2023-08-27                                                 []   \n",
       "5239 2023-08-28                                                 []   \n",
       "5240 2023-08-29                                                 []   \n",
       "5241 2023-08-30                                                 []   \n",
       "5242 2023-08-31                                                 []   \n",
       "\n",
       "     Outage_Color                                          Incidents  \\\n",
       "0         #2fcc66                                                 []   \n",
       "1         #2fcc66                                                 []   \n",
       "2         #e7c414  [{'Incident_Title': 'Haiku Partial Outage', 'I...   \n",
       "3         #f0c40f  [{'Incident_Title': 'Partial Outage on claude....   \n",
       "4         #2fcc66                                                 []   \n",
       "...           ...                                                ...   \n",
       "5238      #2fcc66                                                 []   \n",
       "5239      #2fcc66                                                 []   \n",
       "5240      #2fcc66                                                 []   \n",
       "5241      #2fcc66                                                 []   \n",
       "5242      #2fcc66                                                 []   \n",
       "\n",
       "                    Service  incident_count  \n",
       "0     console.anthropic.com               0  \n",
       "1     console.anthropic.com               0  \n",
       "2     console.anthropic.com               2  \n",
       "3     console.anthropic.com               1  \n",
       "4     console.anthropic.com               0  \n",
       "...                     ...             ...  \n",
       "5238              claude.ai               0  \n",
       "5239              claude.ai               0  \n",
       "5240              claude.ai               0  \n",
       "5241              claude.ai               0  \n",
       "5242              claude.ai               0  \n",
       "\n",
       "[5243 rows x 6 columns]"
      ]
     },
     "execution_count": 92,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# load data\n",
    "\n",
    "DATA_DIR = 'data/raw/uptime/2024-08-31'\n",
    "DATA_LAYER = 'clean'\n",
    "DATA_TYPE = 'outage'\n",
    "\n",
    "df = read_data(DATA_DIR)\n",
    "\n",
    "df = df.drop_duplicates()\n",
    "df = df.reset_index(drop=True)\n",
    "df['Date'] = pd.to_datetime(df['Date'])\n",
    "df = load_json_column(df, 'Outages')\n",
    "df = load_json_column(df, 'Incidents')\n",
    "df['incident_count'] = df['Incidents'].apply(lambda x: len(x))\n",
    "\n",
    "df\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 93,
   "id": "6e101367eb81fcad",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-06-07T07:21:46.446968Z",
     "start_time": "2024-06-07T07:21:46.435543Z"
    },
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "writing data to: data/clean/outage/2024-08-31/outage_unexploded.csv\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Date</th>\n",
       "      <th>Outage_Color</th>\n",
       "      <th>Incidents</th>\n",
       "      <th>Service</th>\n",
       "      <th>incident_count</th>\n",
       "      <th>partial_outage_flag</th>\n",
       "      <th>partial_outage_minutes</th>\n",
       "      <th>major_outage_flag</th>\n",
       "      <th>major_outage_minutes</th>\n",
       "      <th>outage_flag</th>\n",
       "      <th>total_outage_minutes</th>\n",
       "      <th>scaled_total_outage_minutes</th>\n",
       "      <th>outage_impact_level</th>\n",
       "      <th>provider</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2024-06-01</td>\n",
       "      <td>#2fcc66</td>\n",
       "      <td>[]</td>\n",
       "      <td>console.anthropic.com</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>anthropic</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2024-06-02</td>\n",
       "      <td>#2fcc66</td>\n",
       "      <td>[]</td>\n",
       "      <td>console.anthropic.com</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>anthropic</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2024-06-03</td>\n",
       "      <td>#e7c414</td>\n",
       "      <td>[{'Incident_Title': 'Haiku Partial Outage', 'I...</td>\n",
       "      <td>console.anthropic.com</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>59</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>59</td>\n",
       "      <td>17.7</td>\n",
       "      <td>1</td>\n",
       "      <td>anthropic</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2024-06-04</td>\n",
       "      <td>#f0c40f</td>\n",
       "      <td>[{'Incident_Title': 'Partial Outage on claude....</td>\n",
       "      <td>console.anthropic.com</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>65</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>65</td>\n",
       "      <td>19.5</td>\n",
       "      <td>1</td>\n",
       "      <td>anthropic</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2024-06-05</td>\n",
       "      <td>#2fcc66</td>\n",
       "      <td>[]</td>\n",
       "      <td>console.anthropic.com</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>anthropic</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5238</th>\n",
       "      <td>2023-08-27</td>\n",
       "      <td>#2fcc66</td>\n",
       "      <td>[]</td>\n",
       "      <td>claude.ai</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>anthropic</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5239</th>\n",
       "      <td>2023-08-28</td>\n",
       "      <td>#2fcc66</td>\n",
       "      <td>[]</td>\n",
       "      <td>claude.ai</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>anthropic</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5240</th>\n",
       "      <td>2023-08-29</td>\n",
       "      <td>#2fcc66</td>\n",
       "      <td>[]</td>\n",
       "      <td>claude.ai</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>anthropic</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5241</th>\n",
       "      <td>2023-08-30</td>\n",
       "      <td>#2fcc66</td>\n",
       "      <td>[]</td>\n",
       "      <td>claude.ai</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>anthropic</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5242</th>\n",
       "      <td>2023-08-31</td>\n",
       "      <td>#2fcc66</td>\n",
       "      <td>[]</td>\n",
       "      <td>claude.ai</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>anthropic</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5243 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           Date Outage_Color  \\\n",
       "0    2024-06-01      #2fcc66   \n",
       "1    2024-06-02      #2fcc66   \n",
       "2    2024-06-03      #e7c414   \n",
       "3    2024-06-04      #f0c40f   \n",
       "4    2024-06-05      #2fcc66   \n",
       "...         ...          ...   \n",
       "5238 2023-08-27      #2fcc66   \n",
       "5239 2023-08-28      #2fcc66   \n",
       "5240 2023-08-29      #2fcc66   \n",
       "5241 2023-08-30      #2fcc66   \n",
       "5242 2023-08-31      #2fcc66   \n",
       "\n",
       "                                              Incidents  \\\n",
       "0                                                    []   \n",
       "1                                                    []   \n",
       "2     [{'Incident_Title': 'Haiku Partial Outage', 'I...   \n",
       "3     [{'Incident_Title': 'Partial Outage on claude....   \n",
       "4                                                    []   \n",
       "...                                                 ...   \n",
       "5238                                                 []   \n",
       "5239                                                 []   \n",
       "5240                                                 []   \n",
       "5241                                                 []   \n",
       "5242                                                 []   \n",
       "\n",
       "                    Service  incident_count  partial_outage_flag  \\\n",
       "0     console.anthropic.com               0                    0   \n",
       "1     console.anthropic.com               0                    0   \n",
       "2     console.anthropic.com               2                    1   \n",
       "3     console.anthropic.com               1                    1   \n",
       "4     console.anthropic.com               0                    0   \n",
       "...                     ...             ...                  ...   \n",
       "5238              claude.ai               0                    0   \n",
       "5239              claude.ai               0                    0   \n",
       "5240              claude.ai               0                    0   \n",
       "5241              claude.ai               0                    0   \n",
       "5242              claude.ai               0                    0   \n",
       "\n",
       "      partial_outage_minutes  major_outage_flag  major_outage_minutes  \\\n",
       "0                          0                  0                     0   \n",
       "1                          0                  0                     0   \n",
       "2                         59                  0                     0   \n",
       "3                         65                  0                     0   \n",
       "4                          0                  0                     0   \n",
       "...                      ...                ...                   ...   \n",
       "5238                       0                  0                     0   \n",
       "5239                       0                  0                     0   \n",
       "5240                       0                  0                     0   \n",
       "5241                       0                  0                     0   \n",
       "5242                       0                  0                     0   \n",
       "\n",
       "      outage_flag  total_outage_minutes  scaled_total_outage_minutes  \\\n",
       "0               0                     0                          0.0   \n",
       "1               0                     0                          0.0   \n",
       "2               1                    59                         17.7   \n",
       "3               1                    65                         19.5   \n",
       "4               0                     0                          0.0   \n",
       "...           ...                   ...                          ...   \n",
       "5238            0                     0                          0.0   \n",
       "5239            0                     0                          0.0   \n",
       "5240            0                     0                          0.0   \n",
       "5241            0                     0                          0.0   \n",
       "5242            0                     0                          0.0   \n",
       "\n",
       "      outage_impact_level   provider  \n",
       "0                       0  anthropic  \n",
       "1                       0  anthropic  \n",
       "2                       1  anthropic  \n",
       "3                       1  anthropic  \n",
       "4                       0  anthropic  \n",
       "...                   ...        ...  \n",
       "5238                    0  anthropic  \n",
       "5239                    0  anthropic  \n",
       "5240                    0  anthropic  \n",
       "5241                    0  anthropic  \n",
       "5242                    0  anthropic  \n",
       "\n",
       "[5243 rows x 14 columns]"
      ]
     },
     "execution_count": 93,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# unnest outages\n",
    "df['Outages'] = df['Outages'].apply(parse_outages)\n",
    "df = unnest_dict(df, 'Outages')\n",
    "df['outage_flag'] = df['major_outage_flag'] + df['partial_outage_flag']\n",
    "df['total_outage_minutes'] = df['major_outage_minutes'] + df['partial_outage_minutes']\n",
    "df['scaled_total_outage_minutes'] = df['major_outage_minutes'] + (df['partial_outage_minutes'] * 0.3)\n",
    "df['outage_impact_level'] = df['scaled_total_outage_minutes'].apply(get_outage_impact_level).astype(int)\n",
    "\n",
    "# add column provider\n",
    "openai_service = ['api', 'chatgpt', 'labs', 'playground']\n",
    "anthropic_service = ['claude.ai', 'api.anthropic.com', 'console.anthropic.com']\n",
    "characterai_service = ['character.ai']\n",
    "# Define a function to map services to providers\n",
    "def get_provider(service):\n",
    "    if service in openai_service:\n",
    "        return 'openai'\n",
    "    elif service in anthropic_service:\n",
    "        return 'anthropic'\n",
    "    elif service in characterai_service:\n",
    "        return 'characterai'\n",
    "    else:\n",
    "        return 'unknown'\n",
    "df['provider'] = df['Service'].apply(get_provider)\n",
    "\n",
    "# save\n",
    "write_partitioned_data(df, DATA_LAYER, DATA_TYPE, 'outage_unexploded.csv')\n",
    "\n",
    "df\n",
    "        "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 94,
   "id": "3a7e92a2",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-06-07T07:21:46.460450Z",
     "start_time": "2024-06-07T07:21:46.455837Z"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "26 78 7891 3340.3\n",
      "28 42 5185 2744.1\n",
      "13 14 2821 1747.9\n",
      "12 12 1636 1017.8999999999999\n",
      "2 28 3017 982.8\n",
      "0 25 1675 502.5\n",
      "1 26 2032 662.1\n",
      "17 15 3351 1877.5\n"
     ]
    }
   ],
   "source": [
    "services = [\"api\", \"chatgpt\", \"labs\", \"playground\", \"claude.ai\", \"api.anthropic.com\", \"console.anthropic.com\", \"character.ai\"]\n",
    "for service in services:\n",
    "    df_service = df[df['Service'] == service]\n",
    "    print(df_service['major_outage_flag'].sum(), df_service['partial_outage_flag'].sum(), df_service['total_outage_minutes'].sum(), df_service['scaled_total_outage_minutes'].sum())\n"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "7945753d90c2fbac",
   "metadata": {
    "collapsed": false
   },
   "source": [
    "## overview"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "7a5c45b53a8019d",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-06-07T07:21:46.471544Z",
     "start_time": "2024-06-07T07:21:46.469913Z"
    },
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Date</th>\n",
       "      <th>Outage_Color</th>\n",
       "      <th>Incidents</th>\n",
       "      <th>Service</th>\n",
       "      <th>incident_count</th>\n",
       "      <th>partial_outage_flag</th>\n",
       "      <th>partial_outage_minutes</th>\n",
       "      <th>major_outage_flag</th>\n",
       "      <th>major_outage_minutes</th>\n",
       "      <th>outage_flag</th>\n",
       "      <th>total_outage_minutes</th>\n",
       "      <th>scaled_total_outage_minutes</th>\n",
       "      <th>outage_impact_level</th>\n",
       "      <th>provider</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2024-06-01</td>\n",
       "      <td>#2fcc66</td>\n",
       "      <td>[]</td>\n",
       "      <td>console.anthropic.com</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>anthropic</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2024-06-02</td>\n",
       "      <td>#2fcc66</td>\n",
       "      <td>[]</td>\n",
       "      <td>console.anthropic.com</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>anthropic</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2024-06-03</td>\n",
       "      <td>#e7c414</td>\n",
       "      <td>[{'Incident_Title': 'Haiku Partial Outage', 'I...</td>\n",
       "      <td>console.anthropic.com</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>59</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>59</td>\n",
       "      <td>17.7</td>\n",
       "      <td>1</td>\n",
       "      <td>anthropic</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2024-06-04</td>\n",
       "      <td>#f0c40f</td>\n",
       "      <td>[{'Incident_Title': 'Partial Outage on claude....</td>\n",
       "      <td>console.anthropic.com</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>65</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>65</td>\n",
       "      <td>19.5</td>\n",
       "      <td>1</td>\n",
       "      <td>anthropic</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2024-06-05</td>\n",
       "      <td>#2fcc66</td>\n",
       "      <td>[]</td>\n",
       "      <td>console.anthropic.com</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>anthropic</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5238</th>\n",
       "      <td>2023-08-27</td>\n",
       "      <td>#2fcc66</td>\n",
       "      <td>[]</td>\n",
       "      <td>claude.ai</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>anthropic</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5239</th>\n",
       "      <td>2023-08-28</td>\n",
       "      <td>#2fcc66</td>\n",
       "      <td>[]</td>\n",
       "      <td>claude.ai</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>anthropic</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5240</th>\n",
       "      <td>2023-08-29</td>\n",
       "      <td>#2fcc66</td>\n",
       "      <td>[]</td>\n",
       "      <td>claude.ai</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>anthropic</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5241</th>\n",
       "      <td>2023-08-30</td>\n",
       "      <td>#2fcc66</td>\n",
       "      <td>[]</td>\n",
       "      <td>claude.ai</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>anthropic</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5242</th>\n",
       "      <td>2023-08-31</td>\n",
       "      <td>#2fcc66</td>\n",
       "      <td>[]</td>\n",
       "      <td>claude.ai</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>anthropic</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5243 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           Date Outage_Color  \\\n",
       "0    2024-06-01      #2fcc66   \n",
       "1    2024-06-02      #2fcc66   \n",
       "2    2024-06-03      #e7c414   \n",
       "3    2024-06-04      #f0c40f   \n",
       "4    2024-06-05      #2fcc66   \n",
       "...         ...          ...   \n",
       "5238 2023-08-27      #2fcc66   \n",
       "5239 2023-08-28      #2fcc66   \n",
       "5240 2023-08-29      #2fcc66   \n",
       "5241 2023-08-30      #2fcc66   \n",
       "5242 2023-08-31      #2fcc66   \n",
       "\n",
       "                                              Incidents  \\\n",
       "0                                                    []   \n",
       "1                                                    []   \n",
       "2     [{'Incident_Title': 'Haiku Partial Outage', 'I...   \n",
       "3     [{'Incident_Title': 'Partial Outage on claude....   \n",
       "4                                                    []   \n",
       "...                                                 ...   \n",
       "5238                                                 []   \n",
       "5239                                                 []   \n",
       "5240                                                 []   \n",
       "5241                                                 []   \n",
       "5242                                                 []   \n",
       "\n",
       "                    Service  incident_count  partial_outage_flag  \\\n",
       "0     console.anthropic.com               0                    0   \n",
       "1     console.anthropic.com               0                    0   \n",
       "2     console.anthropic.com               2                    1   \n",
       "3     console.anthropic.com               1                    1   \n",
       "4     console.anthropic.com               0                    0   \n",
       "...                     ...             ...                  ...   \n",
       "5238              claude.ai               0                    0   \n",
       "5239              claude.ai               0                    0   \n",
       "5240              claude.ai               0                    0   \n",
       "5241              claude.ai               0                    0   \n",
       "5242              claude.ai               0                    0   \n",
       "\n",
       "      partial_outage_minutes  major_outage_flag  major_outage_minutes  \\\n",
       "0                          0                  0                     0   \n",
       "1                          0                  0                     0   \n",
       "2                         59                  0                     0   \n",
       "3                         65                  0                     0   \n",
       "4                          0                  0                     0   \n",
       "...                      ...                ...                   ...   \n",
       "5238                       0                  0                     0   \n",
       "5239                       0                  0                     0   \n",
       "5240                       0                  0                     0   \n",
       "5241                       0                  0                     0   \n",
       "5242                       0                  0                     0   \n",
       "\n",
       "      outage_flag  total_outage_minutes  scaled_total_outage_minutes  \\\n",
       "0               0                     0                          0.0   \n",
       "1               0                     0                          0.0   \n",
       "2               1                    59                         17.7   \n",
       "3               1                    65                         19.5   \n",
       "4               0                     0                          0.0   \n",
       "...           ...                   ...                          ...   \n",
       "5238            0                     0                          0.0   \n",
       "5239            0                     0                          0.0   \n",
       "5240            0                     0                          0.0   \n",
       "5241            0                     0                          0.0   \n",
       "5242            0                     0                          0.0   \n",
       "\n",
       "      outage_impact_level   provider  \n",
       "0                       0  anthropic  \n",
       "1                       0  anthropic  \n",
       "2                       1  anthropic  \n",
       "3                       1  anthropic  \n",
       "4                       0  anthropic  \n",
       "...                   ...        ...  \n",
       "5238                    0  anthropic  \n",
       "5239                    0  anthropic  \n",
       "5240                    0  anthropic  \n",
       "5241                    0  anthropic  \n",
       "5242                    0  anthropic  \n",
       "\n",
       "[5243 rows x 14 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv('data/clean/outage/2024-08-31/outage_unexploded.csv')\n",
    "df['Date'] = pd.to_datetime(df['Date'])\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "567318b30a9fd01c",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-06-07T07:21:46.502370Z",
     "start_time": "2024-06-07T07:21:46.489694Z"
    },
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "df_summary = df.groupby('Service').agg(\n",
    "    start_date=('Date', 'min'),\n",
    "    end_date=('Date', 'max'),\n",
    "    # sum_days=('Date', 'count'),\n",
    "    sum_months=('Date', lambda x: x.dt.to_period('M').nunique()),\n",
    "    # sum_years=('Date', lambda x: x.dt.to_period('Y').nunique()),\n",
    "    sum_total_outages_counts =('outage_flag', 'sum'),\n",
    "    sum_major_outages_counts =('major_outage_flag', 'sum'),\n",
    "    sum_partial_outages_counts =('partial_outage_flag', 'sum'),\n",
    "    sum_total_outages_minutes =('total_outage_minutes', 'sum'),\n",
    "    sum_scaled_total_outages_minutes =('scaled_total_outage_minutes', 'sum'),\n",
    "    sum_incident_counts =('incident_count', 'sum')\n",
    ").reset_index()\n",
    "\n",
    "# df_summary.to_csv('plot/table/outage_summary.csv', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "7769a05ae820f489",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-06-07T07:21:46.508207Z",
     "start_time": "2024-06-07T07:21:46.503116Z"
    },
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Service</th>\n",
       "      <th>start_date</th>\n",
       "      <th>end_date</th>\n",
       "      <th>sum_months</th>\n",
       "      <th>sum_total_outages_counts</th>\n",
       "      <th>sum_major_outages_counts</th>\n",
       "      <th>sum_partial_outages_counts</th>\n",
       "      <th>sum_total_outages_minutes</th>\n",
       "      <th>sum_scaled_total_outages_minutes</th>\n",
       "      <th>sum_incident_counts</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>api</td>\n",
       "      <td>2021-02-11</td>\n",
       "      <td>2024-08-31</td>\n",
       "      <td>43</td>\n",
       "      <td>104</td>\n",
       "      <td>26</td>\n",
       "      <td>78</td>\n",
       "      <td>7891</td>\n",
       "      <td>3340.3</td>\n",
       "      <td>242</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>chatgpt</td>\n",
       "      <td>2023-02-14</td>\n",
       "      <td>2024-08-31</td>\n",
       "      <td>19</td>\n",
       "      <td>70</td>\n",
       "      <td>28</td>\n",
       "      <td>42</td>\n",
       "      <td>5185</td>\n",
       "      <td>2744.1</td>\n",
       "      <td>157</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>labs</td>\n",
       "      <td>2023-02-21</td>\n",
       "      <td>2024-08-31</td>\n",
       "      <td>19</td>\n",
       "      <td>27</td>\n",
       "      <td>13</td>\n",
       "      <td>14</td>\n",
       "      <td>2821</td>\n",
       "      <td>1747.9</td>\n",
       "      <td>34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>playground</td>\n",
       "      <td>2021-03-31</td>\n",
       "      <td>2024-08-31</td>\n",
       "      <td>42</td>\n",
       "      <td>24</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>1636</td>\n",
       "      <td>1017.9</td>\n",
       "      <td>36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>api.anthropic.com</td>\n",
       "      <td>2023-07-11</td>\n",
       "      <td>2024-08-31</td>\n",
       "      <td>14</td>\n",
       "      <td>25</td>\n",
       "      <td>0</td>\n",
       "      <td>25</td>\n",
       "      <td>1675</td>\n",
       "      <td>502.5</td>\n",
       "      <td>80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>claude.ai</td>\n",
       "      <td>2023-07-11</td>\n",
       "      <td>2024-08-31</td>\n",
       "      <td>14</td>\n",
       "      <td>30</td>\n",
       "      <td>2</td>\n",
       "      <td>28</td>\n",
       "      <td>3017</td>\n",
       "      <td>982.8</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>console.anthropic.com</td>\n",
       "      <td>2023-07-11</td>\n",
       "      <td>2024-08-31</td>\n",
       "      <td>14</td>\n",
       "      <td>27</td>\n",
       "      <td>1</td>\n",
       "      <td>26</td>\n",
       "      <td>2032</td>\n",
       "      <td>662.1</td>\n",
       "      <td>72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>character.ai</td>\n",
       "      <td>2023-10-19</td>\n",
       "      <td>2024-08-31</td>\n",
       "      <td>11</td>\n",
       "      <td>32</td>\n",
       "      <td>17</td>\n",
       "      <td>15</td>\n",
       "      <td>3351</td>\n",
       "      <td>1877.5</td>\n",
       "      <td>41</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 Service start_date   end_date  sum_months  \\\n",
       "0                    api 2021-02-11 2024-08-31          43   \n",
       "1                chatgpt 2023-02-14 2024-08-31          19   \n",
       "2                   labs 2023-02-21 2024-08-31          19   \n",
       "3             playground 2021-03-31 2024-08-31          42   \n",
       "4      api.anthropic.com 2023-07-11 2024-08-31          14   \n",
       "5              claude.ai 2023-07-11 2024-08-31          14   \n",
       "6  console.anthropic.com 2023-07-11 2024-08-31          14   \n",
       "7           character.ai 2023-10-19 2024-08-31          11   \n",
       "\n",
       "   sum_total_outages_counts  sum_major_outages_counts  \\\n",
       "0                       104                        26   \n",
       "1                        70                        28   \n",
       "2                        27                        13   \n",
       "3                        24                        12   \n",
       "4                        25                         0   \n",
       "5                        30                         2   \n",
       "6                        27                         1   \n",
       "7                        32                        17   \n",
       "\n",
       "   sum_partial_outages_counts  sum_total_outages_minutes  \\\n",
       "0                          78                       7891   \n",
       "1                          42                       5185   \n",
       "2                          14                       2821   \n",
       "3                          12                       1636   \n",
       "4                          25                       1675   \n",
       "5                          28                       3017   \n",
       "6                          26                       2032   \n",
       "7                          15                       3351   \n",
       "\n",
       "   sum_scaled_total_outages_minutes  sum_incident_counts  \n",
       "0                            3340.3                  242  \n",
       "1                            2744.1                  157  \n",
       "2                            1747.9                   34  \n",
       "3                            1017.9                   36  \n",
       "4                             502.5                   80  \n",
       "5                             982.8                   90  \n",
       "6                             662.1                   72  \n",
       "7                            1877.5                   41  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "order = ['api', 'chatgpt', 'labs', 'playground', 'api.anthropic.com', 'claude.ai', 'console.anthropic.com', 'character.ai']\n",
    "# order df by service\n",
    "df_summary = df_summary.set_index('Service').loc[order].reset_index()\n",
    "df_summary\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "95d2012c",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.12.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}