what_you_can_watch_from_a_FilmAffinity_list.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "379dc217",
   "metadata": {},
   "source": [
    "# FilmAffinity's lists\n",
    "\n",
    "FA does't show in what platform you can watch movies from a FA's list.\n",
    "\n",
    "I have made my own solution using webscrapping.\n",
    "\n",
    "## VPNs and Platforms\n",
    "\n",
    "Platforms catalogue is different in every country, there are some movies that you can see in Netflix US but not in Netflix UK.\n",
    "\n",
    "I have automatized the way to search. The program gives you in what platforms you can watch the movies in four countries: Spain, US, UK and Canada (I'm limited by FilmAffinity). So if you have access to a VPN, you can watch more movies!\n",
    "\n",
    "# Listas de FilmAffinity\n",
    "\n",
    "En FilmAffinity no puedes saber de manera directa en qué plataforma se encuentran las peliculas de una lista.\n",
    "\n",
    "He implementado mediante webscrapping una solución a este problema.\n",
    "\n",
    "## VPNs y plataformas\n",
    "\n",
    "Por motivos de distribuidoras y derechos, el catálogo de las plataformas es distinto en cada país, existen algunas películas que pueden verse en Netflix US pero no en Netflix España.\n",
    "\n",
    "Por esto he implementado una manera de automatizar la búsqueda. El programa te dice en qué plataformas puedes ver las películas de la lista en cuatro países: España, EEUU, Reino Unido y Canadá (el programa está limitado por FA). ¡Así que si tienes acceso a una VPN podrás ver muchas más peliculas!"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "c92f7c79",
   "metadata": {},
   "outputs": [],
   "source": [
    "from bs4 import BeautifulSoup\n",
    "import pandas as pd\n",
    "import requests\n",
    "from fun import *\n",
    "import os"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "e582c1c1",
   "metadata": {},
   "outputs": [],
   "source": [
    "#All acepted platforms:\n",
    "all_platforms = [\n",
    " 'Starz Play Amazon Channel',\n",
    " 'Filmin Plus',\n",
    " 'Movistar Plus',\n",
    " 'Netflix',\n",
    " 'Filmin',\n",
    " 'fuboTV',\n",
    " 'Rakuten TV',\n",
    " 'HBO',\n",
    " 'Microsoft Store',\n",
    " 'Amazon Prime Video',\n",
    " 'Spamflix',\n",
    " 'Google Play Movies',\n",
    " 'Amazon Video',\n",
    " 'Apple iTunes',\n",
    " 'HBO Max']\n",
    "#All countries:\n",
    "all_countries = [\n",
    " 'es',\n",
    " 'us',\n",
    " 'uk',\n",
    " 'ca',\n",
    "]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "4e0cf9c1",
   "metadata": {},
   "outputs": [],
   "source": [
    "#Only edit this cell:\n",
    "\n",
    "#URL of the list:\n",
    "URL = 'https://www.filmaffinity.com/es/userlist.php?user_id=9046485&list_id=1005'\n",
    "#Number of pages of the list:\n",
    "num_pages = 6\n",
    "#Folder where CSVs are contained:\n",
    "folder_name = './lists/'\n",
    "#List name:\n",
    "list_name = 'PELIS Q VER OBL'\n",
    "#Name of the CSV generated with all movies in FA's list\n",
    "CSV_file_name = list_name + '_list.csv'\n",
    "#Name of the CSV generated with all movies in FA's list that you can watch\n",
    "CSV_file_you_can_watch = list_name +  '_you_can_watch.csv'\n",
    "#List of all platforms where you have an account:\n",
    "your_plattforms = ['Amazon Prime Video', 'Filmin']\n",
    "#Countries (VPN): \n",
    "countries = ['es']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "1a838bca",
   "metadata": {},
   "outputs": [],
   "source": [
    "try:\n",
    "    os.mkdir(folder_name)\n",
    "except:\n",
    "    pass"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "b0f18bab",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ruben/Escritorio/FilmAffinity/fun.py:71: GuessedAtParserWarning: No parser was explicitly specified, so I'm using the best available HTML parser for this system (\"lxml\"). This usually isn't a problem, but if you run this code on another system, or in a different virtual environment, it may use a different parser and behave differently.\n",
      "\n",
      "The code that caused this warning is on line 71 of the file /home/ruben/Escritorio/FilmAffinity/fun.py. To get rid of this warning, pass the additional argument 'features=\"lxml\"' to the BeautifulSoup constructor.\n",
      "\n",
      "  soup = BeautifulSoup(page.content, 'html')\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Importing info from internet...\n",
      "\t Stalker \n",
      "\t Triangle \n",
      "\t Redline \n",
      "\t La vida secreta de Walter Mitty \n",
      "\t La Tierra errante (The Wandering Earth) \n",
      "\t Otra Tierra \n",
      "\t Human Nature \n",
      "\t Delitos y faltas \n",
      "\t Persona \n",
      "\t El buscavidas \n",
      "\t Psicosis \n",
      "\t Alguien voló sobre el nido del cuco \n",
      "\t Ciudad de Dios \n",
      "\t Drive \n",
      "\t Despedidas \n",
      "\t Los amantes del círculo polar \n",
      "\t El maquinista \n",
      "\t Funny Games \n",
      "\t Mulholland Drive \n",
      "\t Beautiful Girls \n",
      "\t Nunca me abandones \n",
      "\t Las tortugas también vuelan \n",
      "\t El caballo de Turín \n",
      "\t La mujer de la arena \n",
      "\t Sin miedo a la vida \n",
      "\t Solaris \n",
      "\t Glengarry Glen Ross (Éxito a cualquier precio) \n",
      "\t Ray \n",
      "\t Bill Hicks: Revelations (TV)\n",
      "\t Sonata de otoño \n",
      "\t Cuentos de la luna pálida \n",
      "\t Chantaje en Broadway \n",
      "\t Fanny y Alexander \n",
      "\t El cazador \n",
      "\t El príncipe de la ciudad \n",
      "\t Lodge 49 (Serie de TV)\n",
      "\t Eduardo Manostijeras \n",
      "\t Forrest Gump \n",
      "\t Ha vuelto \n",
      "\t Devs (Miniserie de TV)\n",
      "\t This is Spinal Tap \n",
      "\t Toma el dinero y corre \n",
      "\t The Larry Sanders Show (Serie de TV)\n",
      "\t Documentary Now! (Serie de TV)\n",
      "\t Una mente maravillosa \n",
      "\t El almuerzo desnudo \n",
      "\t A Room for Romeo Brass \n",
      "\t Dead Man’s Shoes \n",
      "\t This Is England '88 (Miniserie de TV)\n",
      "\t Supongamos que Nueva York es una ciudad (Miniserie de TV)\n",
      "\t White God (Dios blanco) \n",
      "\t Dogville \n",
      "\t Bienvenidos a Belleville \n",
      "\t El espejo \n",
      "\t It Follows \n",
      "\t El crepúsculo de los dioses \n",
      "\t ReMine, el último movimiento obrero \n",
      "\t Midnight in Paris \n",
      "\t Amores perros \n",
      "\t Blow-Up (Deseo de una mañana de verano) \n",
      "\t 7 días en La Habana \n",
      "\t Los miserables \n",
      "\t Silver Lake \n",
      "\t La montaña sagrada \n",
      "\t Rain Man \n",
      "\t Green Book \n",
      "\t Bailando con lobos \n",
      "\t Belle Époque \n",
      "\t Todos a la cárcel \n",
      "\t Sin perdón \n",
      "\t El jinete pálido \n",
      "\t Todo sobre mi madre \n",
      "\t Los otros \n",
      "\t Chicago \n",
      "\t Los lunes al sol \n",
      "\t Un mundo perfecto \n",
      "\t Algo pasa con Mary \n",
      "\t Six Shooter (C)\n",
      "\t Waking Life \n",
      "\t Diarios de motocicleta \n",
      "\t Corazón salvaje \n",
      "\t Un plan irresistible \n",
      "\t Paris, Texas \n",
      "\t The Rocky Horror Picture Show \n",
      "\t Nonfilm \n",
      "\t ¿Quién engañó a Roger Rabbit? \n",
      "\t Citizenfour \n",
      "\t Hana-Bi. Flores de fuego \n",
      "\t Tabú \n",
      "\t La vida es bella \n",
      "\t Boyhood (Momentos de una vida) \n",
      "\t Sherlock: Estudio en rosa (TV)\n",
      "\t Un tipo serio \n",
      "\t 1997: Rescate en Nueva York \n",
      "\t Nomadland \n",
      "\t Holy Motors \n",
      "\t Notting Hill \n",
      "\t Manhunt: Unabomber (Miniserie de TV)\n",
      "\t Nine \n",
      "\t El protegido \n",
      "\t La juventud \n",
      "\t Alps \n",
      "\t Chevalier \n",
      "\t Truman Capote \n",
      "\t Magnolia \n",
      "\t La duda \n",
      "\t Boogie Nights \n",
      "\t Múltiple \n",
      "\t El truco final (El prestigio) \n",
      "\t Philadelphia \n"
     ]
    }
   ],
   "source": [
    "list_name, movies = import_movies(URL, num_pages)\n",
    "data = []\n",
    "print('Importing info from internet...')\n",
    "for movie in movies:\n",
    "    name, rating, URL = movie_info(movie)\n",
    "    print('\\t', name)\n",
    "    \n",
    "    platforms_countries = []\n",
    "    for country in countries:\n",
    "        page = requests.get(URL[:29]+country+URL[31:])\n",
    "        soup = BeautifulSoup(page.content, 'html')\n",
    "        platfforms = rent_plattforms(soup, country)\n",
    "        platforms_countries.append(platfforms)\n",
    "    \n",
    "    data.append([name, rating] + platforms_countries + [URL])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "8834695f",
   "metadata": {},
   "outputs": [],
   "source": [
    "#Name of the CSV generated with all movies in FA's list\n",
    "CSV_file_name = folder_name + list_name + '_list.csv'\n",
    "#Name of the CSV generated with all movies in FA's list that you can watch\n",
    "CSV_file_you_can_watch = folder_name + list_name +  '_you_can_watch.csv'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "6f84529d",
   "metadata": {},
   "outputs": [],
   "source": [
    "df = generate_movies_df(data, countries)\n",
    "df.to_csv(CSV_file_name)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "3523fc0d",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_you_can = what_you_can_watch(df, your_plattforms, countries)\n",
    "df_you_can.to_csv(CSV_file_you_can_watch)\n",
    "print('You can see from {} list all these movies: '.format(list_name))\n",
    "df_you_can\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "88cd761c",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_you_can.sort_values(by=\"Rating\", ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "cedeb4d2",
   "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.9.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}