{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# Data Import" ] }, { "cell_type": "code", "execution_count": 1, "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": [ "# Bar Chart" ] }, { "cell_type": "code", "execution_count": 2, "metadata": { "collapsed": false }, "outputs": [ { "data": { "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYgAAAEVCAYAAAD6u3K7AAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAHIlJREFUeJzt3X2UHXWd5/H3h4QneY5pY0wCQQ1qwlHQNujIQUZUUJSw\nokzY1Y0aT9RFHWeclcRdx8GZzOK64+OIGlSMo0OMKEMGHzAEwRGQ0EEEAmSIhJjEPDRgeIgYSPjs\nH/VruDTV3bdjbt8m/Xmdc8+t+lXV737vTac+t6puVck2ERERve3V7gIiImJ4SkBEREStBERERNRK\nQERERK0ERERE1EpARERErQREDDuS3inpF2143ZWSThzq120HSS+QdJOkByV9aDf3fZWk9+zOPqM9\nEhDRFEkzJV0vaZukLWX4f0hSu2vbXWxPs33V7uxT0vGSrpV0v6T7JF0j6eW78zV20UeBn9k+yPYX\nek+UNE3ST0vNWyWtkPTGNtQZbZSAiAFJ+gjweeDTwLOBccD7gFcB+7SxtKeQNKrdNfSQdDBwGfBF\nYAwwATgX2N7OuoojgJX9TP93YCnVv/ezgA8BDwxBXTGc2M4jjz4fwCHANuCMAebbF/h/wG+BzcBX\ngP3LtBOB9cBHgC3ARuBdDcs+E1hCtQJaDvw98IuG6S+kWlndB6wCzmyY9k3gy8CPSp2v7VXXnwO3\nNIwvBW5oGP8P4PQyfHfP8sB0oKvUtBn4TMMyrwCuBbYCvwZO7OMz6QS29vOZ/R3w7YbxyYCB0WX8\nKuAfyms9RLXSfibwnVLXDcDkfvo/jSoEtpa+XlTarwR2An8s/R7Va7mxpY5D++j3MKrg6wZ+X4Yn\nNky/CnhPw/i7gdvLvJcDR5R2AZ8tfxMPALcAR7f7bz6Phn/rdheQx/B+AKcAO3pWWv3M99mykh8D\nHFRWZv+nTDux9PFJYG/gjcAfgMPK9EXAYuAA4GhgAyUgSts64F3AaOBY4B5gapn+TeB+qq2ZvYD9\netW1f1kRji2vvbn0f1CZ9jDwzDLv3TwRENcB7yjDBwKvKMMTgHvLe9gLeF0Z76j5TA4u0xYCb+h5\nvw3T/46BA2I18DyqoL4N+E/gteWz+BZwYR//HkdRBebryvv+aOlrn4a+39PHsgLupFrxnw6M6zX9\nmcAZwDPK5/g94N8apj/eNzCjvO6LSs3/G7i2TDsZWAEcWl7zRcD4dv/N5/HEI7uYYiBjgXts7+hp\nKPvUt0p6WNIJ5TjEHOCvbN9n+0HgH4GZDf08CnzS9qO2f0T1zfUFZZfQGcDf2t5m+1aqFWqPNwF3\n277Q9g7bvwK+D7ytYZ5LbV9j+zHbf2ws3vbDVN+0TwBeRvWN/xqqQHkFcKfte2ve96PA8yWNtf2Q\n7V+W9rcDP7L9o/J6S6m2NJ6yf972A8DxVCv9C4BuSUskjav9pOtdaPs3tu8Hfgz8xvYV5d/je1SB\nWecvgB/aXmr7Uaqtu/2BPxvoBW2basvrbuCfgI2Sfi5pSpl+r+3v2/5D+beeD7y6j+7eR/VF4fZS\n8z8Cx0g6guozPohqC1Flno0DfyQxVBIQMZB7gbGSRvc02P4z24eWaXsBHVTfJleU4NgK/KS0P95P\nY8hQbUEcWOYZTbWV0GNtw/ARwHE9/Za+/xvVvvEejcvWuZpqK+aEMnwV1Qrt1WW8zmyqb+F3SLpB\n0psa6nlbr3qOB8bXdVJWeu+0PZFq6+g5wOcGqLfR5obhh2vGD+xjuefQ8Dnafozqc5rQzIvaXm/7\nA7afR/Wet1FtsSDpGZK+KmmtpAeAnwOH9nH85wjg8w2f1X1UWwsTbF8J/DPwJWCLpAXluE0MEwmI\nGMh1VAdVZ/Qzzz1UK6tptg8tj0Ns97XyatRNtftpUkPb4Q3D64CrG/o91PaBtt/fMM9AlyTuHRBX\nM0BA2L7T9llUB2g/BVwsqWd317/0qucA2+cN9EZt30G1S+zo0rSNKlh7PLv3Mn+C31GtnAEoW3mT\nqHavDYrtdVQr8Z66PwK8ADjO9sFUnytUK/7e1gHv7fV57W/72tL3F2y/DJhKFcj/c7D1ReskIKJf\ntrdS/fLmfElvlXSQpL0kHUN1fKDn2+kFwGclPQtA0gRJJzfR/07gB8DflW+mU4FZDbNcBhwl6R2S\n9i6Pl0t60SDexrVUK7TpwHLbKylbJlTffp9C0tsldZT3trU0PwZ8G3izpJMljZK0n6QTJU2s6eOF\nkj7SM03SJOAsoGd31U3ACZIOl3QIMG8Q72kgi4FTJZ0kaW+qlfp2qs+iX5IOk3SupOeXf+uxVAea\ne+o+iOoLwVZJY4BP9NPdV4B5kqaVvg+R9LYy/HJJx5X6tlEdK3psl95ttEQCIgZk+/8Cf011oHNz\neXwVOIcnVjjnUB2M/GXZ7XAF1Uq5GR+g2lWyieob9oUNr/0g8Hqq4xm/K/N8iupXU83Wvw24EVhp\n+5HSfB2w1vaWPhY7BVgp6SGqn/jOtP1w+TY9A/gY1dbPOqpvvXX/lx6kCqHrJW2jWsHeSrWyphy/\n+C5wM9XB2suafU8Dsb2K6njJF6m28N4MvLnh/ffnEaoD5ldQ/broVqpweWeZ/jmq4xn3UL2nn/RT\nxyVU/16Lyt/FrVQH7KE6iH8B1a+b1lLtsvx0k28xhoCq41ERERFPli2IiIiolYCIiIhaCYiIiKiV\ngIiIiFoJiIiIqDV64FmGr7Fjx3ry5MntLiMi4mllxYoV99juGGi+p3VATJ48ma6urnaXERHxtCJp\n7cBztXgXk6S/KnfpulXSReWs0zGSlkq6szwf1jD/PEmrJa1q5izciIhonZYFhKQJVDcZ6bR9NDCK\n6mzYucAy21OAZWWccomFmcA0qrNYzx9ON3+JiBhpWn2QejSwf7kS6DOoLpUwgycu57yQ6nrzlPZF\ntrfbXkN12YbpLa4vIiL60LKAsL2BJ+4wthG43/ZPqW4+0nPN901Ut6+E6jLEjZdtXk/NpYklzZHU\nJamru7u7VeVHRIx4rdzFdBjVVsGRVNemP0DS2xvnKTcmGdTFoGwvsN1pu7OjY8CD8BERsYtauYvp\ntcAa293ljlY/oLqb1WZJ4wHKc8/VNDfw5HsCTGQXrl0fERG7RysD4rfAK8o1/gWcRHXj8iU8cb3/\nWcClZXgJMFPSvpKOBKZQ3cA+IiLaoGXnQdi+XtLFVNfh3wH8ClhAdd3/xZJmU10D/swy/0pJi6lu\nzL4DOLvcTCYiItrgaX0/iM7OTudEuYg/zeS5P2x3CXuMu887td0lNEXSCtudA82XazFFREStBERE\nRNRKQERERK0ERERE1EpARERErQRERETUSkBEREStBERERNRKQERERK0ERERE1EpARERErQRERETU\nSkBEREStBERERNRKQERERK0ERERE1EpARERErZYFhKQXSLqp4fGApA9LGiNpqaQ7y/NhDcvMk7Ra\n0ipJJ7eqtoiIGFjLAsL2KtvH2D4GeBnwB+ASYC6wzPYUYFkZR9JUYCYwDTgFOF/SqFbVFxER/Ruq\nXUwnAb+xvRaYASws7QuB08vwDGCR7e221wCrgelDVF9ERPQyVAExE7ioDI+zvbEMbwLGleEJwLqG\nZdaXtoiIaIOWB4SkfYDTgO/1nmbbgAfZ3xxJXZK6uru7d1OVERHR21BsQbwBuNH25jK+WdJ4gPK8\npbRvACY1LDextD2J7QW2O213dnR0tLDsiIiRbSgC4iye2L0EsASYVYZnAZc2tM+UtK+kI4EpwPIh\nqC8iImqMbmXnkg4AXge8t6H5PGCxpNnAWuBMANsrJS0GbgN2AGfb3tnK+iIiom8tDQjb24Bn9mq7\nl+pXTXXzzwfmt7KmiIhoTs6kjoiIWgmIiIiolYCIiIhaCYiIiKiVgIiIiFoJiIiIqJWAiIiIWgmI\niIiolYCIiIhaCYiIiKiVgIiIiFoJiIiIqJWAiIiIWgmIiIiolYCIiIhaCYiIiKiVgIiIiFoJiIiI\nqNXSgJB0qKSLJd0h6XZJr5Q0RtJSSXeW58Ma5p8nabWkVZJObmVtERHRv1ZvQXwe+IntFwIvAW4H\n5gLLbE8BlpVxJE0FZgLTgFOA8yWNanF9ERHRh5YFhKRDgBOArwPYfsT2VmAGsLDMthA4vQzPABbZ\n3m57DbAamN6q+iIion+t3II4EugGLpT0K0lfk3QAMM72xjLPJmBcGZ4ArGtYfn1pexJJcyR1Serq\n7u5uYfkRESNbKwNiNPBS4Mu2jwW2UXYn9bBtwIPp1PYC2522Ozs6OnZbsRER8WStDIj1wHrb15fx\ni6kCY7Ok8QDleUuZvgGY1LD8xNIWERFt0LKAsL0JWCfpBaXpJOA2YAkwq7TNAi4tw0uAmZL2lXQk\nMAVY3qr6IiKif6Nb3P8Hge9I2ge4C3gXVSgtljQbWAucCWB7paTFVCGyAzjb9s4W1xcREX1oaUDY\nvgnorJl0Uh/zzwfmt7KmiIhoTs6kjoiIWgmIiIiolYCIiIhaCYiIiKiVgIiIiFoJiIiIqJWAiIiI\nWgmIiIiolYCIiIhaCYiIiKiVgIiIiFoJiIiIqJWAiIiIWoMKCEmHSXpxq4qJiIjhY8CAkHSVpIMl\njQFuBC6Q9JnWlxYREe3UzBbEIbYfAN4CfMv2ccBrW1tWRES0WzMBMbrcO/pM4LIW1xMREcNEMwHx\nSeBy4De2b5D0XODOZjqXdLekWyTdJKmrtI2RtFTSneX5sIb550laLWmVpJN35Q1FRMTuMWBA2P6e\n7Rfbfn8Zv8v2GYN4jT+3fYztnluPzgWW2Z4CLCvjSJoKzASmAacA50saNYjXiYiI3WjAe1JLOgr4\nMjDO9tHlV0yn2f6HXXzNGcCJZXghcBVwTmlfZHs7sEbSamA6cN0uvs6wMXnuD9tdwh7l7vNObXcJ\nESNCM7uYLgDmAY8C2L6Z6pt+MwxcIWmFpDmlbZztjWV4EzCuDE8A1jUsu760RUREGwy4BQE8w/Zy\nSY1tO5rs/3jbGyQ9C1gq6Y7GibYtyU32BUAJmjkAhx9++GAWjYiIQWhmC+IeSc+j2hpA0luBjf0v\nUrG9oTxvAS6h2mW0ufwqivK8pcy+AZjUsPjE0ta7zwW2O213dnR0NFNGRETsgmYC4mzgq8ALJW0A\nPgy8f6CFJB0g6aCeYeD1wK3AEmBWmW0WcGkZXgLMlLSvpCOBKcDyQbyXiIjYjQbcxWT7LuC1ZSW/\nl+0Hm+x7HHBJ2TU1GvhX2z+RdAOwWNJsYC3V+RXYXilpMXAb1S6ss23vHPQ7ioiI3aLPgJD01320\nA2C738ttlGB5SU37vcBJfSwzH5jfX78RETE0+tuCOGjIqoiIiGGnz4Cwfe5QFhIREcNLMyfK7QfM\npjrDeb+edtvvbmFdERHRZs38iulfgGcDJwNXU/38tNkD1RER8TTVTEA83/bHgW22FwKnAse1tqyI\niGi3ZgLi0fK8VdLRwCHAs1pXUkREDAfNXGpjQbkk98epTmY7sAxHRMQerJkT5b5WBq8GntvaciIi\nYrjocxeTpDdLOqJh/G8l/VrSknIpjIiI2IP1dwxiPtANIOlNwNuBd1PtZvpK60uLiIh26i8gbPsP\nZfgtwNdtryi7nHIZ1YiIPVx/ASFJB0rai+raScsapu3XxzIREbGH6O8g9eeAm4AHgNttdwFIOpYm\n7wcRERFPX/1di+kbki6nOufh1w2TNgHvanVhERHRXv3+zLXcEW5Dr7ZsPUREjADNnEkdEREjUH/n\nQeRch4iIEay/LYiLASQt62eeiIjYQ/V3DGIvSR8Djqq7/ehAtxztIWkU0AVssP0mSWOA7wKTgbuB\nM23/vsw7j+reEzuBD9m+fBDvJSIidqP+tiBmUq2oR1PdfrT3o1l/CdzeMD4XWGZ7CtW5FXMBJE0t\nrzkNOAU4v4RLRES0QX8/c10FfErSzbZ/vCudS5pIdf+I+UDPVsgM4MQyvBC4CjintC+yvR1YI2k1\nMB24bldeOyIi/jTN/IrpWkmfkdRVHv8k6ZAm+/8c8FHgsYa2cQ0/ld0EjCvDE4B1DfOtL21PImlO\nTy3d3d1NlhEREYPVTEB8g+oWo2eWxwPAhQMtVC7wt8X2ir7msW3AzZX6+DILbHfa7uzoyCWhIiJa\npZkbBj3P9hkN4+dKuqmJ5V4FnCbpjVTXbjpY0reBzZLG294oaTywpcy/AZjUsPxEep2kFxERQ6eZ\nLYiHJR3fMyLpVcDDAy1ke57tibYnUx18vtL226kuFz6rzDYLuLQMLwFmStq3nIMxBVje9DuJiIjd\nqpktiPcB32o47vB7nljB74rzgMWSZgNrqXZbYXulpMXAbcAO4GzbO/+E14mIiD9BM7cc/TXwEkkH\nl/EHBvsitq+i+rUStu+lunx43XzzqX7xFBERbdbMFgSwa8EQERFPX7lYX0RE1EpARERErQF3MZXL\nXZxKde2kx+dv9lpMERHx9NTMMYh/B/4I3MKTz4iOiIg9WDMBMdH2i1teSUREDCvNHIP4saTXt7yS\niIgYVprZgvglcImkvYBHAVFdRungllYWERFt1UxAfAZ4JXBLubheRESMAM3sYloH3JpwiIgYWZrZ\ngrgLuErSj4HtPY35mWtExJ6tmYBYUx77lEdERIwAzVys79yhKCQiIoaXZs6k/hk1d32z/ZqWVBQR\nEcNCM7uY/qZheD/gDKr7NURExB6smV1Mve8pfY2k3OktImIP18wupjENo3sBLwMO6WP2iIjYQzSz\ni2kF1TEIUe1aWgPMHmghSfsBPwf2La9zse1PlMD5LtXVYe8GzrT9+7LMvNL3TuBDti8f5PuJiIjd\npJldTEfuYt/bgdfYfkjS3sAvyrkUbwGW2T5P0lxgLnCOpKnATGAa8BzgCklH5b7UERHt0eeZ1JJe\nLunZDeP/XdKlkr7Qa7dTLVceKqN7l4eBGcDC0r4QOL0MzwAW2d5uew2wGpg+6HcUERG7RX+X2vgq\n8AiApBOA84BvAfcDC5rpXNIoSTcBW4Cltq8HxtneWGbZBIwrwxOoLuvRY31pi4iINugvIEbZvq8M\n/wWwwPb3bX8ceH4zndveafsYYCIwXdLRvaabmnMs+iNpjqQuSV3d3d2DWTQiIgah34CQ1HOM4iTg\nyoZpzRzcfpztrcDPgFOAzZLGA5TnLWW2DcCkhsUmlrbefS2w3Wm7s6OjYzBlRETEIPQXEBcBV0u6\nFHgY+A8ASc+n2s3UL0kdkg4tw/sDrwPuAJYAs8pss4BLy/ASYKakfSUdCUwBcr5FRESb9LklYHu+\npGXAeOCnDZf73gv4YBN9jwcWShpVllls+zJJ1wGLJc0G1gJnltdbKWkxcBvVz2nPzi+YIiLap99d\nRbZ/WdP2n810bPtm4Nia9nupdlnVLTMfmN9M/xER0VrN3DAoIiJGoARERETUSkBEREStBERERNRK\nQERERK0ERERE1EpARERErQRERETUSkBEREStBERERNRKQERERK0ERERE1EpARERErQRERETUSkBE\nREStBERERNRKQERERK0ERERE1GpZQEiaJOlnkm6TtFLSX5b2MZKWSrqzPB/WsMw8SaslrZJ0cqtq\ni4iIgbVyC2IH8BHbU4FXAGdLmgrMBZbZngIsK+OUaTOBacApwPmSRrWwvoiI6EfLAsL2Rts3luEH\ngduBCcAMYGGZbSFwehmeASyyvd32GmA1ML1V9UVERP+G5BiEpMnAscD1wDjbG8ukTcC4MjwBWNew\n2PrS1ruvOZK6JHV1d3e3rOaIiJGu5QEh6UDg+8CHbT/QOM22AQ+mP9sLbHfa7uzo6NiNlUZERKOW\nBoSkvanC4Tu2f1CaN0saX6aPB7aU9g3ApIbFJ5a2iIhog1b+iknA14HbbX+mYdISYFYZngVc2tA+\nU9K+ko4EpgDLW1VfRET0b3QL+34V8A7gFkk3lbaPAecBiyXNBtYCZwLYXilpMXAb1S+gzra9s4X1\nRUREP1oWELZ/AaiPySf1scx8YH6raoqIiOblTOqIiKiVgIiIiFoJiIiIqJWAiIiIWgmIiIiolYCI\niIhaCYiIiKiVgIiIiFoJiIiIqJWAiIiIWgmIiIiolYCIiIhaCYiIiKiVgIiIiFoJiIiIqJWAiIiI\nWgmIiIio1cp7Un9D0hZJtza0jZG0VNKd5fmwhmnzJK2WtErSya2qKyIimtPKLYhvAqf0apsLLLM9\nBVhWxpE0FZgJTCvLnC9pVAtri4iIAbQsIGz/HLivV/MMYGEZXgic3tC+yPZ222uA1cD0VtUWERED\nG+pjEONsbyzDm4BxZXgCsK5hvvWlLSIi2qRtB6ltG/Bgl5M0R1KXpK7u7u4WVBYRETD0AbFZ0niA\n8ryltG8AJjXMN7G0PYXtBbY7bXd2dHS0tNiIiJFsqANiCTCrDM8CLm1onylpX0lHAlOA5UNcW0RE\nNBjdqo4lXQScCIyVtB74BHAesFjSbGAtcCaA7ZWSFgO3ATuAs23vbFVtERExsJYFhO2z+ph0Uh/z\nzwfmt6qeiIgYnJxJHRERtRIQERFRKwERERG1EhAREVErAREREbUSEBERUSsBERERtRIQERFRKwER\nERG1EhAREVErAREREbUSEBERUSsBERERtRIQERFRKwERERG1EhAREVErAREREbUSEBERUWvYBYSk\nUyStkrRa0tx21xMRMVINq4CQNAr4EvAGYCpwlqSp7a0qImJkGlYBAUwHVtu+y/YjwCJgRptriogY\nkUa3u4BeJgDrGsbXA8c1ziBpDjCnjD4kadUQ1TYSjAXuaXcRA9Gn2l1BtEH+NnevI5qZabgFxIBs\nLwAWtLuOPZGkLtud7a4jorf8bbbHcNvFtAGY1DA+sbRFRMQQG24BcQMwRdKRkvYBZgJL2lxTRMSI\nNKx2MdneIekDwOXAKOAbtle2uayRJLvuYrjK32YbyHa7a4iIiGFouO1iioiIYSIBERERtRIQERFR\nKwExQkk6vN01RMTwloPUI5SkG22/tAx/3/YZ7a4pAkBSvz9tt33aUNUy0g2rn7nGkFLD8HPbVkXE\nU72S6pI7FwHX8+S/1RhCCYiRy30MR7Tbs4HXAWcB/xX4IXBRzokaetnFNEJJ2glso/p2tj/wh55J\ngG0f3K7aInpI2pcqKD4NnGv7n9tc0oiSLYgRyvaodtcQ0ZcSDKdShcNk4AvAJe2saSTKFkREDCuS\nvgUcDfwIWGT71jaXNGIlICJiWJH0GNXuT3jy8bHs/hxiCYiIiKiVE+UiIqJWAiIiImolICJqSBon\n6V8l3SVphaTrJP2X3dDviZIu2x01RrRaAiKiF0kC/g34ue3n2n4Z1d0NJ7ahlvwUPdomARHxVK8B\nHrH9lZ4G22ttf1HSKEmflnSDpJslvRce3zK4StLFku6Q9J0SNEg6pbTdCLylp09JB0j6hqTlkn4l\naUZpf6ekJZKuBJYN6TuPaJBvJxFPNQ24sY9ps4H7bb+8nMx1jaSflmnHlmV/B1wDvEpSF3ABVeis\nBr7b0Nf/Aq60/W5JhwLLJV1Rpr0UeLHt+3bnG4sYjARExAAkfQk4HngEWAu8WNJby+RDgCll2nLb\n68syN1GdAfwQsMb2naX928CcsuzrgdMk/U0Z3w/ouQz70oRDtFsCIuKpVgKPX/7c9tmSxgJdwG+B\nD9q+vHEBSScC2xuadjLw/y8BZ9he1auv43jiRLGItskxiIinuhLYT9L7G9qeUZ4vB94vaW8ASUdJ\nOqCfvu4AJkt6Xhk/q2Ha5cAHG45VHLtbqo/YTRIQEb24urzA6cCrJa2RtBxYCJwDfA24DbhR0q3A\nV+lnS8H2H6l2Kf2wHKTe0jD574G9gZslrSzjEcNGLrURERG1sgURERG1EhAREVErAREREbUSEBER\nUSsBERERtRIQERFRKwERERG1EhAREVHr/wOmCjYtK0wQwgAAAABJRU5ErkJggg==\n", "text/plain": [ "" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "# Group sum of sales at gender level\n", "var = df.groupby('Gender').Sales.sum()\n", "fig = plt.figure()\n", "ax = fig.add_subplot(1,1,1)\n", "#Here you can change labels and title\n", "ax.set_xlabel('Gender')\n", "ax.set_ylabel('Sum of Sales')\n", "ax.set_title(\"Gender wise Sum of Sales\")\n", "var.plot(kind='bar')\n", "#Show bar chart\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 }