notebooks/lurkers.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "burning-luxury",
   "metadata": {},
   "source": [
    "## bicycles\n",
    "\n",
    "- [Tags] 525\n",
    "- [PostLinks] 6,140\n",
    "- [Badges] 80,935\n",
    "- [Users] 40,571\n",
    "- [Votes] 283,664\n",
    "- [Comments] 131,281\n",
    "- [Posts] 56,860\n",
    "- [PostHistory] 146,878\n",
    "\n",
    "## coffee\n",
    "\n",
    "- [Tags] 115\n",
    "- [PostLinks] 602\n",
    "- [Comments] 4,365\n",
    "- [Badges] 10,852\n",
    "- [Votes] 20,663\n",
    "- [Posts] 3,936\n",
    "- [Users] 8,256\n",
    "- [PostHistory] 10,178\n",
    "\n",
    "## ukrainian\n",
    "\n",
    "- [Tags] 120\n",
    "- [PostLinks] 399\n",
    "- [Badges] 6,248\n",
    "- [Users] 3,080\n",
    "- [Comments] 6,954\n",
    "- [Votes] 28,867\n",
    "- [Posts] 5,069\n",
    "- [PostHistory] 16,102"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "honest-breed",
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt\n",
    "from IPython.display import display\n",
    "%run common.ipynb\n"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "appropriate-dream",
   "metadata": {},
   "source": [
    "## Załadowanie danych"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "divided-knight",
   "metadata": {},
   "outputs": [],
   "source": [
    "bicycles_posts_df = read_stackexchange(ModelType.POSTS, ForumType.BICYCLES)\n",
    "coffee_posts_df = read_stackexchange(ModelType.POSTS, ForumType.COFFEE)\n",
    "ukrainian_posts_df = read_stackexchange(ModelType.POSTS, ForumType.UKRAINIAN)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "destroyed-drunk",
   "metadata": {},
   "outputs": [],
   "source": [
    "def analyze_v1(posts):\n",
    "    # PostTypeId: 1 -> Question, 2 -> Answer\n",
    "    questions = posts.loc[posts.PostTypeId == 1, ['Id', 'CreationDate', 'Title', 'OwnerUserId']]\n",
    "    answers = posts.loc[posts.PostTypeId == 2, ['Id', 'ParentId', 'CreationDate', 'Body', 'OwnerUserId']]\n",
    "    \n",
    "    questions['CreationDate_datetime'] = pd.to_datetime(questions['CreationDate'])\n",
    "    answers['CreationDate_datetime'] = pd.to_datetime(answers['CreationDate'])\n",
    "    \n",
    "    df = questions.join(answers.set_index('ParentId'), on = 'Id', \n",
    "                        lsuffix='_question', rsuffix='_answer', how = 'inner')\n",
    "    df['diff_time'] = df['CreationDate_datetime_answer'] - df['CreationDate_datetime_question']\n",
    "    #df['diff_hours']=df['diff_hours']/np.timedelta64(1,'h')\n",
    "    \n",
    "    \n",
    "    # Aggregate diff_time by Id_question\n",
    "    df = df.groupby('Id_question').agg({'diff_time': ['min', 'max']})\n",
    "    df.columns = ['_'.join(col) for col in df.columns.values]\n",
    "    \n",
    "    # Get (min, max) from min and max\n",
    "    return df.agg({'diff_time_min': ['min', 'max'], 'diff_time_max': ['min', 'max']})\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "opposed-contamination",
   "metadata": {},
   "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>diff_time_min</th>\n",
       "      <th>diff_time_max</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>-292 days +20:16:49.880000</td>\n",
       "      <td>0 days 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>1619 days 12:16:06.473000</td>\n",
       "      <td>3806 days 00:28:05.467000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 diff_time_min             diff_time_max\n",
       "min -292 days +20:16:49.880000           0 days 00:00:00\n",
       "max  1619 days 12:16:06.473000 3806 days 00:28:05.467000"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "analyze_v1(bicycles_posts_df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "awful-bundle",
   "metadata": {},
   "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>diff_time_min</th>\n",
       "      <th>diff_time_max</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>0 days 00:00:00</td>\n",
       "      <td>0 days 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>1679 days 21:41:25.017000</td>\n",
       "      <td>2178 days 04:13:18.530000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                diff_time_min             diff_time_max\n",
       "min           0 days 00:00:00           0 days 00:00:00\n",
       "max 1679 days 21:41:25.017000 2178 days 04:13:18.530000"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "analyze_v1(coffee_posts_df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "early-pastor",
   "metadata": {},
   "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>diff_time_min</th>\n",
       "      <th>diff_time_max</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>0 days 00:00:00</td>\n",
       "      <td>0 days 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>1195 days 04:04:19.527000</td>\n",
       "      <td>1429 days 06:35:39.454000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                diff_time_min             diff_time_max\n",
       "min           0 days 00:00:00           0 days 00:00:00\n",
       "max 1195 days 04:04:19.527000 1429 days 06:35:39.454000"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "analyze_v1(ukrainian_posts_df)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "departmental-questionnaire",
   "metadata": {},
   "source": [
    "Otrzymujemy ciekawe wyniki - zerowe i ujemne.\n",
    "\n",
    "### Zacznijmy od ujemnych.\n",
    "\n",
    "Po krótkim dochodzeniu, znajdujemy winowajcę:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "modified-construction",
   "metadata": {},
   "outputs": [],
   "source": [
    "def nostradamus():\n",
    "    questions = bicycles_posts_df.loc[bicycles_posts_df.PostTypeId == 1, ['Id', 'CreationDate', 'Title']]\n",
    "    answers = bicycles_posts_df.loc[bicycles_posts_df.PostTypeId == 2, ['Id', 'ParentId', 'CreationDate']]\n",
    "    \n",
    "    questions['CreationDate_datetime'] = pd.to_datetime(questions['CreationDate'])\n",
    "    answers['CreationDate_datetime'] = pd.to_datetime(answers['CreationDate'])\n",
    "    \n",
    "    df = questions.join(answers.set_index('ParentId'), on = 'Id', \n",
    "                        lsuffix='_question', rsuffix='_answer', how = 'inner')\n",
    "    df['diff_time'] = df['CreationDate_datetime_answer'] - df['CreationDate_datetime_question']\n",
    "    #df['diff_hours']=df['diff_hours']/np.timedelta64(1,'h')\n",
    "    \n",
    "    \n",
    "    return df.loc[df['Id_question'] == 10069, ['Title', 'CreationDate_question', 'CreationDate_answer', 'diff_time']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "radical-chrome",
   "metadata": {},
   "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>Title</th>\n",
       "      <th>CreationDate_question</th>\n",
       "      <th>CreationDate_answer</th>\n",
       "      <th>diff_time</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>9293</th>\n",
       "      <td>Does drafting cause resistance to the lead rider?</td>\n",
       "      <td>2012-06-26T15:56:24.383</td>\n",
       "      <td>2011-09-09T12:13:14.263</td>\n",
       "      <td>-292 days +20:16:49.880000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9293</th>\n",
       "      <td>Does drafting cause resistance to the lead rider?</td>\n",
       "      <td>2012-06-26T15:56:24.383</td>\n",
       "      <td>2011-09-09T13:09:40.740</td>\n",
       "      <td>-292 days +21:13:16.357000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9293</th>\n",
       "      <td>Does drafting cause resistance to the lead rider?</td>\n",
       "      <td>2012-06-26T15:56:24.383</td>\n",
       "      <td>2012-06-26T16:08:55.867</td>\n",
       "      <td>0 days 00:12:31.484000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9293</th>\n",
       "      <td>Does drafting cause resistance to the lead rider?</td>\n",
       "      <td>2012-06-26T15:56:24.383</td>\n",
       "      <td>2012-06-26T22:40:22.667</td>\n",
       "      <td>0 days 06:43:58.284000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9293</th>\n",
       "      <td>Does drafting cause resistance to the lead rider?</td>\n",
       "      <td>2012-06-26T15:56:24.383</td>\n",
       "      <td>2012-06-27T11:20:53.213</td>\n",
       "      <td>0 days 19:24:28.830000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9293</th>\n",
       "      <td>Does drafting cause resistance to the lead rider?</td>\n",
       "      <td>2012-06-26T15:56:24.383</td>\n",
       "      <td>2015-08-25T04:43:32.313</td>\n",
       "      <td>1154 days 12:47:07.930000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                  Title  \\\n",
       "9293  Does drafting cause resistance to the lead rider?   \n",
       "9293  Does drafting cause resistance to the lead rider?   \n",
       "9293  Does drafting cause resistance to the lead rider?   \n",
       "9293  Does drafting cause resistance to the lead rider?   \n",
       "9293  Does drafting cause resistance to the lead rider?   \n",
       "9293  Does drafting cause resistance to the lead rider?   \n",
       "\n",
       "        CreationDate_question      CreationDate_answer  \\\n",
       "9293  2012-06-26T15:56:24.383  2011-09-09T12:13:14.263   \n",
       "9293  2012-06-26T15:56:24.383  2011-09-09T13:09:40.740   \n",
       "9293  2012-06-26T15:56:24.383  2012-06-26T16:08:55.867   \n",
       "9293  2012-06-26T15:56:24.383  2012-06-26T22:40:22.667   \n",
       "9293  2012-06-26T15:56:24.383  2012-06-27T11:20:53.213   \n",
       "9293  2012-06-26T15:56:24.383  2015-08-25T04:43:32.313   \n",
       "\n",
       "                      diff_time  \n",
       "9293 -292 days +20:16:49.880000  \n",
       "9293 -292 days +21:13:16.357000  \n",
       "9293     0 days 00:12:31.484000  \n",
       "9293     0 days 06:43:58.284000  \n",
       "9293     0 days 19:24:28.830000  \n",
       "9293  1154 days 12:47:07.930000  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "nostradamus()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "powered-bacteria",
   "metadata": {},
   "source": [
    "Rzeczywiście użytkownik [coco](https://bicycles.stackexchange.com/users/4394/coco), znany dalej jako Nostradamus zadał (jedyne w swojej karierze na *bicycles.stackexchange.com*) pytanie w 2012 roku, a następnie (chociaż chciałoby się powiedzieć *poprzednio*) użytownicy [Daniel R Hicks](https://bicycles.stackexchange.com/users/1584/daniel-r-hicks) oraz [Angelo](https://bicycles.stackexchange.com/users/1998/angelo) odpowiedzieli w 2011 roku.\n",
    "\n",
    "> asked Jun 26 '12 at 15:56\n",
    ">\n",
    "> coco\n",
    "\n",
    "> answered Sep 9 '11 at 12:13\n",
    ">\n",
    "> Daniel R Hicks\n",
    "\n",
    "> answered Sep 9 '11 at 13:09\n",
    ">\n",
    "> Angelo\n",
    "\n",
    "Dowód podróży w czasie można znaleźć dalej wiszący na forum: https://bicycles.stackexchange.com/questions/10069/does-drafting-cause-resistance-to-the-lead-rider"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "pediatric-volunteer",
   "metadata": {},
   "source": [
    "### Teraz przejdźmy do wyników zerowych.\n",
    "\n",
    "Poniższa analiza pokazuje, że wszystkie odpowiedzi, które zostały najwidoczniej napisane poniżej 1 tysięcznej sekundy po zamieszczeniu pytania należą do tego samego autora, który zadał pytanie. Znalezienie powodu dla tego fenomenu jest trywialne i pozostawiamy je czytelnikom jako ćwiczenie."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "photographic-genius",
   "metadata": {},
   "outputs": [],
   "source": [
    "def zeroday(posts):\n",
    "    # PostTypeId: 1 -> Question, 2 -> Answer\n",
    "    questions = posts.loc[posts.PostTypeId == 1, ['Id', 'CreationDate', 'Title', 'OwnerUserId']]\n",
    "    answers = posts.loc[posts.PostTypeId == 2, ['Id', 'ParentId', 'CreationDate', 'Body', 'OwnerUserId']]\n",
    "    \n",
    "    questions['CreationDate_datetime'] = pd.to_datetime(questions['CreationDate'])\n",
    "    answers['CreationDate_datetime'] = pd.to_datetime(answers['CreationDate'])\n",
    "    \n",
    "    df = questions.join(answers.set_index('ParentId'), on = 'Id', \n",
    "                        lsuffix='_question', rsuffix='_answer', how = 'inner')\n",
    "    df['diff_time'] = df['CreationDate_datetime_answer'] - df['CreationDate_datetime_question']\n",
    "    \n",
    "    df['IsSame'] = df['OwnerUserId_question'] == df['OwnerUserId_answer']\n",
    "    \n",
    "    df = df.loc[\n",
    "        df['CreationDate_datetime_question'] == df['CreationDate_datetime_answer'],\n",
    "        ['Id_question', 'Title', 'IsSame']\n",
    "    ]\n",
    "    return df\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "compact-loading",
   "metadata": {},
   "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>Id_question</th>\n",
       "      <th>Title</th>\n",
       "      <th>IsSame</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>11165</th>\n",
       "      <td>13157</td>\n",
       "      <td>I know there are better rain-forecast sources ...</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11550</th>\n",
       "      <td>13573</td>\n",
       "      <td>What are some alternatives to fruitlessly ring...</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12018</th>\n",
       "      <td>14102</td>\n",
       "      <td>Is the Suunto Ambit compatible with the Bontra...</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12779</th>\n",
       "      <td>14965</td>\n",
       "      <td>What are my options for cycling mirrors?</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13509</th>\n",
       "      <td>15827</td>\n",
       "      <td>Fixed Gear Chainring Centering</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13606</th>\n",
       "      <td>15945</td>\n",
       "      <td>How can I run a dynamo wire from my front hub ...</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13857</th>\n",
       "      <td>16215</td>\n",
       "      <td>How can I prevent cars from passing me too clo...</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14217</th>\n",
       "      <td>16617</td>\n",
       "      <td>What's an \"Auto-Mini\" folding bike? Can I use ...</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14377</th>\n",
       "      <td>16794</td>\n",
       "      <td>Can I carry my tandem on a bumper carrier?</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16081</th>\n",
       "      <td>18713</td>\n",
       "      <td>What are the effects of completely filling tir...</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16568</th>\n",
       "      <td>20278</td>\n",
       "      <td>Headtube Badges</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21069</th>\n",
       "      <td>28467</td>\n",
       "      <td>SRAM Rival brake caliper screws/bolts are rust...</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23016</th>\n",
       "      <td>30765</td>\n",
       "      <td>Pros and cons of single-sided forks (Cannondal...</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23180</th>\n",
       "      <td>30962</td>\n",
       "      <td>Difference between UD, 3K and 12K carbon finish?</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27009</th>\n",
       "      <td>36298</td>\n",
       "      <td>On a bottom bracket, what does the numeric exp...</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28224</th>\n",
       "      <td>37747</td>\n",
       "      <td>Glossary - types of riders</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28401</th>\n",
       "      <td>37949</td>\n",
       "      <td>How to replace a bottle dynamo with batteries</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29406</th>\n",
       "      <td>39124</td>\n",
       "      <td>Is there any good software to track and compar...</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30196</th>\n",
       "      <td>41040</td>\n",
       "      <td>How do I buy a used bike?</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33325</th>\n",
       "      <td>44679</td>\n",
       "      <td>What does 'Dahonesque' mean?</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33555</th>\n",
       "      <td>44937</td>\n",
       "      <td>What is a taco?</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33604</th>\n",
       "      <td>44990</td>\n",
       "      <td>What freewheel mechanism designs are used in b...</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33765</th>\n",
       "      <td>45168</td>\n",
       "      <td>Should I remove foreign objects from my tyres ...</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34457</th>\n",
       "      <td>45958</td>\n",
       "      <td>How do I open a master link in a chain?</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35037</th>\n",
       "      <td>46639</td>\n",
       "      <td>Bike Rack design</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37266</th>\n",
       "      <td>50244</td>\n",
       "      <td>Problem getting to big ring with XTR M960 Shif...</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41900</th>\n",
       "      <td>56524</td>\n",
       "      <td>Why is cross chaining 'bad', but 1x is OK?</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45691</th>\n",
       "      <td>61916</td>\n",
       "      <td>How can I get a snapped gear cable out of my S...</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48292</th>\n",
       "      <td>64860</td>\n",
       "      <td>What is cheaper, to walk or to cycle?</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49235</th>\n",
       "      <td>65940</td>\n",
       "      <td>Does a Tern Cargo Rack fit on a Bike Friday NW...</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50019</th>\n",
       "      <td>66807</td>\n",
       "      <td>How can I undo the locknut on this Shimano 105...</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50131</th>\n",
       "      <td>66928</td>\n",
       "      <td>How does the Pog Security Washer work when usi...</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50451</th>\n",
       "      <td>67281</td>\n",
       "      <td>What derailleur hanger do I need for my Merida...</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52226</th>\n",
       "      <td>69225</td>\n",
       "      <td>Why do bike tires suffer from frequent punctur...</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52536</th>\n",
       "      <td>69564</td>\n",
       "      <td>28-spoke wheel lost tension, what now?</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53138</th>\n",
       "      <td>71223</td>\n",
       "      <td>How accurate are altimeters in bike computers?</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53324</th>\n",
       "      <td>71428</td>\n",
       "      <td>What power adapter to use for the Cybex 700 st...</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53480</th>\n",
       "      <td>71597</td>\n",
       "      <td>Why are regenerative brakes uncommon on e-bikes?</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53805</th>\n",
       "      <td>71954</td>\n",
       "      <td>What is the mechanical advantage of mechanical...</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53899</th>\n",
       "      <td>72054</td>\n",
       "      <td>What features should I look for in a chain?</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54018</th>\n",
       "      <td>72184</td>\n",
       "      <td>How to model the dynamic tension distribution ...</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54037</th>\n",
       "      <td>72204</td>\n",
       "      <td>Why did my 28-spoke front wheel lost all tensi...</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54087</th>\n",
       "      <td>72258</td>\n",
       "      <td>How to select a rim?</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54751</th>\n",
       "      <td>72984</td>\n",
       "      <td>Which Shimano Centerlock Rotors Work with Avid...</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54791</th>\n",
       "      <td>73028</td>\n",
       "      <td>How to mount wire bead tyres without damaging ...</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55114</th>\n",
       "      <td>73385</td>\n",
       "      <td>Apparently too much rear derailleur cable pull</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55175</th>\n",
       "      <td>73453</td>\n",
       "      <td>Are Penny-Farthings Legal to Ride on Public Ro...</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55357</th>\n",
       "      <td>73647</td>\n",
       "      <td>Why does a Shimano centerlock rotor have free ...</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55703</th>\n",
       "      <td>74030</td>\n",
       "      <td>How to mount a kickstand on a bike with no kic...</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56149</th>\n",
       "      <td>74524</td>\n",
       "      <td>Where should I prefer and avoid cartridge bear...</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56531</th>\n",
       "      <td>74952</td>\n",
       "      <td>How to estimate the speed of cyclist with give...</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56718</th>\n",
       "      <td>75163</td>\n",
       "      <td>GoPro video is sped up!</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56737</th>\n",
       "      <td>75183</td>\n",
       "      <td>Securing a Penny Farthing- HOW?</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       Id_question                                              Title  IsSame\n",
       "11165        13157  I know there are better rain-forecast sources ...    True\n",
       "11550        13573  What are some alternatives to fruitlessly ring...    True\n",
       "12018        14102  Is the Suunto Ambit compatible with the Bontra...    True\n",
       "12779        14965           What are my options for cycling mirrors?    True\n",
       "13509        15827                     Fixed Gear Chainring Centering    True\n",
       "13606        15945  How can I run a dynamo wire from my front hub ...    True\n",
       "13857        16215  How can I prevent cars from passing me too clo...    True\n",
       "14217        16617  What's an \"Auto-Mini\" folding bike? Can I use ...    True\n",
       "14377        16794         Can I carry my tandem on a bumper carrier?    True\n",
       "16081        18713  What are the effects of completely filling tir...    True\n",
       "16568        20278                                    Headtube Badges    True\n",
       "21069        28467  SRAM Rival brake caliper screws/bolts are rust...    True\n",
       "23016        30765  Pros and cons of single-sided forks (Cannondal...    True\n",
       "23180        30962   Difference between UD, 3K and 12K carbon finish?    True\n",
       "27009        36298  On a bottom bracket, what does the numeric exp...    True\n",
       "28224        37747                         Glossary - types of riders    True\n",
       "28401        37949      How to replace a bottle dynamo with batteries    True\n",
       "29406        39124  Is there any good software to track and compar...    True\n",
       "30196        41040                          How do I buy a used bike?    True\n",
       "33325        44679                       What does 'Dahonesque' mean?    True\n",
       "33555        44937                                    What is a taco?    True\n",
       "33604        44990  What freewheel mechanism designs are used in b...    True\n",
       "33765        45168  Should I remove foreign objects from my tyres ...    True\n",
       "34457        45958            How do I open a master link in a chain?    True\n",
       "35037        46639                                   Bike Rack design    True\n",
       "37266        50244  Problem getting to big ring with XTR M960 Shif...    True\n",
       "41900        56524         Why is cross chaining 'bad', but 1x is OK?    True\n",
       "45691        61916  How can I get a snapped gear cable out of my S...    True\n",
       "48292        64860              What is cheaper, to walk or to cycle?    True\n",
       "49235        65940  Does a Tern Cargo Rack fit on a Bike Friday NW...    True\n",
       "50019        66807  How can I undo the locknut on this Shimano 105...    True\n",
       "50131        66928  How does the Pog Security Washer work when usi...    True\n",
       "50451        67281  What derailleur hanger do I need for my Merida...    True\n",
       "52226        69225  Why do bike tires suffer from frequent punctur...    True\n",
       "52536        69564             28-spoke wheel lost tension, what now?    True\n",
       "53138        71223     How accurate are altimeters in bike computers?    True\n",
       "53324        71428  What power adapter to use for the Cybex 700 st...    True\n",
       "53480        71597   Why are regenerative brakes uncommon on e-bikes?    True\n",
       "53805        71954  What is the mechanical advantage of mechanical...    True\n",
       "53899        72054        What features should I look for in a chain?    True\n",
       "54018        72184  How to model the dynamic tension distribution ...    True\n",
       "54037        72204  Why did my 28-spoke front wheel lost all tensi...    True\n",
       "54087        72258                               How to select a rim?    True\n",
       "54751        72984  Which Shimano Centerlock Rotors Work with Avid...    True\n",
       "54791        73028  How to mount wire bead tyres without damaging ...    True\n",
       "55114        73385     Apparently too much rear derailleur cable pull    True\n",
       "55175        73453  Are Penny-Farthings Legal to Ride on Public Ro...    True\n",
       "55357        73647  Why does a Shimano centerlock rotor have free ...    True\n",
       "55703        74030  How to mount a kickstand on a bike with no kic...    True\n",
       "56149        74524  Where should I prefer and avoid cartridge bear...    True\n",
       "56531        74952  How to estimate the speed of cyclist with give...    True\n",
       "56718        75163                            GoPro video is sped up!    True\n",
       "56737        75183                    Securing a Penny Farthing- HOW?    True"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "zeroday(bicycles_posts_df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "insured-cricket",
   "metadata": {},
   "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>Id_question</th>\n",
       "      <th>Title</th>\n",
       "      <th>IsSame</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>318</th>\n",
       "      <td>339</td>\n",
       "      <td>Pouring technique for drip/pour over coffee</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>384</th>\n",
       "      <td>408</td>\n",
       "      <td>What is the difference between a long (luongo)...</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>394</th>\n",
       "      <td>418</td>\n",
       "      <td>What's the difference between a percolator and...</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>406</th>\n",
       "      <td>431</td>\n",
       "      <td>How can I make filtering my cold brew easier?</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>479</th>\n",
       "      <td>1512</td>\n",
       "      <td>What is the process for brewing egg coffee?</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>528</th>\n",
       "      <td>1564</td>\n",
       "      <td>What do the terms extraction and strength mean?</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>865</th>\n",
       "      <td>1938</td>\n",
       "      <td>How to (re-)calibrate an espresso machine and ...</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1101</th>\n",
       "      <td>2195</td>\n",
       "      <td>How much sugar can I put it my coffee before i...</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1382</th>\n",
       "      <td>2515</td>\n",
       "      <td>How to fix burr contact/alignment issues on an...</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1708</th>\n",
       "      <td>2881</td>\n",
       "      <td>Is there a way to economically store freshly r...</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1881</th>\n",
       "      <td>3074</td>\n",
       "      <td>What is \"mırra\", the over-brewed Turkish coffee?</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1963</th>\n",
       "      <td>3168</td>\n",
       "      <td>What are the 4M's of espresso?</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2078</th>\n",
       "      <td>3299</td>\n",
       "      <td>What's the history and content of Coffee Canta...</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2629</th>\n",
       "      <td>3936</td>\n",
       "      <td>What is the history and significance of the \"A...</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2940</th>\n",
       "      <td>4292</td>\n",
       "      <td>Delonghi Magnifica - pump stops after 10 secon...</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2976</th>\n",
       "      <td>4338</td>\n",
       "      <td>Capsule holder drawer stuck in Minù Caffè Latt...</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      Id_question                                              Title  IsSame\n",
       "318           339        Pouring technique for drip/pour over coffee    True\n",
       "384           408  What is the difference between a long (luongo)...    True\n",
       "394           418  What's the difference between a percolator and...    True\n",
       "406           431      How can I make filtering my cold brew easier?    True\n",
       "479          1512        What is the process for brewing egg coffee?    True\n",
       "528          1564    What do the terms extraction and strength mean?    True\n",
       "865          1938  How to (re-)calibrate an espresso machine and ...    True\n",
       "1101         2195  How much sugar can I put it my coffee before i...    True\n",
       "1382         2515  How to fix burr contact/alignment issues on an...    True\n",
       "1708         2881  Is there a way to economically store freshly r...    True\n",
       "1881         3074   What is \"mırra\", the over-brewed Turkish coffee?    True\n",
       "1963         3168                     What are the 4M's of espresso?    True\n",
       "2078         3299  What's the history and content of Coffee Canta...    True\n",
       "2629         3936  What is the history and significance of the \"A...    True\n",
       "2940         4292  Delonghi Magnifica - pump stops after 10 secon...    True\n",
       "2976         4338  Capsule holder drawer stuck in Minù Caffè Latt...    True"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "zeroday(coffee_posts_df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "falling-diary",
   "metadata": {},
   "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>Id_question</th>\n",
       "      <th>Title</th>\n",
       "      <th>IsSame</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>40</td>\n",
       "      <td>Який символ використовувати для позначення апо...</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>435</th>\n",
       "      <td>467</td>\n",
       "      <td>Чи є загальне правило, яке керує написанням \"д...</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>473</th>\n",
       "      <td>505</td>\n",
       "      <td>Милозвучність української мови. Закони й засоби</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>600</th>\n",
       "      <td>639</td>\n",
       "      <td>Як правильно вживати слова \"воєнний\", \"військо...</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>659</th>\n",
       "      <td>699</td>\n",
       "      <td>Чи можна вживати слово \"калитка\" для позначенн...</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>843</th>\n",
       "      <td>900</td>\n",
       "      <td>«Закордон» чи «за кордон», «закордоном» чи «за...</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>870</th>\n",
       "      <td>927</td>\n",
       "      <td>Чи справді вираз «ти правий» у значеннях «твоя...</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1199</th>\n",
       "      <td>1270</td>\n",
       "      <td>Судно́ чи су́дно?</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1996</th>\n",
       "      <td>3148</td>\n",
       "      <td>Лі́карський чи Ліка́рський? Як правильно?</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2003</th>\n",
       "      <td>3155</td>\n",
       "      <td>\"Кажан\" чи \"летюча миша\"? Як правильно?</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2107</th>\n",
       "      <td>3277</td>\n",
       "      <td>Великдень, Пасха, Паска</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4842</th>\n",
       "      <td>6262</td>\n",
       "      <td>У якому роді узгоджується COVID-19?</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      Id_question                                              Title  IsSame\n",
       "36             40  Який символ використовувати для позначення апо...    True\n",
       "435           467  Чи є загальне правило, яке керує написанням \"д...    True\n",
       "473           505    Милозвучність української мови. Закони й засоби    True\n",
       "600           639  Як правильно вживати слова \"воєнний\", \"військо...    True\n",
       "659           699  Чи можна вживати слово \"калитка\" для позначенн...    True\n",
       "843           900  «Закордон» чи «за кордон», «закордоном» чи «за...    True\n",
       "870           927  Чи справді вираз «ти правий» у значеннях «твоя...    True\n",
       "1199         1270                                  Судно́ чи су́дно?    True\n",
       "1996         3148          Лі́карський чи Ліка́рський? Як правильно?    True\n",
       "2003         3155            \"Кажан\" чи \"летюча миша\"? Як правильно?    True\n",
       "2107         3277                            Великдень, Пасха, Паска    True\n",
       "4842         6262                У якому роді узгоджується COVID-19?    True"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "zeroday(ukrainian_posts_df)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "21f9f913",
   "metadata": {},
   "source": [
    "## Wersja 2\n",
    "\n",
    "W tej wersji pomijamy wyniki niedodatnie"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "thousand-backing",
   "metadata": {},
   "outputs": [],
   "source": [
    "def analyze_v2(posts):\n",
    "    # PostTypeId: 1 -> Question, 2 -> Answer\n",
    "    questions = posts.loc[posts.PostTypeId == 1, ['Id', 'CreationDate', 'Title', 'OwnerUserId']]\n",
    "    answers = posts.loc[posts.PostTypeId == 2, ['Id', 'ParentId', 'CreationDate', 'Body', 'OwnerUserId']]\n",
    "    \n",
    "    questions['CreationDate_datetime'] = pd.to_datetime(questions['CreationDate'])\n",
    "    answers['CreationDate_datetime'] = pd.to_datetime(answers['CreationDate'])\n",
    "    \n",
    "    df = questions.join(answers.set_index('ParentId'), on = 'Id', \n",
    "                        lsuffix='_question', rsuffix='_answer', how = 'inner')\n",
    "    df['diff_time'] = df['CreationDate_datetime_answer'] - df['CreationDate_datetime_question']\n",
    "    #df['diff_hours']=df['diff_hours']/np.timedelta64(1,'h')\n",
    "    \n",
    "    df = df.loc[df['CreationDate_datetime_answer'] > df['CreationDate_datetime_question']]\n",
    "    \n",
    "    # Aggregate diff_time by Id_question\n",
    "    df = df.groupby('Id_question').agg({'diff_time': ['min', 'max']})\n",
    "    df.columns = ['_'.join(col) for col in df.columns.values]\n",
    "    \n",
    "    # Get (min, max) from min and max\n",
    "    return df.agg({'diff_time_min': ['min', 'max'], 'diff_time_max': ['min', 'max']})\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "chicken-diploma",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "bicycles\n"
     ]
    },
    {
     "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>diff_time_min</th>\n",
       "      <th>diff_time_max</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>0 days 00:00:00.187000</td>\n",
       "      <td>0 days 00:01:30.724000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>1619 days 12:16:06.473000</td>\n",
       "      <td>3806 days 00:28:05.467000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                diff_time_min             diff_time_max\n",
       "min    0 days 00:00:00.187000    0 days 00:01:30.724000\n",
       "max 1619 days 12:16:06.473000 3806 days 00:28:05.467000"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "codegolf\n"
     ]
    },
    {
     "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>diff_time_min</th>\n",
       "      <th>diff_time_max</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>0 days 00:00:09.916000</td>\n",
       "      <td>0 days 00:01:14.386000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>2286 days 01:20:07.793000</td>\n",
       "      <td>4390 days 00:56:30.434000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                diff_time_min             diff_time_max\n",
       "min    0 days 00:00:09.916000    0 days 00:01:14.386000\n",
       "max 2286 days 01:20:07.793000 4390 days 00:56:30.434000"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "coffee\n"
     ]
    },
    {
     "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>diff_time_min</th>\n",
       "      <th>diff_time_max</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>0 days 00:01:04.147000</td>\n",
       "      <td>0 days 00:01:04.147000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>1679 days 21:41:25.017000</td>\n",
       "      <td>2178 days 04:13:18.530000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                diff_time_min             diff_time_max\n",
       "min    0 days 00:01:04.147000    0 days 00:01:04.147000\n",
       "max 1679 days 21:41:25.017000 2178 days 04:13:18.530000"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "crypto\n"
     ]
    },
    {
     "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>diff_time_min</th>\n",
       "      <th>diff_time_max</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>0 days 00:00:00.234000</td>\n",
       "      <td>0 days 00:00:52.530000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>2603 days 17:38:56.997000</td>\n",
       "      <td>3426 days 18:42:12.203000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                diff_time_min             diff_time_max\n",
       "min    0 days 00:00:00.234000    0 days 00:00:52.530000\n",
       "max 2603 days 17:38:56.997000 3426 days 18:42:12.203000"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "gamedev\n"
     ]
    },
    {
     "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>diff_time_min</th>\n",
       "      <th>diff_time_max</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>0 days 00:00:00.170000</td>\n",
       "      <td>0 days 00:00:09.750000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>2976 days 22:21:36.270000</td>\n",
       "      <td>3787 days 08:41:12.380000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                diff_time_min             diff_time_max\n",
       "min    0 days 00:00:00.170000    0 days 00:00:09.750000\n",
       "max 2976 days 22:21:36.270000 3787 days 08:41:12.380000"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "pets\n"
     ]
    },
    {
     "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>diff_time_min</th>\n",
       "      <th>diff_time_max</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>0 days 00:00:57.300000</td>\n",
       "      <td>0 days 00:00:57.300000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>2227 days 12:09:37.457000</td>\n",
       "      <td>2671 days 18:58:26.343000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                diff_time_min             diff_time_max\n",
       "min    0 days 00:00:57.300000    0 days 00:00:57.300000\n",
       "max 2227 days 12:09:37.457000 2671 days 18:58:26.343000"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "ukrainian\n"
     ]
    },
    {
     "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>diff_time_min</th>\n",
       "      <th>diff_time_max</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>0 days 00:00:15.744000</td>\n",
       "      <td>0 days 00:00:15.744000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>1195 days 04:04:19.527000</td>\n",
       "      <td>1429 days 06:35:39.454000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                diff_time_min             diff_time_max\n",
       "min    0 days 00:00:15.744000    0 days 00:00:15.744000\n",
       "max 1195 days 04:04:19.527000 1429 days 06:35:39.454000"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "for forum_type in ForumType:\n",
    "    posts_df = read_stackexchange(ModelType.POSTS, forum_type)\n",
    "    print(forum_type.value)\n",
    "    display(analyze_v2(posts_df))\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "decent-piano",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "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.8.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}