{ "cells": [ { "cell_type": "code", "execution_count": 17, "metadata": {}, "outputs": [], "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_excel('http://archive.ics.uci.edu/ml/machine-learning-databases/00352/Online%20Retail.xlsx')\n", "# df.head()" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "df['Description'] = df['Description'].str.strip()\n", "df.dropna(axis=0, subset=['InvoiceNo'], inplace=True)\n", "df['InvoiceNo'] = df['InvoiceNo'].astype('str')\n", "df = df[~df['InvoiceNo'].str.contains('C')]" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "basket = (df[df['Country'] ==\"France\"]\n", " .groupby(['InvoiceNo', 'Description'])['Quantity']\n", " .sum().unstack().reset_index().fillna(0)\n", " .set_index('InvoiceNo'))" ] }, { "cell_type": "code", "execution_count": 18, "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", "
item(Sex, Dope &) Cheap Thrills Vinyl + Poster BundleAvalon Masse MugBBHC: Sex, Dope and Cheap Thrills 2CDBBHC: Sex, Dope and Cheap Thrills 2LPBeatnick Blues T-Shirt 2X-LargeBeatnick Blues T-Shirt LargeBeatnick Blues T-Shirt MediumBeatnick Blues T-Shirt SmallBeatnick Blues T-Shirt X-LargeBig Brother & The Holding Company CD...The Pearl Sessions [2 CD]The Very Best Of Janis Joplin [CD]Vintage Handbill T-Shirt LWhite Cheap Thrills Cartoon T-Shirt SWoodstock - Back To The Garden - 50th AnniversaryWoodstock – Back To The Garden - 50th AnniversaryWoodstock – Back To The Garden – The Definitive 5Woodstock — Back To The Garden — 50th AnniversaryX2 (Pearl/Cheap Thrills) [2CD]Zig Zag Man Lithograph
transaction_id
00de91ae00bb2fea1d7e9953d2da87740c7340ddbe5a2ecc0f91125ea149696a2350.00.00.00.00.00.00.00.00.00.0...0.00.00.00.00.00.00.00.00.00.0
0132bfb1ddb43b86872150aa5d5beb506b2c0547c91d8b56259424eb969330e73420.00.00.00.00.00.00.00.00.00.0...0.00.00.00.00.00.00.00.00.00.0
01a28b44a832a0a35949a680fae963ad86563f389a263561f76cb5bfbbb03cf13340.00.00.00.00.00.00.00.00.00.0...0.00.00.00.00.00.00.00.00.00.0
01b1a76315c3c1bb3b08616eba3e9fd98cb8471a0f7ce5b45a9b27ebd06ab1504620.00.00.00.00.00.00.00.00.00.0...0.00.00.00.00.00.00.00.00.00.0
01e0e2d91144b15862e929591bfa30f74fb0757e50476e8b09e6cabd73525f0b1870.00.00.00.00.00.00.00.00.00.0...0.00.00.00.00.00.00.00.00.00.0
023e16af29b004681ac4248606d06658267fe730ba581f0a9091aee4b880d2681790.00.00.00.00.00.00.00.00.00.0...0.00.00.00.00.00.00.00.00.00.0
02463a4dc6a661eeb8607333c2dc3d0a3ec4c9a40d933540051e04a756d0657a4550.00.00.00.00.00.00.00.00.00.0...0.00.00.00.00.00.00.00.00.00.0
026c164abb5f644eacb3d02798c1571c01713e64d76e72573fb0b6131fc1a4b0230.00.00.00.00.00.00.00.00.00.0...0.00.00.00.00.00.00.00.00.00.0
027b046d6acb430991e79e54e08a5bef371aa35e3be4fe7b196788bb66c5f3fe1140.00.00.00.00.00.00.00.00.00.0...0.00.00.00.00.00.00.00.00.00.0
02c5eae6ef36dd5886912fdead95a60865309e5abcf0ad100632d1d9632d75983330.00.00.00.00.00.00.00.00.00.0...0.00.00.00.00.00.00.00.00.00.0
\n", "

10 rows × 308 columns

\n", "
" ], "text/plain": [ "item (Sex, Dope &) Cheap Thrills Vinyl + Poster Bundle \\\n", "transaction_id \n", "00de91ae00bb2fea1d7e9953d2da87740c7340ddbe5a2ec... 0.0 \n", "0132bfb1ddb43b86872150aa5d5beb506b2c0547c91d8b5... 0.0 \n", "01a28b44a832a0a35949a680fae963ad86563f389a26356... 0.0 \n", "01b1a76315c3c1bb3b08616eba3e9fd98cb8471a0f7ce5b... 0.0 \n", "01e0e2d91144b15862e929591bfa30f74fb0757e50476e8... 0.0 \n", "023e16af29b004681ac4248606d06658267fe730ba581f0... 0.0 \n", "02463a4dc6a661eeb8607333c2dc3d0a3ec4c9a40d93354... 0.0 \n", "026c164abb5f644eacb3d02798c1571c01713e64d76e725... 0.0 \n", "027b046d6acb430991e79e54e08a5bef371aa35e3be4fe7... 0.0 \n", "02c5eae6ef36dd5886912fdead95a60865309e5abcf0ad1... 0.0 \n", "\n", "item Avalon Masse Mug \\\n", "transaction_id \n", "00de91ae00bb2fea1d7e9953d2da87740c7340ddbe5a2ec... 0.0 \n", "0132bfb1ddb43b86872150aa5d5beb506b2c0547c91d8b5... 0.0 \n", "01a28b44a832a0a35949a680fae963ad86563f389a26356... 0.0 \n", "01b1a76315c3c1bb3b08616eba3e9fd98cb8471a0f7ce5b... 0.0 \n", "01e0e2d91144b15862e929591bfa30f74fb0757e50476e8... 0.0 \n", "023e16af29b004681ac4248606d06658267fe730ba581f0... 0.0 \n", "02463a4dc6a661eeb8607333c2dc3d0a3ec4c9a40d93354... 0.0 \n", "026c164abb5f644eacb3d02798c1571c01713e64d76e725... 0.0 \n", "027b046d6acb430991e79e54e08a5bef371aa35e3be4fe7... 0.0 \n", "02c5eae6ef36dd5886912fdead95a60865309e5abcf0ad1... 0.0 \n", "\n", "item BBHC: Sex, Dope and Cheap Thrills 2CD \\\n", "transaction_id \n", "00de91ae00bb2fea1d7e9953d2da87740c7340ddbe5a2ec... 0.0 \n", "0132bfb1ddb43b86872150aa5d5beb506b2c0547c91d8b5... 0.0 \n", "01a28b44a832a0a35949a680fae963ad86563f389a26356... 0.0 \n", "01b1a76315c3c1bb3b08616eba3e9fd98cb8471a0f7ce5b... 0.0 \n", "01e0e2d91144b15862e929591bfa30f74fb0757e50476e8... 0.0 \n", "023e16af29b004681ac4248606d06658267fe730ba581f0... 0.0 \n", "02463a4dc6a661eeb8607333c2dc3d0a3ec4c9a40d93354... 0.0 \n", "026c164abb5f644eacb3d02798c1571c01713e64d76e725... 0.0 \n", "027b046d6acb430991e79e54e08a5bef371aa35e3be4fe7... 0.0 \n", "02c5eae6ef36dd5886912fdead95a60865309e5abcf0ad1... 0.0 \n", "\n", "item BBHC: Sex, Dope and Cheap Thrills 2LP \\\n", "transaction_id \n", "00de91ae00bb2fea1d7e9953d2da87740c7340ddbe5a2ec... 0.0 \n", "0132bfb1ddb43b86872150aa5d5beb506b2c0547c91d8b5... 0.0 \n", "01a28b44a832a0a35949a680fae963ad86563f389a26356... 0.0 \n", "01b1a76315c3c1bb3b08616eba3e9fd98cb8471a0f7ce5b... 0.0 \n", "01e0e2d91144b15862e929591bfa30f74fb0757e50476e8... 0.0 \n", "023e16af29b004681ac4248606d06658267fe730ba581f0... 0.0 \n", "02463a4dc6a661eeb8607333c2dc3d0a3ec4c9a40d93354... 0.0 \n", "026c164abb5f644eacb3d02798c1571c01713e64d76e725... 0.0 \n", "027b046d6acb430991e79e54e08a5bef371aa35e3be4fe7... 0.0 \n", "02c5eae6ef36dd5886912fdead95a60865309e5abcf0ad1... 0.0 \n", "\n", "item Beatnick Blues T-Shirt 2X-Large \\\n", "transaction_id \n", "00de91ae00bb2fea1d7e9953d2da87740c7340ddbe5a2ec... 0.0 \n", "0132bfb1ddb43b86872150aa5d5beb506b2c0547c91d8b5... 0.0 \n", "01a28b44a832a0a35949a680fae963ad86563f389a26356... 0.0 \n", "01b1a76315c3c1bb3b08616eba3e9fd98cb8471a0f7ce5b... 0.0 \n", "01e0e2d91144b15862e929591bfa30f74fb0757e50476e8... 0.0 \n", "023e16af29b004681ac4248606d06658267fe730ba581f0... 0.0 \n", "02463a4dc6a661eeb8607333c2dc3d0a3ec4c9a40d93354... 0.0 \n", "026c164abb5f644eacb3d02798c1571c01713e64d76e725... 0.0 \n", "027b046d6acb430991e79e54e08a5bef371aa35e3be4fe7... 0.0 \n", "02c5eae6ef36dd5886912fdead95a60865309e5abcf0ad1... 0.0 \n", "\n", "item Beatnick Blues T-Shirt Large \\\n", "transaction_id \n", "00de91ae00bb2fea1d7e9953d2da87740c7340ddbe5a2ec... 0.0 \n", "0132bfb1ddb43b86872150aa5d5beb506b2c0547c91d8b5... 0.0 \n", "01a28b44a832a0a35949a680fae963ad86563f389a26356... 0.0 \n", "01b1a76315c3c1bb3b08616eba3e9fd98cb8471a0f7ce5b... 0.0 \n", "01e0e2d91144b15862e929591bfa30f74fb0757e50476e8... 0.0 \n", "023e16af29b004681ac4248606d06658267fe730ba581f0... 0.0 \n", "02463a4dc6a661eeb8607333c2dc3d0a3ec4c9a40d93354... 0.0 \n", "026c164abb5f644eacb3d02798c1571c01713e64d76e725... 0.0 \n", "027b046d6acb430991e79e54e08a5bef371aa35e3be4fe7... 0.0 \n", "02c5eae6ef36dd5886912fdead95a60865309e5abcf0ad1... 0.0 \n", "\n", "item Beatnick Blues T-Shirt Medium \\\n", "transaction_id \n", "00de91ae00bb2fea1d7e9953d2da87740c7340ddbe5a2ec... 0.0 \n", "0132bfb1ddb43b86872150aa5d5beb506b2c0547c91d8b5... 0.0 \n", "01a28b44a832a0a35949a680fae963ad86563f389a26356... 0.0 \n", "01b1a76315c3c1bb3b08616eba3e9fd98cb8471a0f7ce5b... 0.0 \n", "01e0e2d91144b15862e929591bfa30f74fb0757e50476e8... 0.0 \n", "023e16af29b004681ac4248606d06658267fe730ba581f0... 0.0 \n", "02463a4dc6a661eeb8607333c2dc3d0a3ec4c9a40d93354... 0.0 \n", "026c164abb5f644eacb3d02798c1571c01713e64d76e725... 0.0 \n", "027b046d6acb430991e79e54e08a5bef371aa35e3be4fe7... 0.0 \n", "02c5eae6ef36dd5886912fdead95a60865309e5abcf0ad1... 0.0 \n", "\n", "item Beatnick Blues T-Shirt Small \\\n", "transaction_id \n", "00de91ae00bb2fea1d7e9953d2da87740c7340ddbe5a2ec... 0.0 \n", "0132bfb1ddb43b86872150aa5d5beb506b2c0547c91d8b5... 0.0 \n", "01a28b44a832a0a35949a680fae963ad86563f389a26356... 0.0 \n", "01b1a76315c3c1bb3b08616eba3e9fd98cb8471a0f7ce5b... 0.0 \n", "01e0e2d91144b15862e929591bfa30f74fb0757e50476e8... 0.0 \n", "023e16af29b004681ac4248606d06658267fe730ba581f0... 0.0 \n", "02463a4dc6a661eeb8607333c2dc3d0a3ec4c9a40d93354... 0.0 \n", "026c164abb5f644eacb3d02798c1571c01713e64d76e725... 0.0 \n", "027b046d6acb430991e79e54e08a5bef371aa35e3be4fe7... 0.0 \n", "02c5eae6ef36dd5886912fdead95a60865309e5abcf0ad1... 0.0 \n", "\n", "item Beatnick Blues T-Shirt X-Large \\\n", "transaction_id \n", "00de91ae00bb2fea1d7e9953d2da87740c7340ddbe5a2ec... 0.0 \n", "0132bfb1ddb43b86872150aa5d5beb506b2c0547c91d8b5... 0.0 \n", "01a28b44a832a0a35949a680fae963ad86563f389a26356... 0.0 \n", "01b1a76315c3c1bb3b08616eba3e9fd98cb8471a0f7ce5b... 0.0 \n", "01e0e2d91144b15862e929591bfa30f74fb0757e50476e8... 0.0 \n", "023e16af29b004681ac4248606d06658267fe730ba581f0... 0.0 \n", "02463a4dc6a661eeb8607333c2dc3d0a3ec4c9a40d93354... 0.0 \n", "026c164abb5f644eacb3d02798c1571c01713e64d76e725... 0.0 \n", "027b046d6acb430991e79e54e08a5bef371aa35e3be4fe7... 0.0 \n", "02c5eae6ef36dd5886912fdead95a60865309e5abcf0ad1... 0.0 \n", "\n", "item Big Brother & The Holding Company CD \\\n", "transaction_id \n", "00de91ae00bb2fea1d7e9953d2da87740c7340ddbe5a2ec... 0.0 \n", "0132bfb1ddb43b86872150aa5d5beb506b2c0547c91d8b5... 0.0 \n", "01a28b44a832a0a35949a680fae963ad86563f389a26356... 0.0 \n", "01b1a76315c3c1bb3b08616eba3e9fd98cb8471a0f7ce5b... 0.0 \n", "01e0e2d91144b15862e929591bfa30f74fb0757e50476e8... 0.0 \n", "023e16af29b004681ac4248606d06658267fe730ba581f0... 0.0 \n", "02463a4dc6a661eeb8607333c2dc3d0a3ec4c9a40d93354... 0.0 \n", "026c164abb5f644eacb3d02798c1571c01713e64d76e725... 0.0 \n", "027b046d6acb430991e79e54e08a5bef371aa35e3be4fe7... 0.0 \n", "02c5eae6ef36dd5886912fdead95a60865309e5abcf0ad1... 0.0 \n", "\n", "item ... \\\n", "transaction_id ... \n", "00de91ae00bb2fea1d7e9953d2da87740c7340ddbe5a2ec... ... \n", "0132bfb1ddb43b86872150aa5d5beb506b2c0547c91d8b5... ... \n", "01a28b44a832a0a35949a680fae963ad86563f389a26356... ... \n", "01b1a76315c3c1bb3b08616eba3e9fd98cb8471a0f7ce5b... ... \n", "01e0e2d91144b15862e929591bfa30f74fb0757e50476e8... ... \n", "023e16af29b004681ac4248606d06658267fe730ba581f0... ... \n", "02463a4dc6a661eeb8607333c2dc3d0a3ec4c9a40d93354... ... \n", "026c164abb5f644eacb3d02798c1571c01713e64d76e725... ... \n", "027b046d6acb430991e79e54e08a5bef371aa35e3be4fe7... ... \n", "02c5eae6ef36dd5886912fdead95a60865309e5abcf0ad1... ... \n", "\n", "item The Pearl Sessions [2 CD] \\\n", "transaction_id \n", "00de91ae00bb2fea1d7e9953d2da87740c7340ddbe5a2ec... 0.0 \n", "0132bfb1ddb43b86872150aa5d5beb506b2c0547c91d8b5... 0.0 \n", "01a28b44a832a0a35949a680fae963ad86563f389a26356... 0.0 \n", "01b1a76315c3c1bb3b08616eba3e9fd98cb8471a0f7ce5b... 0.0 \n", "01e0e2d91144b15862e929591bfa30f74fb0757e50476e8... 0.0 \n", "023e16af29b004681ac4248606d06658267fe730ba581f0... 0.0 \n", "02463a4dc6a661eeb8607333c2dc3d0a3ec4c9a40d93354... 0.0 \n", "026c164abb5f644eacb3d02798c1571c01713e64d76e725... 0.0 \n", "027b046d6acb430991e79e54e08a5bef371aa35e3be4fe7... 0.0 \n", "02c5eae6ef36dd5886912fdead95a60865309e5abcf0ad1... 0.0 \n", "\n", "item The Very Best Of Janis Joplin [CD] \\\n", "transaction_id \n", "00de91ae00bb2fea1d7e9953d2da87740c7340ddbe5a2ec... 0.0 \n", "0132bfb1ddb43b86872150aa5d5beb506b2c0547c91d8b5... 0.0 \n", "01a28b44a832a0a35949a680fae963ad86563f389a26356... 0.0 \n", "01b1a76315c3c1bb3b08616eba3e9fd98cb8471a0f7ce5b... 0.0 \n", "01e0e2d91144b15862e929591bfa30f74fb0757e50476e8... 0.0 \n", "023e16af29b004681ac4248606d06658267fe730ba581f0... 0.0 \n", "02463a4dc6a661eeb8607333c2dc3d0a3ec4c9a40d93354... 0.0 \n", "026c164abb5f644eacb3d02798c1571c01713e64d76e725... 0.0 \n", "027b046d6acb430991e79e54e08a5bef371aa35e3be4fe7... 0.0 \n", "02c5eae6ef36dd5886912fdead95a60865309e5abcf0ad1... 0.0 \n", "\n", "item Vintage Handbill T-Shirt L \\\n", "transaction_id \n", "00de91ae00bb2fea1d7e9953d2da87740c7340ddbe5a2ec... 0.0 \n", "0132bfb1ddb43b86872150aa5d5beb506b2c0547c91d8b5... 0.0 \n", "01a28b44a832a0a35949a680fae963ad86563f389a26356... 0.0 \n", "01b1a76315c3c1bb3b08616eba3e9fd98cb8471a0f7ce5b... 0.0 \n", "01e0e2d91144b15862e929591bfa30f74fb0757e50476e8... 0.0 \n", "023e16af29b004681ac4248606d06658267fe730ba581f0... 0.0 \n", "02463a4dc6a661eeb8607333c2dc3d0a3ec4c9a40d93354... 0.0 \n", "026c164abb5f644eacb3d02798c1571c01713e64d76e725... 0.0 \n", "027b046d6acb430991e79e54e08a5bef371aa35e3be4fe7... 0.0 \n", "02c5eae6ef36dd5886912fdead95a60865309e5abcf0ad1... 0.0 \n", "\n", "item White Cheap Thrills Cartoon T-Shirt S \\\n", "transaction_id \n", "00de91ae00bb2fea1d7e9953d2da87740c7340ddbe5a2ec... 0.0 \n", "0132bfb1ddb43b86872150aa5d5beb506b2c0547c91d8b5... 0.0 \n", "01a28b44a832a0a35949a680fae963ad86563f389a26356... 0.0 \n", "01b1a76315c3c1bb3b08616eba3e9fd98cb8471a0f7ce5b... 0.0 \n", "01e0e2d91144b15862e929591bfa30f74fb0757e50476e8... 0.0 \n", "023e16af29b004681ac4248606d06658267fe730ba581f0... 0.0 \n", "02463a4dc6a661eeb8607333c2dc3d0a3ec4c9a40d93354... 0.0 \n", "026c164abb5f644eacb3d02798c1571c01713e64d76e725... 0.0 \n", "027b046d6acb430991e79e54e08a5bef371aa35e3be4fe7... 0.0 \n", "02c5eae6ef36dd5886912fdead95a60865309e5abcf0ad1... 0.0 \n", "\n", "item Woodstock - Back To The Garden - 50th Anniversary \\\n", "transaction_id \n", "00de91ae00bb2fea1d7e9953d2da87740c7340ddbe5a2ec... 0.0 \n", "0132bfb1ddb43b86872150aa5d5beb506b2c0547c91d8b5... 0.0 \n", "01a28b44a832a0a35949a680fae963ad86563f389a26356... 0.0 \n", "01b1a76315c3c1bb3b08616eba3e9fd98cb8471a0f7ce5b... 0.0 \n", "01e0e2d91144b15862e929591bfa30f74fb0757e50476e8... 0.0 \n", "023e16af29b004681ac4248606d06658267fe730ba581f0... 0.0 \n", "02463a4dc6a661eeb8607333c2dc3d0a3ec4c9a40d93354... 0.0 \n", "026c164abb5f644eacb3d02798c1571c01713e64d76e725... 0.0 \n", "027b046d6acb430991e79e54e08a5bef371aa35e3be4fe7... 0.0 \n", "02c5eae6ef36dd5886912fdead95a60865309e5abcf0ad1... 0.0 \n", "\n", "item Woodstock – Back To The Garden - 50th Anniversary \\\n", "transaction_id \n", "00de91ae00bb2fea1d7e9953d2da87740c7340ddbe5a2ec... 0.0 \n", "0132bfb1ddb43b86872150aa5d5beb506b2c0547c91d8b5... 0.0 \n", "01a28b44a832a0a35949a680fae963ad86563f389a26356... 0.0 \n", "01b1a76315c3c1bb3b08616eba3e9fd98cb8471a0f7ce5b... 0.0 \n", "01e0e2d91144b15862e929591bfa30f74fb0757e50476e8... 0.0 \n", "023e16af29b004681ac4248606d06658267fe730ba581f0... 0.0 \n", "02463a4dc6a661eeb8607333c2dc3d0a3ec4c9a40d93354... 0.0 \n", "026c164abb5f644eacb3d02798c1571c01713e64d76e725... 0.0 \n", "027b046d6acb430991e79e54e08a5bef371aa35e3be4fe7... 0.0 \n", "02c5eae6ef36dd5886912fdead95a60865309e5abcf0ad1... 0.0 \n", "\n", "item Woodstock – Back To The Garden – The Definitive 5 \\\n", "transaction_id \n", "00de91ae00bb2fea1d7e9953d2da87740c7340ddbe5a2ec... 0.0 \n", "0132bfb1ddb43b86872150aa5d5beb506b2c0547c91d8b5... 0.0 \n", "01a28b44a832a0a35949a680fae963ad86563f389a26356... 0.0 \n", "01b1a76315c3c1bb3b08616eba3e9fd98cb8471a0f7ce5b... 0.0 \n", "01e0e2d91144b15862e929591bfa30f74fb0757e50476e8... 0.0 \n", "023e16af29b004681ac4248606d06658267fe730ba581f0... 0.0 \n", "02463a4dc6a661eeb8607333c2dc3d0a3ec4c9a40d93354... 0.0 \n", "026c164abb5f644eacb3d02798c1571c01713e64d76e725... 0.0 \n", "027b046d6acb430991e79e54e08a5bef371aa35e3be4fe7... 0.0 \n", "02c5eae6ef36dd5886912fdead95a60865309e5abcf0ad1... 0.0 \n", "\n", "item Woodstock — Back To The Garden — 50th Anniversary \\\n", "transaction_id \n", "00de91ae00bb2fea1d7e9953d2da87740c7340ddbe5a2ec... 0.0 \n", "0132bfb1ddb43b86872150aa5d5beb506b2c0547c91d8b5... 0.0 \n", "01a28b44a832a0a35949a680fae963ad86563f389a26356... 0.0 \n", "01b1a76315c3c1bb3b08616eba3e9fd98cb8471a0f7ce5b... 0.0 \n", "01e0e2d91144b15862e929591bfa30f74fb0757e50476e8... 0.0 \n", "023e16af29b004681ac4248606d06658267fe730ba581f0... 0.0 \n", "02463a4dc6a661eeb8607333c2dc3d0a3ec4c9a40d93354... 0.0 \n", "026c164abb5f644eacb3d02798c1571c01713e64d76e725... 0.0 \n", "027b046d6acb430991e79e54e08a5bef371aa35e3be4fe7... 0.0 \n", "02c5eae6ef36dd5886912fdead95a60865309e5abcf0ad1... 0.0 \n", "\n", "item X2 (Pearl/Cheap Thrills) [2CD] \\\n", "transaction_id \n", "00de91ae00bb2fea1d7e9953d2da87740c7340ddbe5a2ec... 0.0 \n", "0132bfb1ddb43b86872150aa5d5beb506b2c0547c91d8b5... 0.0 \n", "01a28b44a832a0a35949a680fae963ad86563f389a26356... 0.0 \n", "01b1a76315c3c1bb3b08616eba3e9fd98cb8471a0f7ce5b... 0.0 \n", "01e0e2d91144b15862e929591bfa30f74fb0757e50476e8... 0.0 \n", "023e16af29b004681ac4248606d06658267fe730ba581f0... 0.0 \n", "02463a4dc6a661eeb8607333c2dc3d0a3ec4c9a40d93354... 0.0 \n", "026c164abb5f644eacb3d02798c1571c01713e64d76e725... 0.0 \n", "027b046d6acb430991e79e54e08a5bef371aa35e3be4fe7... 0.0 \n", "02c5eae6ef36dd5886912fdead95a60865309e5abcf0ad1... 0.0 \n", "\n", "item Zig Zag Man Lithograph \n", "transaction_id \n", "00de91ae00bb2fea1d7e9953d2da87740c7340ddbe5a2ec... 0.0 \n", "0132bfb1ddb43b86872150aa5d5beb506b2c0547c91d8b5... 0.0 \n", "01a28b44a832a0a35949a680fae963ad86563f389a26356... 0.0 \n", "01b1a76315c3c1bb3b08616eba3e9fd98cb8471a0f7ce5b... 0.0 \n", "01e0e2d91144b15862e929591bfa30f74fb0757e50476e8... 0.0 \n", "023e16af29b004681ac4248606d06658267fe730ba581f0... 0.0 \n", "02463a4dc6a661eeb8607333c2dc3d0a3ec4c9a40d93354... 0.0 \n", "026c164abb5f644eacb3d02798c1571c01713e64d76e725... 0.0 \n", "027b046d6acb430991e79e54e08a5bef371aa35e3be4fe7... 0.0 \n", "02c5eae6ef36dd5886912fdead95a60865309e5abcf0ad1... 0.0 \n", "\n", "[10 rows x 308 columns]" ] }, "execution_count": 18, "metadata": {}, "output_type": "execute_result" } ], "source": [ "basket.head(10)" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "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.drop('POSTAGE', inplace=True, axis=1)" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "frequent_itemsets = apriori(basket_sets, min_support=0.07, use_colnames=True)" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "rules = association_rules(frequent_itemsets, metric=\"lift\", min_threshold=1)\n", "rules.head()" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "rules[ (rules['lift'] >= 6) &\n", " (rules['confidence'] >= 0.8) ]" ] }, { "cell_type": "code", "execution_count": 6, "metadata": {}, "outputs": [], "source": [ "%run ./utils.ipynb\n", "engine = get_rds_engine()\n", "schema='ace3c2bb4abd9fcaf9807975e6ab940131386dc9ecddb2b7e31288ff8' # Pixies" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "schema='bd345f915775993a4d3de1dae65b93b067ad69dde4286a1e1639e5cd2'\n", "# IHW query\n", "query = f\"\"\"\n", "select fan_id as transaction_id,\n", "merch_Type as item,\n", "CAST (merch_purchase_quantity AS INTEGER) as count from {schema}.fan_merch_data where\n", "CAST(merch_purchase_monetary AS DOUBLE precision)>0 and\n", "CAST (merch_purchase_quantity AS INTEGER)>0\n", "\"\"\"\n", "df = pd.read_sql(query, engine)\n", "df['item'] = df['item'].str.upper() \n", "print(df.head())\n", "print(df.shape)" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "#Pixies query\n", "query = f\"\"\"\n", "select concat(fan_id,DATE_PART('day', now() - (merch_purchase_date::timestamp))::TEXT) as transaction_id,\n", "case WHEN merch_name like '%% - %%' then substring(merch_name from '(^.+)(( -)|(,))')\n", "else merch_name\n", "end as item,\n", "CAST (merch_purchase_quantity AS INTEGER) as count from {schema}.fan_merch_data_temp where\n", "CAST(merch_item_price AS DOUBLE precision)>0 and\n", "CAST (merch_purchase_quantity AS INTEGER)>0 and merch_purchase_date is not null\n", "\"\"\"\n", "df = pd.read_sql(query, engine)\n", "print(df.head())\n", "print(df.shape)" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "#Pixies query 2 with clusters\n", "query = f\"\"\"\n", "select concat(fan_merch_data_temp.fan_id,DATE_PART('day', now() - (merch_purchase_date::timestamp))::TEXT) as transaction_id,\n", "case WHEN merch_name like '%% - %%' then substring(merch_name from '(^.+)(( -)|(,))')\n", "else merch_name\n", "end as item,\n", "CAST (merch_purchase_quantity AS INTEGER) as count from {schema}.fan_merch_data_temp inner join\n", "{schema}.merch_clusters on merch_clusters.fan_id=fan_merch_data_temp.fan_id where\n", "CAST(merch_item_price AS DOUBLE precision)>0 and\n", "CAST (merch_purchase_quantity AS INTEGER)>0 and merch_purchase_date is not null\n", "and cluster in (2,6)\n", "\"\"\"\n", "df = pd.read_sql(query, engine)\n", "print(df.head())\n", "print(df.shape)" ] }, { "cell_type": "code", "execution_count": 19, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ " transaction_id item count\n", "0 00de91ae00bb2fea1d7e9953d2da87740c7340ddbe5a2e... Print Item 1\n", "1 0132bfb1ddb43b86872150aa5d5beb506b2c0547c91d8b... Wmns Apprl 1\n", "2 01a28b44a832a0a35949a680fae963ad86563f389a2635... Unisx Appl 1\n", "3 01b1a76315c3c1bb3b08616eba3e9fd98cb8471a0f7ce5... AV Media 2\n", "4 01e0e2d91144b15862e929591bfa30f74fb0757e50476e... Unisx Appl 1\n", "(1396, 3)\n" ] } ], "source": [ "#JJ query\n", "schema=\"af65a0ef98e7420800afdea2beb81059bde2bc59d797cc0851412ac41\"\n", "query = f\"\"\"\n", "select concat(fan_id,DATE_PART('day', now() - (merch_purchase_date::timestamp))::TEXT) as transaction_id,\n", "merch_type as item,\n", "CAST (merch_purchase_quantity AS INTEGER) as count from {schema}.fan_merch_data where\n", "CAST(merch_item_price AS DOUBLE precision)>0 and\n", "CAST (merch_purchase_quantity AS INTEGER)>0 and merch_purchase_date is not null\n", "\"\"\"\n", "df = pd.read_sql(query, engine)\n", "print(df.head())\n", "print(df.shape)" ] }, { "cell_type": "code", "execution_count": 20, "metadata": {}, "outputs": [], "source": [ "basket = df.groupby(['transaction_id', 'item'])['count'].sum().unstack().reset_index().fillna(0).set_index('transaction_id')" ] }, { "cell_type": "code", "execution_count": 21, "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", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
itemAV MediaAV MediaAsst MerchAsst MerchJewelryJewelryKids ApprlMemorabiliMens ApprlMens ApprlNoncatwearPrint ItemPrint ItemSmallStuffUnisx ApplUnisx ApplWmns ApprlWmns Apprl
transaction_id
00de91ae00bb2fea1d7e9953d2da87740c7340ddbe5a2ecc0f91125ea149696a2350.00.00.00.00.00.00.00.00.00.00.00.01.00.00.00.00.00.0
0132bfb1ddb43b86872150aa5d5beb506b2c0547c91d8b56259424eb969330e73420.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.01.0
01a28b44a832a0a35949a680fae963ad86563f389a263561f76cb5bfbbb03cf13340.00.00.00.00.00.00.00.00.00.00.00.00.00.01.00.00.00.0
01b1a76315c3c1bb3b08616eba3e9fd98cb8471a0f7ce5b45a9b27ebd06ab1504620.02.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0
01e0e2d91144b15862e929591bfa30f74fb0757e50476e8b09e6cabd73525f0b1870.00.00.00.00.00.00.00.00.00.00.00.00.00.02.00.00.00.0
023e16af29b004681ac4248606d06658267fe730ba581f0a9091aee4b880d2681790.00.00.00.00.00.00.00.00.00.00.00.00.00.01.00.00.00.0
02463a4dc6a661eeb8607333c2dc3d0a3ec4c9a40d933540051e04a756d0657a4550.00.00.00.00.00.00.00.00.00.00.00.00.00.01.00.00.00.0
026c164abb5f644eacb3d02798c1571c01713e64d76e72573fb0b6131fc1a4b0230.00.00.00.00.00.00.00.00.00.00.00.01.00.00.00.00.00.0
027b046d6acb430991e79e54e08a5bef371aa35e3be4fe7b196788bb66c5f3fe1140.00.00.00.00.00.00.00.00.00.00.00.01.00.00.00.00.00.0
02c5eae6ef36dd5886912fdead95a60865309e5abcf0ad100632d1d9632d75983330.00.00.04.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0
02d5efb4f7a7ed421530724c7318523511635c02aa0578c4267a0f049ac35c9c740.01.00.00.00.00.00.00.00.00.00.00.02.00.00.00.00.00.0
02f218e640b27885de2ccdb7c3f22a2acb9a296a012505b4ad6cec78b99d16bb2730.00.00.00.00.00.00.00.00.00.00.00.01.00.01.00.00.00.0
030102e337802b33a467fa3fa2f433c2d51f14718943c57d938613b34bcd0bee2960.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.01.00.0
03978b65107fe576a1bba38f76d41e71297eec5f58ee113d4605ba5676d69d6d2250.00.00.00.00.00.00.00.00.00.00.00.01.00.00.00.00.00.0
03b0c44873c147ca39167e0ca031f836ffe47cca7b66c82bb05e34bff8f8bb6b4330.00.00.00.00.00.00.00.00.00.00.00.00.00.01.00.00.01.0
040f584138f13122be9de6803bca77edbf396471e8d17677796e107173f7329a180.00.00.00.00.00.00.00.00.00.00.00.01.00.01.02.00.00.0
04194617a57a88bdb5eea3038ab6a40bac6f9751373efcc96c7953b32ce226782210.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.01.00.0
041d27961b44602fa01fc6b758195ed73d6d106efa3c332d30b8dc12654ec63e630.00.00.00.00.00.00.00.00.00.03.00.00.00.00.00.00.00.0
043051b1d8db2a9d2e51ccbb432feb7648574e67e79c3e670ee9695b48ac0c001070.00.00.00.00.00.00.00.00.00.00.00.01.00.00.00.00.00.0
043051b1d8db2a9d2e51ccbb432feb7648574e67e79c3e670ee9695b48ac0c001990.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.01.00.0
043051b1d8db2a9d2e51ccbb432feb7648574e67e79c3e670ee9695b48ac0c00200.00.00.01.00.00.00.00.00.00.00.00.00.00.00.00.00.01.0
048af26f61363f8863f847f69ec338ba1a5b13bf4d99b0857a89a8722ae32b602590.01.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0
0497476bd0bbbcdd0bba1ee900079a7ec876954ac2140c945c61470fe700409d720.00.00.00.00.01.00.00.00.00.00.00.00.00.01.00.00.01.0
04cbdf2eb46e941754bbf230db51b76258d556c1cc57bb5b2be1dd6bd31cbb59550.00.01.00.00.00.00.00.00.00.01.00.00.00.00.00.00.00.0
04d71a14825027e0454445d8f090c17e07806d6bf0592e31cd6b256f5c833718520.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.01.01.0
05bbaa2c91ce9d45eb654cbbb94071dcfeb16656dd4bad163cc5b0d1b03ea49c550.00.00.01.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0
05d7cf732a82c475b56ffddf6bbfdc12180e3faf29c72e89b4c68c41d76dbd68650.00.00.00.00.00.00.00.00.00.01.00.00.00.00.00.00.00.0
05e1efce4d5e538cff3f0fc9439c0e6e2ef2f1420b21b1d3723337a8954a323a510.00.00.00.00.00.00.00.00.00.00.00.00.00.02.00.00.00.0
06262d3c9daef003c19dbfb3b9c9f6976d9c190e4a455a5bccf0d9d5ee70b9b14430.00.01.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0
065346df86cf995e2d22782120e05422e955070a4c06511a99d1e69aba3b875d230.00.00.00.00.00.00.00.00.00.00.00.00.01.00.00.00.00.0
.........................................................
faeaafabb538ca92e3c6226c775a97a5b3b336ddcb41fa6088fea08210fea8554620.01.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0
fb10289594bb1da49eb3241022628ad3ec6a24cdb90081281028f83b291a773c3550.00.00.01.00.00.00.00.00.00.00.00.00.00.01.00.00.00.0
fb26c5d622129e969e2fa17ac1ef130231b6894ee309b4ca935810115d8e90a33070.00.00.00.00.00.00.00.00.00.00.00.01.00.00.00.00.00.0
fb26c5d622129e969e2fa17ac1ef130231b6894ee309b4ca935810115d8e90a33240.00.00.00.00.00.00.00.00.00.00.00.00.00.01.00.00.00.0
fb26c5d622129e969e2fa17ac1ef130231b6894ee309b4ca935810115d8e90a33540.00.00.00.00.01.00.00.00.00.00.00.00.00.00.00.00.00.0
fb27439e6959b435aec64aadf34df15948b086c9e4df2358756fbb54ecb87488650.00.00.00.00.00.00.00.00.00.01.00.00.00.00.00.00.00.0
fb513c34a472046a10ec14b8f9a5c6de55e3e30ecac5221eda9b81cda4cc4e52750.00.00.00.00.00.00.00.00.00.00.00.00.00.01.00.00.00.0
fbaa5a96fa9860917ba9a6eb4ce5c2001b18c330afd4a743acb8fbee9262e5fd3470.00.00.00.00.01.00.00.00.00.00.00.00.00.00.00.00.00.0
fbd145967d33641676baa21832c06f5fd3268bec3b0133fa63df3b4d6b6677a1690.00.00.00.00.00.00.00.00.00.00.00.00.00.00.01.00.00.0
fbd7080dea62e2e47b21dc9a2d2488a8b045f36c6137222d7b082a6be0ba11aa3940.00.00.00.00.00.00.00.00.00.00.00.01.00.00.00.00.00.0
fbed55eef282ecf6bea8f3bbeac967e2b859fca5239947ad0a18b87ec5428ad44860.00.00.00.00.00.00.00.00.00.00.00.00.00.01.00.00.00.0
fbef1f2eefbb380721d1b908a45c7bdf84a2dad2f34d49b31e8cae14b2a30df82330.00.00.00.00.00.00.00.00.00.00.00.00.00.01.00.00.00.0
fc93cc3a74e99fc5325b951abeba1fc142ce354c5824601bd5fc320fec44ddda4840.01.00.04.00.00.00.00.00.00.00.00.00.00.01.02.00.00.0
fcd76f264472c9ee6727bf1bcb418a51880e020ba12127fb5bc60c6ece858528120.02.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0
fcd76f264472c9ee6727bf1bcb418a51880e020ba12127fb5bc60c6ece8585282010.02.00.00.00.00.00.00.00.00.00.00.00.00.00.01.00.00.0
fceb27bb78f34e82bee2d1b1362ff27207828979e201e64c7ea4b49658f056c42260.00.00.01.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0
fcf6564d2a10dd392a376aa23ff6ac19846fc8f5564beb1daa3a36432883d7753960.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.01.0
fda422842e8e6bf0cc291d048b792d76a293c021319f588015c442faf5d97df51060.00.00.00.00.00.00.00.00.00.00.00.00.00.01.00.00.00.0
fdbde899b8f6b58595afb42de2337ecfcb066481f848f9f68dee5ab65d47db9e2270.00.01.01.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0
fdca2182a7ca43056ccc3a8cf95567396468ddcca1e6fd606e8a87976f07b66f3010.00.00.00.00.00.00.00.00.00.00.00.00.00.01.00.00.00.0
fdd431cab47cf62c4be70e4e05bbd48001edf641c1136c40474457271cc473b22260.00.00.00.00.00.00.00.00.00.00.00.00.00.02.00.00.00.0
fe26e5d679dc1f6a733c8bfa9e7337501d5d127a21a337d58fdb1923ff981264860.00.00.00.00.00.00.00.00.01.00.00.00.00.00.00.00.00.0
fe33c5a8da4dcefc16d5db744a5f18d898805996de2016aee0ea746df9b93408380.00.00.00.01.00.00.00.00.00.00.00.00.00.00.00.00.00.0
fe7a693c020f03fa62e704e29d0db643248426fca3df6b4f80facb7a8889c8ef4620.01.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0
fe943a72a4b8ce3a4e5b42511ed72f53e241a3630ef4343a3eaea0e1ea031eed170.00.00.00.00.00.00.00.00.00.00.00.00.00.01.00.00.00.0
fe943a72a4b8ce3a4e5b42511ed72f53e241a3630ef4343a3eaea0e1ea031eed3420.00.00.00.00.00.00.00.00.00.00.00.00.00.01.00.00.00.0
fed9a9b0dcbeba81cf56c5b9963cced64f7827a554a0598fdaf0054e70c92e982120.01.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0
fef709daecdf01a6164df79083f8a55c2c32f939d0f7199a1dffe754e4163b712710.00.00.00.00.00.00.00.00.00.00.00.01.00.00.00.00.00.0
ff5f650c4fc31086d3b9ea116434ab284714ac317249153ee0cb96426391ac6d4430.01.00.01.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0
ffb521745ac8de7c4715080c46451472f0567736e1206d83b7da5a0c6320f085650.00.00.00.00.00.00.00.00.00.01.00.00.00.00.00.00.00.0
\n", "

998 rows × 18 columns

\n", "
" ], "text/plain": [ "item AV Media AV Media \\\n", "transaction_id \n", "00de91ae00bb2fea1d7e9953d2da87740c7340ddbe5a2ec... 0.0 0.0 \n", "0132bfb1ddb43b86872150aa5d5beb506b2c0547c91d8b5... 0.0 0.0 \n", "01a28b44a832a0a35949a680fae963ad86563f389a26356... 0.0 0.0 \n", "01b1a76315c3c1bb3b08616eba3e9fd98cb8471a0f7ce5b... 0.0 2.0 \n", "01e0e2d91144b15862e929591bfa30f74fb0757e50476e8... 0.0 0.0 \n", "023e16af29b004681ac4248606d06658267fe730ba581f0... 0.0 0.0 \n", "02463a4dc6a661eeb8607333c2dc3d0a3ec4c9a40d93354... 0.0 0.0 \n", "026c164abb5f644eacb3d02798c1571c01713e64d76e725... 0.0 0.0 \n", "027b046d6acb430991e79e54e08a5bef371aa35e3be4fe7... 0.0 0.0 \n", "02c5eae6ef36dd5886912fdead95a60865309e5abcf0ad1... 0.0 0.0 \n", "02d5efb4f7a7ed421530724c7318523511635c02aa0578c... 0.0 1.0 \n", "02f218e640b27885de2ccdb7c3f22a2acb9a296a012505b... 0.0 0.0 \n", "030102e337802b33a467fa3fa2f433c2d51f14718943c57... 0.0 0.0 \n", "03978b65107fe576a1bba38f76d41e71297eec5f58ee113... 0.0 0.0 \n", "03b0c44873c147ca39167e0ca031f836ffe47cca7b66c82... 0.0 0.0 \n", "040f584138f13122be9de6803bca77edbf396471e8d1767... 0.0 0.0 \n", "04194617a57a88bdb5eea3038ab6a40bac6f9751373efcc... 0.0 0.0 \n", "041d27961b44602fa01fc6b758195ed73d6d106efa3c332... 0.0 0.0 \n", "043051b1d8db2a9d2e51ccbb432feb7648574e67e79c3e6... 0.0 0.0 \n", "043051b1d8db2a9d2e51ccbb432feb7648574e67e79c3e6... 0.0 0.0 \n", "043051b1d8db2a9d2e51ccbb432feb7648574e67e79c3e6... 0.0 0.0 \n", "048af26f61363f8863f847f69ec338ba1a5b13bf4d99b08... 0.0 1.0 \n", "0497476bd0bbbcdd0bba1ee900079a7ec876954ac2140c9... 0.0 0.0 \n", "04cbdf2eb46e941754bbf230db51b76258d556c1cc57bb5... 0.0 0.0 \n", "04d71a14825027e0454445d8f090c17e07806d6bf0592e3... 0.0 0.0 \n", "05bbaa2c91ce9d45eb654cbbb94071dcfeb16656dd4bad1... 0.0 0.0 \n", "05d7cf732a82c475b56ffddf6bbfdc12180e3faf29c72e8... 0.0 0.0 \n", "05e1efce4d5e538cff3f0fc9439c0e6e2ef2f1420b21b1d... 0.0 0.0 \n", "06262d3c9daef003c19dbfb3b9c9f6976d9c190e4a455a5... 0.0 0.0 \n", "065346df86cf995e2d22782120e05422e955070a4c06511... 0.0 0.0 \n", "... ... ... \n", "faeaafabb538ca92e3c6226c775a97a5b3b336ddcb41fa6... 0.0 1.0 \n", "fb10289594bb1da49eb3241022628ad3ec6a24cdb900812... 0.0 0.0 \n", "fb26c5d622129e969e2fa17ac1ef130231b6894ee309b4c... 0.0 0.0 \n", "fb26c5d622129e969e2fa17ac1ef130231b6894ee309b4c... 0.0 0.0 \n", "fb26c5d622129e969e2fa17ac1ef130231b6894ee309b4c... 0.0 0.0 \n", "fb27439e6959b435aec64aadf34df15948b086c9e4df235... 0.0 0.0 \n", "fb513c34a472046a10ec14b8f9a5c6de55e3e30ecac5221... 0.0 0.0 \n", "fbaa5a96fa9860917ba9a6eb4ce5c2001b18c330afd4a74... 0.0 0.0 \n", "fbd145967d33641676baa21832c06f5fd3268bec3b0133f... 0.0 0.0 \n", "fbd7080dea62e2e47b21dc9a2d2488a8b045f36c6137222... 0.0 0.0 \n", "fbed55eef282ecf6bea8f3bbeac967e2b859fca5239947a... 0.0 0.0 \n", "fbef1f2eefbb380721d1b908a45c7bdf84a2dad2f34d49b... 0.0 0.0 \n", "fc93cc3a74e99fc5325b951abeba1fc142ce354c5824601... 0.0 1.0 \n", "fcd76f264472c9ee6727bf1bcb418a51880e020ba12127f... 0.0 2.0 \n", "fcd76f264472c9ee6727bf1bcb418a51880e020ba12127f... 0.0 2.0 \n", "fceb27bb78f34e82bee2d1b1362ff27207828979e201e64... 0.0 0.0 \n", "fcf6564d2a10dd392a376aa23ff6ac19846fc8f5564beb1... 0.0 0.0 \n", "fda422842e8e6bf0cc291d048b792d76a293c021319f588... 0.0 0.0 \n", "fdbde899b8f6b58595afb42de2337ecfcb066481f848f9f... 0.0 0.0 \n", "fdca2182a7ca43056ccc3a8cf95567396468ddcca1e6fd6... 0.0 0.0 \n", "fdd431cab47cf62c4be70e4e05bbd48001edf641c1136c4... 0.0 0.0 \n", "fe26e5d679dc1f6a733c8bfa9e7337501d5d127a21a337d... 0.0 0.0 \n", "fe33c5a8da4dcefc16d5db744a5f18d898805996de2016a... 0.0 0.0 \n", "fe7a693c020f03fa62e704e29d0db643248426fca3df6b4... 0.0 1.0 \n", "fe943a72a4b8ce3a4e5b42511ed72f53e241a3630ef4343... 0.0 0.0 \n", "fe943a72a4b8ce3a4e5b42511ed72f53e241a3630ef4343... 0.0 0.0 \n", "fed9a9b0dcbeba81cf56c5b9963cced64f7827a554a0598... 0.0 1.0 \n", "fef709daecdf01a6164df79083f8a55c2c32f939d0f7199... 0.0 0.0 \n", "ff5f650c4fc31086d3b9ea116434ab284714ac317249153... 0.0 1.0 \n", "ffb521745ac8de7c4715080c46451472f0567736e1206d8... 0.0 0.0 \n", "\n", "item Asst Merch Asst Merch \\\n", "transaction_id \n", "00de91ae00bb2fea1d7e9953d2da87740c7340ddbe5a2ec... 0.0 0.0 \n", "0132bfb1ddb43b86872150aa5d5beb506b2c0547c91d8b5... 0.0 0.0 \n", "01a28b44a832a0a35949a680fae963ad86563f389a26356... 0.0 0.0 \n", "01b1a76315c3c1bb3b08616eba3e9fd98cb8471a0f7ce5b... 0.0 0.0 \n", "01e0e2d91144b15862e929591bfa30f74fb0757e50476e8... 0.0 0.0 \n", "023e16af29b004681ac4248606d06658267fe730ba581f0... 0.0 0.0 \n", "02463a4dc6a661eeb8607333c2dc3d0a3ec4c9a40d93354... 0.0 0.0 \n", "026c164abb5f644eacb3d02798c1571c01713e64d76e725... 0.0 0.0 \n", "027b046d6acb430991e79e54e08a5bef371aa35e3be4fe7... 0.0 0.0 \n", "02c5eae6ef36dd5886912fdead95a60865309e5abcf0ad1... 0.0 4.0 \n", "02d5efb4f7a7ed421530724c7318523511635c02aa0578c... 0.0 0.0 \n", "02f218e640b27885de2ccdb7c3f22a2acb9a296a012505b... 0.0 0.0 \n", "030102e337802b33a467fa3fa2f433c2d51f14718943c57... 0.0 0.0 \n", "03978b65107fe576a1bba38f76d41e71297eec5f58ee113... 0.0 0.0 \n", "03b0c44873c147ca39167e0ca031f836ffe47cca7b66c82... 0.0 0.0 \n", "040f584138f13122be9de6803bca77edbf396471e8d1767... 0.0 0.0 \n", "04194617a57a88bdb5eea3038ab6a40bac6f9751373efcc... 0.0 0.0 \n", "041d27961b44602fa01fc6b758195ed73d6d106efa3c332... 0.0 0.0 \n", "043051b1d8db2a9d2e51ccbb432feb7648574e67e79c3e6... 0.0 0.0 \n", "043051b1d8db2a9d2e51ccbb432feb7648574e67e79c3e6... 0.0 0.0 \n", "043051b1d8db2a9d2e51ccbb432feb7648574e67e79c3e6... 0.0 1.0 \n", "048af26f61363f8863f847f69ec338ba1a5b13bf4d99b08... 0.0 0.0 \n", "0497476bd0bbbcdd0bba1ee900079a7ec876954ac2140c9... 0.0 0.0 \n", "04cbdf2eb46e941754bbf230db51b76258d556c1cc57bb5... 1.0 0.0 \n", "04d71a14825027e0454445d8f090c17e07806d6bf0592e3... 0.0 0.0 \n", "05bbaa2c91ce9d45eb654cbbb94071dcfeb16656dd4bad1... 0.0 1.0 \n", "05d7cf732a82c475b56ffddf6bbfdc12180e3faf29c72e8... 0.0 0.0 \n", "05e1efce4d5e538cff3f0fc9439c0e6e2ef2f1420b21b1d... 0.0 0.0 \n", "06262d3c9daef003c19dbfb3b9c9f6976d9c190e4a455a5... 1.0 0.0 \n", "065346df86cf995e2d22782120e05422e955070a4c06511... 0.0 0.0 \n", "... ... ... \n", "faeaafabb538ca92e3c6226c775a97a5b3b336ddcb41fa6... 0.0 0.0 \n", "fb10289594bb1da49eb3241022628ad3ec6a24cdb900812... 0.0 1.0 \n", "fb26c5d622129e969e2fa17ac1ef130231b6894ee309b4c... 0.0 0.0 \n", "fb26c5d622129e969e2fa17ac1ef130231b6894ee309b4c... 0.0 0.0 \n", "fb26c5d622129e969e2fa17ac1ef130231b6894ee309b4c... 0.0 0.0 \n", "fb27439e6959b435aec64aadf34df15948b086c9e4df235... 0.0 0.0 \n", "fb513c34a472046a10ec14b8f9a5c6de55e3e30ecac5221... 0.0 0.0 \n", "fbaa5a96fa9860917ba9a6eb4ce5c2001b18c330afd4a74... 0.0 0.0 \n", "fbd145967d33641676baa21832c06f5fd3268bec3b0133f... 0.0 0.0 \n", "fbd7080dea62e2e47b21dc9a2d2488a8b045f36c6137222... 0.0 0.0 \n", "fbed55eef282ecf6bea8f3bbeac967e2b859fca5239947a... 0.0 0.0 \n", "fbef1f2eefbb380721d1b908a45c7bdf84a2dad2f34d49b... 0.0 0.0 \n", "fc93cc3a74e99fc5325b951abeba1fc142ce354c5824601... 0.0 4.0 \n", "fcd76f264472c9ee6727bf1bcb418a51880e020ba12127f... 0.0 0.0 \n", "fcd76f264472c9ee6727bf1bcb418a51880e020ba12127f... 0.0 0.0 \n", "fceb27bb78f34e82bee2d1b1362ff27207828979e201e64... 0.0 1.0 \n", "fcf6564d2a10dd392a376aa23ff6ac19846fc8f5564beb1... 0.0 0.0 \n", "fda422842e8e6bf0cc291d048b792d76a293c021319f588... 0.0 0.0 \n", "fdbde899b8f6b58595afb42de2337ecfcb066481f848f9f... 1.0 1.0 \n", "fdca2182a7ca43056ccc3a8cf95567396468ddcca1e6fd6... 0.0 0.0 \n", "fdd431cab47cf62c4be70e4e05bbd48001edf641c1136c4... 0.0 0.0 \n", "fe26e5d679dc1f6a733c8bfa9e7337501d5d127a21a337d... 0.0 0.0 \n", "fe33c5a8da4dcefc16d5db744a5f18d898805996de2016a... 0.0 0.0 \n", "fe7a693c020f03fa62e704e29d0db643248426fca3df6b4... 0.0 0.0 \n", "fe943a72a4b8ce3a4e5b42511ed72f53e241a3630ef4343... 0.0 0.0 \n", "fe943a72a4b8ce3a4e5b42511ed72f53e241a3630ef4343... 0.0 0.0 \n", "fed9a9b0dcbeba81cf56c5b9963cced64f7827a554a0598... 0.0 0.0 \n", "fef709daecdf01a6164df79083f8a55c2c32f939d0f7199... 0.0 0.0 \n", "ff5f650c4fc31086d3b9ea116434ab284714ac317249153... 0.0 1.0 \n", "ffb521745ac8de7c4715080c46451472f0567736e1206d8... 0.0 0.0 \n", "\n", "item Jewelry Jewelry \\\n", "transaction_id \n", "00de91ae00bb2fea1d7e9953d2da87740c7340ddbe5a2ec... 0.0 0.0 \n", "0132bfb1ddb43b86872150aa5d5beb506b2c0547c91d8b5... 0.0 0.0 \n", "01a28b44a832a0a35949a680fae963ad86563f389a26356... 0.0 0.0 \n", "01b1a76315c3c1bb3b08616eba3e9fd98cb8471a0f7ce5b... 0.0 0.0 \n", "01e0e2d91144b15862e929591bfa30f74fb0757e50476e8... 0.0 0.0 \n", "023e16af29b004681ac4248606d06658267fe730ba581f0... 0.0 0.0 \n", "02463a4dc6a661eeb8607333c2dc3d0a3ec4c9a40d93354... 0.0 0.0 \n", "026c164abb5f644eacb3d02798c1571c01713e64d76e725... 0.0 0.0 \n", "027b046d6acb430991e79e54e08a5bef371aa35e3be4fe7... 0.0 0.0 \n", "02c5eae6ef36dd5886912fdead95a60865309e5abcf0ad1... 0.0 0.0 \n", "02d5efb4f7a7ed421530724c7318523511635c02aa0578c... 0.0 0.0 \n", "02f218e640b27885de2ccdb7c3f22a2acb9a296a012505b... 0.0 0.0 \n", "030102e337802b33a467fa3fa2f433c2d51f14718943c57... 0.0 0.0 \n", "03978b65107fe576a1bba38f76d41e71297eec5f58ee113... 0.0 0.0 \n", "03b0c44873c147ca39167e0ca031f836ffe47cca7b66c82... 0.0 0.0 \n", "040f584138f13122be9de6803bca77edbf396471e8d1767... 0.0 0.0 \n", "04194617a57a88bdb5eea3038ab6a40bac6f9751373efcc... 0.0 0.0 \n", "041d27961b44602fa01fc6b758195ed73d6d106efa3c332... 0.0 0.0 \n", "043051b1d8db2a9d2e51ccbb432feb7648574e67e79c3e6... 0.0 0.0 \n", "043051b1d8db2a9d2e51ccbb432feb7648574e67e79c3e6... 0.0 0.0 \n", "043051b1d8db2a9d2e51ccbb432feb7648574e67e79c3e6... 0.0 0.0 \n", "048af26f61363f8863f847f69ec338ba1a5b13bf4d99b08... 0.0 0.0 \n", "0497476bd0bbbcdd0bba1ee900079a7ec876954ac2140c9... 0.0 1.0 \n", "04cbdf2eb46e941754bbf230db51b76258d556c1cc57bb5... 0.0 0.0 \n", "04d71a14825027e0454445d8f090c17e07806d6bf0592e3... 0.0 0.0 \n", "05bbaa2c91ce9d45eb654cbbb94071dcfeb16656dd4bad1... 0.0 0.0 \n", "05d7cf732a82c475b56ffddf6bbfdc12180e3faf29c72e8... 0.0 0.0 \n", "05e1efce4d5e538cff3f0fc9439c0e6e2ef2f1420b21b1d... 0.0 0.0 \n", "06262d3c9daef003c19dbfb3b9c9f6976d9c190e4a455a5... 0.0 0.0 \n", "065346df86cf995e2d22782120e05422e955070a4c06511... 0.0 0.0 \n", "... ... ... \n", "faeaafabb538ca92e3c6226c775a97a5b3b336ddcb41fa6... 0.0 0.0 \n", "fb10289594bb1da49eb3241022628ad3ec6a24cdb900812... 0.0 0.0 \n", "fb26c5d622129e969e2fa17ac1ef130231b6894ee309b4c... 0.0 0.0 \n", "fb26c5d622129e969e2fa17ac1ef130231b6894ee309b4c... 0.0 0.0 \n", "fb26c5d622129e969e2fa17ac1ef130231b6894ee309b4c... 0.0 1.0 \n", "fb27439e6959b435aec64aadf34df15948b086c9e4df235... 0.0 0.0 \n", "fb513c34a472046a10ec14b8f9a5c6de55e3e30ecac5221... 0.0 0.0 \n", "fbaa5a96fa9860917ba9a6eb4ce5c2001b18c330afd4a74... 0.0 1.0 \n", "fbd145967d33641676baa21832c06f5fd3268bec3b0133f... 0.0 0.0 \n", "fbd7080dea62e2e47b21dc9a2d2488a8b045f36c6137222... 0.0 0.0 \n", "fbed55eef282ecf6bea8f3bbeac967e2b859fca5239947a... 0.0 0.0 \n", "fbef1f2eefbb380721d1b908a45c7bdf84a2dad2f34d49b... 0.0 0.0 \n", "fc93cc3a74e99fc5325b951abeba1fc142ce354c5824601... 0.0 0.0 \n", "fcd76f264472c9ee6727bf1bcb418a51880e020ba12127f... 0.0 0.0 \n", "fcd76f264472c9ee6727bf1bcb418a51880e020ba12127f... 0.0 0.0 \n", "fceb27bb78f34e82bee2d1b1362ff27207828979e201e64... 0.0 0.0 \n", "fcf6564d2a10dd392a376aa23ff6ac19846fc8f5564beb1... 0.0 0.0 \n", "fda422842e8e6bf0cc291d048b792d76a293c021319f588... 0.0 0.0 \n", "fdbde899b8f6b58595afb42de2337ecfcb066481f848f9f... 0.0 0.0 \n", "fdca2182a7ca43056ccc3a8cf95567396468ddcca1e6fd6... 0.0 0.0 \n", "fdd431cab47cf62c4be70e4e05bbd48001edf641c1136c4... 0.0 0.0 \n", "fe26e5d679dc1f6a733c8bfa9e7337501d5d127a21a337d... 0.0 0.0 \n", "fe33c5a8da4dcefc16d5db744a5f18d898805996de2016a... 1.0 0.0 \n", "fe7a693c020f03fa62e704e29d0db643248426fca3df6b4... 0.0 0.0 \n", "fe943a72a4b8ce3a4e5b42511ed72f53e241a3630ef4343... 0.0 0.0 \n", "fe943a72a4b8ce3a4e5b42511ed72f53e241a3630ef4343... 0.0 0.0 \n", "fed9a9b0dcbeba81cf56c5b9963cced64f7827a554a0598... 0.0 0.0 \n", "fef709daecdf01a6164df79083f8a55c2c32f939d0f7199... 0.0 0.0 \n", "ff5f650c4fc31086d3b9ea116434ab284714ac317249153... 0.0 0.0 \n", "ffb521745ac8de7c4715080c46451472f0567736e1206d8... 0.0 0.0 \n", "\n", "item Kids Apprl Memorabili \\\n", "transaction_id \n", "00de91ae00bb2fea1d7e9953d2da87740c7340ddbe5a2ec... 0.0 0.0 \n", "0132bfb1ddb43b86872150aa5d5beb506b2c0547c91d8b5... 0.0 0.0 \n", "01a28b44a832a0a35949a680fae963ad86563f389a26356... 0.0 0.0 \n", "01b1a76315c3c1bb3b08616eba3e9fd98cb8471a0f7ce5b... 0.0 0.0 \n", "01e0e2d91144b15862e929591bfa30f74fb0757e50476e8... 0.0 0.0 \n", "023e16af29b004681ac4248606d06658267fe730ba581f0... 0.0 0.0 \n", "02463a4dc6a661eeb8607333c2dc3d0a3ec4c9a40d93354... 0.0 0.0 \n", "026c164abb5f644eacb3d02798c1571c01713e64d76e725... 0.0 0.0 \n", "027b046d6acb430991e79e54e08a5bef371aa35e3be4fe7... 0.0 0.0 \n", "02c5eae6ef36dd5886912fdead95a60865309e5abcf0ad1... 0.0 0.0 \n", "02d5efb4f7a7ed421530724c7318523511635c02aa0578c... 0.0 0.0 \n", "02f218e640b27885de2ccdb7c3f22a2acb9a296a012505b... 0.0 0.0 \n", "030102e337802b33a467fa3fa2f433c2d51f14718943c57... 0.0 0.0 \n", "03978b65107fe576a1bba38f76d41e71297eec5f58ee113... 0.0 0.0 \n", "03b0c44873c147ca39167e0ca031f836ffe47cca7b66c82... 0.0 0.0 \n", "040f584138f13122be9de6803bca77edbf396471e8d1767... 0.0 0.0 \n", "04194617a57a88bdb5eea3038ab6a40bac6f9751373efcc... 0.0 0.0 \n", "041d27961b44602fa01fc6b758195ed73d6d106efa3c332... 0.0 0.0 \n", "043051b1d8db2a9d2e51ccbb432feb7648574e67e79c3e6... 0.0 0.0 \n", "043051b1d8db2a9d2e51ccbb432feb7648574e67e79c3e6... 0.0 0.0 \n", "043051b1d8db2a9d2e51ccbb432feb7648574e67e79c3e6... 0.0 0.0 \n", "048af26f61363f8863f847f69ec338ba1a5b13bf4d99b08... 0.0 0.0 \n", "0497476bd0bbbcdd0bba1ee900079a7ec876954ac2140c9... 0.0 0.0 \n", "04cbdf2eb46e941754bbf230db51b76258d556c1cc57bb5... 0.0 0.0 \n", "04d71a14825027e0454445d8f090c17e07806d6bf0592e3... 0.0 0.0 \n", "05bbaa2c91ce9d45eb654cbbb94071dcfeb16656dd4bad1... 0.0 0.0 \n", "05d7cf732a82c475b56ffddf6bbfdc12180e3faf29c72e8... 0.0 0.0 \n", "05e1efce4d5e538cff3f0fc9439c0e6e2ef2f1420b21b1d... 0.0 0.0 \n", "06262d3c9daef003c19dbfb3b9c9f6976d9c190e4a455a5... 0.0 0.0 \n", "065346df86cf995e2d22782120e05422e955070a4c06511... 0.0 0.0 \n", "... ... ... \n", "faeaafabb538ca92e3c6226c775a97a5b3b336ddcb41fa6... 0.0 0.0 \n", "fb10289594bb1da49eb3241022628ad3ec6a24cdb900812... 0.0 0.0 \n", "fb26c5d622129e969e2fa17ac1ef130231b6894ee309b4c... 0.0 0.0 \n", "fb26c5d622129e969e2fa17ac1ef130231b6894ee309b4c... 0.0 0.0 \n", "fb26c5d622129e969e2fa17ac1ef130231b6894ee309b4c... 0.0 0.0 \n", "fb27439e6959b435aec64aadf34df15948b086c9e4df235... 0.0 0.0 \n", "fb513c34a472046a10ec14b8f9a5c6de55e3e30ecac5221... 0.0 0.0 \n", "fbaa5a96fa9860917ba9a6eb4ce5c2001b18c330afd4a74... 0.0 0.0 \n", "fbd145967d33641676baa21832c06f5fd3268bec3b0133f... 0.0 0.0 \n", "fbd7080dea62e2e47b21dc9a2d2488a8b045f36c6137222... 0.0 0.0 \n", "fbed55eef282ecf6bea8f3bbeac967e2b859fca5239947a... 0.0 0.0 \n", "fbef1f2eefbb380721d1b908a45c7bdf84a2dad2f34d49b... 0.0 0.0 \n", "fc93cc3a74e99fc5325b951abeba1fc142ce354c5824601... 0.0 0.0 \n", "fcd76f264472c9ee6727bf1bcb418a51880e020ba12127f... 0.0 0.0 \n", "fcd76f264472c9ee6727bf1bcb418a51880e020ba12127f... 0.0 0.0 \n", "fceb27bb78f34e82bee2d1b1362ff27207828979e201e64... 0.0 0.0 \n", "fcf6564d2a10dd392a376aa23ff6ac19846fc8f5564beb1... 0.0 0.0 \n", "fda422842e8e6bf0cc291d048b792d76a293c021319f588... 0.0 0.0 \n", "fdbde899b8f6b58595afb42de2337ecfcb066481f848f9f... 0.0 0.0 \n", "fdca2182a7ca43056ccc3a8cf95567396468ddcca1e6fd6... 0.0 0.0 \n", "fdd431cab47cf62c4be70e4e05bbd48001edf641c1136c4... 0.0 0.0 \n", "fe26e5d679dc1f6a733c8bfa9e7337501d5d127a21a337d... 0.0 0.0 \n", "fe33c5a8da4dcefc16d5db744a5f18d898805996de2016a... 0.0 0.0 \n", "fe7a693c020f03fa62e704e29d0db643248426fca3df6b4... 0.0 0.0 \n", "fe943a72a4b8ce3a4e5b42511ed72f53e241a3630ef4343... 0.0 0.0 \n", "fe943a72a4b8ce3a4e5b42511ed72f53e241a3630ef4343... 0.0 0.0 \n", "fed9a9b0dcbeba81cf56c5b9963cced64f7827a554a0598... 0.0 0.0 \n", "fef709daecdf01a6164df79083f8a55c2c32f939d0f7199... 0.0 0.0 \n", "ff5f650c4fc31086d3b9ea116434ab284714ac317249153... 0.0 0.0 \n", "ffb521745ac8de7c4715080c46451472f0567736e1206d8... 0.0 0.0 \n", "\n", "item Mens Apprl Mens Apprl \\\n", "transaction_id \n", "00de91ae00bb2fea1d7e9953d2da87740c7340ddbe5a2ec... 0.0 0.0 \n", "0132bfb1ddb43b86872150aa5d5beb506b2c0547c91d8b5... 0.0 0.0 \n", "01a28b44a832a0a35949a680fae963ad86563f389a26356... 0.0 0.0 \n", "01b1a76315c3c1bb3b08616eba3e9fd98cb8471a0f7ce5b... 0.0 0.0 \n", "01e0e2d91144b15862e929591bfa30f74fb0757e50476e8... 0.0 0.0 \n", "023e16af29b004681ac4248606d06658267fe730ba581f0... 0.0 0.0 \n", "02463a4dc6a661eeb8607333c2dc3d0a3ec4c9a40d93354... 0.0 0.0 \n", "026c164abb5f644eacb3d02798c1571c01713e64d76e725... 0.0 0.0 \n", "027b046d6acb430991e79e54e08a5bef371aa35e3be4fe7... 0.0 0.0 \n", "02c5eae6ef36dd5886912fdead95a60865309e5abcf0ad1... 0.0 0.0 \n", "02d5efb4f7a7ed421530724c7318523511635c02aa0578c... 0.0 0.0 \n", "02f218e640b27885de2ccdb7c3f22a2acb9a296a012505b... 0.0 0.0 \n", "030102e337802b33a467fa3fa2f433c2d51f14718943c57... 0.0 0.0 \n", "03978b65107fe576a1bba38f76d41e71297eec5f58ee113... 0.0 0.0 \n", "03b0c44873c147ca39167e0ca031f836ffe47cca7b66c82... 0.0 0.0 \n", "040f584138f13122be9de6803bca77edbf396471e8d1767... 0.0 0.0 \n", "04194617a57a88bdb5eea3038ab6a40bac6f9751373efcc... 0.0 0.0 \n", "041d27961b44602fa01fc6b758195ed73d6d106efa3c332... 0.0 0.0 \n", "043051b1d8db2a9d2e51ccbb432feb7648574e67e79c3e6... 0.0 0.0 \n", "043051b1d8db2a9d2e51ccbb432feb7648574e67e79c3e6... 0.0 0.0 \n", "043051b1d8db2a9d2e51ccbb432feb7648574e67e79c3e6... 0.0 0.0 \n", "048af26f61363f8863f847f69ec338ba1a5b13bf4d99b08... 0.0 0.0 \n", "0497476bd0bbbcdd0bba1ee900079a7ec876954ac2140c9... 0.0 0.0 \n", "04cbdf2eb46e941754bbf230db51b76258d556c1cc57bb5... 0.0 0.0 \n", "04d71a14825027e0454445d8f090c17e07806d6bf0592e3... 0.0 0.0 \n", "05bbaa2c91ce9d45eb654cbbb94071dcfeb16656dd4bad1... 0.0 0.0 \n", "05d7cf732a82c475b56ffddf6bbfdc12180e3faf29c72e8... 0.0 0.0 \n", "05e1efce4d5e538cff3f0fc9439c0e6e2ef2f1420b21b1d... 0.0 0.0 \n", "06262d3c9daef003c19dbfb3b9c9f6976d9c190e4a455a5... 0.0 0.0 \n", "065346df86cf995e2d22782120e05422e955070a4c06511... 0.0 0.0 \n", "... ... ... \n", "faeaafabb538ca92e3c6226c775a97a5b3b336ddcb41fa6... 0.0 0.0 \n", "fb10289594bb1da49eb3241022628ad3ec6a24cdb900812... 0.0 0.0 \n", "fb26c5d622129e969e2fa17ac1ef130231b6894ee309b4c... 0.0 0.0 \n", "fb26c5d622129e969e2fa17ac1ef130231b6894ee309b4c... 0.0 0.0 \n", "fb26c5d622129e969e2fa17ac1ef130231b6894ee309b4c... 0.0 0.0 \n", "fb27439e6959b435aec64aadf34df15948b086c9e4df235... 0.0 0.0 \n", "fb513c34a472046a10ec14b8f9a5c6de55e3e30ecac5221... 0.0 0.0 \n", "fbaa5a96fa9860917ba9a6eb4ce5c2001b18c330afd4a74... 0.0 0.0 \n", "fbd145967d33641676baa21832c06f5fd3268bec3b0133f... 0.0 0.0 \n", "fbd7080dea62e2e47b21dc9a2d2488a8b045f36c6137222... 0.0 0.0 \n", "fbed55eef282ecf6bea8f3bbeac967e2b859fca5239947a... 0.0 0.0 \n", "fbef1f2eefbb380721d1b908a45c7bdf84a2dad2f34d49b... 0.0 0.0 \n", "fc93cc3a74e99fc5325b951abeba1fc142ce354c5824601... 0.0 0.0 \n", "fcd76f264472c9ee6727bf1bcb418a51880e020ba12127f... 0.0 0.0 \n", "fcd76f264472c9ee6727bf1bcb418a51880e020ba12127f... 0.0 0.0 \n", "fceb27bb78f34e82bee2d1b1362ff27207828979e201e64... 0.0 0.0 \n", "fcf6564d2a10dd392a376aa23ff6ac19846fc8f5564beb1... 0.0 0.0 \n", "fda422842e8e6bf0cc291d048b792d76a293c021319f588... 0.0 0.0 \n", "fdbde899b8f6b58595afb42de2337ecfcb066481f848f9f... 0.0 0.0 \n", "fdca2182a7ca43056ccc3a8cf95567396468ddcca1e6fd6... 0.0 0.0 \n", "fdd431cab47cf62c4be70e4e05bbd48001edf641c1136c4... 0.0 0.0 \n", "fe26e5d679dc1f6a733c8bfa9e7337501d5d127a21a337d... 0.0 1.0 \n", "fe33c5a8da4dcefc16d5db744a5f18d898805996de2016a... 0.0 0.0 \n", "fe7a693c020f03fa62e704e29d0db643248426fca3df6b4... 0.0 0.0 \n", "fe943a72a4b8ce3a4e5b42511ed72f53e241a3630ef4343... 0.0 0.0 \n", "fe943a72a4b8ce3a4e5b42511ed72f53e241a3630ef4343... 0.0 0.0 \n", "fed9a9b0dcbeba81cf56c5b9963cced64f7827a554a0598... 0.0 0.0 \n", "fef709daecdf01a6164df79083f8a55c2c32f939d0f7199... 0.0 0.0 \n", "ff5f650c4fc31086d3b9ea116434ab284714ac317249153... 0.0 0.0 \n", "ffb521745ac8de7c4715080c46451472f0567736e1206d8... 0.0 0.0 \n", "\n", "item Noncatwear Print Item \\\n", "transaction_id \n", "00de91ae00bb2fea1d7e9953d2da87740c7340ddbe5a2ec... 0.0 0.0 \n", "0132bfb1ddb43b86872150aa5d5beb506b2c0547c91d8b5... 0.0 0.0 \n", "01a28b44a832a0a35949a680fae963ad86563f389a26356... 0.0 0.0 \n", "01b1a76315c3c1bb3b08616eba3e9fd98cb8471a0f7ce5b... 0.0 0.0 \n", "01e0e2d91144b15862e929591bfa30f74fb0757e50476e8... 0.0 0.0 \n", "023e16af29b004681ac4248606d06658267fe730ba581f0... 0.0 0.0 \n", "02463a4dc6a661eeb8607333c2dc3d0a3ec4c9a40d93354... 0.0 0.0 \n", "026c164abb5f644eacb3d02798c1571c01713e64d76e725... 0.0 0.0 \n", "027b046d6acb430991e79e54e08a5bef371aa35e3be4fe7... 0.0 0.0 \n", "02c5eae6ef36dd5886912fdead95a60865309e5abcf0ad1... 0.0 0.0 \n", "02d5efb4f7a7ed421530724c7318523511635c02aa0578c... 0.0 0.0 \n", "02f218e640b27885de2ccdb7c3f22a2acb9a296a012505b... 0.0 0.0 \n", "030102e337802b33a467fa3fa2f433c2d51f14718943c57... 0.0 0.0 \n", "03978b65107fe576a1bba38f76d41e71297eec5f58ee113... 0.0 0.0 \n", "03b0c44873c147ca39167e0ca031f836ffe47cca7b66c82... 0.0 0.0 \n", "040f584138f13122be9de6803bca77edbf396471e8d1767... 0.0 0.0 \n", "04194617a57a88bdb5eea3038ab6a40bac6f9751373efcc... 0.0 0.0 \n", "041d27961b44602fa01fc6b758195ed73d6d106efa3c332... 3.0 0.0 \n", "043051b1d8db2a9d2e51ccbb432feb7648574e67e79c3e6... 0.0 0.0 \n", "043051b1d8db2a9d2e51ccbb432feb7648574e67e79c3e6... 0.0 0.0 \n", "043051b1d8db2a9d2e51ccbb432feb7648574e67e79c3e6... 0.0 0.0 \n", "048af26f61363f8863f847f69ec338ba1a5b13bf4d99b08... 0.0 0.0 \n", "0497476bd0bbbcdd0bba1ee900079a7ec876954ac2140c9... 0.0 0.0 \n", "04cbdf2eb46e941754bbf230db51b76258d556c1cc57bb5... 1.0 0.0 \n", "04d71a14825027e0454445d8f090c17e07806d6bf0592e3... 0.0 0.0 \n", "05bbaa2c91ce9d45eb654cbbb94071dcfeb16656dd4bad1... 0.0 0.0 \n", "05d7cf732a82c475b56ffddf6bbfdc12180e3faf29c72e8... 1.0 0.0 \n", "05e1efce4d5e538cff3f0fc9439c0e6e2ef2f1420b21b1d... 0.0 0.0 \n", "06262d3c9daef003c19dbfb3b9c9f6976d9c190e4a455a5... 0.0 0.0 \n", "065346df86cf995e2d22782120e05422e955070a4c06511... 0.0 0.0 \n", "... ... ... \n", "faeaafabb538ca92e3c6226c775a97a5b3b336ddcb41fa6... 0.0 0.0 \n", "fb10289594bb1da49eb3241022628ad3ec6a24cdb900812... 0.0 0.0 \n", "fb26c5d622129e969e2fa17ac1ef130231b6894ee309b4c... 0.0 0.0 \n", "fb26c5d622129e969e2fa17ac1ef130231b6894ee309b4c... 0.0 0.0 \n", "fb26c5d622129e969e2fa17ac1ef130231b6894ee309b4c... 0.0 0.0 \n", "fb27439e6959b435aec64aadf34df15948b086c9e4df235... 1.0 0.0 \n", "fb513c34a472046a10ec14b8f9a5c6de55e3e30ecac5221... 0.0 0.0 \n", "fbaa5a96fa9860917ba9a6eb4ce5c2001b18c330afd4a74... 0.0 0.0 \n", "fbd145967d33641676baa21832c06f5fd3268bec3b0133f... 0.0 0.0 \n", "fbd7080dea62e2e47b21dc9a2d2488a8b045f36c6137222... 0.0 0.0 \n", "fbed55eef282ecf6bea8f3bbeac967e2b859fca5239947a... 0.0 0.0 \n", "fbef1f2eefbb380721d1b908a45c7bdf84a2dad2f34d49b... 0.0 0.0 \n", "fc93cc3a74e99fc5325b951abeba1fc142ce354c5824601... 0.0 0.0 \n", "fcd76f264472c9ee6727bf1bcb418a51880e020ba12127f... 0.0 0.0 \n", "fcd76f264472c9ee6727bf1bcb418a51880e020ba12127f... 0.0 0.0 \n", "fceb27bb78f34e82bee2d1b1362ff27207828979e201e64... 0.0 0.0 \n", "fcf6564d2a10dd392a376aa23ff6ac19846fc8f5564beb1... 0.0 0.0 \n", "fda422842e8e6bf0cc291d048b792d76a293c021319f588... 0.0 0.0 \n", "fdbde899b8f6b58595afb42de2337ecfcb066481f848f9f... 0.0 0.0 \n", "fdca2182a7ca43056ccc3a8cf95567396468ddcca1e6fd6... 0.0 0.0 \n", "fdd431cab47cf62c4be70e4e05bbd48001edf641c1136c4... 0.0 0.0 \n", "fe26e5d679dc1f6a733c8bfa9e7337501d5d127a21a337d... 0.0 0.0 \n", "fe33c5a8da4dcefc16d5db744a5f18d898805996de2016a... 0.0 0.0 \n", "fe7a693c020f03fa62e704e29d0db643248426fca3df6b4... 0.0 0.0 \n", "fe943a72a4b8ce3a4e5b42511ed72f53e241a3630ef4343... 0.0 0.0 \n", "fe943a72a4b8ce3a4e5b42511ed72f53e241a3630ef4343... 0.0 0.0 \n", "fed9a9b0dcbeba81cf56c5b9963cced64f7827a554a0598... 0.0 0.0 \n", "fef709daecdf01a6164df79083f8a55c2c32f939d0f7199... 0.0 0.0 \n", "ff5f650c4fc31086d3b9ea116434ab284714ac317249153... 0.0 0.0 \n", "ffb521745ac8de7c4715080c46451472f0567736e1206d8... 1.0 0.0 \n", "\n", "item Print Item SmallStuff \\\n", "transaction_id \n", "00de91ae00bb2fea1d7e9953d2da87740c7340ddbe5a2ec... 1.0 0.0 \n", "0132bfb1ddb43b86872150aa5d5beb506b2c0547c91d8b5... 0.0 0.0 \n", "01a28b44a832a0a35949a680fae963ad86563f389a26356... 0.0 0.0 \n", "01b1a76315c3c1bb3b08616eba3e9fd98cb8471a0f7ce5b... 0.0 0.0 \n", "01e0e2d91144b15862e929591bfa30f74fb0757e50476e8... 0.0 0.0 \n", "023e16af29b004681ac4248606d06658267fe730ba581f0... 0.0 0.0 \n", "02463a4dc6a661eeb8607333c2dc3d0a3ec4c9a40d93354... 0.0 0.0 \n", "026c164abb5f644eacb3d02798c1571c01713e64d76e725... 1.0 0.0 \n", "027b046d6acb430991e79e54e08a5bef371aa35e3be4fe7... 1.0 0.0 \n", "02c5eae6ef36dd5886912fdead95a60865309e5abcf0ad1... 0.0 0.0 \n", "02d5efb4f7a7ed421530724c7318523511635c02aa0578c... 2.0 0.0 \n", "02f218e640b27885de2ccdb7c3f22a2acb9a296a012505b... 1.0 0.0 \n", "030102e337802b33a467fa3fa2f433c2d51f14718943c57... 0.0 0.0 \n", "03978b65107fe576a1bba38f76d41e71297eec5f58ee113... 1.0 0.0 \n", "03b0c44873c147ca39167e0ca031f836ffe47cca7b66c82... 0.0 0.0 \n", "040f584138f13122be9de6803bca77edbf396471e8d1767... 1.0 0.0 \n", "04194617a57a88bdb5eea3038ab6a40bac6f9751373efcc... 0.0 0.0 \n", "041d27961b44602fa01fc6b758195ed73d6d106efa3c332... 0.0 0.0 \n", "043051b1d8db2a9d2e51ccbb432feb7648574e67e79c3e6... 1.0 0.0 \n", "043051b1d8db2a9d2e51ccbb432feb7648574e67e79c3e6... 0.0 0.0 \n", "043051b1d8db2a9d2e51ccbb432feb7648574e67e79c3e6... 0.0 0.0 \n", "048af26f61363f8863f847f69ec338ba1a5b13bf4d99b08... 0.0 0.0 \n", "0497476bd0bbbcdd0bba1ee900079a7ec876954ac2140c9... 0.0 0.0 \n", "04cbdf2eb46e941754bbf230db51b76258d556c1cc57bb5... 0.0 0.0 \n", "04d71a14825027e0454445d8f090c17e07806d6bf0592e3... 0.0 0.0 \n", "05bbaa2c91ce9d45eb654cbbb94071dcfeb16656dd4bad1... 0.0 0.0 \n", "05d7cf732a82c475b56ffddf6bbfdc12180e3faf29c72e8... 0.0 0.0 \n", "05e1efce4d5e538cff3f0fc9439c0e6e2ef2f1420b21b1d... 0.0 0.0 \n", "06262d3c9daef003c19dbfb3b9c9f6976d9c190e4a455a5... 0.0 0.0 \n", "065346df86cf995e2d22782120e05422e955070a4c06511... 0.0 1.0 \n", "... ... ... \n", "faeaafabb538ca92e3c6226c775a97a5b3b336ddcb41fa6... 0.0 0.0 \n", "fb10289594bb1da49eb3241022628ad3ec6a24cdb900812... 0.0 0.0 \n", "fb26c5d622129e969e2fa17ac1ef130231b6894ee309b4c... 1.0 0.0 \n", "fb26c5d622129e969e2fa17ac1ef130231b6894ee309b4c... 0.0 0.0 \n", "fb26c5d622129e969e2fa17ac1ef130231b6894ee309b4c... 0.0 0.0 \n", "fb27439e6959b435aec64aadf34df15948b086c9e4df235... 0.0 0.0 \n", "fb513c34a472046a10ec14b8f9a5c6de55e3e30ecac5221... 0.0 0.0 \n", "fbaa5a96fa9860917ba9a6eb4ce5c2001b18c330afd4a74... 0.0 0.0 \n", "fbd145967d33641676baa21832c06f5fd3268bec3b0133f... 0.0 0.0 \n", "fbd7080dea62e2e47b21dc9a2d2488a8b045f36c6137222... 1.0 0.0 \n", "fbed55eef282ecf6bea8f3bbeac967e2b859fca5239947a... 0.0 0.0 \n", "fbef1f2eefbb380721d1b908a45c7bdf84a2dad2f34d49b... 0.0 0.0 \n", "fc93cc3a74e99fc5325b951abeba1fc142ce354c5824601... 0.0 0.0 \n", "fcd76f264472c9ee6727bf1bcb418a51880e020ba12127f... 0.0 0.0 \n", "fcd76f264472c9ee6727bf1bcb418a51880e020ba12127f... 0.0 0.0 \n", "fceb27bb78f34e82bee2d1b1362ff27207828979e201e64... 0.0 0.0 \n", "fcf6564d2a10dd392a376aa23ff6ac19846fc8f5564beb1... 0.0 0.0 \n", "fda422842e8e6bf0cc291d048b792d76a293c021319f588... 0.0 0.0 \n", "fdbde899b8f6b58595afb42de2337ecfcb066481f848f9f... 0.0 0.0 \n", "fdca2182a7ca43056ccc3a8cf95567396468ddcca1e6fd6... 0.0 0.0 \n", "fdd431cab47cf62c4be70e4e05bbd48001edf641c1136c4... 0.0 0.0 \n", "fe26e5d679dc1f6a733c8bfa9e7337501d5d127a21a337d... 0.0 0.0 \n", "fe33c5a8da4dcefc16d5db744a5f18d898805996de2016a... 0.0 0.0 \n", "fe7a693c020f03fa62e704e29d0db643248426fca3df6b4... 0.0 0.0 \n", "fe943a72a4b8ce3a4e5b42511ed72f53e241a3630ef4343... 0.0 0.0 \n", "fe943a72a4b8ce3a4e5b42511ed72f53e241a3630ef4343... 0.0 0.0 \n", "fed9a9b0dcbeba81cf56c5b9963cced64f7827a554a0598... 0.0 0.0 \n", "fef709daecdf01a6164df79083f8a55c2c32f939d0f7199... 1.0 0.0 \n", "ff5f650c4fc31086d3b9ea116434ab284714ac317249153... 0.0 0.0 \n", "ffb521745ac8de7c4715080c46451472f0567736e1206d8... 0.0 0.0 \n", "\n", "item Unisx Appl Unisx Appl \\\n", "transaction_id \n", "00de91ae00bb2fea1d7e9953d2da87740c7340ddbe5a2ec... 0.0 0.0 \n", "0132bfb1ddb43b86872150aa5d5beb506b2c0547c91d8b5... 0.0 0.0 \n", "01a28b44a832a0a35949a680fae963ad86563f389a26356... 1.0 0.0 \n", "01b1a76315c3c1bb3b08616eba3e9fd98cb8471a0f7ce5b... 0.0 0.0 \n", "01e0e2d91144b15862e929591bfa30f74fb0757e50476e8... 2.0 0.0 \n", "023e16af29b004681ac4248606d06658267fe730ba581f0... 1.0 0.0 \n", "02463a4dc6a661eeb8607333c2dc3d0a3ec4c9a40d93354... 1.0 0.0 \n", "026c164abb5f644eacb3d02798c1571c01713e64d76e725... 0.0 0.0 \n", "027b046d6acb430991e79e54e08a5bef371aa35e3be4fe7... 0.0 0.0 \n", "02c5eae6ef36dd5886912fdead95a60865309e5abcf0ad1... 0.0 0.0 \n", "02d5efb4f7a7ed421530724c7318523511635c02aa0578c... 0.0 0.0 \n", "02f218e640b27885de2ccdb7c3f22a2acb9a296a012505b... 1.0 0.0 \n", "030102e337802b33a467fa3fa2f433c2d51f14718943c57... 0.0 0.0 \n", "03978b65107fe576a1bba38f76d41e71297eec5f58ee113... 0.0 0.0 \n", "03b0c44873c147ca39167e0ca031f836ffe47cca7b66c82... 1.0 0.0 \n", "040f584138f13122be9de6803bca77edbf396471e8d1767... 1.0 2.0 \n", "04194617a57a88bdb5eea3038ab6a40bac6f9751373efcc... 0.0 0.0 \n", "041d27961b44602fa01fc6b758195ed73d6d106efa3c332... 0.0 0.0 \n", "043051b1d8db2a9d2e51ccbb432feb7648574e67e79c3e6... 0.0 0.0 \n", "043051b1d8db2a9d2e51ccbb432feb7648574e67e79c3e6... 0.0 0.0 \n", "043051b1d8db2a9d2e51ccbb432feb7648574e67e79c3e6... 0.0 0.0 \n", "048af26f61363f8863f847f69ec338ba1a5b13bf4d99b08... 0.0 0.0 \n", "0497476bd0bbbcdd0bba1ee900079a7ec876954ac2140c9... 1.0 0.0 \n", "04cbdf2eb46e941754bbf230db51b76258d556c1cc57bb5... 0.0 0.0 \n", "04d71a14825027e0454445d8f090c17e07806d6bf0592e3... 0.0 0.0 \n", "05bbaa2c91ce9d45eb654cbbb94071dcfeb16656dd4bad1... 0.0 0.0 \n", "05d7cf732a82c475b56ffddf6bbfdc12180e3faf29c72e8... 0.0 0.0 \n", "05e1efce4d5e538cff3f0fc9439c0e6e2ef2f1420b21b1d... 2.0 0.0 \n", "06262d3c9daef003c19dbfb3b9c9f6976d9c190e4a455a5... 0.0 0.0 \n", "065346df86cf995e2d22782120e05422e955070a4c06511... 0.0 0.0 \n", "... ... ... \n", "faeaafabb538ca92e3c6226c775a97a5b3b336ddcb41fa6... 0.0 0.0 \n", "fb10289594bb1da49eb3241022628ad3ec6a24cdb900812... 1.0 0.0 \n", "fb26c5d622129e969e2fa17ac1ef130231b6894ee309b4c... 0.0 0.0 \n", "fb26c5d622129e969e2fa17ac1ef130231b6894ee309b4c... 1.0 0.0 \n", "fb26c5d622129e969e2fa17ac1ef130231b6894ee309b4c... 0.0 0.0 \n", "fb27439e6959b435aec64aadf34df15948b086c9e4df235... 0.0 0.0 \n", "fb513c34a472046a10ec14b8f9a5c6de55e3e30ecac5221... 1.0 0.0 \n", "fbaa5a96fa9860917ba9a6eb4ce5c2001b18c330afd4a74... 0.0 0.0 \n", "fbd145967d33641676baa21832c06f5fd3268bec3b0133f... 0.0 1.0 \n", "fbd7080dea62e2e47b21dc9a2d2488a8b045f36c6137222... 0.0 0.0 \n", "fbed55eef282ecf6bea8f3bbeac967e2b859fca5239947a... 1.0 0.0 \n", "fbef1f2eefbb380721d1b908a45c7bdf84a2dad2f34d49b... 1.0 0.0 \n", "fc93cc3a74e99fc5325b951abeba1fc142ce354c5824601... 1.0 2.0 \n", "fcd76f264472c9ee6727bf1bcb418a51880e020ba12127f... 0.0 0.0 \n", "fcd76f264472c9ee6727bf1bcb418a51880e020ba12127f... 0.0 1.0 \n", "fceb27bb78f34e82bee2d1b1362ff27207828979e201e64... 0.0 0.0 \n", "fcf6564d2a10dd392a376aa23ff6ac19846fc8f5564beb1... 0.0 0.0 \n", "fda422842e8e6bf0cc291d048b792d76a293c021319f588... 1.0 0.0 \n", "fdbde899b8f6b58595afb42de2337ecfcb066481f848f9f... 0.0 0.0 \n", "fdca2182a7ca43056ccc3a8cf95567396468ddcca1e6fd6... 1.0 0.0 \n", "fdd431cab47cf62c4be70e4e05bbd48001edf641c1136c4... 2.0 0.0 \n", "fe26e5d679dc1f6a733c8bfa9e7337501d5d127a21a337d... 0.0 0.0 \n", "fe33c5a8da4dcefc16d5db744a5f18d898805996de2016a... 0.0 0.0 \n", "fe7a693c020f03fa62e704e29d0db643248426fca3df6b4... 0.0 0.0 \n", "fe943a72a4b8ce3a4e5b42511ed72f53e241a3630ef4343... 1.0 0.0 \n", "fe943a72a4b8ce3a4e5b42511ed72f53e241a3630ef4343... 1.0 0.0 \n", "fed9a9b0dcbeba81cf56c5b9963cced64f7827a554a0598... 0.0 0.0 \n", "fef709daecdf01a6164df79083f8a55c2c32f939d0f7199... 0.0 0.0 \n", "ff5f650c4fc31086d3b9ea116434ab284714ac317249153... 0.0 0.0 \n", "ffb521745ac8de7c4715080c46451472f0567736e1206d8... 0.0 0.0 \n", "\n", "item Wmns Apprl Wmns Apprl \n", "transaction_id \n", "00de91ae00bb2fea1d7e9953d2da87740c7340ddbe5a2ec... 0.0 0.0 \n", "0132bfb1ddb43b86872150aa5d5beb506b2c0547c91d8b5... 0.0 1.0 \n", "01a28b44a832a0a35949a680fae963ad86563f389a26356... 0.0 0.0 \n", "01b1a76315c3c1bb3b08616eba3e9fd98cb8471a0f7ce5b... 0.0 0.0 \n", "01e0e2d91144b15862e929591bfa30f74fb0757e50476e8... 0.0 0.0 \n", "023e16af29b004681ac4248606d06658267fe730ba581f0... 0.0 0.0 \n", "02463a4dc6a661eeb8607333c2dc3d0a3ec4c9a40d93354... 0.0 0.0 \n", "026c164abb5f644eacb3d02798c1571c01713e64d76e725... 0.0 0.0 \n", "027b046d6acb430991e79e54e08a5bef371aa35e3be4fe7... 0.0 0.0 \n", "02c5eae6ef36dd5886912fdead95a60865309e5abcf0ad1... 0.0 0.0 \n", "02d5efb4f7a7ed421530724c7318523511635c02aa0578c... 0.0 0.0 \n", "02f218e640b27885de2ccdb7c3f22a2acb9a296a012505b... 0.0 0.0 \n", "030102e337802b33a467fa3fa2f433c2d51f14718943c57... 1.0 0.0 \n", "03978b65107fe576a1bba38f76d41e71297eec5f58ee113... 0.0 0.0 \n", "03b0c44873c147ca39167e0ca031f836ffe47cca7b66c82... 0.0 1.0 \n", "040f584138f13122be9de6803bca77edbf396471e8d1767... 0.0 0.0 \n", "04194617a57a88bdb5eea3038ab6a40bac6f9751373efcc... 1.0 0.0 \n", "041d27961b44602fa01fc6b758195ed73d6d106efa3c332... 0.0 0.0 \n", "043051b1d8db2a9d2e51ccbb432feb7648574e67e79c3e6... 0.0 0.0 \n", "043051b1d8db2a9d2e51ccbb432feb7648574e67e79c3e6... 1.0 0.0 \n", "043051b1d8db2a9d2e51ccbb432feb7648574e67e79c3e6... 0.0 1.0 \n", "048af26f61363f8863f847f69ec338ba1a5b13bf4d99b08... 0.0 0.0 \n", "0497476bd0bbbcdd0bba1ee900079a7ec876954ac2140c9... 0.0 1.0 \n", "04cbdf2eb46e941754bbf230db51b76258d556c1cc57bb5... 0.0 0.0 \n", "04d71a14825027e0454445d8f090c17e07806d6bf0592e3... 1.0 1.0 \n", "05bbaa2c91ce9d45eb654cbbb94071dcfeb16656dd4bad1... 0.0 0.0 \n", "05d7cf732a82c475b56ffddf6bbfdc12180e3faf29c72e8... 0.0 0.0 \n", "05e1efce4d5e538cff3f0fc9439c0e6e2ef2f1420b21b1d... 0.0 0.0 \n", "06262d3c9daef003c19dbfb3b9c9f6976d9c190e4a455a5... 0.0 0.0 \n", "065346df86cf995e2d22782120e05422e955070a4c06511... 0.0 0.0 \n", "... ... ... \n", "faeaafabb538ca92e3c6226c775a97a5b3b336ddcb41fa6... 0.0 0.0 \n", "fb10289594bb1da49eb3241022628ad3ec6a24cdb900812... 0.0 0.0 \n", "fb26c5d622129e969e2fa17ac1ef130231b6894ee309b4c... 0.0 0.0 \n", "fb26c5d622129e969e2fa17ac1ef130231b6894ee309b4c... 0.0 0.0 \n", "fb26c5d622129e969e2fa17ac1ef130231b6894ee309b4c... 0.0 0.0 \n", "fb27439e6959b435aec64aadf34df15948b086c9e4df235... 0.0 0.0 \n", "fb513c34a472046a10ec14b8f9a5c6de55e3e30ecac5221... 0.0 0.0 \n", "fbaa5a96fa9860917ba9a6eb4ce5c2001b18c330afd4a74... 0.0 0.0 \n", "fbd145967d33641676baa21832c06f5fd3268bec3b0133f... 0.0 0.0 \n", "fbd7080dea62e2e47b21dc9a2d2488a8b045f36c6137222... 0.0 0.0 \n", "fbed55eef282ecf6bea8f3bbeac967e2b859fca5239947a... 0.0 0.0 \n", "fbef1f2eefbb380721d1b908a45c7bdf84a2dad2f34d49b... 0.0 0.0 \n", "fc93cc3a74e99fc5325b951abeba1fc142ce354c5824601... 0.0 0.0 \n", "fcd76f264472c9ee6727bf1bcb418a51880e020ba12127f... 0.0 0.0 \n", "fcd76f264472c9ee6727bf1bcb418a51880e020ba12127f... 0.0 0.0 \n", "fceb27bb78f34e82bee2d1b1362ff27207828979e201e64... 0.0 0.0 \n", "fcf6564d2a10dd392a376aa23ff6ac19846fc8f5564beb1... 0.0 1.0 \n", "fda422842e8e6bf0cc291d048b792d76a293c021319f588... 0.0 0.0 \n", "fdbde899b8f6b58595afb42de2337ecfcb066481f848f9f... 0.0 0.0 \n", "fdca2182a7ca43056ccc3a8cf95567396468ddcca1e6fd6... 0.0 0.0 \n", "fdd431cab47cf62c4be70e4e05bbd48001edf641c1136c4... 0.0 0.0 \n", "fe26e5d679dc1f6a733c8bfa9e7337501d5d127a21a337d... 0.0 0.0 \n", "fe33c5a8da4dcefc16d5db744a5f18d898805996de2016a... 0.0 0.0 \n", "fe7a693c020f03fa62e704e29d0db643248426fca3df6b4... 0.0 0.0 \n", "fe943a72a4b8ce3a4e5b42511ed72f53e241a3630ef4343... 0.0 0.0 \n", "fe943a72a4b8ce3a4e5b42511ed72f53e241a3630ef4343... 0.0 0.0 \n", "fed9a9b0dcbeba81cf56c5b9963cced64f7827a554a0598... 0.0 0.0 \n", "fef709daecdf01a6164df79083f8a55c2c32f939d0f7199... 0.0 0.0 \n", "ff5f650c4fc31086d3b9ea116434ab284714ac317249153... 0.0 0.0 \n", "ffb521745ac8de7c4715080c46451472f0567736e1206d8... 0.0 0.0 \n", "\n", "[998 rows x 18 columns]" ] }, "execution_count": 21, "metadata": {}, "output_type": "execute_result" } ], "source": [ "basket" ] }, { "cell_type": "code", "execution_count": 22, "metadata": {}, "outputs": [], "source": [ "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.drop('POSTAGE', inplace=True, axis=1) # in tutorial postage was one item that not analyzed" ] }, { "cell_type": "code", "execution_count": 23, "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", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
itemAV MediaAV MediaAsst MerchAsst MerchJewelryJewelryKids ApprlMemorabiliMens ApprlMens ApprlNoncatwearPrint ItemPrint ItemSmallStuffUnisx ApplUnisx ApplWmns ApprlWmns Apprl
transaction_id
00de91ae00bb2fea1d7e9953d2da87740c7340ddbe5a2ecc0f91125ea149696a235000000000000100000
0132bfb1ddb43b86872150aa5d5beb506b2c0547c91d8b56259424eb969330e7342000000000000000001
01a28b44a832a0a35949a680fae963ad86563f389a263561f76cb5bfbbb03cf1334000000000000001000
01b1a76315c3c1bb3b08616eba3e9fd98cb8471a0f7ce5b45a9b27ebd06ab150462010000000000000000
01e0e2d91144b15862e929591bfa30f74fb0757e50476e8b09e6cabd73525f0b187000000000000001000
023e16af29b004681ac4248606d06658267fe730ba581f0a9091aee4b880d268179000000000000001000
02463a4dc6a661eeb8607333c2dc3d0a3ec4c9a40d933540051e04a756d0657a455000000000000001000
026c164abb5f644eacb3d02798c1571c01713e64d76e72573fb0b6131fc1a4b023000000000000100000
027b046d6acb430991e79e54e08a5bef371aa35e3be4fe7b196788bb66c5f3fe114000000000000100000
02c5eae6ef36dd5886912fdead95a60865309e5abcf0ad100632d1d9632d7598333000100000000000000
02d5efb4f7a7ed421530724c7318523511635c02aa0578c4267a0f049ac35c9c74010000000000100000
02f218e640b27885de2ccdb7c3f22a2acb9a296a012505b4ad6cec78b99d16bb273000000000000101000
030102e337802b33a467fa3fa2f433c2d51f14718943c57d938613b34bcd0bee296000000000000000010
03978b65107fe576a1bba38f76d41e71297eec5f58ee113d4605ba5676d69d6d225000000000000100000
03b0c44873c147ca39167e0ca031f836ffe47cca7b66c82bb05e34bff8f8bb6b433000000000000001001
040f584138f13122be9de6803bca77edbf396471e8d17677796e107173f7329a18000000000000101100
04194617a57a88bdb5eea3038ab6a40bac6f9751373efcc96c7953b32ce22678221000000000000000010
041d27961b44602fa01fc6b758195ed73d6d106efa3c332d30b8dc12654ec63e63000000000010000000
043051b1d8db2a9d2e51ccbb432feb7648574e67e79c3e670ee9695b48ac0c00107000000000000100000
043051b1d8db2a9d2e51ccbb432feb7648574e67e79c3e670ee9695b48ac0c00199000000000000000010
043051b1d8db2a9d2e51ccbb432feb7648574e67e79c3e670ee9695b48ac0c0020000100000000000001
048af26f61363f8863f847f69ec338ba1a5b13bf4d99b0857a89a8722ae32b60259010000000000000000
0497476bd0bbbcdd0bba1ee900079a7ec876954ac2140c945c61470fe700409d72000001000000001001
04cbdf2eb46e941754bbf230db51b76258d556c1cc57bb5b2be1dd6bd31cbb5955001000000010000000
04d71a14825027e0454445d8f090c17e07806d6bf0592e31cd6b256f5c83371852000000000000000011
05bbaa2c91ce9d45eb654cbbb94071dcfeb16656dd4bad163cc5b0d1b03ea49c55000100000000000000
05d7cf732a82c475b56ffddf6bbfdc12180e3faf29c72e89b4c68c41d76dbd6865000000000010000000
05e1efce4d5e538cff3f0fc9439c0e6e2ef2f1420b21b1d3723337a8954a323a51000000000000001000
06262d3c9daef003c19dbfb3b9c9f6976d9c190e4a455a5bccf0d9d5ee70b9b1443001000000000000000
065346df86cf995e2d22782120e05422e955070a4c06511a99d1e69aba3b875d23000000000000010000
.........................................................
faeaafabb538ca92e3c6226c775a97a5b3b336ddcb41fa6088fea08210fea855462010000000000000000
fb10289594bb1da49eb3241022628ad3ec6a24cdb90081281028f83b291a773c355000100000000001000
fb26c5d622129e969e2fa17ac1ef130231b6894ee309b4ca935810115d8e90a3307000000000000100000
fb26c5d622129e969e2fa17ac1ef130231b6894ee309b4ca935810115d8e90a3324000000000000001000
fb26c5d622129e969e2fa17ac1ef130231b6894ee309b4ca935810115d8e90a3354000001000000000000
fb27439e6959b435aec64aadf34df15948b086c9e4df2358756fbb54ecb8748865000000000010000000
fb513c34a472046a10ec14b8f9a5c6de55e3e30ecac5221eda9b81cda4cc4e5275000000000000001000
fbaa5a96fa9860917ba9a6eb4ce5c2001b18c330afd4a743acb8fbee9262e5fd347000001000000000000
fbd145967d33641676baa21832c06f5fd3268bec3b0133fa63df3b4d6b6677a169000000000000000100
fbd7080dea62e2e47b21dc9a2d2488a8b045f36c6137222d7b082a6be0ba11aa394000000000000100000
fbed55eef282ecf6bea8f3bbeac967e2b859fca5239947ad0a18b87ec5428ad4486000000000000001000
fbef1f2eefbb380721d1b908a45c7bdf84a2dad2f34d49b31e8cae14b2a30df8233000000000000001000
fc93cc3a74e99fc5325b951abeba1fc142ce354c5824601bd5fc320fec44ddda484010100000000001100
fcd76f264472c9ee6727bf1bcb418a51880e020ba12127fb5bc60c6ece85852812010000000000000000
fcd76f264472c9ee6727bf1bcb418a51880e020ba12127fb5bc60c6ece858528201010000000000000100
fceb27bb78f34e82bee2d1b1362ff27207828979e201e64c7ea4b49658f056c4226000100000000000000
fcf6564d2a10dd392a376aa23ff6ac19846fc8f5564beb1daa3a36432883d775396000000000000000001
fda422842e8e6bf0cc291d048b792d76a293c021319f588015c442faf5d97df5106000000000000001000
fdbde899b8f6b58595afb42de2337ecfcb066481f848f9f68dee5ab65d47db9e227001100000000000000
fdca2182a7ca43056ccc3a8cf95567396468ddcca1e6fd606e8a87976f07b66f301000000000000001000
fdd431cab47cf62c4be70e4e05bbd48001edf641c1136c40474457271cc473b2226000000000000001000
fe26e5d679dc1f6a733c8bfa9e7337501d5d127a21a337d58fdb1923ff98126486000000000100000000
fe33c5a8da4dcefc16d5db744a5f18d898805996de2016aee0ea746df9b9340838000010000000000000
fe7a693c020f03fa62e704e29d0db643248426fca3df6b4f80facb7a8889c8ef462010000000000000000
fe943a72a4b8ce3a4e5b42511ed72f53e241a3630ef4343a3eaea0e1ea031eed17000000000000001000
fe943a72a4b8ce3a4e5b42511ed72f53e241a3630ef4343a3eaea0e1ea031eed342000000000000001000
fed9a9b0dcbeba81cf56c5b9963cced64f7827a554a0598fdaf0054e70c92e98212010000000000000000
fef709daecdf01a6164df79083f8a55c2c32f939d0f7199a1dffe754e4163b71271000000000000100000
ff5f650c4fc31086d3b9ea116434ab284714ac317249153ee0cb96426391ac6d443010100000000000000
ffb521745ac8de7c4715080c46451472f0567736e1206d83b7da5a0c6320f08565000000000010000000
\n", "

998 rows × 18 columns

\n", "
" ], "text/plain": [ "item AV Media AV Media \\\n", "transaction_id \n", "00de91ae00bb2fea1d7e9953d2da87740c7340ddbe5a2ec... 0 0 \n", "0132bfb1ddb43b86872150aa5d5beb506b2c0547c91d8b5... 0 0 \n", "01a28b44a832a0a35949a680fae963ad86563f389a26356... 0 0 \n", "01b1a76315c3c1bb3b08616eba3e9fd98cb8471a0f7ce5b... 0 1 \n", "01e0e2d91144b15862e929591bfa30f74fb0757e50476e8... 0 0 \n", "023e16af29b004681ac4248606d06658267fe730ba581f0... 0 0 \n", "02463a4dc6a661eeb8607333c2dc3d0a3ec4c9a40d93354... 0 0 \n", "026c164abb5f644eacb3d02798c1571c01713e64d76e725... 0 0 \n", "027b046d6acb430991e79e54e08a5bef371aa35e3be4fe7... 0 0 \n", "02c5eae6ef36dd5886912fdead95a60865309e5abcf0ad1... 0 0 \n", "02d5efb4f7a7ed421530724c7318523511635c02aa0578c... 0 1 \n", "02f218e640b27885de2ccdb7c3f22a2acb9a296a012505b... 0 0 \n", "030102e337802b33a467fa3fa2f433c2d51f14718943c57... 0 0 \n", "03978b65107fe576a1bba38f76d41e71297eec5f58ee113... 0 0 \n", "03b0c44873c147ca39167e0ca031f836ffe47cca7b66c82... 0 0 \n", "040f584138f13122be9de6803bca77edbf396471e8d1767... 0 0 \n", "04194617a57a88bdb5eea3038ab6a40bac6f9751373efcc... 0 0 \n", "041d27961b44602fa01fc6b758195ed73d6d106efa3c332... 0 0 \n", "043051b1d8db2a9d2e51ccbb432feb7648574e67e79c3e6... 0 0 \n", "043051b1d8db2a9d2e51ccbb432feb7648574e67e79c3e6... 0 0 \n", "043051b1d8db2a9d2e51ccbb432feb7648574e67e79c3e6... 0 0 \n", "048af26f61363f8863f847f69ec338ba1a5b13bf4d99b08... 0 1 \n", "0497476bd0bbbcdd0bba1ee900079a7ec876954ac2140c9... 0 0 \n", "04cbdf2eb46e941754bbf230db51b76258d556c1cc57bb5... 0 0 \n", "04d71a14825027e0454445d8f090c17e07806d6bf0592e3... 0 0 \n", "05bbaa2c91ce9d45eb654cbbb94071dcfeb16656dd4bad1... 0 0 \n", "05d7cf732a82c475b56ffddf6bbfdc12180e3faf29c72e8... 0 0 \n", "05e1efce4d5e538cff3f0fc9439c0e6e2ef2f1420b21b1d... 0 0 \n", "06262d3c9daef003c19dbfb3b9c9f6976d9c190e4a455a5... 0 0 \n", "065346df86cf995e2d22782120e05422e955070a4c06511... 0 0 \n", "... ... ... \n", "faeaafabb538ca92e3c6226c775a97a5b3b336ddcb41fa6... 0 1 \n", "fb10289594bb1da49eb3241022628ad3ec6a24cdb900812... 0 0 \n", "fb26c5d622129e969e2fa17ac1ef130231b6894ee309b4c... 0 0 \n", "fb26c5d622129e969e2fa17ac1ef130231b6894ee309b4c... 0 0 \n", "fb26c5d622129e969e2fa17ac1ef130231b6894ee309b4c... 0 0 \n", "fb27439e6959b435aec64aadf34df15948b086c9e4df235... 0 0 \n", "fb513c34a472046a10ec14b8f9a5c6de55e3e30ecac5221... 0 0 \n", "fbaa5a96fa9860917ba9a6eb4ce5c2001b18c330afd4a74... 0 0 \n", "fbd145967d33641676baa21832c06f5fd3268bec3b0133f... 0 0 \n", "fbd7080dea62e2e47b21dc9a2d2488a8b045f36c6137222... 0 0 \n", "fbed55eef282ecf6bea8f3bbeac967e2b859fca5239947a... 0 0 \n", "fbef1f2eefbb380721d1b908a45c7bdf84a2dad2f34d49b... 0 0 \n", "fc93cc3a74e99fc5325b951abeba1fc142ce354c5824601... 0 1 \n", "fcd76f264472c9ee6727bf1bcb418a51880e020ba12127f... 0 1 \n", "fcd76f264472c9ee6727bf1bcb418a51880e020ba12127f... 0 1 \n", "fceb27bb78f34e82bee2d1b1362ff27207828979e201e64... 0 0 \n", "fcf6564d2a10dd392a376aa23ff6ac19846fc8f5564beb1... 0 0 \n", "fda422842e8e6bf0cc291d048b792d76a293c021319f588... 0 0 \n", "fdbde899b8f6b58595afb42de2337ecfcb066481f848f9f... 0 0 \n", "fdca2182a7ca43056ccc3a8cf95567396468ddcca1e6fd6... 0 0 \n", "fdd431cab47cf62c4be70e4e05bbd48001edf641c1136c4... 0 0 \n", "fe26e5d679dc1f6a733c8bfa9e7337501d5d127a21a337d... 0 0 \n", "fe33c5a8da4dcefc16d5db744a5f18d898805996de2016a... 0 0 \n", "fe7a693c020f03fa62e704e29d0db643248426fca3df6b4... 0 1 \n", "fe943a72a4b8ce3a4e5b42511ed72f53e241a3630ef4343... 0 0 \n", "fe943a72a4b8ce3a4e5b42511ed72f53e241a3630ef4343... 0 0 \n", "fed9a9b0dcbeba81cf56c5b9963cced64f7827a554a0598... 0 1 \n", "fef709daecdf01a6164df79083f8a55c2c32f939d0f7199... 0 0 \n", "ff5f650c4fc31086d3b9ea116434ab284714ac317249153... 0 1 \n", "ffb521745ac8de7c4715080c46451472f0567736e1206d8... 0 0 \n", "\n", "item Asst Merch Asst Merch \\\n", "transaction_id \n", "00de91ae00bb2fea1d7e9953d2da87740c7340ddbe5a2ec... 0 0 \n", "0132bfb1ddb43b86872150aa5d5beb506b2c0547c91d8b5... 0 0 \n", "01a28b44a832a0a35949a680fae963ad86563f389a26356... 0 0 \n", "01b1a76315c3c1bb3b08616eba3e9fd98cb8471a0f7ce5b... 0 0 \n", "01e0e2d91144b15862e929591bfa30f74fb0757e50476e8... 0 0 \n", "023e16af29b004681ac4248606d06658267fe730ba581f0... 0 0 \n", "02463a4dc6a661eeb8607333c2dc3d0a3ec4c9a40d93354... 0 0 \n", "026c164abb5f644eacb3d02798c1571c01713e64d76e725... 0 0 \n", "027b046d6acb430991e79e54e08a5bef371aa35e3be4fe7... 0 0 \n", "02c5eae6ef36dd5886912fdead95a60865309e5abcf0ad1... 0 1 \n", "02d5efb4f7a7ed421530724c7318523511635c02aa0578c... 0 0 \n", "02f218e640b27885de2ccdb7c3f22a2acb9a296a012505b... 0 0 \n", "030102e337802b33a467fa3fa2f433c2d51f14718943c57... 0 0 \n", "03978b65107fe576a1bba38f76d41e71297eec5f58ee113... 0 0 \n", "03b0c44873c147ca39167e0ca031f836ffe47cca7b66c82... 0 0 \n", "040f584138f13122be9de6803bca77edbf396471e8d1767... 0 0 \n", "04194617a57a88bdb5eea3038ab6a40bac6f9751373efcc... 0 0 \n", "041d27961b44602fa01fc6b758195ed73d6d106efa3c332... 0 0 \n", "043051b1d8db2a9d2e51ccbb432feb7648574e67e79c3e6... 0 0 \n", "043051b1d8db2a9d2e51ccbb432feb7648574e67e79c3e6... 0 0 \n", "043051b1d8db2a9d2e51ccbb432feb7648574e67e79c3e6... 0 1 \n", "048af26f61363f8863f847f69ec338ba1a5b13bf4d99b08... 0 0 \n", "0497476bd0bbbcdd0bba1ee900079a7ec876954ac2140c9... 0 0 \n", "04cbdf2eb46e941754bbf230db51b76258d556c1cc57bb5... 1 0 \n", "04d71a14825027e0454445d8f090c17e07806d6bf0592e3... 0 0 \n", "05bbaa2c91ce9d45eb654cbbb94071dcfeb16656dd4bad1... 0 1 \n", "05d7cf732a82c475b56ffddf6bbfdc12180e3faf29c72e8... 0 0 \n", "05e1efce4d5e538cff3f0fc9439c0e6e2ef2f1420b21b1d... 0 0 \n", "06262d3c9daef003c19dbfb3b9c9f6976d9c190e4a455a5... 1 0 \n", "065346df86cf995e2d22782120e05422e955070a4c06511... 0 0 \n", "... ... ... \n", "faeaafabb538ca92e3c6226c775a97a5b3b336ddcb41fa6... 0 0 \n", "fb10289594bb1da49eb3241022628ad3ec6a24cdb900812... 0 1 \n", "fb26c5d622129e969e2fa17ac1ef130231b6894ee309b4c... 0 0 \n", "fb26c5d622129e969e2fa17ac1ef130231b6894ee309b4c... 0 0 \n", "fb26c5d622129e969e2fa17ac1ef130231b6894ee309b4c... 0 0 \n", "fb27439e6959b435aec64aadf34df15948b086c9e4df235... 0 0 \n", "fb513c34a472046a10ec14b8f9a5c6de55e3e30ecac5221... 0 0 \n", "fbaa5a96fa9860917ba9a6eb4ce5c2001b18c330afd4a74... 0 0 \n", "fbd145967d33641676baa21832c06f5fd3268bec3b0133f... 0 0 \n", "fbd7080dea62e2e47b21dc9a2d2488a8b045f36c6137222... 0 0 \n", "fbed55eef282ecf6bea8f3bbeac967e2b859fca5239947a... 0 0 \n", "fbef1f2eefbb380721d1b908a45c7bdf84a2dad2f34d49b... 0 0 \n", "fc93cc3a74e99fc5325b951abeba1fc142ce354c5824601... 0 1 \n", "fcd76f264472c9ee6727bf1bcb418a51880e020ba12127f... 0 0 \n", "fcd76f264472c9ee6727bf1bcb418a51880e020ba12127f... 0 0 \n", "fceb27bb78f34e82bee2d1b1362ff27207828979e201e64... 0 1 \n", "fcf6564d2a10dd392a376aa23ff6ac19846fc8f5564beb1... 0 0 \n", "fda422842e8e6bf0cc291d048b792d76a293c021319f588... 0 0 \n", "fdbde899b8f6b58595afb42de2337ecfcb066481f848f9f... 1 1 \n", "fdca2182a7ca43056ccc3a8cf95567396468ddcca1e6fd6... 0 0 \n", "fdd431cab47cf62c4be70e4e05bbd48001edf641c1136c4... 0 0 \n", "fe26e5d679dc1f6a733c8bfa9e7337501d5d127a21a337d... 0 0 \n", "fe33c5a8da4dcefc16d5db744a5f18d898805996de2016a... 0 0 \n", "fe7a693c020f03fa62e704e29d0db643248426fca3df6b4... 0 0 \n", "fe943a72a4b8ce3a4e5b42511ed72f53e241a3630ef4343... 0 0 \n", "fe943a72a4b8ce3a4e5b42511ed72f53e241a3630ef4343... 0 0 \n", "fed9a9b0dcbeba81cf56c5b9963cced64f7827a554a0598... 0 0 \n", "fef709daecdf01a6164df79083f8a55c2c32f939d0f7199... 0 0 \n", "ff5f650c4fc31086d3b9ea116434ab284714ac317249153... 0 1 \n", "ffb521745ac8de7c4715080c46451472f0567736e1206d8... 0 0 \n", "\n", "item Jewelry Jewelry \\\n", "transaction_id \n", "00de91ae00bb2fea1d7e9953d2da87740c7340ddbe5a2ec... 0 0 \n", "0132bfb1ddb43b86872150aa5d5beb506b2c0547c91d8b5... 0 0 \n", "01a28b44a832a0a35949a680fae963ad86563f389a26356... 0 0 \n", "01b1a76315c3c1bb3b08616eba3e9fd98cb8471a0f7ce5b... 0 0 \n", "01e0e2d91144b15862e929591bfa30f74fb0757e50476e8... 0 0 \n", "023e16af29b004681ac4248606d06658267fe730ba581f0... 0 0 \n", "02463a4dc6a661eeb8607333c2dc3d0a3ec4c9a40d93354... 0 0 \n", "026c164abb5f644eacb3d02798c1571c01713e64d76e725... 0 0 \n", "027b046d6acb430991e79e54e08a5bef371aa35e3be4fe7... 0 0 \n", "02c5eae6ef36dd5886912fdead95a60865309e5abcf0ad1... 0 0 \n", "02d5efb4f7a7ed421530724c7318523511635c02aa0578c... 0 0 \n", "02f218e640b27885de2ccdb7c3f22a2acb9a296a012505b... 0 0 \n", "030102e337802b33a467fa3fa2f433c2d51f14718943c57... 0 0 \n", "03978b65107fe576a1bba38f76d41e71297eec5f58ee113... 0 0 \n", "03b0c44873c147ca39167e0ca031f836ffe47cca7b66c82... 0 0 \n", "040f584138f13122be9de6803bca77edbf396471e8d1767... 0 0 \n", "04194617a57a88bdb5eea3038ab6a40bac6f9751373efcc... 0 0 \n", "041d27961b44602fa01fc6b758195ed73d6d106efa3c332... 0 0 \n", "043051b1d8db2a9d2e51ccbb432feb7648574e67e79c3e6... 0 0 \n", "043051b1d8db2a9d2e51ccbb432feb7648574e67e79c3e6... 0 0 \n", "043051b1d8db2a9d2e51ccbb432feb7648574e67e79c3e6... 0 0 \n", "048af26f61363f8863f847f69ec338ba1a5b13bf4d99b08... 0 0 \n", "0497476bd0bbbcdd0bba1ee900079a7ec876954ac2140c9... 0 1 \n", "04cbdf2eb46e941754bbf230db51b76258d556c1cc57bb5... 0 0 \n", "04d71a14825027e0454445d8f090c17e07806d6bf0592e3... 0 0 \n", "05bbaa2c91ce9d45eb654cbbb94071dcfeb16656dd4bad1... 0 0 \n", "05d7cf732a82c475b56ffddf6bbfdc12180e3faf29c72e8... 0 0 \n", "05e1efce4d5e538cff3f0fc9439c0e6e2ef2f1420b21b1d... 0 0 \n", "06262d3c9daef003c19dbfb3b9c9f6976d9c190e4a455a5... 0 0 \n", "065346df86cf995e2d22782120e05422e955070a4c06511... 0 0 \n", "... ... ... \n", "faeaafabb538ca92e3c6226c775a97a5b3b336ddcb41fa6... 0 0 \n", "fb10289594bb1da49eb3241022628ad3ec6a24cdb900812... 0 0 \n", "fb26c5d622129e969e2fa17ac1ef130231b6894ee309b4c... 0 0 \n", "fb26c5d622129e969e2fa17ac1ef130231b6894ee309b4c... 0 0 \n", "fb26c5d622129e969e2fa17ac1ef130231b6894ee309b4c... 0 1 \n", "fb27439e6959b435aec64aadf34df15948b086c9e4df235... 0 0 \n", "fb513c34a472046a10ec14b8f9a5c6de55e3e30ecac5221... 0 0 \n", "fbaa5a96fa9860917ba9a6eb4ce5c2001b18c330afd4a74... 0 1 \n", "fbd145967d33641676baa21832c06f5fd3268bec3b0133f... 0 0 \n", "fbd7080dea62e2e47b21dc9a2d2488a8b045f36c6137222... 0 0 \n", "fbed55eef282ecf6bea8f3bbeac967e2b859fca5239947a... 0 0 \n", "fbef1f2eefbb380721d1b908a45c7bdf84a2dad2f34d49b... 0 0 \n", "fc93cc3a74e99fc5325b951abeba1fc142ce354c5824601... 0 0 \n", "fcd76f264472c9ee6727bf1bcb418a51880e020ba12127f... 0 0 \n", "fcd76f264472c9ee6727bf1bcb418a51880e020ba12127f... 0 0 \n", "fceb27bb78f34e82bee2d1b1362ff27207828979e201e64... 0 0 \n", "fcf6564d2a10dd392a376aa23ff6ac19846fc8f5564beb1... 0 0 \n", "fda422842e8e6bf0cc291d048b792d76a293c021319f588... 0 0 \n", "fdbde899b8f6b58595afb42de2337ecfcb066481f848f9f... 0 0 \n", "fdca2182a7ca43056ccc3a8cf95567396468ddcca1e6fd6... 0 0 \n", "fdd431cab47cf62c4be70e4e05bbd48001edf641c1136c4... 0 0 \n", "fe26e5d679dc1f6a733c8bfa9e7337501d5d127a21a337d... 0 0 \n", "fe33c5a8da4dcefc16d5db744a5f18d898805996de2016a... 1 0 \n", "fe7a693c020f03fa62e704e29d0db643248426fca3df6b4... 0 0 \n", "fe943a72a4b8ce3a4e5b42511ed72f53e241a3630ef4343... 0 0 \n", "fe943a72a4b8ce3a4e5b42511ed72f53e241a3630ef4343... 0 0 \n", "fed9a9b0dcbeba81cf56c5b9963cced64f7827a554a0598... 0 0 \n", "fef709daecdf01a6164df79083f8a55c2c32f939d0f7199... 0 0 \n", "ff5f650c4fc31086d3b9ea116434ab284714ac317249153... 0 0 \n", "ffb521745ac8de7c4715080c46451472f0567736e1206d8... 0 0 \n", "\n", "item Kids Apprl Memorabili \\\n", "transaction_id \n", "00de91ae00bb2fea1d7e9953d2da87740c7340ddbe5a2ec... 0 0 \n", "0132bfb1ddb43b86872150aa5d5beb506b2c0547c91d8b5... 0 0 \n", "01a28b44a832a0a35949a680fae963ad86563f389a26356... 0 0 \n", "01b1a76315c3c1bb3b08616eba3e9fd98cb8471a0f7ce5b... 0 0 \n", "01e0e2d91144b15862e929591bfa30f74fb0757e50476e8... 0 0 \n", "023e16af29b004681ac4248606d06658267fe730ba581f0... 0 0 \n", "02463a4dc6a661eeb8607333c2dc3d0a3ec4c9a40d93354... 0 0 \n", "026c164abb5f644eacb3d02798c1571c01713e64d76e725... 0 0 \n", "027b046d6acb430991e79e54e08a5bef371aa35e3be4fe7... 0 0 \n", "02c5eae6ef36dd5886912fdead95a60865309e5abcf0ad1... 0 0 \n", "02d5efb4f7a7ed421530724c7318523511635c02aa0578c... 0 0 \n", "02f218e640b27885de2ccdb7c3f22a2acb9a296a012505b... 0 0 \n", "030102e337802b33a467fa3fa2f433c2d51f14718943c57... 0 0 \n", "03978b65107fe576a1bba38f76d41e71297eec5f58ee113... 0 0 \n", "03b0c44873c147ca39167e0ca031f836ffe47cca7b66c82... 0 0 \n", "040f584138f13122be9de6803bca77edbf396471e8d1767... 0 0 \n", "04194617a57a88bdb5eea3038ab6a40bac6f9751373efcc... 0 0 \n", "041d27961b44602fa01fc6b758195ed73d6d106efa3c332... 0 0 \n", "043051b1d8db2a9d2e51ccbb432feb7648574e67e79c3e6... 0 0 \n", "043051b1d8db2a9d2e51ccbb432feb7648574e67e79c3e6... 0 0 \n", "043051b1d8db2a9d2e51ccbb432feb7648574e67e79c3e6... 0 0 \n", "048af26f61363f8863f847f69ec338ba1a5b13bf4d99b08... 0 0 \n", "0497476bd0bbbcdd0bba1ee900079a7ec876954ac2140c9... 0 0 \n", "04cbdf2eb46e941754bbf230db51b76258d556c1cc57bb5... 0 0 \n", "04d71a14825027e0454445d8f090c17e07806d6bf0592e3... 0 0 \n", "05bbaa2c91ce9d45eb654cbbb94071dcfeb16656dd4bad1... 0 0 \n", "05d7cf732a82c475b56ffddf6bbfdc12180e3faf29c72e8... 0 0 \n", "05e1efce4d5e538cff3f0fc9439c0e6e2ef2f1420b21b1d... 0 0 \n", "06262d3c9daef003c19dbfb3b9c9f6976d9c190e4a455a5... 0 0 \n", "065346df86cf995e2d22782120e05422e955070a4c06511... 0 0 \n", "... ... ... \n", "faeaafabb538ca92e3c6226c775a97a5b3b336ddcb41fa6... 0 0 \n", "fb10289594bb1da49eb3241022628ad3ec6a24cdb900812... 0 0 \n", "fb26c5d622129e969e2fa17ac1ef130231b6894ee309b4c... 0 0 \n", "fb26c5d622129e969e2fa17ac1ef130231b6894ee309b4c... 0 0 \n", "fb26c5d622129e969e2fa17ac1ef130231b6894ee309b4c... 0 0 \n", "fb27439e6959b435aec64aadf34df15948b086c9e4df235... 0 0 \n", "fb513c34a472046a10ec14b8f9a5c6de55e3e30ecac5221... 0 0 \n", "fbaa5a96fa9860917ba9a6eb4ce5c2001b18c330afd4a74... 0 0 \n", "fbd145967d33641676baa21832c06f5fd3268bec3b0133f... 0 0 \n", "fbd7080dea62e2e47b21dc9a2d2488a8b045f36c6137222... 0 0 \n", "fbed55eef282ecf6bea8f3bbeac967e2b859fca5239947a... 0 0 \n", "fbef1f2eefbb380721d1b908a45c7bdf84a2dad2f34d49b... 0 0 \n", "fc93cc3a74e99fc5325b951abeba1fc142ce354c5824601... 0 0 \n", "fcd76f264472c9ee6727bf1bcb418a51880e020ba12127f... 0 0 \n", "fcd76f264472c9ee6727bf1bcb418a51880e020ba12127f... 0 0 \n", "fceb27bb78f34e82bee2d1b1362ff27207828979e201e64... 0 0 \n", "fcf6564d2a10dd392a376aa23ff6ac19846fc8f5564beb1... 0 0 \n", "fda422842e8e6bf0cc291d048b792d76a293c021319f588... 0 0 \n", "fdbde899b8f6b58595afb42de2337ecfcb066481f848f9f... 0 0 \n", "fdca2182a7ca43056ccc3a8cf95567396468ddcca1e6fd6... 0 0 \n", "fdd431cab47cf62c4be70e4e05bbd48001edf641c1136c4... 0 0 \n", "fe26e5d679dc1f6a733c8bfa9e7337501d5d127a21a337d... 0 0 \n", "fe33c5a8da4dcefc16d5db744a5f18d898805996de2016a... 0 0 \n", "fe7a693c020f03fa62e704e29d0db643248426fca3df6b4... 0 0 \n", "fe943a72a4b8ce3a4e5b42511ed72f53e241a3630ef4343... 0 0 \n", "fe943a72a4b8ce3a4e5b42511ed72f53e241a3630ef4343... 0 0 \n", "fed9a9b0dcbeba81cf56c5b9963cced64f7827a554a0598... 0 0 \n", "fef709daecdf01a6164df79083f8a55c2c32f939d0f7199... 0 0 \n", "ff5f650c4fc31086d3b9ea116434ab284714ac317249153... 0 0 \n", "ffb521745ac8de7c4715080c46451472f0567736e1206d8... 0 0 \n", "\n", "item Mens Apprl Mens Apprl \\\n", "transaction_id \n", "00de91ae00bb2fea1d7e9953d2da87740c7340ddbe5a2ec... 0 0 \n", "0132bfb1ddb43b86872150aa5d5beb506b2c0547c91d8b5... 0 0 \n", "01a28b44a832a0a35949a680fae963ad86563f389a26356... 0 0 \n", "01b1a76315c3c1bb3b08616eba3e9fd98cb8471a0f7ce5b... 0 0 \n", "01e0e2d91144b15862e929591bfa30f74fb0757e50476e8... 0 0 \n", "023e16af29b004681ac4248606d06658267fe730ba581f0... 0 0 \n", "02463a4dc6a661eeb8607333c2dc3d0a3ec4c9a40d93354... 0 0 \n", "026c164abb5f644eacb3d02798c1571c01713e64d76e725... 0 0 \n", "027b046d6acb430991e79e54e08a5bef371aa35e3be4fe7... 0 0 \n", "02c5eae6ef36dd5886912fdead95a60865309e5abcf0ad1... 0 0 \n", "02d5efb4f7a7ed421530724c7318523511635c02aa0578c... 0 0 \n", "02f218e640b27885de2ccdb7c3f22a2acb9a296a012505b... 0 0 \n", "030102e337802b33a467fa3fa2f433c2d51f14718943c57... 0 0 \n", "03978b65107fe576a1bba38f76d41e71297eec5f58ee113... 0 0 \n", "03b0c44873c147ca39167e0ca031f836ffe47cca7b66c82... 0 0 \n", "040f584138f13122be9de6803bca77edbf396471e8d1767... 0 0 \n", "04194617a57a88bdb5eea3038ab6a40bac6f9751373efcc... 0 0 \n", "041d27961b44602fa01fc6b758195ed73d6d106efa3c332... 0 0 \n", "043051b1d8db2a9d2e51ccbb432feb7648574e67e79c3e6... 0 0 \n", "043051b1d8db2a9d2e51ccbb432feb7648574e67e79c3e6... 0 0 \n", "043051b1d8db2a9d2e51ccbb432feb7648574e67e79c3e6... 0 0 \n", "048af26f61363f8863f847f69ec338ba1a5b13bf4d99b08... 0 0 \n", "0497476bd0bbbcdd0bba1ee900079a7ec876954ac2140c9... 0 0 \n", "04cbdf2eb46e941754bbf230db51b76258d556c1cc57bb5... 0 0 \n", "04d71a14825027e0454445d8f090c17e07806d6bf0592e3... 0 0 \n", "05bbaa2c91ce9d45eb654cbbb94071dcfeb16656dd4bad1... 0 0 \n", "05d7cf732a82c475b56ffddf6bbfdc12180e3faf29c72e8... 0 0 \n", "05e1efce4d5e538cff3f0fc9439c0e6e2ef2f1420b21b1d... 0 0 \n", "06262d3c9daef003c19dbfb3b9c9f6976d9c190e4a455a5... 0 0 \n", "065346df86cf995e2d22782120e05422e955070a4c06511... 0 0 \n", "... ... ... \n", "faeaafabb538ca92e3c6226c775a97a5b3b336ddcb41fa6... 0 0 \n", "fb10289594bb1da49eb3241022628ad3ec6a24cdb900812... 0 0 \n", "fb26c5d622129e969e2fa17ac1ef130231b6894ee309b4c... 0 0 \n", "fb26c5d622129e969e2fa17ac1ef130231b6894ee309b4c... 0 0 \n", "fb26c5d622129e969e2fa17ac1ef130231b6894ee309b4c... 0 0 \n", "fb27439e6959b435aec64aadf34df15948b086c9e4df235... 0 0 \n", "fb513c34a472046a10ec14b8f9a5c6de55e3e30ecac5221... 0 0 \n", "fbaa5a96fa9860917ba9a6eb4ce5c2001b18c330afd4a74... 0 0 \n", "fbd145967d33641676baa21832c06f5fd3268bec3b0133f... 0 0 \n", "fbd7080dea62e2e47b21dc9a2d2488a8b045f36c6137222... 0 0 \n", "fbed55eef282ecf6bea8f3bbeac967e2b859fca5239947a... 0 0 \n", "fbef1f2eefbb380721d1b908a45c7bdf84a2dad2f34d49b... 0 0 \n", "fc93cc3a74e99fc5325b951abeba1fc142ce354c5824601... 0 0 \n", "fcd76f264472c9ee6727bf1bcb418a51880e020ba12127f... 0 0 \n", "fcd76f264472c9ee6727bf1bcb418a51880e020ba12127f... 0 0 \n", "fceb27bb78f34e82bee2d1b1362ff27207828979e201e64... 0 0 \n", "fcf6564d2a10dd392a376aa23ff6ac19846fc8f5564beb1... 0 0 \n", "fda422842e8e6bf0cc291d048b792d76a293c021319f588... 0 0 \n", "fdbde899b8f6b58595afb42de2337ecfcb066481f848f9f... 0 0 \n", "fdca2182a7ca43056ccc3a8cf95567396468ddcca1e6fd6... 0 0 \n", "fdd431cab47cf62c4be70e4e05bbd48001edf641c1136c4... 0 0 \n", "fe26e5d679dc1f6a733c8bfa9e7337501d5d127a21a337d... 0 1 \n", "fe33c5a8da4dcefc16d5db744a5f18d898805996de2016a... 0 0 \n", "fe7a693c020f03fa62e704e29d0db643248426fca3df6b4... 0 0 \n", "fe943a72a4b8ce3a4e5b42511ed72f53e241a3630ef4343... 0 0 \n", "fe943a72a4b8ce3a4e5b42511ed72f53e241a3630ef4343... 0 0 \n", "fed9a9b0dcbeba81cf56c5b9963cced64f7827a554a0598... 0 0 \n", "fef709daecdf01a6164df79083f8a55c2c32f939d0f7199... 0 0 \n", "ff5f650c4fc31086d3b9ea116434ab284714ac317249153... 0 0 \n", "ffb521745ac8de7c4715080c46451472f0567736e1206d8... 0 0 \n", "\n", "item Noncatwear Print Item \\\n", "transaction_id \n", "00de91ae00bb2fea1d7e9953d2da87740c7340ddbe5a2ec... 0 0 \n", "0132bfb1ddb43b86872150aa5d5beb506b2c0547c91d8b5... 0 0 \n", "01a28b44a832a0a35949a680fae963ad86563f389a26356... 0 0 \n", "01b1a76315c3c1bb3b08616eba3e9fd98cb8471a0f7ce5b... 0 0 \n", "01e0e2d91144b15862e929591bfa30f74fb0757e50476e8... 0 0 \n", "023e16af29b004681ac4248606d06658267fe730ba581f0... 0 0 \n", "02463a4dc6a661eeb8607333c2dc3d0a3ec4c9a40d93354... 0 0 \n", "026c164abb5f644eacb3d02798c1571c01713e64d76e725... 0 0 \n", "027b046d6acb430991e79e54e08a5bef371aa35e3be4fe7... 0 0 \n", "02c5eae6ef36dd5886912fdead95a60865309e5abcf0ad1... 0 0 \n", "02d5efb4f7a7ed421530724c7318523511635c02aa0578c... 0 0 \n", "02f218e640b27885de2ccdb7c3f22a2acb9a296a012505b... 0 0 \n", "030102e337802b33a467fa3fa2f433c2d51f14718943c57... 0 0 \n", "03978b65107fe576a1bba38f76d41e71297eec5f58ee113... 0 0 \n", "03b0c44873c147ca39167e0ca031f836ffe47cca7b66c82... 0 0 \n", "040f584138f13122be9de6803bca77edbf396471e8d1767... 0 0 \n", "04194617a57a88bdb5eea3038ab6a40bac6f9751373efcc... 0 0 \n", "041d27961b44602fa01fc6b758195ed73d6d106efa3c332... 1 0 \n", "043051b1d8db2a9d2e51ccbb432feb7648574e67e79c3e6... 0 0 \n", "043051b1d8db2a9d2e51ccbb432feb7648574e67e79c3e6... 0 0 \n", "043051b1d8db2a9d2e51ccbb432feb7648574e67e79c3e6... 0 0 \n", "048af26f61363f8863f847f69ec338ba1a5b13bf4d99b08... 0 0 \n", "0497476bd0bbbcdd0bba1ee900079a7ec876954ac2140c9... 0 0 \n", "04cbdf2eb46e941754bbf230db51b76258d556c1cc57bb5... 1 0 \n", "04d71a14825027e0454445d8f090c17e07806d6bf0592e3... 0 0 \n", "05bbaa2c91ce9d45eb654cbbb94071dcfeb16656dd4bad1... 0 0 \n", "05d7cf732a82c475b56ffddf6bbfdc12180e3faf29c72e8... 1 0 \n", "05e1efce4d5e538cff3f0fc9439c0e6e2ef2f1420b21b1d... 0 0 \n", "06262d3c9daef003c19dbfb3b9c9f6976d9c190e4a455a5... 0 0 \n", "065346df86cf995e2d22782120e05422e955070a4c06511... 0 0 \n", "... ... ... \n", "faeaafabb538ca92e3c6226c775a97a5b3b336ddcb41fa6... 0 0 \n", "fb10289594bb1da49eb3241022628ad3ec6a24cdb900812... 0 0 \n", "fb26c5d622129e969e2fa17ac1ef130231b6894ee309b4c... 0 0 \n", "fb26c5d622129e969e2fa17ac1ef130231b6894ee309b4c... 0 0 \n", "fb26c5d622129e969e2fa17ac1ef130231b6894ee309b4c... 0 0 \n", "fb27439e6959b435aec64aadf34df15948b086c9e4df235... 1 0 \n", "fb513c34a472046a10ec14b8f9a5c6de55e3e30ecac5221... 0 0 \n", "fbaa5a96fa9860917ba9a6eb4ce5c2001b18c330afd4a74... 0 0 \n", "fbd145967d33641676baa21832c06f5fd3268bec3b0133f... 0 0 \n", "fbd7080dea62e2e47b21dc9a2d2488a8b045f36c6137222... 0 0 \n", "fbed55eef282ecf6bea8f3bbeac967e2b859fca5239947a... 0 0 \n", "fbef1f2eefbb380721d1b908a45c7bdf84a2dad2f34d49b... 0 0 \n", "fc93cc3a74e99fc5325b951abeba1fc142ce354c5824601... 0 0 \n", "fcd76f264472c9ee6727bf1bcb418a51880e020ba12127f... 0 0 \n", "fcd76f264472c9ee6727bf1bcb418a51880e020ba12127f... 0 0 \n", "fceb27bb78f34e82bee2d1b1362ff27207828979e201e64... 0 0 \n", "fcf6564d2a10dd392a376aa23ff6ac19846fc8f5564beb1... 0 0 \n", "fda422842e8e6bf0cc291d048b792d76a293c021319f588... 0 0 \n", "fdbde899b8f6b58595afb42de2337ecfcb066481f848f9f... 0 0 \n", "fdca2182a7ca43056ccc3a8cf95567396468ddcca1e6fd6... 0 0 \n", "fdd431cab47cf62c4be70e4e05bbd48001edf641c1136c4... 0 0 \n", "fe26e5d679dc1f6a733c8bfa9e7337501d5d127a21a337d... 0 0 \n", "fe33c5a8da4dcefc16d5db744a5f18d898805996de2016a... 0 0 \n", "fe7a693c020f03fa62e704e29d0db643248426fca3df6b4... 0 0 \n", "fe943a72a4b8ce3a4e5b42511ed72f53e241a3630ef4343... 0 0 \n", "fe943a72a4b8ce3a4e5b42511ed72f53e241a3630ef4343... 0 0 \n", "fed9a9b0dcbeba81cf56c5b9963cced64f7827a554a0598... 0 0 \n", "fef709daecdf01a6164df79083f8a55c2c32f939d0f7199... 0 0 \n", "ff5f650c4fc31086d3b9ea116434ab284714ac317249153... 0 0 \n", "ffb521745ac8de7c4715080c46451472f0567736e1206d8... 1 0 \n", "\n", "item Print Item SmallStuff \\\n", "transaction_id \n", "00de91ae00bb2fea1d7e9953d2da87740c7340ddbe5a2ec... 1 0 \n", "0132bfb1ddb43b86872150aa5d5beb506b2c0547c91d8b5... 0 0 \n", "01a28b44a832a0a35949a680fae963ad86563f389a26356... 0 0 \n", "01b1a76315c3c1bb3b08616eba3e9fd98cb8471a0f7ce5b... 0 0 \n", "01e0e2d91144b15862e929591bfa30f74fb0757e50476e8... 0 0 \n", "023e16af29b004681ac4248606d06658267fe730ba581f0... 0 0 \n", "02463a4dc6a661eeb8607333c2dc3d0a3ec4c9a40d93354... 0 0 \n", "026c164abb5f644eacb3d02798c1571c01713e64d76e725... 1 0 \n", "027b046d6acb430991e79e54e08a5bef371aa35e3be4fe7... 1 0 \n", "02c5eae6ef36dd5886912fdead95a60865309e5abcf0ad1... 0 0 \n", "02d5efb4f7a7ed421530724c7318523511635c02aa0578c... 1 0 \n", "02f218e640b27885de2ccdb7c3f22a2acb9a296a012505b... 1 0 \n", "030102e337802b33a467fa3fa2f433c2d51f14718943c57... 0 0 \n", "03978b65107fe576a1bba38f76d41e71297eec5f58ee113... 1 0 \n", "03b0c44873c147ca39167e0ca031f836ffe47cca7b66c82... 0 0 \n", "040f584138f13122be9de6803bca77edbf396471e8d1767... 1 0 \n", "04194617a57a88bdb5eea3038ab6a40bac6f9751373efcc... 0 0 \n", "041d27961b44602fa01fc6b758195ed73d6d106efa3c332... 0 0 \n", "043051b1d8db2a9d2e51ccbb432feb7648574e67e79c3e6... 1 0 \n", "043051b1d8db2a9d2e51ccbb432feb7648574e67e79c3e6... 0 0 \n", "043051b1d8db2a9d2e51ccbb432feb7648574e67e79c3e6... 0 0 \n", "048af26f61363f8863f847f69ec338ba1a5b13bf4d99b08... 0 0 \n", "0497476bd0bbbcdd0bba1ee900079a7ec876954ac2140c9... 0 0 \n", "04cbdf2eb46e941754bbf230db51b76258d556c1cc57bb5... 0 0 \n", "04d71a14825027e0454445d8f090c17e07806d6bf0592e3... 0 0 \n", "05bbaa2c91ce9d45eb654cbbb94071dcfeb16656dd4bad1... 0 0 \n", "05d7cf732a82c475b56ffddf6bbfdc12180e3faf29c72e8... 0 0 \n", "05e1efce4d5e538cff3f0fc9439c0e6e2ef2f1420b21b1d... 0 0 \n", "06262d3c9daef003c19dbfb3b9c9f6976d9c190e4a455a5... 0 0 \n", "065346df86cf995e2d22782120e05422e955070a4c06511... 0 1 \n", "... ... ... \n", "faeaafabb538ca92e3c6226c775a97a5b3b336ddcb41fa6... 0 0 \n", "fb10289594bb1da49eb3241022628ad3ec6a24cdb900812... 0 0 \n", "fb26c5d622129e969e2fa17ac1ef130231b6894ee309b4c... 1 0 \n", "fb26c5d622129e969e2fa17ac1ef130231b6894ee309b4c... 0 0 \n", "fb26c5d622129e969e2fa17ac1ef130231b6894ee309b4c... 0 0 \n", "fb27439e6959b435aec64aadf34df15948b086c9e4df235... 0 0 \n", "fb513c34a472046a10ec14b8f9a5c6de55e3e30ecac5221... 0 0 \n", "fbaa5a96fa9860917ba9a6eb4ce5c2001b18c330afd4a74... 0 0 \n", "fbd145967d33641676baa21832c06f5fd3268bec3b0133f... 0 0 \n", "fbd7080dea62e2e47b21dc9a2d2488a8b045f36c6137222... 1 0 \n", "fbed55eef282ecf6bea8f3bbeac967e2b859fca5239947a... 0 0 \n", "fbef1f2eefbb380721d1b908a45c7bdf84a2dad2f34d49b... 0 0 \n", "fc93cc3a74e99fc5325b951abeba1fc142ce354c5824601... 0 0 \n", "fcd76f264472c9ee6727bf1bcb418a51880e020ba12127f... 0 0 \n", "fcd76f264472c9ee6727bf1bcb418a51880e020ba12127f... 0 0 \n", "fceb27bb78f34e82bee2d1b1362ff27207828979e201e64... 0 0 \n", "fcf6564d2a10dd392a376aa23ff6ac19846fc8f5564beb1... 0 0 \n", "fda422842e8e6bf0cc291d048b792d76a293c021319f588... 0 0 \n", "fdbde899b8f6b58595afb42de2337ecfcb066481f848f9f... 0 0 \n", "fdca2182a7ca43056ccc3a8cf95567396468ddcca1e6fd6... 0 0 \n", "fdd431cab47cf62c4be70e4e05bbd48001edf641c1136c4... 0 0 \n", "fe26e5d679dc1f6a733c8bfa9e7337501d5d127a21a337d... 0 0 \n", "fe33c5a8da4dcefc16d5db744a5f18d898805996de2016a... 0 0 \n", "fe7a693c020f03fa62e704e29d0db643248426fca3df6b4... 0 0 \n", "fe943a72a4b8ce3a4e5b42511ed72f53e241a3630ef4343... 0 0 \n", "fe943a72a4b8ce3a4e5b42511ed72f53e241a3630ef4343... 0 0 \n", "fed9a9b0dcbeba81cf56c5b9963cced64f7827a554a0598... 0 0 \n", "fef709daecdf01a6164df79083f8a55c2c32f939d0f7199... 1 0 \n", "ff5f650c4fc31086d3b9ea116434ab284714ac317249153... 0 0 \n", "ffb521745ac8de7c4715080c46451472f0567736e1206d8... 0 0 \n", "\n", "item Unisx Appl Unisx Appl \\\n", "transaction_id \n", "00de91ae00bb2fea1d7e9953d2da87740c7340ddbe5a2ec... 0 0 \n", "0132bfb1ddb43b86872150aa5d5beb506b2c0547c91d8b5... 0 0 \n", "01a28b44a832a0a35949a680fae963ad86563f389a26356... 1 0 \n", "01b1a76315c3c1bb3b08616eba3e9fd98cb8471a0f7ce5b... 0 0 \n", "01e0e2d91144b15862e929591bfa30f74fb0757e50476e8... 1 0 \n", "023e16af29b004681ac4248606d06658267fe730ba581f0... 1 0 \n", "02463a4dc6a661eeb8607333c2dc3d0a3ec4c9a40d93354... 1 0 \n", "026c164abb5f644eacb3d02798c1571c01713e64d76e725... 0 0 \n", "027b046d6acb430991e79e54e08a5bef371aa35e3be4fe7... 0 0 \n", "02c5eae6ef36dd5886912fdead95a60865309e5abcf0ad1... 0 0 \n", "02d5efb4f7a7ed421530724c7318523511635c02aa0578c... 0 0 \n", "02f218e640b27885de2ccdb7c3f22a2acb9a296a012505b... 1 0 \n", "030102e337802b33a467fa3fa2f433c2d51f14718943c57... 0 0 \n", "03978b65107fe576a1bba38f76d41e71297eec5f58ee113... 0 0 \n", "03b0c44873c147ca39167e0ca031f836ffe47cca7b66c82... 1 0 \n", "040f584138f13122be9de6803bca77edbf396471e8d1767... 1 1 \n", "04194617a57a88bdb5eea3038ab6a40bac6f9751373efcc... 0 0 \n", "041d27961b44602fa01fc6b758195ed73d6d106efa3c332... 0 0 \n", "043051b1d8db2a9d2e51ccbb432feb7648574e67e79c3e6... 0 0 \n", "043051b1d8db2a9d2e51ccbb432feb7648574e67e79c3e6... 0 0 \n", "043051b1d8db2a9d2e51ccbb432feb7648574e67e79c3e6... 0 0 \n", "048af26f61363f8863f847f69ec338ba1a5b13bf4d99b08... 0 0 \n", "0497476bd0bbbcdd0bba1ee900079a7ec876954ac2140c9... 1 0 \n", "04cbdf2eb46e941754bbf230db51b76258d556c1cc57bb5... 0 0 \n", "04d71a14825027e0454445d8f090c17e07806d6bf0592e3... 0 0 \n", "05bbaa2c91ce9d45eb654cbbb94071dcfeb16656dd4bad1... 0 0 \n", "05d7cf732a82c475b56ffddf6bbfdc12180e3faf29c72e8... 0 0 \n", "05e1efce4d5e538cff3f0fc9439c0e6e2ef2f1420b21b1d... 1 0 \n", "06262d3c9daef003c19dbfb3b9c9f6976d9c190e4a455a5... 0 0 \n", "065346df86cf995e2d22782120e05422e955070a4c06511... 0 0 \n", "... ... ... \n", "faeaafabb538ca92e3c6226c775a97a5b3b336ddcb41fa6... 0 0 \n", "fb10289594bb1da49eb3241022628ad3ec6a24cdb900812... 1 0 \n", "fb26c5d622129e969e2fa17ac1ef130231b6894ee309b4c... 0 0 \n", "fb26c5d622129e969e2fa17ac1ef130231b6894ee309b4c... 1 0 \n", "fb26c5d622129e969e2fa17ac1ef130231b6894ee309b4c... 0 0 \n", "fb27439e6959b435aec64aadf34df15948b086c9e4df235... 0 0 \n", "fb513c34a472046a10ec14b8f9a5c6de55e3e30ecac5221... 1 0 \n", "fbaa5a96fa9860917ba9a6eb4ce5c2001b18c330afd4a74... 0 0 \n", "fbd145967d33641676baa21832c06f5fd3268bec3b0133f... 0 1 \n", "fbd7080dea62e2e47b21dc9a2d2488a8b045f36c6137222... 0 0 \n", "fbed55eef282ecf6bea8f3bbeac967e2b859fca5239947a... 1 0 \n", "fbef1f2eefbb380721d1b908a45c7bdf84a2dad2f34d49b... 1 0 \n", "fc93cc3a74e99fc5325b951abeba1fc142ce354c5824601... 1 1 \n", "fcd76f264472c9ee6727bf1bcb418a51880e020ba12127f... 0 0 \n", "fcd76f264472c9ee6727bf1bcb418a51880e020ba12127f... 0 1 \n", "fceb27bb78f34e82bee2d1b1362ff27207828979e201e64... 0 0 \n", "fcf6564d2a10dd392a376aa23ff6ac19846fc8f5564beb1... 0 0 \n", "fda422842e8e6bf0cc291d048b792d76a293c021319f588... 1 0 \n", "fdbde899b8f6b58595afb42de2337ecfcb066481f848f9f... 0 0 \n", "fdca2182a7ca43056ccc3a8cf95567396468ddcca1e6fd6... 1 0 \n", "fdd431cab47cf62c4be70e4e05bbd48001edf641c1136c4... 1 0 \n", "fe26e5d679dc1f6a733c8bfa9e7337501d5d127a21a337d... 0 0 \n", "fe33c5a8da4dcefc16d5db744a5f18d898805996de2016a... 0 0 \n", "fe7a693c020f03fa62e704e29d0db643248426fca3df6b4... 0 0 \n", "fe943a72a4b8ce3a4e5b42511ed72f53e241a3630ef4343... 1 0 \n", "fe943a72a4b8ce3a4e5b42511ed72f53e241a3630ef4343... 1 0 \n", "fed9a9b0dcbeba81cf56c5b9963cced64f7827a554a0598... 0 0 \n", "fef709daecdf01a6164df79083f8a55c2c32f939d0f7199... 0 0 \n", "ff5f650c4fc31086d3b9ea116434ab284714ac317249153... 0 0 \n", "ffb521745ac8de7c4715080c46451472f0567736e1206d8... 0 0 \n", "\n", "item Wmns Apprl Wmns Apprl \n", "transaction_id \n", "00de91ae00bb2fea1d7e9953d2da87740c7340ddbe5a2ec... 0 0 \n", "0132bfb1ddb43b86872150aa5d5beb506b2c0547c91d8b5... 0 1 \n", "01a28b44a832a0a35949a680fae963ad86563f389a26356... 0 0 \n", "01b1a76315c3c1bb3b08616eba3e9fd98cb8471a0f7ce5b... 0 0 \n", "01e0e2d91144b15862e929591bfa30f74fb0757e50476e8... 0 0 \n", "023e16af29b004681ac4248606d06658267fe730ba581f0... 0 0 \n", "02463a4dc6a661eeb8607333c2dc3d0a3ec4c9a40d93354... 0 0 \n", "026c164abb5f644eacb3d02798c1571c01713e64d76e725... 0 0 \n", "027b046d6acb430991e79e54e08a5bef371aa35e3be4fe7... 0 0 \n", "02c5eae6ef36dd5886912fdead95a60865309e5abcf0ad1... 0 0 \n", "02d5efb4f7a7ed421530724c7318523511635c02aa0578c... 0 0 \n", "02f218e640b27885de2ccdb7c3f22a2acb9a296a012505b... 0 0 \n", "030102e337802b33a467fa3fa2f433c2d51f14718943c57... 1 0 \n", "03978b65107fe576a1bba38f76d41e71297eec5f58ee113... 0 0 \n", "03b0c44873c147ca39167e0ca031f836ffe47cca7b66c82... 0 1 \n", "040f584138f13122be9de6803bca77edbf396471e8d1767... 0 0 \n", "04194617a57a88bdb5eea3038ab6a40bac6f9751373efcc... 1 0 \n", "041d27961b44602fa01fc6b758195ed73d6d106efa3c332... 0 0 \n", "043051b1d8db2a9d2e51ccbb432feb7648574e67e79c3e6... 0 0 \n", "043051b1d8db2a9d2e51ccbb432feb7648574e67e79c3e6... 1 0 \n", "043051b1d8db2a9d2e51ccbb432feb7648574e67e79c3e6... 0 1 \n", "048af26f61363f8863f847f69ec338ba1a5b13bf4d99b08... 0 0 \n", "0497476bd0bbbcdd0bba1ee900079a7ec876954ac2140c9... 0 1 \n", "04cbdf2eb46e941754bbf230db51b76258d556c1cc57bb5... 0 0 \n", "04d71a14825027e0454445d8f090c17e07806d6bf0592e3... 1 1 \n", "05bbaa2c91ce9d45eb654cbbb94071dcfeb16656dd4bad1... 0 0 \n", "05d7cf732a82c475b56ffddf6bbfdc12180e3faf29c72e8... 0 0 \n", "05e1efce4d5e538cff3f0fc9439c0e6e2ef2f1420b21b1d... 0 0 \n", "06262d3c9daef003c19dbfb3b9c9f6976d9c190e4a455a5... 0 0 \n", "065346df86cf995e2d22782120e05422e955070a4c06511... 0 0 \n", "... ... ... \n", "faeaafabb538ca92e3c6226c775a97a5b3b336ddcb41fa6... 0 0 \n", "fb10289594bb1da49eb3241022628ad3ec6a24cdb900812... 0 0 \n", "fb26c5d622129e969e2fa17ac1ef130231b6894ee309b4c... 0 0 \n", "fb26c5d622129e969e2fa17ac1ef130231b6894ee309b4c... 0 0 \n", "fb26c5d622129e969e2fa17ac1ef130231b6894ee309b4c... 0 0 \n", "fb27439e6959b435aec64aadf34df15948b086c9e4df235... 0 0 \n", "fb513c34a472046a10ec14b8f9a5c6de55e3e30ecac5221... 0 0 \n", "fbaa5a96fa9860917ba9a6eb4ce5c2001b18c330afd4a74... 0 0 \n", "fbd145967d33641676baa21832c06f5fd3268bec3b0133f... 0 0 \n", "fbd7080dea62e2e47b21dc9a2d2488a8b045f36c6137222... 0 0 \n", "fbed55eef282ecf6bea8f3bbeac967e2b859fca5239947a... 0 0 \n", "fbef1f2eefbb380721d1b908a45c7bdf84a2dad2f34d49b... 0 0 \n", "fc93cc3a74e99fc5325b951abeba1fc142ce354c5824601... 0 0 \n", "fcd76f264472c9ee6727bf1bcb418a51880e020ba12127f... 0 0 \n", "fcd76f264472c9ee6727bf1bcb418a51880e020ba12127f... 0 0 \n", "fceb27bb78f34e82bee2d1b1362ff27207828979e201e64... 0 0 \n", "fcf6564d2a10dd392a376aa23ff6ac19846fc8f5564beb1... 0 1 \n", "fda422842e8e6bf0cc291d048b792d76a293c021319f588... 0 0 \n", "fdbde899b8f6b58595afb42de2337ecfcb066481f848f9f... 0 0 \n", "fdca2182a7ca43056ccc3a8cf95567396468ddcca1e6fd6... 0 0 \n", "fdd431cab47cf62c4be70e4e05bbd48001edf641c1136c4... 0 0 \n", "fe26e5d679dc1f6a733c8bfa9e7337501d5d127a21a337d... 0 0 \n", "fe33c5a8da4dcefc16d5db744a5f18d898805996de2016a... 0 0 \n", "fe7a693c020f03fa62e704e29d0db643248426fca3df6b4... 0 0 \n", "fe943a72a4b8ce3a4e5b42511ed72f53e241a3630ef4343... 0 0 \n", "fe943a72a4b8ce3a4e5b42511ed72f53e241a3630ef4343... 0 0 \n", "fed9a9b0dcbeba81cf56c5b9963cced64f7827a554a0598... 0 0 \n", "fef709daecdf01a6164df79083f8a55c2c32f939d0f7199... 0 0 \n", "ff5f650c4fc31086d3b9ea116434ab284714ac317249153... 0 0 \n", "ffb521745ac8de7c4715080c46451472f0567736e1206d8... 0 0 \n", "\n", "[998 rows x 18 columns]" ] }, "execution_count": 23, "metadata": {}, "output_type": "execute_result" } ], "source": [ "basket_sets" ] }, { "cell_type": "code", "execution_count": 24, "metadata": {}, "outputs": [], "source": [ "frequent_itemsets = apriori(basket_sets, min_support=0.005, use_colnames=True)" ] }, { "cell_type": "code", "execution_count": 25, "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", "
supportitemsets
00.023046(AV Media)
10.142285(AV Media )
20.065130(Asst Merch)
30.093186(Asst Merch )
40.046092(Jewelry)
50.012024(Jewelry )
60.009018(Memorabili)
70.010020(Mens Apprl)
80.007014(Mens Apprl )
90.048096(Noncatwear )
100.010020(Print Item)
110.195391(Print Item )
120.024048(SmallStuff)
130.289579(Unisx Appl)
140.149299(Unisx Appl )
150.073146(Wmns Apprl)
160.091182(Wmns Apprl )
170.005010(AV Media , AV Media)
180.005010(AV Media , Asst Merch)
190.007014(Asst Merch , AV Media )
200.012024(AV Media , Print Item )
210.014028(Unisx Appl, AV Media )
220.013026(AV Media , Unisx Appl )
230.007014(AV Media , Wmns Apprl)
240.009018(Asst Merch , Asst Merch)
250.006012(Noncatwear , Asst Merch)
260.006012(SmallStuff, Asst Merch)
270.011022(Unisx Appl, Asst Merch)
280.012024(Unisx Appl , Asst Merch)
290.005010(Wmns Apprl , Asst Merch)
300.011022(Asst Merch , Print Item )
310.016032(Unisx Appl, Asst Merch )
320.009018(Asst Merch , Unisx Appl )
330.006012(Asst Merch , Wmns Apprl )
340.006012(Wmns Apprl , Noncatwear )
350.005010(Print Item, Print Item )
360.025050(Unisx Appl, Print Item )
370.013026(Unisx Appl , Print Item )
380.008016(Wmns Apprl, Print Item )
390.005010(Unisx Appl, SmallStuff)
400.007014(SmallStuff, Unisx Appl )
410.034068(Unisx Appl, Unisx Appl )
420.011022(Unisx Appl, Wmns Apprl)
430.018036(Unisx Appl, Wmns Apprl )
440.006012(Wmns Apprl, Unisx Appl )
450.009018(Wmns Apprl , Unisx Appl )
460.011022(Wmns Apprl , Wmns Apprl)
470.005010(Unisx Appl, Unisx Appl , Asst Merch)
480.005010(Unisx Appl, Unisx Appl , Print Item )
\n", "
" ], "text/plain": [ " support itemsets\n", "0 0.023046 (AV Media)\n", "1 0.142285 (AV Media )\n", "2 0.065130 (Asst Merch)\n", "3 0.093186 (Asst Merch )\n", "4 0.046092 (Jewelry)\n", "5 0.012024 (Jewelry )\n", "6 0.009018 (Memorabili)\n", "7 0.010020 (Mens Apprl)\n", "8 0.007014 (Mens Apprl )\n", "9 0.048096 (Noncatwear )\n", "10 0.010020 (Print Item)\n", "11 0.195391 (Print Item )\n", "12 0.024048 (SmallStuff)\n", "13 0.289579 (Unisx Appl)\n", "14 0.149299 (Unisx Appl )\n", "15 0.073146 (Wmns Apprl)\n", "16 0.091182 (Wmns Apprl )\n", "17 0.005010 (AV Media , AV Media)\n", "18 0.005010 (AV Media , Asst Merch)\n", "19 0.007014 (Asst Merch , AV Media )\n", "20 0.012024 (AV Media , Print Item )\n", "21 0.014028 (Unisx Appl, AV Media )\n", "22 0.013026 (AV Media , Unisx Appl )\n", "23 0.007014 (AV Media , Wmns Apprl)\n", "24 0.009018 (Asst Merch , Asst Merch)\n", "25 0.006012 (Noncatwear , Asst Merch)\n", "26 0.006012 (SmallStuff, Asst Merch)\n", "27 0.011022 (Unisx Appl, Asst Merch)\n", "28 0.012024 (Unisx Appl , Asst Merch)\n", "29 0.005010 (Wmns Apprl , Asst Merch)\n", "30 0.011022 (Asst Merch , Print Item )\n", "31 0.016032 (Unisx Appl, Asst Merch )\n", "32 0.009018 (Asst Merch , Unisx Appl )\n", "33 0.006012 (Asst Merch , Wmns Apprl )\n", "34 0.006012 (Wmns Apprl , Noncatwear )\n", "35 0.005010 (Print Item, Print Item )\n", "36 0.025050 (Unisx Appl, Print Item )\n", "37 0.013026 (Unisx Appl , Print Item )\n", "38 0.008016 (Wmns Apprl, Print Item )\n", "39 0.005010 (Unisx Appl, SmallStuff)\n", "40 0.007014 (SmallStuff, Unisx Appl )\n", "41 0.034068 (Unisx Appl, Unisx Appl )\n", "42 0.011022 (Unisx Appl, Wmns Apprl)\n", "43 0.018036 (Unisx Appl, Wmns Apprl )\n", "44 0.006012 (Wmns Apprl, Unisx Appl )\n", "45 0.009018 (Wmns Apprl , Unisx Appl )\n", "46 0.011022 (Wmns Apprl , Wmns Apprl)\n", "47 0.005010 (Unisx Appl, Unisx Appl , Asst Merch)\n", "48 0.005010 (Unisx Appl, Unisx Appl , Print Item )" ] }, "execution_count": 25, "metadata": {}, "output_type": "execute_result" } ], "source": [ "frequent_itemsets" ] }, { "cell_type": "code", "execution_count": 26, "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", "
antecedentsconsequentsantecedent supportconsequent supportsupportconfidenceliftleverageconviction
0(AV Media )(AV Media)0.1422850.0230460.0050100.0352111.5278630.0017311.012609
1(AV Media)(AV Media )0.0230460.1422850.0050100.2173911.5278630.0017311.095970
2(Asst Merch )(Asst Merch)0.0931860.0651300.0090180.0967741.4858560.0029491.035034
3(Asst Merch)(Asst Merch )0.0651300.0931860.0090180.1384621.4858560.0029491.052552
4(Noncatwear )(Asst Merch)0.0480960.0651300.0060120.1250001.9192310.0028801.068423
5(Asst Merch)(Noncatwear )0.0651300.0480960.0060120.0923081.9192310.0028801.048708
6(SmallStuff)(Asst Merch)0.0240480.0651300.0060120.2500003.8384620.0044461.246493
7(Asst Merch)(SmallStuff)0.0651300.0240480.0060120.0923083.8384620.0044461.075201
8(Unisx Appl )(Asst Merch)0.1492990.0651300.0120240.0805371.2365510.0023001.016756
9(Asst Merch)(Unisx Appl )0.0651300.1492990.0120240.1846151.2365510.0023001.043313
10(Wmns Apprl )(Noncatwear )0.0911820.0480960.0060120.0659341.3708790.0016261.019097
11(Noncatwear )(Wmns Apprl )0.0480960.0911820.0060120.1250001.3708790.0016261.038649
12(Print Item)(Print Item )0.0100200.1953910.0050100.5000002.5589740.0030521.609218
13(Print Item )(Print Item)0.1953910.0100200.0050100.0256412.5589740.0030521.016032
14(SmallStuff)(Unisx Appl )0.0240480.1492990.0070140.2916671.9535790.0034241.200990
15(Unisx Appl )(SmallStuff)0.1492990.0240480.0070140.0469801.9535790.0034241.024062
16(Wmns Apprl )(Wmns Apprl)0.0911820.0731460.0110220.1208791.6525670.0043521.054296
17(Wmns Apprl)(Wmns Apprl )0.0731460.0911820.0110220.1506851.6525670.0043521.070059
18(Unisx Appl, Unisx Appl )(Asst Merch)0.0340680.0651300.0050100.1470592.2579190.0027911.096054
19(Unisx Appl, Asst Merch)(Unisx Appl )0.0110220.1492990.0050100.4545453.0445390.0033641.559619
\n", "
" ], "text/plain": [ " antecedents consequents antecedent support \\\n", "0 (AV Media ) (AV Media) 0.142285 \n", "1 (AV Media) (AV Media ) 0.023046 \n", "2 (Asst Merch ) (Asst Merch) 0.093186 \n", "3 (Asst Merch) (Asst Merch ) 0.065130 \n", "4 (Noncatwear ) (Asst Merch) 0.048096 \n", "5 (Asst Merch) (Noncatwear ) 0.065130 \n", "6 (SmallStuff) (Asst Merch) 0.024048 \n", "7 (Asst Merch) (SmallStuff) 0.065130 \n", "8 (Unisx Appl ) (Asst Merch) 0.149299 \n", "9 (Asst Merch) (Unisx Appl ) 0.065130 \n", "10 (Wmns Apprl ) (Noncatwear ) 0.091182 \n", "11 (Noncatwear ) (Wmns Apprl ) 0.048096 \n", "12 (Print Item) (Print Item ) 0.010020 \n", "13 (Print Item ) (Print Item) 0.195391 \n", "14 (SmallStuff) (Unisx Appl ) 0.024048 \n", "15 (Unisx Appl ) (SmallStuff) 0.149299 \n", "16 (Wmns Apprl ) (Wmns Apprl) 0.091182 \n", "17 (Wmns Apprl) (Wmns Apprl ) 0.073146 \n", "18 (Unisx Appl, Unisx Appl ) (Asst Merch) 0.034068 \n", "19 (Unisx Appl, Asst Merch) (Unisx Appl ) 0.011022 \n", "\n", " consequent support support confidence lift leverage conviction \n", "0 0.023046 0.005010 0.035211 1.527863 0.001731 1.012609 \n", "1 0.142285 0.005010 0.217391 1.527863 0.001731 1.095970 \n", "2 0.065130 0.009018 0.096774 1.485856 0.002949 1.035034 \n", "3 0.093186 0.009018 0.138462 1.485856 0.002949 1.052552 \n", "4 0.065130 0.006012 0.125000 1.919231 0.002880 1.068423 \n", "5 0.048096 0.006012 0.092308 1.919231 0.002880 1.048708 \n", "6 0.065130 0.006012 0.250000 3.838462 0.004446 1.246493 \n", "7 0.024048 0.006012 0.092308 3.838462 0.004446 1.075201 \n", "8 0.065130 0.012024 0.080537 1.236551 0.002300 1.016756 \n", "9 0.149299 0.012024 0.184615 1.236551 0.002300 1.043313 \n", "10 0.048096 0.006012 0.065934 1.370879 0.001626 1.019097 \n", "11 0.091182 0.006012 0.125000 1.370879 0.001626 1.038649 \n", "12 0.195391 0.005010 0.500000 2.558974 0.003052 1.609218 \n", "13 0.010020 0.005010 0.025641 2.558974 0.003052 1.016032 \n", "14 0.149299 0.007014 0.291667 1.953579 0.003424 1.200990 \n", "15 0.024048 0.007014 0.046980 1.953579 0.003424 1.024062 \n", "16 0.073146 0.011022 0.120879 1.652567 0.004352 1.054296 \n", "17 0.091182 0.011022 0.150685 1.652567 0.004352 1.070059 \n", "18 0.065130 0.005010 0.147059 2.257919 0.002791 1.096054 \n", "19 0.149299 0.005010 0.454545 3.044539 0.003364 1.559619 " ] }, "execution_count": 26, "metadata": {}, "output_type": "execute_result" } ], "source": [ "rules = association_rules(frequent_itemsets, metric=\"lift\", min_threshold=1)\n", "rules.head(20)" ] }, { "cell_type": "code", "execution_count": 32, "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", "
antecedentsconsequentsantecedent supportconsequent supportsupportconfidenceliftleverageconviction
6(SmallStuff)(Asst Merch)0.0240480.0651300.0060120.2500003.8384620.0044461.246493
12(Print Item)(Print Item )0.0100200.1953910.0050100.5000002.5589740.0030521.609218
18(Unisx Appl, Unisx Appl )(Asst Merch)0.0340680.0651300.0050100.1470592.2579190.0027911.096054
19(Unisx Appl, Asst Merch)(Unisx Appl )0.0110220.1492990.0050100.4545453.0445390.0033641.559619
\n", "
" ], "text/plain": [ " antecedents consequents antecedent support \\\n", "6 (SmallStuff) (Asst Merch) 0.024048 \n", "12 (Print Item) (Print Item ) 0.010020 \n", "18 (Unisx Appl, Unisx Appl ) (Asst Merch) 0.034068 \n", "19 (Unisx Appl, Asst Merch) (Unisx Appl ) 0.011022 \n", "\n", " consequent support support confidence lift leverage conviction \n", "6 0.065130 0.006012 0.250000 3.838462 0.004446 1.246493 \n", "12 0.195391 0.005010 0.500000 2.558974 0.003052 1.609218 \n", "18 0.065130 0.005010 0.147059 2.257919 0.002791 1.096054 \n", "19 0.149299 0.005010 0.454545 3.044539 0.003364 1.559619 " ] }, "execution_count": 32, "metadata": {}, "output_type": "execute_result" } ], "source": [ "rules[ (rules['lift'] >=2) &\n", " (rules['confidence'] >= 0.1) ]" ] } ], "metadata": { "kernelspec": { "display_name": "conda_python3", "language": "python", "name": "conda_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.6.10" } }, "nbformat": 4, "nbformat_minor": 4 }