{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Data Import"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import matplotlib.pyplot as plt\n",
    "import pandas as pd\n",
    "#Please adjust to your file\n",
    "df=pd.read_excel(\"/Users/davidmika/Desktop/First.xlsx\",\"Sheet1\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Box Plot"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAX4AAAD8CAYAAABw1c+bAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAD65JREFUeJzt3X+MXWWdx/H3x2m1hMWlhElTKGxNJKakkZrcdE1EEhoh\npSK6/qEQ3YA26W6CxE02MZD+gcaYbOK668Y1u+kC2e6qBeIukaCgBWtMEwWmu2CKoCDBSEE6BFCI\nEWj3u3/MqY440zl3fnDbPu9XcnPPec7znPu9SfuZM889d55UFZKkdrxh1AVIkl5fBr8kNcbgl6TG\nGPyS1BiDX5IaY/BLUmMMfklqjMEvSY0x+CWpMctGXcBMTj/99Fq7du2oy5Ck48a+ffuerarxPn2P\nyeBfu3YtExMToy5Dko4bSX7et69TPZLUGINfkhpj8EtSYwx+SWqMwS9JjTH4pR527drF+vXrGRsb\nY/369ezatWvUJUnzdkzezikdS3bt2sX27du58cYbOf/889m7dy9bt24F4IorrhhxddLwciwuvTgY\nDMr7+HWsWL9+PV/60pe48MILf9e2Z88errnmGvbv3z/CyqTfS7Kvqga9+hr80tGNjY3x29/+luXL\nl/+u7dVXX2XFihUcPnx4hJVJvzdM8DvHL81h3bp17N279w/a9u7dy7p160ZUkbQwBr80h+3bt7N1\n61b27NnDq6++yp49e9i6dSvbt28fdWnSvPjhrjSHIx/gXnPNNTz88MOsW7eOz33uc36wq+OWc/yS\ndAJwjl+SNCuDX5IaY/BLUmMMfklqjMEvSY0x+CWpMQa/JDXG4JekxvT+5m6SMWACOFBVlyb5PPA+\n4BXgZ8DHquqFGcY9AbwIHAYO9f2CgSRpaQxzxf9J4OFp+7uB9VX1duCnwHVHGXthVW0w9CVp9HoF\nf5I1wHuBG460VdV3qupQt/tDYM3ilydJWmx9r/i/CHwK+L9Zjn8cuHOWYwXcnWRfkm1D1idJWmRz\nBn+SS4GDVbVvluPbgUPAV2c5xflVtQG4BLg6yQWznGdbkokkE5OTk/2qlyQNrc8V/7uAy7oPaW8G\nNiX5CkCSq4BLgY/ULH/ms6oOdM8HgduAjbP021FVg6oajI+PD/s+JEk9zRn8VXVdVa2pqrXA5cB3\nq+qjSTYzNf1zWVX9ZqaxSU5OcsqRbeBiwEVKJWmEFnIf/z8DpwC7kzyQ5F8BkpyR5Ftdn1XA3iQP\nAvcB36yquxZUsSRpQYZagauqvgd8r9t+6yx9ngK2dNuPA+ctqEJJ0qLym7uS1BiDX5IaY/BLUmMM\nfklqjMEvSY0x+CWpMQa/JDXG4Jekxhj8ktQYg1+SGmPwS1JjDH5JaozBL0mNMfglqTEGvyQ1xuCX\npMYY/JLUGINfkhpj8EtSY3oHf5KxJP+b5I5u/7Qku5M82j2vnGXc5iQ/SfJYkmsXq3BJ0vwMc8X/\nSeDhafvXAvdU1TnAPd3+H0gyBnwZuAQ4F7giybnzL1eStFC9gj/JGuC9wA3Tmt8P7Oy2dwIfmGHo\nRuCxqnq8ql4Bbu7GSZJGZFnPfl8EPgWcMq1tVVU93W3/Elg1w7gzgV9M238S+POZXiDJNmAbwNln\nn92zLGn+krxur1VVr9trSXOZ84o/yaXAwaraN1ufmvpXvaB/2VW1o6oGVTUYHx9fyKmkXqpq6MdC\nxknHij5X/O8CLkuyBVgBvDnJV4BnkqyuqqeTrAYOzjD2AHDWtP01XZskaUTmvOKvquuqak1VrQUu\nB75bVR8Fbgeu7LpdCXxjhuH3A+ckeUuSN3bjb1+UyiVJ87KQ+/j/DrgoyaPAe7p9kpyR5FsAVXUI\n+ATwbabuCLq1qh5aWMmSpIXIsTj/OBgMamJiYtRlSH8kiXP2OiYl2VdVgz59/eauJDXG4Jekxhj8\nktQYg1+SGmPwS1JjDH5JaozBL0mNMfglqTEGvyQ1xuCXpMYY/JLUGINfkhpj8EtSYwx+SWqMwS9J\njTH4JakxBr8kNcbgl6TGLJurQ5IVwPeBN3X9v15V1ye5BXhb1+1U4IWq2jDD+CeAF4HDwKG+S4NJ\nkpbGnMEPvAxsqqqXkiwH9ia5s6o+fKRDki8AvzrKOS6sqmcXWKskaRHMGfw1tbL0S93u8u7xu9Wm\nkwT4ELBpKQqUJC2uXnP8ScaSPAAcBHZX1b3TDr8beKaqHp1leAF3J9mXZNvCypUkLVSv4K+qw938\n/RpgY5L10w5fAew6yvDzu7GXAFcnuWCmTkm2JZlIMjE5OdmzfEnSsIa6q6eqXgD2AJsBkiwDPgjc\ncpQxB7rng8BtwMZZ+u2oqkFVDcbHx4cpS5I0hDmDP8l4klO77ZOAi4BHusPvAR6pqidnGXtyklOO\nbAMXA/sXo3BJ0vz0uatnNbAzyRhTPyhurao7umOX85ppniRnADdU1RZgFXDb1Oe/LAO+VlV3LVbx\nkqTh9bmr50fAO2Y5dtUMbU8BW7rtx4HzFlaiJGkx+c1dSWqMwS9JjTH4JakxfT7clY4Lp512Gs8/\n//ySv053s8KSWblyJc8999ySvobaZvDrhPH8888z9RdGjm9L/YNFcqpHkhpj8EtSYwx+SWqMwS9J\njTH4JakxBr8kNcbgl6TGGPyS1BiDX5IaY/BLUmMMfklqjMEvSY0x+CWpMX0WW1+R5L4kDyZ5KMln\nuvZPJzmQ5IHusWWW8ZuT/CTJY0muXew3IEkaTp8/y/wysKmqXkqyHNib5M7u2D9W1d/PNrBboP3L\nwEXAk8D9SW6vqh8vtHBJ0vzMecVfU17qdpd3j75/9Hwj8FhVPV5VrwA3A++fV6WSpEXRa44/yViS\nB4CDwO6qurc7dE2SHyW5KcnKGYaeCfxi2v6TXZskaUR6rcBVVYeBDUlOBW5Lsh74F+CzTF39fxb4\nAvDx+RaSZBuwDeDss8+e72nUsLr+zfDpPx11GQtW17951CXoBDfU0otV9UKSPcDm6XP7Sf4NuGOG\nIQeAs6btr+naZjr3DmAHwGAwOP7Xz9PrLp/59Qmz9GJ9etRV6ETW566e8e5KnyQnMfVB7SNJVk/r\n9hfA/hmG3w+ck+QtSd4IXA7cvvCyJUnz1eeKfzWws7tD5w3ArVV1R5L/TLKBqameJ4C/AkhyBnBD\nVW2pqkNJPgF8GxgDbqqqh5bijUiS+smx+KvxYDCoiYmJUZeh40ySE2eq5wR4H3p9JdlXVYM+ff3m\nriQ1xuCXpMYY/JLUGINfkhpj8EtSYwx+SWqMwS9JjTH4JakxBr8kNcbgl6TGGPyS1BiDX5IaY/BL\nUmMMfklqjMEvSY0x+CWpMQa/JDXG4Jekxhj8ktSYORdbT7IC+D7wpq7/16vq+iSfB94HvAL8DPhY\nVb0ww/gngBeBw8ChvmtCSpKWRp8r/peBTVV1HrAB2JzkncBuYH1VvR34KXDdUc5xYVVtMPQlafTm\nDP6a8lK3u7x7VFV9p6oOde0/BNYsUY2SpEXUa44/yViSB4CDwO6quvc1XT4O3DnL8ALuTrIvybb5\nlypJWgy9gr+qDlfVBqau6jcmWX/kWJLtwCHgq7MMP78bewlwdZILZuqUZFuSiSQTk5OTQ70JSVJ/\nQ93V0314uwfYDJDkKuBS4CNVVbOMOdA9HwRuAzbO0m9HVQ2qajA+Pj5MWZKkIcwZ/EnGk5zabZ8E\nXAQ8kmQz8Cngsqr6zSxjT05yypFt4GJg/2IVL0ka3py3cwKrgZ1Jxpj6QXFrVd2R5DGmbvHcnQTg\nh1X110nOAG6oqi3AKuC27vgy4GtVdddSvBFJUj9zBn9V/Qh4xwztb52l/1PAlm77ceC8BdYoSVpE\nfa74peNG99vlcW3lypWjLkEnOINfJ4xZ7i9YVElel9eRlpJ/q0eSGmPwS1JjDH5JaozBL0mNMfgl\nqTEGvyQ1xuCXpMYY/JLUGINfkhpj8EtSYwx+SWqMwS9JjTH4JakxBr8kNcbgl6TGGPyS1Jg+i62v\nSHJfkgeTPJTkM137aUl2J3m0e55x2aAkm5P8JMljSa5d7DcgSRpOnyv+l4FNVXUesAHYnOSdwLXA\nPVV1DnBPt/8HugXavwxcApwLXJHk3MUqXpI0vDmDv6a81O0u7x4FvB/Y2bXvBD4ww/CNwGNV9XhV\nvQLc3I2TJI1Irzn+JGNJHgAOArur6l5gVVU93XX5JbBqhqFnAr+Ytv9k1yZJGpFewV9Vh6tqA7AG\n2Jhk/WuOF1O/Bcxbkm1JJpJMTE5OLuRUkqSjGOqunqp6AdgDbAaeSbIaoHs+OMOQA8BZ0/bXdG0z\nnXtHVQ2qajA+Pj5MWZKkIfS5q2c8yand9knARcAjwO3AlV23K4FvzDD8fuCcJG9J8kbg8m6cJGlE\nlvXosxrY2d2h8wbg1qq6I8kPgFuTbAV+DnwIIMkZwA1VtaWqDiX5BPBtYAy4qaoeWpJ3IknqJVPT\n88eWwWBQExMToy5D+iNJOBb/z0hJ9lXVoE9fv7krSY0x+CWpMQa/JDXG4Jekxhj8ktQYg1+SGmPw\nS1JjDH5JaozBL0mNMfglqTEGvyQ1xuCXpMYY/JLUGINfkhpj8EtSYwx+SWqMwS9JjTH4JakxBr8k\nNWbOxdaTnAX8B7AKKGBHVf1TkluAt3XdTgVeqKoNM4x/AngROAwc6rsmpCRpacwZ/MAh4G+r6n+S\nnALsS7K7qj58pEOSLwC/Oso5LqyqZxdYqyRpEcwZ/FX1NPB0t/1ikoeBM4EfAyQJ8CFg0xLWKUla\nJEPN8SdZC7wDuHda87uBZ6rq0VmGFXB3kn1Jth3l3NuSTCSZmJycHKYsSdIQegd/kj8B/gv4m6r6\n9bRDVwC7jjL0/G7u/xLg6iQXzNSpqnZU1aCqBuPj433LkiQNqVfwJ1nOVOh/tar+e1r7MuCDwC2z\nja2qA93zQeA2YONCCpYkLcycwd/N4d8IPFxV//Caw+8BHqmqJ2cZe3L3gTBJTgYuBvYvrGRJ0kL0\nueJ/F/CXwKYkD3SPLd2xy3nNNE+SM5J8q9tdBexN8iBwH/DNqrprkWqXJM1Dn7t69gKZ5dhVM7Q9\nBWzpth8HzltYiZKkxeQ3dyWpMQa/JDXG4Jekxhj8ktQYg1+SGmPwS1JjDH5JaozBL0mNMfglqTEG\nvyQ1xuCXpMb0WXpROiFN/eHZ12dcVc3rtaSlYPCrWYaxWuVUjyQ1xuCXpMYY/JLUGINfkhpj8EtS\nYwx+SWqMwS9JjTH4JakxORa/xJJkEvj5qOuQZnA68Oyoi5Bm8GdVNd6n4zEZ/NKxKslEVQ1GXYe0\nEE71SFJjDH5JaozBLw1nx6gLkBbKOX5JaoxX/JLUGINf6iHJTUkOJtk/6lqkhTL4pX7+Hdg86iKk\nxWDwSz1U1feB50Zdh7QYDH5JaozBL0mNMfglqTEGvyQ1xuCXekiyC/gB8LYkTybZOuqapPnym7uS\n1Biv+CWpMQa/JDXG4Jekxhj8ktQYg1+SGmPwS1JjDH5JaozBL0mN+X80UaS/HoGZ6QAAAABJRU5E\nrkJggg==\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x1157bb510>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "fig=plt.figure()\n",
    "ax = fig.add_subplot(1,1,1)\n",
    "ax.boxplot(df['Age'])\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "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.13"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}