Lab-2 Statistical Analysis Using Pandas Part-1.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>InvoiceNo</th>\n",
       "      <th>StockCode</th>\n",
       "      <th>Description</th>\n",
       "      <th>Quantity</th>\n",
       "      <th>InvoiceDate</th>\n",
       "      <th>UnitPrice</th>\n",
       "      <th>CustomerID</th>\n",
       "      <th>Country</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>536365</td>\n",
       "      <td>85123A</td>\n",
       "      <td>WHITE HANGING HEART T-LIGHT HOLDER</td>\n",
       "      <td>6</td>\n",
       "      <td>2010-12-01 08:26:00</td>\n",
       "      <td>2.55</td>\n",
       "      <td>17850.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>536365</td>\n",
       "      <td>71053</td>\n",
       "      <td>WHITE METAL LANTERN</td>\n",
       "      <td>6</td>\n",
       "      <td>2010-12-01 08:26:00</td>\n",
       "      <td>3.39</td>\n",
       "      <td>17850.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>536365</td>\n",
       "      <td>84406B</td>\n",
       "      <td>CREAM CUPID HEARTS COAT HANGER</td>\n",
       "      <td>8</td>\n",
       "      <td>2010-12-01 08:26:00</td>\n",
       "      <td>2.75</td>\n",
       "      <td>17850.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>536365</td>\n",
       "      <td>84029G</td>\n",
       "      <td>KNITTED UNION FLAG HOT WATER BOTTLE</td>\n",
       "      <td>6</td>\n",
       "      <td>2010-12-01 08:26:00</td>\n",
       "      <td>3.39</td>\n",
       "      <td>17850.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>536365</td>\n",
       "      <td>84029E</td>\n",
       "      <td>RED WOOLLY HOTTIE WHITE HEART.</td>\n",
       "      <td>6</td>\n",
       "      <td>2010-12-01 08:26:00</td>\n",
       "      <td>3.39</td>\n",
       "      <td>17850.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>536365</td>\n",
       "      <td>22752</td>\n",
       "      <td>SET 7 BABUSHKA NESTING BOXES</td>\n",
       "      <td>2</td>\n",
       "      <td>2010-12-01 08:26:00</td>\n",
       "      <td>7.65</td>\n",
       "      <td>17850.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>536365</td>\n",
       "      <td>21730</td>\n",
       "      <td>GLASS STAR FROSTED T-LIGHT HOLDER</td>\n",
       "      <td>6</td>\n",
       "      <td>2010-12-01 08:26:00</td>\n",
       "      <td>4.25</td>\n",
       "      <td>17850.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>536366</td>\n",
       "      <td>22633</td>\n",
       "      <td>HAND WARMER UNION JACK</td>\n",
       "      <td>6</td>\n",
       "      <td>2010-12-01 08:28:00</td>\n",
       "      <td>1.85</td>\n",
       "      <td>17850.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>536366</td>\n",
       "      <td>22632</td>\n",
       "      <td>HAND WARMER RED POLKA DOT</td>\n",
       "      <td>6</td>\n",
       "      <td>2010-12-01 08:28:00</td>\n",
       "      <td>1.85</td>\n",
       "      <td>17850.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>536367</td>\n",
       "      <td>84879</td>\n",
       "      <td>ASSORTED COLOUR BIRD ORNAMENT</td>\n",
       "      <td>32</td>\n",
       "      <td>2010-12-01 08:34:00</td>\n",
       "      <td>1.69</td>\n",
       "      <td>13047.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>536367</td>\n",
       "      <td>22745</td>\n",
       "      <td>POPPY'S PLAYHOUSE BEDROOM</td>\n",
       "      <td>6</td>\n",
       "      <td>2010-12-01 08:34:00</td>\n",
       "      <td>2.10</td>\n",
       "      <td>13047.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>536367</td>\n",
       "      <td>22748</td>\n",
       "      <td>POPPY'S PLAYHOUSE KITCHEN</td>\n",
       "      <td>6</td>\n",
       "      <td>2010-12-01 08:34:00</td>\n",
       "      <td>2.10</td>\n",
       "      <td>13047.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>536367</td>\n",
       "      <td>22749</td>\n",
       "      <td>FELTCRAFT PRINCESS CHARLOTTE DOLL</td>\n",
       "      <td>8</td>\n",
       "      <td>2010-12-01 08:34:00</td>\n",
       "      <td>3.75</td>\n",
       "      <td>13047.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>536367</td>\n",
       "      <td>22310</td>\n",
       "      <td>IVORY KNITTED MUG COSY</td>\n",
       "      <td>6</td>\n",
       "      <td>2010-12-01 08:34:00</td>\n",
       "      <td>1.65</td>\n",
       "      <td>13047.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>536367</td>\n",
       "      <td>84969</td>\n",
       "      <td>BOX OF 6 ASSORTED COLOUR TEASPOONS</td>\n",
       "      <td>6</td>\n",
       "      <td>2010-12-01 08:34:00</td>\n",
       "      <td>4.25</td>\n",
       "      <td>13047.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>536367</td>\n",
       "      <td>22623</td>\n",
       "      <td>BOX OF VINTAGE JIGSAW BLOCKS</td>\n",
       "      <td>3</td>\n",
       "      <td>2010-12-01 08:34:00</td>\n",
       "      <td>4.95</td>\n",
       "      <td>13047.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>536367</td>\n",
       "      <td>22622</td>\n",
       "      <td>BOX OF VINTAGE ALPHABET BLOCKS</td>\n",
       "      <td>2</td>\n",
       "      <td>2010-12-01 08:34:00</td>\n",
       "      <td>9.95</td>\n",
       "      <td>13047.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>536367</td>\n",
       "      <td>21754</td>\n",
       "      <td>HOME BUILDING BLOCK WORD</td>\n",
       "      <td>3</td>\n",
       "      <td>2010-12-01 08:34:00</td>\n",
       "      <td>5.95</td>\n",
       "      <td>13047.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>536367</td>\n",
       "      <td>21755</td>\n",
       "      <td>LOVE BUILDING BLOCK WORD</td>\n",
       "      <td>3</td>\n",
       "      <td>2010-12-01 08:34:00</td>\n",
       "      <td>5.95</td>\n",
       "      <td>13047.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>536367</td>\n",
       "      <td>21777</td>\n",
       "      <td>RECIPE BOX WITH METAL HEART</td>\n",
       "      <td>4</td>\n",
       "      <td>2010-12-01 08:34:00</td>\n",
       "      <td>7.95</td>\n",
       "      <td>13047.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>536367</td>\n",
       "      <td>48187</td>\n",
       "      <td>DOORMAT NEW ENGLAND</td>\n",
       "      <td>4</td>\n",
       "      <td>2010-12-01 08:34:00</td>\n",
       "      <td>7.95</td>\n",
       "      <td>13047.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>536368</td>\n",
       "      <td>22960</td>\n",
       "      <td>JAM MAKING SET WITH JARS</td>\n",
       "      <td>6</td>\n",
       "      <td>2010-12-01 08:34:00</td>\n",
       "      <td>4.25</td>\n",
       "      <td>13047.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>536368</td>\n",
       "      <td>22913</td>\n",
       "      <td>RED COAT RACK PARIS FASHION</td>\n",
       "      <td>3</td>\n",
       "      <td>2010-12-01 08:34:00</td>\n",
       "      <td>4.95</td>\n",
       "      <td>13047.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>536368</td>\n",
       "      <td>22912</td>\n",
       "      <td>YELLOW COAT RACK PARIS FASHION</td>\n",
       "      <td>3</td>\n",
       "      <td>2010-12-01 08:34:00</td>\n",
       "      <td>4.95</td>\n",
       "      <td>13047.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>536368</td>\n",
       "      <td>22914</td>\n",
       "      <td>BLUE COAT RACK PARIS FASHION</td>\n",
       "      <td>3</td>\n",
       "      <td>2010-12-01 08:34:00</td>\n",
       "      <td>4.95</td>\n",
       "      <td>13047.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>536369</td>\n",
       "      <td>21756</td>\n",
       "      <td>BATH BUILDING BLOCK WORD</td>\n",
       "      <td>3</td>\n",
       "      <td>2010-12-01 08:35:00</td>\n",
       "      <td>5.95</td>\n",
       "      <td>13047.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>536370</td>\n",
       "      <td>22728</td>\n",
       "      <td>ALARM CLOCK BAKELIKE PINK</td>\n",
       "      <td>24</td>\n",
       "      <td>2010-12-01 08:45:00</td>\n",
       "      <td>3.75</td>\n",
       "      <td>12583.0</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>536370</td>\n",
       "      <td>22727</td>\n",
       "      <td>ALARM CLOCK BAKELIKE RED</td>\n",
       "      <td>24</td>\n",
       "      <td>2010-12-01 08:45:00</td>\n",
       "      <td>3.75</td>\n",
       "      <td>12583.0</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>536370</td>\n",
       "      <td>22726</td>\n",
       "      <td>ALARM CLOCK BAKELIKE GREEN</td>\n",
       "      <td>12</td>\n",
       "      <td>2010-12-01 08:45:00</td>\n",
       "      <td>3.75</td>\n",
       "      <td>12583.0</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>536370</td>\n",
       "      <td>21724</td>\n",
       "      <td>PANDA AND BUNNIES STICKER SHEET</td>\n",
       "      <td>12</td>\n",
       "      <td>2010-12-01 08:45:00</td>\n",
       "      <td>0.85</td>\n",
       "      <td>12583.0</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541879</th>\n",
       "      <td>581585</td>\n",
       "      <td>22726</td>\n",
       "      <td>ALARM CLOCK BAKELIKE GREEN</td>\n",
       "      <td>8</td>\n",
       "      <td>2011-12-09 12:31:00</td>\n",
       "      <td>3.75</td>\n",
       "      <td>15804.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541880</th>\n",
       "      <td>581585</td>\n",
       "      <td>22727</td>\n",
       "      <td>ALARM CLOCK BAKELIKE RED</td>\n",
       "      <td>4</td>\n",
       "      <td>2011-12-09 12:31:00</td>\n",
       "      <td>3.75</td>\n",
       "      <td>15804.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541881</th>\n",
       "      <td>581585</td>\n",
       "      <td>16016</td>\n",
       "      <td>LARGE CHINESE STYLE SCISSOR</td>\n",
       "      <td>10</td>\n",
       "      <td>2011-12-09 12:31:00</td>\n",
       "      <td>0.85</td>\n",
       "      <td>15804.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541882</th>\n",
       "      <td>581585</td>\n",
       "      <td>21916</td>\n",
       "      <td>SET 12 RETRO WHITE CHALK STICKS</td>\n",
       "      <td>24</td>\n",
       "      <td>2011-12-09 12:31:00</td>\n",
       "      <td>0.42</td>\n",
       "      <td>15804.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541883</th>\n",
       "      <td>581585</td>\n",
       "      <td>84692</td>\n",
       "      <td>BOX OF 24 COCKTAIL PARASOLS</td>\n",
       "      <td>25</td>\n",
       "      <td>2011-12-09 12:31:00</td>\n",
       "      <td>0.42</td>\n",
       "      <td>15804.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541884</th>\n",
       "      <td>581585</td>\n",
       "      <td>84946</td>\n",
       "      <td>ANTIQUE SILVER T-LIGHT GLASS</td>\n",
       "      <td>12</td>\n",
       "      <td>2011-12-09 12:31:00</td>\n",
       "      <td>1.25</td>\n",
       "      <td>15804.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541885</th>\n",
       "      <td>581585</td>\n",
       "      <td>21684</td>\n",
       "      <td>SMALL MEDINA STAMPED METAL BOWL</td>\n",
       "      <td>12</td>\n",
       "      <td>2011-12-09 12:31:00</td>\n",
       "      <td>0.85</td>\n",
       "      <td>15804.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541886</th>\n",
       "      <td>581585</td>\n",
       "      <td>22398</td>\n",
       "      <td>MAGNETS PACK OF 4 SWALLOWS</td>\n",
       "      <td>12</td>\n",
       "      <td>2011-12-09 12:31:00</td>\n",
       "      <td>0.39</td>\n",
       "      <td>15804.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541887</th>\n",
       "      <td>581585</td>\n",
       "      <td>23328</td>\n",
       "      <td>SET 6 SCHOOL MILK BOTTLES IN CRATE</td>\n",
       "      <td>4</td>\n",
       "      <td>2011-12-09 12:31:00</td>\n",
       "      <td>3.75</td>\n",
       "      <td>15804.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541888</th>\n",
       "      <td>581585</td>\n",
       "      <td>23145</td>\n",
       "      <td>ZINC T-LIGHT HOLDER STAR LARGE</td>\n",
       "      <td>12</td>\n",
       "      <td>2011-12-09 12:31:00</td>\n",
       "      <td>0.95</td>\n",
       "      <td>15804.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541889</th>\n",
       "      <td>581585</td>\n",
       "      <td>22466</td>\n",
       "      <td>FAIRY TALE COTTAGE NIGHT LIGHT</td>\n",
       "      <td>12</td>\n",
       "      <td>2011-12-09 12:31:00</td>\n",
       "      <td>1.95</td>\n",
       "      <td>15804.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541890</th>\n",
       "      <td>581586</td>\n",
       "      <td>22061</td>\n",
       "      <td>LARGE CAKE STAND  HANGING STRAWBERY</td>\n",
       "      <td>8</td>\n",
       "      <td>2011-12-09 12:49:00</td>\n",
       "      <td>2.95</td>\n",
       "      <td>13113.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541891</th>\n",
       "      <td>581586</td>\n",
       "      <td>23275</td>\n",
       "      <td>SET OF 3 HANGING OWLS OLLIE BEAK</td>\n",
       "      <td>24</td>\n",
       "      <td>2011-12-09 12:49:00</td>\n",
       "      <td>1.25</td>\n",
       "      <td>13113.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541892</th>\n",
       "      <td>581586</td>\n",
       "      <td>21217</td>\n",
       "      <td>RED RETROSPOT ROUND CAKE TINS</td>\n",
       "      <td>24</td>\n",
       "      <td>2011-12-09 12:49:00</td>\n",
       "      <td>8.95</td>\n",
       "      <td>13113.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541893</th>\n",
       "      <td>581586</td>\n",
       "      <td>20685</td>\n",
       "      <td>DOORMAT RED RETROSPOT</td>\n",
       "      <td>10</td>\n",
       "      <td>2011-12-09 12:49:00</td>\n",
       "      <td>7.08</td>\n",
       "      <td>13113.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541894</th>\n",
       "      <td>581587</td>\n",
       "      <td>22631</td>\n",
       "      <td>CIRCUS PARADE LUNCH BOX</td>\n",
       "      <td>12</td>\n",
       "      <td>2011-12-09 12:50:00</td>\n",
       "      <td>1.95</td>\n",
       "      <td>12680.0</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541895</th>\n",
       "      <td>581587</td>\n",
       "      <td>22556</td>\n",
       "      <td>PLASTERS IN TIN CIRCUS PARADE</td>\n",
       "      <td>12</td>\n",
       "      <td>2011-12-09 12:50:00</td>\n",
       "      <td>1.65</td>\n",
       "      <td>12680.0</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541896</th>\n",
       "      <td>581587</td>\n",
       "      <td>22555</td>\n",
       "      <td>PLASTERS IN TIN STRONGMAN</td>\n",
       "      <td>12</td>\n",
       "      <td>2011-12-09 12:50:00</td>\n",
       "      <td>1.65</td>\n",
       "      <td>12680.0</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541897</th>\n",
       "      <td>581587</td>\n",
       "      <td>22728</td>\n",
       "      <td>ALARM CLOCK BAKELIKE PINK</td>\n",
       "      <td>4</td>\n",
       "      <td>2011-12-09 12:50:00</td>\n",
       "      <td>3.75</td>\n",
       "      <td>12680.0</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541898</th>\n",
       "      <td>581587</td>\n",
       "      <td>22727</td>\n",
       "      <td>ALARM CLOCK BAKELIKE RED</td>\n",
       "      <td>4</td>\n",
       "      <td>2011-12-09 12:50:00</td>\n",
       "      <td>3.75</td>\n",
       "      <td>12680.0</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541899</th>\n",
       "      <td>581587</td>\n",
       "      <td>22726</td>\n",
       "      <td>ALARM CLOCK BAKELIKE GREEN</td>\n",
       "      <td>4</td>\n",
       "      <td>2011-12-09 12:50:00</td>\n",
       "      <td>3.75</td>\n",
       "      <td>12680.0</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541900</th>\n",
       "      <td>581587</td>\n",
       "      <td>22730</td>\n",
       "      <td>ALARM CLOCK BAKELIKE IVORY</td>\n",
       "      <td>4</td>\n",
       "      <td>2011-12-09 12:50:00</td>\n",
       "      <td>3.75</td>\n",
       "      <td>12680.0</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541901</th>\n",
       "      <td>581587</td>\n",
       "      <td>22367</td>\n",
       "      <td>CHILDRENS APRON SPACEBOY DESIGN</td>\n",
       "      <td>8</td>\n",
       "      <td>2011-12-09 12:50:00</td>\n",
       "      <td>1.95</td>\n",
       "      <td>12680.0</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541902</th>\n",
       "      <td>581587</td>\n",
       "      <td>22629</td>\n",
       "      <td>SPACEBOY LUNCH BOX</td>\n",
       "      <td>12</td>\n",
       "      <td>2011-12-09 12:50:00</td>\n",
       "      <td>1.95</td>\n",
       "      <td>12680.0</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541903</th>\n",
       "      <td>581587</td>\n",
       "      <td>23256</td>\n",
       "      <td>CHILDRENS CUTLERY SPACEBOY</td>\n",
       "      <td>4</td>\n",
       "      <td>2011-12-09 12:50:00</td>\n",
       "      <td>4.15</td>\n",
       "      <td>12680.0</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541904</th>\n",
       "      <td>581587</td>\n",
       "      <td>22613</td>\n",
       "      <td>PACK OF 20 SPACEBOY NAPKINS</td>\n",
       "      <td>12</td>\n",
       "      <td>2011-12-09 12:50:00</td>\n",
       "      <td>0.85</td>\n",
       "      <td>12680.0</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541905</th>\n",
       "      <td>581587</td>\n",
       "      <td>22899</td>\n",
       "      <td>CHILDREN'S APRON DOLLY GIRL</td>\n",
       "      <td>6</td>\n",
       "      <td>2011-12-09 12:50:00</td>\n",
       "      <td>2.10</td>\n",
       "      <td>12680.0</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541906</th>\n",
       "      <td>581587</td>\n",
       "      <td>23254</td>\n",
       "      <td>CHILDRENS CUTLERY DOLLY GIRL</td>\n",
       "      <td>4</td>\n",
       "      <td>2011-12-09 12:50:00</td>\n",
       "      <td>4.15</td>\n",
       "      <td>12680.0</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541907</th>\n",
       "      <td>581587</td>\n",
       "      <td>23255</td>\n",
       "      <td>CHILDRENS CUTLERY CIRCUS PARADE</td>\n",
       "      <td>4</td>\n",
       "      <td>2011-12-09 12:50:00</td>\n",
       "      <td>4.15</td>\n",
       "      <td>12680.0</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541908</th>\n",
       "      <td>581587</td>\n",
       "      <td>22138</td>\n",
       "      <td>BAKING SET 9 PIECE RETROSPOT</td>\n",
       "      <td>3</td>\n",
       "      <td>2011-12-09 12:50:00</td>\n",
       "      <td>4.95</td>\n",
       "      <td>12680.0</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>541909 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       InvoiceNo StockCode                          Description  Quantity  \\\n",
       "0         536365    85123A   WHITE HANGING HEART T-LIGHT HOLDER         6   \n",
       "1         536365     71053                  WHITE METAL LANTERN         6   \n",
       "2         536365    84406B       CREAM CUPID HEARTS COAT HANGER         8   \n",
       "3         536365    84029G  KNITTED UNION FLAG HOT WATER BOTTLE         6   \n",
       "4         536365    84029E       RED WOOLLY HOTTIE WHITE HEART.         6   \n",
       "5         536365     22752         SET 7 BABUSHKA NESTING BOXES         2   \n",
       "6         536365     21730    GLASS STAR FROSTED T-LIGHT HOLDER         6   \n",
       "7         536366     22633               HAND WARMER UNION JACK         6   \n",
       "8         536366     22632            HAND WARMER RED POLKA DOT         6   \n",
       "9         536367     84879        ASSORTED COLOUR BIRD ORNAMENT        32   \n",
       "10        536367     22745           POPPY'S PLAYHOUSE BEDROOM          6   \n",
       "11        536367     22748            POPPY'S PLAYHOUSE KITCHEN         6   \n",
       "12        536367     22749    FELTCRAFT PRINCESS CHARLOTTE DOLL         8   \n",
       "13        536367     22310              IVORY KNITTED MUG COSY          6   \n",
       "14        536367     84969   BOX OF 6 ASSORTED COLOUR TEASPOONS         6   \n",
       "15        536367     22623        BOX OF VINTAGE JIGSAW BLOCKS          3   \n",
       "16        536367     22622       BOX OF VINTAGE ALPHABET BLOCKS         2   \n",
       "17        536367     21754             HOME BUILDING BLOCK WORD         3   \n",
       "18        536367     21755             LOVE BUILDING BLOCK WORD         3   \n",
       "19        536367     21777          RECIPE BOX WITH METAL HEART         4   \n",
       "20        536367     48187                  DOORMAT NEW ENGLAND         4   \n",
       "21        536368     22960             JAM MAKING SET WITH JARS         6   \n",
       "22        536368     22913          RED COAT RACK PARIS FASHION         3   \n",
       "23        536368     22912       YELLOW COAT RACK PARIS FASHION         3   \n",
       "24        536368     22914         BLUE COAT RACK PARIS FASHION         3   \n",
       "25        536369     21756             BATH BUILDING BLOCK WORD         3   \n",
       "26        536370     22728            ALARM CLOCK BAKELIKE PINK        24   \n",
       "27        536370     22727            ALARM CLOCK BAKELIKE RED         24   \n",
       "28        536370     22726           ALARM CLOCK BAKELIKE GREEN        12   \n",
       "29        536370     21724      PANDA AND BUNNIES STICKER SHEET        12   \n",
       "...          ...       ...                                  ...       ...   \n",
       "541879    581585     22726           ALARM CLOCK BAKELIKE GREEN         8   \n",
       "541880    581585     22727            ALARM CLOCK BAKELIKE RED          4   \n",
       "541881    581585     16016          LARGE CHINESE STYLE SCISSOR        10   \n",
       "541882    581585     21916      SET 12 RETRO WHITE CHALK STICKS        24   \n",
       "541883    581585     84692          BOX OF 24 COCKTAIL PARASOLS        25   \n",
       "541884    581585     84946         ANTIQUE SILVER T-LIGHT GLASS        12   \n",
       "541885    581585     21684     SMALL MEDINA STAMPED METAL BOWL         12   \n",
       "541886    581585     22398           MAGNETS PACK OF 4 SWALLOWS        12   \n",
       "541887    581585     23328   SET 6 SCHOOL MILK BOTTLES IN CRATE         4   \n",
       "541888    581585     23145       ZINC T-LIGHT HOLDER STAR LARGE        12   \n",
       "541889    581585     22466       FAIRY TALE COTTAGE NIGHT LIGHT        12   \n",
       "541890    581586     22061  LARGE CAKE STAND  HANGING STRAWBERY         8   \n",
       "541891    581586     23275     SET OF 3 HANGING OWLS OLLIE BEAK        24   \n",
       "541892    581586     21217        RED RETROSPOT ROUND CAKE TINS        24   \n",
       "541893    581586     20685                DOORMAT RED RETROSPOT        10   \n",
       "541894    581587     22631             CIRCUS PARADE LUNCH BOX         12   \n",
       "541895    581587     22556       PLASTERS IN TIN CIRCUS PARADE         12   \n",
       "541896    581587     22555            PLASTERS IN TIN STRONGMAN        12   \n",
       "541897    581587     22728            ALARM CLOCK BAKELIKE PINK         4   \n",
       "541898    581587     22727            ALARM CLOCK BAKELIKE RED          4   \n",
       "541899    581587     22726           ALARM CLOCK BAKELIKE GREEN         4   \n",
       "541900    581587     22730           ALARM CLOCK BAKELIKE IVORY         4   \n",
       "541901    581587     22367      CHILDRENS APRON SPACEBOY DESIGN         8   \n",
       "541902    581587     22629                  SPACEBOY LUNCH BOX         12   \n",
       "541903    581587     23256          CHILDRENS CUTLERY SPACEBOY          4   \n",
       "541904    581587     22613          PACK OF 20 SPACEBOY NAPKINS        12   \n",
       "541905    581587     22899         CHILDREN'S APRON DOLLY GIRL          6   \n",
       "541906    581587     23254        CHILDRENS CUTLERY DOLLY GIRL          4   \n",
       "541907    581587     23255      CHILDRENS CUTLERY CIRCUS PARADE         4   \n",
       "541908    581587     22138        BAKING SET 9 PIECE RETROSPOT          3   \n",
       "\n",
       "               InvoiceDate  UnitPrice  CustomerID         Country  \n",
       "0      2010-12-01 08:26:00       2.55     17850.0  United Kingdom  \n",
       "1      2010-12-01 08:26:00       3.39     17850.0  United Kingdom  \n",
       "2      2010-12-01 08:26:00       2.75     17850.0  United Kingdom  \n",
       "3      2010-12-01 08:26:00       3.39     17850.0  United Kingdom  \n",
       "4      2010-12-01 08:26:00       3.39     17850.0  United Kingdom  \n",
       "5      2010-12-01 08:26:00       7.65     17850.0  United Kingdom  \n",
       "6      2010-12-01 08:26:00       4.25     17850.0  United Kingdom  \n",
       "7      2010-12-01 08:28:00       1.85     17850.0  United Kingdom  \n",
       "8      2010-12-01 08:28:00       1.85     17850.0  United Kingdom  \n",
       "9      2010-12-01 08:34:00       1.69     13047.0  United Kingdom  \n",
       "10     2010-12-01 08:34:00       2.10     13047.0  United Kingdom  \n",
       "11     2010-12-01 08:34:00       2.10     13047.0  United Kingdom  \n",
       "12     2010-12-01 08:34:00       3.75     13047.0  United Kingdom  \n",
       "13     2010-12-01 08:34:00       1.65     13047.0  United Kingdom  \n",
       "14     2010-12-01 08:34:00       4.25     13047.0  United Kingdom  \n",
       "15     2010-12-01 08:34:00       4.95     13047.0  United Kingdom  \n",
       "16     2010-12-01 08:34:00       9.95     13047.0  United Kingdom  \n",
       "17     2010-12-01 08:34:00       5.95     13047.0  United Kingdom  \n",
       "18     2010-12-01 08:34:00       5.95     13047.0  United Kingdom  \n",
       "19     2010-12-01 08:34:00       7.95     13047.0  United Kingdom  \n",
       "20     2010-12-01 08:34:00       7.95     13047.0  United Kingdom  \n",
       "21     2010-12-01 08:34:00       4.25     13047.0  United Kingdom  \n",
       "22     2010-12-01 08:34:00       4.95     13047.0  United Kingdom  \n",
       "23     2010-12-01 08:34:00       4.95     13047.0  United Kingdom  \n",
       "24     2010-12-01 08:34:00       4.95     13047.0  United Kingdom  \n",
       "25     2010-12-01 08:35:00       5.95     13047.0  United Kingdom  \n",
       "26     2010-12-01 08:45:00       3.75     12583.0          France  \n",
       "27     2010-12-01 08:45:00       3.75     12583.0          France  \n",
       "28     2010-12-01 08:45:00       3.75     12583.0          France  \n",
       "29     2010-12-01 08:45:00       0.85     12583.0          France  \n",
       "...                    ...        ...         ...             ...  \n",
       "541879 2011-12-09 12:31:00       3.75     15804.0  United Kingdom  \n",
       "541880 2011-12-09 12:31:00       3.75     15804.0  United Kingdom  \n",
       "541881 2011-12-09 12:31:00       0.85     15804.0  United Kingdom  \n",
       "541882 2011-12-09 12:31:00       0.42     15804.0  United Kingdom  \n",
       "541883 2011-12-09 12:31:00       0.42     15804.0  United Kingdom  \n",
       "541884 2011-12-09 12:31:00       1.25     15804.0  United Kingdom  \n",
       "541885 2011-12-09 12:31:00       0.85     15804.0  United Kingdom  \n",
       "541886 2011-12-09 12:31:00       0.39     15804.0  United Kingdom  \n",
       "541887 2011-12-09 12:31:00       3.75     15804.0  United Kingdom  \n",
       "541888 2011-12-09 12:31:00       0.95     15804.0  United Kingdom  \n",
       "541889 2011-12-09 12:31:00       1.95     15804.0  United Kingdom  \n",
       "541890 2011-12-09 12:49:00       2.95     13113.0  United Kingdom  \n",
       "541891 2011-12-09 12:49:00       1.25     13113.0  United Kingdom  \n",
       "541892 2011-12-09 12:49:00       8.95     13113.0  United Kingdom  \n",
       "541893 2011-12-09 12:49:00       7.08     13113.0  United Kingdom  \n",
       "541894 2011-12-09 12:50:00       1.95     12680.0          France  \n",
       "541895 2011-12-09 12:50:00       1.65     12680.0          France  \n",
       "541896 2011-12-09 12:50:00       1.65     12680.0          France  \n",
       "541897 2011-12-09 12:50:00       3.75     12680.0          France  \n",
       "541898 2011-12-09 12:50:00       3.75     12680.0          France  \n",
       "541899 2011-12-09 12:50:00       3.75     12680.0          France  \n",
       "541900 2011-12-09 12:50:00       3.75     12680.0          France  \n",
       "541901 2011-12-09 12:50:00       1.95     12680.0          France  \n",
       "541902 2011-12-09 12:50:00       1.95     12680.0          France  \n",
       "541903 2011-12-09 12:50:00       4.15     12680.0          France  \n",
       "541904 2011-12-09 12:50:00       0.85     12680.0          France  \n",
       "541905 2011-12-09 12:50:00       2.10     12680.0          France  \n",
       "541906 2011-12-09 12:50:00       4.15     12680.0          France  \n",
       "541907 2011-12-09 12:50:00       4.15     12680.0          France  \n",
       "541908 2011-12-09 12:50:00       4.95     12680.0          France  \n",
       "\n",
       "[541909 rows x 8 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df=pd.read_excel(r\"C:\\Users\\TANVI\\Desktop\\New folder\\Online Retail.xlsx\")\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>InvoiceNo</th>\n",
       "      <th>StockCode</th>\n",
       "      <th>Description</th>\n",
       "      <th>Quantity</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1443</th>\n",
       "      <td>536544</td>\n",
       "      <td>21773</td>\n",
       "      <td>DECORATIVE ROSE BATHROOM BOTTLE</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1444</th>\n",
       "      <td>536544</td>\n",
       "      <td>21774</td>\n",
       "      <td>DECORATIVE CATS BATHROOM BOTTLE</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1445</th>\n",
       "      <td>536544</td>\n",
       "      <td>21786</td>\n",
       "      <td>POLKADOT RAIN HAT</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1446</th>\n",
       "      <td>536544</td>\n",
       "      <td>21787</td>\n",
       "      <td>RAIN PONCHO RETROSPOT</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1447</th>\n",
       "      <td>536544</td>\n",
       "      <td>21790</td>\n",
       "      <td>VINTAGE SNAP CARDS</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1448</th>\n",
       "      <td>536544</td>\n",
       "      <td>21791</td>\n",
       "      <td>VINTAGE HEADS AND TAILS CARD GAME</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1449</th>\n",
       "      <td>536544</td>\n",
       "      <td>21801</td>\n",
       "      <td>CHRISTMAS TREE DECORATION WITH BELL</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1450</th>\n",
       "      <td>536544</td>\n",
       "      <td>21802</td>\n",
       "      <td>CHRISTMAS TREE HEART DECORATION</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1451</th>\n",
       "      <td>536544</td>\n",
       "      <td>21803</td>\n",
       "      <td>CHRISTMAS TREE STAR DECORATION</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1452</th>\n",
       "      <td>536544</td>\n",
       "      <td>21809</td>\n",
       "      <td>CHRISTMAS HANGING TREE WITH BELL</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1453</th>\n",
       "      <td>536544</td>\n",
       "      <td>21810</td>\n",
       "      <td>CHRISTMAS HANGING STAR WITH BELL</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1454</th>\n",
       "      <td>536544</td>\n",
       "      <td>21811</td>\n",
       "      <td>CHRISTMAS HANGING HEART WITH BELL</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1455</th>\n",
       "      <td>536544</td>\n",
       "      <td>21821</td>\n",
       "      <td>GLITTER STAR GARLAND WITH BELLS</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1456</th>\n",
       "      <td>536544</td>\n",
       "      <td>21822</td>\n",
       "      <td>GLITTER CHRISTMAS TREE WITH BELLS</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1457</th>\n",
       "      <td>536544</td>\n",
       "      <td>21823</td>\n",
       "      <td>PAINTED METAL HEART WITH HOLLY BELL</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1458</th>\n",
       "      <td>536544</td>\n",
       "      <td>21844</td>\n",
       "      <td>RED RETROSPOT MUG</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1459</th>\n",
       "      <td>536544</td>\n",
       "      <td>21851</td>\n",
       "      <td>LILAC DIAMANTE PEN IN GIFT BOX</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1460</th>\n",
       "      <td>536544</td>\n",
       "      <td>21870</td>\n",
       "      <td>I CAN ONLY PLEASE ONE PERSON MUG</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1461</th>\n",
       "      <td>536544</td>\n",
       "      <td>21871</td>\n",
       "      <td>SAVE THE PLANET MUG</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1462</th>\n",
       "      <td>536544</td>\n",
       "      <td>21874</td>\n",
       "      <td>GIN AND TONIC MUG</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1463</th>\n",
       "      <td>536544</td>\n",
       "      <td>21879</td>\n",
       "      <td>HEARTS GIFT TAPE</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1464</th>\n",
       "      <td>536544</td>\n",
       "      <td>21884</td>\n",
       "      <td>CAKES AND BOWS GIFT  TAPE</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1465</th>\n",
       "      <td>536544</td>\n",
       "      <td>21888</td>\n",
       "      <td>BINGO SET</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1466</th>\n",
       "      <td>536544</td>\n",
       "      <td>21889</td>\n",
       "      <td>WOODEN BOX OF DOMINOES</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1467</th>\n",
       "      <td>536544</td>\n",
       "      <td>21892</td>\n",
       "      <td>TRADITIONAL WOODEN CATCH CUP GAME</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1468</th>\n",
       "      <td>536544</td>\n",
       "      <td>21894</td>\n",
       "      <td>POTTING SHED SEED ENVELOPES</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1469</th>\n",
       "      <td>536544</td>\n",
       "      <td>21911</td>\n",
       "      <td>GARDEN METAL SIGN</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1470</th>\n",
       "      <td>536544</td>\n",
       "      <td>21912</td>\n",
       "      <td>VINTAGE SNAKES &amp; LADDERS</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1471</th>\n",
       "      <td>536544</td>\n",
       "      <td>21913</td>\n",
       "      <td>VINTAGE SEASIDE JIGSAW PUZZLES</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1472</th>\n",
       "      <td>536544</td>\n",
       "      <td>21914</td>\n",
       "      <td>BLUE HARMONICA IN BOX</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1940</th>\n",
       "      <td>536544</td>\n",
       "      <td>21369</td>\n",
       "      <td>MIRRORED WALL ART SPLODGES</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1941</th>\n",
       "      <td>536544</td>\n",
       "      <td>21372</td>\n",
       "      <td>MIRRORED WALL ART TABLE LAMP</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1942</th>\n",
       "      <td>536544</td>\n",
       "      <td>21385</td>\n",
       "      <td>IVORY HANGING DECORATION  HEART</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1943</th>\n",
       "      <td>536544</td>\n",
       "      <td>21407</td>\n",
       "      <td>BROWN CHECK CAT DOORSTOP</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1944</th>\n",
       "      <td>536544</td>\n",
       "      <td>21408</td>\n",
       "      <td>SPOTTY PINK DUCK DOORSTOP</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1945</th>\n",
       "      <td>536544</td>\n",
       "      <td>21429</td>\n",
       "      <td>RED GINGHAM ROSE JEWELLERY BOX</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1946</th>\n",
       "      <td>536544</td>\n",
       "      <td>21479</td>\n",
       "      <td>WHITE SKULL HOT WATER BOTTLE</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1947</th>\n",
       "      <td>536544</td>\n",
       "      <td>21484</td>\n",
       "      <td>CHICK GREY HOT WATER BOTTLE</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1948</th>\n",
       "      <td>536544</td>\n",
       "      <td>21486</td>\n",
       "      <td>PINK HEART DOTS HOT WATER BOTTLE</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1949</th>\n",
       "      <td>536544</td>\n",
       "      <td>21488</td>\n",
       "      <td>RED WHITE SCARF  HOT WATER BOTTLE</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1950</th>\n",
       "      <td>536544</td>\n",
       "      <td>21507</td>\n",
       "      <td>ELEPHANT, BIRTHDAY CARD,</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1951</th>\n",
       "      <td>536544</td>\n",
       "      <td>21523</td>\n",
       "      <td>DOORMAT FANCY FONT HOME SWEET HOME</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1952</th>\n",
       "      <td>536544</td>\n",
       "      <td>21559</td>\n",
       "      <td>STRAWBERRY LUNCH BOX WITH CUTLERY</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1953</th>\n",
       "      <td>536544</td>\n",
       "      <td>21563</td>\n",
       "      <td>RED HEART SHAPE LOVE BUCKET</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1954</th>\n",
       "      <td>536544</td>\n",
       "      <td>21564</td>\n",
       "      <td>PINK  HEART SHAPE LOVE BUCKET</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1955</th>\n",
       "      <td>536544</td>\n",
       "      <td>21577</td>\n",
       "      <td>SAVE THE PLANET COTTON TOTE BAG</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1956</th>\n",
       "      <td>536544</td>\n",
       "      <td>21634</td>\n",
       "      <td>ASSORTED MINI MADRAS NOTEBOOK</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1957</th>\n",
       "      <td>536544</td>\n",
       "      <td>21641</td>\n",
       "      <td>ASSORTED TUTTI FRUTTI KEYRING BALL</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1958</th>\n",
       "      <td>536544</td>\n",
       "      <td>21658</td>\n",
       "      <td>GLASS  BEURRE DISH</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1959</th>\n",
       "      <td>536544</td>\n",
       "      <td>21662</td>\n",
       "      <td>VINTAGE GLASS COFFEE CADDY</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1960</th>\n",
       "      <td>536544</td>\n",
       "      <td>21679</td>\n",
       "      <td>SKULLS  STICKERS</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961</th>\n",
       "      <td>536544</td>\n",
       "      <td>21703</td>\n",
       "      <td>BAG 125g SWIRLY MARBLES</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962</th>\n",
       "      <td>536544</td>\n",
       "      <td>21704</td>\n",
       "      <td>BAG 250g SWIRLY MARBLES</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1963</th>\n",
       "      <td>536544</td>\n",
       "      <td>21706</td>\n",
       "      <td>FOLDING UMBRELLA RED/WHITE POLKADOT</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1964</th>\n",
       "      <td>536544</td>\n",
       "      <td>21716</td>\n",
       "      <td>BOYS VINTAGE TIN SEASIDE BUCKET</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1965</th>\n",
       "      <td>536544</td>\n",
       "      <td>21721</td>\n",
       "      <td>CANDY SHOP  STICKER SHEET</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1966</th>\n",
       "      <td>536544</td>\n",
       "      <td>21722</td>\n",
       "      <td>SWEET PUDDING STICKER SHEET</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1967</th>\n",
       "      <td>536544</td>\n",
       "      <td>21731</td>\n",
       "      <td>RED TOADSTOOL LED NIGHT LIGHT</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1968</th>\n",
       "      <td>536544</td>\n",
       "      <td>21742</td>\n",
       "      <td>LARGE ROUND WICKER PLATTER</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1969</th>\n",
       "      <td>536544</td>\n",
       "      <td>21758</td>\n",
       "      <td>VINTAGE SHELLS PRINT</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>527 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     InvoiceNo StockCode                          Description  Quantity\n",
       "1443    536544     21773      DECORATIVE ROSE BATHROOM BOTTLE         1\n",
       "1444    536544     21774      DECORATIVE CATS BATHROOM BOTTLE         2\n",
       "1445    536544     21786                   POLKADOT RAIN HAT          4\n",
       "1446    536544     21787                RAIN PONCHO RETROSPOT         2\n",
       "1447    536544     21790                   VINTAGE SNAP CARDS         9\n",
       "1448    536544     21791   VINTAGE HEADS AND TAILS CARD GAME          2\n",
       "1449    536544     21801  CHRISTMAS TREE DECORATION WITH BELL        10\n",
       "1450    536544     21802      CHRISTMAS TREE HEART DECORATION         9\n",
       "1451    536544     21803       CHRISTMAS TREE STAR DECORATION        11\n",
       "1452    536544     21809     CHRISTMAS HANGING TREE WITH BELL         1\n",
       "1453    536544     21810     CHRISTMAS HANGING STAR WITH BELL         3\n",
       "1454    536544     21811    CHRISTMAS HANGING HEART WITH BELL         1\n",
       "1455    536544     21821     GLITTER STAR GARLAND WITH BELLS          1\n",
       "1456    536544     21822    GLITTER CHRISTMAS TREE WITH BELLS         1\n",
       "1457    536544     21823  PAINTED METAL HEART WITH HOLLY BELL         2\n",
       "1458    536544     21844                    RED RETROSPOT MUG         2\n",
       "1459    536544     21851       LILAC DIAMANTE PEN IN GIFT BOX         1\n",
       "1460    536544     21870     I CAN ONLY PLEASE ONE PERSON MUG         1\n",
       "1461    536544     21871                  SAVE THE PLANET MUG         5\n",
       "1462    536544     21874                    GIN AND TONIC MUG         1\n",
       "1463    536544     21879                     HEARTS GIFT TAPE         1\n",
       "1464    536544     21884            CAKES AND BOWS GIFT  TAPE         1\n",
       "1465    536544     21888                            BINGO SET         1\n",
       "1466    536544     21889               WOODEN BOX OF DOMINOES         2\n",
       "1467    536544     21892   TRADITIONAL WOODEN CATCH CUP GAME          3\n",
       "1468    536544     21894          POTTING SHED SEED ENVELOPES         1\n",
       "1469    536544     21911                   GARDEN METAL SIGN          1\n",
       "1470    536544     21912             VINTAGE SNAKES & LADDERS         3\n",
       "1471    536544     21913       VINTAGE SEASIDE JIGSAW PUZZLES         1\n",
       "1472    536544     21914               BLUE HARMONICA IN BOX          3\n",
       "...        ...       ...                                  ...       ...\n",
       "1940    536544     21369           MIRRORED WALL ART SPLODGES         1\n",
       "1941    536544     21372         MIRRORED WALL ART TABLE LAMP         1\n",
       "1942    536544     21385      IVORY HANGING DECORATION  HEART         2\n",
       "1943    536544     21407            BROWN CHECK CAT DOORSTOP          2\n",
       "1944    536544     21408            SPOTTY PINK DUCK DOORSTOP         1\n",
       "1945    536544     21429       RED GINGHAM ROSE JEWELLERY BOX         5\n",
       "1946    536544     21479        WHITE SKULL HOT WATER BOTTLE          5\n",
       "1947    536544     21484          CHICK GREY HOT WATER BOTTLE         4\n",
       "1948    536544     21486     PINK HEART DOTS HOT WATER BOTTLE         1\n",
       "1949    536544     21488    RED WHITE SCARF  HOT WATER BOTTLE         1\n",
       "1950    536544     21507            ELEPHANT, BIRTHDAY CARD,          1\n",
       "1951    536544     21523   DOORMAT FANCY FONT HOME SWEET HOME         1\n",
       "1952    536544     21559    STRAWBERRY LUNCH BOX WITH CUTLERY         1\n",
       "1953    536544     21563         RED HEART SHAPE LOVE BUCKET          2\n",
       "1954    536544     21564       PINK  HEART SHAPE LOVE BUCKET          2\n",
       "1955    536544     21577      SAVE THE PLANET COTTON TOTE BAG         2\n",
       "1956    536544     21634        ASSORTED MINI MADRAS NOTEBOOK         1\n",
       "1957    536544     21641   ASSORTED TUTTI FRUTTI KEYRING BALL         1\n",
       "1958    536544     21658                   GLASS  BEURRE DISH         1\n",
       "1959    536544     21662           VINTAGE GLASS COFFEE CADDY         2\n",
       "1960    536544     21679                     SKULLS  STICKERS         3\n",
       "1961    536544     21703              BAG 125g SWIRLY MARBLES         1\n",
       "1962    536544     21704              BAG 250g SWIRLY MARBLES         1\n",
       "1963    536544     21706  FOLDING UMBRELLA RED/WHITE POLKADOT         2\n",
       "1964    536544     21716      BOYS VINTAGE TIN SEASIDE BUCKET         1\n",
       "1965    536544     21721            CANDY SHOP  STICKER SHEET         1\n",
       "1966    536544     21722          SWEET PUDDING STICKER SHEET         1\n",
       "1967    536544     21731        RED TOADSTOOL LED NIGHT LIGHT         5\n",
       "1968    536544     21742          LARGE ROUND WICKER PLATTER          1\n",
       "1969    536544     21758                 VINTAGE SHELLS PRINT         1\n",
       "\n",
       "[527 rows x 4 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#1-a(i)\n",
    "df1=df[['InvoiceNo','StockCode','Description','Quantity']].copy()\n",
    "df1=df1.loc[df.InvoiceNo==536544]\n",
    "df1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Min = -11062.06 \n",
      "Max = 38970.0 \n",
      "Median = 2.08 \n",
      "Mean = 4.611113626083471 \n",
      "Standard Deviation = 96.75985306119716 \n",
      "Variance = 9362.469164424467 \n",
      "Sum = 2498803.974 \n",
      "Count = 541909\n"
     ]
    }
   ],
   "source": [
    "#1-b(i)\n",
    "df2=df['UnitPrice']\n",
    "print(\"Min =\",df2.min(axis=0),\"\\nMax =\",df2.max(axis=0),\"\\nMedian =\",df2.median(),\"\\nMean =\",df2.mean(),\"\\nStandard Deviation =\",df2.std(),\"\\nVariance =\",df2.var(),\"\\nSum =\",df2.sum(),\"\\nCount =\",df2.count())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>InvoiceNo</th>\n",
       "      <th>StockCode</th>\n",
       "      <th>Description</th>\n",
       "      <th>Quantity</th>\n",
       "      <th>InvoiceDate</th>\n",
       "      <th>UnitPrice</th>\n",
       "      <th>CustomerID</th>\n",
       "      <th>Country</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>536378</td>\n",
       "      <td>84519A</td>\n",
       "      <td>TOMATO CHARLIE+LOLA COASTER SET</td>\n",
       "      <td>6</td>\n",
       "      <td>2010-12-01 09:37:00</td>\n",
       "      <td>2.95</td>\n",
       "      <td>14688.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>536378</td>\n",
       "      <td>85183B</td>\n",
       "      <td>CHARLIE &amp; LOLA WASTEPAPER BIN FLORA</td>\n",
       "      <td>48</td>\n",
       "      <td>2010-12-01 09:37:00</td>\n",
       "      <td>1.25</td>\n",
       "      <td>14688.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>536378</td>\n",
       "      <td>85071B</td>\n",
       "      <td>RED CHARLIE+LOLA PERSONAL DOORSIGN</td>\n",
       "      <td>96</td>\n",
       "      <td>2010-12-01 09:37:00</td>\n",
       "      <td>0.38</td>\n",
       "      <td>14688.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>536378</td>\n",
       "      <td>21931</td>\n",
       "      <td>JUMBO STORAGE BAG SUKI</td>\n",
       "      <td>10</td>\n",
       "      <td>2010-12-01 09:37:00</td>\n",
       "      <td>1.95</td>\n",
       "      <td>14688.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>536378</td>\n",
       "      <td>21929</td>\n",
       "      <td>JUMBO BAG PINK VINTAGE PAISLEY</td>\n",
       "      <td>10</td>\n",
       "      <td>2010-12-01 09:37:00</td>\n",
       "      <td>1.95</td>\n",
       "      <td>14688.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>536380</td>\n",
       "      <td>22961</td>\n",
       "      <td>JAM MAKING SET PRINTED</td>\n",
       "      <td>24</td>\n",
       "      <td>2010-12-01 09:41:00</td>\n",
       "      <td>1.45</td>\n",
       "      <td>17809.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>536381</td>\n",
       "      <td>22139</td>\n",
       "      <td>RETROSPOT TEA SET CERAMIC 11 PC</td>\n",
       "      <td>23</td>\n",
       "      <td>2010-12-01 09:41:00</td>\n",
       "      <td>4.25</td>\n",
       "      <td>15311.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>536381</td>\n",
       "      <td>84854</td>\n",
       "      <td>GIRLY PINK TOOL SET</td>\n",
       "      <td>5</td>\n",
       "      <td>2010-12-01 09:41:00</td>\n",
       "      <td>4.95</td>\n",
       "      <td>15311.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>536381</td>\n",
       "      <td>22411</td>\n",
       "      <td>JUMBO SHOPPER VINTAGE RED PAISLEY</td>\n",
       "      <td>10</td>\n",
       "      <td>2010-12-01 09:41:00</td>\n",
       "      <td>1.95</td>\n",
       "      <td>15311.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>536381</td>\n",
       "      <td>82567</td>\n",
       "      <td>AIRLINE LOUNGE,METAL SIGN</td>\n",
       "      <td>2</td>\n",
       "      <td>2010-12-01 09:41:00</td>\n",
       "      <td>2.10</td>\n",
       "      <td>15311.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>536381</td>\n",
       "      <td>21672</td>\n",
       "      <td>WHITE SPOT RED CERAMIC DRAWER KNOB</td>\n",
       "      <td>6</td>\n",
       "      <td>2010-12-01 09:41:00</td>\n",
       "      <td>1.25</td>\n",
       "      <td>15311.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>536381</td>\n",
       "      <td>22774</td>\n",
       "      <td>RED DRAWER KNOB ACRYLIC EDWARDIAN</td>\n",
       "      <td>24</td>\n",
       "      <td>2010-12-01 09:41:00</td>\n",
       "      <td>1.25</td>\n",
       "      <td>15311.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>536381</td>\n",
       "      <td>22771</td>\n",
       "      <td>CLEAR DRAWER KNOB ACRYLIC EDWARDIAN</td>\n",
       "      <td>24</td>\n",
       "      <td>2010-12-01 09:41:00</td>\n",
       "      <td>1.25</td>\n",
       "      <td>15311.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>536381</td>\n",
       "      <td>71270</td>\n",
       "      <td>PHOTO CLIP LINE</td>\n",
       "      <td>1</td>\n",
       "      <td>2010-12-01 09:41:00</td>\n",
       "      <td>1.25</td>\n",
       "      <td>15311.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>536381</td>\n",
       "      <td>22262</td>\n",
       "      <td>FELT EGG COSY CHICKEN</td>\n",
       "      <td>1</td>\n",
       "      <td>2010-12-01 09:41:00</td>\n",
       "      <td>0.85</td>\n",
       "      <td>15311.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>536381</td>\n",
       "      <td>22637</td>\n",
       "      <td>PIGGY BANK RETROSPOT</td>\n",
       "      <td>1</td>\n",
       "      <td>2010-12-01 09:41:00</td>\n",
       "      <td>2.55</td>\n",
       "      <td>15311.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>536381</td>\n",
       "      <td>21934</td>\n",
       "      <td>SKULL SHOULDER BAG</td>\n",
       "      <td>10</td>\n",
       "      <td>2010-12-01 09:41:00</td>\n",
       "      <td>1.65</td>\n",
       "      <td>15311.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>536381</td>\n",
       "      <td>21169</td>\n",
       "      <td>YOU'RE CONFUSING ME METAL SIGN</td>\n",
       "      <td>3</td>\n",
       "      <td>2010-12-01 09:41:00</td>\n",
       "      <td>1.69</td>\n",
       "      <td>15311.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>536381</td>\n",
       "      <td>21166</td>\n",
       "      <td>COOK WITH WINE METAL SIGN</td>\n",
       "      <td>1</td>\n",
       "      <td>2010-12-01 09:41:00</td>\n",
       "      <td>1.95</td>\n",
       "      <td>15311.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>536381</td>\n",
       "      <td>21175</td>\n",
       "      <td>GIN + TONIC DIET METAL SIGN</td>\n",
       "      <td>2</td>\n",
       "      <td>2010-12-01 09:41:00</td>\n",
       "      <td>2.10</td>\n",
       "      <td>15311.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>536381</td>\n",
       "      <td>37444A</td>\n",
       "      <td>YELLOW BREAKFAST CUP AND SAUCER</td>\n",
       "      <td>1</td>\n",
       "      <td>2010-12-01 09:41:00</td>\n",
       "      <td>2.95</td>\n",
       "      <td>15311.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>536381</td>\n",
       "      <td>37444C</td>\n",
       "      <td>PINK BREAKFAST CUP AND SAUCER</td>\n",
       "      <td>1</td>\n",
       "      <td>2010-12-01 09:41:00</td>\n",
       "      <td>2.95</td>\n",
       "      <td>15311.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>536381</td>\n",
       "      <td>22086</td>\n",
       "      <td>PAPER CHAIN KIT 50'S CHRISTMAS</td>\n",
       "      <td>4</td>\n",
       "      <td>2010-12-01 09:41:00</td>\n",
       "      <td>2.95</td>\n",
       "      <td>15311.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>536381</td>\n",
       "      <td>22083</td>\n",
       "      <td>PAPER CHAIN KIT RETROSPOT</td>\n",
       "      <td>1</td>\n",
       "      <td>2010-12-01 09:41:00</td>\n",
       "      <td>2.95</td>\n",
       "      <td>15311.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>536381</td>\n",
       "      <td>84971S</td>\n",
       "      <td>SMALL HEART FLOWERS HOOK</td>\n",
       "      <td>6</td>\n",
       "      <td>2010-12-01 09:41:00</td>\n",
       "      <td>0.85</td>\n",
       "      <td>15311.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>536381</td>\n",
       "      <td>71270</td>\n",
       "      <td>PHOTO CLIP LINE</td>\n",
       "      <td>3</td>\n",
       "      <td>2010-12-01 09:41:00</td>\n",
       "      <td>1.25</td>\n",
       "      <td>15311.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>536381</td>\n",
       "      <td>47580</td>\n",
       "      <td>TEA TIME DES TEA COSY</td>\n",
       "      <td>2</td>\n",
       "      <td>2010-12-01 09:41:00</td>\n",
       "      <td>2.55</td>\n",
       "      <td>15311.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>536381</td>\n",
       "      <td>22261</td>\n",
       "      <td>FELT EGG COSY WHITE RABBIT</td>\n",
       "      <td>1</td>\n",
       "      <td>2010-12-01 09:41:00</td>\n",
       "      <td>0.85</td>\n",
       "      <td>15311.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>536381</td>\n",
       "      <td>84832</td>\n",
       "      <td>ZINC WILLIE WINKIE  CANDLE STICK</td>\n",
       "      <td>1</td>\n",
       "      <td>2010-12-01 09:41:00</td>\n",
       "      <td>0.85</td>\n",
       "      <td>15311.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>536381</td>\n",
       "      <td>22644</td>\n",
       "      <td>CERAMIC CHERRY CAKE MONEY BANK</td>\n",
       "      <td>1</td>\n",
       "      <td>2010-12-01 09:41:00</td>\n",
       "      <td>1.45</td>\n",
       "      <td>15311.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541779</th>\n",
       "      <td>581585</td>\n",
       "      <td>22726</td>\n",
       "      <td>ALARM CLOCK BAKELIKE GREEN</td>\n",
       "      <td>8</td>\n",
       "      <td>2011-12-09 12:31:00</td>\n",
       "      <td>3.75</td>\n",
       "      <td>15804.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541780</th>\n",
       "      <td>581585</td>\n",
       "      <td>22727</td>\n",
       "      <td>ALARM CLOCK BAKELIKE RED</td>\n",
       "      <td>4</td>\n",
       "      <td>2011-12-09 12:31:00</td>\n",
       "      <td>3.75</td>\n",
       "      <td>15804.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541781</th>\n",
       "      <td>581585</td>\n",
       "      <td>16016</td>\n",
       "      <td>LARGE CHINESE STYLE SCISSOR</td>\n",
       "      <td>10</td>\n",
       "      <td>2011-12-09 12:31:00</td>\n",
       "      <td>0.85</td>\n",
       "      <td>15804.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541782</th>\n",
       "      <td>581585</td>\n",
       "      <td>21916</td>\n",
       "      <td>SET 12 RETRO WHITE CHALK STICKS</td>\n",
       "      <td>24</td>\n",
       "      <td>2011-12-09 12:31:00</td>\n",
       "      <td>0.42</td>\n",
       "      <td>15804.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541783</th>\n",
       "      <td>581585</td>\n",
       "      <td>84692</td>\n",
       "      <td>BOX OF 24 COCKTAIL PARASOLS</td>\n",
       "      <td>25</td>\n",
       "      <td>2011-12-09 12:31:00</td>\n",
       "      <td>0.42</td>\n",
       "      <td>15804.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541784</th>\n",
       "      <td>581585</td>\n",
       "      <td>84946</td>\n",
       "      <td>ANTIQUE SILVER T-LIGHT GLASS</td>\n",
       "      <td>12</td>\n",
       "      <td>2011-12-09 12:31:00</td>\n",
       "      <td>1.25</td>\n",
       "      <td>15804.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541785</th>\n",
       "      <td>581585</td>\n",
       "      <td>21684</td>\n",
       "      <td>SMALL MEDINA STAMPED METAL BOWL</td>\n",
       "      <td>12</td>\n",
       "      <td>2011-12-09 12:31:00</td>\n",
       "      <td>0.85</td>\n",
       "      <td>15804.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541786</th>\n",
       "      <td>581585</td>\n",
       "      <td>22398</td>\n",
       "      <td>MAGNETS PACK OF 4 SWALLOWS</td>\n",
       "      <td>12</td>\n",
       "      <td>2011-12-09 12:31:00</td>\n",
       "      <td>0.39</td>\n",
       "      <td>15804.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541787</th>\n",
       "      <td>581585</td>\n",
       "      <td>23328</td>\n",
       "      <td>SET 6 SCHOOL MILK BOTTLES IN CRATE</td>\n",
       "      <td>4</td>\n",
       "      <td>2011-12-09 12:31:00</td>\n",
       "      <td>3.75</td>\n",
       "      <td>15804.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541788</th>\n",
       "      <td>581585</td>\n",
       "      <td>23145</td>\n",
       "      <td>ZINC T-LIGHT HOLDER STAR LARGE</td>\n",
       "      <td>12</td>\n",
       "      <td>2011-12-09 12:31:00</td>\n",
       "      <td>0.95</td>\n",
       "      <td>15804.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541789</th>\n",
       "      <td>581585</td>\n",
       "      <td>22466</td>\n",
       "      <td>FAIRY TALE COTTAGE NIGHT LIGHT</td>\n",
       "      <td>12</td>\n",
       "      <td>2011-12-09 12:31:00</td>\n",
       "      <td>1.95</td>\n",
       "      <td>15804.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541790</th>\n",
       "      <td>581586</td>\n",
       "      <td>22061</td>\n",
       "      <td>LARGE CAKE STAND  HANGING STRAWBERY</td>\n",
       "      <td>8</td>\n",
       "      <td>2011-12-09 12:49:00</td>\n",
       "      <td>2.95</td>\n",
       "      <td>13113.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541791</th>\n",
       "      <td>581586</td>\n",
       "      <td>23275</td>\n",
       "      <td>SET OF 3 HANGING OWLS OLLIE BEAK</td>\n",
       "      <td>24</td>\n",
       "      <td>2011-12-09 12:49:00</td>\n",
       "      <td>1.25</td>\n",
       "      <td>13113.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541792</th>\n",
       "      <td>581586</td>\n",
       "      <td>21217</td>\n",
       "      <td>RED RETROSPOT ROUND CAKE TINS</td>\n",
       "      <td>24</td>\n",
       "      <td>2011-12-09 12:49:00</td>\n",
       "      <td>8.95</td>\n",
       "      <td>13113.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541793</th>\n",
       "      <td>581586</td>\n",
       "      <td>20685</td>\n",
       "      <td>DOORMAT RED RETROSPOT</td>\n",
       "      <td>10</td>\n",
       "      <td>2011-12-09 12:49:00</td>\n",
       "      <td>7.08</td>\n",
       "      <td>13113.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541794</th>\n",
       "      <td>581587</td>\n",
       "      <td>22631</td>\n",
       "      <td>CIRCUS PARADE LUNCH BOX</td>\n",
       "      <td>12</td>\n",
       "      <td>2011-12-09 12:50:00</td>\n",
       "      <td>1.95</td>\n",
       "      <td>12680.0</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541795</th>\n",
       "      <td>581587</td>\n",
       "      <td>22556</td>\n",
       "      <td>PLASTERS IN TIN CIRCUS PARADE</td>\n",
       "      <td>12</td>\n",
       "      <td>2011-12-09 12:50:00</td>\n",
       "      <td>1.65</td>\n",
       "      <td>12680.0</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541796</th>\n",
       "      <td>581587</td>\n",
       "      <td>22555</td>\n",
       "      <td>PLASTERS IN TIN STRONGMAN</td>\n",
       "      <td>12</td>\n",
       "      <td>2011-12-09 12:50:00</td>\n",
       "      <td>1.65</td>\n",
       "      <td>12680.0</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541797</th>\n",
       "      <td>581587</td>\n",
       "      <td>22728</td>\n",
       "      <td>ALARM CLOCK BAKELIKE PINK</td>\n",
       "      <td>4</td>\n",
       "      <td>2011-12-09 12:50:00</td>\n",
       "      <td>3.75</td>\n",
       "      <td>12680.0</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541798</th>\n",
       "      <td>581587</td>\n",
       "      <td>22727</td>\n",
       "      <td>ALARM CLOCK BAKELIKE RED</td>\n",
       "      <td>4</td>\n",
       "      <td>2011-12-09 12:50:00</td>\n",
       "      <td>3.75</td>\n",
       "      <td>12680.0</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541799</th>\n",
       "      <td>581587</td>\n",
       "      <td>22726</td>\n",
       "      <td>ALARM CLOCK BAKELIKE GREEN</td>\n",
       "      <td>4</td>\n",
       "      <td>2011-12-09 12:50:00</td>\n",
       "      <td>3.75</td>\n",
       "      <td>12680.0</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541800</th>\n",
       "      <td>581587</td>\n",
       "      <td>22730</td>\n",
       "      <td>ALARM CLOCK BAKELIKE IVORY</td>\n",
       "      <td>4</td>\n",
       "      <td>2011-12-09 12:50:00</td>\n",
       "      <td>3.75</td>\n",
       "      <td>12680.0</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541801</th>\n",
       "      <td>581587</td>\n",
       "      <td>22367</td>\n",
       "      <td>CHILDRENS APRON SPACEBOY DESIGN</td>\n",
       "      <td>8</td>\n",
       "      <td>2011-12-09 12:50:00</td>\n",
       "      <td>1.95</td>\n",
       "      <td>12680.0</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541802</th>\n",
       "      <td>581587</td>\n",
       "      <td>22629</td>\n",
       "      <td>SPACEBOY LUNCH BOX</td>\n",
       "      <td>12</td>\n",
       "      <td>2011-12-09 12:50:00</td>\n",
       "      <td>1.95</td>\n",
       "      <td>12680.0</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541803</th>\n",
       "      <td>581587</td>\n",
       "      <td>23256</td>\n",
       "      <td>CHILDRENS CUTLERY SPACEBOY</td>\n",
       "      <td>4</td>\n",
       "      <td>2011-12-09 12:50:00</td>\n",
       "      <td>4.15</td>\n",
       "      <td>12680.0</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541804</th>\n",
       "      <td>581587</td>\n",
       "      <td>22613</td>\n",
       "      <td>PACK OF 20 SPACEBOY NAPKINS</td>\n",
       "      <td>12</td>\n",
       "      <td>2011-12-09 12:50:00</td>\n",
       "      <td>0.85</td>\n",
       "      <td>12680.0</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541805</th>\n",
       "      <td>581587</td>\n",
       "      <td>22899</td>\n",
       "      <td>CHILDREN'S APRON DOLLY GIRL</td>\n",
       "      <td>6</td>\n",
       "      <td>2011-12-09 12:50:00</td>\n",
       "      <td>2.10</td>\n",
       "      <td>12680.0</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541806</th>\n",
       "      <td>581587</td>\n",
       "      <td>23254</td>\n",
       "      <td>CHILDRENS CUTLERY DOLLY GIRL</td>\n",
       "      <td>4</td>\n",
       "      <td>2011-12-09 12:50:00</td>\n",
       "      <td>4.15</td>\n",
       "      <td>12680.0</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541807</th>\n",
       "      <td>581587</td>\n",
       "      <td>23255</td>\n",
       "      <td>CHILDRENS CUTLERY CIRCUS PARADE</td>\n",
       "      <td>4</td>\n",
       "      <td>2011-12-09 12:50:00</td>\n",
       "      <td>4.15</td>\n",
       "      <td>12680.0</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541808</th>\n",
       "      <td>581587</td>\n",
       "      <td>22138</td>\n",
       "      <td>BAKING SET 9 PIECE RETROSPOT</td>\n",
       "      <td>3</td>\n",
       "      <td>2011-12-09 12:50:00</td>\n",
       "      <td>4.95</td>\n",
       "      <td>12680.0</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>541809 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       InvoiceNo StockCode                          Description  Quantity  \\\n",
       "0         536378    84519A      TOMATO CHARLIE+LOLA COASTER SET         6   \n",
       "1         536378    85183B  CHARLIE & LOLA WASTEPAPER BIN FLORA        48   \n",
       "2         536378    85071B   RED CHARLIE+LOLA PERSONAL DOORSIGN        96   \n",
       "3         536378     21931               JUMBO STORAGE BAG SUKI        10   \n",
       "4         536378     21929       JUMBO BAG PINK VINTAGE PAISLEY        10   \n",
       "5         536380     22961               JAM MAKING SET PRINTED        24   \n",
       "6         536381     22139     RETROSPOT TEA SET CERAMIC 11 PC         23   \n",
       "7         536381     84854                  GIRLY PINK TOOL SET         5   \n",
       "8         536381     22411    JUMBO SHOPPER VINTAGE RED PAISLEY        10   \n",
       "9         536381     82567            AIRLINE LOUNGE,METAL SIGN         2   \n",
       "10        536381     21672   WHITE SPOT RED CERAMIC DRAWER KNOB         6   \n",
       "11        536381     22774    RED DRAWER KNOB ACRYLIC EDWARDIAN        24   \n",
       "12        536381     22771  CLEAR DRAWER KNOB ACRYLIC EDWARDIAN        24   \n",
       "13        536381     71270                      PHOTO CLIP LINE         1   \n",
       "14        536381     22262                FELT EGG COSY CHICKEN         1   \n",
       "15        536381     22637                PIGGY BANK RETROSPOT          1   \n",
       "16        536381     21934                   SKULL SHOULDER BAG        10   \n",
       "17        536381     21169      YOU'RE CONFUSING ME METAL SIGN          3   \n",
       "18        536381     21166           COOK WITH WINE METAL SIGN          1   \n",
       "19        536381     21175          GIN + TONIC DIET METAL SIGN         2   \n",
       "20        536381    37444A      YELLOW BREAKFAST CUP AND SAUCER         1   \n",
       "21        536381    37444C       PINK BREAKFAST CUP AND SAUCER          1   \n",
       "22        536381     22086      PAPER CHAIN KIT 50'S CHRISTMAS          4   \n",
       "23        536381     22083            PAPER CHAIN KIT RETROSPOT         1   \n",
       "24        536381    84971S            SMALL HEART FLOWERS HOOK          6   \n",
       "25        536381     71270                      PHOTO CLIP LINE         3   \n",
       "26        536381     47580                TEA TIME DES TEA COSY         2   \n",
       "27        536381     22261          FELT EGG COSY WHITE RABBIT          1   \n",
       "28        536381     84832     ZINC WILLIE WINKIE  CANDLE STICK         1   \n",
       "29        536381     22644       CERAMIC CHERRY CAKE MONEY BANK         1   \n",
       "...          ...       ...                                  ...       ...   \n",
       "541779    581585     22726           ALARM CLOCK BAKELIKE GREEN         8   \n",
       "541780    581585     22727            ALARM CLOCK BAKELIKE RED          4   \n",
       "541781    581585     16016          LARGE CHINESE STYLE SCISSOR        10   \n",
       "541782    581585     21916      SET 12 RETRO WHITE CHALK STICKS        24   \n",
       "541783    581585     84692          BOX OF 24 COCKTAIL PARASOLS        25   \n",
       "541784    581585     84946         ANTIQUE SILVER T-LIGHT GLASS        12   \n",
       "541785    581585     21684     SMALL MEDINA STAMPED METAL BOWL         12   \n",
       "541786    581585     22398           MAGNETS PACK OF 4 SWALLOWS        12   \n",
       "541787    581585     23328   SET 6 SCHOOL MILK BOTTLES IN CRATE         4   \n",
       "541788    581585     23145       ZINC T-LIGHT HOLDER STAR LARGE        12   \n",
       "541789    581585     22466       FAIRY TALE COTTAGE NIGHT LIGHT        12   \n",
       "541790    581586     22061  LARGE CAKE STAND  HANGING STRAWBERY         8   \n",
       "541791    581586     23275     SET OF 3 HANGING OWLS OLLIE BEAK        24   \n",
       "541792    581586     21217        RED RETROSPOT ROUND CAKE TINS        24   \n",
       "541793    581586     20685                DOORMAT RED RETROSPOT        10   \n",
       "541794    581587     22631             CIRCUS PARADE LUNCH BOX         12   \n",
       "541795    581587     22556       PLASTERS IN TIN CIRCUS PARADE         12   \n",
       "541796    581587     22555            PLASTERS IN TIN STRONGMAN        12   \n",
       "541797    581587     22728            ALARM CLOCK BAKELIKE PINK         4   \n",
       "541798    581587     22727            ALARM CLOCK BAKELIKE RED          4   \n",
       "541799    581587     22726           ALARM CLOCK BAKELIKE GREEN         4   \n",
       "541800    581587     22730           ALARM CLOCK BAKELIKE IVORY         4   \n",
       "541801    581587     22367      CHILDRENS APRON SPACEBOY DESIGN         8   \n",
       "541802    581587     22629                  SPACEBOY LUNCH BOX         12   \n",
       "541803    581587     23256          CHILDRENS CUTLERY SPACEBOY          4   \n",
       "541804    581587     22613          PACK OF 20 SPACEBOY NAPKINS        12   \n",
       "541805    581587     22899         CHILDREN'S APRON DOLLY GIRL          6   \n",
       "541806    581587     23254        CHILDRENS CUTLERY DOLLY GIRL          4   \n",
       "541807    581587     23255      CHILDRENS CUTLERY CIRCUS PARADE         4   \n",
       "541808    581587     22138        BAKING SET 9 PIECE RETROSPOT          3   \n",
       "\n",
       "               InvoiceDate  UnitPrice  CustomerID         Country  \n",
       "0      2010-12-01 09:37:00       2.95     14688.0  United Kingdom  \n",
       "1      2010-12-01 09:37:00       1.25     14688.0  United Kingdom  \n",
       "2      2010-12-01 09:37:00       0.38     14688.0  United Kingdom  \n",
       "3      2010-12-01 09:37:00       1.95     14688.0  United Kingdom  \n",
       "4      2010-12-01 09:37:00       1.95     14688.0  United Kingdom  \n",
       "5      2010-12-01 09:41:00       1.45     17809.0  United Kingdom  \n",
       "6      2010-12-01 09:41:00       4.25     15311.0  United Kingdom  \n",
       "7      2010-12-01 09:41:00       4.95     15311.0  United Kingdom  \n",
       "8      2010-12-01 09:41:00       1.95     15311.0  United Kingdom  \n",
       "9      2010-12-01 09:41:00       2.10     15311.0  United Kingdom  \n",
       "10     2010-12-01 09:41:00       1.25     15311.0  United Kingdom  \n",
       "11     2010-12-01 09:41:00       1.25     15311.0  United Kingdom  \n",
       "12     2010-12-01 09:41:00       1.25     15311.0  United Kingdom  \n",
       "13     2010-12-01 09:41:00       1.25     15311.0  United Kingdom  \n",
       "14     2010-12-01 09:41:00       0.85     15311.0  United Kingdom  \n",
       "15     2010-12-01 09:41:00       2.55     15311.0  United Kingdom  \n",
       "16     2010-12-01 09:41:00       1.65     15311.0  United Kingdom  \n",
       "17     2010-12-01 09:41:00       1.69     15311.0  United Kingdom  \n",
       "18     2010-12-01 09:41:00       1.95     15311.0  United Kingdom  \n",
       "19     2010-12-01 09:41:00       2.10     15311.0  United Kingdom  \n",
       "20     2010-12-01 09:41:00       2.95     15311.0  United Kingdom  \n",
       "21     2010-12-01 09:41:00       2.95     15311.0  United Kingdom  \n",
       "22     2010-12-01 09:41:00       2.95     15311.0  United Kingdom  \n",
       "23     2010-12-01 09:41:00       2.95     15311.0  United Kingdom  \n",
       "24     2010-12-01 09:41:00       0.85     15311.0  United Kingdom  \n",
       "25     2010-12-01 09:41:00       1.25     15311.0  United Kingdom  \n",
       "26     2010-12-01 09:41:00       2.55     15311.0  United Kingdom  \n",
       "27     2010-12-01 09:41:00       0.85     15311.0  United Kingdom  \n",
       "28     2010-12-01 09:41:00       0.85     15311.0  United Kingdom  \n",
       "29     2010-12-01 09:41:00       1.45     15311.0  United Kingdom  \n",
       "...                    ...        ...         ...             ...  \n",
       "541779 2011-12-09 12:31:00       3.75     15804.0  United Kingdom  \n",
       "541780 2011-12-09 12:31:00       3.75     15804.0  United Kingdom  \n",
       "541781 2011-12-09 12:31:00       0.85     15804.0  United Kingdom  \n",
       "541782 2011-12-09 12:31:00       0.42     15804.0  United Kingdom  \n",
       "541783 2011-12-09 12:31:00       0.42     15804.0  United Kingdom  \n",
       "541784 2011-12-09 12:31:00       1.25     15804.0  United Kingdom  \n",
       "541785 2011-12-09 12:31:00       0.85     15804.0  United Kingdom  \n",
       "541786 2011-12-09 12:31:00       0.39     15804.0  United Kingdom  \n",
       "541787 2011-12-09 12:31:00       3.75     15804.0  United Kingdom  \n",
       "541788 2011-12-09 12:31:00       0.95     15804.0  United Kingdom  \n",
       "541789 2011-12-09 12:31:00       1.95     15804.0  United Kingdom  \n",
       "541790 2011-12-09 12:49:00       2.95     13113.0  United Kingdom  \n",
       "541791 2011-12-09 12:49:00       1.25     13113.0  United Kingdom  \n",
       "541792 2011-12-09 12:49:00       8.95     13113.0  United Kingdom  \n",
       "541793 2011-12-09 12:49:00       7.08     13113.0  United Kingdom  \n",
       "541794 2011-12-09 12:50:00       1.95     12680.0          France  \n",
       "541795 2011-12-09 12:50:00       1.65     12680.0          France  \n",
       "541796 2011-12-09 12:50:00       1.65     12680.0          France  \n",
       "541797 2011-12-09 12:50:00       3.75     12680.0          France  \n",
       "541798 2011-12-09 12:50:00       3.75     12680.0          France  \n",
       "541799 2011-12-09 12:50:00       3.75     12680.0          France  \n",
       "541800 2011-12-09 12:50:00       3.75     12680.0          France  \n",
       "541801 2011-12-09 12:50:00       1.95     12680.0          France  \n",
       "541802 2011-12-09 12:50:00       1.95     12680.0          France  \n",
       "541803 2011-12-09 12:50:00       4.15     12680.0          France  \n",
       "541804 2011-12-09 12:50:00       0.85     12680.0          France  \n",
       "541805 2011-12-09 12:50:00       2.10     12680.0          France  \n",
       "541806 2011-12-09 12:50:00       4.15     12680.0          France  \n",
       "541807 2011-12-09 12:50:00       4.15     12680.0          France  \n",
       "541808 2011-12-09 12:50:00       4.95     12680.0          France  \n",
       "\n",
       "[541809 rows x 8 columns]"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#1-c(i)\n",
    "df3=pd.read_excel(r\"C:\\Users\\TANVI\\Desktop\\New folder\\Online Retail.xlsx\",skiprows=[i for i in range(1,101)])\n",
    "df3"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "df3['InvoiceNo'] = df['InvoiceNo'].astype(int)\n",
    "df3.sort_values(by=['InvoiceNo'], inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>InvoiceNo</th>\n",
       "      <th>StockCode</th>\n",
       "      <th>Description</th>\n",
       "      <th>Quantity</th>\n",
       "      <th>InvoiceDate</th>\n",
       "      <th>UnitPrice</th>\n",
       "      <th>CustomerID</th>\n",
       "      <th>Country</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>536381</td>\n",
       "      <td>21523</td>\n",
       "      <td>DOORMAT FANCY FONT HOME SWEET HOME</td>\n",
       "      <td>10</td>\n",
       "      <td>2010-12-01 09:41:00</td>\n",
       "      <td>6.75</td>\n",
       "      <td>15311.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>C536379</td>\n",
       "      <td>D</td>\n",
       "      <td>Discount</td>\n",
       "      <td>-1</td>\n",
       "      <td>2010-12-01 09:41:00</td>\n",
       "      <td>27.50</td>\n",
       "      <td>14527.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>536388</td>\n",
       "      <td>21523</td>\n",
       "      <td>DOORMAT FANCY FONT HOME SWEET HOME</td>\n",
       "      <td>2</td>\n",
       "      <td>2010-12-01 09:59:00</td>\n",
       "      <td>7.95</td>\n",
       "      <td>16250.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119</th>\n",
       "      <td>536390</td>\n",
       "      <td>20668</td>\n",
       "      <td>DISCO BALL CHRISTMAS DECORATION</td>\n",
       "      <td>288</td>\n",
       "      <td>2010-12-01 10:19:00</td>\n",
       "      <td>0.10</td>\n",
       "      <td>17511.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>536390</td>\n",
       "      <td>22654</td>\n",
       "      <td>DELUXE SEWING KIT</td>\n",
       "      <td>40</td>\n",
       "      <td>2010-12-01 10:19:00</td>\n",
       "      <td>4.95</td>\n",
       "      <td>17511.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>159</th>\n",
       "      <td>536394</td>\n",
       "      <td>22349</td>\n",
       "      <td>DOG BOWL CHASING BALL DESIGN</td>\n",
       "      <td>12</td>\n",
       "      <td>2010-12-01 10:39:00</td>\n",
       "      <td>3.75</td>\n",
       "      <td>13408.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203</th>\n",
       "      <td>536398</td>\n",
       "      <td>48185</td>\n",
       "      <td>DOORMAT FAIRY CAKE</td>\n",
       "      <td>2</td>\n",
       "      <td>2010-12-01 10:52:00</td>\n",
       "      <td>7.95</td>\n",
       "      <td>13448.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>235</th>\n",
       "      <td>536401</td>\n",
       "      <td>21464</td>\n",
       "      <td>DISCO BALL ROTATOR BATTERY OPERATED</td>\n",
       "      <td>1</td>\n",
       "      <td>2010-12-01 11:21:00</td>\n",
       "      <td>4.25</td>\n",
       "      <td>15862.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>240</th>\n",
       "      <td>536401</td>\n",
       "      <td>48129</td>\n",
       "      <td>DOORMAT TOPIARY</td>\n",
       "      <td>1</td>\n",
       "      <td>2010-12-01 11:21:00</td>\n",
       "      <td>7.95</td>\n",
       "      <td>15862.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>354</th>\n",
       "      <td>536408</td>\n",
       "      <td>20685</td>\n",
       "      <td>DOORMAT RED RETROSPOT</td>\n",
       "      <td>2</td>\n",
       "      <td>2010-12-01 11:41:00</td>\n",
       "      <td>7.95</td>\n",
       "      <td>14307.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>355</th>\n",
       "      <td>536408</td>\n",
       "      <td>48194</td>\n",
       "      <td>DOORMAT HEARTS</td>\n",
       "      <td>2</td>\n",
       "      <td>2010-12-01 11:41:00</td>\n",
       "      <td>7.95</td>\n",
       "      <td>14307.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>399</th>\n",
       "      <td>536409</td>\n",
       "      <td>21955</td>\n",
       "      <td>DOORMAT UNION JACK GUNS AND ROSES</td>\n",
       "      <td>1</td>\n",
       "      <td>2010-12-01 11:45:00</td>\n",
       "      <td>7.95</td>\n",
       "      <td>17908.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>413</th>\n",
       "      <td>536409</td>\n",
       "      <td>20668</td>\n",
       "      <td>DISCO BALL CHRISTMAS DECORATION</td>\n",
       "      <td>24</td>\n",
       "      <td>2010-12-01 11:45:00</td>\n",
       "      <td>0.12</td>\n",
       "      <td>17908.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>449</th>\n",
       "      <td>536412</td>\n",
       "      <td>22630</td>\n",
       "      <td>DOLLY GIRL LUNCH BOX</td>\n",
       "      <td>1</td>\n",
       "      <td>2010-12-01 11:49:00</td>\n",
       "      <td>1.95</td>\n",
       "      <td>17920.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>620</th>\n",
       "      <td>536425</td>\n",
       "      <td>22508</td>\n",
       "      <td>DOORSTOP RETROSPOT HEART</td>\n",
       "      <td>8</td>\n",
       "      <td>2010-12-01 12:08:00</td>\n",
       "      <td>3.75</td>\n",
       "      <td>13758.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>682</th>\n",
       "      <td>536464</td>\n",
       "      <td>90059B</td>\n",
       "      <td>DIAMANTE HAIR GRIP PACK/2 BLACK DIA</td>\n",
       "      <td>2</td>\n",
       "      <td>2010-12-01 12:23:00</td>\n",
       "      <td>1.65</td>\n",
       "      <td>17968.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>684</th>\n",
       "      <td>536464</td>\n",
       "      <td>90059E</td>\n",
       "      <td>DIAMANTE HAIR GRIP PACK/2 RUBY</td>\n",
       "      <td>3</td>\n",
       "      <td>2010-12-01 12:23:00</td>\n",
       "      <td>1.65</td>\n",
       "      <td>17968.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>685</th>\n",
       "      <td>536464</td>\n",
       "      <td>90059C</td>\n",
       "      <td>DIAMANTE HAIR GRIP PACK/2 MONTANA</td>\n",
       "      <td>1</td>\n",
       "      <td>2010-12-01 12:23:00</td>\n",
       "      <td>1.65</td>\n",
       "      <td>17968.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>749</th>\n",
       "      <td>536464</td>\n",
       "      <td>21329</td>\n",
       "      <td>DINOSAURS  WRITING SET</td>\n",
       "      <td>1</td>\n",
       "      <td>2010-12-01 12:23:00</td>\n",
       "      <td>1.65</td>\n",
       "      <td>17968.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>754</th>\n",
       "      <td>536464</td>\n",
       "      <td>48173C</td>\n",
       "      <td>DOORMAT BLACK FLOCK</td>\n",
       "      <td>1</td>\n",
       "      <td>2010-12-01 12:23:00</td>\n",
       "      <td>7.95</td>\n",
       "      <td>17968.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>819</th>\n",
       "      <td>536500</td>\n",
       "      <td>22630</td>\n",
       "      <td>DOLLY GIRL LUNCH BOX</td>\n",
       "      <td>2</td>\n",
       "      <td>2010-12-01 12:35:00</td>\n",
       "      <td>1.95</td>\n",
       "      <td>17377.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1134</th>\n",
       "      <td>536531</td>\n",
       "      <td>22688</td>\n",
       "      <td>DOORMAT PEACE ON EARTH BLUE</td>\n",
       "      <td>4</td>\n",
       "      <td>2010-12-01 13:23:00</td>\n",
       "      <td>7.95</td>\n",
       "      <td>15485.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1205</th>\n",
       "      <td>536532</td>\n",
       "      <td>20685</td>\n",
       "      <td>DOORMAT RED RETROSPOT</td>\n",
       "      <td>2</td>\n",
       "      <td>2010-12-01 13:24:00</td>\n",
       "      <td>7.95</td>\n",
       "      <td>12433.0</td>\n",
       "      <td>Norway</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1211</th>\n",
       "      <td>536533</td>\n",
       "      <td>22825</td>\n",
       "      <td>DECORATIVE PLANT POT WITH FRIEZE</td>\n",
       "      <td>2</td>\n",
       "      <td>2010-12-01 13:31:00</td>\n",
       "      <td>7.95</td>\n",
       "      <td>16955.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1226</th>\n",
       "      <td>536535</td>\n",
       "      <td>21523</td>\n",
       "      <td>DOORMAT FANCY FONT HOME SWEET HOME</td>\n",
       "      <td>2</td>\n",
       "      <td>2010-12-01 13:38:00</td>\n",
       "      <td>7.95</td>\n",
       "      <td>15605.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1227</th>\n",
       "      <td>536535</td>\n",
       "      <td>48194</td>\n",
       "      <td>DOORMAT HEARTS</td>\n",
       "      <td>2</td>\n",
       "      <td>2010-12-01 13:38:00</td>\n",
       "      <td>7.95</td>\n",
       "      <td>15605.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1228</th>\n",
       "      <td>536535</td>\n",
       "      <td>20685</td>\n",
       "      <td>DOORMAT RED RETROSPOT</td>\n",
       "      <td>2</td>\n",
       "      <td>2010-12-01 13:38:00</td>\n",
       "      <td>7.95</td>\n",
       "      <td>15605.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1250</th>\n",
       "      <td>536538</td>\n",
       "      <td>21523</td>\n",
       "      <td>DOORMAT FANCY FONT HOME SWEET HOME</td>\n",
       "      <td>1</td>\n",
       "      <td>2010-12-01 13:54:00</td>\n",
       "      <td>7.95</td>\n",
       "      <td>14594.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1251</th>\n",
       "      <td>536538</td>\n",
       "      <td>48129</td>\n",
       "      <td>DOORMAT TOPIARY</td>\n",
       "      <td>1</td>\n",
       "      <td>2010-12-01 13:54:00</td>\n",
       "      <td>7.95</td>\n",
       "      <td>14594.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1252</th>\n",
       "      <td>536538</td>\n",
       "      <td>21524</td>\n",
       "      <td>DOORMAT SPOTTY HOME SWEET HOME</td>\n",
       "      <td>1</td>\n",
       "      <td>2010-12-01 13:54:00</td>\n",
       "      <td>7.95</td>\n",
       "      <td>14594.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>540764</th>\n",
       "      <td>581492</td>\n",
       "      <td>90059E</td>\n",
       "      <td>DIAMANTE HAIR GRIP PACK/2 RUBY</td>\n",
       "      <td>1</td>\n",
       "      <td>2011-12-09 10:03:00</td>\n",
       "      <td>1.65</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>540765</th>\n",
       "      <td>581492</td>\n",
       "      <td>90059F</td>\n",
       "      <td>DIAMANTE HAIR GRIP PACK/2 LT ROSE</td>\n",
       "      <td>1</td>\n",
       "      <td>2011-12-09 10:03:00</td>\n",
       "      <td>1.65</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>540781</th>\n",
       "      <td>581492</td>\n",
       "      <td>90169</td>\n",
       "      <td>DAISY HAIR COMB</td>\n",
       "      <td>1</td>\n",
       "      <td>2011-12-09 10:03:00</td>\n",
       "      <td>2.48</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>540782</th>\n",
       "      <td>581492</td>\n",
       "      <td>90170</td>\n",
       "      <td>DAISY HAIR BAND</td>\n",
       "      <td>1</td>\n",
       "      <td>2011-12-09 10:03:00</td>\n",
       "      <td>1.65</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>540787</th>\n",
       "      <td>581492</td>\n",
       "      <td>90177C</td>\n",
       "      <td>DROP DIAMANTE EARRINGS CRYSTAL</td>\n",
       "      <td>1</td>\n",
       "      <td>2011-12-09 10:03:00</td>\n",
       "      <td>2.90</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>540794</th>\n",
       "      <td>581492</td>\n",
       "      <td>90188</td>\n",
       "      <td>DROP EARRINGS W FLOWER &amp; LEAF</td>\n",
       "      <td>2</td>\n",
       "      <td>2011-12-09 10:03:00</td>\n",
       "      <td>2.48</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>540808</th>\n",
       "      <td>581492</td>\n",
       "      <td>DOT</td>\n",
       "      <td>DOTCOM POSTAGE</td>\n",
       "      <td>1</td>\n",
       "      <td>2011-12-09 10:03:00</td>\n",
       "      <td>933.17</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>540872</th>\n",
       "      <td>581492</td>\n",
       "      <td>22630</td>\n",
       "      <td>DOLLY GIRL LUNCH BOX</td>\n",
       "      <td>1</td>\n",
       "      <td>2011-12-09 10:03:00</td>\n",
       "      <td>4.13</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>540879</th>\n",
       "      <td>581492</td>\n",
       "      <td>22654</td>\n",
       "      <td>DELUXE SEWING KIT</td>\n",
       "      <td>2</td>\n",
       "      <td>2011-12-09 10:03:00</td>\n",
       "      <td>12.46</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>540959</th>\n",
       "      <td>581492</td>\n",
       "      <td>22977</td>\n",
       "      <td>DOLLY GIRL CHILDRENS EGG CUP</td>\n",
       "      <td>1</td>\n",
       "      <td>2011-12-09 10:03:00</td>\n",
       "      <td>2.46</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>540987</th>\n",
       "      <td>581492</td>\n",
       "      <td>23077</td>\n",
       "      <td>DOUGHNUT LIP GLOSS</td>\n",
       "      <td>3</td>\n",
       "      <td>2011-12-09 10:03:00</td>\n",
       "      <td>2.46</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541039</th>\n",
       "      <td>581492</td>\n",
       "      <td>23284</td>\n",
       "      <td>DOORMAT KEEP CALM AND COME IN</td>\n",
       "      <td>1</td>\n",
       "      <td>2011-12-09 10:03:00</td>\n",
       "      <td>15.79</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541114</th>\n",
       "      <td>581494</td>\n",
       "      <td>23390</td>\n",
       "      <td>DOLLY GIRL MINI BACKPACK</td>\n",
       "      <td>4</td>\n",
       "      <td>2011-12-09 10:13:00</td>\n",
       "      <td>4.15</td>\n",
       "      <td>12518.0</td>\n",
       "      <td>Germany</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541125</th>\n",
       "      <td>581495</td>\n",
       "      <td>48138</td>\n",
       "      <td>DOORMAT UNION FLAG</td>\n",
       "      <td>10</td>\n",
       "      <td>2011-12-09 10:20:00</td>\n",
       "      <td>7.08</td>\n",
       "      <td>14051.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541126</th>\n",
       "      <td>581495</td>\n",
       "      <td>21523</td>\n",
       "      <td>DOORMAT FANCY FONT HOME SWEET HOME</td>\n",
       "      <td>10</td>\n",
       "      <td>2011-12-09 10:20:00</td>\n",
       "      <td>7.08</td>\n",
       "      <td>14051.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541251</th>\n",
       "      <td>581498</td>\n",
       "      <td>21329</td>\n",
       "      <td>DINOSAURS  WRITING SET</td>\n",
       "      <td>1</td>\n",
       "      <td>2011-12-09 10:26:00</td>\n",
       "      <td>3.29</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541255</th>\n",
       "      <td>581498</td>\n",
       "      <td>21523</td>\n",
       "      <td>DOORMAT FANCY FONT HOME SWEET HOME</td>\n",
       "      <td>1</td>\n",
       "      <td>2011-12-09 10:26:00</td>\n",
       "      <td>16.63</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541274</th>\n",
       "      <td>581498</td>\n",
       "      <td>21955</td>\n",
       "      <td>DOORMAT UNION JACK GUNS AND ROSES</td>\n",
       "      <td>1</td>\n",
       "      <td>2011-12-09 10:26:00</td>\n",
       "      <td>12.46</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541342</th>\n",
       "      <td>581498</td>\n",
       "      <td>22654</td>\n",
       "      <td>DELUXE SEWING KIT</td>\n",
       "      <td>2</td>\n",
       "      <td>2011-12-09 10:26:00</td>\n",
       "      <td>12.46</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541410</th>\n",
       "      <td>581498</td>\n",
       "      <td>48138</td>\n",
       "      <td>DOORMAT UNION FLAG</td>\n",
       "      <td>1</td>\n",
       "      <td>2011-12-09 10:26:00</td>\n",
       "      <td>14.13</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541440</th>\n",
       "      <td>581498</td>\n",
       "      <td>DOT</td>\n",
       "      <td>DOTCOM POSTAGE</td>\n",
       "      <td>1</td>\n",
       "      <td>2011-12-09 10:26:00</td>\n",
       "      <td>1714.17</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541444</th>\n",
       "      <td>581500</td>\n",
       "      <td>48187</td>\n",
       "      <td>DOORMAT NEW ENGLAND</td>\n",
       "      <td>2</td>\n",
       "      <td>2011-12-09 10:45:00</td>\n",
       "      <td>8.25</td>\n",
       "      <td>15344.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541449</th>\n",
       "      <td>581501</td>\n",
       "      <td>22165</td>\n",
       "      <td>DIAMANTE HEART SHAPED WALL MIRROR,</td>\n",
       "      <td>12</td>\n",
       "      <td>2011-12-09 10:46:00</td>\n",
       "      <td>3.95</td>\n",
       "      <td>12985.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541471</th>\n",
       "      <td>581502</td>\n",
       "      <td>20668</td>\n",
       "      <td>DISCO BALL CHRISTMAS DECORATION</td>\n",
       "      <td>24</td>\n",
       "      <td>2011-12-09 10:51:00</td>\n",
       "      <td>0.12</td>\n",
       "      <td>15910.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541551</th>\n",
       "      <td>581538</td>\n",
       "      <td>23034</td>\n",
       "      <td>DRAWER KNOB CERAMIC BLACK</td>\n",
       "      <td>1</td>\n",
       "      <td>2011-12-09 11:34:00</td>\n",
       "      <td>1.45</td>\n",
       "      <td>14446.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541553</th>\n",
       "      <td>581538</td>\n",
       "      <td>23033</td>\n",
       "      <td>DRAWER KNOB CERAMIC RED</td>\n",
       "      <td>1</td>\n",
       "      <td>2011-12-09 11:34:00</td>\n",
       "      <td>1.45</td>\n",
       "      <td>14446.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541569</th>\n",
       "      <td>581538</td>\n",
       "      <td>21329</td>\n",
       "      <td>DINOSAURS  WRITING SET</td>\n",
       "      <td>1</td>\n",
       "      <td>2011-12-09 11:34:00</td>\n",
       "      <td>1.65</td>\n",
       "      <td>14446.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541627</th>\n",
       "      <td>581570</td>\n",
       "      <td>23077</td>\n",
       "      <td>DOUGHNUT LIP GLOSS</td>\n",
       "      <td>20</td>\n",
       "      <td>2011-12-09 11:59:00</td>\n",
       "      <td>1.25</td>\n",
       "      <td>12662.0</td>\n",
       "      <td>Germany</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541633</th>\n",
       "      <td>581571</td>\n",
       "      <td>48187</td>\n",
       "      <td>DOORMAT NEW ENGLAND</td>\n",
       "      <td>1</td>\n",
       "      <td>2011-12-09 12:00:00</td>\n",
       "      <td>8.25</td>\n",
       "      <td>15311.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541793</th>\n",
       "      <td>581586</td>\n",
       "      <td>20685</td>\n",
       "      <td>DOORMAT RED RETROSPOT</td>\n",
       "      <td>10</td>\n",
       "      <td>2011-12-09 12:49:00</td>\n",
       "      <td>7.08</td>\n",
       "      <td>13113.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>19404 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       InvoiceNo StockCode                          Description  Quantity  \\\n",
       "40        536381     21523   DOORMAT FANCY FONT HOME SWEET HOME        10   \n",
       "41       C536379         D                             Discount        -1   \n",
       "85        536388     21523   DOORMAT FANCY FONT HOME SWEET HOME         2   \n",
       "119       536390     20668      DISCO BALL CHRISTMAS DECORATION       288   \n",
       "128       536390     22654                   DELUXE SEWING KIT         40   \n",
       "159       536394     22349         DOG BOWL CHASING BALL DESIGN        12   \n",
       "203       536398     48185                   DOORMAT FAIRY CAKE         2   \n",
       "235       536401     21464  DISCO BALL ROTATOR BATTERY OPERATED         1   \n",
       "240       536401     48129                      DOORMAT TOPIARY         1   \n",
       "354       536408     20685                DOORMAT RED RETROSPOT         2   \n",
       "355       536408     48194                       DOORMAT HEARTS         2   \n",
       "399       536409     21955    DOORMAT UNION JACK GUNS AND ROSES         1   \n",
       "413       536409     20668      DISCO BALL CHRISTMAS DECORATION        24   \n",
       "449       536412     22630                 DOLLY GIRL LUNCH BOX         1   \n",
       "620       536425     22508             DOORSTOP RETROSPOT HEART         8   \n",
       "682       536464    90059B  DIAMANTE HAIR GRIP PACK/2 BLACK DIA         2   \n",
       "684       536464    90059E       DIAMANTE HAIR GRIP PACK/2 RUBY         3   \n",
       "685       536464    90059C    DIAMANTE HAIR GRIP PACK/2 MONTANA         1   \n",
       "749       536464     21329              DINOSAURS  WRITING SET          1   \n",
       "754       536464    48173C                 DOORMAT BLACK FLOCK          1   \n",
       "819       536500     22630                 DOLLY GIRL LUNCH BOX         2   \n",
       "1134      536531     22688          DOORMAT PEACE ON EARTH BLUE         4   \n",
       "1205      536532     20685                DOORMAT RED RETROSPOT         2   \n",
       "1211      536533     22825     DECORATIVE PLANT POT WITH FRIEZE         2   \n",
       "1226      536535     21523   DOORMAT FANCY FONT HOME SWEET HOME         2   \n",
       "1227      536535     48194                       DOORMAT HEARTS         2   \n",
       "1228      536535     20685                DOORMAT RED RETROSPOT         2   \n",
       "1250      536538     21523   DOORMAT FANCY FONT HOME SWEET HOME         1   \n",
       "1251      536538     48129                      DOORMAT TOPIARY         1   \n",
       "1252      536538     21524       DOORMAT SPOTTY HOME SWEET HOME         1   \n",
       "...          ...       ...                                  ...       ...   \n",
       "540764    581492    90059E       DIAMANTE HAIR GRIP PACK/2 RUBY         1   \n",
       "540765    581492    90059F    DIAMANTE HAIR GRIP PACK/2 LT ROSE         1   \n",
       "540781    581492     90169                      DAISY HAIR COMB         1   \n",
       "540782    581492     90170                      DAISY HAIR BAND         1   \n",
       "540787    581492    90177C       DROP DIAMANTE EARRINGS CRYSTAL         1   \n",
       "540794    581492     90188        DROP EARRINGS W FLOWER & LEAF         2   \n",
       "540808    581492       DOT                       DOTCOM POSTAGE         1   \n",
       "540872    581492     22630                 DOLLY GIRL LUNCH BOX         1   \n",
       "540879    581492     22654                   DELUXE SEWING KIT          2   \n",
       "540959    581492     22977         DOLLY GIRL CHILDRENS EGG CUP         1   \n",
       "540987    581492     23077                  DOUGHNUT LIP GLOSS          3   \n",
       "541039    581492     23284        DOORMAT KEEP CALM AND COME IN         1   \n",
       "541114    581494     23390             DOLLY GIRL MINI BACKPACK         4   \n",
       "541125    581495     48138                   DOORMAT UNION FLAG        10   \n",
       "541126    581495     21523   DOORMAT FANCY FONT HOME SWEET HOME        10   \n",
       "541251    581498     21329              DINOSAURS  WRITING SET          1   \n",
       "541255    581498     21523   DOORMAT FANCY FONT HOME SWEET HOME         1   \n",
       "541274    581498     21955    DOORMAT UNION JACK GUNS AND ROSES         1   \n",
       "541342    581498     22654                   DELUXE SEWING KIT          2   \n",
       "541410    581498     48138                   DOORMAT UNION FLAG         1   \n",
       "541440    581498       DOT                       DOTCOM POSTAGE         1   \n",
       "541444    581500     48187                  DOORMAT NEW ENGLAND         2   \n",
       "541449    581501     22165  DIAMANTE HEART SHAPED WALL MIRROR,         12   \n",
       "541471    581502     20668      DISCO BALL CHRISTMAS DECORATION        24   \n",
       "541551    581538     23034            DRAWER KNOB CERAMIC BLACK         1   \n",
       "541553    581538     23033              DRAWER KNOB CERAMIC RED         1   \n",
       "541569    581538     21329              DINOSAURS  WRITING SET          1   \n",
       "541627    581570     23077                  DOUGHNUT LIP GLOSS         20   \n",
       "541633    581571     48187                  DOORMAT NEW ENGLAND         1   \n",
       "541793    581586     20685                DOORMAT RED RETROSPOT        10   \n",
       "\n",
       "               InvoiceDate  UnitPrice  CustomerID         Country  \n",
       "40     2010-12-01 09:41:00       6.75     15311.0  United Kingdom  \n",
       "41     2010-12-01 09:41:00      27.50     14527.0  United Kingdom  \n",
       "85     2010-12-01 09:59:00       7.95     16250.0  United Kingdom  \n",
       "119    2010-12-01 10:19:00       0.10     17511.0  United Kingdom  \n",
       "128    2010-12-01 10:19:00       4.95     17511.0  United Kingdom  \n",
       "159    2010-12-01 10:39:00       3.75     13408.0  United Kingdom  \n",
       "203    2010-12-01 10:52:00       7.95     13448.0  United Kingdom  \n",
       "235    2010-12-01 11:21:00       4.25     15862.0  United Kingdom  \n",
       "240    2010-12-01 11:21:00       7.95     15862.0  United Kingdom  \n",
       "354    2010-12-01 11:41:00       7.95     14307.0  United Kingdom  \n",
       "355    2010-12-01 11:41:00       7.95     14307.0  United Kingdom  \n",
       "399    2010-12-01 11:45:00       7.95     17908.0  United Kingdom  \n",
       "413    2010-12-01 11:45:00       0.12     17908.0  United Kingdom  \n",
       "449    2010-12-01 11:49:00       1.95     17920.0  United Kingdom  \n",
       "620    2010-12-01 12:08:00       3.75     13758.0  United Kingdom  \n",
       "682    2010-12-01 12:23:00       1.65     17968.0  United Kingdom  \n",
       "684    2010-12-01 12:23:00       1.65     17968.0  United Kingdom  \n",
       "685    2010-12-01 12:23:00       1.65     17968.0  United Kingdom  \n",
       "749    2010-12-01 12:23:00       1.65     17968.0  United Kingdom  \n",
       "754    2010-12-01 12:23:00       7.95     17968.0  United Kingdom  \n",
       "819    2010-12-01 12:35:00       1.95     17377.0  United Kingdom  \n",
       "1134   2010-12-01 13:23:00       7.95     15485.0  United Kingdom  \n",
       "1205   2010-12-01 13:24:00       7.95     12433.0          Norway  \n",
       "1211   2010-12-01 13:31:00       7.95     16955.0  United Kingdom  \n",
       "1226   2010-12-01 13:38:00       7.95     15605.0  United Kingdom  \n",
       "1227   2010-12-01 13:38:00       7.95     15605.0  United Kingdom  \n",
       "1228   2010-12-01 13:38:00       7.95     15605.0  United Kingdom  \n",
       "1250   2010-12-01 13:54:00       7.95     14594.0  United Kingdom  \n",
       "1251   2010-12-01 13:54:00       7.95     14594.0  United Kingdom  \n",
       "1252   2010-12-01 13:54:00       7.95     14594.0  United Kingdom  \n",
       "...                    ...        ...         ...             ...  \n",
       "540764 2011-12-09 10:03:00       1.65         NaN  United Kingdom  \n",
       "540765 2011-12-09 10:03:00       1.65         NaN  United Kingdom  \n",
       "540781 2011-12-09 10:03:00       2.48         NaN  United Kingdom  \n",
       "540782 2011-12-09 10:03:00       1.65         NaN  United Kingdom  \n",
       "540787 2011-12-09 10:03:00       2.90         NaN  United Kingdom  \n",
       "540794 2011-12-09 10:03:00       2.48         NaN  United Kingdom  \n",
       "540808 2011-12-09 10:03:00     933.17         NaN  United Kingdom  \n",
       "540872 2011-12-09 10:03:00       4.13         NaN  United Kingdom  \n",
       "540879 2011-12-09 10:03:00      12.46         NaN  United Kingdom  \n",
       "540959 2011-12-09 10:03:00       2.46         NaN  United Kingdom  \n",
       "540987 2011-12-09 10:03:00       2.46         NaN  United Kingdom  \n",
       "541039 2011-12-09 10:03:00      15.79         NaN  United Kingdom  \n",
       "541114 2011-12-09 10:13:00       4.15     12518.0         Germany  \n",
       "541125 2011-12-09 10:20:00       7.08     14051.0  United Kingdom  \n",
       "541126 2011-12-09 10:20:00       7.08     14051.0  United Kingdom  \n",
       "541251 2011-12-09 10:26:00       3.29         NaN  United Kingdom  \n",
       "541255 2011-12-09 10:26:00      16.63         NaN  United Kingdom  \n",
       "541274 2011-12-09 10:26:00      12.46         NaN  United Kingdom  \n",
       "541342 2011-12-09 10:26:00      12.46         NaN  United Kingdom  \n",
       "541410 2011-12-09 10:26:00      14.13         NaN  United Kingdom  \n",
       "541440 2011-12-09 10:26:00    1714.17         NaN  United Kingdom  \n",
       "541444 2011-12-09 10:45:00       8.25     15344.0  United Kingdom  \n",
       "541449 2011-12-09 10:46:00       3.95     12985.0  United Kingdom  \n",
       "541471 2011-12-09 10:51:00       0.12     15910.0  United Kingdom  \n",
       "541551 2011-12-09 11:34:00       1.45     14446.0  United Kingdom  \n",
       "541553 2011-12-09 11:34:00       1.45     14446.0  United Kingdom  \n",
       "541569 2011-12-09 11:34:00       1.65     14446.0  United Kingdom  \n",
       "541627 2011-12-09 11:59:00       1.25     12662.0         Germany  \n",
       "541633 2011-12-09 12:00:00       8.25     15311.0  United Kingdom  \n",
       "541793 2011-12-09 12:49:00       7.08     13113.0  United Kingdom  \n",
       "\n",
       "[19404 rows x 8 columns]"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#1-c(ii)\n",
    "D=df3['Description'].str.startswith('D', na=False)\n",
    "df3[D]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Name</th>\n",
       "      <th>DOB</th>\n",
       "      <th>Marks</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Tanvi</td>\n",
       "      <td>30-04-2002</td>\n",
       "      <td>100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Akshara</td>\n",
       "      <td>05-07-2001</td>\n",
       "      <td>85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Ridhima</td>\n",
       "      <td>15-04-2000</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Maya</td>\n",
       "      <td>28-09-2000</td>\n",
       "      <td>78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Ayesha</td>\n",
       "      <td>01-01-2001</td>\n",
       "      <td>55</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      Name         DOB  Marks\n",
       "0    Tanvi  30-04-2002    100\n",
       "1  Akshara  05-07-2001     85\n",
       "2  Ridhima  15-04-2000     90\n",
       "3     Maya  28-09-2000     78\n",
       "4   Ayesha  01-01-2001     55"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#2-a(i)\n",
    "df4=[['Tanvi','30-04-2002',100],['Akshara','05-07-2001',85],['Ridhima','15-04-2000',90],['Maya','28-09-2000',78],['Ayesha','01-01-2001',55]]\n",
    "df4=pd.DataFrame(df4,columns=['Name','DOB','Marks'])\n",
    "df4"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Name</th>\n",
       "      <th>DOB</th>\n",
       "      <th>Marks</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Tanvi</td>\n",
       "      <td>30-04-2002</td>\n",
       "      <td>100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Akshara</td>\n",
       "      <td>05-07-2001</td>\n",
       "      <td>85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Ridhima</td>\n",
       "      <td>15-04-2000</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Maya</td>\n",
       "      <td>28-09-2000</td>\n",
       "      <td>78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Ayesha</td>\n",
       "      <td>01-01-2001</td>\n",
       "      <td>55</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      Name         DOB  Marks\n",
       "0    Tanvi  30-04-2002    100\n",
       "1  Akshara  05-07-2001     85\n",
       "2  Ridhima  15-04-2000     90\n",
       "3     Maya  28-09-2000     78\n",
       "4   Ayesha  01-01-2001     55"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#2-a(ii)\n",
    "df5={'Name':['Tanvi','Akshara','Ridhima','Maya','Ayesha'],'DOB':['30-04-2002','05-07-2001','15-04-2000','28-09-2000','01-01-2001'],'Marks':[100,85,90,78,55]}\n",
    "df5=pd.DataFrame(df5)\n",
    "df5"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>DOB</th>\n",
       "      <th>Marks</th>\n",
       "      <th>Name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>30-04-2002</td>\n",
       "      <td>100</td>\n",
       "      <td>Tanvi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>05-07-2001</td>\n",
       "      <td>85</td>\n",
       "      <td>Akshara</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>15-04-2000</td>\n",
       "      <td>90</td>\n",
       "      <td>Ridhima</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>28-09-2000</td>\n",
       "      <td>78</td>\n",
       "      <td>Maya</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>01-01-2001</td>\n",
       "      <td>55</td>\n",
       "      <td>Ayesha</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          DOB  Marks     Name\n",
       "0  30-04-2002    100    Tanvi\n",
       "1  05-07-2001     85  Akshara\n",
       "2  15-04-2000     90  Ridhima\n",
       "3  28-09-2000     78     Maya\n",
       "4  01-01-2001     55   Ayesha"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#2-a(iii)\n",
    "df6=[{'Name':'Tanvi','DOB':'30-04-2002','Marks':100},{'Name':'Akshara','DOB':'05-07-2001','Marks':85},{'Name':'Ridhima','DOB':'15-04-2000','Marks':90},{'Name':'Maya','DOB':'28-09-2000','Marks':78},{'Name':'Ayesha','DOB':'01-01-2001','Marks':55}]\n",
    "df6=pd.DataFrame(df6)\n",
    "df6"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Name</th>\n",
       "      <th>DOB</th>\n",
       "      <th>Marks</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Tanvi</td>\n",
       "      <td>30-04-2002</td>\n",
       "      <td>100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Akshara</td>\n",
       "      <td>05-07-2001</td>\n",
       "      <td>85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Ridhima</td>\n",
       "      <td>15-04-2000</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Maya</td>\n",
       "      <td>28-09-2000</td>\n",
       "      <td>78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Ayesha</td>\n",
       "      <td>01-01-2001</td>\n",
       "      <td>55</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      Name         DOB  Marks\n",
       "0    Tanvi  30-04-2002    100\n",
       "1  Akshara  05-07-2001     85\n",
       "2  Ridhima  15-04-2000     90\n",
       "3     Maya  28-09-2000     78\n",
       "4   Ayesha  01-01-2001     55"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#2-a(iv)\n",
    "Name=pd.Series(['Tanvi','Akshara','Ridhima','Maya','Ayesha'])\n",
    "DOB=pd.Series(['30-04-2002','05-07-2001','15-04-2000','28-09-2000','01-01-2001'])\n",
    "Marks=pd.Series([100,85,90,78,55])\n",
    "data={'Name':Name,'DOB':DOB,'Marks':Marks}\n",
    "df7=pd.DataFrame(*[data])\n",
    "df7"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Student Name</th>\n",
       "      <th>DOB</th>\n",
       "      <th>English Marks</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Tanvi</td>\n",
       "      <td>30-04-2002</td>\n",
       "      <td>100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Akshara</td>\n",
       "      <td>05-07-2001</td>\n",
       "      <td>85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Ridhima</td>\n",
       "      <td>15-04-2000</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Maya</td>\n",
       "      <td>28-09-2000</td>\n",
       "      <td>78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Ayesha</td>\n",
       "      <td>01-01-2001</td>\n",
       "      <td>55</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Student Name         DOB English Marks\n",
       "0        Tanvi  30-04-2002           100\n",
       "1      Akshara  05-07-2001            85\n",
       "2      Ridhima  15-04-2000            90\n",
       "3         Maya  28-09-2000            78\n",
       "4       Ayesha  01-01-2001            55"
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#2-b\n",
    "df8=pd.DataFrame(columns=['Student Name','DOB','English Marks'])\n",
    "df8=df8.append({'Student Name':'Tanvi','DOB':'30-04-2002','English Marks':100},ignore_index = True)\n",
    "df8=df8.append({'Student Name':'Akshara','DOB':'05-07-2001','English Marks':85},ignore_index = True)\n",
    "df8=df8.append({'Student Name':'Ridhima','DOB':'15-04-2000','English Marks':90},ignore_index = True)\n",
    "df8=df8.append({'Student Name':'Maya','DOB':'28-09-2000','English Marks':78},ignore_index = True)\n",
    "df8=df8.append({'Student Name':'Ayesha','DOB':'01-01-2001','English Marks':55},ignore_index = True)\n",
    "df8"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "metadata": {},
   "outputs": [],
   "source": [
    "#3-a\n",
    "import random\n",
    "ser1,ser2=random.sample(range(-100,100),100),random.sample(range(-100,100),100)\n",
    "ser1,ser2=pd.Series(ser1),pd.Series(ser2),"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {},
   "outputs": [],
   "source": [
    "#3-b\n",
    "add=ser1.add(ser2,fill_value=0)\n",
    "sub=ser1.sub(ser2,fill_value=0)\n",
    "mul=ser1.mul(ser2,fill_value=0)\n",
    "div=ser1.div(ser2,fill_value=0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Number 1</th>\n",
       "      <th>Number 2</th>\n",
       "      <th>add</th>\n",
       "      <th>sub</th>\n",
       "      <th>mult</th>\n",
       "      <th>div</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>13</td>\n",
       "      <td>-36</td>\n",
       "      <td>-23</td>\n",
       "      <td>49</td>\n",
       "      <td>-468</td>\n",
       "      <td>-0.361111</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>-67</td>\n",
       "      <td>-55</td>\n",
       "      <td>-122</td>\n",
       "      <td>-12</td>\n",
       "      <td>3685</td>\n",
       "      <td>1.218182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>-69</td>\n",
       "      <td>-81</td>\n",
       "      <td>-150</td>\n",
       "      <td>12</td>\n",
       "      <td>5589</td>\n",
       "      <td>0.851852</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>34</td>\n",
       "      <td>-98</td>\n",
       "      <td>-64</td>\n",
       "      <td>132</td>\n",
       "      <td>-3332</td>\n",
       "      <td>-0.346939</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>72</td>\n",
       "      <td>-65</td>\n",
       "      <td>7</td>\n",
       "      <td>137</td>\n",
       "      <td>-4680</td>\n",
       "      <td>-1.107692</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>-59</td>\n",
       "      <td>43</td>\n",
       "      <td>-16</td>\n",
       "      <td>-102</td>\n",
       "      <td>-2537</td>\n",
       "      <td>-1.372093</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>-62</td>\n",
       "      <td>9</td>\n",
       "      <td>-53</td>\n",
       "      <td>-71</td>\n",
       "      <td>-558</td>\n",
       "      <td>-6.888889</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>15</td>\n",
       "      <td>2</td>\n",
       "      <td>17</td>\n",
       "      <td>13</td>\n",
       "      <td>30</td>\n",
       "      <td>7.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>28</td>\n",
       "      <td>28</td>\n",
       "      <td>56</td>\n",
       "      <td>0</td>\n",
       "      <td>784</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>46</td>\n",
       "      <td>-83</td>\n",
       "      <td>-37</td>\n",
       "      <td>129</td>\n",
       "      <td>-3818</td>\n",
       "      <td>-0.554217</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>45</td>\n",
       "      <td>-46</td>\n",
       "      <td>-1</td>\n",
       "      <td>91</td>\n",
       "      <td>-2070</td>\n",
       "      <td>-0.978261</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>7</td>\n",
       "      <td>-16</td>\n",
       "      <td>-9</td>\n",
       "      <td>23</td>\n",
       "      <td>-112</td>\n",
       "      <td>-0.437500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>-90</td>\n",
       "      <td>74</td>\n",
       "      <td>-16</td>\n",
       "      <td>-164</td>\n",
       "      <td>-6660</td>\n",
       "      <td>-1.216216</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>-7</td>\n",
       "      <td>78</td>\n",
       "      <td>71</td>\n",
       "      <td>-85</td>\n",
       "      <td>-546</td>\n",
       "      <td>-0.089744</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>74</td>\n",
       "      <td>21</td>\n",
       "      <td>95</td>\n",
       "      <td>53</td>\n",
       "      <td>1554</td>\n",
       "      <td>3.523810</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>80</td>\n",
       "      <td>-73</td>\n",
       "      <td>7</td>\n",
       "      <td>153</td>\n",
       "      <td>-5840</td>\n",
       "      <td>-1.095890</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>67</td>\n",
       "      <td>-62</td>\n",
       "      <td>5</td>\n",
       "      <td>129</td>\n",
       "      <td>-4154</td>\n",
       "      <td>-1.080645</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>31</td>\n",
       "      <td>1</td>\n",
       "      <td>32</td>\n",
       "      <td>30</td>\n",
       "      <td>31</td>\n",
       "      <td>31.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>-81</td>\n",
       "      <td>34</td>\n",
       "      <td>-47</td>\n",
       "      <td>-115</td>\n",
       "      <td>-2754</td>\n",
       "      <td>-2.382353</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>-10</td>\n",
       "      <td>32</td>\n",
       "      <td>22</td>\n",
       "      <td>-42</td>\n",
       "      <td>-320</td>\n",
       "      <td>-0.312500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>14</td>\n",
       "      <td>-44</td>\n",
       "      <td>-30</td>\n",
       "      <td>58</td>\n",
       "      <td>-616</td>\n",
       "      <td>-0.318182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>4</td>\n",
       "      <td>83</td>\n",
       "      <td>87</td>\n",
       "      <td>-79</td>\n",
       "      <td>332</td>\n",
       "      <td>0.048193</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>-27</td>\n",
       "      <td>-100</td>\n",
       "      <td>-127</td>\n",
       "      <td>73</td>\n",
       "      <td>2700</td>\n",
       "      <td>0.270000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>-60</td>\n",
       "      <td>67</td>\n",
       "      <td>7</td>\n",
       "      <td>-127</td>\n",
       "      <td>-4020</td>\n",
       "      <td>-0.895522</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>85</td>\n",
       "      <td>-34</td>\n",
       "      <td>51</td>\n",
       "      <td>119</td>\n",
       "      <td>-2890</td>\n",
       "      <td>-2.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>-8</td>\n",
       "      <td>-82</td>\n",
       "      <td>-90</td>\n",
       "      <td>74</td>\n",
       "      <td>656</td>\n",
       "      <td>0.097561</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>84</td>\n",
       "      <td>22</td>\n",
       "      <td>106</td>\n",
       "      <td>62</td>\n",
       "      <td>1848</td>\n",
       "      <td>3.818182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>-57</td>\n",
       "      <td>35</td>\n",
       "      <td>-22</td>\n",
       "      <td>-92</td>\n",
       "      <td>-1995</td>\n",
       "      <td>-1.628571</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>95</td>\n",
       "      <td>8</td>\n",
       "      <td>103</td>\n",
       "      <td>87</td>\n",
       "      <td>760</td>\n",
       "      <td>11.875000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>52</td>\n",
       "      <td>-25</td>\n",
       "      <td>27</td>\n",
       "      <td>77</td>\n",
       "      <td>-1300</td>\n",
       "      <td>-2.080000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>-51</td>\n",
       "      <td>79</td>\n",
       "      <td>28</td>\n",
       "      <td>-130</td>\n",
       "      <td>-4029</td>\n",
       "      <td>-0.645570</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>-18</td>\n",
       "      <td>37</td>\n",
       "      <td>19</td>\n",
       "      <td>-55</td>\n",
       "      <td>-666</td>\n",
       "      <td>-0.486486</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>-92</td>\n",
       "      <td>-87</td>\n",
       "      <td>-179</td>\n",
       "      <td>-5</td>\n",
       "      <td>8004</td>\n",
       "      <td>1.057471</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>-5</td>\n",
       "      <td>65</td>\n",
       "      <td>60</td>\n",
       "      <td>-70</td>\n",
       "      <td>-325</td>\n",
       "      <td>-0.076923</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>57</td>\n",
       "      <td>-32</td>\n",
       "      <td>25</td>\n",
       "      <td>89</td>\n",
       "      <td>-1824</td>\n",
       "      <td>-1.781250</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>-78</td>\n",
       "      <td>-94</td>\n",
       "      <td>-172</td>\n",
       "      <td>16</td>\n",
       "      <td>7332</td>\n",
       "      <td>0.829787</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>-74</td>\n",
       "      <td>-92</td>\n",
       "      <td>-166</td>\n",
       "      <td>18</td>\n",
       "      <td>6808</td>\n",
       "      <td>0.804348</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>81</td>\n",
       "      <td>-30</td>\n",
       "      <td>51</td>\n",
       "      <td>111</td>\n",
       "      <td>-2430</td>\n",
       "      <td>-2.700000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>-15</td>\n",
       "      <td>4</td>\n",
       "      <td>-11</td>\n",
       "      <td>-19</td>\n",
       "      <td>-60</td>\n",
       "      <td>-3.750000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>61</td>\n",
       "      <td>-13</td>\n",
       "      <td>48</td>\n",
       "      <td>74</td>\n",
       "      <td>-793</td>\n",
       "      <td>-4.692308</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>-95</td>\n",
       "      <td>-54</td>\n",
       "      <td>-149</td>\n",
       "      <td>-41</td>\n",
       "      <td>5130</td>\n",
       "      <td>1.759259</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>53</td>\n",
       "      <td>99</td>\n",
       "      <td>152</td>\n",
       "      <td>-46</td>\n",
       "      <td>5247</td>\n",
       "      <td>0.535354</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>63</td>\n",
       "      <td>39</td>\n",
       "      <td>102</td>\n",
       "      <td>24</td>\n",
       "      <td>2457</td>\n",
       "      <td>1.615385</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>-26</td>\n",
       "      <td>-22</td>\n",
       "      <td>-48</td>\n",
       "      <td>-4</td>\n",
       "      <td>572</td>\n",
       "      <td>1.181818</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>32</td>\n",
       "      <td>36</td>\n",
       "      <td>68</td>\n",
       "      <td>-4</td>\n",
       "      <td>1152</td>\n",
       "      <td>0.888889</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>73</td>\n",
       "      <td>-23</td>\n",
       "      <td>50</td>\n",
       "      <td>96</td>\n",
       "      <td>-1679</td>\n",
       "      <td>-3.173913</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>-80</td>\n",
       "      <td>51</td>\n",
       "      <td>-29</td>\n",
       "      <td>-131</td>\n",
       "      <td>-4080</td>\n",
       "      <td>-1.568627</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>-50</td>\n",
       "      <td>-61</td>\n",
       "      <td>-111</td>\n",
       "      <td>11</td>\n",
       "      <td>3050</td>\n",
       "      <td>0.819672</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>-65</td>\n",
       "      <td>44</td>\n",
       "      <td>-21</td>\n",
       "      <td>-109</td>\n",
       "      <td>-2860</td>\n",
       "      <td>-1.477273</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>92</td>\n",
       "      <td>53</td>\n",
       "      <td>145</td>\n",
       "      <td>39</td>\n",
       "      <td>4876</td>\n",
       "      <td>1.735849</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>96</td>\n",
       "      <td>85</td>\n",
       "      <td>181</td>\n",
       "      <td>11</td>\n",
       "      <td>8160</td>\n",
       "      <td>1.129412</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>-68</td>\n",
       "      <td>-89</td>\n",
       "      <td>-157</td>\n",
       "      <td>21</td>\n",
       "      <td>6052</td>\n",
       "      <td>0.764045</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>9</td>\n",
       "      <td>-50</td>\n",
       "      <td>-41</td>\n",
       "      <td>59</td>\n",
       "      <td>-450</td>\n",
       "      <td>-0.180000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>-66</td>\n",
       "      <td>63</td>\n",
       "      <td>-3</td>\n",
       "      <td>-129</td>\n",
       "      <td>-4158</td>\n",
       "      <td>-1.047619</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>-1</td>\n",
       "      <td>56</td>\n",
       "      <td>55</td>\n",
       "      <td>-57</td>\n",
       "      <td>-56</td>\n",
       "      <td>-0.017857</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>16</td>\n",
       "      <td>-29</td>\n",
       "      <td>-13</td>\n",
       "      <td>45</td>\n",
       "      <td>-464</td>\n",
       "      <td>-0.551724</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>70</td>\n",
       "      <td>89</td>\n",
       "      <td>159</td>\n",
       "      <td>-19</td>\n",
       "      <td>6230</td>\n",
       "      <td>0.786517</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>-48</td>\n",
       "      <td>16</td>\n",
       "      <td>-32</td>\n",
       "      <td>-64</td>\n",
       "      <td>-768</td>\n",
       "      <td>-3.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>-84</td>\n",
       "      <td>69</td>\n",
       "      <td>-15</td>\n",
       "      <td>-153</td>\n",
       "      <td>-5796</td>\n",
       "      <td>-1.217391</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>69</td>\n",
       "      <td>-77</td>\n",
       "      <td>-8</td>\n",
       "      <td>146</td>\n",
       "      <td>-5313</td>\n",
       "      <td>-0.896104</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>100 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Number 1  Number 2  add  sub  mult        div\n",
       "0         13       -36  -23   49  -468  -0.361111\n",
       "1        -67       -55 -122  -12  3685   1.218182\n",
       "2        -69       -81 -150   12  5589   0.851852\n",
       "3         34       -98  -64  132 -3332  -0.346939\n",
       "4         72       -65    7  137 -4680  -1.107692\n",
       "5        -59        43  -16 -102 -2537  -1.372093\n",
       "6        -62         9  -53  -71  -558  -6.888889\n",
       "7         15         2   17   13    30   7.500000\n",
       "8         28        28   56    0   784   1.000000\n",
       "9         46       -83  -37  129 -3818  -0.554217\n",
       "10        45       -46   -1   91 -2070  -0.978261\n",
       "11         7       -16   -9   23  -112  -0.437500\n",
       "12       -90        74  -16 -164 -6660  -1.216216\n",
       "13        -7        78   71  -85  -546  -0.089744\n",
       "14        74        21   95   53  1554   3.523810\n",
       "15        80       -73    7  153 -5840  -1.095890\n",
       "16        67       -62    5  129 -4154  -1.080645\n",
       "17        31         1   32   30    31  31.000000\n",
       "18       -81        34  -47 -115 -2754  -2.382353\n",
       "19       -10        32   22  -42  -320  -0.312500\n",
       "20        14       -44  -30   58  -616  -0.318182\n",
       "21         4        83   87  -79   332   0.048193\n",
       "22       -27      -100 -127   73  2700   0.270000\n",
       "23       -60        67    7 -127 -4020  -0.895522\n",
       "24        85       -34   51  119 -2890  -2.500000\n",
       "25        -8       -82  -90   74   656   0.097561\n",
       "26        84        22  106   62  1848   3.818182\n",
       "27       -57        35  -22  -92 -1995  -1.628571\n",
       "28        95         8  103   87   760  11.875000\n",
       "29        52       -25   27   77 -1300  -2.080000\n",
       "..       ...       ...  ...  ...   ...        ...\n",
       "70       -51        79   28 -130 -4029  -0.645570\n",
       "71       -18        37   19  -55  -666  -0.486486\n",
       "72       -92       -87 -179   -5  8004   1.057471\n",
       "73        -5        65   60  -70  -325  -0.076923\n",
       "74        57       -32   25   89 -1824  -1.781250\n",
       "75       -78       -94 -172   16  7332   0.829787\n",
       "76       -74       -92 -166   18  6808   0.804348\n",
       "77        81       -30   51  111 -2430  -2.700000\n",
       "78       -15         4  -11  -19   -60  -3.750000\n",
       "79        61       -13   48   74  -793  -4.692308\n",
       "80       -95       -54 -149  -41  5130   1.759259\n",
       "81        53        99  152  -46  5247   0.535354\n",
       "82        63        39  102   24  2457   1.615385\n",
       "83       -26       -22  -48   -4   572   1.181818\n",
       "84        32        36   68   -4  1152   0.888889\n",
       "85        73       -23   50   96 -1679  -3.173913\n",
       "86       -80        51  -29 -131 -4080  -1.568627\n",
       "87       -50       -61 -111   11  3050   0.819672\n",
       "88       -65        44  -21 -109 -2860  -1.477273\n",
       "89        92        53  145   39  4876   1.735849\n",
       "90        96        85  181   11  8160   1.129412\n",
       "91       -68       -89 -157   21  6052   0.764045\n",
       "92         9       -50  -41   59  -450  -0.180000\n",
       "93       -66        63   -3 -129 -4158  -1.047619\n",
       "94        -1        56   55  -57   -56  -0.017857\n",
       "95        16       -29  -13   45  -464  -0.551724\n",
       "96        70        89  159  -19  6230   0.786517\n",
       "97       -48        16  -32  -64  -768  -3.000000\n",
       "98       -84        69  -15 -153 -5796  -1.217391\n",
       "99        69       -77   -8  146 -5313  -0.896104\n",
       "\n",
       "[100 rows x 6 columns]"
      ]
     },
     "execution_count": 53,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#3-c\n",
    "df9=pd.DataFrame({'Number 1':ser1,'Number 2':ser2,'add':add,'sub':sub,'mult':mul,'div':div})\n",
    "df9"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "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.7.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}