path: root/2023-2/L04/mitsuo/simple.ipynb

{
 "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
}