Formated Data Processing.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Formated Data Processing"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "This sheet goes through each of the columns from the .csv output by the In-Processing program,\"all_data_raw.csv\", and uses the formatted informaiton to add columns to the \"all_data_analytics.csv\". Some columns are already finalized thanks to the base format in the .doc files: Journal Code, Unified Command, Region, Province, Type of Engagement, Reference, Report RN, Date, Summary Report."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import os\n",
    "esoc_all_data_raw = pd.read_csv(\"ESOC_All_Data_2010_2012_Raw.csv\")\n",
    "#Remove Nans\n",
    "esoc_all_data_raw = esoc_all_data_raw.replace(np.nan, '', regex=True)\n",
    "#Set date column to pandas datetime\n",
    "esoc_all_data_raw['Date'] =  pd.to_datetime(esoc_all_data_raw['Date'], format='%d %b %Y')\n",
    "#Create new analytics dataframe to eventuall print out to new csv for the finalized columns\n",
    "final_cols = [\"Journal Code\", \"Unified Command\", \"Region\", \"Province\", \"Type of Engagement\", \"Reference\", \"Report RN\", \"Date\", \"Summary Report\"]\n",
    "esoc_all_data_analytics = esoc_all_data_raw.filter(final_cols, axis=1)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Name Count Tool"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Allows the user to supply a list of subheadings and return the number of names (if each is on its own line) in the same order of the input list"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "import operator\n",
    "def nameCount(text,*wordList):\n",
    "    #Split the text into blocks based on delimeter:\n",
    "    blocks = text.split(\"/\")\n",
    "    #Make a dictionary from word array to hold the block numbers for variable sub-headings\n",
    "    detailBlock = dict.fromkeys(wordList, 0)\n",
    "\n",
    "    #Collect the starting indicies for the present sub-headings\n",
    "    for split in detailBlock:\n",
    "        try:\n",
    "            detailBlock[split] = blocks.index(split)\n",
    "        #Assign -1 for absent sub-headings\n",
    "        except ValueError:\n",
    "            detailBlock[split] = -1\n",
    "            \n",
    "    #Sort based on value of sub-heading indicie\n",
    "    sort = sorted(detailBlock.items(), key=operator.itemgetter(1))\n",
    "    \n",
    "    #Set up output array\n",
    "    out = [0]*(len(wordList))\n",
    "            \n",
    "    #Iterate through sub-headings\n",
    "    for i in range(len(sort)):\n",
    "        #Variable for the number of a certain instance\n",
    "        numOfInstance = 0\n",
    "        #Ignore those that are not present\n",
    "        if sort[i][1] != -1:\n",
    "            #If not at the last present sub-heading collect blocks from the previous sub-heading\n",
    "            if len(sort) - sort.index(sort[i]) != 1:\n",
    "                detailText = blocks[sort[i][1]+1:sort[i+1][1]]\n",
    "                numOfInstance = len(detailText)\n",
    "            #Else, last present sub-heading, collect to the end\n",
    "            else:\n",
    "                detailText = blocks[sort[i][1]+1:]\n",
    "                numOfInstance = len(detailText)\n",
    "\n",
    "            #Place the length (number of names) of the various subheadings into the right index of output\n",
    "            out[wordList.index(sort[i][0])] = numOfInstance\n",
    "    return out\n",
    "#slotFinder(esoc_all_data_raw[\"Enemy Side\"][0],\"hold\",[\"Killed\",\"Captured\"])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Enemy Side"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The enemy side column had 6 possible subheadings to include: Killed, Body Count, Captured, Surrendered, Apprehended, & Arrested.  \n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "     Journal Code Unified Command       Region                     Province  \\\n",
      "0           13312     WESTMINCOM          ARMM                     BASILAN    \n",
      "1           13338     WESTMINCOM          ARMM                        SULU    \n",
      "2           13355     WESTMINCOM          ARMM                        SULU    \n",
      "3           13441     WESTMINCOM          ARMM                    BASILAN     \n",
      "4           13459     WESTMINCOM          ARMM                        SULU    \n",
      "5           13469     WESTMINCOM          ARMM                     BASILAN    \n",
      "6           13482     WESTMINCOM          ARMM                    BASILAN     \n",
      "7           13536     WESTMINCOM          ARMM                        SULU    \n",
      "8           13537     WESTMINCOM          ARMM                     BASILAN    \n",
      "9           13543     WESTMINCOM          ARMM                     BASILAN    \n",
      "10          13553     WESTMINCOM          ARMM                     BASILAN    \n",
      "11          13571     WESTMINCOM          ARMM                        SULU    \n",
      "12          13573     WESTMINCOM          ARMM                        SULU    \n",
      "13          13429     EASTMINCOM    REGION XII             SOUTH COTABATO     \n",
      "14          13315     EASTMINCOM    REGION XII                    COTABATO    \n",
      "15          13316     EASTMINCOM          ARMM                MAGUINDANAO     \n",
      "16          13523     WESTMINCOM      REGION X               LANAO DEL SUR    \n",
      "17          13301         NOLCOM    REGION III                NUEVA ECIJA     \n",
      "18          13444         SOLCOM     REGION IV                     QUEZON     \n",
      "19          13476         SOLCOM   REGION IV-A                      LAGUNA    \n",
      "20          13526         SOLCOM   REGION IV-A                     ROMBLON    \n",
      "21          13548         SOLCOM      REGION V              CAMARINES SUR     \n",
      "22          13484        CENTCOM    REGION VII            NEGROS ORIENTAL     \n",
      "23          13293     EASTMINCOM    REGION XII                    COTABATO    \n",
      "24          13305     EASTMINCOM          ARMM                 MAGUINDANAO    \n",
      "25          13317     EASTMINCOM     REGION XI             DAVAO ORIENTAL     \n",
      "26          13341     EASTMINCOM     REGION XI  COMPOSTELA VALLEY PROVINCE    \n",
      "27          13356     EASTMINCOM     REGION XI             DAVAO DEL NORTE    \n",
      "28          13392     EASTMINCOM          ARMM                 MAGUINDANAO    \n",
      "29          13434     EASTMINCOM    REGION XII              NORTH COTABATO    \n",
      "...           ...             ...          ...                          ...   \n",
      "9811        11720     WESTMINCOM          ARMM                        SULU    \n",
      "9812        11721     WESTMINCOM          ARMM                        SULU    \n",
      "9813        11722     WESTMINCOM     REGION IX            LANAO DEL NORTE     \n",
      "9814        11723     WESTMINCOM      REGION X            LANAO DEL NORTE     \n",
      "9815        11731     WESTMINCOM    REGION XII                   COTABATO     \n",
      "9816        11760     WESTMINCOM      REGION X            LANAO DEL NORTE     \n",
      "9817        11768     WESTMINCOM      REGION X            LANAO DEL NORTE     \n",
      "9818        11785     WESTMINCOM          ARMM              LANAO DEL SUR     \n",
      "9819        11798     WESTMINCOM      REGION X         MISAMIS OCCIDENTAL     \n",
      "9820        11618        CENTCOM    REGION VII                       CEBU     \n",
      "9821        11576         NOLCOM    REGION III                 NEUVA ECIJA    \n",
      "9822        11588         NOLCOM    REGION III                NUEVA ECIJA     \n",
      "9823        11549         SOLCOM     REGION IV                     QUEZON     \n",
      "9824        11412     EASTMINCOM      REGION X            MISAMIS ORIENTAL    \n",
      "9825        11538     EASTMINCOM      REGION X                    BUKIDNON    \n",
      "9826        11738         NOLCOM    REGION III                     TARLAC     \n",
      "9827        11368         SOLCOM   REGION IV-A                       RIZAL    \n",
      "9828        11477         SOLCOM      REGION V                 CATANDUANES    \n",
      "9829        11362     EASTMINCOM    REGION XII                   COTABATO     \n",
      "9830        11395     EASTMINCOM    REGION XII               NOTH COTABATO    \n",
      "9831        11423     EASTMINCOM        CARAGA            SURIGAO DEL SUR     \n",
      "9832        11685     EASTMINCOM      REGION X                   BUKIDNON     \n",
      "9833        11394     WESTMINCOM          ARMM                        SULU    \n",
      "9834        11398     WESTMINCOM     REGION XI                 MARAWI CITY    \n",
      "9835        11414     WESTMINCOM      REGION X             LANAO DEL NORTE    \n",
      "9836        11464     WESTMINCOM          ARMM                    BASILAN     \n",
      "9837        11513     WESTMINCOM          ARMM                     BASILAN    \n",
      "9838        11624     WESTMINCOM     REGION IX                   ZAMBOANGA    \n",
      "9839        11791     WESTMINCOM          ARMM                     BASILAN    \n",
      "9840        11573     WESTMINCOM          ARMM                        SULU    \n",
      "\n",
      "                      Type of Engagement    Reference  \\\n",
      "0                              ENCOUNTER  WESTMINCOM    \n",
      "1                            LIQUIDATION  WESTMINCOM    \n",
      "2                             HARASSMENT  WESTMINCOM    \n",
      "3                              ENCOUNTER  WESTMINCOM    \n",
      "4                             HARASSMENT       ISAFP    \n",
      "5                              ENCOUNTER  WESTMINCOM    \n",
      "6                              ENCOUNTER     PNP-NOC    \n",
      "7                              ENCOUNTER       ISAFP    \n",
      "8                           APPREHENSION  WESTMINCOM    \n",
      "9            SEIZURE OF BOAT USED BY ASG  WESTMINCOM    \n",
      "10                             ENCOUNTER  WESTMINCOM    \n",
      "11                            KIDNAPPING  WESTMINCOM    \n",
      "12                             ENCOUNTER  WESTMINCOM    \n",
      "13                          APPREHENSION  EASTMINCOM    \n",
      "14                           ARMED CLASH     6ID, PA    \n",
      "15                           ARMED CLASH     6ID, PA    \n",
      "16                             SURRENDER  WESTMINCOM    \n",
      "17                        RECOVERY OF FA      NOLCOM    \n",
      "18                        RECOVERY OF FA      SOLCOM    \n",
      "19                       RECOVERY OF IED      SOLCOM    \n",
      "20                                AMBUSH      SOLCOM    \n",
      "21                            HARASSMENT      SOLCOM    \n",
      "22                             SURRENDER     CENTCOM    \n",
      "23                            KIDNAPPING  EASTMINCOM    \n",
      "24                             ABDUCTION   EMC/ISAFP    \n",
      "25                      DISCOVERY OF IED  EASTMINCOM    \n",
      "26               DISCOVERY OF ENEMY CAMP  EASTMINCOM    \n",
      "27                            HARASSMENT  EASTMINCOM    \n",
      "28    RELEASE OF HOSTAGES/KIDNAP VICTIMS  EASTMINCOM    \n",
      "29                            HARASSMENT  EASTMINCOM    \n",
      "...                                  ...          ...   \n",
      "9811         ELECTION VIOLATION (GENERAL          PN    \n",
      "9812         ELECTION VIOLATION (GENERAL          PN    \n",
      "9813                            SHOOTING         1ID    \n",
      "9814                             BURNING         1ID    \n",
      "9815                             BURNING         6ID    \n",
      "9816                      RECOVERY OF FA         1ID    \n",
      "9817                         ARMED CLASH         1ID    \n",
      "9818                      RECOVERY OF FA  WESTMINCOM    \n",
      "9819                            SHOOTING         PNP    \n",
      "9820                        APPREHENSION      PAF A2    \n",
      "9821                            DROWNING      NOLCOM    \n",
      "9822                             TYPHOON      NOLCOM    \n",
      "9823                          SEA MISHAP      SOLCOM    \n",
      "9824                         FLASH FLOOD  EASTMINCOM    \n",
      "9825                           LANDSLIDE     4ID, PA    \n",
      "9826                      RECOVERY OF FA      NOLCOM    \n",
      "9827                     ILLEGAL LOGGING      SOLCOM    \n",
      "9828                     ILLEGAL LOGGING      SOLCOM    \n",
      "9829                         ARMED CLASH         6ID    \n",
      "9830                           ABDUCTION       ISAFP    \n",
      "9831                   ACCIDENT (GENERAL  EASTMINCOM    \n",
      "9832                            SHOOTING     4ID, PA    \n",
      "9833                          KIDNAPPING  WESTMINCOM    \n",
      "9834                                RAID     1ID, PA    \n",
      "9835                     ILLEGAL LOGGING     1ID, PA    \n",
      "9836              DETONATING OF RPG AMMO  WESTMINCOM    \n",
      "9837                    GRENADE THROWING  WESTMINCOM    \n",
      "9838                            RUN AMOK     1ID, PA    \n",
      "9839                            SHOOTING  WESTMINCOM    \n",
      "9840                   RESCUE OPERATIONS  WESTMINCOM    \n",
      "\n",
      "                                     Report RN       Date  \\\n",
      "0                                 WMC-0104-03  2011-04-03   \n",
      "1                              WMC-0504-02-11  2011-04-05   \n",
      "2                                 WMC-0704-03  2011-04-07   \n",
      "3     WMC-1604-01 / PNP NOC RPT DTD 16 APR 11  2011-04-16   \n",
      "4                         STL DTD 18-APR-2011  2011-04-18   \n",
      "5                                 WMC-1904-02  2011-04-18   \n",
      "6       SIGNIFICANT INCIDENT REPORT 042111-01  2011-04-21   \n",
      "7                                         STL  2011-04-27   \n",
      "8                                 WMC-2704-03  2011-04-27   \n",
      "9                                 WMC-2704-06  2011-04-27   \n",
      "10                                WMC-2994-01  2011-04-29   \n",
      "11                                WMC-3004-01  2011-04-30   \n",
      "12                                WMC-3004-03  2011-04-30   \n",
      "13                           EMCOC-1404667-11  2011-04-14   \n",
      "14                        6DTOC-0304-180-2011  2011-04-04   \n",
      "15                        6DTOC-0304-181-2011  2011-04-04   \n",
      "16                                WMC-2604-03  2011-04-26   \n",
      "17                           CN-0204-628-2011  2011-04-02   \n",
      "18                          SLCOC-1604-233-11  2011-04-17   \n",
      "19                             SLCOC-20-04-11  2011-04-20   \n",
      "20                          SLCOC-2604-259-11  2011-04-26   \n",
      "21                          SLCOC-2804-263-11  2011-04-28   \n",
      "22                               COC-2011-164  2011-04-21   \n",
      "23                          EMCOC-0104-570-11  2011-04-02   \n",
      "24                      STL/EMCOC-0204-581-11  2011-04-02   \n",
      "25                          EMCOC-0304-584-11  2011-04-04   \n",
      "26                          EMCOC-0504-605-11  2011-04-06   \n",
      "27                          EMCOC-0704-718-11  2011-04-07   \n",
      "28                          EMCOC-1004-641-11  2011-04-10   \n",
      "29                          EMCOC-1504-672-11  2011-04-15   \n",
      "...                                        ...        ...   \n",
      "9811                             CDO-1010-113  2010-10-25   \n",
      "9812                             CDO-1010-112  2010-10-25   \n",
      "9813                     6D01-3-TCP-2510-2010  2010-10-26   \n",
      "9814                                      1DC  2010-10-26   \n",
      "9815                           6DTOC-104-2010  2010-10-26   \n",
      "9816                       1DC-2610-2014-2010  2010-10-26   \n",
      "9817                       1DC-2610-2016-2010  2010-10-26   \n",
      "9818                              WMC 2910 01  2010-10-29   \n",
      "9819                       DAILY NEMAC REPORT  2010-10-31   \n",
      "9820                                   SITREP  2010-10-22   \n",
      "9821                           CN-356-2010-10  2010-10-20   \n",
      "9822                           CN-361-2010-10  2010-10-20   \n",
      "9823                        SLCOC 1810 930 10  2010-10-18   \n",
      "9824                        EMCOC-0910-841-10  2010-10-09   \n",
      "9825                       DRO-1710-1903-2010  2010-10-17   \n",
      "9826                         NLOC-404-2610-10  2010-10-27   \n",
      "9827                        SLCOC-0710-883-10  2010-10-07   \n",
      "9828                        SLCOC-1310-113-10  2010-10-13   \n",
      "9829                       6DTOC 0610 14 2010  2010-10-06   \n",
      "9830              SPOT REPORT DTD 08 OCT 2010  2010-10-08   \n",
      "9831                        EMCOC 1010 851 10  2010-10-10   \n",
      "9832                         OPN-2510-1975-10  2010-10-26   \n",
      "9833                         WMC-0810-07-2010  2010-10-08   \n",
      "9834                       1DC-0810-1877-2010  2010-10-08   \n",
      "9835                       1DC-0910-1879-2010  2010-10-09   \n",
      "9836                              WMC-1310-01  2010-10-13   \n",
      "9837                              WMC-1610-01  2010-10-17   \n",
      "9838                         1DC-2210-1943-10  2010-10-23   \n",
      "9839                              WMC-3010-02  2010-10-30   \n",
      "9840                          JFTC-2010-43-10  2010-10-21   \n",
      "\n",
      "                                         Summary Report  ES Killed  \\\n",
      "0     On 030620 Apr 2011, two (2) combat group under...          1   \n",
      "1     On 050615 Apr 2011, Pvt Arman S Dinero PN(M) o...          0   \n",
      "2     On 051520 Apr 2011, MBLT5 stationed at Brgy Tu...          0   \n",
      "3     On 16 Apr 2011, Operating elements of 4SRBN, F...          3   \n",
      "4     On 172302 Apr 2011, the Detachment of SOP-30, ...          0   \n",
      "5     Progress report to Journal item  NR: 13441Re E...          3   \n",
      "6     On 210846 Apr 2011, 10th Scout Ranger Company ...          0   \n",
      "7     On 270325 Apr 2011, elements of SOP2, MBLT2 le...          0   \n",
      "8     On 261220 Apr 2011, joint elements of MIG9 ope...          0   \n",
      "9     On 271645 Apr 2011, composite of 13SFC, 4SRBn ...          0   \n",
      "10    Progress Report to Journal Item Nr: 13553 dtd ...          0   \n",
      "11    On 291800 Apr 2011, a certain Nelson Lim aka B...          0   \n",
      "12    Progress Report to Journal Item Nr: 13536 dtd ...          0   \n",
      "13    On 131700 Apr 2011, a certain Ronilo A Biboso,...          0   \n",
      "14    On 030730 Apr 2011, an armed clash occured bet...          2   \n",
      "15    On 030820 Apr 2011, more or less 150 armed sup...          0   \n",
      "16    On 260800 Apr 2011, 26 Moro Islamic Liberation...          0   \n",
      "17    On 300115 Mar 2011, TSgt Ricardo C Navarra PA ...          0   \n",
      "18    On 141400 Apr 2011, team under 1LT CASOCO (INF...          0   \n",
      "19    On 19 Apr 2011, joint elements of 22MICO, 2MIB...          0   \n",
      "20    On 251725 Apr 2011, Municipal Mayor Teofisto G...          0   \n",
      "21    On 27 Apr 2011, Dinumpilan CAA Det based at br...          0   \n",
      "22    On 201500 Apr 2011, a certain Santiago Sandot ...          0   \n",
      "23    On 01 Apr 2011, a certain Jinky Yap, owner of ...          0   \n",
      "24    Progress Report to Journal Item Nr: 13293 dtd ...          0   \n",
      "25    On 011250 Apr 2011, elements of 67IB, 10iD, PA...          0   \n",
      "26    On 03 Apr 2011, PDT/A/25IB/10ID led by 2LT AGU...          0   \n",
      "27    On 06 Apr 2011, Cabadianan PB  led by Sgt Catu...          0   \n",
      "28    Progress report to Journal Item Nr 13293 dtd 0...          0   \n",
      "29    On 142325 Apr 2011, Sqd/A/57IB/602Bde under Cp...          0   \n",
      "...                                                 ...        ...   \n",
      "9811  On 250819 Oct 2010, an unident individual fire...          0   \n",
      "9812  On 250909 Oct 2010, an unidentified individual...          0   \n",
      "9813  On 251100 Oct 2010, Mobile of Tactival Command...          0   \n",
      "9814  On 252130 Oct 2010, a certain Nasroding Makil ...          0   \n",
      "9815  On 252330 Oct 2010, Burning incident transpire...          0   \n",
      "9816  On 26 Oct 2010, troops of CCoy, 35IB, 1ID, PA ...          0   \n",
      "9817  On 250630 Oct 2010, firefight ensued between t...          0   \n",
      "9818  On 26 Oct 2010, 1st Pltn and Command Group \"C\"...          0   \n",
      "9819  On 300130 Oct 2010, newly elected Brgy kagawad...          0   \n",
      "9820  On 201700 Oct 2010, Danilo Bandayos y Escrupol...          0   \n",
      "9821  On 19 Oct 2010, eight (8) Ricemill workers of ...          0   \n",
      "9822  On 182030 Oct 2010, One sec of BCoy, 81IB,unde...          0   \n",
      "9823  On 182106 Oct 2010, DRRO sqd of Salipsip Det, ...          0   \n",
      "9824  On 092110 Oct 2010, flash floods occurred in b...          0   \n",
      "9825  On 131730 Oct 2010, a landslide incident occur...          0   \n",
      "9826  On 250110 Oct 2010, joint Team from PPSC, PIB ...          0   \n",
      "9827  On 051400 Oct 2010, one (1) Platoon (-) of BCo...          0   \n",
      "9828  On 121600 Oct 2010, elements of A/83IB under 1...          0   \n",
      "9829  On 05 Oct 2010, Thirty (30) MNLF forces under ...          0   \n",
      "9830  On 08 Oct 2010, a Fil-Chinese businessman iden...          0   \n",
      "9831  On 092130 Oct 2010, MSg Obatay PA while at his...          0   \n",
      "9832  On 24 Oct 2010, a certain Marivic Magallanes S...          0   \n",
      "9833  On 071500 Oct 2010, a certain Ken Clifford Lao...          0   \n",
      "9834  On 081110 Oct 2010, one (1) Pltn (-), BCoy 65I...          0   \n",
      "9835  On 061115 Oct 2010, two (2) EP and two (2) per...          0   \n",
      "9836  On 081000 Oct 2010, Sgt Patrick C Manao PN(M) ...          0   \n",
      "9837  On 15 Oct 2010, a certain Rasbi Rabalun, 20 yr...          0   \n",
      "9838  On 22 Oct 2010, a certain Fely Bily Mateo run ...          0   \n",
      "9839  On 271100 Oct 2010, a certain Sonny Ingga, a r...          0   \n",
      "9840  On 16 Oct 2010, a passenger vessel identified ...          0   \n",
      "\n",
      "      ES Body Count  ES Captured  ES Surrendered  ES Apprehended  ES Arrested  \n",
      "0                 0            1               0               0            0  \n",
      "1                 0            0               0               0            0  \n",
      "2                 0            0               0               0            0  \n",
      "3                 0            0               0               0            0  \n",
      "4                 0            0               0               0            0  \n",
      "5                 0            0               0               0            0  \n",
      "6                 0            0               0               0            0  \n",
      "7                 0            0               0               0            0  \n",
      "8                 0            0               0               0            0  \n",
      "9                 0            0               0               0            0  \n",
      "10                0            0               0               0            0  \n",
      "11                0            0               0               0            0  \n",
      "12                0            0               0               0            0  \n",
      "13                0            0               0               0            0  \n",
      "14                0            0               0               0            0  \n",
      "15                0            0               0               0            0  \n",
      "16                0            0              26               0            0  \n",
      "17                0            0               0               0            0  \n",
      "18                0            0               0               0            0  \n",
      "19                0            0               0               0            0  \n",
      "20                0            0               0               0            0  \n",
      "21                0            0               0               0            0  \n",
      "22                0            0               0               0            0  \n",
      "23                0            0               0               0            0  \n",
      "24                0            0               0               0            0  \n",
      "25                0            0               0               0            0  \n",
      "26                0            0               0               0            0  \n",
      "27                0            0               0               0            0  \n",
      "28                0            0               0               0            0  \n",
      "29                0            0               0               0            0  \n",
      "...             ...          ...             ...             ...          ...  \n",
      "9811              0            0               0               0            0  \n",
      "9812              0            0               0               0            0  \n",
      "9813              0            0               0               0            0  \n",
      "9814              0            0               0               0            0  \n",
      "9815              0            0               0               0            0  \n",
      "9816              0            0               0               0            0  \n",
      "9817              0            0               0               0            0  \n",
      "9818              0            0               0               0            0  \n",
      "9819              0            0               0               0            0  \n",
      "9820              0            0               0               0            0  \n",
      "9821              0            0               0               0            0  \n",
      "9822              0            0               0               0            0  \n",
      "9823              0            0               0               0            0  \n",
      "9824              0            0               0               0            0  \n",
      "9825              0            0               0               0            0  \n",
      "9826              0            0               0               0            0  \n",
      "9827              0            0               0               0            0  \n",
      "9828              0            0               0               0            0  \n",
      "9829              0            0               0               0            0  \n",
      "9830              0            0               0               0            0  \n",
      "9831              0            0               0               0            0  \n",
      "9832              0            0               0               0            0  \n",
      "9833              0            0               0               0            0  \n",
      "9834              0            0               0               0            0  \n",
      "9835              0            0               0               0            0  \n",
      "9836              0            0               0               0            0  \n",
      "9837              0            0               0               0            0  \n",
      "9838              0            0               0               0            0  \n",
      "9839              0            0               0               0            0  \n",
      "9840              0            0               0               0            0  \n",
      "\n",
      "[9841 rows x 15 columns]\n"
     ]
    }
   ],
   "source": [
    "#Extract counts from the various subheadings and turn into new dataframe\n",
    "to_split = [\"Killed\", \"Body Count\", \"Captured\", \"Surrendered\", \"Apprehended\",  \"Arrested\"]\n",
    "hold_series = esoc_all_data_raw[\"Enemy Side\"].apply(nameCount, args = (to_split))\n",
    "hold_list = hold_series.tolist()\n",
    "to_add_cols = [\"ES Killed\", \"ES Body Count\", \"ES Captured\", \"ES Surrendered\", \"ES Apprehended\",  \"ES Arrested\"]\n",
    "hold_df = pd.DataFrame(hold_list, columns=to_add_cols)\n",
    "\n",
    "#Add new columns to analytics dataframe\n",
    "esoc_all_data_analytics = pd.concat([esoc_all_data_analytics, hold_df], axis=1)\n",
    "\n",
    "print esoc_all_data_analytics"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Government Side"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The government side column had 2 possible subheadings to include: WIA and KIA."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "     Journal Code Unified Command       Region                     Province  \\\n",
      "0           13312     WESTMINCOM          ARMM                     BASILAN    \n",
      "1           13338     WESTMINCOM          ARMM                        SULU    \n",
      "2           13355     WESTMINCOM          ARMM                        SULU    \n",
      "3           13441     WESTMINCOM          ARMM                    BASILAN     \n",
      "4           13459     WESTMINCOM          ARMM                        SULU    \n",
      "5           13469     WESTMINCOM          ARMM                     BASILAN    \n",
      "6           13482     WESTMINCOM          ARMM                    BASILAN     \n",
      "7           13536     WESTMINCOM          ARMM                        SULU    \n",
      "8           13537     WESTMINCOM          ARMM                     BASILAN    \n",
      "9           13543     WESTMINCOM          ARMM                     BASILAN    \n",
      "10          13553     WESTMINCOM          ARMM                     BASILAN    \n",
      "11          13571     WESTMINCOM          ARMM                        SULU    \n",
      "12          13573     WESTMINCOM          ARMM                        SULU    \n",
      "13          13429     EASTMINCOM    REGION XII             SOUTH COTABATO     \n",
      "14          13315     EASTMINCOM    REGION XII                    COTABATO    \n",
      "15          13316     EASTMINCOM          ARMM                MAGUINDANAO     \n",
      "16          13523     WESTMINCOM      REGION X               LANAO DEL SUR    \n",
      "17          13301         NOLCOM    REGION III                NUEVA ECIJA     \n",
      "18          13444         SOLCOM     REGION IV                     QUEZON     \n",
      "19          13476         SOLCOM   REGION IV-A                      LAGUNA    \n",
      "20          13526         SOLCOM   REGION IV-A                     ROMBLON    \n",
      "21          13548         SOLCOM      REGION V              CAMARINES SUR     \n",
      "22          13484        CENTCOM    REGION VII            NEGROS ORIENTAL     \n",
      "23          13293     EASTMINCOM    REGION XII                    COTABATO    \n",
      "24          13305     EASTMINCOM          ARMM                 MAGUINDANAO    \n",
      "25          13317     EASTMINCOM     REGION XI             DAVAO ORIENTAL     \n",
      "26          13341     EASTMINCOM     REGION XI  COMPOSTELA VALLEY PROVINCE    \n",
      "27          13356     EASTMINCOM     REGION XI             DAVAO DEL NORTE    \n",
      "28          13392     EASTMINCOM          ARMM                 MAGUINDANAO    \n",
      "29          13434     EASTMINCOM    REGION XII              NORTH COTABATO    \n",
      "...           ...             ...          ...                          ...   \n",
      "9811        11720     WESTMINCOM          ARMM                        SULU    \n",
      "9812        11721     WESTMINCOM          ARMM                        SULU    \n",
      "9813        11722     WESTMINCOM     REGION IX            LANAO DEL NORTE     \n",
      "9814        11723     WESTMINCOM      REGION X            LANAO DEL NORTE     \n",
      "9815        11731     WESTMINCOM    REGION XII                   COTABATO     \n",
      "9816        11760     WESTMINCOM      REGION X            LANAO DEL NORTE     \n",
      "9817        11768     WESTMINCOM      REGION X            LANAO DEL NORTE     \n",
      "9818        11785     WESTMINCOM          ARMM              LANAO DEL SUR     \n",
      "9819        11798     WESTMINCOM      REGION X         MISAMIS OCCIDENTAL     \n",
      "9820        11618        CENTCOM    REGION VII                       CEBU     \n",
      "9821        11576         NOLCOM    REGION III                 NEUVA ECIJA    \n",
      "9822        11588         NOLCOM    REGION III                NUEVA ECIJA     \n",
      "9823        11549         SOLCOM     REGION IV                     QUEZON     \n",
      "9824        11412     EASTMINCOM      REGION X            MISAMIS ORIENTAL    \n",
      "9825        11538     EASTMINCOM      REGION X                    BUKIDNON    \n",
      "9826        11738         NOLCOM    REGION III                     TARLAC     \n",
      "9827        11368         SOLCOM   REGION IV-A                       RIZAL    \n",
      "9828        11477         SOLCOM      REGION V                 CATANDUANES    \n",
      "9829        11362     EASTMINCOM    REGION XII                   COTABATO     \n",
      "9830        11395     EASTMINCOM    REGION XII               NOTH COTABATO    \n",
      "9831        11423     EASTMINCOM        CARAGA            SURIGAO DEL SUR     \n",
      "9832        11685     EASTMINCOM      REGION X                   BUKIDNON     \n",
      "9833        11394     WESTMINCOM          ARMM                        SULU    \n",
      "9834        11398     WESTMINCOM     REGION XI                 MARAWI CITY    \n",
      "9835        11414     WESTMINCOM      REGION X             LANAO DEL NORTE    \n",
      "9836        11464     WESTMINCOM          ARMM                    BASILAN     \n",
      "9837        11513     WESTMINCOM          ARMM                     BASILAN    \n",
      "9838        11624     WESTMINCOM     REGION IX                   ZAMBOANGA    \n",
      "9839        11791     WESTMINCOM          ARMM                     BASILAN    \n",
      "9840        11573     WESTMINCOM          ARMM                        SULU    \n",
      "\n",
      "                      Type of Engagement    Reference  \\\n",
      "0                              ENCOUNTER  WESTMINCOM    \n",
      "1                            LIQUIDATION  WESTMINCOM    \n",
      "2                             HARASSMENT  WESTMINCOM    \n",
      "3                              ENCOUNTER  WESTMINCOM    \n",
      "4                             HARASSMENT       ISAFP    \n",
      "5                              ENCOUNTER  WESTMINCOM    \n",
      "6                              ENCOUNTER     PNP-NOC    \n",
      "7                              ENCOUNTER       ISAFP    \n",
      "8                           APPREHENSION  WESTMINCOM    \n",
      "9            SEIZURE OF BOAT USED BY ASG  WESTMINCOM    \n",
      "10                             ENCOUNTER  WESTMINCOM    \n",
      "11                            KIDNAPPING  WESTMINCOM    \n",
      "12                             ENCOUNTER  WESTMINCOM    \n",
      "13                          APPREHENSION  EASTMINCOM    \n",
      "14                           ARMED CLASH     6ID, PA    \n",
      "15                           ARMED CLASH     6ID, PA    \n",
      "16                             SURRENDER  WESTMINCOM    \n",
      "17                        RECOVERY OF FA      NOLCOM    \n",
      "18                        RECOVERY OF FA      SOLCOM    \n",
      "19                       RECOVERY OF IED      SOLCOM    \n",
      "20                                AMBUSH      SOLCOM    \n",
      "21                            HARASSMENT      SOLCOM    \n",
      "22                             SURRENDER     CENTCOM    \n",
      "23                            KIDNAPPING  EASTMINCOM    \n",
      "24                             ABDUCTION   EMC/ISAFP    \n",
      "25                      DISCOVERY OF IED  EASTMINCOM    \n",
      "26               DISCOVERY OF ENEMY CAMP  EASTMINCOM    \n",
      "27                            HARASSMENT  EASTMINCOM    \n",
      "28    RELEASE OF HOSTAGES/KIDNAP VICTIMS  EASTMINCOM    \n",
      "29                            HARASSMENT  EASTMINCOM    \n",
      "...                                  ...          ...   \n",
      "9811         ELECTION VIOLATION (GENERAL          PN    \n",
      "9812         ELECTION VIOLATION (GENERAL          PN    \n",
      "9813                            SHOOTING         1ID    \n",
      "9814                             BURNING         1ID    \n",
      "9815                             BURNING         6ID    \n",
      "9816                      RECOVERY OF FA         1ID    \n",
      "9817                         ARMED CLASH         1ID    \n",
      "9818                      RECOVERY OF FA  WESTMINCOM    \n",
      "9819                            SHOOTING         PNP    \n",
      "9820                        APPREHENSION      PAF A2    \n",
      "9821                            DROWNING      NOLCOM    \n",
      "9822                             TYPHOON      NOLCOM    \n",
      "9823                          SEA MISHAP      SOLCOM    \n",
      "9824                         FLASH FLOOD  EASTMINCOM    \n",
      "9825                           LANDSLIDE     4ID, PA    \n",
      "9826                      RECOVERY OF FA      NOLCOM    \n",
      "9827                     ILLEGAL LOGGING      SOLCOM    \n",
      "9828                     ILLEGAL LOGGING      SOLCOM    \n",
      "9829                         ARMED CLASH         6ID    \n",
      "9830                           ABDUCTION       ISAFP    \n",
      "9831                   ACCIDENT (GENERAL  EASTMINCOM    \n",
      "9832                            SHOOTING     4ID, PA    \n",
      "9833                          KIDNAPPING  WESTMINCOM    \n",
      "9834                                RAID     1ID, PA    \n",
      "9835                     ILLEGAL LOGGING     1ID, PA    \n",
      "9836              DETONATING OF RPG AMMO  WESTMINCOM    \n",
      "9837                    GRENADE THROWING  WESTMINCOM    \n",
      "9838                            RUN AMOK     1ID, PA    \n",
      "9839                            SHOOTING  WESTMINCOM    \n",
      "9840                   RESCUE OPERATIONS  WESTMINCOM    \n",
      "\n",
      "                                     Report RN       Date  \\\n",
      "0                                 WMC-0104-03  2011-04-03   \n",
      "1                              WMC-0504-02-11  2011-04-05   \n",
      "2                                 WMC-0704-03  2011-04-07   \n",
      "3     WMC-1604-01 / PNP NOC RPT DTD 16 APR 11  2011-04-16   \n",
      "4                         STL DTD 18-APR-2011  2011-04-18   \n",
      "5                                 WMC-1904-02  2011-04-18   \n",
      "6       SIGNIFICANT INCIDENT REPORT 042111-01  2011-04-21   \n",
      "7                                         STL  2011-04-27   \n",
      "8                                 WMC-2704-03  2011-04-27   \n",
      "9                                 WMC-2704-06  2011-04-27   \n",
      "10                                WMC-2994-01  2011-04-29   \n",
      "11                                WMC-3004-01  2011-04-30   \n",
      "12                                WMC-3004-03  2011-04-30   \n",
      "13                           EMCOC-1404667-11  2011-04-14   \n",
      "14                        6DTOC-0304-180-2011  2011-04-04   \n",
      "15                        6DTOC-0304-181-2011  2011-04-04   \n",
      "16                                WMC-2604-03  2011-04-26   \n",
      "17                           CN-0204-628-2011  2011-04-02   \n",
      "18                          SLCOC-1604-233-11  2011-04-17   \n",
      "19                             SLCOC-20-04-11  2011-04-20   \n",
      "20                          SLCOC-2604-259-11  2011-04-26   \n",
      "21                          SLCOC-2804-263-11  2011-04-28   \n",
      "22                               COC-2011-164  2011-04-21   \n",
      "23                          EMCOC-0104-570-11  2011-04-02   \n",
      "24                      STL/EMCOC-0204-581-11  2011-04-02   \n",
      "25                          EMCOC-0304-584-11  2011-04-04   \n",
      "26                          EMCOC-0504-605-11  2011-04-06   \n",
      "27                          EMCOC-0704-718-11  2011-04-07   \n",
      "28                          EMCOC-1004-641-11  2011-04-10   \n",
      "29                          EMCOC-1504-672-11  2011-04-15   \n",
      "...                                        ...        ...   \n",
      "9811                             CDO-1010-113  2010-10-25   \n",
      "9812                             CDO-1010-112  2010-10-25   \n",
      "9813                     6D01-3-TCP-2510-2010  2010-10-26   \n",
      "9814                                      1DC  2010-10-26   \n",
      "9815                           6DTOC-104-2010  2010-10-26   \n",
      "9816                       1DC-2610-2014-2010  2010-10-26   \n",
      "9817                       1DC-2610-2016-2010  2010-10-26   \n",
      "9818                              WMC 2910 01  2010-10-29   \n",
      "9819                       DAILY NEMAC REPORT  2010-10-31   \n",
      "9820                                   SITREP  2010-10-22   \n",
      "9821                           CN-356-2010-10  2010-10-20   \n",
      "9822                           CN-361-2010-10  2010-10-20   \n",
      "9823                        SLCOC 1810 930 10  2010-10-18   \n",
      "9824                        EMCOC-0910-841-10  2010-10-09   \n",
      "9825                       DRO-1710-1903-2010  2010-10-17   \n",
      "9826                         NLOC-404-2610-10  2010-10-27   \n",
      "9827                        SLCOC-0710-883-10  2010-10-07   \n",
      "9828                        SLCOC-1310-113-10  2010-10-13   \n",
      "9829                       6DTOC 0610 14 2010  2010-10-06   \n",
      "9830              SPOT REPORT DTD 08 OCT 2010  2010-10-08   \n",
      "9831                        EMCOC 1010 851 10  2010-10-10   \n",
      "9832                         OPN-2510-1975-10  2010-10-26   \n",
      "9833                         WMC-0810-07-2010  2010-10-08   \n",
      "9834                       1DC-0810-1877-2010  2010-10-08   \n",
      "9835                       1DC-0910-1879-2010  2010-10-09   \n",
      "9836                              WMC-1310-01  2010-10-13   \n",
      "9837                              WMC-1610-01  2010-10-17   \n",
      "9838                         1DC-2210-1943-10  2010-10-23   \n",
      "9839                              WMC-3010-02  2010-10-30   \n",
      "9840                          JFTC-2010-43-10  2010-10-21   \n",
      "\n",
      "                                         Summary Report  ES Killed  \\\n",
      "0     On 030620 Apr 2011, two (2) combat group under...          1   \n",
      "1     On 050615 Apr 2011, Pvt Arman S Dinero PN(M) o...          0   \n",
      "2     On 051520 Apr 2011, MBLT5 stationed at Brgy Tu...          0   \n",
      "3     On 16 Apr 2011, Operating elements of 4SRBN, F...          3   \n",
      "4     On 172302 Apr 2011, the Detachment of SOP-30, ...          0   \n",
      "5     Progress report to Journal item  NR: 13441Re E...          3   \n",
      "6     On 210846 Apr 2011, 10th Scout Ranger Company ...          0   \n",
      "7     On 270325 Apr 2011, elements of SOP2, MBLT2 le...          0   \n",
      "8     On 261220 Apr 2011, joint elements of MIG9 ope...          0   \n",
      "9     On 271645 Apr 2011, composite of 13SFC, 4SRBn ...          0   \n",
      "10    Progress Report to Journal Item Nr: 13553 dtd ...          0   \n",
      "11    On 291800 Apr 2011, a certain Nelson Lim aka B...          0   \n",
      "12    Progress Report to Journal Item Nr: 13536 dtd ...          0   \n",
      "13    On 131700 Apr 2011, a certain Ronilo A Biboso,...          0   \n",
      "14    On 030730 Apr 2011, an armed clash occured bet...          2   \n",
      "15    On 030820 Apr 2011, more or less 150 armed sup...          0   \n",
      "16    On 260800 Apr 2011, 26 Moro Islamic Liberation...          0   \n",
      "17    On 300115 Mar 2011, TSgt Ricardo C Navarra PA ...          0   \n",
      "18    On 141400 Apr 2011, team under 1LT CASOCO (INF...          0   \n",
      "19    On 19 Apr 2011, joint elements of 22MICO, 2MIB...          0   \n",
      "20    On 251725 Apr 2011, Municipal Mayor Teofisto G...          0   \n",
      "21    On 27 Apr 2011, Dinumpilan CAA Det based at br...          0   \n",
      "22    On 201500 Apr 2011, a certain Santiago Sandot ...          0   \n",
      "23    On 01 Apr 2011, a certain Jinky Yap, owner of ...          0   \n",
      "24    Progress Report to Journal Item Nr: 13293 dtd ...          0   \n",
      "25    On 011250 Apr 2011, elements of 67IB, 10iD, PA...          0   \n",
      "26    On 03 Apr 2011, PDT/A/25IB/10ID led by 2LT AGU...          0   \n",
      "27    On 06 Apr 2011, Cabadianan PB  led by Sgt Catu...          0   \n",
      "28    Progress report to Journal Item Nr 13293 dtd 0...          0   \n",
      "29    On 142325 Apr 2011, Sqd/A/57IB/602Bde under Cp...          0   \n",
      "...                                                 ...        ...   \n",
      "9811  On 250819 Oct 2010, an unident individual fire...          0   \n",
      "9812  On 250909 Oct 2010, an unidentified individual...          0   \n",
      "9813  On 251100 Oct 2010, Mobile of Tactival Command...          0   \n",
      "9814  On 252130 Oct 2010, a certain Nasroding Makil ...          0   \n",
      "9815  On 252330 Oct 2010, Burning incident transpire...          0   \n",
      "9816  On 26 Oct 2010, troops of CCoy, 35IB, 1ID, PA ...          0   \n",
      "9817  On 250630 Oct 2010, firefight ensued between t...          0   \n",
      "9818  On 26 Oct 2010, 1st Pltn and Command Group \"C\"...          0   \n",
      "9819  On 300130 Oct 2010, newly elected Brgy kagawad...          0   \n",
      "9820  On 201700 Oct 2010, Danilo Bandayos y Escrupol...          0   \n",
      "9821  On 19 Oct 2010, eight (8) Ricemill workers of ...          0   \n",
      "9822  On 182030 Oct 2010, One sec of BCoy, 81IB,unde...          0   \n",
      "9823  On 182106 Oct 2010, DRRO sqd of Salipsip Det, ...          0   \n",
      "9824  On 092110 Oct 2010, flash floods occurred in b...          0   \n",
      "9825  On 131730 Oct 2010, a landslide incident occur...          0   \n",
      "9826  On 250110 Oct 2010, joint Team from PPSC, PIB ...          0   \n",
      "9827  On 051400 Oct 2010, one (1) Platoon (-) of BCo...          0   \n",
      "9828  On 121600 Oct 2010, elements of A/83IB under 1...          0   \n",
      "9829  On 05 Oct 2010, Thirty (30) MNLF forces under ...          0   \n",
      "9830  On 08 Oct 2010, a Fil-Chinese businessman iden...          0   \n",
      "9831  On 092130 Oct 2010, MSg Obatay PA while at his...          0   \n",
      "9832  On 24 Oct 2010, a certain Marivic Magallanes S...          0   \n",
      "9833  On 071500 Oct 2010, a certain Ken Clifford Lao...          0   \n",
      "9834  On 081110 Oct 2010, one (1) Pltn (-), BCoy 65I...          0   \n",
      "9835  On 061115 Oct 2010, two (2) EP and two (2) per...          0   \n",
      "9836  On 081000 Oct 2010, Sgt Patrick C Manao PN(M) ...          0   \n",
      "9837  On 15 Oct 2010, a certain Rasbi Rabalun, 20 yr...          0   \n",
      "9838  On 22 Oct 2010, a certain Fely Bily Mateo run ...          0   \n",
      "9839  On 271100 Oct 2010, a certain Sonny Ingga, a r...          0   \n",
      "9840  On 16 Oct 2010, a passenger vessel identified ...          0   \n",
      "\n",
      "      ES Body Count  ES Captured  ES Surrendered  ES Apprehended  ES Arrested  \\\n",
      "0                 0            1               0               0            0   \n",
      "1                 0            0               0               0            0   \n",
      "2                 0            0               0               0            0   \n",
      "3                 0            0               0               0            0   \n",
      "4                 0            0               0               0            0   \n",
      "5                 0            0               0               0            0   \n",
      "6                 0            0               0               0            0   \n",
      "7                 0            0               0               0            0   \n",
      "8                 0            0               0               0            0   \n",
      "9                 0            0               0               0            0   \n",
      "10                0            0               0               0            0   \n",
      "11                0            0               0               0            0   \n",
      "12                0            0               0               0            0   \n",
      "13                0            0               0               0            0   \n",
      "14                0            0               0               0            0   \n",
      "15                0            0               0               0            0   \n",
      "16                0            0              26               0            0   \n",
      "17                0            0               0               0            0   \n",
      "18                0            0               0               0            0   \n",
      "19                0            0               0               0            0   \n",
      "20                0            0               0               0            0   \n",
      "21                0            0               0               0            0   \n",
      "22                0            0               0               0            0   \n",
      "23                0            0               0               0            0   \n",
      "24                0            0               0               0            0   \n",
      "25                0            0               0               0            0   \n",
      "26                0            0               0               0            0   \n",
      "27                0            0               0               0            0   \n",
      "28                0            0               0               0            0   \n",
      "29                0            0               0               0            0   \n",
      "...             ...          ...             ...             ...          ...   \n",
      "9811              0            0               0               0            0   \n",
      "9812              0            0               0               0            0   \n",
      "9813              0            0               0               0            0   \n",
      "9814              0            0               0               0            0   \n",
      "9815              0            0               0               0            0   \n",
      "9816              0            0               0               0            0   \n",
      "9817              0            0               0               0            0   \n",
      "9818              0            0               0               0            0   \n",
      "9819              0            0               0               0            0   \n",
      "9820              0            0               0               0            0   \n",
      "9821              0            0               0               0            0   \n",
      "9822              0            0               0               0            0   \n",
      "9823              0            0               0               0            0   \n",
      "9824              0            0               0               0            0   \n",
      "9825              0            0               0               0            0   \n",
      "9826              0            0               0               0            0   \n",
      "9827              0            0               0               0            0   \n",
      "9828              0            0               0               0            0   \n",
      "9829              0            0               0               0            0   \n",
      "9830              0            0               0               0            0   \n",
      "9831              0            0               0               0            0   \n",
      "9832              0            0               0               0            0   \n",
      "9833              0            0               0               0            0   \n",
      "9834              0            0               0               0            0   \n",
      "9835              0            0               0               0            0   \n",
      "9836              0            0               0               0            0   \n",
      "9837              0            0               0               0            0   \n",
      "9838              0            0               0               0            0   \n",
      "9839              0            0               0               0            0   \n",
      "9840              0            0               0               0            0   \n",
      "\n",
      "      GS WIA  GS KIA  \n",
      "0          2       0  \n",
      "1          0       1  \n",
      "2          0       0  \n",
      "3          1       0  \n",
      "4          1       0  \n",
      "5          4       0  \n",
      "6          0       0  \n",
      "7          0       0  \n",
      "8          0       0  \n",
      "9          0       0  \n",
      "10         3       0  \n",
      "11         0       0  \n",
      "12         3       0  \n",
      "13         0       0  \n",
      "14         0       0  \n",
      "15         0       0  \n",
      "16         0       0  \n",
      "17         0       0  \n",
      "18         0       0  \n",
      "19         0       0  \n",
      "20         0       0  \n",
      "21         0       0  \n",
      "22         0       0  \n",
      "23         0       0  \n",
      "24         0       0  \n",
      "25         0       0  \n",
      "26         0       0  \n",
      "27         0       0  \n",
      "28         0       0  \n",
      "29         0       0  \n",
      "...      ...     ...  \n",
      "9811       0       0  \n",
      "9812       0       0  \n",
      "9813       0       0  \n",
      "9814       0       0  \n",
      "9815       0       0  \n",
      "9816       0       0  \n",
      "9817       0       0  \n",
      "9818       0       0  \n",
      "9819       0       0  \n",
      "9820       0       0  \n",
      "9821       0       0  \n",
      "9822       0       0  \n",
      "9823       0       0  \n",
      "9824       0       0  \n",
      "9825       0       0  \n",
      "9826       0       0  \n",
      "9827       0       0  \n",
      "9828       0       0  \n",
      "9829       0       0  \n",
      "9830       0       0  \n",
      "9831       0       1  \n",
      "9832       0       0  \n",
      "9833       0       0  \n",
      "9834       0       0  \n",
      "9835       0       0  \n",
      "9836       0       0  \n",
      "9837       0       0  \n",
      "9838       0       0  \n",
      "9839       0       0  \n",
      "9840       0       0  \n",
      "\n",
      "[9841 rows x 17 columns]\n"
     ]
    }
   ],
   "source": [
    "#Extract counts from the various subheadings and turn into new dataframe\n",
    "to_split = [\"WIA\", \"KIA\"]\n",
    "hold_series = esoc_all_data_raw[\"Government Side\"].apply(nameCount, args = (to_split))\n",
    "hold_list = hold_series.tolist()\n",
    "to_add_cols = [\"GS WIA\", \"GS KIA\"]\n",
    "hold_df = pd.DataFrame(hold_list, columns=to_add_cols)\n",
    "\n",
    "#Add new columns to analytics dataframe\n",
    "esoc_all_data_analytics = pd.concat([esoc_all_data_analytics, hold_df], axis=1)\n",
    "\n",
    "print esoc_all_data_analytics"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Civilian Side"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The enemy side column had 6 possible subheadings to include: Apprehended, Rescued, Killed, Wounded, Missing, DOA."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "     Journal Code Unified Command       Region                     Province  \\\n",
      "0           13312     WESTMINCOM          ARMM                     BASILAN    \n",
      "1           13338     WESTMINCOM          ARMM                        SULU    \n",
      "2           13355     WESTMINCOM          ARMM                        SULU    \n",
      "3           13441     WESTMINCOM          ARMM                    BASILAN     \n",
      "4           13459     WESTMINCOM          ARMM                        SULU    \n",
      "5           13469     WESTMINCOM          ARMM                     BASILAN    \n",
      "6           13482     WESTMINCOM          ARMM                    BASILAN     \n",
      "7           13536     WESTMINCOM          ARMM                        SULU    \n",
      "8           13537     WESTMINCOM          ARMM                     BASILAN    \n",
      "9           13543     WESTMINCOM          ARMM                     BASILAN    \n",
      "10          13553     WESTMINCOM          ARMM                     BASILAN    \n",
      "11          13571     WESTMINCOM          ARMM                        SULU    \n",
      "12          13573     WESTMINCOM          ARMM                        SULU    \n",
      "13          13429     EASTMINCOM    REGION XII             SOUTH COTABATO     \n",
      "14          13315     EASTMINCOM    REGION XII                    COTABATO    \n",
      "15          13316     EASTMINCOM          ARMM                MAGUINDANAO     \n",
      "16          13523     WESTMINCOM      REGION X               LANAO DEL SUR    \n",
      "17          13301         NOLCOM    REGION III                NUEVA ECIJA     \n",
      "18          13444         SOLCOM     REGION IV                     QUEZON     \n",
      "19          13476         SOLCOM   REGION IV-A                      LAGUNA    \n",
      "20          13526         SOLCOM   REGION IV-A                     ROMBLON    \n",
      "21          13548         SOLCOM      REGION V              CAMARINES SUR     \n",
      "22          13484        CENTCOM    REGION VII            NEGROS ORIENTAL     \n",
      "23          13293     EASTMINCOM    REGION XII                    COTABATO    \n",
      "24          13305     EASTMINCOM          ARMM                 MAGUINDANAO    \n",
      "25          13317     EASTMINCOM     REGION XI             DAVAO ORIENTAL     \n",
      "26          13341     EASTMINCOM     REGION XI  COMPOSTELA VALLEY PROVINCE    \n",
      "27          13356     EASTMINCOM     REGION XI             DAVAO DEL NORTE    \n",
      "28          13392     EASTMINCOM          ARMM                 MAGUINDANAO    \n",
      "29          13434     EASTMINCOM    REGION XII              NORTH COTABATO    \n",
      "...           ...             ...          ...                          ...   \n",
      "9811        11720     WESTMINCOM          ARMM                        SULU    \n",
      "9812        11721     WESTMINCOM          ARMM                        SULU    \n",
      "9813        11722     WESTMINCOM     REGION IX            LANAO DEL NORTE     \n",
      "9814        11723     WESTMINCOM      REGION X            LANAO DEL NORTE     \n",
      "9815        11731     WESTMINCOM    REGION XII                   COTABATO     \n",
      "9816        11760     WESTMINCOM      REGION X            LANAO DEL NORTE     \n",
      "9817        11768     WESTMINCOM      REGION X            LANAO DEL NORTE     \n",
      "9818        11785     WESTMINCOM          ARMM              LANAO DEL SUR     \n",
      "9819        11798     WESTMINCOM      REGION X         MISAMIS OCCIDENTAL     \n",
      "9820        11618        CENTCOM    REGION VII                       CEBU     \n",
      "9821        11576         NOLCOM    REGION III                 NEUVA ECIJA    \n",
      "9822        11588         NOLCOM    REGION III                NUEVA ECIJA     \n",
      "9823        11549         SOLCOM     REGION IV                     QUEZON     \n",
      "9824        11412     EASTMINCOM      REGION X            MISAMIS ORIENTAL    \n",
      "9825        11538     EASTMINCOM      REGION X                    BUKIDNON    \n",
      "9826        11738         NOLCOM    REGION III                     TARLAC     \n",
      "9827        11368         SOLCOM   REGION IV-A                       RIZAL    \n",
      "9828        11477         SOLCOM      REGION V                 CATANDUANES    \n",
      "9829        11362     EASTMINCOM    REGION XII                   COTABATO     \n",
      "9830        11395     EASTMINCOM    REGION XII               NOTH COTABATO    \n",
      "9831        11423     EASTMINCOM        CARAGA            SURIGAO DEL SUR     \n",
      "9832        11685     EASTMINCOM      REGION X                   BUKIDNON     \n",
      "9833        11394     WESTMINCOM          ARMM                        SULU    \n",
      "9834        11398     WESTMINCOM     REGION XI                 MARAWI CITY    \n",
      "9835        11414     WESTMINCOM      REGION X             LANAO DEL NORTE    \n",
      "9836        11464     WESTMINCOM          ARMM                    BASILAN     \n",
      "9837        11513     WESTMINCOM          ARMM                     BASILAN    \n",
      "9838        11624     WESTMINCOM     REGION IX                   ZAMBOANGA    \n",
      "9839        11791     WESTMINCOM          ARMM                     BASILAN    \n",
      "9840        11573     WESTMINCOM          ARMM                        SULU    \n",
      "\n",
      "                      Type of Engagement    Reference  \\\n",
      "0                              ENCOUNTER  WESTMINCOM    \n",
      "1                            LIQUIDATION  WESTMINCOM    \n",
      "2                             HARASSMENT  WESTMINCOM    \n",
      "3                              ENCOUNTER  WESTMINCOM    \n",
      "4                             HARASSMENT       ISAFP    \n",
      "5                              ENCOUNTER  WESTMINCOM    \n",
      "6                              ENCOUNTER     PNP-NOC    \n",
      "7                              ENCOUNTER       ISAFP    \n",
      "8                           APPREHENSION  WESTMINCOM    \n",
      "9            SEIZURE OF BOAT USED BY ASG  WESTMINCOM    \n",
      "10                             ENCOUNTER  WESTMINCOM    \n",
      "11                            KIDNAPPING  WESTMINCOM    \n",
      "12                             ENCOUNTER  WESTMINCOM    \n",
      "13                          APPREHENSION  EASTMINCOM    \n",
      "14                           ARMED CLASH     6ID, PA    \n",
      "15                           ARMED CLASH     6ID, PA    \n",
      "16                             SURRENDER  WESTMINCOM    \n",
      "17                        RECOVERY OF FA      NOLCOM    \n",
      "18                        RECOVERY OF FA      SOLCOM    \n",
      "19                       RECOVERY OF IED      SOLCOM    \n",
      "20                                AMBUSH      SOLCOM    \n",
      "21                            HARASSMENT      SOLCOM    \n",
      "22                             SURRENDER     CENTCOM    \n",
      "23                            KIDNAPPING  EASTMINCOM    \n",
      "24                             ABDUCTION   EMC/ISAFP    \n",
      "25                      DISCOVERY OF IED  EASTMINCOM    \n",
      "26               DISCOVERY OF ENEMY CAMP  EASTMINCOM    \n",
      "27                            HARASSMENT  EASTMINCOM    \n",
      "28    RELEASE OF HOSTAGES/KIDNAP VICTIMS  EASTMINCOM    \n",
      "29                            HARASSMENT  EASTMINCOM    \n",
      "...                                  ...          ...   \n",
      "9811         ELECTION VIOLATION (GENERAL          PN    \n",
      "9812         ELECTION VIOLATION (GENERAL          PN    \n",
      "9813                            SHOOTING         1ID    \n",
      "9814                             BURNING         1ID    \n",
      "9815                             BURNING         6ID    \n",
      "9816                      RECOVERY OF FA         1ID    \n",
      "9817                         ARMED CLASH         1ID    \n",
      "9818                      RECOVERY OF FA  WESTMINCOM    \n",
      "9819                            SHOOTING         PNP    \n",
      "9820                        APPREHENSION      PAF A2    \n",
      "9821                            DROWNING      NOLCOM    \n",
      "9822                             TYPHOON      NOLCOM    \n",
      "9823                          SEA MISHAP      SOLCOM    \n",
      "9824                         FLASH FLOOD  EASTMINCOM    \n",
      "9825                           LANDSLIDE     4ID, PA    \n",
      "9826                      RECOVERY OF FA      NOLCOM    \n",
      "9827                     ILLEGAL LOGGING      SOLCOM    \n",
      "9828                     ILLEGAL LOGGING      SOLCOM    \n",
      "9829                         ARMED CLASH         6ID    \n",
      "9830                           ABDUCTION       ISAFP    \n",
      "9831                   ACCIDENT (GENERAL  EASTMINCOM    \n",
      "9832                            SHOOTING     4ID, PA    \n",
      "9833                          KIDNAPPING  WESTMINCOM    \n",
      "9834                                RAID     1ID, PA    \n",
      "9835                     ILLEGAL LOGGING     1ID, PA    \n",
      "9836              DETONATING OF RPG AMMO  WESTMINCOM    \n",
      "9837                    GRENADE THROWING  WESTMINCOM    \n",
      "9838                            RUN AMOK     1ID, PA    \n",
      "9839                            SHOOTING  WESTMINCOM    \n",
      "9840                   RESCUE OPERATIONS  WESTMINCOM    \n",
      "\n",
      "                                     Report RN       Date  \\\n",
      "0                                 WMC-0104-03  2011-04-03   \n",
      "1                              WMC-0504-02-11  2011-04-05   \n",
      "2                                 WMC-0704-03  2011-04-07   \n",
      "3     WMC-1604-01 / PNP NOC RPT DTD 16 APR 11  2011-04-16   \n",
      "4                         STL DTD 18-APR-2011  2011-04-18   \n",
      "5                                 WMC-1904-02  2011-04-18   \n",
      "6       SIGNIFICANT INCIDENT REPORT 042111-01  2011-04-21   \n",
      "7                                         STL  2011-04-27   \n",
      "8                                 WMC-2704-03  2011-04-27   \n",
      "9                                 WMC-2704-06  2011-04-27   \n",
      "10                                WMC-2994-01  2011-04-29   \n",
      "11                                WMC-3004-01  2011-04-30   \n",
      "12                                WMC-3004-03  2011-04-30   \n",
      "13                           EMCOC-1404667-11  2011-04-14   \n",
      "14                        6DTOC-0304-180-2011  2011-04-04   \n",
      "15                        6DTOC-0304-181-2011  2011-04-04   \n",
      "16                                WMC-2604-03  2011-04-26   \n",
      "17                           CN-0204-628-2011  2011-04-02   \n",
      "18                          SLCOC-1604-233-11  2011-04-17   \n",
      "19                             SLCOC-20-04-11  2011-04-20   \n",
      "20                          SLCOC-2604-259-11  2011-04-26   \n",
      "21                          SLCOC-2804-263-11  2011-04-28   \n",
      "22                               COC-2011-164  2011-04-21   \n",
      "23                          EMCOC-0104-570-11  2011-04-02   \n",
      "24                      STL/EMCOC-0204-581-11  2011-04-02   \n",
      "25                          EMCOC-0304-584-11  2011-04-04   \n",
      "26                          EMCOC-0504-605-11  2011-04-06   \n",
      "27                          EMCOC-0704-718-11  2011-04-07   \n",
      "28                          EMCOC-1004-641-11  2011-04-10   \n",
      "29                          EMCOC-1504-672-11  2011-04-15   \n",
      "...                                        ...        ...   \n",
      "9811                             CDO-1010-113  2010-10-25   \n",
      "9812                             CDO-1010-112  2010-10-25   \n",
      "9813                     6D01-3-TCP-2510-2010  2010-10-26   \n",
      "9814                                      1DC  2010-10-26   \n",
      "9815                           6DTOC-104-2010  2010-10-26   \n",
      "9816                       1DC-2610-2014-2010  2010-10-26   \n",
      "9817                       1DC-2610-2016-2010  2010-10-26   \n",
      "9818                              WMC 2910 01  2010-10-29   \n",
      "9819                       DAILY NEMAC REPORT  2010-10-31   \n",
      "9820                                   SITREP  2010-10-22   \n",
      "9821                           CN-356-2010-10  2010-10-20   \n",
      "9822                           CN-361-2010-10  2010-10-20   \n",
      "9823                        SLCOC 1810 930 10  2010-10-18   \n",
      "9824                        EMCOC-0910-841-10  2010-10-09   \n",
      "9825                       DRO-1710-1903-2010  2010-10-17   \n",
      "9826                         NLOC-404-2610-10  2010-10-27   \n",
      "9827                        SLCOC-0710-883-10  2010-10-07   \n",
      "9828                        SLCOC-1310-113-10  2010-10-13   \n",
      "9829                       6DTOC 0610 14 2010  2010-10-06   \n",
      "9830              SPOT REPORT DTD 08 OCT 2010  2010-10-08   \n",
      "9831                        EMCOC 1010 851 10  2010-10-10   \n",
      "9832                         OPN-2510-1975-10  2010-10-26   \n",
      "9833                         WMC-0810-07-2010  2010-10-08   \n",
      "9834                       1DC-0810-1877-2010  2010-10-08   \n",
      "9835                       1DC-0910-1879-2010  2010-10-09   \n",
      "9836                              WMC-1310-01  2010-10-13   \n",
      "9837                              WMC-1610-01  2010-10-17   \n",
      "9838                         1DC-2210-1943-10  2010-10-23   \n",
      "9839                              WMC-3010-02  2010-10-30   \n",
      "9840                          JFTC-2010-43-10  2010-10-21   \n",
      "\n",
      "                                         Summary Report  ES Killed   ...    \\\n",
      "0     On 030620 Apr 2011, two (2) combat group under...          1   ...     \n",
      "1     On 050615 Apr 2011, Pvt Arman S Dinero PN(M) o...          0   ...     \n",
      "2     On 051520 Apr 2011, MBLT5 stationed at Brgy Tu...          0   ...     \n",
      "3     On 16 Apr 2011, Operating elements of 4SRBN, F...          3   ...     \n",
      "4     On 172302 Apr 2011, the Detachment of SOP-30, ...          0   ...     \n",
      "5     Progress report to Journal item  NR: 13441Re E...          3   ...     \n",
      "6     On 210846 Apr 2011, 10th Scout Ranger Company ...          0   ...     \n",
      "7     On 270325 Apr 2011, elements of SOP2, MBLT2 le...          0   ...     \n",
      "8     On 261220 Apr 2011, joint elements of MIG9 ope...          0   ...     \n",
      "9     On 271645 Apr 2011, composite of 13SFC, 4SRBn ...          0   ...     \n",
      "10    Progress Report to Journal Item Nr: 13553 dtd ...          0   ...     \n",
      "11    On 291800 Apr 2011, a certain Nelson Lim aka B...          0   ...     \n",
      "12    Progress Report to Journal Item Nr: 13536 dtd ...          0   ...     \n",
      "13    On 131700 Apr 2011, a certain Ronilo A Biboso,...          0   ...     \n",
      "14    On 030730 Apr 2011, an armed clash occured bet...          2   ...     \n",
      "15    On 030820 Apr 2011, more or less 150 armed sup...          0   ...     \n",
      "16    On 260800 Apr 2011, 26 Moro Islamic Liberation...          0   ...     \n",
      "17    On 300115 Mar 2011, TSgt Ricardo C Navarra PA ...          0   ...     \n",
      "18    On 141400 Apr 2011, team under 1LT CASOCO (INF...          0   ...     \n",
      "19    On 19 Apr 2011, joint elements of 22MICO, 2MIB...          0   ...     \n",
      "20    On 251725 Apr 2011, Municipal Mayor Teofisto G...          0   ...     \n",
      "21    On 27 Apr 2011, Dinumpilan CAA Det based at br...          0   ...     \n",
      "22    On 201500 Apr 2011, a certain Santiago Sandot ...          0   ...     \n",
      "23    On 01 Apr 2011, a certain Jinky Yap, owner of ...          0   ...     \n",
      "24    Progress Report to Journal Item Nr: 13293 dtd ...          0   ...     \n",
      "25    On 011250 Apr 2011, elements of 67IB, 10iD, PA...          0   ...     \n",
      "26    On 03 Apr 2011, PDT/A/25IB/10ID led by 2LT AGU...          0   ...     \n",
      "27    On 06 Apr 2011, Cabadianan PB  led by Sgt Catu...          0   ...     \n",
      "28    Progress report to Journal Item Nr 13293 dtd 0...          0   ...     \n",
      "29    On 142325 Apr 2011, Sqd/A/57IB/602Bde under Cp...          0   ...     \n",
      "...                                                 ...        ...   ...     \n",
      "9811  On 250819 Oct 2010, an unident individual fire...          0   ...     \n",
      "9812  On 250909 Oct 2010, an unidentified individual...          0   ...     \n",
      "9813  On 251100 Oct 2010, Mobile of Tactival Command...          0   ...     \n",
      "9814  On 252130 Oct 2010, a certain Nasroding Makil ...          0   ...     \n",
      "9815  On 252330 Oct 2010, Burning incident transpire...          0   ...     \n",
      "9816  On 26 Oct 2010, troops of CCoy, 35IB, 1ID, PA ...          0   ...     \n",
      "9817  On 250630 Oct 2010, firefight ensued between t...          0   ...     \n",
      "9818  On 26 Oct 2010, 1st Pltn and Command Group \"C\"...          0   ...     \n",
      "9819  On 300130 Oct 2010, newly elected Brgy kagawad...          0   ...     \n",
      "9820  On 201700 Oct 2010, Danilo Bandayos y Escrupol...          0   ...     \n",
      "9821  On 19 Oct 2010, eight (8) Ricemill workers of ...          0   ...     \n",
      "9822  On 182030 Oct 2010, One sec of BCoy, 81IB,unde...          0   ...     \n",
      "9823  On 182106 Oct 2010, DRRO sqd of Salipsip Det, ...          0   ...     \n",
      "9824  On 092110 Oct 2010, flash floods occurred in b...          0   ...     \n",
      "9825  On 131730 Oct 2010, a landslide incident occur...          0   ...     \n",
      "9826  On 250110 Oct 2010, joint Team from PPSC, PIB ...          0   ...     \n",
      "9827  On 051400 Oct 2010, one (1) Platoon (-) of BCo...          0   ...     \n",
      "9828  On 121600 Oct 2010, elements of A/83IB under 1...          0   ...     \n",
      "9829  On 05 Oct 2010, Thirty (30) MNLF forces under ...          0   ...     \n",
      "9830  On 08 Oct 2010, a Fil-Chinese businessman iden...          0   ...     \n",
      "9831  On 092130 Oct 2010, MSg Obatay PA while at his...          0   ...     \n",
      "9832  On 24 Oct 2010, a certain Marivic Magallanes S...          0   ...     \n",
      "9833  On 071500 Oct 2010, a certain Ken Clifford Lao...          0   ...     \n",
      "9834  On 081110 Oct 2010, one (1) Pltn (-), BCoy 65I...          0   ...     \n",
      "9835  On 061115 Oct 2010, two (2) EP and two (2) per...          0   ...     \n",
      "9836  On 081000 Oct 2010, Sgt Patrick C Manao PN(M) ...          0   ...     \n",
      "9837  On 15 Oct 2010, a certain Rasbi Rabalun, 20 yr...          0   ...     \n",
      "9838  On 22 Oct 2010, a certain Fely Bily Mateo run ...          0   ...     \n",
      "9839  On 271100 Oct 2010, a certain Sonny Ingga, a r...          0   ...     \n",
      "9840  On 16 Oct 2010, a passenger vessel identified ...          0   ...     \n",
      "\n",
      "      ES Apprehended  ES Arrested  GS WIA  GS KIA  CS Apprehended  CS Rescued  \\\n",
      "0                  0            0       2       0               0           0   \n",
      "1                  0            0       0       1               0           0   \n",
      "2                  0            0       0       0               0           0   \n",
      "3                  0            0       1       0               0           0   \n",
      "4                  0            0       1       0               0           0   \n",
      "5                  0            0       4       0               0           0   \n",
      "6                  0            0       0       0               0           0   \n",
      "7                  0            0       0       0               0           0   \n",
      "8                  0            0       0       0               0           0   \n",
      "9                  0            0       0       0               0           0   \n",
      "10                 0            0       3       0               0           0   \n",
      "11                 0            0       0       0               0           0   \n",
      "12                 0            0       3       0               0           0   \n",
      "13                 0            0       0       0               0           0   \n",
      "14                 0            0       0       0               0           0   \n",
      "15                 0            0       0       0               0           0   \n",
      "16                 0            0       0       0               0           0   \n",
      "17                 0            0       0       0               0           0   \n",
      "18                 0            0       0       0               0           0   \n",
      "19                 0            0       0       0               0           0   \n",
      "20                 0            0       0       0               0           0   \n",
      "21                 0            0       0       0               0           0   \n",
      "22                 0            0       0       0               0           0   \n",
      "23                 0            0       0       0               0           0   \n",
      "24                 0            0       0       0               0           0   \n",
      "25                 0            0       0       0               0           0   \n",
      "26                 0            0       0       0               0           0   \n",
      "27                 0            0       0       0               0           0   \n",
      "28                 0            0       0       0               0           0   \n",
      "29                 0            0       0       0               0           0   \n",
      "...              ...          ...     ...     ...             ...         ...   \n",
      "9811               0            0       0       0               0           0   \n",
      "9812               0            0       0       0               0           0   \n",
      "9813               0            0       0       0               0           0   \n",
      "9814               0            0       0       0               0           0   \n",
      "9815               0            0       0       0               0           0   \n",
      "9816               0            0       0       0               0           0   \n",
      "9817               0            0       0       0               0           0   \n",
      "9818               0            0       0       0               0           0   \n",
      "9819               0            0       0       0               0           0   \n",
      "9820               0            0       0       0               0           0   \n",
      "9821               0            0       0       0               0           0   \n",
      "9822               0            0       0       0               0           0   \n",
      "9823               0            0       0       0               0           0   \n",
      "9824               0            0       0       0               0           0   \n",
      "9825               0            0       0       0               0           0   \n",
      "9826               0            0       0       0               0           0   \n",
      "9827               0            0       0       0               0           0   \n",
      "9828               0            0       0       0               0           0   \n",
      "9829               0            0       0       0               0           0   \n",
      "9830               0            0       0       0               0           0   \n",
      "9831               0            0       0       1               0           0   \n",
      "9832               0            0       0       0               0           0   \n",
      "9833               0            0       0       0               0           0   \n",
      "9834               0            0       0       0               0           0   \n",
      "9835               0            0       0       0               0           0   \n",
      "9836               0            0       0       0               0           0   \n",
      "9837               0            0       0       0               0           0   \n",
      "9838               0            0       0       0               0           0   \n",
      "9839               0            0       0       0               0           0   \n",
      "9840               0            0       0       0               0           0   \n",
      "\n",
      "      CS Killed  CS Wounded  CS Missing  CS DOA  \n",
      "0             0           0           0       0  \n",
      "1             0           0           0       0  \n",
      "2             0           0           0       0  \n",
      "3             0           0           0       0  \n",
      "4             0           0           0       0  \n",
      "5             0           0           0       0  \n",
      "6             0           0           0       0  \n",
      "7             0           0           0       0  \n",
      "8             0           0           0       0  \n",
      "9             0           0           0       0  \n",
      "10            0           0           0       0  \n",
      "11            0           0           0       0  \n",
      "12            0           0           0       0  \n",
      "13            0           0           0       0  \n",
      "14            0           0           0       0  \n",
      "15            6           4           0       0  \n",
      "16            0           0           0       0  \n",
      "17            0           0           0       0  \n",
      "18            0           0           0       0  \n",
      "19            0           0           0       0  \n",
      "20            0           0           0       0  \n",
      "21            0           0           0       0  \n",
      "22            0           0           0       0  \n",
      "23            0           0           0       0  \n",
      "24            0           0           0       0  \n",
      "25            0           0           0       0  \n",
      "26            0           0           0       0  \n",
      "27            0           0           0       0  \n",
      "28            0           0           0       0  \n",
      "29            0           0           0       0  \n",
      "...         ...         ...         ...     ...  \n",
      "9811          0           0           0       0  \n",
      "9812          0           0           0       0  \n",
      "9813          0           0           0       0  \n",
      "9814          0           0           0       0  \n",
      "9815          0           0           0       0  \n",
      "9816          0           0           0       0  \n",
      "9817          0           0           0       0  \n",
      "9818          0           0           0       0  \n",
      "9819          1           0           0       0  \n",
      "9820          0           0           0       0  \n",
      "9821          0           0           0       0  \n",
      "9822          0           0           0       0  \n",
      "9823          0           0           0       0  \n",
      "9824          0           0           0       0  \n",
      "9825          0           0           0       0  \n",
      "9826          0           0           0       0  \n",
      "9827          0           0           0       0  \n",
      "9828          0           0           0       0  \n",
      "9829          0           0           0       0  \n",
      "9830          0           0           0       0  \n",
      "9831          0           0           0       0  \n",
      "9832          0           0           0       0  \n",
      "9833          0           0           0       0  \n",
      "9834          0           0           0       0  \n",
      "9835          0           0           0       0  \n",
      "9836          0           0           0       0  \n",
      "9837          0           0           0       0  \n",
      "9838          4           6           0       0  \n",
      "9839          0           0           0       0  \n",
      "9840          0           0           0       0  \n",
      "\n",
      "[9841 rows x 23 columns]\n"
     ]
    }
   ],
   "source": [
    "#Extract counts from the various subheadings and turn into new dataframe\n",
    "to_split = [\"Apprehended\", \"Rescued\", \"Killed\", \"Wounded\", \"Missing\", \"DOA\"]\n",
    "hold_series = esoc_all_data_raw[\"Civilian Side\"].apply(nameCount, args = (to_split))\n",
    "hold_list = hold_series.tolist()\n",
    "to_add_cols = [\"CS Apprehended\", \"CS Rescued\", \"CS Killed\", \"CS Wounded\", \"CS Missing\", \"CS DOA\"]\n",
    "hold_df = pd.DataFrame(hold_list, columns=to_add_cols)\n",
    "\n",
    "#Add new columns to analytics dataframe\n",
    "esoc_all_data_analytics = pd.concat([esoc_all_data_analytics, hold_df], axis=1)\n",
    "\n",
    "print esoc_all_data_analytics"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "esoc_all_data_analytics.to_csv(\"ESOC_All_Data_2010_2012_Analytics.csv\",header=True, index=False, encoding='utf-8')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 2",
   "language": "python",
   "name": "python2"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}