{ "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(\"../Productos.csv\", names=(\"product_id\", \"product_name\", \"price\", \"stock\"))\n", "pedidos = pd.read_csv(\"../Pedidos.csv\", names=(\"product_id\", \"client_id\", \"qty\", \"date\"))\n", "\n", "productos = productos.set_index('product_id')\n", "pedidos['date'] = pd.to_datetime(pedidos['date'], format=\"%d/%m/%Y\")" ] }, { "cell_type": "code", "execution_count": 4, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
product_namepricestock
product_id
BIT-434Campana Extractora modelo Glass375.0910
SSE-115Refrigeradora CoolStyle 311N Steel3,243.5823
NMV-644Lavadora Automatica3,272.485
MLE-193Cocina a gas Ingenious2,779.4110
YYK-309Refrigeradora Door in Door4,079.4425
\n", "
" ], "text/plain": [ " product_name price stock\n", "product_id \n", "BIT-434 Campana Extractora modelo Glass 375.09 10\n", "SSE-115 Refrigeradora CoolStyle 311N Steel 3,243.58 23\n", "NMV-644 Lavadora Automatica 3,272.48 5\n", "MLE-193 Cocina a gas Ingenious 2,779.41 10\n", "YYK-309 Refrigeradora Door in Door 4,079.44 25" ] }, "execution_count": 4, "metadata": {}, "output_type": "execute_result" } ], "source": [ "productos.head()" ] }, { "cell_type": "code", "execution_count": 5, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
product_idclient_idqtydate
0JXD-1395037530362023-08-24
1CRU-0095037530352023-09-03
2YYK-3092277700632023-08-27
3OTS-5814215721952023-08-28
4AWB-3451324550112023-08-24
\n", "
" ], "text/plain": [ " product_id client_id qty date\n", "0 JXD-139 50375303 6 2023-08-24\n", "1 CRU-009 50375303 5 2023-09-03\n", "2 YYK-309 22777006 3 2023-08-27\n", "3 OTS-581 42157219 5 2023-08-28\n", "4 AWB-345 13245501 1 2023-08-24" ] }, "execution_count": 5, "metadata": {}, "output_type": "execute_result" } ], "source": [ "pedidos.head()" ] }, { "cell_type": "code", "execution_count": 6, "metadata": {}, "outputs": [], "source": [ "# reduce stock from products as orders come\n", "\n", "pedidos['qty_served'] = 0\n", "for i, pedido in pedidos.iterrows():\n", " pid = pedido['product_id']\n", " qty = pedido['qty']\n", " stock = productos.loc[pid, 'stock']\n", " if stock >= qty:\n", " pedidos.loc[i, 'qty_served'] = qty\n", " productos.loc[pid, 'stock'] -= qty\n", " else:\n", " pedidos.loc[i, 'qty_served'] = max(0, stock)\n", " productos.loc[pid, 'stock'] = 0" ] }, { "cell_type": "code", "execution_count": 7, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "FECHA: 21/08/2023\n", " client_id product_id product_name qty_served price total\n", "1 57690875 CSZ-863 Video Filmadora 5 1,713.57 8,567.85\n", "2 11602775 CIM-038 Cocina Empotrable Petra 4 2,544.64 10,178.56\n", "3 29337157 ZEX-027 Tablet Xperia Z 3 3,843.75 11,531.25\n", "4 49087435 VDD-853 Deshumedecedor FAD30D7TSSW 3.4L 25-30m2 2 1,095.67 2,191.34\n", "5 62566305 TYF-885 Videojuego TW 4 4 794.14 3,176.56\n", "6 45877001 VVS-017 Tablets MW 0731 4 2,599.72 10,398.88\n", "7 83505958 EJW-346 Campana Extractora 3 359.70 1,079.10\n", "8 98140264 QHC-492 Terma Solucion 4 1,907.23 7,628.92\n", "9 40348917 WZD-331 Refrigeradora ECOTT 465 IX 3 1,213.79 3,641.37\n", "10 90365520 KWP-672 Televisor UHD TV 6 1,625.30 9,751.80\n", "11 45783712 QFR-958 Cocina a gas Bavaro 3 1,607.46 4,822.38\n", "12 49087435 SJQ-827 Reproductor Multimedia Touch Screen 1 1,719.56 1,719.56\n", "13 89429489 VXS-438 Mouse Blue Tooth 1 60.11 60.11\n", "14 17913944 IHG-413 Parlant Y pedestal PAM-83 4 317.70 1,270.80\n", "15 81114108 VRR-793 Rack Giratorio 32/60 4 241.71 966.84\n", "16 90237332 PVZ-181 Ventilador circular 5 309.77 1,548.85\n", "17 40348917 FLJ-040 Parlantes portatiles SOUNDSHOOTER 2 3,703.37 7,406.74\n", "18 37110873 UWA-476 Autoradio MEX BT3150U 2 1,191.39 2,382.78\n", "19 55552996 FQG-293 Rapiducha Premiun 1 2,784.31 2,784.31\n", "20 85949265 TMJ-043 Lavadora EcoBubble 6 2,400.79 14,404.74\n", "21 71463316 QFP-254 Calentador electrico instantaneo 6 180.65 1,083.90\n", "22 26233063 ZAF-449 Tablet Cardle 2 816.43 1,632.86\n", "23 90365520 OPJ-039 Secadora de Ropa 1 2,765.64 2,765.64\n", "24 69639726 OPT-996 Mini componente GPX88 3 1,367.48 4,102.44\n", "25 49087435 PJG-338 Impresora Mutifuncional Inalambricar 1 1,067.80 1,067.80\n", "26 79140840 TMN-884 Secadora de mano 0 310.65 0.00\n", "27 91897732 WLL-607 Cocina Electronica Convencion 1 1,525.04 1,525.04\n", "28 71984468 JJN-837 Lavadora Tecnologia Wobbie 5 1,979.92 9,899.60\n", "29 15210391 HFM-021 Horno Electrico 1 726.91 726.91\n", "30 17972674 UTN-601 Autoradio XAV-601 BT 1 562.51 562.51\n", "31 49087435 XZR-640 Lavadora-Secadora FWD 4 2,390.58 9,562.32\n", "32 25171011 VCL-867 Cocina a gas Rubi 2 1 699.07 699.07\n", "33 85949265 YUQ-590 Refrigeradora CoolStyle 395N Steel 2 1,979.07 3,958.14\n", "34 43043986 TXM-139 Televisor LED FULL HD 3D 0 1,092.95 0.00\n", "35 38913831 JFC-432 DVD DVM-L79 3 307.67 923.01\n", "36 11602775 TMJ-043 Lavadora EcoBubble 6 2,400.79 14,404.74\n", "37 17913944 YJD-279 Cocina a gas Florencia 5 1,028.43 5,142.15\n", "38 81114108 DUG-251 Cocina a gas FFG3047SL 0 1,597.96 0.00\n", "39 50365593 TZY-323 Terma a gas 1 2,341.01 2,341.01\n", "40 32904023 SAM-013 Cocina a gas FFG3047SL 0 2,275.18 0.00\n", "41 40112594 EBI-299 Cocina a gas Fridare 0 2,287.57 0.00\n", "42 44229880 HLR-109 Parlantes inalambricos 5 439.47 2,197.35\n", "43 58187172 VXS-438 Mouse Blue Tooth 2 60.11 120.22\n", "44 15561764 RAH-420 Cocina a gas Pro 6550 INOX 2 157.01 314.02\n", "45 95161027 TZY-323 Terma a gas 3 2,341.01 7,023.03\n", "46 77191257 BWD-036 Cocina Empotrable Klimatica 0 1,086.34 0.00\n", "47 32565207 ZWF-661 Impresora Led 0 2,731.61 0.00\n", "Total ingresado: 175,564.50\n", "Total perdido por falta de stock: 58,108.71\n", "========================================================================================================================\n", "FECHA: 22/08/2023\n", " client_id product_id product_name qty_served price total\n", "1 78757121 OQI-373 Cocina Empotrable Premio Plus 3 906.16 2,718.48\n", "2 71984468 PQH-935 Rack Giratorio 26/32 2 94.45 188.90\n", "3 43488351 XLF-273 Centro de Lavado a Gas 5 2,371.95 11,859.75\n", "4 15210391 RSE-049 Radio CD/DVD - TV 5 4,037.51 20,187.55\n", "5 78078115 XZR-640 Lavadora-Secadora FWD 5 2,390.58 11,952.90\n", "6 77484838 BTO-226 Friobar 4 863.19 3,452.76\n", "7 25171011 OPT-996 Mini componente GPX88 6 1,367.48 8,204.88\n", "8 95161027 VJI-529 Horno Empotrable Electrico 2 1,102.67 2,205.34\n", "9 27912250 LWG-915 Cocina a gas Murano 4 1,101.47 4,405.88\n", "10 15561764 JYQ-045 Horno Microondas 1.2 p3 6 267.15 1,602.90\n", "11 78757121 ZXK-295 Cocina Empotrable Electrica 4 3,679.43 14,717.72\n", "12 76388967 RSE-049 Radio CD/DVD - TV 6 4,037.51 24,225.06\n", "13 37110873 GXF-122 Televisor Ultra HDTV 2 1,110.16 2,220.32\n", "14 16151792 WZD-331 Refrigeradora ECOTT 465 IX 3 1,213.79 3,641.37\n", "15 73535476 CIM-038 Cocina Empotrable Petra 0 2,544.64 0.00\n", "16 89298238 QTK-083 Congeladora Conservador Vertical 476 Lts. 3 2,682.73 8,048.19\n", "17 78078115 DFF-034 Grabadora de voz digital portatil con USB inte... 2 259.25 518.50\n", "18 77484838 YUQ-590 Refrigeradora CoolStyle 395N Steel 6 1,979.07 11,874.42\n", "19 35584593 KCO-488 Ventilador de pared 1 679.60 679.60\n", "20 78078115 TMJ-043 Lavadora EcoBubble 3 2,400.79 7,202.37\n", "21 38913831 YZD-580 Mini componente ESX8 0 1,582.29 0.00\n", "22 87800799 QRC-609 Camara de video EOS 1 1,806.66 1,806.66\n", "23 66409237 ICX-503 Cocina a gas Roma 5 1,221.02 6,105.10\n", "24 86241107 HFC-845 Televisor Serie LED R555A 3 3,736.75 11,210.25\n", "25 36008913 HFC-845 Televisor Serie LED R555A 6 3,736.75 22,420.50\n", "26 64394265 YYK-309 Refrigeradora Door in Door 6 4,079.44 24,476.64\n", "27 32821689 ISU-815 Audifonos 1 619.89 619.89\n", "28 26290971 TZY-323 Terma a gas 5 2,341.01 11,705.05\n", "29 77191257 AVM-258 Cocina a gas Toscana 6 2,831.23 16,987.38\n", "30 52097922 MMA-577 Congeladora Horizontal 252 Lts. 2 1,780.30 3,560.60\n", "31 84165595 QHC-492 Terma Solucion 1 1,907.23 1,907.23\n", "32 93845419 NSR-955 Cocina a gas Blogna 2 2,591.44 5,182.88\n", "33 27912250 LWG-915 Cocina a gas Murano 0 1,101.47 0.00\n", "34 20864087 SPR-580 Dispensador de Agua 1 404.35 404.35\n", "35 94080926 OTW-288 Cavba de Vinos GE cap. 34 botellas 5 1,119.18 5,595.90\n", "36 80048864 BWD-036 Cocina Empotrable Klimatica 0 1,086.34 0.00\n", "Total ingresado: 251,889.32\n", "Total perdido por falta de stock: 19,298.39\n", "========================================================================================================================\n", "FECHA: 23/08/2023\n", " client_id product_id product_name qty_served price total\n", "1 31193794 JDC-028 Puntero Laser 1 30.48 30.48\n", "2 89148118 TKM-141 Cocina a gas Marsella 6 402.24 2,413.44\n", "3 29337157 QHC-492 Terma Solucion 6 1,907.23 11,443.38\n", "4 90237332 PFD-286 Refrigeradora cap. 415 litros 4 2,776.02 11,104.08\n", "5 89298238 PFD-286 Refrigeradora cap. 415 litros 2 2,776.02 5,552.04\n", "6 55552996 AQS-362 Teclado Inalambrico USB 1 233.05 233.05\n", "7 81114108 BCN-855 Cocina a gas Bahia Can 4 4,015.92 16,063.68\n", "8 22280452 VRR-793 Rack Giratorio 32/60 5 241.71 1,208.55\n", "9 69324480 VXS-438 Mouse Blue Tooth 3 60.11 180.33\n", "10 79464412 MTF-868 Impresora Monocromatica WorkForce M205 6 971.59 5,829.54\n", "11 93160528 BRD-969 Centro de Lavado Electrico 5 2,579.72 12,898.60\n", "12 43488351 QTK-083 Congeladora Conservador Vertical 476 Lts. 6 2,682.73 16,096.38\n", "13 93160528 QTK-083 Congeladora Conservador Vertical 476 Lts. 3 2,682.73 8,048.19\n", "14 76388967 CNQ-172 Congeladora Horizontal 364 Lts. 6 3,689.62 22,137.72\n", "15 89298238 YOT-530 Deshumedecedor DM-190H 1 941.73 941.73\n", "16 89429489 QUU-384 Lavavajilla Blue Touch 0 2,545.54 0.00\n", "17 50365593 ZVA-180 Refrigeradora 322 litros 6 2,903.13 17,418.78\n", "18 83236386 OFS-384 Parlantes Bluetooth 1 805.22 805.22\n", "19 81114108 OFS-384 Parlantes Bluetooth 3 805.22 2,415.66\n", "20 23928045 LWG-915 Cocina a gas Murano 2 1,101.47 2,202.94\n", "21 73185299 QFP-254 Calentador electrico instantaneo 0 180.65 0.00\n", "22 78922174 XBD-314 Cocina a gas Fassina 2 1,444.90 2,889.80\n", "23 87813843 LDR-510 Mini componente ESX9 6 2,701.87 16,211.22\n", "24 78078115 PJG-338 Impresora Mutifuncional Inalambricar 2 1,067.80 2,135.60\n", "25 79372768 SAM-013 Cocina a gas FFG3047SL 1 2,275.18 2,275.18\n", "26 64394265 OTW-288 Cavba de Vinos GE cap. 34 botellas 5 1,119.18 5,595.90\n", "27 77642521 YYU-726 Reproductor DVD Portatil 2 767.82 1,535.64\n", "28 12663268 QFP-254 Calentador electrico instantaneo 0 180.65 0.00\n", "Total ingresado: 167,667.13\n", "Total perdido por falta de stock: 4,352.04\n", "========================================================================================================================\n", "FECHA: 24/08/2023\n", " client_id product_id product_name qty_served price total\n", "1 50375303 JXD-139 Terma Evolucion Soltu 6 586.02 3,516.12\n", "2 13245501 AWB-345 Deshumedecedor DM-189H 1 800.37 800.37\n", "3 12663268 AHB-459 Reproductor DVD Portatil TV 7 3 685.50 2,056.50\n", "4 36380447 OWN-701 Olla arrocera 5 220.82 1,104.10\n", "5 88956889 TMN-884 Secadora de mano 1 310.65 310.65\n", "6 59162728 FEG-454 Sillon masajeador 4 1,695.70 6,782.80\n", "7 33713901 ZVA-180 Refrigeradora 322 litros 6 2,903.13 17,418.78\n", "8 86402303 OQI-373 Cocina Empotrable Premio Plus 3 906.16 2,718.48\n", "9 24995742 KCO-488 Ventilador de pared 4 679.60 2,718.40\n", "10 97403853 BCK-361 Tablets 10.1 5 1,872.53 9,362.65\n", "11 79901434 OXP-732 Televisor OLED 4K UHD Google TV Smart 77 XR-77... 2 16,504.47 33,008.94\n", "12 26290971 TYF-885 Videojuego TW 4 0 794.14 0.00\n", "13 26976877 AFL-718 Vinera 5 1,664.97 8,324.85\n", "14 79464412 JXD-139 Terma Evolucion Soltu 4 586.02 2,344.08\n", "15 25171011 QRC-609 Camara de video EOS 3 1,806.66 5,419.98\n", "16 89148118 JFC-432 DVD DVM-L79 5 307.67 1,538.35\n", "17 45828535 AVM-258 Cocina a gas Toscana 2 2,831.23 5,662.46\n", "18 46462527 ISU-815 Audifonos 6 619.89 3,719.34\n", "19 95015539 CSZ-863 Video Filmadora 2 1,713.57 3,427.14\n", "20 11602775 JJN-837 Lavadora Tecnologia Wobbie 2 1,979.92 3,959.84\n", "21 15210391 OTW-288 Cavba de Vinos GE cap. 34 botellas 3 1,119.18 3,357.54\n", "22 43877279 SSD-176 Refrigeradora Linea Gallery 4 567.71 2,270.84\n", "23 54761731 FVB-607 Cocina a gas Essenza BL 5 2,953.07 14,765.35\n", "24 85949265 LDR-510 Mini componente ESX9 6 2,701.87 16,211.22\n", "25 78078115 SSD-176 Refrigeradora Linea Gallery 1 567.71 567.71\n", "26 35565959 VJI-529 Horno Empotrable Electrico 5 1,102.67 5,513.35\n", "27 45783712 VZV-827 Refrigeradora Top Mount 1 1,784.27 1,784.27\n", "28 50365593 VVS-017 Tablets MW 0731 3 2,599.72 7,799.16\n", "29 87800799 JDC-028 Puntero Laser 5 30.48 152.40\n", "30 73914283 OBI-353 Terma Milenium 4 2,960.56 11,842.24\n", "31 45877001 RDT-761 Horno Microondas con dorador 0 904.95 0.00\n", "32 42928709 GLC-370 Video Proyector Power Lite 95 6 552.24 3,313.44\n", "Total ingresado: 181,771.35\n", "Total perdido por falta de stock: 6,907.17\n", "========================================================================================================================\n", "FECHA: 25/08/2023\n", " client_id product_id product_name qty_served price total\n", "1 57263719 TZY-323 Terma a gas 6 2,341.01 14,046.06\n", "2 87800799 KWP-672 Televisor UHD TV 2 1,625.30 3,250.60\n", "3 35565959 CIM-038 Cocina Empotrable Petra 4 2,544.64 10,178.56\n", "4 77642521 QUU-384 Lavavajilla Blue Touch 0 2,545.54 0.00\n", "5 79901434 AHB-459 Reproductor DVD Portatil TV 7 3 685.50 2,056.50\n", "6 67418025 QUU-384 Lavavajilla Blue Touch 0 2,545.54 0.00\n", "7 79140840 TYF-885 Videojuego TW 4 0 794.14 0.00\n", "8 11602775 XLF-273 Centro de Lavado a Gas 4 2,371.95 9,487.80\n", "9 62566305 DIQ-718 Horno Microondas de Conveccion Cello 3 390.80 1,172.40\n", "10 40348917 SNY-500 Cocina a gas Praga Quarzo 4 3,297.09 13,188.36\n", "11 83236386 MTF-868 Impresora Monocromatica WorkForce M205 2 971.59 1,943.18\n", "12 52097922 GBD-525 Refrigeradora Puertas Mágicas 5 2,700.95 13,504.75\n", "13 16151792 CNQ-172 Congeladora Horizontal 364 Lts. 1 3,689.62 3,689.62\n", "14 32821689 MMA-577 Congeladora Horizontal 252 Lts. 5 1,780.30 8,901.50\n", "15 26976877 JXD-139 Terma Evolucion Soltu 2 586.02 1,172.04\n", "16 73535476 LDR-510 Mini componente ESX9 2 2,701.87 5,403.74\n", "17 96258632 EBI-299 Cocina a gas Fridare 4 2,287.57 9,150.28\n", "18 62324793 YJD-279 Cocina a gas Florencia 5 1,028.43 5,142.15\n", "19 13245501 ZWF-661 Impresora Led 0 2,731.61 0.00\n", "20 87800799 ICX-503 Cocina a gas Roma 2 1,221.02 2,442.04\n", "21 73786035 AQS-362 Teclado Inalambrico USB 1 233.05 233.05\n", "22 58187172 KBY-991 Home Theater E4100 6 1,101.08 6,606.48\n", "23 71378466 OQI-373 Cocina Empotrable Premio Plus 1 906.16 906.16\n", "24 88995291 HLR-109 Parlantes inalambricos 2 439.47 878.94\n", "25 95751208 BWD-036 Cocina Empotrable Klimatica 0 1,086.34 0.00\n", "26 87800799 EUZ-452 Impresora Mutifuncional Led Color 2 3,623.88 7,247.76\n", "27 57263719 YOT-530 Deshumedecedor DM-190H 2 941.73 1,883.46\n", "28 93845419 AWB-345 Deshumedecedor DM-189H 0 800.37 0.00\n", "29 19829266 UXG-019 Terma de acumulacion 0 934.91 0.00\n", "30 93160528 DUG-251 Cocina a gas FFG3047SL 2 1,597.96 3,195.92\n", "31 50375303 SJQ-827 Reproductor Multimedia Touch Screen 2 1,719.56 3,439.12\n", "32 42798099 RDT-761 Horno Microondas con dorador 2 904.95 1,809.90\n", "33 49087435 AFL-718 Vinera 0 1,664.97 0.00\n", "34 45783712 SNY-500 Cocina a gas Praga Quarzo 1 3,297.09 3,297.09\n", "35 77484838 YGV-332 Impresora Led Color 3 2,517.66 7,552.98\n", "Total ingresado: 141,780.44\n", "Total perdido por falta de stock: 52,700.51\n", "========================================================================================================================\n", "FECHA: 26/08/2023\n", " client_id product_id product_name qty_served price total\n", "1 27912250 ICX-503 Cocina a gas Roma 1 1,221.02 1,221.02\n", "2 86828079 MQR-442 Reloj Digital RMM-29 3 271.66 814.98\n", "3 49087435 BCK-361 Tablets 10.1 3 1,872.53 5,617.59\n", "4 78922174 AFL-718 Vinera 5 1,664.97 8,324.85\n", "5 11602775 JJN-837 Lavadora Tecnologia Wobbie 1 1,979.92 1,979.92\n", "6 79475585 BWD-036 Cocina Empotrable Klimatica 0 1,086.34 0.00\n", "7 17972674 UWA-476 Autoradio MEX BT3150U 4 1,191.39 4,765.56\n", "8 71378466 BIT-434 Campana Extractora modelo Glass 4 375.09 1,500.36\n", "9 83505958 MQR-442 Reloj Digital RMM-29 1 271.66 271.66\n", "10 77484838 AFL-718 Vinera 1 1,664.97 1,664.97\n", "11 95161027 VVS-017 Tablets MW 0731 5 2,599.72 12,998.60\n", "12 54761731 DEV-433 Parlantes portatiles SHOQBOX 3 2,698.74 8,096.22\n", "13 45828535 QJO-060 Televisor LED FULL HD 6 2,704.14 16,224.84\n", "14 83236386 OPT-996 Mini componente GPX88 2 1,367.48 2,734.96\n", "15 42157219 III-576 Campana Extractora Venus Plus 6 1,077.65 6,465.90\n", "16 38637282 FLJ-040 Parlantes portatiles SOUNDSHOOTER 6 3,703.37 22,220.22\n", "17 59407188 RDT-761 Horno Microondas con dorador 5 904.95 4,524.75\n", "18 78757121 GXF-122 Televisor Ultra HDTV 1 1,110.16 1,110.16\n", "19 90365520 EUZ-452 Impresora Mutifuncional Led Color 6 3,623.88 21,743.28\n", "20 13245501 HFC-845 Televisor Serie LED R555A 6 3,736.75 22,420.50\n", "21 78757121 ARS-231 Audifonos Stereos 4 327.62 1,310.48\n", "22 24995742 BWD-036 Cocina Empotrable Klimatica 0 1,086.34 0.00\n", "23 86402303 OQI-373 Cocina Empotrable Premio Plus 3 906.16 2,718.48\n", "24 57690875 XLF-273 Centro de Lavado a Gas 2 2,371.95 4,743.90\n", "25 94080926 CIM-038 Cocina Empotrable Petra 0 2,544.64 0.00\n", "26 54761731 ZVA-180 Refrigeradora 322 litros 1 2,903.13 2,903.13\n", "27 42157219 KWP-672 Televisor UHD TV 6 1,625.30 9,751.80\n", "28 54761731 VZV-827 Refrigeradora Top Mount 1 1,784.27 1,784.27\n", "29 29337157 WZD-331 Refrigeradora ECOTT 465 IX 0 1,213.79 0.00\n", "30 73535476 KJX-387 Ventilador de techo 2 613.19 1,226.38\n", "31 77191257 TZY-323 Terma a gas 3 2,341.01 7,023.03\n", "32 27912250 FLJ-040 Parlantes portatiles SOUNDSHOOTER 3 3,703.37 11,110.11\n", "33 32904023 KQQ-136 Impresora Laser EPSON 0 1,139.56 0.00\n", "34 99842319 ZAF-449 Tablet Cardle 1 816.43 816.43\n", "35 57263719 ZWF-661 Impresora Led 0 2,731.61 0.00\n", "36 81114108 VCL-867 Cocina a gas Rubi 2 0 699.07 0.00\n", "37 31611146 XSD-310 Refrigeradora No frost 0 2,259.93 0.00\n", "38 40348917 VRR-793 Rack Giratorio 32/60 3 241.71 725.13\n", "39 79901434 TXM-139 Televisor LED FULL HD 3D 0 1,092.95 0.00\n", "40 26976877 XZG-521 Secadora Electrica FAQE7001LW 3 704.27 2,112.81\n", "Total ingresado: 190,926.29\n", "Total perdido por falta de stock: 51,084.66\n", "========================================================================================================================\n", "FECHA: 27/08/2023\n", " client_id product_id product_name qty_served price total\n", "1 22777006 YYK-309 Refrigeradora Door in Door 3 4,079.44 12,238.32\n", "2 63437380 PJG-338 Impresora Mutifuncional Inalambricar 2 1,067.80 2,135.60\n", "3 87813843 MLE-193 Cocina a gas Ingenious 4 2,779.41 11,117.64\n", "4 79140840 DFF-034 Grabadora de voz digital portatil con USB inte... 3 259.25 777.75\n", "5 73914283 OBI-353 Terma Milenium 1 2,960.56 2,960.56\n", "6 43053402 YOT-530 Deshumedecedor DM-190H 2 941.73 1,883.46\n", "7 52097922 ISU-815 Audifonos 5 619.89 3,099.45\n", "8 32565207 UXG-019 Terma de acumulacion 4 934.91 3,739.64\n", "9 37110873 YZD-580 Mini componente ESX8 4 1,582.29 6,329.16\n", "10 12663268 XSD-310 Refrigeradora No frost 6 2,259.93 13,559.58\n", "11 11602775 YYK-309 Refrigeradora Door in Door 3 4,079.44 12,238.32\n", "12 15561764 FYF-898 Proyector a color 2 1,160.46 2,320.92\n", "13 60574154 III-576 Campana Extractora Venus Plus 6 1,077.65 6,465.90\n", "14 73185299 QUU-384 Lavavajilla Blue Touch 0 2,545.54 0.00\n", "15 43877279 SNY-500 Cocina a gas Praga Quarzo 4 3,297.09 13,188.36\n", "16 40112594 KSO-608 Secadora Modelo Italica 6 914.17 5,485.02\n", "17 41036366 AQS-362 Teclado Inalambrico USB 2 233.05 466.10\n", "18 25171011 CIM-038 Cocina Empotrable Petra 0 2,544.64 0.00\n", "19 96659352 KQA-580 Cocina Empotrable Glassy Plus 6 2,907.92 17,447.52\n", "20 79140840 HLR-109 Parlantes inalambricos 1 439.47 439.47\n", "21 90237332 OQI-373 Cocina Empotrable Premio Plus 1 906.16 906.16\n", "22 89863424 SSE-115 Refrigeradora CoolStyle 311N Steel 4 3,243.58 12,974.32\n", "23 86828079 YGV-332 Impresora Led Color 1 2,517.66 2,517.66\n", "24 78757121 KJX-387 Ventilador de techo 4 613.19 2,452.76\n", "25 78078115 XOA-735 Congeladora Vertical 392 Lts. 2 2,708.07 5,416.14\n", "26 67418025 EVN-510 Cocina a gas FFG3011LB 5 2,672.30 13,361.50\n", "27 95751208 BRD-969 Centro de Lavado Electrico 4 2,579.72 10,318.88\n", "28 26976877 KQQ-136 Impresora Laser EPSON 3 1,139.56 3,418.68\n", "29 38913831 FLW-631 Radio Reloj Despertador 3 819.04 2,457.12\n", "30 57263719 OTH-462 Lavadora Semi-Automatica 2 531.04 1,062.08\n", "31 63437380 YEZ-591 Lavadora WA 5 1,320.03 6,600.15\n", "32 91897732 OXP-732 Televisor OLED 4K UHD Google TV Smart 77 XR-77... 2 16,504.47 33,008.94\n", "33 26233063 JFC-432 DVD DVM-L79 4 307.67 1,230.68\n", "34 55552996 SSD-176 Refrigeradora Linea Gallery 6 567.71 3,406.26\n", "35 22777006 XLF-273 Centro de Lavado a Gas 0 2,371.95 0.00\n", "36 13245501 JCW-489 Conservadora Exibidora CMVE-250 5 2,064.97 10,324.85\n", "37 26976877 YUQ-590 Refrigeradora CoolStyle 395N Steel 1 1,979.07 1,979.07\n", "38 38637282 OFS-384 Parlantes Bluetooth 0 805.22 0.00\n", "39 84165595 JFC-432 DVD DVM-L79 3 307.67 923.01\n", "40 45877001 GBJ-693 Radio CD 3 314.20 942.60\n", "41 66409237 CRU-009 Lavavajilla 0 2,655.78 0.00\n", "42 78922174 OQI-373 Cocina Empotrable Premio Plus 1 906.16 906.16\n", "43 54716824 CRU-009 Lavavajilla 0 2,655.78 0.00\n", "44 17913944 XLF-273 Centro de Lavado a Gas 0 2,371.95 0.00\n", "45 57690875 XTE-383 Rack Fijo 32/60 6 261.01 1,566.06\n", "Total ingresado: 231,665.85\n", "Total perdido por falta de stock: 61,736.20\n", "========================================================================================================================\n", "FECHA: 28/08/2023\n", " client_id product_id product_name qty_served price total\n", "1 42157219 OTS-581 Galaxy Note 8.0 5 2,653.10 13,265.50\n", "2 77484838 UWA-476 Autoradio MEX BT3150U 1 1,191.39 1,191.39\n", "3 79464412 CJE-310 Mini componente GPX33 5 3,643.39 18,216.95\n", "4 76388967 SJQ-827 Reproductor Multimedia Touch Screen 5 1,719.56 8,597.80\n", "5 78922174 TKM-141 Cocina a gas Marsella 5 402.24 2,011.20\n", "6 94080926 NMV-644 Lavadora Automatica 5 3,272.48 16,362.40\n", "7 57263719 BWD-036 Cocina Empotrable Klimatica 3 1,086.34 3,259.02\n", "8 17972674 ZWF-661 Impresora Led 1 2,731.61 2,731.61\n", "9 89148118 XLF-273 Centro de Lavado a Gas 5 2,371.95 11,859.75\n", "10 42928709 NSM-283 Cocina a gas FFG3053SL 5 936.81 4,684.05\n", "11 57690875 CIM-038 Cocina Empotrable Petra 3 2,544.64 7,633.92\n", "12 80048864 BCK-361 Tablets 10.1 1 1,872.53 1,872.53\n", "13 59407188 BIT-434 Campana Extractora modelo Glass 6 375.09 2,250.54\n", "14 32565207 FVQ-662 Cocina a gas Pro 6300 INOX 5 1,060.68 5,303.40\n", "15 24995742 YMU-875 Cocina a gas Plermo Quarzo 3 3,232.10 9,696.30\n", "16 89298238 QFP-254 Calentador electrico instantaneo 2 180.65 361.30\n", "17 44679500 AWB-345 Deshumedecedor DM-189H 0 800.37 0.00\n", "18 35584593 AVM-258 Cocina a gas Toscana 4 2,831.23 11,324.92\n", "19 85871751 MYC-756 Cocina a gas Leganza INOX 2 1,506.80 3,013.60\n", "20 43043986 QFP-254 Calentador electrico instantaneo 5 180.65 903.25\n", "21 71463316 UWA-476 Autoradio MEX BT3150U 3 1,191.39 3,574.17\n", "22 71378466 ARS-231 Audifonos Stereos 6 327.62 1,965.72\n", "23 79475585 KQQ-136 Impresora Laser EPSON 6 1,139.56 6,837.36\n", "24 32904023 KJX-387 Ventilador de techo 3 613.19 1,839.57\n", "25 42157219 KCO-488 Ventilador de pared 2 679.60 1,359.20\n", "26 71463316 BCN-855 Cocina a gas Bahia Can 4 4,015.92 16,063.68\n", "27 66409237 UXG-019 Terma de acumulacion 4 934.91 3,739.64\n", "28 23928045 OXP-732 Televisor OLED 4K UHD Google TV Smart 77 XR-77... 3 16,504.47 49,513.41\n", "29 26233063 KSO-608 Secadora Modelo Italica 3 914.17 2,742.51\n", "30 86241107 CIM-038 Cocina Empotrable Petra 0 2,544.64 0.00\n", "31 35565959 DFJ-952 Cocina a gas Prestige 60 INOX 2 3,342.77 6,685.54\n", "32 73786035 DEN-125 Rack Fijo 26/32 4 562.46 2,249.84\n", "33 45828535 TZY-323 Terma a gas 6 2,341.01 14,046.06\n", "34 26976877 SSE-115 Refrigeradora CoolStyle 311N Steel 4 3,243.58 12,974.32\n", "35 80048864 PPX-620 Aire acondicionado tipo split 1 2,873.42 2,873.42\n", "36 60574154 KDA-627 Cocina a gas Ijasmin 5 1,424.46 7,122.30\n", "37 40112594 BCK-361 Tablets 10.1 0 1,872.53 0.00\n", "38 79372768 QVJ-982 Horno Microondas 0.7 p3 6 1,352.76 8,116.56\n", "39 43877279 QUU-384 Lavavajilla Blue Touch 0 2,545.54 0.00\n", "40 69975105 HFM-021 Horno Electrico 3 726.91 2,180.73\n", "41 43053402 FVQ-662 Cocina a gas Pro 6300 INOX 2 1,060.68 2,121.36\n", "42 89863424 OTH-462 Lavadora Semi-Automatica 6 531.04 3,186.24\n", "43 95161027 OQI-373 Cocina Empotrable Premio Plus 0 906.16 0.00\n", "44 62324793 OPJ-039 Secadora de Ropa 2 2,765.64 5,531.28\n", "Total ingresado: 279,262.34\n", "Total perdido por falta de stock: 33,437.08\n", "========================================================================================================================\n", "FECHA: 29/08/2023\n", " client_id product_id product_name qty_served price total\n", "1 98140264 DFF-034 Grabadora de voz digital portatil con USB inte... 2 259.25 518.50\n", "2 25171011 VCL-867 Cocina a gas Rubi 2 3 699.07 2,097.21\n", "3 76388967 EBI-299 Cocina a gas Fridare 5 2,287.57 11,437.85\n", "4 16552775 CNN-411 Congeladora Side by Side 5 2,296.29 11,481.45\n", "5 46462527 KWP-672 Televisor UHD TV 3 1,625.30 4,875.90\n", "6 79464412 NSM-283 Cocina a gas FFG3053SL 2 936.81 1,873.62\n", "7 52097922 OWN-701 Olla arrocera 2 220.82 441.64\n", "8 71463316 KCO-488 Ventilador de pared 5 679.60 3,398.00\n", "9 77642521 DFJ-952 Cocina a gas Prestige 60 INOX 5 3,342.77 16,713.85\n", "10 53166028 QHC-492 Terma Solucion 1 1,907.23 1,907.23\n", "11 45877001 PJG-338 Impresora Mutifuncional Inalambricar 2 1,067.80 2,135.60\n", "12 77484838 UDR-957 Refrigeradora ECOTT 423 IXL 3 861.70 2,585.10\n", "13 71463316 EBI-299 Cocina a gas Fridare 6 2,287.57 13,725.42\n", "14 88956889 HFM-021 Horno Electrico 6 726.91 4,361.46\n", "15 29847168 BCK-361 Tablets 10.1 0 1,872.53 0.00\n", "16 55552996 SJD-818 Refrigeradora CoolStyle 281A Steel 1 3,387.75 3,387.75\n", "17 87800799 WZD-331 Refrigeradora ECOTT 465 IX 0 1,213.79 0.00\n", "18 43053402 VRR-793 Rack Giratorio 32/60 2 241.71 483.42\n", "19 16151792 AQS-362 Teclado Inalambrico USB 1 233.05 233.05\n", "20 81114108 RBE-789 Televisor SMART TV 2 3,303.07 6,606.14\n", "21 62324793 FQG-293 Rapiducha Premiun 1 2,784.31 2,784.31\n", "22 87800799 BTO-226 Friobar 3 863.19 2,589.57\n", "23 44229880 SNY-500 Cocina a gas Praga Quarzo 3 3,297.09 9,891.27\n", "24 20864087 YUQ-590 Refrigeradora CoolStyle 395N Steel 5 1,979.07 9,895.35\n", "25 31193794 BXY-119 Cocina Empotrable Klimatica 3 2,716.11 8,148.33\n", "26 86241107 FEG-454 Sillon masajeador 2 1,695.70 3,391.40\n", "27 95161027 FQG-293 Rapiducha Premiun 4 2,784.31 11,137.24\n", "28 69639726 DON-719 Secadora de Cabello SG-3035 1 360.69 360.69\n", "29 53166028 ONB-903 Reproductor BLU-RAY 3D 3 653.67 1,961.01\n", "30 45828535 YMU-875 Cocina a gas Plermo Quarzo 5 3,232.10 16,160.50\n", "31 71378466 XSD-310 Refrigeradora No frost 0 2,259.93 0.00\n", "Total ingresado: 154,582.86\n", "Total perdido por falta de stock: 16,512.12\n", "========================================================================================================================\n", "FECHA: 30/08/2023\n", " client_id product_id product_name qty_served price total\n", "1 97403853 KQQ-136 Impresora Laser EPSON 6 1,139.56 6,837.36\n", "2 50365593 AFL-718 Vinera 5 1,664.97 8,324.85\n", "3 83505958 TYF-885 Videojuego TW 4 3 794.14 2,382.42\n", "4 63437380 AWB-345 Deshumedecedor DM-189H 0 800.37 0.00\n", "5 19829266 TXM-139 Televisor LED FULL HD 3D 3 1,092.95 3,278.85\n", "6 32821689 ONB-903 Reproductor BLU-RAY 3D 3 653.67 1,961.01\n", "7 96258632 QHC-492 Terma Solucion 2 1,907.23 3,814.46\n", "8 69975105 WZD-331 Refrigeradora ECOTT 465 IX 1 1,213.79 1,213.79\n", "9 79140840 OTH-462 Lavadora Semi-Automatica 1 531.04 531.04\n", "10 87800799 GBD-525 Refrigeradora Puertas Mágicas 6 2,700.95 16,205.70\n", "11 62566305 GXF-122 Televisor Ultra HDTV 5 1,110.16 5,550.80\n", "12 42928709 QIL-029 Mini componente Shake-5 4 2,990.55 11,962.20\n", "13 23928045 TKM-141 Cocina a gas Marsella 5 402.24 2,011.20\n", "14 32565207 TKM-141 Cocina a gas Marsella 4 402.24 1,608.96\n", "15 26290971 GKG-558 Horno Microondas MS2042D 3 1,674.24 5,022.72\n", "16 86402303 RBE-789 Televisor SMART TV 6 3,303.07 19,818.42\n", "17 48184351 KQA-580 Cocina Empotrable Glassy Plus 2 2,907.92 5,815.84\n", "18 85949265 VRR-793 Rack Giratorio 32/60 5 241.71 1,208.55\n", "19 15210391 DON-719 Secadora de Cabello SG-3035 2 360.69 721.38\n", "20 89429489 VCL-867 Cocina a gas Rubi 2 5 699.07 3,495.35\n", "21 35565959 JXD-139 Terma Evolucion Soltu 5 586.02 2,930.10\n", "22 96659352 KQQ-136 Impresora Laser EPSON 2 1,139.56 2,279.12\n", "23 62324793 XBD-314 Cocina a gas Fassina 3 1,444.90 4,334.70\n", "24 89863424 QRC-609 Camara de video EOS 3 1,806.66 5,419.98\n", "25 97403853 GBJ-693 Radio CD 0 314.20 0.00\n", "26 73185299 AVM-258 Cocina a gas Toscana 3 2,831.23 8,493.69\n", "27 15210391 AQS-362 Teclado Inalambrico USB 0 233.05 0.00\n", "28 45877001 KBY-991 Home Theater E4100 6 1,101.08 6,606.48\n", "Total ingresado: 131,828.97\n", "Total perdido por falta de stock: 17,310.04\n", "========================================================================================================================\n", "FECHA: 31/08/2023\n", " client_id product_id product_name qty_served price total\n", "1 35584593 SSD-176 Refrigeradora Linea Gallery 4 567.71 2,270.84\n", "2 73185299 OTH-462 Lavadora Semi-Automatica 3 531.04 1,593.12\n", "3 45783712 YUQ-590 Refrigeradora CoolStyle 395N Steel 2 1,979.07 3,958.14\n", "4 62324793 LDR-510 Mini componente ESX9 1 2,701.87 2,701.87\n", "5 37110873 QUU-384 Lavavajilla Blue Touch 1 2,545.54 2,545.54\n", "6 71463316 AWT-354 Galaxy Gear 4 3,409.22 13,636.88\n", "7 46462527 LWG-915 Cocina a gas Murano 6 1,101.47 6,608.82\n", "8 87800799 VRR-793 Rack Giratorio 32/60 2 241.71 483.42\n", "9 25171011 AWB-345 Deshumedecedor DM-189H 0 800.37 0.00\n", "10 22777006 FCN-617 Televisor Plasma 60 1 4,121.05 4,121.05\n", "11 90237332 QFP-254 Calentador electrico instantaneo 3 180.65 541.95\n", "12 48467976 JDQ-505 Lavadora Modelo Aquamatic 5 1,572.31 7,861.55\n", "13 45828535 XSD-310 Refrigeradora No frost 4 2,259.93 9,039.72\n", "14 90365520 KBY-991 Home Theater E4100 6 1,101.08 6,606.48\n", "15 54716824 UDR-957 Refrigeradora ECOTT 423 IXL 1 861.70 861.70\n", "16 37110873 VDD-853 Deshumedecedor FAD30D7TSSW 3.4L 25-30m2 4 1,095.67 4,382.68\n", "17 54716824 ZEX-027 Tablet Xperia Z 6 3,843.75 23,062.50\n", "18 81114108 DFF-034 Grabadora de voz digital portatil con USB inte... 5 259.25 1,296.25\n", "19 64394265 OFS-384 Parlantes Bluetooth 4 805.22 3,220.88\n", "20 42798099 CNN-411 Congeladora Side by Side 6 2,296.29 13,777.74\n", "21 13245501 QIL-029 Mini componente Shake-5 2 2,990.55 5,981.10\n", "22 86402303 HFM-021 Horno Electrico 6 726.91 4,361.46\n", "23 89148118 EBI-299 Cocina a gas Fridare 0 2,287.57 0.00\n", "24 87813843 OQI-373 Cocina Empotrable Premio Plus 1 906.16 906.16\n", "25 93845419 QIL-029 Mini componente Shake-5 5 2,990.55 14,952.75\n", "26 67418025 FEG-454 Sillon masajeador 2 1,695.70 3,391.40\n", "27 69975105 TMJ-043 Lavadora EcoBubble 6 2,400.79 14,404.74\n", "28 97403853 YJD-279 Cocina a gas Florencia 3 1,028.43 3,085.29\n", "Total ingresado: 155,654.03\n", "Total perdido por falta de stock: 29,960.03\n", "========================================================================================================================\n", "FECHA: 01/09/2023\n", " client_id product_id product_name qty_served price total\n", "1 28390487 GLC-370 Video Proyector Power Lite 95 2 552.24 1,104.48\n", "2 84165595 DFJ-952 Cocina a gas Prestige 60 INOX 1 3,342.77 3,342.77\n", "3 50365593 LWG-915 Cocina a gas Murano 3 1,101.47 3,304.41\n", "4 83236386 UJV-290 Cocina a gas Fassina Plus 5 2,423.26 12,116.30\n", "5 73185299 QHC-492 Terma Solucion 3 1,907.23 5,721.69\n", "6 13245501 VXS-438 Mouse Blue Tooth 3 60.11 180.33\n", "7 42798099 TMN-884 Secadora de mano 5 310.65 1,553.25\n", "8 32904023 DUG-251 Cocina a gas FFG3047SL 4 1,597.96 6,391.84\n", "9 96659352 ADX-669 Refrigeradora cap. 220 litros 4 1,239.38 4,957.52\n", "10 89148118 AFL-718 Vinera 0 1,664.97 0.00\n", "11 77191257 QVJ-982 Horno Microondas 0.7 p3 5 1,352.76 6,763.80\n", "12 91897732 XZR-640 Lavadora-Secadora FWD 5 2,390.58 11,952.90\n", "13 93160528 YYU-726 Reproductor DVD Portatil 1 767.82 767.82\n", "14 89298238 UJV-290 Cocina a gas Fassina Plus 4 2,423.26 9,693.04\n", "15 43488351 DIQ-718 Horno Microondas de Conveccion Cello 0 390.80 0.00\n", "16 78078115 FQG-293 Rapiducha Premiun 4 2,784.31 11,137.24\n", "17 43043986 SSD-176 Refrigeradora Linea Gallery 5 567.71 2,838.55\n", "18 40348917 BMJ-772 Refrigeradora Side by Side 1 936.32 936.32\n", "19 78922174 XBD-314 Cocina a gas Fassina 3 1,444.90 4,334.70\n", "20 35565959 BZS-261 Cocina a gas Trento 1 3,087.87 3,087.87\n", "21 87813843 XSD-310 Refrigeradora No frost 3 2,259.93 6,779.79\n", "22 17913944 DEN-125 Rack Fijo 26/32 1 562.46 562.46\n", "23 79420973 SSE-115 Refrigeradora CoolStyle 311N Steel 5 3,243.58 16,217.90\n", "24 16151792 IDO-503 Laptop GamerVictus de 15.6 6 3,935.17 23,611.02\n", "25 22280452 UCX-285 Galaxy Tab 3 3 3,290.93 9,872.79\n", "26 71984468 TZY-323 Terma a gas 1 2,341.01 2,341.01\n", "27 19829266 RDT-761 Horno Microondas con dorador 3 904.95 2,714.85\n", "28 86241107 UXG-019 Terma de acumulacion 2 934.91 1,869.82\n", "29 84165595 HFM-021 Horno Electrico 6 726.91 4,361.46\n", "30 31611146 FVQ-662 Cocina a gas Pro 6300 INOX 4 1,060.68 4,242.72\n", "31 77191257 ZEX-027 Tablet Xperia Z 6 3,843.75 23,062.50\n", "32 41036366 QVJ-982 Horno Microondas 0.7 p3 1 1,352.76 1,352.76\n", "33 79140840 JXD-139 Terma Evolucion Soltu 4 586.02 2,344.08\n", "34 49087435 III-576 Campana Extractora Venus Plus 2 1,077.65 2,155.30\n", "Total ingresado: 191,673.29\n", "Total perdido por falta de stock: 8,068.05\n", "========================================================================================================================\n", "FECHA: 02/09/2023\n", " client_id product_id product_name qty_served price total\n", "1 86828079 QIL-029 Mini componente Shake-5 5 2,990.55 14,952.75\n", "2 79901434 OBI-353 Terma Milenium 6 2,960.56 17,763.36\n", "3 20864087 BXY-119 Cocina Empotrable Klimatica 4 2,716.11 10,864.44\n", "4 37110873 SSD-176 Refrigeradora Linea Gallery 1 567.71 567.71\n", "5 41036366 SJD-818 Refrigeradora CoolStyle 281A Steel 4 3,387.75 13,551.00\n", "6 98140264 BRD-969 Centro de Lavado Electrico 1 2,579.72 2,579.72\n", "7 84165595 RDT-761 Horno Microondas con dorador 6 904.95 5,429.70\n", "8 50365593 JDC-028 Puntero Laser 6 30.48 182.88\n", "9 15210391 TZY-323 Terma a gas 3 2,341.01 7,023.03\n", "10 95161027 III-576 Campana Extractora Venus Plus 5 1,077.65 5,388.25\n", "11 20864087 JFC-432 DVD DVM-L79 1 307.67 307.67\n", "12 50375303 AFL-718 Vinera 1 1,664.97 1,664.97\n", "13 42928709 OQI-373 Cocina Empotrable Premio Plus 5 906.16 4,530.80\n", "14 43053402 MMA-577 Congeladora Horizontal 252 Lts. 6 1,780.30 10,681.80\n", "15 78922174 EJW-346 Campana Extractora 6 359.70 2,158.20\n", "16 98140264 CJE-310 Mini componente GPX33 3 3,643.39 10,930.17\n", "17 94080926 TXM-139 Televisor LED FULL HD 3D 2 1,092.95 2,185.90\n", "18 20864087 JDQ-505 Lavadora Modelo Aquamatic 6 1,572.31 9,433.86\n", "19 66409237 DFF-034 Grabadora de voz digital portatil con USB inte... 4 259.25 1,037.00\n", "20 66409237 AWT-354 Galaxy Gear 6 3,409.22 20,455.32\n", "21 88956889 MYC-756 Cocina a gas Leganza INOX 4 1,506.80 6,027.20\n", "22 24995742 DON-719 Secadora de Cabello SG-3035 3 360.69 1,082.07\n", "23 88956889 UWA-476 Autoradio MEX BT3150U 6 1,191.39 7,148.34\n", "24 32904023 QFP-254 Calentador electrico instantaneo 4 180.65 722.60\n", "25 89298238 YOT-530 Deshumedecedor DM-190H 4 941.73 3,766.92\n", "26 79372768 GLC-370 Video Proyector Power Lite 95 4 552.24 2,208.96\n", "27 32821689 MTF-868 Impresora Monocromatica WorkForce M205 4 971.59 3,886.36\n", "28 59407188 LYZ-614 Impresore Mutifuncional Expression XP-211 3 3,510.84 10,532.52\n", "29 55552996 QTK-083 Congeladora Conservador Vertical 476 Lts. 1 2,682.73 2,682.73\n", "30 50365593 TMN-884 Secadora de mano 0 310.65 0.00\n", "31 15210391 VXS-438 Mouse Blue Tooth 4 60.11 240.44\n", "32 33397650 VJI-529 Horno Empotrable Electrico 6 1,102.67 6,616.02\n", "33 13245501 BXY-119 Cocina Empotrable Klimatica 5 2,716.11 13,580.55\n", "34 69324480 DIQ-718 Horno Microondas de Conveccion Cello 0 390.80 0.00\n", "35 78078115 DFJ-952 Cocina a gas Prestige 60 INOX 5 3,342.77 16,713.85\n", "36 29337157 HFM-021 Horno Electrico 4 726.91 2,907.64\n", "37 77191257 KWP-672 Televisor UHD TV 2 1,625.30 3,250.60\n", "38 89863424 FVB-607 Cocina a gas Essenza BL 1 2,953.07 2,953.07\n", "39 79420973 GXF-122 Televisor Ultra HDTV 3 1,110.16 3,330.48\n", "40 33713901 UWA-476 Autoradio MEX BT3150U 2 1,191.39 2,382.78\n", "41 90237332 TKM-141 Cocina a gas Marsella 3 402.24 1,206.72\n", "42 89429489 BXY-119 Cocina Empotrable Klimatica 0 2,716.11 0.00\n", "43 90365520 VDD-853 Deshumedecedor FAD30D7TSSW 3.4L 25-30m2 5 1,095.67 5,478.35\n", "44 79372768 EUZ-452 Impresora Mutifuncional Led Color 3 3,623.88 10,871.64\n", "45 53166028 TXM-139 Televisor LED FULL HD 3D 0 1,092.95 0.00\n", "46 45783712 SSD-176 Refrigeradora Linea Gallery 2 567.71 1,135.42\n", "47 57263719 DOV-560 Impresora Laser Mutifuncion Monocromatica 1 1,203.14 1,203.14\n", "48 40348917 DFJ-952 Cocina a gas Prestige 60 INOX 1 3,342.77 3,342.77\n", "49 79140840 QRC-609 Camara de video EOS 5 1,806.66 9,033.30\n", "Total ingresado: 263,993.00\n", "Total perdido por falta de stock: 34,403.11\n", "========================================================================================================================\n", "FECHA: 03/09/2023\n", " client_id product_id product_name qty_served price total\n", "1 50375303 CRU-009 Lavavajilla 5 2,655.78 13,278.90\n", "2 26290971 PVZ-181 Ventilador circular 3 309.77 929.31\n", "3 73535476 FLJ-040 Parlantes portatiles SOUNDSHOOTER 4 3,703.37 14,813.48\n", "4 16552775 AWB-345 Deshumedecedor DM-189H 5 800.37 4,001.85\n", "5 73535476 UWA-476 Autoradio MEX BT3150U 5 1,191.39 5,956.95\n", "6 95751208 UOD-420 Mini componente ESX6 4 828.94 3,315.76\n", "7 15561764 GBJ-693 Radio CD 2 314.20 628.40\n", "8 43043986 ZEX-027 Tablet Xperia Z 1 3,843.75 3,843.75\n", "9 96258632 CRU-009 Lavavajilla 0 2,655.78 0.00\n", "10 79901434 ZEX-027 Tablet Xperia Z 2 3,843.75 7,687.50\n", "11 12663268 YYU-726 Reproductor DVD Portatil 4 767.82 3,071.28\n", "12 71378466 FVQ-662 Cocina a gas Pro 6300 INOX 2 1,060.68 2,121.36\n", "13 26976877 VTV-269 Extractor de aire 4 854.48 3,417.92\n", "14 42798099 OQI-373 Cocina Empotrable Premio Plus 2 906.16 1,812.32\n", "15 23928045 TMN-884 Secadora de mano 2 310.65 621.30\n", "16 69324480 UOD-420 Mini componente ESX6 3 828.94 2,486.82\n", "17 59407188 OWN-701 Olla arrocera 1 220.82 220.82\n", "18 57263719 OTH-462 Lavadora Semi-Automatica 5 531.04 2,655.20\n", "19 37110873 FCN-617 Televisor Plasma 60 5 4,121.05 20,605.25\n", "20 96659352 GBJ-693 Radio CD 3 314.20 942.60\n", "21 52097922 UTN-601 Autoradio XAV-601 BT 2 562.51 1,125.02\n", "22 79901434 CSZ-863 Video Filmadora 5 1,713.57 8,567.85\n", "23 89429489 UXG-019 Terma de acumulacion 0 934.91 0.00\n", "24 52097922 XSD-310 Refrigeradora No frost 2 2,259.93 4,519.86\n", "25 33713901 VVS-017 Tablets MW 0731 1 2,599.72 2,599.72\n", "26 62566305 AVM-258 Cocina a gas Toscana 1 2,831.23 2,831.23\n", "27 32904023 RBE-789 Televisor SMART TV 6 3,303.07 19,818.42\n", "28 99842319 DUG-251 Cocina a gas FFG3047SL 1 1,597.96 1,597.96\n", "29 40112594 FVQ-662 Cocina a gas Pro 6300 INOX 0 1,060.68 0.00\n", "30 16151792 AQS-362 Teclado Inalambrico USB 1 233.05 233.05\n", "31 52097922 XZG-521 Secadora Electrica FAQE7001LW 4 704.27 2,817.08\n", "32 54761731 OTS-581 Galaxy Note 8.0 5 2,653.10 13,265.50\n", "Total ingresado: 149,786.46\n", "Total perdido por falta de stock: 26,048.29\n", "========================================================================================================================\n", "FECHA: 04/09/2023\n", " client_id product_id product_name qty_served price total\n", "1 33397650 IHG-413 Parlant Y pedestal PAM-83 3 317.70 953.10\n", "2 69324480 JCW-489 Conservadora Exibidora CMVE-250 5 2,064.97 10,324.85\n", "3 50375303 KQA-580 Cocina Empotrable Glassy Plus 5 2,907.92 14,539.60\n", "4 32565207 IDO-503 Laptop GamerVictus de 15.6 6 3,935.17 23,611.02\n", "5 63437380 III-576 Campana Extractora Venus Plus 5 1,077.65 5,388.25\n", "6 91897732 TMN-884 Secadora de mano 2 310.65 621.30\n", "7 31611146 YOT-530 Deshumedecedor DM-190H 4 941.73 3,766.92\n", "8 85949265 JFC-432 DVD DVM-L79 4 307.67 1,230.68\n", "9 12663268 RAH-420 Cocina a gas Pro 6550 INOX 3 157.01 471.03\n", "10 88956889 YUQ-590 Refrigeradora CoolStyle 395N Steel 2 1,979.07 3,958.14\n", "11 38913831 BCN-855 Cocina a gas Bahia Can 3 4,015.92 12,047.76\n", "12 44229880 JXD-139 Terma Evolucion Soltu 4 586.02 2,344.08\n", "13 42928709 XLF-273 Centro de Lavado a Gas 4 2,371.95 9,487.80\n", "14 88956889 UWA-476 Autoradio MEX BT3150U 3 1,191.39 3,574.17\n", "15 66409237 BRD-969 Centro de Lavado Electrico 3 2,579.72 7,739.16\n", "16 42928709 QFP-254 Calentador electrico instantaneo 5 180.65 903.25\n", "17 26233063 UWA-476 Autoradio MEX BT3150U 1 1,191.39 1,191.39\n", "18 35565959 QRC-609 Camara de video EOS 5 1,806.66 9,033.30\n", "19 50375303 YJD-279 Cocina a gas Florencia 5 1,028.43 5,142.15\n", "20 27912250 QFR-958 Cocina a gas Bavaro 3 1,607.46 4,822.38\n", "21 88995291 MTF-868 Impresora Monocromatica WorkForce M205 0 971.59 0.00\n", "22 69975105 FQG-293 Rapiducha Premiun 5 2,784.31 13,921.55\n", "23 76388967 PFD-286 Refrigeradora cap. 415 litros 2 2,776.02 5,552.04\n", "24 77191257 ZWF-661 Impresora Led 0 2,731.61 0.00\n", "25 91897732 PFD-286 Refrigeradora cap. 415 litros 0 2,776.02 0.00\n", "26 36380447 HLR-109 Parlantes inalambricos 2 439.47 878.94\n", "27 50375303 VXS-438 Mouse Blue Tooth 4 60.11 240.44\n", "28 25171011 DFJ-952 Cocina a gas Prestige 60 INOX 4 3,342.77 13,371.08\n", "29 48184351 TXM-139 Televisor LED FULL HD 3D 0 1,092.95 0.00\n", "30 45783712 YMU-875 Cocina a gas Plermo Quarzo 1 3,232.10 3,232.10\n", "31 94080926 SPR-580 Dispensador de Agua 5 404.35 2,021.75\n", "Total ingresado: 160,368.23\n", "Total perdido por falta de stock: 41,286.58\n", "========================================================================================================================\n", "FECHA: 05/09/2023\n", " client_id product_id product_name qty_served price total\n", "1 60574154 BWD-036 Cocina Empotrable Klimatica 2 1,086.34 2,172.68\n", "2 13245501 XOA-735 Congeladora Vertical 392 Lts. 5 2,708.07 13,540.35\n", "3 46462527 KCO-488 Ventilador de pared 4 679.60 2,718.40\n", "4 93845419 CIM-038 Cocina Empotrable Petra 5 2,544.64 12,723.20\n", "5 63437380 KQA-580 Cocina Empotrable Glassy Plus 2 2,907.92 5,815.84\n", "6 54716824 SPR-580 Dispensador de Agua 3 404.35 1,213.05\n", "7 55552996 UXG-019 Terma de acumulacion 6 934.91 5,609.46\n", "8 42798099 AQS-362 Teclado Inalambrico USB 1 233.05 233.05\n", "9 80048864 RDT-761 Horno Microondas con dorador 5 904.95 4,524.75\n", "10 43877279 TYF-885 Videojuego TW 4 0 794.14 0.00\n", "11 98589725 VRR-793 Rack Giratorio 32/60 1 241.71 241.71\n", "12 22280452 XSD-310 Refrigeradora No frost 2 2,259.93 4,519.86\n", "13 16151792 TZY-323 Terma a gas 3 2,341.01 7,023.03\n", "14 89298238 JXD-139 Terma Evolucion Soltu 3 586.02 1,758.06\n", "15 12663268 BMJ-772 Refrigeradora Side by Side 1 936.32 936.32\n", "16 64394265 YUQ-590 Refrigeradora CoolStyle 395N Steel 1 1,979.07 1,979.07\n", "17 76388967 DOV-560 Impresora Laser Mutifuncion Monocromatica 2 1,203.14 2,406.28\n", "18 69324480 VJI-529 Horno Empotrable Electrico 1 1,102.67 1,102.67\n", "19 73914283 BRD-969 Centro de Lavado Electrico 3 2,579.72 7,739.16\n", "20 62566305 CNQ-172 Congeladora Horizontal 364 Lts. 3 3,689.62 11,068.86\n", "21 13245501 KJX-387 Ventilador de techo 0 613.19 0.00\n", "22 89298238 ICX-503 Cocina a gas Roma 3 1,221.02 3,663.06\n", "23 67418025 YYU-726 Reproductor DVD Portatil 6 767.82 4,606.92\n", "Total ingresado: 95,595.78\n", "Total perdido por falta de stock: 7,036.65\n", "========================================================================================================================\n" ] } ], "source": [ "# reporte\n", "\n", "df = pedidos.merge(productos, how='left', on='product_id')\n", "\n", "for date, t in df.groupby(\"date\"):\n", " print(\"FECHA: \", date.strftime('%d/%m/%Y'))\n", " t.index = t.reset_index().index + 1\n", " t['total'] = t['qty_served'] * t['price']\n", " print(t[['client_id', 'product_id', 'product_name', 'qty_served', 'price', 'total']])\n", "\n", " served_income = sum(t['total'])\n", " not_served_income = sum((t['qty'] - t['qty_served']) * t['price'])\n", " print(f\"Total ingresado: {served_income:,.2f}\")\n", " print(f\"Total perdido por falta de stock: {not_served_income:,.2f}\")\n", " print('========================================================================================================================')" ] }, { "cell_type": "code", "execution_count": 8, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
product_namepricestock
product_id
BIT-434Campana Extractora modelo Glass375.090
SSE-115Refrigeradora CoolStyle 311N Steel3,243.5810
NMV-644Lavadora Automatica3,272.480
MLE-193Cocina a gas Ingenious2,779.416
YYK-309Refrigeradora Door in Door4,079.4413
............
QFP-254Calentador electrico instantaneo180.650
DUG-251Cocina a gas FFG3047SL1,597.960
III-576Campana Extractora Venus Plus1,077.655
IHG-413Parlant Y pedestal PAM-83317.706
QQB-968Refrigeradora 484 litros1,452.929
\n", "

167 rows × 3 columns

\n", "
" ], "text/plain": [ " product_name price stock\n", "product_id \n", "BIT-434 Campana Extractora modelo Glass 375.09 0\n", "SSE-115 Refrigeradora CoolStyle 311N Steel 3,243.58 10\n", "NMV-644 Lavadora Automatica 3,272.48 0\n", "MLE-193 Cocina a gas Ingenious 2,779.41 6\n", "YYK-309 Refrigeradora Door in Door 4,079.44 13\n", "... ... ... ...\n", "QFP-254 Calentador electrico instantaneo 180.65 0\n", "DUG-251 Cocina a gas FFG3047SL 1,597.96 0\n", "III-576 Campana Extractora Venus Plus 1,077.65 5\n", "IHG-413 Parlant Y pedestal PAM-83 317.70 6\n", "QQB-968 Refrigeradora 484 litros 1,452.92 9\n", "\n", "[167 rows x 3 columns]" ] }, "execution_count": 8, "metadata": {}, "output_type": "execute_result" } ], "source": [ "productos" ] } ], "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 }