stld.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 8,
   "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>Timestamp</th>\n",
       "      <th>uniqueId</th>\n",
       "      <th>kind</th>\n",
       "      <th>key</th>\n",
       "      <th>major</th>\n",
       "      <th>minor</th>\n",
       "      <th>side</th>\n",
       "      <th>receiptNumber</th>\n",
       "      <th>fpReceiptNumber</th>\n",
       "      <th>fpFiscalReceiptNumber</th>\n",
       "      <th>booth</th>\n",
       "      <th>saleType</th>\n",
       "      <th>totalAmount</th>\n",
       "      <th>nonProductAmount</th>\n",
       "      <th>totalTax</th>\n",
       "      <th>nonProductTax</th>\n",
       "      <th>orderSrc</th>\n",
       "      <th>startSaleDate</th>\n",
       "      <th>startSaleTime</th>\n",
       "      <th>endSaleDate</th>\n",
       "      <th>endSaleTime</th>\n",
       "      <th>totalTaxableAmount</th>\n",
       "      <th>totalChargedTaxAmount</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>20221203042342891</td>\n",
       "      <td>1ln8nw5c6j</td>\n",
       "      <td>Sale</td>\n",
       "      <td>POS0002:354760807</td>\n",
       "      <td>35403</td>\n",
       "      <td>0</td>\n",
       "      <td>M-S1 CBCS1 RTM-S1</td>\n",
       "      <td>03</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>EatIn</td>\n",
       "      <td>1.700</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.155</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0</td>\n",
       "      <td>20221203</td>\n",
       "      <td>042342</td>\n",
       "      <td>20221203</td>\n",
       "      <td>042513</td>\n",
       "      <td>1.700</td>\n",
       "      <td>0.155</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>20221203042529214</td>\n",
       "      <td>1ln8nw5c6k</td>\n",
       "      <td>Sale</td>\n",
       "      <td>POS0002:354760808</td>\n",
       "      <td>35404</td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "      <td>04</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>TakeOut</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0</td>\n",
       "      <td>20221203</td>\n",
       "      <td>042529</td>\n",
       "      <td>20221203</td>\n",
       "      <td>042541</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>20221203042557605</td>\n",
       "      <td>1ln8nw5c6l</td>\n",
       "      <td>Sale</td>\n",
       "      <td>POS0002:354760809</td>\n",
       "      <td>35405</td>\n",
       "      <td>0</td>\n",
       "      <td>M-S1 CBCS1 RTM-S1</td>\n",
       "      <td>05</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>EatIn</td>\n",
       "      <td>1.700</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.155</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>20221203</td>\n",
       "      <td>042557</td>\n",
       "      <td>20221203</td>\n",
       "      <td>042714</td>\n",
       "      <td>1.700</td>\n",
       "      <td>0.155</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>20221203042722621</td>\n",
       "      <td>1ln8nw5c6m</td>\n",
       "      <td>Sale</td>\n",
       "      <td>POS0002:354760810</td>\n",
       "      <td>35406</td>\n",
       "      <td>0</td>\n",
       "      <td>M-S1 CBCS1</td>\n",
       "      <td>06</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>EatIn</td>\n",
       "      <td>2.500</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.228</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>20221203</td>\n",
       "      <td>042722</td>\n",
       "      <td>20221203</td>\n",
       "      <td>043049</td>\n",
       "      <td>1.800</td>\n",
       "      <td>0.164</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2022120304374630</td>\n",
       "      <td>1ln8nw5c6n</td>\n",
       "      <td>Sale</td>\n",
       "      <td>POS0002:354760811</td>\n",
       "      <td>35407</td>\n",
       "      <td>0</td>\n",
       "      <td>M-S1</td>\n",
       "      <td>07</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>TakeOut</td>\n",
       "      <td>0.700</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.064</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>20221203</td>\n",
       "      <td>043746</td>\n",
       "      <td>20221203</td>\n",
       "      <td>043817</td>\n",
       "      <td>0.700</td>\n",
       "      <td>0.064</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2041</th>\n",
       "      <td>20221203201953622</td>\n",
       "      <td>1m0dnmb2px</td>\n",
       "      <td>Sale</td>\n",
       "      <td>POS0027:998525212</td>\n",
       "      <td>35586</td>\n",
       "      <td>0</td>\n",
       "      <td>M-S1 CBCS1</td>\n",
       "      <td>86</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>TakeOut</td>\n",
       "      <td>3.300</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.300</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>20221203</td>\n",
       "      <td>201953</td>\n",
       "      <td>20221203</td>\n",
       "      <td>202100</td>\n",
       "      <td>2.200</td>\n",
       "      <td>0.199</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2042</th>\n",
       "      <td>20221203221831972</td>\n",
       "      <td>1m0dnmb2pj</td>\n",
       "      <td>Sale</td>\n",
       "      <td>POS0027:998525213</td>\n",
       "      <td>35630</td>\n",
       "      <td>0</td>\n",
       "      <td>M-S1 CBCS1 RTM-S1</td>\n",
       "      <td>30</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>EatIn</td>\n",
       "      <td>3.400</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.310</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>20221203</td>\n",
       "      <td>221831</td>\n",
       "      <td>20221203</td>\n",
       "      <td>222321</td>\n",
       "      <td>2.300</td>\n",
       "      <td>0.210</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2043</th>\n",
       "      <td>20221203222504585</td>\n",
       "      <td>1m0dnmb2pk</td>\n",
       "      <td>Sale</td>\n",
       "      <td>POS0027:998525214</td>\n",
       "      <td>35631</td>\n",
       "      <td>0</td>\n",
       "      <td>M-S1</td>\n",
       "      <td>31</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>EatIn</td>\n",
       "      <td>1.200</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.110</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>20221203</td>\n",
       "      <td>222504</td>\n",
       "      <td>20221203</td>\n",
       "      <td>222614</td>\n",
       "      <td>1.200</td>\n",
       "      <td>0.110</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2044</th>\n",
       "      <td>20221203222854180</td>\n",
       "      <td>1m0dnmb2pl</td>\n",
       "      <td>Sale</td>\n",
       "      <td>POS0027:998525215</td>\n",
       "      <td>35635</td>\n",
       "      <td>0</td>\n",
       "      <td>CBCS1</td>\n",
       "      <td>35</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>EatIn</td>\n",
       "      <td>1.000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.091</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>20221203</td>\n",
       "      <td>222854</td>\n",
       "      <td>20221203</td>\n",
       "      <td>222950</td>\n",
       "      <td>1.000</td>\n",
       "      <td>0.091</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2045</th>\n",
       "      <td>20221203230801309</td>\n",
       "      <td>1m0dnmb2pm</td>\n",
       "      <td>Sale</td>\n",
       "      <td>POS0027:998525216</td>\n",
       "      <td>35648</td>\n",
       "      <td>0</td>\n",
       "      <td>M-S1 CBCS1</td>\n",
       "      <td>48</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>EatIn</td>\n",
       "      <td>2.100</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.191</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>20221203</td>\n",
       "      <td>230801</td>\n",
       "      <td>20221203</td>\n",
       "      <td>230909</td>\n",
       "      <td>1.400</td>\n",
       "      <td>0.127</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2046 rows × 23 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "              Timestamp    uniqueId  kind                key  major minor  \\\n",
       "0     20221203042342891  1ln8nw5c6j  Sale  POS0002:354760807  35403     0   \n",
       "1     20221203042529214  1ln8nw5c6k  Sale  POS0002:354760808  35404     0   \n",
       "2     20221203042557605  1ln8nw5c6l  Sale  POS0002:354760809  35405     0   \n",
       "3     20221203042722621  1ln8nw5c6m  Sale  POS0002:354760810  35406     0   \n",
       "4      2022120304374630  1ln8nw5c6n  Sale  POS0002:354760811  35407     0   \n",
       "...                 ...         ...   ...                ...    ...   ...   \n",
       "2041  20221203201953622  1m0dnmb2px  Sale  POS0027:998525212  35586     0   \n",
       "2042  20221203221831972  1m0dnmb2pj  Sale  POS0027:998525213  35630     0   \n",
       "2043  20221203222504585  1m0dnmb2pk  Sale  POS0027:998525214  35631     0   \n",
       "2044  20221203222854180  1m0dnmb2pl  Sale  POS0027:998525215  35635     0   \n",
       "2045  20221203230801309  1m0dnmb2pm  Sale  POS0027:998525216  35648     0   \n",
       "\n",
       "                    side receiptNumber fpReceiptNumber fpFiscalReceiptNumber  \\\n",
       "0     M-S1 CBCS1 RTM-S1             03               0                     0   \n",
       "1                                   04               0                     0   \n",
       "2     M-S1 CBCS1 RTM-S1             05               0                     0   \n",
       "3            M-S1 CBCS1             06               0                     0   \n",
       "4                  M-S1             07               0                     0   \n",
       "...                  ...           ...             ...                   ...   \n",
       "2041         M-S1 CBCS1             86               0                     0   \n",
       "2042  M-S1 CBCS1 RTM-S1             30               0                     0   \n",
       "2043               M-S1             31               0                     0   \n",
       "2044              CBCS1             35               0                     0   \n",
       "2045         M-S1 CBCS1             48               0                     0   \n",
       "\n",
       "     booth saleType totalAmount nonProductAmount totalTax nonProductTax  \\\n",
       "0        0    EatIn       1.700            0.000    0.155         0.000   \n",
       "1        0  TakeOut       0.000            0.000    0.000         0.000   \n",
       "2        0    EatIn       1.700             0.00    0.155          0.00   \n",
       "3        0    EatIn       2.500             0.00    0.228          0.00   \n",
       "4        0  TakeOut       0.700             0.00    0.064          0.00   \n",
       "...    ...      ...         ...              ...      ...           ...   \n",
       "2041     0  TakeOut       3.300             0.00    0.300          0.00   \n",
       "2042     0    EatIn       3.400             0.00    0.310          0.00   \n",
       "2043     0    EatIn       1.200             0.00    0.110          0.00   \n",
       "2044     0    EatIn       1.000             0.00    0.091          0.00   \n",
       "2045     0    EatIn       2.100             0.00    0.191          0.00   \n",
       "\n",
       "     orderSrc startSaleDate startSaleTime endSaleDate endSaleTime  \\\n",
       "0           0      20221203        042342    20221203      042513   \n",
       "1           0      20221203        042529    20221203      042541   \n",
       "2           0      20221203        042557    20221203      042714   \n",
       "3           0      20221203        042722    20221203      043049   \n",
       "4           0      20221203        043746    20221203      043817   \n",
       "...       ...           ...           ...         ...         ...   \n",
       "2041        0      20221203        201953    20221203      202100   \n",
       "2042        0      20221203        221831    20221203      222321   \n",
       "2043        0      20221203        222504    20221203      222614   \n",
       "2044        0      20221203        222854    20221203      222950   \n",
       "2045        0      20221203        230801    20221203      230909   \n",
       "\n",
       "     totalTaxableAmount totalChargedTaxAmount  \n",
       "0                 1.700                 0.155  \n",
       "1                 0.000                 0.000  \n",
       "2                 1.700                 0.155  \n",
       "3                 1.800                 0.164  \n",
       "4                 0.700                 0.064  \n",
       "...                 ...                   ...  \n",
       "2041              2.200                 0.199  \n",
       "2042              2.300                 0.210  \n",
       "2043              1.200                 0.110  \n",
       "2044              1.000                 0.091  \n",
       "2045              1.400                 0.127  \n",
       "\n",
       "[2046 rows x 23 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "import xml.etree.ElementTree as ET\n",
    "import pandas as pd\n",
    "# Set display options\n",
    "pd.set_option('display.max_columns', None)\n",
    "pd.set_option('display.width', None)\n",
    "# Load the XML file\n",
    "tree = ET.parse('3.xml')\n",
    "root = tree.getroot()\n",
    "\n",
    "# Initialize an empty list to store the extracted data\n",
    "data = []\n",
    "\n",
    "# Iterate through all TRX_Sale elements\n",
    "for trx_sale in root.findall(\".//TRX_Sale\"):\n",
    "    order_element = trx_sale.find(\".//Order\")\n",
    "    \n",
    "    if order_element is not None:\n",
    "        order_attributes = order_element.attrib\n",
    "        data.append(order_attributes)\n",
    "\n",
    "# Create a pandas DataFrame from the extracted data\n",
    "df = pd.DataFrame(data)\n",
    "\n",
    "# Display the DataFrame\n",
    "display(df)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "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>Timestamp</th>\n",
       "      <th>uniqueId</th>\n",
       "      <th>kind</th>\n",
       "      <th>key</th>\n",
       "      <th>major</th>\n",
       "      <th>minor</th>\n",
       "      <th>side</th>\n",
       "      <th>receiptNumber</th>\n",
       "      <th>fpReceiptNumber</th>\n",
       "      <th>fpFiscalReceiptNumber</th>\n",
       "      <th>booth</th>\n",
       "      <th>saleType</th>\n",
       "      <th>totalAmount</th>\n",
       "      <th>nonProductAmount</th>\n",
       "      <th>totalTax</th>\n",
       "      <th>nonProductTax</th>\n",
       "      <th>orderSrc</th>\n",
       "      <th>startSaleDate</th>\n",
       "      <th>startSaleTime</th>\n",
       "      <th>endSaleDate</th>\n",
       "      <th>endSaleTime</th>\n",
       "      <th>totalTaxableAmount</th>\n",
       "      <th>totalChargedTaxAmount</th>\n",
       "      <th>VATInvoiceNumber</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>20221203042342891</td>\n",
       "      <td>1ln8nw5c6j</td>\n",
       "      <td>Sale</td>\n",
       "      <td>POS0002:354760807</td>\n",
       "      <td>35403</td>\n",
       "      <td>0</td>\n",
       "      <td>M-S1 CBCS1 RTM-S1</td>\n",
       "      <td>03</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>EatIn</td>\n",
       "      <td>1.700</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.155</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0</td>\n",
       "      <td>20221203</td>\n",
       "      <td>042342</td>\n",
       "      <td>20221203</td>\n",
       "      <td>042513</td>\n",
       "      <td>1.700</td>\n",
       "      <td>0.155</td>\n",
       "      <td>70002002221203000001</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>20221203042529214</td>\n",
       "      <td>1ln8nw5c6k</td>\n",
       "      <td>Sale</td>\n",
       "      <td>POS0002:354760808</td>\n",
       "      <td>35404</td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "      <td>04</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>TakeOut</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0</td>\n",
       "      <td>20221203</td>\n",
       "      <td>042529</td>\n",
       "      <td>20221203</td>\n",
       "      <td>042541</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>70002002221203000002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>20221203042557605</td>\n",
       "      <td>1ln8nw5c6l</td>\n",
       "      <td>Sale</td>\n",
       "      <td>POS0002:354760809</td>\n",
       "      <td>35405</td>\n",
       "      <td>0</td>\n",
       "      <td>M-S1 CBCS1 RTM-S1</td>\n",
       "      <td>05</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>EatIn</td>\n",
       "      <td>1.700</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.155</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>20221203</td>\n",
       "      <td>042557</td>\n",
       "      <td>20221203</td>\n",
       "      <td>042714</td>\n",
       "      <td>1.700</td>\n",
       "      <td>0.155</td>\n",
       "      <td>70002002221203000003</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>20221203042722621</td>\n",
       "      <td>1ln8nw5c6m</td>\n",
       "      <td>Sale</td>\n",
       "      <td>POS0002:354760810</td>\n",
       "      <td>35406</td>\n",
       "      <td>0</td>\n",
       "      <td>M-S1 CBCS1</td>\n",
       "      <td>06</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>EatIn</td>\n",
       "      <td>2.500</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.228</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>20221203</td>\n",
       "      <td>042722</td>\n",
       "      <td>20221203</td>\n",
       "      <td>043049</td>\n",
       "      <td>1.800</td>\n",
       "      <td>0.164</td>\n",
       "      <td>70002002221203000004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2022120304374630</td>\n",
       "      <td>1ln8nw5c6n</td>\n",
       "      <td>Sale</td>\n",
       "      <td>POS0002:354760811</td>\n",
       "      <td>35407</td>\n",
       "      <td>0</td>\n",
       "      <td>M-S1</td>\n",
       "      <td>07</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>TakeOut</td>\n",
       "      <td>0.700</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.064</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>20221203</td>\n",
       "      <td>043746</td>\n",
       "      <td>20221203</td>\n",
       "      <td>043817</td>\n",
       "      <td>0.700</td>\n",
       "      <td>0.064</td>\n",
       "      <td>70002002221203000005</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2041</th>\n",
       "      <td>20221203201953622</td>\n",
       "      <td>1m0dnmb2px</td>\n",
       "      <td>Sale</td>\n",
       "      <td>POS0027:998525212</td>\n",
       "      <td>35586</td>\n",
       "      <td>0</td>\n",
       "      <td>M-S1 CBCS1</td>\n",
       "      <td>86</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>TakeOut</td>\n",
       "      <td>3.300</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.300</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>20221203</td>\n",
       "      <td>201953</td>\n",
       "      <td>20221203</td>\n",
       "      <td>202100</td>\n",
       "      <td>2.200</td>\n",
       "      <td>0.199</td>\n",
       "      <td>70002027221203000006</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2042</th>\n",
       "      <td>20221203221831972</td>\n",
       "      <td>1m0dnmb2pj</td>\n",
       "      <td>Sale</td>\n",
       "      <td>POS0027:998525213</td>\n",
       "      <td>35630</td>\n",
       "      <td>0</td>\n",
       "      <td>M-S1 CBCS1 RTM-S1</td>\n",
       "      <td>30</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>EatIn</td>\n",
       "      <td>3.400</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.310</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>20221203</td>\n",
       "      <td>221831</td>\n",
       "      <td>20221203</td>\n",
       "      <td>222321</td>\n",
       "      <td>2.300</td>\n",
       "      <td>0.210</td>\n",
       "      <td>70002027221203000007</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2043</th>\n",
       "      <td>20221203222504585</td>\n",
       "      <td>1m0dnmb2pk</td>\n",
       "      <td>Sale</td>\n",
       "      <td>POS0027:998525214</td>\n",
       "      <td>35631</td>\n",
       "      <td>0</td>\n",
       "      <td>M-S1</td>\n",
       "      <td>31</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>EatIn</td>\n",
       "      <td>1.200</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.110</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>20221203</td>\n",
       "      <td>222504</td>\n",
       "      <td>20221203</td>\n",
       "      <td>222614</td>\n",
       "      <td>1.200</td>\n",
       "      <td>0.110</td>\n",
       "      <td>70002027221203000008</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2044</th>\n",
       "      <td>20221203222854180</td>\n",
       "      <td>1m0dnmb2pl</td>\n",
       "      <td>Sale</td>\n",
       "      <td>POS0027:998525215</td>\n",
       "      <td>35635</td>\n",
       "      <td>0</td>\n",
       "      <td>CBCS1</td>\n",
       "      <td>35</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>EatIn</td>\n",
       "      <td>1.000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.091</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>20221203</td>\n",
       "      <td>222854</td>\n",
       "      <td>20221203</td>\n",
       "      <td>222950</td>\n",
       "      <td>1.000</td>\n",
       "      <td>0.091</td>\n",
       "      <td>70002027221203000009</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2045</th>\n",
       "      <td>20221203230801309</td>\n",
       "      <td>1m0dnmb2pm</td>\n",
       "      <td>Sale</td>\n",
       "      <td>POS0027:998525216</td>\n",
       "      <td>35648</td>\n",
       "      <td>0</td>\n",
       "      <td>M-S1 CBCS1</td>\n",
       "      <td>48</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>EatIn</td>\n",
       "      <td>2.100</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.191</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>20221203</td>\n",
       "      <td>230801</td>\n",
       "      <td>20221203</td>\n",
       "      <td>230909</td>\n",
       "      <td>1.400</td>\n",
       "      <td>0.127</td>\n",
       "      <td>70002027221203000010</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2046 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "              Timestamp    uniqueId  kind                key  major minor  \\\n",
       "0     20221203042342891  1ln8nw5c6j  Sale  POS0002:354760807  35403     0   \n",
       "1     20221203042529214  1ln8nw5c6k  Sale  POS0002:354760808  35404     0   \n",
       "2     20221203042557605  1ln8nw5c6l  Sale  POS0002:354760809  35405     0   \n",
       "3     20221203042722621  1ln8nw5c6m  Sale  POS0002:354760810  35406     0   \n",
       "4      2022120304374630  1ln8nw5c6n  Sale  POS0002:354760811  35407     0   \n",
       "...                 ...         ...   ...                ...    ...   ...   \n",
       "2041  20221203201953622  1m0dnmb2px  Sale  POS0027:998525212  35586     0   \n",
       "2042  20221203221831972  1m0dnmb2pj  Sale  POS0027:998525213  35630     0   \n",
       "2043  20221203222504585  1m0dnmb2pk  Sale  POS0027:998525214  35631     0   \n",
       "2044  20221203222854180  1m0dnmb2pl  Sale  POS0027:998525215  35635     0   \n",
       "2045  20221203230801309  1m0dnmb2pm  Sale  POS0027:998525216  35648     0   \n",
       "\n",
       "                    side receiptNumber fpReceiptNumber fpFiscalReceiptNumber  \\\n",
       "0     M-S1 CBCS1 RTM-S1             03               0                     0   \n",
       "1                                   04               0                     0   \n",
       "2     M-S1 CBCS1 RTM-S1             05               0                     0   \n",
       "3            M-S1 CBCS1             06               0                     0   \n",
       "4                  M-S1             07               0                     0   \n",
       "...                  ...           ...             ...                   ...   \n",
       "2041         M-S1 CBCS1             86               0                     0   \n",
       "2042  M-S1 CBCS1 RTM-S1             30               0                     0   \n",
       "2043               M-S1             31               0                     0   \n",
       "2044              CBCS1             35               0                     0   \n",
       "2045         M-S1 CBCS1             48               0                     0   \n",
       "\n",
       "     booth saleType totalAmount nonProductAmount totalTax nonProductTax  \\\n",
       "0        0    EatIn       1.700            0.000    0.155         0.000   \n",
       "1        0  TakeOut       0.000            0.000    0.000         0.000   \n",
       "2        0    EatIn       1.700             0.00    0.155          0.00   \n",
       "3        0    EatIn       2.500             0.00    0.228          0.00   \n",
       "4        0  TakeOut       0.700             0.00    0.064          0.00   \n",
       "...    ...      ...         ...              ...      ...           ...   \n",
       "2041     0  TakeOut       3.300             0.00    0.300          0.00   \n",
       "2042     0    EatIn       3.400             0.00    0.310          0.00   \n",
       "2043     0    EatIn       1.200             0.00    0.110          0.00   \n",
       "2044     0    EatIn       1.000             0.00    0.091          0.00   \n",
       "2045     0    EatIn       2.100             0.00    0.191          0.00   \n",
       "\n",
       "     orderSrc startSaleDate startSaleTime endSaleDate endSaleTime  \\\n",
       "0           0      20221203        042342    20221203      042513   \n",
       "1           0      20221203        042529    20221203      042541   \n",
       "2           0      20221203        042557    20221203      042714   \n",
       "3           0      20221203        042722    20221203      043049   \n",
       "4           0      20221203        043746    20221203      043817   \n",
       "...       ...           ...           ...         ...         ...   \n",
       "2041        0      20221203        201953    20221203      202100   \n",
       "2042        0      20221203        221831    20221203      222321   \n",
       "2043        0      20221203        222504    20221203      222614   \n",
       "2044        0      20221203        222854    20221203      222950   \n",
       "2045        0      20221203        230801    20221203      230909   \n",
       "\n",
       "     totalTaxableAmount totalChargedTaxAmount      VATInvoiceNumber  \n",
       "0                 1.700                 0.155  70002002221203000001  \n",
       "1                 0.000                 0.000  70002002221203000002  \n",
       "2                 1.700                 0.155  70002002221203000003  \n",
       "3                 1.800                 0.164  70002002221203000004  \n",
       "4                 0.700                 0.064  70002002221203000005  \n",
       "...                 ...                   ...                   ...  \n",
       "2041              2.200                 0.199  70002027221203000006  \n",
       "2042              2.300                 0.210  70002027221203000007  \n",
       "2043              1.200                 0.110  70002027221203000008  \n",
       "2044              1.000                 0.091  70002027221203000009  \n",
       "2045              1.400                 0.127  70002027221203000010  \n",
       "\n",
       "[2046 rows x 24 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "import xml.etree.ElementTree as ET\n",
    "import pandas as pd\n",
    "# Set display options\n",
    "pd.set_option('display.max_columns', None)\n",
    "pd.set_option('display.width', None)\n",
    "# Load the XML file\n",
    "tree = ET.parse('3.xml')\n",
    "root = tree.getroot()\n",
    "# Initialize an empty list to store the extracted data\n",
    "data = []\n",
    "\n",
    "# Iterate through all TRX_Sale elements\n",
    "for trx_sale in root.findall(\".//TRX_Sale\"):\n",
    "    order_element = trx_sale.find(\".//Order\")\n",
    "    \n",
    "    if order_element is not None:\n",
    "        order_attributes = order_element.attrib\n",
    "        \n",
    "        custom_info_element = order_element.find(\".//CustomInfo\")\n",
    "        if custom_info_element is not None:\n",
    "            vat_invoice_info = custom_info_element.find(\"./Info[@name='VATInvoiceNumber']\")\n",
    "            if vat_invoice_info is not None:\n",
    "                order_attributes['VATInvoiceNumber'] = vat_invoice_info.attrib['value']\n",
    "        \n",
    "        data.append(order_attributes)\n",
    "\n",
    "# Create a pandas DataFrame from the extracted data\n",
    "df = pd.DataFrame(data)\n",
    "# Display the DataFrame\n",
    "display(df)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "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>TenderId</th>\n",
       "      <th>TenderName</th>\n",
       "      <th>TenderAmount</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>11</td>\n",
       "      <td>Cashless Common</td>\n",
       "      <td>1.700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>11</td>\n",
       "      <td>Cashless Common</td>\n",
       "      <td>1.700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>13</td>\n",
       "      <td>CashlesMasterCard</td>\n",
       "      <td>2.500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>13</td>\n",
       "      <td>CashlesMasterCard</td>\n",
       "      <td>0.700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0</td>\n",
       "      <td>Cash BHD</td>\n",
       "      <td>20.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1442</th>\n",
       "      <td>13</td>\n",
       "      <td>CashlesMasterCard</td>\n",
       "      <td>3.300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1443</th>\n",
       "      <td>13</td>\n",
       "      <td>CashlesMasterCard</td>\n",
       "      <td>3.400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1444</th>\n",
       "      <td>13</td>\n",
       "      <td>CashlesMasterCard</td>\n",
       "      <td>1.200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1445</th>\n",
       "      <td>13</td>\n",
       "      <td>CashlesMasterCard</td>\n",
       "      <td>1.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1446</th>\n",
       "      <td>13</td>\n",
       "      <td>CashlesMasterCard</td>\n",
       "      <td>2.100</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1447 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     TenderId         TenderName TenderAmount\n",
       "0          11    Cashless Common        1.700\n",
       "1          11    Cashless Common        1.700\n",
       "2          13  CashlesMasterCard        2.500\n",
       "3          13  CashlesMasterCard        0.700\n",
       "4           0           Cash BHD       20.000\n",
       "...       ...                ...          ...\n",
       "1442       13  CashlesMasterCard        3.300\n",
       "1443       13  CashlesMasterCard        3.400\n",
       "1444       13  CashlesMasterCard        1.200\n",
       "1445       13  CashlesMasterCard        1.000\n",
       "1446       13  CashlesMasterCard        2.100\n",
       "\n",
       "[1447 rows x 3 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "import xml.etree.ElementTree as ET\n",
    "import pandas as pd\n",
    "\n",
    "# Load the XML file\n",
    "tree = ET.parse('3.xml')\n",
    "root = tree.getroot()\n",
    "\n",
    "# Initialize an empty list to store the extracted tender data\n",
    "tenders_data = []\n",
    "\n",
    "# Iterate through all Tender elements\n",
    "for tender in root.findall(\".//Tender\"):\n",
    "    tender_data = {\n",
    "        'TenderId': tender.findtext('TenderId').strip(),\n",
    "        'TenderName': tender.findtext('TenderName').strip(),\n",
    "        'TenderAmount': tender.findtext('TenderAmount').strip()\n",
    "    }\n",
    "    tenders_data.append(tender_data)\n",
    "\n",
    "# Create a pandas DataFrame from the extracted tender data\n",
    "tenders_df = pd.DataFrame(tenders_data)\n",
    "\n",
    "# Display the tender DataFrame\n",
    "display(tenders_df)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "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>POS</th>\n",
       "      <th>POD</th>\n",
       "      <th>CheckRefund</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>POS0001</td>\n",
       "      <td>DLV</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>POS0002</td>\n",
       "      <td>FC</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>POS0011</td>\n",
       "      <td>DLV</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>POS0012</td>\n",
       "      <td>DLV</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>POS0018</td>\n",
       "      <td>DT</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>POS0019</td>\n",
       "      <td>DT</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>POS0020</td>\n",
       "      <td>DT</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>POS0025</td>\n",
       "      <td>CSO</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>POS0026</td>\n",
       "      <td>CSO</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>POS0027</td>\n",
       "      <td>CSO</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       POS  POD CheckRefund\n",
       "0  POS0001  DLV           1\n",
       "1  POS0002   FC           1\n",
       "2  POS0011  DLV           1\n",
       "3  POS0012  DLV           1\n",
       "4  POS0018   DT           1\n",
       "5  POS0019   DT           1\n",
       "6  POS0020   DT           1\n",
       "7  POS0025  CSO           1\n",
       "8  POS0026  CSO           1\n",
       "9  POS0027  CSO           1"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "import xml.etree.ElementTree as ET\n",
    "import pandas as pd\n",
    "\n",
    "# Load the XML file\n",
    "tree = ET.parse('3.xml')\n",
    "root = tree.getroot()\n",
    "\n",
    "# Initialize lists to store extracted data\n",
    "pos_list = []\n",
    "pod_list = []\n",
    "check_refund_list = []\n",
    "\n",
    "# Find all TRX_BaseConfig elements\n",
    "base_configs = root.findall(\".//TRX_BaseConfig\")\n",
    "\n",
    "# Iterate through each TRX_BaseConfig element\n",
    "for base_config in base_configs:\n",
    "    pos = base_config.get('POS')\n",
    "    pod = base_config.get('POD')\n",
    "    check_refund = base_config.find('Config/CheckRefund').text.strip()\n",
    "    \n",
    "    # Append data to respective lists\n",
    "    pos_list.append(pos)\n",
    "    pod_list.append(pod)\n",
    "    check_refund_list.append(check_refund)\n",
    "\n",
    "# Create a pandas DataFrame\n",
    "data = {'POS': pos_list, 'POD': pod_list, 'CheckRefund': check_refund_list}\n",
    "base_config_df = pd.DataFrame(data)\n",
    "\n",
    "# Display the base config DataFrame\n",
    "display(base_config_df)\n"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "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.2"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}