{ "cells": [ { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [], "source": [ "import pandas as pd" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [], "source": [ "# pd.set_option('display.max_rows', None)\n", "pd.set_option('display.max_columns', None)\n", "pd.set_option('display.expand_frame_repr', False)\n", "pd.set_option('display.float_format', '{:,.2f}'.format)" ] }, { "cell_type": "code", "execution_count": 3, "metadata": {}, "outputs": [], "source": [ "productos = pd.read_csv(\"../Productos2.csv\", names=(\"product_id\", \"product_name\", \"price\", \"uses_credit\"), encoding='latin1')\n", "clientes = pd.read_csv(\"../Clientes2.csv\", names=(\"client_id\", \"client_name\", \"phonenumber\", \"credit\"))\n", "pedidos = pd.read_csv(\"../Pedidos2.csv\", names=(\"product_id\", \"client_id\", \"qty\"))\n", "\n", "clientes = clientes.set_index('client_id')\n", "productos = productos.set_index('product_id')\n", "# pedidos['date'] = pd.to_datetime(pedidos['date'], format=\"%d/%m/%Y\")" ] }, { "cell_type": "code", "execution_count": 4, "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", "
product_namepriceuses_credit
product_id
BIT-434Campana Extractora modelo Glass375.09S
SSE-115Refrigeradora CoolStyle 311N Steel3,243.58S
NMV-644Lavadora Automatica3,272.48S
MLE-193Cocina a gas Ingenious2,779.41S
YYK-309Refrigeradora Door in Door4,079.44S
\n", "
" ], "text/plain": [ " product_name price uses_credit\n", "product_id \n", "BIT-434 Campana Extractora modelo Glass 375.09 S\n", "SSE-115 Refrigeradora CoolStyle 311N Steel 3,243.58 S\n", "NMV-644 Lavadora Automatica 3,272.48 S\n", "MLE-193 Cocina a gas Ingenious 2,779.41 S\n", "YYK-309 Refrigeradora Door in Door 4,079.44 S" ] }, "execution_count": 4, "metadata": {}, "output_type": "execute_result" } ], "source": [ "productos.head()" ] }, { "cell_type": "code", "execution_count": 5, "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", "
client_namephonenumbercredit
client_id
79464412PORTUGAL RAFFO ALEXANDER390239410000
16552775YALLICO PAREDES LOURDES CARMELA96017666620000
20864087ZEGARRA CASANOVA ESTEFANIA263931110000
94326707CHANG SEGURA ANGEL98418586210000
73786035ORTIZ EPIQUEN HENRY ISRAEL687390820000
\n", "
" ], "text/plain": [ " client_name phonenumber credit\n", "client_id \n", "79464412 PORTUGAL RAFFO ALEXANDER 3902394 10000\n", "16552775 YALLICO PAREDES LOURDES CARMELA 960176666 20000\n", "20864087 ZEGARRA CASANOVA ESTEFANIA 2639311 10000\n", "94326707 CHANG SEGURA ANGEL 984185862 10000\n", "73786035 ORTIZ EPIQUEN HENRY ISRAEL 6873908 20000" ] }, "execution_count": 5, "metadata": {}, "output_type": "execute_result" } ], "source": [ "clientes.head()" ] }, { "cell_type": "code", "execution_count": 6, "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", "
product_idclient_idqty
0JXD-139503753036
1CRU-009503753035
2YYK-309227770063
3OTS-581421572195
4AWB-345132455011
\n", "
" ], "text/plain": [ " product_id client_id qty\n", "0 JXD-139 50375303 6\n", "1 CRU-009 50375303 5\n", "2 YYK-309 22777006 3\n", "3 OTS-581 42157219 5\n", "4 AWB-345 13245501 1" ] }, "execution_count": 6, "metadata": {}, "output_type": "execute_result" } ], "source": [ "pedidos.head()" ] }, { "cell_type": "code", "execution_count": 7, "metadata": {}, "outputs": [], "source": [ "# reduce stock from products as orders come\n", "\n", "pedidos['served'] = False\n", "for i, pedido in pedidos.iterrows():\n", " cid = pedido['client_id']\n", " pid = pedido['product_id']\n", " qty = pedido['qty']\n", " credit = clientes.loc[cid, 'credit']\n", " price = productos.loc[pid, 'price']\n", " uses_credit = productos.loc[pid, 'uses_credit']\n", " total_cost = qty * price\n", " if uses_credit == 'S' and credit >= total_cost:\n", " clientes.loc[cid, 'credit'] -= total_cost\n", " pedidos.loc[i, 'served'] = True\n", " " ] }, { "cell_type": "code", "execution_count": 32, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "========================================================================================================================\n", "client_id 79464412\n", "client_name PORTUGAL RAFFO ALEXANDER\n", "phonenumber 3902394\n", "credit 5,782.30\n", "Name: 0, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 NSM-283 2 1,873.62\n", "1 JXD-139 4 2,344.08\n", "========================================================================================================================\n", "client_id 16552775\n", "client_name YALLICO PAREDES LOURDES CARMELA\n", "phonenumber 960176666\n", "credit 3,716.33\n", "Name: 1, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 AWB-345 6 4,802.22\n", "1 CNN-411 5 11,481.45\n", "========================================================================================================================\n", "client_id 20864087\n", "client_name ZEGARRA CASANOVA ESTEFANIA\n", "phonenumber 2639311\n", "credit 258.47\n", "Name: 2, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 JFC-432 1 307.67\n", "1 JDQ-505 6 9,433.86\n", "========================================================================================================================\n", "client_id 94326707\n", "client_name CHANG SEGURA ANGEL\n", "phonenumber 984185862\n", "credit 10,000.00\n", "Name: 3, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", "Empty DataFrame\n", "Columns: [product_id, qty, total]\n", "Index: []\n", "========================================================================================================================\n", "client_id 73786035\n", "client_name ORTIZ EPIQUEN HENRY ISRAEL\n", "phonenumber 6873908\n", "credit 17,750.16\n", "Name: 4, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 DEN-125 4 2,249.84\n", "========================================================================================================================\n", "client_id 31193794\n", "client_name GARCIA YINO AMERICO WALDEMAR\n", "phonenumber 986742314\n", "credit 5,000.00\n", "Name: 5, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", "Empty DataFrame\n", "Columns: [product_id, qty, total]\n", "Index: []\n", "========================================================================================================================\n", "client_id 96659352\n", "client_name BRAVO VIZCARRA ROBERTO\n", "phonenumber 985707065\n", "credit 4,099.88\n", "Name: 6, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 ADX-669 4 4,957.52\n", "1 GBJ-693 3 942.60\n", "========================================================================================================================\n", "client_id 57690875\n", "client_name NORABUENA VILLEGAS ARTURO RAFAEL\n", "phonenumber 889013091\n", "credit 2,232.17\n", "Name: 7, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 CSZ-863 5 8,567.85\n", "1 CIM-038 3 7,633.92\n", "2 XTE-383 6 1,566.06\n", "========================================================================================================================\n", "client_id 69975105\n", "client_name VALDERRAMA MENDOZA LUIS ADOLFO\n", "phonenumber 977523461\n", "credit 2,717.26\n", "Name: 8, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 WZD-331 6 7,282.74\n", "========================================================================================================================\n", "client_id 54761731\n", "client_name LOYOLA IBEROS ANGEL GUSTAVO\n", "phonenumber 951334343\n", "credit 291.26\n", "Name: 9, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 DEV-433 3 8,096.22\n", "1 ZVA-180 4 11,612.52\n", "========================================================================================================================\n", "client_id 67418025\n", "client_name MOSCOSO SUELDO MARINA\n", "phonenumber 7663823\n", "credit 4,063.06\n", "Name: 10, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 QUU-384 1 2,545.54\n", "1 FEG-454 2 3,391.40\n", "========================================================================================================================\n", "client_id 77642521\n", "client_name SORIA CASTILLO LUIS GUSTAVO\n", "phonenumber 952902679\n", "credit 5,736.66\n", "Name: 11, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 QUU-384 5 12,727.70\n", "1 YYU-726 2 1,535.64\n", "========================================================================================================================\n", "client_id 35584593\n", "client_name LAM VIZCARDO MILAGROS YVONNE\n", "phonenumber 6294058\n", "credit 5,724.64\n", "Name: 12, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 SSD-176 4 2,270.84\n", "1 AVM-258 4 11,324.92\n", "2 KCO-488 1 679.60\n", "========================================================================================================================\n", "client_id 43053402\n", "client_name BENAVENTE ZIMIC MADELEINE ZKENIA\n", "phonenumber 917252545\n", "credit 2,633.12\n", "Name: 13, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 YOT-530 2 1,883.46\n", "1 VRR-793 2 483.42\n", "========================================================================================================================\n", "client_id 84165595\n", "client_name SALAMANCA GAVIDIA ALEX\n", "phonenumber 963178009\n", "credit 304.52\n", "Name: 14, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 DFJ-952 1 3,342.77\n", "1 RDT-761 6 5,429.70\n", "2 JFC-432 3 923.01\n", "========================================================================================================================\n", "client_id 89298238\n", "client_name ALFARO PRECIADO JOHNNY\n", "phonenumber 996727505\n", "credit 319.74\n", "Name: 15, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 PFD-286 2 5,552.04\n", "1 QFP-254 2 361.30\n", "2 YOT-530 4 3,766.92\n", "========================================================================================================================\n", "client_id 71984468\n", "client_name IPARRAGUIRRE VILLEGAS NICOLAS EDILBERTO\n", "phonenumber 935441620\n", "credit 7,570.49\n", "Name: 16, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 PQH-935 2 188.90\n", "1 JJN-837 5 9,899.60\n", "2 TZY-323 1 2,341.01\n", "========================================================================================================================\n", "client_id 29847168\n", "client_name ALDAVE ZEVALLOS ROSARIO\n", "phonenumber 6261108\n", "credit 5,000.00\n", "Name: 17, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", "Empty DataFrame\n", "Columns: [product_id, qty, total]\n", "Index: []\n", "========================================================================================================================\n", "client_id 79475585\n", "client_name RETTO ARCA ANNIE MAGDA\n", "phonenumber 941241092\n", "credit 4,568.30\n", "Name: 18, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 BWD-036 5 5,431.70\n", "========================================================================================================================\n", "client_id 91897732\n", "client_name GAMARRA ALCOCER VIRGINIA\n", "phonenumber 954025615\n", "credit 348.72\n", "Name: 19, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 TMN-884 2 621.30\n", "1 XZR-640 5 11,952.90\n", "2 WLL-607 1 1,525.04\n", "3 PFD-286 2 5,552.04\n", "========================================================================================================================\n", "client_id 33397650\n", "client_name RONDON EGUSQUIZA CARMELA VALENTINA\n", "phonenumber 3911397\n", "credit 2,430.88\n", "Name: 20, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 IHG-413 3 953.10\n", "1 VJI-529 6 6,616.02\n", "========================================================================================================================\n", "client_id 83236386\n", "client_name RIVERO CORRALES JUAN FERNANDO\n", "phonenumber 946513105\n", "credit 4,516.64\n", "Name: 21, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 MTF-868 2 1,943.18\n", "1 OPT-996 2 2,734.96\n", "2 OFS-384 1 805.22\n", "========================================================================================================================\n", "client_id 32821689\n", "client_name ZAVALETA EPIQUEN CARMEN ZKENIA\n", "phonenumber 955248211\n", "credit 3,181.04\n", "Name: 22, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 ONB-903 3 1,961.01\n", "1 MTF-868 5 4,857.95\n", "========================================================================================================================\n", "client_id 45783712\n", "client_name POZO CHUNG RAFAEL DEL\n", "phonenumber 8252118\n", "credit 1,219.48\n", "Name: 23, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 YUQ-590 2 3,958.14\n", "1 QFR-958 3 4,822.38\n", "========================================================================================================================\n", "client_id 48184351\n", "client_name LOPEZ JAUREGUI ROLANDO\n", "phonenumber 884716679\n", "credit 13,091.21\n", "Name: 24, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 KQA-580 2 5,815.84\n", "1 TXM-139 1 1,092.95\n", "========================================================================================================================\n", "client_id 33713901\n", "client_name VILLEGAS CASTRO SOFIA VIRGINIA\n", "phonenumber 2339560\n", "credit 7,617.22\n", "Name: 25, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 UWA-476 2 2,382.78\n", "========================================================================================================================\n", "client_id 76388967\n", "client_name GONZALES QUIO ISABEL\n", "phonenumber 8094909\n", "credit 10,000.00\n", "Name: 26, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", "Empty DataFrame\n", "Columns: [product_id, qty, total]\n", "Index: []\n", "========================================================================================================================\n", "client_id 81114108\n", "client_name ZAMBRANO SHIRAKAWA WILMER\n", "phonenumber 5853087\n", "credit 431.70\n", "Name: 27, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 VRR-793 4 966.84\n", "1 RBE-789 2 6,606.14\n", "2 DFF-034 5 1,296.25\n", "3 VCL-867 1 699.07\n", "========================================================================================================================\n", "client_id 57263719\n", "client_name PRADO TORREALBA CARMEN JANET\n", "phonenumber 988736554\n", "credit 678.90\n", "Name: 28, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 BWD-036 3 3,259.02\n", "1 OTH-462 2 1,062.08\n", "========================================================================================================================\n", "client_id 79140840\n", "client_name TORREALBA ARCA VICTORIA GLENDA\n", "phonenumber 876488179\n", "credit 4,354.41\n", "Name: 29, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 DFF-034 3 777.75\n", "1 HLR-109 1 439.47\n", "2 OTH-462 1 531.04\n", "3 TMN-884 5 1,553.25\n", "4 JXD-139 4 2,344.08\n", "========================================================================================================================\n", "client_id 71378466\n", "client_name MIYAKE CARO HENRRY EDGAR\n", "phonenumber 921051207\n", "credit 5,472.12\n", "Name: 30, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 BIT-434 4 1,500.36\n", "1 FVQ-662 2 2,121.36\n", "2 OQI-373 1 906.16\n", "========================================================================================================================\n", "client_id 17913944\n", "client_name PALOMARES SANTISTEBAN HENRRY\n", "phonenumber 967944433\n", "credit 3,166.74\n", "Name: 31, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 IHG-413 4 1,270.80\n", "1 DEN-125 1 562.46\n", "========================================================================================================================\n", "client_id 62566305\n", "client_name ROMERO ALFARO MONICA JOHANA\n", "phonenumber 8206363\n", "credit 54.77\n", "Name: 32, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 DIQ-718 4 1,563.20\n", "1 GXF-122 5 5,550.80\n", "2 AVM-258 1 2,831.23\n", "========================================================================================================================\n", "client_id 46462527\n", "client_name LOYOLA MORI NICOLAS FERNANDO\n", "phonenumber 5865695\n", "credit 2,281.60\n", "Name: 33, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 KCO-488 4 2,718.40\n", "========================================================================================================================\n", "client_id 79420973\n", "client_name AURIS JOLAY DIANA\n", "phonenumber 7073267\n", "credit 1,669.52\n", "Name: 34, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 GXF-122 3 3,330.48\n", "========================================================================================================================\n", "client_id 22777006\n", "client_name ASMAD PINTO MARIA LORENA\n", "phonenumber 939918070\n", "credit 1,135.05\n", "Name: 35, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 FCN-617 1 4,121.05\n", "1 XLF-273 2 4,743.90\n", "========================================================================================================================\n", "client_id 43877279\n", "client_name RARAZ SUCHERO ADOLFO\n", "phonenumber 4105386\n", "credit 2,729.16\n", "Name: 36, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 SSD-176 4 2,270.84\n", "========================================================================================================================\n", "client_id 73535476\n", "client_name AYALA SANCHEZ MARIA TERESA\n", "phonenumber 892714088\n", "credit 1,590.29\n", "Name: 37, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 UWA-476 5 5,956.95\n", "1 KJX-387 4 2,452.76\n", "========================================================================================================================\n", "client_id 26976877\n", "client_name TORO CUBA DIALY DIANA\n", "phonenumber 2748661\n", "credit 3,297.23\n", "Name: 38, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 VTV-269 4 3,417.92\n", "1 JXD-139 2 1,172.04\n", "2 XZG-521 3 2,112.81\n", "========================================================================================================================\n", "client_id 78078115\n", "client_name TSUKAZAN AMEZQUITA DELIA\n", "phonenumber 905818632\n", "credit 3,913.79\n", "Name: 39, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 DFF-034 2 518.50\n", "1 SSD-176 1 567.71\n", "========================================================================================================================\n", "client_id 48467976\n", "client_name BENITES SANCHEZ MARGOT DELICIA\n", "phonenumber 4888316\n", "credit 5,000.00\n", "Name: 40, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", "Empty DataFrame\n", "Columns: [product_id, qty, total]\n", "Index: []\n", "========================================================================================================================\n", "client_id 41036366\n", "client_name JUSTINO LOYOLA JENNY MAGDA\n", "phonenumber 5939760\n", "credit 5,000.00\n", "Name: 41, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", "Empty DataFrame\n", "Columns: [product_id, qty, total]\n", "Index: []\n", "========================================================================================================================\n", "client_id 31611146\n", "client_name LANDEO LARRIEGA MARTIN\n", "phonenumber 8566657\n", "credit 1,990.36\n", "Name: 42, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 YOT-530 4 3,766.92\n", "1 FVQ-662 4 4,242.72\n", "========================================================================================================================\n", "client_id 64394265\n", "client_name SALAZAR GONZALES DAVID RAFAEL\n", "phonenumber 938884629\n", "credit 973.90\n", "Name: 43, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 OFS-384 5 4,026.10\n", "========================================================================================================================\n", "client_id 50365593\n", "client_name SUAREZ BRAVO MARIELLA TATIANA\n", "phonenumber 965004473\n", "credit 1,675.15\n", "Name: 44, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 AFL-718 5 8,324.85\n", "========================================================================================================================\n", "client_id 95751208\n", "client_name CORONEL ZEGARRA FIORELLA\n", "phonenumber 925608637\n", "credit 1,684.24\n", "Name: 45, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 UOD-420 4 3,315.76\n", "========================================================================================================================\n", "client_id 79372768\n", "client_name BERROCAL YALLICO ANNIE SOFIA\n", "phonenumber 897157366\n", "credit 5,515.86\n", "Name: 46, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 GLC-370 4 2,208.96\n", "1 SAM-013 1 2,275.18\n", "========================================================================================================================\n", "client_id 27912250\n", "client_name CUBA CHUNG ISRAEL EDILBERTO\n", "phonenumber 2489481\n", "credit 3,271.63\n", "Name: 47, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 ICX-503 1 1,221.02\n", "1 LWG-915 4 4,405.88\n", "2 LWG-915 1 1,101.47\n", "========================================================================================================================\n", "client_id 60574154\n", "client_name LOZADA GONZALES JAIME\n", "phonenumber 962838234\n", "credit 4,239.12\n", "Name: 48, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 BWD-036 2 2,172.68\n", "1 III-576 6 6,465.90\n", "2 KDA-627 5 7,122.30\n", "========================================================================================================================\n", "client_id 35565959\n", "client_name VILCARA RODRIGUEZ ANNIE\n", "phonenumber 7272527\n", "credit 1,912.13\n", "Name: 49, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 BZS-261 1 3,087.87\n", "========================================================================================================================\n", "client_id 80048864\n", "client_name JUSTINO CASTILLO SANDRO CHRISTIAN\n", "phonenumber 929077160\n", "credit 475.25\n", "Name: 50, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 RDT-761 5 4,524.75\n", "========================================================================================================================\n", "client_id 96258632\n", "client_name FLORENCIO GARCIA WALTER\n", "phonenumber 993338854\n", "credit 873.98\n", "Name: 51, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 CRU-009 2 5,311.56\n", "1 QHC-492 2 3,814.46\n", "========================================================================================================================\n", "client_id 94080926\n", "client_name SORIA CRUZ MADELEINE\n", "phonenumber 6726720\n", "credit 2,513.50\n", "Name: 52, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 TXM-139 5 5,464.75\n", "1 SPR-580 5 2,021.75\n", "========================================================================================================================\n", "client_id 42157219\n", "client_name LUNA CUEVA RICHARD\n", "phonenumber 6465719\n", "credit 3,640.80\n", "Name: 53, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 KCO-488 2 1,359.20\n", "========================================================================================================================\n", "client_id 86241107\n", "client_name SANCHEZ EPIQUEN EDGAR MELVIN\n", "phonenumber 3096849\n", "credit 3,040.90\n", "Name: 54, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 CIM-038 2 5,089.28\n", "1 UXG-019 2 1,869.82\n", "========================================================================================================================\n", "client_id 26290971\n", "client_name SANTISTEBAN AYALA CAROLA MARITZA\n", "phonenumber 988835189\n", "credit 4,070.69\n", "Name: 55, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 PVZ-181 3 929.31\n", "========================================================================================================================\n", "client_id 22280452\n", "client_name GONZALES MALDONADO ZKENIA ERIKA\n", "phonenumber 5066321\n", "credit 4,271.59\n", "Name: 56, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 XSD-310 2 4,519.86\n", "1 VRR-793 5 1,208.55\n", "========================================================================================================================\n", "client_id 90365520\n", "client_name PALOMINO ADAMS SANDRO RONALD\n", "phonenumber 964902408\n", "credit 248.20\n", "Name: 57, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 KWP-672 6 9,751.80\n", "========================================================================================================================\n", "client_id 40348917\n", "client_name VEGA TSUKAZAN VALENTINA\n", "phonenumber 962692699\n", "credit 4,697.18\n", "Name: 58, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 WZD-331 3 3,641.37\n", "1 BMJ-772 1 936.32\n", "2 VRR-793 3 725.13\n", "========================================================================================================================\n", "client_id 95161027\n", "client_name FALCON POZO WALTER\n", "phonenumber 907875771\n", "credit 1,888.50\n", "Name: 59, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 VJI-529 2 2,205.34\n", "1 OQI-373 1 906.16\n", "========================================================================================================================\n", "client_id 77191257\n", "client_name CORRALES ZUNIGA JENNY\n", "phonenumber 6329003\n", "credit 3,236.20\n", "Name: 60, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 QVJ-982 5 6,763.80\n", "========================================================================================================================\n", "client_id 62324793\n", "client_name GAVIDIA MORENO ISRAEL ROLANDO\n", "phonenumber 979240911\n", "credit 2,298.13\n", "Name: 61, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 LDR-510 1 2,701.87\n", "========================================================================================================================\n", "client_id 16151792\n", "client_name DURAND CASTRO FLOR MARTHA\n", "phonenumber 8008929\n", "credit 2,669.01\n", "Name: 62, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 WZD-331 3 3,641.37\n", "1 CNQ-172 1 3,689.62\n", "========================================================================================================================\n", "client_id 66409237\n", "client_name CANO DELGADO WILLIAMS\n", "phonenumber 969142116\n", "credit 1,379.10\n", "Name: 63, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 DFF-034 4 1,037.00\n", "1 BRD-969 3 7,739.16\n", "2 UXG-019 4 3,739.64\n", "3 ICX-503 5 6,105.10\n", "========================================================================================================================\n", "client_id 63437380\n", "client_name PINTO CABELLO SILVIA FELICITA\n", "phonenumber 8343056\n", "credit 1,410.27\n", "Name: 64, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 III-576 5 5,388.25\n", "1 AWB-345 4 3,201.48\n", "========================================================================================================================\n", "client_id 95015539\n", "client_name CHANG SAONA RONALD\n", "phonenumber 974180726\n", "credit 6,572.86\n", "Name: 65, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 CSZ-863 2 3,427.14\n", "========================================================================================================================\n", "client_id 25171011\n", "client_name CRUZ JUGO SANDRO FAUSTO\n", "phonenumber 982755508\n", "credit 555.93\n", "Name: 66, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 VCL-867 3 2,097.21\n", "1 AWB-345 6 4,802.22\n", "2 CIM-038 1 2,544.64\n", "========================================================================================================================\n", "client_id 90237332\n", "client_name ESPINOZA CASTRO YDALI GIOVANA\n", "phonenumber 8119710\n", "credit 5,796.32\n", "Name: 67, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 QFP-254 3 541.95\n", "1 PVZ-181 5 1,548.85\n", "2 OQI-373 1 906.16\n", "3 TKM-141 3 1,206.72\n", "========================================================================================================================\n", "client_id 87800799\n", "client_name QUIROGA SALAZAR JOHNNY ROBERTO\n", "phonenumber 8105714\n", "credit 1,396.36\n", "Name: 68, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 KWP-672 2 3,250.60\n", "1 VRR-793 2 483.42\n", "2 WZD-331 2 2,427.58\n", "3 ICX-503 2 2,442.04\n", "========================================================================================================================\n", "client_id 38637282\n", "client_name TABORI CARBAJAL YDALI MAGDA\n", "phonenumber 914898726\n", "credit 9,194.78\n", "Name: 69, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 OFS-384 1 805.22\n", "========================================================================================================================\n", "client_id 15561764\n", "client_name VILLEGAS CASTRO ALONSO\n", "phonenumber 4983446\n", "credit 7,140.66\n", "Name: 70, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 GBJ-693 2 628.40\n", "1 JYQ-045 6 1,602.90\n", "2 RAH-420 4 628.04\n", "========================================================================================================================\n", "client_id 45877001\n", "client_name SORIA VILLA HENRRY\n", "phonenumber 876812206\n", "credit 3,904.25\n", "Name: 71, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 GBJ-693 5 1,571.00\n", "1 RDT-761 5 4,524.75\n", "========================================================================================================================\n", "client_id 87813843\n", "client_name AYALA ACUNA RONY ALEX\n", "phonenumber 967252992\n", "credit 2,314.05\n", "Name: 72, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 XSD-310 3 6,779.79\n", "1 OQI-373 1 906.16\n", "========================================================================================================================\n", "client_id 78757121\n", "client_name ASTETE SOLIS FANNY\n", "phonenumber 881829766\n", "credit 1,171.36\n", "Name: 73, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 OQI-373 3 2,718.48\n", "1 GXF-122 1 1,110.16\n", "========================================================================================================================\n", "client_id 53166028\n", "client_name CANO CHUNG EMILIO NICOLAS\n", "phonenumber 935212007\n", "credit 2,852.91\n", "Name: 74, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 QHC-492 1 1,907.23\n", "1 ONB-903 3 1,961.01\n", "2 TXM-139 3 3,278.85\n", "========================================================================================================================\n", "client_id 15210391\n", "client_name QUIROGA CASANOVA BRUNO\n", "phonenumber 912496602\n", "credit 194.17\n", "Name: 75, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 OTW-288 3 3,357.54\n", "1 HFM-021 1 726.91\n", "2 DON-719 2 721.38\n", "========================================================================================================================\n", "client_id 89429489\n", "client_name SERRANO IPARRAGUIRRE VIRGINIA\n", "phonenumber 926380835\n", "credit 2,325.13\n", "Name: 76, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 QUU-384 1 2,545.54\n", "1 UXG-019 1 934.91\n", "2 VCL-867 6 4,194.42\n", "========================================================================================================================\n", "client_id 43488351\n", "client_name MINAYA CERNA LORENA FIORELLA\n", "phonenumber 7039872\n", "credit 5,795.45\n", "Name: 77, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 XLF-273 5 11,859.75\n", "1 DIQ-718 6 2,344.80\n", "========================================================================================================================\n", "client_id 73185299\n", "client_name CORTES LANDA SURAMI\n", "phonenumber 3032891\n", "credit 2,503.63\n", "Name: 78, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 OTH-462 3 1,593.12\n", "1 QFP-254 5 903.25\n", "========================================================================================================================\n", "client_id 36380447\n", "client_name RIVERO RETTO JESUS\n", "phonenumber 963345715\n", "credit 8,016.96\n", "Name: 79, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 OWN-701 5 1,104.10\n", "1 HLR-109 2 878.94\n", "========================================================================================================================\n", "client_id 97403853\n", "client_name PISCOYA MALCA MARIA MONICA\n", "phonenumber 906047403\n", "credit 657.91\n", "Name: 80, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 YJD-279 3 3,085.29\n", "1 GBJ-693 4 1,256.80\n", "========================================================================================================================\n", "client_id 13245501\n", "client_name ESCALANTE YINO EDWARD GONZALO\n", "phonenumber 897778693\n", "credit 486.92\n", "Name: 81, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 AWB-345 1 800.37\n", "1 ZWF-661 1 2,731.61\n", "2 QIL-029 2 5,981.10\n", "========================================================================================================================\n", "client_id 89148118\n", "client_name ZAMBRANO LEYVA ALVARO\n", "phonenumber 987004291\n", "credit 921.59\n", "Name: 82, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 TKM-141 6 2,413.44\n", "1 AFL-718 1 1,664.97\n", "========================================================================================================================\n", "client_id 93845419\n", "client_name QUIO GAVIDIA DIALY FELICITA\n", "phonenumber 5696816\n", "credit 815.27\n", "Name: 83, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 AWB-345 5 4,001.85\n", "1 NSR-955 2 5,182.88\n", "========================================================================================================================\n", "client_id 19829266\n", "client_name TOMASICHE MEJIA MELVIN\n", "phonenumber 915529528\n", "credit 2,136.48\n", "Name: 84, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 TXM-139 3 3,278.85\n", "1 RDT-761 3 2,714.85\n", "2 UXG-019 2 1,869.82\n", "========================================================================================================================\n", "client_id 26233063\n", "client_name TSUKAZAN AYALA MARINA MAGDA\n", "phonenumber 937953132\n", "credit 4,835.42\n", "Name: 85, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 UWA-476 1 1,191.39\n", "1 KSO-608 3 2,742.51\n", "2 JFC-432 4 1,230.68\n", "========================================================================================================================\n", "client_id 78922174\n", "client_name ALAMO MEZA ALVARO\n", "phonenumber 5307494\n", "credit 830.60\n", "Name: 86, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 TKM-141 5 2,011.20\n", "1 EJW-346 6 2,158.20\n", "========================================================================================================================\n", "client_id 42798099\n", "client_name ZEGARRA MUNOZ SONIA GUIDA\n", "phonenumber 874064223\n", "credit 1,204.73\n", "Name: 87, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 TMN-884 5 1,553.25\n", "1 OQI-373 2 1,812.32\n", "2 RDT-761 6 5,429.70\n", "========================================================================================================================\n", "client_id 79901434\n", "client_name SALAZAR FLORENCIO SANDRO JOHNNY\n", "phonenumber 910817217\n", "credit 5,757.60\n", "Name: 88, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 AHB-459 3 2,056.50\n", "1 TXM-139 2 2,185.90\n", "========================================================================================================================\n", "client_id 50375303\n", "client_name SANCHEZ HUAYANAY DIALY LUCERO\n", "phonenumber 5956481\n", "credit 1,483.88\n", "Name: 89, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 JXD-139 6 3,516.12\n", "========================================================================================================================\n", "client_id 55552996\n", "client_name SUCHERO PRECIADO MILAGROS ERICKA\n", "phonenumber 971740977\n", "credit 1,002.79\n", "Name: 90, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 UXG-019 6 5,609.46\n", "1 SJD-818 1 3,387.75\n", "========================================================================================================================\n", "client_id 45828535\n", "client_name SEDANO MERCADO FIORELLA GLORIA\n", "phonenumber 4957431\n", "credit 960.28\n", "Name: 91, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 XSD-310 4 9,039.72\n", "========================================================================================================================\n", "client_id 44229880\n", "client_name PALOMARES BARRIOS EDWARD CESAR\n", "phonenumber 887564400\n", "credit 458.57\n", "Name: 92, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 JXD-139 4 2,344.08\n", "1 HLR-109 5 2,197.35\n", "========================================================================================================================\n", "client_id 59162728\n", "client_name HUAYANAY CORTES GLENDA MARINA\n", "phonenumber 960688828\n", "credit 3,217.20\n", "Name: 93, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 FEG-454 4 6,782.80\n", "========================================================================================================================\n", "client_id 88995291\n", "client_name PEREZ TORRES MILAGROS REBECA\n", "phonenumber 960731274\n", "credit 6,206.29\n", "Name: 94, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 MTF-868 3 2,914.77\n", "1 HLR-109 2 878.94\n", "========================================================================================================================\n", "client_id 73914283\n", "client_name CASANOVA CARBAJAL RICARDO ISRAEL\n", "phonenumber 5786088\n", "credit 7,039.44\n", "Name: 95, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 OBI-353 1 2,960.56\n", "========================================================================================================================\n", "client_id 44679500\n", "client_name CORREA ARCA HELI\n", "phonenumber 3659359\n", "credit 4,199.63\n", "Name: 96, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 AWB-345 1 800.37\n", "========================================================================================================================\n", "client_id 59407188\n", "client_name CANALES MOYA ALONSO JULIO\n", "phonenumber 957111009\n", "credit 3,003.89\n", "Name: 97, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 BIT-434 6 2,250.54\n", "1 OWN-701 1 220.82\n", "2 RDT-761 5 4,524.75\n", "========================================================================================================================\n", "client_id 27635082\n", "client_name CONTRERAS GUEVARA MARINA\n", "phonenumber 984517554\n", "credit 10,000.00\n", "Name: 98, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", "Empty DataFrame\n", "Columns: [product_id, qty, total]\n", "Index: []\n", "========================================================================================================================\n", "client_id 54716824\n", "client_name VALVERDE SEGURA MIGUEL JOSE\n", "phonenumber 968948630\n", "credit 7,925.25\n", "Name: 99, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 SPR-580 3 1,213.05\n", "1 UDR-957 1 861.70\n", "========================================================================================================================\n", "client_id 40112594\n", "client_name CARO RARAZ CHRISTIAN RONAL\n", "phonenumber 4538089\n", "credit 272.26\n", "Name: 100, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 KSO-608 6 5,485.02\n", "1 FVQ-662 4 4,242.72\n", "========================================================================================================================\n", "client_id 37110873\n", "client_name VERGEL HIJAR JESUS\n", "phonenumber 8271950\n", "credit 2,211.97\n", "Name: 101, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 SSD-176 1 567.71\n", "1 GXF-122 2 2,220.32\n", "========================================================================================================================\n", "client_id 83505958\n", "client_name CONTRERAS MEZA ERIKA BLANCA\n", "phonenumber 3913878\n", "credit 8,649.24\n", "Name: 102, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 EJW-346 3 1,079.10\n", "1 MQR-442 1 271.66\n", "========================================================================================================================\n", "client_id 85871751\n", "client_name AYALA LAURA JANET\n", "phonenumber 933420698\n", "credit 6,986.40\n", "Name: 103, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 MYC-756 2 3,013.60\n", "========================================================================================================================\n", "client_id 11602775\n", "client_name HIJAR ARCA ADOLFO\n", "phonenumber 904695641\n", "credit 4,060.24\n", "Name: 104, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 JJN-837 1 1,979.92\n", "1 JJN-837 2 3,959.84\n", "========================================================================================================================\n", "client_id 86402303\n", "client_name RUIZ RUIZ OFELIA DELIA\n", "phonenumber 972026581\n", "credit 201.58\n", "Name: 105, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 OQI-373 3 2,718.48\n", "1 OQI-373 3 2,718.48\n", "2 HFM-021 6 4,361.46\n", "========================================================================================================================\n", "client_id 23928045\n", "client_name ARCA VILCA RONALD\n", "phonenumber 5399501\n", "credit 5,164.56\n", "Name: 106, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 TMN-884 2 621.30\n", "1 TKM-141 5 2,011.20\n", "2 LWG-915 2 2,202.94\n", "========================================================================================================================\n", "client_id 12663268\n", "client_name BARRERA FLORES ENRIQUE\n", "phonenumber 891999690\n", "credit 2,561.62\n", "Name: 107, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 AHB-459 3 2,056.50\n", "1 YYU-726 4 3,071.28\n", "2 RAH-420 3 471.03\n", "3 BMJ-772 1 936.32\n", "4 QFP-254 5 903.25\n", "========================================================================================================================\n", "client_id 42928709\n", "client_name HERNANDEZ MALCA VIRGINIA\n", "phonenumber 6822015\n", "credit 315.95\n", "Name: 108, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 NSM-283 5 4,684.05\n", "========================================================================================================================\n", "client_id 85949265\n", "client_name LEYVA GONZALES CINTHIA\n", "phonenumber 947841946\n", "credit 3,602.63\n", "Name: 109, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 JFC-432 4 1,230.68\n", "1 YUQ-590 2 3,958.14\n", "2 VRR-793 5 1,208.55\n", "========================================================================================================================\n", "client_id 17972674\n", "client_name PISCOYA PORTUGAL WALDEMAR GUSTAVO\n", "phonenumber 7133680\n", "credit 1,705.88\n", "Name: 110, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 ZWF-661 1 2,731.61\n", "1 UTN-601 1 562.51\n", "========================================================================================================================\n", "client_id 38913831\n", "client_name FUENTES TSUKAZAN PATRICIA OFELIA\n", "phonenumber 950215881\n", "credit 5,037.58\n", "Name: 111, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 YZD-580 1 1,582.29\n", "1 JFC-432 3 923.01\n", "2 FLW-631 3 2,457.12\n", "========================================================================================================================\n", "client_id 36008913\n", "client_name CASTILLO ZAMORA VICTOR NESTOR\n", "phonenumber 985923364\n", "credit 5,000.00\n", "Name: 112, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", "Empty DataFrame\n", "Columns: [product_id, qty, total]\n", "Index: []\n", "========================================================================================================================\n", "client_id 49087435\n", "client_name GALLO MARTINEZ VICTOR GUILLERMO\n", "phonenumber 3714856\n", "credit 1,143.69\n", "Name: 113, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 VDD-853 2 2,191.34\n", "1 AFL-718 1 1,664.97\n", "========================================================================================================================\n", "client_id 58187172\n", "client_name SUAREZ ZIMIC MOISES\n", "phonenumber 882248669\n", "credit 3,393.52\n", "Name: 114, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 KBY-991 6 6,606.48\n", "========================================================================================================================\n", "client_id 69324480\n", "client_name FLORES IPARRAGUIRRE HENRRY RICARDO\n", "phonenumber 993711730\n", "credit 6,019.71\n", "Name: 115, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 UOD-420 3 2,486.82\n", "1 DIQ-718 1 390.80\n", "2 VJI-529 1 1,102.67\n", "========================================================================================================================\n", "client_id 32565207\n", "client_name RIVERA ZARATE MARINA\n", "phonenumber 2654996\n", "credit 1,260.36\n", "Name: 116, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 UXG-019 4 3,739.64\n", "========================================================================================================================\n", "client_id 71463316\n", "client_name PRADO CALIXTO KARIN\n", "phonenumber 998998403\n", "credit 1,943.93\n", "Name: 117, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 KCO-488 5 3,398.00\n", "1 UWA-476 3 3,574.17\n", "2 QFP-254 6 1,083.90\n", "========================================================================================================================\n", "client_id 86828079\n", "client_name PRECIADO ADAMS ERIKA DELIA\n", "phonenumber 884791387\n", "credit 9,185.02\n", "Name: 118, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 MQR-442 3 814.98\n", "========================================================================================================================\n", "client_id 29337157\n", "client_name VIZCARDO YEP GUIDA YOLANDA\n", "phonenumber 908273495\n", "credit 2,237.20\n", "Name: 119, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 HFM-021 4 2,907.64\n", "1 WZD-331 4 4,855.16\n", "========================================================================================================================\n", "client_id 32904023\n", "client_name PRADO FORZANI LOURDES\n", "phonenumber 4053489\n", "credit 2,437.83\n", "Name: 120, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 KJX-387 3 1,839.57\n", "1 QFP-254 4 722.60\n", "========================================================================================================================\n", "client_id 28390487\n", "client_name IPARRAGUIRRE PAREDES RAUL\n", "phonenumber 967488454\n", "credit 3,895.52\n", "Name: 121, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 GLC-370 2 1,104.48\n", "========================================================================================================================\n", "client_id 98589725\n", "client_name FORZANI ANTEZANO OSCAR JOSE\n", "phonenumber 894689292\n", "credit 9,758.29\n", "Name: 122, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 VRR-793 1 241.71\n", "========================================================================================================================\n", "client_id 77484838\n", "client_name EPIQUEN ALAMO NANCY\n", "phonenumber 941780448\n", "credit 355.85\n", "Name: 123, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 UWA-476 1 1,191.39\n", "1 BTO-226 4 3,452.76\n", "========================================================================================================================\n", "client_id 88956889\n", "client_name CHUMPITAZ CARBAJAL MARITZA\n", "phonenumber 935335997\n", "credit 1,369.75\n", "Name: 124, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 TMN-884 1 310.65\n", "1 YUQ-590 2 3,958.14\n", "2 HFM-021 6 4,361.46\n", "========================================================================================================================\n", "client_id 89863424\n", "client_name SANTISTEBAN BRAVO EDGARD\n", "phonenumber 990095135\n", "credit 2,046.93\n", "Name: 125, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 FVB-607 1 2,953.07\n", "========================================================================================================================\n", "client_id 99842319\n", "client_name MARTINEZ MARTINEZ CARMELA\n", "phonenumber 5042430\n", "credit 1,804.08\n", "Name: 126, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 DUG-251 2 3,195.92\n", "========================================================================================================================\n", "client_id 98140264\n", "client_name ALAMO ZEGARRA ISRAEL GUSTAVO\n", "phonenumber 990418360\n", "credit 6,901.78\n", "Name: 127, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 DFF-034 2 518.50\n", "1 BRD-969 1 2,579.72\n", "========================================================================================================================\n", "client_id 69639726\n", "client_name ROJAS PATINO GONZALO JAIR\n", "phonenumber 930532818\n", "credit 536.87\n", "Name: 128, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 OPT-996 3 4,102.44\n", "1 DON-719 1 360.69\n", "========================================================================================================================\n", "client_id 93160528\n", "client_name SANTISTEBAN MARTEL MARTIN LUIS\n", "phonenumber 945101047\n", "credit 1,036.26\n", "Name: 129, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 YYU-726 1 767.82\n", "1 DUG-251 2 3,195.92\n", "========================================================================================================================\n", "client_id 24995742\n", "client_name MEREL TAVERA WALTER\n", "phonenumber 8695140\n", "credit 113.19\n", "Name: 130, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 KCO-488 4 2,718.40\n", "1 DON-719 3 1,082.07\n", "2 BWD-036 1 1,086.34\n", "========================================================================================================================\n", "client_id 43043986\n", "client_name LOZADA VALVERDE MOISES HENRRY\n", "phonenumber 8816113\n", "credit 2,979.35\n", "Name: 131, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 QFP-254 5 903.25\n", "1 SSD-176 5 2,838.55\n", "2 TXM-139 3 3,278.85\n", "========================================================================================================================\n", "client_id 52097922\n", "client_name CUBA DURAND YVONNE\n", "phonenumber 3509438\n", "credit 616.26\n", "Name: 132, dtype: object\n", "------------------------------------------------------------------------------------------------------------------------\n", " product_id qty total\n", "0 OWN-701 2 441.64\n", "1 UTN-601 2 1,125.02\n", "2 XZG-521 4 2,817.08\n" ] } ], "source": [ "# reporte\n", "\n", "# # This creates a report with different order for clients (as they appear in pedidos) \n", "# for cid, df in pedidos.groupby('client_id', sort=False):\n", "# print('========================================================================================================================')\n", "# print(clientes.loc[[cid]])\n", "# print('------------------------------------------------------------------------------------------------------------------------')\n", "# print(df.loc[df['served'], ['product_id', 'client_id', 'qty']])\n", "\n", "for i, client in clientes.reset_index().iterrows():\n", " print('========================================================================================================================')\n", " print(client)\n", " print('------------------------------------------------------------------------------------------------------------------------')\n", " mask = (pedidos['client_id'] == client['client_id']) & (pedidos['served'])\n", " t = pedidos.loc[mask, ['product_id', 'qty']]\n", " t = t.merge(productos, how='left', on='product_id')\n", " t['total'] = t['qty'] * t['price']\n", " print(t[['product_id', 'qty', 'total']])" ] }, { "cell_type": "code", "execution_count": 33, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "10000.0" ] }, "execution_count": 33, "metadata": {}, "output_type": "execute_result" } ], "source": [ "2_979.35 + 903.25 + 2_838.55 + 3_278.85" ] }, { "cell_type": "code", "execution_count": 34, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "10864.4" ] }, "execution_count": 34, "metadata": {}, "output_type": "execute_result" } ], "source": [ "0 + 3843.75 + 903.25 + 2838.55 + 3278.85 " ] } ], "metadata": { "kernelspec": { "display_name": "Python 3 (ipykernel)", "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.11.5" } }, "nbformat": 4, "nbformat_minor": 4 }