notebooks/00_b_setup_stats.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "c6bfcf58-b95d-45b4-a395-6e851c347f7f",
   "metadata": {
    "tags": []
   },
   "source": [
    "# About"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "5d083f9e-dafd-4ca6-89a9-c76e9513c587",
   "metadata": {},
   "source": [
    "This notebook explores the conversion dataset.\n",
    "\n",
    "The `conversions.tsv` dataset has one row per search conversion.  \n",
    "\n",
    "The dataset tells you which photo has been downloaded for a search, the country of origin, and an anonymous identifier to indiciate the unique users. \n",
    "\n",
    "[Source](https://github.com/unsplash/datasets/blob/master/DOCS.md)\n",
    "\n",
    "\n",
    "We will use this dataset to understand the type of queries, that users in the platform are searching."
   ]
  },
  {
   "cell_type": "markdown",
   "id": "6020f52f-145b-45ce-8b21-c05f060ad301",
   "metadata": {
    "tags": []
   },
   "source": [
    "# Exploring the data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "34f2eede-56da-4319-8df5-5cf45336484f",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2023-04-25T16:30:53.133017Z",
     "iopub.status.busy": "2023-04-25T16:30:53.132603Z",
     "iopub.status.idle": "2023-04-25T16:30:53.215007Z",
     "shell.execute_reply": "2023-04-25T16:30:53.213149Z",
     "shell.execute_reply.started": "2023-04-25T16:30:53.132981Z"
    }
   },
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "91428786-d229-4748-a91e-2829d834a674",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2023-04-25T16:30:53.216683Z",
     "iopub.status.busy": "2023-04-25T16:30:53.216378Z",
     "iopub.status.idle": "2023-04-25T16:30:53.308980Z",
     "shell.execute_reply": "2023-04-25T16:30:53.308050Z",
     "shell.execute_reply.started": "2023-04-25T16:30:53.216661Z"
    }
   },
   "outputs": [],
   "source": [
    "pd.set_option('display.max_rows', 100)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "9d2b5364-acf5-47c4-a765-1a691435e139",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2023-04-25T16:30:53.310150Z",
     "iopub.status.busy": "2023-04-25T16:30:53.309865Z",
     "iopub.status.idle": "2023-04-25T16:30:53.319703Z",
     "shell.execute_reply": "2023-04-25T16:30:53.318898Z",
     "shell.execute_reply.started": "2023-04-25T16:30:53.310123Z"
    }
   },
   "outputs": [],
   "source": [
    "path = \"../data/raw/conversions.tsv000\"\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "dc7046a8-6a05-41ce-811e-c5df1223a226",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2023-04-25T16:30:53.321113Z",
     "iopub.status.busy": "2023-04-25T16:30:53.320603Z",
     "iopub.status.idle": "2023-04-25T16:31:18.524555Z",
     "shell.execute_reply": "2023-04-25T16:31:18.523773Z",
     "shell.execute_reply.started": "2023-04-25T16:30:53.321087Z"
    }
   },
   "outputs": [],
   "source": [
    "df = pd.read_csv(path,sep=\"\\t\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "a156cb80-e608-40d2-81ba-cdd0e874b819",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2023-04-25T16:31:18.527688Z",
     "iopub.status.busy": "2023-04-25T16:31:18.527041Z",
     "iopub.status.idle": "2023-04-25T16:31:18.533732Z",
     "shell.execute_reply": "2023-04-25T16:31:18.532900Z",
     "shell.execute_reply.started": "2023-04-25T16:31:18.527652Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "12166088"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(df)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "e9aa396d-c335-47cd-b01d-ffb3f7b743ab",
   "metadata": {},
   "source": [
    "sample view of the data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "745cd38a-a41e-44c4-a836-8601ebfd043f",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2023-04-25T16:31:18.535011Z",
     "iopub.status.busy": "2023-04-25T16:31:18.534779Z",
     "iopub.status.idle": "2023-04-25T16:31:18.627594Z",
     "shell.execute_reply": "2023-04-25T16:31:18.626599Z",
     "shell.execute_reply.started": "2023-04-25T16:31:18.534991Z"
    }
   },
   "outputs": [
    {
     "data": {
      "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>converted_at</th>\n",
       "      <th>conversion_type</th>\n",
       "      <th>keyword</th>\n",
       "      <th>photo_id</th>\n",
       "      <th>anonymous_user_id</th>\n",
       "      <th>conversion_country</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2020-07-29 00:08:04.221</td>\n",
       "      <td>download</td>\n",
       "      <td>clouds</td>\n",
       "      <td>ABmygVJcYgY</td>\n",
       "      <td>dd01ebdd-7691-4518-ab19-b2105782ae8b</td>\n",
       "      <td>VE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2020-07-29 00:25:23.426</td>\n",
       "      <td>download</td>\n",
       "      <td>shark</td>\n",
       "      <td>fB2jl6Rb3l4</td>\n",
       "      <td>c48ba6e0-c6a7-4a92-b569-fe57808a8a2c</td>\n",
       "      <td>QA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2020-07-29 00:26:13.122</td>\n",
       "      <td>download</td>\n",
       "      <td>dogs</td>\n",
       "      <td>k1hbfag2na0</td>\n",
       "      <td>62c4f043-579c-438f-8815-eb8ba3c54d34</td>\n",
       "      <td>KR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2020-07-29 00:37:03.308</td>\n",
       "      <td>download</td>\n",
       "      <td>astronaut</td>\n",
       "      <td>-SyUjRlHauQ</td>\n",
       "      <td>7ad6dc18-a02e-4ba2-b93c-fd7ea2e551d8</td>\n",
       "      <td>JP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2020-07-29 00:54:28.942</td>\n",
       "      <td>download</td>\n",
       "      <td>red roses</td>\n",
       "      <td>A0iTJUhK4es</td>\n",
       "      <td>f03a5708-32e4-4fae-8210-3c5d2632cbfb</td>\n",
       "      <td>NZ</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              converted_at conversion_type    keyword     photo_id  \\\n",
       "0  2020-07-29 00:08:04.221        download     clouds  ABmygVJcYgY   \n",
       "1  2020-07-29 00:25:23.426        download      shark  fB2jl6Rb3l4   \n",
       "2  2020-07-29 00:26:13.122        download       dogs  k1hbfag2na0   \n",
       "3  2020-07-29 00:37:03.308        download  astronaut  -SyUjRlHauQ   \n",
       "4  2020-07-29 00:54:28.942        download  red roses  A0iTJUhK4es   \n",
       "\n",
       "                      anonymous_user_id conversion_country  \n",
       "0  dd01ebdd-7691-4518-ab19-b2105782ae8b                 VE  \n",
       "1  c48ba6e0-c6a7-4a92-b569-fe57808a8a2c                 QA  \n",
       "2  62c4f043-579c-438f-8815-eb8ba3c54d34                 KR  \n",
       "3  7ad6dc18-a02e-4ba2-b93c-fd7ea2e551d8                 JP  \n",
       "4  f03a5708-32e4-4fae-8210-3c5d2632cbfb                 NZ  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "3cd9509a-2cc9-452a-ad92-4c4ea5fd7df0",
   "metadata": {},
   "source": [
    "Get top queries"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "6738ac94-950f-45ef-89a9-f558e83ea151",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2023-04-25T16:31:18.629372Z",
     "iopub.status.busy": "2023-04-25T16:31:18.628998Z",
     "iopub.status.idle": "2023-04-25T16:31:20.872575Z",
     "shell.execute_reply": "2023-04-25T16:31:20.871772Z",
     "shell.execute_reply.started": "2023-04-25T16:31:18.629345Z"
    }
   },
   "outputs": [],
   "source": [
    "df_res = df.groupby([\"keyword\"], as_index=False)\\\n",
    "            .size()\\\n",
    "            .sort_values(\"size\", ascending=False)\\\n",
    "            .rename(columns={'size':'num_searches'})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "6500ce65-b8f2-4abf-b796-e80a554c92b4",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2023-04-25T16:31:20.874034Z",
     "iopub.status.busy": "2023-04-25T16:31:20.873707Z",
     "iopub.status.idle": "2023-04-25T16:31:20.879505Z",
     "shell.execute_reply": "2023-04-25T16:31:20.878517Z",
     "shell.execute_reply.started": "2023-04-25T16:31:20.873970Z"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Number of unique queries: 569996 \n"
     ]
    }
   ],
   "source": [
    "print (f\"Number of unique queries: {len(df_res)} \")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "98918b39-a639-42ea-a25c-e17bc0c51c8d",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2023-04-25T16:31:20.881180Z",
     "iopub.status.busy": "2023-04-25T16:31:20.880529Z",
     "iopub.status.idle": "2023-04-25T16:31:20.894394Z",
     "shell.execute_reply": "2023-04-25T16:31:20.893375Z",
     "shell.execute_reply.started": "2023-04-25T16:31:20.881155Z"
    }
   },
   "outputs": [
    {
     "data": {
      "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>keyword</th>\n",
       "      <th>num_searches</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>334943</th>\n",
       "      <td>nature</td>\n",
       "      <td>381173</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>445718</th>\n",
       "      <td>sky</td>\n",
       "      <td>239848</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>193034</th>\n",
       "      <td>flowers</td>\n",
       "      <td>202391</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>333735</th>\n",
       "      <td>natural</td>\n",
       "      <td>196189</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189492</th>\n",
       "      <td>flower</td>\n",
       "      <td>175126</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>431887</th>\n",
       "      <td>sea</td>\n",
       "      <td>165744</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>325200</th>\n",
       "      <td>mountain</td>\n",
       "      <td>161816</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>198609</th>\n",
       "      <td>forest</td>\n",
       "      <td>153677</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>350461</th>\n",
       "      <td>ocean</td>\n",
       "      <td>145435</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45100</th>\n",
       "      <td>beach</td>\n",
       "      <td>136862</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>460237</th>\n",
       "      <td>space</td>\n",
       "      <td>120184</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>146484</th>\n",
       "      <td>dog</td>\n",
       "      <td>112637</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>328262</th>\n",
       "      <td>mountains</td>\n",
       "      <td>111005</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>533443</th>\n",
       "      <td>water</td>\n",
       "      <td>109987</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>320914</th>\n",
       "      <td>moon</td>\n",
       "      <td>106111</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>550361</th>\n",
       "      <td>winter</td>\n",
       "      <td>89541</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90851</th>\n",
       "      <td>cat</td>\n",
       "      <td>87984</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>528686</th>\n",
       "      <td>wallpaper</td>\n",
       "      <td>87079</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19880</th>\n",
       "      <td>animal</td>\n",
       "      <td>79378</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>507852</th>\n",
       "      <td>tree</td>\n",
       "      <td>78697</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>345303</th>\n",
       "      <td>night sky</td>\n",
       "      <td>77892</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>482869</th>\n",
       "      <td>sunset</td>\n",
       "      <td>75404</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>343674</th>\n",
       "      <td>night</td>\n",
       "      <td>74551</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>278629</th>\n",
       "      <td>landscape</td>\n",
       "      <td>72824</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>481555</th>\n",
       "      <td>sunrise</td>\n",
       "      <td>72290</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>161638</th>\n",
       "      <td>earth</td>\n",
       "      <td>70303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21578</th>\n",
       "      <td>animals</td>\n",
       "      <td>68001</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>518127</th>\n",
       "      <td>universe</td>\n",
       "      <td>66711</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>475829</th>\n",
       "      <td>summer</td>\n",
       "      <td>66019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>387151</th>\n",
       "      <td>plant</td>\n",
       "      <td>64406</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          keyword  num_searches\n",
       "334943     nature        381173\n",
       "445718        sky        239848\n",
       "193034    flowers        202391\n",
       "333735    natural        196189\n",
       "189492     flower        175126\n",
       "431887        sea        165744\n",
       "325200   mountain        161816\n",
       "198609     forest        153677\n",
       "350461      ocean        145435\n",
       "45100       beach        136862\n",
       "460237      space        120184\n",
       "146484        dog        112637\n",
       "328262  mountains        111005\n",
       "533443      water        109987\n",
       "320914       moon        106111\n",
       "550361     winter         89541\n",
       "90851         cat         87984\n",
       "528686  wallpaper         87079\n",
       "19880      animal         79378\n",
       "507852       tree         78697\n",
       "345303  night sky         77892\n",
       "482869     sunset         75404\n",
       "343674      night         74551\n",
       "278629  landscape         72824\n",
       "481555    sunrise         72290\n",
       "161638      earth         70303\n",
       "21578     animals         68001\n",
       "518127   universe         66711\n",
       "475829     summer         66019\n",
       "387151      plant         64406"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_res.head(30)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "c8349ec7-0112-4b7a-b1c5-a52e4b33a221",
   "metadata": {
    "tags": []
   },
   "source": [
    "## What can we say about the typical queries ?"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "0548f316-6452-4eab-9740-838176ea683b",
   "metadata": {},
   "source": [
    "- Most of the queries seem to be under <3 keywords.\n",
    "- Users in the platform are interested in nature\n",
    "- no normalizations is done for the queries; animal vs animals ; vs mountain vs mountains"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "bf35d26c-9a62-4e67-b810-1d552dc9e822",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "id": "0ab13652-0433-40c0-9044-e21fc7ac22c6",
   "metadata": {},
   "source": [
    "Queries like above with \"broad\" intent are not that useful for comparing results"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "ba1ef62a-fdab-4a33-8f89-e20e0c6d2fbc",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "6e8e5731-c4f5-45c8-9a15-76c8758e1845",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "id": "fc047f35-f156-4a2c-a0e3-d629ddaca3ff",
   "metadata": {},
   "source": [
    "## Exploring Longer Queries"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "a5f9bcd7-6c07-4b87-8910-81df7affaea4",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2023-04-25T16:31:20.895617Z",
     "iopub.status.busy": "2023-04-25T16:31:20.895394Z",
     "iopub.status.idle": "2023-04-25T16:31:21.322740Z",
     "shell.execute_reply": "2023-04-25T16:31:21.321881Z",
     "shell.execute_reply.started": "2023-04-25T16:31:20.895597Z"
    }
   },
   "outputs": [],
   "source": [
    "df_res[\"num_keywords\"] = df_res[\"keyword\"].apply(lambda x: len(x.split(\" \")))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "049b1fe8-cc95-4e1a-956f-81564bd75c16",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2023-04-25T16:31:21.324017Z",
     "iopub.status.busy": "2023-04-25T16:31:21.323750Z",
     "iopub.status.idle": "2023-04-25T16:31:21.369322Z",
     "shell.execute_reply": "2023-04-25T16:31:21.368403Z",
     "shell.execute_reply.started": "2023-04-25T16:31:21.323993Z"
    }
   },
   "outputs": [],
   "source": [
    "df_long_queries = df_res[(df_res[\"num_keywords\"] > 1) ]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "c06f5c52-1240-432b-aa0a-07b6fb6427ce",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2023-04-25T16:31:21.370917Z",
     "iopub.status.busy": "2023-04-25T16:31:21.370534Z",
     "iopub.status.idle": "2023-04-25T16:31:21.385868Z",
     "shell.execute_reply": "2023-04-25T16:31:21.385104Z",
     "shell.execute_reply.started": "2023-04-25T16:31:21.370890Z"
    }
   },
   "outputs": [
    {
     "data": {
      "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>keyword</th>\n",
       "      <th>num_searches</th>\n",
       "      <th>num_keywords</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>327457</th>\n",
       "      <td>mountain star landscape night sky</td>\n",
       "      <td>779</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>287590</th>\n",
       "      <td>light at the end of the tunnel</td>\n",
       "      <td>308</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499894</th>\n",
       "      <td>there is no planet b</td>\n",
       "      <td>242</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>276561</th>\n",
       "      <td>lago di braies, braies, italy</td>\n",
       "      <td>118</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>534678</th>\n",
       "      <td>water droplets on a leaf</td>\n",
       "      <td>106</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224699</th>\n",
       "      <td>great sand dunes national park</td>\n",
       "      <td>94</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>258115</th>\n",
       "      <td>image of a man in a desert</td>\n",
       "      <td>82</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>274846</th>\n",
       "      <td>konkan beach resort, ratnagiri, india</td>\n",
       "      <td>73</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>335652</th>\n",
       "      <td>nature backgrounds water ripple reflection</td>\n",
       "      <td>67</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>459722</th>\n",
       "      <td>south georgia and the south sandwich islands</td>\n",
       "      <td>54</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>426421</th>\n",
       "      <td>samsung note 10 lite wallpaper</td>\n",
       "      <td>52</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37977</th>\n",
       "      <td>background image for google doc</td>\n",
       "      <td>51</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>141140</th>\n",
       "      <td>desert sunset nature landscape sky</td>\n",
       "      <td>49</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61505</th>\n",
       "      <td>black grapes with wood plates</td>\n",
       "      <td>44</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>454677</th>\n",
       "      <td>snow mountain clear blue sky</td>\n",
       "      <td>44</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>364313</th>\n",
       "      <td>palm trees at the beach</td>\n",
       "      <td>43</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>349030</th>\n",
       "      <td>nova scotia duck tolling retriever</td>\n",
       "      <td>43</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499403</th>\n",
       "      <td>the surface of the moon</td>\n",
       "      <td>37</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499623</th>\n",
       "      <td>the waves of the sea</td>\n",
       "      <td>37</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>263540</th>\n",
       "      <td>iphone 11 pro max wallpaper</td>\n",
       "      <td>36</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27378</th>\n",
       "      <td>art of table potted flower</td>\n",
       "      <td>35</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>337991</th>\n",
       "      <td>nature photos  light colours</td>\n",
       "      <td>35</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>504377</th>\n",
       "      <td>torres del paine national park</td>\n",
       "      <td>32</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134706</th>\n",
       "      <td>dark side of the moon</td>\n",
       "      <td>31</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67340</th>\n",
       "      <td>blue sky and white clouds</td>\n",
       "      <td>31</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>375214</th>\n",
       "      <td>person on top of mountain</td>\n",
       "      <td>31</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>277772</th>\n",
       "      <td>lake with lotus and lilies photos</td>\n",
       "      <td>29</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50421</th>\n",
       "      <td>beauitful wallpaper nature  8k</td>\n",
       "      <td>29</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>287582</th>\n",
       "      <td>light at end of tunnel</td>\n",
       "      <td>28</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26499</th>\n",
       "      <td>ariel view of the ocean</td>\n",
       "      <td>28</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177964</th>\n",
       "      <td>farmhouse rustic yellow and pink</td>\n",
       "      <td>28</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>161094</th>\n",
       "      <td>eagle flying in the sky</td>\n",
       "      <td>27</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>569329</th>\n",
       "      <td>沙漠青蛙      沙漠青蛙      desert frog</td>\n",
       "      <td>26</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>415209</th>\n",
       "      <td>ripley's aquarium of canada, toronto, canada</td>\n",
       "      <td>26</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>425941</th>\n",
       "      <td>salar de uyuni uyuni bolivia</td>\n",
       "      <td>25</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>143650</th>\n",
       "      <td>dew drops on a grass</td>\n",
       "      <td>25</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123267</th>\n",
       "      <td>couple romdik love photo in tamil</td>\n",
       "      <td>25</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>304156</th>\n",
       "      <td>man on top of mountain</td>\n",
       "      <td>25</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>193247</th>\n",
       "      <td>flowers and plants and trees</td>\n",
       "      <td>24</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>497287</th>\n",
       "      <td>the butterfly atrium at hershey gardens</td>\n",
       "      <td>24</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>277773</th>\n",
       "      <td>lake with lotus and lily</td>\n",
       "      <td>24</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>479245</th>\n",
       "      <td>sun rise on a mountain</td>\n",
       "      <td>24</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203350</th>\n",
       "      <td>free hd luminious backgrounds for photos</td>\n",
       "      <td>24</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>298593</th>\n",
       "      <td>lower antelope canyon, page, united states</td>\n",
       "      <td>24</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>393216</th>\n",
       "      <td>por do sol no mar</td>\n",
       "      <td>23</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>142678</th>\n",
       "      <td>desktop wallpapers 1920 x 1080</td>\n",
       "      <td>22</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>534769</th>\n",
       "      <td>water drops on the rose</td>\n",
       "      <td>22</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>437160</th>\n",
       "      <td>seven wonders of the world</td>\n",
       "      <td>20</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66424</th>\n",
       "      <td>blue lake and green shore</td>\n",
       "      <td>19</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>295937</th>\n",
       "      <td>looking up to the sky</td>\n",
       "      <td>19</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                             keyword  num_searches  \\\n",
       "327457             mountain star landscape night sky           779   \n",
       "287590                light at the end of the tunnel           308   \n",
       "499894                          there is no planet b           242   \n",
       "276561                 lago di braies, braies, italy           118   \n",
       "534678                      water droplets on a leaf           106   \n",
       "224699                great sand dunes national park            94   \n",
       "258115                    image of a man in a desert            82   \n",
       "274846         konkan beach resort, ratnagiri, india            73   \n",
       "335652    nature backgrounds water ripple reflection            67   \n",
       "459722  south georgia and the south sandwich islands            54   \n",
       "426421                samsung note 10 lite wallpaper            52   \n",
       "37977                background image for google doc            51   \n",
       "141140            desert sunset nature landscape sky            49   \n",
       "61505                  black grapes with wood plates            44   \n",
       "454677                  snow mountain clear blue sky            44   \n",
       "364313                       palm trees at the beach            43   \n",
       "349030            nova scotia duck tolling retriever            43   \n",
       "499403                       the surface of the moon            37   \n",
       "499623                          the waves of the sea            37   \n",
       "263540                   iphone 11 pro max wallpaper            36   \n",
       "27378                     art of table potted flower            35   \n",
       "337991                  nature photos  light colours            35   \n",
       "504377                torres del paine national park            32   \n",
       "134706                         dark side of the moon            31   \n",
       "67340                      blue sky and white clouds            31   \n",
       "375214                     person on top of mountain            31   \n",
       "277772             lake with lotus and lilies photos            29   \n",
       "50421                 beauitful wallpaper nature  8k            29   \n",
       "287582                        light at end of tunnel            28   \n",
       "26499                        ariel view of the ocean            28   \n",
       "177964              farmhouse rustic yellow and pink            28   \n",
       "161094                       eagle flying in the sky            27   \n",
       "569329               沙漠青蛙      沙漠青蛙      desert frog            26   \n",
       "415209  ripley's aquarium of canada, toronto, canada            26   \n",
       "425941                  salar de uyuni uyuni bolivia            25   \n",
       "143650                          dew drops on a grass            25   \n",
       "123267             couple romdik love photo in tamil            25   \n",
       "304156                        man on top of mountain            25   \n",
       "193247                  flowers and plants and trees            24   \n",
       "497287       the butterfly atrium at hershey gardens            24   \n",
       "277773                      lake with lotus and lily            24   \n",
       "479245                        sun rise on a mountain            24   \n",
       "203350      free hd luminious backgrounds for photos            24   \n",
       "298593    lower antelope canyon, page, united states            24   \n",
       "393216                             por do sol no mar            23   \n",
       "142678                desktop wallpapers 1920 x 1080            22   \n",
       "534769                       water drops on the rose            22   \n",
       "437160                    seven wonders of the world            20   \n",
       "66424                      blue lake and green shore            19   \n",
       "295937                         looking up to the sky            19   \n",
       "\n",
       "        num_keywords  \n",
       "327457             5  \n",
       "287590             7  \n",
       "499894             5  \n",
       "276561             5  \n",
       "534678             5  \n",
       "224699             5  \n",
       "258115             7  \n",
       "274846             5  \n",
       "335652             5  \n",
       "459722             7  \n",
       "426421             5  \n",
       "37977              5  \n",
       "141140             5  \n",
       "61505              5  \n",
       "454677             5  \n",
       "364313             5  \n",
       "349030             5  \n",
       "499403             5  \n",
       "499623             5  \n",
       "263540             5  \n",
       "27378              5  \n",
       "337991             5  \n",
       "504377             5  \n",
       "134706             5  \n",
       "67340              5  \n",
       "375214             5  \n",
       "277772             6  \n",
       "50421              5  \n",
       "287582             5  \n",
       "26499              5  \n",
       "177964             5  \n",
       "161094             5  \n",
       "569329            14  \n",
       "415209             6  \n",
       "425941             5  \n",
       "143650             5  \n",
       "123267             6  \n",
       "304156             5  \n",
       "193247             5  \n",
       "497287             6  \n",
       "277773             5  \n",
       "479245             5  \n",
       "203350             6  \n",
       "298593             6  \n",
       "393216             5  \n",
       "142678             5  \n",
       "534769             5  \n",
       "437160             5  \n",
       "66424              5  \n",
       "295937             5  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_long_queries[df_long_queries.num_keywords > 4].head(50)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "7c4d9566-4f47-4e50-8dde-5790c6466c4d",
   "metadata": {},
   "source": [
    "## Interesting Queries"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "49f0b698-ffde-4da4-9975-2ea8ea63c6b8",
   "metadata": {},
   "source": [
    "Detailed Intent\n",
    "- water droplets on a leaf\t\n",
    "- image of a man in a desert\t\n",
    "- person on top of mountain\t\n",
    "\n",
    "\n",
    "\n",
    "Location:\n",
    "- ripley's aquarium of canada, toronto, canada\t\n",
    "- the butterfly atrium at hershey gardens\t\n",
    "\n",
    "Non English Queries\n",
    "- salar de uyuni uyuni bolivia\t\n",
    "- 沙漠青蛙 沙漠青蛙 desert frog\t\n",
    "- por do sol no mar\t\n",
    "- conhece te a ti mesmo\t ( Greek for know thyself)\n",
    "\n",
    "\n",
    "Metaphors / Slogan:\n",
    "- light at the end of the tunnel\t\n",
    "- there is no planet b\t\n",
    "\n",
    "Multiple Candidates\n",
    "- seven wonders of the world\t\n",
    "\n",
    "Long Query / Single Intent\n",
    "- nova scotia duck tolling retriever\t ( dog breed)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "7f9f81d3-ebfa-4489-920c-d81f0f9e98f3",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "66c63f2d-219b-4ee8-ac61-3ca43a3b79bf",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "1d184a7c-87d2-4003-8082-6e1a38bcdf53",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "id": "8b57c441-ae37-47c4-b0b6-bf07ecb16ca4",
   "metadata": {},
   "source": [
    "Non frequently searched queries"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "5e2d990b-b36f-4274-8b55-e8b71db3ef43",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2023-04-25T16:31:21.387111Z",
     "iopub.status.busy": "2023-04-25T16:31:21.386821Z",
     "iopub.status.idle": "2023-04-25T16:31:21.401449Z",
     "shell.execute_reply": "2023-04-25T16:31:21.400704Z",
     "shell.execute_reply.started": "2023-04-25T16:31:21.387073Z"
    }
   },
   "outputs": [
    {
     "data": {
      "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>keyword</th>\n",
       "      <th>num_searches</th>\n",
       "      <th>num_keywords</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>313105</th>\n",
       "      <td>mid night star picture for youtube thumbnail</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119583</th>\n",
       "      <td>cool gamer pics for free</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>313060</th>\n",
       "      <td>mid century gothic style rose painting</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>313079</th>\n",
       "      <td>mid century modern interior design</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>313077</th>\n",
       "      <td>mid century modern home interior</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>313076</th>\n",
       "      <td>mid century modern home decor</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>313160</th>\n",
       "      <td>middle aged women  beauty</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>313148</th>\n",
       "      <td>middle age is an age of many colors.</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>313185</th>\n",
       "      <td>middle east night in the desert</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>313694</th>\n",
       "      <td>milky way at the sea</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>313709</th>\n",
       "      <td>milky way by the nasa</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119302</th>\n",
       "      <td>cool adventurous places one can visit with a b...</td>\n",
       "      <td>1</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119308</th>\n",
       "      <td>cool and colorful  wallpapers</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119310</th>\n",
       "      <td>cool and fun pictures of animals</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>313799</th>\n",
       "      <td>milky way moon  3000x3000</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119239</th>\n",
       "      <td>cooking over  a flame</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>313744</th>\n",
       "      <td>milky way galaxy and man</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>313765</th>\n",
       "      <td>milky way galaxy with people</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119390</th>\n",
       "      <td>cool beach romance for familly</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119374</th>\n",
       "      <td>cool backgrounds with cool wolves</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>313519</th>\n",
       "      <td>miles pond, vt chamber of commerce</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>315756</th>\n",
       "      <td>minimalist autumn wallpaper for mac</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118529</th>\n",
       "      <td>constantia, cape town, south africa</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118506</th>\n",
       "      <td>conserve energy  hd images</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>315504</th>\n",
       "      <td>minimal windows 10 wallpaper plants</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>315497</th>\n",
       "      <td>minimal white pot with green leaves</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>316032</th>\n",
       "      <td>minimalist nature black and white</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>316000</th>\n",
       "      <td>minimalist lotus whitte background flower</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>316020</th>\n",
       "      <td>minimalist motivation work hard beach</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>316101</th>\n",
       "      <td>minimalist qoutes for travel wallpaper</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118232</th>\n",
       "      <td>conhece te a ti mesmo</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>315931</th>\n",
       "      <td>minimalist gentle monochrome simple macro text...</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>315959</th>\n",
       "      <td>minimalist home decor with plants</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>315905</th>\n",
       "      <td>minimalist flower black and white</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>314828</th>\n",
       "      <td>minimal black and white background</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118809</th>\n",
       "      <td>contaminated and counterfeited bottled water</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>314994</th>\n",
       "      <td>minimal flower on white  background</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>314905</th>\n",
       "      <td>minimal colorful art on white background</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>314803</th>\n",
       "      <td>minimal background texture nature plants</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>314801</th>\n",
       "      <td>minimal background stacks of magazines</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>314765</th>\n",
       "      <td>minimal background dark double screen</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118848</th>\n",
       "      <td>contemporary architecture made from wood</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>314790</th>\n",
       "      <td>minimal background nature soft brown</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118850</th>\n",
       "      <td>contemporary art gallery at night</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>314729</th>\n",
       "      <td>minimal art black and white</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>315333</th>\n",
       "      <td>minimal scene with geometric forms.</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118589</th>\n",
       "      <td>constellations in the night sky</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>315010</th>\n",
       "      <td>minimal food flat lay background</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118714</th>\n",
       "      <td>construction worker at the beach</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118716</th>\n",
       "      <td>construction worker in the winter</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                  keyword  num_searches  \\\n",
       "313105       mid night star picture for youtube thumbnail             1   \n",
       "119583                           cool gamer pics for free             1   \n",
       "313060             mid century gothic style rose painting             1   \n",
       "313079                 mid century modern interior design             1   \n",
       "313077                   mid century modern home interior             1   \n",
       "313076                      mid century modern home decor             1   \n",
       "313160                          middle aged women  beauty             1   \n",
       "313148               middle age is an age of many colors.             1   \n",
       "313185                    middle east night in the desert             1   \n",
       "313694                               milky way at the sea             1   \n",
       "313709                              milky way by the nasa             1   \n",
       "119302  cool adventurous places one can visit with a b...             1   \n",
       "119308                      cool and colorful  wallpapers             1   \n",
       "119310                   cool and fun pictures of animals             1   \n",
       "313799                          milky way moon  3000x3000             1   \n",
       "119239                              cooking over  a flame             1   \n",
       "313744                           milky way galaxy and man             1   \n",
       "313765                       milky way galaxy with people             1   \n",
       "119390                     cool beach romance for familly             1   \n",
       "119374                  cool backgrounds with cool wolves             1   \n",
       "313519                 miles pond, vt chamber of commerce             1   \n",
       "315756                minimalist autumn wallpaper for mac             1   \n",
       "118529                constantia, cape town, south africa             1   \n",
       "118506                         conserve energy  hd images             1   \n",
       "315504                minimal windows 10 wallpaper plants             1   \n",
       "315497                minimal white pot with green leaves             1   \n",
       "316032                  minimalist nature black and white             1   \n",
       "316000          minimalist lotus whitte background flower             1   \n",
       "316020              minimalist motivation work hard beach             1   \n",
       "316101             minimalist qoutes for travel wallpaper             1   \n",
       "118232                              conhece te a ti mesmo             1   \n",
       "315931  minimalist gentle monochrome simple macro text...             1   \n",
       "315959                  minimalist home decor with plants             1   \n",
       "315905                  minimalist flower black and white             1   \n",
       "314828                 minimal black and white background             1   \n",
       "118809       contaminated and counterfeited bottled water             1   \n",
       "314994                minimal flower on white  background             1   \n",
       "314905           minimal colorful art on white background             1   \n",
       "314803           minimal background texture nature plants             1   \n",
       "314801             minimal background stacks of magazines             1   \n",
       "314765              minimal background dark double screen             1   \n",
       "118848           contemporary architecture made from wood             1   \n",
       "314790               minimal background nature soft brown             1   \n",
       "118850                  contemporary art gallery at night             1   \n",
       "314729                        minimal art black and white             1   \n",
       "315333                minimal scene with geometric forms.             1   \n",
       "118589                    constellations in the night sky             1   \n",
       "315010                   minimal food flat lay background             1   \n",
       "118714                   construction worker at the beach             1   \n",
       "118716                  construction worker in the winter             1   \n",
       "\n",
       "        num_keywords  \n",
       "313105             7  \n",
       "119583             5  \n",
       "313060             6  \n",
       "313079             5  \n",
       "313077             5  \n",
       "313076             5  \n",
       "313160             5  \n",
       "313148             8  \n",
       "313185             6  \n",
       "313694             5  \n",
       "313709             5  \n",
       "119302            16  \n",
       "119308             5  \n",
       "119310             6  \n",
       "313799             5  \n",
       "119239             5  \n",
       "313744             5  \n",
       "313765             5  \n",
       "119390             5  \n",
       "119374             5  \n",
       "313519             6  \n",
       "315756             5  \n",
       "118529             5  \n",
       "118506             5  \n",
       "315504             5  \n",
       "315497             6  \n",
       "316032             5  \n",
       "316000             5  \n",
       "316020             5  \n",
       "316101             5  \n",
       "118232             5  \n",
       "315931             7  \n",
       "315959             5  \n",
       "315905             5  \n",
       "314828             5  \n",
       "118809             5  \n",
       "314994             6  \n",
       "314905             6  \n",
       "314803             5  \n",
       "314801             5  \n",
       "314765             5  \n",
       "118848             5  \n",
       "314790             5  \n",
       "118850             5  \n",
       "314729             5  \n",
       "315333             5  \n",
       "118589             5  \n",
       "315010             5  \n",
       "118714             5  \n",
       "118716             5  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_long_queries[df_long_queries.num_keywords > 4].tail(50)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "0fdf13c0-a913-44f4-8786-b223cad1d0a7",
   "metadata": {},
   "source": [
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "49f898d8-5fd1-4475-a8f3-68c2e3d7f7b9",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "environment": {
   "kernel": "python3",
   "name": "pytorch-gpu.1-13.m107",
   "type": "gcloud",
   "uri": "gcr.io/deeplearning-platform-release/pytorch-gpu.1-13:m107"
  },
  "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.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}