{ "cells": [ { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [], "source": [ "#import libraries required for analysis\n", "import pandas as pd\n", "import numpy as np\n", "from ebmdatalab import bq" ] }, { "cell_type": "code", "execution_count": 3, "metadata": {}, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "C:\\Users\\racro\\Anaconda3\\lib\\site-packages\\pandas\\io\\gbq.py:108: FutureWarning: verbose is deprecated and will be removed in a future version. Set logging level in order to vary verbosity\n", " **kwargs)\n" ] }, { "data": { "text/html": [ "
\n", " | month | \n", "bnf_name | \n", "bnf_code | \n", "quantity | \n", "actual_cost | \n", "
---|---|---|---|---|---|
0 | \n", "2011-04-01 | \n", "Intanza_Vac 15mcg/0.1ml Strain Pfs | \n", "1404000H0BQABAI | \n", "1399 | \n", "11654.98 | \n", "
1 | \n", "2011-04-01 | \n", "Inflexal V_Vac 0.5ml Pfs | \n", "1404000H0BIAAAF | \n", "17 | \n", "95.92 | \n", "
2 | \n", "2011-04-01 | \n", "Influenza_Vac Inact 9mcg/0.1ml Pfs | \n", "1404000H0AAAHAH | \n", "2 | \n", "16.72 | \n", "
3 | \n", "2011-04-01 | \n", "Begrivac_Vac 0.5ml Pfs | \n", "1404000H0BGAAAF | \n", "1130 | \n", "6086.22 | \n", "
4 | \n", "2011-04-01 | \n", "Fluvirin_Vac 0.5ml Pfs | \n", "1404000H0BBAAAF | \n", "34 | \n", "173.81 | \n", "
\n", " | quantity | \n", "actual_cost | \n", "
---|---|---|
month | \n", "\n", " | \n", " |
2011-04-01 | \n", "35819 | \n", "£213,769 | \n", "
2011-05-01 | \n", "19270 | \n", "£111,343 | \n", "
2011-06-01 | \n", "15716 | \n", "£89,109 | \n", "
2011-07-01 | \n", "9090 | \n", "£53,687 | \n", "
2011-08-01 | \n", "10258 | \n", "£60,034 | \n", "
2011-09-01 | \n", "850455 | \n", "£5,005,017 | \n", "
2011-10-01 | \n", "5827836 | \n", "£34,338,176 | \n", "
2011-11-01 | \n", "2463149 | \n", "£14,504,938 | \n", "
2011-12-01 | \n", "845111 | \n", "£4,970,248 | \n", "
2012-01-01 | \n", "339537 | \n", "£1,994,701 | \n", "
2012-02-01 | \n", "148304 | \n", "£869,428 | \n", "
2012-03-01 | \n", "68750 | \n", "£401,236 | \n", "
2012-04-01 | \n", "33947 | \n", "£193,163 | \n", "
2012-05-01 | \n", "28119 | \n", "£168,794 | \n", "
2012-06-01 | \n", "23619 | \n", "£131,924 | \n", "
2012-07-01 | \n", "5757 | \n", "£32,806 | \n", "
2012-08-01 | \n", "2989 | \n", "£16,264 | \n", "
2012-09-01 | \n", "756942 | \n", "£4,552,599 | \n", "
2012-10-01 | \n", "5647630 | \n", "£33,464,306 | \n", "
2012-11-01 | \n", "2837006 | \n", "£16,698,334 | \n", "
2012-12-01 | \n", "927877 | \n", "£5,457,099 | \n", "
2013-01-01 | \n", "401230 | \n", "£2,343,758 | \n", "
2013-02-01 | \n", "167973 | \n", "£980,340 | \n", "
2013-03-01 | \n", "93941 | \n", "£547,317 | \n", "
2013-04-01 | \n", "38608 | \n", "£225,166 | \n", "
2013-05-01 | \n", "13406 | \n", "£78,281 | \n", "
2013-06-01 | \n", "20751 | \n", "£124,039 | \n", "
2013-07-01 | \n", "5781 | \n", "£34,879 | \n", "
2013-08-01 | \n", "5574 | \n", "£32,981 | \n", "
2013-09-01 | \n", "725934 | \n", "£4,379,893 | \n", "
... | \n", "... | \n", "... | \n", "
2016-07-01 | \n", "18186 | \n", "£111,040 | \n", "
2016-08-01 | \n", "21015 | \n", "£135,784 | \n", "
2016-09-01 | \n", "2061808 | \n", "£12,665,664 | \n", "
2016-10-01 | \n", "4752789 | \n", "£29,095,693 | \n", "
2016-11-01 | \n", "1903130 | \n", "£11,621,805 | \n", "
2016-12-01 | \n", "796246 | \n", "£4,855,039 | \n", "
2017-01-01 | \n", "368551 | \n", "£2,253,340 | \n", "
2017-02-01 | \n", "210495 | \n", "£1,287,904 | \n", "
2017-03-01 | \n", "148903 | \n", "£897,161 | \n", "
2017-04-01 | \n", "40050 | \n", "£244,332 | \n", "
2017-05-01 | \n", "40878 | \n", "£254,693 | \n", "
2017-06-01 | \n", "26002 | \n", "£159,409 | \n", "
2017-07-01 | \n", "27915 | \n", "£167,995 | \n", "
2017-08-01 | \n", "23677 | \n", "£142,066 | \n", "
2017-09-01 | \n", "2592842 | \n", "£16,560,997 | \n", "
2017-10-01 | \n", "4627952 | \n", "£29,609,255 | \n", "
2017-11-01 | \n", "1752636 | \n", "£11,197,910 | \n", "
2017-12-01 | \n", "708743 | \n", "£4,509,635 | \n", "
2018-01-01 | \n", "465403 | \n", "£2,985,500 | \n", "
2018-02-01 | \n", "220042 | \n", "£1,401,840 | \n", "
2018-03-01 | \n", "135733 | \n", "£863,361 | \n", "
2018-04-01 | \n", "57626 | \n", "£364,694 | \n", "
2018-05-01 | \n", "48693 | \n", "£303,773 | \n", "
2018-06-01 | \n", "18132 | \n", "£120,099 | \n", "
2018-07-01 | \n", "15073 | \n", "£94,847 | \n", "
2018-08-01 | \n", "10927 | \n", "£69,464 | \n", "
2018-09-01 | \n", "1686491 | \n", "£14,290,031 | \n", "
2018-10-01 | \n", "3661628 | \n", "£30,723,290 | \n", "
2018-11-01 | \n", "2998311 | \n", "£25,629,831 | \n", "
2018-12-01 | \n", "973069 | \n", "£8,133,543 | \n", "
93 rows × 2 columns
\n", "