1-motives_of_minimalism_and_veganism(task 1).ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Waseem Salami & Nelly Groissman on the motives of minimalism and veganism - Task 1 - Presenting The Data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "Version 7.7.0 of praw is outdated. Version 7.7.1 was released Tuesday July 11, 2023.\n"
     ]
    }
   ],
   "source": [
    "import praw\n",
    "\n",
    "username = \"someusername\"\n",
    "clientid = \"somepassword\"\n",
    "clientsecret = \"someclient\"\n",
    "\n",
    "reddit = praw.Reddit(client_id=clientid,\n",
    "                     client_secret=clientsecret,\n",
    "                     user_agent='praw_tutorial (by {})'.format(username))\n",
    "\n",
    "import pandas as pd\n",
    "from datetime import datetime"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "results = reddit.subreddit(\"vegan\").search('\"What made you\"', sort=\"new\", limit=10)\n",
    "counter = 0\n",
    "\n",
    "column_names = [\"Index\", \"IsPost\", \"Post Author\", \"Subreddit\", \"Post title\", \"Comment Author\", \"Post text\", \"Post URL\", \"Post time\"]\n",
    "\n",
    "posts_table = []\n",
    "\n",
    "for p in results: # p is a reddit post\n",
    "    counter += 1\n",
    "    \n",
    "    # Add the post to the table\n",
    "    posts_table.append([counter, \"yes\", p.author, p.subreddit, p.title, \"none\", p.selftext, p.permalink,\n",
    "                         datetime.utcfromtimestamp(p.created)])\n",
    "    \n",
    "    for comment in p.comments:\n",
    "        p.comments.replace_more(limit=None) # retrieve all comments using more API calls if needed\n",
    "        posts_table.append([counter, \"no\", \"\", p.subreddit, \"\", comment.author, comment.body, comment.permalink,\n",
    "                         datetime.utcfromtimestamp(comment.created)])\n",
    "\n",
    "what_made_you_vegan_df = pd.DataFrame(posts_table, columns=column_names)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "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>Index</th>\n",
       "      <th>IsPost</th>\n",
       "      <th>Post Author</th>\n",
       "      <th>Subreddit</th>\n",
       "      <th>Post title</th>\n",
       "      <th>Comment Author</th>\n",
       "      <th>Post text</th>\n",
       "      <th>Post URL</th>\n",
       "      <th>Post time</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>yes</td>\n",
       "      <td>Peppa831</td>\n",
       "      <td>vegan</td>\n",
       "      <td>Help needed for nursing school project on the ...</td>\n",
       "      <td>none</td>\n",
       "      <td>Hi! I’m currently doing a project for one of m...</td>\n",
       "      <td>/r/vegan/comments/12uqnyy/help_needed_for_nurs...</td>\n",
       "      <td>2023-04-22 01:51:17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>AutoModerator</td>\n",
       "      <td>\\nThanks for posting to r/Vegan! &amp;#128037;\\n\\n...</td>\n",
       "      <td>/r/vegan/comments/12uqnyy/help_needed_for_nurs...</td>\n",
       "      <td>2023-04-22 01:51:19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>Vegoonmoon</td>\n",
       "      <td>What made you become vegan?\\n\\nI live in the s...</td>\n",
       "      <td>/r/vegan/comments/12uqnyy/help_needed_for_nurs...</td>\n",
       "      <td>2023-04-22 03:23:29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>madelinegumbo</td>\n",
       "      <td>What made you become vegan?\\n\\nSpecifically it...</td>\n",
       "      <td>/r/vegan/comments/12uqnyy/help_needed_for_nurs...</td>\n",
       "      <td>2023-04-22 02:07:31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2</td>\n",
       "      <td>yes</td>\n",
       "      <td>Peppa831</td>\n",
       "      <td>vegan</td>\n",
       "      <td>Help needed for school project related to bein...</td>\n",
       "      <td>none</td>\n",
       "      <td>Hi! I’m currently doing a project where I need...</td>\n",
       "      <td>/r/vegan/comments/12e14bg/help_needed_for_scho...</td>\n",
       "      <td>2023-04-06 22:58:11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158</th>\n",
       "      <td>10</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>PurplePanda1971</td>\n",
       "      <td>What the Health initially and then all the oth...</td>\n",
       "      <td>/r/vegan/comments/wmjivw/those_of_you_who_ate_...</td>\n",
       "      <td>2022-08-13 05:22:33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>159</th>\n",
       "      <td>10</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>TheAverageBiologist</td>\n",
       "      <td>Visited a pig farm</td>\n",
       "      <td>/r/vegan/comments/wmjivw/those_of_you_who_ate_...</td>\n",
       "      <td>2022-08-13 06:51:40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>160</th>\n",
       "      <td>10</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td>I realized the contradiction of loving animals...</td>\n",
       "      <td>/r/vegan/comments/wmjivw/those_of_you_who_ate_...</td>\n",
       "      <td>2022-08-13 09:31:47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>161</th>\n",
       "      <td>10</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>Trick-Necessary4601</td>\n",
       "      <td>Working in delis and chicken prep factories.\\n...</td>\n",
       "      <td>/r/vegan/comments/wmjivw/those_of_you_who_ate_...</td>\n",
       "      <td>2022-08-13 11:27:09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162</th>\n",
       "      <td>10</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td>Documentaries</td>\n",
       "      <td>/r/vegan/comments/wmjivw/those_of_you_who_ate_...</td>\n",
       "      <td>2022-08-14 11:42:19</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>163 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Index IsPost Post Author Subreddit  \\\n",
       "0        1    yes    Peppa831     vegan   \n",
       "1        1     no                 vegan   \n",
       "2        1     no                 vegan   \n",
       "3        1     no                 vegan   \n",
       "4        2    yes    Peppa831     vegan   \n",
       "..     ...    ...         ...       ...   \n",
       "158     10     no                 vegan   \n",
       "159     10     no                 vegan   \n",
       "160     10     no                 vegan   \n",
       "161     10     no                 vegan   \n",
       "162     10     no                 vegan   \n",
       "\n",
       "                                            Post title       Comment Author  \\\n",
       "0    Help needed for nursing school project on the ...                 none   \n",
       "1                                                             AutoModerator   \n",
       "2                                                                Vegoonmoon   \n",
       "3                                                             madelinegumbo   \n",
       "4    Help needed for school project related to bein...                 none   \n",
       "..                                                 ...                  ...   \n",
       "158                                                         PurplePanda1971   \n",
       "159                                                     TheAverageBiologist   \n",
       "160                                                                    None   \n",
       "161                                                     Trick-Necessary4601   \n",
       "162                                                                    None   \n",
       "\n",
       "                                             Post text  \\\n",
       "0    Hi! I’m currently doing a project for one of m...   \n",
       "1    \\nThanks for posting to r/Vegan! &#128037;\\n\\n...   \n",
       "2    What made you become vegan?\\n\\nI live in the s...   \n",
       "3    What made you become vegan?\\n\\nSpecifically it...   \n",
       "4    Hi! I’m currently doing a project where I need...   \n",
       "..                                                 ...   \n",
       "158  What the Health initially and then all the oth...   \n",
       "159                                 Visited a pig farm   \n",
       "160  I realized the contradiction of loving animals...   \n",
       "161  Working in delis and chicken prep factories.\\n...   \n",
       "162                                      Documentaries   \n",
       "\n",
       "                                              Post URL           Post time  \n",
       "0    /r/vegan/comments/12uqnyy/help_needed_for_nurs... 2023-04-22 01:51:17  \n",
       "1    /r/vegan/comments/12uqnyy/help_needed_for_nurs... 2023-04-22 01:51:19  \n",
       "2    /r/vegan/comments/12uqnyy/help_needed_for_nurs... 2023-04-22 03:23:29  \n",
       "3    /r/vegan/comments/12uqnyy/help_needed_for_nurs... 2023-04-22 02:07:31  \n",
       "4    /r/vegan/comments/12e14bg/help_needed_for_scho... 2023-04-06 22:58:11  \n",
       "..                                                 ...                 ...  \n",
       "158  /r/vegan/comments/wmjivw/those_of_you_who_ate_... 2022-08-13 05:22:33  \n",
       "159  /r/vegan/comments/wmjivw/those_of_you_who_ate_... 2022-08-13 06:51:40  \n",
       "160  /r/vegan/comments/wmjivw/those_of_you_who_ate_... 2022-08-13 09:31:47  \n",
       "161  /r/vegan/comments/wmjivw/those_of_you_who_ate_... 2022-08-13 11:27:09  \n",
       "162  /r/vegan/comments/wmjivw/those_of_you_who_ate_... 2022-08-14 11:42:19  \n",
       "\n",
       "[163 rows x 9 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "what_made_you_vegan_df "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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>Index</th>\n",
       "      <th>IsPost</th>\n",
       "      <th>Post Author</th>\n",
       "      <th>Subreddit</th>\n",
       "      <th>Post title</th>\n",
       "      <th>Comment Author</th>\n",
       "      <th>Post text</th>\n",
       "      <th>Post URL</th>\n",
       "      <th>Post time</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>yes</td>\n",
       "      <td>Peppa831</td>\n",
       "      <td>vegan</td>\n",
       "      <td>Help needed for nursing school project on the ...</td>\n",
       "      <td>none</td>\n",
       "      <td>Hi! I’m currently doing a project for one of m...</td>\n",
       "      <td>/r/vegan/comments/12uqnyy/help_needed_for_nurs...</td>\n",
       "      <td>2023-04-22 01:51:17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>AutoModerator</td>\n",
       "      <td>\\nThanks for posting to r/Vegan! &amp;#128037;\\n\\n...</td>\n",
       "      <td>/r/vegan/comments/12uqnyy/help_needed_for_nurs...</td>\n",
       "      <td>2023-04-22 01:51:19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>Vegoonmoon</td>\n",
       "      <td>What made you become vegan?\\n\\nI live in the s...</td>\n",
       "      <td>/r/vegan/comments/12uqnyy/help_needed_for_nurs...</td>\n",
       "      <td>2023-04-22 03:23:29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>madelinegumbo</td>\n",
       "      <td>What made you become vegan?\\n\\nSpecifically it...</td>\n",
       "      <td>/r/vegan/comments/12uqnyy/help_needed_for_nurs...</td>\n",
       "      <td>2023-04-22 02:07:31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2</td>\n",
       "      <td>yes</td>\n",
       "      <td>Peppa831</td>\n",
       "      <td>vegan</td>\n",
       "      <td>Help needed for school project related to bein...</td>\n",
       "      <td>none</td>\n",
       "      <td>Hi! I’m currently doing a project where I need...</td>\n",
       "      <td>/r/vegan/comments/12e14bg/help_needed_for_scho...</td>\n",
       "      <td>2023-04-06 22:58:11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158</th>\n",
       "      <td>10</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>PurplePanda1971</td>\n",
       "      <td>What the Health initially and then all the oth...</td>\n",
       "      <td>/r/vegan/comments/wmjivw/those_of_you_who_ate_...</td>\n",
       "      <td>2022-08-13 05:22:33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>159</th>\n",
       "      <td>10</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>TheAverageBiologist</td>\n",
       "      <td>Visited a pig farm</td>\n",
       "      <td>/r/vegan/comments/wmjivw/those_of_you_who_ate_...</td>\n",
       "      <td>2022-08-13 06:51:40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>160</th>\n",
       "      <td>10</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td>I realized the contradiction of loving animals...</td>\n",
       "      <td>/r/vegan/comments/wmjivw/those_of_you_who_ate_...</td>\n",
       "      <td>2022-08-13 09:31:47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>161</th>\n",
       "      <td>10</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>Trick-Necessary4601</td>\n",
       "      <td>Working in delis and chicken prep factories.\\n...</td>\n",
       "      <td>/r/vegan/comments/wmjivw/those_of_you_who_ate_...</td>\n",
       "      <td>2022-08-13 11:27:09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162</th>\n",
       "      <td>10</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td>Documentaries</td>\n",
       "      <td>/r/vegan/comments/wmjivw/those_of_you_who_ate_...</td>\n",
       "      <td>2022-08-14 11:42:19</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>150 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Index IsPost Post Author Subreddit  \\\n",
       "0        1    yes    Peppa831     vegan   \n",
       "1        1     no                 vegan   \n",
       "2        1     no                 vegan   \n",
       "3        1     no                 vegan   \n",
       "4        2    yes    Peppa831     vegan   \n",
       "..     ...    ...         ...       ...   \n",
       "158     10     no                 vegan   \n",
       "159     10     no                 vegan   \n",
       "160     10     no                 vegan   \n",
       "161     10     no                 vegan   \n",
       "162     10     no                 vegan   \n",
       "\n",
       "                                            Post title       Comment Author  \\\n",
       "0    Help needed for nursing school project on the ...                 none   \n",
       "1                                                             AutoModerator   \n",
       "2                                                                Vegoonmoon   \n",
       "3                                                             madelinegumbo   \n",
       "4    Help needed for school project related to bein...                 none   \n",
       "..                                                 ...                  ...   \n",
       "158                                                         PurplePanda1971   \n",
       "159                                                     TheAverageBiologist   \n",
       "160                                                                    None   \n",
       "161                                                     Trick-Necessary4601   \n",
       "162                                                                    None   \n",
       "\n",
       "                                             Post text  \\\n",
       "0    Hi! I’m currently doing a project for one of m...   \n",
       "1    \\nThanks for posting to r/Vegan! &#128037;\\n\\n...   \n",
       "2    What made you become vegan?\\n\\nI live in the s...   \n",
       "3    What made you become vegan?\\n\\nSpecifically it...   \n",
       "4    Hi! I’m currently doing a project where I need...   \n",
       "..                                                 ...   \n",
       "158  What the Health initially and then all the oth...   \n",
       "159                                 Visited a pig farm   \n",
       "160  I realized the contradiction of loving animals...   \n",
       "161  Working in delis and chicken prep factories.\\n...   \n",
       "162                                      Documentaries   \n",
       "\n",
       "                                              Post URL           Post time  \n",
       "0    /r/vegan/comments/12uqnyy/help_needed_for_nurs... 2023-04-22 01:51:17  \n",
       "1    /r/vegan/comments/12uqnyy/help_needed_for_nurs... 2023-04-22 01:51:19  \n",
       "2    /r/vegan/comments/12uqnyy/help_needed_for_nurs... 2023-04-22 03:23:29  \n",
       "3    /r/vegan/comments/12uqnyy/help_needed_for_nurs... 2023-04-22 02:07:31  \n",
       "4    /r/vegan/comments/12e14bg/help_needed_for_scho... 2023-04-06 22:58:11  \n",
       "..                                                 ...                 ...  \n",
       "158  /r/vegan/comments/wmjivw/those_of_you_who_ate_... 2022-08-13 05:22:33  \n",
       "159  /r/vegan/comments/wmjivw/those_of_you_who_ate_... 2022-08-13 06:51:40  \n",
       "160  /r/vegan/comments/wmjivw/those_of_you_who_ate_... 2022-08-13 09:31:47  \n",
       "161  /r/vegan/comments/wmjivw/those_of_you_who_ate_... 2022-08-13 11:27:09  \n",
       "162  /r/vegan/comments/wmjivw/those_of_you_who_ate_... 2022-08-14 11:42:19  \n",
       "\n",
       "[150 rows x 9 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "what_made_you_vegan_df = what_made_you_vegan_df[what_made_you_vegan_df['Post text'] != '[deleted]']\n",
    "what_made_you_vegan_df = what_made_you_vegan_df[(what_made_you_vegan_df['IsPost'] == 'yes')|(~what_made_you_vegan_df['Comment Author'].duplicated()) | what_made_you_vegan_df['Comment Author'].isna()]\n",
    "what_made_you_vegan_df = what_made_you_vegan_df.drop_duplicates('Post text', keep='first')\n",
    "what_made_you_vegan_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "#what_made_you_vegan_df.to_csv(\"what_made_you_vegan.csv\", index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "results = reddit.subreddit(\"minimalism+Anticonsumption\").search('\"what made you\"', sort=\"new\", limit=None)\n",
    "counter = 0\n",
    "\n",
    "column_names = [\"Index\", \"IsPost\", \"Post Author\", \"Subreddit\", \"Post title\", \"Comment Author\", \"Post text\", \"Post URL\", \"Post time\"]\n",
    "\n",
    "posts_table = []\n",
    "\n",
    "for p in results: # p is a reddit post\n",
    "    counter += 1\n",
    "    \n",
    "    # Add the post to the table\n",
    "    posts_table.append([counter, \"yes\", p.author, p.subreddit, p.title, \"none\", p.selftext, p.permalink,\n",
    "                         datetime.utcfromtimestamp(p.created)])\n",
    "    for comment in p.comments:\n",
    "        p.comments.replace_more(limit=500) # retrieve all comments using more API calls if needed\n",
    "        posts_table.append([counter, \"no\", \"\", p.subreddit, \"\", comment.author, comment.body, comment.permalink,\n",
    "                         datetime.utcfromtimestamp(comment.created)])\n",
    "\n",
    "\n",
    "what_made_you_minimalist_df = pd.DataFrame(posts_table, columns=column_names)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "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>Index</th>\n",
       "      <th>IsPost</th>\n",
       "      <th>Post Author</th>\n",
       "      <th>Subreddit</th>\n",
       "      <th>Post title</th>\n",
       "      <th>Comment Author</th>\n",
       "      <th>Post text</th>\n",
       "      <th>Post URL</th>\n",
       "      <th>Post time</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>yes</td>\n",
       "      <td>desiringdirection</td>\n",
       "      <td>minimalism</td>\n",
       "      <td>What made you decide to become a minimalist?</td>\n",
       "      <td>none</td>\n",
       "      <td>For me it was not being able to find stuff and...</td>\n",
       "      <td>/r/minimalism/comments/qttjf1/what_made_you_de...</td>\n",
       "      <td>2021-11-14 16:35:25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>MiniPeppermints</td>\n",
       "      <td>I agree about too much stuff adding to depress...</td>\n",
       "      <td>/r/minimalism/comments/qttjf1/what_made_you_de...</td>\n",
       "      <td>2021-11-14 17:15:49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>wootangAlpha</td>\n",
       "      <td>Less stressful when things are kept stupid sim...</td>\n",
       "      <td>/r/minimalism/comments/qttjf1/what_made_you_de...</td>\n",
       "      <td>2021-11-14 17:36:53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>unrealz19</td>\n",
       "      <td>realizing happiness is not in things. instead ...</td>\n",
       "      <td>/r/minimalism/comments/qttjf1/what_made_you_de...</td>\n",
       "      <td>2021-11-14 16:37:51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>hologrampants</td>\n",
       "      <td>As a teenager in the 80s, I somehow happened u...</td>\n",
       "      <td>/r/minimalism/comments/qttjf1/what_made_you_de...</td>\n",
       "      <td>2021-11-14 17:27:56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>471</th>\n",
       "      <td>19</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td>Roaches.</td>\n",
       "      <td>/r/minimalism/comments/wnwvh/what_made_you_bec...</td>\n",
       "      <td>2012-07-18 10:09:32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>472</th>\n",
       "      <td>19</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td>Control. I grew up surrounded by hoarded posse...</td>\n",
       "      <td>/r/minimalism/comments/wnwvh/what_made_you_bec...</td>\n",
       "      <td>2012-07-17 16:54:39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>473</th>\n",
       "      <td>19</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>pigganon</td>\n",
       "      <td>The freedom to get up and move if you want/nee...</td>\n",
       "      <td>/r/minimalism/comments/wnwvh/what_made_you_bec...</td>\n",
       "      <td>2012-07-18 05:46:42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>474</th>\n",
       "      <td>19</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td>I don't think I consciously decided to \"become...</td>\n",
       "      <td>/r/minimalism/comments/wnwvh/what_made_you_bec...</td>\n",
       "      <td>2012-07-17 16:48:06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>475</th>\n",
       "      <td>19</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td>I was struggling with depression and was strug...</td>\n",
       "      <td>/r/minimalism/comments/wnwvh/what_made_you_bec...</td>\n",
       "      <td>2012-07-27 01:54:13</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>476 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Index IsPost        Post Author   Subreddit  \\\n",
       "0        1    yes  desiringdirection  minimalism   \n",
       "1        1     no                     minimalism   \n",
       "2        1     no                     minimalism   \n",
       "3        1     no                     minimalism   \n",
       "4        1     no                     minimalism   \n",
       "..     ...    ...                ...         ...   \n",
       "471     19     no                     minimalism   \n",
       "472     19     no                     minimalism   \n",
       "473     19     no                     minimalism   \n",
       "474     19     no                     minimalism   \n",
       "475     19     no                     minimalism   \n",
       "\n",
       "                                       Post title   Comment Author  \\\n",
       "0    What made you decide to become a minimalist?             none   \n",
       "1                                                  MiniPeppermints   \n",
       "2                                                     wootangAlpha   \n",
       "3                                                        unrealz19   \n",
       "4                                                    hologrampants   \n",
       "..                                            ...              ...   \n",
       "471                                                           None   \n",
       "472                                                           None   \n",
       "473                                                       pigganon   \n",
       "474                                                           None   \n",
       "475                                                           None   \n",
       "\n",
       "                                             Post text  \\\n",
       "0    For me it was not being able to find stuff and...   \n",
       "1    I agree about too much stuff adding to depress...   \n",
       "2    Less stressful when things are kept stupid sim...   \n",
       "3    realizing happiness is not in things. instead ...   \n",
       "4    As a teenager in the 80s, I somehow happened u...   \n",
       "..                                                 ...   \n",
       "471                                           Roaches.   \n",
       "472  Control. I grew up surrounded by hoarded posse...   \n",
       "473  The freedom to get up and move if you want/nee...   \n",
       "474  I don't think I consciously decided to \"become...   \n",
       "475  I was struggling with depression and was strug...   \n",
       "\n",
       "                                              Post URL           Post time  \n",
       "0    /r/minimalism/comments/qttjf1/what_made_you_de... 2021-11-14 16:35:25  \n",
       "1    /r/minimalism/comments/qttjf1/what_made_you_de... 2021-11-14 17:15:49  \n",
       "2    /r/minimalism/comments/qttjf1/what_made_you_de... 2021-11-14 17:36:53  \n",
       "3    /r/minimalism/comments/qttjf1/what_made_you_de... 2021-11-14 16:37:51  \n",
       "4    /r/minimalism/comments/qttjf1/what_made_you_de... 2021-11-14 17:27:56  \n",
       "..                                                 ...                 ...  \n",
       "471  /r/minimalism/comments/wnwvh/what_made_you_bec... 2012-07-18 10:09:32  \n",
       "472  /r/minimalism/comments/wnwvh/what_made_you_bec... 2012-07-17 16:54:39  \n",
       "473  /r/minimalism/comments/wnwvh/what_made_you_bec... 2012-07-18 05:46:42  \n",
       "474  /r/minimalism/comments/wnwvh/what_made_you_bec... 2012-07-17 16:48:06  \n",
       "475  /r/minimalism/comments/wnwvh/what_made_you_bec... 2012-07-27 01:54:13  \n",
       "\n",
       "[476 rows x 9 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "what_made_you_minimalist_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "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>Index</th>\n",
       "      <th>IsPost</th>\n",
       "      <th>Post Author</th>\n",
       "      <th>Subreddit</th>\n",
       "      <th>Post title</th>\n",
       "      <th>Comment Author</th>\n",
       "      <th>Post text</th>\n",
       "      <th>Post URL</th>\n",
       "      <th>Post time</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>yes</td>\n",
       "      <td>desiringdirection</td>\n",
       "      <td>minimalism</td>\n",
       "      <td>What made you decide to become a minimalist?</td>\n",
       "      <td>none</td>\n",
       "      <td>For me it was not being able to find stuff and...</td>\n",
       "      <td>/r/minimalism/comments/qttjf1/what_made_you_de...</td>\n",
       "      <td>2021-11-14 16:35:25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>MiniPeppermints</td>\n",
       "      <td>I agree about too much stuff adding to depress...</td>\n",
       "      <td>/r/minimalism/comments/qttjf1/what_made_you_de...</td>\n",
       "      <td>2021-11-14 17:15:49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>wootangAlpha</td>\n",
       "      <td>Less stressful when things are kept stupid sim...</td>\n",
       "      <td>/r/minimalism/comments/qttjf1/what_made_you_de...</td>\n",
       "      <td>2021-11-14 17:36:53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>unrealz19</td>\n",
       "      <td>realizing happiness is not in things. instead ...</td>\n",
       "      <td>/r/minimalism/comments/qttjf1/what_made_you_de...</td>\n",
       "      <td>2021-11-14 16:37:51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>hologrampants</td>\n",
       "      <td>As a teenager in the 80s, I somehow happened u...</td>\n",
       "      <td>/r/minimalism/comments/qttjf1/what_made_you_de...</td>\n",
       "      <td>2021-11-14 17:27:56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>471</th>\n",
       "      <td>19</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td>Roaches.</td>\n",
       "      <td>/r/minimalism/comments/wnwvh/what_made_you_bec...</td>\n",
       "      <td>2012-07-18 10:09:32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>472</th>\n",
       "      <td>19</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td>Control. I grew up surrounded by hoarded posse...</td>\n",
       "      <td>/r/minimalism/comments/wnwvh/what_made_you_bec...</td>\n",
       "      <td>2012-07-17 16:54:39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>473</th>\n",
       "      <td>19</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>pigganon</td>\n",
       "      <td>The freedom to get up and move if you want/nee...</td>\n",
       "      <td>/r/minimalism/comments/wnwvh/what_made_you_bec...</td>\n",
       "      <td>2012-07-18 05:46:42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>474</th>\n",
       "      <td>19</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td>I don't think I consciously decided to \"become...</td>\n",
       "      <td>/r/minimalism/comments/wnwvh/what_made_you_bec...</td>\n",
       "      <td>2012-07-17 16:48:06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>475</th>\n",
       "      <td>19</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td>I was struggling with depression and was strug...</td>\n",
       "      <td>/r/minimalism/comments/wnwvh/what_made_you_bec...</td>\n",
       "      <td>2012-07-27 01:54:13</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>445 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Index IsPost        Post Author   Subreddit  \\\n",
       "0        1    yes  desiringdirection  minimalism   \n",
       "1        1     no                     minimalism   \n",
       "2        1     no                     minimalism   \n",
       "3        1     no                     minimalism   \n",
       "4        1     no                     minimalism   \n",
       "..     ...    ...                ...         ...   \n",
       "471     19     no                     minimalism   \n",
       "472     19     no                     minimalism   \n",
       "473     19     no                     minimalism   \n",
       "474     19     no                     minimalism   \n",
       "475     19     no                     minimalism   \n",
       "\n",
       "                                       Post title   Comment Author  \\\n",
       "0    What made you decide to become a minimalist?             none   \n",
       "1                                                  MiniPeppermints   \n",
       "2                                                     wootangAlpha   \n",
       "3                                                        unrealz19   \n",
       "4                                                    hologrampants   \n",
       "..                                            ...              ...   \n",
       "471                                                           None   \n",
       "472                                                           None   \n",
       "473                                                       pigganon   \n",
       "474                                                           None   \n",
       "475                                                           None   \n",
       "\n",
       "                                             Post text  \\\n",
       "0    For me it was not being able to find stuff and...   \n",
       "1    I agree about too much stuff adding to depress...   \n",
       "2    Less stressful when things are kept stupid sim...   \n",
       "3    realizing happiness is not in things. instead ...   \n",
       "4    As a teenager in the 80s, I somehow happened u...   \n",
       "..                                                 ...   \n",
       "471                                           Roaches.   \n",
       "472  Control. I grew up surrounded by hoarded posse...   \n",
       "473  The freedom to get up and move if you want/nee...   \n",
       "474  I don't think I consciously decided to \"become...   \n",
       "475  I was struggling with depression and was strug...   \n",
       "\n",
       "                                              Post URL           Post time  \n",
       "0    /r/minimalism/comments/qttjf1/what_made_you_de... 2021-11-14 16:35:25  \n",
       "1    /r/minimalism/comments/qttjf1/what_made_you_de... 2021-11-14 17:15:49  \n",
       "2    /r/minimalism/comments/qttjf1/what_made_you_de... 2021-11-14 17:36:53  \n",
       "3    /r/minimalism/comments/qttjf1/what_made_you_de... 2021-11-14 16:37:51  \n",
       "4    /r/minimalism/comments/qttjf1/what_made_you_de... 2021-11-14 17:27:56  \n",
       "..                                                 ...                 ...  \n",
       "471  /r/minimalism/comments/wnwvh/what_made_you_bec... 2012-07-18 10:09:32  \n",
       "472  /r/minimalism/comments/wnwvh/what_made_you_bec... 2012-07-17 16:54:39  \n",
       "473  /r/minimalism/comments/wnwvh/what_made_you_bec... 2012-07-18 05:46:42  \n",
       "474  /r/minimalism/comments/wnwvh/what_made_you_bec... 2012-07-17 16:48:06  \n",
       "475  /r/minimalism/comments/wnwvh/what_made_you_bec... 2012-07-27 01:54:13  \n",
       "\n",
       "[445 rows x 9 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "what_made_you_minimalist_df = what_made_you_minimalist_df[what_made_you_minimalist_df['Post text'] != '[deleted]']\n",
    "what_made_you_minimalist_df = what_made_you_minimalist_df[(what_made_you_minimalist_df['IsPost'] == 'yes')|(~what_made_you_minimalist_df['Comment Author'].duplicated()) | what_made_you_minimalist_df['Comment Author'].isna()]\n",
    "what_made_you_minimalist_df = what_made_you_minimalist_df.drop_duplicates('Post text', keep='first')\n",
    "what_made_you_minimalist_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "results = reddit.subreddit(\"minimalism+Anticonsumption\").search('\"why did you choose\"', sort=\"new\", limit=None)\n",
    "counter = 0\n",
    "\n",
    "column_names = [\"Index\", \"IsPost\", \"Post Author\", \"Subreddit\", \"Post title\", \"Comment Author\", \"Post text\", \"Post URL\", \"Post time\"]\n",
    "\n",
    "posts_table = []\n",
    "\n",
    "for p in results: # p is a reddit post\n",
    "    counter += 1\n",
    "    \n",
    "    # Add the post to the table\n",
    "    posts_table.append([counter, \"yes\", p.author, p.subreddit, p.title, \"none\", p.selftext, p.permalink,\n",
    "                         datetime.utcfromtimestamp(p.created)])\n",
    "    for comment in p.comments:\n",
    "        p.comments.replace_more(limit=500) # retrieve all comments using more API calls if needed\n",
    "        posts_table.append([counter, \"no\", \"\", p.subreddit, \"\", comment.author, comment.body, comment.permalink,\n",
    "                         datetime.utcfromtimestamp(comment.created)])\n",
    "\n",
    "\n",
    "why_did_you_choose_minimalist_df = pd.DataFrame(posts_table, columns=column_names)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "why_did_you_choose_minimalist_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "results = reddit.subreddit(\"minimalism+Anticonsumption\").search('\"what motivated you\"', sort=\"new\", limit=None)\n",
    "counter = 0\n",
    "\n",
    "column_names = [\"Index\", \"IsPost\", \"Post Author\", \"Subreddit\", \"Post title\", \"Comment Author\", \"Post text\", \"Post URL\", \"Post time\"]\n",
    "\n",
    "posts_table = []\n",
    "\n",
    "for p in results: # p is a reddit post\n",
    "    if p.selftext != '[deleted]':\n",
    "        counter += 1\n",
    "        posts_table.append([counter, \"yes\", p.author, p.subreddit, p.title, \"None\", p.selftext, p.permalink,datetime.utcfromtimestamp(p.created)])\n",
    "        for comment in p.comments:\n",
    "            p.comments.replace_more(limit=500) # retrieve all comments using more API calls if needed\n",
    "            posts_table.append([counter, \"no\", \"\", p.subreddit, \"\", comment.author, comment.body, comment.permalink,datetime.utcfromtimestamp(comment.created)])\n",
    "    else:\n",
    "        continue\n",
    "\n",
    "what_motivated_you_minimalist_df = pd.DataFrame(posts_table, columns=column_names)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "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>Index</th>\n",
       "      <th>IsPost</th>\n",
       "      <th>Post Author</th>\n",
       "      <th>Subreddit</th>\n",
       "      <th>Post title</th>\n",
       "      <th>Comment Author</th>\n",
       "      <th>Post text</th>\n",
       "      <th>Post URL</th>\n",
       "      <th>Post time</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>yes</td>\n",
       "      <td>theminimalistwoman</td>\n",
       "      <td>minimalism</td>\n",
       "      <td>What motivates you to stay accountable when yo...</td>\n",
       "      <td>None</td>\n",
       "      <td>For me, it’s a free calendar that keeps me mot...</td>\n",
       "      <td>/r/minimalism/comments/fyi7zc/what_motivates_y...</td>\n",
       "      <td>2020-04-10 15:44:23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>BrokenBrokin</td>\n",
       "      <td>My bank account and investment growth. Minimal...</td>\n",
       "      <td>/r/minimalism/comments/fyi7zc/what_motivates_y...</td>\n",
       "      <td>2020-04-10 15:55:45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td>I like having a clean tidy house. I like havin...</td>\n",
       "      <td>/r/minimalism/comments/fyi7zc/what_motivates_y...</td>\n",
       "      <td>2020-04-10 15:56:44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>odvf</td>\n",
       "      <td>Saving money. And also housechores being easie...</td>\n",
       "      <td>/r/minimalism/comments/fyi7zc/what_motivates_y...</td>\n",
       "      <td>2020-04-10 18:55:11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>hox_blastien</td>\n",
       "      <td>Haha, for me it's remembering coming from a ba...</td>\n",
       "      <td>/r/minimalism/comments/fyi7zc/what_motivates_y...</td>\n",
       "      <td>2020-04-10 21:32:29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>6</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>Anticonsumption</td>\n",
       "      <td></td>\n",
       "      <td>ruminating</td>\n",
       "      <td>All those things to put it short. And I find t...</td>\n",
       "      <td>/r/Anticonsumption/comments/2exnrx/what_motiva...</td>\n",
       "      <td>2014-08-30 06:14:39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>6</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>Anticonsumption</td>\n",
       "      <td></td>\n",
       "      <td>battraman</td>\n",
       "      <td>Basically because I want to live rich and not ...</td>\n",
       "      <td>/r/Anticonsumption/comments/2exnrx/what_motiva...</td>\n",
       "      <td>2014-09-02 14:32:46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129</th>\n",
       "      <td>6</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>Anticonsumption</td>\n",
       "      <td></td>\n",
       "      <td>the_QQ_game</td>\n",
       "      <td>Reducing suffering. The money I don't spend on...</td>\n",
       "      <td>/r/Anticonsumption/comments/2exnrx/what_motiva...</td>\n",
       "      <td>2014-09-02 18:52:33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>130</th>\n",
       "      <td>6</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>Anticonsumption</td>\n",
       "      <td></td>\n",
       "      <td>anachronic</td>\n",
       "      <td>I approach consumption as a utilitarian... wha...</td>\n",
       "      <td>/r/Anticonsumption/comments/2exnrx/what_motiva...</td>\n",
       "      <td>2014-09-05 20:47:28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131</th>\n",
       "      <td>6</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>Anticonsumption</td>\n",
       "      <td></td>\n",
       "      <td>Revolvist</td>\n",
       "      <td>I've gotten to a point where consumerism actua...</td>\n",
       "      <td>/r/Anticonsumption/comments/2exnrx/what_motiva...</td>\n",
       "      <td>2014-09-03 19:05:38</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>132 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Index IsPost         Post Author        Subreddit  \\\n",
       "0        1    yes  theminimalistwoman       minimalism   \n",
       "1        1     no                           minimalism   \n",
       "2        1     no                           minimalism   \n",
       "3        1     no                           minimalism   \n",
       "4        1     no                           minimalism   \n",
       "..     ...    ...                 ...              ...   \n",
       "127      6     no                      Anticonsumption   \n",
       "128      6     no                      Anticonsumption   \n",
       "129      6     no                      Anticonsumption   \n",
       "130      6     no                      Anticonsumption   \n",
       "131      6     no                      Anticonsumption   \n",
       "\n",
       "                                            Post title Comment Author  \\\n",
       "0    What motivates you to stay accountable when yo...           None   \n",
       "1                                                        BrokenBrokin   \n",
       "2                                                                None   \n",
       "3                                                                odvf   \n",
       "4                                                        hox_blastien   \n",
       "..                                                 ...            ...   \n",
       "127                                                        ruminating   \n",
       "128                                                         battraman   \n",
       "129                                                       the_QQ_game   \n",
       "130                                                        anachronic   \n",
       "131                                                         Revolvist   \n",
       "\n",
       "                                             Post text  \\\n",
       "0    For me, it’s a free calendar that keeps me mot...   \n",
       "1    My bank account and investment growth. Minimal...   \n",
       "2    I like having a clean tidy house. I like havin...   \n",
       "3    Saving money. And also housechores being easie...   \n",
       "4    Haha, for me it's remembering coming from a ba...   \n",
       "..                                                 ...   \n",
       "127  All those things to put it short. And I find t...   \n",
       "128  Basically because I want to live rich and not ...   \n",
       "129  Reducing suffering. The money I don't spend on...   \n",
       "130  I approach consumption as a utilitarian... wha...   \n",
       "131  I've gotten to a point where consumerism actua...   \n",
       "\n",
       "                                              Post URL           Post time  \n",
       "0    /r/minimalism/comments/fyi7zc/what_motivates_y... 2020-04-10 15:44:23  \n",
       "1    /r/minimalism/comments/fyi7zc/what_motivates_y... 2020-04-10 15:55:45  \n",
       "2    /r/minimalism/comments/fyi7zc/what_motivates_y... 2020-04-10 15:56:44  \n",
       "3    /r/minimalism/comments/fyi7zc/what_motivates_y... 2020-04-10 18:55:11  \n",
       "4    /r/minimalism/comments/fyi7zc/what_motivates_y... 2020-04-10 21:32:29  \n",
       "..                                                 ...                 ...  \n",
       "127  /r/Anticonsumption/comments/2exnrx/what_motiva... 2014-08-30 06:14:39  \n",
       "128  /r/Anticonsumption/comments/2exnrx/what_motiva... 2014-09-02 14:32:46  \n",
       "129  /r/Anticonsumption/comments/2exnrx/what_motiva... 2014-09-02 18:52:33  \n",
       "130  /r/Anticonsumption/comments/2exnrx/what_motiva... 2014-09-05 20:47:28  \n",
       "131  /r/Anticonsumption/comments/2exnrx/what_motiva... 2014-09-03 19:05:38  \n",
       "\n",
       "[132 rows x 9 columns]"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "what_motivated_you_minimalist_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "what_motivated_you_minimalist = what_motivated_you_minimalist_df[what_motivated_you_minimalist_df['Post text'] != '[deleted]']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "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>Index</th>\n",
       "      <th>IsPost</th>\n",
       "      <th>Post Author</th>\n",
       "      <th>Subreddit</th>\n",
       "      <th>Post title</th>\n",
       "      <th>Comment Author</th>\n",
       "      <th>Post text</th>\n",
       "      <th>Post URL</th>\n",
       "      <th>Post time</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>yes</td>\n",
       "      <td>theminimalistwoman</td>\n",
       "      <td>minimalism</td>\n",
       "      <td>What motivates you to stay accountable when yo...</td>\n",
       "      <td>None</td>\n",
       "      <td>For me, it’s a free calendar that keeps me mot...</td>\n",
       "      <td>/r/minimalism/comments/fyi7zc/what_motivates_y...</td>\n",
       "      <td>2020-04-10 15:44:23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>BrokenBrokin</td>\n",
       "      <td>My bank account and investment growth. Minimal...</td>\n",
       "      <td>/r/minimalism/comments/fyi7zc/what_motivates_y...</td>\n",
       "      <td>2020-04-10 15:55:45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td>I like having a clean tidy house. I like havin...</td>\n",
       "      <td>/r/minimalism/comments/fyi7zc/what_motivates_y...</td>\n",
       "      <td>2020-04-10 15:56:44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>odvf</td>\n",
       "      <td>Saving money. And also housechores being easie...</td>\n",
       "      <td>/r/minimalism/comments/fyi7zc/what_motivates_y...</td>\n",
       "      <td>2020-04-10 18:55:11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>hox_blastien</td>\n",
       "      <td>Haha, for me it's remembering coming from a ba...</td>\n",
       "      <td>/r/minimalism/comments/fyi7zc/what_motivates_y...</td>\n",
       "      <td>2020-04-10 21:32:29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>6</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>Anticonsumption</td>\n",
       "      <td></td>\n",
       "      <td>ruminating</td>\n",
       "      <td>All those things to put it short. And I find t...</td>\n",
       "      <td>/r/Anticonsumption/comments/2exnrx/what_motiva...</td>\n",
       "      <td>2014-08-30 06:14:39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>6</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>Anticonsumption</td>\n",
       "      <td></td>\n",
       "      <td>battraman</td>\n",
       "      <td>Basically because I want to live rich and not ...</td>\n",
       "      <td>/r/Anticonsumption/comments/2exnrx/what_motiva...</td>\n",
       "      <td>2014-09-02 14:32:46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129</th>\n",
       "      <td>6</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>Anticonsumption</td>\n",
       "      <td></td>\n",
       "      <td>the_QQ_game</td>\n",
       "      <td>Reducing suffering. The money I don't spend on...</td>\n",
       "      <td>/r/Anticonsumption/comments/2exnrx/what_motiva...</td>\n",
       "      <td>2014-09-02 18:52:33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>130</th>\n",
       "      <td>6</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>Anticonsumption</td>\n",
       "      <td></td>\n",
       "      <td>anachronic</td>\n",
       "      <td>I approach consumption as a utilitarian... wha...</td>\n",
       "      <td>/r/Anticonsumption/comments/2exnrx/what_motiva...</td>\n",
       "      <td>2014-09-05 20:47:28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131</th>\n",
       "      <td>6</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>Anticonsumption</td>\n",
       "      <td></td>\n",
       "      <td>Revolvist</td>\n",
       "      <td>I've gotten to a point where consumerism actua...</td>\n",
       "      <td>/r/Anticonsumption/comments/2exnrx/what_motiva...</td>\n",
       "      <td>2014-09-03 19:05:38</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>126 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Index IsPost         Post Author        Subreddit  \\\n",
       "0        1    yes  theminimalistwoman       minimalism   \n",
       "1        1     no                           minimalism   \n",
       "2        1     no                           minimalism   \n",
       "3        1     no                           minimalism   \n",
       "4        1     no                           minimalism   \n",
       "..     ...    ...                 ...              ...   \n",
       "127      6     no                      Anticonsumption   \n",
       "128      6     no                      Anticonsumption   \n",
       "129      6     no                      Anticonsumption   \n",
       "130      6     no                      Anticonsumption   \n",
       "131      6     no                      Anticonsumption   \n",
       "\n",
       "                                            Post title Comment Author  \\\n",
       "0    What motivates you to stay accountable when yo...           None   \n",
       "1                                                        BrokenBrokin   \n",
       "2                                                                None   \n",
       "3                                                                odvf   \n",
       "4                                                        hox_blastien   \n",
       "..                                                 ...            ...   \n",
       "127                                                        ruminating   \n",
       "128                                                         battraman   \n",
       "129                                                       the_QQ_game   \n",
       "130                                                        anachronic   \n",
       "131                                                         Revolvist   \n",
       "\n",
       "                                             Post text  \\\n",
       "0    For me, it’s a free calendar that keeps me mot...   \n",
       "1    My bank account and investment growth. Minimal...   \n",
       "2    I like having a clean tidy house. I like havin...   \n",
       "3    Saving money. And also housechores being easie...   \n",
       "4    Haha, for me it's remembering coming from a ba...   \n",
       "..                                                 ...   \n",
       "127  All those things to put it short. And I find t...   \n",
       "128  Basically because I want to live rich and not ...   \n",
       "129  Reducing suffering. The money I don't spend on...   \n",
       "130  I approach consumption as a utilitarian... wha...   \n",
       "131  I've gotten to a point where consumerism actua...   \n",
       "\n",
       "                                              Post URL           Post time  \n",
       "0    /r/minimalism/comments/fyi7zc/what_motivates_y... 2020-04-10 15:44:23  \n",
       "1    /r/minimalism/comments/fyi7zc/what_motivates_y... 2020-04-10 15:55:45  \n",
       "2    /r/minimalism/comments/fyi7zc/what_motivates_y... 2020-04-10 15:56:44  \n",
       "3    /r/minimalism/comments/fyi7zc/what_motivates_y... 2020-04-10 18:55:11  \n",
       "4    /r/minimalism/comments/fyi7zc/what_motivates_y... 2020-04-10 21:32:29  \n",
       "..                                                 ...                 ...  \n",
       "127  /r/Anticonsumption/comments/2exnrx/what_motiva... 2014-08-30 06:14:39  \n",
       "128  /r/Anticonsumption/comments/2exnrx/what_motiva... 2014-09-02 14:32:46  \n",
       "129  /r/Anticonsumption/comments/2exnrx/what_motiva... 2014-09-02 18:52:33  \n",
       "130  /r/Anticonsumption/comments/2exnrx/what_motiva... 2014-09-05 20:47:28  \n",
       "131  /r/Anticonsumption/comments/2exnrx/what_motiva... 2014-09-03 19:05:38  \n",
       "\n",
       "[126 rows x 9 columns]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "what_motivated_you_minimalist"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "what_motivated_you_minimalist = what_motivated_you_minimalist[(what_motivated_you_minimalist['IsPost'] == 'yes')|(~what_motivated_you_minimalist['Comment Author'].duplicated()) | what_motivated_you_minimalist['Comment Author'].isna()]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "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>Index</th>\n",
       "      <th>IsPost</th>\n",
       "      <th>Post Author</th>\n",
       "      <th>Subreddit</th>\n",
       "      <th>Post title</th>\n",
       "      <th>Comment Author</th>\n",
       "      <th>Post text</th>\n",
       "      <th>Post URL</th>\n",
       "      <th>Post time</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>yes</td>\n",
       "      <td>theminimalistwoman</td>\n",
       "      <td>minimalism</td>\n",
       "      <td>What motivates you to stay accountable when yo...</td>\n",
       "      <td>None</td>\n",
       "      <td>For me, it’s a free calendar that keeps me mot...</td>\n",
       "      <td>/r/minimalism/comments/fyi7zc/what_motivates_y...</td>\n",
       "      <td>2020-04-10 15:44:23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>BrokenBrokin</td>\n",
       "      <td>My bank account and investment growth. Minimal...</td>\n",
       "      <td>/r/minimalism/comments/fyi7zc/what_motivates_y...</td>\n",
       "      <td>2020-04-10 15:55:45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td>I like having a clean tidy house. I like havin...</td>\n",
       "      <td>/r/minimalism/comments/fyi7zc/what_motivates_y...</td>\n",
       "      <td>2020-04-10 15:56:44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>odvf</td>\n",
       "      <td>Saving money. And also housechores being easie...</td>\n",
       "      <td>/r/minimalism/comments/fyi7zc/what_motivates_y...</td>\n",
       "      <td>2020-04-10 18:55:11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>hox_blastien</td>\n",
       "      <td>Haha, for me it's remembering coming from a ba...</td>\n",
       "      <td>/r/minimalism/comments/fyi7zc/what_motivates_y...</td>\n",
       "      <td>2020-04-10 21:32:29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>6</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>Anticonsumption</td>\n",
       "      <td></td>\n",
       "      <td>GreatAndRandom</td>\n",
       "      <td>When I realize I just made a bad purchase.</td>\n",
       "      <td>/r/Anticonsumption/comments/2exnrx/what_motiva...</td>\n",
       "      <td>2014-08-30 01:57:43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>6</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>Anticonsumption</td>\n",
       "      <td></td>\n",
       "      <td>ruminating</td>\n",
       "      <td>All those things to put it short. And I find t...</td>\n",
       "      <td>/r/Anticonsumption/comments/2exnrx/what_motiva...</td>\n",
       "      <td>2014-08-30 06:14:39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>6</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>Anticonsumption</td>\n",
       "      <td></td>\n",
       "      <td>battraman</td>\n",
       "      <td>Basically because I want to live rich and not ...</td>\n",
       "      <td>/r/Anticonsumption/comments/2exnrx/what_motiva...</td>\n",
       "      <td>2014-09-02 14:32:46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129</th>\n",
       "      <td>6</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>Anticonsumption</td>\n",
       "      <td></td>\n",
       "      <td>the_QQ_game</td>\n",
       "      <td>Reducing suffering. The money I don't spend on...</td>\n",
       "      <td>/r/Anticonsumption/comments/2exnrx/what_motiva...</td>\n",
       "      <td>2014-09-02 18:52:33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131</th>\n",
       "      <td>6</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>Anticonsumption</td>\n",
       "      <td></td>\n",
       "      <td>Revolvist</td>\n",
       "      <td>I've gotten to a point where consumerism actua...</td>\n",
       "      <td>/r/Anticonsumption/comments/2exnrx/what_motiva...</td>\n",
       "      <td>2014-09-03 19:05:38</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>124 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Index IsPost         Post Author        Subreddit  \\\n",
       "0        1    yes  theminimalistwoman       minimalism   \n",
       "1        1     no                           minimalism   \n",
       "2        1     no                           minimalism   \n",
       "3        1     no                           minimalism   \n",
       "4        1     no                           minimalism   \n",
       "..     ...    ...                 ...              ...   \n",
       "126      6     no                      Anticonsumption   \n",
       "127      6     no                      Anticonsumption   \n",
       "128      6     no                      Anticonsumption   \n",
       "129      6     no                      Anticonsumption   \n",
       "131      6     no                      Anticonsumption   \n",
       "\n",
       "                                            Post title  Comment Author  \\\n",
       "0    What motivates you to stay accountable when yo...            None   \n",
       "1                                                         BrokenBrokin   \n",
       "2                                                                 None   \n",
       "3                                                                 odvf   \n",
       "4                                                         hox_blastien   \n",
       "..                                                 ...             ...   \n",
       "126                                                     GreatAndRandom   \n",
       "127                                                         ruminating   \n",
       "128                                                          battraman   \n",
       "129                                                        the_QQ_game   \n",
       "131                                                          Revolvist   \n",
       "\n",
       "                                             Post text  \\\n",
       "0    For me, it’s a free calendar that keeps me mot...   \n",
       "1    My bank account and investment growth. Minimal...   \n",
       "2    I like having a clean tidy house. I like havin...   \n",
       "3    Saving money. And also housechores being easie...   \n",
       "4    Haha, for me it's remembering coming from a ba...   \n",
       "..                                                 ...   \n",
       "126        When I realize I just made a bad purchase.    \n",
       "127  All those things to put it short. And I find t...   \n",
       "128  Basically because I want to live rich and not ...   \n",
       "129  Reducing suffering. The money I don't spend on...   \n",
       "131  I've gotten to a point where consumerism actua...   \n",
       "\n",
       "                                              Post URL           Post time  \n",
       "0    /r/minimalism/comments/fyi7zc/what_motivates_y... 2020-04-10 15:44:23  \n",
       "1    /r/minimalism/comments/fyi7zc/what_motivates_y... 2020-04-10 15:55:45  \n",
       "2    /r/minimalism/comments/fyi7zc/what_motivates_y... 2020-04-10 15:56:44  \n",
       "3    /r/minimalism/comments/fyi7zc/what_motivates_y... 2020-04-10 18:55:11  \n",
       "4    /r/minimalism/comments/fyi7zc/what_motivates_y... 2020-04-10 21:32:29  \n",
       "..                                                 ...                 ...  \n",
       "126  /r/Anticonsumption/comments/2exnrx/what_motiva... 2014-08-30 01:57:43  \n",
       "127  /r/Anticonsumption/comments/2exnrx/what_motiva... 2014-08-30 06:14:39  \n",
       "128  /r/Anticonsumption/comments/2exnrx/what_motiva... 2014-09-02 14:32:46  \n",
       "129  /r/Anticonsumption/comments/2exnrx/what_motiva... 2014-09-02 18:52:33  \n",
       "131  /r/Anticonsumption/comments/2exnrx/what_motiva... 2014-09-03 19:05:38  \n",
       "\n",
       "[124 rows x 9 columns]"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "what_motivated_you_minimalist"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "what_motivated_you_minimalist = what_motivated_you_minimalist.drop_duplicates('Post text', keep='first')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "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>Index</th>\n",
       "      <th>IsPost</th>\n",
       "      <th>Post Author</th>\n",
       "      <th>Subreddit</th>\n",
       "      <th>Post title</th>\n",
       "      <th>Comment Author</th>\n",
       "      <th>Post text</th>\n",
       "      <th>Post URL</th>\n",
       "      <th>Post time</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>yes</td>\n",
       "      <td>theminimalistwoman</td>\n",
       "      <td>minimalism</td>\n",
       "      <td>What motivates you to stay accountable when yo...</td>\n",
       "      <td>None</td>\n",
       "      <td>For me, it’s a free calendar that keeps me mot...</td>\n",
       "      <td>/r/minimalism/comments/fyi7zc/what_motivates_y...</td>\n",
       "      <td>2020-04-10 15:44:23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>BrokenBrokin</td>\n",
       "      <td>My bank account and investment growth. Minimal...</td>\n",
       "      <td>/r/minimalism/comments/fyi7zc/what_motivates_y...</td>\n",
       "      <td>2020-04-10 15:55:45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td>I like having a clean tidy house. I like havin...</td>\n",
       "      <td>/r/minimalism/comments/fyi7zc/what_motivates_y...</td>\n",
       "      <td>2020-04-10 15:56:44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>odvf</td>\n",
       "      <td>Saving money. And also housechores being easie...</td>\n",
       "      <td>/r/minimalism/comments/fyi7zc/what_motivates_y...</td>\n",
       "      <td>2020-04-10 18:55:11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>hox_blastien</td>\n",
       "      <td>Haha, for me it's remembering coming from a ba...</td>\n",
       "      <td>/r/minimalism/comments/fyi7zc/what_motivates_y...</td>\n",
       "      <td>2020-04-10 21:32:29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>6</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>Anticonsumption</td>\n",
       "      <td></td>\n",
       "      <td>GreatAndRandom</td>\n",
       "      <td>When I realize I just made a bad purchase.</td>\n",
       "      <td>/r/Anticonsumption/comments/2exnrx/what_motiva...</td>\n",
       "      <td>2014-08-30 01:57:43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>6</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>Anticonsumption</td>\n",
       "      <td></td>\n",
       "      <td>ruminating</td>\n",
       "      <td>All those things to put it short. And I find t...</td>\n",
       "      <td>/r/Anticonsumption/comments/2exnrx/what_motiva...</td>\n",
       "      <td>2014-08-30 06:14:39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>6</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>Anticonsumption</td>\n",
       "      <td></td>\n",
       "      <td>battraman</td>\n",
       "      <td>Basically because I want to live rich and not ...</td>\n",
       "      <td>/r/Anticonsumption/comments/2exnrx/what_motiva...</td>\n",
       "      <td>2014-09-02 14:32:46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129</th>\n",
       "      <td>6</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>Anticonsumption</td>\n",
       "      <td></td>\n",
       "      <td>the_QQ_game</td>\n",
       "      <td>Reducing suffering. The money I don't spend on...</td>\n",
       "      <td>/r/Anticonsumption/comments/2exnrx/what_motiva...</td>\n",
       "      <td>2014-09-02 18:52:33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131</th>\n",
       "      <td>6</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>Anticonsumption</td>\n",
       "      <td></td>\n",
       "      <td>Revolvist</td>\n",
       "      <td>I've gotten to a point where consumerism actua...</td>\n",
       "      <td>/r/Anticonsumption/comments/2exnrx/what_motiva...</td>\n",
       "      <td>2014-09-03 19:05:38</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>124 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Index IsPost         Post Author        Subreddit  \\\n",
       "0        1    yes  theminimalistwoman       minimalism   \n",
       "1        1     no                           minimalism   \n",
       "2        1     no                           minimalism   \n",
       "3        1     no                           minimalism   \n",
       "4        1     no                           minimalism   \n",
       "..     ...    ...                 ...              ...   \n",
       "126      6     no                      Anticonsumption   \n",
       "127      6     no                      Anticonsumption   \n",
       "128      6     no                      Anticonsumption   \n",
       "129      6     no                      Anticonsumption   \n",
       "131      6     no                      Anticonsumption   \n",
       "\n",
       "                                            Post title  Comment Author  \\\n",
       "0    What motivates you to stay accountable when yo...            None   \n",
       "1                                                         BrokenBrokin   \n",
       "2                                                                 None   \n",
       "3                                                                 odvf   \n",
       "4                                                         hox_blastien   \n",
       "..                                                 ...             ...   \n",
       "126                                                     GreatAndRandom   \n",
       "127                                                         ruminating   \n",
       "128                                                          battraman   \n",
       "129                                                        the_QQ_game   \n",
       "131                                                          Revolvist   \n",
       "\n",
       "                                             Post text  \\\n",
       "0    For me, it’s a free calendar that keeps me mot...   \n",
       "1    My bank account and investment growth. Minimal...   \n",
       "2    I like having a clean tidy house. I like havin...   \n",
       "3    Saving money. And also housechores being easie...   \n",
       "4    Haha, for me it's remembering coming from a ba...   \n",
       "..                                                 ...   \n",
       "126        When I realize I just made a bad purchase.    \n",
       "127  All those things to put it short. And I find t...   \n",
       "128  Basically because I want to live rich and not ...   \n",
       "129  Reducing suffering. The money I don't spend on...   \n",
       "131  I've gotten to a point where consumerism actua...   \n",
       "\n",
       "                                              Post URL           Post time  \n",
       "0    /r/minimalism/comments/fyi7zc/what_motivates_y... 2020-04-10 15:44:23  \n",
       "1    /r/minimalism/comments/fyi7zc/what_motivates_y... 2020-04-10 15:55:45  \n",
       "2    /r/minimalism/comments/fyi7zc/what_motivates_y... 2020-04-10 15:56:44  \n",
       "3    /r/minimalism/comments/fyi7zc/what_motivates_y... 2020-04-10 18:55:11  \n",
       "4    /r/minimalism/comments/fyi7zc/what_motivates_y... 2020-04-10 21:32:29  \n",
       "..                                                 ...                 ...  \n",
       "126  /r/Anticonsumption/comments/2exnrx/what_motiva... 2014-08-30 01:57:43  \n",
       "127  /r/Anticonsumption/comments/2exnrx/what_motiva... 2014-08-30 06:14:39  \n",
       "128  /r/Anticonsumption/comments/2exnrx/what_motiva... 2014-09-02 14:32:46  \n",
       "129  /r/Anticonsumption/comments/2exnrx/what_motiva... 2014-09-02 18:52:33  \n",
       "131  /r/Anticonsumption/comments/2exnrx/what_motiva... 2014-09-03 19:05:38  \n",
       "\n",
       "[124 rows x 9 columns]"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "what_motivated_you_minimalist"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "#what_motivated_you_minimalist.to_csv(\"what_motivated_you_minimalist.csv\", index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [],
   "source": [
    "results = reddit.subreddit(\"vegan\").search('\"what motivated you\"', sort=\"new\", limit=None)\n",
    "counter = 0\n",
    "\n",
    "column_names = [\"Index\", \"IsPost\", \"Post Author\", \"Subreddit\", \"Post title\", \"Comment Author\", \"Post text\", \"Post URL\", \"Post time\"]\n",
    "\n",
    "posts_table = []\n",
    "\n",
    "for p in results: # p is a reddit post\n",
    "    counter += 1\n",
    "    \n",
    "    # Add the post to the table\n",
    "    posts_table.append([counter, \"yes\", p.author, p.subreddit, p.title, \"none\", p.selftext, p.permalink,\n",
    "                         datetime.utcfromtimestamp(p.created)])\n",
    "    for comment in p.comments:\n",
    "        p.comments.replace_more(limit=500) # retrieve all comments using more API calls if needed\n",
    "        posts_table.append([counter, \"no\", \"\", p.subreddit, \"\", comment.author, comment.body, comment.permalink,\n",
    "                         datetime.utcfromtimestamp(comment.created)])\n",
    "\n",
    "\n",
    "what_motivated_you_vegan = pd.DataFrame(posts_table, columns=column_names)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "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>Index</th>\n",
       "      <th>IsPost</th>\n",
       "      <th>Post Author</th>\n",
       "      <th>Subreddit</th>\n",
       "      <th>Post title</th>\n",
       "      <th>Comment Author</th>\n",
       "      <th>Post text</th>\n",
       "      <th>Post URL</th>\n",
       "      <th>Post time</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>yes</td>\n",
       "      <td>kaliumhydroxide</td>\n",
       "      <td>vegan</td>\n",
       "      <td>Hey there, tell me a story on how you start on...</td>\n",
       "      <td>none</td>\n",
       "      <td>like what motivates you to become vegan, and w...</td>\n",
       "      <td>/r/vegan/comments/nrf2zv/hey_there_tell_me_a_s...</td>\n",
       "      <td>2021-06-03 14:40:11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td>I saw some information about vivisection Peta ...</td>\n",
       "      <td>/r/vegan/comments/nrf2zv/hey_there_tell_me_a_s...</td>\n",
       "      <td>2021-06-03 17:46:19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>KoYouTokuIngoa</td>\n",
       "      <td>Went vegan after watching a few documentaries ...</td>\n",
       "      <td>/r/vegan/comments/nrf2zv/hey_there_tell_me_a_s...</td>\n",
       "      <td>2021-06-03 19:48:45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>Caffeineandsesame</td>\n",
       "      <td>Seeing my step dad get have to get colon surge...</td>\n",
       "      <td>/r/vegan/comments/nrf2zv/hey_there_tell_me_a_s...</td>\n",
       "      <td>2021-06-04 06:02:08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>Available_Suit_5414</td>\n",
       "      <td>Earthling Ed and Game changers turned me vegan...</td>\n",
       "      <td>/r/vegan/comments/nrf2zv/hey_there_tell_me_a_s...</td>\n",
       "      <td>2021-06-04 11:38:02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>7</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>snowflake25911</td>\n",
       "      <td>This is more advice than a convincing argument...</td>\n",
       "      <td>/r/vegan/comments/5gb9oe/convince_me_to_become...</td>\n",
       "      <td>2016-12-04 20:06:05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>7</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>Dydomite</td>\n",
       "      <td>For what it's worth, I found after I switched ...</td>\n",
       "      <td>/r/vegan/comments/5gb9oe/convince_me_to_become...</td>\n",
       "      <td>2016-12-04 06:08:46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>7</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>Xilmi</td>\n",
       "      <td>Do you consider your reasons to not be vegan m...</td>\n",
       "      <td>/r/vegan/comments/5gb9oe/convince_me_to_become...</td>\n",
       "      <td>2016-12-04 08:50:36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>7</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>Shadaez</td>\n",
       "      <td>I didn't find it hard at all to switch, faux m...</td>\n",
       "      <td>/r/vegan/comments/5gb9oe/convince_me_to_become...</td>\n",
       "      <td>2016-12-04 13:03:49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>7</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>SammilovesShadow408</td>\n",
       "      <td>Going on a plant based diet AND exercising dai...</td>\n",
       "      <td>/r/vegan/comments/5gb9oe/convince_me_to_become...</td>\n",
       "      <td>2016-12-04 02:16:04</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>63 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Index IsPost      Post Author Subreddit  \\\n",
       "0       1    yes  kaliumhydroxide     vegan   \n",
       "1       1     no                      vegan   \n",
       "2       1     no                      vegan   \n",
       "3       1     no                      vegan   \n",
       "4       1     no                      vegan   \n",
       "..    ...    ...              ...       ...   \n",
       "58      7     no                      vegan   \n",
       "59      7     no                      vegan   \n",
       "60      7     no                      vegan   \n",
       "61      7     no                      vegan   \n",
       "62      7     no                      vegan   \n",
       "\n",
       "                                           Post title       Comment Author  \\\n",
       "0   Hey there, tell me a story on how you start on...                 none   \n",
       "1                                                                     None   \n",
       "2                                                           KoYouTokuIngoa   \n",
       "3                                                        Caffeineandsesame   \n",
       "4                                                      Available_Suit_5414   \n",
       "..                                                ...                  ...   \n",
       "58                                                          snowflake25911   \n",
       "59                                                                Dydomite   \n",
       "60                                                                   Xilmi   \n",
       "61                                                                 Shadaez   \n",
       "62                                                     SammilovesShadow408   \n",
       "\n",
       "                                            Post text  \\\n",
       "0   like what motivates you to become vegan, and w...   \n",
       "1   I saw some information about vivisection Peta ...   \n",
       "2   Went vegan after watching a few documentaries ...   \n",
       "3   Seeing my step dad get have to get colon surge...   \n",
       "4   Earthling Ed and Game changers turned me vegan...   \n",
       "..                                                ...   \n",
       "58  This is more advice than a convincing argument...   \n",
       "59  For what it's worth, I found after I switched ...   \n",
       "60  Do you consider your reasons to not be vegan m...   \n",
       "61  I didn't find it hard at all to switch, faux m...   \n",
       "62  Going on a plant based diet AND exercising dai...   \n",
       "\n",
       "                                             Post URL           Post time  \n",
       "0   /r/vegan/comments/nrf2zv/hey_there_tell_me_a_s... 2021-06-03 14:40:11  \n",
       "1   /r/vegan/comments/nrf2zv/hey_there_tell_me_a_s... 2021-06-03 17:46:19  \n",
       "2   /r/vegan/comments/nrf2zv/hey_there_tell_me_a_s... 2021-06-03 19:48:45  \n",
       "3   /r/vegan/comments/nrf2zv/hey_there_tell_me_a_s... 2021-06-04 06:02:08  \n",
       "4   /r/vegan/comments/nrf2zv/hey_there_tell_me_a_s... 2021-06-04 11:38:02  \n",
       "..                                                ...                 ...  \n",
       "58  /r/vegan/comments/5gb9oe/convince_me_to_become... 2016-12-04 20:06:05  \n",
       "59  /r/vegan/comments/5gb9oe/convince_me_to_become... 2016-12-04 06:08:46  \n",
       "60  /r/vegan/comments/5gb9oe/convince_me_to_become... 2016-12-04 08:50:36  \n",
       "61  /r/vegan/comments/5gb9oe/convince_me_to_become... 2016-12-04 13:03:49  \n",
       "62  /r/vegan/comments/5gb9oe/convince_me_to_become... 2016-12-04 02:16:04  \n",
       "\n",
       "[63 rows x 9 columns]"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "what_motivated_you_vegan"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "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>Index</th>\n",
       "      <th>IsPost</th>\n",
       "      <th>Post Author</th>\n",
       "      <th>Subreddit</th>\n",
       "      <th>Post title</th>\n",
       "      <th>Comment Author</th>\n",
       "      <th>Post text</th>\n",
       "      <th>Post URL</th>\n",
       "      <th>Post time</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>yes</td>\n",
       "      <td>kaliumhydroxide</td>\n",
       "      <td>vegan</td>\n",
       "      <td>Hey there, tell me a story on how you start on...</td>\n",
       "      <td>none</td>\n",
       "      <td>like what motivates you to become vegan, and w...</td>\n",
       "      <td>/r/vegan/comments/nrf2zv/hey_there_tell_me_a_s...</td>\n",
       "      <td>2021-06-03 14:40:11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td>I saw some information about vivisection Peta ...</td>\n",
       "      <td>/r/vegan/comments/nrf2zv/hey_there_tell_me_a_s...</td>\n",
       "      <td>2021-06-03 17:46:19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>KoYouTokuIngoa</td>\n",
       "      <td>Went vegan after watching a few documentaries ...</td>\n",
       "      <td>/r/vegan/comments/nrf2zv/hey_there_tell_me_a_s...</td>\n",
       "      <td>2021-06-03 19:48:45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>Caffeineandsesame</td>\n",
       "      <td>Seeing my step dad get have to get colon surge...</td>\n",
       "      <td>/r/vegan/comments/nrf2zv/hey_there_tell_me_a_s...</td>\n",
       "      <td>2021-06-04 06:02:08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>Available_Suit_5414</td>\n",
       "      <td>Earthling Ed and Game changers turned me vegan...</td>\n",
       "      <td>/r/vegan/comments/nrf2zv/hey_there_tell_me_a_s...</td>\n",
       "      <td>2021-06-04 11:38:02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>7</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td>You came here asking for help because you want...</td>\n",
       "      <td>/r/vegan/comments/5gb9oe/convince_me_to_become...</td>\n",
       "      <td>2016-12-04 00:05:11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>7</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>snowflake25911</td>\n",
       "      <td>This is more advice than a convincing argument...</td>\n",
       "      <td>/r/vegan/comments/5gb9oe/convince_me_to_become...</td>\n",
       "      <td>2016-12-04 20:06:05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>7</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>Dydomite</td>\n",
       "      <td>For what it's worth, I found after I switched ...</td>\n",
       "      <td>/r/vegan/comments/5gb9oe/convince_me_to_become...</td>\n",
       "      <td>2016-12-04 06:08:46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>7</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>Shadaez</td>\n",
       "      <td>I didn't find it hard at all to switch, faux m...</td>\n",
       "      <td>/r/vegan/comments/5gb9oe/convince_me_to_become...</td>\n",
       "      <td>2016-12-04 13:03:49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>7</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>SammilovesShadow408</td>\n",
       "      <td>Going on a plant based diet AND exercising dai...</td>\n",
       "      <td>/r/vegan/comments/5gb9oe/convince_me_to_become...</td>\n",
       "      <td>2016-12-04 02:16:04</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>61 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Index IsPost      Post Author Subreddit  \\\n",
       "0       1    yes  kaliumhydroxide     vegan   \n",
       "1       1     no                      vegan   \n",
       "2       1     no                      vegan   \n",
       "3       1     no                      vegan   \n",
       "4       1     no                      vegan   \n",
       "..    ...    ...              ...       ...   \n",
       "57      7     no                      vegan   \n",
       "58      7     no                      vegan   \n",
       "59      7     no                      vegan   \n",
       "61      7     no                      vegan   \n",
       "62      7     no                      vegan   \n",
       "\n",
       "                                           Post title       Comment Author  \\\n",
       "0   Hey there, tell me a story on how you start on...                 none   \n",
       "1                                                                     None   \n",
       "2                                                           KoYouTokuIngoa   \n",
       "3                                                        Caffeineandsesame   \n",
       "4                                                      Available_Suit_5414   \n",
       "..                                                ...                  ...   \n",
       "57                                                                    None   \n",
       "58                                                          snowflake25911   \n",
       "59                                                                Dydomite   \n",
       "61                                                                 Shadaez   \n",
       "62                                                     SammilovesShadow408   \n",
       "\n",
       "                                            Post text  \\\n",
       "0   like what motivates you to become vegan, and w...   \n",
       "1   I saw some information about vivisection Peta ...   \n",
       "2   Went vegan after watching a few documentaries ...   \n",
       "3   Seeing my step dad get have to get colon surge...   \n",
       "4   Earthling Ed and Game changers turned me vegan...   \n",
       "..                                                ...   \n",
       "57  You came here asking for help because you want...   \n",
       "58  This is more advice than a convincing argument...   \n",
       "59  For what it's worth, I found after I switched ...   \n",
       "61  I didn't find it hard at all to switch, faux m...   \n",
       "62  Going on a plant based diet AND exercising dai...   \n",
       "\n",
       "                                             Post URL           Post time  \n",
       "0   /r/vegan/comments/nrf2zv/hey_there_tell_me_a_s... 2021-06-03 14:40:11  \n",
       "1   /r/vegan/comments/nrf2zv/hey_there_tell_me_a_s... 2021-06-03 17:46:19  \n",
       "2   /r/vegan/comments/nrf2zv/hey_there_tell_me_a_s... 2021-06-03 19:48:45  \n",
       "3   /r/vegan/comments/nrf2zv/hey_there_tell_me_a_s... 2021-06-04 06:02:08  \n",
       "4   /r/vegan/comments/nrf2zv/hey_there_tell_me_a_s... 2021-06-04 11:38:02  \n",
       "..                                                ...                 ...  \n",
       "57  /r/vegan/comments/5gb9oe/convince_me_to_become... 2016-12-04 00:05:11  \n",
       "58  /r/vegan/comments/5gb9oe/convince_me_to_become... 2016-12-04 20:06:05  \n",
       "59  /r/vegan/comments/5gb9oe/convince_me_to_become... 2016-12-04 06:08:46  \n",
       "61  /r/vegan/comments/5gb9oe/convince_me_to_become... 2016-12-04 13:03:49  \n",
       "62  /r/vegan/comments/5gb9oe/convince_me_to_become... 2016-12-04 02:16:04  \n",
       "\n",
       "[61 rows x 9 columns]"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "what_motivated_you_vegan = what_motivated_you_vegan[what_motivated_you_vegan['Post text'] != '[deleted]']\n",
    "what_motivated_you_vegan = what_motivated_you_vegan[(what_motivated_you_vegan['IsPost'] == 'yes')|(~what_motivated_you_vegan['Comment Author'].duplicated()) | what_motivated_you_vegan['Comment Author'].isna()]\n",
    "what_motivated_you_vegan = what_motivated_you_vegan.drop_duplicates('Post text', keep='first')\n",
    "what_motivated_you_vegan"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [],
   "source": [
    "#what_motivated_you_vegan.to_csv(\"what_motivated_you_vegan.csv\", index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [],
   "source": [
    "minimalism_frames = [what_motivated_you_minimalist, what_made_you_minimalist_df]\n",
    "\n",
    "minimalism_motives = pd.concat(minimalism_frames,ignore_index=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "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>Index</th>\n",
       "      <th>IsPost</th>\n",
       "      <th>Post Author</th>\n",
       "      <th>Subreddit</th>\n",
       "      <th>Post title</th>\n",
       "      <th>Comment Author</th>\n",
       "      <th>Post text</th>\n",
       "      <th>Post URL</th>\n",
       "      <th>Post time</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>yes</td>\n",
       "      <td>theminimalistwoman</td>\n",
       "      <td>minimalism</td>\n",
       "      <td>What motivates you to stay accountable when yo...</td>\n",
       "      <td>None</td>\n",
       "      <td>For me, it’s a free calendar that keeps me mot...</td>\n",
       "      <td>/r/minimalism/comments/fyi7zc/what_motivates_y...</td>\n",
       "      <td>2020-04-10 15:44:23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>BrokenBrokin</td>\n",
       "      <td>My bank account and investment growth. Minimal...</td>\n",
       "      <td>/r/minimalism/comments/fyi7zc/what_motivates_y...</td>\n",
       "      <td>2020-04-10 15:55:45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td>I like having a clean tidy house. I like havin...</td>\n",
       "      <td>/r/minimalism/comments/fyi7zc/what_motivates_y...</td>\n",
       "      <td>2020-04-10 15:56:44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>odvf</td>\n",
       "      <td>Saving money. And also housechores being easie...</td>\n",
       "      <td>/r/minimalism/comments/fyi7zc/what_motivates_y...</td>\n",
       "      <td>2020-04-10 18:55:11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>hox_blastien</td>\n",
       "      <td>Haha, for me it's remembering coming from a ba...</td>\n",
       "      <td>/r/minimalism/comments/fyi7zc/what_motivates_y...</td>\n",
       "      <td>2020-04-10 21:32:29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>564</th>\n",
       "      <td>19</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td>Roaches.</td>\n",
       "      <td>/r/minimalism/comments/wnwvh/what_made_you_bec...</td>\n",
       "      <td>2012-07-18 10:09:32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>565</th>\n",
       "      <td>19</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td>Control. I grew up surrounded by hoarded posse...</td>\n",
       "      <td>/r/minimalism/comments/wnwvh/what_made_you_bec...</td>\n",
       "      <td>2012-07-17 16:54:39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>566</th>\n",
       "      <td>19</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>pigganon</td>\n",
       "      <td>The freedom to get up and move if you want/nee...</td>\n",
       "      <td>/r/minimalism/comments/wnwvh/what_made_you_bec...</td>\n",
       "      <td>2012-07-18 05:46:42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>567</th>\n",
       "      <td>19</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td>I don't think I consciously decided to \"become...</td>\n",
       "      <td>/r/minimalism/comments/wnwvh/what_made_you_bec...</td>\n",
       "      <td>2012-07-17 16:48:06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>568</th>\n",
       "      <td>19</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td>I was struggling with depression and was strug...</td>\n",
       "      <td>/r/minimalism/comments/wnwvh/what_made_you_bec...</td>\n",
       "      <td>2012-07-27 01:54:13</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>565 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Index IsPost         Post Author   Subreddit  \\\n",
       "0        1    yes  theminimalistwoman  minimalism   \n",
       "1        1     no                      minimalism   \n",
       "2        1     no                      minimalism   \n",
       "3        1     no                      minimalism   \n",
       "4        1     no                      minimalism   \n",
       "..     ...    ...                 ...         ...   \n",
       "564     19     no                      minimalism   \n",
       "565     19     no                      minimalism   \n",
       "566     19     no                      minimalism   \n",
       "567     19     no                      minimalism   \n",
       "568     19     no                      minimalism   \n",
       "\n",
       "                                            Post title Comment Author  \\\n",
       "0    What motivates you to stay accountable when yo...           None   \n",
       "1                                                        BrokenBrokin   \n",
       "2                                                                None   \n",
       "3                                                                odvf   \n",
       "4                                                        hox_blastien   \n",
       "..                                                 ...            ...   \n",
       "564                                                              None   \n",
       "565                                                              None   \n",
       "566                                                          pigganon   \n",
       "567                                                              None   \n",
       "568                                                              None   \n",
       "\n",
       "                                             Post text  \\\n",
       "0    For me, it’s a free calendar that keeps me mot...   \n",
       "1    My bank account and investment growth. Minimal...   \n",
       "2    I like having a clean tidy house. I like havin...   \n",
       "3    Saving money. And also housechores being easie...   \n",
       "4    Haha, for me it's remembering coming from a ba...   \n",
       "..                                                 ...   \n",
       "564                                           Roaches.   \n",
       "565  Control. I grew up surrounded by hoarded posse...   \n",
       "566  The freedom to get up and move if you want/nee...   \n",
       "567  I don't think I consciously decided to \"become...   \n",
       "568  I was struggling with depression and was strug...   \n",
       "\n",
       "                                              Post URL           Post time  \n",
       "0    /r/minimalism/comments/fyi7zc/what_motivates_y... 2020-04-10 15:44:23  \n",
       "1    /r/minimalism/comments/fyi7zc/what_motivates_y... 2020-04-10 15:55:45  \n",
       "2    /r/minimalism/comments/fyi7zc/what_motivates_y... 2020-04-10 15:56:44  \n",
       "3    /r/minimalism/comments/fyi7zc/what_motivates_y... 2020-04-10 18:55:11  \n",
       "4    /r/minimalism/comments/fyi7zc/what_motivates_y... 2020-04-10 21:32:29  \n",
       "..                                                 ...                 ...  \n",
       "564  /r/minimalism/comments/wnwvh/what_made_you_bec... 2012-07-18 10:09:32  \n",
       "565  /r/minimalism/comments/wnwvh/what_made_you_bec... 2012-07-17 16:54:39  \n",
       "566  /r/minimalism/comments/wnwvh/what_made_you_bec... 2012-07-18 05:46:42  \n",
       "567  /r/minimalism/comments/wnwvh/what_made_you_bec... 2012-07-17 16:48:06  \n",
       "568  /r/minimalism/comments/wnwvh/what_made_you_bec... 2012-07-27 01:54:13  \n",
       "\n",
       "[565 rows x 9 columns]"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "minimalism_motives = minimalism_motives[minimalism_motives['Post text'] != '[deleted]']\n",
    "minimalism_motives = minimalism_motives[(minimalism_motives['IsPost'] == 'yes')|(~minimalism_motives['Comment Author'].duplicated()) | minimalism_motives['Comment Author'].isna()]\n",
    "minimalism_motives = minimalism_motives.drop_duplicates('Post text', keep='first')\n",
    "minimalism_motives"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [],
   "source": [
    "minimalism_motives = minimalism_motives.drop_duplicates('Post URL', keep='first')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "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>Index</th>\n",
       "      <th>IsPost</th>\n",
       "      <th>Post Author</th>\n",
       "      <th>Subreddit</th>\n",
       "      <th>Post title</th>\n",
       "      <th>Comment Author</th>\n",
       "      <th>Post text</th>\n",
       "      <th>Post URL</th>\n",
       "      <th>Post time</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>yes</td>\n",
       "      <td>theminimalistwoman</td>\n",
       "      <td>minimalism</td>\n",
       "      <td>What motivates you to stay accountable when yo...</td>\n",
       "      <td>None</td>\n",
       "      <td>For me, it’s a free calendar that keeps me mot...</td>\n",
       "      <td>/r/minimalism/comments/fyi7zc/what_motivates_y...</td>\n",
       "      <td>2020-04-10 15:44:23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>BrokenBrokin</td>\n",
       "      <td>My bank account and investment growth. Minimal...</td>\n",
       "      <td>/r/minimalism/comments/fyi7zc/what_motivates_y...</td>\n",
       "      <td>2020-04-10 15:55:45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td>I like having a clean tidy house. I like havin...</td>\n",
       "      <td>/r/minimalism/comments/fyi7zc/what_motivates_y...</td>\n",
       "      <td>2020-04-10 15:56:44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>odvf</td>\n",
       "      <td>Saving money. And also housechores being easie...</td>\n",
       "      <td>/r/minimalism/comments/fyi7zc/what_motivates_y...</td>\n",
       "      <td>2020-04-10 18:55:11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>hox_blastien</td>\n",
       "      <td>Haha, for me it's remembering coming from a ba...</td>\n",
       "      <td>/r/minimalism/comments/fyi7zc/what_motivates_y...</td>\n",
       "      <td>2020-04-10 21:32:29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>564</th>\n",
       "      <td>19</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td>Roaches.</td>\n",
       "      <td>/r/minimalism/comments/wnwvh/what_made_you_bec...</td>\n",
       "      <td>2012-07-18 10:09:32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>565</th>\n",
       "      <td>19</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td>Control. I grew up surrounded by hoarded posse...</td>\n",
       "      <td>/r/minimalism/comments/wnwvh/what_made_you_bec...</td>\n",
       "      <td>2012-07-17 16:54:39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>566</th>\n",
       "      <td>19</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>pigganon</td>\n",
       "      <td>The freedom to get up and move if you want/nee...</td>\n",
       "      <td>/r/minimalism/comments/wnwvh/what_made_you_bec...</td>\n",
       "      <td>2012-07-18 05:46:42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>567</th>\n",
       "      <td>19</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td>I don't think I consciously decided to \"become...</td>\n",
       "      <td>/r/minimalism/comments/wnwvh/what_made_you_bec...</td>\n",
       "      <td>2012-07-17 16:48:06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>568</th>\n",
       "      <td>19</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td>I was struggling with depression and was strug...</td>\n",
       "      <td>/r/minimalism/comments/wnwvh/what_made_you_bec...</td>\n",
       "      <td>2012-07-27 01:54:13</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>565 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Index IsPost         Post Author   Subreddit  \\\n",
       "0        1    yes  theminimalistwoman  minimalism   \n",
       "1        1     no                      minimalism   \n",
       "2        1     no                      minimalism   \n",
       "3        1     no                      minimalism   \n",
       "4        1     no                      minimalism   \n",
       "..     ...    ...                 ...         ...   \n",
       "564     19     no                      minimalism   \n",
       "565     19     no                      minimalism   \n",
       "566     19     no                      minimalism   \n",
       "567     19     no                      minimalism   \n",
       "568     19     no                      minimalism   \n",
       "\n",
       "                                            Post title Comment Author  \\\n",
       "0    What motivates you to stay accountable when yo...           None   \n",
       "1                                                        BrokenBrokin   \n",
       "2                                                                None   \n",
       "3                                                                odvf   \n",
       "4                                                        hox_blastien   \n",
       "..                                                 ...            ...   \n",
       "564                                                              None   \n",
       "565                                                              None   \n",
       "566                                                          pigganon   \n",
       "567                                                              None   \n",
       "568                                                              None   \n",
       "\n",
       "                                             Post text  \\\n",
       "0    For me, it’s a free calendar that keeps me mot...   \n",
       "1    My bank account and investment growth. Minimal...   \n",
       "2    I like having a clean tidy house. I like havin...   \n",
       "3    Saving money. And also housechores being easie...   \n",
       "4    Haha, for me it's remembering coming from a ba...   \n",
       "..                                                 ...   \n",
       "564                                           Roaches.   \n",
       "565  Control. I grew up surrounded by hoarded posse...   \n",
       "566  The freedom to get up and move if you want/nee...   \n",
       "567  I don't think I consciously decided to \"become...   \n",
       "568  I was struggling with depression and was strug...   \n",
       "\n",
       "                                              Post URL           Post time  \n",
       "0    /r/minimalism/comments/fyi7zc/what_motivates_y... 2020-04-10 15:44:23  \n",
       "1    /r/minimalism/comments/fyi7zc/what_motivates_y... 2020-04-10 15:55:45  \n",
       "2    /r/minimalism/comments/fyi7zc/what_motivates_y... 2020-04-10 15:56:44  \n",
       "3    /r/minimalism/comments/fyi7zc/what_motivates_y... 2020-04-10 18:55:11  \n",
       "4    /r/minimalism/comments/fyi7zc/what_motivates_y... 2020-04-10 21:32:29  \n",
       "..                                                 ...                 ...  \n",
       "564  /r/minimalism/comments/wnwvh/what_made_you_bec... 2012-07-18 10:09:32  \n",
       "565  /r/minimalism/comments/wnwvh/what_made_you_bec... 2012-07-17 16:54:39  \n",
       "566  /r/minimalism/comments/wnwvh/what_made_you_bec... 2012-07-18 05:46:42  \n",
       "567  /r/minimalism/comments/wnwvh/what_made_you_bec... 2012-07-17 16:48:06  \n",
       "568  /r/minimalism/comments/wnwvh/what_made_you_bec... 2012-07-27 01:54:13  \n",
       "\n",
       "[565 rows x 9 columns]"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "minimalism_motives"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "25"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "minimalism_posts = minimalism_motives['Post title'].describe().iloc[1]\n",
    "minimalism_posts"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [],
   "source": [
    "vegan_frames = [what_motivated_you_vegan, what_made_you_vegan_df]\n",
    "\n",
    "vegan_motives = pd.concat(vegan_frames,ignore_index=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "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>Index</th>\n",
       "      <th>IsPost</th>\n",
       "      <th>Post Author</th>\n",
       "      <th>Subreddit</th>\n",
       "      <th>Post title</th>\n",
       "      <th>Comment Author</th>\n",
       "      <th>Post text</th>\n",
       "      <th>Post URL</th>\n",
       "      <th>Post time</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>yes</td>\n",
       "      <td>kaliumhydroxide</td>\n",
       "      <td>vegan</td>\n",
       "      <td>Hey there, tell me a story on how you start on...</td>\n",
       "      <td>none</td>\n",
       "      <td>like what motivates you to become vegan, and w...</td>\n",
       "      <td>/r/vegan/comments/nrf2zv/hey_there_tell_me_a_s...</td>\n",
       "      <td>2021-06-03 14:40:11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td>I saw some information about vivisection Peta ...</td>\n",
       "      <td>/r/vegan/comments/nrf2zv/hey_there_tell_me_a_s...</td>\n",
       "      <td>2021-06-03 17:46:19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>KoYouTokuIngoa</td>\n",
       "      <td>Went vegan after watching a few documentaries ...</td>\n",
       "      <td>/r/vegan/comments/nrf2zv/hey_there_tell_me_a_s...</td>\n",
       "      <td>2021-06-03 19:48:45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>Caffeineandsesame</td>\n",
       "      <td>Seeing my step dad get have to get colon surge...</td>\n",
       "      <td>/r/vegan/comments/nrf2zv/hey_there_tell_me_a_s...</td>\n",
       "      <td>2021-06-04 06:02:08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>Available_Suit_5414</td>\n",
       "      <td>Earthling Ed and Game changers turned me vegan...</td>\n",
       "      <td>/r/vegan/comments/nrf2zv/hey_there_tell_me_a_s...</td>\n",
       "      <td>2021-06-04 11:38:02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1412</th>\n",
       "      <td>100</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>Patchesthelurker</td>\n",
       "      <td>Just switched food to vegan, I've always used ...</td>\n",
       "      <td>/r/vegan/comments/6p2bno/how_vegan_do_most_peo...</td>\n",
       "      <td>2017-07-23 19:40:10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1413</th>\n",
       "      <td>100</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td>I started with beauty products when I realized...</td>\n",
       "      <td>/r/vegan/comments/6p2bno/how_vegan_do_most_peo...</td>\n",
       "      <td>2017-07-24 21:31:55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1414</th>\n",
       "      <td>100</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>misskinky</td>\n",
       "      <td>Vegan should always mean the lifestyle, vegan ...</td>\n",
       "      <td>/r/vegan/comments/6p2bno/how_vegan_do_most_peo...</td>\n",
       "      <td>2017-07-23 17:04:45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1415</th>\n",
       "      <td>100</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td>Veganism *is* the vegan lifestyle.</td>\n",
       "      <td>/r/vegan/comments/6p2bno/how_vegan_do_most_peo...</td>\n",
       "      <td>2017-07-23 17:04:57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1416</th>\n",
       "      <td>100</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td>Choosing to be vegan is not a variable 'range'...</td>\n",
       "      <td>/r/vegan/comments/6p2bno/how_vegan_do_most_peo...</td>\n",
       "      <td>2017-07-23 17:31:36</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1417 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Index IsPost      Post Author Subreddit  \\\n",
       "0         1    yes  kaliumhydroxide     vegan   \n",
       "1         1     no                      vegan   \n",
       "2         1     no                      vegan   \n",
       "3         1     no                      vegan   \n",
       "4         1     no                      vegan   \n",
       "...     ...    ...              ...       ...   \n",
       "1412    100     no                      vegan   \n",
       "1413    100     no                      vegan   \n",
       "1414    100     no                      vegan   \n",
       "1415    100     no                      vegan   \n",
       "1416    100     no                      vegan   \n",
       "\n",
       "                                             Post title       Comment Author  \\\n",
       "0     Hey there, tell me a story on how you start on...                 none   \n",
       "1                                                                       None   \n",
       "2                                                             KoYouTokuIngoa   \n",
       "3                                                          Caffeineandsesame   \n",
       "4                                                        Available_Suit_5414   \n",
       "...                                                 ...                  ...   \n",
       "1412                                                        Patchesthelurker   \n",
       "1413                                                                    None   \n",
       "1414                                                               misskinky   \n",
       "1415                                                                    None   \n",
       "1416                                                                    None   \n",
       "\n",
       "                                              Post text  \\\n",
       "0     like what motivates you to become vegan, and w...   \n",
       "1     I saw some information about vivisection Peta ...   \n",
       "2     Went vegan after watching a few documentaries ...   \n",
       "3     Seeing my step dad get have to get colon surge...   \n",
       "4     Earthling Ed and Game changers turned me vegan...   \n",
       "...                                                 ...   \n",
       "1412  Just switched food to vegan, I've always used ...   \n",
       "1413  I started with beauty products when I realized...   \n",
       "1414  Vegan should always mean the lifestyle, vegan ...   \n",
       "1415                 Veganism *is* the vegan lifestyle.   \n",
       "1416  Choosing to be vegan is not a variable 'range'...   \n",
       "\n",
       "                                               Post URL           Post time  \n",
       "0     /r/vegan/comments/nrf2zv/hey_there_tell_me_a_s... 2021-06-03 14:40:11  \n",
       "1     /r/vegan/comments/nrf2zv/hey_there_tell_me_a_s... 2021-06-03 17:46:19  \n",
       "2     /r/vegan/comments/nrf2zv/hey_there_tell_me_a_s... 2021-06-03 19:48:45  \n",
       "3     /r/vegan/comments/nrf2zv/hey_there_tell_me_a_s... 2021-06-04 06:02:08  \n",
       "4     /r/vegan/comments/nrf2zv/hey_there_tell_me_a_s... 2021-06-04 11:38:02  \n",
       "...                                                 ...                 ...  \n",
       "1412  /r/vegan/comments/6p2bno/how_vegan_do_most_peo... 2017-07-23 19:40:10  \n",
       "1413  /r/vegan/comments/6p2bno/how_vegan_do_most_peo... 2017-07-24 21:31:55  \n",
       "1414  /r/vegan/comments/6p2bno/how_vegan_do_most_peo... 2017-07-23 17:04:45  \n",
       "1415  /r/vegan/comments/6p2bno/how_vegan_do_most_peo... 2017-07-23 17:04:57  \n",
       "1416  /r/vegan/comments/6p2bno/how_vegan_do_most_peo... 2017-07-23 17:31:36  \n",
       "\n",
       "[1417 rows x 9 columns]"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "vegan_motives"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "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>Index</th>\n",
       "      <th>IsPost</th>\n",
       "      <th>Post Author</th>\n",
       "      <th>Subreddit</th>\n",
       "      <th>Post title</th>\n",
       "      <th>Comment Author</th>\n",
       "      <th>Post text</th>\n",
       "      <th>Post URL</th>\n",
       "      <th>Post time</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>yes</td>\n",
       "      <td>kaliumhydroxide</td>\n",
       "      <td>vegan</td>\n",
       "      <td>Hey there, tell me a story on how you start on...</td>\n",
       "      <td>none</td>\n",
       "      <td>like what motivates you to become vegan, and w...</td>\n",
       "      <td>/r/vegan/comments/nrf2zv/hey_there_tell_me_a_s...</td>\n",
       "      <td>2021-06-03 14:40:11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td>I saw some information about vivisection Peta ...</td>\n",
       "      <td>/r/vegan/comments/nrf2zv/hey_there_tell_me_a_s...</td>\n",
       "      <td>2021-06-03 17:46:19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>KoYouTokuIngoa</td>\n",
       "      <td>Went vegan after watching a few documentaries ...</td>\n",
       "      <td>/r/vegan/comments/nrf2zv/hey_there_tell_me_a_s...</td>\n",
       "      <td>2021-06-03 19:48:45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>Caffeineandsesame</td>\n",
       "      <td>Seeing my step dad get have to get colon surge...</td>\n",
       "      <td>/r/vegan/comments/nrf2zv/hey_there_tell_me_a_s...</td>\n",
       "      <td>2021-06-04 06:02:08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>Available_Suit_5414</td>\n",
       "      <td>Earthling Ed and Game changers turned me vegan...</td>\n",
       "      <td>/r/vegan/comments/nrf2zv/hey_there_tell_me_a_s...</td>\n",
       "      <td>2021-06-04 11:38:02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1412</th>\n",
       "      <td>100</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>Patchesthelurker</td>\n",
       "      <td>Just switched food to vegan, I've always used ...</td>\n",
       "      <td>/r/vegan/comments/6p2bno/how_vegan_do_most_peo...</td>\n",
       "      <td>2017-07-23 19:40:10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1413</th>\n",
       "      <td>100</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td>I started with beauty products when I realized...</td>\n",
       "      <td>/r/vegan/comments/6p2bno/how_vegan_do_most_peo...</td>\n",
       "      <td>2017-07-24 21:31:55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1414</th>\n",
       "      <td>100</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>misskinky</td>\n",
       "      <td>Vegan should always mean the lifestyle, vegan ...</td>\n",
       "      <td>/r/vegan/comments/6p2bno/how_vegan_do_most_peo...</td>\n",
       "      <td>2017-07-23 17:04:45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1415</th>\n",
       "      <td>100</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td>Veganism *is* the vegan lifestyle.</td>\n",
       "      <td>/r/vegan/comments/6p2bno/how_vegan_do_most_peo...</td>\n",
       "      <td>2017-07-23 17:04:57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1416</th>\n",
       "      <td>100</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td>Choosing to be vegan is not a variable 'range'...</td>\n",
       "      <td>/r/vegan/comments/6p2bno/how_vegan_do_most_peo...</td>\n",
       "      <td>2017-07-23 17:31:36</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1406 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Index IsPost      Post Author Subreddit  \\\n",
       "0         1    yes  kaliumhydroxide     vegan   \n",
       "1         1     no                      vegan   \n",
       "2         1     no                      vegan   \n",
       "3         1     no                      vegan   \n",
       "4         1     no                      vegan   \n",
       "...     ...    ...              ...       ...   \n",
       "1412    100     no                      vegan   \n",
       "1413    100     no                      vegan   \n",
       "1414    100     no                      vegan   \n",
       "1415    100     no                      vegan   \n",
       "1416    100     no                      vegan   \n",
       "\n",
       "                                             Post title       Comment Author  \\\n",
       "0     Hey there, tell me a story on how you start on...                 none   \n",
       "1                                                                       None   \n",
       "2                                                             KoYouTokuIngoa   \n",
       "3                                                          Caffeineandsesame   \n",
       "4                                                        Available_Suit_5414   \n",
       "...                                                 ...                  ...   \n",
       "1412                                                        Patchesthelurker   \n",
       "1413                                                                    None   \n",
       "1414                                                               misskinky   \n",
       "1415                                                                    None   \n",
       "1416                                                                    None   \n",
       "\n",
       "                                              Post text  \\\n",
       "0     like what motivates you to become vegan, and w...   \n",
       "1     I saw some information about vivisection Peta ...   \n",
       "2     Went vegan after watching a few documentaries ...   \n",
       "3     Seeing my step dad get have to get colon surge...   \n",
       "4     Earthling Ed and Game changers turned me vegan...   \n",
       "...                                                 ...   \n",
       "1412  Just switched food to vegan, I've always used ...   \n",
       "1413  I started with beauty products when I realized...   \n",
       "1414  Vegan should always mean the lifestyle, vegan ...   \n",
       "1415                 Veganism *is* the vegan lifestyle.   \n",
       "1416  Choosing to be vegan is not a variable 'range'...   \n",
       "\n",
       "                                               Post URL           Post time  \n",
       "0     /r/vegan/comments/nrf2zv/hey_there_tell_me_a_s... 2021-06-03 14:40:11  \n",
       "1     /r/vegan/comments/nrf2zv/hey_there_tell_me_a_s... 2021-06-03 17:46:19  \n",
       "2     /r/vegan/comments/nrf2zv/hey_there_tell_me_a_s... 2021-06-03 19:48:45  \n",
       "3     /r/vegan/comments/nrf2zv/hey_there_tell_me_a_s... 2021-06-04 06:02:08  \n",
       "4     /r/vegan/comments/nrf2zv/hey_there_tell_me_a_s... 2021-06-04 11:38:02  \n",
       "...                                                 ...                 ...  \n",
       "1412  /r/vegan/comments/6p2bno/how_vegan_do_most_peo... 2017-07-23 19:40:10  \n",
       "1413  /r/vegan/comments/6p2bno/how_vegan_do_most_peo... 2017-07-24 21:31:55  \n",
       "1414  /r/vegan/comments/6p2bno/how_vegan_do_most_peo... 2017-07-23 17:04:45  \n",
       "1415  /r/vegan/comments/6p2bno/how_vegan_do_most_peo... 2017-07-23 17:04:57  \n",
       "1416  /r/vegan/comments/6p2bno/how_vegan_do_most_peo... 2017-07-23 17:31:36  \n",
       "\n",
       "[1406 rows x 9 columns]"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "vegan_motives = vegan_motives[vegan_motives['Post text'] != '[deleted]']\n",
    "vegan_motives = vegan_motives[(vegan_motives['IsPost'] == 'yes')|(~vegan_motives['Comment Author'].duplicated()) | vegan_motives['Comment Author'].isna()]\n",
    "vegan_motives = vegan_motives.drop_duplicates('Post text', keep='first')\n",
    "vegan_motives = vegan_motives.drop_duplicates('Post URL', keep='first')\n",
    "vegan_motives"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "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>Index</th>\n",
       "      <th>IsPost</th>\n",
       "      <th>Post Author</th>\n",
       "      <th>Subreddit</th>\n",
       "      <th>Post title</th>\n",
       "      <th>Comment Author</th>\n",
       "      <th>Post text</th>\n",
       "      <th>Post URL</th>\n",
       "      <th>Post time</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>yes</td>\n",
       "      <td>kaliumhydroxide</td>\n",
       "      <td>vegan</td>\n",
       "      <td>Hey there, tell me a story on how you start on...</td>\n",
       "      <td>none</td>\n",
       "      <td>like what motivates you to become vegan, and w...</td>\n",
       "      <td>/r/vegan/comments/nrf2zv/hey_there_tell_me_a_s...</td>\n",
       "      <td>2021-06-03 14:40:11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td>I saw some information about vivisection Peta ...</td>\n",
       "      <td>/r/vegan/comments/nrf2zv/hey_there_tell_me_a_s...</td>\n",
       "      <td>2021-06-03 17:46:19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>KoYouTokuIngoa</td>\n",
       "      <td>Went vegan after watching a few documentaries ...</td>\n",
       "      <td>/r/vegan/comments/nrf2zv/hey_there_tell_me_a_s...</td>\n",
       "      <td>2021-06-03 19:48:45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>Caffeineandsesame</td>\n",
       "      <td>Seeing my step dad get have to get colon surge...</td>\n",
       "      <td>/r/vegan/comments/nrf2zv/hey_there_tell_me_a_s...</td>\n",
       "      <td>2021-06-04 06:02:08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>Available_Suit_5414</td>\n",
       "      <td>Earthling Ed and Game changers turned me vegan...</td>\n",
       "      <td>/r/vegan/comments/nrf2zv/hey_there_tell_me_a_s...</td>\n",
       "      <td>2021-06-04 11:38:02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2</td>\n",
       "      <td>yes</td>\n",
       "      <td>seahorsec</td>\n",
       "      <td>vegan</td>\n",
       "      <td>What is your reason for being vegn</td>\n",
       "      <td>none</td>\n",
       "      <td>I’ve been on a plant based diet for 5 years no...</td>\n",
       "      <td>/r/vegan/comments/mih6at/what_is_your_reason_f...</td>\n",
       "      <td>2021-04-02 09:59:52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>SexyJesus123</td>\n",
       "      <td>Not wanting or needing to harm and kill animal...</td>\n",
       "      <td>/r/vegan/comments/mih6at/what_is_your_reason_f...</td>\n",
       "      <td>2021-04-02 10:16:20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>Rokurokubi83</td>\n",
       "      <td>I was at the lowest point in my life, I’d had ...</td>\n",
       "      <td>/r/vegan/comments/mih6at/what_is_your_reason_f...</td>\n",
       "      <td>2021-04-02 10:27:58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>ItsVeganJim</td>\n",
       "      <td>Animal rights. Realizing I was speciesist and ...</td>\n",
       "      <td>/r/vegan/comments/mih6at/what_is_your_reason_f...</td>\n",
       "      <td>2021-04-02 10:37:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>fitforfallo</td>\n",
       "      <td>I was heavily depressed, lost my appetite and ...</td>\n",
       "      <td>/r/vegan/comments/mih6at/what_is_your_reason_f...</td>\n",
       "      <td>2021-04-02 11:45:18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>Thumper-HumpHer</td>\n",
       "      <td>#veganfortheboners</td>\n",
       "      <td>/r/vegan/comments/mih6at/what_is_your_reason_f...</td>\n",
       "      <td>2021-04-02 13:14:43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>Edeuinu</td>\n",
       "      <td>Started for health. Learning about environment...</td>\n",
       "      <td>/r/vegan/comments/mih6at/what_is_your_reason_f...</td>\n",
       "      <td>2021-04-02 14:30:53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>zombiegojaejin</td>\n",
       "      <td>\"Aggressiive\" vegans arguing with me.\\n\\nBeing...</td>\n",
       "      <td>/r/vegan/comments/mih6at/what_is_your_reason_f...</td>\n",
       "      <td>2021-04-07 20:00:36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>3</td>\n",
       "      <td>yes</td>\n",
       "      <td>harveyaki</td>\n",
       "      <td>vegan</td>\n",
       "      <td>What's your motivation?</td>\n",
       "      <td>none</td>\n",
       "      <td>Hi there! I've been vegan for a little while, ...</td>\n",
       "      <td>/r/vegan/comments/cfimil/whats_your_motivation/</td>\n",
       "      <td>2019-07-20 06:14:21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>3</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>manwhodoessound</td>\n",
       "      <td>A combination of respect and commitment to the...</td>\n",
       "      <td>/r/vegan/comments/cfimil/whats_your_motivation...</td>\n",
       "      <td>2019-07-20 06:53:15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>3</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td>Animals.</td>\n",
       "      <td>/r/vegan/comments/cfimil/whats_your_motivation...</td>\n",
       "      <td>2019-07-20 06:17:25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>3</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>themusicguy2000</td>\n",
       "      <td>Girlfriend made me watch earthlings\\n\\nHi /u/v...</td>\n",
       "      <td>/r/vegan/comments/cfimil/whats_your_motivation...</td>\n",
       "      <td>2019-07-20 06:19:18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>3</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>chronic_hemphog_420</td>\n",
       "      <td>I was interested since 3rd grade but I always ...</td>\n",
       "      <td>/r/vegan/comments/cfimil/whats_your_motivation...</td>\n",
       "      <td>2019-07-20 17:11:18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>4</td>\n",
       "      <td>yes</td>\n",
       "      <td>fsjchris</td>\n",
       "      <td>vegan</td>\n",
       "      <td>What motivates you to be vegan?</td>\n",
       "      <td>none</td>\n",
       "      <td></td>\n",
       "      <td>/r/vegan/comments/7oyja0/what_motivates_you_to...</td>\n",
       "      <td>2018-01-08 13:35:54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>4</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>vegan</td>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td>Animal agriculture is horrible for the planet...</td>\n",
       "      <td>/r/vegan/comments/7oyja0/what_motivates_you_to...</td>\n",
       "      <td>2018-01-08 13:43:43</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Index IsPost      Post Author Subreddit  \\\n",
       "0       1    yes  kaliumhydroxide     vegan   \n",
       "1       1     no                      vegan   \n",
       "2       1     no                      vegan   \n",
       "3       1     no                      vegan   \n",
       "4       1     no                      vegan   \n",
       "5       2    yes        seahorsec     vegan   \n",
       "6       2     no                      vegan   \n",
       "7       2     no                      vegan   \n",
       "8       2     no                      vegan   \n",
       "9       2     no                      vegan   \n",
       "10      2     no                      vegan   \n",
       "11      2     no                      vegan   \n",
       "12      2     no                      vegan   \n",
       "13      3    yes        harveyaki     vegan   \n",
       "14      3     no                      vegan   \n",
       "15      3     no                      vegan   \n",
       "16      3     no                      vegan   \n",
       "17      3     no                      vegan   \n",
       "18      4    yes         fsjchris     vegan   \n",
       "19      4     no                      vegan   \n",
       "\n",
       "                                           Post title       Comment Author  \\\n",
       "0   Hey there, tell me a story on how you start on...                 none   \n",
       "1                                                                     None   \n",
       "2                                                           KoYouTokuIngoa   \n",
       "3                                                        Caffeineandsesame   \n",
       "4                                                      Available_Suit_5414   \n",
       "5                  What is your reason for being vegn                 none   \n",
       "6                                                             SexyJesus123   \n",
       "7                                                             Rokurokubi83   \n",
       "8                                                              ItsVeganJim   \n",
       "9                                                              fitforfallo   \n",
       "10                                                         Thumper-HumpHer   \n",
       "11                                                                 Edeuinu   \n",
       "12                                                          zombiegojaejin   \n",
       "13                            What's your motivation?                 none   \n",
       "14                                                         manwhodoessound   \n",
       "15                                                                    None   \n",
       "16                                                         themusicguy2000   \n",
       "17                                                     chronic_hemphog_420   \n",
       "18                    What motivates you to be vegan?                 none   \n",
       "19                                                                    None   \n",
       "\n",
       "                                            Post text  \\\n",
       "0   like what motivates you to become vegan, and w...   \n",
       "1   I saw some information about vivisection Peta ...   \n",
       "2   Went vegan after watching a few documentaries ...   \n",
       "3   Seeing my step dad get have to get colon surge...   \n",
       "4   Earthling Ed and Game changers turned me vegan...   \n",
       "5   I’ve been on a plant based diet for 5 years no...   \n",
       "6   Not wanting or needing to harm and kill animal...   \n",
       "7   I was at the lowest point in my life, I’d had ...   \n",
       "8   Animal rights. Realizing I was speciesist and ...   \n",
       "9   I was heavily depressed, lost my appetite and ...   \n",
       "10                                 #veganfortheboners   \n",
       "11  Started for health. Learning about environment...   \n",
       "12  \"Aggressiive\" vegans arguing with me.\\n\\nBeing...   \n",
       "13  Hi there! I've been vegan for a little while, ...   \n",
       "14  A combination of respect and commitment to the...   \n",
       "15                                           Animals.   \n",
       "16  Girlfriend made me watch earthlings\\n\\nHi /u/v...   \n",
       "17  I was interested since 3rd grade but I always ...   \n",
       "18                                                      \n",
       "19   Animal agriculture is horrible for the planet...   \n",
       "\n",
       "                                             Post URL           Post time  \n",
       "0   /r/vegan/comments/nrf2zv/hey_there_tell_me_a_s... 2021-06-03 14:40:11  \n",
       "1   /r/vegan/comments/nrf2zv/hey_there_tell_me_a_s... 2021-06-03 17:46:19  \n",
       "2   /r/vegan/comments/nrf2zv/hey_there_tell_me_a_s... 2021-06-03 19:48:45  \n",
       "3   /r/vegan/comments/nrf2zv/hey_there_tell_me_a_s... 2021-06-04 06:02:08  \n",
       "4   /r/vegan/comments/nrf2zv/hey_there_tell_me_a_s... 2021-06-04 11:38:02  \n",
       "5   /r/vegan/comments/mih6at/what_is_your_reason_f... 2021-04-02 09:59:52  \n",
       "6   /r/vegan/comments/mih6at/what_is_your_reason_f... 2021-04-02 10:16:20  \n",
       "7   /r/vegan/comments/mih6at/what_is_your_reason_f... 2021-04-02 10:27:58  \n",
       "8   /r/vegan/comments/mih6at/what_is_your_reason_f... 2021-04-02 10:37:00  \n",
       "9   /r/vegan/comments/mih6at/what_is_your_reason_f... 2021-04-02 11:45:18  \n",
       "10  /r/vegan/comments/mih6at/what_is_your_reason_f... 2021-04-02 13:14:43  \n",
       "11  /r/vegan/comments/mih6at/what_is_your_reason_f... 2021-04-02 14:30:53  \n",
       "12  /r/vegan/comments/mih6at/what_is_your_reason_f... 2021-04-07 20:00:36  \n",
       "13    /r/vegan/comments/cfimil/whats_your_motivation/ 2019-07-20 06:14:21  \n",
       "14  /r/vegan/comments/cfimil/whats_your_motivation... 2019-07-20 06:53:15  \n",
       "15  /r/vegan/comments/cfimil/whats_your_motivation... 2019-07-20 06:17:25  \n",
       "16  /r/vegan/comments/cfimil/whats_your_motivation... 2019-07-20 06:19:18  \n",
       "17  /r/vegan/comments/cfimil/whats_your_motivation... 2019-07-20 17:11:18  \n",
       "18  /r/vegan/comments/7oyja0/what_motivates_you_to... 2018-01-08 13:35:54  \n",
       "19  /r/vegan/comments/7oyja0/what_motivates_you_to... 2018-01-08 13:43:43  "
      ]
     },
     "execution_count": 59,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "vegan_motives.head(20)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'I was at the lowest point in my life, I’d had an attempt at ending it.  I had nothing to live for and no value.\\n\\nIn that darkness I sat and took stock, what did I care about? Where can I matter?\\n\\nI went through a number of answers before landing on animals, to become the voice of the voiceless, to stand up to all injustices transcending gender, race, sexuality, religion, age, disability or species.\\n\\nIt gave me a reason to keep on living, and I won’t waste it.'"
      ]
     },
     "execution_count": 60,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "vegan_motives['Post text'][7]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "25"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "minimalism_posts = minimalism_motives['Post title'].describe().iloc[1]\n",
    "minimalism_posts"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "75"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "vegan_posts = vegan_motives['Post title'].describe().iloc[1]\n",
    "vegan_posts"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [],
   "source": [
    "#vegan_motives.to_csv(\"vegan_motives.csv\", index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "#minimalism_motives.to_csv(\"minimalism_motives.csv\", index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "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>Index</th>\n",
       "      <th>IsPost</th>\n",
       "      <th>Post Author</th>\n",
       "      <th>Subreddit</th>\n",
       "      <th>Post title</th>\n",
       "      <th>Comment Author</th>\n",
       "      <th>Post text</th>\n",
       "      <th>Post URL</th>\n",
       "      <th>Post time</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>yes</td>\n",
       "      <td>theminimalistwoman</td>\n",
       "      <td>minimalism</td>\n",
       "      <td>What motivates you to stay accountable when yo...</td>\n",
       "      <td>None</td>\n",
       "      <td>For me, it’s a free calendar that keeps me mot...</td>\n",
       "      <td>/r/minimalism/comments/fyi7zc/what_motivates_y...</td>\n",
       "      <td>2020-04-10 15:44:23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>BrokenBrokin</td>\n",
       "      <td>My bank account and investment growth. Minimal...</td>\n",
       "      <td>/r/minimalism/comments/fyi7zc/what_motivates_y...</td>\n",
       "      <td>2020-04-10 15:55:45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td>I like having a clean tidy house. I like havin...</td>\n",
       "      <td>/r/minimalism/comments/fyi7zc/what_motivates_y...</td>\n",
       "      <td>2020-04-10 15:56:44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>odvf</td>\n",
       "      <td>Saving money. And also housechores being easie...</td>\n",
       "      <td>/r/minimalism/comments/fyi7zc/what_motivates_y...</td>\n",
       "      <td>2020-04-10 18:55:11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>hox_blastien</td>\n",
       "      <td>Haha, for me it's remembering coming from a ba...</td>\n",
       "      <td>/r/minimalism/comments/fyi7zc/what_motivates_y...</td>\n",
       "      <td>2020-04-10 21:32:29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>penpaperandcaffeine</td>\n",
       "      <td>For me, I think about all of the money I get t...</td>\n",
       "      <td>/r/minimalism/comments/fyi7zc/what_motivates_y...</td>\n",
       "      <td>2020-04-10 18:41:41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>TheSimpler</td>\n",
       "      <td>My goals are so small that they are done befor...</td>\n",
       "      <td>/r/minimalism/comments/fyi7zc/what_motivates_y...</td>\n",
       "      <td>2020-04-10 20:14:25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>veiwc</td>\n",
       "      <td>Saving money, afew years back I joined a Faceb...</td>\n",
       "      <td>/r/minimalism/comments/fyi7zc/what_motivates_y...</td>\n",
       "      <td>2020-04-10 18:59:30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>ThickYard9</td>\n",
       "      <td>I have made a spreadsheet that I update daily ...</td>\n",
       "      <td>/r/minimalism/comments/fyi7zc/what_motivates_y...</td>\n",
       "      <td>2020-04-10 22:21:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>mmolle</td>\n",
       "      <td>This is going to sound silly, but I love knowi...</td>\n",
       "      <td>/r/minimalism/comments/fyi7zc/what_motivates_y...</td>\n",
       "      <td>2020-04-10 21:36:37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>BenRayfield</td>\n",
       "      <td>Complexity is painful.</td>\n",
       "      <td>/r/minimalism/comments/fyi7zc/what_motivates_y...</td>\n",
       "      <td>2020-04-10 21:03:24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>ghudson42</td>\n",
       "      <td>Not wanting to have my life wasted with a bunc...</td>\n",
       "      <td>/r/minimalism/comments/fyi7zc/what_motivates_y...</td>\n",
       "      <td>2020-04-10 22:46:27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>1</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>nelsonblaha</td>\n",
       "      <td>My goals are so minimal I've already reached t...</td>\n",
       "      <td>/r/minimalism/comments/fyi7zc/what_motivates_y...</td>\n",
       "      <td>2020-04-11 01:28:37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2</td>\n",
       "      <td>yes</td>\n",
       "      <td>lookingforpersimmons</td>\n",
       "      <td>minimalism</td>\n",
       "      <td>What motivated you to adopt a more minimalist ...</td>\n",
       "      <td>None</td>\n",
       "      <td>I could think of quite a few reasons by myself...</td>\n",
       "      <td>/r/minimalism/comments/ejmtpc/what_motivated_y...</td>\n",
       "      <td>2020-01-03 22:21:48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>pftpft_isthisthingon</td>\n",
       "      <td>Efficiency. A fresh start. Stewardship. And more!</td>\n",
       "      <td>/r/minimalism/comments/ejmtpc/what_motivated_y...</td>\n",
       "      <td>2020-01-03 22:25:24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td>So many reasons...\\n\\nTo save money. To clear ...</td>\n",
       "      <td>/r/minimalism/comments/ejmtpc/what_motivated_y...</td>\n",
       "      <td>2020-01-03 22:41:42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>Livonder</td>\n",
       "      <td>As much as I'd like to say to tackle my debt.....</td>\n",
       "      <td>/r/minimalism/comments/ejmtpc/what_motivated_y...</td>\n",
       "      <td>2020-01-03 23:16:19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>spinningnuri</td>\n",
       "      <td>Too much stuff +ADHD +depression =  anxiety</td>\n",
       "      <td>/r/minimalism/comments/ejmtpc/what_motivated_y...</td>\n",
       "      <td>2020-01-04 02:31:28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>densejackalope</td>\n",
       "      <td>Ended a long relationship with a very material...</td>\n",
       "      <td>/r/minimalism/comments/ejmtpc/what_motivated_y...</td>\n",
       "      <td>2020-01-03 22:25:25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td>minimalism</td>\n",
       "      <td></td>\n",
       "      <td>Beareine</td>\n",
       "      <td>I started my minimalism journey when I permane...</td>\n",
       "      <td>/r/minimalism/comments/ejmtpc/what_motivated_y...</td>\n",
       "      <td>2020-01-04 00:11:32</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Index IsPost           Post Author   Subreddit  \\\n",
       "0       1    yes    theminimalistwoman  minimalism   \n",
       "1       1     no                        minimalism   \n",
       "2       1     no                        minimalism   \n",
       "3       1     no                        minimalism   \n",
       "4       1     no                        minimalism   \n",
       "5       1     no                        minimalism   \n",
       "6       1     no                        minimalism   \n",
       "7       1     no                        minimalism   \n",
       "8       1     no                        minimalism   \n",
       "9       1     no                        minimalism   \n",
       "10      1     no                        minimalism   \n",
       "11      1     no                        minimalism   \n",
       "12      1     no                        minimalism   \n",
       "13      2    yes  lookingforpersimmons  minimalism   \n",
       "14      2     no                        minimalism   \n",
       "15      2     no                        minimalism   \n",
       "16      2     no                        minimalism   \n",
       "17      2     no                        minimalism   \n",
       "18      2     no                        minimalism   \n",
       "19      2     no                        minimalism   \n",
       "\n",
       "                                           Post title        Comment Author  \\\n",
       "0   What motivates you to stay accountable when yo...                  None   \n",
       "1                                                              BrokenBrokin   \n",
       "2                                                                      None   \n",
       "3                                                                      odvf   \n",
       "4                                                              hox_blastien   \n",
       "5                                                       penpaperandcaffeine   \n",
       "6                                                                TheSimpler   \n",
       "7                                                                     veiwc   \n",
       "8                                                                ThickYard9   \n",
       "9                                                                    mmolle   \n",
       "10                                                              BenRayfield   \n",
       "11                                                                ghudson42   \n",
       "12                                                              nelsonblaha   \n",
       "13  What motivated you to adopt a more minimalist ...                  None   \n",
       "14                                                     pftpft_isthisthingon   \n",
       "15                                                                     None   \n",
       "16                                                                 Livonder   \n",
       "17                                                             spinningnuri   \n",
       "18                                                           densejackalope   \n",
       "19                                                                 Beareine   \n",
       "\n",
       "                                            Post text  \\\n",
       "0   For me, it’s a free calendar that keeps me mot...   \n",
       "1   My bank account and investment growth. Minimal...   \n",
       "2   I like having a clean tidy house. I like havin...   \n",
       "3   Saving money. And also housechores being easie...   \n",
       "4   Haha, for me it's remembering coming from a ba...   \n",
       "5   For me, I think about all of the money I get t...   \n",
       "6   My goals are so small that they are done befor...   \n",
       "7   Saving money, afew years back I joined a Faceb...   \n",
       "8   I have made a spreadsheet that I update daily ...   \n",
       "9   This is going to sound silly, but I love knowi...   \n",
       "10                             Complexity is painful.   \n",
       "11  Not wanting to have my life wasted with a bunc...   \n",
       "12  My goals are so minimal I've already reached t...   \n",
       "13  I could think of quite a few reasons by myself...   \n",
       "14  Efficiency. A fresh start. Stewardship. And more!   \n",
       "15  So many reasons...\\n\\nTo save money. To clear ...   \n",
       "16  As much as I'd like to say to tackle my debt.....   \n",
       "17        Too much stuff +ADHD +depression =  anxiety   \n",
       "18  Ended a long relationship with a very material...   \n",
       "19  I started my minimalism journey when I permane...   \n",
       "\n",
       "                                             Post URL           Post time  \n",
       "0   /r/minimalism/comments/fyi7zc/what_motivates_y... 2020-04-10 15:44:23  \n",
       "1   /r/minimalism/comments/fyi7zc/what_motivates_y... 2020-04-10 15:55:45  \n",
       "2   /r/minimalism/comments/fyi7zc/what_motivates_y... 2020-04-10 15:56:44  \n",
       "3   /r/minimalism/comments/fyi7zc/what_motivates_y... 2020-04-10 18:55:11  \n",
       "4   /r/minimalism/comments/fyi7zc/what_motivates_y... 2020-04-10 21:32:29  \n",
       "5   /r/minimalism/comments/fyi7zc/what_motivates_y... 2020-04-10 18:41:41  \n",
       "6   /r/minimalism/comments/fyi7zc/what_motivates_y... 2020-04-10 20:14:25  \n",
       "7   /r/minimalism/comments/fyi7zc/what_motivates_y... 2020-04-10 18:59:30  \n",
       "8   /r/minimalism/comments/fyi7zc/what_motivates_y... 2020-04-10 22:21:00  \n",
       "9   /r/minimalism/comments/fyi7zc/what_motivates_y... 2020-04-10 21:36:37  \n",
       "10  /r/minimalism/comments/fyi7zc/what_motivates_y... 2020-04-10 21:03:24  \n",
       "11  /r/minimalism/comments/fyi7zc/what_motivates_y... 2020-04-10 22:46:27  \n",
       "12  /r/minimalism/comments/fyi7zc/what_motivates_y... 2020-04-11 01:28:37  \n",
       "13  /r/minimalism/comments/ejmtpc/what_motivated_y... 2020-01-03 22:21:48  \n",
       "14  /r/minimalism/comments/ejmtpc/what_motivated_y... 2020-01-03 22:25:24  \n",
       "15  /r/minimalism/comments/ejmtpc/what_motivated_y... 2020-01-03 22:41:42  \n",
       "16  /r/minimalism/comments/ejmtpc/what_motivated_y... 2020-01-03 23:16:19  \n",
       "17  /r/minimalism/comments/ejmtpc/what_motivated_y... 2020-01-04 02:31:28  \n",
       "18  /r/minimalism/comments/ejmtpc/what_motivated_y... 2020-01-03 22:25:25  \n",
       "19  /r/minimalism/comments/ejmtpc/what_motivated_y... 2020-01-04 00:11:32  "
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "minimalism_motives.head(20)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'/r/minimalism/comments/ejmtpc/what_motivated_you_to_adopt_a_more_minimalist/fcz0osu/'"
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "minimalism_motives['Post URL'][15]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "\"So many reasons...\\n\\nTo save money. To clear mental space. Because there are hoarders in my family and I've seen the damage it does. To give myself more room for creativity. To encourage me to spend more time with my loved ones rather than my things. Because it gives me freedom to move with the tides in life if I have to. Because the more I clear away, the more honest I become with myself.\""
      ]
     },
     "execution_count": 47,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "minimalism_motives['Post text'][15]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {},
   "outputs": [],
   "source": [
    "minimalism_motives.to_csv(\"minimalism_motives_check.csv\", index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [],
   "source": [
    "vegan_motives.to_csv(\"vegan_motives_check.csv\", index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}