research.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import praw\n",
    "import pandas as pd\n",
    "from datetime import datetime"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "client_id = '09GDzbqdcnadRkM9t0_IWg'\n",
    "client_secret = 'z3H0rtRKu102jRhNL3U26iSsnW0MKQ'\n",
    "user_agent = 'Particular-Pay-2666'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "reddit = praw.Reddit(client_id=client_id,\n",
    "                     client_secret=client_secret,\n",
    "                     user_agent=user_agent)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "def extract_reddit_data(subreddit_name, limit=1000):\n",
    "    subreddit = reddit.subreddit(subreddit_name)\n",
    "    posts = []\n",
    "\n",
    "    for post in subreddit.hot(limit=limit):\n",
    "        posts.append({\n",
    "            'title': post.title,\n",
    "            'score': post.score,\n",
    "            'id': post.id,\n",
    "            'url': post.url,\n",
    "            'comms_num': post.num_comments,\n",
    "            'created': datetime.fromtimestamp(post.created),\n",
    "            'body': post.selftext\n",
    "        })\n",
    "\n",
    "    return pd.DataFrame(posts)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "crypto_subreddits = [\n",
    "    \"Bitcoin\",\n",
    "    \"BTC\",\n",
    "    \"Crypto\",\n",
    "    \"Cryptocurrency\",\n",
    "    \"CryptoNews\",\n",
    "    \"BitcoinPrice\",\n",
    "    \"CryptoAnalysis\",\n",
    "]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Extracting data from r/Bitcoin\n",
      "Extracting data from r/BTC\n",
      "Extracting data from r/Crypto\n",
      "Extracting data from r/Cryptocurrency\n",
      "Extracting data from r/CryptoNews\n",
      "Extracting data from r/BitcoinPrice\n",
      "Extracting data from r/BTCPrice\n",
      "Data not found for BTCPrice\n",
      "Extracting data from r/CryptoAnalysis\n"
     ]
    }
   ],
   "source": [
    "all_data = []\n",
    "for subreddit in crypto_subreddits:\n",
    "    try:\n",
    "        print(f\"Extracting data from r/{subreddit}\")\n",
    "        subreddit_data = extract_reddit_data(subreddit)\n",
    "        all_data.append(subreddit_data)\n",
    "    except Exception as e:\n",
    "        print(f\"Data not found for {subreddit}\")\n",
    "        continue"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "df= pd.concat(all_data, ignore_index=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>title</th>\n",
       "      <th>score</th>\n",
       "      <th>id</th>\n",
       "      <th>url</th>\n",
       "      <th>comms_num</th>\n",
       "      <th>created</th>\n",
       "      <th>body</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Bitcoin Newcomers FAQ - Please read!</td>\n",
       "      <td>33</td>\n",
       "      <td>1f7n947</td>\n",
       "      <td>https://www.reddit.com/r/Bitcoin/comments/1f7n...</td>\n",
       "      <td>12</td>\n",
       "      <td>2024-09-03 06:35:33</td>\n",
       "      <td># Welcome to the /r/Bitcoin Newcomers FAQ\\n\\nY...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Daily Discussion, October 09, 2024</td>\n",
       "      <td>10</td>\n",
       "      <td>1fzksss</td>\n",
       "      <td>https://www.reddit.com/r/Bitcoin/comments/1fzk...</td>\n",
       "      <td>13</td>\n",
       "      <td>2024-10-09 11:35:23</td>\n",
       "      <td>Please utilize this sticky thread for all gene...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Overwhelmed with feelings</td>\n",
       "      <td>75</td>\n",
       "      <td>1fzm5gq</td>\n",
       "      <td>https://i.redd.it/piu5f30irotd1.jpeg</td>\n",
       "      <td>0</td>\n",
       "      <td>2024-10-09 13:19:28</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>U.S. Government Set to Auction $4.4 Billion in...</td>\n",
       "      <td>800</td>\n",
       "      <td>1fz6jtd</td>\n",
       "      <td>https://www.binance.com/en/square/post/1457581...</td>\n",
       "      <td>232</td>\n",
       "      <td>2024-10-08 23:43:56</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Found this in a thrift store years ago and for...</td>\n",
       "      <td>110</td>\n",
       "      <td>1fzjhmt</td>\n",
       "      <td>https://i.redd.it/sfpz7tswsntd1.jpeg</td>\n",
       "      <td>26</td>\n",
       "      <td>2024-10-09 10:06:18</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                               title  score       id  \\\n",
       "0               Bitcoin Newcomers FAQ - Please read!     33  1f7n947   \n",
       "1                 Daily Discussion, October 09, 2024     10  1fzksss   \n",
       "2                         Overwhelmed with feelings      75  1fzm5gq   \n",
       "3  U.S. Government Set to Auction $4.4 Billion in...    800  1fz6jtd   \n",
       "4  Found this in a thrift store years ago and for...    110  1fzjhmt   \n",
       "\n",
       "                                                 url  comms_num  \\\n",
       "0  https://www.reddit.com/r/Bitcoin/comments/1f7n...         12   \n",
       "1  https://www.reddit.com/r/Bitcoin/comments/1fzk...         13   \n",
       "2               https://i.redd.it/piu5f30irotd1.jpeg          0   \n",
       "3  https://www.binance.com/en/square/post/1457581...        232   \n",
       "4               https://i.redd.it/sfpz7tswsntd1.jpeg         26   \n",
       "\n",
       "              created                                               body  \n",
       "0 2024-09-03 06:35:33  # Welcome to the /r/Bitcoin Newcomers FAQ\\n\\nY...  \n",
       "1 2024-10-09 11:35:23  Please utilize this sticky thread for all gene...  \n",
       "2 2024-10-09 13:19:28                                                     \n",
       "3 2024-10-08 23:43:56                                                     \n",
       "4 2024-10-09 10:06:18                                                     "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "title        0\n",
       "score        0\n",
       "id           0\n",
       "url          0\n",
       "comms_num    0\n",
       "created      0\n",
       "body         0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(3708, 7)"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(2287, 7)"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['body']==''].shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = df.drop_duplicates(subset=['id'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(3708, 7)"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.shape"
   ]
  },
  {
   "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>title</th>\n",
       "      <th>score</th>\n",
       "      <th>id</th>\n",
       "      <th>url</th>\n",
       "      <th>comms_num</th>\n",
       "      <th>created</th>\n",
       "      <th>body</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Bitcoin Newcomers FAQ - Please read!</td>\n",
       "      <td>33</td>\n",
       "      <td>1f7n947</td>\n",
       "      <td>https://www.reddit.com/r/Bitcoin/comments/1f7n...</td>\n",
       "      <td>12</td>\n",
       "      <td>2024-09-03 06:35:33</td>\n",
       "      <td># Welcome to the /r/Bitcoin Newcomers FAQ\\n\\nY...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Daily Discussion, October 09, 2024</td>\n",
       "      <td>10</td>\n",
       "      <td>1fzksss</td>\n",
       "      <td>https://www.reddit.com/r/Bitcoin/comments/1fzk...</td>\n",
       "      <td>13</td>\n",
       "      <td>2024-10-09 11:35:23</td>\n",
       "      <td>Please utilize this sticky thread for all gene...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Overwhelmed with feelings</td>\n",
       "      <td>75</td>\n",
       "      <td>1fzm5gq</td>\n",
       "      <td>https://i.redd.it/piu5f30irotd1.jpeg</td>\n",
       "      <td>0</td>\n",
       "      <td>2024-10-09 13:19:28</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>U.S. Government Set to Auction $4.4 Billion in...</td>\n",
       "      <td>800</td>\n",
       "      <td>1fz6jtd</td>\n",
       "      <td>https://www.binance.com/en/square/post/1457581...</td>\n",
       "      <td>232</td>\n",
       "      <td>2024-10-08 23:43:56</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Found this in a thrift store years ago and for...</td>\n",
       "      <td>110</td>\n",
       "      <td>1fzjhmt</td>\n",
       "      <td>https://i.redd.it/sfpz7tswsntd1.jpeg</td>\n",
       "      <td>26</td>\n",
       "      <td>2024-10-09 10:06:18</td>\n",
       "      <td></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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3703</th>\n",
       "      <td>Bitcoin Price Watch; Live Trade! - NEWSBTC</td>\n",
       "      <td>1</td>\n",
       "      <td>72z00e</td>\n",
       "      <td>http://www.newsbtc.com/2017/09/20/bitcoin-pric...</td>\n",
       "      <td>0</td>\n",
       "      <td>2017-09-28 15:01:37</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3704</th>\n",
       "      <td>Bitcoin Price Projections for 2017</td>\n",
       "      <td>1</td>\n",
       "      <td>70y7po</td>\n",
       "      <td>http://bitcoinprice24.blogspot.com/2017/09/bit...</td>\n",
       "      <td>0</td>\n",
       "      <td>2017-09-19 03:04:43</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3705</th>\n",
       "      <td>MOVIE︻FREE A Beautiful Mind 2001 subtitles mov...</td>\n",
       "      <td>1</td>\n",
       "      <td>4qrttg</td>\n",
       "      <td>https://www.reddit.com/r/bitcoinprice/comments...</td>\n",
       "      <td>1</td>\n",
       "      <td>2016-07-01 19:21:07</td>\n",
       "      <td>87125</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3706</th>\n",
       "      <td>FREE BOOK \"Youth by J. M. Coetzee\" epub kindle...</td>\n",
       "      <td>1</td>\n",
       "      <td>44y4au</td>\n",
       "      <td>https://www.reddit.com/r/bitcoinprice/comments...</td>\n",
       "      <td>1</td>\n",
       "      <td>2016-02-10 00:04:04</td>\n",
       "      <td>Ashley Harris</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3707</th>\n",
       "      <td>r/CryptoAnalysis Lounge</td>\n",
       "      <td>1</td>\n",
       "      <td>otwzdc</td>\n",
       "      <td>https://www.reddit.com/r/CryptoAnalysis/commen...</td>\n",
       "      <td>1</td>\n",
       "      <td>2021-07-29 18:28:12</td>\n",
       "      <td>A place for members of r/CryptoAnalysis to cha...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3708 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                  title  score       id  \\\n",
       "0                  Bitcoin Newcomers FAQ - Please read!     33  1f7n947   \n",
       "1                    Daily Discussion, October 09, 2024     10  1fzksss   \n",
       "2                            Overwhelmed with feelings      75  1fzm5gq   \n",
       "3     U.S. Government Set to Auction $4.4 Billion in...    800  1fz6jtd   \n",
       "4     Found this in a thrift store years ago and for...    110  1fzjhmt   \n",
       "...                                                 ...    ...      ...   \n",
       "3703         Bitcoin Price Watch; Live Trade! - NEWSBTC      1   72z00e   \n",
       "3704                 Bitcoin Price Projections for 2017      1   70y7po   \n",
       "3705  MOVIE︻FREE A Beautiful Mind 2001 subtitles mov...      1   4qrttg   \n",
       "3706  FREE BOOK \"Youth by J. M. Coetzee\" epub kindle...      1   44y4au   \n",
       "3707                            r/CryptoAnalysis Lounge      1   otwzdc   \n",
       "\n",
       "                                                    url  comms_num  \\\n",
       "0     https://www.reddit.com/r/Bitcoin/comments/1f7n...         12   \n",
       "1     https://www.reddit.com/r/Bitcoin/comments/1fzk...         13   \n",
       "2                  https://i.redd.it/piu5f30irotd1.jpeg          0   \n",
       "3     https://www.binance.com/en/square/post/1457581...        232   \n",
       "4                  https://i.redd.it/sfpz7tswsntd1.jpeg         26   \n",
       "...                                                 ...        ...   \n",
       "3703  http://www.newsbtc.com/2017/09/20/bitcoin-pric...          0   \n",
       "3704  http://bitcoinprice24.blogspot.com/2017/09/bit...          0   \n",
       "3705  https://www.reddit.com/r/bitcoinprice/comments...          1   \n",
       "3706  https://www.reddit.com/r/bitcoinprice/comments...          1   \n",
       "3707  https://www.reddit.com/r/CryptoAnalysis/commen...          1   \n",
       "\n",
       "                 created                                               body  \n",
       "0    2024-09-03 06:35:33  # Welcome to the /r/Bitcoin Newcomers FAQ\\n\\nY...  \n",
       "1    2024-10-09 11:35:23  Please utilize this sticky thread for all gene...  \n",
       "2    2024-10-09 13:19:28                                                     \n",
       "3    2024-10-08 23:43:56                                                     \n",
       "4    2024-10-09 10:06:18                                                     \n",
       "...                  ...                                                ...  \n",
       "3703 2017-09-28 15:01:37                                                     \n",
       "3704 2017-09-19 03:04:43                                                     \n",
       "3705 2016-07-01 19:21:07                                              87125  \n",
       "3706 2016-02-10 00:04:04                                      Ashley Harris  \n",
       "3707 2021-07-29 18:28:12  A place for members of r/CryptoAnalysis to cha...  \n",
       "\n",
       "[3708 rows x 7 columns]"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>title</th>\n",
       "      <th>score</th>\n",
       "      <th>id</th>\n",
       "      <th>url</th>\n",
       "      <th>comms_num</th>\n",
       "      <th>created</th>\n",
       "      <th>body</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Bitcoin Newcomers FAQ - Please read!</td>\n",
       "      <td>33</td>\n",
       "      <td>1f7n947</td>\n",
       "      <td>https://www.reddit.com/r/Bitcoin/comments/1f7n...</td>\n",
       "      <td>12</td>\n",
       "      <td>2024-09-03 06:35:33</td>\n",
       "      <td># Welcome to the /r/Bitcoin Newcomers FAQ\\n\\nY...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Daily Discussion, October 09, 2024</td>\n",
       "      <td>10</td>\n",
       "      <td>1fzksss</td>\n",
       "      <td>https://www.reddit.com/r/Bitcoin/comments/1fzk...</td>\n",
       "      <td>13</td>\n",
       "      <td>2024-10-09 11:35:23</td>\n",
       "      <td>Please utilize this sticky thread for all gene...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Overwhelmed with feelings</td>\n",
       "      <td>75</td>\n",
       "      <td>1fzm5gq</td>\n",
       "      <td>https://i.redd.it/piu5f30irotd1.jpeg</td>\n",
       "      <td>0</td>\n",
       "      <td>2024-10-09 13:19:28</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>U.S. Government Set to Auction $4.4 Billion in...</td>\n",
       "      <td>800</td>\n",
       "      <td>1fz6jtd</td>\n",
       "      <td>https://www.binance.com/en/square/post/1457581...</td>\n",
       "      <td>232</td>\n",
       "      <td>2024-10-08 23:43:56</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Found this in a thrift store years ago and for...</td>\n",
       "      <td>110</td>\n",
       "      <td>1fzjhmt</td>\n",
       "      <td>https://i.redd.it/sfpz7tswsntd1.jpeg</td>\n",
       "      <td>26</td>\n",
       "      <td>2024-10-09 10:06:18</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                               title  score       id  \\\n",
       "0               Bitcoin Newcomers FAQ - Please read!     33  1f7n947   \n",
       "1                 Daily Discussion, October 09, 2024     10  1fzksss   \n",
       "2                         Overwhelmed with feelings      75  1fzm5gq   \n",
       "3  U.S. Government Set to Auction $4.4 Billion in...    800  1fz6jtd   \n",
       "4  Found this in a thrift store years ago and for...    110  1fzjhmt   \n",
       "\n",
       "                                                 url  comms_num  \\\n",
       "0  https://www.reddit.com/r/Bitcoin/comments/1f7n...         12   \n",
       "1  https://www.reddit.com/r/Bitcoin/comments/1fzk...         13   \n",
       "2               https://i.redd.it/piu5f30irotd1.jpeg          0   \n",
       "3  https://www.binance.com/en/square/post/1457581...        232   \n",
       "4               https://i.redd.it/sfpz7tswsntd1.jpeg         26   \n",
       "\n",
       "              created                                               body  \n",
       "0 2024-09-03 06:35:33  # Welcome to the /r/Bitcoin Newcomers FAQ\\n\\nY...  \n",
       "1 2024-10-09 11:35:23  Please utilize this sticky thread for all gene...  \n",
       "2 2024-10-09 13:19:28                                                     \n",
       "3 2024-10-08 23:43:56                                                     \n",
       "4 2024-10-09 10:06:18                                                     "
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "df=df.rename(columns={'body':'Description','comms_num':'No_Comments'})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv('reddit_data.csv')"
   ]
  },
  {
   "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>title</th>\n",
       "      <th>score</th>\n",
       "      <th>id</th>\n",
       "      <th>url</th>\n",
       "      <th>No_Comments</th>\n",
       "      <th>created</th>\n",
       "      <th>Description</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Bitcoin Newcomers FAQ - Please read!</td>\n",
       "      <td>32</td>\n",
       "      <td>1f7n947</td>\n",
       "      <td>https://www.reddit.com/r/Bitcoin/comments/1f7n...</td>\n",
       "      <td>11</td>\n",
       "      <td>2024-09-03 06:35:33</td>\n",
       "      <td># Welcome to the /r/Bitcoin Newcomers FAQ\\n\\nY...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Daily Discussion, October 06, 2024</td>\n",
       "      <td>9</td>\n",
       "      <td>1fx9x0k</td>\n",
       "      <td>https://www.reddit.com/r/Bitcoin/comments/1fx9...</td>\n",
       "      <td>18</td>\n",
       "      <td>2024-10-06 11:31:33</td>\n",
       "      <td>Please utilize this sticky thread for all gene...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Kids infotainment</td>\n",
       "      <td>54</td>\n",
       "      <td>1fxdmpi</td>\n",
       "      <td>https://v.redd.it/nx6fwzyl64td1</td>\n",
       "      <td>4</td>\n",
       "      <td>2024-10-06 16:07:07</td>\n",
       "      <td>Quite a catchy tune. But I can't see it appear...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>When I saw the BTC light</td>\n",
       "      <td>74</td>\n",
       "      <td>1fx9dvf</td>\n",
       "      <td>https://i.redd.it/d82dq48vm2td1.jpeg</td>\n",
       "      <td>10</td>\n",
       "      <td>2024-10-06 10:54:18</td>\n",
       "      <td>This picture shows perfectly when I became ora...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>I’m too poor to ever be able to afford a whole...</td>\n",
       "      <td>12</td>\n",
       "      <td>1fxgz16</td>\n",
       "      <td>https://www.reddit.com/r/Bitcoin/comments/1fxg...</td>\n",
       "      <td>8</td>\n",
       "      <td>2024-10-06 19:22:37</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                               title  score       id  \\\n",
       "0               Bitcoin Newcomers FAQ - Please read!     32  1f7n947   \n",
       "1                 Daily Discussion, October 06, 2024      9  1fx9x0k   \n",
       "5                                  Kids infotainment     54  1fxdmpi   \n",
       "7                          When I saw the BTC light      74  1fx9dvf   \n",
       "9  I’m too poor to ever be able to afford a whole...     12  1fxgz16   \n",
       "\n",
       "                                                 url  No_Comments  \\\n",
       "0  https://www.reddit.com/r/Bitcoin/comments/1f7n...           11   \n",
       "1  https://www.reddit.com/r/Bitcoin/comments/1fx9...           18   \n",
       "5                    https://v.redd.it/nx6fwzyl64td1            4   \n",
       "7               https://i.redd.it/d82dq48vm2td1.jpeg           10   \n",
       "9  https://www.reddit.com/r/Bitcoin/comments/1fxg...            8   \n",
       "\n",
       "              created                                        Description  \n",
       "0 2024-09-03 06:35:33  # Welcome to the /r/Bitcoin Newcomers FAQ\\n\\nY...  \n",
       "1 2024-10-06 11:31:33  Please utilize this sticky thread for all gene...  \n",
       "5 2024-10-06 16:07:07  Quite a catchy tune. But I can't see it appear...  \n",
       "7 2024-10-06 10:54:18  This picture shows perfectly when I became ora...  \n",
       "9 2024-10-06 19:22:37                                                  Y  "
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "venv",
   "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.12.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}