{
 "cells": [
{
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Pegar o qualis respectivo de cara periodico da area\n",
    "prod_df = prod_df.merge(qualis, on='ISSN', how='left')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Nome</th>\n",
       "      <th>Ano</th>\n",
       "      <th>ArtigosCompletos</th>\n",
       "      <th>ISSN</th>\n",
       "      <th>Título</th>\n",
       "      <th>Estrato</th>\n",
       "      <th>pontuacao</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Andreza Portella Ribeiro</td>\n",
       "      <td>2018</td>\n",
       "      <td>TRAMONTE, KEILA MODESTO ; Figueira, Rubens Ce...</td>\n",
       "      <td>0025-326X</td>\n",
       "      <td>MARINE POLLUTION BULLETIN.</td>\n",
       "      <td>A2</td>\n",
       "      <td>85.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Andreza Portella Ribeiro</td>\n",
       "      <td>2018</td>\n",
       "      <td>TREVIZANI, TAILISI HOPPE ; PETTI, MONICA ANGE...</td>\n",
       "      <td>0025-326X</td>\n",
       "      <td>MARINE POLLUTION BULLETIN.</td>\n",
       "      <td>A2</td>\n",
       "      <td>85.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Andreza Portella Ribeiro</td>\n",
       "      <td>2018</td>\n",
       "      <td>URIOESTE, A. ; Leitão, M. A. S. ; AQUINO, S. ;...</td>\n",
       "      <td>2316-3712</td>\n",
       "      <td>REVISTA DE GESTÃO EM SISTEMAS DE SAÚDE</td>\n",
       "      <td>B3</td>\n",
       "      <td>40.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Andreza Portella Ribeiro</td>\n",
       "      <td>2018</td>\n",
       "      <td>URIOESTE, A. ; Leitão, M. A. S. ; AQUINO, S. ;...</td>\n",
       "      <td>2316-3712</td>\n",
       "      <td>REVISTA DE GESTÃO EM SISTEMAS DE SAÚDE</td>\n",
       "      <td>B3</td>\n",
       "      <td>40.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Andreza Portella Ribeiro</td>\n",
       "      <td>2017</td>\n",
       "      <td>LAMANO FERREIRA, MAURÍCIO ; PORTELLA RIBEIRO,...</td>\n",
       "      <td>0013-9351</td>\n",
       "      <td>ENVIRONMENTAL RESEARCH (NEW YORK, N.Y. PRINT)</td>\n",
       "      <td>A1</td>\n",
       "      <td>100.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                       Nome   Ano  \\\n",
       "0  Andreza Portella Ribeiro  2018   \n",
       "1  Andreza Portella Ribeiro  2018   \n",
       "2  Andreza Portella Ribeiro  2018   \n",
       "3  Andreza Portella Ribeiro  2018   \n",
       "4  Andreza Portella Ribeiro  2017   \n",
       "\n",
       "                                    ArtigosCompletos       ISSN  \\\n",
       "0   TRAMONTE, KEILA MODESTO ; Figueira, Rubens Ce...  0025-326X   \n",
       "1   TREVIZANI, TAILISI HOPPE ; PETTI, MONICA ANGE...  0025-326X   \n",
       "2  URIOESTE, A. ; Leitão, M. A. S. ; AQUINO, S. ;...  2316-3712   \n",
       "3  URIOESTE, A. ; Leitão, M. A. S. ; AQUINO, S. ;...  2316-3712   \n",
       "4   LAMANO FERREIRA, MAURÍCIO ; PORTELLA RIBEIRO,...  0013-9351   \n",
       "\n",
       "                                          Título Estrato  pontuacao  \n",
       "0                     MARINE POLLUTION BULLETIN.      A2       85.0  \n",
       "1                     MARINE POLLUTION BULLETIN.      A2       85.0  \n",
       "2         REVISTA DE GESTÃO EM SISTEMAS DE SAÚDE      B3       40.0  \n",
       "3         REVISTA DE GESTÃO EM SISTEMAS DE SAÚDE      B3       40.0  \n",
       "4  ENVIRONMENTAL RESEARCH (NEW YORK, N.Y. PRINT)      A1      100.0  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Usar um dicionario para computar a pontuação \n",
    "pontuacao={\n",
    "    'A1':100,\n",
    "    'A2':85,\n",
    "    'B1':70,\n",
    "    'B2':50,\n",
    "    'B3':40,\n",
    "    'B4':20,\n",
    "    'B5':10\n",
    "}\n",
    "prod_df['pontuacao'] = prod_df.Estrato.apply(lambda x: pontuacao.get(x))\n",
    "prod_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "#exportar para Excel XLSX\n",
    "prod_df.to_excel('prod_cis.xlsx')"
   ]
  }
 ],
 "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.6.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}