{ "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": [ "# Scatter Plot" ] }, { "cell_type": "code", "execution_count": 2, "metadata": { "collapsed": false }, "outputs": [ { "data": { "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXoAAAD8CAYAAAB5Pm/hAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAEihJREFUeJzt3X1sXfV9x/H3dyZjXh+UdfE68sASptQSUJRMFp3Ugtgm\nzRljTUS1CVRpYp0URaJ7YgvCo4KuHeqDta3SpK5iK6JbQ2glgoXoKkPXCiZNATl1wEBxm1AocVjj\nNvK6qRZNzHd/+Di9MbavH+71vf7l/ZKucs73nOPzzcnhw/XvnHtuZCaSpHL9TKsbkCQ1l0EvSYUz\n6CWpcAa9JBXOoJekwhn0klQ4g16SCmfQS1LhDHpJKtxFrW4AYMOGDbl169ZWtyFJa8qRI0d+kJld\n9dZri6DfunUrQ0NDrW5DktaUiHhlMes5dCNJhTPoJalwBr0kFc6gl6TCGfSSVLi6QR8R90XEqYh4\nbo5lfxkRGREbamp9EXEsIkYjorfRDdcaGB7jvZ/8Otvu+Arv/eTXGRgea+buJGlNWsw7+vuBXbOL\nEbEF+G3gezW1y4GbgCuqbT4bER0N6XSWgeEx+g6NMDYxSQJjE5P0HRox7CVplrpBn5lPAqfnWPQP\nwO1A7XcR7gYezMzXM/O7wDHg6kY0Olv/4CiTZ6bOq02emaJ/cLQZu5OkNWtZY/QRsRsYy8xnZi3a\nBLxaM3+iqs31M/ZGxFBEDI2Pjy+5h5MTk0uqS9KFaslBHxE/D/w1cNdKdpyZ92ZmT2b2dHXV/QTv\nm2xc37mkuiRdqJbzjv5XgW3AMxHxMrAZ+GZE/DIwBmypWXdzVWu4/b3ddK47f/i/c10H+3u7m7E7\nSVqzlvysm8wcAX5pZr4K+57M/EFEPAI8EBF/D2wEtgNPN6jX8+zZOT0i1D84ysmJSTau72R/b/e5\nuiRpWt2gj4iDwHXAhog4AdydmZ+fa93MfD4ivgy8AJwFbs3MqbnWbYQ9OzcZ7JJUR92gz8yb6yzf\nOmv+HuCelbWlpRoYHvO3G0lzaovHFGtlZj5TMHO76cxnCgDDXpKPQCiBnymQtBCDvgB+pkDSQgz6\nAviZAkkLMegL4GcKJC3Ei7EF8DMFkhZi0BfCzxRImo9DN5JUOINekgpn0EtS4Qx6SSqcQS9JhTPo\nJalwBr0kFc6gl6TCGfSSVDiDXpIKZ9BLUuEMekkqnEEvSYUz6CWpcAa9JBXOoJekwhn0klQ4g16S\nCmfQS1LhDHpJKpxBL0mFM+glqXAX1VshIu4DbgBOZeaVVe3jwG7gDeAUcEtmnoyIrcC3gNFq88OZ\nua8JfUsXjIHhMfoHRzk5McnG9Z3s7+1mz85NrW5La8hi3tHfD+yaVevPzKsycwfwKHBXzbLjmbmj\nehny0goMDI/Rd2iEsYlJEhibmKTv0AgDw2Otbk1rSN2gz8wngdOzaj+qmX0LkA3uSxLQPzjK5Jmp\n82qTZ6boHxydZwvpzZY9Rh8R90TEq8AHOf8d/baIOBoRT0TENQtsvzcihiJiaHx8fLltSEU7OTG5\npLo0l2UHfWbemZlbgAPAh6vya8Cl1ZDObcADEfH2eba/NzN7MrOnq6truW1IRdu4vnNJdWkujbjr\n5gDwAYDMfD0zf1hNHwGOA+9qwD6kC9L+3m4613WcV+tc18H+3u4WdaS1aFlBHxHba2Z3Ay9W9a6I\n6KimLwO2Ay+ttEnpQrVn5yY+ceO72bS+kwA2re/kEze+27tutCSLub3yIHAdsCEiTgB3A9dHRDfT\nt1e+AszcXXMt8LGIOFMt25eZp9/8UyUt1p6dmwx2rUjdoM/Mm+cof36edR8CHlppU5KkxvGTsZJU\nOINekgpn0EtS4Qx6SSqcQS9JhTPoJalwBr0kFa7uffTSUnxkYISDT73KVCYdEdz8ni387Z53t7qt\nlvFZ8moHBr0a5iMDI3zx8PfOzU9lnpu/EMN+5lnyM48ZnnmWPGDYa1U5dKOGOfjUq0uql85nyatd\nGPRqmKmc+/tn5quXzmfJq10Y9GqYjogl1Uvns+TVLgx6NczN79mypHrpfJa82oUXY9UwMxdcvetm\n2swFV++6UatFtsH4aU9PTw4NDbW6DUlaUyLiSGb21FvPoRtJKpxBL0mFM+glqXAGvSQVzqCXpMIZ\n9JJUOINekgpn0EtS4Qx6SSqcQS9JhTPoJalwBr0kFc6gl6TCGfSSVLi6QR8R90XEqYh4rqb28Yh4\nNiKORsRjEbGxZllfRByLiNGI6G1W45KkxVnMO/r7gV2zav2ZeVVm7gAeBe4CiIjLgZuAK6ptPhsR\nHUiSWqZu0Gfmk8DpWbUf1cy+BZj59pLdwIOZ+Xpmfhc4BlzdoF4lScuw7K8SjIh7gD8E/gf4jaq8\nCThcs9qJqjbX9nuBvQCXXnrpctuQJNWx7IuxmXlnZm4BDgAfXsb292ZmT2b2dHV1LbcNSVIdjbjr\n5gDwgWp6DNhSs2xzVZMktciygj4ittfM7gZerKYfAW6KiIsjYhuwHXh6ZS1Kklai7hh9RBwErgM2\nRMQJ4G7g+ojoBt4AXgH2AWTm8xHxZeAF4Cxwa2ZONal3SdIiRGbWX6vJenp6cmhoqNVtSNKaEhFH\nMrOn3np+MlaSCmfQS1LhDHpJKpxBL0mFM+glqXAGvSQVzqCXpMIZ9JJUOINekgpn0EtS4Qx6SSqc\nQS9JhTPoJalwBr0kFc6gl6TCGfSSVDiDXpIKZ9BLUuEMekkqnEEvSYUz6CWpcAa9JBXOoJekwhn0\nklQ4g16SCmfQS1LhDHpJKpxBL0mFM+glqXB1gz4i7ouIUxHxXE2tPyJejIhnI+LhiFhf1bdGxGRE\nHK1en2tm85Kk+hbzjv5+YNes2uPAlZl5FfBtoK9m2fHM3FG99jWmTUnSctUN+sx8Ejg9q/ZYZp6t\nZg8Dm5vQmySpARoxRv8h4Ks189uqYZsnIuKa+TaKiL0RMRQRQ+Pj4w1oQ5I0lxUFfUTcCZwFDlSl\n14BLM3MHcBvwQES8fa5tM/PezOzJzJ6urq6VtCFJWsCygz4ibgFuAD6YmQmQma9n5g+r6SPAceBd\nDehTkrRMywr6iNgF3A68PzN/XFPvioiOavoyYDvwUiMalSQtz0X1VoiIg8B1wIaIOAHczfRdNhcD\nj0cEwOHqDptrgY9FxBngDWBfZp6e8wdLklZF3aDPzJvnKH9+nnUfAh5aaVOSpMbxk7GSVDiDXpIK\nZ9BLUuEMekkqnEEvSYUz6CWpcHVvr5TWooHhMfoHRzk5McnG9Z3s7+1mz85NrW5LagmDXsUZGB6j\n79AIk2emABibmKTv0AiAYa8LkkM3Kk7/4Oi5kJ8xeWaK/sHRFnUktZZBr+KcnJhcUl0qnUGv4mxc\n37mkulQ6g17F2d/bTee6jvNqnes62N/b3aKOpNbyYqyKM3PB1btupGkGvYq0Z+cmg12qOHQjSYUz\n6CWpcAa9JBXOoJekwhn0klQ4g16SCmfQS1LhDHpJKpwfmJKayOfiqx0Y9FKT+Fx8tQuHbqQm8bn4\nahcGvdQkPhdf7cKgl5rE5+KrXRj0UpP4XHy1Cy/GSk3ic/HVLuoGfUTcB9wAnMrMK6taP/B7wE+A\n48AfZeZEtawP+GNgCvjTzBxsUu9S2/O5+GoHixm6uR/YNav2OHBlZl4FfBvoA4iIy4GbgCuqbT4b\nER1IklqmbtBn5pPA6Vm1xzLzbDV7GNhcTe8GHszM1zPzu8Ax4OoG9itJWqJGXIz9EPDVanoT8GrN\nshNV7U0iYm9EDEXE0Pj4eAPakCTNZUVBHxF3AmeBA0vdNjPvzcyezOzp6upaSRuSpAUs+66biLiF\n6Yu0v5WZWZXHgC01q22uapKkFlnWO/qI2AXcDrw/M39cs+gR4KaIuDgitgHbgadX3qYkabkWc3vl\nQeA6YENEnADuZvoum4uBxyMC4HBm7svM5yPiy8ALTA/p3JqZU3P/ZEnSaoifjrq0Tk9PTw4NDbW6\nDUlaUyLiSGb21FvPRyBIUuEMekkqnEEvSYUz6CWpcAa9JBXOoJekwhn0klQ4g16SCmfQS1LhDHpJ\nKpxBL0mFM+glqXAGvSQVzqCXpMIt+xumJEnLNzA8Rv/gKCcnJtm4vpP9vd3s2TnnV2yvmEEvSats\nYHiMvkMjTJ6Z/l6msYlJ+g6NADQl7B26kaRV1j84ei7kZ0yemaJ/cLQp+zPoJWmVnZyYXFJ9pQx6\nSVplG9d3Lqm+Uga9JK2y/b3ddK7rOK/Wua6D/b3dTdmfF2MlaZXNXHD1rhtJKtienZuaFuyzOXQj\nSYUz6CWpcAa9JBXOoJekwhn0klQ4g16SCmfQS1Lh6gZ9RNwXEaci4rma2u9HxPMR8UZE9NTUt0bE\nZEQcrV6fa1bjkqTFWcw7+vuBXbNqzwE3Ak/Osf7xzNxRvfatsD9J0grV/WRsZj4ZEVtn1b4FEBHN\n6UqS1DDNGKPfVg3bPBER18y3UkTsjYihiBgaHx9vQhuSJGh80L8GXJqZO4DbgAci4u1zrZiZ92Zm\nT2b2dHV1NbgNSdKMhgZ9Zr6emT+spo8Ax4F3NXIfkqSlaWjQR0RXRHRU05cB24GXGrkPSdLS1L0Y\nGxEHgeuADRFxArgbOA38I9AFfCUijmZmL3At8LGIOAO8AezLzNPNal6SVN9i7rq5eZ5FD8+x7kPA\nQyttSlJ5BobHVu2LNnQ+v3hEUtMNDI/Rd2iEyTNTAIxNTNJ3aATAsF8FPgJBUtP1D46eC/kZk2em\n6B8cbVFHFxaDXlLTnZyYXFJdjWXQS2q6jes7l1RXYxn0kppuf283nes6zqt1rutgf293izq6sHgx\nVlLTzVxw9a6b1jDoJa2KPTs3Gewt4tCNJBXOoJekwhn0klQ4g16SCmfQS1LhIjNb3QMRMQ680uo+\n6tgA/KDVTSyCfTbeWunVPhtrLfT5K5lZ95ub2iLo14KIGMrMnlb3UY99Nt5a6dU+G2ut9LkYDt1I\nUuEMekkqnEG/ePe2uoFFss/GWyu92mdjrZU+63KMXpIK5zt6SSrcBR/0EbElIr4RES9ExPMR8WdV\n/UsRcbR6vRwRR+fZ/uWIGKnWG2pinz8XEU9HxDNVn39T1d8REY9HxHeqP39hnu13RcRoRByLiDta\n0Gd/RLwYEc9GxMMRsX6e7Vt9PD8aEWM1//bXz7P9qhzPOr221Tla7asjIoYj4tFqvq3Ozzq9ttU5\n2lCZeUG/gEuAX6um3wZ8G7h81jp/B9w1z/YvAxtWoc8A3lpNrwOeAn4d+DRwR1W/A/jUHNt2AMeB\ny4CfBZ6Z/XdchT5/G7ioqn9qrj7b5Hh+FPirOtuu2vFcqNd2O0erfd0GPAA8Ws231flZp9e2Okcb\n+brg39Fn5muZ+c1q+n+BbwHnnqUaEQH8AXCwNR1Oy2n/V82uq14J7Aa+UNW/AOyZY/OrgWOZ+VJm\n/gR4sNpu1frMzMcy82xVPwxsbsb+F2uB47kYq3Y8oX6v7XKORsRm4HeBf6kpt9X5uVCv7XaONtIF\nH/S1ImIrsJPpd0wzrgG+n5nfmWezBL4WEUciYm+T++uofj0/BTyemU8B78zM16pV/ht45xybbgJe\nrZk/Qc3/zFapz1ofAr46z+atPp4Af1L9+n7fPEMNq3o86/QK7XOOfga4HXijptZ252dlrl5rtcU5\n2igGfSUi3go8BPx5Zv6oZtHNLPxO6X2ZuQP4HeDWiLi2WT1m5lS1r83A1RFx5azlyeLflTbNQn1G\nxJ3AWeDAPJu3+nj+E9NDCDuA15geEmm5Ov/2LT9HI+IG4FRmHplvnXY5P+v12k7naKMY9EBErGM6\n5A9k5qGa+kXAjcCX5ts2M8eqP08BDzP9a2hTZeYE8A1gF/D9iLik6vcSpt/xzTYGbKmZ31zVVrNP\nIuIW4Abgg9V/9HNt09LjmZnfr0L1DeCf59l/S44nzHlM2+UcfS/w/oh4memhl9+MiC/SnufnfL22\n7Tm6Yq2+SNDqF9MXuv4V+Mwcy3YBTyyw7VuAt9VM/xfTYdGMPruA9dV0J/CfTJ+Q/Zx/sevTc2x7\nEfASsI2fXuy6YpX73AW8AHS1+fG8pGadvwAebOXxXKjXdjtHa/Z5HT+9wNlW52edXtvqHG3o37PV\nDbT6BbyP6V8nnwWOVq/rq2X3A/tmrb8R+Pdq+rLqpHwGeB64s4l9XgUMV30+R3WHBfCLwH8A3wG+\nBrxjdp/V/PVM31F0vEV9HmN6HHbmGH+uTY/nvwEjVf0RquBv1fFcqNd2O0dr9l8bnm11ftbpta3O\n0Ua+/GSsJBXOMXpJKpxBL0mFM+glqXAGvSQVzqCXpMIZ9JJUOINekgpn0EtS4f4fYgqYqJ8BQxwA\nAAAASUVORK5CYII=\n", "text/plain": [ "" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "fig=plt.figure()\n", "ax = fig.add_subplot(1,1,1)\n", "#Change variables here\n", "ax.scatter(df['Age'], df['Sales'])\n", "#Show scatter plot\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 }