Created
August 8, 2019 17:37
-
-
Save royopa/b4634fd35e6f73f2a82d9d6c5c40713f to your computer and use it in GitHub Desktop.
ratings_sr_ratings.ipynb
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "nbformat": 4, | |
| "nbformat_minor": 0, | |
| "metadata": { | |
| "colab": { | |
| "name": "ratings_sr_ratings.ipynb", | |
| "version": "0.3.2", | |
| "provenance": [], | |
| "collapsed_sections": [], | |
| "include_colab_link": true | |
| }, | |
| "kernelspec": { | |
| "name": "python3", | |
| "display_name": "Python 3" | |
| } | |
| }, | |
| "cells": [ | |
| { | |
| "cell_type": "markdown", | |
| "metadata": { | |
| "id": "view-in-github", | |
| "colab_type": "text" | |
| }, | |
| "source": [ | |
| "<a href=\"https://colab.research.google.com/gist/royopa/b4634fd35e6f73f2a82d9d6c5c40713f/ratings_sr_ratings.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "metadata": { | |
| "id": "tbNZBidMNLhL", | |
| "colab_type": "code", | |
| "colab": {} | |
| }, | |
| "source": [ | |
| "import pandas as pd" | |
| ], | |
| "execution_count": 0, | |
| "outputs": [] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "metadata": { | |
| "id": "EklCGYCQNRAF", | |
| "colab_type": "code", | |
| "colab": {} | |
| }, | |
| "source": [ | |
| "url = 'https://docs.google.com/spreadsheets/d/1K8ZcIihZzEXNArGYkwVKrAOWhJ8BxiCJtwBADHSVOho/export?format=csv'" | |
| ], | |
| "execution_count": 0, | |
| "outputs": [] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "metadata": { | |
| "id": "wBANfWmzNSe_", | |
| "colab_type": "code", | |
| "colab": {} | |
| }, | |
| "source": [ | |
| "df = pd.read_csv(url)" | |
| ], | |
| "execution_count": 0, | |
| "outputs": [] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "metadata": { | |
| "id": "PfmCcpxNN4S4", | |
| "colab_type": "code", | |
| "colab": { | |
| "base_uri": "https://localhost:8080/", | |
| "height": 238 | |
| }, | |
| "outputId": "ee841f70-12b2-433b-8283-709f40c28c66" | |
| }, | |
| "source": [ | |
| "df.head()" | |
| ], | |
| "execution_count": 17, | |
| "outputs": [ | |
| { | |
| "output_type": "execute_result", | |
| "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>RATING ATIVOS</th>\n", | |
| " <th>Unnamed: 1</th>\n", | |
| " <th>Unnamed: 2</th>\n", | |
| " <th>Unnamed: 3</th>\n", | |
| " <th>Unnamed: 4</th>\n", | |
| " <th>Unnamed: 5</th>\n", | |
| " <th>Unnamed: 6</th>\n", | |
| " <th>EMPRESA</th>\n", | |
| " </tr>\n", | |
| " </thead>\n", | |
| " <tbody>\n", | |
| " <tr>\n", | |
| " <th>0</th>\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", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>1</th>\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", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2</th>\n", | |
| " <td>RATING CORPORATIVOS E DE INSTITUIÇÕES FINANCEIRAS</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>RATING CORPORATIVOS E DE INSTITUIÇÕES FINANCEIRAS</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>3</th>\n", | |
| " <td>EMPRESA</td>\n", | |
| " <td>NOTA GLOBAL</td>\n", | |
| " <td>EQUIVALÊNCIA BR</td>\n", | |
| " <td>TENDÊNCIA</td>\n", | |
| " <td>VIGÊNCIA DA CLASSIFICAÇÃO</td>\n", | |
| " <td>RELATÓRIO</td>\n", | |
| " <td>INFORMAÇÃO ADICIONAL</td>\n", | |
| " <td>EMPRESA</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>4</th>\n", | |
| " <td>sem ratings vigentes</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>sem ratings vigentes</td>\n", | |
| " </tr>\n", | |
| " </tbody>\n", | |
| "</table>\n", | |
| "</div>" | |
| ], | |
| "text/plain": [ | |
| " RATING ATIVOS ... EMPRESA\n", | |
| "0 NaN ... NaN\n", | |
| "1 NaN ... NaN\n", | |
| "2 RATING CORPORATIVOS E DE INSTITUIÇÕES FINANCEIRAS ... RATING CORPORATIVOS E DE INSTITUIÇÕES FINANCEIRAS\n", | |
| "3 EMPRESA ... EMPRESA\n", | |
| "4 sem ratings vigentes ... sem ratings vigentes\n", | |
| "\n", | |
| "[5 rows x 8 columns]" | |
| ] | |
| }, | |
| "metadata": { | |
| "tags": [] | |
| }, | |
| "execution_count": 17 | |
| } | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "metadata": { | |
| "id": "vwMuB0aqN5RP", | |
| "colab_type": "code", | |
| "colab": {} | |
| }, | |
| "source": [ | |
| "df.describe()\n", | |
| "# renomeia as colunas do dataframe\n", | |
| "\n", | |
| "df.rename(columns={'RATING ATIVOS':'empresa'}, inplace=True)\n", | |
| "df.rename(columns={'Unnamed: 1':'nota_global'}, inplace=True)\n", | |
| "df.rename(columns={'Unnamed: 2':'equivalencia_br'}, inplace=True)\n", | |
| "df.rename(columns={'Unnamed: 3':'tendencia'}, inplace=True)\n", | |
| "df.rename(columns={'Unnamed: 4':'vigencia'}, inplace=True)\n", | |
| "df.rename(columns={'Unnamed: 5':'relatorio'}, inplace=True)\n", | |
| "df.rename(columns={'Unnamed: 6':'info_adicional'}, inplace=True)\n", | |
| "df.rename(columns={'EMPRESA':''}, inplace=True)" | |
| ], | |
| "execution_count": 0, | |
| "outputs": [] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "metadata": { | |
| "id": "Zhh3zD7DOBtn", | |
| "colab_type": "code", | |
| "colab": {} | |
| }, | |
| "source": [ | |
| "# filtra\n", | |
| "df = df[df['empresa'].notnull()]\n", | |
| "df = df[df['nota_global'].notnull()]\n", | |
| "df = df[df['empresa'] != 'EMPRESA']\n", | |
| "df = df[df['empresa'] != 'EMPRESA E EMISSÃO']\n", | |
| "df = df[df['empresa'] != 'SECURITIZADORA E EMISSÃO']\n", | |
| "df = df[df['empresa'] != 'FUNDO']\n", | |
| "df = df[df['empresa'] != 'GESTORA']" | |
| ], | |
| "execution_count": 0, | |
| "outputs": [] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "metadata": { | |
| "id": "Fu7qscCoTT7J", | |
| "colab_type": "code", | |
| "colab": { | |
| "base_uri": "https://localhost:8080/", | |
| "height": 1000 | |
| }, | |
| "outputId": "e4240c16-f618-4dcc-906f-cc8bb3157b03" | |
| }, | |
| "source": [ | |
| "df" | |
| ], | |
| "execution_count": 44, | |
| "outputs": [ | |
| { | |
| "output_type": "execute_result", | |
| "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>nota_global</th>\n", | |
| " <th>equivalencia_br</th>\n", | |
| " <th>tendencia</th>\n", | |
| " <th>vigencia</th>\n", | |
| " <th>relatorio</th>\n", | |
| " <th>info_adicional</th>\n", | |
| " </tr>\n", | |
| " </thead>\n", | |
| " <tbody>\n", | |
| " <tr>\n", | |
| " <th>9</th>\n", | |
| " <td>FATOR SEGURADORA</td>\n", | |
| " <td>BB+SR</td>\n", | |
| " <td>brA+</td>\n", | |
| " <td>estável</td>\n", | |
| " <td>dezembro-19</td>\n", | |
| " <td>pdf</td>\n", | |
| " <td>NaN</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>13</th>\n", | |
| " <td>CIPASA\\n(5ª EMISSÃO DE DEBÊNTURES)</td>\n", | |
| " <td>BB-SR</td>\n", | |
| " <td>brA-</td>\n", | |
| " <td>estável</td>\n", | |
| " <td>novembro-19</td>\n", | |
| " <td>pdf</td>\n", | |
| " <td>NaN</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>14</th>\n", | |
| " <td>NORTH BOULEVARD JARDIM SAVÓIA EMPREENDIMENTOS ...</td>\n", | |
| " <td>BB-SR</td>\n", | |
| " <td>brA-</td>\n", | |
| " <td>estável</td>\n", | |
| " <td>dezembro-19</td>\n", | |
| " <td>pdf</td>\n", | |
| " <td>NaN</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>15</th>\n", | |
| " <td>ODEBRECHT PARTICIPAÇÕES E INVESTIMENTOS\\n(1ª E...</td>\n", | |
| " <td>DSR</td>\n", | |
| " <td>brD</td>\n", | |
| " <td>estável</td>\n", | |
| " <td>indeterminado</td>\n", | |
| " <td>pdf</td>\n", | |
| " <td>NaN</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>21</th>\n", | |
| " <td>ÁPICE SECURITIZADORA - CRI 56ª SERIE DA 1ª EMI...</td>\n", | |
| " <td>B+SR</td>\n", | |
| " <td>brBBB-</td>\n", | |
| " <td>estável</td>\n", | |
| " <td>maio-20</td>\n", | |
| " <td>pdf</td>\n", | |
| " <td>NaN</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>22</th>\n", | |
| " <td>BRAZILIAN SECURITIES CIA DE SECURITIZAÇÃO - CR...</td>\n", | |
| " <td>BBB+SR</td>\n", | |
| " <td>brAA</td>\n", | |
| " <td>estável</td>\n", | |
| " <td>dezembro-19</td>\n", | |
| " <td>pdf</td>\n", | |
| " <td>NaN</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>23</th>\n", | |
| " <td>BRAZILIAN SECURITIES CIA DE SECURITIZAÇÃO - CR...</td>\n", | |
| " <td>BB-SR</td>\n", | |
| " <td>brA-</td>\n", | |
| " <td>estável</td>\n", | |
| " <td>agosto-19</td>\n", | |
| " <td>pdf</td>\n", | |
| " <td>NaN</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>24</th>\n", | |
| " <td>BRAZILIAN SECURITIES CIA DE SECURITIZAÇÃO - CR...</td>\n", | |
| " <td>B-SR</td>\n", | |
| " <td>brBB-</td>\n", | |
| " <td>estável</td>\n", | |
| " <td>agosto-19</td>\n", | |
| " <td>pdf</td>\n", | |
| " <td>NaN</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25</th>\n", | |
| " <td>BRAZILIAN SECURITIES CIA DE SECURITIZAÇÃO - CR...</td>\n", | |
| " <td>BB+SR</td>\n", | |
| " <td>brA+</td>\n", | |
| " <td>estável</td>\n", | |
| " <td>agosto-19</td>\n", | |
| " <td>pdf</td>\n", | |
| " <td>NaN</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>26</th>\n", | |
| " <td>BSI CAPITAL SECURITIZADORA - CRA 3ª SERIE DA 1...</td>\n", | |
| " <td>BB-SR</td>\n", | |
| " <td>brA-</td>\n", | |
| " <td>negativa</td>\n", | |
| " <td>abril-19</td>\n", | |
| " <td>pdf</td>\n", | |
| " <td>em processo de revisão</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>27</th>\n", | |
| " <td>CIBRASEC SECURITIZADORA - CRI 238ª SÉRIE DA 2ª...</td>\n", | |
| " <td>BSR</td>\n", | |
| " <td>brBB+</td>\n", | |
| " <td>estável</td>\n", | |
| " <td>novembro-19</td>\n", | |
| " <td>pdf</td>\n", | |
| " <td>NaN</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>28</th>\n", | |
| " <td>FORTESEC SECURITIZADORA - CRI 42ª e 43ª SÉRIE ...</td>\n", | |
| " <td>BSR</td>\n", | |
| " <td>brBB+</td>\n", | |
| " <td>negativa</td>\n", | |
| " <td>agosto-19</td>\n", | |
| " <td>pdf</td>\n", | |
| " <td>NaN</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>29</th>\n", | |
| " <td>GAIA SECURITIZADORA - CRI 47ª SÉRIE DA 4ª EMIS...</td>\n", | |
| " <td>BB-SR</td>\n", | |
| " <td>brA-</td>\n", | |
| " <td>negativa</td>\n", | |
| " <td>novembro-19</td>\n", | |
| " <td>pdf</td>\n", | |
| " <td>NaN</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>30</th>\n", | |
| " <td>GAIA SECURITIZADORA - CRI 63ª SÉRIE DA 4ª EMIS...</td>\n", | |
| " <td>BB-SR</td>\n", | |
| " <td>brA-</td>\n", | |
| " <td>negativa</td>\n", | |
| " <td>novembro-19</td>\n", | |
| " <td>pdf</td>\n", | |
| " <td>NaN</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>31</th>\n", | |
| " <td>HABITASEC SECURITIZADORA - CRI 43ª SÉRIE DA 1ª...</td>\n", | |
| " <td>B+SR</td>\n", | |
| " <td>brBBB</td>\n", | |
| " <td>estável</td>\n", | |
| " <td>setembro-19</td>\n", | |
| " <td>pdf</td>\n", | |
| " <td>NaN</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>32</th>\n", | |
| " <td>HABITASEC SECURITIZADORA - CRI 124ª SÉRIE DA 1...</td>\n", | |
| " <td>BBSR</td>\n", | |
| " <td>brA</td>\n", | |
| " <td>estável</td>\n", | |
| " <td>janeiro-20</td>\n", | |
| " <td>pdf</td>\n", | |
| " <td>NaN</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>33</th>\n", | |
| " <td>RB CAPITAL SECURITIZADORA - CRI 25ª SÉRIE DA 1...</td>\n", | |
| " <td>BBB+SR</td>\n", | |
| " <td>brAA</td>\n", | |
| " <td>estável</td>\n", | |
| " <td>outubro-19</td>\n", | |
| " <td>pdf</td>\n", | |
| " <td>NaN</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>34</th>\n", | |
| " <td>RB CAPITAL SECURITIZADORA - CRI 73ª SÉRIE DA 1...</td>\n", | |
| " <td>BBB+SR</td>\n", | |
| " <td>brAA</td>\n", | |
| " <td>estável</td>\n", | |
| " <td>julho-19</td>\n", | |
| " <td>pdf</td>\n", | |
| " <td>em processo de revisão</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>35</th>\n", | |
| " <td>RB CAPITAL SECURITIZADORA - CRI 99ª e 100ª SÉR...</td>\n", | |
| " <td>BBB+SR</td>\n", | |
| " <td>brAA</td>\n", | |
| " <td>estável</td>\n", | |
| " <td>julho-19</td>\n", | |
| " <td>pdf</td>\n", | |
| " <td>em processo de revisão</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>36</th>\n", | |
| " <td>VERT COMPANHIA SECURITIZADORA - CRI 1ª SÉRIE D...</td>\n", | |
| " <td>BBB-SR</td>\n", | |
| " <td>brA+</td>\n", | |
| " <td>estável</td>\n", | |
| " <td>novembro-19</td>\n", | |
| " <td>pdf</td>\n", | |
| " <td>NaN</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>41</th>\n", | |
| " <td>NEW ENERGY OPTIONS\\n(CCB - R$ 266,2 MM - emiti...</td>\n", | |
| " <td>CCCSR</td>\n", | |
| " <td>brB</td>\n", | |
| " <td>negativa</td>\n", | |
| " <td>setembro-19</td>\n", | |
| " <td>pdf</td>\n", | |
| " <td>NaN</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>46</th>\n", | |
| " <td>AETHRA SISTEMAS AUTOMOTIVOS S.A. (LOCAÇÃO ATÍP...</td>\n", | |
| " <td>BB-SR</td>\n", | |
| " <td>brA-</td>\n", | |
| " <td>estável</td>\n", | |
| " <td>novembro-19</td>\n", | |
| " <td>pdf</td>\n", | |
| " <td>NaN</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>47</th>\n", | |
| " <td>COVOLAN INDUSTRIA TÊXTIL LTDA. (LOCAÇÃO ATÍPIC...</td>\n", | |
| " <td>BB-SR</td>\n", | |
| " <td>brA-</td>\n", | |
| " <td>estável</td>\n", | |
| " <td>março-20</td>\n", | |
| " <td>pdf</td>\n", | |
| " <td>NaN</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>52</th>\n", | |
| " <td>FIC-FIDC MAXPREV\\n(COTA ÚNICA)</td>\n", | |
| " <td>B-SR</td>\n", | |
| " <td>brBB-</td>\n", | |
| " <td>negativa</td>\n", | |
| " <td>julho-19</td>\n", | |
| " <td>pdf</td>\n", | |
| " <td>em processo de revisão</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>53</th>\n", | |
| " <td>ATTO FIDC MULTISSETORIAL\\n(COTA ÚNICA)</td>\n", | |
| " <td>CCCSR</td>\n", | |
| " <td>brB-</td>\n", | |
| " <td>negativa</td>\n", | |
| " <td>julho-19</td>\n", | |
| " <td>pdf</td>\n", | |
| " <td>em processo de revisão</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>54</th>\n", | |
| " <td>FIDC AMPLIC\\n(COTA SÊNIOR)</td>\n", | |
| " <td>BB-SR</td>\n", | |
| " <td>brA-</td>\n", | |
| " <td>estável</td>\n", | |
| " <td>abril-19</td>\n", | |
| " <td>pdf</td>\n", | |
| " <td>em processo de revisão</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>55</th>\n", | |
| " <td>FIDC CATERPILLAR DO SEGMENTO INDUSTRIAL II\\n(C...</td>\n", | |
| " <td>BBB-SR</td>\n", | |
| " <td>brAA-</td>\n", | |
| " <td>estável</td>\n", | |
| " <td>julho-19</td>\n", | |
| " <td>pdf</td>\n", | |
| " <td>em processo de revisão</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>56</th>\n", | |
| " <td>FIDC CORAL</td>\n", | |
| " <td>CSR</td>\n", | |
| " <td>brC</td>\n", | |
| " <td>estável</td>\n", | |
| " <td>julho-19</td>\n", | |
| " <td>pdf</td>\n", | |
| " <td>em processo de revisão</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>57</th>\n", | |
| " <td>FIDC CREDIFIT MULTISETORIAL\\n(COTA MEZANINO)</td>\n", | |
| " <td>BSR</td>\n", | |
| " <td>brBB+</td>\n", | |
| " <td>negativa</td>\n", | |
| " <td>julho-19</td>\n", | |
| " <td>pdf</td>\n", | |
| " <td>em processo de revisão</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>58</th>\n", | |
| " <td>FIDC CREDIFIT MULTISETORIAL\\n(COTA PRIVATE)</td>\n", | |
| " <td>BB-SR</td>\n", | |
| " <td>brA-</td>\n", | |
| " <td>negativa</td>\n", | |
| " <td>julho-19</td>\n", | |
| " <td>pdf</td>\n", | |
| " <td>em processo de revisão</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>59</th>\n", | |
| " <td>FIDC CREDIFIT MULTISETORIAL\\n(COTA SÊNIOR)</td>\n", | |
| " <td>BBB-SR</td>\n", | |
| " <td>brAA-</td>\n", | |
| " <td>negativa</td>\n", | |
| " <td>julho-19</td>\n", | |
| " <td>pdf</td>\n", | |
| " <td>em processo de revisão</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>60</th>\n", | |
| " <td>FIDC GP FCVS I\\n(COTA SÊNIOR)</td>\n", | |
| " <td>B+SR</td>\n", | |
| " <td>brBBB</td>\n", | |
| " <td>estável</td>\n", | |
| " <td>julho-19</td>\n", | |
| " <td>pdf</td>\n", | |
| " <td>em processo de revisão</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>61</th>\n", | |
| " <td>FIDC GP FCVS II\\n(COTA SÊNIOR)</td>\n", | |
| " <td>BSR</td>\n", | |
| " <td>brBB+</td>\n", | |
| " <td>negativa</td>\n", | |
| " <td>julho-19</td>\n", | |
| " <td>pdf</td>\n", | |
| " <td>em processo de revisão</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>62</th>\n", | |
| " <td>FIDC ONE NP\\n(COTA SÊNIOR)\\nanteriormente FIDC...</td>\n", | |
| " <td>BSR</td>\n", | |
| " <td>brBB+</td>\n", | |
| " <td>estável</td>\n", | |
| " <td>julho-19</td>\n", | |
| " <td>pdf</td>\n", | |
| " <td>em processo de revisão</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>63</th>\n", | |
| " <td>FIDC POLO CLUBES\\n(COTA ÚNICA)</td>\n", | |
| " <td>BBB-SR</td>\n", | |
| " <td>brA+</td>\n", | |
| " <td>estável</td>\n", | |
| " <td>julho-19</td>\n", | |
| " <td>pdf</td>\n", | |
| " <td>em processo de revisão</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>64</th>\n", | |
| " <td>FIDC QUATÁ MULTISETORIAL\\n(COTA ÚNICA)</td>\n", | |
| " <td>BBB+SR</td>\n", | |
| " <td>brAA</td>\n", | |
| " <td>estável</td>\n", | |
| " <td>julho-19</td>\n", | |
| " <td>pdf</td>\n", | |
| " <td>em processo de revisão</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>65</th>\n", | |
| " <td>FIDC RECEBÍVEIS ENEVA\\n(COTAS SÊNIOR E SUBORDI...</td>\n", | |
| " <td>BB+SR</td>\n", | |
| " <td>brA+</td>\n", | |
| " <td>estável</td>\n", | |
| " <td>julho-19</td>\n", | |
| " <td>pdf</td>\n", | |
| " <td>em processo de revisão</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>66</th>\n", | |
| " <td>FIDC RECEBÍVEIS RODOANEL TRECHO OESTE\\n(COTAS ...</td>\n", | |
| " <td>BBSR</td>\n", | |
| " <td>brA</td>\n", | |
| " <td>estável</td>\n", | |
| " <td>julho-19</td>\n", | |
| " <td>pdf</td>\n", | |
| " <td>em processo de revisão</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>67</th>\n", | |
| " <td>FIDC RENOVA\\n(COTAS SÊNIOR)</td>\n", | |
| " <td>BB-SR</td>\n", | |
| " <td>brA-</td>\n", | |
| " <td>estável</td>\n", | |
| " <td>outubro-18</td>\n", | |
| " <td>pdf</td>\n", | |
| " <td>em processo de revisão</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>68</th>\n", | |
| " <td>FIDC TRADEMAX MULTISETORIAL\\n(COTA SÊNIOR)</td>\n", | |
| " <td>BB+SR</td>\n", | |
| " <td>brA+</td>\n", | |
| " <td>estável</td>\n", | |
| " <td>julho-19</td>\n", | |
| " <td>pdf</td>\n", | |
| " <td>em processo de revisão</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>69</th>\n", | |
| " <td>FIDC TRADEMAX MULTISETORIAL\\n(COTA MEZANINO)</td>\n", | |
| " <td>B+SR</td>\n", | |
| " <td>brBBB</td>\n", | |
| " <td>estável</td>\n", | |
| " <td>julho-19</td>\n", | |
| " <td>pdf</td>\n", | |
| " <td>em processo de revisão</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>70</th>\n", | |
| " <td>FIDC YAP NP\\n(COTA ÚNICA)</td>\n", | |
| " <td>CSR</td>\n", | |
| " <td>brC</td>\n", | |
| " <td>estável</td>\n", | |
| " <td>julho-19</td>\n", | |
| " <td>pdf</td>\n", | |
| " <td>em processo de revisão</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>71</th>\n", | |
| " <td>INVISTA MARK HIGH YIELD FIDC NP\\n(COTA SÊNIOR)</td>\n", | |
| " <td>B+SR</td>\n", | |
| " <td>brBBB</td>\n", | |
| " <td>estável</td>\n", | |
| " <td>julho-19</td>\n", | |
| " <td>pdf</td>\n", | |
| " <td>em processo de revisão</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>72</th>\n", | |
| " <td>INVISTA MARK HIGH YIELD FIDC NP\\n(COTA SUBORDI...</td>\n", | |
| " <td>BSR</td>\n", | |
| " <td>brBB</td>\n", | |
| " <td>estável</td>\n", | |
| " <td>julho-19</td>\n", | |
| " <td>pdf</td>\n", | |
| " <td>em processo de revisão</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>73</th>\n", | |
| " <td>INVISTA MARK HIGH YIELD FIDC NP\\n(COTA SUBORDI...</td>\n", | |
| " <td>B-SR</td>\n", | |
| " <td>brB+</td>\n", | |
| " <td>estável</td>\n", | |
| " <td>julho-19</td>\n", | |
| " <td>pdf</td>\n", | |
| " <td>em processo de revisão</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>74</th>\n", | |
| " <td>PRASS FIDC II\\n(COTA SÊNIOR)</td>\n", | |
| " <td>BBBSR</td>\n", | |
| " <td>brAA</td>\n", | |
| " <td>estável</td>\n", | |
| " <td>julho-19</td>\n", | |
| " <td>pdf</td>\n", | |
| " <td>em processo de revisão</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>75</th>\n", | |
| " <td>UPPER FIDC II\\n(COTA SÊNIOR)</td>\n", | |
| " <td>BSR</td>\n", | |
| " <td>brBB+</td>\n", | |
| " <td>positiva</td>\n", | |
| " <td>julho-19</td>\n", | |
| " <td>pdf</td>\n", | |
| " <td>em processo de revisão</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>80</th>\n", | |
| " <td>ELLEVEN GESTORA</td>\n", | |
| " <td>G3-SR</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>estável</td>\n", | |
| " <td>janeiro-20</td>\n", | |
| " <td>pdf</td>\n", | |
| " <td>NaN</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>81</th>\n", | |
| " <td>FINACAP</td>\n", | |
| " <td>G3SR</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>estável</td>\n", | |
| " <td>julho-19</td>\n", | |
| " <td>pdf</td>\n", | |
| " <td>NaN</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>82</th>\n", | |
| " <td>INFINITY ASSET MANAGEMENT</td>\n", | |
| " <td>G3SR</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>positiva</td>\n", | |
| " <td>março-19</td>\n", | |
| " <td>pdf</td>\n", | |
| " <td>em processo de revisão</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>83</th>\n", | |
| " <td>META ASSET MANAGEMENT</td>\n", | |
| " <td>G3+SR</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>estável</td>\n", | |
| " <td>abril-20</td>\n", | |
| " <td>pdf</td>\n", | |
| " <td>NaN</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>84</th>\n", | |
| " <td>ÚNICA ADMINISTRAÇÃO E GESTÃO DE RECURSOS</td>\n", | |
| " <td>G3SR</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>estável</td>\n", | |
| " <td>outubro-19</td>\n", | |
| " <td>pdf</td>\n", | |
| " <td>NaN</td>\n", | |
| " </tr>\n", | |
| " </tbody>\n", | |
| "</table>\n", | |
| "</div>" | |
| ], | |
| "text/plain": [ | |
| " empresa ... info_adicional\n", | |
| "9 FATOR SEGURADORA ... NaN\n", | |
| "13 CIPASA\\n(5ª EMISSÃO DE DEBÊNTURES) ... NaN\n", | |
| "14 NORTH BOULEVARD JARDIM SAVÓIA EMPREENDIMENTOS ... ... NaN\n", | |
| "15 ODEBRECHT PARTICIPAÇÕES E INVESTIMENTOS\\n(1ª E... ... NaN\n", | |
| "21 ÁPICE SECURITIZADORA - CRI 56ª SERIE DA 1ª EMI... ... NaN\n", | |
| "22 BRAZILIAN SECURITIES CIA DE SECURITIZAÇÃO - CR... ... NaN\n", | |
| "23 BRAZILIAN SECURITIES CIA DE SECURITIZAÇÃO - CR... ... NaN\n", | |
| "24 BRAZILIAN SECURITIES CIA DE SECURITIZAÇÃO - CR... ... NaN\n", | |
| "25 BRAZILIAN SECURITIES CIA DE SECURITIZAÇÃO - CR... ... NaN\n", | |
| "26 BSI CAPITAL SECURITIZADORA - CRA 3ª SERIE DA 1... ... em processo de revisão\n", | |
| "27 CIBRASEC SECURITIZADORA - CRI 238ª SÉRIE DA 2ª... ... NaN\n", | |
| "28 FORTESEC SECURITIZADORA - CRI 42ª e 43ª SÉRIE ... ... NaN\n", | |
| "29 GAIA SECURITIZADORA - CRI 47ª SÉRIE DA 4ª EMIS... ... NaN\n", | |
| "30 GAIA SECURITIZADORA - CRI 63ª SÉRIE DA 4ª EMIS... ... NaN\n", | |
| "31 HABITASEC SECURITIZADORA - CRI 43ª SÉRIE DA 1ª... ... NaN\n", | |
| "32 HABITASEC SECURITIZADORA - CRI 124ª SÉRIE DA 1... ... NaN\n", | |
| "33 RB CAPITAL SECURITIZADORA - CRI 25ª SÉRIE DA 1... ... NaN\n", | |
| "34 RB CAPITAL SECURITIZADORA - CRI 73ª SÉRIE DA 1... ... em processo de revisão\n", | |
| "35 RB CAPITAL SECURITIZADORA - CRI 99ª e 100ª SÉR... ... em processo de revisão\n", | |
| "36 VERT COMPANHIA SECURITIZADORA - CRI 1ª SÉRIE D... ... NaN\n", | |
| "41 NEW ENERGY OPTIONS\\n(CCB - R$ 266,2 MM - emiti... ... NaN\n", | |
| "46 AETHRA SISTEMAS AUTOMOTIVOS S.A. (LOCAÇÃO ATÍP... ... NaN\n", | |
| "47 COVOLAN INDUSTRIA TÊXTIL LTDA. (LOCAÇÃO ATÍPIC... ... NaN\n", | |
| "52 FIC-FIDC MAXPREV\\n(COTA ÚNICA) ... em processo de revisão\n", | |
| "53 ATTO FIDC MULTISSETORIAL\\n(COTA ÚNICA) ... em processo de revisão\n", | |
| "54 FIDC AMPLIC\\n(COTA SÊNIOR) ... em processo de revisão\n", | |
| "55 FIDC CATERPILLAR DO SEGMENTO INDUSTRIAL II\\n(C... ... em processo de revisão\n", | |
| "56 FIDC CORAL ... em processo de revisão\n", | |
| "57 FIDC CREDIFIT MULTISETORIAL\\n(COTA MEZANINO) ... em processo de revisão\n", | |
| "58 FIDC CREDIFIT MULTISETORIAL\\n(COTA PRIVATE) ... em processo de revisão\n", | |
| "59 FIDC CREDIFIT MULTISETORIAL\\n(COTA SÊNIOR) ... em processo de revisão\n", | |
| "60 FIDC GP FCVS I\\n(COTA SÊNIOR) ... em processo de revisão\n", | |
| "61 FIDC GP FCVS II\\n(COTA SÊNIOR) ... em processo de revisão\n", | |
| "62 FIDC ONE NP\\n(COTA SÊNIOR)\\nanteriormente FIDC... ... em processo de revisão\n", | |
| "63 FIDC POLO CLUBES\\n(COTA ÚNICA) ... em processo de revisão\n", | |
| "64 FIDC QUATÁ MULTISETORIAL\\n(COTA ÚNICA) ... em processo de revisão\n", | |
| "65 FIDC RECEBÍVEIS ENEVA\\n(COTAS SÊNIOR E SUBORDI... ... em processo de revisão\n", | |
| "66 FIDC RECEBÍVEIS RODOANEL TRECHO OESTE\\n(COTAS ... ... em processo de revisão\n", | |
| "67 FIDC RENOVA\\n(COTAS SÊNIOR) ... em processo de revisão\n", | |
| "68 FIDC TRADEMAX MULTISETORIAL\\n(COTA SÊNIOR) ... em processo de revisão\n", | |
| "69 FIDC TRADEMAX MULTISETORIAL\\n(COTA MEZANINO) ... em processo de revisão\n", | |
| "70 FIDC YAP NP\\n(COTA ÚNICA) ... em processo de revisão\n", | |
| "71 INVISTA MARK HIGH YIELD FIDC NP\\n(COTA SÊNIOR) ... em processo de revisão\n", | |
| "72 INVISTA MARK HIGH YIELD FIDC NP\\n(COTA SUBORDI... ... em processo de revisão\n", | |
| "73 INVISTA MARK HIGH YIELD FIDC NP\\n(COTA SUBORDI... ... em processo de revisão\n", | |
| "74 PRASS FIDC II\\n(COTA SÊNIOR) ... em processo de revisão\n", | |
| "75 UPPER FIDC II\\n(COTA SÊNIOR) ... em processo de revisão\n", | |
| "80 ELLEVEN GESTORA ... NaN\n", | |
| "81 FINACAP ... NaN\n", | |
| "82 INFINITY ASSET MANAGEMENT ... em processo de revisão\n", | |
| "83 META ASSET MANAGEMENT ... NaN\n", | |
| "84 ÚNICA ADMINISTRAÇÃO E GESTÃO DE RECURSOS ... NaN\n", | |
| "\n", | |
| "[52 rows x 7 columns]" | |
| ] | |
| }, | |
| "metadata": { | |
| "tags": [] | |
| }, | |
| "execution_count": 44 | |
| } | |
| ] | |
| } | |
| ] | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment