Infantile Hemangioma Meta-analysis.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Infantile Hemangioma Meta-analysis"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "%matplotlib inline\n",
    "import numpy as np\n",
    "import pandas as pd\n",
    "import pymc as pm\n",
    "import seaborn as sb"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "kq2_outcomes = pd.read_excel('IH_effectiveness_data_Extraction_comparative studies_revised_03242015.xlsx', sheetname='KQ2_outcome data')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "unique_outcomes = kq2_outcomes['Outcome [One outcome row for each each outcome per arm in study--DO NOT USE ABBREVIATIONS EXCEPT IH]'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "78"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(unique_outcomes)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['Complete response', 'Partial response', 'Recurrence',\n",
       "       'Complete response, superficial IH', 'Complete response, mixed IH',\n",
       "       'Volume reduced by ≥ 5%', 'Redness score=0 (no redness)',\n",
       "       'Redness score=1 (half red)', 'Redness score=2 (completely red)',\n",
       "       'Excellent response', 'Good response', 'Poor response',\n",
       "       'Overall response rate (excellent and good)',\n",
       "       'Lesion size reduction > 50%', 'Lesion size reduction < 50%',\n",
       "       'Lesion size reduction little or none',\n",
       "       'Visual acuity scores at 3 months',\n",
       "       'Visual acuity scores at AGE 1 year',\n",
       "       'Excellent response (complete resolution)',\n",
       "       'Good response (≥50% reduction in size of IH)',\n",
       "       'Fair response (<50% reduction in size of IH)',\n",
       "       'Poor response (no response, worsening of IH)', 'Rebound growth',\n",
       "       'Change in TSA, square millimeters', 'Adjusted change in TSA',\n",
       "       'Regrowth', 'Change in volume', 'Redness none', 'Redness moderate',\n",
       "       'Redness significant', 'Blueness none', 'Blueness moderate',\n",
       "       'Blueness significant', 'Elevation none', 'Elevation moderate',\n",
       "       'Elevation significant', 'Complete or nearly complete resolution',\n",
       "       'NR',\n",
       "       'Risk of any invasive treatment (surgical\\nexcision and/or laser treatment)',\n",
       "       'Complete regression', 'Risk of Surgical excision',\n",
       "       'Risk of Laser treatment', 'Significant involution (>50%)',\n",
       "       'Some involution (11%-50%)', 'No involution (≤10%)',\n",
       "       'Visual analog scale', 'Hemangioma activity score',\n",
       "       'Complete clearance', 'near-complete clearance',\n",
       "       'partial\\nclearance', 'Complete involution (> 90% response)',\n",
       "       'reduction in size of 75-90 %', 'reduction in size of 50 to 75 %',\n",
       "       'reduction in size of <25 %', 'reduction in size of >50 %',\n",
       "       'reduction in size of 0-50 %',\n",
       "       'enlarged or caused visually significant ptosis or induced astigmatism',\n",
       "       'degree of clinical improvement in appearance -Slight to moderate (<25% - 50%)',\n",
       "       'Visual Analog Scale - mean mm',\n",
       "       'degree of clinical improvement in appearance -Good to excellent (50% - > 75%)',\n",
       "       'Clearance ≥ 75%', 'Clearance <75%',\n",
       "       'time to complete healing from the onset of ulceration',\n",
       "       'Good or excellent response', 'Fair response', 'Rebound grwoth',\n",
       "       'Response - ineffective', 'Response - controlled growth',\n",
       "       'Response - promoted regression', 'Efficacy rate',\n",
       "       'Response - promotedregression', 'clinical involution',\n",
       "       'Size of hemangioma (cm2)',\n",
       "       'Response rate - Complete resolution achieved',\n",
       "       'Response rate - Sustained plateau, with >50% reduction in size of hemangioma\\nresolution',\n",
       "       'Response rate - <50% reduction in size of hemangioma\\nresolution',\n",
       "       'Resistant to treatment', 'percentage IH shrinkage'], dtype=object)"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "unique_outcomes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "interventions = kq2_outcomes['Arm [One ARM row for each group in study]'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "28"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(interventions)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['propranolol', 'atenolol', 'both arms combined',\n",
       "       'Timolol maleate 0.5% gel', 'placebo', 'Mometasone furoate',\n",
       "       'triamcilone acetonide', 'triamcilone', 'prednisolone', 'control',\n",
       "       'Methylprednisolone', 'prepropranolol ', 'nonpropranolol',\n",
       "       'control - no treatment', 'timolol', 'Imiquimod',\n",
       "       'concurrent propranolol and pulsed dye laser',\n",
       "       'propranolol followed by pulsed dye laser', 'bleomycin',\n",
       "       'prednisone', 'corticosteroids',\n",
       "       'Control (not treated with propranolol)', 'methyprednisolone',\n",
       "       'All treatments combined',\n",
       "       'methyprednisolone, both groups combined',\n",
       "       'No treatment - observation', 'triamcinolone', 'nadolol'], dtype=object)"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "interventions"
   ]
  }
 ],
 "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.4.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}