release_date_order.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "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>Unnamed: 0</th>\n",
       "      <th>id</th>\n",
       "      <th>title</th>\n",
       "      <th>genres</th>\n",
       "      <th>original_language</th>\n",
       "      <th>overview</th>\n",
       "      <th>popularity</th>\n",
       "      <th>production_companies</th>\n",
       "      <th>release_date</th>\n",
       "      <th>budget</th>\n",
       "      <th>...</th>\n",
       "      <th>runtime</th>\n",
       "      <th>status</th>\n",
       "      <th>tagline</th>\n",
       "      <th>vote_average</th>\n",
       "      <th>vote_count</th>\n",
       "      <th>credits</th>\n",
       "      <th>keywords</th>\n",
       "      <th>poster_path</th>\n",
       "      <th>backdrop_path</th>\n",
       "      <th>recommendations</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>152</td>\n",
       "      <td>785521</td>\n",
       "      <td>Battle: Freestyle</td>\n",
       "      <td>Romance-Drama</td>\n",
       "      <td>no</td>\n",
       "      <td>Amalie and Mikael lead their street dance team...</td>\n",
       "      <td>238.540</td>\n",
       "      <td>Friland Produksjon AS</td>\n",
       "      <td>2022-04-01</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>88.0</td>\n",
       "      <td>Released</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.1</td>\n",
       "      <td>30.0</td>\n",
       "      <td>Lisa Teige-Fabian Svegaard Tapia-Ellen Dorrit ...</td>\n",
       "      <td>paris france-based on novel or book-norway-dan...</td>\n",
       "      <td>/6D6QumiHEhnpZG12Ibjy2BxA6n4.jpg</td>\n",
       "      <td>/8WpRRiz3qQqzBiifCTm1dW0b6bs.jpg</td>\n",
       "      <td>818750-790525-800407-739993-946726-682344-9532...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>163</td>\n",
       "      <td>949218</td>\n",
       "      <td>S.O.S. Mamis: La película</td>\n",
       "      <td>Comedy</td>\n",
       "      <td>es</td>\n",
       "      <td>Trini's daughter is sad that her best friend i...</td>\n",
       "      <td>230.012</td>\n",
       "      <td>Tiki Pictures-BH5-Elefantec Global</td>\n",
       "      <td>2022-03-18</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>105.0</td>\n",
       "      <td>Released</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.9</td>\n",
       "      <td>9.0</td>\n",
       "      <td>Paz Bascuñan-Loreto Aravena-María Elena Swett-...</td>\n",
       "      <td>based on web series</td>\n",
       "      <td>/dubFxWUiXW4QzOygVsChYYIuzfx.jpg</td>\n",
       "      <td>/9y7gXxImkZkqniB96TfryYJG3mh.jpg</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>164</td>\n",
       "      <td>928769</td>\n",
       "      <td>AI Love You</td>\n",
       "      <td>Comedy-Romance-Science Fiction</td>\n",
       "      <td>th</td>\n",
       "      <td>A modern love story set in the near future whe...</td>\n",
       "      <td>226.559</td>\n",
       "      <td>Deyi Production-Blue River Films</td>\n",
       "      <td>2022-02-15</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>95.0</td>\n",
       "      <td>Released</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.4</td>\n",
       "      <td>25.0</td>\n",
       "      <td>Mario Maurer-Pimchanok Leuwisetpaiboon-Michael...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>/sBiJOvHCSWORnFpc4yItflIkdTi.jpg</td>\n",
       "      <td>/AfWtIzrdB0HMQ0Swequza4Jo1Kh.jpg</td>\n",
       "      <td>615904-929472-890656-892153-800510-818647-6327...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>180</td>\n",
       "      <td>785521</td>\n",
       "      <td>Battle: Freestyle</td>\n",
       "      <td>Romance-Drama</td>\n",
       "      <td>no</td>\n",
       "      <td>Amalie and Mikael lead their street dance team...</td>\n",
       "      <td>210.928</td>\n",
       "      <td>Friland Produksjon AS</td>\n",
       "      <td>2022-04-01</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>88.0</td>\n",
       "      <td>Released</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.1</td>\n",
       "      <td>30.0</td>\n",
       "      <td>Lisa Teige-Fabian Svegaard Tapia-Ellen Dorrit ...</td>\n",
       "      <td>paris france-based on novel or book-norway-dan...</td>\n",
       "      <td>/6D6QumiHEhnpZG12Ibjy2BxA6n4.jpg</td>\n",
       "      <td>/8WpRRiz3qQqzBiifCTm1dW0b6bs.jpg</td>\n",
       "      <td>818750-790525-800407-739993-946726-682344-9532...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>192</td>\n",
       "      <td>831223</td>\n",
       "      <td>Gone Mom: The Disappearance of Jennifer Dulos</td>\n",
       "      <td>TV Movie-Thriller-Crime</td>\n",
       "      <td>en</td>\n",
       "      <td>Jennifer Dulos the wealthy Connecticut mother-...</td>\n",
       "      <td>201.142</td>\n",
       "      <td>Lighthouse Pictures</td>\n",
       "      <td>2021-06-05</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>88.0</td>\n",
       "      <td>Released</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.7</td>\n",
       "      <td>151.0</td>\n",
       "      <td>Annabeth Gish-Warren Christie-Laura Harris-Ken...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>/mzTNGnLG6LTHmrqrY0IADHDuyOJ.jpg</td>\n",
       "      <td>/kJ2srEZSlmGfAqLKGVMPhBDdr1G.jpg</td>\n",
       "      <td>425909-754067-645886-661004-460458-831827-5850...</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",
       "      <td>...</td>\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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>147388</th>\n",
       "      <td>722723</td>\n",
       "      <td>772891</td>\n",
       "      <td>408</td>\n",
       "      <td>Comedy-Crime</td>\n",
       "      <td>ca</td>\n",
       "      <td>Carles Pau and Dante meet at the funeral of th...</td>\n",
       "      <td>0.600</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019-06-08</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Released</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Carlos Llecha-Rodo Gener-Toni Pons-Toni Villal...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>/kOCr3OrZyXmrVeEfGcGp2t6F2Mq.jpg</td>\n",
       "      <td>/9dGfeASrddwN1vyYWeGB7WQcr1I.jpg</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>147389</th>\n",
       "      <td>722734</td>\n",
       "      <td>869220</td>\n",
       "      <td>Quicksand</td>\n",
       "      <td>NaN</td>\n",
       "      <td>en</td>\n",
       "      <td>An elderly gentleman attempts to retrieve forg...</td>\n",
       "      <td>0.600</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>8.0</td>\n",
       "      <td>Released</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Roy Oppenheim-Walter Oppenheim</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>147390</th>\n",
       "      <td>722738</td>\n",
       "      <td>548760</td>\n",
       "      <td>Wolves of the North</td>\n",
       "      <td>Adventure-Action</td>\n",
       "      <td>en</td>\n",
       "      <td>The adventures of fur trappers in the Pacific ...</td>\n",
       "      <td>0.600</td>\n",
       "      <td>Universal Pictures</td>\n",
       "      <td>1924-09-21</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Released</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>William Duncan-Edith Johnson-Joseph W. Girard-...</td>\n",
       "      <td>fur trapping</td>\n",
       "      <td>/xQwdOJVQpjtvc50Ys2HYFO89BYi.jpg</td>\n",
       "      <td>/nQBmYGkfC2lulniQxB0yZievYtd.jpg</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>147391</th>\n",
       "      <td>722740</td>\n",
       "      <td>702248</td>\n",
       "      <td>Weeping Shriner</td>\n",
       "      <td>NaN</td>\n",
       "      <td>en</td>\n",
       "      <td>A grieving emotionally repressed lounge pianis...</td>\n",
       "      <td>0.600</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1999-08-30</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Released</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>/64j2qDJodQ8du8AJuls3D4WTc6W.jpg</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>147392</th>\n",
       "      <td>722744</td>\n",
       "      <td>912284</td>\n",
       "      <td>Smile</td>\n",
       "      <td>Animation</td>\n",
       "      <td>en</td>\n",
       "      <td>GroM wakes up one morning to find that his mou...</td>\n",
       "      <td>0.600</td>\n",
       "      <td>Menado</td>\n",
       "      <td>2021-07-30</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>7.0</td>\n",
       "      <td>Released</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Anders Wilhelmsson-Emma-Helena Berglund-Eirik ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>/arkZvwlLa4v0QzJZEs8ycnC3dKJ.jpg</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>147393 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        Unnamed: 0      id                                          title  \\\n",
       "0              152  785521                              Battle: Freestyle   \n",
       "1              163  949218                      S.O.S. Mamis: La película   \n",
       "2              164  928769                                    AI Love You   \n",
       "3              180  785521                              Battle: Freestyle   \n",
       "4              192  831223  Gone Mom: The Disappearance of Jennifer Dulos   \n",
       "...            ...     ...                                            ...   \n",
       "147388      722723  772891                                            408   \n",
       "147389      722734  869220                                      Quicksand   \n",
       "147390      722738  548760                            Wolves of the North   \n",
       "147391      722740  702248                                Weeping Shriner   \n",
       "147392      722744  912284                                          Smile   \n",
       "\n",
       "                                genres original_language  \\\n",
       "0                        Romance-Drama                no   \n",
       "1                               Comedy                es   \n",
       "2       Comedy-Romance-Science Fiction                th   \n",
       "3                        Romance-Drama                no   \n",
       "4              TV Movie-Thriller-Crime                en   \n",
       "...                                ...               ...   \n",
       "147388                    Comedy-Crime                ca   \n",
       "147389                             NaN                en   \n",
       "147390                Adventure-Action                en   \n",
       "147391                             NaN                en   \n",
       "147392                       Animation                en   \n",
       "\n",
       "                                                 overview  popularity  \\\n",
       "0       Amalie and Mikael lead their street dance team...     238.540   \n",
       "1       Trini's daughter is sad that her best friend i...     230.012   \n",
       "2       A modern love story set in the near future whe...     226.559   \n",
       "3       Amalie and Mikael lead their street dance team...     210.928   \n",
       "4       Jennifer Dulos the wealthy Connecticut mother-...     201.142   \n",
       "...                                                   ...         ...   \n",
       "147388  Carles Pau and Dante meet at the funeral of th...       0.600   \n",
       "147389  An elderly gentleman attempts to retrieve forg...       0.600   \n",
       "147390  The adventures of fur trappers in the Pacific ...       0.600   \n",
       "147391  A grieving emotionally repressed lounge pianis...       0.600   \n",
       "147392  GroM wakes up one morning to find that his mou...       0.600   \n",
       "\n",
       "                      production_companies release_date  budget  ...  runtime  \\\n",
       "0                    Friland Produksjon AS   2022-04-01     0.0  ...     88.0   \n",
       "1       Tiki Pictures-BH5-Elefantec Global   2022-03-18     0.0  ...    105.0   \n",
       "2         Deyi Production-Blue River Films   2022-02-15     0.0  ...     95.0   \n",
       "3                    Friland Produksjon AS   2022-04-01     0.0  ...     88.0   \n",
       "4                      Lighthouse Pictures   2021-06-05     0.0  ...     88.0   \n",
       "...                                    ...          ...     ...  ...      ...   \n",
       "147388                                 NaN   2019-06-08     0.0  ...      0.0   \n",
       "147389                                 NaN          NaN     0.0  ...      8.0   \n",
       "147390                  Universal Pictures   1924-09-21     0.0  ...      0.0   \n",
       "147391                                 NaN   1999-08-30     0.0  ...      0.0   \n",
       "147392                              Menado   2021-07-30     0.0  ...      7.0   \n",
       "\n",
       "          status tagline vote_average  vote_count  \\\n",
       "0       Released     NaN          5.1        30.0   \n",
       "1       Released     NaN          5.9         9.0   \n",
       "2       Released     NaN          5.4        25.0   \n",
       "3       Released     NaN          5.1        30.0   \n",
       "4       Released     NaN          7.7       151.0   \n",
       "...          ...     ...          ...         ...   \n",
       "147388  Released     NaN          0.0         0.0   \n",
       "147389  Released     NaN          0.0         0.0   \n",
       "147390  Released     NaN          0.0         0.0   \n",
       "147391  Released     NaN          0.0         0.0   \n",
       "147392  Released     NaN          0.0         0.0   \n",
       "\n",
       "                                                  credits  \\\n",
       "0       Lisa Teige-Fabian Svegaard Tapia-Ellen Dorrit ...   \n",
       "1       Paz Bascuñan-Loreto Aravena-María Elena Swett-...   \n",
       "2       Mario Maurer-Pimchanok Leuwisetpaiboon-Michael...   \n",
       "3       Lisa Teige-Fabian Svegaard Tapia-Ellen Dorrit ...   \n",
       "4       Annabeth Gish-Warren Christie-Laura Harris-Ken...   \n",
       "...                                                   ...   \n",
       "147388  Carlos Llecha-Rodo Gener-Toni Pons-Toni Villal...   \n",
       "147389                     Roy Oppenheim-Walter Oppenheim   \n",
       "147390  William Duncan-Edith Johnson-Joseph W. Girard-...   \n",
       "147391                                                NaN   \n",
       "147392  Anders Wilhelmsson-Emma-Helena Berglund-Eirik ...   \n",
       "\n",
       "                                                 keywords  \\\n",
       "0       paris france-based on novel or book-norway-dan...   \n",
       "1                                     based on web series   \n",
       "2                                                     NaN   \n",
       "3       paris france-based on novel or book-norway-dan...   \n",
       "4                                                     NaN   \n",
       "...                                                   ...   \n",
       "147388                                                NaN   \n",
       "147389                                                NaN   \n",
       "147390                                       fur trapping   \n",
       "147391                                                NaN   \n",
       "147392                                                NaN   \n",
       "\n",
       "                             poster_path                     backdrop_path  \\\n",
       "0       /6D6QumiHEhnpZG12Ibjy2BxA6n4.jpg  /8WpRRiz3qQqzBiifCTm1dW0b6bs.jpg   \n",
       "1       /dubFxWUiXW4QzOygVsChYYIuzfx.jpg  /9y7gXxImkZkqniB96TfryYJG3mh.jpg   \n",
       "2       /sBiJOvHCSWORnFpc4yItflIkdTi.jpg  /AfWtIzrdB0HMQ0Swequza4Jo1Kh.jpg   \n",
       "3       /6D6QumiHEhnpZG12Ibjy2BxA6n4.jpg  /8WpRRiz3qQqzBiifCTm1dW0b6bs.jpg   \n",
       "4       /mzTNGnLG6LTHmrqrY0IADHDuyOJ.jpg  /kJ2srEZSlmGfAqLKGVMPhBDdr1G.jpg   \n",
       "...                                  ...                               ...   \n",
       "147388  /kOCr3OrZyXmrVeEfGcGp2t6F2Mq.jpg  /9dGfeASrddwN1vyYWeGB7WQcr1I.jpg   \n",
       "147389                               NaN                               NaN   \n",
       "147390  /xQwdOJVQpjtvc50Ys2HYFO89BYi.jpg  /nQBmYGkfC2lulniQxB0yZievYtd.jpg   \n",
       "147391  /64j2qDJodQ8du8AJuls3D4WTc6W.jpg                               NaN   \n",
       "147392  /arkZvwlLa4v0QzJZEs8ycnC3dKJ.jpg                               NaN   \n",
       "\n",
       "                                          recommendations  \n",
       "0       818750-790525-800407-739993-946726-682344-9532...  \n",
       "1                                                     NaN  \n",
       "2       615904-929472-890656-892153-800510-818647-6327...  \n",
       "3       818750-790525-800407-739993-946726-682344-9532...  \n",
       "4       425909-754067-645886-661004-460458-831827-5850...  \n",
       "...                                                   ...  \n",
       "147388                                                NaN  \n",
       "147389                                                NaN  \n",
       "147390                                                NaN  \n",
       "147391                                                NaN  \n",
       "147392                                                NaN  \n",
       "\n",
       "[147393 rows x 21 columns]"
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "df = pd.read_csv(\"clean_data.csv\")\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_oldest= df\n",
    "df_newest = df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>title</th>\n",
       "      <th>release_date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>115064</th>\n",
       "      <td>The Aquarium</td>\n",
       "      <td>1878-05-07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35776</th>\n",
       "      <td>The Kiss</td>\n",
       "      <td>1882-06-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>114818</th>\n",
       "      <td>Woman Walking Downstairs</td>\n",
       "      <td>1887-01-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32502</th>\n",
       "      <td>Hyde Park Corner</td>\n",
       "      <td>1889-11-23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27686</th>\n",
       "      <td>Je Vous Aime</td>\n",
       "      <td>1891-01-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131574</th>\n",
       "      <td>Monkey and Another, Boxing</td>\n",
       "      <td>1891-01-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27134</th>\n",
       "      <td>The Wave</td>\n",
       "      <td>1891-11-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>130231</th>\n",
       "      <td>Wrestling</td>\n",
       "      <td>1892-01-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48274</th>\n",
       "      <td>Boxing</td>\n",
       "      <td>1892-01-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137784</th>\n",
       "      <td>Rabbits</td>\n",
       "      <td>1893-02-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51006</th>\n",
       "      <td>Athlete with Wand</td>\n",
       "      <td>1894-02-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70864</th>\n",
       "      <td>Highland Dance</td>\n",
       "      <td>1894-04-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90637</th>\n",
       "      <td>Buffalo Bill</td>\n",
       "      <td>1894-06-17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26718</th>\n",
       "      <td>Buffalo Dance</td>\n",
       "      <td>1894-09-23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27445</th>\n",
       "      <td>Hadj Cheriff</td>\n",
       "      <td>1894-10-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80526</th>\n",
       "      <td>Lasso Thrower</td>\n",
       "      <td>1894-10-06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23803</th>\n",
       "      <td>Bucking Broncho</td>\n",
       "      <td>1894-10-16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15669</th>\n",
       "      <td>Annie Oakley</td>\n",
       "      <td>1894-11-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35495</th>\n",
       "      <td>Imperial Japanese Dance</td>\n",
       "      <td>1894-11-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49476</th>\n",
       "      <td>Corbett and Courtney Before the Kinetograph</td>\n",
       "      <td>1894-11-17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>130129</th>\n",
       "      <td>Dance</td>\n",
       "      <td>1894-12-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34628</th>\n",
       "      <td>Déjeuner du Chat</td>\n",
       "      <td>1895-01-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45287</th>\n",
       "      <td>Photograph</td>\n",
       "      <td>1895-01-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16899</th>\n",
       "      <td>Transformation by Hats</td>\n",
       "      <td>1895-01-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22574</th>\n",
       "      <td>Le maréchal-ferrant</td>\n",
       "      <td>1895-01-01</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                              title release_date\n",
       "115064                                 The Aquarium   1878-05-07\n",
       "35776                                      The Kiss   1882-06-01\n",
       "114818                     Woman Walking Downstairs   1887-01-01\n",
       "32502                              Hyde Park Corner   1889-11-23\n",
       "27686                                  Je Vous Aime   1891-01-01\n",
       "131574                   Monkey and Another, Boxing   1891-01-01\n",
       "27134                                      The Wave   1891-11-15\n",
       "130231                                    Wrestling   1892-01-01\n",
       "48274                                        Boxing   1892-01-01\n",
       "137784                                      Rabbits   1893-02-01\n",
       "51006                             Athlete with Wand   1894-02-01\n",
       "70864                                Highland Dance   1894-04-01\n",
       "90637                                  Buffalo Bill   1894-06-17\n",
       "26718                                 Buffalo Dance   1894-09-23\n",
       "27445                                  Hadj Cheriff   1894-10-05\n",
       "80526                                 Lasso Thrower   1894-10-06\n",
       "23803                               Bucking Broncho   1894-10-16\n",
       "15669                                  Annie Oakley   1894-11-01\n",
       "35495                       Imperial Japanese Dance   1894-11-05\n",
       "49476   Corbett and Courtney Before the Kinetograph   1894-11-17\n",
       "130129                                        Dance   1894-12-01\n",
       "34628                              Déjeuner du Chat   1895-01-01\n",
       "45287                                    Photograph   1895-01-01\n",
       "16899                        Transformation by Hats   1895-01-01\n",
       "22574                           Le maréchal-ferrant   1895-01-01"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_oldest['release_date'] = pd.to_datetime(df.release_date, infer_datetime_format = True)\n",
    "df_oldest.sort_values(by = 'release_date', ascending = True, inplace = True)\n",
    "df_oldest[['title', 'release_date']].head(25)"
   ]
  },
  {
   "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>title</th>\n",
       "      <th>release_date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>50396</th>\n",
       "      <td>The Wild Ones</td>\n",
       "      <td>2025-06-13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>296</th>\n",
       "      <td>Fantastic Four</td>\n",
       "      <td>2025-02-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51801</th>\n",
       "      <td>Son Göktürk</td>\n",
       "      <td>2025-01-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8269</th>\n",
       "      <td>Wicked</td>\n",
       "      <td>2024-12-25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>290</th>\n",
       "      <td>Blade</td>\n",
       "      <td>2024-09-04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1989</th>\n",
       "      <td>Garfield</td>\n",
       "      <td>2024-05-24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19140</th>\n",
       "      <td>Fighter</td>\n",
       "      <td>2024-01-25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4649</th>\n",
       "      <td>Distant</td>\n",
       "      <td>2024-01-19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29702</th>\n",
       "      <td>Metro 2033</td>\n",
       "      <td>2024-01-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18691</th>\n",
       "      <td>Metro 2033</td>\n",
       "      <td>2024-01-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3180</th>\n",
       "      <td>Attraction 3</td>\n",
       "      <td>2024-01-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>122569</th>\n",
       "      <td>Guilt</td>\n",
       "      <td>2023-12-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21643</th>\n",
       "      <td>The Field</td>\n",
       "      <td>2023-12-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71765</th>\n",
       "      <td>12 Chairs</td>\n",
       "      <td>2023-12-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60495</th>\n",
       "      <td>Lifelines</td>\n",
       "      <td>2023-12-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9696</th>\n",
       "      <td>Anomaly</td>\n",
       "      <td>2023-12-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41421</th>\n",
       "      <td>Before Dawn</td>\n",
       "      <td>2023-12-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51466</th>\n",
       "      <td>Escape</td>\n",
       "      <td>2023-12-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35245</th>\n",
       "      <td>Ballerina</td>\n",
       "      <td>2023-12-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65104</th>\n",
       "      <td>Guest from the Future</td>\n",
       "      <td>2023-12-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14591</th>\n",
       "      <td>Bade Miyan Chote Miyan</td>\n",
       "      <td>2023-12-25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>759</th>\n",
       "      <td>The Color Purple</td>\n",
       "      <td>2023-12-20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17327</th>\n",
       "      <td>Aashiqui 3</td>\n",
       "      <td>2023-11-10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2241</th>\n",
       "      <td>The Killer</td>\n",
       "      <td>2023-11-10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68204</th>\n",
       "      <td>Inevitable</td>\n",
       "      <td>2023-11-03</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                         title release_date\n",
       "50396            The Wild Ones   2025-06-13\n",
       "296             Fantastic Four   2025-02-12\n",
       "51801              Son Göktürk   2025-01-01\n",
       "8269                    Wicked   2024-12-25\n",
       "290                      Blade   2024-09-04\n",
       "1989                  Garfield   2024-05-24\n",
       "19140                  Fighter   2024-01-25\n",
       "4649                   Distant   2024-01-19\n",
       "29702               Metro 2033   2024-01-01\n",
       "18691               Metro 2033   2024-01-01\n",
       "3180              Attraction 3   2024-01-01\n",
       "122569                   Guilt   2023-12-31\n",
       "21643                The Field   2023-12-31\n",
       "71765                12 Chairs   2023-12-31\n",
       "60495                Lifelines   2023-12-31\n",
       "9696                   Anomaly   2023-12-31\n",
       "41421              Before Dawn   2023-12-31\n",
       "51466                   Escape   2023-12-31\n",
       "35245                Ballerina   2023-12-31\n",
       "65104    Guest from the Future   2023-12-28\n",
       "14591   Bade Miyan Chote Miyan   2023-12-25\n",
       "759           The Color Purple   2023-12-20\n",
       "17327               Aashiqui 3   2023-11-10\n",
       "2241                The Killer   2023-11-10\n",
       "68204               Inevitable   2023-11-03"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_newest['release_date'] = pd.to_datetime(df.release_date, infer_datetime_format = True)\n",
    "df_newest.sort_values(by = 'release_date', ascending = False, inplace = True)\n",
    "df_newest[['title', 'release_date']].head(25)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "base",
   "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.13"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}