历史文章附件列表/（数据科学学习手札92）利用query()与eval()优化pandas代码/（数据科学学习手札92）利用query()与eval()优化pandas代码.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "execution": {
     "iopub.execute_input": "2020-08-07T06:55:47.932042Z",
     "iopub.status.busy": "2020-08-07T06:55:47.932042Z",
     "iopub.status.idle": "2020-08-07T06:55:48.267142Z",
     "shell.execute_reply": "2020-08-07T06:55:48.267142Z",
     "shell.execute_reply.started": "2020-08-07T06:55:47.932042Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'1.1.0'"
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import warnings\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "\n",
    "warnings.filterwarnings('ignore')\n",
    "pd.__version__"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 2 基于query()的高效查询"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "execution": {
     "iopub.execute_input": "2020-08-07T06:55:48.269136Z",
     "iopub.status.busy": "2020-08-07T06:55:48.268141Z",
     "iopub.status.idle": "2020-08-07T06:55:48.327980Z",
     "shell.execute_reply": "2020-08-07T06:55:48.326982Z",
     "shell.execute_reply.started": "2020-08-07T06:55:48.269136Z"
    }
   },
   "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>81145628</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Norm of the North: King Sized Adventure</td>\n",
       "      <td>Richard Finn, Tim Maltby</td>\n",
       "      <td>Alan Marriott, Andrew Toth, Brian Dobson, Cole...</td>\n",
       "      <td>United States, India, South Korea, China</td>\n",
       "      <td>September 9, 2019</td>\n",
       "      <td>2019</td>\n",
       "      <td>TV-PG</td>\n",
       "      <td>90 min</td>\n",
       "      <td>Children &amp; Family Movies, Comedies</td>\n",
       "      <td>Before planning an awesome wedding for his gra...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>80117401</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Jandino: Whatever it Takes</td>\n",
       "      <td></td>\n",
       "      <td>Jandino Asporaat</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>September 9, 2016</td>\n",
       "      <td>2016</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>94 min</td>\n",
       "      <td>Stand-Up Comedy</td>\n",
       "      <td>Jandino Asporaat riffs on the challenges of ra...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>70234439</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Transformers Prime</td>\n",
       "      <td></td>\n",
       "      <td>Peter Cullen, Sumalee Montano, Frank Welker, J...</td>\n",
       "      <td>United States</td>\n",
       "      <td>September 8, 2018</td>\n",
       "      <td>2013</td>\n",
       "      <td>TV-Y7-FV</td>\n",
       "      <td>1 Season</td>\n",
       "      <td>Kids' TV</td>\n",
       "      <td>With the help of three human allies, the Autob...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>80058654</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Transformers: Robots in Disguise</td>\n",
       "      <td></td>\n",
       "      <td>Will Friedle, Darren Criss, Constance Zimmer, ...</td>\n",
       "      <td>United States</td>\n",
       "      <td>September 8, 2018</td>\n",
       "      <td>2016</td>\n",
       "      <td>TV-Y7</td>\n",
       "      <td>1 Season</td>\n",
       "      <td>Kids' TV</td>\n",
       "      <td>When a prison ship crash unleashes hundreds of...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>80125979</td>\n",
       "      <td>Movie</td>\n",
       "      <td>#realityhigh</td>\n",
       "      <td>Fernando Lebrija</td>\n",
       "      <td>Nesta Cooper, Kate Walsh, John Michael Higgins...</td>\n",
       "      <td>United States</td>\n",
       "      <td>September 8, 2017</td>\n",
       "      <td>2017</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>99 min</td>\n",
       "      <td>Comedies</td>\n",
       "      <td>When nerdy high schooler Dani finally attracts...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    show_id     type                                    title  \\\n",
       "0  81145628    Movie  Norm of the North: King Sized Adventure   \n",
       "1  80117401    Movie               Jandino: Whatever it Takes   \n",
       "2  70234439  TV Show                       Transformers Prime   \n",
       "3  80058654  TV Show         Transformers: Robots in Disguise   \n",
       "4  80125979    Movie                             #realityhigh   \n",
       "\n",
       "                   director  \\\n",
       "0  Richard Finn, Tim Maltby   \n",
       "1                             \n",
       "2                             \n",
       "3                             \n",
       "4          Fernando Lebrija   \n",
       "\n",
       "                                                cast  \\\n",
       "0  Alan Marriott, Andrew Toth, Brian Dobson, Cole...   \n",
       "1                                   Jandino Asporaat   \n",
       "2  Peter Cullen, Sumalee Montano, Frank Welker, J...   \n",
       "3  Will Friedle, Darren Criss, Constance Zimmer, ...   \n",
       "4  Nesta Cooper, Kate Walsh, John Michael Higgins...   \n",
       "\n",
       "                                    country         date_added  release_year  \\\n",
       "0  United States, India, South Korea, China  September 9, 2019          2019   \n",
       "1                            United Kingdom  September 9, 2016          2016   \n",
       "2                             United States  September 8, 2018          2013   \n",
       "3                             United States  September 8, 2018          2016   \n",
       "4                             United States  September 8, 2017          2017   \n",
       "\n",
       "     rating  duration                           listed_in  \\\n",
       "0     TV-PG    90 min  Children & Family Movies, Comedies   \n",
       "1     TV-MA    94 min                     Stand-Up Comedy   \n",
       "2  TV-Y7-FV  1 Season                            Kids' TV   \n",
       "3     TV-Y7  1 Season                            Kids' TV   \n",
       "4     TV-14    99 min                            Comedies   \n",
       "\n",
       "                                         description  \n",
       "0  Before planning an awesome wedding for his gra...  \n",
       "1  Jandino Asporaat riffs on the challenges of ra...  \n",
       "2  With the help of three human allies, the Autob...  \n",
       "3  When a prison ship crash unleashes hundreds of...  \n",
       "4  When nerdy high schooler Dani finally attracts...  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 读入netflix发行电影与剧集数据\n",
    "netflix = pd.read_csv('netflix_titles.csv').fillna('')\n",
    "netflix.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "execution": {
     "iopub.execute_input": "2020-08-07T06:55:48.329974Z",
     "iopub.status.busy": "2020-08-07T06:55:48.329974Z",
     "iopub.status.idle": "2020-08-07T06:55:48.353911Z",
     "shell.execute_reply": "2020-08-07T06:55:48.352914Z",
     "shell.execute_reply.started": "2020-08-07T06:55:48.329974Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "True"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 找出类型为TV Show且国家不含美国的Kids' TV记录\n",
    "\n",
    "# 传统做法\n",
    "result1 = netflix[(netflix['type'] == 'TV Show')&(~netflix['country'].str.contains('United States'))&(netflix['listed_in'] == 'Kids\\' TV')]\n",
    "\n",
    "# 基于query()的做法\n",
    "result2 = netflix.query(\"type == 'TV Show' & ~country.str.contains('United States') & listed_in == \\\"Kids' TV\\\"\", \n",
    "                        engine='python')\n",
    "\n",
    "# 检查两种方式计算出来的结果是否完全相等\n",
    "(result1 == result2).all().all()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 2.1 直接解析字段名"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "execution": {
     "iopub.execute_input": "2020-08-07T06:55:48.355905Z",
     "iopub.status.busy": "2020-08-07T06:55:48.355905Z",
     "iopub.status.idle": "2020-08-07T06:55:48.370865Z",
     "shell.execute_reply": "2020-08-07T06:55:48.369869Z",
     "shell.execute_reply.started": "2020-08-07T06:55:48.355905Z"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(6234, 14)\n"
     ]
    }
   ],
   "source": [
    "netflix['中文字段'] = ''\n",
    "netflix['中 文 字 段'] = ''\n",
    "\n",
    "print(netflix.query('中文字段 == \"\"').shape)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "execution": {
     "iopub.execute_input": "2020-08-07T06:55:48.371862Z",
     "iopub.status.busy": "2020-08-07T06:55:48.371862Z",
     "iopub.status.idle": "2020-08-07T06:55:48.384827Z",
     "shell.execute_reply": "2020-08-07T06:55:48.383830Z",
     "shell.execute_reply.started": "2020-08-07T06:55:48.371862Z"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "不添加`时出现错误！\n",
      "(6234, 14)\n"
     ]
    }
   ],
   "source": [
    "try:\n",
    "    print(netflix.query('中 文 字 段 == \"\"').shape)\n",
    "except SyntaxError:\n",
    "    print('不添加`时出现错误！')\n",
    "    print(netflix.query('`中 文 字 段` == \"\"').shape)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 2.2 链式表达式"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "execution": {
     "iopub.execute_input": "2020-08-07T06:55:48.385824Z",
     "iopub.status.busy": "2020-08-07T06:55:48.385824Z",
     "iopub.status.idle": "2020-08-07T06:55:48.395825Z",
     "shell.execute_reply": "2020-08-07T06:55:48.395825Z",
     "shell.execute_reply.started": "2020-08-07T06:55:48.385824Z"
    }
   },
   "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>a</th>\n",
       "      <th>b</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   a  b\n",
       "2  3  3\n",
       "4  1  5"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "demo = pd.DataFrame({\n",
    "    'a': [5, 4, 3, 2, 1],\n",
    "    'b': [1, 2, 3, 4, 5]\n",
    "})\n",
    "\n",
    "demo.query(\"a <= b != 4\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 2.3 支持in判断"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "execution": {
     "iopub.execute_input": "2020-08-07T06:55:48.397792Z",
     "iopub.status.busy": "2020-08-07T06:55:48.397792Z",
     "iopub.status.idle": "2020-08-07T06:55:48.422730Z",
     "shell.execute_reply": "2020-08-07T06:55:48.421729Z",
     "shell.execute_reply.started": "2020-08-07T06:55:48.397792Z"
    }
   },
   "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",
       "      <th>中文字段</th>\n",
       "      <th>中 文 字 段</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>81145628</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Norm of the North: King Sized Adventure</td>\n",
       "      <td>Richard Finn, Tim Maltby</td>\n",
       "      <td>Alan Marriott, Andrew Toth, Brian Dobson, Cole...</td>\n",
       "      <td>United States, India, South Korea, China</td>\n",
       "      <td>September 9, 2019</td>\n",
       "      <td>2019</td>\n",
       "      <td>TV-PG</td>\n",
       "      <td>90 min</td>\n",
       "      <td>Children &amp; Family Movies, Comedies</td>\n",
       "      <td>Before planning an awesome wedding for his gra...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>80203094</td>\n",
       "      <td>Movie</td>\n",
       "      <td>City of Joy</td>\n",
       "      <td>Madeleine Gavin</td>\n",
       "      <td></td>\n",
       "      <td>United States,</td>\n",
       "      <td>September 7, 2018</td>\n",
       "      <td>2018</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>77 min</td>\n",
       "      <td>Documentaries</td>\n",
       "      <td>Women who've been sexually brutalized in war-t...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>80190843</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>First and Last</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>September 7, 2018</td>\n",
       "      <td>2018</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>1 Season</td>\n",
       "      <td>Docuseries</td>\n",
       "      <td>Take an intimate look at the emotionally charg...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>80988892</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Next Gen</td>\n",
       "      <td>Kevin R. Adams, Joe Ksander</td>\n",
       "      <td>John Krasinski, Charlyne Yi, Jason Sudeikis, M...</td>\n",
       "      <td>China, Canada, United States</td>\n",
       "      <td>September 7, 2018</td>\n",
       "      <td>2018</td>\n",
       "      <td>TV-PG</td>\n",
       "      <td>106 min</td>\n",
       "      <td>Children &amp; Family Movies, Comedies, Sci-Fi &amp; F...</td>\n",
       "      <td>When lonely Mai forms an unlikely bond with a ...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>80239639</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Sierra Burgess Is A Loser</td>\n",
       "      <td>Ian Samuels</td>\n",
       "      <td>Shannon Purser, Kristine Froseth, RJ Cyler, No...</td>\n",
       "      <td>United States</td>\n",
       "      <td>September 7, 2018</td>\n",
       "      <td>2018</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>106 min</td>\n",
       "      <td>Comedies, Romantic Movies</td>\n",
       "      <td>A wrong-number text sparks a virtual romance b...</td>\n",
       "      <td></td>\n",
       "      <td></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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6206</th>\n",
       "      <td>80173174</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Samantha!</td>\n",
       "      <td></td>\n",
       "      <td>Emmanuelle Araújo, Douglas Silva, Sabrina Nona...</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>April 19, 2019</td>\n",
       "      <td>2019</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>2 Seasons</td>\n",
       "      <td>International TV Shows, TV Comedies</td>\n",
       "      <td>A child star in the '80s, Samantha clings to t...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6215</th>\n",
       "      <td>80066227</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Crazy Ex-Girlfriend</td>\n",
       "      <td></td>\n",
       "      <td>Rachel Bloom, Vincent Rodriguez III, Santino F...</td>\n",
       "      <td>United States</td>\n",
       "      <td>April 13, 2019</td>\n",
       "      <td>2019</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>4 Seasons</td>\n",
       "      <td>Romantic TV Shows, TV Comedies</td>\n",
       "      <td>Still pining for Josh, the boy who dumped her ...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6216</th>\n",
       "      <td>80108373</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>The Magic School Bus Rides Again</td>\n",
       "      <td></td>\n",
       "      <td>Kate McKinnon, Miles Koseleci-Vieira, Mikaela ...</td>\n",
       "      <td>United States</td>\n",
       "      <td>April 13, 2018</td>\n",
       "      <td>2018</td>\n",
       "      <td>TV-Y</td>\n",
       "      <td>2 Seasons</td>\n",
       "      <td>Kids' TV</td>\n",
       "      <td>Ms. Frizzle's kid sister Fiona takes the wheel...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6219</th>\n",
       "      <td>80186475</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Pokémon the Series</td>\n",
       "      <td></td>\n",
       "      <td>Sarah Natochenny, Laurie Hymes, Jessica Paquet...</td>\n",
       "      <td>Japan</td>\n",
       "      <td>April 1, 2019</td>\n",
       "      <td>2019</td>\n",
       "      <td>TV-Y7-FV</td>\n",
       "      <td>2 Seasons</td>\n",
       "      <td>Anime Series, Kids' TV</td>\n",
       "      <td>Ash and his Pikachu travel to the Alola region...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6224</th>\n",
       "      <td>70304979</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Anthony Bourdain: Parts Unknown</td>\n",
       "      <td></td>\n",
       "      <td>Anthony Bourdain</td>\n",
       "      <td>United States</td>\n",
       "      <td></td>\n",
       "      <td>2018</td>\n",
       "      <td>TV-PG</td>\n",
       "      <td>5 Seasons</td>\n",
       "      <td>Docuseries</td>\n",
       "      <td>This CNN original series has chef Anthony Bour...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1906 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       show_id     type                                    title  \\\n",
       "0     81145628    Movie  Norm of the North: King Sized Adventure   \n",
       "27    80203094    Movie                              City of Joy   \n",
       "28    80190843  TV Show                           First and Last   \n",
       "30    80988892    Movie                                 Next Gen   \n",
       "31    80239639    Movie                Sierra Burgess Is A Loser   \n",
       "...        ...      ...                                      ...   \n",
       "6206  80173174  TV Show                                Samantha!   \n",
       "6215  80066227  TV Show                      Crazy Ex-Girlfriend   \n",
       "6216  80108373  TV Show         The Magic School Bus Rides Again   \n",
       "6219  80186475  TV Show                       Pokémon the Series   \n",
       "6224  70304979  TV Show          Anthony Bourdain: Parts Unknown   \n",
       "\n",
       "                         director  \\\n",
       "0        Richard Finn, Tim Maltby   \n",
       "27                Madeleine Gavin   \n",
       "28                                  \n",
       "30    Kevin R. Adams, Joe Ksander   \n",
       "31                    Ian Samuels   \n",
       "...                           ...   \n",
       "6206                                \n",
       "6215                                \n",
       "6216                                \n",
       "6219                                \n",
       "6224                                \n",
       "\n",
       "                                                   cast  \\\n",
       "0     Alan Marriott, Andrew Toth, Brian Dobson, Cole...   \n",
       "27                                                        \n",
       "28                                                        \n",
       "30    John Krasinski, Charlyne Yi, Jason Sudeikis, M...   \n",
       "31    Shannon Purser, Kristine Froseth, RJ Cyler, No...   \n",
       "...                                                 ...   \n",
       "6206  Emmanuelle Araújo, Douglas Silva, Sabrina Nona...   \n",
       "6215  Rachel Bloom, Vincent Rodriguez III, Santino F...   \n",
       "6216  Kate McKinnon, Miles Koseleci-Vieira, Mikaela ...   \n",
       "6219  Sarah Natochenny, Laurie Hymes, Jessica Paquet...   \n",
       "6224                                   Anthony Bourdain   \n",
       "\n",
       "                                       country         date_added  \\\n",
       "0     United States, India, South Korea, China  September 9, 2019   \n",
       "27                              United States,  September 7, 2018   \n",
       "28                                              September 7, 2018   \n",
       "30                China, Canada, United States  September 7, 2018   \n",
       "31                               United States  September 7, 2018   \n",
       "...                                        ...                ...   \n",
       "6206                                    Brazil     April 19, 2019   \n",
       "6215                             United States     April 13, 2019   \n",
       "6216                             United States     April 13, 2018   \n",
       "6219                                     Japan      April 1, 2019   \n",
       "6224                             United States                      \n",
       "\n",
       "      release_year    rating   duration  \\\n",
       "0             2019     TV-PG     90 min   \n",
       "27            2018     TV-MA     77 min   \n",
       "28            2018     TV-MA   1 Season   \n",
       "30            2018     TV-PG    106 min   \n",
       "31            2018     PG-13    106 min   \n",
       "...            ...       ...        ...   \n",
       "6206          2019     TV-MA  2 Seasons   \n",
       "6215          2019     TV-14  4 Seasons   \n",
       "6216          2018      TV-Y  2 Seasons   \n",
       "6219          2019  TV-Y7-FV  2 Seasons   \n",
       "6224          2018     TV-PG  5 Seasons   \n",
       "\n",
       "                                              listed_in  \\\n",
       "0                    Children & Family Movies, Comedies   \n",
       "27                                        Documentaries   \n",
       "28                                           Docuseries   \n",
       "30    Children & Family Movies, Comedies, Sci-Fi & F...   \n",
       "31                            Comedies, Romantic Movies   \n",
       "...                                                 ...   \n",
       "6206                International TV Shows, TV Comedies   \n",
       "6215                     Romantic TV Shows, TV Comedies   \n",
       "6216                                           Kids' TV   \n",
       "6219                             Anime Series, Kids' TV   \n",
       "6224                                         Docuseries   \n",
       "\n",
       "                                            description 中文字段 中 文 字 段  \n",
       "0     Before planning an awesome wedding for his gra...               \n",
       "27    Women who've been sexually brutalized in war-t...               \n",
       "28    Take an intimate look at the emotionally charg...               \n",
       "30    When lonely Mai forms an unlikely bond with a ...               \n",
       "31    A wrong-number text sparks a virtual romance b...               \n",
       "...                                                 ...  ...     ...  \n",
       "6206  A child star in the '80s, Samantha clings to t...               \n",
       "6215  Still pining for Josh, the boy who dumped her ...               \n",
       "6216  Ms. Frizzle's kid sister Fiona takes the wheel...               \n",
       "6219  Ash and his Pikachu travel to the Alola region...               \n",
       "6224  This CNN original series has chef Anthony Bour...               \n",
       "\n",
       "[1906 rows x 14 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "netflix.query(\"release_year in [2018, 2019]\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 2.4 对外部变量的支持"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "execution": {
     "iopub.execute_input": "2020-08-07T06:55:48.425717Z",
     "iopub.status.busy": "2020-08-07T06:55:48.425717Z",
     "iopub.status.idle": "2020-08-07T06:55:48.452644Z",
     "shell.execute_reply": "2020-08-07T06:55:48.452644Z",
     "shell.execute_reply.started": "2020-08-07T06:55:48.425717Z"
    }
   },
   "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",
       "      <th>中文字段</th>\n",
       "      <th>中 文 字 段</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>81145628</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Norm of the North: King Sized Adventure</td>\n",
       "      <td>Richard Finn, Tim Maltby</td>\n",
       "      <td>Alan Marriott, Andrew Toth, Brian Dobson, Cole...</td>\n",
       "      <td>United States, India, South Korea, China</td>\n",
       "      <td>September 9, 2019</td>\n",
       "      <td>2019</td>\n",
       "      <td>TV-PG</td>\n",
       "      <td>90 min</td>\n",
       "      <td>Children &amp; Family Movies, Comedies</td>\n",
       "      <td>Before planning an awesome wedding for his gra...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>80203094</td>\n",
       "      <td>Movie</td>\n",
       "      <td>City of Joy</td>\n",
       "      <td>Madeleine Gavin</td>\n",
       "      <td></td>\n",
       "      <td>United States,</td>\n",
       "      <td>September 7, 2018</td>\n",
       "      <td>2018</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>77 min</td>\n",
       "      <td>Documentaries</td>\n",
       "      <td>Women who've been sexually brutalized in war-t...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>80190843</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>First and Last</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>September 7, 2018</td>\n",
       "      <td>2018</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>1 Season</td>\n",
       "      <td>Docuseries</td>\n",
       "      <td>Take an intimate look at the emotionally charg...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>80988892</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Next Gen</td>\n",
       "      <td>Kevin R. Adams, Joe Ksander</td>\n",
       "      <td>John Krasinski, Charlyne Yi, Jason Sudeikis, M...</td>\n",
       "      <td>China, Canada, United States</td>\n",
       "      <td>September 7, 2018</td>\n",
       "      <td>2018</td>\n",
       "      <td>TV-PG</td>\n",
       "      <td>106 min</td>\n",
       "      <td>Children &amp; Family Movies, Comedies, Sci-Fi &amp; F...</td>\n",
       "      <td>When lonely Mai forms an unlikely bond with a ...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>80239639</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Sierra Burgess Is A Loser</td>\n",
       "      <td>Ian Samuels</td>\n",
       "      <td>Shannon Purser, Kristine Froseth, RJ Cyler, No...</td>\n",
       "      <td>United States</td>\n",
       "      <td>September 7, 2018</td>\n",
       "      <td>2018</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>106 min</td>\n",
       "      <td>Comedies, Romantic Movies</td>\n",
       "      <td>A wrong-number text sparks a virtual romance b...</td>\n",
       "      <td></td>\n",
       "      <td></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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6206</th>\n",
       "      <td>80173174</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Samantha!</td>\n",
       "      <td></td>\n",
       "      <td>Emmanuelle Araújo, Douglas Silva, Sabrina Nona...</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>April 19, 2019</td>\n",
       "      <td>2019</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>2 Seasons</td>\n",
       "      <td>International TV Shows, TV Comedies</td>\n",
       "      <td>A child star in the '80s, Samantha clings to t...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6215</th>\n",
       "      <td>80066227</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Crazy Ex-Girlfriend</td>\n",
       "      <td></td>\n",
       "      <td>Rachel Bloom, Vincent Rodriguez III, Santino F...</td>\n",
       "      <td>United States</td>\n",
       "      <td>April 13, 2019</td>\n",
       "      <td>2019</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>4 Seasons</td>\n",
       "      <td>Romantic TV Shows, TV Comedies</td>\n",
       "      <td>Still pining for Josh, the boy who dumped her ...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6216</th>\n",
       "      <td>80108373</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>The Magic School Bus Rides Again</td>\n",
       "      <td></td>\n",
       "      <td>Kate McKinnon, Miles Koseleci-Vieira, Mikaela ...</td>\n",
       "      <td>United States</td>\n",
       "      <td>April 13, 2018</td>\n",
       "      <td>2018</td>\n",
       "      <td>TV-Y</td>\n",
       "      <td>2 Seasons</td>\n",
       "      <td>Kids' TV</td>\n",
       "      <td>Ms. Frizzle's kid sister Fiona takes the wheel...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6219</th>\n",
       "      <td>80186475</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Pokémon the Series</td>\n",
       "      <td></td>\n",
       "      <td>Sarah Natochenny, Laurie Hymes, Jessica Paquet...</td>\n",
       "      <td>Japan</td>\n",
       "      <td>April 1, 2019</td>\n",
       "      <td>2019</td>\n",
       "      <td>TV-Y7-FV</td>\n",
       "      <td>2 Seasons</td>\n",
       "      <td>Anime Series, Kids' TV</td>\n",
       "      <td>Ash and his Pikachu travel to the Alola region...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6224</th>\n",
       "      <td>70304979</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Anthony Bourdain: Parts Unknown</td>\n",
       "      <td></td>\n",
       "      <td>Anthony Bourdain</td>\n",
       "      <td>United States</td>\n",
       "      <td></td>\n",
       "      <td>2018</td>\n",
       "      <td>TV-PG</td>\n",
       "      <td>5 Seasons</td>\n",
       "      <td>Docuseries</td>\n",
       "      <td>This CNN original series has chef Anthony Bour...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1906 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       show_id     type                                    title  \\\n",
       "0     81145628    Movie  Norm of the North: King Sized Adventure   \n",
       "27    80203094    Movie                              City of Joy   \n",
       "28    80190843  TV Show                           First and Last   \n",
       "30    80988892    Movie                                 Next Gen   \n",
       "31    80239639    Movie                Sierra Burgess Is A Loser   \n",
       "...        ...      ...                                      ...   \n",
       "6206  80173174  TV Show                                Samantha!   \n",
       "6215  80066227  TV Show                      Crazy Ex-Girlfriend   \n",
       "6216  80108373  TV Show         The Magic School Bus Rides Again   \n",
       "6219  80186475  TV Show                       Pokémon the Series   \n",
       "6224  70304979  TV Show          Anthony Bourdain: Parts Unknown   \n",
       "\n",
       "                         director  \\\n",
       "0        Richard Finn, Tim Maltby   \n",
       "27                Madeleine Gavin   \n",
       "28                                  \n",
       "30    Kevin R. Adams, Joe Ksander   \n",
       "31                    Ian Samuels   \n",
       "...                           ...   \n",
       "6206                                \n",
       "6215                                \n",
       "6216                                \n",
       "6219                                \n",
       "6224                                \n",
       "\n",
       "                                                   cast  \\\n",
       "0     Alan Marriott, Andrew Toth, Brian Dobson, Cole...   \n",
       "27                                                        \n",
       "28                                                        \n",
       "30    John Krasinski, Charlyne Yi, Jason Sudeikis, M...   \n",
       "31    Shannon Purser, Kristine Froseth, RJ Cyler, No...   \n",
       "...                                                 ...   \n",
       "6206  Emmanuelle Araújo, Douglas Silva, Sabrina Nona...   \n",
       "6215  Rachel Bloom, Vincent Rodriguez III, Santino F...   \n",
       "6216  Kate McKinnon, Miles Koseleci-Vieira, Mikaela ...   \n",
       "6219  Sarah Natochenny, Laurie Hymes, Jessica Paquet...   \n",
       "6224                                   Anthony Bourdain   \n",
       "\n",
       "                                       country         date_added  \\\n",
       "0     United States, India, South Korea, China  September 9, 2019   \n",
       "27                              United States,  September 7, 2018   \n",
       "28                                              September 7, 2018   \n",
       "30                China, Canada, United States  September 7, 2018   \n",
       "31                               United States  September 7, 2018   \n",
       "...                                        ...                ...   \n",
       "6206                                    Brazil     April 19, 2019   \n",
       "6215                             United States     April 13, 2019   \n",
       "6216                             United States     April 13, 2018   \n",
       "6219                                     Japan      April 1, 2019   \n",
       "6224                             United States                      \n",
       "\n",
       "      release_year    rating   duration  \\\n",
       "0             2019     TV-PG     90 min   \n",
       "27            2018     TV-MA     77 min   \n",
       "28            2018     TV-MA   1 Season   \n",
       "30            2018     TV-PG    106 min   \n",
       "31            2018     PG-13    106 min   \n",
       "...            ...       ...        ...   \n",
       "6206          2019     TV-MA  2 Seasons   \n",
       "6215          2019     TV-14  4 Seasons   \n",
       "6216          2018      TV-Y  2 Seasons   \n",
       "6219          2019  TV-Y7-FV  2 Seasons   \n",
       "6224          2018     TV-PG  5 Seasons   \n",
       "\n",
       "                                              listed_in  \\\n",
       "0                    Children & Family Movies, Comedies   \n",
       "27                                        Documentaries   \n",
       "28                                           Docuseries   \n",
       "30    Children & Family Movies, Comedies, Sci-Fi & F...   \n",
       "31                            Comedies, Romantic Movies   \n",
       "...                                                 ...   \n",
       "6206                International TV Shows, TV Comedies   \n",
       "6215                     Romantic TV Shows, TV Comedies   \n",
       "6216                                           Kids' TV   \n",
       "6219                             Anime Series, Kids' TV   \n",
       "6224                                         Docuseries   \n",
       "\n",
       "                                            description 中文字段 中 文 字 段  \n",
       "0     Before planning an awesome wedding for his gra...               \n",
       "27    Women who've been sexually brutalized in war-t...               \n",
       "28    Take an intimate look at the emotionally charg...               \n",
       "30    When lonely Mai forms an unlikely bond with a ...               \n",
       "31    A wrong-number text sparks a virtual romance b...               \n",
       "...                                                 ...  ...     ...  \n",
       "6206  A child star in the '80s, Samantha clings to t...               \n",
       "6215  Still pining for Josh, the boy who dumped her ...               \n",
       "6216  Ms. Frizzle's kid sister Fiona takes the wheel...               \n",
       "6219  Ash and his Pikachu travel to the Alola region...               \n",
       "6224  This CNN original series has chef Anthony Bour...               \n",
       "\n",
       "[1906 rows x 14 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "years = [2018, 2019]\n",
    "netflix.query(\"release_year in @years\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 2.5 对常规语句的支持"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "execution": {
     "iopub.execute_input": "2020-08-07T06:55:48.453642Z",
     "iopub.status.busy": "2020-08-07T06:55:48.453642Z",
     "iopub.status.idle": "2020-08-07T06:55:48.477577Z",
     "shell.execute_reply": "2020-08-07T06:55:48.477577Z",
     "shell.execute_reply.started": "2020-08-07T06:55:48.453642Z"
    }
   },
   "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",
       "      <th>中文字段</th>\n",
       "      <th>中 文 字 段</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>6139</th>\n",
       "      <td>80095299</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Ultimate Beastmaster</td>\n",
       "      <td></td>\n",
       "      <td>Tiki Barber, Chris Distefano, Francesco Facchi...</td>\n",
       "      <td>United States, Brazil, South Korea, Mexico, Ja...</td>\n",
       "      <td>August 31, 2018</td>\n",
       "      <td>2018</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>3 Seasons</td>\n",
       "      <td>Reality TV</td>\n",
       "      <td>In this intense obstacle course series, elite ...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6140</th>\n",
       "      <td>80156006</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Ultimate Beastmaster México</td>\n",
       "      <td></td>\n",
       "      <td>Luis Ernesto Franco, Inés Sainz, Tiki Barber, ...</td>\n",
       "      <td>United States, Brazil, South Korea, Mexico, Ja...</td>\n",
       "      <td>August 31, 2018</td>\n",
       "      <td>2018</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>3 Seasons</td>\n",
       "      <td>Reality TV, Spanish-Language TV Shows</td>\n",
       "      <td>Competitors representing countries from around...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       show_id     type                        title director  \\\n",
       "6139  80095299  TV Show         Ultimate Beastmaster            \n",
       "6140  80156006  TV Show  Ultimate Beastmaster México            \n",
       "\n",
       "                                                   cast  \\\n",
       "6139  Tiki Barber, Chris Distefano, Francesco Facchi...   \n",
       "6140  Luis Ernesto Franco, Inés Sainz, Tiki Barber, ...   \n",
       "\n",
       "                                                country        date_added  \\\n",
       "6139  United States, Brazil, South Korea, Mexico, Ja...   August 31, 2018   \n",
       "6140  United States, Brazil, South Korea, Mexico, Ja...   August 31, 2018   \n",
       "\n",
       "      release_year rating   duration                              listed_in  \\\n",
       "6139          2018  TV-14  3 Seasons                             Reality TV   \n",
       "6140          2018  TV-14  3 Seasons  Reality TV, Spanish-Language TV Shows   \n",
       "\n",
       "                                            description 中文字段 中 文 字 段  \n",
       "6139  In this intense obstacle course series, elite ...               \n",
       "6140  Competitors representing countries from around...               "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def country_count(s):\n",
    "    '''\n",
    "    计算涉及国家数量\n",
    "    '''\n",
    "    \n",
    "    return s.split(',').__len__()\n",
    "\n",
    "# 找出发行年份在2018或2019年且合作国家数量超过5个的剧集\n",
    "netflix.query(\"release_year.isin([2018, 2019]) and country.apply(@country_count) > 5\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 2.6 对Index与MultiIndex的支持"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "- **常规index**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "execution": {
     "iopub.execute_input": "2020-08-07T06:55:48.478575Z",
     "iopub.status.busy": "2020-08-07T06:55:48.478575Z",
     "iopub.status.idle": "2020-08-07T06:55:48.510491Z",
     "shell.execute_reply": "2020-08-07T06:55:48.509495Z",
     "shell.execute_reply.started": "2020-08-07T06:55:48.478575Z"
    }
   },
   "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>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",
       "      <th>中文字段</th>\n",
       "      <th>中 文 字 段</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>title</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Norm of the North: King Sized Adventure</th>\n",
       "      <td>81145628</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Richard Finn, Tim Maltby</td>\n",
       "      <td>Alan Marriott, Andrew Toth, Brian Dobson, Cole...</td>\n",
       "      <td>United States, India, South Korea, China</td>\n",
       "      <td>September 9, 2019</td>\n",
       "      <td>2019</td>\n",
       "      <td>TV-PG</td>\n",
       "      <td>90 min</td>\n",
       "      <td>Children &amp; Family Movies, Comedies</td>\n",
       "      <td>Before planning an awesome wedding for his gra...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>The Sinking Of Van Der Wijck</th>\n",
       "      <td>81002866</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Sunil Soraya</td>\n",
       "      <td>Herjunot Ali, Pevita Pearce, Reza Rahadian, Ra...</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>September 28, 2018</td>\n",
       "      <td>2013</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>163 min</td>\n",
       "      <td>Dramas, International Movies, Romantic Movies</td>\n",
       "      <td>When a young man leaves home to fulfill the wi...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Joseph: King of Dreams</th>\n",
       "      <td>60003155</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Rob LaDuca, Robert C. Ramirez</td>\n",
       "      <td>Ben Affleck, Mark Hamill, Richard Herd, Mauree...</td>\n",
       "      <td>United States</td>\n",
       "      <td>September 27, 2011</td>\n",
       "      <td>2000</td>\n",
       "      <td>TV-PG</td>\n",
       "      <td>75 min</td>\n",
       "      <td>Children &amp; Family Movies, Dramas, Faith &amp; Spir...</td>\n",
       "      <td>With his gift of dream interpretation and his ...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>King of Boys</th>\n",
       "      <td>81172721</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Kemi Adetiba</td>\n",
       "      <td>Sola Sobowale, Adesua Etomi, Remilekun Safaru,...</td>\n",
       "      <td>Nigeria</td>\n",
       "      <td>September 21, 2019</td>\n",
       "      <td>2018</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>182 min</td>\n",
       "      <td>Dramas, International Movies</td>\n",
       "      <td>When a powerful businesswoman’s political ambi...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>The Crystal Calls Making the Dark Crystal: Age of Resistance</th>\n",
       "      <td>80238013</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Randall Lobb</td>\n",
       "      <td>Taron Egerton, Natalie Dormer, Simon Pegg, Jas...</td>\n",
       "      <td>United States</td>\n",
       "      <td>September 14, 2019</td>\n",
       "      <td>2019</td>\n",
       "      <td>TV-PG</td>\n",
       "      <td>83 min</td>\n",
       "      <td>Documentaries, International Movies</td>\n",
       "      <td>Go behind the scenes with stars, puppeteers an...</td>\n",
       "      <td></td>\n",
       "      <td></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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>All Hail King Julien</th>\n",
       "      <td>80018987</td>\n",
       "      <td>TV Show</td>\n",
       "      <td></td>\n",
       "      <td>Danny Jacobs, Andy Richter, Henry Winkler, Kev...</td>\n",
       "      <td>United States</td>\n",
       "      <td>December 1, 2017</td>\n",
       "      <td>2017</td>\n",
       "      <td>TV-Y7-FV</td>\n",
       "      <td>5 Seasons</td>\n",
       "      <td>Kids' TV, TV Comedies</td>\n",
       "      <td>In this Emmy winner for Outstanding Children's...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>The Great British Baking Show</th>\n",
       "      <td>80063224</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Andy Devonshire</td>\n",
       "      <td>Mel Giedroyc, Sue Perkins, Mary Berry, Paul Ho...</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>August 30, 2019</td>\n",
       "      <td>2019</td>\n",
       "      <td>TV-PG</td>\n",
       "      <td>7 Seasons</td>\n",
       "      <td>British TV Shows, Reality TV</td>\n",
       "      <td>A talented batch of amateur bakers face off in...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>True and the Rainbow Kingdom</th>\n",
       "      <td>80063599</td>\n",
       "      <td>TV Show</td>\n",
       "      <td></td>\n",
       "      <td>Michela Luci, Jamie Watson, Anna Claire Bartla...</td>\n",
       "      <td>Canada</td>\n",
       "      <td>August 30, 2019</td>\n",
       "      <td>2019</td>\n",
       "      <td>TV-Y</td>\n",
       "      <td>3 Seasons</td>\n",
       "      <td>Kids' TV</td>\n",
       "      <td>When something's wrong in the Rainbow Kingdom,...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Breaking Bad</th>\n",
       "      <td>70143836</td>\n",
       "      <td>TV Show</td>\n",
       "      <td></td>\n",
       "      <td>Bryan Cranston, Aaron Paul, Anna Gunn, Dean No...</td>\n",
       "      <td>United States</td>\n",
       "      <td>August 2, 2013</td>\n",
       "      <td>2013</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>5 Seasons</td>\n",
       "      <td>Crime TV Shows, TV Dramas, TV Thrillers</td>\n",
       "      <td>A high school chemistry teacher dying of cance...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Talking Tom and Friends</th>\n",
       "      <td>80162994</td>\n",
       "      <td>TV Show</td>\n",
       "      <td></td>\n",
       "      <td>Colin Hanks, Tom Kenny, James Adomian, Lisa Sc...</td>\n",
       "      <td>Cyprus, Austria, Thailand</td>\n",
       "      <td>April 10, 2019</td>\n",
       "      <td>2017</td>\n",
       "      <td>TV-G</td>\n",
       "      <td>2 Seasons</td>\n",
       "      <td>Kids' TV, TV Comedies</td>\n",
       "      <td>Full of funny one-liners and always ready for ...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>88 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                     show_id     type  \\\n",
       "title                                                                   \n",
       "Norm of the North: King Sized Adventure             81145628    Movie   \n",
       "The Sinking Of Van Der Wijck                        81002866    Movie   \n",
       "Joseph: King of Dreams                              60003155    Movie   \n",
       "King of Boys                                        81172721    Movie   \n",
       "The Crystal Calls Making the Dark Crystal: Age ...  80238013    Movie   \n",
       "...                                                      ...      ...   \n",
       "All Hail King Julien                                80018987  TV Show   \n",
       "The Great British Baking Show                       80063224  TV Show   \n",
       "True and the Rainbow Kingdom                        80063599  TV Show   \n",
       "Breaking Bad                                        70143836  TV Show   \n",
       "Talking Tom and Friends                             80162994  TV Show   \n",
       "\n",
       "                                                                         director  \\\n",
       "title                                                                               \n",
       "Norm of the North: King Sized Adventure                  Richard Finn, Tim Maltby   \n",
       "The Sinking Of Van Der Wijck                                         Sunil Soraya   \n",
       "Joseph: King of Dreams                              Rob LaDuca, Robert C. Ramirez   \n",
       "King of Boys                                                         Kemi Adetiba   \n",
       "The Crystal Calls Making the Dark Crystal: Age ...                   Randall Lobb   \n",
       "...                                                                           ...   \n",
       "All Hail King Julien                                                                \n",
       "The Great British Baking Show                                     Andy Devonshire   \n",
       "True and the Rainbow Kingdom                                                        \n",
       "Breaking Bad                                                                        \n",
       "Talking Tom and Friends                                                             \n",
       "\n",
       "                                                                                                 cast  \\\n",
       "title                                                                                                   \n",
       "Norm of the North: King Sized Adventure             Alan Marriott, Andrew Toth, Brian Dobson, Cole...   \n",
       "The Sinking Of Van Der Wijck                        Herjunot Ali, Pevita Pearce, Reza Rahadian, Ra...   \n",
       "Joseph: King of Dreams                              Ben Affleck, Mark Hamill, Richard Herd, Mauree...   \n",
       "King of Boys                                        Sola Sobowale, Adesua Etomi, Remilekun Safaru,...   \n",
       "The Crystal Calls Making the Dark Crystal: Age ...  Taron Egerton, Natalie Dormer, Simon Pegg, Jas...   \n",
       "...                                                                                               ...   \n",
       "All Hail King Julien                                Danny Jacobs, Andy Richter, Henry Winkler, Kev...   \n",
       "The Great British Baking Show                       Mel Giedroyc, Sue Perkins, Mary Berry, Paul Ho...   \n",
       "True and the Rainbow Kingdom                        Michela Luci, Jamie Watson, Anna Claire Bartla...   \n",
       "Breaking Bad                                        Bryan Cranston, Aaron Paul, Anna Gunn, Dean No...   \n",
       "Talking Tom and Friends                             Colin Hanks, Tom Kenny, James Adomian, Lisa Sc...   \n",
       "\n",
       "                                                                                     country  \\\n",
       "title                                                                                          \n",
       "Norm of the North: King Sized Adventure             United States, India, South Korea, China   \n",
       "The Sinking Of Van Der Wijck                                                       Indonesia   \n",
       "Joseph: King of Dreams                                                         United States   \n",
       "King of Boys                                                                         Nigeria   \n",
       "The Crystal Calls Making the Dark Crystal: Age ...                             United States   \n",
       "...                                                                                      ...   \n",
       "All Hail King Julien                                                           United States   \n",
       "The Great British Baking Show                                                 United Kingdom   \n",
       "True and the Rainbow Kingdom                                                          Canada   \n",
       "Breaking Bad                                                                   United States   \n",
       "Talking Tom and Friends                                            Cyprus, Austria, Thailand   \n",
       "\n",
       "                                                            date_added  \\\n",
       "title                                                                    \n",
       "Norm of the North: King Sized Adventure              September 9, 2019   \n",
       "The Sinking Of Van Der Wijck                        September 28, 2018   \n",
       "Joseph: King of Dreams                              September 27, 2011   \n",
       "King of Boys                                        September 21, 2019   \n",
       "The Crystal Calls Making the Dark Crystal: Age ...  September 14, 2019   \n",
       "...                                                                ...   \n",
       "All Hail King Julien                                  December 1, 2017   \n",
       "The Great British Baking Show                          August 30, 2019   \n",
       "True and the Rainbow Kingdom                           August 30, 2019   \n",
       "Breaking Bad                                            August 2, 2013   \n",
       "Talking Tom and Friends                                 April 10, 2019   \n",
       "\n",
       "                                                    release_year    rating  \\\n",
       "title                                                                        \n",
       "Norm of the North: King Sized Adventure                     2019     TV-PG   \n",
       "The Sinking Of Van Der Wijck                                2013     TV-14   \n",
       "Joseph: King of Dreams                                      2000     TV-PG   \n",
       "King of Boys                                                2018     TV-MA   \n",
       "The Crystal Calls Making the Dark Crystal: Age ...          2019     TV-PG   \n",
       "...                                                          ...       ...   \n",
       "All Hail King Julien                                        2017  TV-Y7-FV   \n",
       "The Great British Baking Show                               2019     TV-PG   \n",
       "True and the Rainbow Kingdom                                2019      TV-Y   \n",
       "Breaking Bad                                                2013     TV-MA   \n",
       "Talking Tom and Friends                                     2017      TV-G   \n",
       "\n",
       "                                                     duration  \\\n",
       "title                                                           \n",
       "Norm of the North: King Sized Adventure                90 min   \n",
       "The Sinking Of Van Der Wijck                          163 min   \n",
       "Joseph: King of Dreams                                 75 min   \n",
       "King of Boys                                          182 min   \n",
       "The Crystal Calls Making the Dark Crystal: Age ...     83 min   \n",
       "...                                                       ...   \n",
       "All Hail King Julien                                5 Seasons   \n",
       "The Great British Baking Show                       7 Seasons   \n",
       "True and the Rainbow Kingdom                        3 Seasons   \n",
       "Breaking Bad                                        5 Seasons   \n",
       "Talking Tom and Friends                             2 Seasons   \n",
       "\n",
       "                                                                                            listed_in  \\\n",
       "title                                                                                                   \n",
       "Norm of the North: King Sized Adventure                            Children & Family Movies, Comedies   \n",
       "The Sinking Of Van Der Wijck                            Dramas, International Movies, Romantic Movies   \n",
       "Joseph: King of Dreams                              Children & Family Movies, Dramas, Faith & Spir...   \n",
       "King of Boys                                                             Dramas, International Movies   \n",
       "The Crystal Calls Making the Dark Crystal: Age ...                Documentaries, International Movies   \n",
       "...                                                                                               ...   \n",
       "All Hail King Julien                                                            Kids' TV, TV Comedies   \n",
       "The Great British Baking Show                                            British TV Shows, Reality TV   \n",
       "True and the Rainbow Kingdom                                                                 Kids' TV   \n",
       "Breaking Bad                                                  Crime TV Shows, TV Dramas, TV Thrillers   \n",
       "Talking Tom and Friends                                                         Kids' TV, TV Comedies   \n",
       "\n",
       "                                                                                          description  \\\n",
       "title                                                                                                   \n",
       "Norm of the North: King Sized Adventure             Before planning an awesome wedding for his gra...   \n",
       "The Sinking Of Van Der Wijck                        When a young man leaves home to fulfill the wi...   \n",
       "Joseph: King of Dreams                              With his gift of dream interpretation and his ...   \n",
       "King of Boys                                        When a powerful businesswoman’s political ambi...   \n",
       "The Crystal Calls Making the Dark Crystal: Age ...  Go behind the scenes with stars, puppeteers an...   \n",
       "...                                                                                               ...   \n",
       "All Hail King Julien                                In this Emmy winner for Outstanding Children's...   \n",
       "The Great British Baking Show                       A talented batch of amateur bakers face off in...   \n",
       "True and the Rainbow Kingdom                        When something's wrong in the Rainbow Kingdom,...   \n",
       "Breaking Bad                                        A high school chemistry teacher dying of cance...   \n",
       "Talking Tom and Friends                             Full of funny one-liners and always ready for ...   \n",
       "\n",
       "                                                   中文字段 中 文 字 段  \n",
       "title                                                            \n",
       "Norm of the North: King Sized Adventure                          \n",
       "The Sinking Of Van Der Wijck                                     \n",
       "Joseph: King of Dreams                                           \n",
       "King of Boys                                                     \n",
       "The Crystal Calls Making the Dark Crystal: Age ...               \n",
       "...                                                 ...     ...  \n",
       "All Hail King Julien                                             \n",
       "The Great British Baking Show                                    \n",
       "True and the Rainbow Kingdom                                     \n",
       "Breaking Bad                                                     \n",
       "Talking Tom and Friends                                          \n",
       "\n",
       "[88 rows x 13 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 找出索引列中包含king的记录，忽略大小写\n",
    "netflix.set_index('title').query(\"index.str.contains('king', case=False)\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "- **names为空的MultiIndex**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "execution": {
     "iopub.execute_input": "2020-08-07T06:55:48.511488Z",
     "iopub.status.busy": "2020-08-07T06:55:48.511488Z",
     "iopub.status.idle": "2020-08-07T06:55:48.554378Z",
     "shell.execute_reply": "2020-08-07T06:55:48.554378Z",
     "shell.execute_reply.started": "2020-08-07T06:55:48.511488Z"
    }
   },
   "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></th>\n",
       "      <th>show_id</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",
       "      <th>中文字段</th>\n",
       "      <th>中 文 字 段</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Norm of the North: King Sized Adventure</th>\n",
       "      <th>Movie</th>\n",
       "      <td>81145628</td>\n",
       "      <td>Richard Finn, Tim Maltby</td>\n",
       "      <td>Alan Marriott, Andrew Toth, Brian Dobson, Cole...</td>\n",
       "      <td>United States, India, South Korea, China</td>\n",
       "      <td>September 9, 2019</td>\n",
       "      <td>2019</td>\n",
       "      <td>TV-PG</td>\n",
       "      <td>90 min</td>\n",
       "      <td>Children &amp; Family Movies, Comedies</td>\n",
       "      <td>Before planning an awesome wedding for his gra...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>The Sinking Of Van Der Wijck</th>\n",
       "      <th>Movie</th>\n",
       "      <td>81002866</td>\n",
       "      <td>Sunil Soraya</td>\n",
       "      <td>Herjunot Ali, Pevita Pearce, Reza Rahadian, Ra...</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>September 28, 2018</td>\n",
       "      <td>2013</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>163 min</td>\n",
       "      <td>Dramas, International Movies, Romantic Movies</td>\n",
       "      <td>When a young man leaves home to fulfill the wi...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Joseph: King of Dreams</th>\n",
       "      <th>Movie</th>\n",
       "      <td>60003155</td>\n",
       "      <td>Rob LaDuca, Robert C. Ramirez</td>\n",
       "      <td>Ben Affleck, Mark Hamill, Richard Herd, Mauree...</td>\n",
       "      <td>United States</td>\n",
       "      <td>September 27, 2011</td>\n",
       "      <td>2000</td>\n",
       "      <td>TV-PG</td>\n",
       "      <td>75 min</td>\n",
       "      <td>Children &amp; Family Movies, Dramas, Faith &amp; Spir...</td>\n",
       "      <td>With his gift of dream interpretation and his ...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>King of Boys</th>\n",
       "      <th>Movie</th>\n",
       "      <td>81172721</td>\n",
       "      <td>Kemi Adetiba</td>\n",
       "      <td>Sola Sobowale, Adesua Etomi, Remilekun Safaru,...</td>\n",
       "      <td>Nigeria</td>\n",
       "      <td>September 21, 2019</td>\n",
       "      <td>2018</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>182 min</td>\n",
       "      <td>Dramas, International Movies</td>\n",
       "      <td>When a powerful businesswoman’s political ambi...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>The Crystal Calls Making the Dark Crystal: Age of Resistance</th>\n",
       "      <th>Movie</th>\n",
       "      <td>80238013</td>\n",
       "      <td>Randall Lobb</td>\n",
       "      <td>Taron Egerton, Natalie Dormer, Simon Pegg, Jas...</td>\n",
       "      <td>United States</td>\n",
       "      <td>September 14, 2019</td>\n",
       "      <td>2019</td>\n",
       "      <td>TV-PG</td>\n",
       "      <td>83 min</td>\n",
       "      <td>Documentaries, International Movies</td>\n",
       "      <td>Go behind the scenes with stars, puppeteers an...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Jeff Foxworthy and Larry the Cable Guy: We’ve Been Thinking...</th>\n",
       "      <th>Movie</th>\n",
       "      <td>80097431</td>\n",
       "      <td>Jay Karas</td>\n",
       "      <td>Jeff Foxworthy, Larry the Cable Guy</td>\n",
       "      <td>United States</td>\n",
       "      <td>August 26, 2016</td>\n",
       "      <td>2016</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>75 min</td>\n",
       "      <td>Stand-Up Comedy</td>\n",
       "      <td>Grammy-nominated comedians Jeff Foxworthy and ...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Jim Gaffigan: King Baby</th>\n",
       "      <th>Movie</th>\n",
       "      <td>70113636</td>\n",
       "      <td>Troy Miller</td>\n",
       "      <td>Jim Gaffigan</td>\n",
       "      <td>United States</td>\n",
       "      <td>August 11, 2016</td>\n",
       "      <td>2009</td>\n",
       "      <td>TV-PG</td>\n",
       "      <td>71 min</td>\n",
       "      <td>Stand-Up Comedy</td>\n",
       "      <td>Jim Gaffigan offers up his take on bacon, bowl...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Alive and Kicking</th>\n",
       "      <th>Movie</th>\n",
       "      <td>80105356</td>\n",
       "      <td>Susan Glatzer</td>\n",
       "      <td></td>\n",
       "      <td>Sweden, United States</td>\n",
       "      <td>August 10, 2017</td>\n",
       "      <td>2016</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>89 min</td>\n",
       "      <td>Documentaries</td>\n",
       "      <td>Take an inside look at swing dancing's continu...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rodney King</th>\n",
       "      <th>Movie</th>\n",
       "      <td>80128715</td>\n",
       "      <td>Spike Lee</td>\n",
       "      <td>Roger Guenveur Smith</td>\n",
       "      <td>United States</td>\n",
       "      <td>April 28, 2017</td>\n",
       "      <td>2017</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>53 min</td>\n",
       "      <td>Dramas</td>\n",
       "      <td>Roger Guenveur Smith gives voice to the man at...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Patton Oswalt: Talking for Clapping</th>\n",
       "      <th>Movie</th>\n",
       "      <td>80082862</td>\n",
       "      <td></td>\n",
       "      <td>Patton Oswalt</td>\n",
       "      <td>United States</td>\n",
       "      <td>April 22, 2016</td>\n",
       "      <td>2016</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>66 min</td>\n",
       "      <td>Stand-Up Comedy</td>\n",
       "      <td>On stage in San Francisco, the comedian covers...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>62 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                           show_id  \\\n",
       "Norm of the North: King Sized Adventure            Movie  81145628   \n",
       "The Sinking Of Van Der Wijck                       Movie  81002866   \n",
       "Joseph: King of Dreams                             Movie  60003155   \n",
       "King of Boys                                       Movie  81172721   \n",
       "The Crystal Calls Making the Dark Crystal: Age ... Movie  80238013   \n",
       "...                                                            ...   \n",
       "Jeff Foxworthy and Larry the Cable Guy: We’ve B... Movie  80097431   \n",
       "Jim Gaffigan: King Baby                            Movie  70113636   \n",
       "Alive and Kicking                                  Movie  80105356   \n",
       "Rodney King                                        Movie  80128715   \n",
       "Patton Oswalt: Talking for Clapping                Movie  80082862   \n",
       "\n",
       "                                                                               director  \\\n",
       "Norm of the North: King Sized Adventure            Movie       Richard Finn, Tim Maltby   \n",
       "The Sinking Of Van Der Wijck                       Movie                   Sunil Soraya   \n",
       "Joseph: King of Dreams                             Movie  Rob LaDuca, Robert C. Ramirez   \n",
       "King of Boys                                       Movie                   Kemi Adetiba   \n",
       "The Crystal Calls Making the Dark Crystal: Age ... Movie                   Randall Lobb   \n",
       "...                                                                                 ...   \n",
       "Jeff Foxworthy and Larry the Cable Guy: We’ve B... Movie                      Jay Karas   \n",
       "Jim Gaffigan: King Baby                            Movie                    Troy Miller   \n",
       "Alive and Kicking                                  Movie                  Susan Glatzer   \n",
       "Rodney King                                        Movie                      Spike Lee   \n",
       "Patton Oswalt: Talking for Clapping                Movie                                  \n",
       "\n",
       "                                                                                                       cast  \\\n",
       "Norm of the North: King Sized Adventure            Movie  Alan Marriott, Andrew Toth, Brian Dobson, Cole...   \n",
       "The Sinking Of Van Der Wijck                       Movie  Herjunot Ali, Pevita Pearce, Reza Rahadian, Ra...   \n",
       "Joseph: King of Dreams                             Movie  Ben Affleck, Mark Hamill, Richard Herd, Mauree...   \n",
       "King of Boys                                       Movie  Sola Sobowale, Adesua Etomi, Remilekun Safaru,...   \n",
       "The Crystal Calls Making the Dark Crystal: Age ... Movie  Taron Egerton, Natalie Dormer, Simon Pegg, Jas...   \n",
       "...                                                                                                     ...   \n",
       "Jeff Foxworthy and Larry the Cable Guy: We’ve B... Movie                Jeff Foxworthy, Larry the Cable Guy   \n",
       "Jim Gaffigan: King Baby                            Movie                                       Jim Gaffigan   \n",
       "Alive and Kicking                                  Movie                                                      \n",
       "Rodney King                                        Movie                               Roger Guenveur Smith   \n",
       "Patton Oswalt: Talking for Clapping                Movie                                      Patton Oswalt   \n",
       "\n",
       "                                                                                           country  \\\n",
       "Norm of the North: King Sized Adventure            Movie  United States, India, South Korea, China   \n",
       "The Sinking Of Van Der Wijck                       Movie                                 Indonesia   \n",
       "Joseph: King of Dreams                             Movie                             United States   \n",
       "King of Boys                                       Movie                                   Nigeria   \n",
       "The Crystal Calls Making the Dark Crystal: Age ... Movie                             United States   \n",
       "...                                                                                            ...   \n",
       "Jeff Foxworthy and Larry the Cable Guy: We’ve B... Movie                             United States   \n",
       "Jim Gaffigan: King Baby                            Movie                             United States   \n",
       "Alive and Kicking                                  Movie                     Sweden, United States   \n",
       "Rodney King                                        Movie                             United States   \n",
       "Patton Oswalt: Talking for Clapping                Movie                             United States   \n",
       "\n",
       "                                                                  date_added  \\\n",
       "Norm of the North: King Sized Adventure            Movie   September 9, 2019   \n",
       "The Sinking Of Van Der Wijck                       Movie  September 28, 2018   \n",
       "Joseph: King of Dreams                             Movie  September 27, 2011   \n",
       "King of Boys                                       Movie  September 21, 2019   \n",
       "The Crystal Calls Making the Dark Crystal: Age ... Movie  September 14, 2019   \n",
       "...                                                                      ...   \n",
       "Jeff Foxworthy and Larry the Cable Guy: We’ve B... Movie     August 26, 2016   \n",
       "Jim Gaffigan: King Baby                            Movie     August 11, 2016   \n",
       "Alive and Kicking                                  Movie     August 10, 2017   \n",
       "Rodney King                                        Movie      April 28, 2017   \n",
       "Patton Oswalt: Talking for Clapping                Movie      April 22, 2016   \n",
       "\n",
       "                                                          release_year rating  \\\n",
       "Norm of the North: King Sized Adventure            Movie          2019  TV-PG   \n",
       "The Sinking Of Van Der Wijck                       Movie          2013  TV-14   \n",
       "Joseph: King of Dreams                             Movie          2000  TV-PG   \n",
       "King of Boys                                       Movie          2018  TV-MA   \n",
       "The Crystal Calls Making the Dark Crystal: Age ... Movie          2019  TV-PG   \n",
       "...                                                                ...    ...   \n",
       "Jeff Foxworthy and Larry the Cable Guy: We’ve B... Movie          2016  TV-14   \n",
       "Jim Gaffigan: King Baby                            Movie          2009  TV-PG   \n",
       "Alive and Kicking                                  Movie          2016  TV-14   \n",
       "Rodney King                                        Movie          2017  TV-MA   \n",
       "Patton Oswalt: Talking for Clapping                Movie          2016  TV-MA   \n",
       "\n",
       "                                                         duration  \\\n",
       "Norm of the North: King Sized Adventure            Movie   90 min   \n",
       "The Sinking Of Van Der Wijck                       Movie  163 min   \n",
       "Joseph: King of Dreams                             Movie   75 min   \n",
       "King of Boys                                       Movie  182 min   \n",
       "The Crystal Calls Making the Dark Crystal: Age ... Movie   83 min   \n",
       "...                                                           ...   \n",
       "Jeff Foxworthy and Larry the Cable Guy: We’ve B... Movie   75 min   \n",
       "Jim Gaffigan: King Baby                            Movie   71 min   \n",
       "Alive and Kicking                                  Movie   89 min   \n",
       "Rodney King                                        Movie   53 min   \n",
       "Patton Oswalt: Talking for Clapping                Movie   66 min   \n",
       "\n",
       "                                                                                                  listed_in  \\\n",
       "Norm of the North: King Sized Adventure            Movie                 Children & Family Movies, Comedies   \n",
       "The Sinking Of Van Der Wijck                       Movie      Dramas, International Movies, Romantic Movies   \n",
       "Joseph: King of Dreams                             Movie  Children & Family Movies, Dramas, Faith & Spir...   \n",
       "King of Boys                                       Movie                       Dramas, International Movies   \n",
       "The Crystal Calls Making the Dark Crystal: Age ... Movie                Documentaries, International Movies   \n",
       "...                                                                                                     ...   \n",
       "Jeff Foxworthy and Larry the Cable Guy: We’ve B... Movie                                    Stand-Up Comedy   \n",
       "Jim Gaffigan: King Baby                            Movie                                    Stand-Up Comedy   \n",
       "Alive and Kicking                                  Movie                                      Documentaries   \n",
       "Rodney King                                        Movie                                             Dramas   \n",
       "Patton Oswalt: Talking for Clapping                Movie                                    Stand-Up Comedy   \n",
       "\n",
       "                                                                                                description  \\\n",
       "Norm of the North: King Sized Adventure            Movie  Before planning an awesome wedding for his gra...   \n",
       "The Sinking Of Van Der Wijck                       Movie  When a young man leaves home to fulfill the wi...   \n",
       "Joseph: King of Dreams                             Movie  With his gift of dream interpretation and his ...   \n",
       "King of Boys                                       Movie  When a powerful businesswoman’s political ambi...   \n",
       "The Crystal Calls Making the Dark Crystal: Age ... Movie  Go behind the scenes with stars, puppeteers an...   \n",
       "...                                                                                                     ...   \n",
       "Jeff Foxworthy and Larry the Cable Guy: We’ve B... Movie  Grammy-nominated comedians Jeff Foxworthy and ...   \n",
       "Jim Gaffigan: King Baby                            Movie  Jim Gaffigan offers up his take on bacon, bowl...   \n",
       "Alive and Kicking                                  Movie  Take an inside look at swing dancing's continu...   \n",
       "Rodney King                                        Movie  Roger Guenveur Smith gives voice to the man at...   \n",
       "Patton Oswalt: Talking for Clapping                Movie  On stage in San Francisco, the comedian covers...   \n",
       "\n",
       "                                                         中文字段 中 文 字 段  \n",
       "Norm of the North: King Sized Adventure            Movie               \n",
       "The Sinking Of Van Der Wijck                       Movie               \n",
       "Joseph: King of Dreams                             Movie               \n",
       "King of Boys                                       Movie               \n",
       "The Crystal Calls Making the Dark Crystal: Age ... Movie               \n",
       "...                                                       ...     ...  \n",
       "Jeff Foxworthy and Larry the Cable Guy: We’ve B... Movie               \n",
       "Jim Gaffigan: King Baby                            Movie               \n",
       "Alive and Kicking                                  Movie               \n",
       "Rodney King                                        Movie               \n",
       "Patton Oswalt: Talking for Clapping                Movie               \n",
       "\n",
       "[62 rows x 12 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 构造含有MultiIndex的数据框，并重置index的names为None\n",
    "temp = netflix.set_index(['title', 'type']);temp.index.names = (None, None)\n",
    "\n",
    "# 找出第一个index包含king（忽略大小写），第二个index等于Movie的记录\n",
    "temp.query(\"ilevel_0.str.contains('king', case=False) and ilevel_1 == 'Movie'\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "- **names不为空的MultiIndex**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "execution": {
     "iopub.execute_input": "2020-08-07T06:55:48.557366Z",
     "iopub.status.busy": "2020-08-07T06:55:48.556406Z",
     "iopub.status.idle": "2020-08-07T06:55:48.600250Z",
     "shell.execute_reply": "2020-08-07T06:55:48.600250Z",
     "shell.execute_reply.started": "2020-08-07T06:55:48.557366Z"
    }
   },
   "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></th>\n",
       "      <th>show_id</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",
       "      <th>中文字段</th>\n",
       "      <th>中 文 字 段</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>title</th>\n",
       "      <th>type</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Norm of the North: King Sized Adventure</th>\n",
       "      <th>Movie</th>\n",
       "      <td>81145628</td>\n",
       "      <td>Richard Finn, Tim Maltby</td>\n",
       "      <td>Alan Marriott, Andrew Toth, Brian Dobson, Cole...</td>\n",
       "      <td>United States, India, South Korea, China</td>\n",
       "      <td>September 9, 2019</td>\n",
       "      <td>2019</td>\n",
       "      <td>TV-PG</td>\n",
       "      <td>90 min</td>\n",
       "      <td>Children &amp; Family Movies, Comedies</td>\n",
       "      <td>Before planning an awesome wedding for his gra...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>The Sinking Of Van Der Wijck</th>\n",
       "      <th>Movie</th>\n",
       "      <td>81002866</td>\n",
       "      <td>Sunil Soraya</td>\n",
       "      <td>Herjunot Ali, Pevita Pearce, Reza Rahadian, Ra...</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>September 28, 2018</td>\n",
       "      <td>2013</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>163 min</td>\n",
       "      <td>Dramas, International Movies, Romantic Movies</td>\n",
       "      <td>When a young man leaves home to fulfill the wi...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Joseph: King of Dreams</th>\n",
       "      <th>Movie</th>\n",
       "      <td>60003155</td>\n",
       "      <td>Rob LaDuca, Robert C. Ramirez</td>\n",
       "      <td>Ben Affleck, Mark Hamill, Richard Herd, Mauree...</td>\n",
       "      <td>United States</td>\n",
       "      <td>September 27, 2011</td>\n",
       "      <td>2000</td>\n",
       "      <td>TV-PG</td>\n",
       "      <td>75 min</td>\n",
       "      <td>Children &amp; Family Movies, Dramas, Faith &amp; Spir...</td>\n",
       "      <td>With his gift of dream interpretation and his ...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>King of Boys</th>\n",
       "      <th>Movie</th>\n",
       "      <td>81172721</td>\n",
       "      <td>Kemi Adetiba</td>\n",
       "      <td>Sola Sobowale, Adesua Etomi, Remilekun Safaru,...</td>\n",
       "      <td>Nigeria</td>\n",
       "      <td>September 21, 2019</td>\n",
       "      <td>2018</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>182 min</td>\n",
       "      <td>Dramas, International Movies</td>\n",
       "      <td>When a powerful businesswoman’s political ambi...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>The Crystal Calls Making the Dark Crystal: Age of Resistance</th>\n",
       "      <th>Movie</th>\n",
       "      <td>80238013</td>\n",
       "      <td>Randall Lobb</td>\n",
       "      <td>Taron Egerton, Natalie Dormer, Simon Pegg, Jas...</td>\n",
       "      <td>United States</td>\n",
       "      <td>September 14, 2019</td>\n",
       "      <td>2019</td>\n",
       "      <td>TV-PG</td>\n",
       "      <td>83 min</td>\n",
       "      <td>Documentaries, International Movies</td>\n",
       "      <td>Go behind the scenes with stars, puppeteers an...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Jeff Foxworthy and Larry the Cable Guy: We’ve Been Thinking...</th>\n",
       "      <th>Movie</th>\n",
       "      <td>80097431</td>\n",
       "      <td>Jay Karas</td>\n",
       "      <td>Jeff Foxworthy, Larry the Cable Guy</td>\n",
       "      <td>United States</td>\n",
       "      <td>August 26, 2016</td>\n",
       "      <td>2016</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>75 min</td>\n",
       "      <td>Stand-Up Comedy</td>\n",
       "      <td>Grammy-nominated comedians Jeff Foxworthy and ...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Jim Gaffigan: King Baby</th>\n",
       "      <th>Movie</th>\n",
       "      <td>70113636</td>\n",
       "      <td>Troy Miller</td>\n",
       "      <td>Jim Gaffigan</td>\n",
       "      <td>United States</td>\n",
       "      <td>August 11, 2016</td>\n",
       "      <td>2009</td>\n",
       "      <td>TV-PG</td>\n",
       "      <td>71 min</td>\n",
       "      <td>Stand-Up Comedy</td>\n",
       "      <td>Jim Gaffigan offers up his take on bacon, bowl...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Alive and Kicking</th>\n",
       "      <th>Movie</th>\n",
       "      <td>80105356</td>\n",
       "      <td>Susan Glatzer</td>\n",
       "      <td></td>\n",
       "      <td>Sweden, United States</td>\n",
       "      <td>August 10, 2017</td>\n",
       "      <td>2016</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>89 min</td>\n",
       "      <td>Documentaries</td>\n",
       "      <td>Take an inside look at swing dancing's continu...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rodney King</th>\n",
       "      <th>Movie</th>\n",
       "      <td>80128715</td>\n",
       "      <td>Spike Lee</td>\n",
       "      <td>Roger Guenveur Smith</td>\n",
       "      <td>United States</td>\n",
       "      <td>April 28, 2017</td>\n",
       "      <td>2017</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>53 min</td>\n",
       "      <td>Dramas</td>\n",
       "      <td>Roger Guenveur Smith gives voice to the man at...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Patton Oswalt: Talking for Clapping</th>\n",
       "      <th>Movie</th>\n",
       "      <td>80082862</td>\n",
       "      <td></td>\n",
       "      <td>Patton Oswalt</td>\n",
       "      <td>United States</td>\n",
       "      <td>April 22, 2016</td>\n",
       "      <td>2016</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>66 min</td>\n",
       "      <td>Stand-Up Comedy</td>\n",
       "      <td>On stage in San Francisco, the comedian covers...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>62 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                           show_id  \\\n",
       "title                                              type              \n",
       "Norm of the North: King Sized Adventure            Movie  81145628   \n",
       "The Sinking Of Van Der Wijck                       Movie  81002866   \n",
       "Joseph: King of Dreams                             Movie  60003155   \n",
       "King of Boys                                       Movie  81172721   \n",
       "The Crystal Calls Making the Dark Crystal: Age ... Movie  80238013   \n",
       "...                                                            ...   \n",
       "Jeff Foxworthy and Larry the Cable Guy: We’ve B... Movie  80097431   \n",
       "Jim Gaffigan: King Baby                            Movie  70113636   \n",
       "Alive and Kicking                                  Movie  80105356   \n",
       "Rodney King                                        Movie  80128715   \n",
       "Patton Oswalt: Talking for Clapping                Movie  80082862   \n",
       "\n",
       "                                                                               director  \\\n",
       "title                                              type                                   \n",
       "Norm of the North: King Sized Adventure            Movie       Richard Finn, Tim Maltby   \n",
       "The Sinking Of Van Der Wijck                       Movie                   Sunil Soraya   \n",
       "Joseph: King of Dreams                             Movie  Rob LaDuca, Robert C. Ramirez   \n",
       "King of Boys                                       Movie                   Kemi Adetiba   \n",
       "The Crystal Calls Making the Dark Crystal: Age ... Movie                   Randall Lobb   \n",
       "...                                                                                 ...   \n",
       "Jeff Foxworthy and Larry the Cable Guy: We’ve B... Movie                      Jay Karas   \n",
       "Jim Gaffigan: King Baby                            Movie                    Troy Miller   \n",
       "Alive and Kicking                                  Movie                  Susan Glatzer   \n",
       "Rodney King                                        Movie                      Spike Lee   \n",
       "Patton Oswalt: Talking for Clapping                Movie                                  \n",
       "\n",
       "                                                                                                       cast  \\\n",
       "title                                              type                                                       \n",
       "Norm of the North: King Sized Adventure            Movie  Alan Marriott, Andrew Toth, Brian Dobson, Cole...   \n",
       "The Sinking Of Van Der Wijck                       Movie  Herjunot Ali, Pevita Pearce, Reza Rahadian, Ra...   \n",
       "Joseph: King of Dreams                             Movie  Ben Affleck, Mark Hamill, Richard Herd, Mauree...   \n",
       "King of Boys                                       Movie  Sola Sobowale, Adesua Etomi, Remilekun Safaru,...   \n",
       "The Crystal Calls Making the Dark Crystal: Age ... Movie  Taron Egerton, Natalie Dormer, Simon Pegg, Jas...   \n",
       "...                                                                                                     ...   \n",
       "Jeff Foxworthy and Larry the Cable Guy: We’ve B... Movie                Jeff Foxworthy, Larry the Cable Guy   \n",
       "Jim Gaffigan: King Baby                            Movie                                       Jim Gaffigan   \n",
       "Alive and Kicking                                  Movie                                                      \n",
       "Rodney King                                        Movie                               Roger Guenveur Smith   \n",
       "Patton Oswalt: Talking for Clapping                Movie                                      Patton Oswalt   \n",
       "\n",
       "                                                                                           country  \\\n",
       "title                                              type                                              \n",
       "Norm of the North: King Sized Adventure            Movie  United States, India, South Korea, China   \n",
       "The Sinking Of Van Der Wijck                       Movie                                 Indonesia   \n",
       "Joseph: King of Dreams                             Movie                             United States   \n",
       "King of Boys                                       Movie                                   Nigeria   \n",
       "The Crystal Calls Making the Dark Crystal: Age ... Movie                             United States   \n",
       "...                                                                                            ...   \n",
       "Jeff Foxworthy and Larry the Cable Guy: We’ve B... Movie                             United States   \n",
       "Jim Gaffigan: King Baby                            Movie                             United States   \n",
       "Alive and Kicking                                  Movie                     Sweden, United States   \n",
       "Rodney King                                        Movie                             United States   \n",
       "Patton Oswalt: Talking for Clapping                Movie                             United States   \n",
       "\n",
       "                                                                  date_added  \\\n",
       "title                                              type                        \n",
       "Norm of the North: King Sized Adventure            Movie   September 9, 2019   \n",
       "The Sinking Of Van Der Wijck                       Movie  September 28, 2018   \n",
       "Joseph: King of Dreams                             Movie  September 27, 2011   \n",
       "King of Boys                                       Movie  September 21, 2019   \n",
       "The Crystal Calls Making the Dark Crystal: Age ... Movie  September 14, 2019   \n",
       "...                                                                      ...   \n",
       "Jeff Foxworthy and Larry the Cable Guy: We’ve B... Movie     August 26, 2016   \n",
       "Jim Gaffigan: King Baby                            Movie     August 11, 2016   \n",
       "Alive and Kicking                                  Movie     August 10, 2017   \n",
       "Rodney King                                        Movie      April 28, 2017   \n",
       "Patton Oswalt: Talking for Clapping                Movie      April 22, 2016   \n",
       "\n",
       "                                                          release_year rating  \\\n",
       "title                                              type                         \n",
       "Norm of the North: King Sized Adventure            Movie          2019  TV-PG   \n",
       "The Sinking Of Van Der Wijck                       Movie          2013  TV-14   \n",
       "Joseph: King of Dreams                             Movie          2000  TV-PG   \n",
       "King of Boys                                       Movie          2018  TV-MA   \n",
       "The Crystal Calls Making the Dark Crystal: Age ... Movie          2019  TV-PG   \n",
       "...                                                                ...    ...   \n",
       "Jeff Foxworthy and Larry the Cable Guy: We’ve B... Movie          2016  TV-14   \n",
       "Jim Gaffigan: King Baby                            Movie          2009  TV-PG   \n",
       "Alive and Kicking                                  Movie          2016  TV-14   \n",
       "Rodney King                                        Movie          2017  TV-MA   \n",
       "Patton Oswalt: Talking for Clapping                Movie          2016  TV-MA   \n",
       "\n",
       "                                                         duration  \\\n",
       "title                                              type             \n",
       "Norm of the North: King Sized Adventure            Movie   90 min   \n",
       "The Sinking Of Van Der Wijck                       Movie  163 min   \n",
       "Joseph: King of Dreams                             Movie   75 min   \n",
       "King of Boys                                       Movie  182 min   \n",
       "The Crystal Calls Making the Dark Crystal: Age ... Movie   83 min   \n",
       "...                                                           ...   \n",
       "Jeff Foxworthy and Larry the Cable Guy: We’ve B... Movie   75 min   \n",
       "Jim Gaffigan: King Baby                            Movie   71 min   \n",
       "Alive and Kicking                                  Movie   89 min   \n",
       "Rodney King                                        Movie   53 min   \n",
       "Patton Oswalt: Talking for Clapping                Movie   66 min   \n",
       "\n",
       "                                                                                                  listed_in  \\\n",
       "title                                              type                                                       \n",
       "Norm of the North: King Sized Adventure            Movie                 Children & Family Movies, Comedies   \n",
       "The Sinking Of Van Der Wijck                       Movie      Dramas, International Movies, Romantic Movies   \n",
       "Joseph: King of Dreams                             Movie  Children & Family Movies, Dramas, Faith & Spir...   \n",
       "King of Boys                                       Movie                       Dramas, International Movies   \n",
       "The Crystal Calls Making the Dark Crystal: Age ... Movie                Documentaries, International Movies   \n",
       "...                                                                                                     ...   \n",
       "Jeff Foxworthy and Larry the Cable Guy: We’ve B... Movie                                    Stand-Up Comedy   \n",
       "Jim Gaffigan: King Baby                            Movie                                    Stand-Up Comedy   \n",
       "Alive and Kicking                                  Movie                                      Documentaries   \n",
       "Rodney King                                        Movie                                             Dramas   \n",
       "Patton Oswalt: Talking for Clapping                Movie                                    Stand-Up Comedy   \n",
       "\n",
       "                                                                                                description  \\\n",
       "title                                              type                                                       \n",
       "Norm of the North: King Sized Adventure            Movie  Before planning an awesome wedding for his gra...   \n",
       "The Sinking Of Van Der Wijck                       Movie  When a young man leaves home to fulfill the wi...   \n",
       "Joseph: King of Dreams                             Movie  With his gift of dream interpretation and his ...   \n",
       "King of Boys                                       Movie  When a powerful businesswoman’s political ambi...   \n",
       "The Crystal Calls Making the Dark Crystal: Age ... Movie  Go behind the scenes with stars, puppeteers an...   \n",
       "...                                                                                                     ...   \n",
       "Jeff Foxworthy and Larry the Cable Guy: We’ve B... Movie  Grammy-nominated comedians Jeff Foxworthy and ...   \n",
       "Jim Gaffigan: King Baby                            Movie  Jim Gaffigan offers up his take on bacon, bowl...   \n",
       "Alive and Kicking                                  Movie  Take an inside look at swing dancing's continu...   \n",
       "Rodney King                                        Movie  Roger Guenveur Smith gives voice to the man at...   \n",
       "Patton Oswalt: Talking for Clapping                Movie  On stage in San Francisco, the comedian covers...   \n",
       "\n",
       "                                                         中文字段 中 文 字 段  \n",
       "title                                              type                \n",
       "Norm of the North: King Sized Adventure            Movie               \n",
       "The Sinking Of Van Der Wijck                       Movie               \n",
       "Joseph: King of Dreams                             Movie               \n",
       "King of Boys                                       Movie               \n",
       "The Crystal Calls Making the Dark Crystal: Age ... Movie               \n",
       "...                                                       ...     ...  \n",
       "Jeff Foxworthy and Larry the Cable Guy: We’ve B... Movie               \n",
       "Jim Gaffigan: King Baby                            Movie               \n",
       "Alive and Kicking                                  Movie               \n",
       "Rodney King                                        Movie               \n",
       "Patton Oswalt: Talking for Clapping                Movie               \n",
       "\n",
       "[62 rows x 12 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 构造含有MultiIndex的数据框，并重置index的names为None\n",
    "temp = netflix.set_index(['title', 'type'])\n",
    "\n",
    "# 找出第一个index包含king（忽略大小写），第二个index等于Movie的记录\n",
    "temp.query(\"title.str.contains('king', case=False) and type == 'Movie'\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 3 基于eval()的高效运算"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "execution": {
     "iopub.execute_input": "2020-08-07T06:55:48.601247Z",
     "iopub.status.busy": "2020-08-07T06:55:48.601247Z",
     "iopub.status.idle": "2020-08-07T06:55:48.608227Z",
     "shell.execute_reply": "2020-08-07T06:55:48.606237Z",
     "shell.execute_reply.started": "2020-08-07T06:55:48.601247Z"
    }
   },
   "outputs": [],
   "source": [
    "netflix.drop(columns=['中文字段', '中 文 字 段'], inplace=True) # 删除无关字段"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "execution": {
     "iopub.execute_input": "2020-08-07T06:55:48.610224Z",
     "iopub.status.busy": "2020-08-07T06:55:48.609225Z",
     "iopub.status.idle": "2020-08-07T06:55:48.617203Z",
     "shell.execute_reply": "2020-08-07T06:55:48.616205Z",
     "shell.execute_reply.started": "2020-08-07T06:55:48.610224Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'September 9, 2019'"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "netflix['date_added'][0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {
    "execution": {
     "iopub.execute_input": "2020-08-07T06:55:48.617203Z",
     "iopub.status.busy": "2020-08-07T06:55:48.617203Z",
     "iopub.status.idle": "2020-08-07T06:55:48.657097Z",
     "shell.execute_reply": "2020-08-07T06:55:48.655103Z",
     "shell.execute_reply.started": "2020-08-07T06:55:48.617203Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "show_id            True\n",
       "type               True\n",
       "title              True\n",
       "director           True\n",
       "cast               True\n",
       "country            True\n",
       "date_added         True\n",
       "release_year       True\n",
       "rating             True\n",
       "duration           True\n",
       "listed_in          True\n",
       "description        True\n",
       "years_to_now       True\n",
       "new_date_added    False\n",
       "dtype: bool"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 利用assign进行新增字段计算并保存为新数据框\n",
    "result1 = netflix.assign(years_to_now=2020 - netflix['release_year'],\n",
    "                         new_date_added=pd.to_datetime(netflix['date_added'].str.strip(), \n",
    "                                                       format='%B %d, %Y', errors='coerce'))\n",
    "\n",
    "# 利用eval()进行新增字段计算并保存为新数据框\n",
    "result2 = netflix.eval('''\n",
    "                       years_to_now = 2020 - release_year\n",
    "                       new_date_added = @pd.to_datetime(date_added.str.strip(), format='%B %d, %Y', errors='coerce')''')\n",
    "\n",
    "(result1 == result2).all()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "execution": {
     "iopub.execute_input": "2020-08-07T06:55:48.658094Z",
     "iopub.status.busy": "2020-08-07T06:55:48.658094Z",
     "iopub.status.idle": "2020-08-07T06:55:48.745860Z",
     "shell.execute_reply": "2020-08-07T06:55:48.744862Z",
     "shell.execute_reply.started": "2020-08-07T06:55:48.658094Z"
    }
   },
   "outputs": [
    {
     "ename": "TokenError",
     "evalue": "('EOF in multi-line statement', (2, 0))",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mTokenError\u001b[0m                                Traceback (most recent call last)",
      "\u001b[1;32m<ipython-input-16-b817afb0b2a9>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m\u001b[0m\n\u001b[0;32m      3\u001b[0m              new_date_added = @pd.to_datetime(date_added.str.strip(), \n\u001b[0;32m      4\u001b[0m                                               \u001b[0mformat\u001b[0m\u001b[1;33m=\u001b[0m\u001b[1;34m'%B %d, %Y'\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m----> 5\u001b[1;33m                                               errors='coerce')''')\n\u001b[0m",
      "\u001b[1;32mc:\\conda\\envs\\geo-spatial\\lib\\site-packages\\pandas\\core\\frame.py\u001b[0m in \u001b[0;36meval\u001b[1;34m(self, expr, inplace, **kwargs)\u001b[0m\n\u001b[0;32m   3463\u001b[0m         \u001b[0mkwargs\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;34m\"resolvers\"\u001b[0m\u001b[1;33m]\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mkwargs\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mget\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m\"resolvers\"\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m)\u001b[0m \u001b[1;33m+\u001b[0m \u001b[0mtuple\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mresolvers\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m   3464\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m-> 3465\u001b[1;33m         \u001b[1;32mreturn\u001b[0m \u001b[0m_eval\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mexpr\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0minplace\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0minplace\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;33m**\u001b[0m\u001b[0mkwargs\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m   3466\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m   3467\u001b[0m     \u001b[1;32mdef\u001b[0m \u001b[0mselect_dtypes\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0minclude\u001b[0m\u001b[1;33m=\u001b[0m\u001b[1;32mNone\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mexclude\u001b[0m\u001b[1;33m=\u001b[0m\u001b[1;32mNone\u001b[0m\u001b[1;33m)\u001b[0m \u001b[1;33m->\u001b[0m \u001b[1;34m\"DataFrame\"\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mc:\\conda\\envs\\geo-spatial\\lib\\site-packages\\pandas\\core\\computation\\eval.py\u001b[0m in \u001b[0;36meval\u001b[1;34m(expr, parser, engine, truediv, local_dict, global_dict, resolvers, level, target, inplace)\u001b[0m\n\u001b[0;32m    339\u001b[0m         )\n\u001b[0;32m    340\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 341\u001b[1;33m         \u001b[0mparsed_expr\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mExpr\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mexpr\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mengine\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mengine\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mparser\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mparser\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0menv\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0menv\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    342\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    343\u001b[0m         \u001b[1;31m# construct the engine and evaluate the parsed expression\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mc:\\conda\\envs\\geo-spatial\\lib\\site-packages\\pandas\\core\\computation\\expr.py\u001b[0m in \u001b[0;36m__init__\u001b[1;34m(self, expr, engine, parser, env, level)\u001b[0m\n\u001b[0;32m    785\u001b[0m         \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mparser\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mparser\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    786\u001b[0m         \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_visitor\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0m_parsers\u001b[0m\u001b[1;33m[\u001b[0m\u001b[0mparser\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0menv\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mengine\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mparser\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 787\u001b[1;33m         \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mterms\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mparse\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    788\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    789\u001b[0m     \u001b[1;33m@\u001b[0m\u001b[0mproperty\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mc:\\conda\\envs\\geo-spatial\\lib\\site-packages\\pandas\\core\\computation\\expr.py\u001b[0m in \u001b[0;36mparse\u001b[1;34m(self)\u001b[0m\n\u001b[0;32m    804\u001b[0m         \u001b[0mParse\u001b[0m \u001b[0man\u001b[0m \u001b[0mexpression\u001b[0m\u001b[1;33m.\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    805\u001b[0m         \"\"\"\n\u001b[1;32m--> 806\u001b[1;33m         \u001b[1;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_visitor\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mvisit\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mexpr\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    807\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    808\u001b[0m     \u001b[1;33m@\u001b[0m\u001b[0mproperty\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mc:\\conda\\envs\\geo-spatial\\lib\\site-packages\\pandas\\core\\computation\\expr.py\u001b[0m in \u001b[0;36mvisit\u001b[1;34m(self, node, **kwargs)\u001b[0m\n\u001b[0;32m    386\u001b[0m     \u001b[1;32mdef\u001b[0m \u001b[0mvisit\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mnode\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;33m**\u001b[0m\u001b[0mkwargs\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    387\u001b[0m         \u001b[1;32mif\u001b[0m \u001b[0misinstance\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mnode\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mstr\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 388\u001b[1;33m             \u001b[0mclean\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mpreparser\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mnode\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    389\u001b[0m             \u001b[1;32mtry\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    390\u001b[0m                 \u001b[0mnode\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mast\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mfix_missing_locations\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mast\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mparse\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mclean\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mc:\\conda\\envs\\geo-spatial\\lib\\site-packages\\pandas\\core\\computation\\expr.py\u001b[0m in \u001b[0;36m_preparse\u001b[1;34m(source, f)\u001b[0m\n\u001b[0;32m    152\u001b[0m     \"\"\"\n\u001b[0;32m    153\u001b[0m     \u001b[1;32massert\u001b[0m \u001b[0mcallable\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mf\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;34m\"f must be callable\"\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 154\u001b[1;33m     \u001b[1;32mreturn\u001b[0m \u001b[0mtokenize\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0muntokenize\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mf\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mx\u001b[0m\u001b[1;33m)\u001b[0m \u001b[1;32mfor\u001b[0m \u001b[0mx\u001b[0m \u001b[1;32min\u001b[0m \u001b[0mtokenize_string\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0msource\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    155\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    156\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mc:\\conda\\envs\\geo-spatial\\lib\\tokenize.py\u001b[0m in \u001b[0;36muntokenize\u001b[1;34m(iterable)\u001b[0m\n\u001b[0;32m    331\u001b[0m     \"\"\"\n\u001b[0;32m    332\u001b[0m     \u001b[0mut\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mUntokenizer\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 333\u001b[1;33m     \u001b[0mout\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mut\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0muntokenize\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0miterable\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    334\u001b[0m     \u001b[1;32mif\u001b[0m \u001b[0mut\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mencoding\u001b[0m \u001b[1;32mis\u001b[0m \u001b[1;32mnot\u001b[0m \u001b[1;32mNone\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    335\u001b[0m         \u001b[0mout\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mout\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mencode\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mut\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mencoding\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mc:\\conda\\envs\\geo-spatial\\lib\\tokenize.py\u001b[0m in \u001b[0;36muntokenize\u001b[1;34m(self, iterable)\u001b[0m\n\u001b[0;32m    242\u001b[0m         \u001b[1;32mfor\u001b[0m \u001b[0mt\u001b[0m \u001b[1;32min\u001b[0m \u001b[0mit\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    243\u001b[0m             \u001b[1;32mif\u001b[0m \u001b[0mlen\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mt\u001b[0m\u001b[1;33m)\u001b[0m \u001b[1;33m==\u001b[0m \u001b[1;36m2\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 244\u001b[1;33m                 \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mcompat\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mt\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mit\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    245\u001b[0m                 \u001b[1;32mbreak\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    246\u001b[0m             \u001b[0mtok_type\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mtoken\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mstart\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mend\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mline\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mt\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mc:\\conda\\envs\\geo-spatial\\lib\\tokenize.py\u001b[0m in \u001b[0;36mcompat\u001b[1;34m(self, token, iterable)\u001b[0m\n\u001b[0;32m    279\u001b[0m         \u001b[0mprevstring\u001b[0m \u001b[1;33m=\u001b[0m \u001b[1;32mFalse\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    280\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 281\u001b[1;33m         \u001b[1;32mfor\u001b[0m \u001b[0mtok\u001b[0m \u001b[1;32min\u001b[0m \u001b[0mchain\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m[\u001b[0m\u001b[0mtoken\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0miterable\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    282\u001b[0m             \u001b[0mtoknum\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mtokval\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mtok\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;36m2\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    283\u001b[0m             \u001b[1;32mif\u001b[0m \u001b[0mtoknum\u001b[0m \u001b[1;33m==\u001b[0m \u001b[0mENCODING\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mc:\\conda\\envs\\geo-spatial\\lib\\site-packages\\pandas\\core\\computation\\expr.py\u001b[0m in \u001b[0;36m<genexpr>\u001b[1;34m(.0)\u001b[0m\n\u001b[0;32m    152\u001b[0m     \"\"\"\n\u001b[0;32m    153\u001b[0m     \u001b[1;32massert\u001b[0m \u001b[0mcallable\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mf\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;34m\"f must be callable\"\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 154\u001b[1;33m     \u001b[1;32mreturn\u001b[0m \u001b[0mtokenize\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0muntokenize\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mf\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mx\u001b[0m\u001b[1;33m)\u001b[0m \u001b[1;32mfor\u001b[0m \u001b[0mx\u001b[0m \u001b[1;32min\u001b[0m \u001b[0mtokenize_string\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0msource\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    155\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    156\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mc:\\conda\\envs\\geo-spatial\\lib\\site-packages\\pandas\\core\\computation\\parsing.py\u001b[0m in \u001b[0;36mtokenize_string\u001b[1;34m(source)\u001b[0m\n\u001b[0;32m    180\u001b[0m     \u001b[1;31m# Loop over all tokens till a backtick (`) is found.\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    181\u001b[0m     \u001b[1;31m# Then, take all tokens till the next backtick to form a backtick quoted string\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 182\u001b[1;33m     \u001b[1;32mfor\u001b[0m \u001b[0mtoknum\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mtokval\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mstart\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0m_\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0m_\u001b[0m \u001b[1;32min\u001b[0m \u001b[0mtoken_generator\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    183\u001b[0m         \u001b[1;32mif\u001b[0m \u001b[0mtokval\u001b[0m \u001b[1;33m==\u001b[0m \u001b[1;34m\"`\"\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    184\u001b[0m             \u001b[1;32mtry\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mc:\\conda\\envs\\geo-spatial\\lib\\tokenize.py\u001b[0m in \u001b[0;36m_tokenize\u001b[1;34m(readline, encoding)\u001b[0m\n\u001b[0;32m    577\u001b[0m         \u001b[1;32melse\u001b[0m\u001b[1;33m:\u001b[0m                                  \u001b[1;31m# continued statement\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    578\u001b[0m             \u001b[1;32mif\u001b[0m \u001b[1;32mnot\u001b[0m \u001b[0mline\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 579\u001b[1;33m                 \u001b[1;32mraise\u001b[0m \u001b[0mTokenError\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m\"EOF in multi-line statement\"\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;33m(\u001b[0m\u001b[0mlnum\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;36m0\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    580\u001b[0m             \u001b[0mcontinued\u001b[0m \u001b[1;33m=\u001b[0m \u001b[1;36m0\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    581\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;31mTokenError\u001b[0m: ('EOF in multi-line statement', (2, 0))"
     ]
    }
   ],
   "source": [
    "netflix.eval('''\n",
    "             years_to_now = 2020 - release_year\n",
    "             new_date_added = @pd.to_datetime(date_added.str.strip(), \n",
    "                                              format='%B %d, %Y', \n",
    "                                              errors='coerce')''')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {
    "execution": {
     "iopub.execute_input": "2020-08-07T06:55:58.796915Z",
     "iopub.status.busy": "2020-08-07T06:55:58.796915Z",
     "iopub.status.idle": "2020-08-07T06:55:58.832820Z",
     "shell.execute_reply": "2020-08-07T06:55:58.831822Z",
     "shell.execute_reply.started": "2020-08-07T06:55:58.796915Z"
    }
   },
   "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",
       "      <th>years_to_now</th>\n",
       "      <th>new_date_added</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>81145628</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Norm of the North: King Sized Adventure</td>\n",
       "      <td>Richard Finn, Tim Maltby</td>\n",
       "      <td>Alan Marriott, Andrew Toth, Brian Dobson, Cole...</td>\n",
       "      <td>United States, India, South Korea, China</td>\n",
       "      <td>September 9, 2019</td>\n",
       "      <td>2019</td>\n",
       "      <td>TV-PG</td>\n",
       "      <td>90 min</td>\n",
       "      <td>Children &amp; Family Movies, Comedies</td>\n",
       "      <td>Before planning an awesome wedding for his gra...</td>\n",
       "      <td>1</td>\n",
       "      <td>2019-09-09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>80117401</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Jandino: Whatever it Takes</td>\n",
       "      <td></td>\n",
       "      <td>Jandino Asporaat</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>September 9, 2016</td>\n",
       "      <td>2016</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>94 min</td>\n",
       "      <td>Stand-Up Comedy</td>\n",
       "      <td>Jandino Asporaat riffs on the challenges of ra...</td>\n",
       "      <td>4</td>\n",
       "      <td>2016-09-09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>70234439</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Transformers Prime</td>\n",
       "      <td></td>\n",
       "      <td>Peter Cullen, Sumalee Montano, Frank Welker, J...</td>\n",
       "      <td>United States</td>\n",
       "      <td>September 8, 2018</td>\n",
       "      <td>2013</td>\n",
       "      <td>TV-Y7-FV</td>\n",
       "      <td>1 Season</td>\n",
       "      <td>Kids' TV</td>\n",
       "      <td>With the help of three human allies, the Autob...</td>\n",
       "      <td>7</td>\n",
       "      <td>2018-09-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>80058654</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Transformers: Robots in Disguise</td>\n",
       "      <td></td>\n",
       "      <td>Will Friedle, Darren Criss, Constance Zimmer, ...</td>\n",
       "      <td>United States</td>\n",
       "      <td>September 8, 2018</td>\n",
       "      <td>2016</td>\n",
       "      <td>TV-Y7</td>\n",
       "      <td>1 Season</td>\n",
       "      <td>Kids' TV</td>\n",
       "      <td>When a prison ship crash unleashes hundreds of...</td>\n",
       "      <td>4</td>\n",
       "      <td>2018-09-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>80125979</td>\n",
       "      <td>Movie</td>\n",
       "      <td>#realityhigh</td>\n",
       "      <td>Fernando Lebrija</td>\n",
       "      <td>Nesta Cooper, Kate Walsh, John Michael Higgins...</td>\n",
       "      <td>United States</td>\n",
       "      <td>September 8, 2017</td>\n",
       "      <td>2017</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>99 min</td>\n",
       "      <td>Comedies</td>\n",
       "      <td>When nerdy high schooler Dani finally attracts...</td>\n",
       "      <td>3</td>\n",
       "      <td>2017-09-08</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6229</th>\n",
       "      <td>80000063</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Red vs. Blue</td>\n",
       "      <td></td>\n",
       "      <td>Burnie Burns, Jason Saldaña, Gustavo Sorola, G...</td>\n",
       "      <td>United States</td>\n",
       "      <td></td>\n",
       "      <td>2015</td>\n",
       "      <td>NR</td>\n",
       "      <td>13 Seasons</td>\n",
       "      <td>TV Action &amp; Adventure, TV Comedies, TV Sci-Fi ...</td>\n",
       "      <td>This parody of first-person shooter games, mil...</td>\n",
       "      <td>5</td>\n",
       "      <td>NaT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6230</th>\n",
       "      <td>70286564</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Maron</td>\n",
       "      <td></td>\n",
       "      <td>Marc Maron, Judd Hirsch, Josh Brener, Nora Zeh...</td>\n",
       "      <td>United States</td>\n",
       "      <td></td>\n",
       "      <td>2016</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>4 Seasons</td>\n",
       "      <td>TV Comedies</td>\n",
       "      <td>Marc Maron stars as Marc Maron, who interviews...</td>\n",
       "      <td>4</td>\n",
       "      <td>NaT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6231</th>\n",
       "      <td>80116008</td>\n",
       "      <td>Movie</td>\n",
       "      <td>Little Baby Bum: Nursery Rhyme Friends</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>2016</td>\n",
       "      <td></td>\n",
       "      <td>60 min</td>\n",
       "      <td>Movies</td>\n",
       "      <td>Nursery rhymes and original music for children...</td>\n",
       "      <td>4</td>\n",
       "      <td>NaT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6232</th>\n",
       "      <td>70281022</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>A Young Doctor's Notebook and Other Stories</td>\n",
       "      <td></td>\n",
       "      <td>Daniel Radcliffe, Jon Hamm, Adam Godley, Chris...</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td></td>\n",
       "      <td>2013</td>\n",
       "      <td>TV-MA</td>\n",
       "      <td>2 Seasons</td>\n",
       "      <td>British TV Shows, TV Comedies, TV Dramas</td>\n",
       "      <td>Set during the Russian Revolution, this comic ...</td>\n",
       "      <td>7</td>\n",
       "      <td>NaT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6233</th>\n",
       "      <td>70153404</td>\n",
       "      <td>TV Show</td>\n",
       "      <td>Friends</td>\n",
       "      <td></td>\n",
       "      <td>Jennifer Aniston, Courteney Cox, Lisa Kudrow, ...</td>\n",
       "      <td>United States</td>\n",
       "      <td></td>\n",
       "      <td>2003</td>\n",
       "      <td>TV-14</td>\n",
       "      <td>10 Seasons</td>\n",
       "      <td>Classic &amp; Cult TV, TV Comedies</td>\n",
       "      <td>This hit sitcom follows the merry misadventure...</td>\n",
       "      <td>17</td>\n",
       "      <td>NaT</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>6234 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       show_id     type                                        title  \\\n",
       "0     81145628    Movie      Norm of the North: King Sized Adventure   \n",
       "1     80117401    Movie                   Jandino: Whatever it Takes   \n",
       "2     70234439  TV Show                           Transformers Prime   \n",
       "3     80058654  TV Show             Transformers: Robots in Disguise   \n",
       "4     80125979    Movie                                 #realityhigh   \n",
       "...        ...      ...                                          ...   \n",
       "6229  80000063  TV Show                                 Red vs. Blue   \n",
       "6230  70286564  TV Show                                        Maron   \n",
       "6231  80116008    Movie       Little Baby Bum: Nursery Rhyme Friends   \n",
       "6232  70281022  TV Show  A Young Doctor's Notebook and Other Stories   \n",
       "6233  70153404  TV Show                                      Friends   \n",
       "\n",
       "                      director  \\\n",
       "0     Richard Finn, Tim Maltby   \n",
       "1                                \n",
       "2                                \n",
       "3                                \n",
       "4             Fernando Lebrija   \n",
       "...                        ...   \n",
       "6229                             \n",
       "6230                             \n",
       "6231                             \n",
       "6232                             \n",
       "6233                             \n",
       "\n",
       "                                                   cast  \\\n",
       "0     Alan Marriott, Andrew Toth, Brian Dobson, Cole...   \n",
       "1                                      Jandino Asporaat   \n",
       "2     Peter Cullen, Sumalee Montano, Frank Welker, J...   \n",
       "3     Will Friedle, Darren Criss, Constance Zimmer, ...   \n",
       "4     Nesta Cooper, Kate Walsh, John Michael Higgins...   \n",
       "...                                                 ...   \n",
       "6229  Burnie Burns, Jason Saldaña, Gustavo Sorola, G...   \n",
       "6230  Marc Maron, Judd Hirsch, Josh Brener, Nora Zeh...   \n",
       "6231                                                      \n",
       "6232  Daniel Radcliffe, Jon Hamm, Adam Godley, Chris...   \n",
       "6233  Jennifer Aniston, Courteney Cox, Lisa Kudrow, ...   \n",
       "\n",
       "                                       country         date_added  \\\n",
       "0     United States, India, South Korea, China  September 9, 2019   \n",
       "1                               United Kingdom  September 9, 2016   \n",
       "2                                United States  September 8, 2018   \n",
       "3                                United States  September 8, 2018   \n",
       "4                                United States  September 8, 2017   \n",
       "...                                        ...                ...   \n",
       "6229                             United States                      \n",
       "6230                             United States                      \n",
       "6231                                                                \n",
       "6232                            United Kingdom                      \n",
       "6233                             United States                      \n",
       "\n",
       "      release_year    rating    duration  \\\n",
       "0             2019     TV-PG      90 min   \n",
       "1             2016     TV-MA      94 min   \n",
       "2             2013  TV-Y7-FV    1 Season   \n",
       "3             2016     TV-Y7    1 Season   \n",
       "4             2017     TV-14      99 min   \n",
       "...            ...       ...         ...   \n",
       "6229          2015        NR  13 Seasons   \n",
       "6230          2016     TV-MA   4 Seasons   \n",
       "6231          2016                60 min   \n",
       "6232          2013     TV-MA   2 Seasons   \n",
       "6233          2003     TV-14  10 Seasons   \n",
       "\n",
       "                                              listed_in  \\\n",
       "0                    Children & Family Movies, Comedies   \n",
       "1                                       Stand-Up Comedy   \n",
       "2                                              Kids' TV   \n",
       "3                                              Kids' TV   \n",
       "4                                              Comedies   \n",
       "...                                                 ...   \n",
       "6229  TV Action & Adventure, TV Comedies, TV Sci-Fi ...   \n",
       "6230                                        TV Comedies   \n",
       "6231                                             Movies   \n",
       "6232           British TV Shows, TV Comedies, TV Dramas   \n",
       "6233                     Classic & Cult TV, TV Comedies   \n",
       "\n",
       "                                            description  years_to_now  \\\n",
       "0     Before planning an awesome wedding for his gra...             1   \n",
       "1     Jandino Asporaat riffs on the challenges of ra...             4   \n",
       "2     With the help of three human allies, the Autob...             7   \n",
       "3     When a prison ship crash unleashes hundreds of...             4   \n",
       "4     When nerdy high schooler Dani finally attracts...             3   \n",
       "...                                                 ...           ...   \n",
       "6229  This parody of first-person shooter games, mil...             5   \n",
       "6230  Marc Maron stars as Marc Maron, who interviews...             4   \n",
       "6231  Nursery rhymes and original music for children...             4   \n",
       "6232  Set during the Russian Revolution, this comic ...             7   \n",
       "6233  This hit sitcom follows the merry misadventure...            17   \n",
       "\n",
       "     new_date_added  \n",
       "0        2019-09-09  \n",
       "1        2016-09-09  \n",
       "2        2018-09-08  \n",
       "3        2018-09-08  \n",
       "4        2017-09-08  \n",
       "...             ...  \n",
       "6229            NaT  \n",
       "6230            NaT  \n",
       "6231            NaT  \n",
       "6232            NaT  \n",
       "6233            NaT  \n",
       "\n",
       "[6234 rows x 14 columns]"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from functools import partial\n",
    "\n",
    "# 利用partial固化指定参数\n",
    "func = partial(pd.to_datetime, format='%B %d, %Y', errors='coerce')\n",
    "\n",
    "netflix.eval('''\n",
    "             years_to_now = 2020 - release_year\n",
    "             new_date_added = @func(date_added.str.strip())''')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {
    "execution": {
     "iopub.execute_input": "2020-08-07T06:56:01.772937Z",
     "iopub.status.busy": "2020-08-07T06:56:01.772937Z",
     "iopub.status.idle": "2020-08-07T06:56:01.818814Z",
     "shell.execute_reply": "2020-08-07T06:56:01.818814Z",
     "shell.execute_reply.started": "2020-08-07T06:56:01.772937Z"
    }
   },
   "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>月度发行数量</th>\n",
       "      <th>月度发行数量排名</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>new_date_added</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2019-11-30</th>\n",
       "      <td>292</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-12-31</th>\n",
       "      <td>232</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-10-31</th>\n",
       "      <td>220</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-12-31</th>\n",
       "      <td>203</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-10-31</th>\n",
       "      <td>201</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010-08-31</th>\n",
       "      <td>0</td>\n",
       "      <td>119</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010-07-31</th>\n",
       "      <td>0</td>\n",
       "      <td>119</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010-05-31</th>\n",
       "      <td>0</td>\n",
       "      <td>119</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010-03-31</th>\n",
       "      <td>0</td>\n",
       "      <td>119</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-01-31</th>\n",
       "      <td>0</td>\n",
       "      <td>119</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>145 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                月度发行数量  月度发行数量排名\n",
       "new_date_added                  \n",
       "2019-11-30         292         1\n",
       "2019-12-31         232         2\n",
       "2019-10-31         220         3\n",
       "2018-12-31         203         4\n",
       "2018-10-31         201         5\n",
       "...                ...       ...\n",
       "2010-08-31           0       119\n",
       "2010-07-31           0       119\n",
       "2010-05-31           0       119\n",
       "2010-03-31           0       119\n",
       "2011-01-31           0       119\n",
       "\n",
       "[145 rows x 2 columns]"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "netflix.eval('''\n",
    "             years_to_now = 2020 - release_year\n",
    "             new_date_added = @func(date_added.str.strip())''') \\\n",
    "       .resample('M', on='new_date_added') \\\n",
    "       .agg({'new_date_added': 'count'}) \\\n",
    "       .rename(columns={'new_date_added': '月度发行数量'}) \\\n",
    "       .eval('''月度发行数量排名 = 月度发行数量.rank(ascending=False).astype('int')''') \\\n",
    "       .sort_values('月度发行数量排名')"
   ]
  }
 ],
 "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.7.7"
  },
  "widgets": {
   "application/vnd.jupyter.widget-state+json": {
    "state": {},
    "version_major": 2,
    "version_minor": 0
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}