read_data_model.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "from sqlalchemy import create_engine\n",
    "import numpy as np\n",
    "import sqlalchemy as sqlalchemy\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "rds_connection_string = \"postgres:postgres@localhost:5432/finalp_db\"\n",
    "engine = create_engine(f'postgresql://{rds_connection_string}')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['review_info', 'movie_info']"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "engine.table_names()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "movie_info=pd.read_sql_query('select * from movie_info', con=engine)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "review_info=pd.read_sql_query('select * from review_info', con=engine)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "scrolled": true
   },
   "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>movie_id</th>\n",
       "      <th>movie_title</th>\n",
       "      <th>rating</th>\n",
       "      <th>nreviews</th>\n",
       "      <th>genre</th>\n",
       "      <th>genre1</th>\n",
       "      <th>genre2</th>\n",
       "      <th>genre3</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>tt9140560</td>\n",
       "      <td>WandaVision</td>\n",
       "      <td>8.3</td>\n",
       "      <td>66492.0</td>\n",
       "      <td>Action  Comedy  Drama</td>\n",
       "      <td>Action</td>\n",
       "      <td>Comedy</td>\n",
       "      <td>Drama</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>tt2560140</td>\n",
       "      <td>Attack on Titan</td>\n",
       "      <td>8.9</td>\n",
       "      <td>203898.0</td>\n",
       "      <td>Animation  Action  Adventure</td>\n",
       "      <td>Animation</td>\n",
       "      <td>Action</td>\n",
       "      <td>Adventure</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>tt6878306</td>\n",
       "      <td>News of the World</td>\n",
       "      <td>6.8</td>\n",
       "      <td>39587.0</td>\n",
       "      <td>Action  Adventure  Drama</td>\n",
       "      <td>Action</td>\n",
       "      <td>Adventure</td>\n",
       "      <td>Drama</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>tt6475714</td>\n",
       "      <td>Monster Hunter</td>\n",
       "      <td>5.3</td>\n",
       "      <td>18284.0</td>\n",
       "      <td>Action  Adventure  Fantasy</td>\n",
       "      <td>Action</td>\n",
       "      <td>Adventure</td>\n",
       "      <td>Fantasy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>tt0944947</td>\n",
       "      <td>Game of Thrones</td>\n",
       "      <td>9.3</td>\n",
       "      <td>1776219.0</td>\n",
       "      <td>Action  Adventure  Drama</td>\n",
       "      <td>Action</td>\n",
       "      <td>Adventure</td>\n",
       "      <td>Drama</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3841</th>\n",
       "      <td>tt0087075</td>\n",
       "      <td>The Company of Wolves</td>\n",
       "      <td>6.7</td>\n",
       "      <td>15065.0</td>\n",
       "      <td>Drama  Fantasy  Horror</td>\n",
       "      <td>Drama</td>\n",
       "      <td>Fantasy</td>\n",
       "      <td>Horror</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3842</th>\n",
       "      <td>tt4798836</td>\n",
       "      <td>Bad Hair</td>\n",
       "      <td>5.6</td>\n",
       "      <td>2229.0</td>\n",
       "      <td>Comedy  Horror</td>\n",
       "      <td>Comedy</td>\n",
       "      <td>Horror</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3843</th>\n",
       "      <td>tt0256009</td>\n",
       "      <td>The Devil's Backbone</td>\n",
       "      <td>7.4</td>\n",
       "      <td>61988.0</td>\n",
       "      <td>Drama  Horror</td>\n",
       "      <td>Drama</td>\n",
       "      <td>Horror</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3844</th>\n",
       "      <td>tt0086154</td>\n",
       "      <td>Psycho II</td>\n",
       "      <td>6.5</td>\n",
       "      <td>24322.0</td>\n",
       "      <td>Crime  Horror  Mystery</td>\n",
       "      <td>Crime</td>\n",
       "      <td>Horror</td>\n",
       "      <td>Mystery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3845</th>\n",
       "      <td>tt9742392</td>\n",
       "      <td>Kindred</td>\n",
       "      <td>4.8</td>\n",
       "      <td>561.0</td>\n",
       "      <td>Drama  Horror  Mystery</td>\n",
       "      <td>Drama</td>\n",
       "      <td>Horror</td>\n",
       "      <td>Mystery</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3846 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       movie_id            movie_title  rating   nreviews  \\\n",
       "0     tt9140560            WandaVision     8.3    66492.0   \n",
       "1     tt2560140        Attack on Titan     8.9   203898.0   \n",
       "2     tt6878306      News of the World     6.8    39587.0   \n",
       "3     tt6475714         Monster Hunter     5.3    18284.0   \n",
       "4     tt0944947        Game of Thrones     9.3  1776219.0   \n",
       "...         ...                    ...     ...        ...   \n",
       "3841  tt0087075  The Company of Wolves     6.7    15065.0   \n",
       "3842  tt4798836               Bad Hair     5.6     2229.0   \n",
       "3843  tt0256009   The Devil's Backbone     7.4    61988.0   \n",
       "3844  tt0086154              Psycho II     6.5    24322.0   \n",
       "3845  tt9742392                Kindred     4.8      561.0   \n",
       "\n",
       "                                         genre     genre1     genre2  \\\n",
       "0            Action  Comedy  Drama                 Action     Comedy   \n",
       "1     Animation  Action  Adventure              Animation     Action   \n",
       "2         Action  Adventure  Drama                 Action  Adventure   \n",
       "3       Action  Adventure  Fantasy                 Action  Adventure   \n",
       "4         Action  Adventure  Drama                 Action  Adventure   \n",
       "...                                        ...        ...        ...   \n",
       "3841        Drama  Fantasy  Horror                  Drama    Fantasy   \n",
       "3842                Comedy  Horror                 Comedy     Horror   \n",
       "3843                 Drama  Horror                  Drama     Horror   \n",
       "3844        Crime  Horror  Mystery                  Crime     Horror   \n",
       "3845        Drama  Horror  Mystery                  Drama     Horror   \n",
       "\n",
       "         genre3  \n",
       "0         Drama  \n",
       "1     Adventure  \n",
       "2         Drama  \n",
       "3       Fantasy  \n",
       "4         Drama  \n",
       "...         ...  \n",
       "3841     Horror  \n",
       "3842       None  \n",
       "3843       None  \n",
       "3844    Mystery  \n",
       "3845    Mystery  \n",
       "\n",
       "[3846 rows x 8 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movie_info"
   ]
  },
  {
   "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>movie_id</th>\n",
       "      <th>rating_ind</th>\n",
       "      <th>rating_text</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>tt6878306</td>\n",
       "      <td>9.0</td>\n",
       "      <td>I'm a big fan of Paul Greengrass and Tom Hanks...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>tt6878306</td>\n",
       "      <td>8.0</td>\n",
       "      <td>Having read the book made the movie easier to ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>tt6878306</td>\n",
       "      <td>8.0</td>\n",
       "      <td>Tom Hanks is a 19th century newsman who reads ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>tt6878306</td>\n",
       "      <td>9.0</td>\n",
       "      <td>I didn't really love this film. I think it is ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>tt6878306</td>\n",
       "      <td>7.0</td>\n",
       "      <td>It wasn't unreasonable for me to be properly e...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17908</th>\n",
       "      <td>tt0086154</td>\n",
       "      <td>8.0</td>\n",
       "      <td>Psycho II does a great job continuing with the...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17909</th>\n",
       "      <td>tt0086154</td>\n",
       "      <td>8.0</td>\n",
       "      <td>Everyone knows the original 'Psycho' film and ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17910</th>\n",
       "      <td>tt9742392</td>\n",
       "      <td>3.0</td>\n",
       "      <td>This movie just becomes one more recent film ,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17911</th>\n",
       "      <td>tt9742392</td>\n",
       "      <td>2.0</td>\n",
       "      <td>The success of a slow-moving thriller depends ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17912</th>\n",
       "      <td>tt9742392</td>\n",
       "      <td>3.0</td>\n",
       "      <td>I always go into movies like this with no expe...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>17913 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        movie_id  rating_ind  \\\n",
       "0      tt6878306         9.0   \n",
       "1      tt6878306         8.0   \n",
       "2      tt6878306         8.0   \n",
       "3      tt6878306         9.0   \n",
       "4      tt6878306         7.0   \n",
       "...          ...         ...   \n",
       "17908  tt0086154         8.0   \n",
       "17909  tt0086154         8.0   \n",
       "17910  tt9742392         3.0   \n",
       "17911  tt9742392         2.0   \n",
       "17912  tt9742392         3.0   \n",
       "\n",
       "                                             rating_text  \n",
       "0      I'm a big fan of Paul Greengrass and Tom Hanks...  \n",
       "1      Having read the book made the movie easier to ...  \n",
       "2      Tom Hanks is a 19th century newsman who reads ...  \n",
       "3      I didn't really love this film. I think it is ...  \n",
       "4      It wasn't unreasonable for me to be properly e...  \n",
       "...                                                  ...  \n",
       "17908  Psycho II does a great job continuing with the...  \n",
       "17909  Everyone knows the original 'Psycho' film and ...  \n",
       "17910  This movie just becomes one more recent film ,...  \n",
       "17911  The success of a slow-moving thriller depends ...  \n",
       "17912  I always go into movies like this with no expe...  \n",
       "\n",
       "[17913 rows x 3 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "review_info"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}