limpeza_dos_dados.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "249dcaee",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2023-04-19T21:19:54.470790Z",
     "start_time": "2023-04-19T21:19:54.230163Z"
    }
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import datetime\n",
    "#from datetime import datetime"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "7cb7417a",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2023-04-19T21:19:56.614824Z",
     "start_time": "2023-04-19T21:19:55.682221Z"
    }
   },
   "outputs": [],
   "source": [
    "df_raw = pd.read_csv('dados/bronze/raw_data.csv', index_col=0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "5c5fba7c",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2023-04-19T21:19:57.419664Z",
     "start_time": "2023-04-19T21:19:57.333529Z"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(1317, 66)\n"
     ]
    },
    {
     "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>id</th>\n",
       "      <th>uploader</th>\n",
       "      <th>uploader_id</th>\n",
       "      <th>uploader_url</th>\n",
       "      <th>channel_id</th>\n",
       "      <th>channel_url</th>\n",
       "      <th>upload_date</th>\n",
       "      <th>license</th>\n",
       "      <th>creator</th>\n",
       "      <th>title</th>\n",
       "      <th>alt_title</th>\n",
       "      <th>thumbnails</th>\n",
       "      <th>description</th>\n",
       "      <th>categories</th>\n",
       "      <th>tags</th>\n",
       "      <th>subtitles</th>\n",
       "      <th>automatic_captions</th>\n",
       "      <th>duration</th>\n",
       "      <th>age_limit</th>\n",
       "      <th>annotations</th>\n",
       "      <th>chapters</th>\n",
       "      <th>webpage_url</th>\n",
       "      <th>view_count</th>\n",
       "      <th>like_count</th>\n",
       "      <th>dislike_count</th>\n",
       "      <th>average_rating</th>\n",
       "      <th>formats</th>\n",
       "      <th>is_live</th>\n",
       "      <th>start_time</th>\n",
       "      <th>end_time</th>\n",
       "      <th>series</th>\n",
       "      <th>season_number</th>\n",
       "      <th>episode_number</th>\n",
       "      <th>track</th>\n",
       "      <th>artist</th>\n",
       "      <th>album</th>\n",
       "      <th>release_date</th>\n",
       "      <th>release_year</th>\n",
       "      <th>subscriber_count</th>\n",
       "      <th>extractor</th>\n",
       "      <th>webpage_url_basename</th>\n",
       "      <th>extractor_key</th>\n",
       "      <th>n_entries</th>\n",
       "      <th>playlist</th>\n",
       "      <th>playlist_id</th>\n",
       "      <th>playlist_title</th>\n",
       "      <th>playlist_uploader</th>\n",
       "      <th>playlist_uploader_id</th>\n",
       "      <th>playlist_index</th>\n",
       "      <th>thumbnail</th>\n",
       "      <th>display_id</th>\n",
       "      <th>requested_subtitles</th>\n",
       "      <th>requested_formats</th>\n",
       "      <th>format</th>\n",
       "      <th>format_id</th>\n",
       "      <th>ext</th>\n",
       "      <th>width</th>\n",
       "      <th>height</th>\n",
       "      <th>resolution</th>\n",
       "      <th>fps</th>\n",
       "      <th>vcodec</th>\n",
       "      <th>vbr</th>\n",
       "      <th>stretched_ratio</th>\n",
       "      <th>acodec</th>\n",
       "      <th>abr</th>\n",
       "      <th>query</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>kE9gYQDyVr0</td>\n",
       "      <td>Hashtag Programação</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://www.youtube.com/@HashtagProgramacao</td>\n",
       "      <td>UCafFexaRoRylOKdzGBU6Pgg</td>\n",
       "      <td>http://www.youtube.com/channel/UCafFexaRoRylOK...</td>\n",
       "      <td>20230417</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Trabalhando com Bases de Dados (Datasets) Desb...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[{'url': 'https://i.ytimg.com/vi/kE9gYQDyVr0/h...</td>\n",
       "      <td>Quer saber mais sobre o nosso Curso Completo d...</td>\n",
       "      <td>['Education']</td>\n",
       "      <td>['Bases de dados desbalanceadas', 'Datasets de...</td>\n",
       "      <td>{}</td>\n",
       "      <td>{}</td>\n",
       "      <td>1326.0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.youtube.com/watch?v=kE9gYQDyVr0</td>\n",
       "      <td>858</td>\n",
       "      <td>72.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[{'format_id': '249', 'url': 'https://rr1---sn...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>youtube</td>\n",
       "      <td>kE9gYQDyVr0</td>\n",
       "      <td>Youtube</td>\n",
       "      <td>232</td>\n",
       "      <td>ciencia+de+dados</td>\n",
       "      <td>ciencia+de+dados</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>https://i.ytimg.com/vi_webp/kE9gYQDyVr0/maxres...</td>\n",
       "      <td>kE9gYQDyVr0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[{'format_id': '137', 'url': 'https://rr1---sn...</td>\n",
       "      <td>137 - 1920x1080 (1080p)+140 - audio only (tiny)</td>\n",
       "      <td>137+140</td>\n",
       "      <td>mp4</td>\n",
       "      <td>1920</td>\n",
       "      <td>1080</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30</td>\n",
       "      <td>avc1.640028</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>mp4a.40.2</td>\n",
       "      <td>128.0</td>\n",
       "      <td>ciencia+de+dados</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>GgEUPkAG1ho</td>\n",
       "      <td>Jonas Silva</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://www.youtube.com/@jonassilva1500</td>\n",
       "      <td>UC93r1MGydg0Wd9_spsG4W9Q</td>\n",
       "      <td>http://www.youtube.com/channel/UC93r1MGydg0Wd9...</td>\n",
       "      <td>20230413</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Trabalho ciencia de dados-parte-1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[{'url': 'https://i.ytimg.com/vi/GgEUPkAG1ho/h...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>['People &amp; Blogs']</td>\n",
       "      <td>NaN</td>\n",
       "      <td>{}</td>\n",
       "      <td>{}</td>\n",
       "      <td>389.0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.youtube.com/watch?v=GgEUPkAG1ho</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[{'format_id': '251', 'url': 'https://rr1---sn...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>youtube</td>\n",
       "      <td>GgEUPkAG1ho</td>\n",
       "      <td>Youtube</td>\n",
       "      <td>232</td>\n",
       "      <td>ciencia+de+dados</td>\n",
       "      <td>ciencia+de+dados</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>https://i.ytimg.com/vi/GgEUPkAG1ho/maxresdefau...</td>\n",
       "      <td>GgEUPkAG1ho</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[{'format_id': '137', 'url': 'https://rr1---sn...</td>\n",
       "      <td>137 - 1920x1080 (1080p)+140 - audio only (tiny)</td>\n",
       "      <td>137+140</td>\n",
       "      <td>mp4</td>\n",
       "      <td>1920</td>\n",
       "      <td>1080</td>\n",
       "      <td>NaN</td>\n",
       "      <td>25</td>\n",
       "      <td>avc1.640028</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>mp4a.40.2</td>\n",
       "      <td>128.0</td>\n",
       "      <td>ciencia+de+dados</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>U1a_Tp0O1Co</td>\n",
       "      <td>Hashtag Programação</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://www.youtube.com/@HashtagProgramacao</td>\n",
       "      <td>UCafFexaRoRylOKdzGBU6Pgg</td>\n",
       "      <td>http://www.youtube.com/channel/UCafFexaRoRylOK...</td>\n",
       "      <td>20230410</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Como Aprender CIÊNCIA DE DADOS do ZERO?</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[{'url': 'https://i.ytimg.com/vi/U1a_Tp0O1Co/h...</td>\n",
       "      <td>Quer saber mais sobre o nosso Curso Completo d...</td>\n",
       "      <td>['Education']</td>\n",
       "      <td>['Como aprender ciência de dados', 'Como apren...</td>\n",
       "      <td>{}</td>\n",
       "      <td>{}</td>\n",
       "      <td>1514.0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.youtube.com/watch?v=U1a_Tp0O1Co</td>\n",
       "      <td>1</td>\n",
       "      <td>173.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[{'format_id': '249', 'url': 'https://rr1---sn...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>youtube</td>\n",
       "      <td>U1a_Tp0O1Co</td>\n",
       "      <td>Youtube</td>\n",
       "      <td>232</td>\n",
       "      <td>ciencia+de+dados</td>\n",
       "      <td>ciencia+de+dados</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "      <td>https://i.ytimg.com/vi_webp/U1a_Tp0O1Co/maxres...</td>\n",
       "      <td>U1a_Tp0O1Co</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[{'format_id': '137', 'url': 'https://rr1---sn...</td>\n",
       "      <td>137 - 1920x1080 (1080p)+140 - audio only (tiny)</td>\n",
       "      <td>137+140</td>\n",
       "      <td>mp4</td>\n",
       "      <td>1920</td>\n",
       "      <td>1080</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30</td>\n",
       "      <td>avc1.640028</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>mp4a.40.2</td>\n",
       "      <td>128.0</td>\n",
       "      <td>ciencia+de+dados</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            id             uploader  uploader_id  \\\n",
       "0  kE9gYQDyVr0  Hashtag Programação          NaN   \n",
       "1  GgEUPkAG1ho          Jonas Silva          NaN   \n",
       "2  U1a_Tp0O1Co  Hashtag Programação          NaN   \n",
       "\n",
       "                                 uploader_url                channel_id  \\\n",
       "0  http://www.youtube.com/@HashtagProgramacao  UCafFexaRoRylOKdzGBU6Pgg   \n",
       "1      http://www.youtube.com/@jonassilva1500  UC93r1MGydg0Wd9_spsG4W9Q   \n",
       "2  http://www.youtube.com/@HashtagProgramacao  UCafFexaRoRylOKdzGBU6Pgg   \n",
       "\n",
       "                                         channel_url  upload_date  license  \\\n",
       "0  http://www.youtube.com/channel/UCafFexaRoRylOK...     20230417      NaN   \n",
       "1  http://www.youtube.com/channel/UC93r1MGydg0Wd9...     20230413      NaN   \n",
       "2  http://www.youtube.com/channel/UCafFexaRoRylOK...     20230410      NaN   \n",
       "\n",
       "   creator                                              title  alt_title  \\\n",
       "0      NaN  Trabalhando com Bases de Dados (Datasets) Desb...        NaN   \n",
       "1      NaN                  Trabalho ciencia de dados-parte-1        NaN   \n",
       "2      NaN            Como Aprender CIÊNCIA DE DADOS do ZERO?        NaN   \n",
       "\n",
       "                                          thumbnails  \\\n",
       "0  [{'url': 'https://i.ytimg.com/vi/kE9gYQDyVr0/h...   \n",
       "1  [{'url': 'https://i.ytimg.com/vi/GgEUPkAG1ho/h...   \n",
       "2  [{'url': 'https://i.ytimg.com/vi/U1a_Tp0O1Co/h...   \n",
       "\n",
       "                                         description          categories  \\\n",
       "0  Quer saber mais sobre o nosso Curso Completo d...       ['Education']   \n",
       "1                                                NaN  ['People & Blogs']   \n",
       "2  Quer saber mais sobre o nosso Curso Completo d...       ['Education']   \n",
       "\n",
       "                                                tags subtitles  \\\n",
       "0  ['Bases de dados desbalanceadas', 'Datasets de...        {}   \n",
       "1                                                NaN        {}   \n",
       "2  ['Como aprender ciência de dados', 'Como apren...        {}   \n",
       "\n",
       "  automatic_captions  duration  age_limit  annotations  chapters  \\\n",
       "0                 {}    1326.0          0          NaN       NaN   \n",
       "1                 {}     389.0          0          NaN       NaN   \n",
       "2                 {}    1514.0          0          NaN       NaN   \n",
       "\n",
       "                                   webpage_url  view_count  like_count  \\\n",
       "0  https://www.youtube.com/watch?v=kE9gYQDyVr0         858        72.0   \n",
       "1  https://www.youtube.com/watch?v=GgEUPkAG1ho           2         NaN   \n",
       "2  https://www.youtube.com/watch?v=U1a_Tp0O1Co           1       173.0   \n",
       "\n",
       "   dislike_count  average_rating  \\\n",
       "0            NaN             NaN   \n",
       "1            NaN             NaN   \n",
       "2            NaN             NaN   \n",
       "\n",
       "                                             formats  is_live  start_time  \\\n",
       "0  [{'format_id': '249', 'url': 'https://rr1---sn...      NaN         NaN   \n",
       "1  [{'format_id': '251', 'url': 'https://rr1---sn...      NaN         NaN   \n",
       "2  [{'format_id': '249', 'url': 'https://rr1---sn...      NaN         NaN   \n",
       "\n",
       "   end_time  series  season_number  episode_number  track  artist  album  \\\n",
       "0       NaN     NaN            NaN             NaN    NaN     NaN    NaN   \n",
       "1       NaN     NaN            NaN             NaN    NaN     NaN    NaN   \n",
       "2       NaN     NaN            NaN             NaN    NaN     NaN    NaN   \n",
       "\n",
       "   release_date  release_year  subscriber_count extractor  \\\n",
       "0           NaN           NaN               NaN   youtube   \n",
       "1           NaN           NaN               NaN   youtube   \n",
       "2           NaN           NaN               NaN   youtube   \n",
       "\n",
       "  webpage_url_basename extractor_key  n_entries          playlist  \\\n",
       "0          kE9gYQDyVr0       Youtube        232  ciencia+de+dados   \n",
       "1          GgEUPkAG1ho       Youtube        232  ciencia+de+dados   \n",
       "2          U1a_Tp0O1Co       Youtube        232  ciencia+de+dados   \n",
       "\n",
       "        playlist_id  playlist_title  playlist_uploader  playlist_uploader_id  \\\n",
       "0  ciencia+de+dados             NaN                NaN                   NaN   \n",
       "1  ciencia+de+dados             NaN                NaN                   NaN   \n",
       "2  ciencia+de+dados             NaN                NaN                   NaN   \n",
       "\n",
       "   playlist_index                                          thumbnail  \\\n",
       "0               1  https://i.ytimg.com/vi_webp/kE9gYQDyVr0/maxres...   \n",
       "1               2  https://i.ytimg.com/vi/GgEUPkAG1ho/maxresdefau...   \n",
       "2               3  https://i.ytimg.com/vi_webp/U1a_Tp0O1Co/maxres...   \n",
       "\n",
       "    display_id  requested_subtitles  \\\n",
       "0  kE9gYQDyVr0                  NaN   \n",
       "1  GgEUPkAG1ho                  NaN   \n",
       "2  U1a_Tp0O1Co                  NaN   \n",
       "\n",
       "                                   requested_formats  \\\n",
       "0  [{'format_id': '137', 'url': 'https://rr1---sn...   \n",
       "1  [{'format_id': '137', 'url': 'https://rr1---sn...   \n",
       "2  [{'format_id': '137', 'url': 'https://rr1---sn...   \n",
       "\n",
       "                                            format format_id  ext  width  \\\n",
       "0  137 - 1920x1080 (1080p)+140 - audio only (tiny)   137+140  mp4   1920   \n",
       "1  137 - 1920x1080 (1080p)+140 - audio only (tiny)   137+140  mp4   1920   \n",
       "2  137 - 1920x1080 (1080p)+140 - audio only (tiny)   137+140  mp4   1920   \n",
       "\n",
       "   height  resolution  fps       vcodec  vbr  stretched_ratio     acodec  \\\n",
       "0    1080         NaN   30  avc1.640028  NaN              NaN  mp4a.40.2   \n",
       "1    1080         NaN   25  avc1.640028  NaN              NaN  mp4a.40.2   \n",
       "2    1080         NaN   30  avc1.640028  NaN              NaN  mp4a.40.2   \n",
       "\n",
       "     abr             query  \n",
       "0  128.0  ciencia+de+dados  \n",
       "1  128.0  ciencia+de+dados  \n",
       "2  128.0  ciencia+de+dados  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "print(df_raw.shape)\n",
    "pd.set_option(\"display.max_columns\", 70)\n",
    "df_raw.head(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "6830887b",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2023-04-19T21:19:58.066974Z",
     "start_time": "2023-04-19T21:19:58.046247Z"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 1317 entries, 0 to 1316\n",
      "Data columns (total 66 columns):\n",
      " #   Column                Non-Null Count  Dtype  \n",
      "---  ------                --------------  -----  \n",
      " 0   id                    1317 non-null   object \n",
      " 1   uploader              1316 non-null   object \n",
      " 2   uploader_id           0 non-null      float64\n",
      " 3   uploader_url          1317 non-null   object \n",
      " 4   channel_id            1317 non-null   object \n",
      " 5   channel_url           1317 non-null   object \n",
      " 6   upload_date           1317 non-null   int64  \n",
      " 7   license               0 non-null      float64\n",
      " 8   creator               0 non-null      float64\n",
      " 9   title                 1317 non-null   object \n",
      " 10  alt_title             0 non-null      float64\n",
      " 11  thumbnails            1317 non-null   object \n",
      " 12  description           1207 non-null   object \n",
      " 13  categories            1317 non-null   object \n",
      " 14  tags                  938 non-null    object \n",
      " 15  subtitles             1317 non-null   object \n",
      " 16  automatic_captions    1317 non-null   object \n",
      " 17  duration              1317 non-null   float64\n",
      " 18  age_limit             1317 non-null   int64  \n",
      " 19  annotations           0 non-null      float64\n",
      " 20  chapters              0 non-null      float64\n",
      " 21  webpage_url           1317 non-null   object \n",
      " 22  view_count            1317 non-null   int64  \n",
      " 23  like_count            1213 non-null   float64\n",
      " 24  dislike_count         0 non-null      float64\n",
      " 25  average_rating        0 non-null      float64\n",
      " 26  formats               1317 non-null   object \n",
      " 27  is_live               0 non-null      float64\n",
      " 28  start_time            0 non-null      float64\n",
      " 29  end_time              0 non-null      float64\n",
      " 30  series                0 non-null      float64\n",
      " 31  season_number         0 non-null      float64\n",
      " 32  episode_number        0 non-null      float64\n",
      " 33  track                 0 non-null      float64\n",
      " 34  artist                0 non-null      float64\n",
      " 35  album                 0 non-null      float64\n",
      " 36  release_date          0 non-null      float64\n",
      " 37  release_year          0 non-null      float64\n",
      " 38  subscriber_count      0 non-null      float64\n",
      " 39  extractor             1317 non-null   object \n",
      " 40  webpage_url_basename  1317 non-null   object \n",
      " 41  extractor_key         1317 non-null   object \n",
      " 42  n_entries             1317 non-null   int64  \n",
      " 43  playlist              1317 non-null   object \n",
      " 44  playlist_id           1317 non-null   object \n",
      " 45  playlist_title        0 non-null      float64\n",
      " 46  playlist_uploader     0 non-null      float64\n",
      " 47  playlist_uploader_id  0 non-null      float64\n",
      " 48  playlist_index        1317 non-null   int64  \n",
      " 49  thumbnail             1317 non-null   object \n",
      " 50  display_id            1317 non-null   object \n",
      " 51  requested_subtitles   0 non-null      float64\n",
      " 52  requested_formats     1317 non-null   object \n",
      " 53  format                1317 non-null   object \n",
      " 54  format_id             1317 non-null   object \n",
      " 55  ext                   1317 non-null   object \n",
      " 56  width                 1317 non-null   int64  \n",
      " 57  height                1317 non-null   int64  \n",
      " 58  resolution            0 non-null      float64\n",
      " 59  fps                   1317 non-null   int64  \n",
      " 60  vcodec                1317 non-null   object \n",
      " 61  vbr                   0 non-null      float64\n",
      " 62  stretched_ratio       0 non-null      float64\n",
      " 63  acodec                1317 non-null   object \n",
      " 64  abr                   1314 non-null   float64\n",
      " 65  query                 1317 non-null   object \n",
      "dtypes: float64(30), int64(8), object(28)\n",
      "memory usage: 689.4+ KB\n"
     ]
    }
   ],
   "source": [
    "df_raw.info()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "f56da375",
   "metadata": {},
   "source": [
    "# Tratamento dos dados"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "3fe99068",
   "metadata": {},
   "source": [
    "## Tratando valores ausentes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "ff643fa9",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2023-04-19T21:19:59.724589Z",
     "start_time": "2023-04-19T21:19:59.708753Z"
    }
   },
   "outputs": [],
   "source": [
    "df1 = df_raw.copy()\n",
    "df1[['uploader', 'tags', 'like_count']] = df1[['uploader', 'tags', 'like_count']].fillna('Sem valor')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "d90bd417",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2023-04-19T21:20:00.274409Z",
     "start_time": "2023-04-19T21:20:00.269852Z"
    }
   },
   "outputs": [],
   "source": [
    "def split(df, coluna, coluna_vazia, padrao):\n",
    "    for numero, string in enumerate(df[coluna_vazia]):\n",
    "        index = numero \n",
    "        if string == 'Sem valor':\n",
    "            print(df[coluna][index])\n",
    "            valor = df[coluna][index]\n",
    "            print(valor)\n",
    "            df[coluna_vazia][index] = valor.split(padrao)[1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "6a55ff94",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2023-04-19T21:20:00.838179Z",
     "start_time": "2023-04-19T21:20:00.833391Z"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "http://www.youtube.com/@CavalcantiKarlinha\n",
      "http://www.youtube.com/@CavalcantiKarlinha\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/tmp/ipykernel_60664/1667779886.py:8: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  df[coluna_vazia][index] = valor.split(padrao)[1]\n"
     ]
    }
   ],
   "source": [
    "split(df1, 'uploader_url', 'uploader', '@')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "5310d3d5",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2023-04-19T21:20:01.407068Z",
     "start_time": "2023-04-19T21:20:01.398533Z"
    }
   },
   "outputs": [],
   "source": [
    "df1['tags'] = df1['tags'].replace('Sem valor', '')\n",
    "df1['like_count'] = df1['like_count'].replace('Sem valor', 0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "cd57d2de",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2023-04-19T21:20:02.223247Z",
     "start_time": "2023-04-19T21:20:02.188447Z"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 1317 entries, 0 to 1316\n",
      "Data columns (total 37 columns):\n",
      " #   Column                Non-Null Count  Dtype  \n",
      "---  ------                --------------  -----  \n",
      " 0   id                    1317 non-null   object \n",
      " 1   uploader              1317 non-null   object \n",
      " 2   uploader_url          1317 non-null   object \n",
      " 3   channel_id            1317 non-null   object \n",
      " 4   channel_url           1317 non-null   object \n",
      " 5   upload_date           1317 non-null   int64  \n",
      " 6   title                 1317 non-null   object \n",
      " 7   thumbnails            1317 non-null   object \n",
      " 8   categories            1317 non-null   object \n",
      " 9   tags                  1317 non-null   object \n",
      " 10  subtitles             1317 non-null   object \n",
      " 11  automatic_captions    1317 non-null   object \n",
      " 12  duration              1317 non-null   float64\n",
      " 13  age_limit             1317 non-null   int64  \n",
      " 14  webpage_url           1317 non-null   object \n",
      " 15  view_count            1317 non-null   int64  \n",
      " 16  like_count            1317 non-null   float64\n",
      " 17  formats               1317 non-null   object \n",
      " 18  extractor             1317 non-null   object \n",
      " 19  webpage_url_basename  1317 non-null   object \n",
      " 20  extractor_key         1317 non-null   object \n",
      " 21  n_entries             1317 non-null   int64  \n",
      " 22  playlist              1317 non-null   object \n",
      " 23  playlist_id           1317 non-null   object \n",
      " 24  playlist_index        1317 non-null   int64  \n",
      " 25  thumbnail             1317 non-null   object \n",
      " 26  display_id            1317 non-null   object \n",
      " 27  requested_formats     1317 non-null   object \n",
      " 28  format                1317 non-null   object \n",
      " 29  format_id             1317 non-null   object \n",
      " 30  ext                   1317 non-null   object \n",
      " 31  width                 1317 non-null   int64  \n",
      " 32  height                1317 non-null   int64  \n",
      " 33  fps                   1317 non-null   int64  \n",
      " 34  vcodec                1317 non-null   object \n",
      " 35  acodec                1317 non-null   object \n",
      " 36  query                 1317 non-null   object \n",
      "dtypes: float64(2), int64(8), object(27)\n",
      "memory usage: 423.3+ KB\n"
     ]
    }
   ],
   "source": [
    "df1 = df1.dropna(axis=1)\n",
    "df1.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "b950ae24",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2023-04-19T21:20:05.631438Z",
     "start_time": "2023-04-19T21:20:05.624258Z"
    }
   },
   "outputs": [],
   "source": [
    "df2 = df1[['id', 'title', 'uploader', 'upload_date', 'categories', 'tags',\n",
    "           'duration', 'webpage_url', 'view_count', 'like_count', 'query']]"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "88294469",
   "metadata": {},
   "source": [
    "## Ajuste de id"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "4465aaf8",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2023-04-19T21:20:06.611926Z",
     "start_time": "2023-04-19T21:20:06.605225Z"
    }
   },
   "outputs": [],
   "source": [
    "df3 = df2.copy()\n",
    "df3['id'] = 'watch?v='+df3['id']"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "5fa979d2",
   "metadata": {},
   "source": [
    "## Limpeza da data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "e64634dc",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2023-04-19T21:20:07.822511Z",
     "start_time": "2023-04-19T21:20:07.781703Z"
    }
   },
   "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>id</th>\n",
       "      <th>title</th>\n",
       "      <th>uploader</th>\n",
       "      <th>upload_date</th>\n",
       "      <th>categories</th>\n",
       "      <th>tags</th>\n",
       "      <th>duration</th>\n",
       "      <th>webpage_url</th>\n",
       "      <th>view_count</th>\n",
       "      <th>like_count</th>\n",
       "      <th>query</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>watch?v=kE9gYQDyVr0</td>\n",
       "      <td>Trabalhando com Bases de Dados (Datasets) Desb...</td>\n",
       "      <td>Hashtag Programação</td>\n",
       "      <td>2023-04-17</td>\n",
       "      <td>['Education']</td>\n",
       "      <td>['Bases de dados desbalanceadas', 'Datasets de...</td>\n",
       "      <td>1326.0</td>\n",
       "      <td>https://www.youtube.com/watch?v=kE9gYQDyVr0</td>\n",
       "      <td>858</td>\n",
       "      <td>72.0</td>\n",
       "      <td>ciencia+de+dados</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>watch?v=GgEUPkAG1ho</td>\n",
       "      <td>Trabalho ciencia de dados-parte-1</td>\n",
       "      <td>Jonas Silva</td>\n",
       "      <td>2023-04-13</td>\n",
       "      <td>['People &amp; Blogs']</td>\n",
       "      <td></td>\n",
       "      <td>389.0</td>\n",
       "      <td>https://www.youtube.com/watch?v=GgEUPkAG1ho</td>\n",
       "      <td>2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>ciencia+de+dados</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    id                                              title  \\\n",
       "0  watch?v=kE9gYQDyVr0  Trabalhando com Bases de Dados (Datasets) Desb...   \n",
       "1  watch?v=GgEUPkAG1ho                  Trabalho ciencia de dados-parte-1   \n",
       "\n",
       "              uploader upload_date          categories  \\\n",
       "0  Hashtag Programação  2023-04-17       ['Education']   \n",
       "1          Jonas Silva  2023-04-13  ['People & Blogs']   \n",
       "\n",
       "                                                tags  duration  \\\n",
       "0  ['Bases de dados desbalanceadas', 'Datasets de...    1326.0   \n",
       "1                                                        389.0   \n",
       "\n",
       "                                   webpage_url  view_count  like_count  \\\n",
       "0  https://www.youtube.com/watch?v=kE9gYQDyVr0         858        72.0   \n",
       "1  https://www.youtube.com/watch?v=GgEUPkAG1ho           2         0.0   \n",
       "\n",
       "              query  \n",
       "0  ciencia+de+dados  \n",
       "1  ciencia+de+dados  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df3['upload_date'] = df3['upload_date'].astype(str).apply(lambda x: datetime.datetime.strptime(x, '%Y%m%d').strftime('%Y-%m-%d'))\n",
    "df3['upload_date'] = pd.to_datetime(df3['upload_date'], format='%Y-%m-%d')\n",
    "df3.head(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "aadfc50e",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2023-04-19T21:20:11.577812Z",
     "start_time": "2023-04-19T21:20:11.559341Z"
    }
   },
   "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>id</th>\n",
       "      <th>titulo</th>\n",
       "      <th>canal</th>\n",
       "      <th>data_upload</th>\n",
       "      <th>categoria</th>\n",
       "      <th>tags</th>\n",
       "      <th>duracao_segundos</th>\n",
       "      <th>link</th>\n",
       "      <th>visualizacoes</th>\n",
       "      <th>quantidade_likes</th>\n",
       "      <th>query</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>watch?v=kE9gYQDyVr0</td>\n",
       "      <td>Trabalhando com Bases de Dados (Datasets) Desb...</td>\n",
       "      <td>Hashtag Programação</td>\n",
       "      <td>2023-04-17</td>\n",
       "      <td>['Education']</td>\n",
       "      <td>['Bases de dados desbalanceadas', 'Datasets de...</td>\n",
       "      <td>1326.0</td>\n",
       "      <td>https://www.youtube.com/watch?v=kE9gYQDyVr0</td>\n",
       "      <td>858</td>\n",
       "      <td>72.0</td>\n",
       "      <td>ciencia+de+dados</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>watch?v=GgEUPkAG1ho</td>\n",
       "      <td>Trabalho ciencia de dados-parte-1</td>\n",
       "      <td>Jonas Silva</td>\n",
       "      <td>2023-04-13</td>\n",
       "      <td>['People &amp; Blogs']</td>\n",
       "      <td></td>\n",
       "      <td>389.0</td>\n",
       "      <td>https://www.youtube.com/watch?v=GgEUPkAG1ho</td>\n",
       "      <td>2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>ciencia+de+dados</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    id                                             titulo  \\\n",
       "0  watch?v=kE9gYQDyVr0  Trabalhando com Bases de Dados (Datasets) Desb...   \n",
       "1  watch?v=GgEUPkAG1ho                  Trabalho ciencia de dados-parte-1   \n",
       "\n",
       "                 canal data_upload           categoria  \\\n",
       "0  Hashtag Programação  2023-04-17       ['Education']   \n",
       "1          Jonas Silva  2023-04-13  ['People & Blogs']   \n",
       "\n",
       "                                                tags  duracao_segundos  \\\n",
       "0  ['Bases de dados desbalanceadas', 'Datasets de...            1326.0   \n",
       "1                                                                389.0   \n",
       "\n",
       "                                          link  visualizacoes  \\\n",
       "0  https://www.youtube.com/watch?v=kE9gYQDyVr0            858   \n",
       "1  https://www.youtube.com/watch?v=GgEUPkAG1ho              2   \n",
       "\n",
       "   quantidade_likes             query  \n",
       "0              72.0  ciencia+de+dados  \n",
       "1               0.0  ciencia+de+dados  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "colunas = ['id', 'titulo', 'canal', 'data_upload', 'categoria', 'tags',\n",
    "           'duracao_segundos', 'link', 'visualizacoes', 'quantidade_likes',\n",
    "           'query']\n",
    "df3.columns = colunas\n",
    "df3.head(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "1a3ebc95",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2023-04-19T21:42:22.581264Z",
     "start_time": "2023-04-19T21:42:22.495920Z"
    }
   },
   "outputs": [],
   "source": [
    "# Salvando os dados tratados\n",
    "df3.to_csv('dados/silver/dados_tratados.csv')"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "5406749b",
   "metadata": {},
   "source": [
    "# Feature Engineering"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "08553310",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2023-04-19T21:20:17.086325Z",
     "start_time": "2023-04-19T21:20:17.078487Z"
    }
   },
   "outputs": [],
   "source": [
    "df4 = df3.copy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "60966d1a",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2023-04-19T21:20:17.453592Z",
     "start_time": "2023-04-19T21:20:17.425291Z"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 1317 entries, 0 to 1316\n",
      "Data columns (total 11 columns):\n",
      " #   Column            Non-Null Count  Dtype         \n",
      "---  ------            --------------  -----         \n",
      " 0   id                1317 non-null   object        \n",
      " 1   titulo            1317 non-null   object        \n",
      " 2   canal             1317 non-null   object        \n",
      " 3   data_upload       1317 non-null   datetime64[ns]\n",
      " 4   categoria         1317 non-null   object        \n",
      " 5   tags              1317 non-null   object        \n",
      " 6   duracao_segundos  1317 non-null   float64       \n",
      " 7   link              1317 non-null   object        \n",
      " 8   visualizacoes     1317 non-null   int64         \n",
      " 9   quantidade_likes  1317 non-null   float64       \n",
      " 10  query             1317 non-null   object        \n",
      "dtypes: datetime64[ns](1), float64(2), int64(1), object(7)\n",
      "memory usage: 155.8+ KB\n"
     ]
    }
   ],
   "source": [
    "df4.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "fb0abbce",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2023-04-19T21:20:26.770237Z",
     "start_time": "2023-04-19T21:20:26.747607Z"
    },
    "scrolled": true
   },
   "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>id</th>\n",
       "      <th>titulo</th>\n",
       "      <th>canal</th>\n",
       "      <th>data_upload</th>\n",
       "      <th>categoria</th>\n",
       "      <th>tags</th>\n",
       "      <th>duracao_segundos</th>\n",
       "      <th>link</th>\n",
       "      <th>visualizacoes</th>\n",
       "      <th>quantidade_likes</th>\n",
       "      <th>query</th>\n",
       "      <th>tempo_desde_pub</th>\n",
       "      <th>visualizacoes_por_dia</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>watch?v=kE9gYQDyVr0</td>\n",
       "      <td>Trabalhando com Bases de Dados (Datasets) Desb...</td>\n",
       "      <td>Hashtag Programação</td>\n",
       "      <td>2023-04-17</td>\n",
       "      <td>['Education']</td>\n",
       "      <td>['Bases de dados desbalanceadas', 'Datasets de...</td>\n",
       "      <td>1326.0</td>\n",
       "      <td>https://www.youtube.com/watch?v=kE9gYQDyVr0</td>\n",
       "      <td>858</td>\n",
       "      <td>72.0</td>\n",
       "      <td>ciencia+de+dados</td>\n",
       "      <td>3.0</td>\n",
       "      <td>286.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>watch?v=GgEUPkAG1ho</td>\n",
       "      <td>Trabalho ciencia de dados-parte-1</td>\n",
       "      <td>Jonas Silva</td>\n",
       "      <td>2023-04-13</td>\n",
       "      <td>['People &amp; Blogs']</td>\n",
       "      <td></td>\n",
       "      <td>389.0</td>\n",
       "      <td>https://www.youtube.com/watch?v=GgEUPkAG1ho</td>\n",
       "      <td>2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>ciencia+de+dados</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.285714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>watch?v=U1a_Tp0O1Co</td>\n",
       "      <td>Como Aprender CIÊNCIA DE DADOS do ZERO?</td>\n",
       "      <td>Hashtag Programação</td>\n",
       "      <td>2023-04-10</td>\n",
       "      <td>['Education']</td>\n",
       "      <td>['Como aprender ciência de dados', 'Como apren...</td>\n",
       "      <td>1514.0</td>\n",
       "      <td>https://www.youtube.com/watch?v=U1a_Tp0O1Co</td>\n",
       "      <td>1</td>\n",
       "      <td>173.0</td>\n",
       "      <td>ciencia+de+dados</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.100000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    id                                             titulo  \\\n",
       "0  watch?v=kE9gYQDyVr0  Trabalhando com Bases de Dados (Datasets) Desb...   \n",
       "1  watch?v=GgEUPkAG1ho                  Trabalho ciencia de dados-parte-1   \n",
       "2  watch?v=U1a_Tp0O1Co            Como Aprender CIÊNCIA DE DADOS do ZERO?   \n",
       "\n",
       "                 canal data_upload           categoria  \\\n",
       "0  Hashtag Programação  2023-04-17       ['Education']   \n",
       "1          Jonas Silva  2023-04-13  ['People & Blogs']   \n",
       "2  Hashtag Programação  2023-04-10       ['Education']   \n",
       "\n",
       "                                                tags  duracao_segundos  \\\n",
       "0  ['Bases de dados desbalanceadas', 'Datasets de...            1326.0   \n",
       "1                                                                389.0   \n",
       "2  ['Como aprender ciência de dados', 'Como apren...            1514.0   \n",
       "\n",
       "                                          link  visualizacoes  \\\n",
       "0  https://www.youtube.com/watch?v=kE9gYQDyVr0            858   \n",
       "1  https://www.youtube.com/watch?v=GgEUPkAG1ho              2   \n",
       "2  https://www.youtube.com/watch?v=U1a_Tp0O1Co              1   \n",
       "\n",
       "   quantidade_likes             query  tempo_desde_pub  visualizacoes_por_dia  \n",
       "0              72.0  ciencia+de+dados              3.0             286.000000  \n",
       "1               0.0  ciencia+de+dados              7.0               0.285714  \n",
       "2             173.0  ciencia+de+dados             10.0               0.100000  "
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dia_posterior_atual = str(datetime.date.today() + datetime.timedelta(1)) # para evitar divisões por zero\n",
    "df4['tempo_desde_pub'] = (pd.to_datetime(dia_posterior_atual) - df4['data_upload']) / np.timedelta64(1, 'D')\n",
    "df4['visualizacoes_por_dia'] = df4['visualizacoes'] / df4['tempo_desde_pub']\n",
    "df4.head(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "e14fd2f7",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2023-04-19T21:41:17.810489Z",
     "start_time": "2023-04-19T21:41:16.666764Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<AxesSubplot:>"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAABj0AAALjCAYAAABJfMfcAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjUuMiwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8qNh9FAAAACXBIWXMAAA9hAAAPYQGoP6dpAABpRElEQVR4nOzdeXxcdb0//vckadOFtNCdlhYKlB3ZKQKyKVVQRFERRBFFL1xwQbxwRVxwo19R+XERBRGUqqAiF70ugBSFshQolK0UaCldaZvuTdI2e87vjzbTSZO0TTLtpKfP5+ORR5MzZ858Jvn0ZHJe8/68M0mSJAEAAAAAALCDKyr0AAAAAAAAAPJB6AEAAAAAAKSC0AMAAAAAAEgFoQcAAAAAAJAKQg8AAAAAACAVhB4AAAAAAEAqCD0AAAAAAIBUKCn0ADbV1NQUixYtirKysshkMoUeDgAAAAAAUEBJkkRVVVUMHz48ioo2X8vR7UKPRYsWxciRIws9DAAAAAAAoBtZsGBB7LHHHpvdp9uFHmVlZRGxfvD9+vUr8GgAAAAAAIBCqqysjJEjR2bzg83pdqFH85JW/fr1E3oAAAAAAAAREVvVEkMjcwAAAAAAIBWEHgAAAAAAQCoIPQAAAAAAgFQQegAAAAAAAKkg9AAAAAAAAFJB6AEAAAAAAKSC0AMAAAAAAEgFoQcAAAAAAJAKQg8AAAAAACAVhB4AAAAAAEAqCD0AAAAAAIBUEHoAAAAAAACpIPQAAAAAAABSQegBAAAAAACkgtADAAAAAABIBaEHAAAAAACQCkIPAAAAAAAgFYQeAAAAAABAKgg9AAAAAACAVBB6AAAAAAAAqSD0AAAAAAAAUkHoAQAAAAAApILQAwAAAAAASAWhBwAAAAAAkApCDwAAAAAAIBWEHgAAAAAAQCoIPQAAAAAAgFQQegAAAAAAQIEtq6qNr977ckydt6rQQ9mhCT0AAAAAAKDAvvGXafG/L7wdH7l1cqGHskMTegAAAAAAQIHNXra20ENIBaEHAAAAAACQCkIPAAAAAAAosEym0CNIB6EHAAAAAAAUWCakHvkg9AAAAAAAAFJB6AEAAAAAAKSC0AMAAAAAAEgFoQcAAAAAABSYRub5IfQAAAAAAABSQegBAAAAAACkgtADAAAAAABIBaEHAAAAAACQCkIPAAAAAAAgFYQeAAAAAABQYJlMptBDSAWhBwAAAAAAkApCDwAAAAAAIBWEHgAAAAAAUGAWt8oPoQcAAAAAAJAKQg8AAAAAACAVhB4AAAAAAEAqCD0AAAAAAKDAMpp65IXQAwAAAAAASAWhBwAAAAAAFJhKj/wQegAAAAAAAKkg9AAAAAAAAFJB6AEAAAAAAAWWCetb5YPQAwAAAAAASAWhBwAAAAAAFJhG5vkh9AAAAAAAAFJB6AEAAAAAAKSC0AMAAAAAAEgFoQcAAAAAABSYlh75IfQAAAAAAABSQegBAAAAAACFllHrkQ9CDwAAAAAAIBWEHgAAAAAAQCoIPQAAAAAAoMAsbpUfQg8AAAAAACAVhB4AAAAAAEAqCD0AAAAAAIBUEHoAAAAAAECBZTT1yAuhBwAAAAAAkApCDwAAAAAAKDCFHvkh9AAAAAAAAFJB6AEAAAAAAKSC0AMAAAAAAAoso5N5Xgg9AAAAAACAVBB6AAAAAABAganzyA+hBwAAAAAAkApCDwAAAAAAIBWEHgAAAAAAQCoIPQAAAAAAoMAymnrkhdADAAAAAABIBaEHAAAAAACQCkIPAAAAAAAgFYQeAAAAAABQYJnQ1CMfhB4AAAAAAFBoMo+8EHoAAAAAAACpIPQAAAAAAABSQegBAAAAAACkgtADAAAAAAAKTEuP/BB6AAAAAAAAqSD0AAAAAAAAUkHoAQAAAAAApILQAwAAAAAACiyjqUdeCD0AAAAAAIBUEHoAAAAAAECBZUKpRz4IPQAAAAAAgFQQegAAAAAAAKkg9AAAAAAAgALTyDw/hB4AAAAAAEAqCD0AAAAAAKDAVHrkh9ADAAAAAABIBaEHAAAAAACQCkIPAAAAAAAgFYQeAAAAAABQYJnQ1CMfhB4AAAAAAFBgGpnnh9ADAAAAAABIBaEHAAAAAACQCkIPAAAAAAAgFYQeAAAAAABAKgg9AAAAAACAVBB6AAAAAAAAqdCh0KOhoSG+8Y1vxOjRo6N3796x9957x3e/+91oamrK7pMkSVx33XUxfPjw6N27d5xyyikxffr0vA8cAAAAAAAgV4dCjx/+8Idx2223xS233BKvv/563HDDDfGjH/0ofvrTn2b3ueGGG+LGG2+MW265JZ577rkYNmxYnH766VFVVZX3wQMAAAAAQBpkMplCDyEVOhR6PP3003H22WfH+9///thrr73iox/9aIwbNy6ef/75iFhf5XHTTTfFtddeG+ecc04ccsghMWHChFi3bl3cc8892+QJAAAAAAAARHQw9DjxxBPjX//6V8ycOTMiIl5++eV48skn48wzz4yIiDlz5kR5eXmMGzcue5/S0tI4+eSTY/LkyW0es7a2NiorK1t8AAAAAADAzkSdR36UdGTn//7v/46Kioo44IADori4OBobG+MHP/hBnH/++RERUV5eHhERQ4cObXG/oUOHxrx589o85vjx4+M73/lOZ8YOAAAAAACQ1aFKjz/+8Y/xu9/9Lu6555544YUXYsKECfHjH/84JkyY0GK/TdceS5Kk3fXIrrnmmqioqMh+LFiwoINPAQAAAAAAoIOVHldddVV87Wtfi/POOy8iIg499NCYN29ejB8/Pj796U/HsGHDImJ9xcfuu++evd/SpUtbVX80Ky0tjdLS0s6OHwAAAAAAdnj6mOdHhyo91q1bF0VFLe9SXFwcTU1NERExevToGDZsWEycODF7e11dXUyaNCmOP/74PAwXAAAAAACgbR2q9DjrrLPiBz/4QYwaNSoOPvjgePHFF+PGG2+Mz372sxGxflmrK664Iq6//voYM2ZMjBkzJq6//vro06dPfOITn9gmTwAAAAAAAHZ0Cj3yo0Ohx09/+tP45je/GZdddlksXbo0hg8fHpdcckl861vfyu5z9dVXR3V1dVx22WWxatWqGDt2bDz88MNRVlaW98EDAAAAAAA0yyRJkhR6ELkqKyujf//+UVFREf369Sv0cAAAAAAAYJv7zK+nxKMzlkVExNz/9/4Cj6Z76Uhu0KGeHgAAAAAAAN2V0AMAAAAAAAosk9HVIx+EHgAAAAAAQCoIPQAAAAAAoMDUeeSH0AMAAAAAAEgFoQcAAAAAAJAKQg8AAAAAACgwfczzQ+gBAAAAAACkgtADAAAAAABIBaEHAAAAAACQCkIPAAAAAAAoOE098kHoAQAAAAAApILQAwAAAAAACiyj0CMvhB4AAAAAAEAqCD0AAAAAAIBUEHoAAAAAAECBWd0qP4QeAAAAAABAKgg9AAAAAACAVBB6AAAAAAAAqSD0AAAAAACAAsto6pEXQg8AAAAAACAVhB4AAAAAAFBgmVDqkQ9CDwAAAAAAIBWEHgAAAAAAQCoIPQAAAAAAoMA0Ms8PoQcAAAAAAJAKQg8AAAAAACgwlR75IfQAAAAAAABSQegBAAAAAACkgtADAAAAAABIBaEHAAAAAAAUWCY09cgHoQcAAAAAAJAKQg8AAAAAACAVhB4AAAAAAEAqCD0AAAAAAKDQtPTIC6EHAAAAAAAUmMwjP4QeAAAAAABAKgg9AAAAAACAVBB6AAAAAAAAqSD0AAAAAACAAstkdPXIB6EHAAAAAACQCkIPAAAAAAAoMHUe+SH0AAAAAAAAUkHoAQAAAAAApILQAwAAAAAACkwf8/wQegAAAAAAAKkg9AAAAAAAgAJT6JEfQg8AAAAAACAVhB4AAAAAAEAqCD0AAAAAAIBUEHoAAAAAAECBZTK6euSD0AMAAAAAAEgFoQcAAAAAAJAKQg8AAAAAACAVhB4AAAAAAFBgOnrkh9ADAAAAAAAKTeqRF0IPAAAAAAAgFYQeAAAAAABAKgg9AAAAAACAVBB6AAAAAABAgWU09cgLoQcAAAAAAHQjSZIUegg7LKEHAAAAAACQCkIPAAAAAADoRhR6dJ7QAwAAAAAACiyjpUdeCD0AAAAAAKAbUejReUIPAAAAAAAosNxCD43MO0/oAQAAAAAApILQAwAAAAAAuhF1Hp0n9AAAAAAAgALTyDw/hB4AAAAAANCNaOnReUIPAAAAAAAosEwo9cgHoQcAAAAAAHQjia4enSb0AAAAAAAAUkHoAQAAAAAA3YieHp0n9AAAAAAAgALLaOmRF0IPAAAAAAAgFYQeAAAAAABQYLmVHpa36jyhBwAAAAAAkApCDwAAAAAA6EaSUOrRWUIPAAAAAAAoOJ3M80HoAQAAAAAA3YieHp0n9AAAAAAAAFJB6AEAAAAAAN2IQo/OE3oAAAAAAECBZbT0yAuhBwAAAAAAdCOJph6dJvQAAAAAAIACyy30EHl0ntADAAAAAABIBaEHAAAAAAAUWG5Pj2INPjpN6AEAAAAAAAXWo3j95frLTtkn+paWFHg0Oy6hBwAAAAAAkApCDwAAAAAA6CasbNU1Qg8AAAAAACiwJCn0CNJB6AEAAAAAAKSC0AMAAAAAAEgFoQcAAAAAAHQTmdDUoyuEHgAAAAAAQCoIPQAAAAAAgFQQegAAAAAAAKkg9AAAAAAAAFJB6AEAAAAAAN1ERh/zLhF6AAAAAABAgSVJUughpILQAwAAAAAASAWhBwAAAAAAkApCDwAAAAAAIBWEHgAAAAAA0E3oY941Qg8AAAAAACgwbczzQ+gBAAAAAACkgtADAAAAAABIBaEHAAAAAACQCkIPAAAAAADoLjJamXeF0AMAAAAAAAos0ck8L4QeAAAAAABAKgg9AAAAAACAVBB6AAAAAAAAqSD0AAAAAACAbkIb864RegAAAAAAQIEloZN5Pgg9AAAAAACAVBB6AAAAAAAAqSD0AAAAAAAAUkHoAQAAAAAA3URGJ/MuEXoAAAAAAECBJfqY54XQAwAAAAAASAWhBwAAAAAAkAodDj0WLlwYn/zkJ2PgwIHRp0+fOPzww2Pq1KnZ25Mkieuuuy6GDx8evXv3jlNOOSWmT5+e10EDAAAAAABsqkOhx6pVq+KEE06IHj16xIMPPhivvfZa/OQnP4ldd901u88NN9wQN954Y9xyyy3x3HPPxbBhw+L000+PqqqqfI8dAAAAAABSJRM6mXdFSUd2/uEPfxgjR46MX//619lte+21V/bzJEnipptuimuvvTbOOeeciIiYMGFCDB06NO6555645JJL8jNqAAAAAABIEX3M86NDlR5//etf4+ijj46PfexjMWTIkDjiiCPil7/8Zfb2OXPmRHl5eYwbNy67rbS0NE4++eSYPHlym8esra2NysrKFh8AAAAAAAAd1aHQY/bs2XHrrbfGmDFj4p///Gdceuml8aUvfSl+85vfREREeXl5REQMHTq0xf2GDh2avW1T48ePj/79+2c/Ro4c2ZnnAQAAAAAA7OQ6FHo0NTXFkUceGddff30cccQRcckll8TnP//5uPXWW1vsl8m0XHMsSZJW25pdc801UVFRkf1YsGBBB58CAAAAAACkQzuX0tlKHQo9dt999zjooINabDvwwANj/vz5ERExbNiwiIhWVR1Lly5tVf3RrLS0NPr169fiAwAAAAAAoKM6FHqccMIJMWPGjBbbZs6cGXvuuWdERIwePTqGDRsWEydOzN5eV1cXkyZNiuOPPz4PwwUAAAAAgPRJdDLPi5KO7PyVr3wljj/++Lj++uvj3HPPjSlTpsTtt98et99+e0SsX9bqiiuuiOuvvz7GjBkTY8aMieuvvz769OkTn/jEJ7bJEwAAAAAAAIjoYOhxzDHHxJ///Oe45ppr4rvf/W6MHj06brrpprjggguy+1x99dVRXV0dl112WaxatSrGjh0bDz/8cJSVleV98AAAAAAAAM0ySdK9imYqKyujf//+UVFRob8HAAAAAAA7hWvunxa/nzI/vnr6fvHFd48p9HC6lY7kBh3q6QEAAAAAAGwL3ao+YYcl9AAAAAAAAFJB6AEAAAAAAKSC0AMAAAAAAEgFoQcAAAAAAHQTmUyhR7BjE3oAAAAAAECBJfqY54XQAwAAAAAASAWhBwAAAAAAkApCDwAAAAAAIBWEHgAAAAAA0E1kdDLvEqEHAAAAAAAUmEbm+SH0AAAAAAAAUkHoAQAAAAAApILQAwAAAAAASAWhBwAAAAAAkApCDwAAAAAAKLAkdDLPB6EHAAAAAACQCkIPAAAAAAAgFYQeAAAAAABAKgg9AAAAAACgm8hkCj2CHZvQAwAAAAAACizRxzwvhB4AAAAAAEAqCD0AAAAAAIBUEHoAAAAAAEA3kQlNPbpC6AEAAAAAAKSC0AMAAAAAAApMH/P8EHoAAAAAAACpIPQAAAAAAABSQegBAAAAAADdREYf8y4RegAAAAAAAKkg9AAAAAAAgAJLdDLPC6EHAAAAAACQCkIPAAAAAAAgFYQeAAAAAADQTehj3jVCDwAAAAAAIBWEHgAAAAAAUGBJ6GSeD0IPAAAAAAAgFYQeAAAAAABAKgg9AAAAAACgm8joZN4lQg8AAAAAACAVhB4AAAAAAFBo+pjnhdADAAAAAABIBaEHAAAAAACQCkIPAAAAAADoJjKhk3lXCD0AAAAAAKDAtPTID6EHAAAAAACQCkIPAAAAAAAgFYQeAAAAAABAKgg9AAAAAACgm8joY94lQg8AAAAAACiwJNHKPB+EHgAAAAAAQCoIPQAAAAAAgFQQegAAAAAAAKkg9AAAAAAAAFJB6AEAAAAAAAWmjXl+CD0AAAAAAIBUEHoAAAAAAACpIPQAAAAAAIBuIpPJFHoIOzShBwAAAAAAkApCDwAAAAAAKLBEJ/O8EHoAAAAAAACpIPQAAAAAAABSQegBAAAAAADdhDbmXSP0AAAAAAAAUkHoAQAAAAAABaaPeX4IPQAAAAAAgFQQegAAAAAAAKkg9AAAAAAAgG4io5N5lwg9AAAAAACAVBB6AAAAAABAgSWJVub5IPQAAAAAAABSQegBAAAAAACkgtADAAAAAAC6CX3Mu0boAQAAAAAApILQAwAAAAAACkwb8/wQegAAAAAAAKkg9AAAAAAAAFJB6AEAAAAAAN1EJqOVeVcIPQAAAAAAgFQQegAAAAAAQKHpZJ4XQg8AAAAAACAVhB4AAAAAANBNaOnRNUIPAAAAAAAgFYQeAAAAAABAKgg9AAAAAACgwBKdzPNC6AEAAAAAAKSC0AMAAAAAALoJfcy7RugBAAAAAACkgtADAAAAAAAKLNHSIy+EHgAAAAAAQCoIPQAAAAAAgFQQegAAAAAAQHeR0cq8K4QeAAAAAABAKgg9AAAAAACgwDQyzw+hBwAAAAAAkApCDwAAAAAAIBWEHgAAAAAA0E1oY941Qg8AAAAAACAVhB4AAAAAAFBgSehkng9CDwAAAAAAIBWEHgAAAAAAQCoIPQAAAAAAoJvI6GTeJUIPAAAAAAAgFYQeAAAAAABQYIk+5nkh9AAAAAAAAFJB6AEAAAAAAKSC0AMAAAAAALqJTOhk3hVCDwAAAAAAIBWEHgAAAAAAUGD6mOeH0AMAAAAAAEgFoQcAAAAAAHQTGS09ukToAQAAAAAApILQAwAAAAAASAWhBwAAAAAAFFiik3leCD0AAAAAAIBUEHoAAAAAAEA3oY951wg9AAAAAACAVBB6AAAAAAAAqSD0AAAAAACAgtPJPB+EHgAAAAAAQCoIPQAAAAAAoJvI6GTeJUIPAAAAAAAgFYQeAAAAAABAKgg9AAAAAACgwBJ9zPOiS6HH+PHjI5PJxBVXXJHdliRJXHfddTF8+PDo3bt3nHLKKTF9+vSujhMAAAAAAGCzOh16PPfcc3H77bfHO97xjhbbb7jhhrjxxhvjlltuieeeey6GDRsWp59+elRVVXV5sAAAAAAAkGaZ0Mm8KzoVeqxZsyYuuOCC+OUvfxm77bZbdnuSJHHTTTfFtddeG+ecc04ccsghMWHChFi3bl3cc889bR6rtrY2KisrW3wAAAAAAAB0VKdCj8svvzze//73x3ve854W2+fMmRPl5eUxbty47LbS0tI4+eSTY/LkyW0ea/z48dG/f//sx8iRIzszJAAAAAAAYCfX4dDjD3/4Q7zwwgsxfvz4VreVl5dHRMTQoUNbbB86dGj2tk1dc801UVFRkf1YsGBBR4cEAAAAAAA7NH3M86OkIzsvWLAgvvzlL8fDDz8cvXr1ane/TKblmmNJkrTa1qy0tDRKS0s7MgwAAAAAAIBWOlTpMXXq1Fi6dGkcddRRUVJSEiUlJTFp0qS4+eabo6SkJFvhsWlVx9KlS1tVfwAAAAAAAJvQx7xLOhR6vPvd745p06bFSy+9lP04+uij44ILLoiXXnop9t577xg2bFhMnDgxe5+6urqYNGlSHH/88XkfPAAAAAAAQLMOLW9VVlYWhxxySIttffv2jYEDB2a3X3HFFXH99dfHmDFjYsyYMXH99ddHnz594hOf+ET+Rg0AAAAAACmSJLp65EOHQo+tcfXVV0d1dXVcdtllsWrVqhg7dmw8/PDDUVZWlu+HAgAAAAAAyOpy6PHYY4+1+DqTycR1110X1113XVcPDQAAAAAAsNU61NMDAAAAAADYdvQx7xqhBwAAAAAAkApCDwAAAAAAKDBtzPND6AEAAAAAAKSC0AMAAAAAALqJTEZXj64QegAAAAAAAKkg9AAAAAAAAFJB6AEAAAAAAAWW6GSeF0IPAAAAAAAgFYQeAAAAAADQTWhj3jVCDwAAAAAAIBWEHgAAAAAAQCoIPQAAAAAAoMD0Mc8PoQcAAAAAAJAKQg8AAAAAAOgmMjqZd4nQAwAAAAAASAWhBwAAAAAAkApCDwAAAAAAKLAk0co8H4QeAAAAAABAKgg9AAAAAACgm9DIvGuEHgAAAAAAQCoIPQAAAAAAgFQQegAAAAAAAKkg9AAAAAAAAFJB6AEAAAAAAN1EJnQy7wqhBwAAAAAAkApCDwAAAAAAIBWEHgAAAAAAUGBJUugRpIPQAwAAAAAASAWhBwAAAAAAdBMZfcy7ROgBAAAAAACkgtADAAAAAABIBaEHAAAAAAAUWBI6meeD0AMAAAAAAEgFoQcAAAAAAJAKQg8AAAAAACAVhB4AAAAAAEAqCD0AAAAAAKDAEn3M80LoAQAAAAAA3UQmkyn0EHZoQg8AAAAAACAVhB4AAAAAAEAqCD0AAAAAAKDA9PTID6EHAAAAAACQCkIPAAAAAADoJrQx7xqhBwAAAAAAkApCDwAAAAAAIBWEHgAAAAAAUGBJ6GSeD0IPAAAAAAAgFYQeAAAAAADQTWR0Mu8SoQcAAAAAAJAKQg8AAAAAACAVhB4AAAAAAFBgiT7meSH0AAAAAAAAUkHoAQAAAAAA3UQmdDLvCqEHAAAAAACQCkIPAAAAAAAgFYQeAAAAAABQYPqY54fQAwAAAAAASAWhBwAAAAAAdBMZfcy7ROgBAAAAAACkgtADAAAAAABIBaEHAAAAAAAUmk7meSH0AAAAAAAAUkHoAQAAAAAA3YQ+5l0j9AAAAAAAAFJB6AEAAAAAAKSC0AMAAAAAAAos0ck8L4QeAAAAAADQTWQ09egSoQcAAAAAAJAKQg8AAAAAACAVhB4AAAAAAEAqCD0AAAAAAKDAEn3M80LoAQAAAAAA3YZO5l0h9AAAAAAAAFJB6AEAAAAAAKSC0AMAAAAAAEgFoQcAAAAAABSYPub5IfQAAAAAAIBuIqOPeZcIPQAAAAAAgFQQegAAAAAAAKkg9AAAAAAAAFJB6AEAAAAAAAWWJFqZ54PQAwAAAAAAugl9zLtG6AEAAAAAAKSC0AMAAAAAAEgFoQcAAAAAABSYjh75IfQAAAAAAABSQegBAAAAAADdRCajlXlXCD0AAAAAAIBUEHoAAAAAAACpIPQAAAAAAIACS3QyzwuhBwAAAAAAkApCDwAAAAAA6Ca0Me8aoQcAAAAAAJAKQg8AAAAAACAVhB4AAAAAAFBg+pjnh9ADAAAAAAC6iYymHl0i9AAAAAAAAFJB6AEAAAAAAKSC0AMAAAAAAEgFoQcAAAAAABRaopV5Pgg9AAAAAACgm9DIvGuEHgAAAAAAQCoIPQAAAAAAgFQQegAAAAAAAKkg9AAAAAAAgALTxjw/hB4AAAAAANBNZEIn864QegAAAAAAAKkg9AAAAAAAAFJB6AEAAAAAAKSC0AMAAAAAAAos0ck8L4QeAAAAAADQXehj3iVCDwAAAAAAIBWEHgAAAAAAQCoIPQAAAAAAgFQQegAAAAAAQIEloZN5Pgg9AAAAAACgm9DHvGuEHgAAAAAAQCoIPQAAAAAAgFQQegAAAAAAAKkg9AAAAAAAgAJL9DHPC6EHAAAAAAAUWHPokcloZd4VQg8AAAAAACiw5kIPkUfXdCj0GD9+fBxzzDFRVlYWQ4YMiQ996EMxY8aMFvskSRLXXXddDB8+PHr37h2nnHJKTJ8+Pa+DBgAAAACANEk2lHoo9OiaDoUekyZNissvvzyeeeaZmDhxYjQ0NMS4ceNi7dq12X1uuOGGuPHGG+OWW26J5557LoYNGxann356VFVV5X3wAAAAAACQJhm1Hl1S0pGdH3rooRZf//rXv44hQ4bE1KlT46STTookSeKmm26Ka6+9Ns4555yIiJgwYUIMHTo07rnnnrjkkkvyN3IAAAAAAEiJjT09CjuOHV2XenpUVFRERMSAAQMiImLOnDlRXl4e48aNy+5TWloaJ598ckyePLnNY9TW1kZlZWWLDwAAAAAA2JkkG7p6yDy6ptOhR5IkceWVV8aJJ54YhxxySERElJeXR0TE0KFDW+w7dOjQ7G2bGj9+fPTv3z/7MXLkyM4OCQAAAAAAdkiJTuZ50enQ4wtf+EK88sor8fvf/77VbZlN6m+SJGm1rdk111wTFRUV2Y8FCxZ0dkgAAAAAALBD2ph5SD26okM9PZp98YtfjL/+9a/x+OOPxx577JHdPmzYsIhYX/Gx++67Z7cvXbq0VfVHs9LS0igtLe3MMAAAAAAAIBWSDaUeenp0TYcqPZIkiS984Qtx//33x7///e8YPXp0i9tHjx4dw4YNi4kTJ2a31dXVxaRJk+L444/Pz4gBAAAAACBlrG6VHx2q9Lj88svjnnvuif/7v/+LsrKybJ+O/v37R+/evSOTycQVV1wR119/fYwZMybGjBkT119/ffTp0yc+8YlPbJMnAAAAAAAAO7wNqUd7rSLYOh0KPW699daIiDjllFNabP/1r38dF110UUREXH311VFdXR2XXXZZrFq1KsaOHRsPP/xwlJWV5WXAAAAAAAAAbelQ6JFk28e3L5PJxHXXXRfXXXddZ8cEAAAAAAA7lezyVgo9uqRDPT0AAAAAAID8yzYyL/A4dnRCDwAAAAAAKDCVHvkh9AAAAAAAgALb2F1C6tEVQg8AAAAAACiwZEOth0qPrhF6AAAAAABAgTVXesg8ukboAQAAAAAABZYNPZR6dInQAwAAAAAAugmRR9cIPQAAAAAAoMCSRE+PfBB6AAAAAABAgW1Y3Soyaj26ROgBAAAAAAAFtrGnR2HHsaMTegAAAAAAQIEl2VoPukLoAQAAAAAABZbIPPJC6AEAAAAAAAWW7elheasuEXoAAAAAAEA3oZF51wg9AAAAAACgwDQyzw+hBwAAAAAAFNz61EPo0TVCDwAAAAAAKLBspYflrbpE6AEAAAAAAAWmkXl+CD0AAAAAAKDAkg2lHjKPrhF6AAAAAABAgan0yA+hBwAAAAAAFFhzTw+1Hl0j9AAAAAAAgALLLm8l8+gSoQcAAAAAABRYdnmrgo5ixyf0AAAAAACAQku2vAtbJvQAAAAAAIAC29jIXK1HVwg9AAAAAACgwLI9PQo8jh2d0AMAAAAAAApsY6VHQYexwxN6AAAAAABAN5FR69ElQg8AAAAAACiwDatbqfToIqEHAAAAAAAUWJJd4IquEHoAAAAAAECBqfTID6EHAAAAAAAU2MZG5lKPrhB6AAAAAABAoTVXehR2FDs8oQcAAAAAABRYc08PhR5dI/QAAAAAAIACy/b0UOvRJUIPAAAAAAAosI09PQo6jB2e0AMAAAAAAAosaS71oEuEHgAAAAAAUGDZSo+CjmLHJ/QAAAAAAIACS6QeeSH0AAAAAACAbkIj864RegAAAAAAQAHl9vPQyLxrhB4AAAAAANBNyDy6RugBAAAAAAAFlFPoERmlHl0i9AAAAAAAgALKyTxUenSR0AMAAAAAAApIT4/8EXoAAAAAAEAnzF62Jh56dXGXj9Oy0kPq0RVCDwAAAAAA6ITTfjIpLv3dC/H4zGVdOk5ifau8EXoAAAAAAEAXvLxgdZfun4TlrfJF6AEAAAAAAF2QbHmXzd+/qwcgS+gBAAAAAADdhEKPrhF6AAAAAABAAeVWemSsb9UlQg8AAAAAAOiCri5P1aKnRxfHsrMTegAAAAAAQBteXVgRV/zhxVi4ujrmrVgbV/zhxXijvLLNfZ94c1lcee9LUVFd36HHmDRzWXz13pezXyv06JqSQg8AAAAAAAC6ow/89MmIiJi/cl2sXlcfs5evjYmvLYnp331fq30/deeUiIgY2LdnXPv+g7b6MT79qyktvs6o9egSoQcAAAAAAGzGrKVrorKmISIi1tY1tro9d3mqJZW1XXoslR5dY3krAAAAAADYjI40F+/do3gbjoQtEXoAAAAAAMBmdKT6olePrl12V+nRNUIPAAAAAADYjC3lEE0bV7eKXj27Vumhp0fXCD0AAAAAAGAztrS8VU39xj4fzctbJUnS3u5beKxO3Y0NhB4AAAAAALAZW8ohqmrqs5/3KC6K+194O4783sSYOm9l3h+LzRN6AAAAAABAF1TXbaz0aGxK4sp7X45V6+rjkt++0OFjdaRpOq0JPQAAAAAAYDO2lEPU5zT1aGhsyn5e19DY1u5sQ0IPAAAAAADYrM2nHrlBR24A0tjU8b4e6jy6RugBAAAAAABd0NDYdqVHQ2dCD6lHlwg9AAAAAABgM7YURNTlVnrkBCBNSWdCD6lHVwg9AAAAAADYaS2prIkFK9e12NbQ2BSvvL06+3VuDFHURibRotKjqWWlxxvllbGmtqHF/k1NSUx7uyKWVtZ0aey0VlLoAQAAAAAAQCEkSRJjr/9XRERMu25clPXqERER3//H63HX5Llt3qekqHUtQYugIycASZKI9930RIzYtXc89bXTsttve/ytuOGhGa2Oo8ij61R6AAAAAACwU8rtubEkp+pi08AjN4xoI/OIupygI3d5q2YLV1e3+Pr2x2e3OR6ZR9cJPQAAAAAA2CnlVmVsrpdGJieOKG5jv/qGjZUejTlVH+0pauex9PPoOqEHAAAAAAA7pfqcgKK9ICJi00qP1vvlLm9V37Tl5uXthh5bvCdbIvQAAAAAAGCnlFvpkZtl9ChuP34oaSP0yF3SqqFxayo92t6u0KPrhB4AAAAAAOyUcis0kpwCjV49ilvsl5tFFG9o6pEkuX082m5k3p7idlKPjFqPLisp9AAAAAAAAKAQfjN5Xvbzxg0hxozyqqiqaWixX26vjeVrauOn/3ozPn7MyOy23KDjX28sbfOxyitqYkllTfxj2uJYXFHT5j4yj64TegAAAAAAsNN5acHquOXRWdmvmzb04njvTY9v8b4/mTgznpi1PPt1/VYsaXXRr6dERXV9+4FHyDzyQegBAAAAAMBOZ9Hq6hZfNyZbXpYq15Q5K7Ofb03o8UZ5VYeOT+fo6QEAAAAAwE5n06qKxqb2Q4/N3RbRspF5V2hk3nVCDwAAAAAAdjqbBgxNmynW2FIlR8Pm7twBGpl3ndADAAAAAICdTmaT1GNzy1ttKfRQ6dF9CD0AAAAAANjpFG0aenRheat8achTeLIzE3oAAAAAALBTuOb+V+Kbf3k1IiKSTSo7mjZX6bGdQo+6rWiIzuYJPQAAAAAASL1lVbXx+ykL4rfPzIuqmvpo2CTI2Fw1x5aWt6L7EHoAAAAAAJB6uaFGU9I6yGjaTOixmSIQuhmhBwAAAAAAqdeihUcSUdewSeiRtF7yih2P0AMAAAAAgNRrmXkkUb9J0/DGJGm15BU7HqEHAAAAAAA7lcampM3lrTat/mDHI/QAAAAAACC1qmrqI2L98lXNGpPWoUd1fWOsqW3o0mP1LHbJvdBKCj0AAAAAAADYFn77zLz45l9ejf93zqFx0n6Ds9ubmiLqNgk9Lrv7hS4/XmlJUavjsn2JnQAAAAAASKVv/uXViIj42v3TojGn1KMxSaK+If/9O3qWuOReaH4CAAAAAACkXpKTcTS10dMjH4QehecnAAAAAABA6jXmpB5tNTLPh1KhR8H5CQAAAAAAkHpNScvlrbZF743SkuK8H5OOEXoAAAAAAJB6TTk9PbbV8lalPVxyLzQ/AQAAAAAAuqW5y9fG4zOXtXt7U1MSE19bEgtXV8ffXl4U97/wdtTUN7a575S5K7Ofb6tG5pa3KrySQg8AAAAAAADacsqPH4uIiPsvOz6OHLVbq9v/7+WF8ZU/vtxi29q6xvjUcXu22vfaP7+a/byxKYn6JstbpZHYCQAAAACAbu2VBavb3P74zOWtti2trNni8ZqaIuobt2+lx+Ejd83749Ga0AMAAAAAgB1SUSbTaltdw5YrONYvb7Vte3psGoA0bIPKEloTegAAAAAAsEMqap15RO3WhB7bqpF5zvJWfUtbdpdo2AaVJbQm9AAAAAAAYIfUVqXH1oQeTUkSddsk9Nh4yb13j5b9PbbF49Ga0AMAAAAAgB1SURulHlu1vFVOpUfP4vxdJs8NPfr0bBl6qPTYPoQeAAAAAECH3P/C23HDQ29EkrR9EfepWcvjG3+ZFtV1jdt5ZN1Txbr6uOb+afHs7BXb5Ph1DU3x7f97NR59Y+lW7d/YlMR3//ZaPPTq4k4/5v+9tDDGP/h6u3Mg35KI+NE/34j7pr7dYvvvp8xvtW9tQ2MsXF0d/33fK+0e77zbn4lnZq+MiJZ9OLqqNKe6Y9PQY/7KdXl7HNpXsuVdAAAAAAA2uvLelyMi4qT9Bsdxew9sdfsFdzwbERED+pbGlafvt13H1h09OmNp/H7K/Ji5pCr+9z+Pz/vxfz9lfkx4el5MeHpezP1/79/i/n9/ZVH86qk58aun5mzV/m358h9eioiId+07OE4cM6hTx+iIlxesjr+8tCgiIj561B4RETF72Zo2961raIpLfvt8vLqwcquO3adncVTVNORlnEPKSrOf994k9GD7EHoAAAAAAJ2ycm3dZm9f4J3tERFRXb++4mX6oopoaGyKkjwupxQRsbiipkP7L1+z+Z9bR6xYW5u3Y23OupyqocamJIqLMlHZTlBR19i01YFHRMRufXrGksrWz2NYv15RXtn297YoE9GUbNzvJ+ceFr16FMfSnP379HT5vRAsbwUAAAAAdErTdlraaEfXsKF3RE19U7y1bG3ej9+juHVfi3zuv6nttqRVzuP0ylk2ak3t+rCjsantcdTWd6xh+MBdera5fbe+bW+PiOibE2gUF2XihH0HxVF77taix4hKj8IQegAAAAAAndLeRWdaqs9pYP3K26vzfvziNpp553P/TdVuRaPwfMidX7lDbg492gvd6ho7Nr6y0h5tbt/ct6lP6cZAIzecKc5svFOfHkKPQhB6AAAAAABbrSnnQrRCj63T0LTxIvy0hRV5P36PDi6X1aNo4/71HQwIIiJq6jcuNbUt50BDzlzL/byqpj4i1vfuaEttQ2Ob29vTs6Tt719mM6FH39KNlR6NuaFHTlKyaSNztg+hBwAAAACw1epzLuCr9Ng6LSs98h96lORcaN+an0lJzvJWuQHG1qrOuU9nQpOtlVvJ0dCYG3qsr/Sormt77O2FIe1pLzTKRPupxy45oUfut7zl8lZ6ehSC0AMAAAAK5CcPz4iTf/RoLKvaPk1ggbY9P3dlvHP8v+Ifrywu9FC6nQUr18VpP34sfvfMvOy23IvPjXl8m/9jM5bGO8f/K558c3nejtld5H7PXltcmbeg4IFpi+Od4/8Vr+RUj2xNiJFbjVDdzv5Lq2ripBsejZv/9War23LDhrYe7+t/nhZn/M8TnQpUcrWs9Nj4PfvYbU/HXl/7R9z97Ly27tbh0KNnSdvhxmaXt8qp4sitfmqxvJVKj4IQegAAAECBPPRqecxbsS6enLWs0EOBndoXf/9iLK6oicvveaHQQ+l2Hpi2OGYvXxv3PDs/uy33An4+G1pf9OvnYnFFTXzyzmfzdszuIveCfV1DU7y5ZE1ejnvZ3S/E4oqaFoFdeyFGrtzKk5q6tgOCX0yaHfNXrosbJ85sdVvuY7T1ePc8Oz9eX1wZj83o2u+3xpxx1jW2nmuPtnP8jvYcuWDsnrFrn9Z9Pb79wYMjIuLU/Qdnt+07ZJfoWVwU3/rAwXHYyF0jIuKU/Ydkb88NSnKrQXK97+Bh8f5Dd+/QGNl66msAAACgQJovyrxRXlXgkcDObWsuEu+sZmw4P81atiYaGpuipLhok+WtCjWyHUv9Jhfspy1cHQcN77dNHqu9JZ9yNeT84Nqb/5ur0si9rXqT0KRF1UMXG6bnVhLVdyDI6Gilx6iBfWLK198Ttzw6q0Vly5GjdouZ3z8j3iivzAYsX3vfAfGu/QZFaUlx3P+fx8fKtXUxaJee2fvkLm/Vr3frIOXiE0fHN95/YERE/H+Nh8ffX1kUV977cofGy+ap9AAAAIACab4oM1PoAQXVs4NNoHcmM5asPz/VNTTF3BXrIqJlpUddBxtG76waNkmHtkVfj2Zb08S7PieY6MwSVDX1G59PzSaPt6auIft5ew3Ct1Zuf5KONCdv7vmxtXbpWbJ+rG1ULvUsKYqinCWrepQURWnJ+mWriosyMbisNDI5t+cGPT2KW4c+A3fpGZlMJjKZTPTMORb544wOAAAABVK34SLYzDwtcwJ0TlcvzKZVQ2NTvLl04/mpueojtx9FnVKPrdLcm2KvgX0iImLawm0XemxaedHmeLai0iNX0ybN0XOrSTatLMkNHLpW59Gyp0du0LIlHZ2XzdUZ7fWA31KQ0eJYOQFI7ufNNg052tiFLnJGBwAAgAKp3XChaeHq6qisqS/waGDnVZoTemx6cXdnNm/luhbLBDVXfeReiK7twIXonVlzT48jR+0WERFvLK7q8BJMW2trQozcCoqt2X/dJvvk3mfTSpE1OaFHV59jUycrPToribb//+eGF1uqDMsNSEraWN5r05BV5pF/enoAAKTE0qqaKMpkYtAupYUeCuxwkiSJN5euiVED+kSvHpYYYNuprKmPJRU1MWZoWUS0fCfqm0uq4qg9BxRqaB1SVVMf6+oaY2i/Xnk97sLV1VHWqyT69Wq9BvqOprKmPhatro59B+8SJdtg6aSa+sZYUlkTew7sG3UNTbFodXXsNahvp483b8XaGNqvVyxaXR0jB/SJHjljbmxK4q1la2LMkF0ik8nE0qqa6FFUFLv17dnqOEsra6JHcdu3dQd1DU3xwvxVLZZnimjZb2F1dX0M2DD+5WtqIxMRA3cpjYp19VFVWx977Lb+nfpLq2oiIqJ/7x7x4vzV0dCYxKF79I/ioky8smB1NCURI3brHaM3+bnUNjTGvBXrst/Pjoz9xfmrWvWGaLb/sLIYXFYaq9bWRW1DUwzrv/H/5+xla2L4rr2zv+OWr6mNiNjs68byipp4+q0VLbbNKK+MiIjGppaVHvM3LHvVp7Q4Bu1Sutnm5qvX1cWa2obs97GuoSleebt1f4vV6+rirWVr4rA9du3y/6EkSWLW0jWx58C+W6zqWb2uLiqq62PPgZ37/7RybV3UbfL9T5IkZpavr5gZPahv9O/dIyqq62PmkqoYuVufeHVRRRw8vF/s2mfj/5vFFdXRo7go5q9cF717FMeBu7fu/9He93lxRXUsXF0dI3btnd22am1dTF9Umf16Vk4FT3VdY8wor4p9h+ySvWA/b8XaWF29MYyvqqnPNuVeU9sQT81avvH+9ZtWemy8X11jU6ytbYiVa+ti5IA+Lc5dERHr6hritUWVMWpgnxhS1isq1tXHuvqG2L3/+rHnBmxvLVvb5vPNp/ambu4U7LGl0KOdpa6alW5y/46cB9g6Qg8AgBSYtXRNfPhnT0XvnsXx1NdO2+ILcWCjmvrG+Pqfp8X9LyyMc4/eI2746GGFHhIpkyRJTJ23Kn4/ZUH8Y9qiqKlviv857/A46x3DW1y8fKN8xwg93lxSFef+4umorm+M//3P4+Pg4f27fMzqusb44UNvxF2T58YBw8riH196V5eb325vFevqY8rclfHs7BXx7JyVMX1RRTQlEd/6wEHx2RNH5/Wx6hub4txfPB3TFlbEI1eeHL96ck7c/ez8+ON/HBdj9x7Y4eM9/daKOP+Xz8TIAb1jwcrq+M9T9on/ft8B2du//ddX43fPzI9vfuCg+PgxI+N9Nz0Ru/buEY9ceXKLhr2r19XFuJsej4F9e8YjV57cLS/kfe/vr8Vvn5m32X2Wr6mNAX17Rk19Y5z10ycjImLSVafGyT9+NFavq49nv/7u2K1Pzzj2B/+KiIhzjhwR97+wMCIiDtq9XwzcpWc88eb6C8IlRZl49L9OiZED+mSPf+UfX45/TFsct3/qqBh38LCtHvv1D7wed02e2+7tQ/uVxuSvvTs+etvkWFpZGw9feVLs3r93PD93ZXz0tqfj0BH9429fPDGq6xrjAzc/GU1JEo9ffWqbYX9FdX0cN/5f2a9H7No7Fq6uzi7Ft+m566QfPRoREcP69YrHrjpls/9/T/3xY7FqXX08d+17YnBZafy/B9+IXz01J07df3CL/Q7/7sSIiLjkpL3jmjMP3PI3aDMefLU8Lrv7hXjfwcPitk8d1e5+SZLEx3/xTLy5tCquOePA+Ny7RndoHq9cWxfvvenxqKlvjKe+dlo2wJ0weW5MmbsyItb3g3jHHv3jiTeXx6sLK+K//vRyvLEhcHjkypMjYn2o8M7x/25x7Ls/NzZO2HdQi21P5gQPub78h5ciImLKte+OIWW9oq6hKT5y6+SYvbzt0OCn/54Vry+ujM+dODq+8YGD4q1la+LdP5nUYp+qmobYfcPp/rN3PRdT5qzM3ra55a1qGxrjqvtejoenL4m/XH5C/O8Lb8evn5qbfT4fvOWpbAAz4/vviwvufCZmL1sbD335pBg1sE+LgG17aC+ua9HTYwt/a/Uo2fy+rSo9NpliuWEVneOvYQCAHVx1XWNcfvcLUVXbEEuraqO8oqbQQ4IdxoKV6+Kcn0/OXqzK/QMeumrFmtq444nZcfr/93h89Lan439feDu7HvmP/jkj1ta1bLK6IzQzX7ByXXzyzmdj1br6qKlviiv/+HKnGuDmeuXt1fGBnz6RvZj7RnlVPDy9PA+j3bZWra2Lh14tj+/8bXqc8T9PxOHfezg+/5vn444n58S0hRXZdeFfX1y5+QN1wh1PzIlX3q6IJFl//L++vCgiIl7r5GM98eayiIhYsLI6IiL+ucn3/3fPzI+IiB//c0bMXrYmVq6ti9nL17bo9RAR8eyclbF6XX28tWxtLO6mr0feXLr+/9mIXXvHAcPKWnw0a66CeOXtilhcUbPhozpWr1v/7vVnZq+I1evqsvtPnL4k+/nMJVXZ3yV9ehZHQ1PS6sL0P6YtjojYbIDRluYeEHvs1nrsmUzEksraeHVhRby1bG1U1TbEH59bEBER9019u8X9H3l9SZRX1sTSqtpYuLq6zcd6ecHqFl+fddjwiIiYu2JtVNc1tqiUmfjaxudfXlkTLy9Y3aqSpllNfWOs2vB9fGnDY/zp+fXjfHTGsjbv85eXFrb9DemAO56YHRERD23h3DJr6ZqYsaQqmpKIHzzwevzXn17p0Dnu+39/LZZV1UZVTUNMX7jx/+OfX9z4HEqKMjF8QxXD8jW18caGc/+spWuyyze9vWpdq2O3NV/e3EI/qKlzV0VExL3PL4jZy9dGn57Fsc/g1hUszeepO56cExERj7Xxs8it3tj09dKmlR65yzXWNTTF83NXRUNTEn9/ZXE2EGz+N7fiZM7ytfHqwspYV9cYd09ZH07ms2VMcz+VTX3ngwdnP29qp9QjN8jrWbL5IGzMkLL44GHD47QDhsSxowfEXZ85JnbPqfzpW9qyDiE3UDl5v8Hx688cs9njs2UqPQAAdnDX/XV6dn3liIjFFTUt3k0ItO2xGUvjy394KSqq62PXPj1i9br6mLdyXayra4g+Pf2pROc0NSUx+a0V8fvn5sfD08uz74bu3aM4zjps9/jwEXvEl/7wYry9qjp+83TLd5vnnsu7o2VVtXHhr6bEksraGDNkl1i1ri5mLKmKnzw8I659/0EdPl5DY1P87NG34qf/fjMampIYUlYah4/cNR5+bUncNumteN8hw7pVpcDyNbUxZc7KeGb2inh29so2f177DO4bY/ceGGNHD4i3lq2Nm//1ZqypbWjjaJ03d/nauOmRmdmvH5uxLPuu6tx19Dti5ibPZfaytbFiTW0MbGPpo0WrN4YZz89bGfvnhAVT563Kfj5jSVUM74bvVm7+eXz/Q4fEqQcMaXHbub94OqbMWRkr1qwPNJ6ft/HCbu475CtrGlr8XKtyPm9oSqKhKYlePYri08fvFbc+9lY8P3dVnH/sqIhYv/xXszFDdunQ2BdvCCh+ev4RccSGvhDNTvh//46Fq6vj0RlLs9v+MGVBfOHUfVsdpzkkW3/MmthncOtxzF/Z8qL7CfsOjHufXxAr19bFrKVron4z775/ft6qOHB466WYIqLFm3PWbvi+tXeROZ/KtnLJvObv37B+vWLZmtr43xfejtnL18QvPnVUDCnb/HJ+j89cFvfnhBszl1TFO/cZGMuqauPltzc2Le9RXBRlvda/zli+pq7FMcorNi5Zt6l/vb4kFldUZ5d9iogtnl+qahqipr4xfvrvNyMi4ur37h8fPHxEHPm9iZu9X1lp69dBzeeZtvpPterpkTOuNbWNsWxDkPjwa+Uxb8NSaDOXVLXq0fHS/NXZz//0/Ntx5en7ZXuhtOXQEf071BD+d58bGyf+cH1V0qBdema//x/cEOpFRLulHh2p9CguysTN5x+R/fqU/YfEXZ85Nt570+MREdmff7Pc33QTPnvslp4GW8EreQCAHdj9L7wdf3x+QWQyEYN3KY2lVbWxqJ137AHrNTUl8bNHZ8WNj8yMJIk4bOSucdsnj4wP3PxkrNhwMecde+xa6GGyg1lSWRN/en5B/PH5Bdl3y0dEvGOP/nHeMaPirMN2z150++Jp+8a3/m963PrYWy2OMaO8KpIk6VYX+ptV1tTHp381JeYsXxsjdu0dv714bLy6sCI+t6Gy4bQDhsY799n6ZZVmL1sTX7n35ey7yd9/6O7x/Q8dEo1JEpNmLouX366IZ2av7NAx821pVU08O3tDyDFnZYt3Izfbb+guMXb0wBi794A4dvSAFhdF//zi+nfXV3UyiGhLkiRx7V+mRW3OBdG/5VzArupkwPJGG1VGU+etanPppdzXGVPnrooLxu6Z/fr5uRtDghnlVXHq/i1Dhe6g+eex6UXHiPUXQSPWV2lFbHyXfETLSqyKdXVb/LmOGVIWx44eELc+9lZMzQlPns8JhjqiobEpyjcEJm0tfbN7/14bQo+N79Avr6yJf7+xtMXSORXV9TEpZ5/2XjduGoTtP6ws9hu6SzyzIfAbtZk32EydtzHk2VTu4y2qqI7GpqTFfN5Wcn/e9Y1N7V60fvSN9d+bS07eO8YMKYvL7p4aL85fHWff8lT88sKj45ARbS/nt66uIa79y7TsY1XVNGT/Xz0+s2XVRElxJnbZMJ7FFS2//wtXV8eeA/u2Ob+akvVB1ldO3y+7raqNACLXirV18btn5sWSytoYsWvvOH/sqBYX79vT2EYQ1TymtuZMzSbN7HPHv2DlumyfjNk5PTlmlFfFkoraFvfL/f+xckM13aY9cXIN3KVjvYNyw6/cXiElxRu/J+1FcLmVHp1ZSjh3xbdNzz9F1mLKO6EHAMAOatbSqrj2z69GRMQV794v5q1cG/e/sLDdZQqA9Rd7vnrvS/HI6+vfyfmJsaPi22cdFKUlxbHf0LJ4evaKeKO8SujBVmlobIrHZiyLPzw3P/79xtLsckZlvUriw0eMiI8fM7LNfhfnHTMqfjFpdvZ8XVKUiaYkiVXr6mPZmtotvpt4e6upb4zPTXg+XltcGYN26Rm/+9zYGNa/Vwzr3yvOO2Zk/OG5BfFff3o5HrziXVtsQJ4kSfz2mXlx/QOvR019U5T1KonvnX1InH348GzYc+7RI+O3z8yL2ya9tV1Dj8UV1fHs7JXx7Jz1lRxtrX1/wLCyOG5DJcexowe0WQnRrKx0/fdiSxclO+K+qW/HU7NWRK8eRXH0ngPiyVnLW1ww7sxjraltiLdXtX7t0F7okXuRNvcCZU19Y4t3XHfX5do2hh6t52pzU+8Va+uiqSmJqfNzKlfKW1bVbnpRepfSkkiSJNZu6G2w39CyOHLUbpHJRMxdsS6WVdXG4LLSeD4nSOlIILakqjaakogexZk2m48P37V3xLxV2SCxrLQkqmob4p4p82NYv43nlIdeXRx1OesFLapo+3XjjE1+foN3KY0DhvVbH3qUV8bw/u2fp6bOWxX1OY/RmHNxOfd16qLV1bF8TW2Li8/bSm4PhSWVNdkm6rmqaurjuQ3B3an7D4m9BvWN//vCifG5Cc/FW8vWxkdvmxw/+uhh2aW+ct30yJuxYGV1DO/fK7747jFxzf3TssFRbvVNxPpzfvP8y62cyv160//LZx46LB6YVh5/fG5BfPG0fbON3bc0h95cWpVdqupL7943Skta92/ZVF1DU5vnkubHWry69dJ1m2tkPqedPiILV1e3qphrDk6z8/fZ+fG1Mw5o6+4REbFbn46FHrvkVLCsy+lDkhtitNccvquhR+4bGjb9XZmJ7vdmhx2d0AMAYAdUXdcYl939QlTXN8YJ+w6ML5y2b3api03fMQasN6O8Ki757fMxd8W66FlSFN//0CFx7tEjs7fvP2x96NFdL9TRfSxYuS7++NyC+NPUBbGkcuO7VI/da0B8/JiRceahu0fvnu1fWOpZUhRffs+YuPq+VyIionfP4hi8S2nMXr42Zpav6VahR31jU3zhnhdiypyVUVZaEnd95tgW77r9xgcOislvrYj5K9fFd/76Wvzk3MPaPVZ5RU1cdd/L2XXcT9h3YPzoo4e1WgLpc+8aHXc/Oy8mzVwWry+ujAN3b3uZnK56e9W6jSHHnJXZJVeaZTLrm1JnKzn2GhC79d36C2zN7+TNV6XH8jW18YMHXo+IiCves1+sWlvXqldEZSce6812llVrryIh9yLt/JXrYmllTQzp1yteebuiRXPr7rhcW5Ik2YuxbVV6DOy7PkxYvqYu3lq2JtvDIyJaLSW66UXh4bv2isrqhmzoccCwsujfu0fsP7Qs3iiviqnzVsb7Dtm9xZJZHfl5NS9tNax/rxbN4zc+fsv/R184bd8Y/+AbMWnmsjg+Jzy8Z8r6/hnNyzq29a79JElaVXpkMpnsUmYzlqyJE8cMbnW/ZhXV9S162eQuT5Tb62Xx6pqtqlCub6c/SEeszamCWlzRdujx1Kzl0dCUxOhBfWOvDee50YP6xp8vPyG+9PsX47EZy+KLv38xZi6piq+8Z7/sz+HVhRXZniHf+9Ah2WPPLK+K+sam1pUeRUVR1mv9fTd9/s0/503nxkeP2iOenb0yW73THEhu6fzS3LNs9KC+8ZEj99jsvs2WVLYO9dY/1vo539YbrDbXyHzuirZDj4iISTNbBkJzN5yHLzt13/jRP9+IZ+esbBXA5eqzmd+1bckNLnKXECvJ2d7eamu523sUdzykyF3GrdXyVjKPvBN67CAqquvjlg3r7wEAvLa4MmYuWRODy0rjpo8fEcVFmez6vk/NWhE/+MdrBR4hdC/1jUn88bkFUV3fGCN27R23ffKoOHSPlu/Ab76Y88jrS/zxSbteX1zV4kLzgL494yNHjoiPHzMq9u3A+vznHDEibpv0VsxetjZbaTR7+dr4xeNvtboIVEhvlFfFE28uj9KSorjzomNaLe2yS2lJ3HjuYXHuL9Y3ai8pykS/3q0vNTQ0JXH/Cwujoro+SkuK4mtnHBCffudebV683XNg3zjj0N3jH68sjmvunxbH7LVbq326YsXaupgyZ2Wr6oaiTMQhI/rH2NEDYuzogXHMXgOif5+t6wPQlubla8ora/Lye/mlBatj9br6OHD3fnHxiaPjtk2WR4tY3xS+o4/11rK2L0hOe7ui1bGq6xvjhfktw5Dr/jY9RuzaO15fvP7C5EG794vXFlfGm0vWdLvXI03Jxgvou7QVemxYKufZ2Sta9N6IiBZN2195u6JF9UJExO79e0dTUh2x4Vr/fht+pxy1527xRnlV/PKJOfH83FXx2qKNYcDriyu3+ns0Z/m67OO0ZfiuLcPScQcPiydnLY8n3lweT81akd3eXAly4XF7xs3/nhXPzF7Zagz1jUm22XhExOCy9WHQfkPXP6eX5q+Ke57d/Dvdf/7oxvk5fdHG59liLG9XtFrmry0V1fVdnkuv5jQV/8Wkt+LhNhqaNzfnPmX/loFOv1494s5PHxM/fOiNuP3x2fHTf8+KlxasjgM2/IybK/3e/47d490HDo26hqYoKcpEVW1DfPXel1sFGCXFmei7oeJixdqWPT0efLU8KmvqY3rOPImIGNC3ND529Mi4bdJb8ZOHZ2YrUl5ZuHqrnv9XTt8vWx2yJT9+eEaLZaia/XN6eSxfUxsv5PTdaLZybV2Ln9Ezszf+nJvPtQcMK2u1lN5Dr7bdWP7k/QbHC/NXxcTXlsTPNzNH8vV6LTcMaS9iy13yq63fXVuSG7xt2si8Oy5ruaMTeuwg1tY2xC+fmFPoYQAA3UhRJuJ/zjs8+4do8ztv5yxf63UDtONdYwbF/5x3RAxo493ah2xYhmjuinX+D7FZmUzEifsOivOOGRWnHzS0xbIpW6ukuCiuPH2/+MI9L8aAvj3ikBH94qHp5fHEm8uzlRDdRXFRJn5+wZFx7OgBbd5+9F4D4j9P2Sd+9uhb8cfnF2z2WIeO6B//38cPi32HlG12v/88eZ/4xyuL46UFq+OlDRdp8624KBOHjugfY/ceEMeNHhhH77XbVjc73hqDy0ojk1m/hEq+zilFmYgffuTQ6FFcFENzliw6bu8B8czslbFgZXWnH+vg4f2yF1qH9esV5ZU1bR6r+Z3679x7YDw9e0U8MK3lRcuPHLVHvP3IzKis6b7XMfr0LI5dera+JDZit/WBwuzla7PLmzU/z9x3hS9fUxuTNnn3/uhBfaOhqSnb++XA3dfP8bF7D4y7n50fU+etatHoPWL9O+Y7+j0aPbDt/gZ75WwvKy2JUQP6xAVjR7V5Pjls5K5x8v6D4+Z/z4r5K7f8O++cI0dExPo3B/QozkRlTUP8c/qSNvfde1DfmL18bUzJ6e8yr53fq8vX1MbDr7V9nFyNTUle51LzEpftefcBQ1ttKy7KxNfPPDD2G1oWX79/Wqtzdb9eJfHtsw6KiPXVfPsPK4vpiyqzTeOPHT0gG6r0792j3XPNa4sr47XFla22Dy4rjU8cOyp+8fhbMWNJVYcqqQ4YVhYfOHT3Ftv2Gdy33cDz/15a1Ob2F+avbjPwiFgfiLb3M2oOCN9/6O5RUV0fiytq4sR9B8WTs5a3auQeEVFaUhT7DOkbF4wdFRNfWxLzV65rtU+z3KXbms9hmUzE8P69213yd9AupbF8TW0ctkf/bIP53NDhkBEbqwsPHr7x89xzRmknfu/nvvbcdHmstvr00DWZpL2FygqksrIy+vfvHxUVFdGv37YpYd0RVVTXx88fm1XoYQAA3cgp+w1psdZ5U9P6ddLbW5sZdnZ7Dewb5x49ssW7+Tb1hynzY85mlmGA/r17xFnvGB4jN9PEd2slSRJ/fXlRjB7UN/Yc2Dd++/TcTjei3lYykYl3Hzgkjtmr7cCjWX1jU9z11NxYvra23X1G7tYnPn7MyK1eC/2vLy+K6YsqtrxjB/XuURxHjNotjtpztxbru28Lf3t5Ubyax+dw9J4D4vSD1l+QXVfXEL95el40NiXxqXfuGf879e1so+uO6tOjJD553Kh45PUlsd/QsmhKIia+tiSS5vc8J+uXd2quiNt7UN9494FD43fPzGuxln//3j3iM8ePjhcXrGoVCnQnJ+wzKE7ar/XyTI1NSUyYPDeWVK3/Pu7SsyQufOde8X8vr++ZVlKUiSTZ+I7vnsVFUdfYFL1KiuOCsaNidXV9/OXFhXHIiP5x5oaLzA2NTXHX5LmxbENz9ExkYtzBQ+PVhRUd7sNWWlIc5x0zstVSVhHrXwdOeHpulFfWxMljBsfx+w7K9tBZuLo65i5fG7v37x19S4vjw0eMiH0G7xK/e3Z+vL2q7QvKRZlMHDy8XyyprI1PHjcq2wviX68vyQYaxZlMHDKif7y6sCIymfVVKGe9Y3j85um5saauIeoammLhquoYPbhlUDOwb8/o16tH9vdtaXFRvO+Q3ePfbyyJqtqGmFFeFZefum/MXrYmFqysjvqm/DU6b/6ZtWeP3frEJ8eO2uw776cvqogHpi3O9iJp/pkeOWq3Fvv8/ZXF0ZQkUVpSHOcfOzKenb0yVq6ti0+9c88oKcpkv//FmUyceejuMfmt5S0qP5rHeuCwfvGhI9YHTw+9Wh4vLmgZng3r1yt6lhTF/JXrj9U89CRZH9Kfc+Qesc/glpWIM8qr4q7Jc6KxKYnBZaXR0JREUSYTRZmNDb6b5/v+w8piwcp1LX4/9evVI3bv3yuWr6mNXfv0jLeWrYlNFWcyUZTJRH1TU5SVlsQnj9sz3l5VHW8tWxPvGjM4fvfMvFhb1xAlRZlYXlUXDU1JDCrrGcfvMyhO3m9wJEkSv5+yIOatXBtraxti1br6GDWgT/Tr1SNG7NY7FqxcF588bs+Ys3xtzCyvincfOCTueXZ+jN17YPTpWRwTJs+NXfv0iH2H7BL/fmNpXPXe/WPfIWXx6sKKeOT1JXHu0SPjxfmrY9c+PeKEfQdlx93UlMRtj78V85avi6++d78WS04+PL08epQUxan7D2l3fmzOX19eFIN3KW2zX9VfX14UQ8pK47i9t18vqx1NR3IDoQcAAAAAANBtdSQ36Hgtzlb6+c9/HqNHj45evXrFUUcdFU888cS2eigAAAAAAIBtE3r88Y9/jCuuuCKuvfbaePHFF+Nd73pXnHHGGTF//vxt8XAAAAAAAADbZnmrsWPHxpFHHhm33nprdtuBBx4YH/rQh2L8+PGbva/lrQAAAAAAgGYFXd6qrq4upk6dGuPGjWuxfdy4cTF58uRW+9fW1kZlZWWLDwAAAAAAgI7Ke+ixfPnyaGxsjKFDh7bYPnTo0CgvL2+1//jx46N///7Zj5EjR+Z7SAAAAAAAwE5gmzUyz2QyLb5OkqTVtoiIa665JioqKrIfCxYs2FZDAgAAAAAAUqwk3wccNGhQFBcXt6rqWLp0aavqj4iI0tLSKC0tzfcwAAAAAACAnUzeKz169uwZRx11VEycOLHF9okTJ8bxxx+f74cDAAAAAACIiG1Q6RERceWVV8anPvWpOProo+Od73xn3H777TF//vy49NJLt8XDAQAAAAAAbJvQ4+Mf/3isWLEivvvd78bixYvjkEMOiQceeCD23HPPbfFwAAAAAAAAkUmSJCn0IHJVVlZG//79o6KiIvr161fo4QAAAAAAAAXUkdwg7z09AAAAAAAACkHoAQAAAAAApILQAwAAAAAASAWhBwAAAAAAkApCDwAAAAAAIBWEHgAAAAAAQCoIPQAAAAAAgFQQegAAAAAAAKkg9AAAAAAAAFJB6AEAAAAAAKSC0AMAAAAAAEgFoQcAAAAAAJAKQg8AAAAAACAVhB4AAAAAAEAqCD0AAAAAAIBUEHoAAAAAAACpUFLoAWwqSZKIiKisrCzwSAAAAAAAgEJrzgua84PN6XahR1VVVUREjBw5ssAjAQAAAAAAuouqqqro37//ZvfJJFsTjWxHTU1NsWjRoigrK4tMJtOlY1VWVsbIkSNjwYIF0a9fvzyNkLQzb+gM84aOMmfoLHOHjjJn6Azzhs4wb+gM84bOMG/oDPNmx5YkSVRVVcXw4cOjqGjzXTu6XaVHUVFR7LHHHnk9Zr9+/UxkOsy8oTPMGzrKnKGzzB06ypyhM8wbOsO8oTPMGzrDvKEzzJsd15YqPJppZA4AAAAAAKSC0AMAAAAAAEiFVIcepaWl8e1vfztKS0sLPRR2IOYNnWHe0FHmDJ1l7tBR5gydYd7QGeYNnWHe0BnmDZ1h3uw8ul0jcwAAAAAAgM5IdaUHAAAAAACw8xB6AAAAAAAAqSD0AAAAAAAAUkHoAQAAAAAApILQAwAAAAAASAWhBwBAN7JmzZpCDwHYCSRJUughsAMyb4DtxfkG6IodNvRYunRpLFu2LOrq6iIioqmpqcAjorubNWtWTJw4sdDDYAczffr0uPrqq2PmzJmFHgo7kJkzZ8all14aTzzxRKGHwg5k5syZccopp8R3vvOdiPDahq2zYMGCmDp1aixatKjQQ2EHsmzZsli3bl32axeW2BpLly6Nqqqq7NfmDVuj+fVMY2NjgUfCjqSioqLFnHG+YWu4VkyuHS70qK+vj0svvTROOumkOOuss+KDH/xg1NbWRlHRDvdU2I5eeeWV2G+//eL888+PefPmFXo47ADq6uriM5/5TBx66KFRU1MTe+21V6GHxA6gqakpvvKVr8Thhx8ea9eubXFhANpTV1cXn/70p+Pggw+O559/Ph577LGICK9t2Kz6+vq45JJL4sgjj4zPfvazcdhhh8VTTz1V6GHRzdXX18d//Md/xAknnBBnnXVWfOYzn4mVK1dGJpMp9NDoxhoaGuLiiy+OY489Nt7znvfEBRdcEMuXLzdv2Kz6+vq47LLL4pJLLokIr2vYOvX19XH55ZfHmWeeGWeeeWZ873vfi8bGRucbNsu1YtqyQ/3077vvvjjwwAPjjTfeiFtvvTUuvvjiePPNN+OrX/1qoYdGN1dXVxfvfe97o0ePHnHDDTcUejh0c7/61a9i0KBBMXPmzHj55Zfj5ptvjp49e0aEd5iweQ8++GA899xz8eCDD8Zvf/vbOPPMM7O3mTu05fvf/34MGDAg5s6dG6+++mp8+9vfjuLi4li+fHmhh0Y3tmbNmvjoRz8ab775Zjz88MNx7733xpFHHhnf/OY3I8L5hratWrUqzjzzzJg1a1b8+te/jvPPPz9efvnl+OAHPxgzZswo9PDophoaGuKiiy6K1157LSZMmBDnn39+vPLKK3HOOefE66+/Xujh0U09++yz8Z73vCfuu+++mDBhQjz11FORyWRUe7BZEydOjIMOOiimT58eV111VYwcOTLuvvvuuO666yLC6xva5lox7dmhQo/HHnssPvGJT8QjjzwSp556anz+85+Pd73rXVFaWlroodHNvfDCC7HbbrvF3XffHbfffntMmTKl0EOiG7vzzjtjjz32iH/84x9x6KGHxgsvvBAPPvhgzJw5M2prayPCCy7adscdd8Thhx8eJ598ckyaNCm++c1vxl133RXz58/37iRamT59ejz00ENx5513xqRJk2L//fePAw88MKZOnZp9V5JzDW157bXX4vXXX49vfvObccQRR8T+++8fH/vYx6KsrCyampqcb2jTlClTory8PG699dY44YQT4vOf/3zcfffd8fTTT8fPfvazWLp0aaGHSDe0ePHimDJlSlx++eVx8sknx1e+8pWYOHFizJ49O2699dZYsmRJoYdIN/TMM8/EmDFjYsKECXHWWWdlLz4WFxcXeGR0V5WVlXHvvffGe9/73pg4cWJ86EMfiltvvTXOO++8eO6552LdunVe39Am14ppzw4RejS/G+Ab3/hGfP7zn4+SkpKIiJg3b15MmzYthg8fHs8++2whh0g3V1paGnvuuWecdtppccwxx2TXS6+srCzwyOhOGhoaIiLixz/+cdTW1sbNN98cZ599dnzsYx+Lq666Kk466aT4zGc+ExHhBRetVFVVxfLly+Pd7353fP/734/zzjsvpk2bFt/61rfitNNOi7/97W+FHiLdRHOQccABB8STTz4ZH//4x7O3DRkyJPbYY4/sElfONbSlvr4+Zs2alf1jbvny5fGzn/0shg8fHr/61a+iurq6wCOkO1qyZEm8/fbbsf/++2e3rVq1KnbdddeYOHGiPlS0acWKFfH222/HcccdFxERtbW1MWzYsLjmmmvi4Ycfjscff7zAI6Q7aX6N85GPfCSuvPLKOOOMM+I//uM/Yvbs2XHnnXdGxMa/uSBXY2NjnHjiifG5z30uevToEUmSRM+ePaOmpiaqq6ujT58+3gxEC839Olwrpj3dNvR44IEHImL9L83mdwMMGzYsRo4cGRERP/3pT2P06NHRp0+f+Nvf/hZnnHFGfOc738m+C5udT+6c2dQLL7wQa9asiYiIu+++Ox566KE444wz4r3vfW+88cYb23WcdC+586akpCSSJIl3vvOdcfLJJ8f48eNjwIABcf/998fvf//7uOOOO+Ivf/lLfO973yvwqCm0ts43ZWVlUV9fH3fccUfMnDkz7r///rjvvvti3rx5sc8++8SvfvUr55ud3Kbzpq13Ow4aNCiqq6ujvr6+xb7svNo635xwwglxyimnxGc+85k444wzYujQoTFs2LDo2bNnXHPNNfHpT386pk2bVqgh0w20NW9GjhwZAwcOjB/+8IfZbXfccUdcfPHFUV9fH4888kir+7Bzuf322+OXv/xliyBjzJgxMWzYsPjd734XERv7Mlx++eVRVlYWDz74oL/Bd3LN82bSpEnZN2uMGDEiDjrooIiIOProo+O8886L73znO9HY2Jj9m4udW+68iYjYbbfd4sILL4zDDz88IjZe0K6oqIi99947IrwZiJbzpvn30dChQ10rpm1JN/P3v/89GTFiRJLJZJKnnnoqSZIkaWpqarXfXXfdlTz++OPZ2373u98lvXv3TubOnbtdx0vhbW7ONP973nnnJY888kiSJEnyy1/+Mundu3fSo0eP5L777ivMoCm49uZNQ0NDkiRJsnTp0uQb3/hGsnDhwhb3+/GPf5wMGjQoqaur2+5jpvDamzfN55o777wzyWQyyX777ZcsXbo0e7/HH3882X333ZPJkycXZNwU1ta+tmnedthhhyVf+tKX2t2PnUNb86axsTFpbGxMkiRJ1qxZk7z55pvJ8ccfn/z4xz/O3u/FF19M9t577+Tee+8tyLgprLbmTfNrm5UrVyY33HBDkslkkuOPPz7ZZZddkkMOOSSpr69Pbr755mTEiBGFHDoFdM899yRDhgxJ3vnOdyaHH354Mnjw4OQHP/hBkiRJUlFRkVx99dXJfvvtlyxZsiRJkiSprq5OkiRJJkyYkOy6667Zr9m5tDVvrr/++iRJNp53mj377LPJmDFjkv/6r/9KkiTJ/i5j57O5803uvGl+DTx27NjkjjvuaLGNnc/Wnm9cKyZXt6r0ePLJJ+OWW26JD3/4w/G+970vvvzlL0dEyzQ32fCOgE9/+tPxrne9K3vbUUcdFfX19TFz5sztP3AKZktzpnm+lJaWxoQJE+LYY4+Nr3/96/H1r389dtlll5g7d26hhk4BbW7eFBcXR5IkMXjw4Ljmmmti+PDhLe47YsSIaGxs1PBzJ7S5edN8zmmuEiopKWnRqPGYY46JqqqqWLhwYUHGTuFszWubZplMJqqrq+PAAw+MhQsXRnV1tXe07aTamzdFRUXZd7X17ds3qqqqYsWKFXHhhRdmX/MceuihsWrVqpg/f37Bxk9htDdvmqvKdtttt7jqqqvisccei/PPPz/uv//+mDZtWpSUlER1dXXstddeUVFRUcinQAHcc8898cMf/jC++93vxuTJk+Mf//hHfPvb347rr78+Kisro1+/fnH66adH//79s0sENy+tN2rUqOjZs6e/wXdC7c2bH/zgB1FVVdWqmvXQQw+N//iP/4hf/vKXMW/evCgqKorHHnvMctM7mc2dbzadN5lMJubOnRuzZ8+OE088Mbtt9uzZEbGxEoT025rzTfPf3q4Vk6tbhB7Nf6QNHTo0xo0bF1deeWV873vfi9deey277mPzCa29P/7/8pe/xGmnnZY9GZJuWztnioqKorq6OiorK+OBBx6IY489Nl588cX4xje+Ef/93/8dV111leBjJ7K186b5PNOnT59Wx3j88cfj1FNPjUMOOWT7DZyC2pp50/wia7/99osrrrgi3nrrrbjtttuyIcdf//rXOPTQQ+Okk04qzJNgu+vIa5tcvXv3jl133TUWL14cvXv39gfdTqaj86ZPnz7x5ptvxoIFC7K/u/72t7/F6NGj47TTTtv+T4CC6Oi8Oemkk+ILX/hCnH766RERUVdXF08//XQceeSR0b9//+3/BCiI5nlTX18fY8eOjQsvvDAiIoYPHx6HH354jBgxIl577bWIiDjxxBPjE5/4REyYMCH+/Oc/Z5dgfOqpp+Kggw6KQw89tDBPgu1ua+bN66+/3up+vXv3jrPPPjuOOOKIOPfcc+Poo4+Oj3zkI7Fy5crtOn4Ko7Pz5qGHHoqRI0fG/vvvHy+++GKMHTs2jjvuuGhoaMi+CYT06si8aWvZ4AjXind6BaguyZo6dWqyevXqFtuay5Lq6+uTr371q8ngwYOTmpqaNu8/b968ZNasWcnnPve5ZPjw4cldd92VJImStzTr6Jxpvm3KlCnJ9OnTW9yvpqYmueGGG5TW7gS6eq6ZM2dOMmvWrOTiiy9ORo0alfzlL39JksS5Ju06Om9yzyU333xzMnz48GT//fdPPvzhDyd9+/bNlm2Tbl053zTPoT/96U9Jz549k0WLFm37AdMtdHTeNP/+WbFiRXL++ecnffr0SS699NLkwgsvTMrKypJvfetbfkftBLr6+uaNN95IZs6cmVx44YXJ6NGjk6effnqbj5nCmzp1arJq1ars16tXr261FNFLL72UDBs2LFm5cmV2W2VlZXL11VcnZWVlycknn5x87GMfS3r37p387Gc/S5LE6+K06+y8yTVt2rTkHe94R5LJZJLLLrssqa2t3ZZDphvo7LxpPp988YtfTD760Y8mX/nKV5KioqLk4osvbvd3GunR1fONa8U0K0jocd999yV77LFHss8++ySjRo1KvvWtbyWLFy9OkqTl2uizZ89ORo4cmXz1q1/N3tZs5syZyZVXXpnsscceyamnnprMmDFj+z8RtpvOzplNT4zsXPJxrnnjjTeSyy+/PBkyZEhyyimnONfsBDo7bzYNUJ955pnk5z//eXLNNdeYNzuBfJxvmv3mN79JLr300qSiosKL85TLx/lm3bp1yVVXXZVcdNFFyYUXXuh8sxPI1/nmJz/5SbLPPvskJ510UjJz5szt+yTY7jadN9/85jeT8vLy7O2555Ubb7wxOeGEE5IkSVpdmP7Tn/6UfPvb304uvfTS5PXXX98+g6dg8jVvnnjiiWTPPfdMjjvuuGTWrFnbZ/AUTD7mTWNjY7LnnnsmmUwmOeWUU1q9iZX06ey8ye23OnPmzOSrX/2qa8UkSVKA0OO5555LDjjggOSmm25KXn755eTnP/95Mnjw4OQ///M/kxUrViRJsvFCdVNTU/Lzn/88KSkpSWbPnp0kyfp359fW1iZNTU3Jo48+mm3QR3p1dc7U1tYma9euzd7OziFf55qGhobkn//8Z/L4448X7Lmw/eTjfFNZWVmw8VMY+fw9lSSae+4s8vF7Kvd8U19fv/2fBNtdPn9PLVq0KJk6dWphngjb1dbMm8bGxux55MMf/nBy+eWXF3LIdAP5nDeLFi1STbaTyNe8Wb16dTJ+/Pjkn//853YdP4WRr3mzbt265LHHHnOtmCRJtmPo0Xyx+dZbb0322GOPpKKiInvbLbfckhx33HHJ9773vVb3W7FiRXL88ccnZ599djJ16tTk9NNPT37729+6eL0TyNecGTdunDmzE3GuoTOcb+gM84bOMG/ojHzPG+HqzqGj86axsTFpampK9tlnn+Tvf/97kiRJMmPGjOS8885L5s+fv30HT8GYN3SGeUNnmDdsS9ut809zc8U5c+bEfvvtFyUlJdnbLrroojjqqKPiwQcfjOnTp0fExqawAwYMiM9//vPx17/+NY455pgoLS2Nc845p92G5qRHvuZMz5494yMf+Yg5s5NwrqEznG/oDPOGzjBv6Ix8zxsNYHcOHZ03RUVF8dxzz0WfPn3iyCOPjCuuuCLe8Y53xIoVK2LIkCEFeQ5sf+YNnZHPeTN48OCCPAe2P+cbtqVt9mp34sSJ8aUvfSn+53/+J6ZMmZLdfsIJJ8TkyZOjvLw8Ita/IO/bt2+cffbZkclk4uGHH46IiOLi4qirq4uf//zncfHFF8dJJ50Ur7zySvztb3+LPn36bKthU0Dbcs707t27IM+Jbc+5hs5wvqEzzBs6w7yhM8wbOqOr8yYi4oEHHohXX3019t9//5g4cWI89dRT8fDDD0dpael2fz5sH+YNnbEt502vXr22+/Nh+3C+YXvKe+ixePHiOOuss+KTn/xkrFy5Mu68884YN25cdjKPGzcu9tprr/jhD38YERtTvdNPPz2Kiopi1qxZ2WOtWrUqZs6cGb/+9a/jsccei4MPPjjfw6UbMGfoDPOGzjBv6Azzhs4wb+gM84bOyOe86dGjRwwaNCjuuuuumD59ehx11FHb/wmxXZg3dIZ5Q2eYNxREPtfKWrt2bfLpT386+fjHP55tlpckSXLMMcckF110UZIk6xvr/eY3v0mKiopaNZa54IILklNPPTWfQ6KbM2foDPOGzjBv6Azzhs4wb+gM84bOyMe8OeWUU7JfL126dPsMnIIyb+gM84bOMG8olLxWevTp0ydKS0vjoosuitGjR0dDQ0NERHzgAx+I119/PSLWl1qfe+65cfbZZ8fnPve5mDRpUiRJEuXl5fHmm2/GBRdckM8h0c2ZM3SGeUNnmDd0hnlDZ5g3dIZ5Q2fkY9588pOfzB7PWvo7B/OGzjBv6AzzhkLJJEmS5POA9fX10aNHj4iISJIkMplMfOpTn4revXvH7bffnt1WU1MTZ5xxRrz22mtx+OGHx6uvvhqjRo2Ke++9N0aOHJnPIdHNmTN0hnlDZ5g3dIZ5Q2eYN3SGeUNnmDd0hnlDZ5g3dIZ5QyHkPfRoy0knnRSf/exn46KLLookSaKpqSmKi4tjyf/f3h3iNBaFYRj+O53cVFRXY5DdAL4rqGMB2MrquwE2wRpQ2Kri8NTDAghpQjJqyOgvnDvpyfMsoP8Vr/uSnre3enl5qefn57q6uqrb29vWn8KF0AwJ3ZDQDQndkNANCd2Q0A0J3ZDQDQnd0Frz0eN0OtXNzU09Pj5+Py5zPp9rGIaWZ7lgmiGhGxK6IaEbErohoRsSuiGhGxK6IaEbpvCjb3r86++Wcjgcarlcfkc8jmPtdrt6f39vdZoLpRkSuiGhGxK6IaEbErohoRsSuiGhGxK6YUq/W/3wbDarqqrj8Vjb7baenp7q7u6uPj4+6uHhoVarVavTXCjNkNANCd2Q0A0J3ZDQDQndkNANCd2Q0A1Tavr3Vp+fn7Ver+v19bWGYahxHGu/37c6Rwc0Q0I3JHRDQjckdENCNyR0Q0I3JHRDQjdMpfmbHpvNpq6vr+v+/r4Wi0XLU3RCMyR0Q0I3JHRDQjckdENCNyR0Q0I3JHTDFJqPHl9fXzWfz1ueoDOaIaEbErohoRsSuiGhGxK6IaEbErohoRum0Hz0AAAAAAAAmMKv//0BAAAAAAAAP8HoAQAAAAAAdMHoAQAAAAAAdMHoAQAAAAAAdMHoAQAAAAAAdMHoAQAAAAAAdMHoAQAAAAAAdMHoAQAAAAAAdMHoAQAAAAAAdMHoAQAAAAAAdOEPTPSGbLgmG3IAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 2000x1000 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "df4['data_upload'].value_counts().plot(figsize=(20, 10))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "7f9aaa92",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2023-04-19T21:43:02.889761Z",
     "start_time": "2023-04-19T21:43:02.836432Z"
    }
   },
   "outputs": [],
   "source": [
    "# Salvando os dados tratados\n",
    "df4.to_csv('dados/silver/dados_tratados_com_features_novas.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "8bf3b2e5",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2023-04-19T21:51:44.944840Z",
     "start_time": "2023-04-19T21:51:44.936428Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(1317, 13)"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df4.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "b86d337a",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.13"
  },
  "latex_envs": {
   "LaTeX_envs_menu_present": true,
   "autoclose": false,
   "autocomplete": true,
   "bibliofile": "biblio.bib",
   "cite_by": "apalike",
   "current_citInitial": 1,
   "eqLabelWithNumbers": true,
   "eqNumInitial": 1,
   "hotkeys": {
    "equation": "Ctrl-E",
    "itemize": "Ctrl-I"
   },
   "labels_anchors": false,
   "latex_user_defs": false,
   "report_style_numbering": false,
   "user_envs_cfg": false
  },
  "nbTranslate": {
   "displayLangs": [
    "*"
   ],
   "hotkey": "alt-t",
   "langInMainMenu": true,
   "sourceLang": "en",
   "targetLang": "fr",
   "useGoogleTranslate": true
  },
  "toc": {
   "base_numbering": 1,
   "nav_menu": {},
   "number_sections": true,
   "sideBar": true,
   "skip_h1_title": false,
   "title_cell": "Table of Contents",
   "title_sidebar": "Contents",
   "toc_cell": false,
   "toc_position": {},
   "toc_section_display": true,
   "toc_window_display": false
  },
  "varInspector": {
   "cols": {
    "lenName": 16,
    "lenType": 16,
    "lenVar": 40
   },
   "kernels_config": {
    "python": {
     "delete_cmd_postfix": "",
     "delete_cmd_prefix": "del ",
     "library": "var_list.py",
     "varRefreshCmd": "print(var_dic_list())"
    },
    "r": {
     "delete_cmd_postfix": ") ",
     "delete_cmd_prefix": "rm(",
     "library": "var_list.r",
     "varRefreshCmd": "cat(var_dic_list()) "
    }
   },
   "types_to_exclude": [
    "module",
    "function",
    "builtin_function_or_method",
    "instance",
    "_Feature"
   ],
   "window_display": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}