companies with more than 100 output % input flow ratio.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# THis notebook analyzes all the companies that produce more than 100 times their own input volume of wood"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/bcoelho/.local/lib/python3.6/site-packages/IPython/core/interactiveshell.py:2785: DtypeWarning: Columns (11,17,18,19,20,33,34,35,36,51) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    }
   ],
   "source": [
    "data = pd.read_csv('sample_data_short.csv', sep = ';')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Data reshape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "ut_avoid = {'Cancelado', 'Suspenso'}\n",
    "data.query('ultima_transacao not in @ut_avoid', inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [],
   "source": [
    "#temp = data.groupby('numero_serie_dof').nth(0)\n",
    "#temp.drop(columns=['volume', 'valor'], inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [],
   "source": [
    "#data = pd.concat([temp, data.groupby('numero_serie_dof')[['volume', 'valor']].sum()], axis = 1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Elo volume change ratio"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['Madeira serrada bruta', 'Produtos acabados de madeira', 'Tora',\n",
       "       'Blocos e dormentes', 'Resíduos industriais',\n",
       "       'Toretes, estacas, palanques e mourões',\n",
       "       'Cavacos, lascas, cascas e rachas', 'Chapas e Lâminas de madeira',\n",
       "       'Carvão e lenha'], dtype=object)"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.produto_agrupado.unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "elo1 = {'Tora'}\n",
    "elo2 = {'Madeira serrada bruta', \n",
    "        'Blocos e dormentes', 'Chapas e Lâminas de madeira'}\n",
    "elo_non_tora = {'Madeira serrada bruta', 'Produtos acabados de madeira', \n",
    "       'Blocos e dormentes', 'Resíduos industriais',\n",
    "       'Toretes, estacas, palanques e mourões',\n",
    "       'Cavacos, lascas, cascas e rachas', 'Chapas e Lâminas de madeira',\n",
    "       'Carvão e lenha'}\n",
    "elo3 = {'Produtos acabados de madeira'}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "remetentes = data.nome_remetente.unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "A A PORTAS & PORTAS LTDA - ME                                                   NaN\n",
       "A BREVE FERREIRA ME                                                             NaN\n",
       "A D PORTAS E JANELAS EIRELI                                                     NaN\n",
       "A M C MADEIRAS LTDA                                                             NaN\n",
       "A NOVACK JUNIOR EPP                                                             NaN\n",
       "A P T COMERCIO DE MADEIRAS EIRELI                                          1.060531\n",
       "A R JONAS EIRELI - ME                                                           NaN\n",
       "A R LEMES MADEIRAS - ME                                                    2.665304\n",
       "A S DA SILVA BIBIANO IMPORT E EXPORT - ME                                       NaN\n",
       "A S MEIRA - ME                                                             1.610829\n",
       "A. A. MARQUES LTDA ME                                                           NaN\n",
       "A. A. PENA - ME                                                                 NaN\n",
       "A. C DOS SANTOS INDUSTRIA COMERCIO IMPORTAÇÃO E EXPORTAÇÃO DE MADEIRA      9.430607\n",
       "A. C. CORREA FILHO EPP                                                          NaN\n",
       "A. C. DE PAIVA - ME                                                             NaN\n",
       "A. DA SILVA TAVARES EIRELI EPP                                                  NaN\n",
       "A. E. PETROSKI MADEIRAS - ME                                               1.470239\n",
       "A. F. DOS SANTOS EIRELI - ME                                                    NaN\n",
       "A. G. DE A. NETO FERREIRA ME                                                    NaN\n",
       "A. J. COMERCIO DE MADEIRA LTDA - ME                                             NaN\n",
       "A. JOSE DA SILVA - ME                                                           NaN\n",
       "A. P. C. DE SOUSA                                                               NaN\n",
       "A. P. MACHADO COMERCIO E BENEFICIAMENTO DE MADEIRAS EIRELI - ME            0.025910\n",
       "A. P. MACHADO MADEIRAS                                                          NaN\n",
       "A. R. INDUSTRIA E COMERCIO DE MADEIRAS LTDA - EPP                          1.029400\n",
       "A. R. SOUZA COELHO MADEIRAS - ME                                                NaN\n",
       "A. R. WINK - ME                                                                 NaN\n",
       "A. S. DO NASCIMENTO ME                                                     0.770573\n",
       "A. S. GUEDES EIRELI - EPP                                                  0.554319\n",
       "A.C.RIBEIRO MADEIRAS -ME                                                   2.131622\n",
       "                                                                            ...    \n",
       "W C DA SILVA - ME                                                               NaN\n",
       "W O DA SILVA MADEIRAS - ME                                                      NaN\n",
       "W R COMERCIO DE MADEIRAS LTDA ME                                                NaN\n",
       "W T PORTAIS EIRELI - EPP                                                        NaN\n",
       "W. C. DA SILVA - ME                                                             NaN\n",
       "W. DE S. CAMPOS - ME                                                            NaN\n",
       "W. ELIAS DE RESENDE - EIRELI - EPP                                         2.684100\n",
       "W. F. DOS SANTOS - (ME)                                                    9.739673\n",
       "W. S. SENES - ME                                                         303.485986\n",
       "W.J.BATTISTI & CIA LTDA                                                    3.026017\n",
       "W.L. GAVA COMERCIO DE MADEIRAS ME                                               NaN\n",
       "W.S. DE OLIVEIRA COMERCIO DE CARVÃO                                             NaN\n",
       "W20 INDUSTRIA E COMERCIO DE MADEIRAS LTDA-ME                               0.177086\n",
       "WAGNER GONCALVES - ME                                                           NaN\n",
       "WANDERLEY ALENCAR NUNES - ME                                                    NaN\n",
       "WEVERTON DE ANDRADE ME                                                          NaN\n",
       "WFL PEIXOTO REPRESENTAÇÃO E COMÉRCIO DE MATERIAS PARA COSNTRUÇÃO           1.131345\n",
       "WILLIANE S. PEREIRA                                                             NaN\n",
       "WIRLEIDE F. DOS SANTOS - (ME)                                            139.674170\n",
       "WOOD NORTE MADEIRAS EIRELI - ME                                           13.640860\n",
       "WOOD SHOPPING EIRELI - EPP                                                 3.161356\n",
       "WOODLAND COMERCIO IMPORTAÇÃO E EXPORTAÇÃO LTDA                                  NaN\n",
       "WOODSADI DO GUATA, INDUSTRIA E COMERCIO DE MADEIRAS LTDA - ME                   NaN\n",
       "YOKOTA & BARBOSA LTDA. -ME                                                      NaN\n",
       "Z. M. MARCENARIA E COMÉRCIO DE MADEIRAS LTDA - ME                               NaN\n",
       "ZAMPIERÃO & ZAMPIERÃO LTDA                                                      NaN\n",
       "ZILKE MADEIRAS LTDA                                                        1.243499\n",
       "ZORNITA & SEGALLA LTDA                                                          NaN\n",
       "ÁGUIA IMPORTAÇÃO E EXPORTAÇÃO LTDA - ME                                         NaN\n",
       "ÁGUIA WOOD PRODUCTS IMPORTAÇÃO E EXPORTAÇÃO DE MADEIRAS LTDA                    NaN\n",
       "Name: volume, Length: 1231, dtype: float64"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "elo1 = {'Tora'}\n",
    "elo2 = elo_non_tora\n",
    "\n",
    "X1 = data.query('produto_agrupado in @elo1 and nome_destinatario in @remetentes')\n",
    "vol_elo1 = X1.groupby('nome_destinatario')['volume'].sum()\n",
    "\n",
    "X2out = data.query('produto_agrupado in @elo2')\n",
    "vol_elo2out = X2out.groupby('nome_remetente')['volume'].sum()\n",
    "\n",
    "ratio_2_over_1 = vol_elo2out / vol_elo1\n",
    "ratio_2_over_1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.lines.Line2D at 0x7f3a4c82a2e8>"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAsMAAAKvCAYAAACPusJjAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDMuMC4zLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvnQurowAAGlBJREFUeJzt3X+M7Xld3/HXWwaqqBHtTpWyOx3a4iZIBO2VYontCtqsXsM2KX/splCwmJuYitiQkKtNS+pft63xR3+k5gZWaEsWDVJLvdqyUei2CazdXUEWFiqht7gUu8C2YKOBbn33j3tw18vcO3Pn/Ji58348kps7c853zvc95zNn9rnf+535VncHAAAm+rKjHgAAAI6KGAYAYCwxDADAWGIYAICxxDAAAGOJYQAAxhLDAACMJYYBABhLDAMAMNbWJnd2ww039O7u7iZ3CRzURz5y6e+bbz7aOQBgBe6///5Pd/f2ftttNIZ3d3dz3333bXKXwEHdcsulv9/97qOcAgBWoqr++0G2c5oEAABjiWEAAMYSwwAAjCWGAQAYSwwDADCWGAYAYCwxDADAWGIYAICxxDAAAGOJYQAAxhLDAACMJYYBABhLDAMAMJYYBgBgLDEMAMBYYhgAgLHEMAAAY4lhAADGEsMAAIwlhgEAGEsMAwAwlhgGAGAsMQwAwFhiGACAscQwAABjiWEAAMYSwwAAjCWGAQAYSwwDADCWGAYAYKytox4Apto9e+GK9108d3qDkwDAXI4MAwAwlhgGAGAsMQwAwFhiGACAscQwAABjiWEAAMYSwwAAjCWGAQAYSwwDADCWGAYAYCwxDADAWGIYAICxxDAAAGOJYQAAxhLDAACMJYYBABhLDAMAMJYYBgBgLDEMAMBYYhgAgLHEMAAAY4lhAADGEsMAAIwlhgEAGEsMAwAwlhgGAGAsMQwAwFhiGACAscQwAABjiWEAAMYSwwAAjLVvDFfVnVX1SFU9eNntr66qD1fVB6vqH61vRAAAWI+DHBl+U5Jbn3hDVX1nktuSPLe7vynJT6x+NAAAWK99Y7i770ny6GU3/2CSc939+cU2j6xhNgAAWKvDnjP8jUm+o6rurar/WFXftsqhAABgE7aW+LivS/KCJN+W5Beq6s92d1++YVWdSXImSXZ2dg47Jxx7u2cv7Hn7xXOnNzwJAHBQhz0y/HCSt/clv5HkD5PcsNeG3X2+u09196nt7e3DzgkAACt32Bj+pSTfmSRV9Y1JnpLk06saCgAANmHf0ySq6q4ktyS5oaoeTvL6JHcmuXPx69a+kOQVe50iAQAAx9m+Mdzdd1zhrpeteBYAANgoV6ADAGAsMQwAwFhiGACAscQwAABjiWEAAMYSwwAAjCWGAQAYSwwDADCWGAYAYCwxDADAWGIYAICxxDAAAGOJYQAAxhLDAACMJYYBABhLDAMAMJYYBgBgLDEMAMBYYhgAgLHEMAAAY4lhAADGEsMAAIwlhgEAGEsMAwAwlhgGAGAsMQwAwFhiGACAscQwAABjiWEAAMYSwwAAjCWGAQAYSwwDADDW1lEPAFeze/bCnrdfPHd6w5MAACeRI8MAAIwlhgEAGEsMAwAwlhgGAGAsMQwAwFhiGACAscQwAABjiWEAAMYSwwAAjCWGAQAYSwwDADCWGAYAYCwxDADAWGIYAICxxDAAAGOJYQAAxhLDAACMJYYBABhLDAMAMJYYBgBgLDEMAMBYYhgAgLHEMAAAY4lhAADGEsMAAIwlhgEAGEsMAwAwlhgGAGAsMQwAwFhiGACAscQwAABj7RvDVXVnVT1SVQ/ucd9rq6qr6ob1jAcAAOtzkCPDb0py6+U3VtVNSf5qko+veCYAANiIfWO4u+9J8uged/1Uktcl6VUPBQAAm3Coc4ar6rYkn+ju9694HgAA2Jita/2Aqnpqkh/LpVMkDrL9mSRnkmRnZ+dadwcAAGtzmCPDfy7JM5O8v6ouJrkxyQNV9Q17bdzd57v7VHef2t7ePvykAACwYtd8ZLi7P5DkT33x/UUQn+ruT69wLgAAWLuD/Gq1u5K8J8nNVfVwVb1q/WMBAMD67XtkuLvv2Of+3ZVNAwAAG+QKdAAAjCWGAQAYSwwDADCWGAYAYCwxDADAWGIYAICxxDAAAGOJYQAAxhLDAACMJYYBABhLDAMAMJYYBgBgLDEMAMBYYhgAgLHEMAAAY4lhAADGEsMAAIwlhgEAGEsMAwAwlhgGAGAsMQwAwFhiGACAscQwAABjiWEAAMYSwwAAjCWGAQAYSwwDADCWGAYAYCwxDADAWGIYAICxxDAAAGOJYQAAxhLDAACMJYYBABhLDAMAMJYYBgBgLDEMAMBYYhgAgLHEMAAAY4lhAADGEsMAAIwlhgEAGEsMAwAwlhgGAGAsMQwAwFhiGACAscQwAABjiWEAAMYSwwAAjCWGAQAYSwwDADCWGAYAYCwxDADAWGIYAICxxDAAAGOJYQAAxhLDAACMJYYBABhLDAMAMJYYBgBgLDEMAMBYYhgAgLHEMAAAY4lhAADG2jeGq+rOqnqkqh58wm3/uKo+XFW/VVX/pqqett4xAQBg9Q5yZPhNSW697La7kzynu785yX9N8qMrngsAANZu3xju7nuSPHrZbe/s7scW7743yY1rmA0AANZqFecM/60kv7qCxwEAgI3aWuaDq+rvJnksyVuuss2ZJGeSZGdnZ5ndwVrsnr2w5+0Xz53e8CSPu9aZjuPnAADXg0MfGa6qVyb5viR/o7v7Stt19/nuPtXdp7a3tw+7OwAAWLlDHRmuqluTvC7JX+nu31/tSAAAsBkH+dVqdyV5T5Kbq+rhqnpVkn+W5KuT3F1V76uqn13znAAAsHL7Hhnu7jv2uPmNa5gFAAA2yhXoAAAYSwwDADCWGAYAYCwxDADAWGIYAICxxDAAAGOJYQAAxhLDAACMJYYBABhLDAMAMJYYBgBgLDEMAMBYYhgAgLHEMAAAY4lhAADGEsMAAIwlhgEAGEsMAwAwlhgGAGAsMQwAwFhiGACAscQwAABjiWEAAMYSwwAAjCWGAQAYSwwDADCWGAYAYCwxDADAWGIYAICxxDAAAGOJYQAAxhLDAACMtXXUAzDL7tkLe95+8dzpI3kclmctALieOTIMAMBYYhgAgLHEMAAAY4lhAADGEsMAAIwlhgEAGEsMAwAwlhgGAGAsMQwAwFhiGACAscQwAABjiWEAAMYSwwAAjCWGAQAYSwwDADCWGAYAYCwxDADAWGIYAICxxDAAAGOJYQAAxhLDAACMJYYBABhLDAMAMJYYBgBgLDEMAMBYYhgAgLHEMAAAY4lhAADGEsMAAIwlhgEAGEsMAwAwlhgGAGCsfWO4qu6sqkeq6sEn3PZ1VXV3Vf324u+vXe+YAACwegc5MvymJLdedtvZJL/W3c9K8muL9wEA4Lqybwx39z1JHr3s5tuSvHnx9puT/LUVzwUAAGu3dciP+/ru/uTi7d9N8vVX2rCqziQ5kyQ7OzuH3B2rtHv2wp63Xzx3esOTbNaVPm8e996PfSa3e54AGGTpH6Dr7k7SV7n/fHef6u5T29vby+4OAABW5rAx/D+r6ulJsvj7kdWNBAAAm3HYGH5Hklcs3n5Fkn+7mnEAAGBzDvKr1e5K8p4kN1fVw1X1qiTnknx3Vf12ku9avA8AANeVfX+ArrvvuMJdL17xLAAAsFGuQAcAwFhiGACAscQwAABjiWEAAMYSwwAAjCWGAQAYSwwDADCWGAYAYCwxDADAWGIYAICxxDAAAGOJYQAAxhLDAACMJYYBABhLDAMAMJYYBgBgLDEMAMBYYhgAgLHEMAAAY4lhAADGEsMAAIwlhgEAGEsMAwAwlhgGAGAsMQwAwFhiGACAscQwAABjiWEAAMYSwwAAjCWGAQAYSwwDADDW1lEPsAm7Zy9c8b6L505vcBImutrXH1zp68P3JoDNcGQYAICxxDAAAGOJYQAAxhLDAACMJYYBABhLDAMAMJYYBgBgLDEMAMBYYhgAgLHEMAAAY4lhAADGEsMAAIwlhgEAGEsMAwAwlhgGAGAsMQwAwFhiGACAscQwAABjiWEAAMYSwwAAjCWGAQAYSwwDADCWGAYAYCwxDADAWGIYAICxxDAAAGOJYQAAxhLDAACMJYYBABhLDAMAMJYYBgBgLDEMAMBYS8VwVf2dqvpgVT1YVXdV1ZevajAAAFi3Q8dwVT0jyQ8nOdXdz0nypCS3r2owAABYt2VPk9hK8hVVtZXkqUn+x/IjAQDAZmwd9gO7+xNV9RNJPp7kD5K8s7vfefl2VXUmyZkk2dnZOezuxtg9e+GK9108d3qDk+zvOM56tZkmutLzcdy+lg7jJH9uVzP18wZYl2VOk/jaJLcleWaSP53kK6vqZZdv193nu/tUd5/a3t4+/KQAALBiy5wm8V1J/lt3f6q7/2+Styf5S6sZCwAA1m+ZGP54khdU1VOrqpK8OMlDqxkLAADW79Ax3N33JnlbkgeSfGDxWOdXNBcAAKzdoX+ALkm6+/VJXr+iWQAAYKNcgQ4AgLHEMAAAY4lhAADGEsMAAIwlhgEAGEsMAwAwlhgGAGAsMQwAwFhiGACAscQwAABjiWEAAMYSwwAAjCWGAQAYSwwDADCWGAYAYCwxDADAWGIYAICxxDAAAGOJYQAAxhLDAACMJYYBABhLDAMAMJYYBgBgLDEMAMBYYhgAgLHEMAAAY4lhAADGEsMAAIwlhgEAGEsMAwAwlhgGAGCsraMegIPbPXthz9svnjt9JPs96Y7q+T4pPH8AXA8cGQYAYCwxDADAWGIYAICxxDAAAGOJYQAAxhLDAACMJYYBABhLDAMAMJYYBgBgLDEMAMBYYhgAgLHEMAAAY4lhAADGEsMAAIwlhgEAGEsMAwAwlhgGAGAsMQwAwFhiGACAscQwAABjiWEAAMYSwwAAjCWGAQAYSwwDADCWGAYAYCwxDADAWGIYAICxxDAAAGOJYQAAxhLDAACMJYYBABhLDAMAMNZSMVxVT6uqt1XVh6vqoar69lUNBgAA67a15Mf/TJJ/390vraqnJHnqCmYCAICNOHQMV9XXJPnLSV6ZJN39hSRfWM1YAACwfsucJvHMJJ9K8nNV9ZtV9Yaq+soVzQUAAGu3zGkSW0m+Ncmru/veqvqZJGeT/L0nblRVZ5KcSZKdnZ0ldsf1ZPfshaMeYW1O8ucGANMsc2T44SQPd/e9i/fflktx/Md09/nuPtXdp7a3t5fYHQAArNahY7i7fzfJ71TVzYubXpzkQyuZCgAANmDZ3ybx6iRvWfwmiY8l+f7lRwIAgM1YKoa7+31JTq1oFgAA2ChXoAMAYCwxDADAWGIYAICxxDAAAGOJYQAAxhLDAACMJYYBABhLDAMAMJYYBgBgLDEMAMBYYhgAgLHEMAAAY4lhAADGEsMAAIwlhgEAGEsMAwAwlhgGAGAsMQwAwFhiGACAscQwAABjiWEAAMYSwwAAjCWGAQAYSwwDADCWGAYAYCwxDADAWGIYAICxxDAAAGOJYQAAxhLDAACMJYYBABhr66gHOCl2z17Y8/aL505f0/ar3Dcnz6rWeq/HeevHPrOSxz6sa30NXevjHOaxWM6q1vQorfJ7+/X0ecMkjgwDADCWGAYAYCwxDADAWGIYAICxxDAAAGOJYQAAxhLDAACMJYYBABhLDAMAMJYYBgBgLDEMAMBYYhgAgLHEMAAAY4lhAADGEsMAAIwlhgEAGEsMAwAwlhgGAGAsMQwAwFhiGACAscQwAABjiWEAAMYSwwAAjCWGAQAYSwwDADCWGAYAYCwxDADAWGIYAICxxDAAAGOJYQAAxhLDAACMJYYBABhr6RiuqidV1W9W1S+vYiAAANiUVRwZfk2Sh1bwOAAAsFFLxXBV3ZjkdJI3rGYcAADYnGWPDP90ktcl+cMVzAIAABu1ddgPrKrvS/JId99fVbdcZbszSc4kyc7OzmF3d2zsnr1w1COcSJ7XOY7jWl9ppovnTm94kscdx+fpSq511uP4fLMca/q4q70eJj4f14Nljgy/MMlLqupikrcmeVFV/evLN+ru8919qrtPbW9vL7E7AABYrUPHcHf/aHff2N27SW5P8uvd/bKVTQYAAGvm9wwDADDWoc8ZfqLufneSd6/isQAAYFMcGQYAYCwxDADAWGIYAICxxDAAAGOJYQAAxhLDAACMJYYBABhLDAMAMJYYBgBgLDEMAMBYYhgAgLHEMAAAY4lhAADGEsMAAIwlhgEAGEsMAwAwlhgGAGAsMQwAwFhiGACAscQwAABjiWEAAMYSwwAAjCWGAQAYSwwDADCWGAYAYCwxDADAWGIYAICxxDAAAGOJYQAAxhLDAACMJYYBABhr66gHOGq7Zy/sefvFc6c3PMnRu9JzAUdplV+X1/pY1/r94aR/P1n394hNfA+6ntbipH89wXHhyDAAAGOJYQAAxhLDAACMJYYBABhLDAMAMJYYBgBgLDEMAMBYYhgAgLHEMAAAY4lhAADGEsMAAIwlhgEAGEsMAwAwlhgGAGAsMQwAwFhiGACAscQwAABjiWEAAMYSwwAAjCWGAQAYSwwDADCWGAYAYCwxDADAWGIYAICxxDAAAGOJYQAAxhLDAACMJYYBABhLDAMAMJYYBgBgLDEMAMBYYhgAgLEOHcNVdVNVvauqPlRVH6yq16xyMAAAWLetJT72sSSv7e4Hquqrk9xfVXd394dWNBsAAKzVoY8Md/cnu/uBxdu/l+ShJM9Y1WAAALBuKzlnuKp2k3xLkntX8XgAALAJy5wmkSSpqq9K8otJfqS7P7fH/WeSnEmSnZ2dZXe3MbtnLxyrxwGuX5v4PuB7zcFc6Xm6eO70hieZYVVfl1dbH2u6v8Osw6Tnb6kjw1X15FwK4bd099v32qa7z3f3qe4+tb29vczuAABgpZb5bRKV5I1JHurun1zdSAAAsBnLHBl+YZKXJ3lRVb1v8ed7VzQXAACs3aHPGe7u/5ykVjgLAABslCvQAQAwlhgGAGAsMQwAwFhiGACAscQwAABjiWEAAMYSwwAAjCWGAQAYSwwDADCWGAYAYCwxDADAWGIYAICxxDAAAGOJYQAAxhLDAACMJYYBABhLDAMAMJYYBgBgLDEMAMBYYhgAgLHEMAAAY4lhAADGEsMAAIwlhgEAGEsMAwAwlhgGAGAsMQwAwFhiGACAscQwAABjiWEAAMYSwwAAjLV11AMAXG92z1446hFYsU2s6ZX2cfHc6bU+zqr2e7XHWrfD7PckvE5XtdZcnSPDAACMJYYBABhLDAMAMJYYBgBgLDEMAMBYYhgAgLHEMAAAY4lhAADGEsMAAIwlhgEAGEsMAwAwlhgGAGAsMQwAwFhiGACAscQwAABjiWEAAMYSwwAAjCWGAQAYSwwDADCWGAYAYCwxDADAWGIYAICxxDAAAGOJYQAAxhLDAACMJYYBABhLDAMAMJYYBgBgLDEMAMBYYhgAgLHEMAAAY4lhAADGWiqGq+rWqvpIVX20qs6uaigAANiEQ8dwVT0pyT9P8j1Jnp3kjqp69qoGAwCAdVvmyPDzk3y0uz/W3V9I8tYkt61mLAAAWL9lYvgZSX7nCe8/vLgNAACuC9Xdh/vAqpcmubW7f2Dx/suT/MXu/qHLtjuT5Mzi3ZuTfOTw4x7aDUk+fQT75eqsy/FjTY4n63L8WJPjybocP0e5Jn+mu7f322hriR18IslNT3j/xsVtf0x3n09yfon9LK2q7uvuU0c5A1/Kuhw/1uR4si7HjzU5nqzL8XM9rMkyp0n8lyTPqqpnVtVTktye5B2rGQsAANbv0EeGu/uxqvqhJP8hyZOS3NndH1zZZAAAsGbLnCaR7v6VJL+yolnW6UhP0+CKrMvxY02OJ+ty/FiT48m6HD/Hfk0O/QN0AABwvXM5ZgAAxjpRMbzf5aGr6k9U1c8v7r+3qnY3P+U8B1iXV1bVp6rqfYs/P3AUc05RVXdW1SNV9eAV7q+q+ieL9fqtqvrWTc840QHW5Zaq+uwTXid/f9MzTlNVN1XVu6rqQ1X1wap6zR7beL1s0AHXxGtlw6rqy6vqN6rq/Yt1+Qd7bHNsG+zExPABLw/9qiT/q7v/fJKfSvIPNzvlPNdw2e6f7+7nLf68YaNDzvOmJLde5f7vSfKsxZ8zSf7FBmZi/3VJkv/0hNfJj29gpukeS/La7n52khck+dt7fP/yetmsg6xJ4rWyaZ9P8qLufm6S5yW5tapecNk2x7bBTkwM52CXh74tyZsXb78tyYurqjY440Qu233MdPc9SR69yia3JfmXfcl7kzytqp6+menmOsC6sGHd/cnufmDx9u8leShfeqVVr5cNOuCasGGLr///s3j3yYs/l/9Q2rFtsJMUwwe5PPQfbdPdjyX5bJI/uZHp5jroZbv/+uKfGN9WVTftcT+b41Lrx9e3L/4Z8ler6puOephJFv+k+y1J7r3sLq+XI3KVNUm8Vjauqp5UVe9L8kiSu7v7iq+V49ZgJymGuX79uyS73f3NSe7O4//nCDzugVy6tOhzk/zTJL90xPOMUVVfleQXk/xId3/uqOdh3zXxWjkC3f3/uvt5uXRF4udX1XOOeqaDOkkxfJDLQ//RNlW1leRrknxmI9PNte+6dPdnuvvzi3ffkOQvbGg29nagS62zWd39uS/+M+Tid7w/uapuOOKxTryqenIuRddbuvvte2zi9bJh+62J18rR6u7/neRd+dKfgTi2DXaSYvggl4d+R5JXLN5+aZJfb79oed32XZfLzq97SS6dA8bReUeSv7n4KfkXJPlsd3/yqIearqq+4Yvn11XV83Pp+/ex+A/JSbV4vt+Y5KHu/skrbOb1skEHWROvlc2rqu2qetri7a9I8t1JPnzZZse2wZa6At1xcqXLQ1fVjye5r7vfkUsvoH9VVR/NpR9Uuf3oJp7hgOvyw1X1klz6KeFHk7zyyAYeoKruSnJLkhuq6uEkr8+lH3ZId/9sLl1V8nuTfDTJ7yf5/qOZdJYDrMtLk/xgVT2W5A+S3H5c/kNygr0wycuTfGBxLmSS/FiSncTr5YgcZE28Vjbv6UnevPgNUl+W5Be6+5evlwZzBToAAMY6SadJAADANRHDAACMJYYBABhLDAMAMJYYBgBgLDEMAMBYYhgAgLHEMAAAY/1/pIusBf6i8DYAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 864x864 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "plt.figure(figsize=(12, 12))\n",
    "plt.hist(ratio_2_over_1.dropna() , bins = np.linspace(0, 3, 100));\n",
    "plt.axvline(x=1, color=\"r\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "54"
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "over_10 = ratio_2_over_1[ratio_2_over_1 > 10]\n",
    "len(over_10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "18"
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "over_100 = ratio_2_over_1[ratio_2_over_1 > 100]\n",
    "len(over_100)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['A.S COM. IND.IMP. EXP DE MADEIRAS LTDA-ME',\n",
       "       'INDUSTRIA E COMERCIO NOVA SAMUEL LTDA-ME', 'LG MADEIRAS LTDA - ME',\n",
       "       'MADEIREIRA IMIGRANTES LTDA - ME',\n",
       "       'MADEIREIRA SANTO ANTONIO DE PÁDUA LTDA', 'MADEREIRA CASTOR LTDA EPP',\n",
       "       'MARCON INDUSTRIA E COMERCIO DE MADEIRAS LTDA ME',\n",
       "       'MATEUS DE JESUS ALMEIDA E CIA LTDA-EPP', 'N. MEZZOMO',\n",
       "       'NOSSILA MATERIAIS DE CONSTRUÇÃO LTDA - ME', 'PORTELA MADEIRAS EIRELI',\n",
       "       'ROZA M. DOS SANTOS - (ME)',\n",
       "       'S P COMERCIO VAREJ E ATAC MADEIRA E MATERIAIS DE CONSTRUÇÃO EIRELI-ME',\n",
       "       'S. DE P. CARDOSO  INDUSTRIA E COMERCIO DE MADEIRAS ME',\n",
       "       'S.H. DO NASCIMENTO ME', 'V. PRESTES DE OLIVEIRA ME',\n",
       "       'W. S. SENES - ME', 'WIRLEIDE F. DOS SANTOS - (ME)'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "over_100.index.unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1475"
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[\"nome_remetente\"].nunique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['A.S COM. IND.IMP. EXP DE MADEIRAS LTDA-ME',\n",
       "       'AFONSO E FARIAS COMERCIO DE MATERIAIS DE CONSTRUÇÃO LTDA - ME',\n",
       "       'AGROINDUSTRIAL SAMAUMA IMP. E EXP. DE ARTF DE MADEIRA LTDA',\n",
       "       'BEIRA RIO AGRO INDUSTRIAL MADEIREIRA LTDA - ME',\n",
       "       'BEM-TI-VI IND COM IMP E EXP LTDA',\n",
       "       'BRANDAO BENEFICIAMENTO DE MADEIRAS LTDA ME',\n",
       "       'CIDEMAD- INDÚSTRIA, COMÉRCIO E EXPORTAÇÃO DE MADEIRAS LTDA - EPP',\n",
       "       'CLAUDIO OMAR PASSARELLO & CIA LTDA - ME',\n",
       "       'DI ARTUSO INDUSTRIA MADEIREIRA LTDA-EPP',\n",
       "       'DILLIMAD BENEFICIAMENTO E COM. DE MADEIRAS LTDA', 'E. B. ALVES',\n",
       "       'E. L. LOEVE INDUSTRIA E COMERCIO DE MADEIRAS - EPP',\n",
       "       'EURO MADEIRAS EIRELI - EPP', 'FABIOLA REGINA MENDES DE SOUZA - ME',\n",
       "       'FG INDUSTRIA DE MADEIRAS LTDA', 'G. NUNES DA COSTA - ME',\n",
       "       'H A SILVA MADEIRAS -ME',\n",
       "       'INDUSTRIA COM. E EXP. DE MADEIRAS CEDROARANA LTDA-EPP',\n",
       "       'INDUSTRIA E COMERCIO NOVA SAMUEL LTDA-ME', 'J.B. ARCE - ME',\n",
       "       'J.M. NIZA EIRELI - ME', 'JEANICE DE OLIVEIRA ROCHA ME',\n",
       "       'LAMINADOS ALVES LTDA', 'LG MADEIRAS LTDA - ME', 'M.F.PROCHNOW - EPP',\n",
       "       'MADEBRAS-MADEIRAS DO BRASIL COM, IMPORT. E EXPORT. LTDA-ME',\n",
       "       'MADEC IND E COM DE MADEIRAS LTDA',\n",
       "       'MADEIREIRA BELA VISTA EIRELI - EPP', 'MADEIREIRA BOM FUTURO LTDA',\n",
       "       'MADEIREIRA ESPLANADA LTDA-ME', 'MADEIREIRA IMIGRANTES LTDA - ME',\n",
       "       'MADEIREIRA SANTO ANTONIO DE PÁDUA LTDA',\n",
       "       'MADEIREIRA UBERABA LTDA - ME', 'MADEREIRA CASTOR LTDA EPP',\n",
       "       'MARCON INDUSTRIA E COMERCIO DE MADEIRAS LTDA ME',\n",
       "       'MARCOS FABIANO DO AMARAL EIRELI - ME',\n",
       "       'MATEUS DE JESUS ALMEIDA E CIA LTDA-EPP', 'N. MEZZOMO',\n",
       "       'NOSSILA MATERIAIS DE CONSTRUÇÃO LTDA - ME',\n",
       "       'P. S. LEOCADIO DA ROCHA - ME',\n",
       "       'PERONDI INDUSTRIA E COMERCIO DE MADEIRAS LTDA',\n",
       "       'PORTELA MADEIRAS EIRELI',\n",
       "       'R.M. DA SILVA IND E COMERCIO DE MADEIRAS - ME',\n",
       "       'RECOMEÇO INDUSTRIA E COMERCIO DE MADEIRAS LTDA',\n",
       "       'RIMATLA- EXPLORAÇÃO E COMÉRCIO DE MADEIRAS LTDA.',\n",
       "       'RONDONIA BENEFICIAMENTO DE MADEIRAS LTDA - ME',\n",
       "       'ROZA M. DOS SANTOS - (ME)',\n",
       "       'S P COMERCIO VAREJ E ATAC MADEIRA E MATERIAIS DE CONSTRUÇÃO EIRELI-ME',\n",
       "       'S. DE P. CARDOSO  INDUSTRIA E COMERCIO DE MADEIRAS ME',\n",
       "       'S.H. DO NASCIMENTO ME', 'V. PRESTES DE OLIVEIRA ME',\n",
       "       'W. S. SENES - ME', 'WIRLEIDE F. DOS SANTOS - (ME)',\n",
       "       'WOOD NORTE MADEIRAS EIRELI - ME'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "over_10.index.unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {
    "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>index</th>\n",
       "      <th>municipio_origem</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>PORTO VELHO</td>\n",
       "      <td>7028</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>BURITIS</td>\n",
       "      <td>5002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>CUJUBIM</td>\n",
       "      <td>3329</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>CANDEIAS DO JAMARI</td>\n",
       "      <td>3205</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>ARIQUEMES</td>\n",
       "      <td>2608</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>ALTO PARAISO</td>\n",
       "      <td>2130</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>MACHADINHO D'OESTE</td>\n",
       "      <td>2010</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>RIO BRANCO</td>\n",
       "      <td>1740</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>NOVA MAMORE</td>\n",
       "      <td>941</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>SENA MADUREIRA</td>\n",
       "      <td>758</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                index  municipio_origem\n",
       "0         PORTO VELHO              7028\n",
       "1             BURITIS              5002\n",
       "2             CUJUBIM              3329\n",
       "3  CANDEIAS DO JAMARI              3205\n",
       "4           ARIQUEMES              2608\n",
       "5        ALTO PARAISO              2130\n",
       "6  MACHADINHO D'OESTE              2010\n",
       "7          RIO BRANCO              1740\n",
       "8         NOVA MAMORE               941\n",
       "9      SENA MADUREIRA               758"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[data[\"nome_destinatario\"].isin(over_10.index.values)]\\\n",
    "        [\"municipio_origem\"].value_counts(ascending=False).reset_index().head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "PORTO VELHO                 285487\n",
       "CANDEIAS DO JAMARI          113898\n",
       "ESPIGAO D'OESTE             102598\n",
       "CUJUBIM                     101089\n",
       "ARIQUEMES                    78022\n",
       "RIO BRANCO                   75551\n",
       "MACHADINHO D'OESTE           68471\n",
       "ALTO PARAISO                 53060\n",
       "BURITIS                      39902\n",
       "ITAPUA DO OESTE              30090\n",
       "JI-PARANA                    30062\n",
       "SENA MADUREIRA               29777\n",
       "VILHENA                      19328\n",
       "PIMENTA BUENO                18952\n",
       "NOVA MAMORE                  18743\n",
       "CHUPINGUAIA                  13094\n",
       "CACOAL                       12976\n",
       "ROLIM DE MOURA               11727\n",
       "RIO CRESPO                   10881\n",
       "JARU                          9712\n",
       "OURO PRETO DO OESTE           7183\n",
       "ALTA FLORESTA D'OESTE         7177\n",
       "COLORADO DO OESTE             7046\n",
       "CAMPO NOVO DE RONDONIA        6906\n",
       "VALE DO ANARI                 6776\n",
       "MINISTRO ANDREAZZA            6731\n",
       "FEIJO                         6647\n",
       "PORTO ACRE                    6355\n",
       "SERINGUEIRAS                  5910\n",
       "BUJARI                        5837\n",
       "COSTA MARQUES                 5105\n",
       "PIMENTEIRAS DO OESTE          4812\n",
       "PARECIS                       4553\n",
       "MANOEL URBANO                 4439\n",
       "NOVA BRASILANDIA D'OESTE      3707\n",
       "SAO MIGUEL DO GUAPORE         3523\n",
       "MONTE NEGRO                   3433\n",
       "GUAJARA-MIRIM                 3382\n",
       "SAO FRANCISCO DO GUAPORE      3253\n",
       "CEREJEIRAS                    3241\n",
       "PRESIDENTE MEDICI             3104\n",
       "CAPIXABA                      2985\n",
       "NOVA UNIAO                    2873\n",
       "ALTO ALEGRE DOS PARECIS       2724\n",
       "CORUMBIARA                    2398\n",
       "SANTA LUZIA D'OESTE           2392\n",
       "THEOBROMA                     2078\n",
       "ALVORADA D'OESTE              1898\n",
       "ACRELANDIA                    1831\n",
       "CACAULANDIA                   1566\n",
       "Name: municipio_origem, dtype: int64"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[\"municipio_origem\"].value_counts(ascending=False).head(50)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "ut_avoid = {'Cancelado', 'Suspenso'}\n",
    "data.query('ultima_transacao not in @ut_avoid', inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "elo1 = [1]\n",
    "elo2 = [12]\n",
    "\n",
    "X1 = data.query('id_produto_agrupado in @elo1 and nome_destinatario in @remetentes')\n",
    "senders = X1[\"nome_destinatario\"].unique()\n",
    "companies = data.query('id_produto_agrupado in @elo2 and nome_remetente in @senders')\n",
    "companies = companies[\"nome_remetente\"].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0.36745762711864405"
      ]
     },
     "execution_count": 67,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(companies) / data[\"nome_remetente\"].nunique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['MARTINS E RABELO LTDA - ME',\n",
       "       'AGROCORTEX MADEIRAS DO ACRE AGROFLORESTAL LTDA',\n",
       "       'FOX LAMINADOS LTDA', 'IND E COM DE MAD INDIA PORA LTDA',\n",
       "       'E. B. ALVES', 'F.ARTUSO EIRELI EPP', 'ROZA M. DOS SANTOS - (ME)',\n",
       "       'MADEIREIRA JR LTDA - ME', 'SENA MADEIREIRA LTDA',\n",
       "       'IND. E COM. DE MADEIRA TRIANGULO LTDA', 'PORTELA MADEIRAS EIRELI',\n",
       "       'MADMENDES IND. E COM. DE MAD. IMP. EXP. LTDA. ME',\n",
       "       'L. A. GRAMS IMPORTAÇÃO E EXPORTAÇÃO - ME',\n",
       "       'RABELO E FEITOSA LTDA - ME', 'MADEIREIRA JANEL IND E COM LTDA',\n",
       "       'CAETANO AGROINDUSTRIA LTDA. ME', 'R ALVES DE MORAIS',\n",
       "       'ACRE MADEIRAS & ENERGIA ALTERNATIVA LTDA',\n",
       "       'CASA DO MARCENEIRO EIRELI',\n",
       "       'RECOMAL RED IND E COM DE MADEIRAS LTDA',\n",
       "       'OURO BRANCO MADEIRAS IMP. E EXP. LTDA.', 'L.N.MOTA ME',\n",
       "       'UNIACRE INDUSTRIA E COMERCIO DE MADEIRA', 'C. DAMSKI EIRELI - ME',\n",
       "       'WIRLEIDE F. DOS SANTOS - (ME)', 'MADEIREIRA JR LTDA-ME',\n",
       "       'CIA DE DESENVOLVIMENTO NOVA OLINDA', 'SERRARIA SILVEIRA LTDA',\n",
       "       'DBS MADEIRAS LTDA', 'ACRE MADEIRAS EIRELI', 'G. L. MAFFI',\n",
       "       'COMPLEXO INDUSTRIAL FLORESTAL XAPURI S.A.',\n",
       "       'F. C. DE LIMA INDUSTRIA E COMERCIO - EIRELI - EPP',\n",
       "       'AMAZON WOOD INDUSTRIAL MADEIREIRA LTDA', 'KAYA INDUSTRIA LTDA.',\n",
       "       'DI ARTUSO INDUSTRIA MADEIREIRA EIRELI',\n",
       "       'ANAZILDO GOMES DO REGO-ME',\n",
       "       'MADEIREIRA LEAL IND COM IMP E EXP LTDA', 'MALINSKI MADEIRAS LTDA',\n",
       "       'W.J.BATTISTI & CIA LTDA', 'G. R. FERNANDES - ME',\n",
       "       'POLLETINI E POLLETINI LTDA - ME',\n",
       "       'EXCELSA IND E COM E EXP. E IMP. DE MADEIRAS LTDA',\n",
       "       'SAMEIR WOODS INDUSTRIA E COMERCIO DE MADEIRAS EIRELI ME',\n",
       "       'S. DE ALCANTES INDUSTRIA E COMERCIO DE MADEIRAS - EPP',\n",
       "       'N. MEZZOMO', 'ADDR INDUSTRIA E COMERCIO DE MADEIRAS LTDA-ME',\n",
       "       'RAINHA - INDUSTRIA E COMERCIO DE MADEIRAS LTDA',\n",
       "       'SOBERANA IND. E COM DE MADEIRAS LTDA - M',\n",
       "       'I B M IND. E BENEFICIAMENTO DE MADEIRAS LTDA',\n",
       "       'MADEIREIRA FÊNIX VINTE UM LTDA EPP', 'FORTS MADEIRA EIRELI-ME',\n",
       "       'MADEIREIRA RIO CLARO LTDA - EPP', 'J.M. NIZA EIRELI - ME',\n",
       "       'NORMADE IND E COM DE MADEIRAS LTDA', 'V. PRESTES DE OLIVEIRA ME',\n",
       "       'INDUSTRIA E COMERCIO DE MADEIRAS ABSOLUTA LTDA',\n",
       "       'J & S ESQUADRIAS DE MADEIRAS LTDA ME',\n",
       "       'IND COM DE MADEIRAS MICRANTHA LTDA-ME',\n",
       "       'R & I INDUSTRIA E COMERCIO DE MADEIRAS LTDA EPP',\n",
       "       'P. P. MADEIRAS DA AMAZONIA LTDA', 'MADEIREIRA AMIGÃO LTDA',\n",
       "       'INDÚSTRIA E COMÉRCIO DE MADEIRAS SOSSEGO LTDA-EPP',\n",
       "       'MLAK COMÉRCIO E SERVIÇOS EIRELI - ME.',\n",
       "       'MADEIREIRA ESPLANADA LTDA-ME', 'MADEC IND E COM DE MADEIRAS LTDA',\n",
       "       'INDUSTRIA E COMERCIO DE MADEIRAS ARARAS IMP. E EXP LTDA-EPP',\n",
       "       'INDUMAR MAD SAO MARCOS LTDA', 'J.M. DA SILVA FILHO E CIA LTDA',\n",
       "       'MADEIREIRA SÃO LOURENÇO LTDA - EPP',\n",
       "       'NOVA MUTUM INDÚSTRIA E COMÉCIO DE MADEIRAS LTDA',\n",
       "       'MADEIREIRA TRIUNFO DA AMAZONIA EIRELI - EPP',\n",
       "       'FORTALEZA INDÚSTRIA E COMÉRCIO DE MADEIRAS LTDA',\n",
       "       'MADESCHAPPO IND. E COM DE MADEIRAS LTDA',\n",
       "       'J.A. ANDRADE IND. E COM. DE MADEIRAS EPP',\n",
       "       'SÃO GABRIEL COMÉRCIO DE MADEIRAS LTDA- ME.',\n",
       "       'SILVA & SANTOS IND E COM DE MADEIRAS LTDA ME',\n",
       "       'PANDA INDUSTRIA E COMERCIO DE MADEIRAS LTDA - EPP',\n",
       "       'W. ELIAS DE RESENDE - EIRELI - EPP',\n",
       "       'J. S. DA SILVA & CIA LTDA. EPP',\n",
       "       'IND. COM. E EXP. DE MADEIRAS CEDROARANA LTDA.-EPP', 'N MEZZOMO',\n",
       "       'INDUSTRIA E COMERCIO DE MADEIRAS BONAMIGO LTDA',\n",
       "       'NORTE MADEIRA INDÚSTRIA E COMÉRCIO EIRELI - EPP',\n",
       "       'JEANICE DE OLIVEIRA ROCHA ME', 'AMARAL MADEIRAS EIRELI - EPP',\n",
       "       'PORT & MOVEIS ESQUADRIAS E MADEIRAS LTDA - ME',\n",
       "       'IRAUATÉ INDUSTRIA E COMERCIO DE ARTEFATOS DE MADEIRA LTDA',\n",
       "       'CLAUDIO LAMBRECHT - EPP',\n",
       "       'CASTRO& TREVISOL IND COM IMP E EXP DE MADEIRAS LTDA - EPP',\n",
       "       'MADEIREIRA SÃO JOSÉ LTDA.',\n",
       "       'LARA IND. E COM. DE MADEIRAS LTDA ME',\n",
       "       'A. R. INDUSTRIA E COMERCIO DE MADEIRAS LTDA - EPP',\n",
       "       'MADEIREIRA SÃO LUCAS LTDA',\n",
       "       'KBF INDUSTRIA E COMERCIO DE MADEIRAS LTDA',\n",
       "       'VALDIR DO NASCIMENTO - EPP', 'MADEIREIRA SCHMIDT EIRELI EPP',\n",
       "       'SELECTAS S.A. INDÚSTRIA E COMÉRCIO DE MADEIRAS',\n",
       "       'MADEREIRA DIVISA IND E COM DE MADEIRA LTDA',\n",
       "       'D & F COMERCIO E BENEFICIAMENTO DE MAD. LTDA EPP',\n",
       "       'MADEIREIRA RONDINHA LTDA - EPP', 'A. S. GUEDES EIRELI - EPP',\n",
       "       'J.C. SCHUTZ INDÚSTRIA COMÉRCIO, SERVIÇOS E TRANSPORTES DE CARGAS EIRELI - ME',\n",
       "       'A.C.RIBEIRO MADEIRAS -ME', 'MADERTEC MADEIRAS LTDA - ME (FILIAL)',\n",
       "       'MADEIREIRA PARANAISO LTDA - EPP', 'MADEIREIRA ASTEKA LTDA',\n",
       "       'IND. E COM. DE MADEIRAS SANTA RITA LTDA-EPP.',\n",
       "       'JUNIOR DOUGLAS DE CAMARGO ME',\n",
       "       'LAMINADORA SANTO EXPEDITO LTDA-ME',\n",
       "       'MADEFLONA INDUSTRIAL MADEIREIRA LTDA',\n",
       "       'CESAR RONHISKI IND. COM. IMP. E EXP. - EPP', 'M N WIGGERS - ME',\n",
       "       'INDUSTRIA COMERCIO E TRANSP.DE MADEIRAS B.B. LTDA',\n",
       "       \"IND. E COM. DE MAD. PAU D' ARCO LTDA\",\n",
       "       'PLAIN - MAX INDUSTRIA E COMERCIO DE MADEIRAS LTDA-ME',\n",
       "       'K. S. GUIDAS ME', 'A. E. PETROSKI MADEIRAS - ME',\n",
       "       'MADEIREIRA PARANÁ LTDA - ME',\n",
       "       'MADECAAOBI INDUSTRIA E COMERCIO DE MADEIRAS LTDA-ME',\n",
       "       'SOLIMAD MADEIRAS EIRELI',\n",
       "       'MADEMIRO INDUSTRIALIZAÇÃO DE PRODUTOS DA FLORESTA LTDA',\n",
       "       'GUANANDI INDUSTRIA E COMERCIO DE MADEIRAS LTDA ME',\n",
       "       'MADEIREIRA BELA VISTA LTDA - EPP',\n",
       "       'MADEIREIRA SANTO ANTONIO LTDA ME',\n",
       "       'G T SALES COMERCIO DE MADEIRAS - ME.', 'W. S. SENES - ME',\n",
       "       'MATOS & LITTQUE IND E COM DE MADEIRAS LTDA',\n",
       "       'MADALENA MADEIRAS LTDA', 'M. ORTOLAN - ME',\n",
       "       'INDUSTRIA E COMERCIO DE MADEIRAS CRISTALINA LTDA',\n",
       "       'TOCO - IND. COM. IMP E EXP DE MADEIRAS E LAMINADOS LTDA EPP',\n",
       "       'MADEIREIRA PALMEIRAS INDÚSTRIA, COMÉRCIO, IMPORTAÇÃO E EXPORTAÇÃO DE MADEIRAS LTDA EPP',\n",
       "       'AGROINDUSTRIAL SAMAUMA IMP. E EXP. DE ARTF DE MADEIRA LTDA',\n",
       "       'TALISMÃ IND. E COM. DE MADEIRAS LTDA', 'B W MADEIRAS LTDA',\n",
       "       'INDUSTRIA E COMERCIO DE MADEIRAS ANDIROBA LTDA.',\n",
       "       'G. NUNES DA COSTA - ME', 'MADEIREIRA C R LTDA',\n",
       "       'J.M. COMÉRCIO E BENEFICIAMENTO DE MADEIRAS EIRELI - ME',\n",
       "       'MADEZON INDUSTRIAL MADEIREIRA LTDA',\n",
       "       'LINCE MADEIRAS E ARTEFATOS LTDA - EPP', 'L K DA SILVA',\n",
       "       'M E M COMÉRCIO IMPORTAÇÃO E EXPORTAÇÃO DE MADEIRAS EIRELI-ME',\n",
       "       'B S INDÚSTRIA E COMÉRCIO DE MADEIRAS LTDA EPP',\n",
       "       'M.F.PROCHNOW - EPP', 'WOOD SHOPPING EIRELI - EPP',\n",
       "       'INDUSTRIAL MADEIREIRA ATALAIA LTDA EPP', 'ORNIL MADEIRAS LTDA ME',\n",
       "       'SOBERANA IND. E COM. DE MADEIRAS EIRELI - ME',\n",
       "       'A.S COM. IND.IMP. EXP DE MADEIRAS LTDA-ME',\n",
       "       'MADEIREIRA BEHENCK LTDA',\n",
       "       'F F INDUSTRIA E COMERCIO DE MADEIRAS LTDA',\n",
       "       'PRISMA IND. E COM. DE MADEIRAS LTDA.-EPP',\n",
       "       'SADINEZ BORGES DA ROSA SERRARIA - ME',\n",
       "       'TUDO EM MADEIRAS INDUSTRIA E COMERCIO EIRELI EPP',\n",
       "       'RONDOAMA IND. E COM. DE MADEIRAS IMPORTAÇÃO E EXPORTAÇÃO LTDA',\n",
       "       'MADEIREIRA ROSALIN EIRELI - EPP',\n",
       "       'COMÉRCIO E INDUSTRIA DE MADEIRAS GHELLER LTDA',\n",
       "       'D F THOMES COMERCIO DE MADEIRAS - ME',\n",
       "       'DIDAFA COMERCIO E BENEFICIAMENTO DE MADEIRAS LTDA - ME',\n",
       "       'MADEIREIRA TANGARÁ LTDA',\n",
       "       'INDUSTRIA E COMERCIO DE MADEIRAS CICLO LTDA ME',\n",
       "       'SAKURA INDÚSTRIA E COMÉRCIO DE MADEIRAS LTDA-EPP',\n",
       "       'D. G. DE ALMEIDA MADEIRAS - ME', 'P. S. LEOCADIO DA ROCHA - ME',\n",
       "       'MADEIREIRA GIRASSOL LTDA ME', 'MADEIREIRA SOL DO NORTE LTDA. EPP',\n",
       "       'AMAZONIA MADEIRA LEGAL LTDA', 'NORTE MADEIRAS DA AMAZÔNIA LTDA',\n",
       "       'INDÚSTRIA E COMÉRCIO DE MADEIRAS 2 IRMÃOS', 'S.MARTIN DOS REIS',\n",
       "       'MADEIREIRA LIDER EXTREMA LTDA ME',\n",
       "       'FABRICA DE MOVEIS E BENEFICIAMENTO VILA SAMUEL LTDA - ME',\n",
       "       'MADEIREIRA BAMBÚ LTDA', 'URUCUMACUÃ MADEIRAS LTDA - ME',\n",
       "       'GASTONE E TEIXEIRA INDUSTRIA E COMÉRCIO DE MADEIRAS LTDA',\n",
       "       'SETOR INDUSTRIAL COM DE MADEIRAS E DERIVADOS EIRELI - ME',\n",
       "       'ASA BRANCA INDÚSTRIA E COMÉRCIO DE MADEIRAS LTDA-E',\n",
       "       'SANTANA E FERREIRA INDUSTRIA E COMERCIO DE MADEIRAS LTDA ME',\n",
       "       'NICOLY INDUSTRIA E COMERCIO DE MOVEIS LTDA',\n",
       "       'MADEIREIRA PACIFIC LTDA - ME', 'MADEIREIRA DIVILAN LTDA',\n",
       "       'RCM INDÚSTRIA E COMERCIO DE MADEIRAS LTDA',\n",
       "       'MADEIREIRA MONTE ALEGRE LTDA ME', 'R.P NOGUEIRA E CIA LTDA ME',\n",
       "       'JAVA IND E COM IMP E EXP DE MADEIRAS LTDA - ME',\n",
       "       'FORMOSA MADEIRAS LTDA - EPP',\n",
       "       'S. DE P. CARDOSO \\x96 INDUSTRIA E COMERCIO DE MADEIRAS ME',\n",
       "       'FLORA NORTE IND. E COMERCIO DE MADEIRAS IMP. E EXP. LTDA-ME',\n",
       "       'INDUSTRIA E COM. DE MADEIRAS RIO PRETO LTDA',\n",
       "       'IND. E COM. DE MADEIRAS SANDALLO LTDA-ME',\n",
       "       'PARIROL IND. E COM. DE MADEIRAS LTDA',\n",
       "       'L & I PIMENTA IND.COM.TRANSP.IMP.E EXP.DE MADEIRAS EIRELI-EPP',\n",
       "       'CLAUDIO OMAR PASSARELLO & CIA LTDA - ME', 'CACIQUE MADEIRAS LTDA',\n",
       "       'VIEIRA & SANTOS IND. COM. IMP. EXP. MADEIRAS LTDA.',\n",
       "       'MADEIREIRA PÔR DO SOL LTDA ME',\n",
       "       'DILLIMAD BENEFICIAMENTO E COM. DE MADEIRAS LTDA',\n",
       "       'FG INDUSTRIA DE MADEIRAS LTDA', 'GOL MADEIRAS LTDA - ME',\n",
       "       'MADEIREIRA BARCELONA LTDA', 'MADEIREIRA OURO VERDE EIRELI - ME',\n",
       "       'BEZERRA & JUNQUEIRA IND E COM IMP E EXP DE MAD LTD',\n",
       "       'MADERIO IND E COM DE MADEIRAS LTDA',\n",
       "       'I.C. DE MEDEIROS - INDUSTRIA E COMERCIO DE MADEIRAS ME',\n",
       "       'INDÚSTRIA COMÉRCIO IMPORTAÇÃO EXPORTAÇÃO DE MADEIRAS SAGRADA FAMÍLIA LTDA ME',\n",
       "       'MADEIREIRA CATARINENSE LTDA',\n",
       "       'E. J. P. IMPORTAÇÃO E EXPORTAÇÃO DE MADEIRAS LTDA',\n",
       "       'INDUSTRIA E COMERCIO DE MADEIRAS HOFSTETTER LTDA',\n",
       "       'PERONDI INDUSTRIA E COMERCIO DE MADEIRAS LTDA',\n",
       "       'A. C DOS SANTOS INDUSTRIA COMERCIO IMPORTAÇÃO E EXPORTAÇÃO DE MADEIRA',\n",
       "       'AMATA', 'INDÚSTRIA E COMÉRCIO DE MADEIRAS ESPÍRITO SANTO LTDA',\n",
       "       'MARIA IZABEL DE FREITAS ALVES', 'MADEIREIRA IMIGRANTES LTDA - ME',\n",
       "       'UNIVERSAL BLUE MADEIRAS LTDA',\n",
       "       'IND. E COM. DE MADEIRAS SÃO CARLOS LTDA - ME',\n",
       "       'REAL MADEIRAS INDUSTRIA E COMERCIO LTDA-ME',\n",
       "       'MADEIREIRA RONDON LTDA - EPP',\n",
       "       'MADEIREIRA CENTRAL NORTE EIRELI-ME',\n",
       "       'C.A. DA SILVA FABRICA DE MOVEIS ME',\n",
       "       'JONATAS DA FONSECA VIANA ME', 'J.B. ARCE - ME',\n",
       "       'ANARI INDUSTRIAL MADEIREIRA EIRELI - EPP',\n",
       "       'D.R. MACHADO & CIA LTDA - EPP', 'MADEIREIRA LIDER LTDA',\n",
       "       'IND. E COM. IMP E EXP DE MADEIRAS ECOLOGICA LTDA EPP',\n",
       "       'ROVERMAD INDÚSTRIA E COMÉRCIO DE MADEIRAS LTDA EPP',\n",
       "       'PORTOLAMINAS IND.COM.E EXPORTAÇÃO DE MADEIRAS LTDA',\n",
       "       'COMAVEL COM. E SECAGEM DE MADEIRAS LTDA-ME',\n",
       "       'MADEIREIRA CAXINGO COM. E IND. DE MADEIRAS LTDA-ME',\n",
       "       'DEPOSITO DE MADEIRA COQUEIRO LTDA-ME', 'S.H. DO NASCIMENTO ME',\n",
       "       'A S MEIRA - ME', 'INDUSTRIA E COM MADEIRAS CAROBA LTDA- ME',\n",
       "       'LG MADEIRAS LTDA - ME',\n",
       "       'MARCON INDUSTRIA E COMERCIO DE MADEIRAS LTDA ME',\n",
       "       'MADEIREIRA TRÊS ESTADOS EIRELI-ME', 'NORTE MADEIRAS LTDA',\n",
       "       'ZILKE MADEIRAS LTDA', 'I. R. DE PAULA MADEIRAS EIRELI EPP',\n",
       "       'MADEIREIRA RONDONIA LTDA-ME',\n",
       "       'INDUSTRIA E COMÉRCIO DE MADEIRA NEPAL LTDA',\n",
       "       'SAMEX IND E COM DE MADEIRAS EIRELI EPP',\n",
       "       'SANTA LUZIA EMPREENDIMENTOS FLORESTAIS LTDA &#150; EPP',\n",
       "       'CIMAL COMERCIO E IND DE MAD. LTDA',\n",
       "       'SORRISO IND. COM. E TRANSP. DE MADEIRAS LTDA.',\n",
       "       'MADEIREIRA PAU GIGANTE LTDA',\n",
       "       'NERES & HEINZEN MADEIRAS LTDA - ME',\n",
       "       'MADEOESTE INDUSTRIAL MADEIREIRA LTDA- EPP',\n",
       "       'CIDEMAD- INDÚSTRIA, COMÉRCIO E EXPORTAÇÃO DE MADEIRAS LTDA - EPP',\n",
       "       'MADEIREIRA BAIOTO IMP. E EXPORTAÇÃO DE MADEIRA LTDA-ME',\n",
       "       'LEONILDO TEIXEIRA DA SILVA', 'IRM MADEIRAS LTDA',\n",
       "       'MELO & MELO BENEFICIAMENTO E COMERCIO DE MADEIRA LTDA ME',\n",
       "       'MADEIREIRA VENECIANA LTDA', 'ROIMA ROND.IND.MADEIREIRA LTDA EPP',\n",
       "       'COMERCIO DE MADEIRAS EUROPA LTDA - ME',\n",
       "       'MADEIREIRA NOVO PLANO LTDA-ME',\n",
       "       'NOVO HORIZONTE IND. COM. IMP. EXP. DE MADEIRAS LTD',\n",
       "       'H S IND. E COM. DE MADEIRA LTDA',\n",
       "       'MASTER INDUSTRIA E COMERCIO DE MADEIRAS LTDA',\n",
       "       'ANTONIO FERREIRA DINIZ FILHO',\n",
       "       'INDUSFLORA IND. COM. I´P. E EXP. DE MADEIRAS LTDA',\n",
       "       'IND COM DE MAD E TRANSP ITAGIBA LTDA',\n",
       "       'MR IND. E COM. DE MADEIRAS LTDA. - ME', 'ISABELA MADEIRAS LTDA',\n",
       "       'MADEIREIRA NOVA SAMUEL LTDA EPP',\n",
       "       'RONDONIA BENEFICIAMENTO DE MADEIRAS LTDA - ME',\n",
       "       'MADEIREIRA PALMEIRAS IND. COM. IMP. EXP. DE MADEIRAS LTDA EPP',\n",
       "       'J. C. GASPAR INDUSTRIA E COMERCIO DE MADEIRAS - ME',\n",
       "       'PONTAL CABOS IND E COM DE MADEIRAS IMP E EXP LTDA',\n",
       "       'MADEIREIRA MARINGÁ LTDA - ME', 'MADEIREIRA REDENÇÃO LTDA',\n",
       "       'RIMATLA- EXPLORAÇÃO E COMÉRCIO DE MADEIRAS LTDA.',\n",
       "       'MADEIREIRA REAL LTDA',\n",
       "       'WFL PEIXOTO REPRESENTAÇÃO E COMÉRCIO DE MATERIAS PARA COSNTRUÇÃO',\n",
       "       'MADEMOLD INDUSTRIA E COM DE MAD LTDA',\n",
       "       'LIBRAS COMÉRCIO DE MADEIRAS LTDA.-ME', 'P. A. TELES',\n",
       "       'KBC INDUSTRIA COMERCIO E TRANSPORTE DE MADEIRAS LT ME',\n",
       "       'IND E COM DE MADEIRAS TOP LTDA', 'DIORA MADEIRAS COMERCIO LTDA',\n",
       "       'R R IND E COM DE MADEIRAS IMP. E EXP. LTDA',\n",
       "       'MINAS RONDONIA IND E COM DE MADEIRAS EIRELI ME',\n",
       "       'GOMES & ROSA INDUSTRIA E COMERCIO DE MADEIRA LTDA',\n",
       "       'C & M.AMAZONIA INDUSTRIA E COMÉRCIO DE MADEIRAS LTDA-ME',\n",
       "       'TOLEDO INDUSTRIA COMERCIO DE MADEIRAS E TRANSPORTES LTDA EPP',\n",
       "       'INDÚSTRIA E COMÉRCIO DE MADEIRAS IMPAR LTDA',\n",
       "       'MADEIREIRA N. SRA APARECIDA LTDA',\n",
       "       'M.I. DOS SANTOS PACHECO DE LIMA',\n",
       "       'AGROMAD INDUSTRIA E COMERCIO DE MADEIRAS LTDA EPP',\n",
       "       'MADEIREIRA BANDOLIM LTDA', 'M DEZEM BANDEIRA ME',\n",
       "       'MADEIREIRA SOARES LTDA', 'BEM-TI-VI IND COM IMP E EXP LTDA',\n",
       "       'LAMIART INDUSTRIA E COMÉRCIO DE MADEIRAS LTDA',\n",
       "       'INDUSTRIA E COMERCIO DE MADEIRAS SERRADÃO LTDA EPP',\n",
       "       'COM IND MAD TRANSP CAPIXABA LTDA',\n",
       "       'COMÉRCIO DE MADEIRAS PLANALTO LTDA',\n",
       "       'PEREIRA & SANTOS IND. E COM. DE MADEIRAS LTDA-ME',\n",
       "       'LAMINADOS DE MADEIRAS S. M. LTDA',\n",
       "       'R.M. DA SILVA IND E COMERCIO DE MADEIRAS - ME',\n",
       "       'MADEIREIRA MARINGA LTDA', 'MADEIREIRA ILHA GRANDE LTDA - ME',\n",
       "       'MADEIREIRA DIAMANTE LTDA EPP',\n",
       "       'B.H.M. LEAL INDUSTRIA E COMERCIO DE MADEIRAS LTDA',\n",
       "       'BELUNO MADEIRAS DA AMAZONIA LTDA', 'ADAIR JOSÉ DA SILVA - EPP',\n",
       "       'COMERCIO DE MADEIRAS COMODORO EIRELI-ME',\n",
       "       'TIAGO DANIEL SOUSA MADEIRAS ME.', 'C.F.J. MADEIRAS LTDA.',\n",
       "       'M. M. MARCONI - EIRELI', 'RUBIRA &PACHECO LTDA-ME',\n",
       "       'MADEBRAS-MADEIRAS DO BRASIL COM, IMPORT. E EXPORT. LTDA-ME',\n",
       "       'G. RIBEIRO DA SILVA EPP',\n",
       "       'PORTAL COMERCIO BENEFCIAMENTO DE MADEIRAS LTDA-EPP',\n",
       "       'EURO MADEIRAS EIRELI - EPP', 'E. L. DAHMER MADEIRAS ME',\n",
       "       'BRASMAD IND. E COM. DE MADEIRAS EIRELI EPP',\n",
       "       'MADEIREIRA CINCO IRMAOS LTDA- ME',\n",
       "       'J W INDUSTRIA,COM.,IMP.E EXP.DE  MADEIRAS LTDA - ME',\n",
       "       'MADEIREIRA OLIVEIRA LTDA-EPP',\n",
       "       'RAINHA INDUSTRIA E COMÉRCIO DE MADEIRAS LTDA-ME',\n",
       "       'ECOMAB MADEIRAS LTDA - ME',\n",
       "       'RUTI FERREIRA DE OLIVERA IND. COM. IMP. EXP EPP',\n",
       "       'MBM INDUSTRIA E COM DE MADEIRAS LTDA',\n",
       "       'MADEIREIRA TAMARINO LTDA - EPP',\n",
       "       'E F DE SOUZA IND COM IMP E EXP DE MADEIRAS - ME',\n",
       "       'SÃO JOÃO INDUSTRIA E COMÉRCIO DE MADEIRAS LTDA.',\n",
       "       'DI ARTUSO INDUSTRIA MADEIREIRA LTDA-EPP',\n",
       "       'COMERCIO E BENEFICIAMENTO DE MADEIRAS GADITA LTDA - ME',\n",
       "       'MADEIREIRA COLIBRI LTDA', 'LAMINAZA IND. DE MADEIRAS LTDA - EPP',\n",
       "       'MADEREIRA 31 DE MARÇO', 'INDUSTRIA DE MADEIRAS MANOA LTDA',\n",
       "       'INDUSTRIA E COMERCIO DE MOVEIS PB LTDA - ME',\n",
       "       'J.M. SARTOR IND. E COM. DE MADEIRAS LTDA',\n",
       "       'J SERAFIM & CIA LTDA ME', 'F.L. COMERCIAL MADEIREIRA LTDA - ME',\n",
       "       'SIEBERT & CIA LTDA-EPP', 'RONDÔNIA RURAL AGROINDUSTRIAL LTDA',\n",
       "       'GUSTAVO MODANESE PIGNATON EIRELI-ME',\n",
       "       'E. L. LOEVE INDUSTRIA E COMERCIO DE MADEIRAS - EPP',\n",
       "       'MADEIREIRA OSOWSKI LTDA ME', 'A R LEMES MADEIRAS - ME',\n",
       "       'MADEIREIRA SANTA MARIA LTDA - EPP',\n",
       "       'MADEIREIRA PAU BRASIL LTDA ME',\n",
       "       'SERRARIA PONTE BONITA EIRELI EPP',\n",
       "       'MADEIREIRA BETANIN EIRELI - EPP',\n",
       "       'MADEIREIRA BOM JESUS LTDA - ME',\n",
       "       'ANTUNES & FOCHESATO IND COM IMP E EXP MAD LTDA',\n",
       "       'MADEIREIRA IRMÃOS OLIVEIRA LTDA &#150;ME.',\n",
       "       'MADEIREIRA JAQUIRANA LTDA - ME.', 'C.L. PAGNUSSAT MADEIRAS - EPP',\n",
       "       'ROXINHO MADEIRAS LTDA', 'L.CAPPELLARO MARIN-ME',\n",
       "       'BRASIL MADEIRAS EIRELI - EPP', 'SOBRADINHO IND MAD LTDA',\n",
       "       'R. DA SILVA INDUSTRIA E COMERCIO DE MADEIRAS EPP',\n",
       "       'VERDE AMAZÔNIA IND. E COM. DE MADEIRAS LTDA - ME',\n",
       "       'MADEIREIRA ROSANA IMPORTAÇÃO E EXPORTAÇÃO LTDA-ME',\n",
       "       'IND E COM DE MADEIRAS YAMAGISHI LTDA',\n",
       "       'CAMARU - INDÚSTRIA E COMÉRCIO DE MADEIRAS LTDA',\n",
       "       'AGROFLORESTAL VALE DO GUAPORE LTDA',\n",
       "       'G. DE O. NASCIMENTO INDUSTRIA E COMERCIO DE MADEIRAS LTDA - EPP',\n",
       "       'V. M. HIGUTI MADEIRAS E CONSTRUTORA - ME',\n",
       "       'INDUSTRIA E COMERCIO DE MADEIRAS BRASILEIRA LTDA',\n",
       "       'MADEIREIRA SANTO ANTONIO DE PÁDUA LTDA',\n",
       "       'MADEIREIRA JATUARANA LTDA- EPP.', 'M A L AMANCIO EIRELI ME',\n",
       "       'COM. REP. DE MADEIRAS GABRIEL LTDA',\n",
       "       'EDMO SILVA JUNIOR MADEIRAS-EIRELI-EPP',\n",
       "       'OIAPOQUE IND. COM. E BENEFICIAMENTO DE MADEIRAS LT',\n",
       "       'INDUSTRIA E COMERCIO DE MADEIRAS RONDOMAD LTDA', 'M. MENONCIN ME',\n",
       "       'M E M COMÉRCIO IMPORTAÇÃO E EXPORTAÇÃO DE MADEIRAS LTDA.-ME',\n",
       "       'ALVES E PEREIRA INDÚSTRIA E COMÉRCIO DE MADEIRAS LTDA-ME',\n",
       "       'MADERAZI IND. DE MADEIRAS LTDA',\n",
       "       'AMAZÔNIA VERDE IMP. E EXP. LTDA - ME',\n",
       "       'MADEIREIRA BOM FUTURO LTDA', 'MORETTO IND E COM DE MADEIRAS LTDA',\n",
       "       'MADEREIRA CASTOR LTDA EPP', 'LAMINADOS ALVES LTDA',\n",
       "       'MADEIREIRA TICO TICO LTDA - EPP', 'F.T.ISHIYAMA EIRELI ME',\n",
       "       'MARCOS FABIANO DO AMARAL EIRELI - ME',\n",
       "       'MADEIRAR IND. COM. EXPOR. E IMPORT. DE MADEIRA',\n",
       "       'CHAVES & FILHOS INDUSTRIA E COM. DE MADEIRAS LTDA',\n",
       "       'IND COM IMP EXP DE MADEIRAS TEKA LTDA-ME',\n",
       "       'MADEIREIRA LAMPUGNANI EIRELI - ME',\n",
       "       'VALE VERDES IND E COM DE MADEIRAS IMP E EXP LTDA',\n",
       "       'SERRARIA IRMAOS CORREIA LTDA',\n",
       "       'AAB IND E COMERCIO DE MADEIRAS EXP E IMP LTDA',\n",
       "       'MADEFRAN IND E COM IMP E XP DE MADEIRAS LTDA (FILIAL 01)',\n",
       "       'ABUNÃ LAM. E RECICLAGEM DE RES. DE MAD. LTDA ME',\n",
       "       'RECOMEÇO INDUSTRIA E COMERCIO DE MADEIRAS LTDA',\n",
       "       'MADSEB COMÉRCIO DE MADEIRAS LTDA - ME',\n",
       "       'JACOB MADEIRAS EIRELI - EPP',\n",
       "       'INDÚSTRIA E COMÉRCIO DE MADEIRAS ÁGUAS CLARAS LTDA ME',\n",
       "       'SANTANA INDÚSTRIA E COMÉRCIO DE MADEIRAS LTDA.',\n",
       "       'ROMA MADEIRAS BENEFICIADAS LTDA-ME',\n",
       "       'MADEIREIRA SANTA ISABEL LTDA',\n",
       "       'N M LAMINAÇÃO EM MADEIRAS LTDA ME',\n",
       "       'GOFER INDUSTRIA E COMERCIO DE MADEIRAS LTDA-ME',\n",
       "       'EUGENIO LAIZO NETTO - ME', 'H. M. R. MADEIRAS LTDA',\n",
       "       'MADEIREIRA UBERABA LTDA - ME',\n",
       "       'P.H. IND.E COM.DE ESQUADRIAS LTDA.',\n",
       "       'TALISMA INDUSTRIA E COMERCIO DE MADEIRAS LTDA - ME',\n",
       "       'MADEIREIRA 31 DE MARÇO LTDA. EPP', 'H A SILVA MADEIRAS -ME',\n",
       "       'ASA BRANCA INDÚSTRIA E COMÉRCIO DE MADEIRAS EIRELI',\n",
       "       'J. CARLOS BADU DA SILVA & CIA LTDA EPP', 'IVONE ROSIN - ME',\n",
       "       'MADEIREIRA SANTO EXPEDITO LTDA - ME',\n",
       "       'LWM COMERCIO DE MADEIRAS EIRELI-EPP',\n",
       "       'M. M. DE SOUZA LIMA EIRELI ME',\n",
       "       'M DOS ANJOS RAMOS E CIA LTDA - ME',\n",
       "       'E. P. S. DE OLIVEIRA EIRELI - EPP',\n",
       "       'MARTINHAGO MARTINHAGO & CIA LTDA-ME',\n",
       "       'SANTHIAGO IND COMERCIO IMP EXP DE MADEIRAS LTDA ME',\n",
       "       'AFONSO E FARIAS COMERCIO DE MATERIAIS DE CONSTRUÇÃO LTDA - ME',\n",
       "       'BEIRA RIO AGRO INDUSTRIAL MADEIREIRA LTDA - ME',\n",
       "       'INDUSTRIA COM. E EXP. DE MADEIRAS CEDROARANA LTDA-EPP',\n",
       "       'E. L. BRIZOLA IND E COM DE MADEIRAS IMP E EXP LTDA - ME',\n",
       "       'MADEIREIRA SOUZA INDUSTRIA E COMERCIO DE MADEIRAS EIRELI-ME',\n",
       "       'RODRIGUES & DIAS INDUSTRIA DE TRANSFORMAÇÃO LTDA - ME',\n",
       "       'R. S. COMERCIAL E INDUSTRIAL EIRELI - ME',\n",
       "       'INDUSTRIA E COMERCIO DE MADEIRAS BONAMIGO EIRELI - EPP',\n",
       "       'MADEZON INDUSTRIAL MADEIREIRA EIRELI EPP',\n",
       "       'INDUSTRIA E COMERCIO NOVA SAMUEL LTDA-ME',\n",
       "       'MADEIREIRA LIDER LTDA - EPP', 'MADEIREIRA MODELO EIRELI - ME',\n",
       "       'D.BUENO DA SILVA-ME', 'MADEIREIRA SÃO JOSÉ LTDA - ME',\n",
       "       'BRANDAO BENEFICIAMENTO DE MADEIRAS LTDA ME',\n",
       "       'D.S. MADEIRAS EIRELI - ME',\n",
       "       'KBC INDUSTRIA, COMERCIO E TRANSPORTE DE MADEIRAS EIRELI- EPP',\n",
       "       'STANGE E STANGE IND. E COM. DE MADEIRAS LTDA EPP',\n",
       "       'DIVISA INDUSTRIA E COMERCIO DE MADEIRAS IMP E EXP EIRELI-ME',\n",
       "       'ROSIANE DOS SANTOS E SILVA - EPP',\n",
       "       'NOSSILA MATERIAIS DE CONSTRUÇÃO LTDA - ME',\n",
       "       'S P COMERCIO VAREJ E ATAC MADEIRA E MATERIAIS DE CONSTRUÇÃO EIRELI-ME',\n",
       "       'MACHADO E SOUSA MADEIRAS LTDA ME',\n",
       "       'BEM TI VI IND. COM. IMP. E EXP. DE MADEIRAS EIRELI EPP',\n",
       "       'VLS JUNQUEIRA EIRELI - ME',\n",
       "       'CC ROCHA INDUSTRIA E COMERCIO DE MADEIRAS EIRELI ME',\n",
       "       'R & I INDUSTRIA E COMERCIO DE MADEIRAS LTDA ME',\n",
       "       'P L BRASIL CABOS PARA FERRAMENTAS EIRELI',\n",
       "       'RIO MADEIRA INDUSTRIA E COMERCIO DE MADEIRAS EIRELI - EPP',\n",
       "       'A. S. DO NASCIMENTO ME', 'MADEIREIRA C. R. EIRELI - EPP',\n",
       "       'MADEIREIRA MADEVILA LTDA - EPP',\n",
       "       'MATEUS DE JESUS ALMEIDA E CIA LTDA-EPP',\n",
       "       'MADEIREIRA TRIUNFO DA AMAZONIA EIRELI',\n",
       "       'ANTONIO FERREIRA DINIZ FILHO - ME', 'MADEIREIRA DIAMANTE LTDA ME',\n",
       "       'MIX INDUSTRIA E COMERCIO DE MADEIRAS EIRELI ME',\n",
       "       'MADEOESTE INDUSTRIAL MADEIREIRA EIRELI EPP',\n",
       "       'VALENTE MADEIRAS LTDA - ME',\n",
       "       'CIMAL COMERCIO E INDUSTRIA DE MADEIRAS ARIQUEMES LTDA - EPP',\n",
       "       'MADERIO INDUSTRIA E COMERCIO DE MADEIRAS LTDA - EPP',\n",
       "       'VSL JUNQUEIRA EIRELI - ME', 'N MEZZOMO EIRELI',\n",
       "       'MINAS RONDONIA INDUSTRIA E COMERCIO DE MADEIRAS EIRELI ME',\n",
       "       'INDUSTRIA E COMERCIO DE MADEIRAS CRISTALINA LTDA - ME',\n",
       "       'E. C. S. RIBEIRO - ME',\n",
       "       'INDUSTRIA E COMERCIO DE MADEIRA MATOS LTDA - ME',\n",
       "       'R.V DA SILVA MADEIRA ME',\n",
       "       'TALISMA INDUSTRIA E COMERCIO DE MADEIRAS EIRELI -EPP',\n",
       "       'CELINI E BERTANI LTDA - EPP',\n",
       "       'INDUSTRIA E COMÉRCIO DE MADEIRA NEPAL LTDA - EPP',\n",
       "       'INDUSTRIA DE MADEIRAS MENONCIN EIRELI-ME',\n",
       "       'T. D. S. COMERCIO E BENEFICIAMENTO DE MADEIRAS EIRELI - EPP',\n",
       "       'SD INDUSTRIA DE MADEIRAS E LAMINADOS LTDA',\n",
       "       'IND. E COM. IMP. E EXP. DE MADEIRAS ECOLOGICA LTDA - ME',\n",
       "       'MARCOS ALVES DE MELO ME',\n",
       "       'W20 INDUSTRIA E COMERCIO DE MADEIRAS LTDA-ME',\n",
       "       'R. A. R. LOPEZ - ME', 'MADEIREIRA MATO ALTO EIRELI - EPP',\n",
       "       'P.R. DE SOUZA BENDEITO EIRELI - ME',\n",
       "       'ROSIANE DOS SANTOS E SILVA - ME', 'C. DE OLIVEIRA - ME',\n",
       "       'O. J. TOLEDO & CIA LTDA - ME', 'S. M. FEIER MADEIRAS - ME',\n",
       "       'IND E COM DE MADEIRAS JETROL LTDA',\n",
       "       'N. RIBEIRO DA SILVA EIRELI ME', 'WOOD NORTE MADEIRAS EIRELI - ME',\n",
       "       'ONIX INDÚSTRIA E COMÉRCIO EIRELI ME',\n",
       "       'FABIOLA REGINA MENDES DE SOUZA - ME', 'MADEIREIRA LÍDER LTDA',\n",
       "       'INDUSTRIA E COMERCIO DE MADEIRAS PALMAS EIRELI ME',\n",
       "       'INDUSTRIA E COMERCIO DE MADEIRAS ABSOLUTA EIRELI - EPP',\n",
       "       'MADENOBRE INDUSTRIA E COMERCIO DE MADEIRAS EIRELI ME',\n",
       "       'MADEIREIRA SANTA IZABEL LTDA - ME',\n",
       "       'JORGE PIGNATON MORELLATO EIRELI - ME',\n",
       "       'MADEIREIRA CAXINGO COMÉRCIO E INDÚSTRIA DE MADEIRAS EIRELI - ME',\n",
       "       'INDUMAR MADEIREIRA SAO MARCOS LTDA - ME',\n",
       "       'R.V. DA SILVA MADEIREIRA ME',\n",
       "       'INDUSTRIA E COMERCIO DE MADEIRAS COLORADO DO OESTE LTDA - ME',\n",
       "       'BASE IND. E COMERCIO DE MADEIRAS EIRELI',\n",
       "       'MADEIREIRA N. SRA APARECIDA EIRELI',\n",
       "       'I. AGRA INDUSTRIA COMERCIO IMPORTACAO EXPORTACAO EIRELI-EPP',\n",
       "       'GOLFETTO & CIA LTDA', 'CASA NOVA MADEIRAS EIRELI',\n",
       "       'MADEIREIRA LIDER LTDA - ME', 'J. MARTINS DE OLIVEIRA EIRELI - ME',\n",
       "       'A P T COMERCIO DE MADEIRAS EIRELI',\n",
       "       'INDUSTRIA, COM. E EXP. DE MADEIRAS COLMAR LTDA',\n",
       "       'SERRARIA S MARTINS DOS REIS LTDA', 'S MARTINS DOS REIS LTDA',\n",
       "       'ANDRADINA INDUSTRIA E COMERCIO DE MADEIRAS EIRELI',\n",
       "       'MADEIREIRA JK EIRELI EPP',\n",
       "       'MACANAIBA COMERCIO E SERVIÇOS LTDA ME',\n",
       "       'MADEIREIRA BELA VISTA EIRELI - EPP',\n",
       "       'MICHELY ALVES E SOUZA EIRELI - ME',\n",
       "       'INDUSTRIAL SANTO EXPEDITO EIRELI - ME', 'FORTS MADEIRA EIRELI',\n",
       "       'S MARTINS DOS REIS - ME', 'IND. COM. MADEIRAS DIAMANTE EIRELI',\n",
       "       'PRISMA INDUSTRIA E COMERCIO DE MADEIRAS LTDA',\n",
       "       'IND. E COM. DE MADEIRAS SANDALLO LTDA-EPP',\n",
       "       'MADENORTE COMERCIO DE MADEIRA LTDA- ME',\n",
       "       'BEMAD IND. E COM. IMP. E EXP. DE MADEIRAS EIRELI-EPP',\n",
       "       'LEST INDUSTRIA E COMERCIO DE MADEIRAS EIRELI - EPP',\n",
       "       'SOBRADINHO INDUSTRIAL MADEIREIRA LTDA', 'AMATA S/A',\n",
       "       'A. P. MACHADO COMERCIO E BENEFICIAMENTO DE MADEIRAS EIRELI - ME',\n",
       "       'MADREX EIRELI - ME',\n",
       "       'FORTALEZA INDÚSTRIA E COMÉRCIO DE MADEIRAS EIRELI ME',\n",
       "       'MAD MAIS INDUSTRIA COMERCIO DE BENEFICIAMENTO DE MADEIRAS EIRELI',\n",
       "       'W. F. DOS SANTOS - (ME)', 'MARKA MADEIRAS LTDA',\n",
       "       'S. H. M. MADEIRAS IMP. E EXP. LTDA', 'D M NUNES ME',\n",
       "       'L. MACHADO ROMERO - (ME)',\n",
       "       'FELIPE FRANCIO IMPORTAÇÃO E EXPORTAÇÃO',\n",
       "       'ASSOC. DOS MORAD. E PROD. DA RESEX CHICO MENDES',\n",
       "       'LAMINADOS TRIUNFO LTDA', 'F C C PEDROSA - EPP'], dtype=object)"
      ]
     },
     "execution_count": 72,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "companies"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "542"
      ]
     },
     "execution_count": 71,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(companies)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "da"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "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>id</th>\n",
       "      <th>nome_remetente</th>\n",
       "      <th>cpf_remetente</th>\n",
       "      <th>uf_origem</th>\n",
       "      <th>municipio_origem</th>\n",
       "      <th>cd_mun_origem</th>\n",
       "      <th>latitude_origem</th>\n",
       "      <th>longitude_origem</th>\n",
       "      <th>ctf_remetente</th>\n",
       "      <th>tipo_origem</th>\n",
       "      <th>...</th>\n",
       "      <th>produto</th>\n",
       "      <th>produto_agrupado</th>\n",
       "      <th>id_produto_agrupado</th>\n",
       "      <th>nome_cientifico</th>\n",
       "      <th>nome_popular</th>\n",
       "      <th>especie_agrupada</th>\n",
       "      <th>id_especie_agrupada</th>\n",
       "      <th>volume</th>\n",
       "      <th>unidade</th>\n",
       "      <th>valor</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>690796</td>\n",
       "      <td>MARTINS E RABELO LTDA - ME</td>\n",
       "      <td>20201146000102</td>\n",
       "      <td>AC</td>\n",
       "      <td>RIO BRANCO</td>\n",
       "      <td>1200401</td>\n",
       "      <td>-10.066148</td>\n",
       "      <td>-68.371045</td>\n",
       "      <td>6057030</td>\n",
       "      <td>PATIO</td>\n",
       "      <td>...</td>\n",
       "      <td>Madeira serrada (viga)</td>\n",
       "      <td>Madeira serrada bruta</td>\n",
       "      <td>12</td>\n",
       "      <td>Apuleia leiocarpa</td>\n",
       "      <td>Garapeira</td>\n",
       "      <td>Garapeira</td>\n",
       "      <td>117</td>\n",
       "      <td>0.5220</td>\n",
       "      <td>M3</td>\n",
       "      <td>78.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>690797</td>\n",
       "      <td>MARTINS E RABELO LTDA - ME</td>\n",
       "      <td>20201146000102</td>\n",
       "      <td>AC</td>\n",
       "      <td>RIO BRANCO</td>\n",
       "      <td>1200401</td>\n",
       "      <td>-10.066148</td>\n",
       "      <td>-68.371045</td>\n",
       "      <td>6057030</td>\n",
       "      <td>PATIO</td>\n",
       "      <td>...</td>\n",
       "      <td>Madeira serrada (viga)</td>\n",
       "      <td>Madeira serrada bruta</td>\n",
       "      <td>12</td>\n",
       "      <td>Couratari guianensis</td>\n",
       "      <td>Tauari</td>\n",
       "      <td>Tauari</td>\n",
       "      <td>70</td>\n",
       "      <td>5.2000</td>\n",
       "      <td>M3</td>\n",
       "      <td>78.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>690798</td>\n",
       "      <td>L. A. GRAMS IMPORTAÇÃO E EXPORTAÇÃO - ME</td>\n",
       "      <td>24438974000110</td>\n",
       "      <td>AC</td>\n",
       "      <td>SENA MADUREIRA</td>\n",
       "      <td>1200500</td>\n",
       "      <td>-9.771175</td>\n",
       "      <td>-69.381570</td>\n",
       "      <td>6559713</td>\n",
       "      <td>PATIO</td>\n",
       "      <td>...</td>\n",
       "      <td>Alisar</td>\n",
       "      <td>Produtos acabados de madeira</td>\n",
       "      <td>13</td>\n",
       "      <td>Couratari macrosperma</td>\n",
       "      <td>Tauari</td>\n",
       "      <td>Tauari</td>\n",
       "      <td>70</td>\n",
       "      <td>1.9080</td>\n",
       "      <td>M3</td>\n",
       "      <td>1457.65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>690799</td>\n",
       "      <td>L. A. GRAMS IMPORTAÇÃO E EXPORTAÇÃO - ME</td>\n",
       "      <td>24438974000110</td>\n",
       "      <td>AC</td>\n",
       "      <td>SENA MADUREIRA</td>\n",
       "      <td>1200500</td>\n",
       "      <td>-9.771175</td>\n",
       "      <td>-69.381570</td>\n",
       "      <td>6559713</td>\n",
       "      <td>PATIO</td>\n",
       "      <td>...</td>\n",
       "      <td>Portal ou Batente</td>\n",
       "      <td>Produtos acabados de madeira</td>\n",
       "      <td>13</td>\n",
       "      <td>Couratari macrosperma</td>\n",
       "      <td>Tauari</td>\n",
       "      <td>Tauari</td>\n",
       "      <td>70</td>\n",
       "      <td>7.3140</td>\n",
       "      <td>M3</td>\n",
       "      <td>4587.94</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>690803</td>\n",
       "      <td>AGROCORTEX MADEIRAS DO ACRE AGROFLORESTAL LTDA</td>\n",
       "      <td>19848073000166</td>\n",
       "      <td>AC</td>\n",
       "      <td>MANOEL URBANO</td>\n",
       "      <td>1200344</td>\n",
       "      <td>-9.381206</td>\n",
       "      <td>-69.853924</td>\n",
       "      <td>6046829</td>\n",
       "      <td>PATIO</td>\n",
       "      <td>...</td>\n",
       "      <td>Tora</td>\n",
       "      <td>Tora</td>\n",
       "      <td>1</td>\n",
       "      <td>Eschweilera grandiflora</td>\n",
       "      <td>Matamatá</td>\n",
       "      <td>Biriba - Matamatá</td>\n",
       "      <td>4</td>\n",
       "      <td>15.3710</td>\n",
       "      <td>M3</td>\n",
       "      <td>323.87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>690808</td>\n",
       "      <td>AGROCORTEX MADEIRAS DO ACRE AGROFLORESTAL LTDA</td>\n",
       "      <td>19848073000166</td>\n",
       "      <td>AC</td>\n",
       "      <td>MANOEL URBANO</td>\n",
       "      <td>1200344</td>\n",
       "      <td>-9.381206</td>\n",
       "      <td>-69.853924</td>\n",
       "      <td>6046829</td>\n",
       "      <td>PATIO</td>\n",
       "      <td>...</td>\n",
       "      <td>Madeira serrada (tábua)</td>\n",
       "      <td>Madeira serrada bruta</td>\n",
       "      <td>12</td>\n",
       "      <td>Dipteryx odorata</td>\n",
       "      <td>Cumaru</td>\n",
       "      <td>Cumaru</td>\n",
       "      <td>63</td>\n",
       "      <td>32.5190</td>\n",
       "      <td>M3</td>\n",
       "      <td>79938.15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>690811</td>\n",
       "      <td>MARTINS E RABELO LTDA - ME</td>\n",
       "      <td>20201146000102</td>\n",
       "      <td>AC</td>\n",
       "      <td>RIO BRANCO</td>\n",
       "      <td>1200401</td>\n",
       "      <td>-10.066148</td>\n",
       "      <td>-68.371045</td>\n",
       "      <td>6057030</td>\n",
       "      <td>PATIO</td>\n",
       "      <td>...</td>\n",
       "      <td>Bloco, quadrado ou filé</td>\n",
       "      <td>Blocos e dormentes</td>\n",
       "      <td>4</td>\n",
       "      <td>Eschweilera grandiflora</td>\n",
       "      <td>Matamatárosa</td>\n",
       "      <td>Biriba - Matamatá</td>\n",
       "      <td>4</td>\n",
       "      <td>0.1270</td>\n",
       "      <td>M3</td>\n",
       "      <td>19.05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>690812</td>\n",
       "      <td>MARTINS E RABELO LTDA - ME</td>\n",
       "      <td>20201146000102</td>\n",
       "      <td>AC</td>\n",
       "      <td>RIO BRANCO</td>\n",
       "      <td>1200401</td>\n",
       "      <td>-10.066148</td>\n",
       "      <td>-68.371045</td>\n",
       "      <td>6057030</td>\n",
       "      <td>PATIO</td>\n",
       "      <td>...</td>\n",
       "      <td>Madeira serrada (caibro)</td>\n",
       "      <td>Madeira serrada bruta</td>\n",
       "      <td>12</td>\n",
       "      <td>Caryocar glabrum</td>\n",
       "      <td>Pequiarana</td>\n",
       "      <td>Pequiá</td>\n",
       "      <td>50</td>\n",
       "      <td>0.9040</td>\n",
       "      <td>M3</td>\n",
       "      <td>135.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>690813</td>\n",
       "      <td>MARTINS E RABELO LTDA - ME</td>\n",
       "      <td>20201146000102</td>\n",
       "      <td>AC</td>\n",
       "      <td>RIO BRANCO</td>\n",
       "      <td>1200401</td>\n",
       "      <td>-10.066148</td>\n",
       "      <td>-68.371045</td>\n",
       "      <td>6057030</td>\n",
       "      <td>PATIO</td>\n",
       "      <td>...</td>\n",
       "      <td>Madeira serrada (caibro)</td>\n",
       "      <td>Madeira serrada bruta</td>\n",
       "      <td>12</td>\n",
       "      <td>Caryocar villosum</td>\n",
       "      <td>Pequi</td>\n",
       "      <td>Pequiá</td>\n",
       "      <td>50</td>\n",
       "      <td>0.1710</td>\n",
       "      <td>M3</td>\n",
       "      <td>25.65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>690814</td>\n",
       "      <td>MARTINS E RABELO LTDA - ME</td>\n",
       "      <td>20201146000102</td>\n",
       "      <td>AC</td>\n",
       "      <td>RIO BRANCO</td>\n",
       "      <td>1200401</td>\n",
       "      <td>-10.066148</td>\n",
       "      <td>-68.371045</td>\n",
       "      <td>6057030</td>\n",
       "      <td>PATIO</td>\n",
       "      <td>...</td>\n",
       "      <td>Madeira serrada (tábua)</td>\n",
       "      <td>Madeira serrada bruta</td>\n",
       "      <td>12</td>\n",
       "      <td>Caryocar villosum</td>\n",
       "      <td>Pequirana</td>\n",
       "      <td>Pequiá</td>\n",
       "      <td>50</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>M3</td>\n",
       "      <td>300.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>690815</td>\n",
       "      <td>MARTINS E RABELO LTDA - ME</td>\n",
       "      <td>20201146000102</td>\n",
       "      <td>AC</td>\n",
       "      <td>RIO BRANCO</td>\n",
       "      <td>1200401</td>\n",
       "      <td>-10.066148</td>\n",
       "      <td>-68.371045</td>\n",
       "      <td>6057030</td>\n",
       "      <td>PATIO</td>\n",
       "      <td>...</td>\n",
       "      <td>Madeira serrada (viga)</td>\n",
       "      <td>Madeira serrada bruta</td>\n",
       "      <td>12</td>\n",
       "      <td>Eschweilera grandiflora</td>\n",
       "      <td>Matamatárosa</td>\n",
       "      <td>Biriba - Matamatá</td>\n",
       "      <td>4</td>\n",
       "      <td>0.2250</td>\n",
       "      <td>M3</td>\n",
       "      <td>33.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>690818</td>\n",
       "      <td>AGROCORTEX MADEIRAS DO ACRE AGROFLORESTAL LTDA</td>\n",
       "      <td>19848073000166</td>\n",
       "      <td>AC</td>\n",
       "      <td>MANOEL URBANO</td>\n",
       "      <td>1200344</td>\n",
       "      <td>-9.381206</td>\n",
       "      <td>-69.853924</td>\n",
       "      <td>6046829</td>\n",
       "      <td>PATIO</td>\n",
       "      <td>...</td>\n",
       "      <td>Tora</td>\n",
       "      <td>Tora</td>\n",
       "      <td>1</td>\n",
       "      <td>Caryocar villosum</td>\n",
       "      <td>Pequiá</td>\n",
       "      <td>Pequiá</td>\n",
       "      <td>50</td>\n",
       "      <td>32.2700</td>\n",
       "      <td>M3</td>\n",
       "      <td>1799.81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>690822</td>\n",
       "      <td>MARTINS E RABELO LTDA - ME</td>\n",
       "      <td>20201146000102</td>\n",
       "      <td>AC</td>\n",
       "      <td>RIO BRANCO</td>\n",
       "      <td>1200401</td>\n",
       "      <td>-10.066148</td>\n",
       "      <td>-68.371045</td>\n",
       "      <td>6057030</td>\n",
       "      <td>PATIO</td>\n",
       "      <td>...</td>\n",
       "      <td>Madeira serrada (caibro)</td>\n",
       "      <td>Madeira serrada bruta</td>\n",
       "      <td>12</td>\n",
       "      <td>Couratari guianensis</td>\n",
       "      <td>Tauari</td>\n",
       "      <td>Tauari</td>\n",
       "      <td>70</td>\n",
       "      <td>0.0954</td>\n",
       "      <td>M3</td>\n",
       "      <td>14.31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>690823</td>\n",
       "      <td>MARTINS E RABELO LTDA - ME</td>\n",
       "      <td>20201146000102</td>\n",
       "      <td>AC</td>\n",
       "      <td>RIO BRANCO</td>\n",
       "      <td>1200401</td>\n",
       "      <td>-10.066148</td>\n",
       "      <td>-68.371045</td>\n",
       "      <td>6057030</td>\n",
       "      <td>PATIO</td>\n",
       "      <td>...</td>\n",
       "      <td>Madeira serrada (tábua)</td>\n",
       "      <td>Madeira serrada bruta</td>\n",
       "      <td>12</td>\n",
       "      <td>Caryocar villosum</td>\n",
       "      <td>Pequi</td>\n",
       "      <td>Pequiá</td>\n",
       "      <td>50</td>\n",
       "      <td>0.6000</td>\n",
       "      <td>M3</td>\n",
       "      <td>90.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>690824</td>\n",
       "      <td>MARTINS E RABELO LTDA - ME</td>\n",
       "      <td>20201146000102</td>\n",
       "      <td>AC</td>\n",
       "      <td>RIO BRANCO</td>\n",
       "      <td>1200401</td>\n",
       "      <td>-10.066148</td>\n",
       "      <td>-68.371045</td>\n",
       "      <td>6057030</td>\n",
       "      <td>PATIO</td>\n",
       "      <td>...</td>\n",
       "      <td>Ripas</td>\n",
       "      <td>Madeira serrada bruta</td>\n",
       "      <td>12</td>\n",
       "      <td>Pouteria caimito</td>\n",
       "      <td>Abiurana</td>\n",
       "      <td>Abiu</td>\n",
       "      <td>17</td>\n",
       "      <td>0.0500</td>\n",
       "      <td>M3</td>\n",
       "      <td>7.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>690825</td>\n",
       "      <td>MARTINS E RABELO LTDA - ME</td>\n",
       "      <td>20201146000102</td>\n",
       "      <td>AC</td>\n",
       "      <td>RIO BRANCO</td>\n",
       "      <td>1200401</td>\n",
       "      <td>-10.066148</td>\n",
       "      <td>-68.371045</td>\n",
       "      <td>6057030</td>\n",
       "      <td>PATIO</td>\n",
       "      <td>...</td>\n",
       "      <td>Bloco, quadrado ou filé</td>\n",
       "      <td>Blocos e dormentes</td>\n",
       "      <td>4</td>\n",
       "      <td>Caryocar villosum</td>\n",
       "      <td>Pequi</td>\n",
       "      <td>Pequiá</td>\n",
       "      <td>50</td>\n",
       "      <td>17.7000</td>\n",
       "      <td>M3</td>\n",
       "      <td>2655.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>690829</td>\n",
       "      <td>MADEIREIRA JR LTDA - ME</td>\n",
       "      <td>34703017000127</td>\n",
       "      <td>AC</td>\n",
       "      <td>RIO BRANCO</td>\n",
       "      <td>1200401</td>\n",
       "      <td>-10.066148</td>\n",
       "      <td>-68.371045</td>\n",
       "      <td>25565</td>\n",
       "      <td>PATIO</td>\n",
       "      <td>...</td>\n",
       "      <td>Resíduo para Fins Energéticos</td>\n",
       "      <td>Resíduos industriais</td>\n",
       "      <td>8</td>\n",
       "      <td>Ceiba pentandra</td>\n",
       "      <td>Sumaúma</td>\n",
       "      <td>Espécies mistas brancas</td>\n",
       "      <td>58</td>\n",
       "      <td>22.8003</td>\n",
       "      <td>M3</td>\n",
       "      <td>456.06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>690832</td>\n",
       "      <td>MARTINS E RABELO LTDA - ME</td>\n",
       "      <td>20201146000102</td>\n",
       "      <td>AC</td>\n",
       "      <td>RIO BRANCO</td>\n",
       "      <td>1200401</td>\n",
       "      <td>-10.066148</td>\n",
       "      <td>-68.371045</td>\n",
       "      <td>6057030</td>\n",
       "      <td>PATIO</td>\n",
       "      <td>...</td>\n",
       "      <td>Madeira serrada (tábua)</td>\n",
       "      <td>Madeira serrada bruta</td>\n",
       "      <td>12</td>\n",
       "      <td>Caryocar villosum</td>\n",
       "      <td>Pequirosa</td>\n",
       "      <td>Pequiá</td>\n",
       "      <td>50</td>\n",
       "      <td>1.9200</td>\n",
       "      <td>M3</td>\n",
       "      <td>288.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>690926</td>\n",
       "      <td>FOX LAMINADOS LTDA</td>\n",
       "      <td>04642220000170</td>\n",
       "      <td>AC</td>\n",
       "      <td>PORTO ACRE</td>\n",
       "      <td>1200807</td>\n",
       "      <td>-9.629506</td>\n",
       "      <td>-67.698446</td>\n",
       "      <td>40218</td>\n",
       "      <td>PATIO</td>\n",
       "      <td>...</td>\n",
       "      <td>Madeira serrada (viga)</td>\n",
       "      <td>Madeira serrada bruta</td>\n",
       "      <td>12</td>\n",
       "      <td>Apuleia molaris</td>\n",
       "      <td>Garapeira</td>\n",
       "      <td>Garapeira</td>\n",
       "      <td>117</td>\n",
       "      <td>1.8750</td>\n",
       "      <td>M3</td>\n",
       "      <td>56.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>690838</td>\n",
       "      <td>IND E COM DE MAD INDIA PORA LTDA</td>\n",
       "      <td>04582045000172</td>\n",
       "      <td>AC</td>\n",
       "      <td>RIO BRANCO</td>\n",
       "      <td>1200401</td>\n",
       "      <td>-10.066148</td>\n",
       "      <td>-68.371045</td>\n",
       "      <td>4351</td>\n",
       "      <td>PATIO</td>\n",
       "      <td>...</td>\n",
       "      <td>Madeira serrada (prancha)</td>\n",
       "      <td>Madeira serrada bruta</td>\n",
       "      <td>12</td>\n",
       "      <td>Apuleia molaris</td>\n",
       "      <td>Garapa</td>\n",
       "      <td>Garapeira</td>\n",
       "      <td>117</td>\n",
       "      <td>1.2800</td>\n",
       "      <td>M3</td>\n",
       "      <td>320.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>690839</td>\n",
       "      <td>IND E COM DE MAD INDIA PORA LTDA</td>\n",
       "      <td>04582045000172</td>\n",
       "      <td>AC</td>\n",
       "      <td>RIO BRANCO</td>\n",
       "      <td>1200401</td>\n",
       "      <td>-10.066148</td>\n",
       "      <td>-68.371045</td>\n",
       "      <td>4351</td>\n",
       "      <td>PATIO</td>\n",
       "      <td>...</td>\n",
       "      <td>Madeira serrada (tábua)</td>\n",
       "      <td>Madeira serrada bruta</td>\n",
       "      <td>12</td>\n",
       "      <td>Dinizia excelsa</td>\n",
       "      <td>Angelim</td>\n",
       "      <td>Angelim vermelho</td>\n",
       "      <td>105</td>\n",
       "      <td>1.5530</td>\n",
       "      <td>M3</td>\n",
       "      <td>388.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>690840</td>\n",
       "      <td>E. B. ALVES</td>\n",
       "      <td>10567563000110</td>\n",
       "      <td>AC</td>\n",
       "      <td>RIO BRANCO</td>\n",
       "      <td>1200401</td>\n",
       "      <td>-10.066148</td>\n",
       "      <td>-68.371045</td>\n",
       "      <td>6721966</td>\n",
       "      <td>PATIO</td>\n",
       "      <td>...</td>\n",
       "      <td>Madeira serrada (caibro)</td>\n",
       "      <td>Madeira serrada bruta</td>\n",
       "      <td>12</td>\n",
       "      <td>Enterolobium schomburgkii</td>\n",
       "      <td>Orelhademacaco</td>\n",
       "      <td>Fava orelha de macaco</td>\n",
       "      <td>73</td>\n",
       "      <td>0.8130</td>\n",
       "      <td>M3</td>\n",
       "      <td>73.17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>690841</td>\n",
       "      <td>E. B. ALVES</td>\n",
       "      <td>10567563000110</td>\n",
       "      <td>AC</td>\n",
       "      <td>RIO BRANCO</td>\n",
       "      <td>1200401</td>\n",
       "      <td>-10.066148</td>\n",
       "      <td>-68.371045</td>\n",
       "      <td>6721966</td>\n",
       "      <td>PATIO</td>\n",
       "      <td>...</td>\n",
       "      <td>Sarrafo</td>\n",
       "      <td>Madeira serrada bruta</td>\n",
       "      <td>12</td>\n",
       "      <td>Dialium guianense</td>\n",
       "      <td>Tamarindo</td>\n",
       "      <td>Jitaí e jutaí</td>\n",
       "      <td>113</td>\n",
       "      <td>1.2090</td>\n",
       "      <td>M3</td>\n",
       "      <td>108.81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>690842</td>\n",
       "      <td>E. B. ALVES</td>\n",
       "      <td>10567563000110</td>\n",
       "      <td>AC</td>\n",
       "      <td>RIO BRANCO</td>\n",
       "      <td>1200401</td>\n",
       "      <td>-10.066148</td>\n",
       "      <td>-68.371045</td>\n",
       "      <td>6721966</td>\n",
       "      <td>PATIO</td>\n",
       "      <td>...</td>\n",
       "      <td>Madeira serrada (tábua)</td>\n",
       "      <td>Madeira serrada bruta</td>\n",
       "      <td>12</td>\n",
       "      <td>Dipteryx polyphylla</td>\n",
       "      <td>Cumaru</td>\n",
       "      <td>Cumaru</td>\n",
       "      <td>63</td>\n",
       "      <td>0.2870</td>\n",
       "      <td>M3</td>\n",
       "      <td>31.57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>690843</td>\n",
       "      <td>E. B. ALVES</td>\n",
       "      <td>10567563000110</td>\n",
       "      <td>AC</td>\n",
       "      <td>RIO BRANCO</td>\n",
       "      <td>1200401</td>\n",
       "      <td>-10.066148</td>\n",
       "      <td>-68.371045</td>\n",
       "      <td>6721966</td>\n",
       "      <td>PATIO</td>\n",
       "      <td>...</td>\n",
       "      <td>Madeira serrada (viga)</td>\n",
       "      <td>Madeira serrada bruta</td>\n",
       "      <td>12</td>\n",
       "      <td>Qualea tessmannii</td>\n",
       "      <td>Catuaba</td>\n",
       "      <td>Mandioqueiro</td>\n",
       "      <td>41</td>\n",
       "      <td>0.3740</td>\n",
       "      <td>M3</td>\n",
       "      <td>33.66</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>690844</td>\n",
       "      <td>E. B. ALVES</td>\n",
       "      <td>10567563000110</td>\n",
       "      <td>AC</td>\n",
       "      <td>RIO BRANCO</td>\n",
       "      <td>1200401</td>\n",
       "      <td>-10.066148</td>\n",
       "      <td>-68.371045</td>\n",
       "      <td>6721966</td>\n",
       "      <td>PATIO</td>\n",
       "      <td>...</td>\n",
       "      <td>Madeira serrada (vigota)</td>\n",
       "      <td>Madeira serrada bruta</td>\n",
       "      <td>12</td>\n",
       "      <td>Aspidosperma parvifolium</td>\n",
       "      <td>Amarelão</td>\n",
       "      <td>Peroba</td>\n",
       "      <td>118</td>\n",
       "      <td>0.1830</td>\n",
       "      <td>M3</td>\n",
       "      <td>16.47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>690845</td>\n",
       "      <td>E. B. ALVES</td>\n",
       "      <td>10567563000110</td>\n",
       "      <td>AC</td>\n",
       "      <td>RIO BRANCO</td>\n",
       "      <td>1200401</td>\n",
       "      <td>-10.066148</td>\n",
       "      <td>-68.371045</td>\n",
       "      <td>6721966</td>\n",
       "      <td>PATIO</td>\n",
       "      <td>...</td>\n",
       "      <td>Madeira serrada (caibro)</td>\n",
       "      <td>Madeira serrada bruta</td>\n",
       "      <td>12</td>\n",
       "      <td>Eschweilera odora</td>\n",
       "      <td>Castanharanavermelha</td>\n",
       "      <td>Biriba - Matamatá</td>\n",
       "      <td>4</td>\n",
       "      <td>0.2520</td>\n",
       "      <td>M3</td>\n",
       "      <td>22.68</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>690846</td>\n",
       "      <td>E. B. ALVES</td>\n",
       "      <td>10567563000110</td>\n",
       "      <td>AC</td>\n",
       "      <td>RIO BRANCO</td>\n",
       "      <td>1200401</td>\n",
       "      <td>-10.066148</td>\n",
       "      <td>-68.371045</td>\n",
       "      <td>6721966</td>\n",
       "      <td>PATIO</td>\n",
       "      <td>...</td>\n",
       "      <td>Sarrafo</td>\n",
       "      <td>Madeira serrada bruta</td>\n",
       "      <td>12</td>\n",
       "      <td>Enterolobium schomburgkii</td>\n",
       "      <td>Orelhademacaco</td>\n",
       "      <td>Fava orelha de macaco</td>\n",
       "      <td>73</td>\n",
       "      <td>0.1150</td>\n",
       "      <td>M3</td>\n",
       "      <td>10.35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>690847</td>\n",
       "      <td>E. B. ALVES</td>\n",
       "      <td>10567563000110</td>\n",
       "      <td>AC</td>\n",
       "      <td>RIO BRANCO</td>\n",
       "      <td>1200401</td>\n",
       "      <td>-10.066148</td>\n",
       "      <td>-68.371045</td>\n",
       "      <td>6721966</td>\n",
       "      <td>PATIO</td>\n",
       "      <td>...</td>\n",
       "      <td>Madeira serrada (tábua)</td>\n",
       "      <td>Madeira serrada bruta</td>\n",
       "      <td>12</td>\n",
       "      <td>Cariniana micrantha</td>\n",
       "      <td>Jequitiba</td>\n",
       "      <td>Espécies mistas brancas</td>\n",
       "      <td>58</td>\n",
       "      <td>0.9600</td>\n",
       "      <td>M3</td>\n",
       "      <td>105.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>690882</td>\n",
       "      <td>SENA MADEIREIRA LTDA</td>\n",
       "      <td>15625377000103</td>\n",
       "      <td>AC</td>\n",
       "      <td>FEIJO</td>\n",
       "      <td>1200302</td>\n",
       "      <td>-8.924464</td>\n",
       "      <td>-70.744779</td>\n",
       "      <td>5675249</td>\n",
       "      <td>AUTEX-Exploração em Planos de Manejo</td>\n",
       "      <td>...</td>\n",
       "      <td>Tora</td>\n",
       "      <td>Tora</td>\n",
       "      <td>1</td>\n",
       "      <td>Eschweilera odora</td>\n",
       "      <td>Castanharanavermelha</td>\n",
       "      <td>Biriba - Matamatá</td>\n",
       "      <td>4</td>\n",
       "      <td>2.9280</td>\n",
       "      <td>M3</td>\n",
       "      <td>175.68</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>1349734</th>\n",
       "      <td>690750</td>\n",
       "      <td>C. DAMSKI EIRELI - ME</td>\n",
       "      <td>14029287000197</td>\n",
       "      <td>AC</td>\n",
       "      <td>RIO BRANCO</td>\n",
       "      <td>1200401</td>\n",
       "      <td>-10.066148</td>\n",
       "      <td>-68.371045</td>\n",
       "      <td>5299377</td>\n",
       "      <td>PATIO</td>\n",
       "      <td>...</td>\n",
       "      <td>Tora</td>\n",
       "      <td>Tora</td>\n",
       "      <td>1</td>\n",
       "      <td>Pterocarpus rohrii</td>\n",
       "      <td>Pausangue</td>\n",
       "      <td>Espécies mistas brancas</td>\n",
       "      <td>58</td>\n",
       "      <td>5.6860</td>\n",
       "      <td>M3</td>\n",
       "      <td>862.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1349735</th>\n",
       "      <td>690751</td>\n",
       "      <td>C. DAMSKI EIRELI - ME</td>\n",
       "      <td>14029287000197</td>\n",
       "      <td>AC</td>\n",
       "      <td>RIO BRANCO</td>\n",
       "      <td>1200401</td>\n",
       "      <td>-10.066148</td>\n",
       "      <td>-68.371045</td>\n",
       "      <td>5299377</td>\n",
       "      <td>PATIO</td>\n",
       "      <td>...</td>\n",
       "      <td>Tora</td>\n",
       "      <td>Tora</td>\n",
       "      <td>1</td>\n",
       "      <td>Schizolobium amazonicum</td>\n",
       "      <td>Pinhocuiabano</td>\n",
       "      <td>Paricá</td>\n",
       "      <td>98</td>\n",
       "      <td>3.9820</td>\n",
       "      <td>M3</td>\n",
       "      <td>651.06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1349736</th>\n",
       "      <td>690752</td>\n",
       "      <td>C. DAMSKI EIRELI - ME</td>\n",
       "      <td>14029287000197</td>\n",
       "      <td>AC</td>\n",
       "      <td>RIO BRANCO</td>\n",
       "      <td>1200401</td>\n",
       "      <td>-10.066148</td>\n",
       "      <td>-68.371045</td>\n",
       "      <td>5299377</td>\n",
       "      <td>PATIO</td>\n",
       "      <td>...</td>\n",
       "      <td>Tora</td>\n",
       "      <td>Tora</td>\n",
       "      <td>1</td>\n",
       "      <td>Ceiba samauma</td>\n",
       "      <td>SamaúmaPreta</td>\n",
       "      <td>Espécies mistas brancas</td>\n",
       "      <td>58</td>\n",
       "      <td>7.6710</td>\n",
       "      <td>M3</td>\n",
       "      <td>1150.56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1349737</th>\n",
       "      <td>690754</td>\n",
       "      <td>RECOMAL RED IND E COM DE MADEIRAS LTDA</td>\n",
       "      <td>01856239000120</td>\n",
       "      <td>AC</td>\n",
       "      <td>ACRELANDIA</td>\n",
       "      <td>1200013</td>\n",
       "      <td>-9.933715</td>\n",
       "      <td>-66.950492</td>\n",
       "      <td>31757</td>\n",
       "      <td>PATIO</td>\n",
       "      <td>...</td>\n",
       "      <td>Resíduo para Fins Energéticos</td>\n",
       "      <td>Resíduos industriais</td>\n",
       "      <td>8</td>\n",
       "      <td>Apuleia molaris</td>\n",
       "      <td>Garapeira</td>\n",
       "      <td>Garapeira</td>\n",
       "      <td>117</td>\n",
       "      <td>5.2180</td>\n",
       "      <td>M3</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1349738</th>\n",
       "      <td>690755</td>\n",
       "      <td>RECOMAL RED IND E COM DE MADEIRAS LTDA</td>\n",
       "      <td>01856239000120</td>\n",
       "      <td>AC</td>\n",
       "      <td>ACRELANDIA</td>\n",
       "      <td>1200013</td>\n",
       "      <td>-9.933715</td>\n",
       "      <td>-66.950492</td>\n",
       "      <td>31757</td>\n",
       "      <td>PATIO</td>\n",
       "      <td>...</td>\n",
       "      <td>Resíduo para Fins Energéticos</td>\n",
       "      <td>Resíduos industriais</td>\n",
       "      <td>8</td>\n",
       "      <td>Clarisia racemosa</td>\n",
       "      <td>Guariúba</td>\n",
       "      <td>Gameleiro</td>\n",
       "      <td>99</td>\n",
       "      <td>6.1000</td>\n",
       "      <td>M3</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1349739</th>\n",
       "      <td>690756</td>\n",
       "      <td>IND. E COM. DE MADEIRA TRIANGULO LTDA</td>\n",
       "      <td>84328434000105</td>\n",
       "      <td>AC</td>\n",
       "      <td>RIO BRANCO</td>\n",
       "      <td>1200401</td>\n",
       "      <td>-10.066148</td>\n",
       "      <td>-68.371045</td>\n",
       "      <td>30322</td>\n",
       "      <td>PATIO</td>\n",
       "      <td>...</td>\n",
       "      <td>Madeira serrada (viga)</td>\n",
       "      <td>Madeira serrada bruta</td>\n",
       "      <td>12</td>\n",
       "      <td>Hymenaea courbaril</td>\n",
       "      <td>Jatobá</td>\n",
       "      <td>Jatobá</td>\n",
       "      <td>119</td>\n",
       "      <td>0.7840</td>\n",
       "      <td>M3</td>\n",
       "      <td>78.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1349740</th>\n",
       "      <td>690757</td>\n",
       "      <td>L. A. GRAMS IMPORTAÇÃO E EXPORTAÇÃO - ME</td>\n",
       "      <td>24438974000110</td>\n",
       "      <td>AC</td>\n",
       "      <td>SENA MADUREIRA</td>\n",
       "      <td>1200500</td>\n",
       "      <td>-9.771175</td>\n",
       "      <td>-69.381570</td>\n",
       "      <td>6559713</td>\n",
       "      <td>PATIO</td>\n",
       "      <td>...</td>\n",
       "      <td>Madeira serrada (prancha)</td>\n",
       "      <td>Madeira serrada bruta</td>\n",
       "      <td>12</td>\n",
       "      <td>Manilkara bidentata</td>\n",
       "      <td>Maçaranduba</td>\n",
       "      <td>Maçaranduba</td>\n",
       "      <td>38</td>\n",
       "      <td>1.8270</td>\n",
       "      <td>M3</td>\n",
       "      <td>69.43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1349741</th>\n",
       "      <td>690758</td>\n",
       "      <td>L. A. GRAMS IMPORTAÇÃO E EXPORTAÇÃO - ME</td>\n",
       "      <td>24438974000110</td>\n",
       "      <td>AC</td>\n",
       "      <td>SENA MADUREIRA</td>\n",
       "      <td>1200500</td>\n",
       "      <td>-9.771175</td>\n",
       "      <td>-69.381570</td>\n",
       "      <td>6559713</td>\n",
       "      <td>PATIO</td>\n",
       "      <td>...</td>\n",
       "      <td>Bloco, quadrado ou filé</td>\n",
       "      <td>Blocos e dormentes</td>\n",
       "      <td>4</td>\n",
       "      <td>Manilkara bidentata</td>\n",
       "      <td>Maçaranduba</td>\n",
       "      <td>Maçaranduba</td>\n",
       "      <td>38</td>\n",
       "      <td>1.3000</td>\n",
       "      <td>M3</td>\n",
       "      <td>49.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1349742</th>\n",
       "      <td>690759</td>\n",
       "      <td>L. A. GRAMS IMPORTAÇÃO E EXPORTAÇÃO - ME</td>\n",
       "      <td>24438974000110</td>\n",
       "      <td>AC</td>\n",
       "      <td>SENA MADUREIRA</td>\n",
       "      <td>1200500</td>\n",
       "      <td>-9.771175</td>\n",
       "      <td>-69.381570</td>\n",
       "      <td>6559713</td>\n",
       "      <td>PATIO</td>\n",
       "      <td>...</td>\n",
       "      <td>Madeira serrada (caibro)</td>\n",
       "      <td>Madeira serrada bruta</td>\n",
       "      <td>12</td>\n",
       "      <td>Manilkara bidentata</td>\n",
       "      <td>Maçaranduba</td>\n",
       "      <td>Maçaranduba</td>\n",
       "      <td>38</td>\n",
       "      <td>1.3070</td>\n",
       "      <td>M3</td>\n",
       "      <td>36.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1349743</th>\n",
       "      <td>690760</td>\n",
       "      <td>L. A. GRAMS IMPORTAÇÃO E EXPORTAÇÃO - ME</td>\n",
       "      <td>24438974000110</td>\n",
       "      <td>AC</td>\n",
       "      <td>SENA MADUREIRA</td>\n",
       "      <td>1200500</td>\n",
       "      <td>-9.771175</td>\n",
       "      <td>-69.381570</td>\n",
       "      <td>6559713</td>\n",
       "      <td>PATIO</td>\n",
       "      <td>...</td>\n",
       "      <td>Sarrafo</td>\n",
       "      <td>Madeira serrada bruta</td>\n",
       "      <td>12</td>\n",
       "      <td>Manilkara bidentata</td>\n",
       "      <td>Maparajuba</td>\n",
       "      <td>Maçaranduba</td>\n",
       "      <td>38</td>\n",
       "      <td>1.4370</td>\n",
       "      <td>M3</td>\n",
       "      <td>25.87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1349744</th>\n",
       "      <td>690761</td>\n",
       "      <td>L. A. GRAMS IMPORTAÇÃO E EXPORTAÇÃO - ME</td>\n",
       "      <td>24438974000110</td>\n",
       "      <td>AC</td>\n",
       "      <td>SENA MADUREIRA</td>\n",
       "      <td>1200500</td>\n",
       "      <td>-9.771175</td>\n",
       "      <td>-69.381570</td>\n",
       "      <td>6559713</td>\n",
       "      <td>PATIO</td>\n",
       "      <td>...</td>\n",
       "      <td>Madeira serrada (tábua)</td>\n",
       "      <td>Madeira serrada bruta</td>\n",
       "      <td>12</td>\n",
       "      <td>Dialium guianense</td>\n",
       "      <td>Tamarinda</td>\n",
       "      <td>Jitaí e jutaí</td>\n",
       "      <td>113</td>\n",
       "      <td>17.8000</td>\n",
       "      <td>M3</td>\n",
       "      <td>498.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1349745</th>\n",
       "      <td>690762</td>\n",
       "      <td>L. A. GRAMS IMPORTAÇÃO E EXPORTAÇÃO - ME</td>\n",
       "      <td>24438974000110</td>\n",
       "      <td>AC</td>\n",
       "      <td>SENA MADUREIRA</td>\n",
       "      <td>1200500</td>\n",
       "      <td>-9.771175</td>\n",
       "      <td>-69.381570</td>\n",
       "      <td>6559713</td>\n",
       "      <td>PATIO</td>\n",
       "      <td>...</td>\n",
       "      <td>Madeira serrada (viga)</td>\n",
       "      <td>Madeira serrada bruta</td>\n",
       "      <td>12</td>\n",
       "      <td>Manilkara bidentata</td>\n",
       "      <td>Maçaranduba</td>\n",
       "      <td>Maçaranduba</td>\n",
       "      <td>38</td>\n",
       "      <td>22.4320</td>\n",
       "      <td>M3</td>\n",
       "      <td>852.42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1349752</th>\n",
       "      <td>690769</td>\n",
       "      <td>IND E COM DE MAD INDIA PORA LTDA</td>\n",
       "      <td>04582045000172</td>\n",
       "      <td>AC</td>\n",
       "      <td>RIO BRANCO</td>\n",
       "      <td>1200401</td>\n",
       "      <td>-10.066148</td>\n",
       "      <td>-68.371045</td>\n",
       "      <td>4351</td>\n",
       "      <td>PATIO</td>\n",
       "      <td>...</td>\n",
       "      <td>Madeira serrada (tábua)</td>\n",
       "      <td>Madeira serrada bruta</td>\n",
       "      <td>12</td>\n",
       "      <td>Copaifera multijuga</td>\n",
       "      <td>Copaíba</td>\n",
       "      <td>Copaíba</td>\n",
       "      <td>27</td>\n",
       "      <td>6.1100</td>\n",
       "      <td>M3</td>\n",
       "      <td>1527.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1349753</th>\n",
       "      <td>690770</td>\n",
       "      <td>MARTINS E RABELO LTDA - ME</td>\n",
       "      <td>20201146000102</td>\n",
       "      <td>AC</td>\n",
       "      <td>RIO BRANCO</td>\n",
       "      <td>1200401</td>\n",
       "      <td>-10.066148</td>\n",
       "      <td>-68.371045</td>\n",
       "      <td>6057030</td>\n",
       "      <td>PATIO</td>\n",
       "      <td>...</td>\n",
       "      <td>Madeira serrada (viga)</td>\n",
       "      <td>Madeira serrada bruta</td>\n",
       "      <td>12</td>\n",
       "      <td>Hymenaea courbaril</td>\n",
       "      <td>Jatobá</td>\n",
       "      <td>Jatobá</td>\n",
       "      <td>119</td>\n",
       "      <td>0.1560</td>\n",
       "      <td>M3</td>\n",
       "      <td>23.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1349754</th>\n",
       "      <td>690771</td>\n",
       "      <td>MARTINS E RABELO LTDA - ME</td>\n",
       "      <td>20201146000102</td>\n",
       "      <td>AC</td>\n",
       "      <td>RIO BRANCO</td>\n",
       "      <td>1200401</td>\n",
       "      <td>-10.066148</td>\n",
       "      <td>-68.371045</td>\n",
       "      <td>6057030</td>\n",
       "      <td>PATIO</td>\n",
       "      <td>...</td>\n",
       "      <td>Madeira Aplainada 2 Faces (S2S)</td>\n",
       "      <td>Produtos acabados de madeira</td>\n",
       "      <td>13</td>\n",
       "      <td>Apuleia molaris</td>\n",
       "      <td>Garapeira</td>\n",
       "      <td>Garapeira</td>\n",
       "      <td>117</td>\n",
       "      <td>0.8020</td>\n",
       "      <td>M3</td>\n",
       "      <td>120.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1349755</th>\n",
       "      <td>690772</td>\n",
       "      <td>MARTINS E RABELO LTDA - ME</td>\n",
       "      <td>20201146000102</td>\n",
       "      <td>AC</td>\n",
       "      <td>RIO BRANCO</td>\n",
       "      <td>1200401</td>\n",
       "      <td>-10.066148</td>\n",
       "      <td>-68.371045</td>\n",
       "      <td>6057030</td>\n",
       "      <td>PATIO</td>\n",
       "      <td>...</td>\n",
       "      <td>Madeira serrada (prancha)</td>\n",
       "      <td>Madeira serrada bruta</td>\n",
       "      <td>12</td>\n",
       "      <td>Cedrela odorata</td>\n",
       "      <td>Cedro</td>\n",
       "      <td>Cedro</td>\n",
       "      <td>120</td>\n",
       "      <td>7.0300</td>\n",
       "      <td>M3</td>\n",
       "      <td>4218.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1349756</th>\n",
       "      <td>690773</td>\n",
       "      <td>MARTINS E RABELO LTDA - ME</td>\n",
       "      <td>20201146000102</td>\n",
       "      <td>AC</td>\n",
       "      <td>RIO BRANCO</td>\n",
       "      <td>1200401</td>\n",
       "      <td>-10.066148</td>\n",
       "      <td>-68.371045</td>\n",
       "      <td>6057030</td>\n",
       "      <td>PATIO</td>\n",
       "      <td>...</td>\n",
       "      <td>Madeira serrada (tábua)</td>\n",
       "      <td>Madeira serrada bruta</td>\n",
       "      <td>12</td>\n",
       "      <td>Cedrela odorata</td>\n",
       "      <td>Cedro</td>\n",
       "      <td>Cedro</td>\n",
       "      <td>120</td>\n",
       "      <td>4.3200</td>\n",
       "      <td>M3</td>\n",
       "      <td>2592.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1349761</th>\n",
       "      <td>690778</td>\n",
       "      <td>ROZA M. DOS SANTOS - (ME)</td>\n",
       "      <td>04004549000105</td>\n",
       "      <td>AC</td>\n",
       "      <td>RIO BRANCO</td>\n",
       "      <td>1200401</td>\n",
       "      <td>-10.066148</td>\n",
       "      <td>-68.371045</td>\n",
       "      <td>199421</td>\n",
       "      <td>PATIO</td>\n",
       "      <td>...</td>\n",
       "      <td>Sarrafo</td>\n",
       "      <td>Madeira serrada bruta</td>\n",
       "      <td>12</td>\n",
       "      <td>Enterolobium schomburgkii</td>\n",
       "      <td>Orelhademacaco</td>\n",
       "      <td>Fava orelha de macaco</td>\n",
       "      <td>73</td>\n",
       "      <td>0.2688</td>\n",
       "      <td>M3</td>\n",
       "      <td>40.32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1349762</th>\n",
       "      <td>690779</td>\n",
       "      <td>ROZA M. DOS SANTOS - (ME)</td>\n",
       "      <td>04004549000105</td>\n",
       "      <td>AC</td>\n",
       "      <td>RIO BRANCO</td>\n",
       "      <td>1200401</td>\n",
       "      <td>-10.066148</td>\n",
       "      <td>-68.371045</td>\n",
       "      <td>199421</td>\n",
       "      <td>PATIO</td>\n",
       "      <td>...</td>\n",
       "      <td>Madeira serrada (viga)</td>\n",
       "      <td>Madeira serrada bruta</td>\n",
       "      <td>12</td>\n",
       "      <td>Apuleia leiocarpa</td>\n",
       "      <td>Garapeira</td>\n",
       "      <td>Garapeira</td>\n",
       "      <td>117</td>\n",
       "      <td>0.4410</td>\n",
       "      <td>M3</td>\n",
       "      <td>66.15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1349766</th>\n",
       "      <td>690783</td>\n",
       "      <td>ROZA M. DOS SANTOS - (ME)</td>\n",
       "      <td>04004549000105</td>\n",
       "      <td>AC</td>\n",
       "      <td>RIO BRANCO</td>\n",
       "      <td>1200401</td>\n",
       "      <td>-10.066148</td>\n",
       "      <td>-68.371045</td>\n",
       "      <td>199421</td>\n",
       "      <td>PATIO</td>\n",
       "      <td>...</td>\n",
       "      <td>Madeira serrada (tábua)</td>\n",
       "      <td>Madeira serrada bruta</td>\n",
       "      <td>12</td>\n",
       "      <td>Apuleia leiocarpa</td>\n",
       "      <td>Garapeira</td>\n",
       "      <td>Garapeira</td>\n",
       "      <td>117</td>\n",
       "      <td>1.6706</td>\n",
       "      <td>M3</td>\n",
       "      <td>250.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1349767</th>\n",
       "      <td>690784</td>\n",
       "      <td>ROZA M. DOS SANTOS - (ME)</td>\n",
       "      <td>04004549000105</td>\n",
       "      <td>AC</td>\n",
       "      <td>RIO BRANCO</td>\n",
       "      <td>1200401</td>\n",
       "      <td>-10.066148</td>\n",
       "      <td>-68.371045</td>\n",
       "      <td>199421</td>\n",
       "      <td>PATIO</td>\n",
       "      <td>...</td>\n",
       "      <td>Madeira serrada (tábua)</td>\n",
       "      <td>Madeira serrada bruta</td>\n",
       "      <td>12</td>\n",
       "      <td>Ceiba pentandra</td>\n",
       "      <td>Sumaúma</td>\n",
       "      <td>Espécies mistas brancas</td>\n",
       "      <td>58</td>\n",
       "      <td>2.6466</td>\n",
       "      <td>M3</td>\n",
       "      <td>396.99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1349768</th>\n",
       "      <td>690785</td>\n",
       "      <td>ROZA M. DOS SANTOS - (ME)</td>\n",
       "      <td>04004549000105</td>\n",
       "      <td>AC</td>\n",
       "      <td>RIO BRANCO</td>\n",
       "      <td>1200401</td>\n",
       "      <td>-10.066148</td>\n",
       "      <td>-68.371045</td>\n",
       "      <td>199421</td>\n",
       "      <td>PATIO</td>\n",
       "      <td>...</td>\n",
       "      <td>Madeira serrada (viga)</td>\n",
       "      <td>Madeira serrada bruta</td>\n",
       "      <td>12</td>\n",
       "      <td>Myroxylon balsamum</td>\n",
       "      <td>Bálsamo</td>\n",
       "      <td>Outras espécies nativas</td>\n",
       "      <td>107</td>\n",
       "      <td>0.5788</td>\n",
       "      <td>M3</td>\n",
       "      <td>86.82</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1349771</th>\n",
       "      <td>690788</td>\n",
       "      <td>MARTINS E RABELO LTDA - ME</td>\n",
       "      <td>20201146000102</td>\n",
       "      <td>AC</td>\n",
       "      <td>RIO BRANCO</td>\n",
       "      <td>1200401</td>\n",
       "      <td>-10.066148</td>\n",
       "      <td>-68.371045</td>\n",
       "      <td>6057030</td>\n",
       "      <td>PATIO</td>\n",
       "      <td>...</td>\n",
       "      <td>Madeira serrada (prancha)</td>\n",
       "      <td>Madeira serrada bruta</td>\n",
       "      <td>12</td>\n",
       "      <td>Eschweilera grandiflora</td>\n",
       "      <td>Matamatárosa</td>\n",
       "      <td>Biriba - Matamatá</td>\n",
       "      <td>4</td>\n",
       "      <td>0.2100</td>\n",
       "      <td>M3</td>\n",
       "      <td>31.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1349772</th>\n",
       "      <td>690789</td>\n",
       "      <td>MARTINS E RABELO LTDA - ME</td>\n",
       "      <td>20201146000102</td>\n",
       "      <td>AC</td>\n",
       "      <td>RIO BRANCO</td>\n",
       "      <td>1200401</td>\n",
       "      <td>-10.066148</td>\n",
       "      <td>-68.371045</td>\n",
       "      <td>6057030</td>\n",
       "      <td>PATIO</td>\n",
       "      <td>...</td>\n",
       "      <td>Madeira serrada (pranchão desdobrado)</td>\n",
       "      <td>Madeira serrada bruta</td>\n",
       "      <td>12</td>\n",
       "      <td>Eschweilera grandiflora</td>\n",
       "      <td>Matamatárosa</td>\n",
       "      <td>Biriba - Matamatá</td>\n",
       "      <td>4</td>\n",
       "      <td>0.6000</td>\n",
       "      <td>M3</td>\n",
       "      <td>90.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1349773</th>\n",
       "      <td>690790</td>\n",
       "      <td>MARTINS E RABELO LTDA - ME</td>\n",
       "      <td>20201146000102</td>\n",
       "      <td>AC</td>\n",
       "      <td>RIO BRANCO</td>\n",
       "      <td>1200401</td>\n",
       "      <td>-10.066148</td>\n",
       "      <td>-68.371045</td>\n",
       "      <td>6057030</td>\n",
       "      <td>PATIO</td>\n",
       "      <td>...</td>\n",
       "      <td>Madeira serrada (caibro)</td>\n",
       "      <td>Madeira serrada bruta</td>\n",
       "      <td>12</td>\n",
       "      <td>Eschweilera grandiflora</td>\n",
       "      <td>Matamatárosa</td>\n",
       "      <td>Biriba - Matamatá</td>\n",
       "      <td>4</td>\n",
       "      <td>0.3900</td>\n",
       "      <td>M3</td>\n",
       "      <td>58.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1349774</th>\n",
       "      <td>690791</td>\n",
       "      <td>MARTINS E RABELO LTDA - ME</td>\n",
       "      <td>20201146000102</td>\n",
       "      <td>AC</td>\n",
       "      <td>RIO BRANCO</td>\n",
       "      <td>1200401</td>\n",
       "      <td>-10.066148</td>\n",
       "      <td>-68.371045</td>\n",
       "      <td>6057030</td>\n",
       "      <td>PATIO</td>\n",
       "      <td>...</td>\n",
       "      <td>Madeira serrada (viga)</td>\n",
       "      <td>Madeira serrada bruta</td>\n",
       "      <td>12</td>\n",
       "      <td>Eschweilera grandiflora</td>\n",
       "      <td>Matamatárosa</td>\n",
       "      <td>Biriba - Matamatá</td>\n",
       "      <td>4</td>\n",
       "      <td>1.9000</td>\n",
       "      <td>M3</td>\n",
       "      <td>285.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1349775</th>\n",
       "      <td>690792</td>\n",
       "      <td>MARTINS E RABELO LTDA - ME</td>\n",
       "      <td>20201146000102</td>\n",
       "      <td>AC</td>\n",
       "      <td>RIO BRANCO</td>\n",
       "      <td>1200401</td>\n",
       "      <td>-10.066148</td>\n",
       "      <td>-68.371045</td>\n",
       "      <td>6057030</td>\n",
       "      <td>PATIO</td>\n",
       "      <td>...</td>\n",
       "      <td>Madeira serrada (caibro)</td>\n",
       "      <td>Madeira serrada bruta</td>\n",
       "      <td>12</td>\n",
       "      <td>Apuleia leiocarpa</td>\n",
       "      <td>Garapeira</td>\n",
       "      <td>Garapeira</td>\n",
       "      <td>117</td>\n",
       "      <td>2.8862</td>\n",
       "      <td>M3</td>\n",
       "      <td>432.93</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1349776</th>\n",
       "      <td>690793</td>\n",
       "      <td>MARTINS E RABELO LTDA - ME</td>\n",
       "      <td>20201146000102</td>\n",
       "      <td>AC</td>\n",
       "      <td>RIO BRANCO</td>\n",
       "      <td>1200401</td>\n",
       "      <td>-10.066148</td>\n",
       "      <td>-68.371045</td>\n",
       "      <td>6057030</td>\n",
       "      <td>PATIO</td>\n",
       "      <td>...</td>\n",
       "      <td>Madeira serrada (caibro)</td>\n",
       "      <td>Madeira serrada bruta</td>\n",
       "      <td>12</td>\n",
       "      <td>Caryocar villosum</td>\n",
       "      <td>Pequiarana</td>\n",
       "      <td>Pequiá</td>\n",
       "      <td>50</td>\n",
       "      <td>3.3120</td>\n",
       "      <td>M3</td>\n",
       "      <td>496.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1349777</th>\n",
       "      <td>690794</td>\n",
       "      <td>MARTINS E RABELO LTDA - ME</td>\n",
       "      <td>20201146000102</td>\n",
       "      <td>AC</td>\n",
       "      <td>RIO BRANCO</td>\n",
       "      <td>1200401</td>\n",
       "      <td>-10.066148</td>\n",
       "      <td>-68.371045</td>\n",
       "      <td>6057030</td>\n",
       "      <td>PATIO</td>\n",
       "      <td>...</td>\n",
       "      <td>Ripas</td>\n",
       "      <td>Madeira serrada bruta</td>\n",
       "      <td>12</td>\n",
       "      <td>Apuleia molaris</td>\n",
       "      <td>Garapeira</td>\n",
       "      <td>Garapeira</td>\n",
       "      <td>117</td>\n",
       "      <td>0.4500</td>\n",
       "      <td>M3</td>\n",
       "      <td>67.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1349778</th>\n",
       "      <td>690795</td>\n",
       "      <td>MARTINS E RABELO LTDA - ME</td>\n",
       "      <td>20201146000102</td>\n",
       "      <td>AC</td>\n",
       "      <td>RIO BRANCO</td>\n",
       "      <td>1200401</td>\n",
       "      <td>-10.066148</td>\n",
       "      <td>-68.371045</td>\n",
       "      <td>6057030</td>\n",
       "      <td>PATIO</td>\n",
       "      <td>...</td>\n",
       "      <td>Madeira serrada (viga)</td>\n",
       "      <td>Madeira serrada bruta</td>\n",
       "      <td>12</td>\n",
       "      <td>Enterolobium schomburgkii</td>\n",
       "      <td>Favaorelhademacaco</td>\n",
       "      <td>Fava orelha de macaco</td>\n",
       "      <td>73</td>\n",
       "      <td>1.2722</td>\n",
       "      <td>M3</td>\n",
       "      <td>190.83</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>788768 rows × 57 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             id                                  nome_remetente  \\\n",
       "0        690796                      MARTINS E RABELO LTDA - ME   \n",
       "1        690797                      MARTINS E RABELO LTDA - ME   \n",
       "2        690798        L. A. GRAMS IMPORTAÇÃO E EXPORTAÇÃO - ME   \n",
       "3        690799        L. A. GRAMS IMPORTAÇÃO E EXPORTAÇÃO - ME   \n",
       "7        690803  AGROCORTEX MADEIRAS DO ACRE AGROFLORESTAL LTDA   \n",
       "11       690808  AGROCORTEX MADEIRAS DO ACRE AGROFLORESTAL LTDA   \n",
       "14       690811                      MARTINS E RABELO LTDA - ME   \n",
       "15       690812                      MARTINS E RABELO LTDA - ME   \n",
       "16       690813                      MARTINS E RABELO LTDA - ME   \n",
       "17       690814                      MARTINS E RABELO LTDA - ME   \n",
       "18       690815                      MARTINS E RABELO LTDA - ME   \n",
       "20       690818  AGROCORTEX MADEIRAS DO ACRE AGROFLORESTAL LTDA   \n",
       "23       690822                      MARTINS E RABELO LTDA - ME   \n",
       "24       690823                      MARTINS E RABELO LTDA - ME   \n",
       "25       690824                      MARTINS E RABELO LTDA - ME   \n",
       "26       690825                      MARTINS E RABELO LTDA - ME   \n",
       "30       690829                         MADEIREIRA JR LTDA - ME   \n",
       "33       690832                      MARTINS E RABELO LTDA - ME   \n",
       "37       690926                              FOX LAMINADOS LTDA   \n",
       "40       690838                IND E COM DE MAD INDIA PORA LTDA   \n",
       "41       690839                IND E COM DE MAD INDIA PORA LTDA   \n",
       "42       690840                                     E. B. ALVES   \n",
       "43       690841                                     E. B. ALVES   \n",
       "44       690842                                     E. B. ALVES   \n",
       "45       690843                                     E. B. ALVES   \n",
       "46       690844                                     E. B. ALVES   \n",
       "47       690845                                     E. B. ALVES   \n",
       "48       690846                                     E. B. ALVES   \n",
       "49       690847                                     E. B. ALVES   \n",
       "83       690882                            SENA MADEIREIRA LTDA   \n",
       "...         ...                                             ...   \n",
       "1349734  690750                           C. DAMSKI EIRELI - ME   \n",
       "1349735  690751                           C. DAMSKI EIRELI - ME   \n",
       "1349736  690752                           C. DAMSKI EIRELI - ME   \n",
       "1349737  690754          RECOMAL RED IND E COM DE MADEIRAS LTDA   \n",
       "1349738  690755          RECOMAL RED IND E COM DE MADEIRAS LTDA   \n",
       "1349739  690756           IND. E COM. DE MADEIRA TRIANGULO LTDA   \n",
       "1349740  690757        L. A. GRAMS IMPORTAÇÃO E EXPORTAÇÃO - ME   \n",
       "1349741  690758        L. A. GRAMS IMPORTAÇÃO E EXPORTAÇÃO - ME   \n",
       "1349742  690759        L. A. GRAMS IMPORTAÇÃO E EXPORTAÇÃO - ME   \n",
       "1349743  690760        L. A. GRAMS IMPORTAÇÃO E EXPORTAÇÃO - ME   \n",
       "1349744  690761        L. A. GRAMS IMPORTAÇÃO E EXPORTAÇÃO - ME   \n",
       "1349745  690762        L. A. GRAMS IMPORTAÇÃO E EXPORTAÇÃO - ME   \n",
       "1349752  690769                IND E COM DE MAD INDIA PORA LTDA   \n",
       "1349753  690770                      MARTINS E RABELO LTDA - ME   \n",
       "1349754  690771                      MARTINS E RABELO LTDA - ME   \n",
       "1349755  690772                      MARTINS E RABELO LTDA - ME   \n",
       "1349756  690773                      MARTINS E RABELO LTDA - ME   \n",
       "1349761  690778                       ROZA M. DOS SANTOS - (ME)   \n",
       "1349762  690779                       ROZA M. DOS SANTOS - (ME)   \n",
       "1349766  690783                       ROZA M. DOS SANTOS - (ME)   \n",
       "1349767  690784                       ROZA M. DOS SANTOS - (ME)   \n",
       "1349768  690785                       ROZA M. DOS SANTOS - (ME)   \n",
       "1349771  690788                      MARTINS E RABELO LTDA - ME   \n",
       "1349772  690789                      MARTINS E RABELO LTDA - ME   \n",
       "1349773  690790                      MARTINS E RABELO LTDA - ME   \n",
       "1349774  690791                      MARTINS E RABELO LTDA - ME   \n",
       "1349775  690792                      MARTINS E RABELO LTDA - ME   \n",
       "1349776  690793                      MARTINS E RABELO LTDA - ME   \n",
       "1349777  690794                      MARTINS E RABELO LTDA - ME   \n",
       "1349778  690795                      MARTINS E RABELO LTDA - ME   \n",
       "\n",
       "          cpf_remetente uf_origem municipio_origem  cd_mun_origem  \\\n",
       "0        20201146000102        AC       RIO BRANCO        1200401   \n",
       "1        20201146000102        AC       RIO BRANCO        1200401   \n",
       "2        24438974000110        AC   SENA MADUREIRA        1200500   \n",
       "3        24438974000110        AC   SENA MADUREIRA        1200500   \n",
       "7        19848073000166        AC    MANOEL URBANO        1200344   \n",
       "11       19848073000166        AC    MANOEL URBANO        1200344   \n",
       "14       20201146000102        AC       RIO BRANCO        1200401   \n",
       "15       20201146000102        AC       RIO BRANCO        1200401   \n",
       "16       20201146000102        AC       RIO BRANCO        1200401   \n",
       "17       20201146000102        AC       RIO BRANCO        1200401   \n",
       "18       20201146000102        AC       RIO BRANCO        1200401   \n",
       "20       19848073000166        AC    MANOEL URBANO        1200344   \n",
       "23       20201146000102        AC       RIO BRANCO        1200401   \n",
       "24       20201146000102        AC       RIO BRANCO        1200401   \n",
       "25       20201146000102        AC       RIO BRANCO        1200401   \n",
       "26       20201146000102        AC       RIO BRANCO        1200401   \n",
       "30       34703017000127        AC       RIO BRANCO        1200401   \n",
       "33       20201146000102        AC       RIO BRANCO        1200401   \n",
       "37       04642220000170        AC       PORTO ACRE        1200807   \n",
       "40       04582045000172        AC       RIO BRANCO        1200401   \n",
       "41       04582045000172        AC       RIO BRANCO        1200401   \n",
       "42       10567563000110        AC       RIO BRANCO        1200401   \n",
       "43       10567563000110        AC       RIO BRANCO        1200401   \n",
       "44       10567563000110        AC       RIO BRANCO        1200401   \n",
       "45       10567563000110        AC       RIO BRANCO        1200401   \n",
       "46       10567563000110        AC       RIO BRANCO        1200401   \n",
       "47       10567563000110        AC       RIO BRANCO        1200401   \n",
       "48       10567563000110        AC       RIO BRANCO        1200401   \n",
       "49       10567563000110        AC       RIO BRANCO        1200401   \n",
       "83       15625377000103        AC            FEIJO        1200302   \n",
       "...                 ...       ...              ...            ...   \n",
       "1349734  14029287000197        AC       RIO BRANCO        1200401   \n",
       "1349735  14029287000197        AC       RIO BRANCO        1200401   \n",
       "1349736  14029287000197        AC       RIO BRANCO        1200401   \n",
       "1349737  01856239000120        AC       ACRELANDIA        1200013   \n",
       "1349738  01856239000120        AC       ACRELANDIA        1200013   \n",
       "1349739  84328434000105        AC       RIO BRANCO        1200401   \n",
       "1349740  24438974000110        AC   SENA MADUREIRA        1200500   \n",
       "1349741  24438974000110        AC   SENA MADUREIRA        1200500   \n",
       "1349742  24438974000110        AC   SENA MADUREIRA        1200500   \n",
       "1349743  24438974000110        AC   SENA MADUREIRA        1200500   \n",
       "1349744  24438974000110        AC   SENA MADUREIRA        1200500   \n",
       "1349745  24438974000110        AC   SENA MADUREIRA        1200500   \n",
       "1349752  04582045000172        AC       RIO BRANCO        1200401   \n",
       "1349753  20201146000102        AC       RIO BRANCO        1200401   \n",
       "1349754  20201146000102        AC       RIO BRANCO        1200401   \n",
       "1349755  20201146000102        AC       RIO BRANCO        1200401   \n",
       "1349756  20201146000102        AC       RIO BRANCO        1200401   \n",
       "1349761  04004549000105        AC       RIO BRANCO        1200401   \n",
       "1349762  04004549000105        AC       RIO BRANCO        1200401   \n",
       "1349766  04004549000105        AC       RIO BRANCO        1200401   \n",
       "1349767  04004549000105        AC       RIO BRANCO        1200401   \n",
       "1349768  04004549000105        AC       RIO BRANCO        1200401   \n",
       "1349771  20201146000102        AC       RIO BRANCO        1200401   \n",
       "1349772  20201146000102        AC       RIO BRANCO        1200401   \n",
       "1349773  20201146000102        AC       RIO BRANCO        1200401   \n",
       "1349774  20201146000102        AC       RIO BRANCO        1200401   \n",
       "1349775  20201146000102        AC       RIO BRANCO        1200401   \n",
       "1349776  20201146000102        AC       RIO BRANCO        1200401   \n",
       "1349777  20201146000102        AC       RIO BRANCO        1200401   \n",
       "1349778  20201146000102        AC       RIO BRANCO        1200401   \n",
       "\n",
       "         latitude_origem  longitude_origem  ctf_remetente  \\\n",
       "0             -10.066148        -68.371045        6057030   \n",
       "1             -10.066148        -68.371045        6057030   \n",
       "2              -9.771175        -69.381570        6559713   \n",
       "3              -9.771175        -69.381570        6559713   \n",
       "7              -9.381206        -69.853924        6046829   \n",
       "11             -9.381206        -69.853924        6046829   \n",
       "14            -10.066148        -68.371045        6057030   \n",
       "15            -10.066148        -68.371045        6057030   \n",
       "16            -10.066148        -68.371045        6057030   \n",
       "17            -10.066148        -68.371045        6057030   \n",
       "18            -10.066148        -68.371045        6057030   \n",
       "20             -9.381206        -69.853924        6046829   \n",
       "23            -10.066148        -68.371045        6057030   \n",
       "24            -10.066148        -68.371045        6057030   \n",
       "25            -10.066148        -68.371045        6057030   \n",
       "26            -10.066148        -68.371045        6057030   \n",
       "30            -10.066148        -68.371045          25565   \n",
       "33            -10.066148        -68.371045        6057030   \n",
       "37             -9.629506        -67.698446          40218   \n",
       "40            -10.066148        -68.371045           4351   \n",
       "41            -10.066148        -68.371045           4351   \n",
       "42            -10.066148        -68.371045        6721966   \n",
       "43            -10.066148        -68.371045        6721966   \n",
       "44            -10.066148        -68.371045        6721966   \n",
       "45            -10.066148        -68.371045        6721966   \n",
       "46            -10.066148        -68.371045        6721966   \n",
       "47            -10.066148        -68.371045        6721966   \n",
       "48            -10.066148        -68.371045        6721966   \n",
       "49            -10.066148        -68.371045        6721966   \n",
       "83             -8.924464        -70.744779        5675249   \n",
       "...                  ...               ...            ...   \n",
       "1349734       -10.066148        -68.371045        5299377   \n",
       "1349735       -10.066148        -68.371045        5299377   \n",
       "1349736       -10.066148        -68.371045        5299377   \n",
       "1349737        -9.933715        -66.950492          31757   \n",
       "1349738        -9.933715        -66.950492          31757   \n",
       "1349739       -10.066148        -68.371045          30322   \n",
       "1349740        -9.771175        -69.381570        6559713   \n",
       "1349741        -9.771175        -69.381570        6559713   \n",
       "1349742        -9.771175        -69.381570        6559713   \n",
       "1349743        -9.771175        -69.381570        6559713   \n",
       "1349744        -9.771175        -69.381570        6559713   \n",
       "1349745        -9.771175        -69.381570        6559713   \n",
       "1349752       -10.066148        -68.371045           4351   \n",
       "1349753       -10.066148        -68.371045        6057030   \n",
       "1349754       -10.066148        -68.371045        6057030   \n",
       "1349755       -10.066148        -68.371045        6057030   \n",
       "1349756       -10.066148        -68.371045        6057030   \n",
       "1349761       -10.066148        -68.371045         199421   \n",
       "1349762       -10.066148        -68.371045         199421   \n",
       "1349766       -10.066148        -68.371045         199421   \n",
       "1349767       -10.066148        -68.371045         199421   \n",
       "1349768       -10.066148        -68.371045         199421   \n",
       "1349771       -10.066148        -68.371045        6057030   \n",
       "1349772       -10.066148        -68.371045        6057030   \n",
       "1349773       -10.066148        -68.371045        6057030   \n",
       "1349774       -10.066148        -68.371045        6057030   \n",
       "1349775       -10.066148        -68.371045        6057030   \n",
       "1349776       -10.066148        -68.371045        6057030   \n",
       "1349777       -10.066148        -68.371045        6057030   \n",
       "1349778       -10.066148        -68.371045        6057030   \n",
       "\n",
       "                                  tipo_origem    ...     \\\n",
       "0                                       PATIO    ...      \n",
       "1                                       PATIO    ...      \n",
       "2                                       PATIO    ...      \n",
       "3                                       PATIO    ...      \n",
       "7                                       PATIO    ...      \n",
       "11                                      PATIO    ...      \n",
       "14                                      PATIO    ...      \n",
       "15                                      PATIO    ...      \n",
       "16                                      PATIO    ...      \n",
       "17                                      PATIO    ...      \n",
       "18                                      PATIO    ...      \n",
       "20                                      PATIO    ...      \n",
       "23                                      PATIO    ...      \n",
       "24                                      PATIO    ...      \n",
       "25                                      PATIO    ...      \n",
       "26                                      PATIO    ...      \n",
       "30                                      PATIO    ...      \n",
       "33                                      PATIO    ...      \n",
       "37                                      PATIO    ...      \n",
       "40                                      PATIO    ...      \n",
       "41                                      PATIO    ...      \n",
       "42                                      PATIO    ...      \n",
       "43                                      PATIO    ...      \n",
       "44                                      PATIO    ...      \n",
       "45                                      PATIO    ...      \n",
       "46                                      PATIO    ...      \n",
       "47                                      PATIO    ...      \n",
       "48                                      PATIO    ...      \n",
       "49                                      PATIO    ...      \n",
       "83       AUTEX-Exploração em Planos de Manejo    ...      \n",
       "...                                       ...    ...      \n",
       "1349734                                 PATIO    ...      \n",
       "1349735                                 PATIO    ...      \n",
       "1349736                                 PATIO    ...      \n",
       "1349737                                 PATIO    ...      \n",
       "1349738                                 PATIO    ...      \n",
       "1349739                                 PATIO    ...      \n",
       "1349740                                 PATIO    ...      \n",
       "1349741                                 PATIO    ...      \n",
       "1349742                                 PATIO    ...      \n",
       "1349743                                 PATIO    ...      \n",
       "1349744                                 PATIO    ...      \n",
       "1349745                                 PATIO    ...      \n",
       "1349752                                 PATIO    ...      \n",
       "1349753                                 PATIO    ...      \n",
       "1349754                                 PATIO    ...      \n",
       "1349755                                 PATIO    ...      \n",
       "1349756                                 PATIO    ...      \n",
       "1349761                                 PATIO    ...      \n",
       "1349762                                 PATIO    ...      \n",
       "1349766                                 PATIO    ...      \n",
       "1349767                                 PATIO    ...      \n",
       "1349768                                 PATIO    ...      \n",
       "1349771                                 PATIO    ...      \n",
       "1349772                                 PATIO    ...      \n",
       "1349773                                 PATIO    ...      \n",
       "1349774                                 PATIO    ...      \n",
       "1349775                                 PATIO    ...      \n",
       "1349776                                 PATIO    ...      \n",
       "1349777                                 PATIO    ...      \n",
       "1349778                                 PATIO    ...      \n",
       "\n",
       "                                       produto              produto_agrupado  \\\n",
       "0                       Madeira serrada (viga)         Madeira serrada bruta   \n",
       "1                       Madeira serrada (viga)         Madeira serrada bruta   \n",
       "2                                       Alisar  Produtos acabados de madeira   \n",
       "3                            Portal ou Batente  Produtos acabados de madeira   \n",
       "7                                         Tora                          Tora   \n",
       "11                     Madeira serrada (tábua)         Madeira serrada bruta   \n",
       "14                     Bloco, quadrado ou filé            Blocos e dormentes   \n",
       "15                    Madeira serrada (caibro)         Madeira serrada bruta   \n",
       "16                    Madeira serrada (caibro)         Madeira serrada bruta   \n",
       "17                     Madeira serrada (tábua)         Madeira serrada bruta   \n",
       "18                      Madeira serrada (viga)         Madeira serrada bruta   \n",
       "20                                        Tora                          Tora   \n",
       "23                    Madeira serrada (caibro)         Madeira serrada bruta   \n",
       "24                     Madeira serrada (tábua)         Madeira serrada bruta   \n",
       "25                                       Ripas         Madeira serrada bruta   \n",
       "26                     Bloco, quadrado ou filé            Blocos e dormentes   \n",
       "30               Resíduo para Fins Energéticos          Resíduos industriais   \n",
       "33                     Madeira serrada (tábua)         Madeira serrada bruta   \n",
       "37                      Madeira serrada (viga)         Madeira serrada bruta   \n",
       "40                   Madeira serrada (prancha)         Madeira serrada bruta   \n",
       "41                     Madeira serrada (tábua)         Madeira serrada bruta   \n",
       "42                    Madeira serrada (caibro)         Madeira serrada bruta   \n",
       "43                                     Sarrafo         Madeira serrada bruta   \n",
       "44                     Madeira serrada (tábua)         Madeira serrada bruta   \n",
       "45                      Madeira serrada (viga)         Madeira serrada bruta   \n",
       "46                    Madeira serrada (vigota)         Madeira serrada bruta   \n",
       "47                    Madeira serrada (caibro)         Madeira serrada bruta   \n",
       "48                                     Sarrafo         Madeira serrada bruta   \n",
       "49                     Madeira serrada (tábua)         Madeira serrada bruta   \n",
       "83                                        Tora                          Tora   \n",
       "...                                        ...                           ...   \n",
       "1349734                                   Tora                          Tora   \n",
       "1349735                                   Tora                          Tora   \n",
       "1349736                                   Tora                          Tora   \n",
       "1349737          Resíduo para Fins Energéticos          Resíduos industriais   \n",
       "1349738          Resíduo para Fins Energéticos          Resíduos industriais   \n",
       "1349739                 Madeira serrada (viga)         Madeira serrada bruta   \n",
       "1349740              Madeira serrada (prancha)         Madeira serrada bruta   \n",
       "1349741                Bloco, quadrado ou filé            Blocos e dormentes   \n",
       "1349742               Madeira serrada (caibro)         Madeira serrada bruta   \n",
       "1349743                                Sarrafo         Madeira serrada bruta   \n",
       "1349744                Madeira serrada (tábua)         Madeira serrada bruta   \n",
       "1349745                 Madeira serrada (viga)         Madeira serrada bruta   \n",
       "1349752                Madeira serrada (tábua)         Madeira serrada bruta   \n",
       "1349753                 Madeira serrada (viga)         Madeira serrada bruta   \n",
       "1349754        Madeira Aplainada 2 Faces (S2S)  Produtos acabados de madeira   \n",
       "1349755              Madeira serrada (prancha)         Madeira serrada bruta   \n",
       "1349756                Madeira serrada (tábua)         Madeira serrada bruta   \n",
       "1349761                                Sarrafo         Madeira serrada bruta   \n",
       "1349762                 Madeira serrada (viga)         Madeira serrada bruta   \n",
       "1349766                Madeira serrada (tábua)         Madeira serrada bruta   \n",
       "1349767                Madeira serrada (tábua)         Madeira serrada bruta   \n",
       "1349768                 Madeira serrada (viga)         Madeira serrada bruta   \n",
       "1349771              Madeira serrada (prancha)         Madeira serrada bruta   \n",
       "1349772  Madeira serrada (pranchão desdobrado)         Madeira serrada bruta   \n",
       "1349773               Madeira serrada (caibro)         Madeira serrada bruta   \n",
       "1349774                 Madeira serrada (viga)         Madeira serrada bruta   \n",
       "1349775               Madeira serrada (caibro)         Madeira serrada bruta   \n",
       "1349776               Madeira serrada (caibro)         Madeira serrada bruta   \n",
       "1349777                                  Ripas         Madeira serrada bruta   \n",
       "1349778                 Madeira serrada (viga)         Madeira serrada bruta   \n",
       "\n",
       "        id_produto_agrupado            nome_cientifico          nome_popular  \\\n",
       "0                        12          Apuleia leiocarpa             Garapeira   \n",
       "1                        12       Couratari guianensis                Tauari   \n",
       "2                        13      Couratari macrosperma                Tauari   \n",
       "3                        13      Couratari macrosperma                Tauari   \n",
       "7                         1    Eschweilera grandiflora              Matamatá   \n",
       "11                       12           Dipteryx odorata                Cumaru   \n",
       "14                        4    Eschweilera grandiflora          Matamatárosa   \n",
       "15                       12           Caryocar glabrum            Pequiarana   \n",
       "16                       12          Caryocar villosum                 Pequi   \n",
       "17                       12          Caryocar villosum             Pequirana   \n",
       "18                       12    Eschweilera grandiflora          Matamatárosa   \n",
       "20                        1          Caryocar villosum                Pequiá   \n",
       "23                       12       Couratari guianensis                Tauari   \n",
       "24                       12          Caryocar villosum                 Pequi   \n",
       "25                       12           Pouteria caimito              Abiurana   \n",
       "26                        4          Caryocar villosum                 Pequi   \n",
       "30                        8            Ceiba pentandra               Sumaúma   \n",
       "33                       12          Caryocar villosum             Pequirosa   \n",
       "37                       12            Apuleia molaris             Garapeira   \n",
       "40                       12            Apuleia molaris                Garapa   \n",
       "41                       12            Dinizia excelsa               Angelim   \n",
       "42                       12  Enterolobium schomburgkii        Orelhademacaco   \n",
       "43                       12          Dialium guianense             Tamarindo   \n",
       "44                       12        Dipteryx polyphylla                Cumaru   \n",
       "45                       12          Qualea tessmannii               Catuaba   \n",
       "46                       12   Aspidosperma parvifolium              Amarelão   \n",
       "47                       12          Eschweilera odora  Castanharanavermelha   \n",
       "48                       12  Enterolobium schomburgkii        Orelhademacaco   \n",
       "49                       12        Cariniana micrantha             Jequitiba   \n",
       "83                        1          Eschweilera odora  Castanharanavermelha   \n",
       "...                     ...                        ...                   ...   \n",
       "1349734                   1         Pterocarpus rohrii             Pausangue   \n",
       "1349735                   1    Schizolobium amazonicum         Pinhocuiabano   \n",
       "1349736                   1              Ceiba samauma          SamaúmaPreta   \n",
       "1349737                   8            Apuleia molaris             Garapeira   \n",
       "1349738                   8          Clarisia racemosa              Guariúba   \n",
       "1349739                  12         Hymenaea courbaril                Jatobá   \n",
       "1349740                  12        Manilkara bidentata           Maçaranduba   \n",
       "1349741                   4        Manilkara bidentata           Maçaranduba   \n",
       "1349742                  12        Manilkara bidentata           Maçaranduba   \n",
       "1349743                  12        Manilkara bidentata            Maparajuba   \n",
       "1349744                  12          Dialium guianense             Tamarinda   \n",
       "1349745                  12        Manilkara bidentata           Maçaranduba   \n",
       "1349752                  12        Copaifera multijuga               Copaíba   \n",
       "1349753                  12         Hymenaea courbaril                Jatobá   \n",
       "1349754                  13            Apuleia molaris             Garapeira   \n",
       "1349755                  12            Cedrela odorata                 Cedro   \n",
       "1349756                  12            Cedrela odorata                 Cedro   \n",
       "1349761                  12  Enterolobium schomburgkii        Orelhademacaco   \n",
       "1349762                  12          Apuleia leiocarpa             Garapeira   \n",
       "1349766                  12          Apuleia leiocarpa             Garapeira   \n",
       "1349767                  12            Ceiba pentandra               Sumaúma   \n",
       "1349768                  12         Myroxylon balsamum               Bálsamo   \n",
       "1349771                  12    Eschweilera grandiflora          Matamatárosa   \n",
       "1349772                  12    Eschweilera grandiflora          Matamatárosa   \n",
       "1349773                  12    Eschweilera grandiflora          Matamatárosa   \n",
       "1349774                  12    Eschweilera grandiflora          Matamatárosa   \n",
       "1349775                  12          Apuleia leiocarpa             Garapeira   \n",
       "1349776                  12          Caryocar villosum            Pequiarana   \n",
       "1349777                  12            Apuleia molaris             Garapeira   \n",
       "1349778                  12  Enterolobium schomburgkii    Favaorelhademacaco   \n",
       "\n",
       "                especie_agrupada  id_especie_agrupada   volume unidade  \\\n",
       "0                      Garapeira                  117   0.5220      M3   \n",
       "1                         Tauari                   70   5.2000      M3   \n",
       "2                         Tauari                   70   1.9080      M3   \n",
       "3                         Tauari                   70   7.3140      M3   \n",
       "7              Biriba - Matamatá                    4  15.3710      M3   \n",
       "11                        Cumaru                   63  32.5190      M3   \n",
       "14             Biriba - Matamatá                    4   0.1270      M3   \n",
       "15                        Pequiá                   50   0.9040      M3   \n",
       "16                        Pequiá                   50   0.1710      M3   \n",
       "17                        Pequiá                   50   2.0000      M3   \n",
       "18             Biriba - Matamatá                    4   0.2250      M3   \n",
       "20                        Pequiá                   50  32.2700      M3   \n",
       "23                        Tauari                   70   0.0954      M3   \n",
       "24                        Pequiá                   50   0.6000      M3   \n",
       "25                          Abiu                   17   0.0500      M3   \n",
       "26                        Pequiá                   50  17.7000      M3   \n",
       "30       Espécies mistas brancas                   58  22.8003      M3   \n",
       "33                        Pequiá                   50   1.9200      M3   \n",
       "37                     Garapeira                  117   1.8750      M3   \n",
       "40                     Garapeira                  117   1.2800      M3   \n",
       "41              Angelim vermelho                  105   1.5530      M3   \n",
       "42         Fava orelha de macaco                   73   0.8130      M3   \n",
       "43                 Jitaí e jutaí                  113   1.2090      M3   \n",
       "44                        Cumaru                   63   0.2870      M3   \n",
       "45                  Mandioqueiro                   41   0.3740      M3   \n",
       "46                        Peroba                  118   0.1830      M3   \n",
       "47             Biriba - Matamatá                    4   0.2520      M3   \n",
       "48         Fava orelha de macaco                   73   0.1150      M3   \n",
       "49       Espécies mistas brancas                   58   0.9600      M3   \n",
       "83             Biriba - Matamatá                    4   2.9280      M3   \n",
       "...                          ...                  ...      ...     ...   \n",
       "1349734  Espécies mistas brancas                   58   5.6860      M3   \n",
       "1349735                   Paricá                   98   3.9820      M3   \n",
       "1349736  Espécies mistas brancas                   58   7.6710      M3   \n",
       "1349737                Garapeira                  117   5.2180      M3   \n",
       "1349738                Gameleiro                   99   6.1000      M3   \n",
       "1349739                   Jatobá                  119   0.7840      M3   \n",
       "1349740              Maçaranduba                   38   1.8270      M3   \n",
       "1349741              Maçaranduba                   38   1.3000      M3   \n",
       "1349742              Maçaranduba                   38   1.3070      M3   \n",
       "1349743              Maçaranduba                   38   1.4370      M3   \n",
       "1349744            Jitaí e jutaí                  113  17.8000      M3   \n",
       "1349745              Maçaranduba                   38  22.4320      M3   \n",
       "1349752                  Copaíba                   27   6.1100      M3   \n",
       "1349753                   Jatobá                  119   0.1560      M3   \n",
       "1349754                Garapeira                  117   0.8020      M3   \n",
       "1349755                    Cedro                  120   7.0300      M3   \n",
       "1349756                    Cedro                  120   4.3200      M3   \n",
       "1349761    Fava orelha de macaco                   73   0.2688      M3   \n",
       "1349762                Garapeira                  117   0.4410      M3   \n",
       "1349766                Garapeira                  117   1.6706      M3   \n",
       "1349767  Espécies mistas brancas                   58   2.6466      M3   \n",
       "1349768  Outras espécies nativas                  107   0.5788      M3   \n",
       "1349771        Biriba - Matamatá                    4   0.2100      M3   \n",
       "1349772        Biriba - Matamatá                    4   0.6000      M3   \n",
       "1349773        Biriba - Matamatá                    4   0.3900      M3   \n",
       "1349774        Biriba - Matamatá                    4   1.9000      M3   \n",
       "1349775                Garapeira                  117   2.8862      M3   \n",
       "1349776                   Pequiá                   50   3.3120      M3   \n",
       "1349777                Garapeira                  117   0.4500      M3   \n",
       "1349778    Fava orelha de macaco                   73   1.2722      M3   \n",
       "\n",
       "            valor  \n",
       "0           78.30  \n",
       "1           78.00  \n",
       "2         1457.65  \n",
       "3         4587.94  \n",
       "7          323.87  \n",
       "11       79938.15  \n",
       "14          19.05  \n",
       "15         135.60  \n",
       "16          25.65  \n",
       "17         300.00  \n",
       "18          33.75  \n",
       "20        1799.81  \n",
       "23          14.31  \n",
       "24          90.00  \n",
       "25           7.50  \n",
       "26        2655.00  \n",
       "30         456.06  \n",
       "33         288.00  \n",
       "37          56.25  \n",
       "40         320.00  \n",
       "41         388.25  \n",
       "42          73.17  \n",
       "43         108.81  \n",
       "44          31.57  \n",
       "45          33.66  \n",
       "46          16.47  \n",
       "47          22.68  \n",
       "48          10.35  \n",
       "49         105.60  \n",
       "83         175.68  \n",
       "...           ...  \n",
       "1349734    862.20  \n",
       "1349735    651.06  \n",
       "1349736   1150.56  \n",
       "1349737      0.00  \n",
       "1349738      0.00  \n",
       "1349739     78.40  \n",
       "1349740     69.43  \n",
       "1349741     49.40  \n",
       "1349742     36.60  \n",
       "1349743     25.87  \n",
       "1349744    498.40  \n",
       "1349745    852.42  \n",
       "1349752   1527.50  \n",
       "1349753     23.40  \n",
       "1349754    120.30  \n",
       "1349755   4218.00  \n",
       "1349756   2592.00  \n",
       "1349761     40.32  \n",
       "1349762     66.15  \n",
       "1349766    250.59  \n",
       "1349767    396.99  \n",
       "1349768     86.82  \n",
       "1349771     31.50  \n",
       "1349772     90.00  \n",
       "1349773     58.50  \n",
       "1349774    285.00  \n",
       "1349775    432.93  \n",
       "1349776    496.80  \n",
       "1349777     67.50  \n",
       "1349778    190.83  \n",
       "\n",
       "[788768 rows x 57 columns]"
      ]
     },
     "execution_count": 73,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.query(\"nome_remetente in @companies\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 75,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0.6238609606804536"
      ]
     },
     "execution_count": 75,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(data.query(\"nome_remetente in @companies\")) / len(data)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.5rc1"
  },
  "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
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}