Pandas1.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd # the most powerful line :-)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "     show_id     type                           title  \\\n",
      "0         s1    Movie                   A Spark Story   \n",
      "1         s2    Movie                  Spooky Buddies   \n",
      "2         s3    Movie          The Fault in Our Stars   \n",
      "3         s4  TV Show                 Dog: Impossible   \n",
      "4         s5  TV Show  Spidey And His Amazing Friends   \n",
      "...      ...      ...                             ...   \n",
      "1363   s1364    Movie          The Sword in the Stone   \n",
      "1364   s1365    Movie                 Those Calloways   \n",
      "1365   s1366  TV Show            Disney Kirby Buckets   \n",
      "1366   s1367  TV Show                  Disney Mech-X4   \n",
      "1367   s1368  TV Show              Imagination Movers   \n",
      "\n",
      "                        director  \\\n",
      "0     Jason Sterman, Leanne Dare   \n",
      "1                   Robert Vince   \n",
      "2                     Josh Boone   \n",
      "3                            NaN   \n",
      "4                            NaN   \n",
      "...                          ...   \n",
      "1363         Wolfgang Reitherman   \n",
      "1364                Norman Tokar   \n",
      "1365                         NaN   \n",
      "1366                         NaN   \n",
      "1367                         NaN   \n",
      "\n",
      "                                                   cast  \\\n",
      "0                         Apthon Corbin, Louis Gonzales   \n",
      "1     Tucker Albrizzi, Diedrich Bader, Ameko Eks Mas...   \n",
      "2     Shailene Woodley, Ansel Elgort, Laura Dern, Sa...   \n",
      "3                                          Matt Beisner   \n",
      "4     Benjamin Valic, Lily Sanfelippo, Jakari Fraser...   \n",
      "...                                                 ...   \n",
      "1363  Sebastian Cabot, Karl Swenson, Rickie Sorensen...   \n",
      "1364  Brian Keith, Vera Miles, Brandon de Wilde, Wal...   \n",
      "1365  Jacob Bertrand, Mekai Curtis, Cade Sutton, Oli...   \n",
      "1366  Nathaniel Potvin, Raymond Cham, Kamran Lucas, ...   \n",
      "1367  Rich Collins, Dave Poche, Scott Durbin, Scott ...   \n",
      "\n",
      "                    country          date_added  release_year rating  \\\n",
      "0                       NaN  September 24, 2021          2021  TV-PG   \n",
      "1     United States, Canada  September 24, 2021          2011      G   \n",
      "2             United States  September 24, 2021          2014  PG-13   \n",
      "3             United States  September 22, 2021          2019  TV-PG   \n",
      "4             United States  September 22, 2021          2021   TV-Y   \n",
      "...                     ...                 ...           ...    ...   \n",
      "1363          United States     October 1, 2019          1963      G   \n",
      "1364          United States     October 1, 2019          1965     PG   \n",
      "1365          United States                 NaN          2014  TV-Y7   \n",
      "1366                 Canada                 NaN          2016  TV-Y7   \n",
      "1367          United States                 NaN          2008   TV-Y   \n",
      "\n",
      "       duration                                  listed_in  \\\n",
      "0        88 min                                Documentary   \n",
      "1        93 min                      Comedy, Fantasy, Kids   \n",
      "2       127 min              Coming of Age, Drama, Romance   \n",
      "3     2 Seasons       Animals & Nature, Docuseries, Family   \n",
      "4      1 Season          Action-Adventure, Animation, Kids   \n",
      "...         ...                                        ...   \n",
      "1363     80 min        Action-Adventure, Animation, Comedy   \n",
      "1364    132 min            Animals & Nature, Drama, Family   \n",
      "1365  3 Seasons    Action-Adventure, Comedy, Coming of Age   \n",
      "1366  2 Seasons  Action-Adventure, Comedy, Science Fiction   \n",
      "1367  3 Seasons                                Kids, Music   \n",
      "\n",
      "                                            description  \n",
      "0     Two Pixar filmmakers strive to bring their uni...  \n",
      "1     The puppies go on a spooky adventure through a...  \n",
      "2     Hazel and Gus share a love that sweeps them on...  \n",
      "3     Matt Beisner uses unique approaches to modifyi...  \n",
      "4     Spidey teams up with pals to become The Spidey...  \n",
      "...                                                 ...  \n",
      "1363  Merlin trains a young orphan who's destined to...  \n",
      "1364  A strong-willed family struggles to establish ...  \n",
      "1365   Welcome to Kirby's world! It's rude and sketchy.  \n",
      "1366  Ryan discovers his ability to control a giant ...  \n",
      "1367  Rock out with the Imagination Movers, Disney J...  \n",
      "\n",
      "[1368 rows x 12 columns]\n"
     ]
    }
   ],
   "source": [
    "df = pd.read_csv('disney_plus_titles.csv') # loading data into pandas, csv= comma seprated values\n",
    "print(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "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>show_id</th>\n",
       "      <th>type</th>\n",
       "      <th>title</th>\n",
       "      <th>director</th>\n",
       "      <th>cast</th>\n",
       "      <th>country</th>\n",
       "      <th>date_added</th>\n",
       "      <th>release_year</th>\n",
       "      <th>rating</th>\n",
       "      <th>duration</th>\n",
       "      <th>listed_in</th>\n",
       "      <th>description</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>s1</td>\n",
       "      <td>Movie</td>\n",
       "      <td>A Spark Story</td>\n",
       "      <td>Jason Sterman, Leanne Dare</td>\n",
       "      <td>Apthon Corbin, Louis Gonzales</td>\n",
       "      <td>NaN</td>\n",
       "      <td>September 24, 2021</td>\n",
       "      <td>2021</td>\n",
       "      <td>TV-PG</td>\n",
       "      <td>88 min</td>\n",
       "      <td>Documentary</td>\n",
       "      <td>Two Pixar filmmakers strive to bring their uni...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>s2</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Spooky Buddies</td>\n",
       "      <td>Robert Vince</td>\n",
       "      <td>Tucker Albrizzi, Diedrich Bader, Ameko Eks Mas...</td>\n",
       "      <td>United States, Canada</td>\n",
       "      <td>September 24, 2021</td>\n",
       "      <td>2011</td>\n",
       "      <td>G</td>\n",
       "      <td>93 min</td>\n",
       "      <td>Comedy, Fantasy, Kids</td>\n",
       "      <td>The puppies go on a spooky adventure through a...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>s3</td>\n",
       "      <td>Movie</td>\n",
       "      <td>The Fault in Our Stars</td>\n",
       "      <td>Josh Boone</td>\n",
       "      <td>Shailene Woodley, Ansel Elgort, Laura Dern, Sa...</td>\n",
       "      <td>United States</td>\n",
       "      <td>September 24, 2021</td>\n",
       "      <td>2014</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>127 min</td>\n",
       "      <td>Coming of Age, Drama, Romance</td>\n",
       "      <td>Hazel and Gus share a love that sweeps them on...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>s4</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Dog: Impossible</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Matt Beisner</td>\n",
       "      <td>United States</td>\n",
       "      <td>September 22, 2021</td>\n",
       "      <td>2019</td>\n",
       "      <td>TV-PG</td>\n",
       "      <td>2 Seasons</td>\n",
       "      <td>Animals &amp; Nature, Docuseries, Family</td>\n",
       "      <td>Matt Beisner uses unique approaches to modifyi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>s5</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Spidey And His Amazing Friends</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Benjamin Valic, Lily Sanfelippo, Jakari Fraser...</td>\n",
       "      <td>United States</td>\n",
       "      <td>September 22, 2021</td>\n",
       "      <td>2021</td>\n",
       "      <td>TV-Y</td>\n",
       "      <td>1 Season</td>\n",
       "      <td>Action-Adventure, Animation, Kids</td>\n",
       "      <td>Spidey teams up with pals to become The Spidey...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>s6</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Star Wars: Visions</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>September 22, 2021</td>\n",
       "      <td>2021</td>\n",
       "      <td>TV-PG</td>\n",
       "      <td>1 Season</td>\n",
       "      <td>Action-Adventure, Animation, Anime</td>\n",
       "      <td>An animated anthology celebrating Star Wars th...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>s7</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Confessions of a Shopaholic</td>\n",
       "      <td>P.J. Hogan</td>\n",
       "      <td>Isla Fisher, Hugh Dancy, Joan Cusack, John Goo...</td>\n",
       "      <td>United States</td>\n",
       "      <td>September 17, 2021</td>\n",
       "      <td>2009</td>\n",
       "      <td>PG</td>\n",
       "      <td>106 min</td>\n",
       "      <td>Comedy, Romance, Romantic Comedy</td>\n",
       "      <td>Becky writes a personal finance column en rout...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>s8</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Descendants: Royal Wedding</td>\n",
       "      <td>Salvador Simó</td>\n",
       "      <td>Dove Cameron, Sofia Carson, Booboo Stewart, Mi...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>September 17, 2021</td>\n",
       "      <td>2021</td>\n",
       "      <td>TV-G</td>\n",
       "      <td>22 min</td>\n",
       "      <td>Animation, Fantasy, Musical</td>\n",
       "      <td>Mal and Ben’s wedding is finally here!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>s9</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Disney's Broadway Hits at London's Royal Alber...</td>\n",
       "      <td>Jay Hatcher</td>\n",
       "      <td>John Barrowman, Ashley Brown, Merle Dandridge,...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>September 17, 2021</td>\n",
       "      <td>2016</td>\n",
       "      <td>TV-G</td>\n",
       "      <td>116 min</td>\n",
       "      <td>Concert Film</td>\n",
       "      <td>Experience the magic of Disney on Broadway in ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>s10</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Flooded Tombs of the Nile</td>\n",
       "      <td>Katie Bauer Murdock</td>\n",
       "      <td>Devin E. Haqq</td>\n",
       "      <td>NaN</td>\n",
       "      <td>September 17, 2021</td>\n",
       "      <td>2021</td>\n",
       "      <td>TV-PG</td>\n",
       "      <td>44 min</td>\n",
       "      <td>Documentary</td>\n",
       "      <td>Archaeologists dive into a pyramid flooded by ...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  show_id     type                                              title  \\\n",
       "0      s1    Movie                                      A Spark Story   \n",
       "1      s2    Movie                                     Spooky Buddies   \n",
       "2      s3    Movie                             The Fault in Our Stars   \n",
       "3      s4  TV Show                                    Dog: Impossible   \n",
       "4      s5  TV Show                     Spidey And His Amazing Friends   \n",
       "5      s6  TV Show                                 Star Wars: Visions   \n",
       "6      s7    Movie                        Confessions of a Shopaholic   \n",
       "7      s8    Movie                         Descendants: Royal Wedding   \n",
       "8      s9    Movie  Disney's Broadway Hits at London's Royal Alber...   \n",
       "9     s10    Movie                          Flooded Tombs of the Nile   \n",
       "\n",
       "                     director  \\\n",
       "0  Jason Sterman, Leanne Dare   \n",
       "1                Robert Vince   \n",
       "2                  Josh Boone   \n",
       "3                         NaN   \n",
       "4                         NaN   \n",
       "5                         NaN   \n",
       "6                  P.J. Hogan   \n",
       "7               Salvador Simó   \n",
       "8                 Jay Hatcher   \n",
       "9         Katie Bauer Murdock   \n",
       "\n",
       "                                                cast                country  \\\n",
       "0                      Apthon Corbin, Louis Gonzales                    NaN   \n",
       "1  Tucker Albrizzi, Diedrich Bader, Ameko Eks Mas...  United States, Canada   \n",
       "2  Shailene Woodley, Ansel Elgort, Laura Dern, Sa...          United States   \n",
       "3                                       Matt Beisner          United States   \n",
       "4  Benjamin Valic, Lily Sanfelippo, Jakari Fraser...          United States   \n",
       "5                                                NaN                    NaN   \n",
       "6  Isla Fisher, Hugh Dancy, Joan Cusack, John Goo...          United States   \n",
       "7  Dove Cameron, Sofia Carson, Booboo Stewart, Mi...                    NaN   \n",
       "8  John Barrowman, Ashley Brown, Merle Dandridge,...                    NaN   \n",
       "9                                      Devin E. Haqq                    NaN   \n",
       "\n",
       "           date_added  release_year rating   duration  \\\n",
       "0  September 24, 2021          2021  TV-PG     88 min   \n",
       "1  September 24, 2021          2011      G     93 min   \n",
       "2  September 24, 2021          2014  PG-13    127 min   \n",
       "3  September 22, 2021          2019  TV-PG  2 Seasons   \n",
       "4  September 22, 2021          2021   TV-Y   1 Season   \n",
       "5  September 22, 2021          2021  TV-PG   1 Season   \n",
       "6  September 17, 2021          2009     PG    106 min   \n",
       "7  September 17, 2021          2021   TV-G     22 min   \n",
       "8  September 17, 2021          2016   TV-G    116 min   \n",
       "9  September 17, 2021          2021  TV-PG     44 min   \n",
       "\n",
       "                              listed_in  \\\n",
       "0                           Documentary   \n",
       "1                 Comedy, Fantasy, Kids   \n",
       "2         Coming of Age, Drama, Romance   \n",
       "3  Animals & Nature, Docuseries, Family   \n",
       "4     Action-Adventure, Animation, Kids   \n",
       "5    Action-Adventure, Animation, Anime   \n",
       "6      Comedy, Romance, Romantic Comedy   \n",
       "7           Animation, Fantasy, Musical   \n",
       "8                          Concert Film   \n",
       "9                           Documentary   \n",
       "\n",
       "                                         description  \n",
       "0  Two Pixar filmmakers strive to bring their uni...  \n",
       "1  The puppies go on a spooky adventure through a...  \n",
       "2  Hazel and Gus share a love that sweeps them on...  \n",
       "3  Matt Beisner uses unique approaches to modifyi...  \n",
       "4  Spidey teams up with pals to become The Spidey...  \n",
       "5  An animated anthology celebrating Star Wars th...  \n",
       "6  Becky writes a personal finance column en rout...  \n",
       "7             Mal and Ben’s wedding is finally here!  \n",
       "8  Experience the magic of Disney on Broadway in ...  \n",
       "9  Archaeologists dive into a pyramid flooded by ...  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>show_id</th>\n",
       "      <th>type</th>\n",
       "      <th>title</th>\n",
       "      <th>director</th>\n",
       "      <th>cast</th>\n",
       "      <th>country</th>\n",
       "      <th>date_added</th>\n",
       "      <th>release_year</th>\n",
       "      <th>rating</th>\n",
       "      <th>duration</th>\n",
       "      <th>listed_in</th>\n",
       "      <th>description</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1358</th>\n",
       "      <td>s1359</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Justin Morgan had a Horse</td>\n",
       "      <td>Hollingsworth Morse</td>\n",
       "      <td>Don Murray, Lana Wood, R.G. Armstrong, Gary Cr...</td>\n",
       "      <td>United States</td>\n",
       "      <td>October 1, 2019</td>\n",
       "      <td>1972</td>\n",
       "      <td>TV-G</td>\n",
       "      <td>88 min</td>\n",
       "      <td>Animals &amp; Nature, Biographical, Drama</td>\n",
       "      <td>The story of the foundation sire of the Morgan...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1359</th>\n",
       "      <td>s1360</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Lady and the Tramp II: Scamp's Adventure</td>\n",
       "      <td>Darrell Rooney</td>\n",
       "      <td>Scott Wolf, Alyssa Milano, Chazz Palminteri, J...</td>\n",
       "      <td>United States, Australia</td>\n",
       "      <td>October 1, 2019</td>\n",
       "      <td>2001</td>\n",
       "      <td>G</td>\n",
       "      <td>73 min</td>\n",
       "      <td>Action-Adventure, Animation, Coming of Age</td>\n",
       "      <td>Itching for freedom, Lady's pup Scamp joins up...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1360</th>\n",
       "      <td>s1361</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Smart Guy</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tahj Mowry, John Jones, Jason Weaver, Essence ...</td>\n",
       "      <td>United States</td>\n",
       "      <td>October 1, 2019</td>\n",
       "      <td>1996</td>\n",
       "      <td>TV-G</td>\n",
       "      <td>3 Seasons</td>\n",
       "      <td>Comedy, Coming of Age, Kids</td>\n",
       "      <td>A genius tries to fit in as a high school soph...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1361</th>\n",
       "      <td>s1362</td>\n",
       "      <td>Movie</td>\n",
       "      <td>The Cat from Outer Space</td>\n",
       "      <td>Norman Tokar</td>\n",
       "      <td>Ken Berry, Sandy Duncan, Harry Morgan, Roddy M...</td>\n",
       "      <td>United States</td>\n",
       "      <td>October 1, 2019</td>\n",
       "      <td>1978</td>\n",
       "      <td>G</td>\n",
       "      <td>104 min</td>\n",
       "      <td>Comedy, Family, Science Fiction</td>\n",
       "      <td>A physicist tries to help an alien cat after i...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1362</th>\n",
       "      <td>s1363</td>\n",
       "      <td>Movie</td>\n",
       "      <td>The Great Mouse Detective</td>\n",
       "      <td>John Musker, Ron Clements, Dave Michener</td>\n",
       "      <td>Vincent Price, Barrie Ingham, Val Bettin, Susa...</td>\n",
       "      <td>United States</td>\n",
       "      <td>October 1, 2019</td>\n",
       "      <td>1986</td>\n",
       "      <td>G</td>\n",
       "      <td>75 min</td>\n",
       "      <td>Animation, Family, Mystery</td>\n",
       "      <td>A super-sleuth mouse must solve a toy maker's ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1363</th>\n",
       "      <td>s1364</td>\n",
       "      <td>Movie</td>\n",
       "      <td>The Sword in the Stone</td>\n",
       "      <td>Wolfgang Reitherman</td>\n",
       "      <td>Sebastian Cabot, Karl Swenson, Rickie Sorensen...</td>\n",
       "      <td>United States</td>\n",
       "      <td>October 1, 2019</td>\n",
       "      <td>1963</td>\n",
       "      <td>G</td>\n",
       "      <td>80 min</td>\n",
       "      <td>Action-Adventure, Animation, Comedy</td>\n",
       "      <td>Merlin trains a young orphan who's destined to...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1364</th>\n",
       "      <td>s1365</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Those Calloways</td>\n",
       "      <td>Norman Tokar</td>\n",
       "      <td>Brian Keith, Vera Miles, Brandon de Wilde, Wal...</td>\n",
       "      <td>United States</td>\n",
       "      <td>October 1, 2019</td>\n",
       "      <td>1965</td>\n",
       "      <td>PG</td>\n",
       "      <td>132 min</td>\n",
       "      <td>Animals &amp; Nature, Drama, Family</td>\n",
       "      <td>A strong-willed family struggles to establish ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1365</th>\n",
       "      <td>s1366</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Disney Kirby Buckets</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Jacob Bertrand, Mekai Curtis, Cade Sutton, Oli...</td>\n",
       "      <td>United States</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2014</td>\n",
       "      <td>TV-Y7</td>\n",
       "      <td>3 Seasons</td>\n",
       "      <td>Action-Adventure, Comedy, Coming of Age</td>\n",
       "      <td>Welcome to Kirby's world! It's rude and sketchy.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1366</th>\n",
       "      <td>s1367</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Disney Mech-X4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nathaniel Potvin, Raymond Cham, Kamran Lucas, ...</td>\n",
       "      <td>Canada</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2016</td>\n",
       "      <td>TV-Y7</td>\n",
       "      <td>2 Seasons</td>\n",
       "      <td>Action-Adventure, Comedy, Science Fiction</td>\n",
       "      <td>Ryan discovers his ability to control a giant ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1367</th>\n",
       "      <td>s1368</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Imagination Movers</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rich Collins, Dave Poche, Scott Durbin, Scott ...</td>\n",
       "      <td>United States</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2008</td>\n",
       "      <td>TV-Y</td>\n",
       "      <td>3 Seasons</td>\n",
       "      <td>Kids, Music</td>\n",
       "      <td>Rock out with the Imagination Movers, Disney J...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     show_id     type                                     title  \\\n",
       "1358   s1359    Movie                 Justin Morgan had a Horse   \n",
       "1359   s1360    Movie  Lady and the Tramp II: Scamp's Adventure   \n",
       "1360   s1361  TV Show                                 Smart Guy   \n",
       "1361   s1362    Movie                  The Cat from Outer Space   \n",
       "1362   s1363    Movie                 The Great Mouse Detective   \n",
       "1363   s1364    Movie                    The Sword in the Stone   \n",
       "1364   s1365    Movie                           Those Calloways   \n",
       "1365   s1366  TV Show                      Disney Kirby Buckets   \n",
       "1366   s1367  TV Show                            Disney Mech-X4   \n",
       "1367   s1368  TV Show                        Imagination Movers   \n",
       "\n",
       "                                      director  \\\n",
       "1358                       Hollingsworth Morse   \n",
       "1359                            Darrell Rooney   \n",
       "1360                                       NaN   \n",
       "1361                              Norman Tokar   \n",
       "1362  John Musker, Ron Clements, Dave Michener   \n",
       "1363                       Wolfgang Reitherman   \n",
       "1364                              Norman Tokar   \n",
       "1365                                       NaN   \n",
       "1366                                       NaN   \n",
       "1367                                       NaN   \n",
       "\n",
       "                                                   cast  \\\n",
       "1358  Don Murray, Lana Wood, R.G. Armstrong, Gary Cr...   \n",
       "1359  Scott Wolf, Alyssa Milano, Chazz Palminteri, J...   \n",
       "1360  Tahj Mowry, John Jones, Jason Weaver, Essence ...   \n",
       "1361  Ken Berry, Sandy Duncan, Harry Morgan, Roddy M...   \n",
       "1362  Vincent Price, Barrie Ingham, Val Bettin, Susa...   \n",
       "1363  Sebastian Cabot, Karl Swenson, Rickie Sorensen...   \n",
       "1364  Brian Keith, Vera Miles, Brandon de Wilde, Wal...   \n",
       "1365  Jacob Bertrand, Mekai Curtis, Cade Sutton, Oli...   \n",
       "1366  Nathaniel Potvin, Raymond Cham, Kamran Lucas, ...   \n",
       "1367  Rich Collins, Dave Poche, Scott Durbin, Scott ...   \n",
       "\n",
       "                       country       date_added  release_year rating  \\\n",
       "1358             United States  October 1, 2019          1972   TV-G   \n",
       "1359  United States, Australia  October 1, 2019          2001      G   \n",
       "1360             United States  October 1, 2019          1996   TV-G   \n",
       "1361             United States  October 1, 2019          1978      G   \n",
       "1362             United States  October 1, 2019          1986      G   \n",
       "1363             United States  October 1, 2019          1963      G   \n",
       "1364             United States  October 1, 2019          1965     PG   \n",
       "1365             United States              NaN          2014  TV-Y7   \n",
       "1366                    Canada              NaN          2016  TV-Y7   \n",
       "1367             United States              NaN          2008   TV-Y   \n",
       "\n",
       "       duration                                   listed_in  \\\n",
       "1358     88 min       Animals & Nature, Biographical, Drama   \n",
       "1359     73 min  Action-Adventure, Animation, Coming of Age   \n",
       "1360  3 Seasons                 Comedy, Coming of Age, Kids   \n",
       "1361    104 min             Comedy, Family, Science Fiction   \n",
       "1362     75 min                  Animation, Family, Mystery   \n",
       "1363     80 min         Action-Adventure, Animation, Comedy   \n",
       "1364    132 min             Animals & Nature, Drama, Family   \n",
       "1365  3 Seasons     Action-Adventure, Comedy, Coming of Age   \n",
       "1366  2 Seasons   Action-Adventure, Comedy, Science Fiction   \n",
       "1367  3 Seasons                                 Kids, Music   \n",
       "\n",
       "                                            description  \n",
       "1358  The story of the foundation sire of the Morgan...  \n",
       "1359  Itching for freedom, Lady's pup Scamp joins up...  \n",
       "1360  A genius tries to fit in as a high school soph...  \n",
       "1361  A physicist tries to help an alien cat after i...  \n",
       "1362  A super-sleuth mouse must solve a toy maker's ...  \n",
       "1363  Merlin trains a young orphan who's destined to...  \n",
       "1364  A strong-willed family struggles to establish ...  \n",
       "1365   Welcome to Kirby's world! It's rude and sketchy.  \n",
       "1366  Ryan discovers his ability to control a giant ...  \n",
       "1367  Rock out with the Imagination Movers, Disney J...  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.tail(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Index(['show_id', 'type', 'title', 'director', 'cast', 'country', 'date_added',\n",
      "       'release_year', 'rating', 'duration', 'listed_in', 'description'],\n",
      "      dtype='object')\n"
     ]
    }
   ],
   "source": [
    "print(df.columns)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0      Movie\n",
      "1      Movie\n",
      "2      Movie\n",
      "3    TV Show\n",
      "4    TV Show\n",
      "Name: type, dtype: object\n"
     ]
    }
   ],
   "source": [
    "# reading specific column\n",
    "print(df['type'][0:5])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "         type                           title   duration\n",
      "0       Movie                   A Spark Story     88 min\n",
      "1       Movie                  Spooky Buddies     93 min\n",
      "2       Movie          The Fault in Our Stars    127 min\n",
      "3     TV Show                 Dog: Impossible  2 Seasons\n",
      "4     TV Show  Spidey And His Amazing Friends   1 Season\n",
      "...       ...                             ...        ...\n",
      "1363    Movie          The Sword in the Stone     80 min\n",
      "1364    Movie                 Those Calloways    132 min\n",
      "1365  TV Show            Disney Kirby Buckets  3 Seasons\n",
      "1366  TV Show                  Disney Mech-X4  2 Seasons\n",
      "1367  TV Show              Imagination Movers  3 Seasons\n",
      "\n",
      "[1368 rows x 3 columns]\n"
     ]
    }
   ],
   "source": [
    "# multiple colums\n",
    "print(df[['type', 'title', 'duration']])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "show_id                                                        s2\n",
      "type                                                        Movie\n",
      "title                                              Spooky Buddies\n",
      "director                                             Robert Vince\n",
      "cast            Tucker Albrizzi, Diedrich Bader, Ameko Eks Mas...\n",
      "country                                     United States, Canada\n",
      "date_added                                     September 24, 2021\n",
      "release_year                                                 2011\n",
      "rating                                                          G\n",
      "duration                                                   93 min\n",
      "listed_in                                   Comedy, Fantasy, Kids\n",
      "description     The puppies go on a spooky adventure through a...\n",
      "Name: 1, dtype: object\n"
     ]
    }
   ],
   "source": [
    "print(df.iloc[1])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "  show_id     type                           title      director  \\\n",
      "1      s2    Movie                  Spooky Buddies  Robert Vince   \n",
      "2      s3    Movie          The Fault in Our Stars    Josh Boone   \n",
      "3      s4  TV Show                 Dog: Impossible           NaN   \n",
      "4      s5  TV Show  Spidey And His Amazing Friends           NaN   \n",
      "\n",
      "                                                cast                country  \\\n",
      "1  Tucker Albrizzi, Diedrich Bader, Ameko Eks Mas...  United States, Canada   \n",
      "2  Shailene Woodley, Ansel Elgort, Laura Dern, Sa...          United States   \n",
      "3                                       Matt Beisner          United States   \n",
      "4  Benjamin Valic, Lily Sanfelippo, Jakari Fraser...          United States   \n",
      "\n",
      "           date_added  release_year rating   duration  \\\n",
      "1  September 24, 2021          2011      G     93 min   \n",
      "2  September 24, 2021          2014  PG-13    127 min   \n",
      "3  September 22, 2021          2019  TV-PG  2 Seasons   \n",
      "4  September 22, 2021          2021   TV-Y   1 Season   \n",
      "\n",
      "                              listed_in  \\\n",
      "1                 Comedy, Fantasy, Kids   \n",
      "2         Coming of Age, Drama, Romance   \n",
      "3  Animals & Nature, Docuseries, Family   \n",
      "4     Action-Adventure, Animation, Kids   \n",
      "\n",
      "                                         description  \n",
      "1  The puppies go on a spooky adventure through a...  \n",
      "2  Hazel and Gus share a love that sweeps them on...  \n",
      "3  Matt Beisner uses unique approaches to modifyi...  \n",
      "4  Spidey teams up with pals to become The Spidey...  \n"
     ]
    }
   ],
   "source": [
    "print(df.iloc[1:5])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "s3\n"
     ]
    }
   ],
   "source": [
    "print(df.iloc[2,0])"
   ]
  },
  {
   "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.8.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}