Created
June 18, 2015 14:47
-
-
Save mburke05/e7a83f8550a2dda43f5b to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "cells": [ | |
| { | |
| "cell_type": "code", | |
| "execution_count": 3, | |
| "metadata": { | |
| "collapsed": false | |
| }, | |
| "outputs": [], | |
| "source": [ | |
| "import pandas.io.ga as ga" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 4, | |
| "metadata": { | |
| "collapsed": false | |
| }, | |
| "outputs": [ | |
| { | |
| "name": "stderr", | |
| "output_type": "stream", | |
| "text": [ | |
| "WARNING:root:This function, oauth2client.tools.run(), and the use of the gflags library are deprecated and will be removed in a future version of the library.\n" | |
| ] | |
| }, | |
| { | |
| "name": "stdout", | |
| "output_type": "stream", | |
| "text": [ | |
| "Your browser has been opened to visit:\n", | |
| "\n", | |
| " https://accounts.google.com/o/oauth2/auth?scope=https%3A%2F%2Fwww.googleapis.com%2Fauth%2Fanalytics.readonly&redirect_uri=http%3A%2F%2Flocalhost%3A8080%2F&response_type=code&client_id=164657813033-sj7d36ni36pi3g3jrkgrn4ub0bc8t8ik.apps.googleusercontent.com&access_type=offline\n", | |
| "\n", | |
| "If your browser is on a different machine then exit and re-run\n", | |
| "this application with the command-line parameter \n", | |
| "\n", | |
| " --noauth_local_webserver\n", | |
| "\n", | |
| "Authentication successful.\n" | |
| ] | |
| }, | |
| { | |
| "data": { | |
| "text/html": [ | |
| "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n", | |
| "<table border=\"1\" class=\"dataframe\">\n", | |
| " <thead>\n", | |
| " <tr style=\"text-align: right;\">\n", | |
| " <th></th>\n", | |
| " <th>hour</th>\n", | |
| " <th>minute</th>\n", | |
| " <th>productName</th>\n", | |
| " <th>transactionId</th>\n", | |
| " <th>itemQuantity</th>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>date</th>\n", | |
| " <th></th>\n", | |
| " <th></th>\n", | |
| " <th></th>\n", | |
| " <th></th>\n", | |
| " <th></th>\n", | |
| " </tr>\n", | |
| " </thead>\n", | |
| " <tbody>\n", | |
| " <tr>\n", | |
| " <th>2015-05-08</th>\n", | |
| " <td> 0</td>\n", | |
| " <td> 20</td>\n", | |
| " <td> Dell Inspiron 17 17.3\" HD+ Notebook Computer, ...</td>\n", | |
| " <td> 640ED1BFEBC21</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2015-05-08</th>\n", | |
| " <td> 16</td>\n", | |
| " <td> 12</td>\n", | |
| " <td> Mario Party 10 - Nintendo Wii U</td>\n", | |
| " <td> 401A7F84E8021</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2015-05-08</th>\n", | |
| " <td> 16</td>\n", | |
| " <td> 12</td>\n", | |
| " <td> Just Dance 2015 - Nintendo Wii U</td>\n", | |
| " <td> 401A7F84E8021</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2015-05-08</th>\n", | |
| " <td> 16</td>\n", | |
| " <td> 12</td>\n", | |
| " <td> Captain Toad Treasure Tracker - Nintendo Wii U</td>\n", | |
| " <td> 401A7F84E8021</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2015-05-08</th>\n", | |
| " <td> 16</td>\n", | |
| " <td> 7</td>\n", | |
| " <td> Brinkmann Medallion 5-Burner Propane Gas Grill...</td>\n", | |
| " <td> 4017BDB71B821</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2015-05-08</th>\n", | |
| " <td> 15</td>\n", | |
| " <td> 35</td>\n", | |
| " <td> Bettega Parson Chair (Set of 2)</td>\n", | |
| " <td> 3FF75771A0021</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2015-05-08</th>\n", | |
| " <td> 15</td>\n", | |
| " <td> 31</td>\n", | |
| " <td> Apple iPad mini 2 Wi-Fi - tablet - 16 GB - 7.9\"</td>\n", | |
| " <td> 3FF783C9F3821</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2015-05-08</th>\n", | |
| " <td> 15</td>\n", | |
| " <td> 28</td>\n", | |
| " <td> Nikon D3200 - digital camera AF-S DX 18-55mm a...</td>\n", | |
| " <td> 645FEEE901C21</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2015-05-08</th>\n", | |
| " <td> 15</td>\n", | |
| " <td> 10</td>\n", | |
| " <td> Sony - PlayStation 4 500GB The Last of Us Rema...</td>\n", | |
| " <td> 3FE3E3779A021</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2015-05-08</th>\n", | |
| " <td> 15</td>\n", | |
| " <td> 9</td>\n", | |
| " <td> Samsung HT-H4500 - home theater system - 5.1 c...</td>\n", | |
| " <td> 3FE368A324821</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2015-05-08</th>\n", | |
| " <td> 15</td>\n", | |
| " <td> 9</td>\n", | |
| " <td> Dell - Inspiron 11.6&quot;Touch-Screen Laptop ...</td>\n", | |
| " <td> 3FE368A324821</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2015-05-08</th>\n", | |
| " <td> 15</td>\n", | |
| " <td> 8</td>\n", | |
| " <td> Canon Speedlite 430EX II Flash with Guide Numb...</td>\n", | |
| " <td> 3FE0F8DBB7421</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2015-05-08</th>\n", | |
| " <td> 15</td>\n", | |
| " <td> 5</td>\n", | |
| " <td> Dynex 24-inch 720p LED TV</td>\n", | |
| " <td> 3FE0761BF0421</td>\n", | |
| " <td> 2</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2015-05-08</th>\n", | |
| " <td> 14</td>\n", | |
| " <td> 54</td>\n", | |
| " <td> Poundex F7615 3 Pieces Chocolate Reversible Se...</td>\n", | |
| " <td> 3FB68D7808821</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2015-05-08</th>\n", | |
| " <td> 14</td>\n", | |
| " <td> 39</td>\n", | |
| " <td> Coaster 500100 Regatta Contemporary 3 Pcs Livi...</td>\n", | |
| " <td> 3FC864A6F7021</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2015-05-08</th>\n", | |
| " <td> 14</td>\n", | |
| " <td> 36</td>\n", | |
| " <td> Microsoft - Surface Pro 3 - 64GB - Intel i3 - ...</td>\n", | |
| " <td> 3FC5A61BF6021</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2015-05-08</th>\n", | |
| " <td> 14</td>\n", | |
| " <td> 24</td>\n", | |
| " <td> Mortal Kombat X - PlayStation 4</td>\n", | |
| " <td> 645A75BCB4C21</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2015-05-08</th>\n", | |
| " <td> 14</td>\n", | |
| " <td> 24</td>\n", | |
| " <td> King Sealy Posturepedic Classic Inland Greens ...</td>\n", | |
| " <td> 645A59D53D021</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2015-05-08</th>\n", | |
| " <td> 14</td>\n", | |
| " <td> 17</td>\n", | |
| " <td> Canon VIXIA HF R600 Camcorder, 57x Optical Zoo...</td>\n", | |
| " <td> 3FB48638EF421</td>\n", | |
| " <td> 2</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2015-05-08</th>\n", | |
| " <td> 13</td>\n", | |
| " <td> 53</td>\n", | |
| " <td> Samsung Galaxy Tab 4 - tablet - Android 4.4 (K...</td>\n", | |
| " <td> 3F9B6EC5AF021</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2015-05-08</th>\n", | |
| " <td> 13</td>\n", | |
| " <td> 53</td>\n", | |
| " <td> KitchenAid - 4-Slice Wide-Slot Toaster - Silve...</td>\n", | |
| " <td> 3F9B6EC5AF021</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2015-05-08</th>\n", | |
| " <td> 13</td>\n", | |
| " <td> 53</td>\n", | |
| " <td> Hoover WindTunnel 3 Pro Pet UH70935 - vacuum c...</td>\n", | |
| " <td> 3F9B6EC5AF021</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2015-05-08</th>\n", | |
| " <td> 13</td>\n", | |
| " <td> 53</td>\n", | |
| " <td> HP Envy 5530 e-All-in-One Inkjet Printer, 21pp...</td>\n", | |
| " <td> 3F9B6EC5AF021</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2015-05-08</th>\n", | |
| " <td> 13</td>\n", | |
| " <td> 38</td>\n", | |
| " <td> Ricoh SP 213SFNw 3-In-1 Monochrome Multifuncti...</td>\n", | |
| " <td> 3F92B0FFC6021</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2015-05-08</th>\n", | |
| " <td> 16</td>\n", | |
| " <td> 27</td>\n", | |
| " <td> Sony PlayStation 4 - game console - 500 GB HDD...</td>\n", | |
| " <td> 6465600D42421</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2015-05-08</th>\n", | |
| " <td> 13</td>\n", | |
| " <td> 38</td>\n", | |
| " <td> ASUS VX228H - LED monitor - 21.5\"</td>\n", | |
| " <td> 3F92B0FFC6021</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2015-05-08</th>\n", | |
| " <td> 16</td>\n", | |
| " <td> 41</td>\n", | |
| " <td> Apple MacBook Pro 13\" Notebook Computer with R...</td>\n", | |
| " <td> 64651828A3021</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2015-05-08</th>\n", | |
| " <td> 16</td>\n", | |
| " <td> 41</td>\n", | |
| " <td> Sony - PlayStation 4 500GB The Last of Us Rema...</td>\n", | |
| " <td> 64651828A3021</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2015-05-08</th>\n", | |
| " <td> 23</td>\n", | |
| " <td> 38</td>\n", | |
| " <td> Fitbit - Charge Wireless Activity Tracker + Sl...</td>\n", | |
| " <td> 41AB0F1FD1C21</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2015-05-08</th>\n", | |
| " <td> 23</td>\n", | |
| " <td> 1</td>\n", | |
| " <td> HP Stream 13-c010nr - 13.3\" - Celeron N2840 - ...</td>\n", | |
| " <td> 4189CA46BF421</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>...</th>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2015-05-08</th>\n", | |
| " <td> 0</td>\n", | |
| " <td> 22</td>\n", | |
| " <td> Super Smash Bros. - Nintendo Wii U</td>\n", | |
| " <td> 3CCA8AF206421</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2015-05-08</th>\n", | |
| " <td> 10</td>\n", | |
| " <td> 33</td>\n", | |
| " <td> Cheval Espresso Finish Wooden Bedroom Floor Mi...</td>\n", | |
| " <td> 3EEC76AEBB021</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2015-05-08</th>\n", | |
| " <td> 13</td>\n", | |
| " <td> 33</td>\n", | |
| " <td> Acer - Iconia Tab 8 - 8&quot;- Intel Atom - 16...</td>\n", | |
| " <td> 3F8C9011D8021</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2015-05-08</th>\n", | |
| " <td> 10</td>\n", | |
| " <td> 33</td>\n", | |
| " <td> Tall Cabinet (White)</td>\n", | |
| " <td> 3EEC76AEBB021</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2015-05-08</th>\n", | |
| " <td> 10</td>\n", | |
| " <td> 42</td>\n", | |
| " <td> Hoover Sprint Quick Vac UH20040 - vacuum clean...</td>\n", | |
| " <td> 3EF4A29D35C21</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2015-05-08</th>\n", | |
| " <td> 13</td>\n", | |
| " <td> 32</td>\n", | |
| " <td> Confidence Power Plus Motorized Fitness Treadm...</td>\n", | |
| " <td> 1B36A3AC19421</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2015-05-08</th>\n", | |
| " <td> 13</td>\n", | |
| " <td> 29</td>\n", | |
| " <td> Coaster 500100 Regatta Contemporary 3 Pcs Livi...</td>\n", | |
| " <td> 3F8998ED84821</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2015-05-08</th>\n", | |
| " <td> 12</td>\n", | |
| " <td> 13</td>\n", | |
| " <td> Need for Speed: Rivals</td>\n", | |
| " <td> 3F46EB8CCE421</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2015-05-08</th>\n", | |
| " <td> 12</td>\n", | |
| " <td> 13</td>\n", | |
| " <td> Killzone 3 - PlayStation 3 PlayStation 4</td>\n", | |
| " <td> 3F46EB8CCE421</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2015-05-08</th>\n", | |
| " <td> 12</td>\n", | |
| " <td> 13</td>\n", | |
| " <td> EA SPORTS UFC - PlayStation 4</td>\n", | |
| " <td> 3F46EB8CCE421</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2015-05-08</th>\n", | |
| " <td> 12</td>\n", | |
| " <td> 12</td>\n", | |
| " <td> Cowon iAudio 9+ MP3 &amp; Video Player, 16GB F...</td>\n", | |
| " <td> 1B35EDE5C5821</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2015-05-08</th>\n", | |
| " <td> 11</td>\n", | |
| " <td> 59</td>\n", | |
| " <td> Igloo - 9.2 Cu. Ft. Bottom-Freezer Refrigerato...</td>\n", | |
| " <td> 3F390868CCC21</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2015-05-08</th>\n", | |
| " <td> 11</td>\n", | |
| " <td> 56</td>\n", | |
| " <td> The Order: 1886 - PlayStation 4</td>\n", | |
| " <td> 644CF4E066821</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2015-05-08</th>\n", | |
| " <td> 11</td>\n", | |
| " <td> 56</td>\n", | |
| " <td> Sony - Gold Wireless Stereo Headset for PlaySt...</td>\n", | |
| " <td> 644CF4E066821</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2015-05-08</th>\n", | |
| " <td> 11</td>\n", | |
| " <td> 56</td>\n", | |
| " <td> Sony - DualShock 4 Wireless Controller for Pla...</td>\n", | |
| " <td> 644CF4E066821</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2015-05-08</th>\n", | |
| " <td> 11</td>\n", | |
| " <td> 56</td>\n", | |
| " <td> Mortal Kombat X - PlayStation 4</td>\n", | |
| " <td> 644CF4E066821</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2015-05-08</th>\n", | |
| " <td> 11</td>\n", | |
| " <td> 56</td>\n", | |
| " <td> MLB 15 The Show - PlayStation 4</td>\n", | |
| " <td> 644CF4E066821</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2015-05-08</th>\n", | |
| " <td> 11</td>\n", | |
| " <td> 56</td>\n", | |
| " <td> Borderlands: The Handsome Collection - PlaySta...</td>\n", | |
| " <td> 644CF4E066821</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2015-05-08</th>\n", | |
| " <td> 11</td>\n", | |
| " <td> 41</td>\n", | |
| " <td> Insignia - 24 in - LED - 720p HDTV</td>\n", | |
| " <td> 3F220F04A1421</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2015-05-08</th>\n", | |
| " <td> 11</td>\n", | |
| " <td> 28</td>\n", | |
| " <td> 235/45ZR18 Hankook Ventus R-S3 (Version 2) Blackw</td>\n", | |
| " <td> 3F19FCEF39421</td>\n", | |
| " <td> 4</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2015-05-08</th>\n", | |
| " <td> 11</td>\n", | |
| " <td> 28</td>\n", | |
| " <td> 18x8 ASA GT10 Hyper Silver wheels</td>\n", | |
| " <td> 3F19FCEF39421</td>\n", | |
| " <td> 4</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2015-05-08</th>\n", | |
| " <td> 11</td>\n", | |
| " <td> 24</td>\n", | |
| " <td> Orchard Hills Armoire</td>\n", | |
| " <td> 3F1078F321421</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2015-05-08</th>\n", | |
| " <td> 11</td>\n", | |
| " <td> 24</td>\n", | |
| " <td> Oahu Cotton Topper,</td>\n", | |
| " <td> 3F1078F321421</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2015-05-08</th>\n", | |
| " <td> 11</td>\n", | |
| " <td> 24</td>\n", | |
| " <td> Frigidaire - 8 000 BTU Window Air Conditioner ...</td>\n", | |
| " <td> 3F1078F321421</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2015-05-08</th>\n", | |
| " <td> 11</td>\n", | |
| " <td> 14</td>\n", | |
| " <td> GoPro Hero4 Black Edition Action Camera w/ 12M...</td>\n", | |
| " <td> 3EBF3FC0B2421</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2015-05-08</th>\n", | |
| " <td> 11</td>\n", | |
| " <td> 11</td>\n", | |
| " <td> LG Electronics 22CV241-W Chromebase 21.5\" Full...</td>\n", | |
| " <td> 3F0EF0130BC21</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2015-05-08</th>\n", | |
| " <td> 10</td>\n", | |
| " <td> 55</td>\n", | |
| " <td> Hamilton Beach - FlexBrew 12-Cup Coffeemaker -...</td>\n", | |
| " <td> 3F008090CEC21</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2015-05-08</th>\n", | |
| " <td> 10</td>\n", | |
| " <td> 52</td>\n", | |
| " <td> Acer Aspire E1-731-20204G50Mnii - 17.3\" - Pent...</td>\n", | |
| " <td> 3EFDDE2FDD821</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2015-05-08</th>\n", | |
| " <td> 10</td>\n", | |
| " <td> 40</td>\n", | |
| " <td> LG 42LB6300 42&quot; Smart HDTV with WebOS Ful...</td>\n", | |
| " <td> 3EF199B5AFC21</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2015-05-08</th>\n", | |
| " <td> 23</td>\n", | |
| " <td> 41</td>\n", | |
| " <td> Apple&reg; - iPad Air 2 Wi-Fi 64GB - Silver</td>\n", | |
| " <td> 41A06D5977821</td>\n", | |
| " <td> 1</td>\n", | |
| " </tr>\n", | |
| " </tbody>\n", | |
| "</table>\n", | |
| "<p>107 rows × 5 columns</p>\n", | |
| "</div>" | |
| ], | |
| "text/plain": [ | |
| " hour minute productName \\\n", | |
| "date \n", | |
| "2015-05-08 0 20 Dell Inspiron 17 17.3\" HD+ Notebook Computer, ... \n", | |
| "2015-05-08 16 12 Mario Party 10 - Nintendo Wii U \n", | |
| "2015-05-08 16 12 Just Dance 2015 - Nintendo Wii U \n", | |
| "2015-05-08 16 12 Captain Toad Treasure Tracker - Nintendo Wii U \n", | |
| "2015-05-08 16 7 Brinkmann Medallion 5-Burner Propane Gas Grill... \n", | |
| "2015-05-08 15 35 Bettega Parson Chair (Set of 2) \n", | |
| "2015-05-08 15 31 Apple iPad mini 2 Wi-Fi - tablet - 16 GB - 7.9\" \n", | |
| "2015-05-08 15 28 Nikon D3200 - digital camera AF-S DX 18-55mm a... \n", | |
| "2015-05-08 15 10 Sony - PlayStation 4 500GB The Last of Us Rema... \n", | |
| "2015-05-08 15 9 Samsung HT-H4500 - home theater system - 5.1 c... \n", | |
| "2015-05-08 15 9 Dell - Inspiron 11.6"Touch-Screen Laptop ... \n", | |
| "2015-05-08 15 8 Canon Speedlite 430EX II Flash with Guide Numb... \n", | |
| "2015-05-08 15 5 Dynex 24-inch 720p LED TV \n", | |
| "2015-05-08 14 54 Poundex F7615 3 Pieces Chocolate Reversible Se... \n", | |
| "2015-05-08 14 39 Coaster 500100 Regatta Contemporary 3 Pcs Livi... \n", | |
| "2015-05-08 14 36 Microsoft - Surface Pro 3 - 64GB - Intel i3 - ... \n", | |
| "2015-05-08 14 24 Mortal Kombat X - PlayStation 4 \n", | |
| "2015-05-08 14 24 King Sealy Posturepedic Classic Inland Greens ... \n", | |
| "2015-05-08 14 17 Canon VIXIA HF R600 Camcorder, 57x Optical Zoo... \n", | |
| "2015-05-08 13 53 Samsung Galaxy Tab 4 - tablet - Android 4.4 (K... \n", | |
| "2015-05-08 13 53 KitchenAid - 4-Slice Wide-Slot Toaster - Silve... \n", | |
| "2015-05-08 13 53 Hoover WindTunnel 3 Pro Pet UH70935 - vacuum c... \n", | |
| "2015-05-08 13 53 HP Envy 5530 e-All-in-One Inkjet Printer, 21pp... \n", | |
| "2015-05-08 13 38 Ricoh SP 213SFNw 3-In-1 Monochrome Multifuncti... \n", | |
| "2015-05-08 16 27 Sony PlayStation 4 - game console - 500 GB HDD... \n", | |
| "2015-05-08 13 38 ASUS VX228H - LED monitor - 21.5\" \n", | |
| "2015-05-08 16 41 Apple MacBook Pro 13\" Notebook Computer with R... \n", | |
| "2015-05-08 16 41 Sony - PlayStation 4 500GB The Last of Us Rema... \n", | |
| "2015-05-08 23 38 Fitbit - Charge Wireless Activity Tracker + Sl... \n", | |
| "2015-05-08 23 1 HP Stream 13-c010nr - 13.3\" - Celeron N2840 - ... \n", | |
| "... ... ... ... \n", | |
| "2015-05-08 0 22 Super Smash Bros. - Nintendo Wii U \n", | |
| "2015-05-08 10 33 Cheval Espresso Finish Wooden Bedroom Floor Mi... \n", | |
| "2015-05-08 13 33 Acer - Iconia Tab 8 - 8"- Intel Atom - 16... \n", | |
| "2015-05-08 10 33 Tall Cabinet (White) \n", | |
| "2015-05-08 10 42 Hoover Sprint Quick Vac UH20040 - vacuum clean... \n", | |
| "2015-05-08 13 32 Confidence Power Plus Motorized Fitness Treadm... \n", | |
| "2015-05-08 13 29 Coaster 500100 Regatta Contemporary 3 Pcs Livi... \n", | |
| "2015-05-08 12 13 Need for Speed: Rivals \n", | |
| "2015-05-08 12 13 Killzone 3 - PlayStation 3 PlayStation 4 \n", | |
| "2015-05-08 12 13 EA SPORTS UFC - PlayStation 4 \n", | |
| "2015-05-08 12 12 Cowon iAudio 9+ MP3 & Video Player, 16GB F... \n", | |
| "2015-05-08 11 59 Igloo - 9.2 Cu. Ft. Bottom-Freezer Refrigerato... \n", | |
| "2015-05-08 11 56 The Order: 1886 - PlayStation 4 \n", | |
| "2015-05-08 11 56 Sony - Gold Wireless Stereo Headset for PlaySt... \n", | |
| "2015-05-08 11 56 Sony - DualShock 4 Wireless Controller for Pla... \n", | |
| "2015-05-08 11 56 Mortal Kombat X - PlayStation 4 \n", | |
| "2015-05-08 11 56 MLB 15 The Show - PlayStation 4 \n", | |
| "2015-05-08 11 56 Borderlands: The Handsome Collection - PlaySta... \n", | |
| "2015-05-08 11 41 Insignia - 24 in - LED - 720p HDTV \n", | |
| "2015-05-08 11 28 235/45ZR18 Hankook Ventus R-S3 (Version 2) Blackw \n", | |
| "2015-05-08 11 28 18x8 ASA GT10 Hyper Silver wheels \n", | |
| "2015-05-08 11 24 Orchard Hills Armoire \n", | |
| "2015-05-08 11 24 Oahu Cotton Topper, \n", | |
| "2015-05-08 11 24 Frigidaire - 8 000 BTU Window Air Conditioner ... \n", | |
| "2015-05-08 11 14 GoPro Hero4 Black Edition Action Camera w/ 12M... \n", | |
| "2015-05-08 11 11 LG Electronics 22CV241-W Chromebase 21.5\" Full... \n", | |
| "2015-05-08 10 55 Hamilton Beach - FlexBrew 12-Cup Coffeemaker -... \n", | |
| "2015-05-08 10 52 Acer Aspire E1-731-20204G50Mnii - 17.3\" - Pent... \n", | |
| "2015-05-08 10 40 LG 42LB6300 42" Smart HDTV with WebOS Ful... \n", | |
| "2015-05-08 23 41 Apple® - iPad Air 2 Wi-Fi 64GB - Silver \n", | |
| "\n", | |
| " transactionId itemQuantity \n", | |
| "date \n", | |
| "2015-05-08 640ED1BFEBC21 1 \n", | |
| "2015-05-08 401A7F84E8021 1 \n", | |
| "2015-05-08 401A7F84E8021 1 \n", | |
| "2015-05-08 401A7F84E8021 1 \n", | |
| "2015-05-08 4017BDB71B821 1 \n", | |
| "2015-05-08 3FF75771A0021 1 \n", | |
| "2015-05-08 3FF783C9F3821 1 \n", | |
| "2015-05-08 645FEEE901C21 1 \n", | |
| "2015-05-08 3FE3E3779A021 1 \n", | |
| "2015-05-08 3FE368A324821 1 \n", | |
| "2015-05-08 3FE368A324821 1 \n", | |
| "2015-05-08 3FE0F8DBB7421 1 \n", | |
| "2015-05-08 3FE0761BF0421 2 \n", | |
| "2015-05-08 3FB68D7808821 1 \n", | |
| "2015-05-08 3FC864A6F7021 1 \n", | |
| "2015-05-08 3FC5A61BF6021 1 \n", | |
| "2015-05-08 645A75BCB4C21 1 \n", | |
| "2015-05-08 645A59D53D021 1 \n", | |
| "2015-05-08 3FB48638EF421 2 \n", | |
| "2015-05-08 3F9B6EC5AF021 1 \n", | |
| "2015-05-08 3F9B6EC5AF021 1 \n", | |
| "2015-05-08 3F9B6EC5AF021 1 \n", | |
| "2015-05-08 3F9B6EC5AF021 1 \n", | |
| "2015-05-08 3F92B0FFC6021 1 \n", | |
| "2015-05-08 6465600D42421 1 \n", | |
| "2015-05-08 3F92B0FFC6021 1 \n", | |
| "2015-05-08 64651828A3021 1 \n", | |
| "2015-05-08 64651828A3021 1 \n", | |
| "2015-05-08 41AB0F1FD1C21 1 \n", | |
| "2015-05-08 4189CA46BF421 1 \n", | |
| "... ... ... \n", | |
| "2015-05-08 3CCA8AF206421 1 \n", | |
| "2015-05-08 3EEC76AEBB021 1 \n", | |
| "2015-05-08 3F8C9011D8021 1 \n", | |
| "2015-05-08 3EEC76AEBB021 1 \n", | |
| "2015-05-08 3EF4A29D35C21 1 \n", | |
| "2015-05-08 1B36A3AC19421 1 \n", | |
| "2015-05-08 3F8998ED84821 1 \n", | |
| "2015-05-08 3F46EB8CCE421 1 \n", | |
| "2015-05-08 3F46EB8CCE421 1 \n", | |
| "2015-05-08 3F46EB8CCE421 1 \n", | |
| "2015-05-08 1B35EDE5C5821 1 \n", | |
| "2015-05-08 3F390868CCC21 1 \n", | |
| "2015-05-08 644CF4E066821 1 \n", | |
| "2015-05-08 644CF4E066821 1 \n", | |
| "2015-05-08 644CF4E066821 1 \n", | |
| "2015-05-08 644CF4E066821 1 \n", | |
| "2015-05-08 644CF4E066821 1 \n", | |
| "2015-05-08 644CF4E066821 1 \n", | |
| "2015-05-08 3F220F04A1421 1 \n", | |
| "2015-05-08 3F19FCEF39421 4 \n", | |
| "2015-05-08 3F19FCEF39421 4 \n", | |
| "2015-05-08 3F1078F321421 1 \n", | |
| "2015-05-08 3F1078F321421 1 \n", | |
| "2015-05-08 3F1078F321421 1 \n", | |
| "2015-05-08 3EBF3FC0B2421 1 \n", | |
| "2015-05-08 3F0EF0130BC21 1 \n", | |
| "2015-05-08 3F008090CEC21 1 \n", | |
| "2015-05-08 3EFDDE2FDD821 1 \n", | |
| "2015-05-08 3EF199B5AFC21 1 \n", | |
| "2015-05-08 41A06D5977821 1 \n", | |
| "\n", | |
| "[107 rows x 5 columns]" | |
| ] | |
| }, | |
| "execution_count": 4, | |
| "metadata": {}, | |
| "output_type": "execute_result" | |
| } | |
| ], | |
| "source": [ | |
| "ga.read_ga(\n", | |
| " account_id = \"44376140\",\n", | |
| " profile_id = \"77093466\",\n", | |
| " property_id = \"UA-44376140-1\",\n", | |
| " metrics = ['itemQuantity'],\n", | |
| " dimensions = ['date', 'hour', 'minute', 'productName','transactionId'],\n", | |
| " start_date = \"2015-05-08\",\n", | |
| " end_date = \"2015-05-08\",\n", | |
| " index_col = 0)" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": null, | |
| "metadata": { | |
| "collapsed": false | |
| }, | |
| "outputs": [], | |
| "source": [] | |
| } | |
| ], | |
| "metadata": { | |
| "kernelspec": { | |
| "display_name": "Python 2", | |
| "language": "python", | |
| "name": "python2" | |
| }, | |
| "language_info": { | |
| "codemirror_mode": { | |
| "name": "ipython", | |
| "version": 2 | |
| }, | |
| "file_extension": ".py", | |
| "mimetype": "text/x-python", | |
| "name": "python", | |
| "nbconvert_exporter": "python", | |
| "pygments_lexer": "ipython2", | |
| "version": "2.7.9" | |
| } | |
| }, | |
| "nbformat": 4, | |
| "nbformat_minor": 0 | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment