{ "cells": [ { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [], "source": [ "import pandas as pd\n", "import numpy as np\n", "import matplotlib.pyplot as plt\n", "import seaborn as sns" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [], "source": [ "reagent_prices = pd.read_excel('Prices for reagent 2023 2024 COMPLETE - edited.xlsx', skiprows=1)" ] }, { "cell_type": "code", "execution_count": 3, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
S/NMADE BYUnnamed: 2ODERING NUMBERPRODUCTSQTYUOMUNIT NGNTOTAL NGNCategory
01.0ROCHENaN10744948Reflotron Glucose 15 x 2 stripes /pkt80Pack45000NaNCLINICAL CHEMISTRY
1NaNROCHENaN10886874Reflotron Creatinine x30 stripes/pkt40Pack50000NaNCLINICAL CHEMISTRY
2NaNROCHENaN10745065Reflotron Cholesterol x30 stripes/pkt60Pack50000NaNCLINICAL CHEMISTRY
3NaNROCHENaN10745049Reflotron Triglycerides x30 stripes/pkt60Pack50000NaNCLINICAL CHEMISTRY
4NaNROCHENaN11208756Reflotron HDL Cholesterol x 30 stripes/pkt40Pack65000NaNCLINICAL CHEMISTRY
\n", "
" ], "text/plain": [ " S/N MADE BY Unnamed: 2 ODERING NUMBER \\\n", "0 1.0 ROCHE NaN 10744948 \n", "1 NaN ROCHE NaN 10886874 \n", "2 NaN ROCHE NaN 10745065 \n", "3 NaN ROCHE NaN 10745049 \n", "4 NaN ROCHE NaN 11208756 \n", "\n", " PRODUCTS QTY UOM UNIT NGN \\\n", "0 Reflotron Glucose 15 x 2 stripes /pkt 80 Pack 45000 \n", "1 Reflotron Creatinine x30 stripes/pkt 40 Pack 50000 \n", "2 Reflotron Cholesterol x30 stripes/pkt 60 Pack 50000 \n", "3 Reflotron Triglycerides x30 stripes/pkt 60 Pack 50000 \n", "4 Reflotron HDL Cholesterol x 30 stripes/pkt 40 Pack 65000 \n", "\n", " TOTAL NGN Category \n", "0 NaN CLINICAL CHEMISTRY \n", "1 NaN CLINICAL CHEMISTRY \n", "2 NaN CLINICAL CHEMISTRY \n", "3 NaN CLINICAL CHEMISTRY \n", "4 NaN CLINICAL CHEMISTRY " ] }, "execution_count": 3, "metadata": {}, "output_type": "execute_result" } ], "source": [ "reagent_prices.head()" ] }, { "cell_type": "code", "execution_count": 4, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "Index(['S/N', 'MADE BY', 'Unnamed: 2', 'ODERING NUMBER', 'PRODUCTS', 'QTY',\n", " 'UOM', 'UNIT NGN', 'TOTAL NGN', 'Category'],\n", " dtype='object')" ] }, "execution_count": 4, "metadata": {}, "output_type": "execute_result" } ], "source": [ "reagent_prices.columns" ] }, { "cell_type": "code", "execution_count": 5, "metadata": {}, "outputs": [], "source": [ "# selecting the columns that we need \n", "cols = ['PRODUCTS', 'QTY', 'UOM', 'UNIT NGN', 'TOTAL NGN', 'Category']\n", "reagent_prices_1 = reagent_prices[cols]" ] }, { "cell_type": "code", "execution_count": 6, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
PRODUCTSQTYUOMUNIT NGNTOTAL NGNCategory
0Reflotron Glucose 15 x 2 stripes /pkt80Pack45000NaNCLINICAL CHEMISTRY
1Reflotron Creatinine x30 stripes/pkt40Pack50000NaNCLINICAL CHEMISTRY
2Reflotron Cholesterol x30 stripes/pkt60Pack50000NaNCLINICAL CHEMISTRY
3Reflotron Triglycerides x30 stripes/pkt60Pack50000NaNCLINICAL CHEMISTRY
4Reflotron HDL Cholesterol x 30 stripes/pkt40Pack65000NaNCLINICAL CHEMISTRY
.....................
135Pyrix Beaker 1000ml10Pcs3500NaNGLASSWARES
136Pyrix Beaker 2000 ml10Pcs4900NaNGLASSWARES
137Conical Flask 250ml10Pcs1900NaNGLASSWARES
138Conical Flask 500ml10Pcs3500NaNGLASSWARES
139Conical Flask 1000ml10Pcs4900NaNGLASSWARES
\n", "

140 rows × 6 columns

\n", "
" ], "text/plain": [ " PRODUCTS QTY UOM UNIT NGN \\\n", "0 Reflotron Glucose 15 x 2 stripes /pkt 80 Pack 45000 \n", "1 Reflotron Creatinine x30 stripes/pkt 40 Pack 50000 \n", "2 Reflotron Cholesterol x30 stripes/pkt 60 Pack 50000 \n", "3 Reflotron Triglycerides x30 stripes/pkt 60 Pack 50000 \n", "4 Reflotron HDL Cholesterol x 30 stripes/pkt 40 Pack 65000 \n", ".. ... ... ... ... \n", "135 Pyrix Beaker 1000ml 10 Pcs 3500 \n", "136 Pyrix Beaker 2000 ml 10 Pcs 4900 \n", "137 Conical Flask 250ml 10 Pcs 1900 \n", "138 Conical Flask 500ml 10 Pcs 3500 \n", "139 Conical Flask 1000ml 10 Pcs 4900 \n", "\n", " TOTAL NGN Category \n", "0 NaN CLINICAL CHEMISTRY \n", "1 NaN CLINICAL CHEMISTRY \n", "2 NaN CLINICAL CHEMISTRY \n", "3 NaN CLINICAL CHEMISTRY \n", "4 NaN CLINICAL CHEMISTRY \n", ".. ... ... \n", "135 NaN GLASSWARES \n", "136 NaN GLASSWARES \n", "137 NaN GLASSWARES \n", "138 NaN GLASSWARES \n", "139 NaN GLASSWARES \n", "\n", "[140 rows x 6 columns]" ] }, "execution_count": 6, "metadata": {}, "output_type": "execute_result" } ], "source": [ "reagent_prices_1" ] }, { "cell_type": "code", "execution_count": 7, "metadata": {}, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "C:\\Users\\timmy_3aupohg\\AppData\\Local\\Temp\\ipykernel_26600\\2737799389.py:1: SettingWithCopyWarning: \n", "A value is trying to be set on a copy of a slice from a DataFrame.\n", "Try using .loc[row_indexer,col_indexer] = value instead\n", "\n", "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n", " reagent_prices_1['CINUC PRICE'] = reagent_prices_1['UNIT NGN']\n" ] } ], "source": [ "reagent_prices_1['CINUC PRICE'] = reagent_prices_1['UNIT NGN']" ] }, { "cell_type": "code", "execution_count": 8, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
PRODUCTSQTYUOMUNIT NGNTOTAL NGNCategoryCINUC PRICE
0Reflotron Glucose 15 x 2 stripes /pkt80Pack45000NaNCLINICAL CHEMISTRY45000
1Reflotron Creatinine x30 stripes/pkt40Pack50000NaNCLINICAL CHEMISTRY50000
2Reflotron Cholesterol x30 stripes/pkt60Pack50000NaNCLINICAL CHEMISTRY50000
3Reflotron Triglycerides x30 stripes/pkt60Pack50000NaNCLINICAL CHEMISTRY50000
4Reflotron HDL Cholesterol x 30 stripes/pkt40Pack65000NaNCLINICAL CHEMISTRY65000
........................
135Pyrix Beaker 1000ml10Pcs3500NaNGLASSWARES3500
136Pyrix Beaker 2000 ml10Pcs4900NaNGLASSWARES4900
137Conical Flask 250ml10Pcs1900NaNGLASSWARES1900
138Conical Flask 500ml10Pcs3500NaNGLASSWARES3500
139Conical Flask 1000ml10Pcs4900NaNGLASSWARES4900
\n", "

140 rows × 7 columns

\n", "
" ], "text/plain": [ " PRODUCTS QTY UOM UNIT NGN \\\n", "0 Reflotron Glucose 15 x 2 stripes /pkt 80 Pack 45000 \n", "1 Reflotron Creatinine x30 stripes/pkt 40 Pack 50000 \n", "2 Reflotron Cholesterol x30 stripes/pkt 60 Pack 50000 \n", "3 Reflotron Triglycerides x30 stripes/pkt 60 Pack 50000 \n", "4 Reflotron HDL Cholesterol x 30 stripes/pkt 40 Pack 65000 \n", ".. ... ... ... ... \n", "135 Pyrix Beaker 1000ml 10 Pcs 3500 \n", "136 Pyrix Beaker 2000 ml 10 Pcs 4900 \n", "137 Conical Flask 250ml 10 Pcs 1900 \n", "138 Conical Flask 500ml 10 Pcs 3500 \n", "139 Conical Flask 1000ml 10 Pcs 4900 \n", "\n", " TOTAL NGN Category CINUC PRICE \n", "0 NaN CLINICAL CHEMISTRY 45000 \n", "1 NaN CLINICAL CHEMISTRY 50000 \n", "2 NaN CLINICAL CHEMISTRY 50000 \n", "3 NaN CLINICAL CHEMISTRY 50000 \n", "4 NaN CLINICAL CHEMISTRY 65000 \n", ".. ... ... ... \n", "135 NaN GLASSWARES 3500 \n", "136 NaN GLASSWARES 4900 \n", "137 NaN GLASSWARES 1900 \n", "138 NaN GLASSWARES 3500 \n", "139 NaN GLASSWARES 4900 \n", "\n", "[140 rows x 7 columns]" ] }, "execution_count": 8, "metadata": {}, "output_type": "execute_result" } ], "source": [ "reagent_prices_1" ] }, { "cell_type": "code", "execution_count": 9, "metadata": {}, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "C:\\Users\\timmy_3aupohg\\AppData\\Local\\Temp\\ipykernel_26600\\428992090.py:2: SettingWithCopyWarning: \n", "A value is trying to be set on a copy of a slice from a DataFrame.\n", "Try using .loc[row_indexer,col_indexer] = value instead\n", "\n", "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n", " reagent_prices_1['PRODUCTS'] = reagent_prices_1['PRODUCTS'].str.replace(r'\\s+', ' ', regex=True).str.strip()\n" ] }, { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
PRODUCTSQTYUOMUNIT NGNTOTAL NGNCategoryCINUC PRICE
0Reflotron Glucose 15 x 2 stripes /pkt80Pack45000NaNCLINICAL CHEMISTRY45000
1Reflotron Creatinine x30 stripes/pkt40Pack50000NaNCLINICAL CHEMISTRY50000
2Reflotron Cholesterol x30 stripes/pkt60Pack50000NaNCLINICAL CHEMISTRY50000
3Reflotron Triglycerides x30 stripes/pkt60Pack50000NaNCLINICAL CHEMISTRY50000
4Reflotron HDL Cholesterol x 30 stripes/pkt40Pack65000NaNCLINICAL CHEMISTRY65000
........................
135Pyrix Beaker 1000ml10Pcs3500NaNGLASSWARES3500
136Pyrix Beaker 2000 ml10Pcs4900NaNGLASSWARES4900
137Conical Flask 250ml10Pcs1900NaNGLASSWARES1900
138Conical Flask 500ml10Pcs3500NaNGLASSWARES3500
139Conical Flask 1000ml10Pcs4900NaNGLASSWARES4900
\n", "

140 rows × 7 columns

\n", "
" ], "text/plain": [ " PRODUCTS QTY UOM UNIT NGN \\\n", "0 Reflotron Glucose 15 x 2 stripes /pkt 80 Pack 45000 \n", "1 Reflotron Creatinine x30 stripes/pkt 40 Pack 50000 \n", "2 Reflotron Cholesterol x30 stripes/pkt 60 Pack 50000 \n", "3 Reflotron Triglycerides x30 stripes/pkt 60 Pack 50000 \n", "4 Reflotron HDL Cholesterol x 30 stripes/pkt 40 Pack 65000 \n", ".. ... ... ... ... \n", "135 Pyrix Beaker 1000ml 10 Pcs 3500 \n", "136 Pyrix Beaker 2000 ml 10 Pcs 4900 \n", "137 Conical Flask 250ml 10 Pcs 1900 \n", "138 Conical Flask 500ml 10 Pcs 3500 \n", "139 Conical Flask 1000ml 10 Pcs 4900 \n", "\n", " TOTAL NGN Category CINUC PRICE \n", "0 NaN CLINICAL CHEMISTRY 45000 \n", "1 NaN CLINICAL CHEMISTRY 50000 \n", "2 NaN CLINICAL CHEMISTRY 50000 \n", "3 NaN CLINICAL CHEMISTRY 50000 \n", "4 NaN CLINICAL CHEMISTRY 65000 \n", ".. ... ... ... \n", "135 NaN GLASSWARES 3500 \n", "136 NaN GLASSWARES 4900 \n", "137 NaN GLASSWARES 1900 \n", "138 NaN GLASSWARES 3500 \n", "139 NaN GLASSWARES 4900 \n", "\n", "[140 rows x 7 columns]" ] }, "execution_count": 9, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# removing all spaces in the PRODUCTS column\n", "reagent_prices_1['PRODUCTS'] = reagent_prices_1['PRODUCTS'].str.replace(r'\\s+', ' ', regex=True).str.strip()\n", "reagent_prices_1" ] }, { "cell_type": "code", "execution_count": 10, "metadata": {}, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "C:\\Users\\timmy_3aupohg\\AppData\\Local\\Temp\\ipykernel_26600\\1123187307.py:2: SettingWithCopyWarning: \n", "A value is trying to be set on a copy of a slice from a DataFrame\n", "\n", "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n", " reagent_prices_1.rename(columns={'Category':'CATEGORY'}, inplace=True)\n" ] } ], "source": [ "# renaming Category as CATEGORY\n", "reagent_prices_1.rename(columns={'Category':'CATEGORY'}, inplace=True)" ] }, { "cell_type": "code", "execution_count": 11, "metadata": {}, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "C:\\Users\\timmy_3aupohg\\AppData\\Local\\Temp\\ipykernel_26600\\33697305.py:1: SettingWithCopyWarning: \n", "A value is trying to be set on a copy of a slice from a DataFrame.\n", "Try using .loc[row_indexer,col_indexer] = value instead\n", "\n", "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n", " reagent_prices_1['DATE'] = \"29/03/2023\"\n", "C:\\Users\\timmy_3aupohg\\AppData\\Local\\Temp\\ipykernel_26600\\33697305.py:2: SettingWithCopyWarning: \n", "A value is trying to be set on a copy of a slice from a DataFrame.\n", "Try using .loc[row_indexer,col_indexer] = value instead\n", "\n", "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n", " reagent_prices_1['EXCHANGE RATE'] = 462.000000\n" ] } ], "source": [ "reagent_prices_1['DATE'] = \"29/03/2023\"\n", "reagent_prices_1['EXCHANGE RATE'] = 462.000000" ] }, { "cell_type": "code", "execution_count": 12, "metadata": {}, "outputs": [], "source": [ "cols = ['PRODUCTS', 'UNIT NGN', 'CINUC PRICE', 'CATEGORY', 'DATE', 'EXCHANGE RATE']\n", "reagent_prices_df = reagent_prices_1[cols]" ] }, { "cell_type": "code", "execution_count": 13, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
PRODUCTSUNIT NGNCINUC PRICECATEGORYDATEEXCHANGE RATE
0Reflotron Glucose 15 x 2 stripes /pkt4500045000CLINICAL CHEMISTRY29/03/2023462.0
1Reflotron Creatinine x30 stripes/pkt5000050000CLINICAL CHEMISTRY29/03/2023462.0
2Reflotron Cholesterol x30 stripes/pkt5000050000CLINICAL CHEMISTRY29/03/2023462.0
3Reflotron Triglycerides x30 stripes/pkt5000050000CLINICAL CHEMISTRY29/03/2023462.0
4Reflotron HDL Cholesterol x 30 stripes/pkt6500065000CLINICAL CHEMISTRY29/03/2023462.0
.....................
135Pyrix Beaker 1000ml35003500GLASSWARES29/03/2023462.0
136Pyrix Beaker 2000 ml49004900GLASSWARES29/03/2023462.0
137Conical Flask 250ml19001900GLASSWARES29/03/2023462.0
138Conical Flask 500ml35003500GLASSWARES29/03/2023462.0
139Conical Flask 1000ml49004900GLASSWARES29/03/2023462.0
\n", "

140 rows × 6 columns

\n", "
" ], "text/plain": [ " PRODUCTS UNIT NGN CINUC PRICE \\\n", "0 Reflotron Glucose 15 x 2 stripes /pkt 45000 45000 \n", "1 Reflotron Creatinine x30 stripes/pkt 50000 50000 \n", "2 Reflotron Cholesterol x30 stripes/pkt 50000 50000 \n", "3 Reflotron Triglycerides x30 stripes/pkt 50000 50000 \n", "4 Reflotron HDL Cholesterol x 30 stripes/pkt 65000 65000 \n", ".. ... ... ... \n", "135 Pyrix Beaker 1000ml 3500 3500 \n", "136 Pyrix Beaker 2000 ml 4900 4900 \n", "137 Conical Flask 250ml 1900 1900 \n", "138 Conical Flask 500ml 3500 3500 \n", "139 Conical Flask 1000ml 4900 4900 \n", "\n", " CATEGORY DATE EXCHANGE RATE \n", "0 CLINICAL CHEMISTRY 29/03/2023 462.0 \n", "1 CLINICAL CHEMISTRY 29/03/2023 462.0 \n", "2 CLINICAL CHEMISTRY 29/03/2023 462.0 \n", "3 CLINICAL CHEMISTRY 29/03/2023 462.0 \n", "4 CLINICAL CHEMISTRY 29/03/2023 462.0 \n", ".. ... ... ... \n", "135 GLASSWARES 29/03/2023 462.0 \n", "136 GLASSWARES 29/03/2023 462.0 \n", "137 GLASSWARES 29/03/2023 462.0 \n", "138 GLASSWARES 29/03/2023 462.0 \n", "139 GLASSWARES 29/03/2023 462.0 \n", "\n", "[140 rows x 6 columns]" ] }, "execution_count": 13, "metadata": {}, "output_type": "execute_result" } ], "source": [ "reagent_prices_df" ] }, { "cell_type": "code", "execution_count": 14, "metadata": {}, "outputs": [], "source": [ "# saving as csv file\n", "reagent_prices_df.to_csv('reagent_prices.csv', index=False)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## This happened Last Year" ] }, { "cell_type": "code", "execution_count": 15, "metadata": {}, "outputs": [], "source": [ "# This happened June last year" ] }, { "cell_type": "code", "execution_count": 16, "metadata": {}, "outputs": [], "source": [ "first_call_off = pd.read_excel('FIRST CALL OFF-edited.xlsx')" ] }, { "cell_type": "code", "execution_count": 17, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
S/NMADE BYODERING NUMBERPRODUCTSEST. QTYUOMUNIT RATE NGNUNIT RATE NGN.1TOTAL NGNTOTAL NGN.1CATEGORY
01.0ROCHE10744948Reflotron Glucose 15 x 2 stripes /pkt15Pack45000450003600000NaNCLINICAL CHEMISTRY
1NaNROCHE10886874Reflotron Creatinine x30 stripes/pkt20Pack40000400001600000NaNCLINICAL CHEMISTRY
2NaNROCHE10745065Reflotron Cholesterol x30 stripes/pkt20Pack40000400002400000NaNCLINICAL CHEMISTRY
3NaNROCHE10745049Reflotron Triglycerides x30 stripes/pkt30Pack50000500003000000NaNCLINICAL CHEMISTRY
4NaNROCHENaNReflotron Potassium x 303Pack6000060000360000NaNCLINICAL CHEMISTRY
\n", "
" ], "text/plain": [ " S/N MADE BY ODERING NUMBER PRODUCTS \\\n", "0 1.0 ROCHE 10744948 Reflotron Glucose 15 x 2 stripes /pkt \n", "1 NaN ROCHE 10886874 Reflotron Creatinine x30 stripes/pkt \n", "2 NaN ROCHE 10745065 Reflotron Cholesterol x30 stripes/pkt \n", "3 NaN ROCHE 10745049 Reflotron Triglycerides x30 stripes/pkt \n", "4 NaN ROCHE NaN Reflotron Potassium x 30 \n", "\n", " EST. QTY UOM UNIT RATE NGN UNIT RATE NGN.1 TOTAL NGN TOTAL NGN.1 \\\n", "0 15 Pack 45000 45000 3600000 NaN \n", "1 20 Pack 40000 40000 1600000 NaN \n", "2 20 Pack 40000 40000 2400000 NaN \n", "3 30 Pack 50000 50000 3000000 NaN \n", "4 3 Pack 60000 60000 360000 NaN \n", "\n", " CATEGORY \n", "0 CLINICAL CHEMISTRY \n", "1 CLINICAL CHEMISTRY \n", "2 CLINICAL CHEMISTRY \n", "3 CLINICAL CHEMISTRY \n", "4 CLINICAL CHEMISTRY " ] }, "execution_count": 17, "metadata": {}, "output_type": "execute_result" } ], "source": [ "first_call_off.head()" ] }, { "cell_type": "code", "execution_count": 18, "metadata": {}, "outputs": [], "source": [ "first_call_off['PRODUCTS'] = first_call_off['PRODUCTS'].str.replace(r'\\s+', ' ', regex=True).str.strip()" ] }, { "cell_type": "code", "execution_count": 19, "metadata": {}, "outputs": [], "source": [ "first_call_off['CINUC PRICE'] = first_call_off['UNIT RATE NGN']\n", "first_call_off['UNIT NGN'] = first_call_off['UNIT RATE NGN']" ] }, { "cell_type": "code", "execution_count": 20, "metadata": {}, "outputs": [], "source": [ "first_call_off['DATE'] = \"31/07/2023\"\n", "first_call_off['EXCHANGE RATE'] = 775.000000" ] }, { "cell_type": "code", "execution_count": 21, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
PRODUCTSUNIT NGNCINUC PRICECATEGORYDATEEXCHANGE RATE
0Reflotron Glucose 15 x 2 stripes /pkt4500045000CLINICAL CHEMISTRY31/07/2023775.0
1Reflotron Creatinine x30 stripes/pkt4000040000CLINICAL CHEMISTRY31/07/2023775.0
2Reflotron Cholesterol x30 stripes/pkt4000040000CLINICAL CHEMISTRY31/07/2023775.0
3Reflotron Triglycerides x30 stripes/pkt5000050000CLINICAL CHEMISTRY31/07/2023775.0
4Reflotron Potassium x 306000060000CLINICAL CHEMISTRY31/07/2023775.0
.....................
101Veneral Disease Resarch LAB antigen test, VDRL...1000010000MICROBIOLOGY AND LABORATORY REAGENTS31/07/2023775.0
102Paper tapes (Rolls)55445544MICROBIOLOGY AND LABORATORY REAGENTS31/07/2023775.0
103Parazone 500ml x 20bottles /ctn3500035000MICROBIOLOGY AND LABORATORY REAGENTS31/07/2023775.0
104Sterilin type universal containers, (for urine...4000040000MICROBIOLOGY AND LABORATORY REAGENTS31/07/2023775.0
105Sterilin type petri dish containers / 100cm6000060000MICROBIOLOGY AND LABORATORY REAGENTS31/07/2023775.0
\n", "

106 rows × 6 columns

\n", "
" ], "text/plain": [ " PRODUCTS UNIT NGN CINUC PRICE \\\n", "0 Reflotron Glucose 15 x 2 stripes /pkt 45000 45000 \n", "1 Reflotron Creatinine x30 stripes/pkt 40000 40000 \n", "2 Reflotron Cholesterol x30 stripes/pkt 40000 40000 \n", "3 Reflotron Triglycerides x30 stripes/pkt 50000 50000 \n", "4 Reflotron Potassium x 30 60000 60000 \n", ".. ... ... ... \n", "101 Veneral Disease Resarch LAB antigen test, VDRL... 10000 10000 \n", "102 Paper tapes (Rolls) 5544 5544 \n", "103 Parazone 500ml x 20bottles /ctn 35000 35000 \n", "104 Sterilin type universal containers, (for urine... 40000 40000 \n", "105 Sterilin type petri dish containers / 100cm 60000 60000 \n", "\n", " CATEGORY DATE EXCHANGE RATE \n", "0 CLINICAL CHEMISTRY 31/07/2023 775.0 \n", "1 CLINICAL CHEMISTRY 31/07/2023 775.0 \n", "2 CLINICAL CHEMISTRY 31/07/2023 775.0 \n", "3 CLINICAL CHEMISTRY 31/07/2023 775.0 \n", "4 CLINICAL CHEMISTRY 31/07/2023 775.0 \n", ".. ... ... ... \n", "101 MICROBIOLOGY AND LABORATORY REAGENTS 31/07/2023 775.0 \n", "102 MICROBIOLOGY AND LABORATORY REAGENTS 31/07/2023 775.0 \n", "103 MICROBIOLOGY AND LABORATORY REAGENTS 31/07/2023 775.0 \n", "104 MICROBIOLOGY AND LABORATORY REAGENTS 31/07/2023 775.0 \n", "105 MICROBIOLOGY AND LABORATORY REAGENTS 31/07/2023 775.0 \n", "\n", "[106 rows x 6 columns]" ] }, "execution_count": 21, "metadata": {}, "output_type": "execute_result" } ], "source": [ "cols = ['PRODUCTS', 'UNIT NGN', 'CINUC PRICE', 'CATEGORY', 'DATE', 'EXCHANGE RATE']\n", "first_call_off_df = first_call_off[cols]\n", "first_call_off_df" ] }, { "cell_type": "code", "execution_count": 22, "metadata": {}, "outputs": [], "source": [ "# saving as csv file\n", "first_call_off_df.to_csv('first_call_off.csv', index=False)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Are you buying for this data..." ] }, { "cell_type": "code", "execution_count": 23, "metadata": {}, "outputs": [], "source": [ "# this happened last year ending. ## 2023" ] }, { "cell_type": "code", "execution_count": 24, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
S/N OPRODUCTSQTYUOMCOST PRICE UNIT RATE NGNCOST PRICE TOTAL NGNCINUC PRICES UNIT NGNCINUC PRICES TOTAL NGNDateCATEGORY
01.0COBAS C 111 UREA 400 TESTS1Pack0.025138.545250NaN2023-08-09CLINICAL CHEMISTRY
1NaNCOBAS C111 HDL 400TESTS1Pack0.070383.5195350NaN2023-08-09CLINICAL CHEMISTRY
2NaNCOBAS C 111 TRIGLYCERIDES 200 TESTS5Pack41147.0NaN55550NaN2023-08-09CLINICAL CHEMISTRY
3NaNCOBAS C 111 CFAS Lipid3Pack50266.0NaN143346NaN2023-08-09CLINICAL CHEMISTRY
4NaNT3 i- chromax2Pack55000.0NaN60750NaN2023-08-09HORMONE ASSAY REAGENTS
\n", "
" ], "text/plain": [ " S/N O PRODUCTS QTY UOM \\\n", "0 1.0 COBAS C 111 UREA 400 TESTS 1 Pack \n", "1 NaN COBAS C111 HDL 400TESTS 1 Pack \n", "2 NaN COBAS C 111 TRIGLYCERIDES 200 TESTS 5 Pack \n", "3 NaN COBAS C 111 CFAS Lipid 3 Pack \n", "4 NaN T3 i- chromax 2 Pack \n", "\n", " COST PRICE UNIT RATE NGN COST PRICE TOTAL NGN CINUC PRICES UNIT NGN \\\n", "0 0.0 25138.5 45250 \n", "1 0.0 70383.5 195350 \n", "2 41147.0 NaN 55550 \n", "3 50266.0 NaN 143346 \n", "4 55000.0 NaN 60750 \n", "\n", " CINUC PRICES TOTAL NGN Date CATEGORY \n", "0 NaN 2023-08-09 CLINICAL CHEMISTRY \n", "1 NaN 2023-08-09 CLINICAL CHEMISTRY \n", "2 NaN 2023-08-09 CLINICAL CHEMISTRY \n", "3 NaN 2023-08-09 CLINICAL CHEMISTRY \n", "4 NaN 2023-08-09 HORMONE ASSAY REAGENTS " ] }, "execution_count": 24, "metadata": {}, "output_type": "execute_result" } ], "source": [ "list_price = pd.read_excel('List 2-EDITED.xlsx')\n", "list_price.head()" ] }, { "cell_type": "code", "execution_count": 25, "metadata": {}, "outputs": [], "source": [ "list_price['PRODUCTS'] = list_price['PRODUCTS'].str.replace(r'\\s+', ' ', regex=True).str.strip()" ] }, { "cell_type": "code", "execution_count": 26, "metadata": {}, "outputs": [], "source": [ "list_price['CINUC PRICE'] = list_price['CINUC PRICES UNIT NGN']\n", "list_price['UNIT NGN'] = list_price['COST PRICE UNIT RATE NGN']\n", "list_price['DATE'] = \"25/09/2023\"\n", "list_price['EXCHANGE RATE'] = 767.429993" ] }, { "cell_type": "code", "execution_count": 27, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
PRODUCTSUNIT NGNCINUC PRICECATEGORYDATEEXCHANGE RATE
0COBAS C 111 UREA 400 TESTS0.045250CLINICAL CHEMISTRY25/09/2023767.429993
1COBAS C111 HDL 400TESTS0.0195350CLINICAL CHEMISTRY25/09/2023767.429993
2COBAS C 111 TRIGLYCERIDES 200 TESTS41147.055550CLINICAL CHEMISTRY25/09/2023767.429993
3COBAS C 111 CFAS Lipid50266.0143346CLINICAL CHEMISTRY25/09/2023767.429993
4T3 i- chromax55000.060750HORMONE ASSAY REAGENTS25/09/2023767.429993
5T4 i- chromax55000.060750HORMONE ASSAY REAGENTS25/09/2023767.429993
6TSH i- chromax55000.060750HORMONE ASSAY REAGENTS25/09/2023767.429993
7D-DIMER i-chromax62000.070200HORMONE ASSAY REAGENTS25/09/2023767.429993
8PSA i- chromax55000.060750HORMONE ASSAY REAGENTS25/09/2023767.429993
9CRP i- chromax56000.0100000HORMONE ASSAY REAGENTS25/09/2023767.429993
10QBC HEMATOLOGY/MALARIA TUBES TUBES 250T275000.0290500HEMATOLOGY AND SEROLOGY25/09/2023767.429993
11SD BIO LINE H.Pylori Antibody test 30 tests /pkt5000.065000HEMATOLOGY AND SEROLOGY25/09/2023767.429993
12mindray 5 heamatology reagent Diluent 20ml43254.069212HEMATOLOGY AND SEROLOGY25/09/2023767.429993
13BioMed sicle scan for rapid genotye X25 /PKT150000.0200000MICROBIOLOGY AND LABORATORY REAGENTS25/09/2023767.429993
14Febrile antigen test (VOSAN) 8 x 5ml with cont...13000.040000MICROBIOLOGY AND LABORATORY REAGENTS25/09/2023767.429993
15Latex examination gloves (by Sempercare) 100 8-9L2400.036000MICROBIOLOGY AND LABORATORY REAGENTS25/09/2023767.429993
16Immersion oil 100ml600.011880MICROBIOLOGY AND LABORATORY REAGENTS25/09/2023767.429993
17Multistrips for urinalysis, ACON LABS5500.070000MICROBIOLOGY AND LABORATORY REAGENTS25/09/2023767.429993
18Water quality quick test with probefor PH, ORP...886032.21138500WATER ANALYZES KIT25/09/2023767.429993
19Glucose (Accu Answer)15500.045000Accu answer kits25/09/2023767.429993
20Cholesterol (Accu Answer)18500.040000Accu answer kits25/09/2023767.429993
\n", "
" ], "text/plain": [ " PRODUCTS UNIT NGN CINUC PRICE \\\n", "0 COBAS C 111 UREA 400 TESTS 0.0 45250 \n", "1 COBAS C111 HDL 400TESTS 0.0 195350 \n", "2 COBAS C 111 TRIGLYCERIDES 200 TESTS 41147.0 55550 \n", "3 COBAS C 111 CFAS Lipid 50266.0 143346 \n", "4 T3 i- chromax 55000.0 60750 \n", "5 T4 i- chromax 55000.0 60750 \n", "6 TSH i- chromax 55000.0 60750 \n", "7 D-DIMER i-chromax 62000.0 70200 \n", "8 PSA i- chromax 55000.0 60750 \n", "9 CRP i- chromax 56000.0 100000 \n", "10 QBC HEMATOLOGY/MALARIA TUBES TUBES 250T 275000.0 290500 \n", "11 SD BIO LINE H.Pylori Antibody test 30 tests /pkt 5000.0 65000 \n", "12 mindray 5 heamatology reagent Diluent 20ml 43254.0 69212 \n", "13 BioMed sicle scan for rapid genotye X25 /PKT 150000.0 200000 \n", "14 Febrile antigen test (VOSAN) 8 x 5ml with cont... 13000.0 40000 \n", "15 Latex examination gloves (by Sempercare) 100 8-9L 2400.0 36000 \n", "16 Immersion oil 100ml 600.0 11880 \n", "17 Multistrips for urinalysis, ACON LABS 5500.0 70000 \n", "18 Water quality quick test with probefor PH, ORP... 886032.2 1138500 \n", "19 Glucose (Accu Answer) 15500.0 45000 \n", "20 Cholesterol (Accu Answer) 18500.0 40000 \n", "\n", " CATEGORY DATE EXCHANGE RATE \n", "0 CLINICAL CHEMISTRY 25/09/2023 767.429993 \n", "1 CLINICAL CHEMISTRY 25/09/2023 767.429993 \n", "2 CLINICAL CHEMISTRY 25/09/2023 767.429993 \n", "3 CLINICAL CHEMISTRY 25/09/2023 767.429993 \n", "4 HORMONE ASSAY REAGENTS 25/09/2023 767.429993 \n", "5 HORMONE ASSAY REAGENTS 25/09/2023 767.429993 \n", "6 HORMONE ASSAY REAGENTS 25/09/2023 767.429993 \n", "7 HORMONE ASSAY REAGENTS 25/09/2023 767.429993 \n", "8 HORMONE ASSAY REAGENTS 25/09/2023 767.429993 \n", "9 HORMONE ASSAY REAGENTS 25/09/2023 767.429993 \n", "10 HEMATOLOGY AND SEROLOGY 25/09/2023 767.429993 \n", "11 HEMATOLOGY AND SEROLOGY 25/09/2023 767.429993 \n", "12 HEMATOLOGY AND SEROLOGY 25/09/2023 767.429993 \n", "13 MICROBIOLOGY AND LABORATORY REAGENTS 25/09/2023 767.429993 \n", "14 MICROBIOLOGY AND LABORATORY REAGENTS 25/09/2023 767.429993 \n", "15 MICROBIOLOGY AND LABORATORY REAGENTS 25/09/2023 767.429993 \n", "16 MICROBIOLOGY AND LABORATORY REAGENTS 25/09/2023 767.429993 \n", "17 MICROBIOLOGY AND LABORATORY REAGENTS 25/09/2023 767.429993 \n", "18 WATER ANALYZES KIT 25/09/2023 767.429993 \n", "19 Accu answer kits 25/09/2023 767.429993 \n", "20 Accu answer kits 25/09/2023 767.429993 " ] }, "execution_count": 27, "metadata": {}, "output_type": "execute_result" } ], "source": [ "cols = ['PRODUCTS', 'UNIT NGN', 'CINUC PRICE', 'CATEGORY', 'DATE', 'EXCHANGE RATE']\n", "list_price_df = list_price[cols]\n", "list_price_df" ] }, { "cell_type": "code", "execution_count": 28, "metadata": {}, "outputs": [], "source": [ "# saving as csv file\n", "list_price_df.to_csv('list_price_df.csv', index=False)" ] }, { "cell_type": "code", "execution_count": 29, "metadata": {}, "outputs": [], "source": [ "# calculating percentage added by cinuc\n", "list_price['Percentage diff'] = ((list_price['CINUC PRICES UNIT NGN'] - list_price['COST PRICE UNIT RATE NGN']) / list_price['CINUC PRICES UNIT NGN']) * 100" ] }, { "cell_type": "code", "execution_count": 30, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
S/N OPRODUCTSQTYUOMCOST PRICE UNIT RATE NGNCOST PRICE TOTAL NGNCINUC PRICES UNIT NGNCINUC PRICES TOTAL NGNDateCATEGORYCINUC PRICEUNIT NGNDATEEXCHANGE RATEPercentage diff
01.0COBAS C 111 UREA 400 TESTS1Pack0.025138.545250NaN2023-08-09CLINICAL CHEMISTRY452500.025/09/2023767.429993100.000000
1NaNCOBAS C111 HDL 400TESTS1Pack0.070383.5195350NaN2023-08-09CLINICAL CHEMISTRY1953500.025/09/2023767.429993100.000000
2NaNCOBAS C 111 TRIGLYCERIDES 200 TESTS5Pack41147.0NaN55550NaN2023-08-09CLINICAL CHEMISTRY5555041147.025/09/2023767.42999325.927993
3NaNCOBAS C 111 CFAS Lipid3Pack50266.0NaN143346NaN2023-08-09CLINICAL CHEMISTRY14334650266.025/09/2023767.42999364.933797
4NaNT3 i- chromax2Pack55000.0NaN60750NaN2023-08-09HORMONE ASSAY REAGENTS6075055000.025/09/2023767.4299939.465021
5NaNT4 i- chromax2Pack55000.0NaN60750NaN2023-08-09HORMONE ASSAY REAGENTS6075055000.025/09/2023767.4299939.465021
6NaNTSH i- chromax2Pack55000.0NaN60750NaN2023-08-09HORMONE ASSAY REAGENTS6075055000.025/09/2023767.4299939.465021
7NaND-DIMER i-chromax2Pack62000.0NaN70200NaN2023-08-09HORMONE ASSAY REAGENTS7020062000.025/09/2023767.42999311.680912
8NaNPSA i- chromax2Pack55000.0NaN60750NaN2023-08-09HORMONE ASSAY REAGENTS6075055000.025/09/2023767.4299939.465021
9NaNCRP i- chromax2Pack56000.0NaN100000NaN2023-08-09HORMONE ASSAY REAGENTS10000056000.025/09/2023767.42999344.000000
10NaNQBC HEMATOLOGY/MALARIA TUBES TUBES 250T5Pack275000.0NaN290500NaN2023-08-09HEMATOLOGY AND SEROLOGY290500275000.025/09/2023767.4299935.335628
11NaNSD BIO LINE H.Pylori Antibody test 30 tests /pkt10Pack5000.0NaN65000NaN2023-08-09HEMATOLOGY AND SEROLOGY650005000.025/09/2023767.42999392.307692
12NaNmindray 5 heamatology reagent Diluent 20ml4Pack43254.0NaN69212NaN2023-08-09HEMATOLOGY AND SEROLOGY6921243254.025/09/2023767.42999337.505057
13NaNBioMed sicle scan for rapid genotye X25 /PKT2Pack150000.0NaN200000NaN2023-08-09MICROBIOLOGY AND LABORATORY REAGENTS200000150000.025/09/2023767.42999325.000000
14NaNFebrile antigen test (VOSAN) 8 x 5ml with cont...13Pack13000.0NaN40000NaN2023-08-09MICROBIOLOGY AND LABORATORY REAGENTS4000013000.025/09/2023767.42999367.500000
15NaNLatex examination gloves (by Sempercare) 100 8-9L12Pack2400.0NaN36000NaN2023-08-09MICROBIOLOGY AND LABORATORY REAGENTS360002400.025/09/2023767.42999393.333333
16NaNImmersion oil 100ml12Pack600.0NaN11880NaN2023-08-09MICROBIOLOGY AND LABORATORY REAGENTS11880600.025/09/2023767.42999394.949495
17NaNMultistrips for urinalysis, ACON LABS11Pack5500.0NaN70000NaN2023-08-09MICROBIOLOGY AND LABORATORY REAGENTS700005500.025/09/2023767.42999392.142857
18NaNWater quality quick test with probefor PH, ORP...2Pack886032.2NaN1138500NaN2023-08-09WATER ANALYZES KIT1138500886032.225/09/2023767.42999322.175477
19NaNGlucose (Accu Answer)10Pack15500.0NaN45000NaN2023-08-09Accu answer kits4500015500.025/09/2023767.42999365.555556
20NaNCholesterol (Accu Answer)12Pack18500.0NaN40000NaN2023-08-09Accu answer kits4000018500.025/09/2023767.42999353.750000
\n", "
" ], "text/plain": [ " S/N O PRODUCTS QTY UOM \\\n", "0 1.0 COBAS C 111 UREA 400 TESTS 1 Pack \n", "1 NaN COBAS C111 HDL 400TESTS 1 Pack \n", "2 NaN COBAS C 111 TRIGLYCERIDES 200 TESTS 5 Pack \n", "3 NaN COBAS C 111 CFAS Lipid 3 Pack \n", "4 NaN T3 i- chromax 2 Pack \n", "5 NaN T4 i- chromax 2 Pack \n", "6 NaN TSH i- chromax 2 Pack \n", "7 NaN D-DIMER i-chromax 2 Pack \n", "8 NaN PSA i- chromax 2 Pack \n", "9 NaN CRP i- chromax 2 Pack \n", "10 NaN QBC HEMATOLOGY/MALARIA TUBES TUBES 250T 5 Pack \n", "11 NaN SD BIO LINE H.Pylori Antibody test 30 tests /pkt 10 Pack \n", "12 NaN mindray 5 heamatology reagent Diluent 20ml 4 Pack \n", "13 NaN BioMed sicle scan for rapid genotye X25 /PKT 2 Pack \n", "14 NaN Febrile antigen test (VOSAN) 8 x 5ml with cont... 13 Pack \n", "15 NaN Latex examination gloves (by Sempercare) 100 8-9L 12 Pack \n", "16 NaN Immersion oil 100ml 12 Pack \n", "17 NaN Multistrips for urinalysis, ACON LABS 11 Pack \n", "18 NaN Water quality quick test with probefor PH, ORP... 2 Pack \n", "19 NaN Glucose (Accu Answer) 10 Pack \n", "20 NaN Cholesterol (Accu Answer) 12 Pack \n", "\n", " COST PRICE UNIT RATE NGN COST PRICE TOTAL NGN CINUC PRICES UNIT NGN \\\n", "0 0.0 25138.5 45250 \n", "1 0.0 70383.5 195350 \n", "2 41147.0 NaN 55550 \n", "3 50266.0 NaN 143346 \n", "4 55000.0 NaN 60750 \n", "5 55000.0 NaN 60750 \n", "6 55000.0 NaN 60750 \n", "7 62000.0 NaN 70200 \n", "8 55000.0 NaN 60750 \n", "9 56000.0 NaN 100000 \n", "10 275000.0 NaN 290500 \n", "11 5000.0 NaN 65000 \n", "12 43254.0 NaN 69212 \n", "13 150000.0 NaN 200000 \n", "14 13000.0 NaN 40000 \n", "15 2400.0 NaN 36000 \n", "16 600.0 NaN 11880 \n", "17 5500.0 NaN 70000 \n", "18 886032.2 NaN 1138500 \n", "19 15500.0 NaN 45000 \n", "20 18500.0 NaN 40000 \n", "\n", " CINUC PRICES TOTAL NGN Date CATEGORY \\\n", "0 NaN 2023-08-09 CLINICAL CHEMISTRY \n", "1 NaN 2023-08-09 CLINICAL CHEMISTRY \n", "2 NaN 2023-08-09 CLINICAL CHEMISTRY \n", "3 NaN 2023-08-09 CLINICAL CHEMISTRY \n", "4 NaN 2023-08-09 HORMONE ASSAY REAGENTS \n", "5 NaN 2023-08-09 HORMONE ASSAY REAGENTS \n", "6 NaN 2023-08-09 HORMONE ASSAY REAGENTS \n", "7 NaN 2023-08-09 HORMONE ASSAY REAGENTS \n", "8 NaN 2023-08-09 HORMONE ASSAY REAGENTS \n", "9 NaN 2023-08-09 HORMONE ASSAY REAGENTS \n", "10 NaN 2023-08-09 HEMATOLOGY AND SEROLOGY \n", "11 NaN 2023-08-09 HEMATOLOGY AND SEROLOGY \n", "12 NaN 2023-08-09 HEMATOLOGY AND SEROLOGY \n", "13 NaN 2023-08-09 MICROBIOLOGY AND LABORATORY REAGENTS \n", "14 NaN 2023-08-09 MICROBIOLOGY AND LABORATORY REAGENTS \n", "15 NaN 2023-08-09 MICROBIOLOGY AND LABORATORY REAGENTS \n", "16 NaN 2023-08-09 MICROBIOLOGY AND LABORATORY REAGENTS \n", "17 NaN 2023-08-09 MICROBIOLOGY AND LABORATORY REAGENTS \n", "18 NaN 2023-08-09 WATER ANALYZES KIT \n", "19 NaN 2023-08-09 Accu answer kits \n", "20 NaN 2023-08-09 Accu answer kits \n", "\n", " CINUC PRICE UNIT NGN DATE EXCHANGE RATE Percentage diff \n", "0 45250 0.0 25/09/2023 767.429993 100.000000 \n", "1 195350 0.0 25/09/2023 767.429993 100.000000 \n", "2 55550 41147.0 25/09/2023 767.429993 25.927993 \n", "3 143346 50266.0 25/09/2023 767.429993 64.933797 \n", "4 60750 55000.0 25/09/2023 767.429993 9.465021 \n", "5 60750 55000.0 25/09/2023 767.429993 9.465021 \n", "6 60750 55000.0 25/09/2023 767.429993 9.465021 \n", "7 70200 62000.0 25/09/2023 767.429993 11.680912 \n", "8 60750 55000.0 25/09/2023 767.429993 9.465021 \n", "9 100000 56000.0 25/09/2023 767.429993 44.000000 \n", "10 290500 275000.0 25/09/2023 767.429993 5.335628 \n", "11 65000 5000.0 25/09/2023 767.429993 92.307692 \n", "12 69212 43254.0 25/09/2023 767.429993 37.505057 \n", "13 200000 150000.0 25/09/2023 767.429993 25.000000 \n", "14 40000 13000.0 25/09/2023 767.429993 67.500000 \n", "15 36000 2400.0 25/09/2023 767.429993 93.333333 \n", "16 11880 600.0 25/09/2023 767.429993 94.949495 \n", "17 70000 5500.0 25/09/2023 767.429993 92.142857 \n", "18 1138500 886032.2 25/09/2023 767.429993 22.175477 \n", "19 45000 15500.0 25/09/2023 767.429993 65.555556 \n", "20 40000 18500.0 25/09/2023 767.429993 53.750000 " ] }, "execution_count": 30, "metadata": {}, "output_type": "execute_result" } ], "source": [ "list_price" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## This happened two years ago." ] }, { "cell_type": "code", "execution_count": 31, "metadata": {}, "outputs": [], "source": [ "# March Two years ago" ] }, { "cell_type": "code", "execution_count": 32, "metadata": {}, "outputs": [], "source": [ "# loading forth call off \n", "forth_call_off = pd.read_excel('FOURTH CALL-OFF IN STOCK-edited.xlsx', skiprows=1)" ] }, { "cell_type": "code", "execution_count": 33, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Unnamed: 0PRODUCTSQTYVENDOR PRICES UNIT PRICE NAIRAVENDOR PRICES TOTAL PRICE NAIRACINUC PRICES UNIT PRICE NAIRACINUC PRICES TOTAL PRICE NAIRAAFTER 10% REDUCTIONCATEGORY
0NaNReflotron Glucose 15 x 2 stripes /pkt517298.0NaN13989.90NaNNaNCLINICAL CHEMISTRY
1NaNReflotron Creatinine x30 stripes/pkt1023663.0NaN19137.38NaNNaNCLINICAL CHEMISTRY
2NaNReflotron Triglycerides x30 stripes/pkt223663.0NaN19137.38NaNNaNCLINICAL CHEMISTRY
3NaNEpson ribbon for Reflotron printer473346.0NaN14019.97NaNNaNCLINICAL CHEMISTRY
4NaNReflotron Pancreatic Amylase 15x2 stripes/pkt223688.0NaN13989.90NaNNaNCLINICAL CHEMISTRY
\n", "
" ], "text/plain": [ " Unnamed: 0 PRODUCTS QTY \\\n", "0 NaN Reflotron Glucose 15 x 2 stripes /pkt 5 \n", "1 NaN Reflotron Creatinine x30 stripes/pkt 10 \n", "2 NaN Reflotron Triglycerides x30 stripes/pkt 2 \n", "3 NaN Epson ribbon for Reflotron printer 4 \n", "4 NaN Reflotron Pancreatic Amylase 15x2 stripes/pkt 2 \n", "\n", " VENDOR PRICES UNIT PRICE NAIRA VENDOR PRICES TOTAL PRICE NAIRA \\\n", "0 17298.0 NaN \n", "1 23663.0 NaN \n", "2 23663.0 NaN \n", "3 73346.0 NaN \n", "4 23688.0 NaN \n", "\n", " CINUC PRICES UNIT PRICE NAIRA CINUC PRICES TOTAL PRICE NAIRA \\\n", "0 13989.90 NaN \n", "1 19137.38 NaN \n", "2 19137.38 NaN \n", "3 14019.97 NaN \n", "4 13989.90 NaN \n", "\n", " AFTER 10% REDUCTION CATEGORY \n", "0 NaN CLINICAL CHEMISTRY \n", "1 NaN CLINICAL CHEMISTRY \n", "2 NaN CLINICAL CHEMISTRY \n", "3 NaN CLINICAL CHEMISTRY \n", "4 NaN CLINICAL CHEMISTRY " ] }, "execution_count": 33, "metadata": {}, "output_type": "execute_result" } ], "source": [ "forth_call_off.head()" ] }, { "cell_type": "code", "execution_count": 34, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "Index(['Unnamed: 0', 'PRODUCTS', 'QTY', 'VENDOR PRICES UNIT PRICE NAIRA',\n", " 'VENDOR PRICES TOTAL PRICE NAIRA', 'CINUC PRICES UNIT PRICE NAIRA',\n", " 'CINUC PRICES TOTAL PRICE NAIRA', 'AFTER 10% REDUCTION', 'CATEGORY'],\n", " dtype='object')" ] }, "execution_count": 34, "metadata": {}, "output_type": "execute_result" } ], "source": [ "forth_call_off.columns" ] }, { "cell_type": "code", "execution_count": 35, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
PRODUCTSQTYVENDOR PRICES UNIT PRICE NAIRAVENDOR PRICES TOTAL PRICE NAIRACINUC PRICES UNIT PRICE NAIRACINUC PRICES TOTAL PRICE NAIRAAFTER 10% REDUCTIONCATEGORY
0Reflotron Glucose 15 x 2 stripes /pkt517298.00NaN13989.90NaNNaNCLINICAL CHEMISTRY
1Reflotron Creatinine x30 stripes/pkt1023663.00NaN19137.38NaNNaNCLINICAL CHEMISTRY
2Reflotron Triglycerides x30 stripes/pkt223663.00NaN19137.38NaNNaNCLINICAL CHEMISTRY
3Epson ribbon for Reflotron printer473346.00NaN14019.97NaNNaNCLINICAL CHEMISTRY
4Reflotron Pancreatic Amylase 15x2 stripes/pkt223688.00NaN13989.90NaNNaNCLINICAL CHEMISTRY
5Reflotron Bilirubin x 30 stripes/pkt1721841.00NaN17664.03NaNNaNCLINICAL CHEMISTRY
6Reflotron AST/GOT x30 stripes/pkt823663.00NaN19137.38NaNNaNCLINICAL CHEMISTRY
7Reflotron GPT/ALT x 30 stripes/pkt823663.00NaN19137.38NaNNaNCLINICAL CHEMISTRY
8Reflotron Urea 15 x 2 stripes/pkt823688.00NaN14999.70NaNNaNCLINICAL CHEMISTRY
9Reflotron Gamma GT x 30 stripes/pkt621841.00NaN17664.03NaNNaNCLINICAL CHEMISTRY
10PROBE SET COBAS c1111114933.82NaN107626.37NaNNaNCLINICAL CHEMISTRY
11COBAS 3 C111 CLEANER730195.00NaN31745.30NaNNaNCLINICAL CHEMISTRY
12COBAS C 11 GLU2 GLUCOSE 400 TESTS430992.00NaN25064.32NaNNaNCLINICAL CHEMISTRY
13COBAS C 111 ALT (GPT) 400 TESTS422018.00NaN17806.27NaNNaNCLINICAL CHEMISTRY
14COBAS C 111 AST (GOT) 400 TESTS422018.00NaN17806.27NaNNaNCLINICAL CHEMISTRY
15COBAS C 111 PRINTER PAPER 4 rolls /PKT13643.25NaN4199.92NaNNaNCLINICAL CHEMISTRY
16COBAS C 111 BLT3 TOTAL BILIRUBIN536303.00NaN33994.64NaNNaNCLINICAL CHEMISTRY
17COBAS C 111 UREA 400 TESTS424254.00NaN19615.01NaNNaNCLINICAL CHEMISTRY
18QBC HEAMATOLOGY/MALARIA TUBES 250T20209995.80NaN209995.80NaNNaNHEMATOLOGY AND SEROLOGY
19SD malaria Ag Pf.kit for single use, 25/pkt B...2038675.00NaN59998.80NaNNaNHEMATOLOGY AND SEROLOGY
20SD BIO LINE HIV Ag/Ab combo 30tests/pkt817550.00NaN34999.30NaNNaNHEMATOLOGY AND SEROLOGY
21mindray 5 heaamatology reagent Diluent 20ml216333.00NaN40949.18NaNNaNHEMATOLOGY AND SEROLOGY
22Sarstedt multi-safe comfort 6l, sharp box1402570.00NaN122997.54NaNNaNSAFETY PRODUCTS / MATRIALS
23S- monovette 4.5ml lithium heparin Sarstedt ...5160384.00NaN151996.96NaNNaNSAFETY PRODUCTS / MATRIALS
24Blood group A typing serum 10ml/ 10 bottles /p...29000.00NaN2499.95NaNNaNMICROBIOLOGY AND LABORATORY REAGENTS
25Blood group AB typing serum 10ml/ 10 bottles /...514000.00NaN13999.72NaNNaNMICROBIOLOGY AND LABORATORY REAGENTS
26Blood group B typing serum 10ml/ 10 bottles /p...59000.00NaN17999.64NaNNaNMICROBIOLOGY AND LABORATORY REAGENTS
27Blood group D typing serum 10ml/ 10 bottles /p...512000.00NaN19999.60NaNNaNMICROBIOLOGY AND LABORATORY REAGENTS
28cellulose acetate strips shandon 60 x150mm x ...1145000.00NaN99998.00NaNNaNMICROBIOLOGY AND LABORATORY REAGENTS
29Erytrocyte sedimentation rate, dispet 100/pkt113500.00NaN19999.60NaNNaNMICROBIOLOGY AND LABORATORY REAGENTS
30Febrile antigen test (OMEGA) 8 x 5ml with con...98500.00NaN11499.77NaNNaNMICROBIOLOGY AND LABORATORY REAGENTS
31Latex examination gloves (by Sempercare) 100 ...26500.00NaN3499.93NaNNaNMICROBIOLOGY AND LABORATORY REAGENTS
32Giemsa Stain 100ml/bottle ferntec biosciences8350.00NaN1199.98NaNNaNMICROBIOLOGY AND LABORATORY REAGENTS
33Pipette tips (1-200ul) blue type x 1000/pkt EP...41500.00NaN2999.94NaNNaNMICROBIOLOGY AND LABORATORY REAGENTS
34Sterilin type universal containers, (for urin...414000.00NaN25499.49NaNNaNMICROBIOLOGY AND LABORATORY REAGENTS
\n", "
" ], "text/plain": [ " PRODUCTS QTY \\\n", "0 Reflotron Glucose 15 x 2 stripes /pkt 5 \n", "1 Reflotron Creatinine x30 stripes/pkt 10 \n", "2 Reflotron Triglycerides x30 stripes/pkt 2 \n", "3 Epson ribbon for Reflotron printer 4 \n", "4 Reflotron Pancreatic Amylase 15x2 stripes/pkt 2 \n", "5 Reflotron Bilirubin x 30 stripes/pkt 17 \n", "6 Reflotron AST/GOT x30 stripes/pkt 8 \n", "7 Reflotron GPT/ALT x 30 stripes/pkt 8 \n", "8 Reflotron Urea 15 x 2 stripes/pkt 8 \n", "9 Reflotron Gamma GT x 30 stripes/pkt 6 \n", "10 PROBE SET COBAS c111 1 \n", "11 COBAS 3 C111 CLEANER 7 \n", "12 COBAS C 11 GLU2 GLUCOSE 400 TESTS 4 \n", "13 COBAS C 111 ALT (GPT) 400 TESTS 4 \n", "14 COBAS C 111 AST (GOT) 400 TESTS 4 \n", "15 COBAS C 111 PRINTER PAPER 4 rolls /PKT 1 \n", "16 COBAS C 111 BLT3 TOTAL BILIRUBIN 5 \n", "17 COBAS C 111 UREA 400 TESTS 4 \n", "18 QBC HEAMATOLOGY/MALARIA TUBES 250T 20 \n", "19 SD malaria Ag Pf.kit for single use, 25/pkt B... 20 \n", "20 SD BIO LINE HIV Ag/Ab combo 30tests/pkt 8 \n", "21 mindray 5 heaamatology reagent Diluent 20ml 2 \n", "22 Sarstedt multi-safe comfort 6l, sharp box 1 \n", "23 S- monovette 4.5ml lithium heparin Sarstedt ... 5 \n", "24 Blood group A typing serum 10ml/ 10 bottles /p... 2 \n", "25 Blood group AB typing serum 10ml/ 10 bottles /... 5 \n", "26 Blood group B typing serum 10ml/ 10 bottles /p... 5 \n", "27 Blood group D typing serum 10ml/ 10 bottles /p... 5 \n", "28 cellulose acetate strips shandon 60 x150mm x ... 1 \n", "29 Erytrocyte sedimentation rate, dispet 100/pkt 1 \n", "30 Febrile antigen test (OMEGA) 8 x 5ml with con... 9 \n", "31 Latex examination gloves (by Sempercare) 100 ... 2 \n", "32 Giemsa Stain 100ml/bottle ferntec biosciences 8 \n", "33 Pipette tips (1-200ul) blue type x 1000/pkt EP... 4 \n", "34 Sterilin type universal containers, (for urin... 4 \n", "\n", " VENDOR PRICES UNIT PRICE NAIRA VENDOR PRICES TOTAL PRICE NAIRA \\\n", "0 17298.00 NaN \n", "1 23663.00 NaN \n", "2 23663.00 NaN \n", "3 73346.00 NaN \n", "4 23688.00 NaN \n", "5 21841.00 NaN \n", "6 23663.00 NaN \n", "7 23663.00 NaN \n", "8 23688.00 NaN \n", "9 21841.00 NaN \n", "10 114933.82 NaN \n", "11 30195.00 NaN \n", "12 30992.00 NaN \n", "13 22018.00 NaN \n", "14 22018.00 NaN \n", "15 3643.25 NaN \n", "16 36303.00 NaN \n", "17 24254.00 NaN \n", "18 209995.80 NaN \n", "19 38675.00 NaN \n", "20 17550.00 NaN \n", "21 16333.00 NaN \n", "22 402570.00 NaN \n", "23 160384.00 NaN \n", "24 9000.00 NaN \n", "25 14000.00 NaN \n", "26 9000.00 NaN \n", "27 12000.00 NaN \n", "28 145000.00 NaN \n", "29 13500.00 NaN \n", "30 8500.00 NaN \n", "31 6500.00 NaN \n", "32 350.00 NaN \n", "33 1500.00 NaN \n", "34 14000.00 NaN \n", "\n", " CINUC PRICES UNIT PRICE NAIRA CINUC PRICES TOTAL PRICE NAIRA \\\n", "0 13989.90 NaN \n", "1 19137.38 NaN \n", "2 19137.38 NaN \n", "3 14019.97 NaN \n", "4 13989.90 NaN \n", "5 17664.03 NaN \n", "6 19137.38 NaN \n", "7 19137.38 NaN \n", "8 14999.70 NaN \n", "9 17664.03 NaN \n", "10 107626.37 NaN \n", "11 31745.30 NaN \n", "12 25064.32 NaN \n", "13 17806.27 NaN \n", "14 17806.27 NaN \n", "15 4199.92 NaN \n", "16 33994.64 NaN \n", "17 19615.01 NaN \n", "18 209995.80 NaN \n", "19 59998.80 NaN \n", "20 34999.30 NaN \n", "21 40949.18 NaN \n", "22 122997.54 NaN \n", "23 151996.96 NaN \n", "24 2499.95 NaN \n", "25 13999.72 NaN \n", "26 17999.64 NaN \n", "27 19999.60 NaN \n", "28 99998.00 NaN \n", "29 19999.60 NaN \n", "30 11499.77 NaN \n", "31 3499.93 NaN \n", "32 1199.98 NaN \n", "33 2999.94 NaN \n", "34 25499.49 NaN \n", "\n", " AFTER 10% REDUCTION CATEGORY \n", "0 NaN CLINICAL CHEMISTRY \n", "1 NaN CLINICAL CHEMISTRY \n", "2 NaN CLINICAL CHEMISTRY \n", "3 NaN CLINICAL CHEMISTRY \n", "4 NaN CLINICAL CHEMISTRY \n", "5 NaN CLINICAL CHEMISTRY \n", "6 NaN CLINICAL CHEMISTRY \n", "7 NaN CLINICAL CHEMISTRY \n", "8 NaN CLINICAL CHEMISTRY \n", "9 NaN CLINICAL CHEMISTRY \n", "10 NaN CLINICAL CHEMISTRY \n", "11 NaN CLINICAL CHEMISTRY \n", "12 NaN CLINICAL CHEMISTRY \n", "13 NaN CLINICAL CHEMISTRY \n", "14 NaN CLINICAL CHEMISTRY \n", "15 NaN CLINICAL CHEMISTRY \n", "16 NaN CLINICAL CHEMISTRY \n", "17 NaN CLINICAL CHEMISTRY \n", "18 NaN HEMATOLOGY AND SEROLOGY \n", "19 NaN HEMATOLOGY AND SEROLOGY \n", "20 NaN HEMATOLOGY AND SEROLOGY \n", "21 NaN HEMATOLOGY AND SEROLOGY \n", "22 NaN SAFETY PRODUCTS / MATRIALS \n", "23 NaN SAFETY PRODUCTS / MATRIALS \n", "24 NaN MICROBIOLOGY AND LABORATORY REAGENTS \n", "25 NaN MICROBIOLOGY AND LABORATORY REAGENTS \n", "26 NaN MICROBIOLOGY AND LABORATORY REAGENTS \n", "27 NaN MICROBIOLOGY AND LABORATORY REAGENTS \n", "28 NaN MICROBIOLOGY AND LABORATORY REAGENTS \n", "29 NaN MICROBIOLOGY AND LABORATORY REAGENTS \n", "30 NaN MICROBIOLOGY AND LABORATORY REAGENTS \n", "31 NaN MICROBIOLOGY AND LABORATORY REAGENTS \n", "32 NaN MICROBIOLOGY AND LABORATORY REAGENTS \n", "33 NaN MICROBIOLOGY AND LABORATORY REAGENTS \n", "34 NaN MICROBIOLOGY AND LABORATORY REAGENTS " ] }, "execution_count": 35, "metadata": {}, "output_type": "execute_result" } ], "source": [ "forth_call_off_1 = forth_call_off[forth_call_off.columns[1:]]\n", "forth_call_off_1" ] }, { "cell_type": "code", "execution_count": 36, "metadata": {}, "outputs": [], "source": [ "# calculating percentage difference\n", "forth_call_off_1['Percentage diff'] = ((forth_call_off_1['CINUC PRICES UNIT PRICE NAIRA'] - forth_call_off_1['VENDOR PRICES UNIT PRICE NAIRA']) / forth_call_off_1['CINUC PRICES UNIT PRICE NAIRA']) * 100" ] }, { "cell_type": "code", "execution_count": 37, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
PRODUCTSQTYVENDOR PRICES UNIT PRICE NAIRAVENDOR PRICES TOTAL PRICE NAIRACINUC PRICES UNIT PRICE NAIRACINUC PRICES TOTAL PRICE NAIRAAFTER 10% REDUCTIONCATEGORYPercentage diff
0Reflotron Glucose 15 x 2 stripes /pkt517298.00NaN13989.90NaNNaNCLINICAL CHEMISTRY-23.646345
1Reflotron Creatinine x30 stripes/pkt1023663.00NaN19137.38NaNNaNCLINICAL CHEMISTRY-23.648065
2Reflotron Triglycerides x30 stripes/pkt223663.00NaN19137.38NaNNaNCLINICAL CHEMISTRY-23.648065
3Epson ribbon for Reflotron printer473346.00NaN14019.97NaNNaNCLINICAL CHEMISTRY-423.153759
4Reflotron Pancreatic Amylase 15x2 stripes/pkt223688.00NaN13989.90NaNNaNCLINICAL CHEMISTRY-69.322154
5Reflotron Bilirubin x 30 stripes/pkt1721841.00NaN17664.03NaNNaNCLINICAL CHEMISTRY-23.646756
6Reflotron AST/GOT x30 stripes/pkt823663.00NaN19137.38NaNNaNCLINICAL CHEMISTRY-23.648065
7Reflotron GPT/ALT x 30 stripes/pkt823663.00NaN19137.38NaNNaNCLINICAL CHEMISTRY-23.648065
8Reflotron Urea 15 x 2 stripes/pkt823688.00NaN14999.70NaNNaNCLINICAL CHEMISTRY-57.923158
9Reflotron Gamma GT x 30 stripes/pkt621841.00NaN17664.03NaNNaNCLINICAL CHEMISTRY-23.646756
10PROBE SET COBAS c1111114933.82NaN107626.37NaNNaNCLINICAL CHEMISTRY-6.789646
11COBAS 3 C111 CLEANER730195.00NaN31745.30NaNNaNCLINICAL CHEMISTRY4.883558
12COBAS C 11 GLU2 GLUCOSE 400 TESTS430992.00NaN25064.32NaNNaNCLINICAL CHEMISTRY-23.649874
13COBAS C 111 ALT (GPT) 400 TESTS422018.00NaN17806.27NaNNaNCLINICAL CHEMISTRY-23.653073
14COBAS C 111 AST (GOT) 400 TESTS422018.00NaN17806.27NaNNaNCLINICAL CHEMISTRY-23.653073
15COBAS C 111 PRINTER PAPER 4 rolls /PKT13643.25NaN4199.92NaNNaNCLINICAL CHEMISTRY13.254300
16COBAS C 111 BLT3 TOTAL BILIRUBIN536303.00NaN33994.64NaNNaNCLINICAL CHEMISTRY-6.790365
17COBAS C 111 UREA 400 TESTS424254.00NaN19615.01NaNNaNCLINICAL CHEMISTRY-23.650205
18QBC HEAMATOLOGY/MALARIA TUBES 250T20209995.80NaN209995.80NaNNaNHEMATOLOGY AND SEROLOGY0.000000
19SD malaria Ag Pf.kit for single use, 25/pkt B...2038675.00NaN59998.80NaNNaNHEMATOLOGY AND SEROLOGY35.540377
20SD BIO LINE HIV Ag/Ab combo 30tests/pkt817550.00NaN34999.30NaNNaNHEMATOLOGY AND SEROLOGY49.856140
21mindray 5 heaamatology reagent Diluent 20ml216333.00NaN40949.18NaNNaNHEMATOLOGY AND SEROLOGY60.113975
22Sarstedt multi-safe comfort 6l, sharp box1402570.00NaN122997.54NaNNaNSAFETY PRODUCTS / MATRIALS-227.299229
23S- monovette 4.5ml lithium heparin Sarstedt ...5160384.00NaN151996.96NaNNaNSAFETY PRODUCTS / MATRIALS-5.517900
24Blood group A typing serum 10ml/ 10 bottles /p...29000.00NaN2499.95NaNNaNMICROBIOLOGY AND LABORATORY REAGENTS-260.007200
25Blood group AB typing serum 10ml/ 10 bottles /...514000.00NaN13999.72NaNNaNMICROBIOLOGY AND LABORATORY REAGENTS-0.002000
26Blood group B typing serum 10ml/ 10 bottles /p...59000.00NaN17999.64NaNNaNMICROBIOLOGY AND LABORATORY REAGENTS49.999000
27Blood group D typing serum 10ml/ 10 bottles /p...512000.00NaN19999.60NaNNaNMICROBIOLOGY AND LABORATORY REAGENTS39.998800
28cellulose acetate strips shandon 60 x150mm x ...1145000.00NaN99998.00NaNNaNMICROBIOLOGY AND LABORATORY REAGENTS-45.002900
29Erytrocyte sedimentation rate, dispet 100/pkt113500.00NaN19999.60NaNNaNMICROBIOLOGY AND LABORATORY REAGENTS32.498650
30Febrile antigen test (OMEGA) 8 x 5ml with con...98500.00NaN11499.77NaNNaNMICROBIOLOGY AND LABORATORY REAGENTS26.085478
31Latex examination gloves (by Sempercare) 100 ...26500.00NaN3499.93NaNNaNMICROBIOLOGY AND LABORATORY REAGENTS-85.718000
32Giemsa Stain 100ml/bottle ferntec biosciences8350.00NaN1199.98NaNNaNMICROBIOLOGY AND LABORATORY REAGENTS70.832847
33Pipette tips (1-200ul) blue type x 1000/pkt EP...41500.00NaN2999.94NaNNaNMICROBIOLOGY AND LABORATORY REAGENTS49.999000
34Sterilin type universal containers, (for urin...414000.00NaN25499.49NaNNaNMICROBIOLOGY AND LABORATORY REAGENTS45.096941
\n", "
" ], "text/plain": [ " PRODUCTS QTY \\\n", "0 Reflotron Glucose 15 x 2 stripes /pkt 5 \n", "1 Reflotron Creatinine x30 stripes/pkt 10 \n", "2 Reflotron Triglycerides x30 stripes/pkt 2 \n", "3 Epson ribbon for Reflotron printer 4 \n", "4 Reflotron Pancreatic Amylase 15x2 stripes/pkt 2 \n", "5 Reflotron Bilirubin x 30 stripes/pkt 17 \n", "6 Reflotron AST/GOT x30 stripes/pkt 8 \n", "7 Reflotron GPT/ALT x 30 stripes/pkt 8 \n", "8 Reflotron Urea 15 x 2 stripes/pkt 8 \n", "9 Reflotron Gamma GT x 30 stripes/pkt 6 \n", "10 PROBE SET COBAS c111 1 \n", "11 COBAS 3 C111 CLEANER 7 \n", "12 COBAS C 11 GLU2 GLUCOSE 400 TESTS 4 \n", "13 COBAS C 111 ALT (GPT) 400 TESTS 4 \n", "14 COBAS C 111 AST (GOT) 400 TESTS 4 \n", "15 COBAS C 111 PRINTER PAPER 4 rolls /PKT 1 \n", "16 COBAS C 111 BLT3 TOTAL BILIRUBIN 5 \n", "17 COBAS C 111 UREA 400 TESTS 4 \n", "18 QBC HEAMATOLOGY/MALARIA TUBES 250T 20 \n", "19 SD malaria Ag Pf.kit for single use, 25/pkt B... 20 \n", "20 SD BIO LINE HIV Ag/Ab combo 30tests/pkt 8 \n", "21 mindray 5 heaamatology reagent Diluent 20ml 2 \n", "22 Sarstedt multi-safe comfort 6l, sharp box 1 \n", "23 S- monovette 4.5ml lithium heparin Sarstedt ... 5 \n", "24 Blood group A typing serum 10ml/ 10 bottles /p... 2 \n", "25 Blood group AB typing serum 10ml/ 10 bottles /... 5 \n", "26 Blood group B typing serum 10ml/ 10 bottles /p... 5 \n", "27 Blood group D typing serum 10ml/ 10 bottles /p... 5 \n", "28 cellulose acetate strips shandon 60 x150mm x ... 1 \n", "29 Erytrocyte sedimentation rate, dispet 100/pkt 1 \n", "30 Febrile antigen test (OMEGA) 8 x 5ml with con... 9 \n", "31 Latex examination gloves (by Sempercare) 100 ... 2 \n", "32 Giemsa Stain 100ml/bottle ferntec biosciences 8 \n", "33 Pipette tips (1-200ul) blue type x 1000/pkt EP... 4 \n", "34 Sterilin type universal containers, (for urin... 4 \n", "\n", " VENDOR PRICES UNIT PRICE NAIRA VENDOR PRICES TOTAL PRICE NAIRA \\\n", "0 17298.00 NaN \n", "1 23663.00 NaN \n", "2 23663.00 NaN \n", "3 73346.00 NaN \n", "4 23688.00 NaN \n", "5 21841.00 NaN \n", "6 23663.00 NaN \n", "7 23663.00 NaN \n", "8 23688.00 NaN \n", "9 21841.00 NaN \n", "10 114933.82 NaN \n", "11 30195.00 NaN \n", "12 30992.00 NaN \n", "13 22018.00 NaN \n", "14 22018.00 NaN \n", "15 3643.25 NaN \n", "16 36303.00 NaN \n", "17 24254.00 NaN \n", "18 209995.80 NaN \n", "19 38675.00 NaN \n", "20 17550.00 NaN \n", "21 16333.00 NaN \n", "22 402570.00 NaN \n", "23 160384.00 NaN \n", "24 9000.00 NaN \n", "25 14000.00 NaN \n", "26 9000.00 NaN \n", "27 12000.00 NaN \n", "28 145000.00 NaN \n", "29 13500.00 NaN \n", "30 8500.00 NaN \n", "31 6500.00 NaN \n", "32 350.00 NaN \n", "33 1500.00 NaN \n", "34 14000.00 NaN \n", "\n", " CINUC PRICES UNIT PRICE NAIRA CINUC PRICES TOTAL PRICE NAIRA \\\n", "0 13989.90 NaN \n", "1 19137.38 NaN \n", "2 19137.38 NaN \n", "3 14019.97 NaN \n", "4 13989.90 NaN \n", "5 17664.03 NaN \n", "6 19137.38 NaN \n", "7 19137.38 NaN \n", "8 14999.70 NaN \n", "9 17664.03 NaN \n", "10 107626.37 NaN \n", "11 31745.30 NaN \n", "12 25064.32 NaN \n", "13 17806.27 NaN \n", "14 17806.27 NaN \n", "15 4199.92 NaN \n", "16 33994.64 NaN \n", "17 19615.01 NaN \n", "18 209995.80 NaN \n", "19 59998.80 NaN \n", "20 34999.30 NaN \n", "21 40949.18 NaN \n", "22 122997.54 NaN \n", "23 151996.96 NaN \n", "24 2499.95 NaN \n", "25 13999.72 NaN \n", "26 17999.64 NaN \n", "27 19999.60 NaN \n", "28 99998.00 NaN \n", "29 19999.60 NaN \n", "30 11499.77 NaN \n", "31 3499.93 NaN \n", "32 1199.98 NaN \n", "33 2999.94 NaN \n", "34 25499.49 NaN \n", "\n", " AFTER 10% REDUCTION CATEGORY \\\n", "0 NaN CLINICAL CHEMISTRY \n", "1 NaN CLINICAL CHEMISTRY \n", "2 NaN CLINICAL CHEMISTRY \n", "3 NaN CLINICAL CHEMISTRY \n", "4 NaN CLINICAL CHEMISTRY \n", "5 NaN CLINICAL CHEMISTRY \n", "6 NaN CLINICAL CHEMISTRY \n", "7 NaN CLINICAL CHEMISTRY \n", "8 NaN CLINICAL CHEMISTRY \n", "9 NaN CLINICAL CHEMISTRY \n", "10 NaN CLINICAL CHEMISTRY \n", "11 NaN CLINICAL CHEMISTRY \n", "12 NaN CLINICAL CHEMISTRY \n", "13 NaN CLINICAL CHEMISTRY \n", "14 NaN CLINICAL CHEMISTRY \n", "15 NaN CLINICAL CHEMISTRY \n", "16 NaN CLINICAL CHEMISTRY \n", "17 NaN CLINICAL CHEMISTRY \n", "18 NaN HEMATOLOGY AND SEROLOGY \n", "19 NaN HEMATOLOGY AND SEROLOGY \n", "20 NaN HEMATOLOGY AND SEROLOGY \n", "21 NaN HEMATOLOGY AND SEROLOGY \n", "22 NaN SAFETY PRODUCTS / MATRIALS \n", "23 NaN SAFETY PRODUCTS / MATRIALS \n", "24 NaN MICROBIOLOGY AND LABORATORY REAGENTS \n", "25 NaN MICROBIOLOGY AND LABORATORY REAGENTS \n", "26 NaN MICROBIOLOGY AND LABORATORY REAGENTS \n", "27 NaN MICROBIOLOGY AND LABORATORY REAGENTS \n", "28 NaN MICROBIOLOGY AND LABORATORY REAGENTS \n", "29 NaN MICROBIOLOGY AND LABORATORY REAGENTS \n", "30 NaN MICROBIOLOGY AND LABORATORY REAGENTS \n", "31 NaN MICROBIOLOGY AND LABORATORY REAGENTS \n", "32 NaN MICROBIOLOGY AND LABORATORY REAGENTS \n", "33 NaN MICROBIOLOGY AND LABORATORY REAGENTS \n", "34 NaN MICROBIOLOGY AND LABORATORY REAGENTS \n", "\n", " Percentage diff \n", "0 -23.646345 \n", "1 -23.648065 \n", "2 -23.648065 \n", "3 -423.153759 \n", "4 -69.322154 \n", "5 -23.646756 \n", "6 -23.648065 \n", "7 -23.648065 \n", "8 -57.923158 \n", "9 -23.646756 \n", "10 -6.789646 \n", "11 4.883558 \n", "12 -23.649874 \n", "13 -23.653073 \n", "14 -23.653073 \n", "15 13.254300 \n", "16 -6.790365 \n", "17 -23.650205 \n", "18 0.000000 \n", "19 35.540377 \n", "20 49.856140 \n", "21 60.113975 \n", "22 -227.299229 \n", "23 -5.517900 \n", "24 -260.007200 \n", "25 -0.002000 \n", "26 49.999000 \n", "27 39.998800 \n", "28 -45.002900 \n", "29 32.498650 \n", "30 26.085478 \n", "31 -85.718000 \n", "32 70.832847 \n", "33 49.999000 \n", "34 45.096941 " ] }, "execution_count": 37, "metadata": {}, "output_type": "execute_result" } ], "source": [ "forth_call_off_1" ] }, { "cell_type": "code", "execution_count": 38, "metadata": {}, "outputs": [], "source": [ "forth_call_off_1['PRODUCTS'] = forth_call_off_1['PRODUCTS'].str.replace(r'\\s+', ' ', regex=True).str.strip()" ] }, { "cell_type": "code", "execution_count": 39, "metadata": {}, "outputs": [], "source": [ "forth_call_off_1['CINUC PRICE'] = forth_call_off_1['VENDOR PRICES UNIT PRICE NAIRA']\n", "forth_call_off_1['UNIT NGN'] = forth_call_off_1['CINUC PRICES UNIT PRICE NAIRA']" ] }, { "cell_type": "code", "execution_count": 40, "metadata": {}, "outputs": [], "source": [ "forth_call_off_1['DATE'] = \"8/5/2022\"\n", "forth_call_off_1['EXCHANGE RATE'] = 416.690002" ] }, { "cell_type": "code", "execution_count": 41, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
PRODUCTSUNIT NGNCINUC PRICECATEGORYDATEEXCHANGE RATE
0Reflotron Glucose 15 x 2 stripes /pkt13989.9017298.00CLINICAL CHEMISTRY8/5/2022416.690002
1Reflotron Creatinine x30 stripes/pkt19137.3823663.00CLINICAL CHEMISTRY8/5/2022416.690002
2Reflotron Triglycerides x30 stripes/pkt19137.3823663.00CLINICAL CHEMISTRY8/5/2022416.690002
3Epson ribbon for Reflotron printer14019.9773346.00CLINICAL CHEMISTRY8/5/2022416.690002
4Reflotron Pancreatic Amylase 15x2 stripes/pkt13989.9023688.00CLINICAL CHEMISTRY8/5/2022416.690002
5Reflotron Bilirubin x 30 stripes/pkt17664.0321841.00CLINICAL CHEMISTRY8/5/2022416.690002
6Reflotron AST/GOT x30 stripes/pkt19137.3823663.00CLINICAL CHEMISTRY8/5/2022416.690002
7Reflotron GPT/ALT x 30 stripes/pkt19137.3823663.00CLINICAL CHEMISTRY8/5/2022416.690002
8Reflotron Urea 15 x 2 stripes/pkt14999.7023688.00CLINICAL CHEMISTRY8/5/2022416.690002
9Reflotron Gamma GT x 30 stripes/pkt17664.0321841.00CLINICAL CHEMISTRY8/5/2022416.690002
10PROBE SET COBAS c111107626.37114933.82CLINICAL CHEMISTRY8/5/2022416.690002
11COBAS 3 C111 CLEANER31745.3030195.00CLINICAL CHEMISTRY8/5/2022416.690002
12COBAS C 11 GLU2 GLUCOSE 400 TESTS25064.3230992.00CLINICAL CHEMISTRY8/5/2022416.690002
13COBAS C 111 ALT (GPT) 400 TESTS17806.2722018.00CLINICAL CHEMISTRY8/5/2022416.690002
14COBAS C 111 AST (GOT) 400 TESTS17806.2722018.00CLINICAL CHEMISTRY8/5/2022416.690002
15COBAS C 111 PRINTER PAPER 4 rolls /PKT4199.923643.25CLINICAL CHEMISTRY8/5/2022416.690002
16COBAS C 111 BLT3 TOTAL BILIRUBIN33994.6436303.00CLINICAL CHEMISTRY8/5/2022416.690002
17COBAS C 111 UREA 400 TESTS19615.0124254.00CLINICAL CHEMISTRY8/5/2022416.690002
18QBC HEAMATOLOGY/MALARIA TUBES 250T209995.80209995.80HEMATOLOGY AND SEROLOGY8/5/2022416.690002
19SD malaria Ag Pf.kit for single use, 25/pkt BI...59998.8038675.00HEMATOLOGY AND SEROLOGY8/5/2022416.690002
20SD BIO LINE HIV Ag/Ab combo 30tests/pkt34999.3017550.00HEMATOLOGY AND SEROLOGY8/5/2022416.690002
21mindray 5 heaamatology reagent Diluent 20ml40949.1816333.00HEMATOLOGY AND SEROLOGY8/5/2022416.690002
22Sarstedt multi-safe comfort 6l, sharp box122997.54402570.00SAFETY PRODUCTS / MATRIALS8/5/2022416.690002
23S- monovette 4.5ml lithium heparin Sarstedt x ...151996.96160384.00SAFETY PRODUCTS / MATRIALS8/5/2022416.690002
24Blood group A typing serum 10ml/ 10 bottles /p...2499.959000.00MICROBIOLOGY AND LABORATORY REAGENTS8/5/2022416.690002
25Blood group AB typing serum 10ml/ 10 bottles /...13999.7214000.00MICROBIOLOGY AND LABORATORY REAGENTS8/5/2022416.690002
26Blood group B typing serum 10ml/ 10 bottles /p...17999.649000.00MICROBIOLOGY AND LABORATORY REAGENTS8/5/2022416.690002
27Blood group D typing serum 10ml/ 10 bottles /p...19999.6012000.00MICROBIOLOGY AND LABORATORY REAGENTS8/5/2022416.690002
28cellulose acetate strips shandon 60 x150mm x 1...99998.00145000.00MICROBIOLOGY AND LABORATORY REAGENTS8/5/2022416.690002
29Erytrocyte sedimentation rate, dispet 100/pkt19999.6013500.00MICROBIOLOGY AND LABORATORY REAGENTS8/5/2022416.690002
30Febrile antigen test (OMEGA) 8 x 5ml with cont...11499.778500.00MICROBIOLOGY AND LABORATORY REAGENTS8/5/2022416.690002
31Latex examination gloves (by Sempercare) 100 8-9L3499.936500.00MICROBIOLOGY AND LABORATORY REAGENTS8/5/2022416.690002
32Giemsa Stain 100ml/bottle ferntec biosciences1199.98350.00MICROBIOLOGY AND LABORATORY REAGENTS8/5/2022416.690002
33Pipette tips (1-200ul) blue type x 1000/pkt EP...2999.941500.00MICROBIOLOGY AND LABORATORY REAGENTS8/5/2022416.690002
34Sterilin type universal containers, (for urine...25499.4914000.00MICROBIOLOGY AND LABORATORY REAGENTS8/5/2022416.690002
\n", "
" ], "text/plain": [ " PRODUCTS UNIT NGN CINUC PRICE \\\n", "0 Reflotron Glucose 15 x 2 stripes /pkt 13989.90 17298.00 \n", "1 Reflotron Creatinine x30 stripes/pkt 19137.38 23663.00 \n", "2 Reflotron Triglycerides x30 stripes/pkt 19137.38 23663.00 \n", "3 Epson ribbon for Reflotron printer 14019.97 73346.00 \n", "4 Reflotron Pancreatic Amylase 15x2 stripes/pkt 13989.90 23688.00 \n", "5 Reflotron Bilirubin x 30 stripes/pkt 17664.03 21841.00 \n", "6 Reflotron AST/GOT x30 stripes/pkt 19137.38 23663.00 \n", "7 Reflotron GPT/ALT x 30 stripes/pkt 19137.38 23663.00 \n", "8 Reflotron Urea 15 x 2 stripes/pkt 14999.70 23688.00 \n", "9 Reflotron Gamma GT x 30 stripes/pkt 17664.03 21841.00 \n", "10 PROBE SET COBAS c111 107626.37 114933.82 \n", "11 COBAS 3 C111 CLEANER 31745.30 30195.00 \n", "12 COBAS C 11 GLU2 GLUCOSE 400 TESTS 25064.32 30992.00 \n", "13 COBAS C 111 ALT (GPT) 400 TESTS 17806.27 22018.00 \n", "14 COBAS C 111 AST (GOT) 400 TESTS 17806.27 22018.00 \n", "15 COBAS C 111 PRINTER PAPER 4 rolls /PKT 4199.92 3643.25 \n", "16 COBAS C 111 BLT3 TOTAL BILIRUBIN 33994.64 36303.00 \n", "17 COBAS C 111 UREA 400 TESTS 19615.01 24254.00 \n", "18 QBC HEAMATOLOGY/MALARIA TUBES 250T 209995.80 209995.80 \n", "19 SD malaria Ag Pf.kit for single use, 25/pkt BI... 59998.80 38675.00 \n", "20 SD BIO LINE HIV Ag/Ab combo 30tests/pkt 34999.30 17550.00 \n", "21 mindray 5 heaamatology reagent Diluent 20ml 40949.18 16333.00 \n", "22 Sarstedt multi-safe comfort 6l, sharp box 122997.54 402570.00 \n", "23 S- monovette 4.5ml lithium heparin Sarstedt x ... 151996.96 160384.00 \n", "24 Blood group A typing serum 10ml/ 10 bottles /p... 2499.95 9000.00 \n", "25 Blood group AB typing serum 10ml/ 10 bottles /... 13999.72 14000.00 \n", "26 Blood group B typing serum 10ml/ 10 bottles /p... 17999.64 9000.00 \n", "27 Blood group D typing serum 10ml/ 10 bottles /p... 19999.60 12000.00 \n", "28 cellulose acetate strips shandon 60 x150mm x 1... 99998.00 145000.00 \n", "29 Erytrocyte sedimentation rate, dispet 100/pkt 19999.60 13500.00 \n", "30 Febrile antigen test (OMEGA) 8 x 5ml with cont... 11499.77 8500.00 \n", "31 Latex examination gloves (by Sempercare) 100 8-9L 3499.93 6500.00 \n", "32 Giemsa Stain 100ml/bottle ferntec biosciences 1199.98 350.00 \n", "33 Pipette tips (1-200ul) blue type x 1000/pkt EP... 2999.94 1500.00 \n", "34 Sterilin type universal containers, (for urine... 25499.49 14000.00 \n", "\n", " CATEGORY DATE EXCHANGE RATE \n", "0 CLINICAL CHEMISTRY 8/5/2022 416.690002 \n", "1 CLINICAL CHEMISTRY 8/5/2022 416.690002 \n", "2 CLINICAL CHEMISTRY 8/5/2022 416.690002 \n", "3 CLINICAL CHEMISTRY 8/5/2022 416.690002 \n", "4 CLINICAL CHEMISTRY 8/5/2022 416.690002 \n", "5 CLINICAL CHEMISTRY 8/5/2022 416.690002 \n", "6 CLINICAL CHEMISTRY 8/5/2022 416.690002 \n", "7 CLINICAL CHEMISTRY 8/5/2022 416.690002 \n", "8 CLINICAL CHEMISTRY 8/5/2022 416.690002 \n", "9 CLINICAL CHEMISTRY 8/5/2022 416.690002 \n", "10 CLINICAL CHEMISTRY 8/5/2022 416.690002 \n", "11 CLINICAL CHEMISTRY 8/5/2022 416.690002 \n", "12 CLINICAL CHEMISTRY 8/5/2022 416.690002 \n", "13 CLINICAL CHEMISTRY 8/5/2022 416.690002 \n", "14 CLINICAL CHEMISTRY 8/5/2022 416.690002 \n", "15 CLINICAL CHEMISTRY 8/5/2022 416.690002 \n", "16 CLINICAL CHEMISTRY 8/5/2022 416.690002 \n", "17 CLINICAL CHEMISTRY 8/5/2022 416.690002 \n", "18 HEMATOLOGY AND SEROLOGY 8/5/2022 416.690002 \n", "19 HEMATOLOGY AND SEROLOGY 8/5/2022 416.690002 \n", "20 HEMATOLOGY AND SEROLOGY 8/5/2022 416.690002 \n", "21 HEMATOLOGY AND SEROLOGY 8/5/2022 416.690002 \n", "22 SAFETY PRODUCTS / MATRIALS 8/5/2022 416.690002 \n", "23 SAFETY PRODUCTS / MATRIALS 8/5/2022 416.690002 \n", "24 MICROBIOLOGY AND LABORATORY REAGENTS 8/5/2022 416.690002 \n", "25 MICROBIOLOGY AND LABORATORY REAGENTS 8/5/2022 416.690002 \n", "26 MICROBIOLOGY AND LABORATORY REAGENTS 8/5/2022 416.690002 \n", "27 MICROBIOLOGY AND LABORATORY REAGENTS 8/5/2022 416.690002 \n", "28 MICROBIOLOGY AND LABORATORY REAGENTS 8/5/2022 416.690002 \n", "29 MICROBIOLOGY AND LABORATORY REAGENTS 8/5/2022 416.690002 \n", "30 MICROBIOLOGY AND LABORATORY REAGENTS 8/5/2022 416.690002 \n", "31 MICROBIOLOGY AND LABORATORY REAGENTS 8/5/2022 416.690002 \n", "32 MICROBIOLOGY AND LABORATORY REAGENTS 8/5/2022 416.690002 \n", "33 MICROBIOLOGY AND LABORATORY REAGENTS 8/5/2022 416.690002 \n", "34 MICROBIOLOGY AND LABORATORY REAGENTS 8/5/2022 416.690002 " ] }, "execution_count": 41, "metadata": {}, "output_type": "execute_result" } ], "source": [ "cols = ['PRODUCTS', 'UNIT NGN', 'CINUC PRICE', 'CATEGORY', 'DATE', 'EXCHANGE RATE']\n", "forth_call_off_df = forth_call_off_1[cols]\n", "forth_call_off_df" ] }, { "cell_type": "code", "execution_count": 42, "metadata": {}, "outputs": [], "source": [ "# saving as csv file\n", "forth_call_off_df.to_csv('fourth_call_off_stock.csv', index=False)" ] }, { "cell_type": "code", "execution_count": 43, "metadata": {}, "outputs": [], "source": [ "# April Two years ago\n", "\n", "fourth_call_off_abc = pd.read_excel('FOURTH CALL-OFF A, B, C SUPPLY-EDITED.xlsx', skiprows=2)" ] }, { "cell_type": "code", "execution_count": 44, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
S/NPRODUCTSQTYVENDOR PRICES - A UNIT PRICE NAIRAVENDOR PRICES - A TOTAL PRICE NAIRAQTY.1CINUC PRICES- B UNIT PRICE NAIRACINUC PRICES- B TOTAL PRICE NAIRAAFTER 10% REDUCTIONQTY.2CINUC PRICES - C UNIT PRICE NAIRACINUC PRICES - C TOTAL PRICE NAIRAAFTER 10% REDUCTION.1CATEGORYQTY GIVEN FOR AQTY SIGNED FOR BQTY REMAINING AQTY REMAINING B
01.0Reflotron Glucose 15 x 2 stripes /pkt10.017298.0NaN15.013989.900000NaNNaN2513989.900000NaNNaNCLINICAL CHEMISTRY5.0NaNNaNNaN
1NaNReflotron Creatinine x30 stripes/pkt10.023663.0NaN7.019137.380000NaNNaN1719137.380000NaNNaNCLINICAL CHEMISTRY10.0NaNNaNNaN
2NaNReflotron Cholesterol x30 stripes/pkt10.023663.0NaN15.019137.380000NaNNaN2519137.380000NaNNaNCLINICAL CHEMISTRYNaNNaNNaNNaN
3NaNReflotron Triglycerides x30 stripes/pkt2.023663.0NaN2.019137.380000NaNNaN419137.380000NaNNaNCLINICAL CHEMISTRYNaNNaNNaNNaN
4NaNReflotron HDL Cholesterol x 30 stripes/pkt5.031863.0NaN6.025768.610000NaNNaN1125768.610000NaNNaNCLINICAL CHEMISTRYNaNNaNNaNNaN
.........................................................
58NaNSterilin type universal containers, (for urin...4.014000.0NaN1.025499.490000NaNNaN525499.490000NaNNaNMICROBIOLOGY AND LABORATORY REAGENTSNaNNaNNaNNaN
59NaNPSA i- chromax3.035000.0NaN2.041999.160000NaNNaN541999.160000NaNNaNHORMONE REAGENTSNaNNaNNaNNaN
60NaNHbA1C i- chromax3.035000.0NaN12.042199.160000NaNNaN1542199.160000NaNNaNHORMONE REAGENTSNaNNaNNaNNaN
61NaNS-monovette 2.6ml EDTA by Sarstedt x500/car...2.0145800.0NaN6.064998.700000NaNNaN864998.700000NaNNaNITEMS NOT LISTED IN FORTH CALL OFF BUT SUPPLIED1.01.0NaNNaN
62NaNLabacon H.pylori9.04500.0NaN3.034998.600014NaNNaN934998.600014NaNNaNITEMS NOT LISTED IN FORTH CALL OFF BUT SUPPLIED3.03.0NaNNaN
\n", "

63 rows × 18 columns

\n", "
" ], "text/plain": [ " S/N PRODUCTS QTY \\\n", "0 1.0 Reflotron Glucose 15 x 2 stripes /pkt 10.0 \n", "1 NaN Reflotron Creatinine x30 stripes/pkt 10.0 \n", "2 NaN Reflotron Cholesterol x30 stripes/pkt 10.0 \n", "3 NaN Reflotron Triglycerides x30 stripes/pkt 2.0 \n", "4 NaN Reflotron HDL Cholesterol x 30 stripes/pkt 5.0 \n", ".. ... ... ... \n", "58 NaN Sterilin type universal containers, (for urin... 4.0 \n", "59 NaN PSA i- chromax 3.0 \n", "60 NaN HbA1C i- chromax 3.0 \n", "61 NaN S-monovette 2.6ml EDTA by Sarstedt x500/car... 2.0 \n", "62 NaN Labacon H.pylori 9.0 \n", "\n", " VENDOR PRICES - A UNIT PRICE NAIRA VENDOR PRICES - A TOTAL PRICE NAIRA \\\n", "0 17298.0 NaN \n", "1 23663.0 NaN \n", "2 23663.0 NaN \n", "3 23663.0 NaN \n", "4 31863.0 NaN \n", ".. ... ... \n", "58 14000.0 NaN \n", "59 35000.0 NaN \n", "60 35000.0 NaN \n", "61 145800.0 NaN \n", "62 4500.0 NaN \n", "\n", " QTY.1 CINUC PRICES- B UNIT PRICE NAIRA \\\n", "0 15.0 13989.900000 \n", "1 7.0 19137.380000 \n", "2 15.0 19137.380000 \n", "3 2.0 19137.380000 \n", "4 6.0 25768.610000 \n", ".. ... ... \n", "58 1.0 25499.490000 \n", "59 2.0 41999.160000 \n", "60 12.0 42199.160000 \n", "61 6.0 64998.700000 \n", "62 3.0 34998.600014 \n", "\n", " CINUC PRICES- B TOTAL PRICE NAIRA AFTER 10% REDUCTION QTY.2 \\\n", "0 NaN NaN 25 \n", "1 NaN NaN 17 \n", "2 NaN NaN 25 \n", "3 NaN NaN 4 \n", "4 NaN NaN 11 \n", ".. ... ... ... \n", "58 NaN NaN 5 \n", "59 NaN NaN 5 \n", "60 NaN NaN 15 \n", "61 NaN NaN 8 \n", "62 NaN NaN 9 \n", "\n", " CINUC PRICES - C UNIT PRICE NAIRA CINUC PRICES - C TOTAL PRICE NAIRA \\\n", "0 13989.900000 NaN \n", "1 19137.380000 NaN \n", "2 19137.380000 NaN \n", "3 19137.380000 NaN \n", "4 25768.610000 NaN \n", ".. ... ... \n", "58 25499.490000 NaN \n", "59 41999.160000 NaN \n", "60 42199.160000 NaN \n", "61 64998.700000 NaN \n", "62 34998.600014 NaN \n", "\n", " AFTER 10% REDUCTION.1 CATEGORY \\\n", "0 NaN CLINICAL CHEMISTRY \n", "1 NaN CLINICAL CHEMISTRY \n", "2 NaN CLINICAL CHEMISTRY \n", "3 NaN CLINICAL CHEMISTRY \n", "4 NaN CLINICAL CHEMISTRY \n", ".. ... ... \n", "58 NaN MICROBIOLOGY AND LABORATORY REAGENTS \n", "59 NaN HORMONE REAGENTS \n", "60 NaN HORMONE REAGENTS \n", "61 NaN ITEMS NOT LISTED IN FORTH CALL OFF BUT SUPPLIED \n", "62 NaN ITEMS NOT LISTED IN FORTH CALL OFF BUT SUPPLIED \n", "\n", " QTY GIVEN FOR A QTY SIGNED FOR B QTY REMAINING A QTY REMAINING B \n", "0 5.0 NaN NaN NaN \n", "1 10.0 NaN NaN NaN \n", "2 NaN NaN NaN NaN \n", "3 NaN NaN NaN NaN \n", "4 NaN NaN NaN NaN \n", ".. ... ... ... ... \n", "58 NaN NaN NaN NaN \n", "59 NaN NaN NaN NaN \n", "60 NaN NaN NaN NaN \n", "61 1.0 1.0 NaN NaN \n", "62 3.0 3.0 NaN NaN \n", "\n", "[63 rows x 18 columns]" ] }, "execution_count": 44, "metadata": {}, "output_type": "execute_result" } ], "source": [ "fourth_call_off_abc" ] }, { "cell_type": "code", "execution_count": 45, "metadata": {}, "outputs": [], "source": [ "# filling nan with 0\n", "fourth_call_off_abc.fillna(0, inplace=True)" ] }, { "cell_type": "code", "execution_count": 46, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
S/NPRODUCTSQTYVENDOR PRICES - A UNIT PRICE NAIRAVENDOR PRICES - A TOTAL PRICE NAIRAQTY.1CINUC PRICES- B UNIT PRICE NAIRACINUC PRICES- B TOTAL PRICE NAIRAAFTER 10% REDUCTIONQTY.2CINUC PRICES - C UNIT PRICE NAIRACINUC PRICES - C TOTAL PRICE NAIRAAFTER 10% REDUCTION.1CATEGORYQTY GIVEN FOR AQTY SIGNED FOR BQTY REMAINING AQTY REMAINING B
01.0Reflotron Glucose 15 x 2 stripes /pkt10.017298.00.015.013989.9000000.00.02513989.9000000.00.0CLINICAL CHEMISTRY5.00.00.00.0
10.0Reflotron Creatinine x30 stripes/pkt10.023663.00.07.019137.3800000.00.01719137.3800000.00.0CLINICAL CHEMISTRY10.00.00.00.0
20.0Reflotron Cholesterol x30 stripes/pkt10.023663.00.015.019137.3800000.00.02519137.3800000.00.0CLINICAL CHEMISTRY0.00.00.00.0
30.0Reflotron Triglycerides x30 stripes/pkt2.023663.00.02.019137.3800000.00.0419137.3800000.00.0CLINICAL CHEMISTRY0.00.00.00.0
40.0Reflotron HDL Cholesterol x 30 stripes/pkt5.031863.00.06.025768.6100000.00.01125768.6100000.00.0CLINICAL CHEMISTRY0.00.00.00.0
.........................................................
580.0Sterilin type universal containers, (for urin...4.014000.00.01.025499.4900000.00.0525499.4900000.00.0MICROBIOLOGY AND LABORATORY REAGENTS0.00.00.00.0
590.0PSA i- chromax3.035000.00.02.041999.1600000.00.0541999.1600000.00.0HORMONE REAGENTS0.00.00.00.0
600.0HbA1C i- chromax3.035000.00.012.042199.1600000.00.01542199.1600000.00.0HORMONE REAGENTS0.00.00.00.0
610.0S-monovette 2.6ml EDTA by Sarstedt x500/car...2.0145800.00.06.064998.7000000.00.0864998.7000000.00.0ITEMS NOT LISTED IN FORTH CALL OFF BUT SUPPLIED1.01.00.00.0
620.0Labacon H.pylori9.04500.00.03.034998.6000140.00.0934998.6000140.00.0ITEMS NOT LISTED IN FORTH CALL OFF BUT SUPPLIED3.03.00.00.0
\n", "

63 rows × 18 columns

\n", "
" ], "text/plain": [ " S/N PRODUCTS QTY \\\n", "0 1.0 Reflotron Glucose 15 x 2 stripes /pkt 10.0 \n", "1 0.0 Reflotron Creatinine x30 stripes/pkt 10.0 \n", "2 0.0 Reflotron Cholesterol x30 stripes/pkt 10.0 \n", "3 0.0 Reflotron Triglycerides x30 stripes/pkt 2.0 \n", "4 0.0 Reflotron HDL Cholesterol x 30 stripes/pkt 5.0 \n", ".. ... ... ... \n", "58 0.0 Sterilin type universal containers, (for urin... 4.0 \n", "59 0.0 PSA i- chromax 3.0 \n", "60 0.0 HbA1C i- chromax 3.0 \n", "61 0.0 S-monovette 2.6ml EDTA by Sarstedt x500/car... 2.0 \n", "62 0.0 Labacon H.pylori 9.0 \n", "\n", " VENDOR PRICES - A UNIT PRICE NAIRA VENDOR PRICES - A TOTAL PRICE NAIRA \\\n", "0 17298.0 0.0 \n", "1 23663.0 0.0 \n", "2 23663.0 0.0 \n", "3 23663.0 0.0 \n", "4 31863.0 0.0 \n", ".. ... ... \n", "58 14000.0 0.0 \n", "59 35000.0 0.0 \n", "60 35000.0 0.0 \n", "61 145800.0 0.0 \n", "62 4500.0 0.0 \n", "\n", " QTY.1 CINUC PRICES- B UNIT PRICE NAIRA \\\n", "0 15.0 13989.900000 \n", "1 7.0 19137.380000 \n", "2 15.0 19137.380000 \n", "3 2.0 19137.380000 \n", "4 6.0 25768.610000 \n", ".. ... ... \n", "58 1.0 25499.490000 \n", "59 2.0 41999.160000 \n", "60 12.0 42199.160000 \n", "61 6.0 64998.700000 \n", "62 3.0 34998.600014 \n", "\n", " CINUC PRICES- B TOTAL PRICE NAIRA AFTER 10% REDUCTION QTY.2 \\\n", "0 0.0 0.0 25 \n", "1 0.0 0.0 17 \n", "2 0.0 0.0 25 \n", "3 0.0 0.0 4 \n", "4 0.0 0.0 11 \n", ".. ... ... ... \n", "58 0.0 0.0 5 \n", "59 0.0 0.0 5 \n", "60 0.0 0.0 15 \n", "61 0.0 0.0 8 \n", "62 0.0 0.0 9 \n", "\n", " CINUC PRICES - C UNIT PRICE NAIRA CINUC PRICES - C TOTAL PRICE NAIRA \\\n", "0 13989.900000 0.0 \n", "1 19137.380000 0.0 \n", "2 19137.380000 0.0 \n", "3 19137.380000 0.0 \n", "4 25768.610000 0.0 \n", ".. ... ... \n", "58 25499.490000 0.0 \n", "59 41999.160000 0.0 \n", "60 42199.160000 0.0 \n", "61 64998.700000 0.0 \n", "62 34998.600014 0.0 \n", "\n", " AFTER 10% REDUCTION.1 CATEGORY \\\n", "0 0.0 CLINICAL CHEMISTRY \n", "1 0.0 CLINICAL CHEMISTRY \n", "2 0.0 CLINICAL CHEMISTRY \n", "3 0.0 CLINICAL CHEMISTRY \n", "4 0.0 CLINICAL CHEMISTRY \n", ".. ... ... \n", "58 0.0 MICROBIOLOGY AND LABORATORY REAGENTS \n", "59 0.0 HORMONE REAGENTS \n", "60 0.0 HORMONE REAGENTS \n", "61 0.0 ITEMS NOT LISTED IN FORTH CALL OFF BUT SUPPLIED \n", "62 0.0 ITEMS NOT LISTED IN FORTH CALL OFF BUT SUPPLIED \n", "\n", " QTY GIVEN FOR A QTY SIGNED FOR B QTY REMAINING A QTY REMAINING B \n", "0 5.0 0.0 0.0 0.0 \n", "1 10.0 0.0 0.0 0.0 \n", "2 0.0 0.0 0.0 0.0 \n", "3 0.0 0.0 0.0 0.0 \n", "4 0.0 0.0 0.0 0.0 \n", ".. ... ... ... ... \n", "58 0.0 0.0 0.0 0.0 \n", "59 0.0 0.0 0.0 0.0 \n", "60 0.0 0.0 0.0 0.0 \n", "61 1.0 1.0 0.0 0.0 \n", "62 3.0 3.0 0.0 0.0 \n", "\n", "[63 rows x 18 columns]" ] }, "execution_count": 46, "metadata": {}, "output_type": "execute_result" } ], "source": [ "fourth_call_off_abc" ] }, { "cell_type": "code", "execution_count": 47, "metadata": {}, "outputs": [], "source": [ "# Calcculating percentage difference\n", "fourth_call_off_abc['Percentage diff B'] = ((fourth_call_off_abc['CINUC PRICES- B UNIT PRICE NAIRA'] - fourth_call_off_abc['VENDOR PRICES - A UNIT PRICE NAIRA']) / fourth_call_off_abc['CINUC PRICES- B UNIT PRICE NAIRA']) * 100\n", "fourth_call_off_abc['Percentage diff C'] = ((fourth_call_off_abc['CINUC PRICES - C UNIT PRICE NAIRA'] - fourth_call_off_abc['VENDOR PRICES - A UNIT PRICE NAIRA']) / fourth_call_off_abc['CINUC PRICES - C UNIT PRICE NAIRA']) * 100" ] }, { "cell_type": "code", "execution_count": 48, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
S/NPRODUCTSQTYVENDOR PRICES - A UNIT PRICE NAIRAVENDOR PRICES - A TOTAL PRICE NAIRAQTY.1CINUC PRICES- B UNIT PRICE NAIRACINUC PRICES- B TOTAL PRICE NAIRAAFTER 10% REDUCTIONQTY.2CINUC PRICES - C UNIT PRICE NAIRACINUC PRICES - C TOTAL PRICE NAIRAAFTER 10% REDUCTION.1CATEGORYQTY GIVEN FOR AQTY SIGNED FOR BQTY REMAINING AQTY REMAINING BPercentage diff BPercentage diff C
01.0Reflotron Glucose 15 x 2 stripes /pkt10.017298.000.015.013989.900.00.02513989.900.00.0CLINICAL CHEMISTRY5.00.00.00.0-23.646345-23.646345
10.0Reflotron Creatinine x30 stripes/pkt10.023663.000.07.019137.380.00.01719137.380.00.0CLINICAL CHEMISTRY10.00.00.00.0-23.648065-23.648065
20.0Reflotron Cholesterol x30 stripes/pkt10.023663.000.015.019137.380.00.02519137.380.00.0CLINICAL CHEMISTRY0.00.00.00.0-23.648065-23.648065
30.0Reflotron Triglycerides x30 stripes/pkt2.023663.000.02.019137.380.00.0419137.380.00.0CLINICAL CHEMISTRY0.00.00.00.0-23.648065-23.648065
40.0Reflotron HDL Cholesterol x 30 stripes/pkt5.031863.000.06.025768.610.00.01125768.610.00.0CLINICAL CHEMISTRY0.00.00.00.0-23.650441-23.650441
50.0Epson ribbon for Reflotron printer4.073346.000.022.014019.970.00.02614019.970.00.0CLINICAL CHEMISTRY0.00.00.00.0-423.153759-423.153759
60.0Reflotron Pancreatic Amylase 15x2 stripes/pkt2.023688.000.02.013989.900.00.0413989.900.00.0CLINICAL CHEMISTRY0.00.00.00.0-69.322154-69.322154
70.0Reflotron Bilirubin x 30 stripes/pkt17.021841.000.010.017664.030.00.02717664.030.00.0CLINICAL CHEMISTRY0.00.00.00.0-23.646756-23.646756
80.0Reflotron AST/GOT x30 stripes/pkt8.023663.000.07.019137.380.00.01519137.380.00.0CLINICAL CHEMISTRY0.00.00.00.0-23.648065-23.648065
90.0Reflotron GPT/ALT x 30 stripes/pkt8.023663.000.07.019137.380.00.01519137.380.00.0CLINICAL CHEMISTRY0.00.00.00.0-23.648065-23.648065
100.0Reflotron Alk.Phosphate x 30 stripes/pkt8.023663.000.07.019137.380.00.01519137.380.00.0CLINICAL CHEMISTRY0.00.00.00.0-23.648065-23.648065
110.0Reflotron Urea 15 x 2 stripes/pkt8.023688.000.08.014999.700.00.01614999.700.00.0CLINICAL CHEMISTRY4.04.00.00.0-57.923158-57.923158
120.0Reflotron Uric Acid x 30 stripes/pkt25.021512.000.010.019137.380.00.03519137.380.00.0CLINICAL CHEMISTRY4.04.00.00.0-12.408282-12.408282
130.0Reflotron Gamma GT x 30 stripes/pkt6.021841.000.03.017664.030.00.0917664.030.00.0CLINICAL CHEMISTRY0.00.00.00.0-23.646756-23.646756
140.0PROBE SET COBAS c1111.0114933.820.00.0107626.370.00.01107626.370.00.0CLINICAL CHEMISTRY0.00.00.00.0-6.789646-6.789646
150.0COBAS C 111 PRINTER PAPER 4 rolls /PKT3.03643.250.01.04199.920.00.044199.920.00.0CLINICAL CHEMISTRY0.00.00.00.013.25430013.254300
160.0COBAS C 111 Automated system CFAS 12 x 3ml b...3.036979.000.01.057667.720.00.0457667.720.00.0CLINICAL CHEMISTRY0.00.00.00.035.87573835.875738
170.0COBAS INTEGRA C 111 ACTIVATOR 9X12 ml bo...3.031936.000.01.029905.330.00.0429905.330.00.0CLINICAL CHEMISTRY0.00.00.00.0-6.790328-6.790328
180.0COBAS C 111 DEPROTEINIZER 2 bottles / pkt4.013393.000.02.010831.560.00.0610831.560.00.0CLINICAL CHEMISTRY0.00.00.00.0-23.647933-23.647933
190.0COBAS 3 C111 CLEANER7.030195.000.01.031745.300.00.0831745.300.00.0CLINICAL CHEMISTRY0.00.00.00.04.8835584.883558
200.0COBAS C 111 CHOL3 CHOLESTEROL 400 TESTS4.035303.000.03.028549.950.00.0728549.950.00.0CLINICAL CHEMISTRY0.00.00.00.0-23.653456-23.653456
210.0COBAS C 11 GLU2 GLUCOSE 400 TESTS4.030992.000.04.025064.320.00.0825064.320.00.0CLINICAL CHEMISTRY2.02.00.00.0-23.649874-23.649874
220.0COBAS C 111 ALKALINE PHOS 400 TESTS4.028027.000.03.035596.360.00.0735596.360.00.0CLINICAL CHEMISTRY0.00.00.00.021.26442121.264421
230.0COBAS C 111 ALT (GPT) 400 TESTS4.022018.000.03.017806.270.00.0717806.270.00.0CLINICAL CHEMISTRY2.02.00.00.0-23.653073-23.653073
240.0COBAS C 111 AST (GOT) 400 TESTS4.022018.000.03.017806.270.00.0717806.270.00.0CLINICAL CHEMISTRY2.02.00.00.0-23.653073-23.653073
250.0COBAS C 111 BLT3 TOTAL BILIRUBIN5.036303.000.02.033994.640.00.0733994.640.00.0CLINICAL CHEMISTRY0.00.00.00.0-6.790365-6.790365
260.0COBAS C 111 TRIGLYCERIDES 200 TESTS4.029712.000.03.024029.280.00.0724029.280.00.0CLINICAL CHEMISTRY0.00.00.00.0-23.649148-23.649148
270.0COBAS C 111 UREA 400 TESTS4.024254.000.03.019615.010.00.0719615.010.00.0CLINICAL CHEMISTRY4.04.00.00.0-23.650205-23.650205
280.0COBAS C 111 URIC ACID PLUS 400 TESTS2.099036.000.02.080092.960.00.0480092.960.00.0CLINICAL CHEMISTRY0.00.00.00.0-23.651317-23.651317
290.0QBC HEAMATOLOGY/MALARIA TUBES 250T20.0209995.800.010.0209995.800.00.030209995.800.00.0HEMATOLOGY AND SEROLOGY0.00.00.00.00.0000000.000000
300.0SD malaria Ag Pf.kit for single use, 25/pkt B...20.038675.000.00.059998.800.00.02059998.800.00.0HEMATOLOGY AND SEROLOGY0.00.00.00.035.54037735.540377
310.0SD malaria Ag Pf.kit for multiple use, 25/pkt ...12.04500.000.06.05999.880.00.0185999.880.00.0HEMATOLOGY AND SEROLOGY0.00.00.00.024.99850024.998500
320.0SD BIO LINE HIV Ag/Ab combo 30tests/pkt8.017550.000.00.034999.300.00.0834999.300.00.0HEMATOLOGY AND SEROLOGY0.00.00.00.049.85614049.856140
330.0AIC NOW catridge for HB Aic determination 10...20.062700.000.012.064998.700.00.03264998.700.00.0HEMATOLOGY AND SEROLOGY0.00.00.00.03.5365323.536532
340.0Mindray UA66 uirinalysis strips 50/pkt0.00.000.00.017999.640.00.03017999.640.00.0HEMATOLOGY AND SEROLOGY0.00.00.00.0100.000000100.000000
350.0mindray 5 heaamatology reagent Diluent 20ml2.016333.000.02.040949.180.00.0440949.180.00.0HEMATOLOGY AND SEROLOGY1.01.00.00.060.11397560.113975
360.0mindray 5 heaamatology reagent leo 1 lys...1.0139899.000.00.0269994.600.00.01269994.600.00.0HEMATOLOGY AND SEROLOGY0.00.00.00.048.18451948.184519
370.0mindray 5 heaamatology reagent leo 11 ly...1.0201748.000.00.0229995.400.00.01229995.400.00.0HEMATOLOGY AND SEROLOGY0.00.00.00.012.28172412.281724
380.0mindray 5 heaamatology reagent Rinse1L X 41.018414.000.00.0217195.660.00.01217195.660.00.0HEMATOLOGY AND SEROLOGY0.00.00.00.091.52193091.521930
390.0mindray 5 heaamatology reagent Cleaner3.046182.000.02.038499.230.00.0538499.230.00.0HEMATOLOGY AND SEROLOGY0.00.00.00.0-19.955646-19.955646
400.0mindray 5 heamtology reagents 53LH LYSE 500/ x42.0239373.000.00.0180496.390.00.02180496.390.00.0HEMATOLOGY AND SEROLOGY0.00.00.00.0-32.619273-32.619273
410.0Sarstedt multi-safe comfort 6l, sharp box1.0402570.000.01.0122997.540.00.02122997.540.00.0SAFETY PRODUCTS / MATRIALS0.00.00.00.0-227.299229-227.299229
420.0S- monovette 4.5ml lithium heparin Sarstedt ...5.0160384.000.02.0151996.960.00.07151996.960.00.0SAFETY PRODUCTS / MATRIALS0.00.00.00.0-5.517900-5.517900
430.0Antibiotics multidisk( AB-DISC) gram neg2.017000.000.01.015699.690.00.0315699.690.00.0MICROBIOLOGY AND LABORATORY REAGENTS0.00.00.00.0-8.282393-8.282393
440.0Antibiotics multidisk( AB-DISC) gram pos2.017000.000.01.015699.690.00.0315699.690.00.0MICROBIOLOGY AND LABORATORY REAGENTS0.00.00.00.0-8.282393-8.282393
450.0Agary 2ml single-use syringes 23G X11/4 100...5.01600.000.01.02799.940.00.062799.940.00.0MICROBIOLOGY AND LABORATORY REAGENTS0.00.00.00.042.85591842.855918
460.0Blood group A typing serum 10ml/ 10 bottles /p...2.09000.000.06.02499.950.00.082499.950.00.0MICROBIOLOGY AND LABORATORY REAGENTS0.00.00.00.0-260.007200-260.007200
470.0Blood group AB typing serum 10ml/ 10 bottles /...5.014000.000.03.013999.720.00.0813999.720.00.0MICROBIOLOGY AND LABORATORY REAGENTS0.00.00.00.0-0.002000-0.002000
480.0Blood group B typing serum 10ml/ 10 bottles /p...5.09000.000.03.017999.640.00.0817999.640.00.0MICROBIOLOGY AND LABORATORY REAGENTS0.00.00.00.049.99900049.999000
490.0Blood group D typing serum 10ml/ 10 bottles /p...5.012000.000.03.019999.600.00.0819999.600.00.0MICROBIOLOGY AND LABORATORY REAGENTS0.00.00.00.039.99880039.998800
\n", "
" ], "text/plain": [ " S/N PRODUCTS QTY \\\n", "0 1.0 Reflotron Glucose 15 x 2 stripes /pkt 10.0 \n", "1 0.0 Reflotron Creatinine x30 stripes/pkt 10.0 \n", "2 0.0 Reflotron Cholesterol x30 stripes/pkt 10.0 \n", "3 0.0 Reflotron Triglycerides x30 stripes/pkt 2.0 \n", "4 0.0 Reflotron HDL Cholesterol x 30 stripes/pkt 5.0 \n", "5 0.0 Epson ribbon for Reflotron printer 4.0 \n", "6 0.0 Reflotron Pancreatic Amylase 15x2 stripes/pkt 2.0 \n", "7 0.0 Reflotron Bilirubin x 30 stripes/pkt 17.0 \n", "8 0.0 Reflotron AST/GOT x30 stripes/pkt 8.0 \n", "9 0.0 Reflotron GPT/ALT x 30 stripes/pkt 8.0 \n", "10 0.0 Reflotron Alk.Phosphate x 30 stripes/pkt 8.0 \n", "11 0.0 Reflotron Urea 15 x 2 stripes/pkt 8.0 \n", "12 0.0 Reflotron Uric Acid x 30 stripes/pkt 25.0 \n", "13 0.0 Reflotron Gamma GT x 30 stripes/pkt 6.0 \n", "14 0.0 PROBE SET COBAS c111 1.0 \n", "15 0.0 COBAS C 111 PRINTER PAPER 4 rolls /PKT 3.0 \n", "16 0.0 COBAS C 111 Automated system CFAS 12 x 3ml b... 3.0 \n", "17 0.0 COBAS INTEGRA C 111 ACTIVATOR 9X12 ml bo... 3.0 \n", "18 0.0 COBAS C 111 DEPROTEINIZER 2 bottles / pkt 4.0 \n", "19 0.0 COBAS 3 C111 CLEANER 7.0 \n", "20 0.0 COBAS C 111 CHOL3 CHOLESTEROL 400 TESTS 4.0 \n", "21 0.0 COBAS C 11 GLU2 GLUCOSE 400 TESTS 4.0 \n", "22 0.0 COBAS C 111 ALKALINE PHOS 400 TESTS 4.0 \n", "23 0.0 COBAS C 111 ALT (GPT) 400 TESTS 4.0 \n", "24 0.0 COBAS C 111 AST (GOT) 400 TESTS 4.0 \n", "25 0.0 COBAS C 111 BLT3 TOTAL BILIRUBIN 5.0 \n", "26 0.0 COBAS C 111 TRIGLYCERIDES 200 TESTS 4.0 \n", "27 0.0 COBAS C 111 UREA 400 TESTS 4.0 \n", "28 0.0 COBAS C 111 URIC ACID PLUS 400 TESTS 2.0 \n", "29 0.0 QBC HEAMATOLOGY/MALARIA TUBES 250T 20.0 \n", "30 0.0 SD malaria Ag Pf.kit for single use, 25/pkt B... 20.0 \n", "31 0.0 SD malaria Ag Pf.kit for multiple use, 25/pkt ... 12.0 \n", "32 0.0 SD BIO LINE HIV Ag/Ab combo 30tests/pkt 8.0 \n", "33 0.0 AIC NOW catridge for HB Aic determination 10... 20.0 \n", "34 0.0 Mindray UA66 uirinalysis strips 50/pkt 0.0 \n", "35 0.0 mindray 5 heaamatology reagent Diluent 20ml 2.0 \n", "36 0.0 mindray 5 heaamatology reagent leo 1 lys... 1.0 \n", "37 0.0 mindray 5 heaamatology reagent leo 11 ly... 1.0 \n", "38 0.0 mindray 5 heaamatology reagent Rinse1L X 4 1.0 \n", "39 0.0 mindray 5 heaamatology reagent Cleaner 3.0 \n", "40 0.0 mindray 5 heamtology reagents 53LH LYSE 500/ x4 2.0 \n", "41 0.0 Sarstedt multi-safe comfort 6l, sharp box 1.0 \n", "42 0.0 S- monovette 4.5ml lithium heparin Sarstedt ... 5.0 \n", "43 0.0 Antibiotics multidisk( AB-DISC) gram neg 2.0 \n", "44 0.0 Antibiotics multidisk( AB-DISC) gram pos 2.0 \n", "45 0.0 Agary 2ml single-use syringes 23G X11/4 100... 5.0 \n", "46 0.0 Blood group A typing serum 10ml/ 10 bottles /p... 2.0 \n", "47 0.0 Blood group AB typing serum 10ml/ 10 bottles /... 5.0 \n", "48 0.0 Blood group B typing serum 10ml/ 10 bottles /p... 5.0 \n", "49 0.0 Blood group D typing serum 10ml/ 10 bottles /p... 5.0 \n", "\n", " VENDOR PRICES - A UNIT PRICE NAIRA VENDOR PRICES - A TOTAL PRICE NAIRA \\\n", "0 17298.00 0.0 \n", "1 23663.00 0.0 \n", "2 23663.00 0.0 \n", "3 23663.00 0.0 \n", "4 31863.00 0.0 \n", "5 73346.00 0.0 \n", "6 23688.00 0.0 \n", "7 21841.00 0.0 \n", "8 23663.00 0.0 \n", "9 23663.00 0.0 \n", "10 23663.00 0.0 \n", "11 23688.00 0.0 \n", "12 21512.00 0.0 \n", "13 21841.00 0.0 \n", "14 114933.82 0.0 \n", "15 3643.25 0.0 \n", "16 36979.00 0.0 \n", "17 31936.00 0.0 \n", "18 13393.00 0.0 \n", "19 30195.00 0.0 \n", "20 35303.00 0.0 \n", "21 30992.00 0.0 \n", "22 28027.00 0.0 \n", "23 22018.00 0.0 \n", "24 22018.00 0.0 \n", "25 36303.00 0.0 \n", "26 29712.00 0.0 \n", "27 24254.00 0.0 \n", "28 99036.00 0.0 \n", "29 209995.80 0.0 \n", "30 38675.00 0.0 \n", "31 4500.00 0.0 \n", "32 17550.00 0.0 \n", "33 62700.00 0.0 \n", "34 0.00 0.0 \n", "35 16333.00 0.0 \n", "36 139899.00 0.0 \n", "37 201748.00 0.0 \n", "38 18414.00 0.0 \n", "39 46182.00 0.0 \n", "40 239373.00 0.0 \n", "41 402570.00 0.0 \n", "42 160384.00 0.0 \n", "43 17000.00 0.0 \n", "44 17000.00 0.0 \n", "45 1600.00 0.0 \n", "46 9000.00 0.0 \n", "47 14000.00 0.0 \n", "48 9000.00 0.0 \n", "49 12000.00 0.0 \n", "\n", " QTY.1 CINUC PRICES- B UNIT PRICE NAIRA \\\n", "0 15.0 13989.90 \n", "1 7.0 19137.38 \n", "2 15.0 19137.38 \n", "3 2.0 19137.38 \n", "4 6.0 25768.61 \n", "5 22.0 14019.97 \n", "6 2.0 13989.90 \n", "7 10.0 17664.03 \n", "8 7.0 19137.38 \n", "9 7.0 19137.38 \n", "10 7.0 19137.38 \n", "11 8.0 14999.70 \n", "12 10.0 19137.38 \n", "13 3.0 17664.03 \n", "14 0.0 107626.37 \n", "15 1.0 4199.92 \n", "16 1.0 57667.72 \n", "17 1.0 29905.33 \n", "18 2.0 10831.56 \n", "19 1.0 31745.30 \n", "20 3.0 28549.95 \n", "21 4.0 25064.32 \n", "22 3.0 35596.36 \n", "23 3.0 17806.27 \n", "24 3.0 17806.27 \n", "25 2.0 33994.64 \n", "26 3.0 24029.28 \n", "27 3.0 19615.01 \n", "28 2.0 80092.96 \n", "29 10.0 209995.80 \n", "30 0.0 59998.80 \n", "31 6.0 5999.88 \n", "32 0.0 34999.30 \n", "33 12.0 64998.70 \n", "34 0.0 17999.64 \n", "35 2.0 40949.18 \n", "36 0.0 269994.60 \n", "37 0.0 229995.40 \n", "38 0.0 217195.66 \n", "39 2.0 38499.23 \n", "40 0.0 180496.39 \n", "41 1.0 122997.54 \n", "42 2.0 151996.96 \n", "43 1.0 15699.69 \n", "44 1.0 15699.69 \n", "45 1.0 2799.94 \n", "46 6.0 2499.95 \n", "47 3.0 13999.72 \n", "48 3.0 17999.64 \n", "49 3.0 19999.60 \n", "\n", " CINUC PRICES- B TOTAL PRICE NAIRA AFTER 10% REDUCTION QTY.2 \\\n", "0 0.0 0.0 25 \n", "1 0.0 0.0 17 \n", "2 0.0 0.0 25 \n", "3 0.0 0.0 4 \n", "4 0.0 0.0 11 \n", "5 0.0 0.0 26 \n", "6 0.0 0.0 4 \n", "7 0.0 0.0 27 \n", "8 0.0 0.0 15 \n", "9 0.0 0.0 15 \n", "10 0.0 0.0 15 \n", "11 0.0 0.0 16 \n", "12 0.0 0.0 35 \n", "13 0.0 0.0 9 \n", "14 0.0 0.0 1 \n", "15 0.0 0.0 4 \n", "16 0.0 0.0 4 \n", "17 0.0 0.0 4 \n", "18 0.0 0.0 6 \n", "19 0.0 0.0 8 \n", "20 0.0 0.0 7 \n", "21 0.0 0.0 8 \n", "22 0.0 0.0 7 \n", "23 0.0 0.0 7 \n", "24 0.0 0.0 7 \n", "25 0.0 0.0 7 \n", "26 0.0 0.0 7 \n", "27 0.0 0.0 7 \n", "28 0.0 0.0 4 \n", "29 0.0 0.0 30 \n", "30 0.0 0.0 20 \n", "31 0.0 0.0 18 \n", "32 0.0 0.0 8 \n", "33 0.0 0.0 32 \n", "34 0.0 0.0 30 \n", "35 0.0 0.0 4 \n", "36 0.0 0.0 1 \n", "37 0.0 0.0 1 \n", "38 0.0 0.0 1 \n", "39 0.0 0.0 5 \n", "40 0.0 0.0 2 \n", "41 0.0 0.0 2 \n", "42 0.0 0.0 7 \n", "43 0.0 0.0 3 \n", "44 0.0 0.0 3 \n", "45 0.0 0.0 6 \n", "46 0.0 0.0 8 \n", "47 0.0 0.0 8 \n", "48 0.0 0.0 8 \n", "49 0.0 0.0 8 \n", "\n", " CINUC PRICES - C UNIT PRICE NAIRA CINUC PRICES - C TOTAL PRICE NAIRA \\\n", "0 13989.90 0.0 \n", "1 19137.38 0.0 \n", "2 19137.38 0.0 \n", "3 19137.38 0.0 \n", "4 25768.61 0.0 \n", "5 14019.97 0.0 \n", "6 13989.90 0.0 \n", "7 17664.03 0.0 \n", "8 19137.38 0.0 \n", "9 19137.38 0.0 \n", "10 19137.38 0.0 \n", "11 14999.70 0.0 \n", "12 19137.38 0.0 \n", "13 17664.03 0.0 \n", "14 107626.37 0.0 \n", "15 4199.92 0.0 \n", "16 57667.72 0.0 \n", "17 29905.33 0.0 \n", "18 10831.56 0.0 \n", "19 31745.30 0.0 \n", "20 28549.95 0.0 \n", "21 25064.32 0.0 \n", "22 35596.36 0.0 \n", "23 17806.27 0.0 \n", "24 17806.27 0.0 \n", "25 33994.64 0.0 \n", "26 24029.28 0.0 \n", "27 19615.01 0.0 \n", "28 80092.96 0.0 \n", "29 209995.80 0.0 \n", "30 59998.80 0.0 \n", "31 5999.88 0.0 \n", "32 34999.30 0.0 \n", "33 64998.70 0.0 \n", "34 17999.64 0.0 \n", "35 40949.18 0.0 \n", "36 269994.60 0.0 \n", "37 229995.40 0.0 \n", "38 217195.66 0.0 \n", "39 38499.23 0.0 \n", "40 180496.39 0.0 \n", "41 122997.54 0.0 \n", "42 151996.96 0.0 \n", "43 15699.69 0.0 \n", "44 15699.69 0.0 \n", "45 2799.94 0.0 \n", "46 2499.95 0.0 \n", "47 13999.72 0.0 \n", "48 17999.64 0.0 \n", "49 19999.60 0.0 \n", "\n", " AFTER 10% REDUCTION.1 CATEGORY \\\n", "0 0.0 CLINICAL CHEMISTRY \n", "1 0.0 CLINICAL CHEMISTRY \n", "2 0.0 CLINICAL CHEMISTRY \n", "3 0.0 CLINICAL CHEMISTRY \n", "4 0.0 CLINICAL CHEMISTRY \n", "5 0.0 CLINICAL CHEMISTRY \n", "6 0.0 CLINICAL CHEMISTRY \n", "7 0.0 CLINICAL CHEMISTRY \n", "8 0.0 CLINICAL CHEMISTRY \n", "9 0.0 CLINICAL CHEMISTRY \n", "10 0.0 CLINICAL CHEMISTRY \n", "11 0.0 CLINICAL CHEMISTRY \n", "12 0.0 CLINICAL CHEMISTRY \n", "13 0.0 CLINICAL CHEMISTRY \n", "14 0.0 CLINICAL CHEMISTRY \n", "15 0.0 CLINICAL CHEMISTRY \n", "16 0.0 CLINICAL CHEMISTRY \n", "17 0.0 CLINICAL CHEMISTRY \n", "18 0.0 CLINICAL CHEMISTRY \n", "19 0.0 CLINICAL CHEMISTRY \n", "20 0.0 CLINICAL CHEMISTRY \n", "21 0.0 CLINICAL CHEMISTRY \n", "22 0.0 CLINICAL CHEMISTRY \n", "23 0.0 CLINICAL CHEMISTRY \n", "24 0.0 CLINICAL CHEMISTRY \n", "25 0.0 CLINICAL CHEMISTRY \n", "26 0.0 CLINICAL CHEMISTRY \n", "27 0.0 CLINICAL CHEMISTRY \n", "28 0.0 CLINICAL CHEMISTRY \n", "29 0.0 HEMATOLOGY AND SEROLOGY \n", "30 0.0 HEMATOLOGY AND SEROLOGY \n", "31 0.0 HEMATOLOGY AND SEROLOGY \n", "32 0.0 HEMATOLOGY AND SEROLOGY \n", "33 0.0 HEMATOLOGY AND SEROLOGY \n", "34 0.0 HEMATOLOGY AND SEROLOGY \n", "35 0.0 HEMATOLOGY AND SEROLOGY \n", "36 0.0 HEMATOLOGY AND SEROLOGY \n", "37 0.0 HEMATOLOGY AND SEROLOGY \n", "38 0.0 HEMATOLOGY AND SEROLOGY \n", "39 0.0 HEMATOLOGY AND SEROLOGY \n", "40 0.0 HEMATOLOGY AND SEROLOGY \n", "41 0.0 SAFETY PRODUCTS / MATRIALS \n", "42 0.0 SAFETY PRODUCTS / MATRIALS \n", "43 0.0 MICROBIOLOGY AND LABORATORY REAGENTS \n", "44 0.0 MICROBIOLOGY AND LABORATORY REAGENTS \n", "45 0.0 MICROBIOLOGY AND LABORATORY REAGENTS \n", "46 0.0 MICROBIOLOGY AND LABORATORY REAGENTS \n", "47 0.0 MICROBIOLOGY AND LABORATORY REAGENTS \n", "48 0.0 MICROBIOLOGY AND LABORATORY REAGENTS \n", "49 0.0 MICROBIOLOGY AND LABORATORY REAGENTS \n", "\n", " QTY GIVEN FOR A QTY SIGNED FOR B QTY REMAINING A QTY REMAINING B \\\n", "0 5.0 0.0 0.0 0.0 \n", "1 10.0 0.0 0.0 0.0 \n", "2 0.0 0.0 0.0 0.0 \n", "3 0.0 0.0 0.0 0.0 \n", "4 0.0 0.0 0.0 0.0 \n", "5 0.0 0.0 0.0 0.0 \n", "6 0.0 0.0 0.0 0.0 \n", "7 0.0 0.0 0.0 0.0 \n", "8 0.0 0.0 0.0 0.0 \n", "9 0.0 0.0 0.0 0.0 \n", "10 0.0 0.0 0.0 0.0 \n", "11 4.0 4.0 0.0 0.0 \n", "12 4.0 4.0 0.0 0.0 \n", "13 0.0 0.0 0.0 0.0 \n", "14 0.0 0.0 0.0 0.0 \n", "15 0.0 0.0 0.0 0.0 \n", "16 0.0 0.0 0.0 0.0 \n", "17 0.0 0.0 0.0 0.0 \n", "18 0.0 0.0 0.0 0.0 \n", "19 0.0 0.0 0.0 0.0 \n", "20 0.0 0.0 0.0 0.0 \n", "21 2.0 2.0 0.0 0.0 \n", "22 0.0 0.0 0.0 0.0 \n", "23 2.0 2.0 0.0 0.0 \n", "24 2.0 2.0 0.0 0.0 \n", "25 0.0 0.0 0.0 0.0 \n", "26 0.0 0.0 0.0 0.0 \n", "27 4.0 4.0 0.0 0.0 \n", "28 0.0 0.0 0.0 0.0 \n", "29 0.0 0.0 0.0 0.0 \n", "30 0.0 0.0 0.0 0.0 \n", "31 0.0 0.0 0.0 0.0 \n", "32 0.0 0.0 0.0 0.0 \n", "33 0.0 0.0 0.0 0.0 \n", "34 0.0 0.0 0.0 0.0 \n", "35 1.0 1.0 0.0 0.0 \n", "36 0.0 0.0 0.0 0.0 \n", "37 0.0 0.0 0.0 0.0 \n", "38 0.0 0.0 0.0 0.0 \n", "39 0.0 0.0 0.0 0.0 \n", "40 0.0 0.0 0.0 0.0 \n", "41 0.0 0.0 0.0 0.0 \n", "42 0.0 0.0 0.0 0.0 \n", "43 0.0 0.0 0.0 0.0 \n", "44 0.0 0.0 0.0 0.0 \n", "45 0.0 0.0 0.0 0.0 \n", "46 0.0 0.0 0.0 0.0 \n", "47 0.0 0.0 0.0 0.0 \n", "48 0.0 0.0 0.0 0.0 \n", "49 0.0 0.0 0.0 0.0 \n", "\n", " Percentage diff B Percentage diff C \n", "0 -23.646345 -23.646345 \n", "1 -23.648065 -23.648065 \n", "2 -23.648065 -23.648065 \n", "3 -23.648065 -23.648065 \n", "4 -23.650441 -23.650441 \n", "5 -423.153759 -423.153759 \n", "6 -69.322154 -69.322154 \n", "7 -23.646756 -23.646756 \n", "8 -23.648065 -23.648065 \n", "9 -23.648065 -23.648065 \n", "10 -23.648065 -23.648065 \n", "11 -57.923158 -57.923158 \n", "12 -12.408282 -12.408282 \n", "13 -23.646756 -23.646756 \n", "14 -6.789646 -6.789646 \n", "15 13.254300 13.254300 \n", "16 35.875738 35.875738 \n", "17 -6.790328 -6.790328 \n", "18 -23.647933 -23.647933 \n", "19 4.883558 4.883558 \n", "20 -23.653456 -23.653456 \n", "21 -23.649874 -23.649874 \n", "22 21.264421 21.264421 \n", "23 -23.653073 -23.653073 \n", "24 -23.653073 -23.653073 \n", "25 -6.790365 -6.790365 \n", "26 -23.649148 -23.649148 \n", "27 -23.650205 -23.650205 \n", "28 -23.651317 -23.651317 \n", "29 0.000000 0.000000 \n", "30 35.540377 35.540377 \n", "31 24.998500 24.998500 \n", "32 49.856140 49.856140 \n", "33 3.536532 3.536532 \n", "34 100.000000 100.000000 \n", "35 60.113975 60.113975 \n", "36 48.184519 48.184519 \n", "37 12.281724 12.281724 \n", "38 91.521930 91.521930 \n", "39 -19.955646 -19.955646 \n", "40 -32.619273 -32.619273 \n", "41 -227.299229 -227.299229 \n", "42 -5.517900 -5.517900 \n", "43 -8.282393 -8.282393 \n", "44 -8.282393 -8.282393 \n", "45 42.855918 42.855918 \n", "46 -260.007200 -260.007200 \n", "47 -0.002000 -0.002000 \n", "48 49.999000 49.999000 \n", "49 39.998800 39.998800 " ] }, "execution_count": 48, "metadata": {}, "output_type": "execute_result" } ], "source": [ "fourth_call_off_abc[:50]" ] }, { "cell_type": "code", "execution_count": 49, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
S/NPRODUCTSQTYVENDOR PRICES - A UNIT PRICE NAIRAVENDOR PRICES - A TOTAL PRICE NAIRAQTY.1CINUC PRICES- B UNIT PRICE NAIRACINUC PRICES- B TOTAL PRICE NAIRAAFTER 10% REDUCTIONQTY.2CINUC PRICES - C UNIT PRICE NAIRACINUC PRICES - C TOTAL PRICE NAIRAAFTER 10% REDUCTION.1CATEGORYQTY GIVEN FOR AQTY SIGNED FOR BQTY REMAINING AQTY REMAINING BPercentage diff BPercentage diff C
500.0cellulose acetate strips shandon 60 x150mm x ...1.0145000.00.02.099998.0000000.00.0399998.0000000.00.0MICROBIOLOGY AND LABORATORY REAGENTS0.00.00.00.0-45.002900-45.002900
510.0Erytrocyte sedimentation rate, dispet 100/pkt1.013500.00.04.019999.6000000.00.0519999.6000000.00.0MICROBIOLOGY AND LABORATORY REAGENTS0.00.00.00.032.49865032.498650
520.0Febrile antigen test (OMEGA) 8 x 5ml with con...58.08500.00.04.011499.7700000.00.06211499.7700000.00.0MICROBIOLOGY AND LABORATORY REAGENTS0.00.00.00.026.08547826.085478
530.0Filter paper whatman 42 ashless 12.5 cm 100/pkt4.04000.00.04.02999.9400000.00.082999.9400000.00.0MICROBIOLOGY AND LABORATORY REAGENTS0.00.00.00.0-33.336000-33.336000
540.0Latex examination gloves (by Sempercare) 100 ...2.06500.00.03.03499.9300000.00.053499.9300000.00.0MICROBIOLOGY AND LABORATORY REAGENTS0.00.00.00.0-85.718000-85.718000
550.0Giemsa Stain 100ml/bottle ferntec biosciences8.0350.00.04.01199.9800000.00.0121199.9800000.00.0MICROBIOLOGY AND LABORATORY REAGENTS0.00.00.00.070.83284770.832847
560.0Uristix for urinalysis, plus auto check, SIEM...1.03000.00.00.04999.9000000.00.014999.9000000.00.0MICROBIOLOGY AND LABORATORY REAGENTS0.00.00.00.039.99880039.998800
570.0Pipette tips (1-200ul) blue type x 1000/pkt EP...4.01500.00.02.02999.9400000.00.062999.9400000.00.0MICROBIOLOGY AND LABORATORY REAGENTS0.00.00.00.049.99900049.999000
580.0Sterilin type universal containers, (for urin...4.014000.00.01.025499.4900000.00.0525499.4900000.00.0MICROBIOLOGY AND LABORATORY REAGENTS0.00.00.00.045.09694145.096941
590.0PSA i- chromax3.035000.00.02.041999.1600000.00.0541999.1600000.00.0HORMONE REAGENTS0.00.00.00.016.66500016.665000
600.0HbA1C i- chromax3.035000.00.012.042199.1600000.00.01542199.1600000.00.0HORMONE REAGENTS0.00.00.00.017.05996017.059960
610.0S-monovette 2.6ml EDTA by Sarstedt x500/car...2.0145800.00.06.064998.7000000.00.0864998.7000000.00.0ITEMS NOT LISTED IN FORTH CALL OFF BUT SUPPLIED1.01.00.00.0-124.312179-124.312179
620.0Labacon H.pylori9.04500.00.03.034998.6000140.00.0934998.6000140.00.0ITEMS NOT LISTED IN FORTH CALL OFF BUT SUPPLIED3.03.00.00.087.14234387.142343
\n", "
" ], "text/plain": [ " S/N PRODUCTS QTY \\\n", "50 0.0 cellulose acetate strips shandon 60 x150mm x ... 1.0 \n", "51 0.0 Erytrocyte sedimentation rate, dispet 100/pkt 1.0 \n", "52 0.0 Febrile antigen test (OMEGA) 8 x 5ml with con... 58.0 \n", "53 0.0 Filter paper whatman 42 ashless 12.5 cm 100/pkt 4.0 \n", "54 0.0 Latex examination gloves (by Sempercare) 100 ... 2.0 \n", "55 0.0 Giemsa Stain 100ml/bottle ferntec biosciences 8.0 \n", "56 0.0 Uristix for urinalysis, plus auto check, SIEM... 1.0 \n", "57 0.0 Pipette tips (1-200ul) blue type x 1000/pkt EP... 4.0 \n", "58 0.0 Sterilin type universal containers, (for urin... 4.0 \n", "59 0.0 PSA i- chromax 3.0 \n", "60 0.0 HbA1C i- chromax 3.0 \n", "61 0.0 S-monovette 2.6ml EDTA by Sarstedt x500/car... 2.0 \n", "62 0.0 Labacon H.pylori 9.0 \n", "\n", " VENDOR PRICES - A UNIT PRICE NAIRA VENDOR PRICES - A TOTAL PRICE NAIRA \\\n", "50 145000.0 0.0 \n", "51 13500.0 0.0 \n", "52 8500.0 0.0 \n", "53 4000.0 0.0 \n", "54 6500.0 0.0 \n", "55 350.0 0.0 \n", "56 3000.0 0.0 \n", "57 1500.0 0.0 \n", "58 14000.0 0.0 \n", "59 35000.0 0.0 \n", "60 35000.0 0.0 \n", "61 145800.0 0.0 \n", "62 4500.0 0.0 \n", "\n", " QTY.1 CINUC PRICES- B UNIT PRICE NAIRA \\\n", "50 2.0 99998.000000 \n", "51 4.0 19999.600000 \n", "52 4.0 11499.770000 \n", "53 4.0 2999.940000 \n", "54 3.0 3499.930000 \n", "55 4.0 1199.980000 \n", "56 0.0 4999.900000 \n", "57 2.0 2999.940000 \n", "58 1.0 25499.490000 \n", "59 2.0 41999.160000 \n", "60 12.0 42199.160000 \n", "61 6.0 64998.700000 \n", "62 3.0 34998.600014 \n", "\n", " CINUC PRICES- B TOTAL PRICE NAIRA AFTER 10% REDUCTION QTY.2 \\\n", "50 0.0 0.0 3 \n", "51 0.0 0.0 5 \n", "52 0.0 0.0 62 \n", "53 0.0 0.0 8 \n", "54 0.0 0.0 5 \n", "55 0.0 0.0 12 \n", "56 0.0 0.0 1 \n", "57 0.0 0.0 6 \n", "58 0.0 0.0 5 \n", "59 0.0 0.0 5 \n", "60 0.0 0.0 15 \n", "61 0.0 0.0 8 \n", "62 0.0 0.0 9 \n", "\n", " CINUC PRICES - C UNIT PRICE NAIRA CINUC PRICES - C TOTAL PRICE NAIRA \\\n", "50 99998.000000 0.0 \n", "51 19999.600000 0.0 \n", "52 11499.770000 0.0 \n", "53 2999.940000 0.0 \n", "54 3499.930000 0.0 \n", "55 1199.980000 0.0 \n", "56 4999.900000 0.0 \n", "57 2999.940000 0.0 \n", "58 25499.490000 0.0 \n", "59 41999.160000 0.0 \n", "60 42199.160000 0.0 \n", "61 64998.700000 0.0 \n", "62 34998.600014 0.0 \n", "\n", " AFTER 10% REDUCTION.1 CATEGORY \\\n", "50 0.0 MICROBIOLOGY AND LABORATORY REAGENTS \n", "51 0.0 MICROBIOLOGY AND LABORATORY REAGENTS \n", "52 0.0 MICROBIOLOGY AND LABORATORY REAGENTS \n", "53 0.0 MICROBIOLOGY AND LABORATORY REAGENTS \n", "54 0.0 MICROBIOLOGY AND LABORATORY REAGENTS \n", "55 0.0 MICROBIOLOGY AND LABORATORY REAGENTS \n", "56 0.0 MICROBIOLOGY AND LABORATORY REAGENTS \n", "57 0.0 MICROBIOLOGY AND LABORATORY REAGENTS \n", "58 0.0 MICROBIOLOGY AND LABORATORY REAGENTS \n", "59 0.0 HORMONE REAGENTS \n", "60 0.0 HORMONE REAGENTS \n", "61 0.0 ITEMS NOT LISTED IN FORTH CALL OFF BUT SUPPLIED \n", "62 0.0 ITEMS NOT LISTED IN FORTH CALL OFF BUT SUPPLIED \n", "\n", " QTY GIVEN FOR A QTY SIGNED FOR B QTY REMAINING A QTY REMAINING B \\\n", "50 0.0 0.0 0.0 0.0 \n", "51 0.0 0.0 0.0 0.0 \n", "52 0.0 0.0 0.0 0.0 \n", "53 0.0 0.0 0.0 0.0 \n", "54 0.0 0.0 0.0 0.0 \n", "55 0.0 0.0 0.0 0.0 \n", "56 0.0 0.0 0.0 0.0 \n", "57 0.0 0.0 0.0 0.0 \n", "58 0.0 0.0 0.0 0.0 \n", "59 0.0 0.0 0.0 0.0 \n", "60 0.0 0.0 0.0 0.0 \n", "61 1.0 1.0 0.0 0.0 \n", "62 3.0 3.0 0.0 0.0 \n", "\n", " Percentage diff B Percentage diff C \n", "50 -45.002900 -45.002900 \n", "51 32.498650 32.498650 \n", "52 26.085478 26.085478 \n", "53 -33.336000 -33.336000 \n", "54 -85.718000 -85.718000 \n", "55 70.832847 70.832847 \n", "56 39.998800 39.998800 \n", "57 49.999000 49.999000 \n", "58 45.096941 45.096941 \n", "59 16.665000 16.665000 \n", "60 17.059960 17.059960 \n", "61 -124.312179 -124.312179 \n", "62 87.142343 87.142343 " ] }, "execution_count": 49, "metadata": {}, "output_type": "execute_result" } ], "source": [ "fourth_call_off_abc[50:]" ] }, { "cell_type": "code", "execution_count": 50, "metadata": {}, "outputs": [], "source": [ "fourth_call_off_abc['PRODUCTS'] = fourth_call_off_abc['PRODUCTS'].str.replace(r'\\s+', ' ', regex=True).str.strip()" ] }, { "cell_type": "code", "execution_count": 51, "metadata": {}, "outputs": [], "source": [ "fourth_call_off_abc['CINUC PRICE'] = fourth_call_off_abc['VENDOR PRICES - A UNIT PRICE NAIRA']\n", "fourth_call_off_abc['UNIT NGN'] = fourth_call_off_abc['CINUC PRICES- B UNIT PRICE NAIRA']" ] }, { "cell_type": "code", "execution_count": 52, "metadata": {}, "outputs": [], "source": [ "fourth_call_off_abc['DATE'] = \"22/04/2022\"\n", "fourth_call_off_abc['EXCHANGE RATE'] = 415.079987" ] }, { "cell_type": "code", "execution_count": 53, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
PRODUCTSUNIT NGNCINUC PRICECATEGORYDATEEXCHANGE RATE
0Reflotron Glucose 15 x 2 stripes /pkt13989.90000017298.0CLINICAL CHEMISTRY22/04/2022415.079987
1Reflotron Creatinine x30 stripes/pkt19137.38000023663.0CLINICAL CHEMISTRY22/04/2022415.079987
2Reflotron Cholesterol x30 stripes/pkt19137.38000023663.0CLINICAL CHEMISTRY22/04/2022415.079987
3Reflotron Triglycerides x30 stripes/pkt19137.38000023663.0CLINICAL CHEMISTRY22/04/2022415.079987
4Reflotron HDL Cholesterol x 30 stripes/pkt25768.61000031863.0CLINICAL CHEMISTRY22/04/2022415.079987
.....................
58Sterilin type universal containers, (for urine...25499.49000014000.0MICROBIOLOGY AND LABORATORY REAGENTS22/04/2022415.079987
59PSA i- chromax41999.16000035000.0HORMONE REAGENTS22/04/2022415.079987
60HbA1C i- chromax42199.16000035000.0HORMONE REAGENTS22/04/2022415.079987
61S-monovette 2.6ml EDTA by Sarstedt x500/carton *64998.700000145800.0ITEMS NOT LISTED IN FORTH CALL OFF BUT SUPPLIED22/04/2022415.079987
62Labacon H.pylori34998.6000144500.0ITEMS NOT LISTED IN FORTH CALL OFF BUT SUPPLIED22/04/2022415.079987
\n", "

63 rows × 6 columns

\n", "
" ], "text/plain": [ " PRODUCTS UNIT NGN \\\n", "0 Reflotron Glucose 15 x 2 stripes /pkt 13989.900000 \n", "1 Reflotron Creatinine x30 stripes/pkt 19137.380000 \n", "2 Reflotron Cholesterol x30 stripes/pkt 19137.380000 \n", "3 Reflotron Triglycerides x30 stripes/pkt 19137.380000 \n", "4 Reflotron HDL Cholesterol x 30 stripes/pkt 25768.610000 \n", ".. ... ... \n", "58 Sterilin type universal containers, (for urine... 25499.490000 \n", "59 PSA i- chromax 41999.160000 \n", "60 HbA1C i- chromax 42199.160000 \n", "61 S-monovette 2.6ml EDTA by Sarstedt x500/carton * 64998.700000 \n", "62 Labacon H.pylori 34998.600014 \n", "\n", " CINUC PRICE CATEGORY DATE \\\n", "0 17298.0 CLINICAL CHEMISTRY 22/04/2022 \n", "1 23663.0 CLINICAL CHEMISTRY 22/04/2022 \n", "2 23663.0 CLINICAL CHEMISTRY 22/04/2022 \n", "3 23663.0 CLINICAL CHEMISTRY 22/04/2022 \n", "4 31863.0 CLINICAL CHEMISTRY 22/04/2022 \n", ".. ... ... ... \n", "58 14000.0 MICROBIOLOGY AND LABORATORY REAGENTS 22/04/2022 \n", "59 35000.0 HORMONE REAGENTS 22/04/2022 \n", "60 35000.0 HORMONE REAGENTS 22/04/2022 \n", "61 145800.0 ITEMS NOT LISTED IN FORTH CALL OFF BUT SUPPLIED 22/04/2022 \n", "62 4500.0 ITEMS NOT LISTED IN FORTH CALL OFF BUT SUPPLIED 22/04/2022 \n", "\n", " EXCHANGE RATE \n", "0 415.079987 \n", "1 415.079987 \n", "2 415.079987 \n", "3 415.079987 \n", "4 415.079987 \n", ".. ... \n", "58 415.079987 \n", "59 415.079987 \n", "60 415.079987 \n", "61 415.079987 \n", "62 415.079987 \n", "\n", "[63 rows x 6 columns]" ] }, "execution_count": 53, "metadata": {}, "output_type": "execute_result" } ], "source": [ "cols = ['PRODUCTS', 'UNIT NGN', 'CINUC PRICE', 'CATEGORY', 'DATE', 'EXCHANGE RATE']\n", "fourth_call_off_abc_df = fourth_call_off_abc[cols]\n", "fourth_call_off_abc_df" ] }, { "cell_type": "code", "execution_count": 54, "metadata": {}, "outputs": [], "source": [ "# saving as csv file\n", "fourth_call_off_abc_df.to_csv('fourth_call_off_abc_df.csv', index=False)" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## creating an app" ] }, { "cell_type": "code", "execution_count": 55, "metadata": {}, "outputs": [], "source": [ "# getting all the product names \n", "reg_prod = reagent_prices_1['PRODUCTS'].unique()\n", "first_prod = first_call_off['PRODUCTS'].unique()\n", "list_prod = list_price['PRODUCTS'].unique()\n", "forth_prod = forth_call_off_1['PRODUCTS'].unique()\n", "forth_abc_prod = fourth_call_off_abc['PRODUCTS'].unique()\n", "\n", "# adding all together in a list\n", "all_prod = list(reg_prod) + list(first_prod) + list(list_prod) + list(forth_prod) + list(forth_abc_prod)" ] }, { "cell_type": "code", "execution_count": 56, "metadata": {}, "outputs": [], "source": [ "# getting the unique values with set\n", "all_prod = list(set(all_prod))" ] }, { "cell_type": "code", "execution_count": 57, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "['Reflotron AST/GOT x30 stripes/pkt',\n", " 'Reflotron HDL Cholesterol x 30 stripes/pkt',\n", " 'T4 i- chromax',\n", " 'COBAS 3 C111 CLEANER',\n", " 'AFP i- chromax',\n", " 'Sterilin type universal containers, (for urine) Red cap type(400)/ctn',\n", " 'Blood group B typing serum 10ml/ 10 bottles /pkt by Biotec',\n", " 'PSA i- chromax',\n", " 'Parazone 500ml x 20bottles /ctn',\n", " 'BHCG i- chromax',\n", " 'Bispot 1 &2 Determinate pkt',\n", " 'SD BIOLINE Prostatic specific antigen ( PSA) 30/pkt',\n", " 'Latex examination gloves (by Sempercare) 100 8-9L',\n", " 'QBC HEAMATOLOGY/MALARIA TUBES 250T',\n", " 'SD BIO LINE HBV test kit',\n", " 'CORTISOL i- chromax',\n", " 'Oxoid Yeast extract agar 500gm pronadisa product',\n", " 'Veneral Disease Research Laboratory (VDRL) TEST KIT',\n", " 'Reflotron GPT/ALT x 30 stripes/pkt',\n", " 'Reflotron Gamma GT x 30 stripes/pkt',\n", " 'Labacon H.pylori',\n", " 'PROGESTERONE i- chromax',\n", " 'COBAS C 111 DEPROTEINIZER 2 bottles / pkt',\n", " 'mindray 5 heamtology reagents 53LH LYSE 500/ x4',\n", " 'Heavy duty oxivir TB bench wipes AHP approved',\n", " 'Conical Flask 1000ml',\n", " 'Febrile antigen test (OMEGA) 8 x 5ml with controls',\n", " 'PROBE SET COBAS c111',\n", " 'Reflotron Uric Acid x 30 stripes/pkt',\n", " 'Insta TEST 6 PLUS lamotte 50strips/pkt',\n", " 'mindray 5 heamatology reagent Cleaner',\n", " 'COBAS C 111 CHOL3 CHOLESTEROL 400 TESTS',\n", " 'Sarstedt multi-safe comfort 6l, sharp box',\n", " 'COBAS C111 SODIUN CHLORIDE',\n", " 'Insta iron Lamotte25 strips/pkt',\n", " 'Methylated spirit 4l BDH with MSDS',\n", " 'SD MALARIA SINGLE UNITS',\n", " 'COBAS C 111 UREA 400 TESTS',\n", " 'Reflotron Bilirubin x 30 stripes/pkt',\n", " 'mindray 5 heamatology reagent Rinse1L X 4',\n", " 'SD BIO LINE HIV 1/2 antibody test kit 3.0 25/pkt',\n", " 'SD BIOLINE HAC 30 TEST/PKT. (HAV)',\n", " 'Laboratory lighter plastic gun type',\n", " \"Field's stain B 100ml\",\n", " 'CLED 500g',\n", " 'mindray 5 heaamatology reagent leo 11 lyse(400mlx4)',\n", " 'COBAS C 111 PRINTER PAPER 4 rolls /PKT',\n", " 'Manifred cover slips 50 x10/pkt',\n", " 'Reflotron Potassium x 30',\n", " 'COBAS C111 SAMPLE CUPS 1000/PKT',\n", " 'mindray 5 heaamatology reagent Cleaner',\n", " 'STATPAK HIV 1/2',\n", " 'Blood group D typing serum 10ml/ 10 bottles /pkt by Biotec',\n", " 'COBAS 3 C111 PROBE CLEANER 500ML',\n", " 'COBAS C 111 TRIGLYCERIDES 200 TESTS',\n", " 'CK-MB i- chromax',\n", " 'mindray 5 heaamatology reagent leo 1 lyse1L X4',\n", " 'PCT i- chromax',\n", " 'Veneral Disease Resarch LAB antigen test, VDRL TEST.',\n", " 'SD BIOLINE MALARIA Ag P. f ELISA Test',\n", " 'Pyrix Beaker 1000ml',\n", " 'S- monovette 4.5ml lithium heparin Sarstedt x 500/cartoon',\n", " 'Pipette tips (1-200ul) blue type x 1000/pkt EPPENDDORE',\n", " 'Mindray UA66 uirinalysis strips 50/pkt',\n", " 'Oxoid Iso- sensitest agar agar 500gm pronadisa product',\n", " 'HCG test strips Diaspot, diagnostic USA,/ Antec type/ 50/pkt',\n", " 'SD BIOLINE HIV ELISA 3.0 Confirmatory test kit',\n", " 'QBC HEAMATOLOGY/MALARIA TUBES TUBES 250T',\n", " 'Oxoid Nutrient agar 500gm pronadisa product',\n", " 'cellulose acetate strips shandon 60 x150mm x 100/pkt',\n", " 'Electrophoresing buffer, 6.1g x 10 shandon/pky',\n", " 'HALOGEN LAMP for COBAS c111',\n", " 'SD Malaria kit HRP2/Pldh (Pf PAN )',\n", " 'QBC HEMATOLOGY/MALARIA TUBES TUBES 250T',\n", " 'LH i- chromax',\n", " 'mindray 5 heamatology reagent leo 1 lyse1L X4',\n", " 'Bispot 1 &2 Determine pkt ALEERE',\n", " 'FSH i- chromax',\n", " 'CEA i- chromax',\n", " 'Chloroscope complete kit with ortholidine',\n", " 'SD BIOLINE Rheumatoid athritis test kit 30 tests /pkt',\n", " 'COBAS C 111 ALT (GPT) 400 TESTS',\n", " 'Reflotron Pancreatic Amylase 15 x 2 stripes/pkt',\n", " 'Tn-I i- chromax',\n", " 'SD BIOLINE Strep A antigen test 25 tests /pkts',\n", " 'SD BIOLINE 30 TEST/PKT. (HAV)',\n", " 'Cotton wool non absorbent 500g',\n", " 'Oxoid Blood agar base 500gm by pronadis product',\n", " 'COBAS C 11 GLU2 GLUCOSE 400 TESTS',\n", " 'Reflotron Cholesterol x30 stripes/pkt',\n", " 'Oxoid MacConkey agar 500gm by pronadisa procuct',\n", " 'Conical Flask 250ml',\n", " 'Autoclave tapes (roll)',\n", " 'mindray 5 heaamatology reagent Diluent 20ml',\n", " 'S-monovette 2.6ml EDTA by Sarstedt x500/carton *',\n", " 'Pyrix Beaker 250ml',\n", " 'COBAS C 111 BLT3 TOTAL BILIRUBIN',\n", " 'Reflotron Creatinine x30 stripes/pkt',\n", " 'SD BIO LINE HIV Ag/Ab combo 30tests/pkt',\n", " 'Starstedt Safety sterile petri dish disposable type 92/16mm/ctn',\n", " 'Water quality quick test with probefor PH, ORP, EC, DO and Turbidity',\n", " 'Reflotron Pancreatic Amylase 15 x 2',\n", " 'Febrile antigen test (VOSAN) 8 x 5ml with controls',\n", " 'Antibiotics multidisk( AB-DISC) gram pos',\n", " 'SD malaria Ag Pf.kit for single use, 25/pkt BIOLINE',\n", " 'COBAS C111 CREATININE 400 TESTS',\n", " 'COBAS C111 HDL 400TESTS',\n", " 'CUVETTE SEGMENT COBAS C 111 5,000 pcs/pkt',\n", " 'CRP i- chromax',\n", " 'Blood group A typing serum 10ml/ 10 bottles /pkt by Biotec',\n", " 'Oxoid Iso-sensitest agar agar 500gm pronadisa product',\n", " 'T3 i- chromax',\n", " 'COBAS C 111 Automated system CFAS 12 x 3ml botlles /pkt',\n", " \"Field's stain A 100ml\",\n", " 'Multistrips for urinalysis, ACON LABS',\n", " 'Reflotron Triglycerides x30 stripes/pkt',\n", " 'MICROALBUMIN i- chromax',\n", " 'cellulose acetate foils X50 Bayer',\n", " 'Vit D I-Chromax',\n", " 'Antibiotics multidisk( AB- DISC) gram pos',\n", " 'COBAS C 111 URIC ACID PLUS 400 TESTS',\n", " 'Reflotron Pottasium x 30',\n", " 'Agary 2ml single-use syringes 23G X11/4 100 /PACK',\n", " 'BioMed sicle scan for rapid genotye X25 /PKT',\n", " 'COBAS INTEGRA C 111 ACTIVATOR 9X12 ml bottles /pt',\n", " 'mindray 5 heamtology reagents 53LH LYSE 500/4',\n", " 'FERRITIN i- chromax',\n", " 'Sterilin type petri dish containers / 100cm',\n", " 'Cholesterol (Accu Answer)',\n", " 'Oxoid CLED agar 500grams pronadisa product',\n", " 'MYOGLOBIN same',\n", " 'SD BIOLINE TB Ag test kit 25/kpt',\n", " 'sensigrip latex BX 100 INVACARE',\n", " 'Conical Flask 500ml',\n", " 'COBAS C 111 AST (GOT) 400 TESTS',\n", " 'Manfred grease free crytal clear slides 72/Pack x20',\n", " 'Filter paper whatman 42 ashless 12.5 cm 100/pkt',\n", " 'D-DIMER i- chromax',\n", " 'PROLACTIN i- chromax',\n", " 'COBAS C 111 CFAS Lipid',\n", " 'mindray 5 heamatology reagent Diluent 20ml',\n", " 'Antibiotics multidisk( AB- DISC) gram neg',\n", " 'Macconkey agar 500g oxoid',\n", " 'Reflotron Urea 15 x 2 stripes/pkt',\n", " 'UNIGOLD HIV test kit',\n", " 'Complete set Vacutainer 4ml EDTA by 1000/pkt BD',\n", " 'HCG i- chromax',\n", " 'SD BIO LINE H.Pylori Antibody test 30 tests /pkt',\n", " 'Giemsa Stain 100ml/bottle ferntec biosciences',\n", " 'Pyrix Beaker 500ml',\n", " 'Blood group AB typing serum 10ml/ 10 bottles /pkt by Biotec',\n", " 'SD BIOLINE HCV 3.0 30 tests/pkt',\n", " 'BATTERY LITHIUM A A3.6V',\n", " 'Paper tapes (Rolls)',\n", " 'Pyrix Beaker 100ml',\n", " 'Reflotron AST/GOT x30 stripes/pkt stripes/pkt',\n", " 'Uristix for urinalysis, plus auto check, SIEMENS/ 100/PKT',\n", " 'Reflotron Glucose 15 x 2 stripes /pkt',\n", " 'Latex examination gloves (by Sempercare) 100 7L',\n", " 'HbA1C i- chromax',\n", " 'RF IgM i- chromax',\n", " 'AIC NOW catridge for HB Aic determination 10.PKT',\n", " 'Glucose (Accu Answer)',\n", " 'COBAS C 111 ALKALINE PHOS 400 TESTS',\n", " 'mindray 5 heaamatology reagent Rinse1L X 4',\n", " 'SD BIO LINE H. Pylori Antibody test 30 tests /pkt',\n", " 'HsCRP i- chromax',\n", " 'Immersion oil 100ml',\n", " 'Pyrix Beaker 2000 ml',\n", " 'Reflotron Alk.Phosphate x 30 stripes/pkt',\n", " 'Sarstedt standardinnoculation loop(50)/pkt',\n", " 'TSH i- chromax',\n", " 'Erytrocyte sedimentation rate, dispet 100/pkt',\n", " 'oxivir TB sprays AHP approved',\n", " 'Epson ribbon for Reflotron printer',\n", " 'Clean and check',\n", " 'TESTOSTERONE i- chromax',\n", " 'Dependaplast waterproof round spot plasters 100/pkt',\n", " 'D-DIMER i-chromax',\n", " 'Reflotron Pancreatic Amylase 15x2 stripes/pkt',\n", " 'SD malaria Ag Pf.kit for multiple use, 25/pkt BIOLINE',\n", " 'Antibiotics multidisk( AB-DISC) gram neg']" ] }, "execution_count": 57, "metadata": {}, "output_type": "execute_result" } ], "source": [ "all_prod" ] }, { "cell_type": "code", "execution_count": 58, "metadata": {}, "outputs": [], "source": [ "# sorting the list\n", "all_prod.sort()" ] }, { "cell_type": "code", "execution_count": 59, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "['AFP i- chromax',\n", " 'AIC NOW catridge for HB Aic determination 10.PKT',\n", " 'Agary 2ml single-use syringes 23G X11/4 100 /PACK',\n", " 'Antibiotics multidisk( AB- DISC) gram neg',\n", " 'Antibiotics multidisk( AB- DISC) gram pos',\n", " 'Antibiotics multidisk( AB-DISC) gram neg',\n", " 'Antibiotics multidisk( AB-DISC) gram pos',\n", " 'Autoclave tapes (roll)',\n", " 'BATTERY LITHIUM A A3.6V',\n", " 'BHCG i- chromax',\n", " 'BioMed sicle scan for rapid genotye X25 /PKT',\n", " 'Bispot 1 &2 Determinate pkt',\n", " 'Bispot 1 &2 Determine pkt ALEERE',\n", " 'Blood group A typing serum 10ml/ 10 bottles /pkt by Biotec',\n", " 'Blood group AB typing serum 10ml/ 10 bottles /pkt by Biotec',\n", " 'Blood group B typing serum 10ml/ 10 bottles /pkt by Biotec',\n", " 'Blood group D typing serum 10ml/ 10 bottles /pkt by Biotec',\n", " 'CEA i- chromax',\n", " 'CK-MB i- chromax',\n", " 'CLED 500g',\n", " 'COBAS 3 C111 CLEANER',\n", " 'COBAS 3 C111 PROBE CLEANER 500ML',\n", " 'COBAS C 11 GLU2 GLUCOSE 400 TESTS',\n", " 'COBAS C 111 ALKALINE PHOS 400 TESTS',\n", " 'COBAS C 111 ALT (GPT) 400 TESTS',\n", " 'COBAS C 111 AST (GOT) 400 TESTS',\n", " 'COBAS C 111 Automated system CFAS 12 x 3ml botlles /pkt',\n", " 'COBAS C 111 BLT3 TOTAL BILIRUBIN',\n", " 'COBAS C 111 CFAS Lipid',\n", " 'COBAS C 111 CHOL3 CHOLESTEROL 400 TESTS',\n", " 'COBAS C 111 DEPROTEINIZER 2 bottles / pkt',\n", " 'COBAS C 111 PRINTER PAPER 4 rolls /PKT',\n", " 'COBAS C 111 TRIGLYCERIDES 200 TESTS',\n", " 'COBAS C 111 UREA 400 TESTS',\n", " 'COBAS C 111 URIC ACID PLUS 400 TESTS',\n", " 'COBAS C111 CREATININE 400 TESTS',\n", " 'COBAS C111 HDL 400TESTS',\n", " 'COBAS C111 SAMPLE CUPS 1000/PKT',\n", " 'COBAS C111 SODIUN CHLORIDE',\n", " 'COBAS INTEGRA C 111 ACTIVATOR 9X12 ml bottles /pt',\n", " 'CORTISOL i- chromax',\n", " 'CRP i- chromax',\n", " 'CUVETTE SEGMENT COBAS C 111 5,000 pcs/pkt',\n", " 'Chloroscope complete kit with ortholidine',\n", " 'Cholesterol (Accu Answer)',\n", " 'Clean and check',\n", " 'Complete set Vacutainer 4ml EDTA by 1000/pkt BD',\n", " 'Conical Flask 1000ml',\n", " 'Conical Flask 250ml',\n", " 'Conical Flask 500ml',\n", " 'Cotton wool non absorbent 500g',\n", " 'D-DIMER i- chromax',\n", " 'D-DIMER i-chromax',\n", " 'Dependaplast waterproof round spot plasters 100/pkt',\n", " 'Electrophoresing buffer, 6.1g x 10 shandon/pky',\n", " 'Epson ribbon for Reflotron printer',\n", " 'Erytrocyte sedimentation rate, dispet 100/pkt',\n", " 'FERRITIN i- chromax',\n", " 'FSH i- chromax',\n", " 'Febrile antigen test (OMEGA) 8 x 5ml with controls',\n", " 'Febrile antigen test (VOSAN) 8 x 5ml with controls',\n", " \"Field's stain A 100ml\",\n", " \"Field's stain B 100ml\",\n", " 'Filter paper whatman 42 ashless 12.5 cm 100/pkt',\n", " 'Giemsa Stain 100ml/bottle ferntec biosciences',\n", " 'Glucose (Accu Answer)',\n", " 'HALOGEN LAMP for COBAS c111',\n", " 'HCG i- chromax',\n", " 'HCG test strips Diaspot, diagnostic USA,/ Antec type/ 50/pkt',\n", " 'HbA1C i- chromax',\n", " 'Heavy duty oxivir TB bench wipes AHP approved',\n", " 'HsCRP i- chromax',\n", " 'Immersion oil 100ml',\n", " 'Insta TEST 6 PLUS lamotte 50strips/pkt',\n", " 'Insta iron Lamotte25 strips/pkt',\n", " 'LH i- chromax',\n", " 'Labacon H.pylori',\n", " 'Laboratory lighter plastic gun type',\n", " 'Latex examination gloves (by Sempercare) 100 7L',\n", " 'Latex examination gloves (by Sempercare) 100 8-9L',\n", " 'MICROALBUMIN i- chromax',\n", " 'MYOGLOBIN same',\n", " 'Macconkey agar 500g oxoid',\n", " 'Manfred grease free crytal clear slides 72/Pack x20',\n", " 'Manifred cover slips 50 x10/pkt',\n", " 'Methylated spirit 4l BDH with MSDS',\n", " 'Mindray UA66 uirinalysis strips 50/pkt',\n", " 'Multistrips for urinalysis, ACON LABS',\n", " 'Oxoid Blood agar base 500gm by pronadis product',\n", " 'Oxoid CLED agar 500grams pronadisa product',\n", " 'Oxoid Iso- sensitest agar agar 500gm pronadisa product',\n", " 'Oxoid Iso-sensitest agar agar 500gm pronadisa product',\n", " 'Oxoid MacConkey agar 500gm by pronadisa procuct',\n", " 'Oxoid Nutrient agar 500gm pronadisa product',\n", " 'Oxoid Yeast extract agar 500gm pronadisa product',\n", " 'PCT i- chromax',\n", " 'PROBE SET COBAS c111',\n", " 'PROGESTERONE i- chromax',\n", " 'PROLACTIN i- chromax',\n", " 'PSA i- chromax',\n", " 'Paper tapes (Rolls)',\n", " 'Parazone 500ml x 20bottles /ctn',\n", " 'Pipette tips (1-200ul) blue type x 1000/pkt EPPENDDORE',\n", " 'Pyrix Beaker 1000ml',\n", " 'Pyrix Beaker 100ml',\n", " 'Pyrix Beaker 2000 ml',\n", " 'Pyrix Beaker 250ml',\n", " 'Pyrix Beaker 500ml',\n", " 'QBC HEAMATOLOGY/MALARIA TUBES 250T',\n", " 'QBC HEAMATOLOGY/MALARIA TUBES TUBES 250T',\n", " 'QBC HEMATOLOGY/MALARIA TUBES TUBES 250T',\n", " 'RF IgM i- chromax',\n", " 'Reflotron AST/GOT x30 stripes/pkt',\n", " 'Reflotron AST/GOT x30 stripes/pkt stripes/pkt',\n", " 'Reflotron Alk.Phosphate x 30 stripes/pkt',\n", " 'Reflotron Bilirubin x 30 stripes/pkt',\n", " 'Reflotron Cholesterol x30 stripes/pkt',\n", " 'Reflotron Creatinine x30 stripes/pkt',\n", " 'Reflotron GPT/ALT x 30 stripes/pkt',\n", " 'Reflotron Gamma GT x 30 stripes/pkt',\n", " 'Reflotron Glucose 15 x 2 stripes /pkt',\n", " 'Reflotron HDL Cholesterol x 30 stripes/pkt',\n", " 'Reflotron Pancreatic Amylase 15 x 2',\n", " 'Reflotron Pancreatic Amylase 15 x 2 stripes/pkt',\n", " 'Reflotron Pancreatic Amylase 15x2 stripes/pkt',\n", " 'Reflotron Potassium x 30',\n", " 'Reflotron Pottasium x 30',\n", " 'Reflotron Triglycerides x30 stripes/pkt',\n", " 'Reflotron Urea 15 x 2 stripes/pkt',\n", " 'Reflotron Uric Acid x 30 stripes/pkt',\n", " 'S- monovette 4.5ml lithium heparin Sarstedt x 500/cartoon',\n", " 'S-monovette 2.6ml EDTA by Sarstedt x500/carton *',\n", " 'SD BIO LINE H. Pylori Antibody test 30 tests /pkt',\n", " 'SD BIO LINE H.Pylori Antibody test 30 tests /pkt',\n", " 'SD BIO LINE HBV test kit',\n", " 'SD BIO LINE HIV 1/2 antibody test kit 3.0 25/pkt',\n", " 'SD BIO LINE HIV Ag/Ab combo 30tests/pkt',\n", " 'SD BIOLINE 30 TEST/PKT. (HAV)',\n", " 'SD BIOLINE HAC 30 TEST/PKT. (HAV)',\n", " 'SD BIOLINE HCV 3.0 30 tests/pkt',\n", " 'SD BIOLINE HIV ELISA 3.0 Confirmatory test kit',\n", " 'SD BIOLINE MALARIA Ag P. f ELISA Test',\n", " 'SD BIOLINE Prostatic specific antigen ( PSA) 30/pkt',\n", " 'SD BIOLINE Rheumatoid athritis test kit 30 tests /pkt',\n", " 'SD BIOLINE Strep A antigen test 25 tests /pkts',\n", " 'SD BIOLINE TB Ag test kit 25/kpt',\n", " 'SD MALARIA SINGLE UNITS',\n", " 'SD Malaria kit HRP2/Pldh (Pf PAN )',\n", " 'SD malaria Ag Pf.kit for multiple use, 25/pkt BIOLINE',\n", " 'SD malaria Ag Pf.kit for single use, 25/pkt BIOLINE',\n", " 'STATPAK HIV 1/2',\n", " 'Sarstedt multi-safe comfort 6l, sharp box',\n", " 'Sarstedt standardinnoculation loop(50)/pkt',\n", " 'Starstedt Safety sterile petri dish disposable type 92/16mm/ctn',\n", " 'Sterilin type petri dish containers / 100cm',\n", " 'Sterilin type universal containers, (for urine) Red cap type(400)/ctn',\n", " 'T3 i- chromax',\n", " 'T4 i- chromax',\n", " 'TESTOSTERONE i- chromax',\n", " 'TSH i- chromax',\n", " 'Tn-I i- chromax',\n", " 'UNIGOLD HIV test kit',\n", " 'Uristix for urinalysis, plus auto check, SIEMENS/ 100/PKT',\n", " 'Veneral Disease Resarch LAB antigen test, VDRL TEST.',\n", " 'Veneral Disease Research Laboratory (VDRL) TEST KIT',\n", " 'Vit D I-Chromax',\n", " 'Water quality quick test with probefor PH, ORP, EC, DO and Turbidity',\n", " 'cellulose acetate foils X50 Bayer',\n", " 'cellulose acetate strips shandon 60 x150mm x 100/pkt',\n", " 'mindray 5 heaamatology reagent Cleaner',\n", " 'mindray 5 heaamatology reagent Diluent 20ml',\n", " 'mindray 5 heaamatology reagent Rinse1L X 4',\n", " 'mindray 5 heaamatology reagent leo 1 lyse1L X4',\n", " 'mindray 5 heaamatology reagent leo 11 lyse(400mlx4)',\n", " 'mindray 5 heamatology reagent Cleaner',\n", " 'mindray 5 heamatology reagent Diluent 20ml',\n", " 'mindray 5 heamatology reagent Rinse1L X 4',\n", " 'mindray 5 heamatology reagent leo 1 lyse1L X4',\n", " 'mindray 5 heamtology reagents 53LH LYSE 500/ x4',\n", " 'mindray 5 heamtology reagents 53LH LYSE 500/4',\n", " 'oxivir TB sprays AHP approved',\n", " 'sensigrip latex BX 100 INVACARE']" ] }, "execution_count": 59, "metadata": {}, "output_type": "execute_result" } ], "source": [ "all_prod" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [] } ], "metadata": { "kernelspec": { "display_name": "new_env", "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.7" } }, "nbformat": 4, "nbformat_minor": 2 }