diff options
Diffstat (limited to '2023-2/L04/mitsuo')
| -rw-r--r-- | 2023-2/L04/mitsuo/ReporteDePedidos.txt | 1394 | ||||
| -rw-r--r-- | 2023-2/L04/mitsuo/fun.cpp | 257 | ||||
| -rw-r--r-- | 2023-2/L04/mitsuo/fun.hpp | 18 | ||||
| -rw-r--r-- | 2023-2/L04/mitsuo/main.cpp | 22 | ||||
| -rw-r--r-- | 2023-2/L04/mitsuo/simple.ipynb | 1768 |
5 files changed, 3459 insertions, 0 deletions
diff --git a/2023-2/L04/mitsuo/ReporteDePedidos.txt b/2023-2/L04/mitsuo/ReporteDePedidos.txt new file mode 100644 index 0000000..422b89b --- /dev/null +++ b/2023-2/L04/mitsuo/ReporteDePedidos.txt @@ -0,0 +1,1394 @@ +=========================================================================================================== +DNI Nombre Credito +79464412 PORTUGAL RAFFO ALEXANDER 5782.30 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +NSM-283 2 1873.62 +JXD-139 4 2344.08 +=========================================================================================================== +DNI Nombre Credito +16552775 YALLICO PAREDES LOURDES CARMELA 3716.33 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +AWB-345 6 4802.22 +CNN-411 5 11481.45 +=========================================================================================================== +DNI Nombre Credito +20864087 ZEGARRA CASANOVA ESTEFANIA 258.47 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +JFC-432 1 307.67 +JDQ-505 6 9433.86 +=========================================================================================================== +DNI Nombre Credito +94326707 CHANG SEGURA ANGEL 10000.00 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +=========================================================================================================== +DNI Nombre Credito +73786035 ORTIZ EPIQUEN HENRY ISRAEL 17750.16 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +AQS-362 1 233.05 +DEN-125 4 2249.84 +=========================================================================================================== +DNI Nombre Credito +31193794 GARCIA YINO AMERICO WALDEMAR 5000.00 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +JDC-028 1 30.48 +=========================================================================================================== +DNI Nombre Credito +96659352 BRAVO VIZCARRA ROBERTO 4099.88 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +ADX-669 4 4957.52 +GBJ-693 3 942.60 +KQQ-136 3 3418.68 +=========================================================================================================== +DNI Nombre Credito +57690875 NORABUENA VILLEGAS ARTURO RAFAEL 2232.17 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +CSZ-863 5 8567.85 +CIM-038 3 7633.92 +XTE-383 6 1566.06 +=========================================================================================================== +DNI Nombre Credito +69975105 VALDERRAMA MENDOZA LUIS ADOLFO 2717.26 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +WZD-331 6 7282.74 +=========================================================================================================== +DNI Nombre Credito +54761731 LOYOLA IBEROS ANGEL GUSTAVO 291.26 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +DEV-433 3 8096.22 +ZVA-180 4 11612.52 +OTS-581 5 13265.50 +=========================================================================================================== +DNI Nombre Credito +67418025 MOSCOSO SUELDO MARINA 4063.06 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +QUU-384 1 2545.54 +FEG-454 2 3391.40 +=========================================================================================================== +DNI Nombre Credito +77642521 SORIA CASTILLO LUIS GUSTAVO 5736.66 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +QUU-384 5 12727.70 +YYU-726 2 1535.64 +=========================================================================================================== +DNI Nombre Credito +35584593 LAM VIZCARDO MILAGROS YVONNE 5724.64 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +SSD-176 4 2270.84 +AVM-258 4 11324.92 +KCO-488 1 679.60 +=========================================================================================================== +DNI Nombre Credito +43053402 BENAVENTE ZIMIC MADELEINE ZKENIA 2633.12 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +YOT-530 2 1883.46 +VRR-793 2 483.42 +=========================================================================================================== +DNI Nombre Credito +84165595 SALAMANCA GAVIDIA ALEX 304.52 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +DFJ-952 1 3342.77 +RDT-761 6 5429.70 +JFC-432 3 923.01 +=========================================================================================================== +DNI Nombre Credito +89298238 ALFARO PRECIADO JOHNNY 319.74 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +PFD-286 2 5552.04 +QFP-254 2 361.30 +YOT-530 4 3766.92 +=========================================================================================================== +DNI Nombre Credito +71984468 IPARRAGUIRRE VILLEGAS NICOLAS EDILBERTO 7570.49 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +PQH-935 2 188.90 +JJN-837 5 9899.60 +TZY-323 1 2341.01 +=========================================================================================================== +DNI Nombre Credito +29847168 ALDAVE ZEVALLOS ROSARIO 5000.00 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +BCK-361 1 1872.53 +=========================================================================================================== +DNI Nombre Credito +79475585 RETTO ARCA ANNIE MAGDA 4568.30 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +BWD-036 5 5431.70 +KQQ-136 6 6837.36 +=========================================================================================================== +DNI Nombre Credito +91897732 GAMARRA ALCOCER VIRGINIA 0.00 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +TMN-884 2 621.30 +XZR-640 5 11952.90 +WLL-607 1 1525.04 +PFD-286 2 5552.04 +=========================================================================================================== +DNI Nombre Credito +33397650 RONDON EGUSQUIZA CARMELA VALENTINA 2430.88 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +IHG-413 3 953.10 +VJI-529 6 6616.02 +=========================================================================================================== +DNI Nombre Credito +83236386 RIVERO CORRALES JUAN FERNANDO 4516.64 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +MTF-868 2 1943.18 +OPT-996 2 2734.96 +OFS-384 1 805.22 +=========================================================================================================== +DNI Nombre Credito +32821689 ZAVALETA EPIQUEN CARMEN ZKENIA 3181.04 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +ONB-903 3 1961.01 +MTF-868 5 4857.95 +ISU-815 1 619.89 +=========================================================================================================== +DNI Nombre Credito +45783712 POZO CHUNG RAFAEL DEL 1219.48 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +YUQ-590 2 3958.14 +QFR-958 3 4822.38 +=========================================================================================================== +DNI Nombre Credito +48184351 LOPEZ JAUREGUI ROLANDO 13091.21 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +KQA-580 2 5815.84 +TXM-139 1 1092.95 +=========================================================================================================== +DNI Nombre Credito +33713901 VILLEGAS CASTRO SOFIA VIRGINIA 7617.22 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +UWA-476 2 2382.78 +VVS-017 1 2599.72 +=========================================================================================================== +DNI Nombre Credito +76388967 GONZALES QUIO ISABEL 10000.00 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +SJQ-827 5 8597.80 +DOV-560 2 2406.28 +=========================================================================================================== +DNI Nombre Credito +81114108 ZAMBRANO SHIRAKAWA WILMER 0.00 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +VRR-793 4 966.84 +RBE-789 2 6606.14 +DFF-034 5 1296.25 +VCL-867 1 699.07 +=========================================================================================================== +DNI Nombre Credito +57263719 PRADO TORREALBA CARMEN JANET 678.90 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +BWD-036 3 3259.02 +OTH-462 2 1062.08 +DOV-560 4 4812.56 +=========================================================================================================== +DNI Nombre Credito +79140840 TORREALBA ARCA VICTORIA GLENDA 0.00 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +DFF-034 3 777.75 +TYF-885 2 1588.28 +HLR-109 1 439.47 +OTH-462 1 531.04 +=========================================================================================================== +DNI Nombre Credito +71378466 MIYAKE CARO HENRRY EDGAR 0.00 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +BIT-434 4 1500.36 +FVQ-662 2 2121.36 +ARS-231 6 1965.72 +OQI-373 1 906.16 +=========================================================================================================== +DNI Nombre Credito +17913944 PALOMARES SANTISTEBAN HENRRY 3166.74 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +IHG-413 4 1270.80 +DEN-125 1 562.46 +=========================================================================================================== +DNI Nombre Credito +62566305 ROMERO ALFARO MONICA JOHANA 0.00 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +TYF-885 4 3176.56 +DIQ-718 4 1563.20 +GXF-122 5 5550.80 +AVM-258 1 2831.23 +=========================================================================================================== +DNI Nombre Credito +46462527 LOYOLA MORI NICOLAS FERNANDO 2281.60 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +KCO-488 4 2718.40 +ISU-815 6 3719.34 +=========================================================================================================== +DNI Nombre Credito +79420973 AURIS JOLAY DIANA 1669.52 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +GXF-122 3 3330.48 +=========================================================================================================== +DNI Nombre Credito +22777006 ASMAD PINTO MARIA LORENA 1135.05 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +FCN-617 1 4121.05 +XLF-273 2 4743.90 +=========================================================================================================== +DNI Nombre Credito +43877279 RARAZ SUCHERO ADOLFO 2729.16 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +TYF-885 5 3970.70 +SSD-176 4 2270.84 +=========================================================================================================== +DNI Nombre Credito +73535476 AYALA SANCHEZ MARIA TERESA 1590.29 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +UWA-476 5 5956.95 +KJX-387 4 2452.76 +=========================================================================================================== +DNI Nombre Credito +26976877 TORO CUBA DIALY DIANA 0.00 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +VTV-269 4 3417.92 +JXD-139 2 1172.04 +KQQ-136 3 3418.68 +XZG-521 3 2112.81 +=========================================================================================================== +DNI Nombre Credito +78078115 TSUKAZAN AMEZQUITA DELIA 3913.79 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +DFF-034 2 518.50 +SSD-176 1 567.71 +PJG-338 2 2135.60 +=========================================================================================================== +DNI Nombre Credito +48467976 BENITES SANCHEZ MARGOT DELICIA 5000.00 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +=========================================================================================================== +DNI Nombre Credito +41036366 JUSTINO LOYOLA JENNY MAGDA 5000.00 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +AQS-362 2 466.10 +=========================================================================================================== +DNI Nombre Credito +31611146 LANDEO LARRIEGA MARTIN 1990.36 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +YOT-530 4 3766.92 +FVQ-662 4 4242.72 +=========================================================================================================== +DNI Nombre Credito +64394265 SALAZAR GONZALES DAVID RAFAEL 973.90 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +OFS-384 5 4026.10 +=========================================================================================================== +DNI Nombre Credito +50365593 SUAREZ BRAVO MARIELLA TATIANA 1675.15 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +AFL-718 5 8324.85 +JDC-028 6 182.88 +VVS-017 3 7799.16 +=========================================================================================================== +DNI Nombre Credito +95751208 CORONEL ZEGARRA FIORELLA 1684.24 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +UOD-420 4 3315.76 +=========================================================================================================== +DNI Nombre Credito +79372768 BERROCAL YALLICO ANNIE SOFIA 5515.86 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +GLC-370 4 2208.96 +SAM-013 1 2275.18 +EUZ-452 5 18119.40 +=========================================================================================================== +DNI Nombre Credito +27912250 CUBA CHUNG ISRAEL EDILBERTO 3271.63 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +ICX-503 1 1221.02 +LWG-915 4 4405.88 +LWG-915 1 1101.47 +=========================================================================================================== +DNI Nombre Credito +60574154 LOZADA GONZALES JAIME 4239.12 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +BWD-036 2 2172.68 +III-576 6 6465.90 +KDA-627 5 7122.30 +=========================================================================================================== +DNI Nombre Credito +35565959 VILCARA RODRIGUEZ ANNIE 1912.13 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +BZS-261 1 3087.87 +=========================================================================================================== +DNI Nombre Credito +80048864 JUSTINO CASTILLO SANDRO CHRISTIAN 475.25 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +BCK-361 3 5617.59 +RDT-761 5 4524.75 +=========================================================================================================== +DNI Nombre Credito +96258632 FLORENCIO GARCIA WALTER 873.98 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +CRU-009 2 5311.56 +QHC-492 2 3814.46 +=========================================================================================================== +DNI Nombre Credito +94080926 SORIA CRUZ MADELEINE 2513.50 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +TXM-139 5 5464.75 +SPR-580 5 2021.75 +=========================================================================================================== +DNI Nombre Credito +42157219 LUNA CUEVA RICHARD 3640.80 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +OTS-581 5 13265.50 +KCO-488 2 1359.20 +=========================================================================================================== +DNI Nombre Credito +86241107 SANCHEZ EPIQUEN EDGAR MELVIN 3040.90 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +CIM-038 2 5089.28 +UXG-019 2 1869.82 +=========================================================================================================== +DNI Nombre Credito +26290971 SANTISTEBAN AYALA CAROLA MARITZA 4070.69 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +PVZ-181 3 929.31 +TYF-885 3 2382.42 +=========================================================================================================== +DNI Nombre Credito +22280452 GONZALES MALDONADO ZKENIA ERIKA 4271.59 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +XSD-310 2 4519.86 +VRR-793 5 1208.55 +UCX-285 3 9872.79 +=========================================================================================================== +DNI Nombre Credito +90365520 PALOMINO ADAMS SANDRO RONALD 248.20 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +KWP-672 6 9751.80 +EUZ-452 6 21743.28 +=========================================================================================================== +DNI Nombre Credito +40348917 VEGA TSUKAZAN VALENTINA 4697.18 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +WZD-331 3 3641.37 +BMJ-772 1 936.32 +VRR-793 3 725.13 +=========================================================================================================== +DNI Nombre Credito +95161027 FALCON POZO WALTER 1888.50 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +VJI-529 2 2205.34 +VVS-017 5 12998.60 +OQI-373 1 906.16 +=========================================================================================================== +DNI Nombre Credito +77191257 CORRALES ZUNIGA JENNY 3236.20 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +QVJ-982 5 6763.80 +ZEX-027 6 23062.50 +=========================================================================================================== +DNI Nombre Credito +62324793 GAVIDIA MORENO ISRAEL ROLANDO 2298.13 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +LDR-510 1 2701.87 +=========================================================================================================== +DNI Nombre Credito +16151792 DURAND CASTRO FLOR MARTHA 0.00 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +WZD-331 3 3641.37 +CNQ-172 1 3689.62 +AQS-362 1 233.05 +IDO-503 6 23611.02 +AQS-362 1 233.05 +=========================================================================================================== +DNI Nombre Credito +66409237 CANO DELGADO WILLIAMS 0.00 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +DFF-034 4 1037.00 +AWT-354 6 20455.32 +BRD-969 3 7739.16 +UXG-019 4 3739.64 +=========================================================================================================== +DNI Nombre Credito +63437380 PINTO CABELLO SILVIA FELICITA 1410.27 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +PJG-338 2 2135.60 +III-576 5 5388.25 +AWB-345 4 3201.48 +=========================================================================================================== +DNI Nombre Credito +95015539 CHANG SAONA RONALD 6572.86 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +CSZ-863 2 3427.14 +=========================================================================================================== +DNI Nombre Credito +25171011 CRUZ JUGO SANDRO FAUSTO 555.93 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +VCL-867 3 2097.21 +AWB-345 6 4802.22 +CIM-038 1 2544.64 +=========================================================================================================== +DNI Nombre Credito +90237332 ESPINOZA CASTRO YDALI GIOVANA 0.00 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +QFP-254 3 541.95 +PVZ-181 5 1548.85 +OQI-373 1 906.16 +TKM-141 3 1206.72 +=========================================================================================================== +DNI Nombre Credito +87800799 QUIROGA SALAZAR JOHNNY ROBERTO 0.00 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +KWP-672 2 3250.60 +VRR-793 2 483.42 +WZD-331 2 2427.58 +ICX-503 2 2442.04 +EUZ-452 2 7247.76 +JDC-028 5 152.40 +=========================================================================================================== +DNI Nombre Credito +38637282 TABORI CARBAJAL YDALI MAGDA 9194.78 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +OFS-384 1 805.22 +=========================================================================================================== +DNI Nombre Credito +15561764 VILLEGAS CASTRO ALONSO 0.00 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +GBJ-693 2 628.40 +JYQ-045 6 1602.90 +FYF-898 2 2320.92 +RAH-420 4 628.04 +=========================================================================================================== +DNI Nombre Credito +45877001 SORIA VILLA HENRRY 0.00 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +VVS-017 4 10398.88 +PJG-338 2 2135.60 +GBJ-693 5 1571.00 +RDT-761 5 4524.75 +=========================================================================================================== +DNI Nombre Credito +87813843 AYALA ACUNA RONY ALEX 2314.05 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +XSD-310 3 6779.79 +OQI-373 1 906.16 +=========================================================================================================== +DNI Nombre Credito +78757121 ASTETE SOLIS FANNY 1171.36 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +OQI-373 3 2718.48 +GXF-122 1 1110.16 +ARS-231 4 1310.48 +=========================================================================================================== +DNI Nombre Credito +53166028 CANO CHUNG EMILIO NICOLAS 2852.91 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +QHC-492 1 1907.23 +ONB-903 3 1961.01 +TXM-139 3 3278.85 +=========================================================================================================== +DNI Nombre Credito +15210391 QUIROGA CASANOVA BRUNO 0.00 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +OTW-288 3 3357.54 +VXS-438 4 240.44 +HFM-021 1 726.91 +DON-719 2 721.38 +AQS-362 2 466.10 +=========================================================================================================== +DNI Nombre Credito +89429489 SERRANO IPARRAGUIRRE VIRGINIA 0.00 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +VXS-438 1 60.11 +QUU-384 1 2545.54 +UXG-019 1 934.91 +VCL-867 6 4194.42 +=========================================================================================================== +DNI Nombre Credito +43488351 MINAYA CERNA LORENA FIORELLA 5795.45 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +XLF-273 5 11859.75 +DIQ-718 6 2344.80 +=========================================================================================================== +DNI Nombre Credito +73185299 CORTES LANDA SURAMI 2503.63 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +OTH-462 3 1593.12 +QFP-254 5 903.25 +=========================================================================================================== +DNI Nombre Credito +36380447 RIVERO RETTO JESUS 8016.96 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +OWN-701 5 1104.10 +HLR-109 2 878.94 +=========================================================================================================== +DNI Nombre Credito +97403853 PISCOYA MALCA MARIA MONICA 0.00 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +KQQ-136 6 6837.36 +BCK-361 5 9362.65 +YJD-279 3 3085.29 +GBJ-693 4 1256.80 +=========================================================================================================== +DNI Nombre Credito +13245501 ESCALANTE YINO EDWARD GONZALO 0.00 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +AWB-345 1 800.37 +VXS-438 3 180.33 +ZWF-661 1 2731.61 +QIL-029 2 5981.10 +=========================================================================================================== +DNI Nombre Credito +89148118 ZAMBRANO LEYVA ALVARO 921.59 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +TKM-141 6 2413.44 +AFL-718 1 1664.97 +=========================================================================================================== +DNI Nombre Credito +93845419 QUIO GAVIDIA DIALY FELICITA 815.27 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +AWB-345 5 4001.85 +NSR-955 2 5182.88 +=========================================================================================================== +DNI Nombre Credito +19829266 TOMASICHE MEJIA MELVIN 2136.48 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +TXM-139 3 3278.85 +RDT-761 3 2714.85 +UXG-019 2 1869.82 +=========================================================================================================== +DNI Nombre Credito +26233063 TSUKAZAN AYALA MARINA MAGDA 0.00 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +ZAF-449 2 1632.86 +UWA-476 1 1191.39 +KSO-608 3 2742.51 +JFC-432 4 1230.68 +=========================================================================================================== +DNI Nombre Credito +78922174 ALAMO MEZA ALVARO 830.60 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +TKM-141 5 2011.20 +EJW-346 6 2158.20 +=========================================================================================================== +DNI Nombre Credito +42798099 ZEGARRA MUNOZ SONIA GUIDA 0.00 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +AQS-362 1 233.05 +TMN-884 5 1553.25 +OQI-373 2 1812.32 +RDT-761 6 5429.70 +=========================================================================================================== +DNI Nombre Credito +79901434 SALAZAR FLORENCIO SANDRO JOHNNY 5757.60 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +ZEX-027 2 7687.50 +AHB-459 3 2056.50 +TXM-139 2 2185.90 +=========================================================================================================== +DNI Nombre Credito +50375303 SANCHEZ HUAYANAY DIALY LUCERO 1483.88 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +JXD-139 6 3516.12 +SJQ-827 2 3439.12 +VXS-438 4 240.44 +=========================================================================================================== +DNI Nombre Credito +55552996 SUCHERO PRECIADO MILAGROS ERICKA 1002.79 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +AQS-362 1 233.05 +UXG-019 6 5609.46 +SJD-818 1 3387.75 +=========================================================================================================== +DNI Nombre Credito +45828535 SEDANO MERCADO FIORELLA GLORIA 960.28 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +XSD-310 4 9039.72 +=========================================================================================================== +DNI Nombre Credito +44229880 PALOMARES BARRIOS EDWARD CESAR 458.57 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +JXD-139 4 2344.08 +HLR-109 5 2197.35 +=========================================================================================================== +DNI Nombre Credito +59162728 HUAYANAY CORTES GLENDA MARINA 3217.20 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +FEG-454 4 6782.80 +=========================================================================================================== +DNI Nombre Credito +88995291 PEREZ TORRES MILAGROS REBECA 6206.29 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +MTF-868 3 2914.77 +HLR-109 2 878.94 +=========================================================================================================== +DNI Nombre Credito +73914283 CASANOVA CARBAJAL RICARDO ISRAEL 7039.44 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +OBI-353 1 2960.56 +=========================================================================================================== +DNI Nombre Credito +44679500 CORREA ARCA HELI 4199.63 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +AWB-345 1 800.37 +=========================================================================================================== +DNI Nombre Credito +59407188 CANALES MOYA ALONSO JULIO 0.00 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +BIT-434 6 2250.54 +OWN-701 1 220.82 +RDT-761 5 4524.75 +LYZ-614 3 10532.52 +=========================================================================================================== +DNI Nombre Credito +27635082 CONTRERAS GUEVARA MARINA 10000.00 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +=========================================================================================================== +DNI Nombre Credito +54716824 VALVERDE SEGURA MIGUEL JOSE 7925.25 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +SPR-580 3 1213.05 +UDR-957 1 861.70 +ZEX-027 6 23062.50 +=========================================================================================================== +DNI Nombre Credito +40112594 CARO RARAZ CHRISTIAN RONAL 272.26 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +KSO-608 6 5485.02 +BCK-361 2 3745.06 +FVQ-662 4 4242.72 +=========================================================================================================== +DNI Nombre Credito +37110873 VERGEL HIJAR JESUS 2211.97 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +SSD-176 1 567.71 +GXF-122 2 2220.32 +=========================================================================================================== +DNI Nombre Credito +83505958 CONTRERAS MEZA ERIKA BLANCA 8649.24 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +TYF-885 5 3970.70 +EJW-346 3 1079.10 +MQR-442 1 271.66 +=========================================================================================================== +DNI Nombre Credito +85871751 AYALA LAURA JANET 6986.40 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +MYC-756 2 3013.60 +=========================================================================================================== +DNI Nombre Credito +11602775 HIJAR ARCA ADOLFO 4060.24 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +JJN-837 1 1979.92 +JJN-837 2 3959.84 +=========================================================================================================== +DNI Nombre Credito +86402303 RUIZ RUIZ OFELIA DELIA 201.58 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +OQI-373 3 2718.48 +OQI-373 3 2718.48 +HFM-021 6 4361.46 +=========================================================================================================== +DNI Nombre Credito +23928045 ARCA VILCA RONALD 5164.56 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +TMN-884 2 621.30 +TKM-141 5 2011.20 +LWG-915 2 2202.94 +=========================================================================================================== +DNI Nombre Credito +12663268 BARRERA FLORES ENRIQUE 0.00 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +AHB-459 3 2056.50 +YYU-726 4 3071.28 +RAH-420 3 471.03 +BMJ-772 1 936.32 +=========================================================================================================== +DNI Nombre Credito +42928709 HERNANDEZ MALCA VIRGINIA 315.95 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +NSM-283 5 4684.05 +=========================================================================================================== +DNI Nombre Credito +85949265 LEYVA GONZALES CINTHIA 3602.63 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +JFC-432 4 1230.68 +YUQ-590 2 3958.14 +VRR-793 5 1208.55 +=========================================================================================================== +DNI Nombre Credito +17972674 PISCOYA PORTUGAL WALDEMAR GUSTAVO 1705.88 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +ZWF-661 1 2731.61 +UTN-601 1 562.51 +=========================================================================================================== +DNI Nombre Credito +38913831 FUENTES TSUKAZAN PATRICIA OFELIA 5037.58 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +YZD-580 1 1582.29 +JFC-432 3 923.01 +FLW-631 3 2457.12 +=========================================================================================================== +DNI Nombre Credito +36008913 CASTILLO ZAMORA VICTOR NESTOR 5000.00 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +=========================================================================================================== +DNI Nombre Credito +49087435 GALLO MARTINEZ VICTOR GUILLERMO 0.00 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +VDD-853 2 2191.34 +BCK-361 3 5617.59 +SJQ-827 1 1719.56 +PJG-338 1 1067.80 +=========================================================================================================== +DNI Nombre Credito +58187172 SUAREZ ZIMIC MOISES 3393.52 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +KBY-991 6 6606.48 +VXS-438 2 120.22 +=========================================================================================================== +DNI Nombre Credito +69324480 FLORES IPARRAGUIRRE HENRRY RICARDO 0.00 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +UOD-420 3 2486.82 +VXS-438 3 180.33 +DIQ-718 1 390.80 +VJI-529 1 1102.67 +=========================================================================================================== +DNI Nombre Credito +32565207 RIVERA ZARATE MARINA 1260.36 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +IDO-503 6 23611.02 +UXG-019 4 3739.64 +=========================================================================================================== +DNI Nombre Credito +71463316 PRADO CALIXTO KARIN 0.00 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +AWT-354 4 13636.88 +KCO-488 5 3398.00 +UWA-476 3 3574.17 +QFP-254 6 1083.90 +=========================================================================================================== +DNI Nombre Credito +86828079 PRECIADO ADAMS ERIKA DELIA 9185.02 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +MQR-442 3 814.98 +YGV-332 1 2517.66 +=========================================================================================================== +DNI Nombre Credito +29337157 VIZCARDO YEP GUIDA YOLANDA 2237.20 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +ZEX-027 3 11531.25 +HFM-021 4 2907.64 +WZD-331 4 4855.16 +=========================================================================================================== +DNI Nombre Credito +32904023 PRADO FORZANI LOURDES 2437.83 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +KJX-387 3 1839.57 +QFP-254 4 722.60 +KQQ-136 1 1139.56 +=========================================================================================================== +DNI Nombre Credito +28390487 IPARRAGUIRRE PAREDES RAUL 3895.52 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +GLC-370 2 1104.48 +=========================================================================================================== +DNI Nombre Credito +98589725 FORZANI ANTEZANO OSCAR JOSE 9758.29 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +VRR-793 1 241.71 +=========================================================================================================== +DNI Nombre Credito +77484838 EPIQUEN ALAMO NANCY 355.85 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +UWA-476 1 1191.39 +BTO-226 4 3452.76 +YGV-332 3 7552.98 +=========================================================================================================== +DNI Nombre Credito +88956889 CHUMPITAZ CARBAJAL MARITZA 1369.75 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +TMN-884 1 310.65 +YUQ-590 2 3958.14 +HFM-021 6 4361.46 +=========================================================================================================== +DNI Nombre Credito +89863424 SANTISTEBAN BRAVO EDGARD 2046.93 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +FVB-607 1 2953.07 +=========================================================================================================== +DNI Nombre Credito +99842319 MARTINEZ MARTINEZ CARMELA 1804.08 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +DUG-251 2 3195.92 +ZAF-449 1 816.43 +=========================================================================================================== +DNI Nombre Credito +98140264 ALAMO ZEGARRA ISRAEL GUSTAVO 6901.78 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +DFF-034 2 518.50 +BRD-969 1 2579.72 +=========================================================================================================== +DNI Nombre Credito +69639726 ROJAS PATINO GONZALO JAIR 536.87 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +OPT-996 3 4102.44 +DON-719 1 360.69 +=========================================================================================================== +DNI Nombre Credito +93160528 SANTISTEBAN MARTEL MARTIN LUIS 1036.26 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +YYU-726 1 767.82 +DUG-251 2 3195.92 +=========================================================================================================== +DNI Nombre Credito +24995742 MEREL TAVERA WALTER 113.19 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +KCO-488 4 2718.40 +DON-719 3 1082.07 +BWD-036 1 1086.34 +=========================================================================================================== +DNI Nombre Credito +43043986 LOZADA VALVERDE MOISES HENRRY 0.00 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +ZEX-027 1 3843.75 +QFP-254 5 903.25 +SSD-176 5 2838.55 +TXM-139 3 3278.85 +=========================================================================================================== +DNI Nombre Credito +52097922 CUBA DURAND YVONNE 0.00 +----------------------------------------------------------------------------------------------------------- +Pedidos atendidos: +----------------------------------------------------------------------------------------------------------- +Codigo Cantidad Total +----------------------------------------------------------------------------------------------------------- +ISU-815 5 3099.45 +OWN-701 2 441.64 +UTN-601 2 1125.02 +XZG-521 4 2817.08 diff --git a/2023-2/L04/mitsuo/fun.cpp b/2023-2/L04/mitsuo/fun.cpp new file mode 100644 index 0000000..6e7ff38 --- /dev/null +++ b/2023-2/L04/mitsuo/fun.cpp @@ -0,0 +1,257 @@ +#include <iostream> +#include <fstream> +#include <iomanip> +#include <cstring> +#include <algorithm> +#include "fun.hpp" + +using namespace std; + +void cargaproductos(void *& productos) { + ifstream in("../Productos2.csv"); + if (!in) { + cerr << "Error: no se puedo abrir archivo\n"; + } + char code[MAXLEN]; + char desc[MAXLEN]; + double price; + char uses_credit; // S|N (yes or no) + + // "metodo exacto" + void * productos_tmp[MAX]; + + int i; + for (i = 0; true; i++) { + in.getline(code, MAXLEN, ','); + in.getline(desc, MAXLEN, ','); + in >> price; in.get(); + in >> uses_credit; in.get(); + if (!in) { + break; + } + void ** producto = new void * [4]; + // 0: code, 1: desc, 2: price, 3: uses_credit + producto[0] = new char [strlen(code) + 1]; strcpy((char *) producto[0], code); + producto[1] = new char [strlen(desc) + 1]; strcpy((char *) producto[1], desc); + producto[2] = new double {price}; + producto[3] = new char {uses_credit}; + productos_tmp[i] = producto; + } + productos_tmp[i++] = NULL; + int n = i; + productos = new void * [n]; + for (i = 0; i < n; i++) { + ((void **) productos)[i] = productos_tmp[i]; + } +} + +void imprimeproductos(void * productos) { + cout << "PRODUCTOS: \n"; + void ** ps = (void **) productos; + for (int i = 0; ps[i]; i++) { + void ** p = (void **) ps[i]; + cout << left; + cout << setw(12) << (char *) p[0]; + cout << setw(64) << (char *) p[1]; + cout << right << fixed << setprecision(2); + cout << setw(8) << * (double *) p[2]; + cout << setw(8) << * (char *) p[3]; + cout << '\n'; + } +} + +void cargaclientes(void *& clientes) { + ifstream in("../Clientes2.csv"); + if (!in) { + cerr << "Error: no se puedo abrir archivo\n"; + } + int dni; + char name[MAXLEN]; + char phonenumber[MAXLEN]; // not used + void * pedidos = NULL; + double credit; + + // "metodo exacto" + void * clientes_tmp[MAX]; + + int i; + for (i = 0; true; i++) { + in >> dni; in.get(); + in.getline(name, MAXLEN, ','); + in.getline(phonenumber, MAXLEN, ','); + in >> credit; in.get(); + if (!in) { + break; + } + void ** cliente = new void * [4]; + // 0: dni, 1: name, 2: pedidos, 3: credit + cliente[0] = new int {dni}; + cliente[1] = new char [strlen(name) + 1]; strcpy((char *) cliente[1], name); + cliente[2] = new void * {NULL}; + cliente[3] = new double {credit}; + clientes_tmp[i] = cliente; + } + clientes_tmp[i++] = NULL; + int n = i; + clientes = new void * [n]; + for (i = 0; i < n; i++) { + ((void **) clientes)[i] = clientes_tmp[i]; + } +} + +void imprimeclientes(void * clientes) { + cout << "CLIENTES: \n"; + void ** cs = (void **) clientes; + for (int i = 0; cs[i]; i++) { + void ** c = (void **) cs[i]; + cout << left; + cout << setw(12) << * (int *) c[0]; + cout << setw(64) << (char *) c[1]; + + // void ** pedidos = (void **) c[2]; + + cout << right << fixed << setprecision(2); + cout << setw(8) << * (double *) c[3]; + cout << '\n'; + } +} + +void cargapedidos(void *& productos, void * clientes) { + ifstream in("../Pedidos2.csv"); + if (!in) { + cerr << "Error: no se puedo abrir archivo\n"; + } + char code[MAXLEN]; // product code + int dni; + int qty; + + int i; + for (i = 0; true; i++) { + in.getline(code, MAXLEN, ','); + in >> dni; in.get(); + in >> qty; in.get(); + if (!in) { + break; + } + + // 1. Search the client + void ** c = busca_cliente(clientes, dni); + // 0: dni, 1: name, 2: pedidos, 3: credit + double & credit = * (double *) c[3]; + void *& pedidos = c[2]; + if (!pedidos) { + // "metodo exacto": first use a buffer of certain size, then trim it. + pedidos = new void * [MAX]; + ((void **) pedidos)[0] = NULL; + } + + // 2. Before adding the pedido, a check must be done + void ** p = busca_producto(productos, code); + // 0: code, 1: desc, 2: price, 3: uses_credit + double price = * (double *) p[2]; + char uses_credit = * (char *) p[3]; + double total_cost = qty * price; + if (uses_credit == 'S') { + if (credit < total_cost) { + // not enough credit + continue; + } + credit -= total_cost; + } + + void ** pedido = new void * [3]; + // 0: product code, 1: order qty, 2: total (qty * price) + pedido[0] = new char [strlen(code) + 1]; strcpy((char *) pedido[0], code); + pedido[1] = new int {qty}; + pedido[2] = new double {total_cost}; + agrega_pedido(pedidos, pedido); // appends pedido to the list + } + + // trim TODO + // for (i = 0; i < n; i++) { + // ((void **) clientes)[i] = clientes_tmp[i]; + // } +} + +void ** busca_cliente(void * clientes, int dni) { + void ** cs = (void **) clientes; + for (int i = 0; cs[i]; i++) { + void ** c = (void **) cs[i]; + int c_dni = * (int *) c[0]; + if (c_dni == dni) { + return c; + } + } + return NULL; +} + +void ** busca_producto(void * productos, char * code) { + void ** ps = (void **) productos; + for (int i = 0; ps[i]; i++) { + void ** p = (void **) ps[i]; + char * p_code = (char *) p[0]; + if (strcmp(p_code, code) == 0) { + return p; + } + } + return NULL; +} + +void agrega_pedido(void * pedidos, void * pedido) { + void ** peds = (void **) pedidos; + int i; + for (i = 0; i < MAX && peds[i]; i++) + ; + if (i == MAX) { + cerr << "ERROR: STACK OVERFLOW\n"; + } + peds[i++] = pedido; + peds[i] = NULL; +} + +void imprimereporte(void * clientes) { + ofstream out("ReporteDePedidos.txt"); + if (!out) { + cerr << "Error: no se pudo abrir archivo para reporte\n"; + } + void ** cs = (void **) clientes; + for (int i = 0; cs[i]; i++) { + void ** c = (void **) cs[i]; + // 0: dni, 1: name, 2: pedidos, 3: credit + int dni = * (int *) c[0]; + char * name = (char *) c[1]; + void ** pedidos = (void **) c[2]; + double credit = * (double *) c[3]; + out << + "===========================================================================================================\n" + "DNI Nombre Credito\n" + ; + out << left; + out << setw(12) << dni; + out << setw(64) << name; + out << right << fixed << setprecision(2); + out << setw(8) << credit; + out << '\n'; + + out << + "-----------------------------------------------------------------------------------------------------------\n" + "Pedidos atendidos:\n" + "-----------------------------------------------------------------------------------------------------------\n" + "Codigo Cantidad Total\n" + "-----------------------------------------------------------------------------------------------------------\n" + ; + for (int j = 0; pedidos[j]; j++) { + void ** pedido = (void **) pedidos[j]; + // 0: product code, 1: order qty, 2: total (qty * price) + char * code = (char *) pedido[0]; + int qty = * (int *) pedido[1]; + double total_cost = * (double *) pedido[2]; + + out << left; + out << setw(12) << code; + out << setw(12) << qty; + out << setw(12) << total_cost; + out << '\n'; + } + } +}
\ No newline at end of file diff --git a/2023-2/L04/mitsuo/fun.hpp b/2023-2/L04/mitsuo/fun.hpp new file mode 100644 index 0000000..8665f00 --- /dev/null +++ b/2023-2/L04/mitsuo/fun.hpp @@ -0,0 +1,18 @@ +#ifndef FUN_HPP +#define FUN_HPP + +#define MAX 1000 +#define MAXLEN 100 + +void cargaproductos(void *& productos); +void cargaclientes(void *& clientes); +void cargapedidos(void *& productos, void * clientes); +void imprimereporte(void * clientes); + +void imprimeproductos(void * productos); +void imprimeclientes(void * clientes); +void ** busca_cliente(void * clientes, int dni); +void ** busca_producto(void * productos, char * code); +void agrega_pedido(void * pedidos, void * pedido); + +#endif /* FUN_HPP */
\ No newline at end of file diff --git a/2023-2/L04/mitsuo/main.cpp b/2023-2/L04/mitsuo/main.cpp new file mode 100644 index 0000000..a3ad225 --- /dev/null +++ b/2023-2/L04/mitsuo/main.cpp @@ -0,0 +1,22 @@ +/* Static libraries are not portable, and I'm using a Linux system, so I wont + be using the supplied static library. + + clang++ -std=c++11 -g *.cpp +*/ + +#include "fun.hpp" +// #include "MuestraPunteros.h" + +int main(int argc, char ** argv) { + void * productos, * clientes; + cargaproductos(productos); + imprimeproductos(productos); + + cargaclientes(clientes); + imprimeclientes(clientes); + + cargapedidos(productos, clientes); + imprimereporte(clientes); + return 0; +} + diff --git a/2023-2/L04/mitsuo/simple.ipynb b/2023-2/L04/mitsuo/simple.ipynb new file mode 100644 index 0000000..1e90256 --- /dev/null +++ b/2023-2/L04/mitsuo/simple.ipynb @@ -0,0 +1,1768 @@ +{ + "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": [ + "<div>\n", + "<style scoped>\n", + " .dataframe tbody tr th:only-of-type {\n", + " vertical-align: middle;\n", + " }\n", + "\n", + " .dataframe tbody tr th {\n", + " vertical-align: top;\n", + " }\n", + "\n", + " .dataframe thead th {\n", + " text-align: right;\n", + " }\n", + "</style>\n", + "<table border=\"1\" class=\"dataframe\">\n", + " <thead>\n", + " <tr style=\"text-align: right;\">\n", + " <th></th>\n", + " <th>product_name</th>\n", + " <th>price</th>\n", + " <th>uses_credit</th>\n", + " </tr>\n", + " <tr>\n", + " <th>product_id</th>\n", + " <th></th>\n", + " <th></th>\n", + " <th></th>\n", + " </tr>\n", + " </thead>\n", + " <tbody>\n", + " <tr>\n", + " <th>BIT-434</th>\n", + " <td>Campana Extractora modelo Glass</td>\n", + " <td>375.09</td>\n", + " <td>S</td>\n", + " </tr>\n", + " <tr>\n", + " <th>SSE-115</th>\n", + " <td>Refrigeradora CoolStyle 311N Steel</td>\n", + " <td>3,243.58</td>\n", + " <td>S</td>\n", + " </tr>\n", + " <tr>\n", + " <th>NMV-644</th>\n", + " <td>Lavadora Automatica</td>\n", + " <td>3,272.48</td>\n", + " <td>S</td>\n", + " </tr>\n", + " <tr>\n", + " <th>MLE-193</th>\n", + " <td>Cocina a gas Ingenious</td>\n", + " <td>2,779.41</td>\n", + " <td>S</td>\n", + " </tr>\n", + " <tr>\n", + " <th>YYK-309</th>\n", + " <td>Refrigeradora Door in Door</td>\n", + " <td>4,079.44</td>\n", + " <td>S</td>\n", + " </tr>\n", + " </tbody>\n", + "</table>\n", + "</div>" + ], + "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": [ + "<div>\n", + "<style scoped>\n", + " .dataframe tbody tr th:only-of-type {\n", + " vertical-align: middle;\n", + " }\n", + "\n", + " .dataframe tbody tr th {\n", + " vertical-align: top;\n", + " }\n", + "\n", + " .dataframe thead th {\n", + " text-align: right;\n", + " }\n", + "</style>\n", + "<table border=\"1\" class=\"dataframe\">\n", + " <thead>\n", + " <tr style=\"text-align: right;\">\n", + " <th></th>\n", + " <th>client_name</th>\n", + " <th>phonenumber</th>\n", + " <th>credit</th>\n", + " </tr>\n", + " <tr>\n", + " <th>client_id</th>\n", + " <th></th>\n", + " <th></th>\n", + " <th></th>\n", + " </tr>\n", + " </thead>\n", + " <tbody>\n", + " <tr>\n", + " <th>79464412</th>\n", + " <td>PORTUGAL RAFFO ALEXANDER</td>\n", + " <td>3902394</td>\n", + " <td>10000</td>\n", + " </tr>\n", + " <tr>\n", + " <th>16552775</th>\n", + " <td>YALLICO PAREDES LOURDES CARMELA</td>\n", + " <td>960176666</td>\n", + " <td>20000</td>\n", + " </tr>\n", + " <tr>\n", + " <th>20864087</th>\n", + " <td>ZEGARRA CASANOVA ESTEFANIA</td>\n", + " <td>2639311</td>\n", + " <td>10000</td>\n", + " </tr>\n", + " <tr>\n", + " <th>94326707</th>\n", + " <td>CHANG SEGURA ANGEL</td>\n", + " <td>984185862</td>\n", + " <td>10000</td>\n", + " </tr>\n", + " <tr>\n", + " <th>73786035</th>\n", + " <td>ORTIZ EPIQUEN HENRY ISRAEL</td>\n", + " <td>6873908</td>\n", + " <td>20000</td>\n", + " </tr>\n", + " </tbody>\n", + "</table>\n", + "</div>" + ], + "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": [ + "<div>\n", + "<style scoped>\n", + " .dataframe tbody tr th:only-of-type {\n", + " vertical-align: middle;\n", + " }\n", + "\n", + " .dataframe tbody tr th {\n", + " vertical-align: top;\n", + " }\n", + "\n", + " .dataframe thead th {\n", + " text-align: right;\n", + " }\n", + "</style>\n", + "<table border=\"1\" class=\"dataframe\">\n", + " <thead>\n", + " <tr style=\"text-align: right;\">\n", + " <th></th>\n", + " <th>product_id</th>\n", + " <th>client_id</th>\n", + " <th>qty</th>\n", + " </tr>\n", + " </thead>\n", + " <tbody>\n", + " <tr>\n", + " <th>0</th>\n", + " <td>JXD-139</td>\n", + " <td>50375303</td>\n", + " <td>6</td>\n", + " </tr>\n", + " <tr>\n", + " <th>1</th>\n", + " <td>CRU-009</td>\n", + " <td>50375303</td>\n", + " <td>5</td>\n", + " </tr>\n", + " <tr>\n", + " <th>2</th>\n", + " <td>YYK-309</td>\n", + " <td>22777006</td>\n", + " <td>3</td>\n", + " </tr>\n", + " <tr>\n", + " <th>3</th>\n", + " <td>OTS-581</td>\n", + " <td>42157219</td>\n", + " <td>5</td>\n", + " </tr>\n", + " <tr>\n", + " <th>4</th>\n", + " <td>AWB-345</td>\n", + " <td>13245501</td>\n", + " <td>1</td>\n", + " </tr>\n", + " </tbody>\n", + "</table>\n", + "</div>" + ], + "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 +} |