extrair.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 169,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import sqlalchemy as sq\n",
    "from sqlalchemy import text\n",
    "import pyodbc as po\n",
    "import pymysql as pm\n",
    "import datetime as da\n",
    "from datetime import date as dt\n",
    "from datetime import timedelta as td"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 170,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "<>:1: SyntaxWarning: invalid escape sequence '\\I'\n",
      "<>:1: SyntaxWarning: invalid escape sequence '\\I'\n",
      "C:\\Users\\Controladoria\\AppData\\Local\\Temp\\ipykernel_7996\\3766686350.py:1: SyntaxWarning: invalid escape sequence '\\I'\n",
      "  SERVER = 'SEVENTH\\INSIDEINS'\n"
     ]
    }
   ],
   "source": [
    "SERVER = 'SEVENTH\\INSIDEINS'\n",
    "DATABASE = 'Service'\n",
    "DRIVER = 'SQL Server Native Client 11.0'\n",
    "USERNAME = 'controladoria'\n",
    "PASSWORD = 'Brb1508.'\n",
    "DATABASE_CONNECTION = f'mssql://{USERNAME}:{PASSWORD}@{SERVER}/{DATABASE}?driver={DRIVER}'\n",
    "\n",
    "engine = sq.create_engine(DATABASE_CONNECTION)\n",
    "connection = engine.connect()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 171,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'2024-06-11'"
      ]
     },
     "execution_count": 171,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data = (dt.today() - td(10)).isoformat()\n",
    "#data = data.strftime(\"%Y-%m-%d\")\n",
    "#data = da.datetime(data.year,data.month,data.day).timestamp()\n",
    "#data = da.datetime(data)\n",
    "#data = da.datetime(data.year,data.month,data.day)\n",
    "#data = da.datetime.fromisoformat(data.isoformat())\n",
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 172,
   "metadata": {},
   "outputs": [],
   "source": [
    "ContasReceber = pd.read_sql_query(f\"SELECT * FROM [Service].[dbo].[ContasReceber] where Pago = 0\",connection,parse_dates=['date'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 173,
   "metadata": {},
   "outputs": [],
   "source": [
    "intervalo = ContasReceber['Vencimento'] <= data\n",
    "ContasReceber = ContasReceber.loc[intervalo]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 174,
   "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>Empresa</th>\n",
       "      <th>Operação</th>\n",
       "      <th>Cliente</th>\n",
       "      <th>NotaFiscal</th>\n",
       "      <th>Série</th>\n",
       "      <th>DataEmissão</th>\n",
       "      <th>FormaPagamento</th>\n",
       "      <th>Pago</th>\n",
       "      <th>Número</th>\n",
       "      <th>Letra</th>\n",
       "      <th>...</th>\n",
       "      <th>EliminadaPJ</th>\n",
       "      <th>CodFatLote</th>\n",
       "      <th>CodMarketingVei</th>\n",
       "      <th>ErroCartão</th>\n",
       "      <th>IDWakeUp</th>\n",
       "      <th>WakeEmpresaRegistro</th>\n",
       "      <th>PixUrl</th>\n",
       "      <th>PixTxId</th>\n",
       "      <th>PixEmv</th>\n",
       "      <th>CodRestriçãoInnove</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1001</td>\n",
       "      <td>Grupo</td>\n",
       "      <td>856.0</td>\n",
       "      <td>1608</td>\n",
       "      <td>TMP</td>\n",
       "      <td>2021-01-25</td>\n",
       "      <td>31.0</td>\n",
       "      <td>False</td>\n",
       "      <td>1608</td>\n",
       "      <td>A1</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1001</td>\n",
       "      <td>Grupo</td>\n",
       "      <td>364.0</td>\n",
       "      <td>458</td>\n",
       "      <td>REC</td>\n",
       "      <td>2019-08-28</td>\n",
       "      <td>31.0</td>\n",
       "      <td>False</td>\n",
       "      <td>458</td>\n",
       "      <td>A2</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1001</td>\n",
       "      <td>Grupo</td>\n",
       "      <td>364.0</td>\n",
       "      <td>458</td>\n",
       "      <td>REC</td>\n",
       "      <td>2019-08-28</td>\n",
       "      <td>31.0</td>\n",
       "      <td>False</td>\n",
       "      <td>458</td>\n",
       "      <td>A3</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1001</td>\n",
       "      <td>Grupo</td>\n",
       "      <td>244.0</td>\n",
       "      <td>544</td>\n",
       "      <td>REC</td>\n",
       "      <td>2019-11-01</td>\n",
       "      <td>31.0</td>\n",
       "      <td>False</td>\n",
       "      <td>544</td>\n",
       "      <td>A2</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1001</td>\n",
       "      <td>Grupo</td>\n",
       "      <td>244.0</td>\n",
       "      <td>544</td>\n",
       "      <td>REC</td>\n",
       "      <td>2019-11-01</td>\n",
       "      <td>31.0</td>\n",
       "      <td>False</td>\n",
       "      <td>544</td>\n",
       "      <td>A3</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1408</th>\n",
       "      <td>1001</td>\n",
       "      <td>FatLote</td>\n",
       "      <td>1279.0</td>\n",
       "      <td>4385</td>\n",
       "      <td>REC</td>\n",
       "      <td>2023-02-24</td>\n",
       "      <td>31.0</td>\n",
       "      <td>False</td>\n",
       "      <td>4385</td>\n",
       "      <td>01</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>946.0</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1410</th>\n",
       "      <td>1001</td>\n",
       "      <td>FatLote</td>\n",
       "      <td>1566.0</td>\n",
       "      <td>6774</td>\n",
       "      <td>TMP</td>\n",
       "      <td>2023-03-21</td>\n",
       "      <td>31.0</td>\n",
       "      <td>False</td>\n",
       "      <td>6774</td>\n",
       "      <td>01</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>971.0</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1411</th>\n",
       "      <td>1001</td>\n",
       "      <td>Grupo</td>\n",
       "      <td>1566.0</td>\n",
       "      <td>976</td>\n",
       "      <td>S</td>\n",
       "      <td>2023-03-21</td>\n",
       "      <td>31.0</td>\n",
       "      <td>False</td>\n",
       "      <td>976</td>\n",
       "      <td>A1</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1412</th>\n",
       "      <td>1001</td>\n",
       "      <td>Grupo</td>\n",
       "      <td>1479.0</td>\n",
       "      <td>4509</td>\n",
       "      <td>REC</td>\n",
       "      <td>2023-03-21</td>\n",
       "      <td>31.0</td>\n",
       "      <td>False</td>\n",
       "      <td>4509</td>\n",
       "      <td>A1</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1413</th>\n",
       "      <td>1001</td>\n",
       "      <td>FatLote</td>\n",
       "      <td>1279.0</td>\n",
       "      <td>4539</td>\n",
       "      <td>REC</td>\n",
       "      <td>2023-03-22</td>\n",
       "      <td>31.0</td>\n",
       "      <td>False</td>\n",
       "      <td>4539</td>\n",
       "      <td>01</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>976.0</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>266 rows × 67 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Empresa Operação  Cliente NotaFiscal Série DataEmissão  FormaPagamento  \\\n",
       "0       1001    Grupo    856.0       1608   TMP  2021-01-25            31.0   \n",
       "1       1001    Grupo    364.0        458   REC  2019-08-28            31.0   \n",
       "2       1001    Grupo    364.0        458   REC  2019-08-28            31.0   \n",
       "3       1001    Grupo    244.0        544   REC  2019-11-01            31.0   \n",
       "4       1001    Grupo    244.0        544   REC  2019-11-01            31.0   \n",
       "...      ...      ...      ...        ...   ...         ...             ...   \n",
       "1408    1001  FatLote   1279.0       4385   REC  2023-02-24            31.0   \n",
       "1410    1001  FatLote   1566.0       6774   TMP  2023-03-21            31.0   \n",
       "1411    1001    Grupo   1566.0        976     S  2023-03-21            31.0   \n",
       "1412    1001    Grupo   1479.0       4509   REC  2023-03-21            31.0   \n",
       "1413    1001  FatLote   1279.0       4539   REC  2023-03-22            31.0   \n",
       "\n",
       "       Pago Número Letra  ... EliminadaPJ  CodFatLote CodMarketingVei  \\\n",
       "0     False   1608    A1  ...       False         NaN            None   \n",
       "1     False    458    A2  ...       False         NaN            None   \n",
       "2     False    458    A3  ...       False         NaN            None   \n",
       "3     False    544    A2  ...       False         NaN            None   \n",
       "4     False    544    A3  ...       False         NaN            None   \n",
       "...     ...    ...   ...  ...         ...         ...             ...   \n",
       "1408  False   4385    01  ...       False       946.0            None   \n",
       "1410  False   6774    01  ...       False       971.0            None   \n",
       "1411  False    976    A1  ...       False         NaN            None   \n",
       "1412  False   4509    A1  ...       False         NaN            None   \n",
       "1413  False   4539    01  ...       False       976.0            None   \n",
       "\n",
       "      ErroCartão  IDWakeUp  WakeEmpresaRegistro  PixUrl PixTxId  PixEmv  \\\n",
       "0           None      None                 None    None    None    None   \n",
       "1           None      None                 None    None    None    None   \n",
       "2           None      None                 None    None    None    None   \n",
       "3           None      None                 None    None    None    None   \n",
       "4           None      None                 None    None    None    None   \n",
       "...          ...       ...                  ...     ...     ...     ...   \n",
       "1408        None      None                 None    None    None    None   \n",
       "1410        None      None                 None    None    None    None   \n",
       "1411        None      None                 None    None    None    None   \n",
       "1412        None      None                 None    None    None    None   \n",
       "1413        None      None                 None    None    None    None   \n",
       "\n",
       "     CodRestriçãoInnove  \n",
       "0                  None  \n",
       "1                  None  \n",
       "2                  None  \n",
       "3                  None  \n",
       "4                  None  \n",
       "...                 ...  \n",
       "1408               None  \n",
       "1410               None  \n",
       "1411               None  \n",
       "1412               None  \n",
       "1413               None  \n",
       "\n",
       "[266 rows x 67 columns]"
      ]
     },
     "execution_count": 174,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ContasReceber"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 175,
   "metadata": {},
   "outputs": [],
   "source": [
    "AReceber = ContasReceber.filter(['CodInterno','Empresa','CentroResultados','Cliente','DataEmissão','Vencimento','Saldo'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 176,
   "metadata": {},
   "outputs": [],
   "source": [
    "AReceber = AReceber.rename(columns={'CentroResultados':'CodReceita','Cliente':'CodCliente','DataEmissão':'Emissao'})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 177,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "CodInterno             int64\n",
       "Empresa                int64\n",
       "CodReceita             int64\n",
       "CodCliente             int64\n",
       "Emissao       datetime64[ns]\n",
       "Vencimento    datetime64[ns]\n",
       "Saldo                float64\n",
       "dtype: object"
      ]
     },
     "execution_count": 177,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "AReceber = AReceber.astype({'CodInterno':'int64','Empresa':'int64','CodReceita':'int64','CodCliente':'int64','Emissao':'datetime64[ns]','Vencimento':'datetime64[ns]','Saldo':'float64'})\n",
    "AReceber.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 178,
   "metadata": {},
   "outputs": [],
   "source": [
    "for i, row in AReceber.iterrows():\n",
    "    if row['Empresa'] == 1001:\n",
    "        AReceber.loc[i,'Empresa'] = 1\n",
    "\n",
    "for i, row in AReceber.iterrows():\n",
    "    if row['Empresa'] == 1002:\n",
    "        AReceber.loc[i,'Empresa'] = 2\n",
    "\n",
    "for i, row in AReceber.iterrows():\n",
    "    if row['Empresa'] == 1003:\n",
    "        AReceber.loc[i,'Empresa'] = 3"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 179,
   "metadata": {},
   "outputs": [],
   "source": [
    "emp1 = [43,47,35,7,19,93,22,17,16,8,166]\n",
    "\n",
    "for x in emp1:\n",
    "    for i, row in AReceber.iterrows():\n",
    "        if row['CodReceita'] == x:\n",
    "            AReceber.loc[i,'Empresa'] = 1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "Vencimentos = []\n",
    "ven = []\n",
    "Atraso = []\n",
    "hoje = dt.today()\n",
    "for i in AReceber['Vencimento']:\n",
    "    Vencimentos.append(i)\n",
    "for j in Vencimentos:\n",
    "    j = str(j)\n",
    "    j = da.datetime.strptime(j,'%Y-%m-%d %H:%M:%S')\n",
    "    j = dt(j.year,j.month,j.day)\n",
    "    ven.append(j)\n",
    "\n",
    "for z in ven:\n",
    "    Atraso.append((hoje - z).days)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 206,
   "metadata": {},
   "outputs": [],
   "source": [
    "AReceber['Atraso'] = Atraso"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 210,
   "metadata": {},
   "outputs": [
    {
     "ename": "KeyError",
     "evalue": "18",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mKeyError\u001b[0m                                  Traceback (most recent call last)",
      "File \u001b[1;32mc:\\Users\\Controladoria\\AppData\\Local\\Programs\\Python\\Python312\\Lib\\site-packages\\pandas\\core\\indexes\\base.py:3802\u001b[0m, in \u001b[0;36mIndex.get_loc\u001b[1;34m(self, key)\u001b[0m\n\u001b[0;32m   3801\u001b[0m \u001b[38;5;28;01mtry\u001b[39;00m:\n\u001b[1;32m-> 3802\u001b[0m     \u001b[38;5;28;01mreturn\u001b[39;00m \u001b[38;5;28;43mself\u001b[39;49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43m_engine\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mget_loc\u001b[49m\u001b[43m(\u001b[49m\u001b[43mcasted_key\u001b[49m\u001b[43m)\u001b[49m\n\u001b[0;32m   3803\u001b[0m \u001b[38;5;28;01mexcept\u001b[39;00m \u001b[38;5;167;01mKeyError\u001b[39;00m \u001b[38;5;28;01mas\u001b[39;00m err:\n",
      "File \u001b[1;32mindex.pyx:153\u001b[0m, in \u001b[0;36mpandas._libs.index.IndexEngine.get_loc\u001b[1;34m()\u001b[0m\n",
      "File \u001b[1;32mindex.pyx:182\u001b[0m, in \u001b[0;36mpandas._libs.index.IndexEngine.get_loc\u001b[1;34m()\u001b[0m\n",
      "File \u001b[1;32mpandas\\\\_libs\\\\hashtable_class_helper.pxi:2606\u001b[0m, in \u001b[0;36mpandas._libs.hashtable.Int64HashTable.get_item\u001b[1;34m()\u001b[0m\n",
      "File \u001b[1;32mpandas\\\\_libs\\\\hashtable_class_helper.pxi:2630\u001b[0m, in \u001b[0;36mpandas._libs.hashtable.Int64HashTable.get_item\u001b[1;34m()\u001b[0m\n",
      "\u001b[1;31mKeyError\u001b[0m: 18",
      "\nThe above exception was the direct cause of the following exception:\n",
      "\u001b[1;31mKeyError\u001b[0m                                  Traceback (most recent call last)",
      "Cell \u001b[1;32mIn[210], line 4\u001b[0m\n\u001b[0;32m      2\u001b[0m juros \u001b[38;5;241m=\u001b[39m []\n\u001b[0;32m      3\u001b[0m \u001b[38;5;28;01mfor\u001b[39;00m a \u001b[38;5;129;01min\u001b[39;00m \u001b[38;5;28mrange\u001b[39m(\u001b[38;5;28mlen\u001b[39m(AReceber[\u001b[38;5;124m'\u001b[39m\u001b[38;5;124mSaldo\u001b[39m\u001b[38;5;124m'\u001b[39m])):\n\u001b[1;32m----> 4\u001b[0m     k \u001b[38;5;241m=\u001b[39m \u001b[43mAReceber\u001b[49m\u001b[43m[\u001b[49m\u001b[38;5;124;43m'\u001b[39;49m\u001b[38;5;124;43mSaldo\u001b[39;49m\u001b[38;5;124;43m'\u001b[39;49m\u001b[43m]\u001b[49m\u001b[43m[\u001b[49m\u001b[43ma\u001b[49m\u001b[43m]\u001b[49m \u001b[38;5;241m*\u001b[39m AReceber[\u001b[38;5;124m'\u001b[39m\u001b[38;5;124mAtraso\u001b[39m\u001b[38;5;124m'\u001b[39m][a] \u001b[38;5;241m*\u001b[39m taxa\n\u001b[0;32m      5\u001b[0m juros\n",
      "File \u001b[1;32mc:\\Users\\Controladoria\\AppData\\Local\\Programs\\Python\\Python312\\Lib\\site-packages\\pandas\\core\\series.py:1111\u001b[0m, in \u001b[0;36mSeries.__getitem__\u001b[1;34m(self, key)\u001b[0m\n\u001b[0;32m   1108\u001b[0m     \u001b[38;5;28;01mreturn\u001b[39;00m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39m_values[key]\n\u001b[0;32m   1110\u001b[0m \u001b[38;5;28;01melif\u001b[39;00m key_is_scalar:\n\u001b[1;32m-> 1111\u001b[0m     \u001b[38;5;28;01mreturn\u001b[39;00m \u001b[38;5;28;43mself\u001b[39;49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43m_get_value\u001b[49m\u001b[43m(\u001b[49m\u001b[43mkey\u001b[49m\u001b[43m)\u001b[49m\n\u001b[0;32m   1113\u001b[0m \u001b[38;5;66;03m# Convert generator to list before going through hashable part\u001b[39;00m\n\u001b[0;32m   1114\u001b[0m \u001b[38;5;66;03m# (We will iterate through the generator there to check for slices)\u001b[39;00m\n\u001b[0;32m   1115\u001b[0m \u001b[38;5;28;01mif\u001b[39;00m is_iterator(key):\n",
      "File \u001b[1;32mc:\\Users\\Controladoria\\AppData\\Local\\Programs\\Python\\Python312\\Lib\\site-packages\\pandas\\core\\series.py:1227\u001b[0m, in \u001b[0;36mSeries._get_value\u001b[1;34m(self, label, takeable)\u001b[0m\n\u001b[0;32m   1224\u001b[0m     \u001b[38;5;28;01mreturn\u001b[39;00m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39m_values[label]\n\u001b[0;32m   1226\u001b[0m \u001b[38;5;66;03m# Similar to Index.get_value, but we do not fall back to positional\u001b[39;00m\n\u001b[1;32m-> 1227\u001b[0m loc \u001b[38;5;241m=\u001b[39m \u001b[38;5;28;43mself\u001b[39;49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mindex\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mget_loc\u001b[49m\u001b[43m(\u001b[49m\u001b[43mlabel\u001b[49m\u001b[43m)\u001b[49m\n\u001b[0;32m   1229\u001b[0m \u001b[38;5;28;01mif\u001b[39;00m is_integer(loc):\n\u001b[0;32m   1230\u001b[0m     \u001b[38;5;28;01mreturn\u001b[39;00m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39m_values[loc]\n",
      "File \u001b[1;32mc:\\Users\\Controladoria\\AppData\\Local\\Programs\\Python\\Python312\\Lib\\site-packages\\pandas\\core\\indexes\\base.py:3809\u001b[0m, in \u001b[0;36mIndex.get_loc\u001b[1;34m(self, key)\u001b[0m\n\u001b[0;32m   3804\u001b[0m     \u001b[38;5;28;01mif\u001b[39;00m \u001b[38;5;28misinstance\u001b[39m(casted_key, \u001b[38;5;28mslice\u001b[39m) \u001b[38;5;129;01mor\u001b[39;00m (\n\u001b[0;32m   3805\u001b[0m         \u001b[38;5;28misinstance\u001b[39m(casted_key, abc\u001b[38;5;241m.\u001b[39mIterable)\n\u001b[0;32m   3806\u001b[0m         \u001b[38;5;129;01mand\u001b[39;00m \u001b[38;5;28many\u001b[39m(\u001b[38;5;28misinstance\u001b[39m(x, \u001b[38;5;28mslice\u001b[39m) \u001b[38;5;28;01mfor\u001b[39;00m x \u001b[38;5;129;01min\u001b[39;00m casted_key)\n\u001b[0;32m   3807\u001b[0m     ):\n\u001b[0;32m   3808\u001b[0m         \u001b[38;5;28;01mraise\u001b[39;00m InvalidIndexError(key)\n\u001b[1;32m-> 3809\u001b[0m     \u001b[38;5;28;01mraise\u001b[39;00m \u001b[38;5;167;01mKeyError\u001b[39;00m(key) \u001b[38;5;28;01mfrom\u001b[39;00m \u001b[38;5;21;01merr\u001b[39;00m\n\u001b[0;32m   3810\u001b[0m \u001b[38;5;28;01mexcept\u001b[39;00m \u001b[38;5;167;01mTypeError\u001b[39;00m:\n\u001b[0;32m   3811\u001b[0m     \u001b[38;5;66;03m# If we have a listlike key, _check_indexing_error will raise\u001b[39;00m\n\u001b[0;32m   3812\u001b[0m     \u001b[38;5;66;03m#  InvalidIndexError. Otherwise we fall through and re-raise\u001b[39;00m\n\u001b[0;32m   3813\u001b[0m     \u001b[38;5;66;03m#  the TypeError.\u001b[39;00m\n\u001b[0;32m   3814\u001b[0m     \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39m_check_indexing_error(key)\n",
      "\u001b[1;31mKeyError\u001b[0m: 18"
     ]
    }
   ],
   "source": [
    "taxa = 0.1 / 100\n",
    "juros = []\n",
    "for a in range(len(AReceber['Saldo'])):\n",
    "    k = AReceber['Saldo'][a] * AReceber['Atraso'][a] * taxa\n",
    "juros"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "AReceber"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 207,
   "metadata": {},
   "outputs": [],
   "source": [
    "AReceber.to_excel(\"Inadimplentes.xlsx\",index=False)"
   ]
  }
 ],
 "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.12.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}