{ "cells": [ { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [ { "data": { "text/html": [ "" ], "text/plain": [ "" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "import warnings\n", "warnings.filterwarnings('ignore')\n", "\n", "from IPython.display import display, HTML\n", "display(HTML(\"\"))" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "# TU257-Lab9-Demo2\n", "For this lab follow what is run in each cell\n", "\n", "#### Then add a new cell above each Code Cell, change it to Markdown, and write some text to describe what is happening in the next Code Cell\n", "\n", "i.e. write some comments/documentation for this notebook" ] }, { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
InvoiceNoStockCodeDescriptionQuantityInvoiceDateUnitPriceCustomerIDCountry
053636585123AWHITE HANGING HEART T-LIGHT HOLDER601/12/2010 08:262.5517850.0United Kingdom
153636571053WHITE METAL LANTERN601/12/2010 08:263.3917850.0United Kingdom
253636584406BCREAM CUPID HEARTS COAT HANGER801/12/2010 08:262.7517850.0United Kingdom
353636584029GKNITTED UNION FLAG HOT WATER BOTTLE601/12/2010 08:263.3917850.0United Kingdom
453636584029ERED WOOLLY HOTTIE WHITE HEART.601/12/2010 08:263.3917850.0United Kingdom
553636522752SET 7 BABUSHKA NESTING BOXES201/12/2010 08:267.6517850.0United Kingdom
653636521730GLASS STAR FROSTED T-LIGHT HOLDER601/12/2010 08:264.2517850.0United Kingdom
753636622633HAND WARMER UNION JACK601/12/2010 08:281.8517850.0United Kingdom
853636622632HAND WARMER RED POLKA DOT601/12/2010 08:281.8517850.0United Kingdom
953636784879ASSORTED COLOUR BIRD ORNAMENT3201/12/2010 08:341.6913047.0United Kingdom
1053636722745POPPY'S PLAYHOUSE BEDROOM601/12/2010 08:342.1013047.0United Kingdom
1153636722748POPPY'S PLAYHOUSE KITCHEN601/12/2010 08:342.1013047.0United Kingdom
1253636722749FELTCRAFT PRINCESS CHARLOTTE DOLL801/12/2010 08:343.7513047.0United Kingdom
1353636722310IVORY KNITTED MUG COSY601/12/2010 08:341.6513047.0United Kingdom
1453636784969BOX OF 6 ASSORTED COLOUR TEASPOONS601/12/2010 08:344.2513047.0United Kingdom
1553636722623BOX OF VINTAGE JIGSAW BLOCKS301/12/2010 08:344.9513047.0United Kingdom
1653636722622BOX OF VINTAGE ALPHABET BLOCKS201/12/2010 08:349.9513047.0United Kingdom
1753636721754HOME BUILDING BLOCK WORD301/12/2010 08:345.9513047.0United Kingdom
1853636721755LOVE BUILDING BLOCK WORD301/12/2010 08:345.9513047.0United Kingdom
1953636721777RECIPE BOX WITH METAL HEART401/12/2010 08:347.9513047.0United Kingdom
\n", "
" ], "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", "\n", " InvoiceDate UnitPrice CustomerID Country \n", "0 01/12/2010 08:26 2.55 17850.0 United Kingdom \n", "1 01/12/2010 08:26 3.39 17850.0 United Kingdom \n", "2 01/12/2010 08:26 2.75 17850.0 United Kingdom \n", "3 01/12/2010 08:26 3.39 17850.0 United Kingdom \n", "4 01/12/2010 08:26 3.39 17850.0 United Kingdom \n", "5 01/12/2010 08:26 7.65 17850.0 United Kingdom \n", "6 01/12/2010 08:26 4.25 17850.0 United Kingdom \n", "7 01/12/2010 08:28 1.85 17850.0 United Kingdom \n", "8 01/12/2010 08:28 1.85 17850.0 United Kingdom \n", "9 01/12/2010 08:34 1.69 13047.0 United Kingdom \n", "10 01/12/2010 08:34 2.10 13047.0 United Kingdom \n", "11 01/12/2010 08:34 2.10 13047.0 United Kingdom \n", "12 01/12/2010 08:34 3.75 13047.0 United Kingdom \n", "13 01/12/2010 08:34 1.65 13047.0 United Kingdom \n", "14 01/12/2010 08:34 4.25 13047.0 United Kingdom \n", "15 01/12/2010 08:34 4.95 13047.0 United Kingdom \n", "16 01/12/2010 08:34 9.95 13047.0 United Kingdom \n", "17 01/12/2010 08:34 5.95 13047.0 United Kingdom \n", "18 01/12/2010 08:34 5.95 13047.0 United Kingdom \n", "19 01/12/2010 08:34 7.95 13047.0 United Kingdom " ] }, "execution_count": 1, "metadata": {}, "output_type": "execute_result" } ], "source": [ "import pandas as pd\n", "from mlxtend.frequent_patterns import apriori\n", "from mlxtend.frequent_patterns import association_rules\n", "\n", "df = pd.read_csv('/Users/brendan.tierney/Dropbox/4-Datasets/Online-Retail.csv')\n", "df.head(20)" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
CountryNumRecords
0Australia1259
1Austria401
2Bahrain19
3Belgium2069
4Brazil32
5Canada151
6Channel Islands758
7Cyprus622
8Czech Republic30
9Denmark389
10EIRE8196
11European Community61
12Finland695
13France8557
14Germany9495
15Greece146
16Hong Kong288
17Iceland182
18Israel297
19Italy803
20Japan358
21Lebanon45
22Lithuania35
23Malta127
24Netherlands2371
25Norway1086
26Poland341
27Portugal1519
28RSA58
29Saudi Arabia10
30Singapore229
31Spain2533
32Sweden462
33Switzerland2002
34USA291
35United Arab Emirates68
36United Kingdom495478
37Unspecified446
\n", "
" ], "text/plain": [ " Country NumRecords\n", "0 Australia 1259\n", "1 Austria 401\n", "2 Bahrain 19\n", "3 Belgium 2069\n", "4 Brazil 32\n", "5 Canada 151\n", "6 Channel Islands 758\n", "7 Cyprus 622\n", "8 Czech Republic 30\n", "9 Denmark 389\n", "10 EIRE 8196\n", "11 European Community 61\n", "12 Finland 695\n", "13 France 8557\n", "14 Germany 9495\n", "15 Greece 146\n", "16 Hong Kong 288\n", "17 Iceland 182\n", "18 Israel 297\n", "19 Italy 803\n", "20 Japan 358\n", "21 Lebanon 45\n", "22 Lithuania 35\n", "23 Malta 127\n", "24 Netherlands 2371\n", "25 Norway 1086\n", "26 Poland 341\n", "27 Portugal 1519\n", "28 RSA 58\n", "29 Saudi Arabia 10\n", "30 Singapore 229\n", "31 Spain 2533\n", "32 Sweden 462\n", "33 Switzerland 2002\n", "34 USA 291\n", "35 United Arab Emirates 68\n", "36 United Kingdom 495478\n", "37 Unspecified 446" ] }, "execution_count": 2, "metadata": {}, "output_type": "execute_result" } ], "source": [ "#...\n", "country_sales = df.groupby(['Country'])['InvoiceNo'].count().reset_index(name ='NumRecords')\n", "country_sales" ] }, { "cell_type": "code", "execution_count": 3, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
CountryNumRecords
36United Kingdom495478
14Germany9495
13France8557
10EIRE8196
31Spain2533
24Netherlands2371
3Belgium2069
33Switzerland2002
27Portugal1519
0Australia1259
25Norway1086
19Italy803
6Channel Islands758
12Finland695
7Cyprus622
32Sweden462
37Unspecified446
1Austria401
9Denmark389
20Japan358
26Poland341
18Israel297
34USA291
16Hong Kong288
30Singapore229
17Iceland182
5Canada151
15Greece146
23Malta127
35United Arab Emirates68
11European Community61
28RSA58
21Lebanon45
22Lithuania35
4Brazil32
8Czech Republic30
2Bahrain19
29Saudi Arabia10
\n", "
" ], "text/plain": [ " Country NumRecords\n", "36 United Kingdom 495478\n", "14 Germany 9495\n", "13 France 8557\n", "10 EIRE 8196\n", "31 Spain 2533\n", "24 Netherlands 2371\n", "3 Belgium 2069\n", "33 Switzerland 2002\n", "27 Portugal 1519\n", "0 Australia 1259\n", "25 Norway 1086\n", "19 Italy 803\n", "6 Channel Islands 758\n", "12 Finland 695\n", "7 Cyprus 622\n", "32 Sweden 462\n", "37 Unspecified 446\n", "1 Austria 401\n", "9 Denmark 389\n", "20 Japan 358\n", "26 Poland 341\n", "18 Israel 297\n", "34 USA 291\n", "16 Hong Kong 288\n", "30 Singapore 229\n", "17 Iceland 182\n", "5 Canada 151\n", "15 Greece 146\n", "23 Malta 127\n", "35 United Arab Emirates 68\n", "11 European Community 61\n", "28 RSA 58\n", "21 Lebanon 45\n", "22 Lithuania 35\n", "4 Brazil 32\n", "8 Czech Republic 30\n", "2 Bahrain 19\n", "29 Saudi Arabia 10" ] }, "execution_count": 3, "metadata": {}, "output_type": "execute_result" } ], "source": [ "country_sales_order = country_sales.sort_values(['NumRecords'],ascending=False)\n", "country_sales_order" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## This is an example of Markdown\n", "##### This section explores the retails sales from Ireland\n", "This line has no formatting" ] }, { "cell_type": "code", "execution_count": 4, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
indexInvoiceNoStockCodeDescriptionQuantityInvoiceDateUnitPriceCustomerIDCountry
0140453654022968ROSE COTTAGE KEEPSAKE BOX401/12/2010 14:059.9514911.0EIRE
1140553654085071ABLUE CHARLIE+LOLA PERSONAL DOORSIGN601/12/2010 14:052.9514911.0EIRE
2140653654085071CCHARLIE+LOLA\"EXTREMELY BUSY\" SIGN601/12/2010 14:052.5514911.0EIRE
3140753654022355CHARLOTTE BAG SUKI DESIGN5001/12/2010 14:050.8514911.0EIRE
4140853654021579LOLITA DESIGN COTTON TOTE BAG601/12/2010 14:052.2514911.0EIRE
5140953654021576LETS GO SHOPPING COTTON TOTE BAG601/12/2010 14:052.2514911.0EIRE
6141053654022147FELTCRAFT BUTTERFLY HEARTS1201/12/2010 14:051.4514911.0EIRE
71411536540221503 STRIPEY MICE FELTCRAFT1201/12/2010 14:051.9514911.0EIRE
8141253654022492MINI PAINT SET VINTAGE3601/12/2010 14:050.6514911.0EIRE
9141353654022493PAINT YOUR OWN CANVAS SET2401/12/2010 14:051.6514911.0EIRE
\n", "
" ], "text/plain": [ " index InvoiceNo StockCode Description Quantity \\\n", "0 1404 536540 22968 ROSE COTTAGE KEEPSAKE BOX 4 \n", "1 1405 536540 85071A BLUE CHARLIE+LOLA PERSONAL DOORSIGN 6 \n", "2 1406 536540 85071C CHARLIE+LOLA\"EXTREMELY BUSY\" SIGN 6 \n", "3 1407 536540 22355 CHARLOTTE BAG SUKI DESIGN 50 \n", "4 1408 536540 21579 LOLITA DESIGN COTTON TOTE BAG 6 \n", "5 1409 536540 21576 LETS GO SHOPPING COTTON TOTE BAG 6 \n", "6 1410 536540 22147 FELTCRAFT BUTTERFLY HEARTS 12 \n", "7 1411 536540 22150 3 STRIPEY MICE FELTCRAFT 12 \n", "8 1412 536540 22492 MINI PAINT SET VINTAGE 36 \n", "9 1413 536540 22493 PAINT YOUR OWN CANVAS SET 24 \n", "\n", " InvoiceDate UnitPrice CustomerID Country \n", "0 01/12/2010 14:05 9.95 14911.0 EIRE \n", "1 01/12/2010 14:05 2.95 14911.0 EIRE \n", "2 01/12/2010 14:05 2.55 14911.0 EIRE \n", "3 01/12/2010 14:05 0.85 14911.0 EIRE \n", "4 01/12/2010 14:05 2.25 14911.0 EIRE \n", "5 01/12/2010 14:05 2.25 14911.0 EIRE \n", "6 01/12/2010 14:05 1.45 14911.0 EIRE \n", "7 01/12/2010 14:05 1.95 14911.0 EIRE \n", "8 01/12/2010 14:05 0.65 14911.0 EIRE \n", "9 01/12/2010 14:05 1.65 14911.0 EIRE " ] }, "execution_count": 4, "metadata": {}, "output_type": "execute_result" } ], "source": [ "Ireland_sales = df[df['Country'] ==\"EIRE\"].reset_index()\n", "Ireland_sales.head(10)" ] }, { "cell_type": "code", "execution_count": 5, "metadata": {}, "outputs": [], "source": [ "Ireland_sales['Description'] = Ireland_sales['Description'].str.strip()\n" ] }, { "cell_type": "code", "execution_count": 6, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Description4 PURPLE FLOCK DINNER CANDLES50'S CHRISTMAS GIFT BAG LARGEDOLLY GIRL BEAKERNINE DRAWER OFFICE TIDYOVAL WALL MIRROR DIAMANTERED SPOT GIFT BAG LARGESPACEBOY BABY GIFT SETTRELLIS COAT RACK10 COLOUR SPACEBOY PEN12 COLOURED PARTY BALLOONS...ZINC FOLKART SLEIGH BELLSZINC HEART FLOWER T-LIGHT HOLDERZINC HERB GARDEN CONTAINERZINC METAL HEART DECORATIONZINC SWEETHEART WIRE LETTER RACKZINC T-LIGHT HOLDER STAR LARGEZINC T-LIGHT HOLDER STARS SMALLZINC WILLIE WINKIE CANDLE STICKZINC WIRE KITCHEN ORGANISERZINC WIRE SWEETHEART LETTER TRAY
InvoiceNo
5365400.00.00.00.00.00.00.00.00.00.0...0.00.00.00.00.00.00.00.00.00.0
5365410.00.00.00.00.00.00.00.00.00.0...0.00.00.00.00.00.00.00.00.00.0
5368030.00.00.00.00.00.00.00.00.00.0...0.00.00.00.00.00.00.00.00.00.0
5368850.00.00.00.00.00.00.00.00.00.0...0.00.00.00.00.00.00.00.00.00.0
5368900.00.00.00.00.00.00.00.00.00.0...0.00.00.00.00.00.00.00.00.00.0
..................................................................
C5773880.00.00.00.00.00.00.00.00.00.0...0.00.00.00.00.00.00.00.00.00.0
C5778280.00.00.00.00.00.00.00.00.00.0...0.00.00.00.00.00.00.00.00.00.0
C5781360.00.00.00.00.00.00.00.00.00.0...0.00.00.00.00.00.00.00.00.00.0
C5799070.00.00.00.00.00.00.00.00.00.0...0.00.00.00.00.00.00.00.00.00.0
C5800560.00.00.00.00.00.00.00.00.00.0...0.00.00.00.00.00.00.00.00.00.0
\n", "

360 rows × 2027 columns

\n", "
" ], "text/plain": [ "Description 4 PURPLE FLOCK DINNER CANDLES 50'S CHRISTMAS GIFT BAG LARGE \\\n", "InvoiceNo \n", "536540 0.0 0.0 \n", "536541 0.0 0.0 \n", "536803 0.0 0.0 \n", "536885 0.0 0.0 \n", "536890 0.0 0.0 \n", "... ... ... \n", "C577388 0.0 0.0 \n", "C577828 0.0 0.0 \n", "C578136 0.0 0.0 \n", "C579907 0.0 0.0 \n", "C580056 0.0 0.0 \n", "\n", "Description DOLLY GIRL BEAKER NINE DRAWER OFFICE TIDY \\\n", "InvoiceNo \n", "536540 0.0 0.0 \n", "536541 0.0 0.0 \n", "536803 0.0 0.0 \n", "536885 0.0 0.0 \n", "536890 0.0 0.0 \n", "... ... ... \n", "C577388 0.0 0.0 \n", "C577828 0.0 0.0 \n", "C578136 0.0 0.0 \n", "C579907 0.0 0.0 \n", "C580056 0.0 0.0 \n", "\n", "Description OVAL WALL MIRROR DIAMANTE RED SPOT GIFT BAG LARGE \\\n", "InvoiceNo \n", "536540 0.0 0.0 \n", "536541 0.0 0.0 \n", "536803 0.0 0.0 \n", "536885 0.0 0.0 \n", "536890 0.0 0.0 \n", "... ... ... \n", "C577388 0.0 0.0 \n", "C577828 0.0 0.0 \n", "C578136 0.0 0.0 \n", "C579907 0.0 0.0 \n", "C580056 0.0 0.0 \n", "\n", "Description SPACEBOY BABY GIFT SET TRELLIS COAT RACK \\\n", "InvoiceNo \n", "536540 0.0 0.0 \n", "536541 0.0 0.0 \n", "536803 0.0 0.0 \n", "536885 0.0 0.0 \n", "536890 0.0 0.0 \n", "... ... ... \n", "C577388 0.0 0.0 \n", "C577828 0.0 0.0 \n", "C578136 0.0 0.0 \n", "C579907 0.0 0.0 \n", "C580056 0.0 0.0 \n", "\n", "Description 10 COLOUR SPACEBOY PEN 12 COLOURED PARTY BALLOONS ... \\\n", "InvoiceNo ... \n", "536540 0.0 0.0 ... \n", "536541 0.0 0.0 ... \n", "536803 0.0 0.0 ... \n", "536885 0.0 0.0 ... \n", "536890 0.0 0.0 ... \n", "... ... ... ... \n", "C577388 0.0 0.0 ... \n", "C577828 0.0 0.0 ... \n", "C578136 0.0 0.0 ... \n", "C579907 0.0 0.0 ... \n", "C580056 0.0 0.0 ... \n", "\n", "Description ZINC FOLKART SLEIGH BELLS ZINC HEART FLOWER T-LIGHT HOLDER \\\n", "InvoiceNo \n", "536540 0.0 0.0 \n", "536541 0.0 0.0 \n", "536803 0.0 0.0 \n", "536885 0.0 0.0 \n", "536890 0.0 0.0 \n", "... ... ... \n", "C577388 0.0 0.0 \n", "C577828 0.0 0.0 \n", "C578136 0.0 0.0 \n", "C579907 0.0 0.0 \n", "C580056 0.0 0.0 \n", "\n", "Description ZINC HERB GARDEN CONTAINER ZINC METAL HEART DECORATION \\\n", "InvoiceNo \n", "536540 0.0 0.0 \n", "536541 0.0 0.0 \n", "536803 0.0 0.0 \n", "536885 0.0 0.0 \n", "536890 0.0 0.0 \n", "... ... ... \n", "C577388 0.0 0.0 \n", "C577828 0.0 0.0 \n", "C578136 0.0 0.0 \n", "C579907 0.0 0.0 \n", "C580056 0.0 0.0 \n", "\n", "Description ZINC SWEETHEART WIRE LETTER RACK ZINC T-LIGHT HOLDER STAR LARGE \\\n", "InvoiceNo \n", "536540 0.0 0.0 \n", "536541 0.0 0.0 \n", "536803 0.0 0.0 \n", "536885 0.0 0.0 \n", "536890 0.0 0.0 \n", "... ... ... \n", "C577388 0.0 0.0 \n", "C577828 0.0 0.0 \n", "C578136 0.0 0.0 \n", "C579907 0.0 0.0 \n", "C580056 0.0 0.0 \n", "\n", "Description ZINC T-LIGHT HOLDER STARS SMALL \\\n", "InvoiceNo \n", "536540 0.0 \n", "536541 0.0 \n", "536803 0.0 \n", "536885 0.0 \n", "536890 0.0 \n", "... ... \n", "C577388 0.0 \n", "C577828 0.0 \n", "C578136 0.0 \n", "C579907 0.0 \n", "C580056 0.0 \n", "\n", "Description ZINC WILLIE WINKIE CANDLE STICK ZINC WIRE KITCHEN ORGANISER \\\n", "InvoiceNo \n", "536540 0.0 0.0 \n", "536541 0.0 0.0 \n", "536803 0.0 0.0 \n", "536885 0.0 0.0 \n", "536890 0.0 0.0 \n", "... ... ... \n", "C577388 0.0 0.0 \n", "C577828 0.0 0.0 \n", "C578136 0.0 0.0 \n", "C579907 0.0 0.0 \n", "C580056 0.0 0.0 \n", "\n", "Description ZINC WIRE SWEETHEART LETTER TRAY \n", "InvoiceNo \n", "536540 0.0 \n", "536541 0.0 \n", "536803 0.0 \n", "536885 0.0 \n", "536890 0.0 \n", "... ... \n", "C577388 0.0 \n", "C577828 0.0 \n", "C578136 0.0 \n", "C579907 0.0 \n", "C580056 0.0 \n", "\n", "[360 rows x 2027 columns]" ] }, "execution_count": 6, "metadata": {}, "output_type": "execute_result" } ], "source": [ "basket = (df[df['Country'] ==\"EIRE\"]\n", " .groupby(['InvoiceNo', 'Description'])['Quantity']\n", " .sum().unstack().reset_index().fillna(0)\n", " .set_index('InvoiceNo'))\n", "basket" ] }, { "cell_type": "code", "execution_count": 7, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "Index([' 4 PURPLE FLOCK DINNER CANDLES', ' 50'S CHRISTMAS GIFT BAG LARGE',\n", " ' DOLLY GIRL BEAKER', ' NINE DRAWER OFFICE TIDY',\n", " ' OVAL WALL MIRROR DIAMANTE ', ' RED SPOT GIFT BAG LARGE',\n", " ' SPACEBOY BABY GIFT SET', ' TRELLIS COAT RACK',\n", " '10 COLOUR SPACEBOY PEN', '12 COLOURED PARTY BALLOONS',\n", " ...\n", " 'ZINC FOLKART SLEIGH BELLS', 'ZINC HEART FLOWER T-LIGHT HOLDER',\n", " 'ZINC HERB GARDEN CONTAINER', 'ZINC METAL HEART DECORATION',\n", " 'ZINC SWEETHEART WIRE LETTER RACK', 'ZINC T-LIGHT HOLDER STAR LARGE',\n", " 'ZINC T-LIGHT HOLDER STARS SMALL', 'ZINC WILLIE WINKIE CANDLE STICK',\n", " 'ZINC WIRE KITCHEN ORGANISER', 'ZINC WIRE SWEETHEART LETTER TRAY'],\n", " dtype='object', name='Description', length=2027)" ] }, "execution_count": 7, "metadata": {}, "output_type": "execute_result" } ], "source": [ "basket.columns\n" ] }, { "cell_type": "code", "execution_count": 8, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "[' 4 PURPLE FLOCK DINNER CANDLES',\n", " \" 50'S CHRISTMAS GIFT BAG LARGE\",\n", " ' DOLLY GIRL BEAKER',\n", " ' NINE DRAWER OFFICE TIDY',\n", " ' OVAL WALL MIRROR DIAMANTE ',\n", " ' RED SPOT GIFT BAG LARGE',\n", " ' SPACEBOY BABY GIFT SET',\n", " ' TRELLIS COAT RACK',\n", " '10 COLOUR SPACEBOY PEN',\n", " '12 COLOURED PARTY BALLOONS',\n", " '12 DAISY PEGS IN WOOD BOX',\n", " '12 EGG HOUSE PAINTED WOOD',\n", " '12 IVORY ROSE PEG PLACE SETTINGS',\n", " '12 MESSAGE CARDS WITH ENVELOPES',\n", " '12 PENCIL SMALL TUBE WOODLAND',\n", " '12 PENCILS SMALL TUBE RED RETROSPOT',\n", " '12 PENCILS TALL TUBE POSY',\n", " '12 PENCILS TALL TUBE RED RETROSPOT',\n", " '12 PENCILS TALL TUBE SKULLS',\n", " '12 PENCILS TALL TUBE WOODLAND',\n", " '12 PINK HEN+CHICKS IN BASKET',\n", " '12 PINK ROSE PEG PLACE SETTINGS',\n", " '12 RED ROSE PEG PLACE SETTINGS',\n", " '15CM CHRISTMAS GLASS BALL 20 LIGHTS',\n", " '16 PIECE CUTLERY SET PANTRY DESIGN',\n", " '18PC WOODEN CUTLERY SET DISPOSABLE',\n", " '2 DAISIES HAIR COMB',\n", " '2 PICTURE BOOK EGGS EASTER BUNNY',\n", " '2 PICTURE BOOK EGGS EASTER DUCKS',\n", " '20 DOLLY PEGS RETROSPOT',\n", " '200 RED + WHITE BENDY STRAWS',\n", " '3 DRAWER ANTIQUE WHITE WOOD CABINET',\n", " '3 HEARTS HANGING DECORATION RUSTIC',\n", " '3 HOOK HANGER MAGIC GARDEN',\n", " '3 HOOK PHOTO SHELF ANTIQUE WHITE',\n", " '3 PIECE SPACEBOY COOKIE CUTTER SET',\n", " \"3 RAFFIA RIBBONS 50'S CHRISTMAS \",\n", " '3 RAFFIA RIBBONS VINTAGE CHRISTMAS',\n", " '3 ROSE MORRIS BOXED CANDLES',\n", " '3 STRIPEY MICE FELTCRAFT',\n", " '3 TIER CAKE TIN GREEN AND CREAM',\n", " '3 TIER CAKE TIN RED AND CREAM',\n", " '3 TIER SWEETHEART GARDEN SHELF',\n", " '3 TRADITIONAL COOKIE CUTTERS SET',\n", " '3 TRADITIONAl BISCUIT CUTTERS SET',\n", " '3 WHITE CHOC MORRIS BOXED CANDLES',\n", " '3 WICK CHRISTMAS BRIAR CANDLE ',\n", " '36 DOILIES VINTAGE CHRISTMAS',\n", " '36 FOIL HEART CAKE CASES',\n", " '36 FOIL STAR CAKE CASES ',\n", " '36 PENCILS TUBE RED RETROSPOT',\n", " '36 PENCILS TUBE SKULLS',\n", " '36 PENCILS TUBE WOODLAND',\n", " '3D CHRISTMAS STAMPS STICKERS ',\n", " '3D DOG PICTURE PLAYING CARDS',\n", " '3D SHEET OF CAT STICKERS',\n", " '3D SHEET OF DOG STICKERS',\n", " '3D TRADITIONAL CHRISTMAS STICKERS',\n", " '3D VINTAGE CHRISTMAS STICKERS ',\n", " '4 IVORY DINNER CANDLES SILVER FLOCK',\n", " '4 LAVENDER BOTANICAL DINNER CANDLES',\n", " '4 LILY BOTANICAL DINNER CANDLES',\n", " '4 PEAR BOTANICAL DINNER CANDLES',\n", " '4 PINK DINNER CANDLE SILVER FLOCK',\n", " '4 TRADITIONAL SPINNING TOPS',\n", " '4 VANILLA BOTANICAL CANDLES',\n", " '4 WILDFLOWER BOTANICAL CANDLES',\n", " '6 EGG HOUSE PAINTED WOOD',\n", " \"6 GIFT TAGS 50'S CHRISTMAS \",\n", " '6 GIFT TAGS VINTAGE CHRISTMAS ',\n", " '6 RIBBONS ELEGANT CHRISTMAS ',\n", " '6 RIBBONS RUSTIC CHARM',\n", " '6 RIBBONS SHIMMERING PINKS ',\n", " '6 ROCKET BALLOONS ',\n", " '60 CAKE CASES DOLLY GIRL DESIGN',\n", " '60 CAKE CASES VINTAGE CHRISTMAS',\n", " '60 TEATIME FAIRY CAKE CASES',\n", " '6PC WOOD PLATE SET DISPOSABLE',\n", " '72 SWEETHEART FAIRY CAKE CASES',\n", " '75 GREEN PETIT FOUR CASES',\n", " 'A PRETTY THANK YOU CARD',\n", " 'A4 WALL TIDY BLUE OFFICE',\n", " 'ABC TREASURE BOOK BOX ',\n", " 'ABSTRACT CIRCLES SKETCHBOOK ',\n", " 'ACRYLIC HANGING JEWEL,BLUE',\n", " 'ACRYLIC JEWEL ICICLE, PINK',\n", " 'ACRYLIC JEWEL SNOWFLAKE, PINK',\n", " 'ADULT APRON APPLE DELIGHT',\n", " 'ADVENT CALENDAR GINGHAM SACK',\n", " 'AGED GLASS SILVER T-LIGHT HOLDER',\n", " 'AIRLINE BAG VINTAGE JET SET BROWN',\n", " 'AIRLINE BAG VINTAGE JET SET RED',\n", " 'AIRLINE BAG VINTAGE JET SET WHITE',\n", " 'AIRLINE BAG VINTAGE TOKYO 78',\n", " 'AIRLINE BAG VINTAGE WORLD CHAMPION ',\n", " 'ALARM CLOCK BAKELIKE CHOCOLATE',\n", " 'ALARM CLOCK BAKELIKE GREEN',\n", " 'ALARM CLOCK BAKELIKE IVORY',\n", " 'ALARM CLOCK BAKELIKE ORANGE',\n", " 'ALARM CLOCK BAKELIKE PINK',\n", " 'ALARM CLOCK BAKELIKE RED ',\n", " 'ALUMINIUM STAMPED HEART',\n", " 'AMBER DIAMANTE EXPANDABLE RING',\n", " 'AMBER DROP EARRINGS W LONG BEADS',\n", " 'AMETHYST DIAMANTE EXPANDABLE RING',\n", " 'ANGEL DECORATION STARS ON DRESS',\n", " 'ANIMAL STICKERS',\n", " 'ANTIQUE CREAM CUTLERY CUPBOARD',\n", " 'ANTIQUE GLASS DRESSING TABLE POT',\n", " 'ANTIQUE GLASS PEDESTAL BOWL',\n", " 'ANTIQUE HEART SHELF UNIT',\n", " 'ANTIQUE IVORY WIRE BOWL SMALL',\n", " 'ANTIQUE SILVER BAUBLE LAMP ',\n", " 'ANTIQUE SILVER T-LIGHT GLASS',\n", " 'ANTIQUE SILVER TEA GLASS ENGRAVED',\n", " 'ANTIQUE SILVER TEA GLASS ETCHED',\n", " 'ANTIQUE TALL SWIRLGLASS TRINKET POT',\n", " 'APPLE BATH SPONGE',\n", " 'APRON APPLE DELIGHT',\n", " 'APRON MODERN VINTAGE COTTON',\n", " 'AREA PATROLLED METAL SIGN',\n", " 'ART LIGHTS,FUNK MONKEY',\n", " 'ASS COLOUR GLOWING TIARAS',\n", " 'ASS DES PHONE SPONGE CRAFT STICKER',\n", " 'ASS FLORAL PRINT MULTI SCREWDRIVER',\n", " 'ASSORTED BOTTLE TOP MAGNETS ',\n", " 'ASSORTED COLOUR BIRD ORNAMENT',\n", " 'ASSORTED COLOUR MINI CASES',\n", " 'ASSORTED COLOUR T-LIGHT HOLDER',\n", " 'ASSORTED COLOURS SILK FAN',\n", " 'ASSORTED CREEPY CRAWLIES',\n", " 'ASSORTED EASTER DECORATIONS BELLS',\n", " 'ASSORTED EASTER GIFT TAGS',\n", " 'ASSORTED FLOWER COLOUR \"LEIS\"',\n", " 'ASSORTED INCENSE PACK',\n", " 'ASSORTED MINI MADRAS NOTEBOOK',\n", " 'ASSORTED TUTTI FRUTTI BRACELET',\n", " 'ASSORTED TUTTI FRUTTI MIRROR',\n", " 'ASSORTED TUTTI FRUTTI PEN',\n", " 'ASSORTED TUTTI FRUTTI SMALL PURSE',\n", " 'ASSTD DESIGN RACING CAR PEN',\n", " 'ASSTD FRUIT+FLOWERS FRIDGE MAGNETS',\n", " 'BABY BOOM RIBBONS ',\n", " 'BAG 125g SWIRLY MARBLES',\n", " 'BAG 250g SWIRLY MARBLES',\n", " 'BAG 500g SWIRLY MARBLES',\n", " 'BAKING MOULD CHOCOLATE CUPCAKES',\n", " 'BAKING MOULD EASTER EGG MILK CHOC',\n", " 'BAKING MOULD EASTER EGG WHITE CHOC',\n", " 'BAKING MOULD HEART MILK CHOCOLATE',\n", " 'BAKING MOULD HEART WHITE CHOCOLATE',\n", " 'BAKING MOULD ROSE MILK CHOCOLATE',\n", " 'BAKING MOULD ROSE WHITE CHOCOLATE',\n", " 'BAKING MOULD TOFFEE CUP CHOCOLATE',\n", " 'BAKING SET 9 PIECE RETROSPOT ',\n", " 'BAKING SET SPACEBOY DESIGN',\n", " 'BALLOON ART MAKE YOUR OWN FLOWERS',\n", " 'BALLOON PUMP WITH 10 BALLOONS',\n", " 'BALLOON WATER BOMB PACK OF 35',\n", " 'BALLOONS WRITING SET ',\n", " 'BANK ACCOUNT GREETING CARD ',\n", " 'BANQUET BIRTHDAY CARD ',\n", " 'BASKET OF FLOWERS SEWING KIT',\n", " 'BASKET OF TOADSTOOLS',\n", " 'BATH BUILDING BLOCK WORD',\n", " 'BATHROOM HOOK',\n", " 'BATHROOM METAL SIGN',\n", " 'BATHROOM METAL SIGN ',\n", " 'BATHROOM SCALES RUBBER DUCKS',\n", " 'BATHROOM SET LOVE HEART DESIGN',\n", " 'BEACH HUT DESIGN BLACKBOARD',\n", " 'BEADED CRYSTAL HEART BLUE LARGE',\n", " 'BEADED CRYSTAL HEART GREEN LARGE',\n", " 'BELLE JARDINIERE CUSHION COVER',\n", " 'BEWARE OF THE CAT METAL SIGN ',\n", " 'BICYCLE PUNCTURE REPAIR KIT ',\n", " 'BILI NUT AND WOOD NECKLACE',\n", " 'BINGO SET',\n", " 'BIRD DECORATION RED RETROSPOT',\n", " 'BIRD HOUSE HOT WATER BOTTLE',\n", " 'BIRDCAGE DECORATION TEALIGHT HOLDER',\n", " 'BIRDHOUSE GARDEN MARKER ',\n", " 'BIRDS MOBILE VINTAGE DESIGN',\n", " 'BIRTHDAY BANQUET GIFT WRAP',\n", " \"BISCUIT TIN 50'S CHRISTMAS\",\n", " 'BISCUIT TIN VINTAGE CHRISTMAS',\n", " 'BISCUIT TIN VINTAGE GREEN',\n", " 'BISCUIT TIN VINTAGE RED',\n", " 'BISCUITS SMALL BOWL LIGHT BLUE',\n", " 'BLACK 3 BEAD DROP EARRINGS',\n", " 'BLACK CANDELABRA T-LIGHT HOLDER',\n", " 'BLACK CHRISTMAS TREE 60CM',\n", " 'BLACK DIAMANTE EXPANDABLE RING',\n", " 'BLACK DINER WALL CLOCK',\n", " 'BLACK ENAMEL FLOWER RING',\n", " 'BLACK KITCHEN SCALES',\n", " 'BLACK RECORD COVER FRAME',\n", " 'BLACK SILOUETTE CANDLE PLATE',\n", " 'BLACK SQUARE TABLE CLOCK',\n", " 'BLACK TEA TOWEL CLASSIC DESIGN',\n", " 'BLACK/BLUE POLKADOT UMBRELLA',\n", " 'BLOND DOLL DOORSTOP',\n", " 'BLOSSOM IMAGES NOTEBOOK SET',\n", " 'BLOSSOM IMAGES GIFT WRAP SET',\n", " 'BLUE TILE HOOK',\n", " 'BLUE BIRDHOUSE DECORATION',\n", " 'BLUE BLOSSOM HAIR CLIP',\n", " 'BLUE CHARLIE+LOLA PERSONAL DOORSIGN',\n", " 'BLUE CIRCLES DESIGN TEDDY',\n", " 'BLUE COAT RACK PARIS FASHION',\n", " 'BLUE DAISY MOBILE',\n", " 'BLUE DINER WALL CLOCK',\n", " 'BLUE DRAGONFLY HELICOPTER',\n", " 'BLUE DRAWER KNOB ACRYLIC EDWARDIAN',\n", " 'BLUE EGG SPOON',\n", " 'BLUE GIANT GARDEN THERMOMETER',\n", " 'BLUE HAPPY BIRTHDAY BUNTING',\n", " 'BLUE HARMONICA IN BOX ',\n", " 'BLUE KNITTED EGG COSY',\n", " 'BLUE NEW BAROQUE CANDLESTICK CANDLE',\n", " 'BLUE OWL SOFT TOY',\n", " 'BLUE PAISLEY JOURNAL ',\n", " 'BLUE PAISLEY POCKET BOOK',\n", " 'BLUE PAISLEY SKETCHBOOK',\n", " 'BLUE PAISLEY TISSUE BOX',\n", " 'BLUE PARTY BAGS ',\n", " 'BLUE POLKADOT BOWL',\n", " 'BLUE POLKADOT COFFEE MUG',\n", " 'BLUE POLKADOT EGG CUP ',\n", " 'BLUE POLKADOT LUGGAGE TAG ',\n", " 'BLUE POLKADOT WASHING UP GLOVES',\n", " 'BLUE POLKADOT WRAP',\n", " 'BLUE PUDDING SPOON',\n", " 'BLUE REFECTORY CLOCK ',\n", " 'BLUE RETRO KITCHEN WALL CLOCK',\n", " 'BLUE ROSE FABRIC MIRROR',\n", " 'BLUE SCANDINAVIAN PAISLEY WRAP',\n", " 'BLUE SCOTTIE DOG W FLOWER PATTERN',\n", " 'BLUE SPOT CERAMIC DRAWER KNOB',\n", " 'BLUE STONES ON WIRE FOR CANDLE',\n", " 'BLUE STRIPE CERAMIC DRAWER KNOB',\n", " 'BLUE TEA TOWEL CLASSIC DESIGN',\n", " 'BLUE VICTORIAN FABRIC OVAL BOX',\n", " 'BLUE VINTAGE SPOT BEAKER',\n", " 'BOOM BOX SPEAKER BOYS',\n", " 'BOTANICAL GARDENS WALL CLOCK ',\n", " 'BOTANICAL LAVENDER GIFT WRAP ',\n", " 'BOTANICAL LILY GREETING CARD',\n", " 'BOTTLE BAG RETROSPOT ',\n", " 'BOUDOIR SQUARE TISSUE BOX',\n", " 'BOX OF 24 COCKTAIL PARASOLS',\n", " 'BOX OF 6 ASSORTED COLOUR TEASPOONS',\n", " 'BOX OF 6 CHRISTMAS CAKE DECORATIONS',\n", " \"BOX OF 6 MINI 50'S CRACKERS\",\n", " 'BOX OF 6 MINI VINTAGE CRACKERS',\n", " 'BOX OF VINTAGE ALPHABET BLOCKS',\n", " 'BOX OF VINTAGE JIGSAW BLOCKS ',\n", " 'BREAD BIN DINER STYLE IVORY',\n", " 'BREAD BIN DINER STYLE MINT',\n", " 'BREAD BIN DINER STYLE PINK',\n", " 'BREAD BIN DINER STYLE RED ',\n", " 'BRIGHT BLUES RIBBONS ',\n", " 'BROCANTE COAT RACK',\n", " 'BROCANTE SHELF WITH HOOKS',\n", " 'BROWN CHECK CAT DOORSTOP ',\n", " 'BROWN KUKUI COCONUT SEED NECKLACE',\n", " 'BUBBLEGUM RING ASSORTED',\n", " 'BUFFALO BILL TREASURE BOOK BOX',\n", " 'BULL DOG BOTTLE OPENER',\n", " 'BUNDLE OF 3 ALPHABET EXERCISE BOOKS',\n", " 'BUNDLE OF 3 RETRO NOTE BOOKS',\n", " 'BUNNY EGG BOX',\n", " 'BUNNY EGG GARLAND',\n", " 'BUNNY WOODEN PAINTED WITH BIRD ',\n", " 'BUNNY WOODEN PAINTED WITH FLOWER ',\n", " 'BUTTERFLIES STICKERS',\n", " 'BUTTERFLY CROCHET FOOD COVER',\n", " 'BUTTERFLY HAIR BAND',\n", " 'BUTTON BOX ',\n", " 'CABIN BAG VINTAGE PAISLEY',\n", " 'CAKE PLATE LOVEBIRD PINK',\n", " 'CAKE STAND 3 TIER MAGIC GARDEN',\n", " 'CAKE STAND LOVEBIRD 2 TIER PINK',\n", " 'CAKE STAND LOVEBIRD 2 TIER WHITE',\n", " 'CAKE STAND VICTORIAN FILIGREE MED',\n", " 'CAKE STAND VICTORIAN FILIGREE SMALL',\n", " 'CAKE STAND WHITE TWO TIER LACE',\n", " 'CALENDAR IN SEASON DESIGN',\n", " 'CALENDAR PAPER CUT DESIGN',\n", " 'CAMOUFLAGE LED TORCH',\n", " 'CANDLE PLATE LACE WHITE',\n", " 'CANDLEHOLDER PINK HANGING HEART',\n", " 'CANDY HEART HANGING DECORATION',\n", " 'CANDY SPOT EGG WARMER HARE',\n", " 'CANDY SPOT EGG WARMER RABBIT',\n", " 'CARAVAN SQUARE TISSUE BOX',\n", " 'CARD BILLBOARD FONT',\n", " 'CARD BIRTHDAY COWBOY',\n", " 'CARD CAT AND TREE ',\n", " 'CARD CHRISTMAS VILLAGE',\n", " 'CARD CIRCUS PARADE',\n", " 'CARD DOLLY GIRL ',\n", " 'CARD GINGHAM ROSE ',\n", " 'CARD HOLDER GINGHAM HEART',\n", " 'CARD HOLDER LOVE BIRD LARGE ',\n", " 'CARD HOLDER LOVE BIRD SMALL',\n", " 'CARD MOTORBIKE SANTA',\n", " 'CARD PSYCHEDELIC APPLES',\n", " 'CARD WEDDING DAY',\n", " 'CARDHOLDER GINGHAM CHRISTMAS TREE',\n", " 'CARDHOLDER GINGHAM STAR',\n", " 'CARDHOLDER HOLLY WREATH METAL',\n", " 'CARRIAGE',\n", " 'CARROT CHARLIE+LOLA COASTER SET',\n", " 'CARTOON PENCIL SHARPENERS',\n", " 'CAT BOWL VINTAGE CREAM',\n", " 'CERAMIC BOWL WITH STRAWBERRY DESIGN',\n", " 'CERAMIC CAKE DESIGN SPOTTED PLATE',\n", " 'CERAMIC CAKE STAND + HANGING CAKES',\n", " 'CERAMIC CHERRY CAKE MONEY BANK',\n", " 'CERAMIC LOVE HEART MONEY BANK',\n", " 'CERAMIC PIRATE CHEST MONEY BANK',\n", " 'CERAMIC PLATE STRAWBERRY DESIGN',\n", " 'CERAMIC STRAWBERRY DESIGN MUG',\n", " 'CERAMIC STRAWBERRY MONEY BOX',\n", " 'CHALKBOARD KITCHEN ORGANISER',\n", " 'CHARLIE & LOLA WASTEPAPER BIN BLUE',\n", " 'CHARLIE & LOLA WASTEPAPER BIN FLORA',\n", " 'CHARLIE + LOLA RED HOT WATER BOTTLE',\n", " 'CHARLIE AND LOLA FIGURES TINS',\n", " 'CHARLIE AND LOLA TABLE TINS',\n", " 'CHARLIE+LOLA PINK HOT WATER BOTTLE',\n", " 'CHARLIE+LOLA RED HOT WATER BOTTLE ',\n", " 'CHARLIE+LOLA\"EXTREMELY BUSY\" SIGN',\n", " 'CHARLOTTE BAG APPLES DESIGN',\n", " 'CHARLOTTE BAG DOLLY GIRL DESIGN',\n", " 'CHARLOTTE BAG PINK POLKADOT',\n", " 'CHARLOTTE BAG SUKI DESIGN',\n", " 'CHARLOTTE BAG VINTAGE ALPHABET ',\n", " 'CHERRY BLOSSOM DECORATIVE FLASK',\n", " 'CHERRY BLOSSOM DECORATIVE FLASK',\n", " 'CHERRY CROCHET FOOD COVER',\n", " 'CHERUB HEART DECORATION GOLD',\n", " 'CHERUB HEART DECORATION SILVER ',\n", " 'CHEST OF DRAWERS GINGHAM HEART ',\n", " 'CHICK GREY HOT WATER BOTTLE',\n", " \"CHILDREN'S APRON DOLLY GIRL \",\n", " \"CHILDREN'S SPACEBOY MUG\",\n", " 'CHILDRENS APRON APPLES DESIGN',\n", " 'CHILDRENS APRON SPACEBOY DESIGN',\n", " 'CHILDRENS CUTLERY DOLLY GIRL ',\n", " 'CHILDRENS CUTLERY POLKADOT BLUE',\n", " 'CHILDRENS CUTLERY POLKADOT GREEN ',\n", " 'CHILDRENS CUTLERY POLKADOT PINK',\n", " 'CHILDRENS CUTLERY RETROSPOT RED ',\n", " 'CHILDRENS CUTLERY SPACEBOY ',\n", " 'CHILDRENS DOLLY GIRL MUG',\n", " 'CHILDRENS GARDEN GLOVES BLUE',\n", " 'CHILDRENS TOY COOKING UTENSIL SET',\n", " 'CHILDS BREAKFAST SET CIRCUS PARADE',\n", " 'CHILDS BREAKFAST SET DOLLY GIRL ',\n", " 'CHILDS BREAKFAST SET SPACEBOY ',\n", " 'CHILDS GARDEN FORK BLUE ',\n", " 'CHILDS GARDEN FORK PINK',\n", " 'CHILDS GARDEN RAKE BLUE',\n", " 'CHILDS GARDEN RAKE PINK',\n", " 'CHILDS GARDEN SPADE BLUE',\n", " 'CHILDS GARDEN SPADE PINK',\n", " 'CHILDS GARDEN TROWEL BLUE ',\n", " 'CHILDS GARDEN TROWEL PINK',\n", " 'CHILLI LIGHTS',\n", " 'CHOCOLATE BOX RIBBONS ',\n", " 'CHOCOLATE CALCULATOR',\n", " 'CHOCOLATE HOT WATER BOTTLE',\n", " 'CHOCOLATE THIS WAY METAL SIGN',\n", " 'CHRISTMAS CARD SCREEN PRINT ',\n", " 'CHRISTMAS CARD STACK OF PRESENTS',\n", " 'CHRISTMAS CRAFT LITTLE FRIENDS',\n", " 'CHRISTMAS CRAFT TREE TOP ANGEL',\n", " 'CHRISTMAS CRAFT WHITE FAIRY ',\n", " 'CHRISTMAS DECOUPAGE CANDLE',\n", " 'CHRISTMAS GINGHAM HEART',\n", " 'CHRISTMAS GINGHAM STAR',\n", " 'CHRISTMAS GINGHAM TREE',\n", " 'CHRISTMAS HANGING SNOWFLAKE',\n", " 'CHRISTMAS HANGING STAR WITH BELL',\n", " 'CHRISTMAS HANGING TREE WITH BELL',\n", " 'CHRISTMAS LIGHTS 10 REINDEER',\n", " 'CHRISTMAS LIGHTS 10 SANTAS ',\n", " 'CHRISTMAS LIGHTS 10 VINTAGE BAUBLES',\n", " 'CHRISTMAS METAL POSTCARD WITH BELLS',\n", " 'CHRISTMAS METAL TAGS ASSORTED ',\n", " 'CHRISTMAS PUDDING TRINKET POT ',\n", " 'CHRISTMAS RETROSPOT ANGEL WOOD',\n", " 'CHRISTMAS RETROSPOT TREE WOOD',\n", " 'CHRISTMAS STAR WISH LIST CHALKBOARD',\n", " 'CHRISTMAS TABLE SILVER CANDLE SPIKE',\n", " 'CHRISTMAS TOILET ROLL',\n", " 'CHRISTMAS TREE HANGING GOLD',\n", " 'CHRISTMAS TREE PAINTED ZINC ',\n", " 'CHRYSANTHEMUM JOURNAL',\n", " 'CHRYSANTHEMUM SKETCHBOOK ',\n", " 'CINAMMON & ORANGE WREATH',\n", " 'CINAMMON SET OF 9 T-LIGHTS',\n", " 'CINDERELLA CHANDELIER ',\n", " 'CINNAMON SCENTED VOTIVE CANDLE',\n", " 'CIRCUS PARADE BABY GIFT SET',\n", " 'CIRCUS PARADE CHILDRENS EGG CUP ',\n", " 'CIRCUS PARADE LUNCH BOX ',\n", " 'CITRONELLA CANDLE FLOWERPOT',\n", " 'CITRONELLA CANDLE GARDEN POT',\n", " 'CLASSIC BICYCLE CLIPS ',\n", " 'CLASSIC CAFE SUGAR DISPENSER',\n", " 'CLASSIC CHROME BICYCLE BELL ',\n", " 'CLASSIC CROME BICYCLE BELL ',\n", " 'CLASSIC DIAMANTE EARRINGS JET',\n", " 'CLASSIC FRENCH STYLE BASKET GREEN ',\n", " 'CLASSIC FRENCH STYLE BASKET NATURAL',\n", " 'CLASSIC GLASS COOKIE JAR',\n", " 'CLASSIC METAL BIRDCAGE PLANT HOLDER',\n", " 'CLASSICAL ROSE CANDLESTAND',\n", " 'CLASSICAL ROSE SMALL VASE',\n", " 'CLEAR DRAWER KNOB ACRYLIC EDWARDIAN',\n", " 'CLEAR LOVE BIRD T-LIGHT HOLDER',\n", " \"CLOCK MAGNET MUM'S KITCHEN\",\n", " 'CLOTHES PEGS RETROSPOT PACK 24 ',\n", " 'COCKTAIL SWORDS 50 PIECES',\n", " 'COFFEE MUG APPLES DESIGN',\n", " 'COFFEE MUG BLUE PAISLEY DESIGN',\n", " 'COFFEE MUG CAT + BIRD DESIGN',\n", " 'COFFEE MUG DOG + BALL DESIGN',\n", " 'COFFEE MUG PEARS DESIGN',\n", " 'COFFEE MUG PINK PAISLEY DESIGN',\n", " 'COFFEE SCENT PILLAR CANDLE',\n", " 'COLOUR GLASS T-LIGHT HOLDER HANGING',\n", " 'COLOUR GLASS. STAR T-LIGHT HOLDER',\n", " 'COLOURED GLASS STAR T-LIGHT HOLDER',\n", " 'COLOURING PENCILS BROWN TUBE',\n", " 'COLUMBIAN CANDLE ROUND',\n", " 'COOK WITH WINE METAL SIGN ',\n", " 'CORDIAL GLASS JUG',\n", " 'COSY SLIPPER SHOES SMALL RED ',\n", " 'COSY SLIPPER SHOES SMALL GREEN',\n", " 'COTTON APRON PANTRY DESIGN',\n", " 'COWBOYS AND INDIANS BIRTHDAY CARD ',\n", " 'CREAM CUPID HEARTS COAT HANGER',\n", " 'CREAM FELT EASTER EGG BASKET',\n", " 'CREAM HEART CARD HOLDER',\n", " 'CREAM SWEETHEART EGG HOLDER',\n", " 'CREAM SWEETHEART MINI CHEST',\n", " 'CREAM WALL PLANTER HEART SHAPED',\n", " 'CRYSTAL PAIR HEART HAIR SLIDES',\n", " 'CUBIC MUG FLOCK PINK ON BROWN',\n", " 'CUPBOARD 3 DRAWER MA CAMPAGNE',\n", " 'CUPCAKE LACE PAPER SET 6',\n", " 'CUPID DESIGN SCENTED CANDLES',\n", " 'DAIRY MAID LARGE MILK JUG',\n", " 'DAIRY MAID STRIPE MUG',\n", " 'DAIRY MAID TOASTRACK',\n", " 'DAIRY MAID TRADITIONAL TEAPOT ',\n", " 'DAISY GARDEN MARKER',\n", " 'DAISY HAIR BAND',\n", " 'DAISY HAIR COMB',\n", " 'DAISY JOURNAL ',\n", " 'DAISY SKETCHBOOK ',\n", " 'DANISH ROSE DECORATIVE PLATE',\n", " 'DANISH ROSE DELUXE COASTER',\n", " 'DANISH ROSE PHOTO FRAME',\n", " 'DANISH ROSE ROUND SEWING BOX',\n", " 'DANISH ROSE TRINKET TRAYS',\n", " 'DARK BIRD HOUSE TREE DECORATION',\n", " 'DECORATION , WOBBLY CHICKEN, METAL ',\n", " 'DECORATION SITTING BUNNY',\n", " 'DECORATION WHITE CHICK MAGIC GARDEN',\n", " 'DECORATION WOBBLY CHICKEN',\n", " 'DECORATION WOBBLY RABBIT METAL ',\n", " 'DECORATIVE VINTAGE COFFEE BOX',\n", " 'DECORATIVE WICKER HEART LARGE',\n", " 'DECORATIVE WICKER HEART MEDIUM',\n", " 'DECOUPAGE,GREETING CARD,',\n", " 'DECROTIVEVINTAGE COFFEE GRINDER BOX',\n", " 'DELUXE SEWING KIT ',\n", " 'DENIM PATCH PURSE PINK BUTTERFLY',\n", " 'DIAMANTE HAIR GRIP PACK/2 BLACK DIA',\n", " 'DIAMANTE HAIR GRIP PACK/2 CRYSTAL',\n", " 'DIAMANTE HAIR GRIP PACK/2 LT ROSE',\n", " 'DIAMANTE HAIR GRIP PACK/2 MONTANA',\n", " 'DIAMANTE HAIR GRIP PACK/2 PERIDOT',\n", " 'DIAMANTE HAIR GRIP PACK/2 RUBY',\n", " 'DIAMANTE RING ASSORTED IN BOX.',\n", " 'DINOSAUR HEIGHT CHART STICKER SET',\n", " 'DINOSAUR KEYRINGS ASSORTED',\n", " 'DINOSAUR LUNCH BOX WITH CUTLERY',\n", " 'DINOSAUR PARTY BAG + STICKER SET',\n", " 'DISCO BALL CHRISTMAS DECORATION',\n", " 'DO NOT TOUCH MY STUFF DOOR HANGER ',\n", " \"DOCTOR'S BAG SOFT TOY\",\n", " 'DOG BOWL CHASING BALL DESIGN',\n", " 'DOG BOWL VINTAGE CREAM',\n", " 'DOG TOY WITH PINK CROCHET SKIRT',\n", " 'DOILEY BISCUIT TIN',\n", " 'DOILEY STORAGE TIN',\n", " 'DOILY THANK YOU CARD',\n", " 'DOLLY CABINET 3 DRAWERS ',\n", " 'DOLLY GIRL BABY GIFT SET',\n", " 'DOLLY GIRL CHILDRENS BOWL',\n", " 'DOLLY GIRL CHILDRENS CUP',\n", " 'DOLLY GIRL CHILDRENS EGG CUP',\n", " 'DOLLY GIRL LUNCH BOX',\n", " 'DOLLY GIRL MINI BACKPACK',\n", " 'DOLLY GIRL MINI RUCKSACK',\n", " \"DOLLY MIXTURE CHILDREN'S UMBRELLA\",\n", " 'DOORKNOB CERAMIC IVORY',\n", " 'DOORKNOB CRACKED GLAZE BLUE',\n", " 'DOORKNOB CRACKED GLAZE GREEN',\n", " 'DOORKNOB CRACKED GLAZE IVORY',\n", " 'DOORKNOB CRACKED GLAZE PINK',\n", " 'DOORMAT 3 SMILEY CATS',\n", " 'DOORMAT BLACK FLOCK ',\n", " 'DOORMAT CHRISTMAS VILLAGE',\n", " 'DOORMAT ENGLISH ROSE ',\n", " 'DOORMAT FAIRY CAKE',\n", " 'DOORMAT FANCY FONT HOME SWEET HOME',\n", " 'DOORMAT HEARTS',\n", " 'DOORMAT HOME SWEET HOME BLUE ',\n", " 'DOORMAT KEEP CALM AND COME IN',\n", " 'DOORMAT MERRY CHRISTMAS RED ',\n", " 'DOORMAT MULTICOLOUR STRIPE',\n", " 'DOORMAT NEW ENGLAND',\n", " 'DOORMAT PEACE ON EARTH BLUE',\n", " 'DOORMAT RED RETROSPOT',\n", " 'DOORMAT RESPECTABLE HOUSE',\n", " 'DOORMAT SPOTTY HOME SWEET HOME',\n", " 'DOORMAT TOPIARY',\n", " 'DOORMAT VINTAGE LEAF',\n", " 'DOORMAT VINTAGE LEAVES DESIGN ',\n", " 'DOORMAT WELCOME PUPPIES',\n", " 'DOORMAT WELCOME TO OUR HOME',\n", " 'DOORSTOP RETROSPOT HEART',\n", " 'DOUBLE CERAMIC PARLOUR HOOK',\n", " 'DOUGHNUT LIP GLOSS ',\n", " 'DOVE DECORATION PAINTED ZINC ',\n", " 'DRAWER KNOB CERAMIC BLACK',\n", " 'DRAWER KNOB CERAMIC IVORY',\n", " 'DRAWER KNOB CERAMIC RED',\n", " 'DRAWER KNOB CRACKLE GLAZE BLUE',\n", " 'DRAWER KNOB CRACKLE GLAZE GREEN',\n", " 'DRAWER KNOB CRACKLE GLAZE IVORY',\n", " 'DRAWER KNOB CRACKLE GLAZE PINK',\n", " 'DRAWER KNOB VINTAGE GLASS BALL',\n", " 'DRAWER KNOB VINTAGE GLASS STAR',\n", " 'DROP DIAMANTE EARRINGS CRYSTAL',\n", " 'DROP DIAMANTE EARRINGS GREEN',\n", " 'DROP DIAMANTE EARRINGS PURPLE',\n", " 'Discount',\n", " 'EASTER BUNNY WREATH',\n", " 'EASTER CRAFT 4 CHICKS ',\n", " 'EASTER DECORATION EGG BUNNY ',\n", " 'EASTER DECORATION HANGING BUNNY',\n", " 'EASTER DECORATION SITTING BUNNY',\n", " 'EASTER TIN BUCKET',\n", " 'EASTER TIN BUNNY BOUQUET',\n", " 'EASTER TIN CHICKS IN GARDEN',\n", " 'EASTER TIN CHICKS PINK DAISY',\n", " 'EASTER TIN KEEPSAKE',\n", " 'EASTER TREE YELLOW BIRDS',\n", " 'EAU DE NIL LOVE BIRD CANDLE',\n", " 'EAU DE NILE JEWELLED PHOTOFRAME',\n", " 'EDWARDIAN DROP EARRINGS JET BLACK',\n", " 'EDWARDIAN HEART PHOTO FRAME',\n", " 'EDWARDIAN PARASOL BLACK',\n", " 'EDWARDIAN PARASOL NATURAL',\n", " 'EDWARDIAN PARASOL PINK',\n", " 'EDWARDIAN PARASOL RED',\n", " 'EDWARDIAN PHOTO FRAME',\n", " 'EGG CUP HENRIETTA HEN CREAM ',\n", " 'EGG CUP HENRIETTA HEN PINK',\n", " 'EGG CUP MILKMAID HEIDI',\n", " 'EGG CUP MILKMAID HELGA ',\n", " 'EGG CUP MILKMAID INGRID',\n", " 'EGG CUP NATURAL CHICKEN',\n", " 'EGG FRYING PAN BLUE ',\n", " 'EGG FRYING PAN IVORY ',\n", " 'EGG FRYING PAN MINT ',\n", " 'EGG FRYING PAN PINK ',\n", " 'EGG FRYING PAN RED ',\n", " 'ELEPHANT CARNIVAL POUFFE',\n", " 'ELEPHANT, BIRTHDAY CARD, ',\n", " 'EMBOSSED GLASS TEALIGHT HOLDER',\n", " 'EMBOSSED HEART TRINKET BOX',\n", " 'EMBROIDERED RIBBON REEL EMILY ',\n", " 'EMBROIDERED RIBBON REEL REBECCA ',\n", " 'EMBROIDERED RIBBON REEL ROSIE',\n", " 'EMBROIDERED RIBBON REEL SALLY ',\n", " 'EMERGENCY FIRST AID TIN ',\n", " 'ENAMEL BLUE RIM BISCUIT BIN',\n", " 'ENAMEL BLUE RIM COFFEE CONTAINER',\n", " 'ENAMEL BREAD BIN CREAM',\n", " 'ENAMEL COLANDER CREAM',\n", " 'ENAMEL FIRE BUCKET CREAM',\n", " 'ENAMEL FLOWER JUG CREAM',\n", " 'ENAMEL MEASURING JUG CREAM',\n", " 'ENAMEL PINK COFFEE CONTAINER',\n", " 'ENAMEL PINK TEA CONTAINER',\n", " 'ENAMEL WASH BOWL CREAM',\n", " 'ENAMEL WATERING CAN CREAM',\n", " 'ENCHANTED BIRD COATHANGER 5 HOOK',\n", " 'ENCHANTED BIRD PLANT CAGE',\n", " 'ENGLISH ROSE GARDEN SECATEURS',\n", " 'ENGLISH ROSE HOT WATER BOTTLE',\n", " 'ENGLISH ROSE NOTEBOOK A7 SIZE',\n", " 'ENGLISH ROSE SPIRIT LEVEL ',\n", " 'ENVELOPE 50 BLOSSOM IMAGES',\n", " 'ETCHED GLASS COASTER',\n", " 'EUCALYPTUS & PINECONE WREATH',\n", " 'FAIRY CAKE BIRTHDAY CANDLE SET',\n", " 'FAIRY CAKE DESIGN UMBRELLA',\n", " 'FAIRY CAKE FLANNEL ASSORTED COLOUR',\n", " 'FAIRY SOAP SOAP HOLDER',\n", " 'FAIRY TALE COTTAGE NIGHT LIGHT',\n", " 'FAIRY TALE COTTAGE NIGHTLIGHT',\n", " 'FAMILY ALBUM WHITE PICTURE FRAME',\n", " 'FAMILY PHOTO FRAME CORNICE',\n", " 'FANCY FONT BIRTHDAY CARD, ',\n", " 'FANCY FONTS BIRTHDAY WRAP',\n", " 'FAWN BLUE HOT WATER BOTTLE',\n", " 'FEATHER PEN,COAL BLACK',\n", " 'FEATHER PEN,HOT PINK',\n", " 'FEATHER PEN,LIGHT PINK',\n", " 'FELT EGG COSY BLUE RABBIT ',\n", " 'FELT EGG COSY CHICKEN',\n", " 'FELT EGG COSY WHITE RABBIT ',\n", " 'FELT FARM ANIMAL CHICKEN',\n", " 'FELT FARM ANIMAL SHEEP',\n", " 'FELT TOADSTOOL LARGE',\n", " 'FELTCRAFT 6 FLOWER FRIENDS',\n", " 'FELTCRAFT BOY JEAN-PAUL KIT',\n", " 'FELTCRAFT BUTTERFLY HEARTS',\n", " 'FELTCRAFT CHRISTMAS FAIRY',\n", " 'FELTCRAFT CUSHION BUTTERFLY',\n", " 'FELTCRAFT CUSHION OWL',\n", " 'FELTCRAFT CUSHION RABBIT',\n", " 'FELTCRAFT DOLL EMILY',\n", " 'FELTCRAFT DOLL MOLLY',\n", " 'FELTCRAFT DOLL ROSIE',\n", " 'FELTCRAFT GIRL AMELIE KIT',\n", " 'FELTCRAFT GIRL NICOLE KIT',\n", " 'FELTCRAFT HAIRBAND RED AND BLUE',\n", " 'FELTCRAFT PRINCESS CHARLOTTE DOLL',\n", " 'FELTCRAFT PRINCESS LOLA DOLL',\n", " 'FELTCRAFT PRINCESS OLIVIA DOLL',\n", " 'FILIGREE HEART BUTTERFLY WHITE ',\n", " 'FILIGREE HEART DAISY WHITE',\n", " 'FINE WICKER HEART ',\n", " 'FIRST CLASS LUGGAGE TAG ',\n", " 'FIVE CATS HANGING DECORATION',\n", " 'FIVE HEART HANGING DECORATION',\n", " 'FLOOR CUSHION ELEPHANT CARNIVAL',\n", " 'FLORAL FOLK STATIONERY SET',\n", " 'FLORAL SOFT CAR TOY',\n", " 'FLOWER FAIRY 5 DRAWER LINERS',\n", " \"FLOWER FAIRY,5 SUMMER B'DRAW LINERS\",\n", " 'FLOWER VINE RAFFIA FOOD COVER',\n", " 'FLOWERS CHANDELIER T-LIGHT HOLDER',\n", " 'FLOWERS TILE COASTER',\n", " 'FLUTED ANTIQUE CANDLE HOLDER',\n", " 'FLYING PIG WATERING CAN',\n", " 'FOLDING BUTTERFLY MIRROR HOT PINK ',\n", " 'FOLDING BUTTERFLY MIRROR IVORY ',\n", " 'FOLDING BUTTERFLY MIRROR RED ',\n", " 'FOLDING UMBRELLA RED/WHITE POLKADOT',\n", " 'FOLK ART METAL HEART T-LIGHT HOLDER',\n", " 'FOLK ART METAL STAR T-LIGHT HOLDER',\n", " 'FOLKART CLIP ON STARS',\n", " 'FOLKART HEART NAPKIN RINGS',\n", " 'FOLKART STAR CHRISTMAS DECORATIONS',\n", " 'FOLKART ZINC HEART CHRISTMAS DEC',\n", " 'FOOD CONTAINER SET 3 LOVE HEART ',\n", " 'FOOD COVER WITH BEADS SET 2 ',\n", " 'FOOD/DRINK SPONGE STICKERS',\n", " 'FOOT STOOL HOME SWEET HOME ',\n", " 'FORKED CACTUS CANDLE',\n", " 'FOUR HOOK WHITE LOVEBIRDS',\n", " 'FRENCH BATHROOM SIGN BLUE METAL',\n", " 'FRENCH BLUE METAL DOOR SIGN 0',\n", " 'FRENCH BLUE METAL DOOR SIGN 1',\n", " 'FRENCH BLUE METAL DOOR SIGN 2',\n", " 'FRENCH BLUE METAL DOOR SIGN 3',\n", " 'FRENCH BLUE METAL DOOR SIGN 4',\n", " 'FRENCH BLUE METAL DOOR SIGN 5',\n", " 'FRENCH BLUE METAL DOOR SIGN 6',\n", " 'FRENCH BLUE METAL DOOR SIGN 7',\n", " 'FRENCH BLUE METAL DOOR SIGN 8',\n", " 'FRENCH BLUE METAL DOOR SIGN 9',\n", " 'FRENCH BLUE METAL DOOR SIGN No',\n", " 'FRENCH CARRIAGE LANTERN',\n", " 'FRENCH ENAMEL CANDLEHOLDER',\n", " 'FRENCH ENAMEL POT W LID',\n", " 'FRENCH ENAMEL UTENSIL HOLDER',\n", " 'FRENCH ENAMEL WATER BASIN',\n", " 'FRENCH FLORAL CUSHION COVER ',\n", " 'FRENCH GARDEN SIGN BLUE METAL',\n", " 'FRENCH KITCHEN SIGN BLUE METAL',\n", " 'FRENCH LAUNDRY SIGN BLUE METAL',\n", " 'FRENCH LAVENDER SCENT HEART',\n", " 'FRENCH PAISLEY CUSHION COVER ',\n", " 'FRENCH STYLE STORAGE JAR BONBONS',\n", " 'FRENCH STYLE STORAGE JAR CAFE ',\n", " 'FRENCH STYLE STORAGE JAR JAM',\n", " 'FRENCH TOILET SIGN BLUE METAL',\n", " 'FRENCH WC SIGN BLUE METAL',\n", " 'FRIDGE MAGNETS LES ENFANTS ASSORTED',\n", " 'FRIDGE MAGNETS US DINER ASSORTED',\n", " 'FROSTED WHITE BASE ',\n", " 'FRYING PAN PINK POLKADOT',\n", " 'FRYING PAN RED POLKADOT ',\n", " 'FRYING PAN RED RETROSPOT',\n", " 'FULL ENGLISH BREAKFAST PLATE',\n", " 'FUNKY DIVA PEN',\n", " 'FUNKY WASHING UP GLOVES ASSORTED',\n", " 'FUSCHIA FLOWER PURSE WITH BEADS',\n", " 'FUSCHIA TABLE RUN FLOWER ',\n", " 'FUSCHIA VOILE POINTY SHOE DEC',\n", " 'GARDEN PATH JOURNAL',\n", " 'GARDEN PATH SKETCHBOOK',\n", " 'GARDENERS KNEELING PAD CUP OF TEA ',\n", " 'GARDENERS KNEELING PAD KEEP CALM ',\n", " 'GARDENIA 1 WICK MORRIS BOXED CANDLE',\n", " 'GARLAND WOODEN HAPPY EASTER',\n", " 'GARLAND, MAGIC GARDEN 1.8M',\n", " 'GENTLEMAN SHIRT REPAIR KIT ',\n", " 'GEORGIAN TRINKET BOX',\n", " \"GIANT 50'S CHRISTMAS CRACKER\",\n", " 'GIFT BAG BIRTHDAY',\n", " 'GIFT BAG PSYCHEDELIC APPLES',\n", " 'GIN & TONIC DIET GREETING CARD ',\n", " 'GIN + TONIC DIET METAL SIGN',\n", " 'GIN AND TONIC MUG',\n", " 'GINGERBREAD MAN COOKIE CUTTER',\n", " 'GINGHAM HEART DOORSTOP RED',\n", " 'GINGHAM HEART DECORATION',\n", " 'GINGHAM RECIPE BOOK BOX',\n", " 'GINGHAM ROSE WRAP',\n", " 'GIRAFFE WOODEN RULER',\n", " 'GIRLS VINTAGE TIN SEASIDE BUCKET',\n", " 'GLAMOROUS MUG',\n", " 'GLASS BEURRE DISH',\n", " 'GLASS APOTHECARY BOTTLE PERFUME',\n", " 'GLASS APOTHECARY BOTTLE TONIC',\n", " 'GLASS BON BON JAR',\n", " 'GLASS BONNE JAM JAR',\n", " 'GLASS CHALICE BLUE SMALL ',\n", " 'GLASS HEART T-LIGHT HOLDER ',\n", " 'GLASS JAR DAISY FRESH COTTON WOOL',\n", " 'GLASS JAR DIGESTIVE BISCUITS',\n", " 'GLASS JAR ENGLISH CONFECTIONERY',\n", " 'GLASS JAR MARMALADE ',\n", " 'GLASS JAR PEACOCK BATH SALTS',\n", " 'GLASS STAR FROSTED T-LIGHT HOLDER',\n", " 'GLITTER BUTTERFLY CLIPS',\n", " 'GLITTER CHRISTMAS STAR ',\n", " 'GLITTER CHRISTMAS TREE',\n", " 'GLITTER CHRISTMAS TREE WITH BELLS',\n", " 'GLITTER HANGING BUTTERFLY STRING',\n", " 'GLITTER HEART DECORATION',\n", " 'GLITTER HEART GARLAND WITH BELLS ',\n", " 'GLITTER STAR GARLAND WITH BELLS ',\n", " 'GOLD M.O.P ORBIT DROP EARRINGS',\n", " 'GOLD MINI TAPE MEASURE ',\n", " 'GOLD MUG BONE CHINA TREE OF LIFE',\n", " 'GOLD PHOTO FRAME',\n", " 'GRAND CHOCOLATECANDLE',\n", " 'GREEN BIRDHOUSE DECORATION',\n", " 'GREEN BITTY LIGHT CHAIN',\n", " 'GREEN CHRISTMAS TREE CARD HOLDER',\n", " 'GREEN DRAWER KNOB ACRYLIC EDWARDIAN',\n", " 'GREEN EASTER EGG HUNT START POST',\n", " 'GREEN ENAMEL FLOWER HAIR TIE',\n", " 'GREEN ENAMEL FLOWER RING',\n", " 'GREEN FERN JOURNAL ',\n", " 'GREEN FERN SKETCHBOOK ',\n", " 'GREEN GIANT GARDEN THERMOMETER',\n", " 'GREEN GOOSE FEATHER CHRISTMAS TREE ',\n", " 'GREEN GOOSE FEATHER TREE 60CM',\n", " 'GREEN METAL BOX ARMY SUPPLIES',\n", " 'GREEN METAL SWINGING BUNNY',\n", " 'GREEN PAIR HEART HAIR SLIDES',\n", " 'GREEN PENDANT TRIPLE SHELL NECKLACE',\n", " 'GREEN POLKADOT BOWL',\n", " 'GREEN POLKADOT PLATE ',\n", " 'GREEN REGENCY TEACUP AND SAUCER',\n", " 'GREEN ROSE WASHBAG',\n", " 'GREEN ROUND COMPACT MIRROR',\n", " 'GREEN SQUARE COMPACT MIRROR',\n", " 'GREEN VINTAGE SPOT BEAKER',\n", " 'GREETING CARD, OVERCROWDED POOL.',\n", " 'GREY HEART HOT WATER BOTTLE',\n", " 'GROW A FLYTRAP OR SUNFLOWER IN TIN',\n", " 'GROW YOUR OWN BASIL IN ENAMEL MUG',\n", " 'GROW YOUR OWN FLOWERS SET OF 3',\n", " 'GROW YOUR OWN HERBS SET OF 3',\n", " 'GUMBALL COAT RACK',\n", " 'GUMBALL MAGAZINE RACK',\n", " 'GYMKHANA TREASURE BOOK BOX',\n", " 'GYMKHANNA TREASURE BOOK BOX',\n", " 'HAND OPEN SHAPE GOLD',\n", " 'HAND OVER THE CHOCOLATE SIGN ',\n", " 'HAND WARMER BABUSHKA DESIGN',\n", " 'HAND WARMER BIRD DESIGN',\n", " 'HAND WARMER OWL DESIGN',\n", " 'HAND WARMER RED LOVE HEART',\n", " 'HAND WARMER RED RETROSPOT',\n", " 'HAND WARMER SCOTTY DOG DESIGN',\n", " 'HANGING BAUBLE T-LIGHT HOLDER SMALL',\n", " 'HANGING ENGRAVED METAL HEART',\n", " 'HANGING FAIRY CAKE DECORATION',\n", " 'HANGING HEART BONHEUR',\n", " 'HANGING HEART JAR T-LIGHT HOLDER',\n", " 'HANGING HEART MIRROR DECORATION ',\n", " 'HANGING HEART WITH BELL',\n", " 'HANGING HEART ZINC T-LIGHT HOLDER',\n", " 'HANGING HEN ON NEST DECORATION',\n", " 'HANGING JAM JAR T-LIGHT HOLDER',\n", " 'HANGING JAM JAR T-LIGHT HOLDERS',\n", " 'HANGING METAL HEART LANTERN',\n", " 'HANGING METAL RABBIT DECORATION',\n", " 'HANGING METAL STAR LANTERN',\n", " 'HANGING MINI COLOURED BOTTLES',\n", " 'HANGING PHOTO CLIP ROPE LADDER',\n", " 'HANGING QUILTED PATCHWORK APPLES',\n", " 'HANGING SPRING FLOWER EGG LARGE',\n", " 'HANGING SPRING FLOWER EGG SMALL',\n", " 'HANGING WOOD AND FELT FLOWER',\n", " 'HAPPY EASTER HANGING DECORATION',\n", " 'HAPPY STENCIL CRAFT',\n", " 'HAWAIIAN GRASS SKIRT ',\n", " 'HEADS AND TAILS SPORTING FUN',\n", " 'HEART BEADED TRELLIS DECORATION',\n", " 'HEART CALCULATOR',\n", " 'HEART DECORATION RUSTIC HANGING ',\n", " 'HEART FILIGREE DOVE SMALL',\n", " 'HEART IVORY TRELLIS LARGE',\n", " 'HEART IVORY TRELLIS SMALL',\n", " 'HEART MINI PORTRAIT FRAME',\n", " 'HEART OF WICKER LARGE',\n", " 'HEART OF WICKER SMALL',\n", " 'HEART SHAPED HOLLY WREATH',\n", " 'HEART STRING MEMO HOLDER HANGING',\n", " 'HEART T-LIGHT HOLDER WILLIE WINKIE',\n", " 'HEART WOODEN CHRISTMAS DECORATION',\n", " 'HEART WREATH DECORATION WITH BELL',\n", " 'HEARTS STICKERS',\n", " 'HELLO SAILOR BLUE SOAP HOLDER',\n", " 'HEN HOUSE DECORATION',\n", " 'HEN HOUSE W CHICK STANDING',\n", " 'HEN HOUSE W FAMILY IN BARN & NEST',\n", " 'HERB MARKER BASIL',\n", " 'HERB MARKER CHIVES ',\n", " 'HERB MARKER MINT',\n", " 'HERB MARKER PARSLEY',\n", " 'HERB MARKER ROSEMARY',\n", " 'HERB MARKER THYME',\n", " 'HILDA CANDY SPOT RABBIT',\n", " 'HOLIDAY FUN LUDO',\n", " 'HOME BUILDING BLOCK WORD',\n", " 'HOME GARLAND PAINTED ZINC ',\n", " 'HOME SMALL WOOD LETTERS',\n", " 'HOME SWEET HOME 2 DRAWER CABINET',\n", " 'HOME SWEET HOME 3 PEG HANGER ',\n", " 'HOME SWEET HOME BLACKBOARD',\n", " 'HOME SWEET HOME BOTTLE ',\n", " 'HOME SWEET HOME CUSHION COVER ',\n", " 'HOME SWEET HOME HANGING HEART',\n", " 'HOME SWEET HOME HOOK',\n", " 'HOME SWEET HOME KEY HOLDER',\n", " 'HOME SWEET HOME METAL SIGN ',\n", " 'HOME SWEET HOME MUG',\n", " 'HOMEMADE JAM SCENTED CANDLES',\n", " 'HOT BATHS METAL SIGN',\n", " 'HOT BATHS SOAP HOLDER',\n", " 'HOT STUFF HOT WATER BOTTLE',\n", " 'HOT WATER BOTTLE BABUSHKA ',\n", " 'HOT WATER BOTTLE I AM SO POORLY',\n", " 'HOT WATER BOTTLE KEEP CALM',\n", " 'HOT WATER BOTTLE TEA AND SYMPATHY',\n", " 'HOUSE SHAPE PENCIL SHARPENER',\n", " 'HYACINTH BULB T-LIGHT CANDLES',\n", " 'I CAN ONLY PLEASE ONE PERSON MUG',\n", " \"I'M ON HOLIDAY METAL SIGN\",\n", " 'ICE CREAM PEN LIP GLOSS ',\n", " 'ICE CREAM SUNDAE LIP GLOSS',\n", " 'ICON PLACEMAT POP ART ELVIS',\n", " \"IF YOU CAN'T STAND THE HEAT MUG\",\n", " 'ILLUSTRATED CAT BOWL ',\n", " 'INFLATABLE POLITICAL GLOBE ',\n", " 'IVORY CAFE HANGING LAMP ',\n", " 'IVORY DINER WALL CLOCK',\n", " 'IVORY EMBROIDERED QUILT ',\n", " 'IVORY GIANT GARDEN THERMOMETER',\n", " 'IVORY HANGING DECORATION BIRD',\n", " 'IVORY HANGING DECORATION EGG',\n", " 'IVORY KITCHEN SCALES',\n", " 'IVORY KNITTED MUG COSY ',\n", " 'IVORY LOVE BIRD CANDLE',\n", " 'IVORY PENDANT TRIPLE SHELL NECKLACE',\n", " 'IVORY PILLAR CANDLE SILVER FLOCK',\n", " 'IVORY REFECTORY CLOCK',\n", " 'IVORY RETRO KITCHEN WALL CLOCK',\n", " 'IVORY SWEETHEART SOAP DISH',\n", " 'IVORY SWEETHEART WIRE LETTER RACK ',\n", " 'IVORY WICKER HEART LARGE',\n", " 'IVORY WICKER HEART MEDIUM',\n", " 'IVORY WIRE KITCHEN ORGANISER',\n", " 'IVORY WIRE SWEETHEART LETTER TRAY',\n", " 'JADE DROP EARRINGS W FILIGREE',\n", " 'JAM CLOCK MAGNET',\n", " 'JAM JAR WITH GREEN LID',\n", " 'JAM JAR WITH PINK LID',\n", " 'JAM MAKING SET PRINTED',\n", " 'JAM MAKING SET WITH JARS',\n", " 'JARDIN ETCHED GLASS CHEESE DISH',\n", " 'JAZZ HEARTS ADDRESS BOOK',\n", " 'JAZZ HEARTS PURSE NOTEBOOK',\n", " 'JIGSAW RABBIT AND BIRDHOUSE',\n", " 'JIGSAW TOADSTOOLS 3 PIECE',\n", " 'JIGSAW TREE WITH BIRDHOUSE',\n", " 'JIGSAW TREE WITH WATERING CAN',\n", " 'JINGLE BELL HEART ANTIQUE GOLD',\n", " 'JINGLE BELL HEART DECORATION',\n", " 'JUMBO BAG BAROQUE BLACK WHITE',\n", " \"JUMBO BAG 50'S CHRISTMAS \",\n", " 'JUMBO BAG ALPHABET',\n", " 'JUMBO BAG APPLES',\n", " 'JUMBO BAG DOILEY PATTERNS',\n", " 'JUMBO BAG DOLLY GIRL DESIGN',\n", " 'JUMBO BAG OWLS',\n", " 'JUMBO BAG PAISLEY PARK',\n", " 'JUMBO BAG PEARS',\n", " 'JUMBO BAG PINK POLKADOT',\n", " 'JUMBO BAG PINK VINTAGE PAISLEY',\n", " 'JUMBO BAG RED RETROSPOT',\n", " 'JUMBO BAG SCANDINAVIAN BLUE PAISLEY',\n", " 'JUMBO BAG SPACEBOY DESIGN',\n", " 'JUMBO BAG STRAWBERRY',\n", " 'JUMBO BAG VINTAGE CHRISTMAS ',\n", " 'JUMBO BAG VINTAGE DOILY ',\n", " 'JUMBO BAG VINTAGE LEAF',\n", " 'JUMBO BAG WOODLAND ANIMALS',\n", " 'JUMBO SHOPPER VINTAGE RED PAISLEY',\n", " 'JUMBO STORAGE BAG SUKI',\n", " 'JUNGLE POPSICLES ICE LOLLY MOULDS',\n", " 'KEEP CALM WALL ART ',\n", " 'KEY CABINET MA CAMPAGNE',\n", " 'KEY FOB , BACK DOOR ',\n", " 'KEY FOB , FRONT DOOR ',\n", " 'KEY FOB , GARAGE DESIGN',\n", " 'KEY FOB , SHED',\n", " 'KEY RING BASEBALL BOOT ASSORTED ',\n", " 'KIDS RAIN MAC BLUE',\n", " 'KIDS RAIN MAC PINK',\n", " 'KITCHEN FLOWER POTS WALL PLAQUE',\n", " 'KITTY PENCIL ERASERS',\n", " 'KNEELING MAT HOUSEWORK DESIGN',\n", " 'KNICKERBOCKERGLORY MAGNET ASSORTED ',\n", " 'LA JARDIN BOTANIQUE CUSHION COVER',\n", " 'LADIES & GENTLEMEN METAL SIGN',\n", " 'LANTERN CREAM GAZEBO ',\n", " 'LARGE ANTIQUE WHITE PHOTO FRAME',\n", " 'LARGE BLACK DIAMANTE HAIRSLIDE',\n", " 'LARGE BLUE PROVENCAL CERAMIC BALL',\n", " 'LARGE CAKE STAND HANGING STRAWBERY',\n", " 'LARGE CAKE TOWEL CHOCOLATE SPOTS',\n", " 'LARGE CERAMIC TOP STORAGE JAR',\n", " 'LARGE CHINESE STYLE SCISSOR',\n", " 'LARGE CRYSTAL DIAMANTE HAIRSLIDE',\n", " 'LARGE DECO JEWELLERY STAND',\n", " 'LARGE HANGING IVORY & RED WOOD BIRD',\n", " 'LARGE HEART MEASURING SPOONS',\n", " 'LARGE IVORY HEART WALL ORGANISER',\n", " 'LARGE MINT DIAMANTE HAIRSLIDE',\n", " 'LARGE PARLOUR FRAME',\n", " 'LARGE PARLOUR PICTURE FRAME',\n", " 'LARGE POPCORN HOLDER ',\n", " 'LARGE PURPLE BABUSHKA NOTEBOOK ',\n", " 'LARGE RED BABUSHKA NOTEBOOK ',\n", " 'LARGE RED RETROSPOT WINDMILL',\n", " 'LARGE ROUND WICKER PLATTER ',\n", " 'LARGE STRIPES CHOCOLATE GIFT BAG',\n", " 'LARGE TORTILLA DESIGN RED BOWL',\n", " 'LARGE WHITE HEART OF WICKER',\n", " 'LARGE WHITE/PINK ROSE ART FLOWER',\n", " 'LARGE YELLOW BABUSHKA NOTEBOOK ',\n", " 'LAUNDRY 15C METAL SIGN',\n", " 'LAUREL STAR ANTIQUE GOLD',\n", " 'LAVENDER INCENSE 40 CONES IN TIN',\n", " 'LAVENDER SCENT CAKE CANDLE',\n", " 'LAVENDER SCENTED FABRIC HEART',\n", " 'LE GRAND TRAY CHIC SET',\n", " 'LETS GO SHOPPING COTTON TOTE BAG',\n", " 'LETTER HOLDER HOME SWEET HOME',\n", " ...]" ] }, "execution_count": 8, "metadata": {}, "output_type": "execute_result" } ], "source": [ "list(basket.columns)" ] }, { "cell_type": "code", "execution_count": 9, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Description4 PURPLE FLOCK DINNER CANDLES50'S CHRISTMAS GIFT BAG LARGEDOLLY GIRL BEAKERNINE DRAWER OFFICE TIDYOVAL WALL MIRROR DIAMANTERED SPOT GIFT BAG LARGESPACEBOY BABY GIFT SETTRELLIS COAT RACK10 COLOUR SPACEBOY PEN12 COLOURED PARTY BALLOONS...ZINC FOLKART SLEIGH BELLSZINC HEART FLOWER T-LIGHT HOLDERZINC HERB GARDEN CONTAINERZINC METAL HEART DECORATIONZINC SWEETHEART WIRE LETTER RACKZINC T-LIGHT HOLDER STAR LARGEZINC T-LIGHT HOLDER STARS SMALLZINC WILLIE WINKIE CANDLE STICKZINC WIRE KITCHEN ORGANISERZINC WIRE SWEETHEART LETTER TRAY
InvoiceNo
5365400000000000...0000000000
5365410000000000...0000000000
5368030000000000...0000000000
5368850000000000...0000000000
5368900000000000...0000000000
..................................................................
C5773880000000000...0000000000
C5778280000000000...0000000000
C5781360000000000...0000000000
C5799070000000000...0000000000
C5800560000000000...0000000000
\n", "

360 rows × 2027 columns

\n", "
" ], "text/plain": [ "Description 4 PURPLE FLOCK DINNER CANDLES 50'S CHRISTMAS GIFT BAG LARGE \\\n", "InvoiceNo \n", "536540 0 0 \n", "536541 0 0 \n", "536803 0 0 \n", "536885 0 0 \n", "536890 0 0 \n", "... ... ... \n", "C577388 0 0 \n", "C577828 0 0 \n", "C578136 0 0 \n", "C579907 0 0 \n", "C580056 0 0 \n", "\n", "Description DOLLY GIRL BEAKER NINE DRAWER OFFICE TIDY \\\n", "InvoiceNo \n", "536540 0 0 \n", "536541 0 0 \n", "536803 0 0 \n", "536885 0 0 \n", "536890 0 0 \n", "... ... ... \n", "C577388 0 0 \n", "C577828 0 0 \n", "C578136 0 0 \n", "C579907 0 0 \n", "C580056 0 0 \n", "\n", "Description OVAL WALL MIRROR DIAMANTE RED SPOT GIFT BAG LARGE \\\n", "InvoiceNo \n", "536540 0 0 \n", "536541 0 0 \n", "536803 0 0 \n", "536885 0 0 \n", "536890 0 0 \n", "... ... ... \n", "C577388 0 0 \n", "C577828 0 0 \n", "C578136 0 0 \n", "C579907 0 0 \n", "C580056 0 0 \n", "\n", "Description SPACEBOY BABY GIFT SET TRELLIS COAT RACK \\\n", "InvoiceNo \n", "536540 0 0 \n", "536541 0 0 \n", "536803 0 0 \n", "536885 0 0 \n", "536890 0 0 \n", "... ... ... \n", "C577388 0 0 \n", "C577828 0 0 \n", "C578136 0 0 \n", "C579907 0 0 \n", "C580056 0 0 \n", "\n", "Description 10 COLOUR SPACEBOY PEN 12 COLOURED PARTY BALLOONS ... \\\n", "InvoiceNo ... \n", "536540 0 0 ... \n", "536541 0 0 ... \n", "536803 0 0 ... \n", "536885 0 0 ... \n", "536890 0 0 ... \n", "... ... ... ... \n", "C577388 0 0 ... \n", "C577828 0 0 ... \n", "C578136 0 0 ... \n", "C579907 0 0 ... \n", "C580056 0 0 ... \n", "\n", "Description ZINC FOLKART SLEIGH BELLS ZINC HEART FLOWER T-LIGHT HOLDER \\\n", "InvoiceNo \n", "536540 0 0 \n", "536541 0 0 \n", "536803 0 0 \n", "536885 0 0 \n", "536890 0 0 \n", "... ... ... \n", "C577388 0 0 \n", "C577828 0 0 \n", "C578136 0 0 \n", "C579907 0 0 \n", "C580056 0 0 \n", "\n", "Description ZINC HERB GARDEN CONTAINER ZINC METAL HEART DECORATION \\\n", "InvoiceNo \n", "536540 0 0 \n", "536541 0 0 \n", "536803 0 0 \n", "536885 0 0 \n", "536890 0 0 \n", "... ... ... \n", "C577388 0 0 \n", "C577828 0 0 \n", "C578136 0 0 \n", "C579907 0 0 \n", "C580056 0 0 \n", "\n", "Description ZINC SWEETHEART WIRE LETTER RACK ZINC T-LIGHT HOLDER STAR LARGE \\\n", "InvoiceNo \n", "536540 0 0 \n", "536541 0 0 \n", "536803 0 0 \n", "536885 0 0 \n", "536890 0 0 \n", "... ... ... \n", "C577388 0 0 \n", "C577828 0 0 \n", "C578136 0 0 \n", "C579907 0 0 \n", "C580056 0 0 \n", "\n", "Description ZINC T-LIGHT HOLDER STARS SMALL \\\n", "InvoiceNo \n", "536540 0 \n", "536541 0 \n", "536803 0 \n", "536885 0 \n", "536890 0 \n", "... ... \n", "C577388 0 \n", "C577828 0 \n", "C578136 0 \n", "C579907 0 \n", "C580056 0 \n", "\n", "Description ZINC WILLIE WINKIE CANDLE STICK ZINC WIRE KITCHEN ORGANISER \\\n", "InvoiceNo \n", "536540 0 0 \n", "536541 0 0 \n", "536803 0 0 \n", "536885 0 0 \n", "536890 0 0 \n", "... ... ... \n", "C577388 0 0 \n", "C577828 0 0 \n", "C578136 0 0 \n", "C579907 0 0 \n", "C580056 0 0 \n", "\n", "Description ZINC WIRE SWEETHEART LETTER TRAY \n", "InvoiceNo \n", "536540 0 \n", "536541 0 \n", "536803 0 \n", "536885 0 \n", "536890 0 \n", "... ... \n", "C577388 0 \n", "C577828 0 \n", "C578136 0 \n", "C579907 0 \n", "C580056 0 \n", "\n", "[360 rows x 2027 columns]" ] }, "execution_count": 9, "metadata": {}, "output_type": "execute_result" } ], "source": [ "#Recode the numbers in the cells to indicate if item was bought (1) or not (0). The actual number is not important\n", "def encode_units(x):\n", " if x <= 0:\n", " return 0\n", " if x >= 1:\n", " return 1\n", "\n", "basket_sets = basket.applymap(encode_units)\n", "basket_sets" ] }, { "cell_type": "code", "execution_count": 10, "metadata": {}, "outputs": [], "source": [ "#load the MLxtend package and the particular functions we are going to use\n", "from mlxtend.frequent_patterns import apriori\n", "from mlxtend.frequent_patterns import association_rules" ] }, { "cell_type": "code", "execution_count": 11, "metadata": {}, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "/Users/brendan.tierney/opt/anaconda3/lib/python3.9/site-packages/mlxtend/frequent_patterns/fpcommon.py:111: DeprecationWarning: DataFrames with non-bool types result in worse computationalperformance and their support might be discontinued in the future.Please use a DataFrame with bool type\n", " warnings.warn(\n" ] }, { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
supportitemsets
00.066667(60 TEATIME FAIRY CAKE CASES)
10.055556(72 SWEETHEART FAIRY CAKE CASES)
20.055556(ASSORTED COLOUR BIRD ORNAMENT)
30.083333(BAKING SET 9 PIECE RETROSPOT )
40.050000(BINGO SET)
.........
710.069444(ROSES REGENCY TEACUP AND SAUCER , REGENCY CAK...
720.050000(ROSES REGENCY TEACUP AND SAUCER , REGENCY SUG...
730.055556(PINK REGENCY TEACUP AND SAUCER, ROSES REGENCY...
740.050000(ROSES REGENCY TEACUP AND SAUCER , REGENCY CAK...
750.052778(PINK REGENCY TEACUP AND SAUCER, ROSES REGENCY...
\n", "

76 rows × 2 columns

\n", "
" ], "text/plain": [ " support itemsets\n", "0 0.066667 (60 TEATIME FAIRY CAKE CASES)\n", "1 0.055556 (72 SWEETHEART FAIRY CAKE CASES)\n", "2 0.055556 (ASSORTED COLOUR BIRD ORNAMENT)\n", "3 0.083333 (BAKING SET 9 PIECE RETROSPOT )\n", "4 0.050000 (BINGO SET)\n", ".. ... ...\n", "71 0.069444 (ROSES REGENCY TEACUP AND SAUCER , REGENCY CAK...\n", "72 0.050000 (ROSES REGENCY TEACUP AND SAUCER , REGENCY SUG...\n", "73 0.055556 (PINK REGENCY TEACUP AND SAUCER, ROSES REGENCY...\n", "74 0.050000 (ROSES REGENCY TEACUP AND SAUCER , REGENCY CAK...\n", "75 0.052778 (PINK REGENCY TEACUP AND SAUCER, ROSES REGENCY...\n", "\n", "[76 rows x 2 columns]" ] }, "execution_count": 11, "metadata": {}, "output_type": "execute_result" } ], "source": [ "frequent_itemsets = apriori(basket_sets, min_support=0.05, use_colnames=True)\n", "frequent_itemsets" ] }, { "cell_type": "code", "execution_count": 12, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
antecedentsconsequentsantecedent supportconsequent supportsupportconfidenceliftleverageconviction
0(PINK REGENCY TEACUP AND SAUCER)(GREEN REGENCY TEACUP AND SAUCER)0.0777780.1000000.0722220.9285719.2857140.06444412.600000
1(GREEN REGENCY TEACUP AND SAUCER)(PINK REGENCY TEACUP AND SAUCER)0.1000000.0777780.0722220.7222229.2857140.0644443.320000
2(REGENCY CAKESTAND 3 TIER)(GREEN REGENCY TEACUP AND SAUCER)0.1972220.1000000.0694440.3521133.5211270.0497221.389130
3(GREEN REGENCY TEACUP AND SAUCER)(REGENCY CAKESTAND 3 TIER)0.1000000.1972220.0694440.6944443.5211270.0497222.627273
4(REGENCY SUGAR BOWL GREEN)(GREEN REGENCY TEACUP AND SAUCER)0.0694440.1000000.0500000.7200007.2000000.0430563.214286
\n", "
" ], "text/plain": [ " antecedents consequents \\\n", "0 (PINK REGENCY TEACUP AND SAUCER) (GREEN REGENCY TEACUP AND SAUCER) \n", "1 (GREEN REGENCY TEACUP AND SAUCER) (PINK REGENCY TEACUP AND SAUCER) \n", "2 (REGENCY CAKESTAND 3 TIER) (GREEN REGENCY TEACUP AND SAUCER) \n", "3 (GREEN REGENCY TEACUP AND SAUCER) (REGENCY CAKESTAND 3 TIER) \n", "4 (REGENCY SUGAR BOWL GREEN) (GREEN REGENCY TEACUP AND SAUCER) \n", "\n", " antecedent support consequent support support confidence lift \\\n", "0 0.077778 0.100000 0.072222 0.928571 9.285714 \n", "1 0.100000 0.077778 0.072222 0.722222 9.285714 \n", "2 0.197222 0.100000 0.069444 0.352113 3.521127 \n", "3 0.100000 0.197222 0.069444 0.694444 3.521127 \n", "4 0.069444 0.100000 0.050000 0.720000 7.200000 \n", "\n", " leverage conviction \n", "0 0.064444 12.600000 \n", "1 0.064444 3.320000 \n", "2 0.049722 1.389130 \n", "3 0.049722 2.627273 \n", "4 0.043056 3.214286 " ] }, "execution_count": 12, "metadata": {}, "output_type": "execute_result" } ], "source": [ "#Generate the rules with their corresponding support, confidence and lift\n", "rules = association_rules(frequent_itemsets, metric=\"lift\", min_threshold=1)\n", "rules.head()" ] }, { "cell_type": "code", "execution_count": 13, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
antecedentsconsequentsantecedent supportconsequent supportsupportconfidenceliftleverageconviction
0(PINK REGENCY TEACUP AND SAUCER)(GREEN REGENCY TEACUP AND SAUCER)0.0777780.1000000.0722220.9285719.2857140.06444412.600000
28(REGENCY TEAPOT ROSES )(REGENCY SUGAR BOWL GREEN)0.0527780.0694440.0500000.94736813.6421050.04633517.680556
32(REGENCY TEA PLATE PINK)(REGENCY TEA PLATE GREEN )0.0555560.0638890.0500000.90000014.0869570.0464519.361111
35(REGENCY TEA PLATE GREEN )(REGENCY TEA PLATE ROSES )0.0638890.0722220.0555560.86956512.0401340.0509417.112963
38(PINK REGENCY TEACUP AND SAUCER, REGENCY CAKES...(GREEN REGENCY TEACUP AND SAUCER)0.0555560.1000000.0527780.9500009.5000000.04722218.000000
44(PINK REGENCY TEACUP AND SAUCER, ROSES REGENCY...(GREEN REGENCY TEACUP AND SAUCER)0.0750000.1000000.0694440.9259269.2592590.06194412.150000
47(PINK REGENCY TEACUP AND SAUCER)(ROSES REGENCY TEACUP AND SAUCER , GREEN REGEN...0.0777780.0916670.0694440.8928579.7402600.0623158.477778
56(ROSES REGENCY TEACUP AND SAUCER , REGENCY SUG...(GREEN REGENCY TEACUP AND SAUCER)0.0583330.1000000.0500000.8571438.5714290.0441676.300000
74(PINK REGENCY TEACUP AND SAUCER, ROSES REGENCY...(GREEN REGENCY TEACUP AND SAUCER)0.0555560.1000000.0527780.9500009.5000000.04722218.000000
79(PINK REGENCY TEACUP AND SAUCER, REGENCY CAKES...(ROSES REGENCY TEACUP AND SAUCER , GREEN REGEN...0.0555560.0916670.0527780.95000010.3636360.04768518.166667
\n", "
" ], "text/plain": [ " antecedents \\\n", "0 (PINK REGENCY TEACUP AND SAUCER) \n", "28 (REGENCY TEAPOT ROSES ) \n", "32 (REGENCY TEA PLATE PINK) \n", "35 (REGENCY TEA PLATE GREEN ) \n", "38 (PINK REGENCY TEACUP AND SAUCER, REGENCY CAKES... \n", "44 (PINK REGENCY TEACUP AND SAUCER, ROSES REGENCY... \n", "47 (PINK REGENCY TEACUP AND SAUCER) \n", "56 (ROSES REGENCY TEACUP AND SAUCER , REGENCY SUG... \n", "74 (PINK REGENCY TEACUP AND SAUCER, ROSES REGENCY... \n", "79 (PINK REGENCY TEACUP AND SAUCER, REGENCY CAKES... \n", "\n", " consequents antecedent support \\\n", "0 (GREEN REGENCY TEACUP AND SAUCER) 0.077778 \n", "28 (REGENCY SUGAR BOWL GREEN) 0.052778 \n", "32 (REGENCY TEA PLATE GREEN ) 0.055556 \n", "35 (REGENCY TEA PLATE ROSES ) 0.063889 \n", "38 (GREEN REGENCY TEACUP AND SAUCER) 0.055556 \n", "44 (GREEN REGENCY TEACUP AND SAUCER) 0.075000 \n", "47 (ROSES REGENCY TEACUP AND SAUCER , GREEN REGEN... 0.077778 \n", "56 (GREEN REGENCY TEACUP AND SAUCER) 0.058333 \n", "74 (GREEN REGENCY TEACUP AND SAUCER) 0.055556 \n", "79 (ROSES REGENCY TEACUP AND SAUCER , GREEN REGEN... 0.055556 \n", "\n", " consequent support support confidence lift leverage conviction \n", "0 0.100000 0.072222 0.928571 9.285714 0.064444 12.600000 \n", "28 0.069444 0.050000 0.947368 13.642105 0.046335 17.680556 \n", "32 0.063889 0.050000 0.900000 14.086957 0.046451 9.361111 \n", "35 0.072222 0.055556 0.869565 12.040134 0.050941 7.112963 \n", "38 0.100000 0.052778 0.950000 9.500000 0.047222 18.000000 \n", "44 0.100000 0.069444 0.925926 9.259259 0.061944 12.150000 \n", "47 0.091667 0.069444 0.892857 9.740260 0.062315 8.477778 \n", "56 0.100000 0.050000 0.857143 8.571429 0.044167 6.300000 \n", "74 0.100000 0.052778 0.950000 9.500000 0.047222 18.000000 \n", "79 0.091667 0.052778 0.950000 10.363636 0.047685 18.166667 " ] }, "execution_count": 13, "metadata": {}, "output_type": "execute_result" } ], "source": [ "#After generating the association rules, you will want to query the data by filtering \n", "#based on certain criteria, for example based on the support and confidence values.\n", "#filter the dataframe to select a subset\n", "rules[ (rules['lift'] >= 8) &\n", "(rules['confidence'] >= 0.8) ]" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Exercises\n", "Repeat the above steps for the following countries. Some additional data cleaning might be necessary.\n", "\n", "-United Kingdom\n", "\n", "-France\n", "\n", "-Germany\n", "\n", "Compare the Rules to see if there is any overlap or commonalty of sales transactions between these countries." ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": 14, "metadata": {}, "outputs": [], "source": [ "#Some Additional Code examples below" ] }, { "cell_type": "code", "execution_count": 15, "metadata": {}, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "/Users/brendan.tierney/opt/anaconda3/lib/python3.9/site-packages/mlxtend/frequent_patterns/fpcommon.py:111: DeprecationWarning: DataFrames with non-bool types result in worse computationalperformance and their support might be discontinued in the future.Please use a DataFrame with bool type\n", " warnings.warn(\n" ] } ], "source": [ "frequent_itemsets = apriori(basket_sets, min_support=0.07, use_colnames=True)" ] }, { "cell_type": "code", "execution_count": 16, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
antecedentsconsequentsantecedent supportconsequent supportsupportconfidenceliftleverageconviction
0(PINK REGENCY TEACUP AND SAUCER)(GREEN REGENCY TEACUP AND SAUCER)0.0777780.1000000.0722220.9285719.2857140.06444412.600000
1(GREEN REGENCY TEACUP AND SAUCER)(PINK REGENCY TEACUP AND SAUCER)0.1000000.0777780.0722220.7222229.2857140.0644443.320000
2(ROSES REGENCY TEACUP AND SAUCER )(GREEN REGENCY TEACUP AND SAUCER)0.1333330.1000000.0916670.6875006.8750000.0783332.880000
3(GREEN REGENCY TEACUP AND SAUCER)(ROSES REGENCY TEACUP AND SAUCER )0.1000000.1333330.0916670.9166676.8750000.07833310.400000
4(PINK REGENCY TEACUP AND SAUCER)(ROSES REGENCY TEACUP AND SAUCER )0.0777780.1333330.0750000.9642867.2321430.06463024.266667
\n", "
" ], "text/plain": [ " antecedents consequents \\\n", "0 (PINK REGENCY TEACUP AND SAUCER) (GREEN REGENCY TEACUP AND SAUCER) \n", "1 (GREEN REGENCY TEACUP AND SAUCER) (PINK REGENCY TEACUP AND SAUCER) \n", "2 (ROSES REGENCY TEACUP AND SAUCER ) (GREEN REGENCY TEACUP AND SAUCER) \n", "3 (GREEN REGENCY TEACUP AND SAUCER) (ROSES REGENCY TEACUP AND SAUCER ) \n", "4 (PINK REGENCY TEACUP AND SAUCER) (ROSES REGENCY TEACUP AND SAUCER ) \n", "\n", " antecedent support consequent support support confidence lift \\\n", "0 0.077778 0.100000 0.072222 0.928571 9.285714 \n", "1 0.100000 0.077778 0.072222 0.722222 9.285714 \n", "2 0.133333 0.100000 0.091667 0.687500 6.875000 \n", "3 0.100000 0.133333 0.091667 0.916667 6.875000 \n", "4 0.077778 0.133333 0.075000 0.964286 7.232143 \n", "\n", " leverage conviction \n", "0 0.064444 12.600000 \n", "1 0.064444 3.320000 \n", "2 0.078333 2.880000 \n", "3 0.078333 10.400000 \n", "4 0.064630 24.266667 " ] }, "execution_count": 16, "metadata": {}, "output_type": "execute_result" } ], "source": [ "rules = association_rules(frequent_itemsets, metric=\"lift\", min_threshold=1)\n", "rules.head()" ] }, { "cell_type": "code", "execution_count": 17, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
antecedentsconsequentsantecedent supportconsequent supportsupportconfidenceliftleverageconviction
0(PINK REGENCY TEACUP AND SAUCER)(GREEN REGENCY TEACUP AND SAUCER)0.0777780.1000000.0722220.9285719.2857140.06444412.600000
3(GREEN REGENCY TEACUP AND SAUCER)(ROSES REGENCY TEACUP AND SAUCER )0.1000000.1333330.0916670.9166676.8750000.07833310.400000
4(PINK REGENCY TEACUP AND SAUCER)(ROSES REGENCY TEACUP AND SAUCER )0.0777780.1333330.0750000.9642867.2321430.06463024.266667
\n", "
" ], "text/plain": [ " antecedents consequents \\\n", "0 (PINK REGENCY TEACUP AND SAUCER) (GREEN REGENCY TEACUP AND SAUCER) \n", "3 (GREEN REGENCY TEACUP AND SAUCER) (ROSES REGENCY TEACUP AND SAUCER ) \n", "4 (PINK REGENCY TEACUP AND SAUCER) (ROSES REGENCY TEACUP AND SAUCER ) \n", "\n", " antecedent support consequent support support confidence lift \\\n", "0 0.077778 0.100000 0.072222 0.928571 9.285714 \n", "3 0.100000 0.133333 0.091667 0.916667 6.875000 \n", "4 0.077778 0.133333 0.075000 0.964286 7.232143 \n", "\n", " leverage conviction \n", "0 0.064444 12.600000 \n", "3 0.078333 10.400000 \n", "4 0.064630 24.266667 " ] }, "execution_count": 17, "metadata": {}, "output_type": "execute_result" } ], "source": [ "rules[ (rules['lift'] >= 6) &\n", " (rules['confidence'] >= 0.8) ]" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [] } ], "metadata": { "kernelspec": { "display_name": "Python 3 (ipykernel)", "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.10.9" } }, "nbformat": 4, "nbformat_minor": 2 }