excel_filmes_exibidos_brasil_2009_2017.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Análise de dados de filmes exibidos no Brasil de 2009 a 2017\n",
    "Com base nos dados da Ancine (http://oca.ancine.gov.br), vamos analisar os filmes exibidos no Brasil\n",
    "\n",
    "Arquivo -> 2120_0.xlsx"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Importando as bibliotecas\n",
    "import pandas as pd\n",
    "# Configurando o matplotlib\n",
    "%matplotlib inline"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Criando o DataFrame com base no arquivo Excel\n",
    "# Precisamos pular as 2 primeiras linhas\n",
    "# Precisamos desconsiderar as últimas 16 linhas\n",
    "df = pd.read_excel('2120_0.xlsx', skiprows=2, skipfooter=16)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Ano de exibição</th>\n",
       "      <th>Título da obra</th>\n",
       "      <th>Gênero</th>\n",
       "      <th>País(es) produtor(es) da obra</th>\n",
       "      <th>Nacionalidade da obra</th>\n",
       "      <th>Data de lançamento</th>\n",
       "      <th>Distribuidora</th>\n",
       "      <th>Origem da empresa distribuidora</th>\n",
       "      <th>Público no ano de exibição</th>\n",
       "      <th>Renda (R$) no ano de exibição</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2017</td>\n",
       "      <td>#Screamers</td>\n",
       "      <td>Ficção</td>\n",
       "      <td>Estados Unidos</td>\n",
       "      <td>Estrangeiros</td>\n",
       "      <td>2017-11-30 00:00:00</td>\n",
       "      <td>Cineart Filmes</td>\n",
       "      <td>Distribuição Nacional</td>\n",
       "      <td>714</td>\n",
       "      <td>9437.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2017</td>\n",
       "      <td>10 Centavos para o Número da Besta</td>\n",
       "      <td>Documentário</td>\n",
       "      <td>Brasil</td>\n",
       "      <td>Brasileiros</td>\n",
       "      <td>2017-11-28 00:00:00</td>\n",
       "      <td>Ponto de Equilíbrio</td>\n",
       "      <td>Distribuição Nacional</td>\n",
       "      <td>7</td>\n",
       "      <td>63.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2017</td>\n",
       "      <td>120 batimentos por minuto</td>\n",
       "      <td>Ficção</td>\n",
       "      <td>França</td>\n",
       "      <td>Estrangeiros</td>\n",
       "      <td>2018-01-04 00:00:00</td>\n",
       "      <td>Imovision</td>\n",
       "      <td>Distribuição Nacional</td>\n",
       "      <td>262</td>\n",
       "      <td>3791.63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2017</td>\n",
       "      <td>13 Minutos</td>\n",
       "      <td>Ficção</td>\n",
       "      <td>Alemanha</td>\n",
       "      <td>Estrangeiros</td>\n",
       "      <td>2016-11-03 00:00:00</td>\n",
       "      <td>Alphaville Filmes</td>\n",
       "      <td>Distribuição Nacional</td>\n",
       "      <td>620</td>\n",
       "      <td>6463.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2017</td>\n",
       "      <td>150 Miligramas</td>\n",
       "      <td>Ficção</td>\n",
       "      <td>França</td>\n",
       "      <td>Estrangeiros</td>\n",
       "      <td>2017-08-31 00:00:00</td>\n",
       "      <td>Califórnia</td>\n",
       "      <td>Distribuição Nacional</td>\n",
       "      <td>771</td>\n",
       "      <td>10508.71</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Ano de exibição                      Título da obra        Gênero  \\\n",
       "0             2017                          #Screamers        Ficção   \n",
       "1             2017  10 Centavos para o Número da Besta  Documentário   \n",
       "2             2017           120 batimentos por minuto        Ficção   \n",
       "3             2017                          13 Minutos        Ficção   \n",
       "4             2017                      150 Miligramas        Ficção   \n",
       "\n",
       "  País(es) produtor(es) da obra Nacionalidade da obra   Data de lançamento  \\\n",
       "0                Estados Unidos          Estrangeiros  2017-11-30 00:00:00   \n",
       "1                        Brasil           Brasileiros  2017-11-28 00:00:00   \n",
       "2                        França          Estrangeiros  2018-01-04 00:00:00   \n",
       "3                      Alemanha          Estrangeiros  2016-11-03 00:00:00   \n",
       "4                        França          Estrangeiros  2017-08-31 00:00:00   \n",
       "\n",
       "         Distribuidora Origem da empresa distribuidora  \\\n",
       "0       Cineart Filmes           Distribuição Nacional   \n",
       "1  Ponto de Equilíbrio           Distribuição Nacional   \n",
       "2           Imovision            Distribuição Nacional   \n",
       "3    Alphaville Filmes           Distribuição Nacional   \n",
       "4          Califórnia            Distribuição Nacional   \n",
       "\n",
       "   Público no ano de exibição  Renda (R$) no ano de exibição  \n",
       "0                         714                        9437.45  \n",
       "1                           7                          63.00  \n",
       "2                         262                        3791.63  \n",
       "3                         620                        6463.50  \n",
       "4                         771                       10508.71  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Exibindo as primeiras linhas\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Ano de exibição</th>\n",
       "      <th>Título da obra</th>\n",
       "      <th>Gênero</th>\n",
       "      <th>País(es) produtor(es) da obra</th>\n",
       "      <th>Nacionalidade da obra</th>\n",
       "      <th>Data de lançamento</th>\n",
       "      <th>Distribuidora</th>\n",
       "      <th>Origem da empresa distribuidora</th>\n",
       "      <th>Público no ano de exibição</th>\n",
       "      <th>Renda (R$) no ano de exibição</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>5686</th>\n",
       "      <td>2009</td>\n",
       "      <td>X-Men Origens: Wolverine</td>\n",
       "      <td>Ficção</td>\n",
       "      <td>Estados Unidos</td>\n",
       "      <td>Estrangeiros</td>\n",
       "      <td>2009-05-01 00:00:00</td>\n",
       "      <td>Fox</td>\n",
       "      <td>Distribuição Internacional</td>\n",
       "      <td>3199434</td>\n",
       "      <td>27352313.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5687</th>\n",
       "      <td>2009</td>\n",
       "      <td>Xuxa em o Mistério de Feiurinha</td>\n",
       "      <td>Ficção</td>\n",
       "      <td>Brasil</td>\n",
       "      <td>Brasileiros</td>\n",
       "      <td>2009-12-25 00:00:00</td>\n",
       "      <td>Playarte</td>\n",
       "      <td>Distribuição Nacional</td>\n",
       "      <td>250109</td>\n",
       "      <td>1766416.65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5688</th>\n",
       "      <td>2009</td>\n",
       "      <td>Xuxa em Sonho de Menina</td>\n",
       "      <td>Ficção</td>\n",
       "      <td>Brasil</td>\n",
       "      <td>Brasileiros</td>\n",
       "      <td>2007-12-21 00:00:00</td>\n",
       "      <td>Warner</td>\n",
       "      <td>Distribuição Internacional</td>\n",
       "      <td>8914</td>\n",
       "      <td>26880.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5689</th>\n",
       "      <td>2009</td>\n",
       "      <td>Xuxa Gêmeas</td>\n",
       "      <td>Ficção</td>\n",
       "      <td>Brasil</td>\n",
       "      <td>Brasileiros</td>\n",
       "      <td>2006-12-15 00:00:00</td>\n",
       "      <td>Fox</td>\n",
       "      <td>Distribuição Internacional</td>\n",
       "      <td>1671</td>\n",
       "      <td>5013.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5690</th>\n",
       "      <td>2009</td>\n",
       "      <td>Zico na Rede</td>\n",
       "      <td>Documentário</td>\n",
       "      <td>Brasil</td>\n",
       "      <td>Brasileiros</td>\n",
       "      <td>2009-07-03 00:00:00</td>\n",
       "      <td>Business Telecom</td>\n",
       "      <td>Distribuição Nacional</td>\n",
       "      <td>546</td>\n",
       "      <td>2529.50</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      Ano de exibição                   Título da obra        Gênero  \\\n",
       "5686             2009         X-Men Origens: Wolverine        Ficção   \n",
       "5687             2009  Xuxa em o Mistério de Feiurinha        Ficção   \n",
       "5688             2009          Xuxa em Sonho de Menina        Ficção   \n",
       "5689             2009                      Xuxa Gêmeas        Ficção   \n",
       "5690             2009                     Zico na Rede  Documentário   \n",
       "\n",
       "     País(es) produtor(es) da obra Nacionalidade da obra   Data de lançamento  \\\n",
       "5686                Estados Unidos          Estrangeiros  2009-05-01 00:00:00   \n",
       "5687                        Brasil           Brasileiros  2009-12-25 00:00:00   \n",
       "5688                        Brasil           Brasileiros  2007-12-21 00:00:00   \n",
       "5689                        Brasil           Brasileiros  2006-12-15 00:00:00   \n",
       "5690                        Brasil           Brasileiros  2009-07-03 00:00:00   \n",
       "\n",
       "         Distribuidora Origem da empresa distribuidora  \\\n",
       "5686               Fox      Distribuição Internacional   \n",
       "5687          Playarte           Distribuição Nacional   \n",
       "5688            Warner      Distribuição Internacional   \n",
       "5689               Fox      Distribuição Internacional   \n",
       "5690  Business Telecom           Distribuição Nacional   \n",
       "\n",
       "      Público no ano de exibição  Renda (R$) no ano de exibição  \n",
       "5686                     3199434                    27352313.00  \n",
       "5687                      250109                     1766416.65  \n",
       "5688                        8914                       26880.00  \n",
       "5689                        1671                        5013.00  \n",
       "5690                         546                        2529.50  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Exibindo as últimas linhas\n",
    "df.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Ano de exibição                      int64\n",
       "Título da obra                      object\n",
       "Gênero                              object\n",
       "País(es) produtor(es) da obra       object\n",
       "Nacionalidade da obra               object\n",
       "Data de lançamento                  object\n",
       "Distribuidora                       object\n",
       "Origem da empresa distribuidora     object\n",
       "Público no ano de exibição           int64\n",
       "Renda (R$) no ano de exibição      float64\n",
       "dtype: object"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Verificar os tipos das colunas\n",
    "df.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "ename": "TypeError",
     "evalue": "invalid string coercion to datetime",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mUnicodeEncodeError\u001b[0m                        Traceback (most recent call last)",
      "\u001b[1;32mpandas\\_libs\\tslib.pyx\u001b[0m in \u001b[0;36mpandas._libs.tslib.array_to_datetime\u001b[1;34m()\u001b[0m\n",
      "\u001b[1;32mpandas\\_libs\\tslibs\\np_datetime.pyx\u001b[0m in \u001b[0;36mpandas._libs.tslibs.np_datetime._string_to_dts\u001b[1;34m()\u001b[0m\n",
      "\u001b[1;31mUnicodeEncodeError\u001b[0m: 'ascii' codec can't encode character '\\xe7' in position 5: ordinal not in range(128)",
      "\nDuring handling of the above exception, another exception occurred:\n",
      "\u001b[1;31mValueError\u001b[0m                                Traceback (most recent call last)",
      "\u001b[1;32mpandas\\_libs\\tslib.pyx\u001b[0m in \u001b[0;36mpandas._libs.tslib.array_to_datetime\u001b[1;34m()\u001b[0m\n",
      "\u001b[1;32mpandas\\_libs\\tslibs\\parsing.pyx\u001b[0m in \u001b[0;36mpandas._libs.tslibs.parsing.parse_datetime_string\u001b[1;34m()\u001b[0m\n",
      "\u001b[1;32mD:\\Anaconda3\\lib\\site-packages\\dateutil\\parser\\_parser.py\u001b[0m in \u001b[0;36mparse\u001b[1;34m(timestr, parserinfo, **kwargs)\u001b[0m\n\u001b[0;32m   1355\u001b[0m     \u001b[1;32melse\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m-> 1356\u001b[1;33m         \u001b[1;32mreturn\u001b[0m \u001b[0mDEFAULTPARSER\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mparse\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mtimestr\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   1357\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mD:\\Anaconda3\\lib\\site-packages\\dateutil\\parser\\_parser.py\u001b[0m in \u001b[0;36mparse\u001b[1;34m(self, timestr, default, ignoretz, tzinfos, **kwargs)\u001b[0m\n\u001b[0;32m    647\u001b[0m         \u001b[1;32mif\u001b[0m \u001b[0mres\u001b[0m \u001b[1;32mis\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[1;32m--> 648\u001b[1;33m             \u001b[1;32mraise\u001b[0m \u001b[0mValueError\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m\"Unknown string format:\"\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mtimestr\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    649\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;31mValueError\u001b[0m: ('Unknown string format:', 'Relançamento')",
      "\nDuring handling of the above exception, another exception occurred:\n",
      "\u001b[1;31mTypeError\u001b[0m                                 Traceback (most recent call last)",
      "\u001b[1;32m<ipython-input-12-4a3bd99d0191>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m\u001b[0m\n\u001b[0;32m      1\u001b[0m \u001b[1;31m# Converter a coluna 'Data de lançamento' de object para data\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m----> 2\u001b[1;33m \u001b[0mdt\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;34m'Data de lançamento'\u001b[0m\u001b[1;33m]\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mpd\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mto_datetime\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mdf\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;34m'Data de lançamento'\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[1;32mD:\\Anaconda3\\lib\\site-packages\\pandas\\core\\tools\\datetimes.py\u001b[0m in \u001b[0;36mto_datetime\u001b[1;34m(arg, errors, dayfirst, yearfirst, utc, box, format, exact, unit, infer_datetime_format, origin, cache)\u001b[0m\n\u001b[0;32m    449\u001b[0m         \u001b[1;32melse\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    450\u001b[0m             \u001b[1;32mfrom\u001b[0m \u001b[0mpandas\u001b[0m \u001b[1;32mimport\u001b[0m \u001b[0mSeries\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 451\u001b[1;33m             \u001b[0mvalues\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0m_convert_listlike\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0marg\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_values\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;32mTrue\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mformat\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    452\u001b[0m             \u001b[0mresult\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mSeries\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mvalues\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mindex\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0marg\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mindex\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mname\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0marg\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mname\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    453\u001b[0m     \u001b[1;32melif\u001b[0m \u001b[0misinstance\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0marg\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;33m(\u001b[0m\u001b[0mABCDataFrame\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mMutableMapping\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[1;32mD:\\Anaconda3\\lib\\site-packages\\pandas\\core\\tools\\datetimes.py\u001b[0m in \u001b[0;36m_convert_listlike\u001b[1;34m(arg, box, format, name, tz)\u001b[0m\n\u001b[0;32m    366\u001b[0m                     \u001b[0mdayfirst\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mdayfirst\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    367\u001b[0m                     \u001b[0myearfirst\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0myearfirst\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 368\u001b[1;33m                     \u001b[0mrequire_iso8601\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mrequire_iso8601\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    369\u001b[0m                 )\n\u001b[0;32m    370\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mpandas\\_libs\\tslib.pyx\u001b[0m in \u001b[0;36mpandas._libs.tslib.array_to_datetime\u001b[1;34m()\u001b[0m\n",
      "\u001b[1;32mpandas\\_libs\\tslib.pyx\u001b[0m in \u001b[0;36mpandas._libs.tslib.array_to_datetime\u001b[1;34m()\u001b[0m\n",
      "\u001b[1;32mpandas\\_libs\\tslib.pyx\u001b[0m in \u001b[0;36mpandas._libs.tslib.array_to_datetime\u001b[1;34m()\u001b[0m\n",
      "\u001b[1;31mTypeError\u001b[0m: invalid string coercion to datetime"
     ]
    }
   ],
   "source": [
    "# Converter a coluna 'Data de lançamento' de object para data\n",
    "dt['Data de lançamento'] = pd.to_datetime(df['Data de lançamento'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Relançamento           175\n",
       "2015-12-03 00:00:00     33\n",
       "2012-12-21 00:00:00     33\n",
       "2013-11-29 00:00:00     29\n",
       "2012-11-02 00:00:00     27\n",
       "2015-11-12 00:00:00     25\n",
       "2015-11-19 00:00:00     25\n",
       "2013-11-01 00:00:00     23\n",
       "2013-12-06 00:00:00     23\n",
       "2013-10-11 00:00:00     23\n",
       "2016-11-17 00:00:00     23\n",
       "2014-11-06 00:00:00     21\n",
       "2011-11-11 00:00:00     21\n",
       "2011-12-02 00:00:00     21\n",
       "2013-09-13 00:00:00     21\n",
       "2009-12-11 00:00:00     20\n",
       "2011-09-30 00:00:00     19\n",
       "2016-11-10 00:00:00     19\n",
       "2011-12-09 00:00:00     19\n",
       "2013-12-20 00:00:00     19\n",
       "2014-06-19 00:00:00     19\n",
       "2013-09-06 00:00:00     18\n",
       "2016-12-01 00:00:00     18\n",
       "2015-12-10 00:00:00     18\n",
       "2015-11-26 00:00:00     18\n",
       "2011-11-25 00:00:00     18\n",
       "2014-12-04 00:00:00     18\n",
       "2015-08-20 00:00:00     18\n",
       "2016-11-24 00:00:00     18\n",
       "2012-10-12 00:00:00     18\n",
       "                      ... \n",
       "2018-03-15 00:00:00      1\n",
       "2014-07-26 00:00:00      1\n",
       "2017-12-02 00:00:00      1\n",
       "2017-12-25 00:00:00      1\n",
       "2008-02-15 00:00:00      1\n",
       "2004-11-06 00:00:00      1\n",
       "2018-02-22 00:00:00      1\n",
       "2015-09-29 00:00:00      1\n",
       "2010-05-08 00:00:00      1\n",
       "2014-01-18 00:00:00      1\n",
       "2009-10-03 00:00:00      1\n",
       "2018-04-12 00:00:00      1\n",
       "2008-10-18 00:00:00      1\n",
       "2015-09-12 00:00:00      1\n",
       "2007-11-02 00:00:00      1\n",
       "2009-03-14 00:00:00      1\n",
       "2006-12-15 00:00:00      1\n",
       "2005-10-07 00:00:00      1\n",
       "2006-09-29 00:00:00      1\n",
       "1998-10-30 00:00:00      1\n",
       "2018-01-18 00:00:00      1\n",
       "2015-01-01 00:00:00      1\n",
       "2013-06-15 00:00:00      1\n",
       "2006-08-11 00:00:00      1\n",
       "2011-02-05 00:00:00      1\n",
       "2009-10-28 00:00:00      1\n",
       "2011-07-02 00:00:00      1\n",
       "2011-08-13 00:00:00      1\n",
       "2014-10-01 00:00:00      1\n",
       "2006-10-13 00:00:00      1\n",
       "Name: Data de lançamento, Length: 759, dtype: int64"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Vamos tentar identificar o problema da coluna 'Data de lançamento'\n",
    "df['Data de lançamento'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Ano de exibição</th>\n",
       "      <th>Título da obra</th>\n",
       "      <th>Gênero</th>\n",
       "      <th>País(es) produtor(es) da obra</th>\n",
       "      <th>Nacionalidade da obra</th>\n",
       "      <th>Data de lançamento</th>\n",
       "      <th>Distribuidora</th>\n",
       "      <th>Origem da empresa distribuidora</th>\n",
       "      <th>Público no ano de exibição</th>\n",
       "      <th>Renda (R$) no ano de exibição</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2017</td>\n",
       "      <td>8½</td>\n",
       "      <td>Ficção</td>\n",
       "      <td>França, Itália</td>\n",
       "      <td>Estrangeiros</td>\n",
       "      <td>Relançamento</td>\n",
       "      <td>F. J. Cines</td>\n",
       "      <td>Distribuição Nacional</td>\n",
       "      <td>29</td>\n",
       "      <td>196.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2017</td>\n",
       "      <td>A bela da tarde</td>\n",
       "      <td>Ficção</td>\n",
       "      <td>França, Itália</td>\n",
       "      <td>Estrangeiros</td>\n",
       "      <td>Relançamento</td>\n",
       "      <td>Zeta Filmes</td>\n",
       "      <td>Distribuição Nacional</td>\n",
       "      <td>3011</td>\n",
       "      <td>42839.31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>2017</td>\n",
       "      <td>A História sem Fim</td>\n",
       "      <td>Ficção</td>\n",
       "      <td>Alemanha, Estados Unidos</td>\n",
       "      <td>Estrangeiros</td>\n",
       "      <td>Relançamento</td>\n",
       "      <td>F. J. Cines</td>\n",
       "      <td>Distribuição Nacional</td>\n",
       "      <td>797</td>\n",
       "      <td>6969.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>2017</td>\n",
       "      <td>A primeira noite de um homem</td>\n",
       "      <td>Ficção</td>\n",
       "      <td>Estados Unidos</td>\n",
       "      <td>Estrangeiros</td>\n",
       "      <td>Relançamento</td>\n",
       "      <td>Zeta Filmes</td>\n",
       "      <td>Distribuição Nacional</td>\n",
       "      <td>12</td>\n",
       "      <td>96.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>2017</td>\n",
       "      <td>Ballet Bolshoi: A bela adormecida</td>\n",
       "      <td>Vídeomusical</td>\n",
       "      <td>Inglaterra</td>\n",
       "      <td>Estrangeiros</td>\n",
       "      <td>Relançamento</td>\n",
       "      <td>UCI</td>\n",
       "      <td>Distribuição Nacional</td>\n",
       "      <td>1504</td>\n",
       "      <td>41391.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     Ano de exibição                     Título da obra        Gênero  \\\n",
       "7               2017                                 8½        Ficção   \n",
       "11              2017                    A bela da tarde        Ficção   \n",
       "36              2017                 A História sem Fim        Ficção   \n",
       "53              2017       A primeira noite de um homem        Ficção   \n",
       "128             2017  Ballet Bolshoi: A bela adormecida  Vídeomusical   \n",
       "\n",
       "    País(es) produtor(es) da obra Nacionalidade da obra Data de lançamento  \\\n",
       "7                  França, Itália          Estrangeiros       Relançamento   \n",
       "11                 França, Itália          Estrangeiros       Relançamento   \n",
       "36       Alemanha, Estados Unidos          Estrangeiros       Relançamento   \n",
       "53                 Estados Unidos          Estrangeiros       Relançamento   \n",
       "128                    Inglaterra          Estrangeiros       Relançamento   \n",
       "\n",
       "    Distribuidora Origem da empresa distribuidora  Público no ano de exibição  \\\n",
       "7     F. J. Cines           Distribuição Nacional                          29   \n",
       "11    Zeta Filmes           Distribuição Nacional                        3011   \n",
       "36    F. J. Cines           Distribuição Nacional                         797   \n",
       "53    Zeta Filmes           Distribuição Nacional                          12   \n",
       "128           UCI           Distribuição Nacional                        1504   \n",
       "\n",
       "     Renda (R$) no ano de exibição  \n",
       "7                           196.00  \n",
       "11                        42839.31  \n",
       "36                         6969.00  \n",
       "53                           96.00  \n",
       "128                       41391.00  "
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    " # Exibir alguns filmes que estão com data de lançamento igual à Relançamento\n",
    "df[df['Data de lançamento'] == 'Relançamento'].head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Decisão sobre dados incorretos/faltantes/divergentes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Criar novo DataFrame sem os relançamentos\n",
    "df_novo = df[df['Data de lançamento'] != 'Relançamento'].copy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(5516, 10)"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Exibe o tamanho do DataFrame (linhas, colunas)\n",
    "df_novo.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Ano de exibição                      int64\n",
       "Título da obra                      object\n",
       "Gênero                              object\n",
       "País(es) produtor(es) da obra       object\n",
       "Nacionalidade da obra               object\n",
       "Data de lançamento                  object\n",
       "Distribuidora                       object\n",
       "Origem da empresa distribuidora     object\n",
       "Público no ano de exibição           int64\n",
       "Renda (R$) no ano de exibição      float64\n",
       "dtype: object"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Vamos verificar os tipos das colunas\n",
    "df_novo.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Converter a coluna 'Data de lançamento' de object para data\n",
    "df_novo['Data de lançamento'] = pd.to_datetime(df_novo['Data de lançamento'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Ano de exibição                             int64\n",
       "Título da obra                             object\n",
       "Gênero                                     object\n",
       "País(es) produtor(es) da obra              object\n",
       "Nacionalidade da obra                      object\n",
       "Data de lançamento                 datetime64[ns]\n",
       "Distribuidora                              object\n",
       "Origem da empresa distribuidora            object\n",
       "Público no ano de exibição                  int64\n",
       "Renda (R$) no ano de exibição             float64\n",
       "dtype: object"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Vamos verificar os tipos das colunas\n",
    "df_novo.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2013    669\n",
       "2015    646\n",
       "2014    619\n",
       "2016    613\n",
       "2011    553\n",
       "2012    539\n",
       "2009    503\n",
       "2017    487\n",
       "2010    475\n",
       "2008    225\n",
       "2007     61\n",
       "2006     49\n",
       "2005     29\n",
       "2018     17\n",
       "2004     10\n",
       "2002      6\n",
       "2001      5\n",
       "2003      4\n",
       "1999      3\n",
       "2000      2\n",
       "1998      1\n",
       "Name: Data de lançamento, dtype: int64"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Quais os anos tiverem mais filmes lançados?\n",
    "df_novo['Data de lançamento'].dt.year.value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x20ceb182320>"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXoAAAELCAYAAADX3k30AAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDMuMC4yLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvOIA7rQAAG0xJREFUeJzt3X+0XWV95/H3hyQgPyoJcAmYBIMaBWeQX3dhWrQCEYcfDmG1/GwLkWJjLVZdOtS0s9aIM60TOlWEVQcnEiEZf/CrChmgChOUYllBAoQECJiAQK4JSRQISnAq8p0/nueWw829Z+9zz7n3nDz9vNba6+zz7Oe7n2fve+737POcvfdRRGBmZuXapdsdMDOzseVEb2ZWOCd6M7PCOdGbmRXOid7MrHBO9GZmhatM9JLeIWlVw/SipE9K2kfSHZLW5ccpub4kXSFpvaTVko4a+80wM7ORVCb6iHg8Io6IiCOAo4HtwHeABcDyiJgFLM/PAU4GZuVpPnDlWHTczMzqaXXoZg7wREQ8DcwFluTyJcDpeX4usDSSFcBkSQd2pLdmZtayiS3WPwf4Vp6fGhGbACJik6T9c/k0YENDzEAu2zTSSvfbb7+YOXNmi10xM/u37f777/9ZRPRV1aud6CXtCpwG/GVV1WHKdrjPgqT5pKEdDjroIFauXFm3K2ZmBkh6uk69VoZuTgYeiIjN+fnmwSGZ/Lgllw8AMxripgMbh64sIhZFRH9E9Pf1Vb4hmZnZKLWS6M/ltWEbgGXAvDw/D7i5ofz8fPbNbGDb4BCPmZmNv1pDN5L2AE4EPtJQvBC4XtKFwDPAmbn8NuAUYD3pDJ0LOtZbMzNrWa1EHxHbgX2HlP2cdBbO0LoBXNSR3pmZWdt8ZayZWeGc6M3MCudEb2ZWOCd6M7PCtXpl7LiYueDWpsufWnjqOPXEzGzn5yN6M7PCOdGbmRXOid7MrHBO9GZmhXOiNzMrnBO9mVnhevL0yrZdsnfF8m3j0w8zsx7gI3ozs8I50ZuZFc6J3syscE70ZmaFc6I3MyucE72ZWeGc6M3MCudEb2ZWuDIvmGrTYUsOa7p8zbw149QTM7P2+YjezKxwtY7oJU0GrgL+PRDAHwOPA9cBM4GngLMi4nlJAi4HTgG2Ax+KiAc63vMetvaQQ5suP/SxtePUEzOz+kf0lwPfjYhDgMOBtcACYHlEzAKW5+cAJwOz8jQfuLKjPTYzs5ZUJnpJbwR+F1gMEBH/EhEvAHOBJbnaEuD0PD8XWBrJCmCypAM73nMzM6ulzhH9W4CtwNWSHpR0laQ9gakRsQkgP+6f608DNjTED+QyMzPrgjqJfiJwFHBlRBwJvMRrwzTD0TBlsUMlab6klZJWbt26tVZnzcysdXUS/QAwEBH35uc3khL/5sEhmfy4paH+jIb46cDGoSuNiEUR0R8R/X19faPtv5mZVahM9BHxLLBB0jty0RzgUWAZMC+XzQNuzvPLgPOVzAa2DQ7xmJnZ+Kt7wdSfA9+QtCvwJHAB6U3iekkXAs8AZ+a6t5FOrVxPOr3ygo722MzMWlIr0UfEKqB/mEVzhqkbwEVt9svMzDrEV8aamRXOid7MrHBO9GZmhXOiNzMrnBO9mVnhnOjNzArnRG9mVjgnejOzwjnRm5kVzr8Z24O+/Kd3Nl1+0VdOGKeemFkJfERvZlY4J3ozs8I50ZuZFc5j9AX6wtkfbLr809fdMk49MbNe4CN6M7PCOdGbmRXOid7MrHBO9GZmhXOiNzMrnBO9mVnhnOjNzArnRG9mVrhaiV7SU5LWSFolaWUu20fSHZLW5ccpuVySrpC0XtJqSUeN5QaYmVlzrRzRHx8RR0REf36+AFgeEbOA5fk5wMnArDzNB67sVGfNzKx17QzdzAWW5PklwOkN5UsjWQFMlnRgG+2YmVkb6t7rJoDbJQXwvyJiETA1IjYBRMQmSfvnutOADQ2xA7lsU4f6bGNsYMHdTZdPX/jeceqJmXVC3UR/bERszMn8DkmPNamrYcpih0rSfNLQDgcddFDNbpiZWatqDd1ExMb8uAX4DnAMsHlwSCY/bsnVB4AZDeHTgY3DrHNRRPRHRH9fX9/ot8DMzJqqTPSS9pT0W4PzwAeAh4FlwLxcbR5wc55fBpyfz76ZDWwbHOIxM7PxV2foZirwHUmD9b8ZEd+VdB9wvaQLgWeAM3P924BTgPXAduCCjvfazMxqq0z0EfEkcPgw5T8H5gxTHsBFHemd7ZQuueSStpabWWf5ylgzs8I50ZuZFc6/GWs9Z/mdb226fM4JT4xTT8zK4CN6M7PCOdGbmRXOid7MrHBO9GZmhXOiNzMrnBO9mVnhnOjNzArnRG9mVjgnejOzwjnRm5kVzonezKxwTvRmZoVzojczK5wTvZlZ4ZzozcwK50RvZlY4J3ozs8I50ZuZFc6J3syscLUTvaQJkh6UdEt+frCkeyWtk3SdpF1z+W75+fq8fObYdN3MzOpo5Yj+E8DahueXApdFxCzgeeDCXH4h8HxEvA24LNczM7MuqZXoJU0HTgWuys8FnADcmKssAU7P83Pzc/LyObm+mZl1Qd0j+i8BfwG8mp/vC7wQEa/k5wPAtDw/DdgAkJdvy/VfR9J8SSslrdy6desou29mZlUqE72kDwJbIuL+xuJhqkaNZa8VRCyKiP6I6O/r66vVWTMza93EGnWOBU6TdArwBuCNpCP8yZIm5qP26cDGXH8AmAEMSJoI7A081/Gem5lZLZVH9BHxlxExPSJmAucAd0bEHwLfB87I1eYBN+f5Zfk5efmdEbHDEb2ZmY2Pds6j/wzwKUnrSWPwi3P5YmDfXP4pYEF7XTQzs3bUGbr5VxHxA+AHef5J4Jhh6vwKOLMDfTMzsw7wlbFmZoVzojczK5wTvZlZ4ZzozcwK50RvZlY4J3ozs8I50ZuZFc6J3syscE70ZmaFc6I3MyucE72ZWeGc6M3MCudEb2ZWOCd6M7PCOdGbmRXOid7MrHBO9GZmhXOiNzMrnBO9mVnhnOjNzArnRG9mVjgnejOzwlUmeklvkPQjSQ9JekTS53L5wZLulbRO0nWSds3lu+Xn6/PymWO7CWZm1kydI/r/B5wQEYcDRwAnSZoNXApcFhGzgOeBC3P9C4HnI+JtwGW5npmZdUlloo/kl/nppDwFcAJwYy5fApye5+fm5+TlcySpYz02M7OW1BqjlzRB0ipgC3AH8ATwQkS8kqsMANPy/DRgA0Bevg3Yd5h1zpe0UtLKrVu3trcVZmY2olqJPiJ+ExFHANOBY4BDh6uWH4c7eo8dCiIWRUR/RPT39fXV7a+ZmbWopbNuIuIF4AfAbGCypIl50XRgY54fAGYA5OV7A891orNmZta6Omfd9EmanOd3B94PrAW+D5yRq80Dbs7zy/Jz8vI7I2KHI3ozMxsfE6urcCCwRNIE0hvD9RFxi6RHgWsl/TXwILA4118M/G9J60lH8ueMQb/NzKymykQfEauBI4cpf5I0Xj+0/FfAmR3pnZmZtc1XxpqZFc6J3syscE70ZmaFc6I3MyucE72ZWeGc6M3MCudEb2ZWOCd6M7PCOdGbmRXOid7MrHBO9GZmhXOiNzMrnBO9mVnhnOjNzArnRG9mVjgnejOzwjnRm5kVzonezKxwdX4z1myncsD3VzVd/uzxR4xTT8x6g4/ozcwK50RvZlY4J3ozs8JVJnpJMyR9X9JaSY9I+kQu30fSHZLW5ccpuVySrpC0XtJqSUeN9UaYmdnI6hzRvwJ8OiIOBWYDF0l6J7AAWB4Rs4Dl+TnAycCsPM0Hrux4r83MrLbKRB8RmyLigTz/C2AtMA2YCyzJ1ZYAp+f5ucDSSFYAkyUd2PGem5lZLS2N0UuaCRwJ3AtMjYhNkN4MgP1ztWnAhoawgVw2dF3zJa2UtHLr1q2t99zMzGqpnegl7QX8A/DJiHixWdVhymKHgohFEdEfEf19fX11u2FmZi2qleglTSIl+W9ExLdz8ebBIZn8uCWXDwAzGsKnAxs7010zM2tVnbNuBCwG1kbEFxsWLQPm5fl5wM0N5efns29mA9sGh3jMzGz81bkFwrHAecAaSYPXlv8VsBC4XtKFwDPAmXnZbcApwHpgO3BBR3tsZmYtqUz0EfFDhh93B5gzTP0ALmqzX2Zm1iG+MtbMrHBO9GZmhXOiNzMrnBO9mVnhnOjNzArnRG9mVjgnejOzwjnRm5kVzonezKxwTvRmZoVzojczK5wTvZlZ4ZzozcwK50RvZlY4J3ozs8I50ZuZFc6J3syscE70ZmaFc6I3MyucE72ZWeGc6M3MCudEb2ZWuMpEL+lrkrZIerihbB9Jd0halx+n5HJJukLSekmrJR01lp03M7NqdY7orwFOGlK2AFgeEbOA5fk5wMnArDzNB67sTDfNzGy0KhN9RPwT8NyQ4rnAkjy/BDi9oXxpJCuAyZIO7FRnzcysdaMdo58aEZsA8uP+uXwasKGh3kAu24Gk+ZJWSlq5devWUXbDzMyqdPrLWA1TFsNVjIhFEdEfEf19fX0d7oaZmQ0abaLfPDgkkx+35PIBYEZDvenAxtF3z8zM2jXaRL8MmJfn5wE3N5Sfn8++mQ1sGxziMTOz7phYVUHSt4DjgP0kDQCfBRYC10u6EHgGODNXvw04BVgPbAcuGIM+m5lZCyoTfUScO8KiOcPUDeCidjtlZmad4ytjzcwK50RvZlY4J3ozs8I50ZuZFc6J3syscE70ZmaFqzy90uzfkpkLbm26/KmFp45TT8w6x0f0ZmaFc6I3MyucE72ZWeE8Rm/WQR7jt17kI3ozs8I50ZuZFc6J3syscE70ZmaFc6I3Myucz7ox6yWX7F2xfNv49MOK4iN6M7PCOdGbmRXOid7MrHAeozcryGFLDmu6fM28NePUE+slPqI3MyvcmBzRSzoJuByYAFwVEQvHoh0z66y1hxzadPmhj60dp55YJ3U80UuaAHwZOBEYAO6TtCwiHu10W2bWW778p3c2XX7RV04Yp55Yo7E4oj8GWB8RTwJIuhaYCzjRm1lTXzj7g02Xf/q6W5ouH1hwd9Pl0xe+t+nySy65pK3lvUoR0dkVSmcAJ0XEh/Pz84B3R8THhtSbD8zPT98BPN5ktfsBP2ujW453/Gjjd+a+O778+DdHRF/VSsbiiF7DlO3wbhIRi4BFtVYorYyI/lF3yPGOH2X8ztx3xzt+0FicdTMAzGh4Ph3YOAbtmJlZDWOR6O8DZkk6WNKuwDnAsjFox8zMauj40E1EvCLpY8D3SKdXfi0iHmlztbWGeBzv+DGI35n77njHA2PwZayZmfUWXxlrZlY4J3ozs8I50ZuZFc6J3syscD15m2JJxwAREfdJeidwEvBYRNzWpf4sjYjzu9H2eJO0F2l/zwBeAdYBt0fEq+PU/iGkW2ZMI11otxFYFhG17qYl6XeBzRHxuKT3ALOBtRFxa43Y00jb+qtR9v0gYEtE/EqSgA8BR5Fu//HViHilxfUdDBwJPBoRj9WoP3g688aI+L+S/gD4HWAtsCgift3SBqV1fj4i/qqF+m8E+iLiiSHl74qI1a223xB/YkTcUaPeAQAR8aykPuC9wOMdOPOvFkl7k/5/Gl+/34uIF8aj/RH71Wtn3Uj6LHAy6U3oDuDdwA+A95N22N+0uL73kO6/83BE3F6j/tBz/gUcD9wJEBGnVcS/m5RYXpS0O7CA1/7ZPx8Ro/7RT0kXRMTVNeodQnqh3RsRv2woPykivtsk7izgYuAh0jbfQ/rUdxjwhxHR9Gbmkj4OfCciNtTZnmHiPwOcC1xLuvAO0gV35wDXVt0FVdKXSH/riaTTe+cA/wi8D3gwIi6uiH8ZeCnHfIv0evtNC/1/GDgmIrZLuhR4K3ATcAJARPxxRfxNEXF6np8LfIn02v8d4L9HxDUV8d8gbfsewAvAXsC3SftBETGvIv6KoUXAecDS3P+PV8Sflfu8BZgEfCgi7svLHoiIo5rFV6z7mYg4qKLOR0j/bwIuJb3RPgIcC/xtRCwebfs1+3g+8FngduCnuXg66QaPn4uIpWPZflMR0VMTsIZ0/v0ewIvAG3P57sDqGvE/apj/E2AVaef/M7CgRvwDwNeB40gJ4jhgU55/X434R4CJeX4R6YX/ntyHb7e5b56pUefjpPsG3QQ8Bcxt3LaK2NXAHnl+P1KiA3gXcE+NtreRjmDuBv6MdGTXyvb9GJg0TPmuwLqa+175tfN8w7ZMIr3RV8U/CEzJr5vlwGbgK3X+7jn+0Yb5+4FdGp4/VKf9hvl7gIMb/hZ14lfnx4m57xPyc9X83xnIr/3zgXl52jo4XyN+FXBgnj8GeAz4vaHb1iR+2QjT/wFeqhG/Jv/t9wV+CRyQy6cAq2r+DY8H/h64GfgHYCHwtpqxjwOThymfAvy4Rvw+wH8BPpz/Zv8ZuAX4H8CUOn0YaerFoZtXIh1FbZf0RES8CBARL0uqM3wwqWF+PnBiRGyV9HfACtIfrpl+4BOknXxxRKyS9HJE3FWz/7vEax/R++O1o5gfSlpVFSxppI+3AqbWaP9PgKMj4peSZgI3SpoZEZcz/H2Ihrbxcp5/CdgfICJW54/kVZ4EjiZ9+job+Jyk+0lHx9+OiF9UxL8KvAl4ekj5gXlZlYiIaHidDH5cfZV630dFRDwPfBX4ah4GOAtYKGl6RMxoHs4GSSdExJ2kN9kZwNOS9q3RdmN/IR0s/CR36mc1X/u75OGbPUkJb2/gOWA3Xv9/MZJDgf9GGnq4OCJ+KumzEbGkZv8nRMSm3OcfSToeuEXSdIa539Uw3gv8ESlJNxLpjaPKryNiO6/ljmdzX56XVNm+pIWk/7HlwAHAT4AngBvyENYNVatg+O18ler/PUhvsmtI/0N/lOcvJX0iuIY0pDkqvZjo/0XSHvkPdvRgYR77qvtin0L6x1ZEbAWIiJckVY6RRhqLvkzSDflxM63tp4cbhlgektQfESslvR2oM0Y6FfgPpCPSRiId5VWZEHm4JiKeknQcKdm/meoX223AdyXdRRo+uwFA0j41YnOT8Srpo+vtkibl9ZwL/B1QdZe9TwLLJa0DBod/DgLeBnxsxKjX3CrpbuANwFXA9ZJWkD6N/VON+NdtY04UVwBX5P1X5cPAUkmXkD7drJI0+CnhUzXiD5f0Yu7HbpIOiDTWvCvpU26VxaSj6AmkA5UbJD1J+p7i2qrg/Eb8SUlHA1+XdCutnbDxC0lvjTw+HxGb8uvvJuDf1YhfAWwf7qBKUrO72w56VdKkSN9FnNoQ+wbqbcepEXFYjrkWuCsiLpZ0I+lTalWi/xvgAUm38/rX74mkN9Aqb4qIU/L3OwMRcVwuv7vOQWJT7XwcGIsJ2G2E8v2Aw2rEP0U6svxJfhz8+LYXNT++DVnfqaSx9br19ya9+z4B3EtK7k8CdwGH14hfDLxnhGXfrBF/J3DEkLKJpHHW39SIPwX4T6RPQoNlu4z0dxkSO+LHc2D3mvtvF1Ji+n3gjDw/oYX9/9vA7Dz/1rwtZ9EwjNIk9rh2X795PYeSjr5+n/QdU2XbFeubDPx2zbpvIiWMwbgzSN8btNqmgIuAr7cQczgwa5jySaTveNretxXtH8TwQ3/TgPfXiH8I2KdhXSsalj1Ssw9TSN8pfTq/9s6h5rALaeh0Sm57GzAzl+9Lw7DgaKae+zK2GUl7RcOXiy3G7gFMjfxxeKzbl/RbwFtISXYgIjaPtt1W5I/Jr0T+2Dpk2bER8c811jGVhrMG6vZd0tsj4set9rnmulvZ96PqfynxI6zT+6867mzgb0lj7YcAH42IW/PZO5dHxB+Mcfvnkr7Tg/Qd10fzOt5J+jJ31Pe92dkSfeU37xXxo36j6JH2xzRe0hGkLx/35vVnDbwA/FlEPDBWbdeIr3PWRVv974H4I4ErR4j/aEQ82Cy+Yt3d3n+V/a/Y/jFvP69jH9IB2vpo8ZTIIe0PkD4VtfT/o/RTrIp0c8iJwBHATyN/9zFaPTdGL2mksUyRhl/a8SjpY1HPtt/l+GuAj0TEvY2FkmYDV5M+mo9V253Y99fQXv+7HX91k/hrquJ7fP9dUyO+2faPR/tExHOS3gIcn7/TWxc1rmGo0X6t/5+I+I2kfkn/eh1Lu0keejDRA58nnU403BenlV+odODF3tX2uxy/59AXKUBErJC05xi3DW3ue9rsfwHx3n/tvX7fB3yBdAR+NOmU7CmSfg2cF9XXh3S7/RH1YqJ/ALgpIu4fukDSh2vEt/ti73b73Yz/x3ymxVJeO2tgBum86hEvtOpQ29D+vm+3/zt7vPdfe/FfAj4Q6XTsg4EvRsSxkk4knSTxgR5vf0Q9N0Yv6R3Ac5FPixyybGrVFxuS7gH+fIQX+4aoOBe6B9rvdvzJvHYLApHGGpdFjdtPdHvft9v/nT3e+6/t/bc6It6V5ycA90W+DkbSIxFReYpot9sfcd29lujb1YkXezfb73Z8O7q9783aIelrpLNclpOS9U8j4lNKZ+w9EBGH7LTtxxif29rqRPrGeiHpwo+f52ltLtvh8uLS2u+Rfb92Z9z37fa/oHjvv9HFTyKd1vj3pCvMB28hsTvw5l5vv9nUi7cpvp50VehxEbFvROxLuv/E81RfmYakvSUtlPSYpJ/naW0um9zr7Xc5fnDbjx+y7S+Mx7bT5r5vt/8FxXv/jSI+In4dEf8zIj4WEV+NfEO7iHg5IobelqMX22+68p6aSLcUbXlZQ53vAZ8hXxGbyw7IZXfsBO13Lb4Htr3d9h3v+Hbi9wL+K/Aw6crUraTbMnyoKrYX2m829eIR/dOS/kLp6jIgje8q3cK2zulFMyPi0mi4MjQino2IS6l3Dnq32+9mfLe3vd32He/4duK/QbpdyUnA50j3OTqPdE7953eC9kfUi4n+bNK9He6S9Lyk50j35N6HdM+SKu3u7G633834bm97u+073vHtxM+MiGsiYiAivgicFhHrgAuA39sJ2h9Zux8JxmIi3Wfi/cBeQ8pPqhE7hXRrz8dI42XPkb4QuZR8w6Jebr8H4nfafe94x7f5+r2HfENB4D+Sf48hP68ceumF9kdcdzvBYzHRxg9ndGhnd7X9bsZ3e9vbbd/xjm8z/l3Aj0hfnv4QeHsu7wM+3uvtN113O8FjMZFutr9Xnp8JrAQ+kZ/X+ZWadnd2t9vvWnwPbHu77Tve8aOOr1j3Bb3efrOpF2+B0M4PZ0B7v7DUC+13M77b295u+453fDvxzXyOdGOyXm5/RL34ZeyzSrf7BCDvuA+Sf3ikRvzrdjbpN19PlvRF6u3sbrffzfhub3u77Tve8aOOl7R6hGkN9X7Gs9vtj6ydjwNjMZHu33zACMuOrRHf7i8sdbv9rsX3wLa3277jHd9O/GbS/d/fPGSaSfoBkZ5uv9lU4r1u2v6FpW623+34dnR735u1Q9Ji4OqI+OEwy74ZNX9hqhfbLy7Rm5nZ6/XiGL2ZmXWQE72ZWeGc6M3MCudEb2ZWuP8PjKVXoAqJae0AAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "# Plotar gráfico com os lançamentos por ano\n",
    "df_novo['Data de lançamento'].dt.year.value_counts().plot.bar()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Ano de exibição</th>\n",
       "      <th>Título da obra</th>\n",
       "      <th>Gênero</th>\n",
       "      <th>País(es) produtor(es) da obra</th>\n",
       "      <th>Nacionalidade da obra</th>\n",
       "      <th>Data de lançamento</th>\n",
       "      <th>Distribuidora</th>\n",
       "      <th>Origem da empresa distribuidora</th>\n",
       "      <th>Público no ano de exibição</th>\n",
       "      <th>Renda (R$) no ano de exibição</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2249</th>\n",
       "      <td>2015</td>\n",
       "      <td>Vingadores: A Era de Ultron</td>\n",
       "      <td>Ficção</td>\n",
       "      <td>Estados Unidos</td>\n",
       "      <td>Estrangeiros</td>\n",
       "      <td>2015-04-23</td>\n",
       "      <td>Disney</td>\n",
       "      <td>Distribuição Internacional</td>\n",
       "      <td>10129071</td>\n",
       "      <td>146184931.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      Ano de exibição               Título da obra  Gênero  \\\n",
       "2249             2015  Vingadores: A Era de Ultron  Ficção   \n",
       "\n",
       "     País(es) produtor(es) da obra Nacionalidade da obra Data de lançamento  \\\n",
       "2249                Estados Unidos          Estrangeiros         2015-04-23   \n",
       "\n",
       "     Distribuidora Origem da empresa distribuidora  \\\n",
       "2249        Disney      Distribuição Internacional   \n",
       "\n",
       "      Público no ano de exibição  Renda (R$) no ano de exibição  \n",
       "2249                    10129071                    146184931.0  "
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Qual é o filme que teve a maior bilheteria?\n",
    "df_novo[df_novo['Renda (R$) no ano de exibição'] == df_novo['Renda (R$) no ano de exibição'].max()]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Ano de exibição</th>\n",
       "      <th>Título da obra</th>\n",
       "      <th>Gênero</th>\n",
       "      <th>País(es) produtor(es) da obra</th>\n",
       "      <th>Nacionalidade da obra</th>\n",
       "      <th>Data de lançamento</th>\n",
       "      <th>Distribuidora</th>\n",
       "      <th>Origem da empresa distribuidora</th>\n",
       "      <th>Público no ano de exibição</th>\n",
       "      <th>Renda (R$) no ano de exibição</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2277</th>\n",
       "      <td>2014</td>\n",
       "      <td>A Batalha do passinho</td>\n",
       "      <td>Documentário</td>\n",
       "      <td>Brasil</td>\n",
       "      <td>Brasileiros</td>\n",
       "      <td>2013-10-11</td>\n",
       "      <td>Cine Santa Teresa</td>\n",
       "      <td>Distribuição Nacional</td>\n",
       "      <td>355</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2608</th>\n",
       "      <td>2014</td>\n",
       "      <td>Mar negro</td>\n",
       "      <td>Ficção</td>\n",
       "      <td>Brasil</td>\n",
       "      <td>Brasileiros</td>\n",
       "      <td>2014-01-17</td>\n",
       "      <td>Petrini</td>\n",
       "      <td>Distribuição Nacional</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2728</th>\n",
       "      <td>2014</td>\n",
       "      <td>O Último Lance do Leilão</td>\n",
       "      <td>Ficção</td>\n",
       "      <td>Brasil</td>\n",
       "      <td>Brasileiros</td>\n",
       "      <td>2014-05-01</td>\n",
       "      <td>Sam Rádio Pictures</td>\n",
       "      <td>Distribuição Nacional</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3041</th>\n",
       "      <td>2013</td>\n",
       "      <td>As horas vulgares</td>\n",
       "      <td>Ficção</td>\n",
       "      <td>Brasil</td>\n",
       "      <td>Brasileiros</td>\n",
       "      <td>2013-08-09</td>\n",
       "      <td>Petrini</td>\n",
       "      <td>Distribuição Nacional</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3058</th>\n",
       "      <td>2013</td>\n",
       "      <td>Beije-me outra vez</td>\n",
       "      <td>Ficção</td>\n",
       "      <td>Itália</td>\n",
       "      <td>Estrangeiros</td>\n",
       "      <td>2013-05-10</td>\n",
       "      <td>Petrini</td>\n",
       "      <td>Distribuição Nacional</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3105</th>\n",
       "      <td>2013</td>\n",
       "      <td>Crazy Horse</td>\n",
       "      <td>Ficção</td>\n",
       "      <td>Estados Unidos</td>\n",
       "      <td>Estrangeiros</td>\n",
       "      <td>2013-06-28</td>\n",
       "      <td>Petrini</td>\n",
       "      <td>Distribuição Nacional</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3390</th>\n",
       "      <td>2013</td>\n",
       "      <td>Quase um tango</td>\n",
       "      <td>Ficção</td>\n",
       "      <td>Brasil</td>\n",
       "      <td>Brasileiros</td>\n",
       "      <td>2013-08-16</td>\n",
       "      <td>NGM Produções</td>\n",
       "      <td>Distribuição Nacional</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3459</th>\n",
       "      <td>2013</td>\n",
       "      <td>Todos os Dias</td>\n",
       "      <td>Ficção</td>\n",
       "      <td>Reino Unido</td>\n",
       "      <td>Estrangeiros</td>\n",
       "      <td>2014-01-24</td>\n",
       "      <td>Esfera Produções</td>\n",
       "      <td>Distribuição Nacional</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3603</th>\n",
       "      <td>2012</td>\n",
       "      <td>Apenas entre Nós</td>\n",
       "      <td>Ficção</td>\n",
       "      <td>França, Eslovênia, Sérvia, Croácia</td>\n",
       "      <td>Estrangeiros</td>\n",
       "      <td>2015-05-07</td>\n",
       "      <td>Lume</td>\n",
       "      <td>Distribuição Nacional</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3627</th>\n",
       "      <td>2012</td>\n",
       "      <td>Ataque ao prédio</td>\n",
       "      <td>Ficção</td>\n",
       "      <td>Reino Unido</td>\n",
       "      <td>Estrangeiros</td>\n",
       "      <td>2012-01-13</td>\n",
       "      <td>Sony</td>\n",
       "      <td>Distribuição Internacional</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3665</th>\n",
       "      <td>2012</td>\n",
       "      <td>Clementina de Jesus - Rainha Quelé</td>\n",
       "      <td>Documentário</td>\n",
       "      <td>Brasil</td>\n",
       "      <td>Brasileiros</td>\n",
       "      <td>2012-11-15</td>\n",
       "      <td>Werinton Kermes Telles Marsal</td>\n",
       "      <td>Distribuição Nacional</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3787</th>\n",
       "      <td>2012</td>\n",
       "      <td>Luto em Luta</td>\n",
       "      <td>Documentário</td>\n",
       "      <td>Brasil</td>\n",
       "      <td>Brasileiros</td>\n",
       "      <td>2012-09-21</td>\n",
       "      <td>Like Filmes</td>\n",
       "      <td>Distribuição Nacional</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3815</th>\n",
       "      <td>2012</td>\n",
       "      <td>Movimento Browniano</td>\n",
       "      <td>Ficção</td>\n",
       "      <td>Holanda</td>\n",
       "      <td>Estrangeiros</td>\n",
       "      <td>2012-07-06</td>\n",
       "      <td>Petrini</td>\n",
       "      <td>Distribuição Nacional</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3829</th>\n",
       "      <td>2012</td>\n",
       "      <td>O abrigo</td>\n",
       "      <td>Ficção</td>\n",
       "      <td>Estados Unidos</td>\n",
       "      <td>Estrangeiros</td>\n",
       "      <td>2012-06-01</td>\n",
       "      <td>Sony</td>\n",
       "      <td>Distribuição Internacional</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3920</th>\n",
       "      <td>2012</td>\n",
       "      <td>Ponto Org</td>\n",
       "      <td>Ficção</td>\n",
       "      <td>Brasil</td>\n",
       "      <td>Brasileiros</td>\n",
       "      <td>2012-09-21</td>\n",
       "      <td>Usina Digital</td>\n",
       "      <td>Distribuição Nacional</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4085</th>\n",
       "      <td>2011</td>\n",
       "      <td>A Última Estrada da Praia</td>\n",
       "      <td>Ficção</td>\n",
       "      <td>Brasil</td>\n",
       "      <td>Brasileiros</td>\n",
       "      <td>2011-09-16</td>\n",
       "      <td>Okna Produções</td>\n",
       "      <td>Distribuição Nacional</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4462</th>\n",
       "      <td>2011</td>\n",
       "      <td>Poema de Salvação</td>\n",
       "      <td>Ficção</td>\n",
       "      <td>Argentina</td>\n",
       "      <td>Estrangeiros</td>\n",
       "      <td>2011-09-30</td>\n",
       "      <td>Canzión filmes</td>\n",
       "      <td>Distribuição Nacional</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4466</th>\n",
       "      <td>2011</td>\n",
       "      <td>Porta a porta – A política em dois tempos</td>\n",
       "      <td>Documentário</td>\n",
       "      <td>Brasil</td>\n",
       "      <td>Brasileiros</td>\n",
       "      <td>2011-12-02</td>\n",
       "      <td>Zéfiro Produções</td>\n",
       "      <td>Distribuição Nacional</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4587</th>\n",
       "      <td>2011</td>\n",
       "      <td>Walachai</td>\n",
       "      <td>Documentário</td>\n",
       "      <td>Brasil</td>\n",
       "      <td>Brasileiros</td>\n",
       "      <td>2011-11-18</td>\n",
       "      <td>Ciclorama</td>\n",
       "      <td>Distribuição Nacional</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4732</th>\n",
       "      <td>2010</td>\n",
       "      <td>Cine Cocoricó: As Aventuras na Cidade</td>\n",
       "      <td>Ficção</td>\n",
       "      <td>Brasil</td>\n",
       "      <td>Brasileiros</td>\n",
       "      <td>2009-07-17</td>\n",
       "      <td>Moviemobz</td>\n",
       "      <td>Distribuição Nacional</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4853</th>\n",
       "      <td>2010</td>\n",
       "      <td>Luto Como Mãe</td>\n",
       "      <td>Documentário</td>\n",
       "      <td>Brasil</td>\n",
       "      <td>Brasileiros</td>\n",
       "      <td>2010-08-20</td>\n",
       "      <td>TV Zero Cinema</td>\n",
       "      <td>Distribuição Nacional</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5022</th>\n",
       "      <td>2010</td>\n",
       "      <td>Simonal - Ninguém Sabe o Duro que Dei</td>\n",
       "      <td>Documentário</td>\n",
       "      <td>Brasil</td>\n",
       "      <td>Brasileiros</td>\n",
       "      <td>2009-05-15</td>\n",
       "      <td>Moviemobz/RioFilme</td>\n",
       "      <td>Distribuição Nacional</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5203</th>\n",
       "      <td>2009</td>\n",
       "      <td>As Chaves de Casa</td>\n",
       "      <td>Ficção</td>\n",
       "      <td>Itália</td>\n",
       "      <td>Estrangeiros</td>\n",
       "      <td>2006-01-06</td>\n",
       "      <td>Filmes do Estação</td>\n",
       "      <td>Distribuição Nacional</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5463</th>\n",
       "      <td>2009</td>\n",
       "      <td>Naufrágio - Mistério e Morte na Catástrofe do ...</td>\n",
       "      <td>Documentário</td>\n",
       "      <td>Brasil</td>\n",
       "      <td>Brasileiros</td>\n",
       "      <td>2009-12-25</td>\n",
       "      <td>Master Shot Produções</td>\n",
       "      <td>Distribuição Nacional</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5591</th>\n",
       "      <td>2009</td>\n",
       "      <td>Santiago</td>\n",
       "      <td>Documentário</td>\n",
       "      <td>Brasil</td>\n",
       "      <td>Brasileiros</td>\n",
       "      <td>2007-08-24</td>\n",
       "      <td>Videofilmes</td>\n",
       "      <td>Distribuição Nacional</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5666</th>\n",
       "      <td>2009</td>\n",
       "      <td>Vamos Subir, Leão</td>\n",
       "      <td>Documentário</td>\n",
       "      <td>Brasil</td>\n",
       "      <td>Brasileiros</td>\n",
       "      <td>2009-03-20</td>\n",
       "      <td>Canal 3</td>\n",
       "      <td>Distribuição Nacional</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      Ano de exibição                                     Título da obra  \\\n",
       "2277             2014                              A Batalha do passinho   \n",
       "2608             2014                                          Mar negro   \n",
       "2728             2014                           O Último Lance do Leilão   \n",
       "3041             2013                                  As horas vulgares   \n",
       "3058             2013                                 Beije-me outra vez   \n",
       "3105             2013                                        Crazy Horse   \n",
       "3390             2013                                     Quase um tango   \n",
       "3459             2013                                      Todos os Dias   \n",
       "3603             2012                                   Apenas entre Nós   \n",
       "3627             2012                                   Ataque ao prédio   \n",
       "3665             2012                 Clementina de Jesus - Rainha Quelé   \n",
       "3787             2012                                       Luto em Luta   \n",
       "3815             2012                                Movimento Browniano   \n",
       "3829             2012                                           O abrigo   \n",
       "3920             2012                                          Ponto Org   \n",
       "4085             2011                          A Última Estrada da Praia   \n",
       "4462             2011                                  Poema de Salvação   \n",
       "4466             2011          Porta a porta – A política em dois tempos   \n",
       "4587             2011                                           Walachai   \n",
       "4732             2010              Cine Cocoricó: As Aventuras na Cidade   \n",
       "4853             2010                                      Luto Como Mãe   \n",
       "5022             2010              Simonal - Ninguém Sabe o Duro que Dei   \n",
       "5203             2009                                  As Chaves de Casa   \n",
       "5463             2009  Naufrágio - Mistério e Morte na Catástrofe do ...   \n",
       "5591             2009                                           Santiago   \n",
       "5666             2009                                  Vamos Subir, Leão   \n",
       "\n",
       "            Gênero       País(es) produtor(es) da obra Nacionalidade da obra  \\\n",
       "2277  Documentário                              Brasil           Brasileiros   \n",
       "2608        Ficção                              Brasil           Brasileiros   \n",
       "2728        Ficção                              Brasil           Brasileiros   \n",
       "3041        Ficção                              Brasil           Brasileiros   \n",
       "3058        Ficção                              Itália          Estrangeiros   \n",
       "3105        Ficção                      Estados Unidos          Estrangeiros   \n",
       "3390        Ficção                              Brasil           Brasileiros   \n",
       "3459        Ficção                         Reino Unido          Estrangeiros   \n",
       "3603        Ficção  França, Eslovênia, Sérvia, Croácia          Estrangeiros   \n",
       "3627        Ficção                         Reino Unido          Estrangeiros   \n",
       "3665  Documentário                              Brasil           Brasileiros   \n",
       "3787  Documentário                              Brasil           Brasileiros   \n",
       "3815        Ficção                             Holanda          Estrangeiros   \n",
       "3829        Ficção                      Estados Unidos          Estrangeiros   \n",
       "3920        Ficção                              Brasil           Brasileiros   \n",
       "4085        Ficção                              Brasil           Brasileiros   \n",
       "4462        Ficção                           Argentina          Estrangeiros   \n",
       "4466  Documentário                              Brasil           Brasileiros   \n",
       "4587  Documentário                              Brasil           Brasileiros   \n",
       "4732        Ficção                              Brasil           Brasileiros   \n",
       "4853  Documentário                              Brasil           Brasileiros   \n",
       "5022  Documentário                              Brasil           Brasileiros   \n",
       "5203        Ficção                              Itália          Estrangeiros   \n",
       "5463  Documentário                              Brasil           Brasileiros   \n",
       "5591  Documentário                              Brasil           Brasileiros   \n",
       "5666  Documentário                              Brasil           Brasileiros   \n",
       "\n",
       "     Data de lançamento                  Distribuidora  \\\n",
       "2277         2013-10-11              Cine Santa Teresa   \n",
       "2608         2014-01-17                        Petrini   \n",
       "2728         2014-05-01             Sam Rádio Pictures   \n",
       "3041         2013-08-09                        Petrini   \n",
       "3058         2013-05-10                        Petrini   \n",
       "3105         2013-06-28                        Petrini   \n",
       "3390         2013-08-16                  NGM Produções   \n",
       "3459         2014-01-24               Esfera Produções   \n",
       "3603         2015-05-07                           Lume   \n",
       "3627         2012-01-13                          Sony    \n",
       "3665         2012-11-15  Werinton Kermes Telles Marsal   \n",
       "3787         2012-09-21                    Like Filmes   \n",
       "3815         2012-07-06                        Petrini   \n",
       "3829         2012-06-01                          Sony    \n",
       "3920         2012-09-21                  Usina Digital   \n",
       "4085         2011-09-16                 Okna Produções   \n",
       "4462         2011-09-30                 Canzión filmes   \n",
       "4466         2011-12-02               Zéfiro Produções   \n",
       "4587         2011-11-18                      Ciclorama   \n",
       "4732         2009-07-17                     Moviemobz    \n",
       "4853         2010-08-20                 TV Zero Cinema   \n",
       "5022         2009-05-15             Moviemobz/RioFilme   \n",
       "5203         2006-01-06              Filmes do Estação   \n",
       "5463         2009-12-25          Master Shot Produções   \n",
       "5591         2007-08-24                    Videofilmes   \n",
       "5666         2009-03-20                        Canal 3   \n",
       "\n",
       "     Origem da empresa distribuidora  Público no ano de exibição  \\\n",
       "2277           Distribuição Nacional                         355   \n",
       "2608           Distribuição Nacional                           0   \n",
       "2728           Distribuição Nacional                           0   \n",
       "3041           Distribuição Nacional                           0   \n",
       "3058           Distribuição Nacional                           0   \n",
       "3105           Distribuição Nacional                           0   \n",
       "3390           Distribuição Nacional                           0   \n",
       "3459           Distribuição Nacional                           0   \n",
       "3603           Distribuição Nacional                           0   \n",
       "3627      Distribuição Internacional                           0   \n",
       "3665           Distribuição Nacional                           0   \n",
       "3787           Distribuição Nacional                           0   \n",
       "3815           Distribuição Nacional                           0   \n",
       "3829      Distribuição Internacional                           0   \n",
       "3920           Distribuição Nacional                           0   \n",
       "4085           Distribuição Nacional                           0   \n",
       "4462           Distribuição Nacional                           0   \n",
       "4466           Distribuição Nacional                           0   \n",
       "4587           Distribuição Nacional                           0   \n",
       "4732           Distribuição Nacional                           1   \n",
       "4853           Distribuição Nacional                           0   \n",
       "5022           Distribuição Nacional                           1   \n",
       "5203           Distribuição Nacional                           0   \n",
       "5463           Distribuição Nacional                           0   \n",
       "5591           Distribuição Nacional                           0   \n",
       "5666           Distribuição Nacional                           0   \n",
       "\n",
       "      Renda (R$) no ano de exibição  \n",
       "2277                            0.0  \n",
       "2608                            0.0  \n",
       "2728                            0.0  \n",
       "3041                            0.0  \n",
       "3058                            0.0  \n",
       "3105                            0.0  \n",
       "3390                            0.0  \n",
       "3459                            0.0  \n",
       "3603                            0.0  \n",
       "3627                            0.0  \n",
       "3665                            0.0  \n",
       "3787                            0.0  \n",
       "3815                            0.0  \n",
       "3829                            0.0  \n",
       "3920                            0.0  \n",
       "4085                            0.0  \n",
       "4462                            0.0  \n",
       "4466                            0.0  \n",
       "4587                            0.0  \n",
       "4732                            0.0  \n",
       "4853                            0.0  \n",
       "5022                            0.0  \n",
       "5203                            0.0  \n",
       "5463                            0.0  \n",
       "5591                            0.0  \n",
       "5666                            0.0  "
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Qual é o filme que teve a menor bilheteria?\n",
    "df_novo[df_novo['Renda (R$) no ano de exibição'] == df_novo['Renda (R$) no ano de exibição'].min()]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Estrangeiros    3902\n",
       "Brasileiros     1614\n",
       "Name: Nacionalidade da obra, dtype: int64"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Quantos filmes brasileiros e estrangeiros?\n",
    "df_novo['Nacionalidade da obra'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}