Landing Page Analysis.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "landingpage = pd.read_excel(\"C:\\\\Users\\Joanna Kang\\\\Desktop\\TASK\\\\5. Data Anaylsis\\\\6월 페이지 랜딩 분석\\\\Analytics All Web Site Data All Traffic 20200601-20200629.xlsx\", sheet_name\n",
    "                        = \"Dataset1\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "import os"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": "         Source/Medium                                       Landing Page  \\\n0    Facebook / Social  /products/happy-weeks-zipper-file-folder-ryan?...   \n1    Facebook / Social  /products/baby-dreaming-theme-iphone-case-x-xs...   \n2    Facebook / Social  /collections/all-plush-toys/products/lemon-ter...   \n3    Facebook / Social                            /collections/sale-store   \n4    Facebook / Social  /products/baby-dreaming-theme-compact-glitter-...   \n..                 ...                                                ...   \n258  Facebook / Social  /products/yumyum-friends-mini-bag-little-apeac...   \n259  Facebook / Social  /products/yumyum-friends-mini-tote-bag-little-...   \n260  Facebook / Social                                     /search?q=Lamp   \n261  Facebook / Social                                 /search?q=Tote+bag   \n262                NaN                                                NaN   \n\n     Users  New Users  Sessions  Bounce Rate  Pages/Session  \\\n0        1          0         1     0.000000     102.000000   \n1        1          0         1     0.000000      30.000000   \n2        1          0         1     0.000000      16.000000   \n3        1          0         1     0.000000      28.000000   \n4        1          1         1     0.000000      16.000000   \n..     ...        ...       ...          ...            ...   \n258      3          1         3     1.000000       1.000000   \n259      4          0         4     1.000000       1.000000   \n260      1          0         1     1.000000       1.000000   \n261      1          0         1     1.000000       1.000000   \n262   1226        596      1305     0.595402       2.778544   \n\n     Avg. Session Duration  E-commerce Conversion Rate  Transactions  Revenue  \n0               6470.00000                    0.000000             0     0.00  \n1               2664.00000                    1.000000             1    43.97  \n2               2092.00000                    0.000000             0     0.00  \n3               1437.00000                    0.000000             0     0.00  \n4                899.00000                    0.000000             0     0.00  \n..                     ...                         ...           ...      ...  \n258                0.00000                    0.000000             0     0.00  \n259                0.00000                    0.000000             0     0.00  \n260                0.00000                    0.000000             0     0.00  \n261                0.00000                    0.000000             0     0.00  \n262               98.70728                    0.002299             3   149.93  \n\n[263 rows x 11 columns]",
      "text/html": "<div>\n<style scoped>\n    .dataframe tbody tr th:only-of-type {\n        vertical-align: middle;\n    }\n\n    .dataframe tbody tr th {\n        vertical-align: top;\n    }\n\n    .dataframe thead th {\n        text-align: right;\n    }\n</style>\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>Source/Medium</th>\n      <th>Landing Page</th>\n      <th>Users</th>\n      <th>New Users</th>\n      <th>Sessions</th>\n      <th>Bounce Rate</th>\n      <th>Pages/Session</th>\n      <th>Avg. Session Duration</th>\n      <th>E-commerce Conversion Rate</th>\n      <th>Transactions</th>\n      <th>Revenue</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>Facebook / Social</td>\n      <td>/products/happy-weeks-zipper-file-folder-ryan?...</td>\n      <td>1</td>\n      <td>0</td>\n      <td>1</td>\n      <td>0.000000</td>\n      <td>102.000000</td>\n      <td>6470.00000</td>\n      <td>0.000000</td>\n      <td>0</td>\n      <td>0.00</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>Facebook / Social</td>\n      <td>/products/baby-dreaming-theme-iphone-case-x-xs...</td>\n      <td>1</td>\n      <td>0</td>\n      <td>1</td>\n      <td>0.000000</td>\n      <td>30.000000</td>\n      <td>2664.00000</td>\n      <td>1.000000</td>\n      <td>1</td>\n      <td>43.97</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>Facebook / Social</td>\n      <td>/collections/all-plush-toys/products/lemon-ter...</td>\n      <td>1</td>\n      <td>0</td>\n      <td>1</td>\n      <td>0.000000</td>\n      <td>16.000000</td>\n      <td>2092.00000</td>\n      <td>0.000000</td>\n      <td>0</td>\n      <td>0.00</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>Facebook / Social</td>\n      <td>/collections/sale-store</td>\n      <td>1</td>\n      <td>0</td>\n      <td>1</td>\n      <td>0.000000</td>\n      <td>28.000000</td>\n      <td>1437.00000</td>\n      <td>0.000000</td>\n      <td>0</td>\n      <td>0.00</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>Facebook / Social</td>\n      <td>/products/baby-dreaming-theme-compact-glitter-...</td>\n      <td>1</td>\n      <td>1</td>\n      <td>1</td>\n      <td>0.000000</td>\n      <td>16.000000</td>\n      <td>899.00000</td>\n      <td>0.000000</td>\n      <td>0</td>\n      <td>0.00</td>\n    </tr>\n    <tr>\n      <th>...</th>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n    </tr>\n    <tr>\n      <th>258</th>\n      <td>Facebook / Social</td>\n      <td>/products/yumyum-friends-mini-bag-little-apeac...</td>\n      <td>3</td>\n      <td>1</td>\n      <td>3</td>\n      <td>1.000000</td>\n      <td>1.000000</td>\n      <td>0.00000</td>\n      <td>0.000000</td>\n      <td>0</td>\n      <td>0.00</td>\n    </tr>\n    <tr>\n      <th>259</th>\n      <td>Facebook / Social</td>\n      <td>/products/yumyum-friends-mini-tote-bag-little-...</td>\n      <td>4</td>\n      <td>0</td>\n      <td>4</td>\n      <td>1.000000</td>\n      <td>1.000000</td>\n      <td>0.00000</td>\n      <td>0.000000</td>\n      <td>0</td>\n      <td>0.00</td>\n    </tr>\n    <tr>\n      <th>260</th>\n      <td>Facebook / Social</td>\n      <td>/search?q=Lamp</td>\n      <td>1</td>\n      <td>0</td>\n      <td>1</td>\n      <td>1.000000</td>\n      <td>1.000000</td>\n      <td>0.00000</td>\n      <td>0.000000</td>\n      <td>0</td>\n      <td>0.00</td>\n    </tr>\n    <tr>\n      <th>261</th>\n      <td>Facebook / Social</td>\n      <td>/search?q=Tote+bag</td>\n      <td>1</td>\n      <td>0</td>\n      <td>1</td>\n      <td>1.000000</td>\n      <td>1.000000</td>\n      <td>0.00000</td>\n      <td>0.000000</td>\n      <td>0</td>\n      <td>0.00</td>\n    </tr>\n    <tr>\n      <th>262</th>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>1226</td>\n      <td>596</td>\n      <td>1305</td>\n      <td>0.595402</td>\n      <td>2.778544</td>\n      <td>98.70728</td>\n      <td>0.002299</td>\n      <td>3</td>\n      <td>149.93</td>\n    </tr>\n  </tbody>\n</table>\n<p>263 rows × 11 columns</p>\n</div>"
     },
     "metadata": {},
     "execution_count": 14
    }
   ],
   "source": [
    "landingpage"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [],
   "source": [
    "split_landingpage = landingpage['Landing Page'].str.split('/')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [],
   "source": [
    "split_landingpage = split_landingpage.apply(lambda x: pd.Series(x))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [],
   "source": [
    "landingpage = landingpage.merge(split_landingpage, left_index=True, right_index=True, how='left')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [],
   "source": [
    "landingpage = landingpage.rename({0:'Depth1', 1:'Depth1', 2: 'Depth3', 3: 'Depth4', 4: 'Depth5'}, axis='columns')\n",
    "\n",
    "#landingpage.columns.values[11:16] = 'depth1', 'depth2', 'depth3', 'depth4'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": "         Source/Medium                                       Landing Page  \\\n0    Facebook / Social  /products/happy-weeks-zipper-file-folder-ryan?...   \n1    Facebook / Social  /products/baby-dreaming-theme-iphone-case-x-xs...   \n2    Facebook / Social  /collections/all-plush-toys/products/lemon-ter...   \n3    Facebook / Social                            /collections/sale-store   \n4    Facebook / Social  /products/baby-dreaming-theme-compact-glitter-...   \n..                 ...                                                ...   \n258  Facebook / Social  /products/yumyum-friends-mini-bag-little-apeac...   \n259  Facebook / Social  /products/yumyum-friends-mini-tote-bag-little-...   \n260  Facebook / Social                                     /search?q=Lamp   \n261  Facebook / Social                                 /search?q=Tote+bag   \n262                NaN                                                NaN   \n\n     Users  New Users  Sessions  Bounce Rate  Pages/Session  \\\n0        1          0         1     0.000000     102.000000   \n1        1          0         1     0.000000      30.000000   \n2        1          0         1     0.000000      16.000000   \n3        1          0         1     0.000000      28.000000   \n4        1          1         1     0.000000      16.000000   \n..     ...        ...       ...          ...            ...   \n258      3          1         3     1.000000       1.000000   \n259      4          0         4     1.000000       1.000000   \n260      1          0         1     1.000000       1.000000   \n261      1          0         1     1.000000       1.000000   \n262   1226        596      1305     0.595402       2.778544   \n\n     Avg. Session Duration  E-commerce Conversion Rate  Transactions  Revenue  \\\n0               6470.00000                    0.000000             0     0.00   \n1               2664.00000                    1.000000             1    43.97   \n2               2092.00000                    0.000000             0     0.00   \n3               1437.00000                    0.000000             0     0.00   \n4                899.00000                    0.000000             0     0.00   \n..                     ...                         ...           ...      ...   \n258                0.00000                    0.000000             0     0.00   \n259                0.00000                    0.000000             0     0.00   \n260                0.00000                    0.000000             0     0.00   \n261                0.00000                    0.000000             0     0.00   \n262               98.70728                    0.002299             3   149.93   \n\n    Depth1             Depth1  \\\n0                    products   \n1                    products   \n2                 collections   \n3                 collections   \n4                    products   \n..     ...                ...   \n258                  products   \n259                  products   \n260             search?q=Lamp   \n261         search?q=Tote+bag   \n262    NaN                NaN   \n\n                                                Depth3    Depth4  \\\n0    happy-weeks-zipper-file-folder-ryan?variant=31...       NaN   \n1    baby-dreaming-theme-iphone-case-x-xs-11-11pro-...       NaN   \n2                                       all-plush-toys  products   \n3                                           sale-store       NaN   \n4    baby-dreaming-theme-compact-glitter-mirror-lit...       NaN   \n..                                                 ...       ...   \n258  yumyum-friends-mini-bag-little-apeach?variant=...       NaN   \n259  yumyum-friends-mini-tote-bag-little-apeach?var...       NaN   \n260                                                NaN       NaN   \n261                                                NaN       NaN   \n262                                                NaN       NaN   \n\n                       Depth5  \n0                         NaN  \n1                         NaN  \n2    lemon-terrace-plush-ryan  \n3                         NaN  \n4                         NaN  \n..                        ...  \n258                       NaN  \n259                       NaN  \n260                       NaN  \n261                       NaN  \n262                       NaN  \n\n[263 rows x 16 columns]",
      "text/html": "<div>\n<style scoped>\n    .dataframe tbody tr th:only-of-type {\n        vertical-align: middle;\n    }\n\n    .dataframe tbody tr th {\n        vertical-align: top;\n    }\n\n    .dataframe thead th {\n        text-align: right;\n    }\n</style>\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>Source/Medium</th>\n      <th>Landing Page</th>\n      <th>Users</th>\n      <th>New Users</th>\n      <th>Sessions</th>\n      <th>Bounce Rate</th>\n      <th>Pages/Session</th>\n      <th>Avg. Session Duration</th>\n      <th>E-commerce Conversion Rate</th>\n      <th>Transactions</th>\n      <th>Revenue</th>\n      <th>Depth1</th>\n      <th>Depth1</th>\n      <th>Depth3</th>\n      <th>Depth4</th>\n      <th>Depth5</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>Facebook / Social</td>\n      <td>/products/happy-weeks-zipper-file-folder-ryan?...</td>\n      <td>1</td>\n      <td>0</td>\n      <td>1</td>\n      <td>0.000000</td>\n      <td>102.000000</td>\n      <td>6470.00000</td>\n      <td>0.000000</td>\n      <td>0</td>\n      <td>0.00</td>\n      <td></td>\n      <td>products</td>\n      <td>happy-weeks-zipper-file-folder-ryan?variant=31...</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>Facebook / Social</td>\n      <td>/products/baby-dreaming-theme-iphone-case-x-xs...</td>\n      <td>1</td>\n      <td>0</td>\n      <td>1</td>\n      <td>0.000000</td>\n      <td>30.000000</td>\n      <td>2664.00000</td>\n      <td>1.000000</td>\n      <td>1</td>\n      <td>43.97</td>\n      <td></td>\n      <td>products</td>\n      <td>baby-dreaming-theme-iphone-case-x-xs-11-11pro-...</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>Facebook / Social</td>\n      <td>/collections/all-plush-toys/products/lemon-ter...</td>\n      <td>1</td>\n      <td>0</td>\n      <td>1</td>\n      <td>0.000000</td>\n      <td>16.000000</td>\n      <td>2092.00000</td>\n      <td>0.000000</td>\n      <td>0</td>\n      <td>0.00</td>\n      <td></td>\n      <td>collections</td>\n      <td>all-plush-toys</td>\n      <td>products</td>\n      <td>lemon-terrace-plush-ryan</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>Facebook / Social</td>\n      <td>/collections/sale-store</td>\n      <td>1</td>\n      <td>0</td>\n      <td>1</td>\n      <td>0.000000</td>\n      <td>28.000000</td>\n      <td>1437.00000</td>\n      <td>0.000000</td>\n      <td>0</td>\n      <td>0.00</td>\n      <td></td>\n      <td>collections</td>\n      <td>sale-store</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>Facebook / Social</td>\n      <td>/products/baby-dreaming-theme-compact-glitter-...</td>\n      <td>1</td>\n      <td>1</td>\n      <td>1</td>\n      <td>0.000000</td>\n      <td>16.000000</td>\n      <td>899.00000</td>\n      <td>0.000000</td>\n      <td>0</td>\n      <td>0.00</td>\n      <td></td>\n      <td>products</td>\n      <td>baby-dreaming-theme-compact-glitter-mirror-lit...</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>...</th>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n    </tr>\n    <tr>\n      <th>258</th>\n      <td>Facebook / Social</td>\n      <td>/products/yumyum-friends-mini-bag-little-apeac...</td>\n      <td>3</td>\n      <td>1</td>\n      <td>3</td>\n      <td>1.000000</td>\n      <td>1.000000</td>\n      <td>0.00000</td>\n      <td>0.000000</td>\n      <td>0</td>\n      <td>0.00</td>\n      <td></td>\n      <td>products</td>\n      <td>yumyum-friends-mini-bag-little-apeach?variant=...</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>259</th>\n      <td>Facebook / Social</td>\n      <td>/products/yumyum-friends-mini-tote-bag-little-...</td>\n      <td>4</td>\n      <td>0</td>\n      <td>4</td>\n      <td>1.000000</td>\n      <td>1.000000</td>\n      <td>0.00000</td>\n      <td>0.000000</td>\n      <td>0</td>\n      <td>0.00</td>\n      <td></td>\n      <td>products</td>\n      <td>yumyum-friends-mini-tote-bag-little-apeach?var...</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>260</th>\n      <td>Facebook / Social</td>\n      <td>/search?q=Lamp</td>\n      <td>1</td>\n      <td>0</td>\n      <td>1</td>\n      <td>1.000000</td>\n      <td>1.000000</td>\n      <td>0.00000</td>\n      <td>0.000000</td>\n      <td>0</td>\n      <td>0.00</td>\n      <td></td>\n      <td>search?q=Lamp</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>261</th>\n      <td>Facebook / Social</td>\n      <td>/search?q=Tote+bag</td>\n      <td>1</td>\n      <td>0</td>\n      <td>1</td>\n      <td>1.000000</td>\n      <td>1.000000</td>\n      <td>0.00000</td>\n      <td>0.000000</td>\n      <td>0</td>\n      <td>0.00</td>\n      <td></td>\n      <td>search?q=Tote+bag</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>262</th>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>1226</td>\n      <td>596</td>\n      <td>1305</td>\n      <td>0.595402</td>\n      <td>2.778544</td>\n      <td>98.70728</td>\n      <td>0.002299</td>\n      <td>3</td>\n      <td>149.93</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n  </tbody>\n</table>\n<p>263 rows × 16 columns</p>\n</div>"
     },
     "metadata": {},
     "execution_count": 39
    }
   ],
   "source": [
    "landingpage"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": "       0                  1  \\\n0                  products   \n1                  products   \n2               collections   \n3               collections   \n4                  products   \n..   ...                ...   \n258                products   \n259                products   \n260           search?q=Lamp   \n261       search?q=Tote+bag   \n262  NaN                NaN   \n\n                                                     2         3  \\\n0    happy-weeks-zipper-file-folder-ryan?variant=31...       NaN   \n1    baby-dreaming-theme-iphone-case-x-xs-11-11pro-...       NaN   \n2                                       all-plush-toys  products   \n3                                           sale-store       NaN   \n4    baby-dreaming-theme-compact-glitter-mirror-lit...       NaN   \n..                                                 ...       ...   \n258  yumyum-friends-mini-bag-little-apeach?variant=...       NaN   \n259  yumyum-friends-mini-tote-bag-little-apeach?var...       NaN   \n260                                                NaN       NaN   \n261                                                NaN       NaN   \n262                                                NaN       NaN   \n\n                            4  \n0                         NaN  \n1                         NaN  \n2    lemon-terrace-plush-ryan  \n3                         NaN  \n4                         NaN  \n..                        ...  \n258                       NaN  \n259                       NaN  \n260                       NaN  \n261                       NaN  \n262                       NaN  \n\n[263 rows x 5 columns]",
      "text/html": "<div>\n<style scoped>\n    .dataframe tbody tr th:only-of-type {\n        vertical-align: middle;\n    }\n\n    .dataframe tbody tr th {\n        vertical-align: top;\n    }\n\n    .dataframe thead th {\n        text-align: right;\n    }\n</style>\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>0</th>\n      <th>1</th>\n      <th>2</th>\n      <th>3</th>\n      <th>4</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td></td>\n      <td>products</td>\n      <td>happy-weeks-zipper-file-folder-ryan?variant=31...</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td></td>\n      <td>products</td>\n      <td>baby-dreaming-theme-iphone-case-x-xs-11-11pro-...</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td></td>\n      <td>collections</td>\n      <td>all-plush-toys</td>\n      <td>products</td>\n      <td>lemon-terrace-plush-ryan</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td></td>\n      <td>collections</td>\n      <td>sale-store</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td></td>\n      <td>products</td>\n      <td>baby-dreaming-theme-compact-glitter-mirror-lit...</td>\n      <td>NaN</td>\n      <td>NaN</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>258</th>\n      <td></td>\n      <td>products</td>\n      <td>yumyum-friends-mini-bag-little-apeach?variant=...</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>259</th>\n      <td></td>\n      <td>products</td>\n      <td>yumyum-friends-mini-tote-bag-little-apeach?var...</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>260</th>\n      <td></td>\n      <td>search?q=Lamp</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>261</th>\n      <td></td>\n      <td>search?q=Tote+bag</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>262</th>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n  </tbody>\n</table>\n<p>263 rows × 5 columns</p>\n</div>"
     },
     "metadata": {},
     "execution_count": 30
    }
   ],
   "source": [
    "split_landingpage"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": "0      [, products, happy-weeks-zipper-file-folder-ry...\n1      [, products, baby-dreaming-theme-iphone-case-x...\n2      [, collections, all-plush-toys, products, lemo...\n3                            [, collections, sale-store]\n4      [, products, baby-dreaming-theme-compact-glitt...\n                             ...                        \n258    [, products, yumyum-friends-mini-bag-little-ap...\n259    [, products, yumyum-friends-mini-tote-bag-litt...\n260                                    [, search?q=Lamp]\n261                                [, search?q=Tote+bag]\n262                                                  NaN\nName: Landing Page, Length: 263, dtype: object"
     },
     "metadata": {},
     "execution_count": 28
    }
   ],
   "source": [
    "split_landingpage"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "split = landingpage['Source/Medium'].str.split('/')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": "             0        1\n0    Facebook    Social\n1    Facebook    Social\n2    Facebook    Social\n3    Facebook    Social\n4    Facebook    Social\n..         ...      ...\n258  Facebook    Social\n259  Facebook    Social\n260  Facebook    Social\n261  Facebook    Social\n262        NaN      NaN\n\n[263 rows x 2 columns]",
      "text/html": "<div>\n<style scoped>\n    .dataframe tbody tr th:only-of-type {\n        vertical-align: middle;\n    }\n\n    .dataframe tbody tr th {\n        vertical-align: top;\n    }\n\n    .dataframe thead th {\n        text-align: right;\n    }\n</style>\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>0</th>\n      <th>1</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>Facebook</td>\n      <td>Social</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>Facebook</td>\n      <td>Social</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>Facebook</td>\n      <td>Social</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>Facebook</td>\n      <td>Social</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>Facebook</td>\n      <td>Social</td>\n    </tr>\n    <tr>\n      <th>...</th>\n      <td>...</td>\n      <td>...</td>\n    </tr>\n    <tr>\n      <th>258</th>\n      <td>Facebook</td>\n      <td>Social</td>\n    </tr>\n    <tr>\n      <th>259</th>\n      <td>Facebook</td>\n      <td>Social</td>\n    </tr>\n    <tr>\n      <th>260</th>\n      <td>Facebook</td>\n      <td>Social</td>\n    </tr>\n    <tr>\n      <th>261</th>\n      <td>Facebook</td>\n      <td>Social</td>\n    </tr>\n    <tr>\n      <th>262</th>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n  </tbody>\n</table>\n<p>263 rows × 2 columns</p>\n</div>"
     },
     "metadata": {},
     "execution_count": 18
    }
   ],
   "source": [
    "split = split.apply(lambda x: pd.Series(x))\n",
    "split"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    "split = split.rename({0:'Source', 1:'Medium'}, axis='columns')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": "        Source   Medium\n0    Facebook    Social\n1    Facebook    Social\n2    Facebook    Social\n3    Facebook    Social\n4    Facebook    Social\n..         ...      ...\n258  Facebook    Social\n259  Facebook    Social\n260  Facebook    Social\n261  Facebook    Social\n262        NaN      NaN\n\n[263 rows x 2 columns]",
      "text/html": "<div>\n<style scoped>\n    .dataframe tbody tr th:only-of-type {\n        vertical-align: middle;\n    }\n\n    .dataframe tbody tr th {\n        vertical-align: top;\n    }\n\n    .dataframe thead th {\n        text-align: right;\n    }\n</style>\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>Source</th>\n      <th>Medium</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>Facebook</td>\n      <td>Social</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>Facebook</td>\n      <td>Social</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>Facebook</td>\n      <td>Social</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>Facebook</td>\n      <td>Social</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>Facebook</td>\n      <td>Social</td>\n    </tr>\n    <tr>\n      <th>...</th>\n      <td>...</td>\n      <td>...</td>\n    </tr>\n    <tr>\n      <th>258</th>\n      <td>Facebook</td>\n      <td>Social</td>\n    </tr>\n    <tr>\n      <th>259</th>\n      <td>Facebook</td>\n      <td>Social</td>\n    </tr>\n    <tr>\n      <th>260</th>\n      <td>Facebook</td>\n      <td>Social</td>\n    </tr>\n    <tr>\n      <th>261</th>\n      <td>Facebook</td>\n      <td>Social</td>\n    </tr>\n    <tr>\n      <th>262</th>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n  </tbody>\n</table>\n<p>263 rows × 2 columns</p>\n</div>"
     },
     "metadata": {},
     "execution_count": 26
    }
   ],
   "source": [
    "split"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [],
   "source": [
    "landingpage = landingpage.merge(split, left_index=True, right_index=True, how='left')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": "         Source/Medium                                       Landing Page  \\\n0    Facebook / Social  /products/happy-weeks-zipper-file-folder-ryan?...   \n1    Facebook / Social  /products/baby-dreaming-theme-iphone-case-x-xs...   \n2    Facebook / Social  /collections/all-plush-toys/products/lemon-ter...   \n3    Facebook / Social                            /collections/sale-store   \n4    Facebook / Social  /products/baby-dreaming-theme-compact-glitter-...   \n..                 ...                                                ...   \n258  Facebook / Social  /products/yumyum-friends-mini-bag-little-apeac...   \n259  Facebook / Social  /products/yumyum-friends-mini-tote-bag-little-...   \n260  Facebook / Social                                     /search?q=Lamp   \n261  Facebook / Social                                 /search?q=Tote+bag   \n262                NaN                                                NaN   \n\n     Users  New Users  Sessions  Bounce Rate  Pages/Session  \\\n0        1          0         1     0.000000     102.000000   \n1        1          0         1     0.000000      30.000000   \n2        1          0         1     0.000000      16.000000   \n3        1          0         1     0.000000      28.000000   \n4        1          1         1     0.000000      16.000000   \n..     ...        ...       ...          ...            ...   \n258      3          1         3     1.000000       1.000000   \n259      4          0         4     1.000000       1.000000   \n260      1          0         1     1.000000       1.000000   \n261      1          0         1     1.000000       1.000000   \n262   1226        596      1305     0.595402       2.778544   \n\n     Avg. Session Duration  E-commerce Conversion Rate  Transactions  Revenue  \\\n0               6470.00000                    0.000000             0     0.00   \n1               2664.00000                    1.000000             1    43.97   \n2               2092.00000                    0.000000             0     0.00   \n3               1437.00000                    0.000000             0     0.00   \n4                899.00000                    0.000000             0     0.00   \n..                     ...                         ...           ...      ...   \n258                0.00000                    0.000000             0     0.00   \n259                0.00000                    0.000000             0     0.00   \n260                0.00000                    0.000000             0     0.00   \n261                0.00000                    0.000000             0     0.00   \n262               98.70728                    0.002299             3   149.93   \n\n    Depth1             Depth1  \\\n0                    products   \n1                    products   \n2                 collections   \n3                 collections   \n4                    products   \n..     ...                ...   \n258                  products   \n259                  products   \n260             search?q=Lamp   \n261         search?q=Tote+bag   \n262    NaN                NaN   \n\n                                                Depth3    Depth4  \\\n0    happy-weeks-zipper-file-folder-ryan?variant=31...       NaN   \n1    baby-dreaming-theme-iphone-case-x-xs-11-11pro-...       NaN   \n2                                       all-plush-toys  products   \n3                                           sale-store       NaN   \n4    baby-dreaming-theme-compact-glitter-mirror-lit...       NaN   \n..                                                 ...       ...   \n258  yumyum-friends-mini-bag-little-apeach?variant=...       NaN   \n259  yumyum-friends-mini-tote-bag-little-apeach?var...       NaN   \n260                                                NaN       NaN   \n261                                                NaN       NaN   \n262                                                NaN       NaN   \n\n                       Depth5     Source   Medium  \n0                         NaN  Facebook    Social  \n1                         NaN  Facebook    Social  \n2    lemon-terrace-plush-ryan  Facebook    Social  \n3                         NaN  Facebook    Social  \n4                         NaN  Facebook    Social  \n..                        ...        ...      ...  \n258                       NaN  Facebook    Social  \n259                       NaN  Facebook    Social  \n260                       NaN  Facebook    Social  \n261                       NaN  Facebook    Social  \n262                       NaN        NaN      NaN  \n\n[263 rows x 18 columns]",
      "text/html": "<div>\n<style scoped>\n    .dataframe tbody tr th:only-of-type {\n        vertical-align: middle;\n    }\n\n    .dataframe tbody tr th {\n        vertical-align: top;\n    }\n\n    .dataframe thead th {\n        text-align: right;\n    }\n</style>\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>Source/Medium</th>\n      <th>Landing Page</th>\n      <th>Users</th>\n      <th>New Users</th>\n      <th>Sessions</th>\n      <th>Bounce Rate</th>\n      <th>Pages/Session</th>\n      <th>Avg. Session Duration</th>\n      <th>E-commerce Conversion Rate</th>\n      <th>Transactions</th>\n      <th>Revenue</th>\n      <th>Depth1</th>\n      <th>Depth1</th>\n      <th>Depth3</th>\n      <th>Depth4</th>\n      <th>Depth5</th>\n      <th>Source</th>\n      <th>Medium</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>Facebook / Social</td>\n      <td>/products/happy-weeks-zipper-file-folder-ryan?...</td>\n      <td>1</td>\n      <td>0</td>\n      <td>1</td>\n      <td>0.000000</td>\n      <td>102.000000</td>\n      <td>6470.00000</td>\n      <td>0.000000</td>\n      <td>0</td>\n      <td>0.00</td>\n      <td></td>\n      <td>products</td>\n      <td>happy-weeks-zipper-file-folder-ryan?variant=31...</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>Facebook</td>\n      <td>Social</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>Facebook / Social</td>\n      <td>/products/baby-dreaming-theme-iphone-case-x-xs...</td>\n      <td>1</td>\n      <td>0</td>\n      <td>1</td>\n      <td>0.000000</td>\n      <td>30.000000</td>\n      <td>2664.00000</td>\n      <td>1.000000</td>\n      <td>1</td>\n      <td>43.97</td>\n      <td></td>\n      <td>products</td>\n      <td>baby-dreaming-theme-iphone-case-x-xs-11-11pro-...</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>Facebook</td>\n      <td>Social</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>Facebook / Social</td>\n      <td>/collections/all-plush-toys/products/lemon-ter...</td>\n      <td>1</td>\n      <td>0</td>\n      <td>1</td>\n      <td>0.000000</td>\n      <td>16.000000</td>\n      <td>2092.00000</td>\n      <td>0.000000</td>\n      <td>0</td>\n      <td>0.00</td>\n      <td></td>\n      <td>collections</td>\n      <td>all-plush-toys</td>\n      <td>products</td>\n      <td>lemon-terrace-plush-ryan</td>\n      <td>Facebook</td>\n      <td>Social</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>Facebook / Social</td>\n      <td>/collections/sale-store</td>\n      <td>1</td>\n      <td>0</td>\n      <td>1</td>\n      <td>0.000000</td>\n      <td>28.000000</td>\n      <td>1437.00000</td>\n      <td>0.000000</td>\n      <td>0</td>\n      <td>0.00</td>\n      <td></td>\n      <td>collections</td>\n      <td>sale-store</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>Facebook</td>\n      <td>Social</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>Facebook / Social</td>\n      <td>/products/baby-dreaming-theme-compact-glitter-...</td>\n      <td>1</td>\n      <td>1</td>\n      <td>1</td>\n      <td>0.000000</td>\n      <td>16.000000</td>\n      <td>899.00000</td>\n      <td>0.000000</td>\n      <td>0</td>\n      <td>0.00</td>\n      <td></td>\n      <td>products</td>\n      <td>baby-dreaming-theme-compact-glitter-mirror-lit...</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>Facebook</td>\n      <td>Social</td>\n    </tr>\n    <tr>\n      <th>...</th>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n    </tr>\n    <tr>\n      <th>258</th>\n      <td>Facebook / Social</td>\n      <td>/products/yumyum-friends-mini-bag-little-apeac...</td>\n      <td>3</td>\n      <td>1</td>\n      <td>3</td>\n      <td>1.000000</td>\n      <td>1.000000</td>\n      <td>0.00000</td>\n      <td>0.000000</td>\n      <td>0</td>\n      <td>0.00</td>\n      <td></td>\n      <td>products</td>\n      <td>yumyum-friends-mini-bag-little-apeach?variant=...</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>Facebook</td>\n      <td>Social</td>\n    </tr>\n    <tr>\n      <th>259</th>\n      <td>Facebook / Social</td>\n      <td>/products/yumyum-friends-mini-tote-bag-little-...</td>\n      <td>4</td>\n      <td>0</td>\n      <td>4</td>\n      <td>1.000000</td>\n      <td>1.000000</td>\n      <td>0.00000</td>\n      <td>0.000000</td>\n      <td>0</td>\n      <td>0.00</td>\n      <td></td>\n      <td>products</td>\n      <td>yumyum-friends-mini-tote-bag-little-apeach?var...</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>Facebook</td>\n      <td>Social</td>\n    </tr>\n    <tr>\n      <th>260</th>\n      <td>Facebook / Social</td>\n      <td>/search?q=Lamp</td>\n      <td>1</td>\n      <td>0</td>\n      <td>1</td>\n      <td>1.000000</td>\n      <td>1.000000</td>\n      <td>0.00000</td>\n      <td>0.000000</td>\n      <td>0</td>\n      <td>0.00</td>\n      <td></td>\n      <td>search?q=Lamp</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>Facebook</td>\n      <td>Social</td>\n    </tr>\n    <tr>\n      <th>261</th>\n      <td>Facebook / Social</td>\n      <td>/search?q=Tote+bag</td>\n      <td>1</td>\n      <td>0</td>\n      <td>1</td>\n      <td>1.000000</td>\n      <td>1.000000</td>\n      <td>0.00000</td>\n      <td>0.000000</td>\n      <td>0</td>\n      <td>0.00</td>\n      <td></td>\n      <td>search?q=Tote+bag</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>Facebook</td>\n      <td>Social</td>\n    </tr>\n    <tr>\n      <th>262</th>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>1226</td>\n      <td>596</td>\n      <td>1305</td>\n      <td>0.595402</td>\n      <td>2.778544</td>\n      <td>98.70728</td>\n      <td>0.002299</td>\n      <td>3</td>\n      <td>149.93</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n  </tbody>\n</table>\n<p>263 rows × 18 columns</p>\n</div>"
     },
     "metadata": {},
     "execution_count": 43
    }
   ],
   "source": [
    "landingpage"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "metadata": {},
   "outputs": [],
   "source": [
    "session_per_pages = pd.pivot_table(landingpage, index='Depth3', values=['Sessions', 'Avg. Session Duration', 'Pages/Session', 'Bounce Rate', 'Transactions'], aggfunc='sum')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": "                                                    Avg. Session Duration  \\\nDepth3                                                                      \nacrylic-keyring-apeach?variant=31773338927189                   54.000000   \nairpods-cases-accessories                                        0.000000   \nairpods-pro-case-cover-with-keyring-little-apea...             414.285714   \nairpods-pro-case-cover-with-keyring-ryan?varian...               0.000000   \nall-beauty-bath                                                  0.000000   \n...                                                                   ...   \nyumyum-friends-tote-bag-little-jay-g?variant=32...             178.000000   \nyumyum-friends-tote-bag-little-ryan?variant=323...               5.833333   \nyumyum-friends-tote-bag-little-tube?variant=323...              94.833333   \nyumyum-friends-trivet-little-apeach?variant=323...              74.000000   \nyumyum-friends-trivet-little-ryan?variant=32302...              95.692308   \n\n                                                    Bounce Rate  \\\nDepth3                                                            \nacrylic-keyring-apeach?variant=31773338927189          0.000000   \nairpods-cases-accessories                              1.000000   \nairpods-pro-case-cover-with-keyring-little-apea...     0.428571   \nairpods-pro-case-cover-with-keyring-ryan?varian...     1.000000   \nall-beauty-bath                                        1.000000   \n...                                                         ...   \nyumyum-friends-tote-bag-little-jay-g?variant=32...     0.400000   \nyumyum-friends-tote-bag-little-ryan?variant=323...     0.833333   \nyumyum-friends-tote-bag-little-tube?variant=323...     0.333333   \nyumyum-friends-trivet-little-apeach?variant=323...     0.750000   \nyumyum-friends-trivet-little-ryan?variant=32302...     0.692308   \n\n                                                    Pages/Session  Sessions  \\\nDepth3                                                                        \nacrylic-keyring-apeach?variant=31773338927189            5.000000         2   \nairpods-cases-accessories                                1.000000         1   \nairpods-pro-case-cover-with-keyring-little-apea...       6.285714         7   \nairpods-pro-case-cover-with-keyring-ryan?varian...       1.000000         1   \nall-beauty-bath                                          1.000000         2   \n...                                                           ...       ...   \nyumyum-friends-tote-bag-little-jay-g?variant=32...       3.800000         5   \nyumyum-friends-tote-bag-little-ryan?variant=323...       1.166667         6   \nyumyum-friends-tote-bag-little-tube?variant=323...       4.666667         6   \nyumyum-friends-trivet-little-apeach?variant=323...       2.250000         4   \nyumyum-friends-trivet-little-ryan?variant=32302...       3.000000        13   \n\n                                                    Transactions  \nDepth3                                                            \nacrylic-keyring-apeach?variant=31773338927189                  0  \nairpods-cases-accessories                                      0  \nairpods-pro-case-cover-with-keyring-little-apea...             0  \nairpods-pro-case-cover-with-keyring-ryan?varian...             0  \nall-beauty-bath                                                0  \n...                                                          ...  \nyumyum-friends-tote-bag-little-jay-g?variant=32...             0  \nyumyum-friends-tote-bag-little-ryan?variant=323...             0  \nyumyum-friends-tote-bag-little-tube?variant=323...             0  \nyumyum-friends-trivet-little-apeach?variant=323...             0  \nyumyum-friends-trivet-little-ryan?variant=32302...             0  \n\n[253 rows x 5 columns]",
      "text/html": "<div>\n<style scoped>\n    .dataframe tbody tr th:only-of-type {\n        vertical-align: middle;\n    }\n\n    .dataframe tbody tr th {\n        vertical-align: top;\n    }\n\n    .dataframe thead th {\n        text-align: right;\n    }\n</style>\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>Avg. Session Duration</th>\n      <th>Bounce Rate</th>\n      <th>Pages/Session</th>\n      <th>Sessions</th>\n      <th>Transactions</th>\n    </tr>\n    <tr>\n      <th>Depth3</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>acrylic-keyring-apeach?variant=31773338927189</th>\n      <td>54.000000</td>\n      <td>0.000000</td>\n      <td>5.000000</td>\n      <td>2</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>airpods-cases-accessories</th>\n      <td>0.000000</td>\n      <td>1.000000</td>\n      <td>1.000000</td>\n      <td>1</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>airpods-pro-case-cover-with-keyring-little-apeach?variant=31718312083541</th>\n      <td>414.285714</td>\n      <td>0.428571</td>\n      <td>6.285714</td>\n      <td>7</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>airpods-pro-case-cover-with-keyring-ryan?variant=31718308020309</th>\n      <td>0.000000</td>\n      <td>1.000000</td>\n      <td>1.000000</td>\n      <td>1</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>all-beauty-bath</th>\n      <td>0.000000</td>\n      <td>1.000000</td>\n      <td>1.000000</td>\n      <td>2</td>\n      <td>0</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>yumyum-friends-tote-bag-little-jay-g?variant=32302211924053</th>\n      <td>178.000000</td>\n      <td>0.400000</td>\n      <td>3.800000</td>\n      <td>5</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>yumyum-friends-tote-bag-little-ryan?variant=32302177026133</th>\n      <td>5.833333</td>\n      <td>0.833333</td>\n      <td>1.166667</td>\n      <td>6</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>yumyum-friends-tote-bag-little-tube?variant=32302200684629</th>\n      <td>94.833333</td>\n      <td>0.333333</td>\n      <td>4.666667</td>\n      <td>6</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>yumyum-friends-trivet-little-apeach?variant=32302428225621</th>\n      <td>74.000000</td>\n      <td>0.750000</td>\n      <td>2.250000</td>\n      <td>4</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>yumyum-friends-trivet-little-ryan?variant=32302386708565</th>\n      <td>95.692308</td>\n      <td>0.692308</td>\n      <td>3.000000</td>\n      <td>13</td>\n      <td>0</td>\n    </tr>\n  </tbody>\n</table>\n<p>253 rows × 5 columns</p>\n</div>"
     },
     "metadata": {},
     "execution_count": 74
    }
   ],
   "source": [
    "session_per_pages"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 75,
   "metadata": {},
   "outputs": [],
   "source": [
    "session_per_pages = session_per_pages.sort_values(by = ['Transactions', 'Avg. Session Duration'], ascending = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": "                                                    Avg. Session Duration  \\\nDepth3                                                                      \nbaby-dreaming-theme-iphone-case-x-xs-11-11pro-1...            2664.000000   \nplush-doll-lovely-apeach-1?variant=23259320189013              146.500000   \nyumyum-friends-mini-tote-bag-little-jay-g?varia...             143.111111   \nhappy-weeks-zipper-file-folder-ryan?variant=318...            6470.000000   \nall-plush-toys                                                2092.000000   \nsale-store                                                    1437.000000   \nall-products                                                   931.000000   \nbaby-dreaming-theme-compact-glitter-mirror-litt...             899.000000   \nsoft-face-cushion-tube?variant=21943860297813                  688.000000   \nsale-store?constraint=custom-filter+page=4                     569.000000   \ncontact_information?discount=                                  553.000000   \nbaby-dreaming-theme-bag-little-apeach?variant=3...             519.666667   \nhugging-body-pillow-jay-g?variant=30735413149781               500.666667   \nhoodie-body-pillow-muzi-con                                    497.000000   \nbaby-dreaming-theme-hair-brush-apeach?variant=3...             496.000000   \nbaby-dreaming-theme-pen-holder-memo?variant=321...             479.666667   \nplush-pencil-case-apeach?variant=30315703533653                455.000000   \nhoodie-body-pillow-muzi-con?_pos=15&_sid=3dab0f...             418.000000   \nairpods-pro-case-cover-with-keyring-little-apea...             414.285714   \ncheese-friends-mug-ryan?variant=31718302613589                 389.500000   \nhappy-weeks-document-index-file-muzi?variant=31...             368.000000   \nhappy-weeks-multi-pen-4-colours-sharpening-penc...             357.000000   \nhappy-weeks-ruled-note-friday-apeach?variant=31...             323.500000   \nmini-face-plush-keyring-apeach?variant=32126159...             312.333333   \nbaby-dreaming-theme-kids-pyjama-little-apeach?v...             293.000000   \nall-products?constraint=custom-filter+page=2                   285.000000   \nforest-theme-ivory-slipper-ryan?variant=3103376...             268.500000   \nhappy-weeks-document-index-file-ryan?variant=31...             267.600000   \nhappy-weeks-a5-ringbound-notepad-apeach?variant...             264.777778   \nyumyum-friends-keyring-little-ryan?variant=3230...             264.200000   \nmini-face-plush-keyring-little-con?variant=3212...             261.000000   \nmini-pillow-little-apeach?variant=22802854576213               249.200000   \nbadges                                                         248.000000   \nbaby-dreaming-theme-glitter-airpods-case-ryan?v...             243.333333   \nbuds-buds-pro-case-ryan?variant=32002822013013                 241.650000   \nhappy-weeks-a5-ringbound-notepad-ryan?variant=3...             240.333333   \npu-airpods-case-little-ryan?variant=31602224037973             237.000000   \nhoodie-body-pillow-ryan?variant=31830366290005                 233.428571   \nlemon-terrace-pyjama-set-ryan?variant=323007487...             209.538462   \nhumidifier-little-apeach?variant=31705923223637                199.000000   \nyumyum-friends-tote-bag-little-jay-g?variant=32...             178.000000   \nhappy-weeks-desk-mat-ryan?variant=31851398463573               177.250000   \nhumidifier-apeach?variant=23145606578261                       175.466667   \nbasic-stainless-tumbler-ryan-black-1?variant=31...             173.333333   \nlemon-terrace-hair-tie-ryan?variant=32295656161365             168.166667   \nstainless-steel-insulated-mug-with-lid-ryan?var...             165.285714   \nforest-theme-plush-ryan?variant=31033886179413                 161.333333   \nbasic-airpods-case-little-ryan?variant=32302795...             154.500000   \npyjamas                                                        149.000000   \nyumyum-friends-tote-bag-little-apeach?variant=3...             148.461538   \n\n                                                    Bounce Rate  \\\nDepth3                                                            \nbaby-dreaming-theme-iphone-case-x-xs-11-11pro-1...     0.000000   \nplush-doll-lovely-apeach-1?variant=23259320189013      0.500000   \nyumyum-friends-mini-tote-bag-little-jay-g?varia...     0.333333   \nhappy-weeks-zipper-file-folder-ryan?variant=318...     0.000000   \nall-plush-toys                                         1.000000   \nsale-store                                             0.000000   \nall-products                                           1.000000   \nbaby-dreaming-theme-compact-glitter-mirror-litt...     0.000000   \nsoft-face-cushion-tube?variant=21943860297813          0.000000   \nsale-store?constraint=custom-filter+page=4             0.500000   \ncontact_information?discount=                          0.000000   \nbaby-dreaming-theme-bag-little-apeach?variant=3...     0.666667   \nhugging-body-pillow-jay-g?variant=30735413149781       0.333333   \nhoodie-body-pillow-muzi-con                            0.000000   \nbaby-dreaming-theme-hair-brush-apeach?variant=3...     0.500000   \nbaby-dreaming-theme-pen-holder-memo?variant=321...     0.000000   \nplush-pencil-case-apeach?variant=30315703533653        0.250000   \nhoodie-body-pillow-muzi-con?_pos=15&_sid=3dab0f...     0.000000   \nairpods-pro-case-cover-with-keyring-little-apea...     0.428571   \ncheese-friends-mug-ryan?variant=31718302613589         0.500000   \nhappy-weeks-document-index-file-muzi?variant=31...     0.000000   \nhappy-weeks-multi-pen-4-colours-sharpening-penc...     0.000000   \nhappy-weeks-ruled-note-friday-apeach?variant=31...     0.500000   \nmini-face-plush-keyring-apeach?variant=32126159...     0.444444   \nbaby-dreaming-theme-kids-pyjama-little-apeach?v...     0.000000   \nall-products?constraint=custom-filter+page=2           0.000000   \nforest-theme-ivory-slipper-ryan?variant=3103376...     0.500000   \nhappy-weeks-document-index-file-ryan?variant=31...     0.200000   \nhappy-weeks-a5-ringbound-notepad-apeach?variant...     0.333333   \nyumyum-friends-keyring-little-ryan?variant=3230...     0.400000   \nmini-face-plush-keyring-little-con?variant=3212...     0.000000   \nmini-pillow-little-apeach?variant=22802854576213       0.600000   \nbadges                                                 0.000000   \nbaby-dreaming-theme-glitter-airpods-case-ryan?v...     0.666667   \nbuds-buds-pro-case-ryan?variant=32002822013013         0.550000   \nhappy-weeks-a5-ringbound-notepad-ryan?variant=3...     0.500000   \npu-airpods-case-little-ryan?variant=31602224037973     0.333333   \nhoodie-body-pillow-ryan?variant=31830366290005         0.476190   \nlemon-terrace-pyjama-set-ryan?variant=323007487...     0.461538   \nhumidifier-little-apeach?variant=31705923223637        0.000000   \nyumyum-friends-tote-bag-little-jay-g?variant=32...     0.400000   \nhappy-weeks-desk-mat-ryan?variant=31851398463573       0.500000   \nhumidifier-apeach?variant=23145606578261               0.533333   \nbasic-stainless-tumbler-ryan-black-1?variant=31...     0.333333   \nlemon-terrace-hair-tie-ryan?variant=32295656161365     0.500000   \nstainless-steel-insulated-mug-with-lid-ryan?var...     0.571429   \nforest-theme-plush-ryan?variant=31033886179413         0.333333   \nbasic-airpods-case-little-ryan?variant=32302795...     0.333333   \npyjamas                                                0.000000   \nyumyum-friends-tote-bag-little-apeach?variant=3...     0.461538   \n\n                                                    Pages/Session  Sessions  \\\nDepth3                                                                        \nbaby-dreaming-theme-iphone-case-x-xs-11-11pro-1...      30.000000         1   \nplush-doll-lovely-apeach-1?variant=23259320189013        5.000000         4   \nyumyum-friends-mini-tote-bag-little-jay-g?varia...       4.555556         9   \nhappy-weeks-zipper-file-folder-ryan?variant=318...     102.000000         1   \nall-plush-toys                                          17.000000         2   \nsale-store                                              28.000000         1   \nall-products                                             7.000000         5   \nbaby-dreaming-theme-compact-glitter-mirror-litt...      16.000000         1   \nsoft-face-cushion-tube?variant=21943860297813            9.000000         1   \nsale-store?constraint=custom-filter+page=4               2.000000         2   \ncontact_information?discount=                           14.000000         1   \nbaby-dreaming-theme-bag-little-apeach?variant=3...       6.000000         3   \nhugging-body-pillow-jay-g?variant=30735413149781         2.333333         3   \nhoodie-body-pillow-muzi-con                             12.000000         1   \nbaby-dreaming-theme-hair-brush-apeach?variant=3...       8.000000         2   \nbaby-dreaming-theme-pen-holder-memo?variant=321...       5.666667         3   \nplush-pencil-case-apeach?variant=30315703533653          4.000000         4   \nhoodie-body-pillow-muzi-con?_pos=15&_sid=3dab0f...       2.000000         2   \nairpods-pro-case-cover-with-keyring-little-apea...       6.285714         7   \ncheese-friends-mug-ryan?variant=31718302613589           1.500000         2   \nhappy-weeks-document-index-file-muzi?variant=31...      10.000000         1   \nhappy-weeks-multi-pen-4-colours-sharpening-penc...      10.000000         1   \nhappy-weeks-ruled-note-friday-apeach?variant=31...       8.000000         2   \nmini-face-plush-keyring-apeach?variant=32126159...       5.555556         9   \nbaby-dreaming-theme-kids-pyjama-little-apeach?v...       7.000000         1   \nall-products?constraint=custom-filter+page=2            10.000000         1   \nforest-theme-ivory-slipper-ryan?variant=3103376...       4.500000         8   \nhappy-weeks-document-index-file-ryan?variant=31...       4.000000         5   \nhappy-weeks-a5-ringbound-notepad-apeach?variant...       5.777778         9   \nyumyum-friends-keyring-little-ryan?variant=3230...       7.000000         5   \nmini-face-plush-keyring-little-con?variant=3212...       8.000000         1   \nmini-pillow-little-apeach?variant=22802854576213         4.800000         5   \nbadges                                                   4.000000         1   \nbaby-dreaming-theme-glitter-airpods-case-ryan?v...       5.666667         3   \nbuds-buds-pro-case-ryan?variant=32002822013013           4.025000        40   \nhappy-weeks-a5-ringbound-notepad-ryan?variant=3...       2.000000         6   \npu-airpods-case-little-ryan?variant=31602224037973       3.666667         3   \nhoodie-body-pillow-ryan?variant=31830366290005           8.047619        21   \nlemon-terrace-pyjama-set-ryan?variant=323007487...       2.615385        13   \nhumidifier-little-apeach?variant=31705923223637          5.500000         2   \nyumyum-friends-tote-bag-little-jay-g?variant=32...       3.800000         5   \nhappy-weeks-desk-mat-ryan?variant=31851398463573         5.000000         4   \nhumidifier-apeach?variant=23145606578261                 3.200000        30   \nbasic-stainless-tumbler-ryan-black-1?variant=31...       4.000000         3   \nlemon-terrace-hair-tie-ryan?variant=32295656161365       3.333333         6   \nstainless-steel-insulated-mug-with-lid-ryan?var...       2.000000         7   \nforest-theme-plush-ryan?variant=31033886179413           4.888889         9   \nbasic-airpods-case-little-ryan?variant=32302795...       5.833333         6   \npyjamas                                                  8.000000         1   \nyumyum-friends-tote-bag-little-apeach?variant=3...       3.230769        13   \n\n                                                    Transactions  \nDepth3                                                            \nbaby-dreaming-theme-iphone-case-x-xs-11-11pro-1...             1  \nplush-doll-lovely-apeach-1?variant=23259320189013              1  \nyumyum-friends-mini-tote-bag-little-jay-g?varia...             1  \nhappy-weeks-zipper-file-folder-ryan?variant=318...             0  \nall-plush-toys                                                 0  \nsale-store                                                     0  \nall-products                                                   0  \nbaby-dreaming-theme-compact-glitter-mirror-litt...             0  \nsoft-face-cushion-tube?variant=21943860297813                  0  \nsale-store?constraint=custom-filter+page=4                     0  \ncontact_information?discount=                                  0  \nbaby-dreaming-theme-bag-little-apeach?variant=3...             0  \nhugging-body-pillow-jay-g?variant=30735413149781               0  \nhoodie-body-pillow-muzi-con                                    0  \nbaby-dreaming-theme-hair-brush-apeach?variant=3...             0  \nbaby-dreaming-theme-pen-holder-memo?variant=321...             0  \nplush-pencil-case-apeach?variant=30315703533653                0  \nhoodie-body-pillow-muzi-con?_pos=15&_sid=3dab0f...             0  \nairpods-pro-case-cover-with-keyring-little-apea...             0  \ncheese-friends-mug-ryan?variant=31718302613589                 0  \nhappy-weeks-document-index-file-muzi?variant=31...             0  \nhappy-weeks-multi-pen-4-colours-sharpening-penc...             0  \nhappy-weeks-ruled-note-friday-apeach?variant=31...             0  \nmini-face-plush-keyring-apeach?variant=32126159...             0  \nbaby-dreaming-theme-kids-pyjama-little-apeach?v...             0  \nall-products?constraint=custom-filter+page=2                   0  \nforest-theme-ivory-slipper-ryan?variant=3103376...             0  \nhappy-weeks-document-index-file-ryan?variant=31...             0  \nhappy-weeks-a5-ringbound-notepad-apeach?variant...             0  \nyumyum-friends-keyring-little-ryan?variant=3230...             0  \nmini-face-plush-keyring-little-con?variant=3212...             0  \nmini-pillow-little-apeach?variant=22802854576213               0  \nbadges                                                         0  \nbaby-dreaming-theme-glitter-airpods-case-ryan?v...             0  \nbuds-buds-pro-case-ryan?variant=32002822013013                 0  \nhappy-weeks-a5-ringbound-notepad-ryan?variant=3...             0  \npu-airpods-case-little-ryan?variant=31602224037973             0  \nhoodie-body-pillow-ryan?variant=31830366290005                 0  \nlemon-terrace-pyjama-set-ryan?variant=323007487...             0  \nhumidifier-little-apeach?variant=31705923223637                0  \nyumyum-friends-tote-bag-little-jay-g?variant=32...             0  \nhappy-weeks-desk-mat-ryan?variant=31851398463573               0  \nhumidifier-apeach?variant=23145606578261                       0  \nbasic-stainless-tumbler-ryan-black-1?variant=31...             0  \nlemon-terrace-hair-tie-ryan?variant=32295656161365             0  \nstainless-steel-insulated-mug-with-lid-ryan?var...             0  \nforest-theme-plush-ryan?variant=31033886179413                 0  \nbasic-airpods-case-little-ryan?variant=32302795...             0  \npyjamas                                                        0  \nyumyum-friends-tote-bag-little-apeach?variant=3...             0  ",
      "text/html": "<div>\n<style scoped>\n    .dataframe tbody tr th:only-of-type {\n        vertical-align: middle;\n    }\n\n    .dataframe tbody tr th {\n        vertical-align: top;\n    }\n\n    .dataframe thead th {\n        text-align: right;\n    }\n</style>\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>Avg. Session Duration</th>\n      <th>Bounce Rate</th>\n      <th>Pages/Session</th>\n      <th>Sessions</th>\n      <th>Transactions</th>\n    </tr>\n    <tr>\n      <th>Depth3</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>baby-dreaming-theme-iphone-case-x-xs-11-11pro-11pro-max-little-ryan</th>\n      <td>2664.000000</td>\n      <td>0.000000</td>\n      <td>30.000000</td>\n      <td>1</td>\n      <td>1</td>\n    </tr>\n    <tr>\n      <th>plush-doll-lovely-apeach-1?variant=23259320189013</th>\n      <td>146.500000</td>\n      <td>0.500000</td>\n      <td>5.000000</td>\n      <td>4</td>\n      <td>1</td>\n    </tr>\n    <tr>\n      <th>yumyum-friends-mini-tote-bag-little-jay-g?variant=32302228832341</th>\n      <td>143.111111</td>\n      <td>0.333333</td>\n      <td>4.555556</td>\n      <td>9</td>\n      <td>1</td>\n    </tr>\n    <tr>\n      <th>happy-weeks-zipper-file-folder-ryan?variant=31851496046677</th>\n      <td>6470.000000</td>\n      <td>0.000000</td>\n      <td>102.000000</td>\n      <td>1</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>all-plush-toys</th>\n      <td>2092.000000</td>\n      <td>1.000000</td>\n      <td>17.000000</td>\n      <td>2</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>sale-store</th>\n      <td>1437.000000</td>\n      <td>0.000000</td>\n      <td>28.000000</td>\n      <td>1</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>all-products</th>\n      <td>931.000000</td>\n      <td>1.000000</td>\n      <td>7.000000</td>\n      <td>5</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>baby-dreaming-theme-compact-glitter-mirror-little-ryan?variant=31953056399445</th>\n      <td>899.000000</td>\n      <td>0.000000</td>\n      <td>16.000000</td>\n      <td>1</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>soft-face-cushion-tube?variant=21943860297813</th>\n      <td>688.000000</td>\n      <td>0.000000</td>\n      <td>9.000000</td>\n      <td>1</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>sale-store?constraint=custom-filter+page=4</th>\n      <td>569.000000</td>\n      <td>0.500000</td>\n      <td>2.000000</td>\n      <td>2</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>contact_information?discount=</th>\n      <td>553.000000</td>\n      <td>0.000000</td>\n      <td>14.000000</td>\n      <td>1</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>baby-dreaming-theme-bag-little-apeach?variant=32113525882965</th>\n      <td>519.666667</td>\n      <td>0.666667</td>\n      <td>6.000000</td>\n      <td>3</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>hugging-body-pillow-jay-g?variant=30735413149781</th>\n      <td>500.666667</td>\n      <td>0.333333</td>\n      <td>2.333333</td>\n      <td>3</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>hoodie-body-pillow-muzi-con</th>\n      <td>497.000000</td>\n      <td>0.000000</td>\n      <td>12.000000</td>\n      <td>1</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>baby-dreaming-theme-hair-brush-apeach?variant=31952918249557</th>\n      <td>496.000000</td>\n      <td>0.500000</td>\n      <td>8.000000</td>\n      <td>2</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>baby-dreaming-theme-pen-holder-memo?variant=32117500772437</th>\n      <td>479.666667</td>\n      <td>0.000000</td>\n      <td>5.666667</td>\n      <td>3</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>plush-pencil-case-apeach?variant=30315703533653</th>\n      <td>455.000000</td>\n      <td>0.250000</td>\n      <td>4.000000</td>\n      <td>4</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>hoodie-body-pillow-muzi-con?_pos=15&amp;_sid=3dab0f74b&amp;_ss=r</th>\n      <td>418.000000</td>\n      <td>0.000000</td>\n      <td>2.000000</td>\n      <td>2</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>airpods-pro-case-cover-with-keyring-little-apeach?variant=31718312083541</th>\n      <td>414.285714</td>\n      <td>0.428571</td>\n      <td>6.285714</td>\n      <td>7</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>cheese-friends-mug-ryan?variant=31718302613589</th>\n      <td>389.500000</td>\n      <td>0.500000</td>\n      <td>1.500000</td>\n      <td>2</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>happy-weeks-document-index-file-muzi?variant=31851335024725</th>\n      <td>368.000000</td>\n      <td>0.000000</td>\n      <td>10.000000</td>\n      <td>1</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>happy-weeks-multi-pen-4-colours-sharpening-pencil-muzi?variant=31849177153621</th>\n      <td>357.000000</td>\n      <td>0.000000</td>\n      <td>10.000000</td>\n      <td>1</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>happy-weeks-ruled-note-friday-apeach?variant=31849077506133</th>\n      <td>323.500000</td>\n      <td>0.500000</td>\n      <td>8.000000</td>\n      <td>2</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>mini-face-plush-keyring-apeach?variant=32126159126613</th>\n      <td>312.333333</td>\n      <td>0.444444</td>\n      <td>5.555556</td>\n      <td>9</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>baby-dreaming-theme-kids-pyjama-little-apeach?variant=31998769692757</th>\n      <td>293.000000</td>\n      <td>0.000000</td>\n      <td>7.000000</td>\n      <td>1</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>all-products?constraint=custom-filter+page=2</th>\n      <td>285.000000</td>\n      <td>0.000000</td>\n      <td>10.000000</td>\n      <td>1</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>forest-theme-ivory-slipper-ryan?variant=31033760579669</th>\n      <td>268.500000</td>\n      <td>0.500000</td>\n      <td>4.500000</td>\n      <td>8</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>happy-weeks-document-index-file-ryan?variant=31851321458773</th>\n      <td>267.600000</td>\n      <td>0.200000</td>\n      <td>4.000000</td>\n      <td>5</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>happy-weeks-a5-ringbound-notepad-apeach?variant=32002939224149</th>\n      <td>264.777778</td>\n      <td>0.333333</td>\n      <td>5.777778</td>\n      <td>9</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>yumyum-friends-keyring-little-ryan?variant=32302571061333</th>\n      <td>264.200000</td>\n      <td>0.400000</td>\n      <td>7.000000</td>\n      <td>5</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>mini-face-plush-keyring-little-con?variant=32126552899669</th>\n      <td>261.000000</td>\n      <td>0.000000</td>\n      <td>8.000000</td>\n      <td>1</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>mini-pillow-little-apeach?variant=22802854576213</th>\n      <td>249.200000</td>\n      <td>0.600000</td>\n      <td>4.800000</td>\n      <td>5</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>badges</th>\n      <td>248.000000</td>\n      <td>0.000000</td>\n      <td>4.000000</td>\n      <td>1</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>baby-dreaming-theme-glitter-airpods-case-ryan?variant=31998563221589</th>\n      <td>243.333333</td>\n      <td>0.666667</td>\n      <td>5.666667</td>\n      <td>3</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>buds-buds-pro-case-ryan?variant=32002822013013</th>\n      <td>241.650000</td>\n      <td>0.550000</td>\n      <td>4.025000</td>\n      <td>40</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>happy-weeks-a5-ringbound-notepad-ryan?variant=32002930671701</th>\n      <td>240.333333</td>\n      <td>0.500000</td>\n      <td>2.000000</td>\n      <td>6</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>pu-airpods-case-little-ryan?variant=31602224037973</th>\n      <td>237.000000</td>\n      <td>0.333333</td>\n      <td>3.666667</td>\n      <td>3</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>hoodie-body-pillow-ryan?variant=31830366290005</th>\n      <td>233.428571</td>\n      <td>0.476190</td>\n      <td>8.047619</td>\n      <td>21</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>lemon-terrace-pyjama-set-ryan?variant=32300748734549</th>\n      <td>209.538462</td>\n      <td>0.461538</td>\n      <td>2.615385</td>\n      <td>13</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>humidifier-little-apeach?variant=31705923223637</th>\n      <td>199.000000</td>\n      <td>0.000000</td>\n      <td>5.500000</td>\n      <td>2</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>yumyum-friends-tote-bag-little-jay-g?variant=32302211924053</th>\n      <td>178.000000</td>\n      <td>0.400000</td>\n      <td>3.800000</td>\n      <td>5</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>happy-weeks-desk-mat-ryan?variant=31851398463573</th>\n      <td>177.250000</td>\n      <td>0.500000</td>\n      <td>5.000000</td>\n      <td>4</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>humidifier-apeach?variant=23145606578261</th>\n      <td>175.466667</td>\n      <td>0.533333</td>\n      <td>3.200000</td>\n      <td>30</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>basic-stainless-tumbler-ryan-black-1?variant=31602180292693</th>\n      <td>173.333333</td>\n      <td>0.333333</td>\n      <td>4.000000</td>\n      <td>3</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>lemon-terrace-hair-tie-ryan?variant=32295656161365</th>\n      <td>168.166667</td>\n      <td>0.500000</td>\n      <td>3.333333</td>\n      <td>6</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>stainless-steel-insulated-mug-with-lid-ryan?variant=22374568886357</th>\n      <td>165.285714</td>\n      <td>0.571429</td>\n      <td>2.000000</td>\n      <td>7</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>forest-theme-plush-ryan?variant=31033886179413</th>\n      <td>161.333333</td>\n      <td>0.333333</td>\n      <td>4.888889</td>\n      <td>9</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>basic-airpods-case-little-ryan?variant=32302795784277</th>\n      <td>154.500000</td>\n      <td>0.333333</td>\n      <td>5.833333</td>\n      <td>6</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>pyjamas</th>\n      <td>149.000000</td>\n      <td>0.000000</td>\n      <td>8.000000</td>\n      <td>1</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>yumyum-friends-tote-bag-little-apeach?variant=32302186365013</th>\n      <td>148.461538</td>\n      <td>0.461538</td>\n      <td>3.230769</td>\n      <td>13</td>\n      <td>0</td>\n    </tr>\n  </tbody>\n</table>\n</div>"
     },
     "metadata": {},
     "execution_count": 76
    }
   ],
   "source": [
    "session_per_pages.head(50)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}