{ "cells": [ { "attachments": {}, "cell_type": "markdown", "metadata": {}, "source": [ "### Desafio Valor Futuro" ] }, { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "1600" ] }, "execution_count": 1, "metadata": {}, "output_type": "execute_result" } ], "source": [ "def calculate(my_var):\n", " my_local_var = 20\n", " return my_var * my_local_var\n", "\n", "calculate(my_var=80)" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [], "source": [ "def calculate_future_value(present_value, time_in_months, rate):\n", " \"\"\"Calculates the future value of a present value given a rate and time in months.\"\"\"\n", " future_value = present_value * (1 + rate) ** time_in_months\n", " return future_value" ] }, { "cell_type": "code", "execution_count": 4, "metadata": {}, "outputs": [], "source": [ "assert round(calculate_future_value(present_value=500, time_in_months=11, rate=0.88/100), 2) == 550.59, \"O resultado da função não está correto.\"" ] }, { "attachments": {}, "cell_type": "markdown", "metadata": {}, "source": [ "# Collections" ] }, { "cell_type": "code", "execution_count": 5, "metadata": {}, "outputs": [], "source": [ "my_fruit_list = [\"morango\", \"maçã\", \"abacate\"]\n", "my_fruit_dict = {\"morango\": 2, \"maçã\": 3, \"abacate\": 1}\n", "my_fruit_set = {\"morango\", \"maçã\", \"abacate\", \"abacate\"}\n", "my_fruit_tuple = (\"morango\", \"maçã\", \"abacate\", \"morango\")" ] }, { "cell_type": "code", "execution_count": 6, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "morango\n", "2\n", "True\n", "morango 2\n" ] } ], "source": [ "print(my_fruit_list[0])\n", "print(my_fruit_dict[\"morango\"])\n", "print(\"morango\" in my_fruit_set)\n", "print(my_fruit_tuple[0], my_fruit_tuple.count(\"morango\"))" ] }, { "cell_type": "code", "execution_count": 7, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "['suco de morango', 'suco de maçã', 'suco de abacate']" ] }, "execution_count": 7, "metadata": {}, "output_type": "execute_result" } ], "source": [ "my_juices = [\"suco de {}\".format(fruit) for fruit in my_fruit_list]\n", "my_juices" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Desafio lista compressa" ] }, { "cell_type": "code", "execution_count": 9, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "['name 1',\n", " 'name 2',\n", " 'name 3',\n", " 'name 4',\n", " 'name 5',\n", " 'name 6',\n", " 'name 7',\n", " 'name 8',\n", " 'name 9',\n", " 'name 10',\n", " 'name 11',\n", " 'name 12',\n", " 'name 13',\n", " 'name 14',\n", " 'name 15',\n", " 'name 16',\n", " 'name 17',\n", " 'name 18',\n", " 'name 19',\n", " 'name 20',\n", " 'name 21',\n", " 'name 22',\n", " 'name 23',\n", " 'name 24',\n", " 'name 25',\n", " 'name 26',\n", " 'name 27',\n", " 'name 28',\n", " 'name 29',\n", " 'name 30',\n", " 'name 31',\n", " 'name 32',\n", " 'name 33',\n", " 'name 34',\n", " 'name 35',\n", " 'name 36',\n", " 'name 37',\n", " 'name 38',\n", " 'name 39',\n", " 'name 40',\n", " 'name 41',\n", " 'name 42',\n", " 'name 43',\n", " 'name 44',\n", " 'name 45',\n", " 'name 46',\n", " 'name 47',\n", " 'name 48',\n", " 'name 49',\n", " 'name 50',\n", " 'name 51']" ] }, "execution_count": 9, "metadata": {}, "output_type": "execute_result" } ], "source": [ "names = [\"name {}\".format(i) for i in range(1, 52)]\n", "names" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "# Python e Dados" ] }, { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [], "source": [ "import pandas as pd\n", "df = pd.read_excel(\"diversificacao_fake.xlsx\", sheet_name=\"Sheet1\", header=2)" ] }, { "cell_type": "code", "execution_count": 14, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
AssessorClienteProdutoSub ProdutoProduto em GarantiaCNPJ FundoAtivoEmissorData de VencimentoQuantidadeNET
0623742074FundosNaNSim3.499367e+12Western Asset Renda Fixa Ativo FINaNNaT0.1194261923.264482
16237451215Somente FinanceiroSaldo em ContaSimNaNSaldo em ContaNaNNaT1.0000000.000000
26237451215FundosMultimercadoSim3.224064e+13Gávea Macro Advisory FIC FIMNaNNaT95.67700443900.715287
36237461169Renda FixaCrédito PrivadoSimNaNDEB FLU U MVLV16MOVIDA LOCACAO DE VEICULOS S.A.2028-06-1517.00000024046.564453
4623742074PrevidênciaPREVIDÊNCIA RENDA FIXA PRÉ/INFLAÇÃOSim4.186635e+13Vinland Renda Fixa Ativo XP SeNaNNaT0.0000000.000000
....................................
4876237464702Renda FixaEmissão BancáriaSimNaNCDB FLU CDB421EAIFRBANCO MASTER S/A2026-11-2544.00000052614.378906
4886237463617FundosNaNSim3.468744e+13Vinland Renda Fixa Ativo Advisory LP FIC FINaNNaT5994.3188237220.781031
4896237466400Renda FixaProduto EstruturadoSimNaNCOE PB5019L31D7BANCO BNP PARIBAS BR2024-12-0535.00000035000.000000
4906237482601FundosRenda FixaSim4.527883e+13Trend DI FIC FIRF SimplesNaNNaT176.767077189.641628
4916237464702FundosMultimercadoSim2.858111e+13Vinland Macro Advisory FIC FIMNaNNaT1997.0143463144.227795
\n", "

492 rows × 11 columns

\n", "
" ], "text/plain": [ " Assessor Cliente Produto \n", "0 62374 2074 Fundos \\\n", "1 62374 51215 Somente Financeiro \n", "2 62374 51215 Fundos \n", "3 62374 61169 Renda Fixa \n", "4 62374 2074 Previdência \n", ".. ... ... ... \n", "487 62374 64702 Renda Fixa \n", "488 62374 63617 Fundos \n", "489 62374 66400 Renda Fixa \n", "490 62374 82601 Fundos \n", "491 62374 64702 Fundos \n", "\n", " Sub Produto Produto em Garantia CNPJ Fundo \n", "0 NaN Sim 3.499367e+12 \\\n", "1 Saldo em Conta Sim NaN \n", "2 Multimercado Sim 3.224064e+13 \n", "3 Crédito Privado Sim NaN \n", "4 PREVIDÊNCIA RENDA FIXA PRÉ/INFLAÇÃO Sim 4.186635e+13 \n", ".. ... ... ... \n", "487 Emissão Bancária Sim NaN \n", "488 NaN Sim 3.468744e+13 \n", "489 Produto Estruturado Sim NaN \n", "490 Renda Fixa Sim 4.527883e+13 \n", "491 Multimercado Sim 2.858111e+13 \n", "\n", " Ativo \n", "0 Western Asset Renda Fixa Ativo FI \\\n", "1 Saldo em Conta \n", "2 Gávea Macro Advisory FIC FIM \n", "3 DEB FLU U MVLV16 \n", "4 Vinland Renda Fixa Ativo XP Se \n", ".. ... \n", "487 CDB FLU CDB421EAIFR \n", "488 Vinland Renda Fixa Ativo Advisory LP FIC FI \n", "489 COE PB5019L31D7 \n", "490 Trend DI FIC FIRF Simples \n", "491 Vinland Macro Advisory FIC FIM \n", "\n", " Emissor Data de Vencimento Quantidade \n", "0 NaN NaT 0.119426 \\\n", "1 NaN NaT 1.000000 \n", "2 NaN NaT 95.677004 \n", "3 MOVIDA LOCACAO DE VEICULOS S.A. 2028-06-15 17.000000 \n", "4 NaN NaT 0.000000 \n", ".. ... ... ... \n", "487 BANCO MASTER S/A 2026-11-25 44.000000 \n", "488 NaN NaT 5994.318823 \n", "489 BANCO BNP PARIBAS BR 2024-12-05 35.000000 \n", "490 NaN NaT 176.767077 \n", "491 NaN NaT 1997.014346 \n", "\n", " NET \n", "0 1923.264482 \n", "1 0.000000 \n", "2 43900.715287 \n", "3 24046.564453 \n", "4 0.000000 \n", ".. ... \n", "487 52614.378906 \n", "488 7220.781031 \n", "489 35000.000000 \n", "490 189.641628 \n", "491 3144.227795 \n", "\n", "[492 rows x 11 columns]" ] }, "execution_count": 14, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df" ] }, { "cell_type": "code", "execution_count": 6, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "0 True\n", "1 False\n", "2 False\n", "3 False\n", "4 True\n", " ... \n", "487 False\n", "488 False\n", "489 False\n", "490 False\n", "491 False\n", "Name: Cliente, Length: 492, dtype: bool" ] }, "execution_count": 6, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df['Cliente'] == 2074" ] }, { "cell_type": "code", "execution_count": 7, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "0 1923.264482\n", "1 0.000000\n", "2 43900.715287\n", "3 24046.564453\n", "4 0.000000\n", " ... \n", "487 52614.378906\n", "488 7220.781031\n", "489 35000.000000\n", "490 189.641628\n", "491 3144.227795\n", "Name: NET, Length: 492, dtype: float64" ] }, "execution_count": 7, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df['NET']" ] }, { "cell_type": "code", "execution_count": 19, "metadata": {}, "outputs": [], "source": [ "net_by_customer = df.groupby('Cliente')['NET'].sum()" ] }, { "cell_type": "code", "execution_count": 21, "metadata": {}, "outputs": [], "source": [ "net_by_customer.to_excel(\"net_by_customer.xlsx\")" ] }, { "cell_type": "code", "execution_count": 39, "metadata": {}, "outputs": [], "source": [ "net_by_customer.to_csv(\"net_by_customer.csv\")" ] }, { "cell_type": "code", "execution_count": 12, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "\n", "RangeIndex: 492 entries, 0 to 491\n", "Data columns (total 11 columns):\n", " # Column Non-Null Count Dtype \n", "--- ------ -------------- ----- \n", " 0 Assessor 492 non-null int64 \n", " 1 Cliente 492 non-null int64 \n", " 2 Produto 492 non-null object \n", " 3 Sub Produto 430 non-null object \n", " 4 Produto em Garantia 492 non-null object \n", " 5 CNPJ Fundo 226 non-null float64 \n", " 6 Ativo 492 non-null object \n", " 7 Emissor 208 non-null object \n", " 8 Data de Vencimento 208 non-null datetime64[ns]\n", " 9 Quantidade 492 non-null float64 \n", " 10 NET 492 non-null float64 \n", "dtypes: datetime64[ns](1), float64(3), int64(2), object(5)\n", "memory usage: 42.4+ KB\n" ] } ], "source": [ "df.info()" ] }, { "cell_type": "code", "execution_count": 22, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
AssessorClienteCNPJ FundoData de VencimentoQuantidadeNET
count492.0492.0000002.260000e+02208492.000000492.000000
mean62374.057048.5813013.504180e+132028-10-24 10:57:41.53846144014883.62144841641.182232
min62374.02074.0000006.016920e+112023-04-15 00:00:000.0000000.000000
25%62374.050499.0000002.973293e+132024-12-01 06:00:0017.0000003389.298393
50%62374.061169.0000003.643679e+132026-07-21 12:00:0099.00000023091.122065
75%62374.068933.0000004.462556e+132030-11-18 00:00:007621.95640758472.205302
max62374.088665.0000004.772976e+132055-05-15 00:00:00525937.016148541734.200000
std0.022594.5315641.124974e+13NaN43591.89842559403.261251
\n", "
" ], "text/plain": [ " Assessor Cliente CNPJ Fundo Data de Vencimento \n", "count 492.0 492.000000 2.260000e+02 208 \\\n", "mean 62374.0 57048.581301 3.504180e+13 2028-10-24 10:57:41.538461440 \n", "min 62374.0 2074.000000 6.016920e+11 2023-04-15 00:00:00 \n", "25% 62374.0 50499.000000 2.973293e+13 2024-12-01 06:00:00 \n", "50% 62374.0 61169.000000 3.643679e+13 2026-07-21 12:00:00 \n", "75% 62374.0 68933.000000 4.462556e+13 2030-11-18 00:00:00 \n", "max 62374.0 88665.000000 4.772976e+13 2055-05-15 00:00:00 \n", "std 0.0 22594.531564 1.124974e+13 NaN \n", "\n", " Quantidade NET \n", "count 492.000000 492.000000 \n", "mean 14883.621448 41641.182232 \n", "min 0.000000 0.000000 \n", "25% 17.000000 3389.298393 \n", "50% 99.000000 23091.122065 \n", "75% 7621.956407 58472.205302 \n", "max 525937.016148 541734.200000 \n", "std 43591.898425 59403.261251 " ] }, "execution_count": 22, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df.describe()" ] }, { "cell_type": "code", "execution_count": 23, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "Index(['Assessor', 'Cliente', 'Produto', 'Sub Produto', 'Produto em Garantia',\n", " 'CNPJ Fundo', 'Ativo', 'Emissor', 'Data de Vencimento', 'Quantidade',\n", " 'NET'],\n", " dtype='object')" ] }, "execution_count": 23, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df.columns" ] }, { "cell_type": "code", "execution_count": 24, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "Assessor 62374\n", "Cliente 2074\n", "Produto Fundos\n", "Sub Produto NaN\n", "Produto em Garantia Sim\n", "CNPJ Fundo 3499367000190.0\n", "Ativo Western Asset Renda Fixa Ativo FI\n", "Emissor NaN\n", "Data de Vencimento NaT\n", "Quantidade 0.119426\n", "NET 1923.264482\n", "Name: 0, dtype: object" ] }, "execution_count": 24, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df.iloc[0]" ] }, { "cell_type": "code", "execution_count": 25, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
AssessorClienteProdutoSub ProdutoProduto em GarantiaCNPJ FundoAtivoEmissorData de VencimentoQuantidadeNET
39623742074FundosRenda FixaSim4.772976e+13VLGI Asset DI FIRF CPNaNNaT9754.64679210046.618491
786237469105FundosRenda FixaSim4.772976e+13VLGI Asset DI FIRF CPNaNNaT113146.899784116533.561872
1216237464702FundosRenda FixaSim4.772976e+13VLGI Asset DI FIRF CPNaNNaT11221.89172111557.780334
1226237458398FundosRenda FixaSim4.772976e+13VLGI Asset DI FIRF CPNaNNaT4198.3165584323.978680
130623744127FundosRenda FixaSim4.772976e+13VLGI Asset DI FIRF CPNaNNaT71686.77443973832.470713
1726237482601FundosRenda FixaSim4.772976e+13VLGI Asset DI FIRF CPNaNNaT1710.2212331761.410805
2026237455792FundosRenda FixaSim4.772976e+13VLGI Asset DI FIRF CPNaNNaT97117.199984100024.068312
2126237444666FundosRenda FixaSim4.772976e+13VLGI Asset DI FIRF CPNaNNaT35515.07342736578.094623
2296237463617FundosRenda FixaSim4.772976e+13VLGI Asset DI FIRF CPNaNNaT61326.50039763162.097610
2616237433652FundosRenda FixaSim4.772976e+13VLGI Asset DI FIRF CPNaNNaT12708.53418213088.920308
2786237471335FundosRenda FixaSim4.772976e+13VLGI Asset DI FIRF CPNaNNaT1629.1977041677.962117
2846237450499FundosRenda FixaSim4.772976e+13VLGI Asset DI FIRF CPNaNNaT988.7925311018.388624
3466237410208FundosRenda FixaSim4.772976e+13VLGI Asset DI FIRF CPNaNNaT1395.8903511437.671513
3646237435960FundosRenda FixaSim4.772976e+13VLGI Asset DI FIRF CPNaNNaT63609.15787265513.078562
3656237461169FundosRenda FixaSim4.772976e+13VLGI Asset DI FIRF CPNaNNaT58902.37489360665.414272
3716237467920FundosRenda FixaSim4.772976e+13VLGI Asset DI FIRF CPNaNNaT3239.3304813336.288664
3906237468933FundosRenda FixaSim4.772976e+13VLGI Asset DI FIRF CPNaNNaT56454.93310558144.716758
4506237466400FundosRenda FixaSim4.772976e+13VLGI Asset DI FIRF CPNaNNaT92123.67621094881.080631
4626237483649FundosRenda FixaSim4.772976e+13VLGI Asset DI FIRF CPNaNNaT101371.570982104405.779228
4706237488665FundosRenda FixaSim4.772976e+13VLGI Asset DI FIRF CPNaNNaT49870.85153951363.563425
4776237451215FundosRenda FixaSim4.772976e+13VLGI Asset DI FIRF CPNaNNaT525937.016148541679.126244
4836237429855FundosRenda FixaSim4.772976e+13VLGI Asset DI FIRF CPNaNNaT1086.1919731118.703383
\n", "
" ], "text/plain": [ " Assessor Cliente Produto Sub Produto Produto em Garantia CNPJ Fundo \n", "39 62374 2074 Fundos Renda Fixa Sim 4.772976e+13 \\\n", "78 62374 69105 Fundos Renda Fixa Sim 4.772976e+13 \n", "121 62374 64702 Fundos Renda Fixa Sim 4.772976e+13 \n", "122 62374 58398 Fundos Renda Fixa Sim 4.772976e+13 \n", "130 62374 4127 Fundos Renda Fixa Sim 4.772976e+13 \n", "172 62374 82601 Fundos Renda Fixa Sim 4.772976e+13 \n", "202 62374 55792 Fundos Renda Fixa Sim 4.772976e+13 \n", "212 62374 44666 Fundos Renda Fixa Sim 4.772976e+13 \n", "229 62374 63617 Fundos Renda Fixa Sim 4.772976e+13 \n", "261 62374 33652 Fundos Renda Fixa Sim 4.772976e+13 \n", "278 62374 71335 Fundos Renda Fixa Sim 4.772976e+13 \n", "284 62374 50499 Fundos Renda Fixa Sim 4.772976e+13 \n", "346 62374 10208 Fundos Renda Fixa Sim 4.772976e+13 \n", "364 62374 35960 Fundos Renda Fixa Sim 4.772976e+13 \n", "365 62374 61169 Fundos Renda Fixa Sim 4.772976e+13 \n", "371 62374 67920 Fundos Renda Fixa Sim 4.772976e+13 \n", "390 62374 68933 Fundos Renda Fixa Sim 4.772976e+13 \n", "450 62374 66400 Fundos Renda Fixa Sim 4.772976e+13 \n", "462 62374 83649 Fundos Renda Fixa Sim 4.772976e+13 \n", "470 62374 88665 Fundos Renda Fixa Sim 4.772976e+13 \n", "477 62374 51215 Fundos Renda Fixa Sim 4.772976e+13 \n", "483 62374 29855 Fundos Renda Fixa Sim 4.772976e+13 \n", "\n", " Ativo Emissor Data de Vencimento Quantidade \n", "39 VLGI Asset DI FIRF CP NaN NaT 9754.646792 \\\n", "78 VLGI Asset DI FIRF CP NaN NaT 113146.899784 \n", "121 VLGI Asset DI FIRF CP NaN NaT 11221.891721 \n", "122 VLGI Asset DI FIRF CP NaN NaT 4198.316558 \n", "130 VLGI Asset DI FIRF CP NaN NaT 71686.774439 \n", "172 VLGI Asset DI FIRF CP NaN NaT 1710.221233 \n", "202 VLGI Asset DI FIRF CP NaN NaT 97117.199984 \n", "212 VLGI Asset DI FIRF CP NaN NaT 35515.073427 \n", "229 VLGI Asset DI FIRF CP NaN NaT 61326.500397 \n", "261 VLGI Asset DI FIRF CP NaN NaT 12708.534182 \n", "278 VLGI Asset DI FIRF CP NaN NaT 1629.197704 \n", "284 VLGI Asset DI FIRF CP NaN NaT 988.792531 \n", "346 VLGI Asset DI FIRF CP NaN NaT 1395.890351 \n", "364 VLGI Asset DI FIRF CP NaN NaT 63609.157872 \n", "365 VLGI Asset DI FIRF CP NaN NaT 58902.374893 \n", "371 VLGI Asset DI FIRF CP NaN NaT 3239.330481 \n", "390 VLGI Asset DI FIRF CP NaN NaT 56454.933105 \n", "450 VLGI Asset DI FIRF CP NaN NaT 92123.676210 \n", "462 VLGI Asset DI FIRF CP NaN NaT 101371.570982 \n", "470 VLGI Asset DI FIRF CP NaN NaT 49870.851539 \n", "477 VLGI Asset DI FIRF CP NaN NaT 525937.016148 \n", "483 VLGI Asset DI FIRF CP NaN NaT 1086.191973 \n", "\n", " NET \n", "39 10046.618491 \n", "78 116533.561872 \n", "121 11557.780334 \n", "122 4323.978680 \n", "130 73832.470713 \n", "172 1761.410805 \n", "202 100024.068312 \n", "212 36578.094623 \n", "229 63162.097610 \n", "261 13088.920308 \n", "278 1677.962117 \n", "284 1018.388624 \n", "346 1437.671513 \n", "364 65513.078562 \n", "365 60665.414272 \n", "371 3336.288664 \n", "390 58144.716758 \n", "450 94881.080631 \n", "462 104405.779228 \n", "470 51363.563425 \n", "477 541679.126244 \n", "483 1118.703383 " ] }, "execution_count": 25, "metadata": {}, "output_type": "execute_result" } ], "source": [ "VLGI_FUND = \"VLGI Asset DI FIRF CP\"\n", "df[df[\"Ativo\"] == VLGI_FUND]" ] }, { "cell_type": "code", "execution_count": 28, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "\n", "RangeIndex: 492 entries, 0 to 491\n", "Data columns (total 11 columns):\n", " # Column Non-Null Count Dtype \n", "--- ------ -------------- ----- \n", " 0 Assessor 492 non-null int64 \n", " 1 Cliente 492 non-null int64 \n", " 2 Produto 492 non-null object \n", " 3 Sub Produto 430 non-null object \n", " 4 Produto em Garantia 492 non-null object \n", " 5 CNPJ Fundo 226 non-null float64 \n", " 6 Ativo 492 non-null object \n", " 7 Emissor 208 non-null object \n", " 8 Data de Vencimento 208 non-null datetime64[ns]\n", " 9 Quantidade 492 non-null float64 \n", " 10 NET 492 non-null float64 \n", "dtypes: datetime64[ns](1), float64(3), int64(2), object(5)\n", "memory usage: 42.4+ KB\n" ] } ], "source": [ "df.info()" ] }, { "cell_type": "code", "execution_count": 35, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "True" ] }, "execution_count": 35, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# lógica booleana" ] }, { "cell_type": "code", "execution_count": 38, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "0 False\n", "1 False\n", "2 False\n", "3 False\n", "4 False\n", " ... \n", "487 False\n", "488 False\n", "489 False\n", "490 False\n", "491 False\n", "Name: Data de Vencimento, Length: 492, dtype: bool" ] }, "execution_count": 38, "metadata": {}, "output_type": "execute_result" } ], "source": [ "(df['Data de Vencimento'] > '2030-01-01') & (df['Data de Vencimento'] < '2030-12-31')" ] }, { "cell_type": "code", "execution_count": 33, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
AssessorClienteProdutoSub ProdutoProduto em GarantiaCNPJ FundoAtivoEmissorData de VencimentoQuantidadeNET
576237482601Renda FixaEmissão BancáriaSimNaNCDB PRE DU CDB4220FP9GMASTER - JUROS MENSAL2030-10-0326.024509.107422
1296237464702Renda FixaCrédito PrivadoSimNaNCRA FLU CRA020003PYECO SECURITIZADORA DE DIREITOS CRED DO AGRO S/A2030-11-1851.067804.515625
3226237461169Renda FixaCrédito PrivadoSimNaNCRA FLU CRA020003PYECO SECURITIZADORA DE DIREITOS CRED DO AGRO S/A2030-11-1844.058498.015625
3486237483649Renda FixaCrédito PrivadoSimNaNCRA FLU CRA020003KBRB CAPITAL SECURITIZADORA S.A2030-11-1838.046507.316406
4546237410208Renda FixaTítulo PúblicoSimNaNNTN-B 760199TESOURO NACIONAL2030-08-1512.051605.343750
4856237464702Renda FixaTítulo PúblicoSimNaNNTN-B 760199TESOURO NACIONAL2030-08-1522.094230.046875
\n", "
" ], "text/plain": [ " Assessor Cliente Produto Sub Produto Produto em Garantia \n", "57 62374 82601 Renda Fixa Emissão Bancária Sim \\\n", "129 62374 64702 Renda Fixa Crédito Privado Sim \n", "322 62374 61169 Renda Fixa Crédito Privado Sim \n", "348 62374 83649 Renda Fixa Crédito Privado Sim \n", "454 62374 10208 Renda Fixa Título Público Sim \n", "485 62374 64702 Renda Fixa Título Público Sim \n", "\n", " CNPJ Fundo Ativo \n", "57 NaN CDB PRE DU CDB4220FP9G \\\n", "129 NaN CRA FLU CRA020003PY \n", "322 NaN CRA FLU CRA020003PY \n", "348 NaN CRA FLU CRA020003KB \n", "454 NaN NTN-B 760199 \n", "485 NaN NTN-B 760199 \n", "\n", " Emissor Data de Vencimento \n", "57 MASTER - JUROS MENSAL 2030-10-03 \\\n", "129 ECO SECURITIZADORA DE DIREITOS CRED DO AGRO S/A 2030-11-18 \n", "322 ECO SECURITIZADORA DE DIREITOS CRED DO AGRO S/A 2030-11-18 \n", "348 RB CAPITAL SECURITIZADORA S.A 2030-11-18 \n", "454 TESOURO NACIONAL 2030-08-15 \n", "485 TESOURO NACIONAL 2030-08-15 \n", "\n", " Quantidade NET \n", "57 26.0 24509.107422 \n", "129 51.0 67804.515625 \n", "322 44.0 58498.015625 \n", "348 38.0 46507.316406 \n", "454 12.0 51605.343750 \n", "485 22.0 94230.046875 " ] }, "execution_count": 33, "metadata": {}, "output_type": "execute_result" } ], "source": [ ",df[(df['Data de Vencimento'] > '2030-01-01') & (df['Data de Vencimento'] < '2030-12-31')]" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "# Quais são os clientes que investem no Fundo VLGI Asset DI FIRF CP?" ] } ], "metadata": { "kernelspec": { "display_name": ".venv", "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.10.6" }, "orig_nbformat": 4 }, "nbformat": 4, "nbformat_minor": 2 }