Week14.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "provenance": [],
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/AlainWalbar/Database_2022/blob/main/Week_14DBLab.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "_JBemdqeP9Z0",
        "outputId": "d74e061c-e4b0-44ba-b60b-ecf636e29062"
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "How i met your mother\n",
            "The Sopranos\n",
            "Friday Night Lights\n",
            "Family Guy\n",
            "New Girl\n",
            "Friends\n",
            "Office\n",
            "Breaking Bad\n",
            "Modern Family\n",
            "Office\n",
            "White Collar\n",
            "Modern Family\n",
            "Game of Thrones\n",
            "the Untamed\n",
            "The 100\n",
            "Modern Family\n",
            "The Office\n",
            "New Girl\n",
            "The Office\n",
            "Avatar: The Last Airbender\n",
            "Cobra Kai\n",
            "Sherlock Homes\n",
            "New Girl\n",
            "arrow\n",
            "Grace and Frankie\n",
            "The Great British Baking Show\n",
            "The Mentalist\n",
            "Brooklyn-99\n",
            "Avatar The Last Airbender \n",
            "Parks and Rec\n",
            "Archer\n",
            "Friends\n",
            "The Simpsons\n",
            "Avatar The Last Airbender\n",
            "The Flash\n",
            "Avatar the Last Airbender \n",
            "New Girl\n",
            "Stranger Things\n",
            "Squid Game\n",
            "Friends \n",
            "Community\n",
            "Curb Your Enthusiasm\n",
            "Hannah Montana \n",
            "The Simpsons\n",
            "The Good Place\n",
            "Band of Brothers\n",
            "Jeopardy\n",
            "The Office\n",
            "The Good Place\n",
            "Violet Evergarden\n",
            "Avatar the Last Airbender\n",
            "Game of Thrones\n",
            "Breaking Bad\n",
            "Criminal Minds\n",
            "Shark Tank\n",
            "Star Trek: The Next Generation\n",
            "Squid Game\n",
            "White Collar\n",
            "Parks and Recreation \n",
            "Mad Men\n",
            "Friends\n",
            "South Park\n",
            "The Office \n",
            "Norsemen\n",
            "The West Wing\n",
            "Regular Show\n",
            "Ted Lasso\n",
            "The Wire\n",
            "Lost\n",
            "The Office\n",
            "Breaking Bad\n",
            "community\n",
            "Queen’s Gambit\n",
            "Community\n",
            "Friends\n",
            "How I Met Your Mother\n",
            "Six Flying Dragons\n",
            "Gilmore Girls\n",
            "Reba\n",
            "friends\n",
            "Evacuate Earth\n",
            "Friends\n",
            "The Flash\n",
            "The Office\n",
            "Supernatural \n",
            "Peaky Blinders\n",
            "Game of Thrones\n",
            "Game of Thrones\n",
            "Community\n",
            "Breaking Bad\n",
            "Community\n",
            "The Office\n",
            "The Good Place\n",
            "The Office\n",
            "You\n",
            "Community\n",
            "Grey's Anatomy\n",
            "Breaking Bad\n",
            "The Crown\n",
            "Arrested Development\n",
            "Avatar: The Last Airbender\n",
            "Black Mirror\n",
            "Friends\n",
            "Saturday Night Live\n",
            "How I Met Your Mother\n",
            "The Office\n",
            "the bachelorette\n",
            "The CROWN\n",
            "Law and order\n",
            "B99\n",
            "GoT\n",
            "Sherlock\n",
            "WandaVision\n",
            "Stranger Things\n",
            "The Good Place\n",
            "adventure time\n",
            "Parks and Rec\n",
            "squid game\n",
            "Yellowstone\n",
            "Brooklyn 99\n",
            "criminal minds\n",
            "The Haunting of Hill House\n",
            "Avatar\n",
            "the office\n",
            "The Office\n",
            "Game Of Thrones\n",
            "The Originals\n",
            "family guy\n",
            "Last Week Tonight with John Oliver\n",
            "Community\n",
            "WandaVision\n",
            "billions\n",
            "ThE OffiCE\n",
            "Friends\n",
            "The Office\n",
            "Top Gear\n",
            "Six Flying Dragons\n",
            "New Amsterdam\n",
            "Game of Thrones\n",
            "Blue Mountain State\n",
            "Community\n",
            "Its Always Sunny in Philidelphia\n",
            "Thevoffice\n",
            "Atlanta\n",
            "Good Omens\n",
            "The Big Bang Theory\n",
            "Grey's anatomy \n",
            "Gilmore girls\n",
            "Avatar: The Last Airbender\n",
            "Avatar the Last Airbender\n",
            "Hunter X Hunter\n",
            "brooklyn 99\n",
            "sherlock holmes \n",
            "Anne With An E\n",
            "Money Heist\n",
            "Succession\n",
            "Silicon Valley\n"
          ]
        }
      ],
      "source": [
        "# Prints all titles in CSV using csv.reader\n",
        "\n",
        "import csv\n",
        "\n",
        "# Open CSV file\n",
        "with open(\"favorites.csv\", \"r\") as file:\n",
        "\n",
        "    # Create reader\n",
        "    reader = csv.reader(file)\n",
        "\n",
        "    # Skip header row\n",
        "    next(reader)\n",
        "\n",
        "    # Iterate over CSV file, printing each title (row[\"title\"])\n",
        "    for row in reader:\n",
        "        print(row[1])\n"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# Prints unique titles in CSV, case sensitively\n",
        "\n",
        "import csv\n",
        "\n",
        "# For accumulating (and later sorting) titles\n",
        "titles = set()\n",
        "\n",
        "# Open CSV file\n",
        "with open(\"favorites.csv\", \"r\") as file:\n",
        "\n",
        "    # Create DictReader\n",
        "    reader = csv.DictReader(file)\n",
        "\n",
        "    # Iterate over CSV file, adding each title to set\n",
        "    for row in reader:\n",
        "        titles.add(row[\"title\"])\n",
        "\n",
        "# Print titles in sorted order\n",
        "for title in sorted(titles):\n",
        "    print(title)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "e5_3aVLyQsLN",
        "outputId": "ba32e63f-50e2-4ea4-92e8-69833f1b6f7f"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Anne With An E\n",
            "Archer\n",
            "Arrested Development\n",
            "Atlanta\n",
            "Avatar\n",
            "Avatar The Last Airbender\n",
            "Avatar The Last Airbender \n",
            "Avatar the Last Airbender\n",
            "Avatar the Last Airbender \n",
            "Avatar: The Last Airbender\n",
            "B99\n",
            "Band of Brothers\n",
            "Black Mirror\n",
            "Blue Mountain State\n",
            "Breaking Bad\n",
            "Brooklyn 99\n",
            "Brooklyn-99\n",
            "Cobra Kai\n",
            "Community\n",
            "Criminal Minds\n",
            "Curb Your Enthusiasm\n",
            "Evacuate Earth\n",
            "Family Guy\n",
            "Friday Night Lights\n",
            "Friends\n",
            "Friends \n",
            "Game Of Thrones\n",
            "Game of Thrones\n",
            "Gilmore Girls\n",
            "Gilmore girls\n",
            "GoT\n",
            "Good Omens\n",
            "Grace and Frankie\n",
            "Grey's Anatomy\n",
            "Grey's anatomy \n",
            "Hannah Montana \n",
            "How I Met Your Mother\n",
            "How i met your mother\n",
            "Hunter X Hunter\n",
            "Its Always Sunny in Philidelphia\n",
            "Jeopardy\n",
            "Last Week Tonight with John Oliver\n",
            "Law and order\n",
            "Lost\n",
            "Mad Men\n",
            "Modern Family\n",
            "Money Heist\n",
            "New Amsterdam\n",
            "New Girl\n",
            "Norsemen\n",
            "Office\n",
            "Parks and Rec\n",
            "Parks and Recreation \n",
            "Peaky Blinders\n",
            "Queen’s Gambit\n",
            "Reba\n",
            "Regular Show\n",
            "Saturday Night Live\n",
            "Shark Tank\n",
            "Sherlock\n",
            "Sherlock Homes\n",
            "Silicon Valley\n",
            "Six Flying Dragons\n",
            "South Park\n",
            "Squid Game\n",
            "Star Trek: The Next Generation\n",
            "Stranger Things\n",
            "Succession\n",
            "Supernatural \n",
            "Ted Lasso\n",
            "ThE OffiCE\n",
            "The 100\n",
            "The Big Bang Theory\n",
            "The CROWN\n",
            "The Crown\n",
            "The Flash\n",
            "The Good Place\n",
            "The Great British Baking Show\n",
            "The Haunting of Hill House\n",
            "The Mentalist\n",
            "The Office\n",
            "The Office \n",
            "The Originals\n",
            "The Simpsons\n",
            "The Sopranos\n",
            "The West Wing\n",
            "The Wire\n",
            "Thevoffice\n",
            "Top Gear\n",
            "Violet Evergarden\n",
            "WandaVision\n",
            "White Collar\n",
            "Yellowstone\n",
            "You\n",
            "adventure time\n",
            "arrow\n",
            "billions\n",
            "brooklyn 99\n",
            "community\n",
            "criminal minds\n",
            "family guy\n",
            "friends\n",
            "sherlock holmes \n",
            "squid game\n",
            "the Untamed\n",
            "the bachelorette\n",
            "the office\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# Prints unique titles in CSV, case insensitively\n",
        "\n",
        "import csv\n",
        "\n",
        "# For accumulating (and later sorting) titles\n",
        "titles = set()\n",
        "\n",
        "# Open CSV file\n",
        "with open(\"favorites.csv\", \"r\") as file:\n",
        "\n",
        "    # Create DictReader\n",
        "    reader = csv.DictReader(file)\n",
        "\n",
        "    # Iterate over CSV file, adding each (uppercased) title to set\n",
        "    for row in reader:\n",
        "        titles.add(row[\"title\"].strip().upper())\n",
        "\n",
        "# Print titles in sorted order\n",
        "for title in sorted(titles):\n",
        "    print(title)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "yK4tNEV1R4at",
        "outputId": "c8ad3717-3366-40cc-f62b-3fceb48d1b79"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "ADVENTURE TIME\n",
            "ANNE WITH AN E\n",
            "ARCHER\n",
            "ARRESTED DEVELOPMENT\n",
            "ARROW\n",
            "ATLANTA\n",
            "AVATAR\n",
            "AVATAR THE LAST AIRBENDER\n",
            "AVATAR: THE LAST AIRBENDER\n",
            "B99\n",
            "BAND OF BROTHERS\n",
            "BILLIONS\n",
            "BLACK MIRROR\n",
            "BLUE MOUNTAIN STATE\n",
            "BREAKING BAD\n",
            "BROOKLYN 99\n",
            "BROOKLYN-99\n",
            "COBRA KAI\n",
            "COMMUNITY\n",
            "CRIMINAL MINDS\n",
            "CURB YOUR ENTHUSIASM\n",
            "EVACUATE EARTH\n",
            "FAMILY GUY\n",
            "FRIDAY NIGHT LIGHTS\n",
            "FRIENDS\n",
            "GAME OF THRONES\n",
            "GILMORE GIRLS\n",
            "GOOD OMENS\n",
            "GOT\n",
            "GRACE AND FRANKIE\n",
            "GREY'S ANATOMY\n",
            "HANNAH MONTANA\n",
            "HOW I MET YOUR MOTHER\n",
            "HUNTER X HUNTER\n",
            "ITS ALWAYS SUNNY IN PHILIDELPHIA\n",
            "JEOPARDY\n",
            "LAST WEEK TONIGHT WITH JOHN OLIVER\n",
            "LAW AND ORDER\n",
            "LOST\n",
            "MAD MEN\n",
            "MODERN FAMILY\n",
            "MONEY HEIST\n",
            "NEW AMSTERDAM\n",
            "NEW GIRL\n",
            "NORSEMEN\n",
            "OFFICE\n",
            "PARKS AND REC\n",
            "PARKS AND RECREATION\n",
            "PEAKY BLINDERS\n",
            "QUEEN’S GAMBIT\n",
            "REBA\n",
            "REGULAR SHOW\n",
            "SATURDAY NIGHT LIVE\n",
            "SHARK TANK\n",
            "SHERLOCK\n",
            "SHERLOCK HOLMES\n",
            "SHERLOCK HOMES\n",
            "SILICON VALLEY\n",
            "SIX FLYING DRAGONS\n",
            "SOUTH PARK\n",
            "SQUID GAME\n",
            "STAR TREK: THE NEXT GENERATION\n",
            "STRANGER THINGS\n",
            "SUCCESSION\n",
            "SUPERNATURAL\n",
            "TED LASSO\n",
            "THE 100\n",
            "THE BACHELORETTE\n",
            "THE BIG BANG THEORY\n",
            "THE CROWN\n",
            "THE FLASH\n",
            "THE GOOD PLACE\n",
            "THE GREAT BRITISH BAKING SHOW\n",
            "THE HAUNTING OF HILL HOUSE\n",
            "THE MENTALIST\n",
            "THE OFFICE\n",
            "THE ORIGINALS\n",
            "THE SIMPSONS\n",
            "THE SOPRANOS\n",
            "THE UNTAMED\n",
            "THE WEST WING\n",
            "THE WIRE\n",
            "THEVOFFICE\n",
            "TOP GEAR\n",
            "VIOLET EVERGARDEN\n",
            "WANDAVISION\n",
            "WHITE COLLAR\n",
            "YELLOWSTONE\n",
            "YOU\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# Prints popularity of titles in CSV, sorted by title\n",
        "\n",
        "import csv\n",
        "\n",
        "# For accumulating (and later sorting) titles\n",
        "titles = {}\n",
        "\n",
        "# Open CSV file\n",
        "with open(\"favorites.csv\", \"r\") as file:\n",
        "\n",
        "    # Create DictReader\n",
        "    reader = csv.DictReader(file)\n",
        "\n",
        "    # Iterate over CSV file, adding each (uppercased) title to dictionary\n",
        "    for row in reader:\n",
        "\n",
        "        # Canoncalize title\n",
        "        title = row[\"title\"].strip().upper()\n",
        "\n",
        "        # Count title\n",
        "        if title in titles:\n",
        "            titles[title] += 1\n",
        "        else:\n",
        "            titles[title] = 1\n",
        "\n",
        "# Print titles in sorted order\n",
        "for title in sorted(titles):\n",
        "    print(title, titles[title])"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "a6GeVQo3SGqd",
        "outputId": "3ab9dcb3-f6da-439c-8d2d-9c8b34be80ae"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "ADVENTURE TIME 1\n",
            "ANNE WITH AN E 1\n",
            "ARCHER 1\n",
            "ARRESTED DEVELOPMENT 1\n",
            "ARROW 1\n",
            "ATLANTA 1\n",
            "AVATAR 1\n",
            "AVATAR THE LAST AIRBENDER 5\n",
            "AVATAR: THE LAST AIRBENDER 3\n",
            "B99 1\n",
            "BAND OF BROTHERS 1\n",
            "BILLIONS 1\n",
            "BLACK MIRROR 1\n",
            "BLUE MOUNTAIN STATE 1\n",
            "BREAKING BAD 5\n",
            "BROOKLYN 99 2\n",
            "BROOKLYN-99 1\n",
            "COBRA KAI 1\n",
            "COMMUNITY 8\n",
            "CRIMINAL MINDS 2\n",
            "CURB YOUR ENTHUSIASM 1\n",
            "EVACUATE EARTH 1\n",
            "FAMILY GUY 2\n",
            "FRIDAY NIGHT LIGHTS 1\n",
            "FRIENDS 9\n",
            "GAME OF THRONES 6\n",
            "GILMORE GIRLS 2\n",
            "GOOD OMENS 1\n",
            "GOT 1\n",
            "GRACE AND FRANKIE 1\n",
            "GREY'S ANATOMY 2\n",
            "HANNAH MONTANA 1\n",
            "HOW I MET YOUR MOTHER 3\n",
            "HUNTER X HUNTER 1\n",
            "ITS ALWAYS SUNNY IN PHILIDELPHIA 1\n",
            "JEOPARDY 1\n",
            "LAST WEEK TONIGHT WITH JOHN OLIVER 1\n",
            "LAW AND ORDER 1\n",
            "LOST 1\n",
            "MAD MEN 1\n",
            "MODERN FAMILY 3\n",
            "MONEY HEIST 1\n",
            "NEW AMSTERDAM 1\n",
            "NEW GIRL 4\n",
            "NORSEMEN 1\n",
            "OFFICE 2\n",
            "PARKS AND REC 2\n",
            "PARKS AND RECREATION 1\n",
            "PEAKY BLINDERS 1\n",
            "QUEEN’S GAMBIT 1\n",
            "REBA 1\n",
            "REGULAR SHOW 1\n",
            "SATURDAY NIGHT LIVE 1\n",
            "SHARK TANK 1\n",
            "SHERLOCK 1\n",
            "SHERLOCK HOLMES 1\n",
            "SHERLOCK HOMES 1\n",
            "SILICON VALLEY 1\n",
            "SIX FLYING DRAGONS 2\n",
            "SOUTH PARK 1\n",
            "SQUID GAME 3\n",
            "STAR TREK: THE NEXT GENERATION 1\n",
            "STRANGER THINGS 2\n",
            "SUCCESSION 1\n",
            "SUPERNATURAL 1\n",
            "TED LASSO 1\n",
            "THE 100 1\n",
            "THE BACHELORETTE 1\n",
            "THE BIG BANG THEORY 1\n",
            "THE CROWN 2\n",
            "THE FLASH 2\n",
            "THE GOOD PLACE 4\n",
            "THE GREAT BRITISH BAKING SHOW 1\n",
            "THE HAUNTING OF HILL HOUSE 1\n",
            "THE MENTALIST 1\n",
            "THE OFFICE 13\n",
            "THE ORIGINALS 1\n",
            "THE SIMPSONS 2\n",
            "THE SOPRANOS 1\n",
            "THE UNTAMED 1\n",
            "THE WEST WING 1\n",
            "THE WIRE 1\n",
            "THEVOFFICE 1\n",
            "TOP GEAR 1\n",
            "VIOLET EVERGARDEN 1\n",
            "WANDAVISION 2\n",
            "WHITE COLLAR 2\n",
            "YELLOWSTONE 1\n",
            "YOU 1\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# Prints popularity of titles in CSV, sorted by popularity\n",
        "\n",
        "import csv\n",
        "\n",
        "# For accumulating (and later sorting) titles\n",
        "titles = {}\n",
        "\n",
        "# Open CSV file\n",
        "with open(\"favorites.csv\", \"r\") as file:\n",
        "\n",
        "    # Create DictReader\n",
        "    reader = csv.DictReader(file)\n",
        "\n",
        "    # Iterate over CSV file, adding each (uppercased) title to dictionary\n",
        "    for row in reader:\n",
        "\n",
        "        # Canoncalize title\n",
        "        title = row[\"title\"].strip().upper()\n",
        "\n",
        "        # Count title\n",
        "        if title in titles:\n",
        "            titles[title] += 1\n",
        "        else:\n",
        "            titles[title] = 1\n",
        "\n",
        "# Function for comparing titles by popularity\n",
        "def get_value(title):\n",
        "    return titles[title]\n",
        "\n",
        "# Print titles in sorted order\n",
        "for title in sorted(titles, key=get_value, reverse=True):\n",
        "    print(title, titles[title])"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "YQH_ehW_SZzN",
        "outputId": "29912101-0cf3-402c-cda2-b46571c55a54"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "THE OFFICE 13\n",
            "FRIENDS 9\n",
            "COMMUNITY 8\n",
            "GAME OF THRONES 6\n",
            "BREAKING BAD 5\n",
            "AVATAR THE LAST AIRBENDER 5\n",
            "NEW GIRL 4\n",
            "THE GOOD PLACE 4\n",
            "HOW I MET YOUR MOTHER 3\n",
            "MODERN FAMILY 3\n",
            "AVATAR: THE LAST AIRBENDER 3\n",
            "SQUID GAME 3\n",
            "FAMILY GUY 2\n",
            "OFFICE 2\n",
            "WHITE COLLAR 2\n",
            "PARKS AND REC 2\n",
            "THE SIMPSONS 2\n",
            "THE FLASH 2\n",
            "STRANGER THINGS 2\n",
            "CRIMINAL MINDS 2\n",
            "SIX FLYING DRAGONS 2\n",
            "GILMORE GIRLS 2\n",
            "GREY'S ANATOMY 2\n",
            "THE CROWN 2\n",
            "WANDAVISION 2\n",
            "BROOKLYN 99 2\n",
            "THE SOPRANOS 1\n",
            "FRIDAY NIGHT LIGHTS 1\n",
            "THE UNTAMED 1\n",
            "THE 100 1\n",
            "COBRA KAI 1\n",
            "SHERLOCK HOMES 1\n",
            "ARROW 1\n",
            "GRACE AND FRANKIE 1\n",
            "THE GREAT BRITISH BAKING SHOW 1\n",
            "THE MENTALIST 1\n",
            "BROOKLYN-99 1\n",
            "ARCHER 1\n",
            "CURB YOUR ENTHUSIASM 1\n",
            "HANNAH MONTANA 1\n",
            "BAND OF BROTHERS 1\n",
            "JEOPARDY 1\n",
            "VIOLET EVERGARDEN 1\n",
            "SHARK TANK 1\n",
            "STAR TREK: THE NEXT GENERATION 1\n",
            "PARKS AND RECREATION 1\n",
            "MAD MEN 1\n",
            "SOUTH PARK 1\n",
            "NORSEMEN 1\n",
            "THE WEST WING 1\n",
            "REGULAR SHOW 1\n",
            "TED LASSO 1\n",
            "THE WIRE 1\n",
            "LOST 1\n",
            "QUEEN’S GAMBIT 1\n",
            "REBA 1\n",
            "EVACUATE EARTH 1\n",
            "SUPERNATURAL 1\n",
            "PEAKY BLINDERS 1\n",
            "YOU 1\n",
            "ARRESTED DEVELOPMENT 1\n",
            "BLACK MIRROR 1\n",
            "SATURDAY NIGHT LIVE 1\n",
            "THE BACHELORETTE 1\n",
            "LAW AND ORDER 1\n",
            "B99 1\n",
            "GOT 1\n",
            "SHERLOCK 1\n",
            "ADVENTURE TIME 1\n",
            "YELLOWSTONE 1\n",
            "THE HAUNTING OF HILL HOUSE 1\n",
            "AVATAR 1\n",
            "THE ORIGINALS 1\n",
            "LAST WEEK TONIGHT WITH JOHN OLIVER 1\n",
            "BILLIONS 1\n",
            "TOP GEAR 1\n",
            "NEW AMSTERDAM 1\n",
            "BLUE MOUNTAIN STATE 1\n",
            "ITS ALWAYS SUNNY IN PHILIDELPHIA 1\n",
            "THEVOFFICE 1\n",
            "ATLANTA 1\n",
            "GOOD OMENS 1\n",
            "THE BIG BANG THEORY 1\n",
            "HUNTER X HUNTER 1\n",
            "SHERLOCK HOLMES 1\n",
            "ANNE WITH AN E 1\n",
            "MONEY HEIST 1\n",
            "SUCCESSION 1\n",
            "SILICON VALLEY 1\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# Prints popularity of titles in CSV, sorted by popularity, using a lambda function\n",
        "\n",
        "import csv\n",
        "\n",
        "# For accumulating (and later sorting) titles\n",
        "titles = {}\n",
        "\n",
        "# Open CSV file\n",
        "with open(\"favorites.csv\", \"r\") as file:\n",
        "\n",
        "    # Create DictReader\n",
        "    reader = csv.DictReader(file)\n",
        "\n",
        "    # Iterate over CSV file\n",
        "    for row in reader:\n",
        "\n",
        "        # Canoncalize title\n",
        "        title = row[\"title\"].strip().upper()\n",
        "\n",
        "        # Update counter\n",
        "        if title in titles:\n",
        "            titles[title] += 1\n",
        "        else:\n",
        "            titles[title] = 1\n",
        "\n",
        "# Print titles in sorted order\n",
        "for title in sorted(titles, key=lambda title: titles[title], reverse=True):\n",
        "    print(title, titles[title])"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "mcCqTExwS2rW",
        "outputId": "8fb2fa5a-d923-433b-8aac-eb601037a377"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "THE OFFICE 13\n",
            "FRIENDS 9\n",
            "COMMUNITY 8\n",
            "GAME OF THRONES 6\n",
            "BREAKING BAD 5\n",
            "AVATAR THE LAST AIRBENDER 5\n",
            "NEW GIRL 4\n",
            "THE GOOD PLACE 4\n",
            "HOW I MET YOUR MOTHER 3\n",
            "MODERN FAMILY 3\n",
            "AVATAR: THE LAST AIRBENDER 3\n",
            "SQUID GAME 3\n",
            "FAMILY GUY 2\n",
            "OFFICE 2\n",
            "WHITE COLLAR 2\n",
            "PARKS AND REC 2\n",
            "THE SIMPSONS 2\n",
            "THE FLASH 2\n",
            "STRANGER THINGS 2\n",
            "CRIMINAL MINDS 2\n",
            "SIX FLYING DRAGONS 2\n",
            "GILMORE GIRLS 2\n",
            "GREY'S ANATOMY 2\n",
            "THE CROWN 2\n",
            "WANDAVISION 2\n",
            "BROOKLYN 99 2\n",
            "THE SOPRANOS 1\n",
            "FRIDAY NIGHT LIGHTS 1\n",
            "THE UNTAMED 1\n",
            "THE 100 1\n",
            "COBRA KAI 1\n",
            "SHERLOCK HOMES 1\n",
            "ARROW 1\n",
            "GRACE AND FRANKIE 1\n",
            "THE GREAT BRITISH BAKING SHOW 1\n",
            "THE MENTALIST 1\n",
            "BROOKLYN-99 1\n",
            "ARCHER 1\n",
            "CURB YOUR ENTHUSIASM 1\n",
            "HANNAH MONTANA 1\n",
            "BAND OF BROTHERS 1\n",
            "JEOPARDY 1\n",
            "VIOLET EVERGARDEN 1\n",
            "SHARK TANK 1\n",
            "STAR TREK: THE NEXT GENERATION 1\n",
            "PARKS AND RECREATION 1\n",
            "MAD MEN 1\n",
            "SOUTH PARK 1\n",
            "NORSEMEN 1\n",
            "THE WEST WING 1\n",
            "REGULAR SHOW 1\n",
            "TED LASSO 1\n",
            "THE WIRE 1\n",
            "LOST 1\n",
            "QUEEN’S GAMBIT 1\n",
            "REBA 1\n",
            "EVACUATE EARTH 1\n",
            "SUPERNATURAL 1\n",
            "PEAKY BLINDERS 1\n",
            "YOU 1\n",
            "ARRESTED DEVELOPMENT 1\n",
            "BLACK MIRROR 1\n",
            "SATURDAY NIGHT LIVE 1\n",
            "THE BACHELORETTE 1\n",
            "LAW AND ORDER 1\n",
            "B99 1\n",
            "GOT 1\n",
            "SHERLOCK 1\n",
            "ADVENTURE TIME 1\n",
            "YELLOWSTONE 1\n",
            "THE HAUNTING OF HILL HOUSE 1\n",
            "AVATAR 1\n",
            "THE ORIGINALS 1\n",
            "LAST WEEK TONIGHT WITH JOHN OLIVER 1\n",
            "BILLIONS 1\n",
            "TOP GEAR 1\n",
            "NEW AMSTERDAM 1\n",
            "BLUE MOUNTAIN STATE 1\n",
            "ITS ALWAYS SUNNY IN PHILIDELPHIA 1\n",
            "THEVOFFICE 1\n",
            "ATLANTA 1\n",
            "GOOD OMENS 1\n",
            "THE BIG BANG THEORY 1\n",
            "HUNTER X HUNTER 1\n",
            "SHERLOCK HOLMES 1\n",
            "ANNE WITH AN E 1\n",
            "MONEY HEIST 1\n",
            "SUCCESSION 1\n",
            "SILICON VALLEY 1\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "import csv\n",
        "import re\n",
        "\n",
        "# For counting mentions of The Office\n",
        "counter = 0\n",
        "\n",
        "# Open CSV File\n",
        "with open(\"favorites.csv\", \"r\") as file:\n",
        "\n",
        "    # Create DictReader\n",
        "    reader = csv.DictReader(file)\n",
        "\n",
        "    # Iterate over CSV file, counting mentions of OFFICE and THE OFFICE\n",
        "    for row in reader:\n",
        "        title = row[\"title\"].strip().upper()\n",
        "        if re.search(\"^(OFFICE|THE OFFICE)$\", title):\n",
        "            counter += 1\n",
        "\n",
        "# Print popularity\n",
        "print(f\"Number of people who like The Office: {counter}\")"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "lMHKOWGsTMBu",
        "outputId": "5e40c247-2cf1-4e65-c9e9-2fd2f34137fd"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Number of people who like The Office: 15\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# Searches CSV for popularity of a title\n",
        "\n",
        "import csv\n",
        "\n",
        "# Prompt user for title\n",
        "title = input(\"Title: \").strip().upper()\n",
        "\n",
        "# Open CSV file\n",
        "with open(\"favorites.csv\", \"r\") as file:\n",
        "\n",
        "    # Create DictReader\n",
        "    reader = csv.DictReader(file)\n",
        "\n",
        "    # Iterate over CSV file, counting favorites\n",
        "    counter = 0\n",
        "    for row in reader:\n",
        "        if row[\"title\"].strip().upper() == title:\n",
        "            counter += 1\n",
        "\n",
        "# Print popularity\n",
        "print(counter)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "ZGADpRKCTdwm",
        "outputId": "e7057ad9-8dce-429f-aa1c-f0e303ddcab9"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Title: GAME OF THRONES\n",
            "6\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# Imports titles and genres from CSV into a SQLite database\n",
        "\n",
        "import csv\n",
        "\n",
        "# Create database\n",
        "from sqlalchemy import create_engine\n",
        "db = create_engine(\"sqlite:////content/favorites.db/\")\n",
        "print(db.name)\n",
        "\n",
        "\n",
        "# Create tables\n",
        "db.execute(\"CREATE TABLE shows (id INTEGER, title TEXT NOT NULL, PRIMARY KEY(id))\")\n",
        "db.execute(\"CREATE TABLE genres (show_id INTEGER, genre TEXT NOT NULL, FOREIGN KEY(show_id) REFERENCES shows(id))\")\n",
        "\n",
        "r_set=db.execute('''select name from sqlite_master where type = 'table' ''')\n",
        "for row in r_set:\n",
        "  print(row)\n",
        "\n",
        "# Open CSV file\n",
        "with open(\"favorites.csv\", \"r\") as file:\n",
        "\n",
        "    # Create DictReader\n",
        "    reader = csv.DictReader(file)\n",
        "    show_id = 1\n",
        "    # Iterate over CSV file\n",
        "    for row in reader:\n",
        "\n",
        "        # Canoncalize title\n",
        "        title = row[\"title\"].strip().upper()\n",
        "\n",
        "        # Insert title\n",
        "        db.execute(\"INSERT INTO shows (id, title) VALUES(?,?)\",show_id,title)\n",
        "        show_id = show_id + 1\n",
        "\n",
        "        # Insert genres\n",
        "        for genre in row[\"genres\"].split(\", \"):\n",
        "            print(genre + \"||\"+ str(show_id))\n",
        "            db.execute(\"INSERT INTO genres (show_id, genre) VALUES(?, ?)\", show_id, genre)\n",
        "            "
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "VCuqgQ1LTyv2",
        "outputId": "5e378ec0-e47c-4a0e-ed9c-1de3f06729b9"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "sqlite\n",
            "('shows',)\n",
            "('genres',)\n",
            "Comedy||2\n",
            "Comedy||3\n",
            "Crime||3\n",
            "Drama||3\n",
            "Horror||3\n",
            "Sci-Fi||3\n",
            "Talk-Show||3\n",
            "Thriller||3\n",
            "Drama||4\n",
            "Family||4\n",
            "Sport||4\n",
            "Animation||5\n",
            "Comedy||5\n",
            "Comedy||6\n",
            "Comedy||7\n",
            "Comedy||8\n",
            "Crime||9\n",
            "Drama||9\n",
            "Comedy||10\n",
            "Comedy||11\n",
            "Action||12\n",
            "Crime||12\n",
            "Drama||12\n",
            "Comedy||13\n",
            "Family||13\n",
            "Action||14\n",
            "Adventure||14\n",
            "Drama||14\n",
            "Fantasy||14\n",
            "Thriller||14\n",
            "War||14\n",
            "Action||15\n",
            "Drama||15\n",
            "Fantasy||15\n",
            "History||15\n",
            "Romance||15\n",
            "Action||16\n",
            "Sci-Fi||16\n",
            "Comedy||17\n",
            "Family||17\n",
            "Comedy||18\n",
            "Comedy||19\n",
            "Comedy||20\n",
            "Adventure||21\n",
            "Animation||21\n",
            "Action||22\n",
            "Sport||22\n",
            "Crime||23\n",
            "Drama||23\n",
            "Mystery||23\n",
            "Comedy||24\n",
            "Action||25\n",
            "Crime||25\n",
            "Fantasy||25\n",
            "Comedy||26\n",
            "Romance||26\n",
            "Game-Show||27\n",
            "Crime||28\n",
            "Mystery||28\n",
            "Action||29\n",
            "Comedy||29\n",
            "Crime||29\n",
            "Action||30\n",
            "Adventure||30\n",
            "Animation||30\n",
            "Comedy||30\n",
            "Family||30\n",
            "Fantasy||30\n",
            "Comedy||31\n",
            "Action||32\n",
            "Animation||32\n",
            "Comedy||32\n",
            "Comedy||33\n",
            "Comedy||34\n",
            "Action||35\n",
            "Animation||35\n",
            "Crime||35\n",
            "Action||36\n",
            "Crime||36\n",
            "Action||37\n",
            "Animation||37\n",
            "Fantasy||37\n",
            "Comedy||38\n",
            "Action||39\n",
            "Adventure||39\n",
            "Action||40\n",
            "Adventure||40\n",
            "Drama||40\n",
            "Thriller||40\n",
            "Comedy||41\n",
            "Comedy||42\n",
            "Comedy||43\n",
            "Comedy||44\n",
            "Family||44\n",
            "Comedy||45\n",
            "Comedy||46\n",
            "Action||47\n",
            "Biography||47\n",
            "Documentary||47\n",
            "Drama||47\n",
            "History||47\n",
            "War||47\n",
            "Game-Show||48\n",
            "Comedy||49\n",
            "Comedy||50\n",
            "Fantasy||50\n",
            "Animation||51\n",
            "Drama||51\n",
            "Adventure||52\n",
            "Comedy||52\n",
            "Family||52\n",
            "Action||53\n",
            "Adventure||53\n",
            "Drama||53\n",
            "Action||54\n",
            "Crime||54\n",
            "Drama||54\n",
            "Thriller||54\n",
            "Crime||55\n",
            "Family||56\n",
            "Sci-Fi||57\n",
            "Action||58\n",
            "Horror||58\n",
            "Thriller||58\n",
            "Crime||59\n",
            "Drama||59\n",
            "Comedy||60\n",
            "Documentary||60\n",
            "Drama||61\n",
            "Comedy||62\n",
            "Comedy||63\n",
            "Comedy||64\n",
            "Adventure||65\n",
            "Comedy||65\n",
            "History||65\n",
            "Drama||66\n",
            "Comedy||67\n",
            "Comedy||68\n",
            "Crime||69\n",
            "Drama||69\n",
            "Action||70\n",
            "Adventure||70\n",
            "Fantasy||70\n",
            "Sci-Fi||70\n",
            "Comedy||71\n",
            "Action||72\n",
            "Comedy||73\n",
            "Drama||74\n",
            "Thriller||74\n",
            "Comedy||75\n",
            "Comedy||76\n",
            "Comedy||77\n",
            "Action||78\n",
            "Drama||78\n",
            "History||78\n",
            "Family||79\n",
            "Horror||79\n",
            "Romance||79\n",
            "Comedy||80\n",
            "Comedy||81\n",
            "Sci-Fi||82\n",
            "Comedy||83\n",
            "Sci-Fi||84\n",
            "Animation||85\n",
            "Comedy||85\n",
            "Sci-Fi||85\n",
            "Action||86\n",
            "Drama||86\n",
            "Fantasy||86\n",
            "Horror||86\n",
            "Mystery||86\n",
            "Action||87\n",
            "Adventure||87\n",
            "Crime||87\n",
            "Drama||87\n",
            "History||87\n",
            "Action||88\n",
            "Adventure||88\n",
            "Comedy||88\n",
            "Drama||88\n",
            "Family||88\n",
            "Fantasy||88\n",
            "History||88\n",
            "Horror||88\n",
            "Musical||88\n",
            "Mystery||88\n",
            "Romance||88\n",
            "Thriller||88\n",
            "War||88\n",
            "Action||89\n",
            "Drama||89\n",
            "Family||89\n",
            "Fantasy||89\n",
            "War||89\n",
            "Comedy||90\n",
            "Crime||91\n",
            "Comedy||92\n",
            "Comedy||93\n",
            "Drama||93\n",
            "Adventure||94\n",
            "Comedy||94\n",
            "Drama||94\n",
            "Comedy||95\n",
            "Drama||96\n",
            "Thriller||96\n",
            "Comedy||97\n",
            "Drama||98\n",
            "Action||99\n",
            "Comedy||99\n",
            "Crime||99\n",
            "Comedy||100\n",
            "Comedy||101\n",
            "Action||102\n",
            "Adventure||102\n",
            "Animation||102\n",
            "Fantasy||102\n",
            "Action||103\n",
            "Adventure||103\n",
            "Animation||103\n",
            "Biography||103\n",
            "Comedy||103\n",
            "Crime||103\n",
            "Documentary||103\n",
            "Drama||103\n",
            "Family||103\n",
            "Fantasy||103\n",
            "Game-Show||103\n",
            "History||103\n",
            "Horror||103\n",
            "Music||103\n",
            "Musical||103\n",
            "Mystery||103\n",
            "News||103\n",
            "Reality-TV||103\n",
            "Romance||103\n",
            "Sci-Fi||103\n",
            "Short||103\n",
            "Sport||103\n",
            "Talk-Show||103\n",
            "Thriller||103\n",
            "War||103\n",
            "Western||103\n",
            "Comedy||104\n",
            "Comedy||105\n",
            "Comedy||106\n",
            "Comedy||107\n",
            "Reality-TV||108\n",
            "Romance||108\n",
            "Drama||109\n",
            "Crime||110\n",
            "Drama||110\n",
            "Mystery||110\n",
            "Thriller||110\n",
            "Comedy||111\n",
            "Action||112\n",
            "Mystery||113\n",
            "Action||114\n",
            "Comedy||114\n",
            "Drama||114\n",
            "Thriller||114\n",
            "Action||115\n",
            "Adventure||115\n",
            "Sci-Fi||115\n",
            "Comedy||116\n",
            "Family||116\n",
            "Fantasy||116\n",
            "Adventure||117\n",
            "Drama||117\n",
            "Romance||117\n",
            "Comedy||118\n",
            "Action||119\n",
            "Drama||119\n",
            "Game-Show||119\n",
            "Horror||119\n",
            "Mystery||119\n",
            "Thriller||119\n",
            "Western||120\n",
            "Comedy||121\n",
            "Crime||121\n",
            "Crime||122\n",
            "Horror||123\n",
            "Action||124\n",
            "Animation||124\n",
            "Fantasy||124\n",
            "Comedy||125\n",
            "Comedy||126\n",
            "Thriller||127\n",
            "Drama||128\n",
            "Comedy||129\n",
            "Comedy||130\n",
            "News||130\n",
            "Talk-Show||130\n",
            "Comedy||131\n",
            "Action||132\n",
            "Fantasy||132\n",
            "Sci-Fi||132\n",
            "Comedy||133\n",
            "Drama||133\n",
            "Comedy||134\n",
            "Comedy||135\n",
            "Family||135\n",
            "Documentary||136\n",
            "Action||137\n",
            "Adventure||137\n",
            "Comedy||137\n",
            "Documentary||137\n",
            "Family||137\n",
            "Action||138\n",
            "Drama||138\n",
            "History||138\n",
            "Drama||139\n",
            "Fantasy||140\n",
            "Thriller||140\n",
            "War||140\n",
            "Action||141\n",
            "Comedy||141\n",
            "Sport||141\n",
            "Action||142\n",
            "Adventure||142\n",
            "Animation||142\n",
            "Comedy||142\n",
            "Crime||142\n",
            "Documentary||142\n",
            "Drama||142\n",
            "Family||142\n",
            "Fantasy||142\n",
            "Game-Show||142\n",
            "History||142\n",
            "Horror||142\n",
            "Music||142\n",
            "Musical||142\n",
            "Mystery||142\n",
            "News||142\n",
            "Romance||142\n",
            "Sci-Fi||142\n",
            "Sport||142\n",
            "Talk-Show||142\n",
            "Thriller||142\n",
            "War||142\n",
            "Western||142\n",
            "Comedy||143\n",
            "Drama||143\n",
            "Comedy||144\n",
            "Drama||145\n",
            "Comedy||146\n",
            "Drama||146\n",
            "Fantasy||146\n",
            "Sci-Fi||146\n",
            "Comedy||147\n",
            "Drama||148\n",
            "Comedy||149\n",
            "Drama||149\n",
            "Action||150\n",
            "Animation||150\n",
            "Adventure||151\n",
            "Comedy||151\n",
            "Drama||151\n",
            "Family||151\n",
            "Fantasy||151\n",
            "Action||152\n",
            "Adventure||152\n",
            "Animation||152\n",
            "Comedy||153\n",
            "Crime||153\n",
            "Crime||154\n",
            "Drama||154\n",
            "Mystery||154\n",
            "Drama||155\n",
            "Action||156\n",
            "Adventure||156\n",
            "Crime||156\n",
            "Horror||156\n",
            "Mystery||156\n",
            "Sci-Fi||156\n",
            "Thriller||156\n",
            "War||156\n",
            "Drama||157\n",
            "Comedy||158\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# Searches CSV for popularity of a title\n",
        "\n",
        "import csv\n",
        "\n",
        "# Open database\n",
        "from sqlalchemy import create_engine\n",
        "db = create_engine(\"sqlite:////content/favorites.db/\")\n",
        "print(db.name)\n",
        "\n",
        "# Prompt user for title\n",
        "title = input(\"Title: \").strip()\n",
        "\n",
        "# Search for title\n",
        "r_set = db.execute(\"SELECT COUNT(*) AS counter FROM shows WHERE title LIKE ?\", \"%\" + title + \"%\")\n",
        "\n",
        "# Get first (and only) row\n",
        "# Print popularity\n",
        "data=r_set.fetchall()\n",
        "for row in data:\n",
        "    print(row[0])\n",
        "\n"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "AK06We0eeJvx",
        "outputId": "56118e9e-1268-4b31-f5bf-9a1a2bf5562b"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "sqlite\n",
            "Title: Office\n",
            "16\n"
          ]
        }
      ]
    }
  ]
}