Damaged Vehicles.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "d683b55d-7e80-4fcc-9f24-3a4793ad57c6",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "c738ce76-2fa7-4f4c-94a2-30b079145418",
   "metadata": {},
   "outputs": [],
   "source": [
    "def compute_speed_and_error(distance, time, dtime):\n",
    "    c = distance / (time * time - dtime * dtime)\n",
    "    return c * time, c * dtime "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "ae164b47-d14f-43a9-9180-2a425533c7ac",
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.DataFrame(columns=[\"Unit Type\",\n",
    "                           \"Speed\", \n",
    "                           \"Speed Tol\",\n",
    "                           \"Status\", \n",
    "                           \"Smoke Duration\",\n",
    "                           \"Health %\",\n",
    "                           \"Health Color\"],\n",
    "                 )\n",
    "pd.options.display.float_format = '{:.2f}'.format"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "5a915a95-76d3-46dc-b936-789e2a86680e",
   "metadata": {},
   "source": [
    "### Harkonnen"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "c39c64a2-eff8-4045-b851-88906de68039",
   "metadata": {},
   "outputs": [],
   "source": [
    "speed_d, speed_error_d = compute_speed_and_error(8, 26, 1)\n",
    "speed_i, speed_error_i = compute_speed_and_error(8, 17, 1)\n",
    "df = df.append({\n",
    "    \"Unit Type\": \"Devastator\",\n",
    "    \"Speed\": speed_i,\n",
    "    \"Speed Tol\": speed_error_i,\n",
    "    \"Status\": \"Intact\",\n",
    "    \"Health %\": 100,\n",
    "    \"Health Color\": \"Green\"\n",
    "}, ignore_index=True)\n",
    "\n",
    "df = df.append({\n",
    "    \"Unit Type\": \"Devastator\",\n",
    "    \"Speed\": speed_d,\n",
    "    \"Speed Tol\": speed_error_d,\n",
    "    \"Status\": \"Smoking\",\n",
    "    \"Smoke Duration\": 26,\n",
    "    \"Health %\": 40,\n",
    "    \"Health Color\": \"Yellow\"\n",
    "}, ignore_index=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "89e5eb12-f679-4682-9585-ed7920189b47",
   "metadata": {},
   "outputs": [],
   "source": [
    "speed_d, speed_error_d = compute_speed_and_error(8, 7, 1)\n",
    "speed_i, speed_error_i = compute_speed_and_error(7, 6, 1)\n",
    "\n",
    "df = df.append({\n",
    "    \"Unit Type\": \"Quad\",\n",
    "    \"Speed\": speed_i,\n",
    "    \"Speed Tol\": speed_error_i,\n",
    "    \"Status\": \"Intact\",\n",
    "    \"Health %\": 100,\n",
    "    \"Health Color\": \"Green\"\n",
    "}, ignore_index=True)\n",
    "\n",
    "df = df.append({\n",
    "    \"Unit Type\": \"Quad\",\n",
    "    \"Speed\": speed_d,\n",
    "    \"Speed Tol\": speed_error_d,\n",
    "    \"Status\": \"Damaged\",\n",
    "    \"Smoke Duration\": 25,\n",
    "    \"Health %\": 15,\n",
    "    \"Health Color\": \"Red\"\n",
    "}, ignore_index=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "46aaf81b-94cc-4a77-a3ac-a03cd92b6e8f",
   "metadata": {},
   "outputs": [],
   "source": [
    "speed_d, speed_error_d = compute_speed_and_error(8, 7, 1)\n",
    "speed_i, speed_error_i = compute_speed_and_error(8, 5, 1)\n",
    "df = df.append({\n",
    "    \"Unit Type\": \"Trike\",\n",
    "    \"Speed\": speed_i,\n",
    "    \"Speed Tol\": speed_error_i,\n",
    "    \"Status\": \"Intact\",\n",
    "    \"Health %\": 100,\n",
    "    \"Health Color\": \"Green\"\n",
    "}, ignore_index=True)\n",
    "\n",
    "df = df.append({\n",
    "    \"Unit Type\": \"Trike\",\n",
    "    \"Speed\": speed_d,\n",
    "    \"Speed Tol\": speed_error_d,\n",
    "    \"Status\": \"Smoking\",\n",
    "    \"Smoke Duration\": 36,\n",
    "    \"Health %\": 20,\n",
    "    \"Health Color\": \"Red\"\n",
    "}, ignore_index=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "261041ec-28f6-4f34-9270-7a90f0eed2fb",
   "metadata": {},
   "outputs": [],
   "source": [
    "speed_d, speed_error_d = compute_speed_and_error(8, 15, 1)\n",
    "speed_i, speed_error_i = compute_speed_and_error(8, 14, 1)\n",
    "df = df.append({\n",
    "    \"Unit Type\": \"Siege Tank\",\n",
    "    \"Speed\": speed_i,\n",
    "    \"Speed Tol\": speed_error_i,\n",
    "    \"Status\": \"Intact\",\n",
    "    \"Health %\": 100,\n",
    "    \"Health Color\": \"Green\"\n",
    "}, ignore_index=True)\n",
    "\n",
    "df = df.append({\n",
    "    \"Unit Type\": \"Siege Tank\",\n",
    "    \"Speed\": speed_d,\n",
    "    \"Speed Tol\": speed_error_d,\n",
    "    \"Status\": \"Smoking\",\n",
    "    \"Smoke Duration\": 26,\n",
    "    \"Health %\": 30,\n",
    "    \"Health Color\": \"Red\"\n",
    "}, ignore_index=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "4f66060d-b9ce-4c47-b954-c8502df5750e",
   "metadata": {},
   "outputs": [],
   "source": [
    "speed_d, speed_error_d = compute_speed_and_error(9, 13, 1)\n",
    "speed_i, speed_error_i = compute_speed_and_error(9, 9, 1)\n",
    "\n",
    "df = df.append({\n",
    "    \"Unit Type\": \"Combat Tank H\",\n",
    "    \"Speed\": speed_i,\n",
    "    \"Speed Tol\": speed_error_i,\n",
    "    \"Status\": \"Intact\",\n",
    "    \"Health %\": 100,\n",
    "    \"Health Color\": \"Green\"\n",
    "}, ignore_index=True)\n",
    "\n",
    "df = df.append({\n",
    "    \"Unit Type\": \"Combat Tank H\",\n",
    "    \"Speed\": speed_d,\n",
    "    \"Speed Tol\": speed_error_d,\n",
    "    \"Status\": \"Smoking\",\n",
    "    \"Smoke Duration\": 16,\n",
    "    \"Health %\": 30,\n",
    "    \"Health Color\": \"Yellow\"\n",
    "}, ignore_index=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "c3b6a4a8-7956-4f25-93be-972f97de1e75",
   "metadata": {},
   "outputs": [],
   "source": [
    "speed_d, speed_error_d = compute_speed_and_error(8, 9, 1)\n",
    "speed_i, speed_error_i = compute_speed_and_error(8, 7, 1)\n",
    "df = df.append({\n",
    "    \"Unit Type\": \"Missile Tank\",\n",
    "    \"Speed\": speed_i,\n",
    "    \"Speed Tol\": speed_error_i,\n",
    "    \"Status\": \"Intact\",\n",
    "    \"Health %\": 100,\n",
    "    \"Health Color\": \"Green\"\n",
    "}, ignore_index=True)\n",
    "\n",
    "df = df.append({\n",
    "    \"Unit Type\": \"Missile Tank\",\n",
    "    \"Speed\": speed_d,\n",
    "    \"Speed Tol\": speed_error_d,\n",
    "    \"Status\": \"Smoking\",\n",
    "    \"Smoke Duration\": 25,\n",
    "    \"Health %\": 25,\n",
    "    \"Health Color\": \"Red\"\n",
    "}, ignore_index=True)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "f993fa5f-fbe3-49c2-9d1c-0cc7fdca0e63",
   "metadata": {},
   "source": [
    "### Ordos"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "0cec745e-ac17-4896-a00b-4132c6db27ba",
   "metadata": {},
   "outputs": [],
   "source": [
    "df = df.append({\n",
    "    \"Unit Type\": \"Raider\",\n",
    "    \"Smoke Duration\": 40,\n",
    "    \"Status\": \"Smoking\",\n",
    "    \"Health %\": 45,\n",
    "    \"Health Color\": \"Yellow\"\n",
    "}, ignore_index=True)\n",
    "\n",
    "df = df.append({\n",
    "    \"Unit Type\": \"Raider\",\n",
    "    \"Smoke Duration\": 36,\n",
    "    \"Status\": \"Smoking\",\n",
    "    \"Health %\": 45,\n",
    "    \"Health Color\": \"Yellow\"\n",
    "}, ignore_index=True)\n",
    "\n",
    "df = df.append({\n",
    "    \"Unit Type\": \"Raider\",\n",
    "    \"Smoke Duration\": 34,\n",
    "    \"Status\": \"Smoking\",\n",
    "    \"Health %\": 45,\n",
    "    \"Health Color\": \"Yellow\"\n",
    "}, ignore_index=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "31d97a6d-6468-413b-b93b-2c9da4f3d303",
   "metadata": {},
   "outputs": [],
   "source": [
    "speed_d, speed_error_d = compute_speed_and_error(8, 8, 1)\n",
    "speed_i, speed_error_i = compute_speed_and_error(8, 6, 1)\n",
    "\n",
    "df = df.append({\n",
    "    \"Unit Type\": \"Combat Tank O\",\n",
    "    \"Speed\": speed_i,\n",
    "    \"Speed Tol\": speed_error_i,\n",
    "    \"Status\": \"Intact\",\n",
    "    \"Health %\": 100,\n",
    "    \"Health Color\": \"Green\"\n",
    "}, ignore_index=True)\n",
    "\n",
    "df = df.append({\n",
    "    \"Unit Type\": \"Combat Tank O\",\n",
    "    \"Speed\": speed_d,\n",
    "    \"Speed Tol\": speed_error_d,\n",
    "    \"Status\": \"Smoking\",\n",
    "    \"Smoke Duration\": 36,\n",
    "    \"Health %\": 30,\n",
    "    \"Health Color\": \"Yellow\"\n",
    "}, ignore_index=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "4c93ea6e-3681-4863-9edc-e6b0a1f61f3f",
   "metadata": {},
   "outputs": [],
   "source": [
    "speed_d, speed_error_d = compute_speed_and_error(8, 12, 1)\n",
    "speed_i, speed_error_i = compute_speed_and_error(8, 10, 1)\n",
    "\n",
    "df = df.append({\n",
    "    \"Unit Type\": \"Deviator\",\n",
    "    \"Speed\": speed_i,\n",
    "    \"Speed Tol\": speed_error_i,\n",
    "    \"Status\": \"Intact\",\n",
    "    \"Health %\": 100,\n",
    "    \"Health Color\": \"Green\"\n",
    "}, ignore_index=True)\n",
    "\n",
    "df = df.append({\n",
    "    \"Unit Type\": \"Deviator\",\n",
    "    \"Speed\": speed_d,\n",
    "    \"Speed Tol\": speed_error_d,\n",
    "    \"Status\": \"Smoking\",\n",
    "    \"Smoke Duration\": 21,\n",
    "    \"Health %\": 30,\n",
    "    \"Health Color\": \"Yellow\"\n",
    "}, ignore_index=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "9b493045-8120-4d03-9e14-de483dc76b2b",
   "metadata": {},
   "outputs": [],
   "source": [
    "speed_d, speed_error_d = compute_speed_and_error(8, 5, 1)\n",
    "speed_i, speed_error_i = compute_speed_and_error(8, 3, 1)\n",
    "\n",
    "df = df.append({\n",
    "    \"Unit Type\": \"Stealth Raider\",\n",
    "    \"Speed\": speed_i,\n",
    "    \"Speed Tol\": speed_error_i,\n",
    "    \"Status\": \"Intact\",\n",
    "    \"Health %\": 100,\n",
    "    \"Health Color\": \"Green\"\n",
    "}, ignore_index=True)\n",
    "\n",
    "df = df.append({\n",
    "    \"Unit Type\": \"Stealth Raider\",\n",
    "    \"Speed\": speed_d,\n",
    "    \"Speed Tol\": speed_error_d,\n",
    "    \"Status\": \"Smoking\",\n",
    "    \"Smoke Duration\": 21,\n",
    "    \"Health %\": 50,\n",
    "    \"Health Color\": \"Yellow\"\n",
    "}, ignore_index=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "9817a86b-a9ad-41ad-a9bb-6b3e784b2b76",
   "metadata": {},
   "outputs": [],
   "source": [
    "speed_d, speed_error_d = compute_speed_and_error(8, 7, 1)\n",
    "speed_i, speed_error_i = compute_speed_and_error(8, 6, 1)\n",
    "\n",
    "df = df.append({\n",
    "    \"Unit Type\": \"Quad\",\n",
    "    \"Speed\": speed_i,\n",
    "    \"Speed Tol\": speed_error_i,\n",
    "    \"Status\": \"Intact\",\n",
    "    \"Health %\": 100,\n",
    "    \"Health Color\": \"Green\"\n",
    "}, ignore_index=True)\n",
    "\n",
    "df = df.append({\n",
    "    \"Unit Type\": \"Quad\",\n",
    "    \"Speed\": speed_d,\n",
    "    \"Speed Tol\": speed_error_d,\n",
    "    \"Status\": \"Smoking\",\n",
    "    \"Smoke Duration\": 31,\n",
    "    \"Health %\": 30,\n",
    "    \"Health Color\": \"Red\"\n",
    "}, ignore_index=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "040b8ee0-d614-47c4-9fc5-272487873127",
   "metadata": {},
   "outputs": [],
   "source": [
    "speed_d, speed_error_d = compute_speed_and_error(7, 16, 1)\n",
    "speed_i, speed_error_i = compute_speed_and_error(8, 13, 1)\n",
    "\n",
    "df = df.append({\n",
    "    \"Unit Type\": \"Siege Tank\",\n",
    "    \"Speed\": speed_i,\n",
    "    \"Speed Tol\": speed_error_i,\n",
    "    \"Status\": \"Intact\",\n",
    "    \"Health %\": 100,\n",
    "    \"Health Color\": \"Green\"\n",
    "}, ignore_index=True)\n",
    "\n",
    "df = df.append({\n",
    "    \"Unit Type\": \"Siege Tank\",\n",
    "    \"Speed\": speed_d,\n",
    "    \"Speed Tol\": speed_error_d,\n",
    "    \"Status\": \"Smoking\",\n",
    "    \"Smoke Duration\": 37,\n",
    "    \"Health %\": 50,\n",
    "    \"Health Color\": \"Yellow\"\n",
    "}, ignore_index=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "c2215eb3-26ed-4782-ae66-ef6501b822ce",
   "metadata": {},
   "outputs": [],
   "source": [
    "speed_d, speed_error_d = compute_speed_and_error(8, 15, 1)\n",
    "speed_i, speed_error_i = compute_speed_and_error(8, 13, 1)\n",
    "\n",
    "df = df.append({\n",
    "    \"Unit Type\": \"Harvester\",\n",
    "    \"Speed\": speed_i,\n",
    "    \"Speed Tol\": speed_error_i,\n",
    "    \"Status\": \"Intact\",\n",
    "    \"Health %\": 100,\n",
    "    \"Health Color\": \"Green\"\n",
    "}, ignore_index=True)\n",
    "\n",
    "df = df.append({\n",
    "    \"Unit Type\": \"Harvester\",\n",
    "    \"Speed\": speed_d,\n",
    "    \"Speed Tol\": speed_error_d,\n",
    "    \"Status\": \"Smoking\",\n",
    "    \"Health %\": 30,\n",
    "    \"Health Color\": \"Red\"\n",
    "}, ignore_index=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "d5761d3b-c636-498d-93bc-2106124eff68",
   "metadata": {},
   "outputs": [],
   "source": [
    "speed_d, speed_error_d = compute_speed_and_error(8, 5, 1)\n",
    "speed_i, speed_error_i = compute_speed_and_error(8, 3, 1)\n",
    "\n",
    "df = df.append({\n",
    "    \"Unit Type\": \"Raider\",\n",
    "    \"Speed\": speed_i,\n",
    "    \"Speed Tol\": speed_error_i,\n",
    "    \"Status\": \"Intact\",\n",
    "    \"Health %\": 100,\n",
    "    \"Health Color\": \"Green\"\n",
    "}, ignore_index=True)\n",
    "\n",
    "df = df.append({\n",
    "    \"Unit Type\": \"Raider\",\n",
    "    \"Speed\": speed_d,\n",
    "    \"Speed Tol\": speed_error_d,\n",
    "    \"Status\": \"Smoking\",\n",
    "    \"Health %\": 45,\n",
    "    \"Health Color\": \"Yellow\"\n",
    "}, ignore_index=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "f21d70d2-b4f9-4586-892e-420195f22e0b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unit Type</th>\n",
       "      <th>Speed</th>\n",
       "      <th>Speed Tol</th>\n",
       "      <th>Status</th>\n",
       "      <th>Smoke Duration</th>\n",
       "      <th>Health %</th>\n",
       "      <th>Health Color</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Devastator</td>\n",
       "      <td>0.47</td>\n",
       "      <td>0.03</td>\n",
       "      <td>Intact</td>\n",
       "      <td>NaN</td>\n",
       "      <td>100</td>\n",
       "      <td>Green</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Devastator</td>\n",
       "      <td>0.31</td>\n",
       "      <td>0.01</td>\n",
       "      <td>Smoking</td>\n",
       "      <td>26.00</td>\n",
       "      <td>40</td>\n",
       "      <td>Yellow</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Quad</td>\n",
       "      <td>1.20</td>\n",
       "      <td>0.20</td>\n",
       "      <td>Intact</td>\n",
       "      <td>NaN</td>\n",
       "      <td>100</td>\n",
       "      <td>Green</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Quad</td>\n",
       "      <td>1.17</td>\n",
       "      <td>0.17</td>\n",
       "      <td>Damaged</td>\n",
       "      <td>25.00</td>\n",
       "      <td>15</td>\n",
       "      <td>Red</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Trike</td>\n",
       "      <td>1.67</td>\n",
       "      <td>0.33</td>\n",
       "      <td>Intact</td>\n",
       "      <td>NaN</td>\n",
       "      <td>100</td>\n",
       "      <td>Green</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Trike</td>\n",
       "      <td>1.17</td>\n",
       "      <td>0.17</td>\n",
       "      <td>Smoking</td>\n",
       "      <td>36.00</td>\n",
       "      <td>20</td>\n",
       "      <td>Red</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Siege Tank</td>\n",
       "      <td>0.57</td>\n",
       "      <td>0.04</td>\n",
       "      <td>Intact</td>\n",
       "      <td>NaN</td>\n",
       "      <td>100</td>\n",
       "      <td>Green</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Siege Tank</td>\n",
       "      <td>0.54</td>\n",
       "      <td>0.04</td>\n",
       "      <td>Smoking</td>\n",
       "      <td>26.00</td>\n",
       "      <td>30</td>\n",
       "      <td>Red</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Combat Tank H</td>\n",
       "      <td>1.01</td>\n",
       "      <td>0.11</td>\n",
       "      <td>Intact</td>\n",
       "      <td>NaN</td>\n",
       "      <td>100</td>\n",
       "      <td>Green</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Combat Tank H</td>\n",
       "      <td>0.70</td>\n",
       "      <td>0.05</td>\n",
       "      <td>Smoking</td>\n",
       "      <td>16.00</td>\n",
       "      <td>30</td>\n",
       "      <td>Yellow</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Missile Tank</td>\n",
       "      <td>1.17</td>\n",
       "      <td>0.17</td>\n",
       "      <td>Intact</td>\n",
       "      <td>NaN</td>\n",
       "      <td>100</td>\n",
       "      <td>Green</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Missile Tank</td>\n",
       "      <td>0.90</td>\n",
       "      <td>0.10</td>\n",
       "      <td>Smoking</td>\n",
       "      <td>25.00</td>\n",
       "      <td>25</td>\n",
       "      <td>Red</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Raider</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Smoking</td>\n",
       "      <td>40.00</td>\n",
       "      <td>45</td>\n",
       "      <td>Yellow</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Raider</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Smoking</td>\n",
       "      <td>36.00</td>\n",
       "      <td>45</td>\n",
       "      <td>Yellow</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Raider</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Smoking</td>\n",
       "      <td>34.00</td>\n",
       "      <td>45</td>\n",
       "      <td>Yellow</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Combat Tank O</td>\n",
       "      <td>1.37</td>\n",
       "      <td>0.23</td>\n",
       "      <td>Intact</td>\n",
       "      <td>NaN</td>\n",
       "      <td>100</td>\n",
       "      <td>Green</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Combat Tank O</td>\n",
       "      <td>1.02</td>\n",
       "      <td>0.13</td>\n",
       "      <td>Smoking</td>\n",
       "      <td>36.00</td>\n",
       "      <td>30</td>\n",
       "      <td>Yellow</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Deviator</td>\n",
       "      <td>0.81</td>\n",
       "      <td>0.08</td>\n",
       "      <td>Intact</td>\n",
       "      <td>NaN</td>\n",
       "      <td>100</td>\n",
       "      <td>Green</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Deviator</td>\n",
       "      <td>0.67</td>\n",
       "      <td>0.06</td>\n",
       "      <td>Smoking</td>\n",
       "      <td>21.00</td>\n",
       "      <td>30</td>\n",
       "      <td>Yellow</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Stealth Raider</td>\n",
       "      <td>3.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>Intact</td>\n",
       "      <td>NaN</td>\n",
       "      <td>100</td>\n",
       "      <td>Green</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Stealth Raider</td>\n",
       "      <td>1.67</td>\n",
       "      <td>0.33</td>\n",
       "      <td>Smoking</td>\n",
       "      <td>21.00</td>\n",
       "      <td>50</td>\n",
       "      <td>Yellow</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Quad</td>\n",
       "      <td>1.37</td>\n",
       "      <td>0.23</td>\n",
       "      <td>Intact</td>\n",
       "      <td>NaN</td>\n",
       "      <td>100</td>\n",
       "      <td>Green</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Quad</td>\n",
       "      <td>1.17</td>\n",
       "      <td>0.17</td>\n",
       "      <td>Smoking</td>\n",
       "      <td>31.00</td>\n",
       "      <td>30</td>\n",
       "      <td>Red</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Siege Tank</td>\n",
       "      <td>0.62</td>\n",
       "      <td>0.05</td>\n",
       "      <td>Intact</td>\n",
       "      <td>NaN</td>\n",
       "      <td>100</td>\n",
       "      <td>Green</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Siege Tank</td>\n",
       "      <td>0.44</td>\n",
       "      <td>0.03</td>\n",
       "      <td>Smoking</td>\n",
       "      <td>37.00</td>\n",
       "      <td>50</td>\n",
       "      <td>Yellow</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Harvester</td>\n",
       "      <td>0.62</td>\n",
       "      <td>0.05</td>\n",
       "      <td>Intact</td>\n",
       "      <td>NaN</td>\n",
       "      <td>100</td>\n",
       "      <td>Green</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Harvester</td>\n",
       "      <td>0.54</td>\n",
       "      <td>0.04</td>\n",
       "      <td>Smoking</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30</td>\n",
       "      <td>Red</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Raider</td>\n",
       "      <td>3.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>Intact</td>\n",
       "      <td>NaN</td>\n",
       "      <td>100</td>\n",
       "      <td>Green</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Raider</td>\n",
       "      <td>1.67</td>\n",
       "      <td>0.33</td>\n",
       "      <td>Smoking</td>\n",
       "      <td>NaN</td>\n",
       "      <td>45</td>\n",
       "      <td>Yellow</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         Unit Type  Speed  Speed Tol   Status  Smoke Duration Health %  \\\n",
       "0       Devastator   0.47       0.03   Intact             NaN      100   \n",
       "1       Devastator   0.31       0.01  Smoking           26.00       40   \n",
       "2             Quad   1.20       0.20   Intact             NaN      100   \n",
       "3             Quad   1.17       0.17  Damaged           25.00       15   \n",
       "4            Trike   1.67       0.33   Intact             NaN      100   \n",
       "5            Trike   1.17       0.17  Smoking           36.00       20   \n",
       "6       Siege Tank   0.57       0.04   Intact             NaN      100   \n",
       "7       Siege Tank   0.54       0.04  Smoking           26.00       30   \n",
       "8    Combat Tank H   1.01       0.11   Intact             NaN      100   \n",
       "9    Combat Tank H   0.70       0.05  Smoking           16.00       30   \n",
       "10    Missile Tank   1.17       0.17   Intact             NaN      100   \n",
       "11    Missile Tank   0.90       0.10  Smoking           25.00       25   \n",
       "12          Raider    NaN        NaN  Smoking           40.00       45   \n",
       "13          Raider    NaN        NaN  Smoking           36.00       45   \n",
       "14          Raider    NaN        NaN  Smoking           34.00       45   \n",
       "15   Combat Tank O   1.37       0.23   Intact             NaN      100   \n",
       "16   Combat Tank O   1.02       0.13  Smoking           36.00       30   \n",
       "17        Deviator   0.81       0.08   Intact             NaN      100   \n",
       "18        Deviator   0.67       0.06  Smoking           21.00       30   \n",
       "19  Stealth Raider   3.00       1.00   Intact             NaN      100   \n",
       "20  Stealth Raider   1.67       0.33  Smoking           21.00       50   \n",
       "21            Quad   1.37       0.23   Intact             NaN      100   \n",
       "22            Quad   1.17       0.17  Smoking           31.00       30   \n",
       "23      Siege Tank   0.62       0.05   Intact             NaN      100   \n",
       "24      Siege Tank   0.44       0.03  Smoking           37.00       50   \n",
       "25       Harvester   0.62       0.05   Intact             NaN      100   \n",
       "26       Harvester   0.54       0.04  Smoking             NaN       30   \n",
       "27          Raider   3.00       1.00   Intact             NaN      100   \n",
       "28          Raider   1.67       0.33  Smoking             NaN       45   \n",
       "\n",
       "   Health Color  \n",
       "0         Green  \n",
       "1        Yellow  \n",
       "2         Green  \n",
       "3           Red  \n",
       "4         Green  \n",
       "5           Red  \n",
       "6         Green  \n",
       "7           Red  \n",
       "8         Green  \n",
       "9        Yellow  \n",
       "10        Green  \n",
       "11          Red  \n",
       "12       Yellow  \n",
       "13       Yellow  \n",
       "14       Yellow  \n",
       "15        Green  \n",
       "16       Yellow  \n",
       "17        Green  \n",
       "18       Yellow  \n",
       "19        Green  \n",
       "20       Yellow  \n",
       "21        Green  \n",
       "22          Red  \n",
       "23        Green  \n",
       "24       Yellow  \n",
       "25        Green  \n",
       "26          Red  \n",
       "27        Green  \n",
       "28       Yellow  "
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "a0f94b7c-4a83-4bdf-8fe3-fdf81cd50066",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv(\"Damaged Vehicle.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "807f4194-7dcc-44e2-acd1-3259b3ed7618",
   "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.7.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}