SAP Automation.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Setting up data source for validation\n",
    "excel = pd.read_excel(r\"C:\\Users\\chenar1\\Documents\\Check Qty\\20210407.XLSX\",sheet_name = 'Sheet3')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[4591800182,\n",
       " 4591800182,\n",
       " 4591817010,\n",
       " 4591817010,\n",
       " 4591826486,\n",
       " 4591826486,\n",
       " 4591866400,\n",
       " 4591866400,\n",
       " 4591887708,\n",
       " 4591887708,\n",
       " 4591887708,\n",
       " 4591887711,\n",
       " 4591887711,\n",
       " 4591887711,\n",
       " 4591887716,\n",
       " 4591887716,\n",
       " 4591887716,\n",
       " 4591887719,\n",
       " 4591887719,\n",
       " 4591887719,\n",
       " 4591889065,\n",
       " 4591889065,\n",
       " 4591889065,\n",
       " 4591964941,\n",
       " 4591964941,\n",
       " 4591964941,\n",
       " 4591978502,\n",
       " 4591978502,\n",
       " 4591978502,\n",
       " 4591978541,\n",
       " 4591978541,\n",
       " 4591993498,\n",
       " 4591993498,\n",
       " 4591993498,\n",
       " 4591994337,\n",
       " 4592003988,\n",
       " 4592003988,\n",
       " 4592016646,\n",
       " 4592016646,\n",
       " 4592016646,\n",
       " 4592016651,\n",
       " 4592016651,\n",
       " 4592016651,\n",
       " 4592016715,\n",
       " 4592016715,\n",
       " 4592027141,\n",
       " 4592027141,\n",
       " 4592027763,\n",
       " 4592027765,\n",
       " 4592038275,\n",
       " 4592038505,\n",
       " 4592038505,\n",
       " 4592039024,\n",
       " 4592048455,\n",
       " 4592048455,\n",
       " 4592048455,\n",
       " 4592049210,\n",
       " 4592049218,\n",
       " 4592055930,\n",
       " 4592056585,\n",
       " 4592057983,\n",
       " 4592057983,\n",
       " 4592057983,\n",
       " 4592057983,\n",
       " 4592057992,\n",
       " 4592057992,\n",
       " 4592057992,\n",
       " 4592057996,\n",
       " 4592057996,\n",
       " 4592057996,\n",
       " 4592058025,\n",
       " 4592058025,\n",
       " 4592059116,\n",
       " 4592060495,\n",
       " 4592064496,\n",
       " 4592064496,\n",
       " 4592065682,\n",
       " 4592067594,\n",
       " 4592068562,\n",
       " 4592068562,\n",
       " 4592068580,\n",
       " 4592068984,\n",
       " 4592068984,\n",
       " 4592070141,\n",
       " 4592070141,\n",
       " 4592070216,\n",
       " 4592071155,\n",
       " 4592071155,\n",
       " 4592071155,\n",
       " 4592071155,\n",
       " 4592071178,\n",
       " 4592071178,\n",
       " 4592071178,\n",
       " 4592071178,\n",
       " 4592071182,\n",
       " 4592071182,\n",
       " 4592071182,\n",
       " 4592071182,\n",
       " 4592089619,\n",
       " 4592089619,\n",
       " 4592089619,\n",
       " 4592093784,\n",
       " 4592095340,\n",
       " 4592095340,\n",
       " 4592096726,\n",
       " 4592099592,\n",
       " 4592099597,\n",
       " 4592099605,\n",
       " 4592100430,\n",
       " 4592100430,\n",
       " 4592100892,\n",
       " 4592100892,\n",
       " 4592100899,\n",
       " 4592100899,\n",
       " 4592100899,\n",
       " 4592105550,\n",
       " 4592109764,\n",
       " 4592110704,\n",
       " 4592110748]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Exporting PO within the data source out into a more friendly format\n",
    "PO_list = []\n",
    "for i in range(0,119):\n",
    "    PO_list.append(excel.at[i,'A~Purch.Doc.'])\n",
    "    i+=1\n",
    "    \n",
    "PO_list"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[419957,\n",
       " 549849,\n",
       " 549849,\n",
       " 2651520,\n",
       " 549849,\n",
       " 2651520,\n",
       " 1224738,\n",
       " 1224299,\n",
       " 2562586,\n",
       " 549849,\n",
       " 2651520,\n",
       " 2562586,\n",
       " 549849,\n",
       " 2651520,\n",
       " 2562586,\n",
       " 549849,\n",
       " 2651520,\n",
       " 2562586,\n",
       " 549849,\n",
       " 2651520,\n",
       " 1947094,\n",
       " 2562586,\n",
       " 549849,\n",
       " 1776073,\n",
       " 2562586,\n",
       " 549849,\n",
       " 1947093,\n",
       " 2562586,\n",
       " 549849,\n",
       " 419953,\n",
       " 549849,\n",
       " 420512,\n",
       " 2562586,\n",
       " 549849,\n",
       " 1224948,\n",
       " 1224528,\n",
       " 1224790,\n",
       " 1776073,\n",
       " 2562586,\n",
       " 549849,\n",
       " 1776073,\n",
       " 2562586,\n",
       " 549849,\n",
       " 420512,\n",
       " 549849,\n",
       " 549770,\n",
       " 549849,\n",
       " 597690,\n",
       " 917870,\n",
       " 1027773,\n",
       " 1224790,\n",
       " 1224528,\n",
       " 1217550,\n",
       " 832403,\n",
       " 1483419,\n",
       " 549849,\n",
       " 848181,\n",
       " 1224640,\n",
       " 750423,\n",
       " 2549162,\n",
       " 832403,\n",
       " 1483419,\n",
       " 549849,\n",
       " 2562586,\n",
       " 1947094,\n",
       " 2562586,\n",
       " 549849,\n",
       " 1947094,\n",
       " 2562586,\n",
       " 549849,\n",
       " 1031775,\n",
       " 549849,\n",
       " 1224762,\n",
       " 1223182,\n",
       " 549770,\n",
       " 549849,\n",
       " 748630,\n",
       " 1224640,\n",
       " 1224528,\n",
       " 1224790,\n",
       " 900436,\n",
       " 1728094,\n",
       " 549849,\n",
       " 2306997,\n",
       " 2306996,\n",
       " 594818,\n",
       " 832403,\n",
       " 549849,\n",
       " 1483419,\n",
       " 2562586,\n",
       " 832403,\n",
       " 549849,\n",
       " 1483419,\n",
       " 2562586,\n",
       " 832403,\n",
       " 549849,\n",
       " 1483419,\n",
       " 2562586,\n",
       " 1936402,\n",
       " 2562586,\n",
       " 549849,\n",
       " 1224552,\n",
       " 419959,\n",
       " 549849,\n",
       " 1224834,\n",
       " 1027773,\n",
       " 848181,\n",
       " 1481461,\n",
       " 2306996,\n",
       " 2306997,\n",
       " 549770,\n",
       " 549849,\n",
       " 1776073,\n",
       " 2562586,\n",
       " 549849,\n",
       " 848181,\n",
       " 1224640,\n",
       " 594418,\n",
       " 1224556]"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Exporting material within the data source out into a more friendly format\n",
    "material = []\n",
    "for i in range(0,119):\n",
    "    material.append(excel.at[i,'B~Material'])\n",
    "    i+=1\n",
    "\n",
    "material"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Defining output for data storage\n",
    "output = {'PO':[],'Status':[]}\n",
    "out = pd.DataFrame(output)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "E2\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "Done\n",
      "Done\n",
      "Done\n",
      "Done\n",
      "Done\n",
      "Done\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "Done\n",
      "Done\n",
      "Done\n",
      "Done\n",
      "Done\n",
      "Done\n",
      "Done\n",
      "Done\n",
      "Done\n",
      "Done\n",
      "Done\n",
      "Done\n",
      "Done\n",
      "Done\n",
      "Done\n",
      "Done\n",
      "Done\n",
      "Done\n",
      "Done\n",
      "Done\n",
      "Done\n",
      "Done\n",
      "Done\n",
      "Done\n",
      "Done\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n",
      "AB\n"
     ]
    }
   ],
   "source": [
    "\n",
    "# #-Begin-----------------------------------------------------------------\n",
    "\n",
    "# #-Includes--------------------------------------------------------------\n",
    "# import sys\n",
    "# import win32com.client\n",
    "\n",
    "# #-Sub Main--------------------------------------------------------------\n",
    "# def Main():\n",
    "\n",
    "#   try:\n",
    "\n",
    "#     SapGuiAuto = win32com.client.GetObject(\"SAPGUI\")\n",
    "\n",
    "#     application = SapGuiAuto.GetScriptingEngine\n",
    "\n",
    "#     connection = application.Children(0)\n",
    "\n",
    "#     if connection.DisabledByServer == True:\n",
    "#       print(\"Scripting is disabled by server\")\n",
    "#       application = None\n",
    "#       SapGuiAuto = None\n",
    "#       return\n",
    "\n",
    "#     session = connection.Children(0)\n",
    "\n",
    "#     if session.Info.IsLowSpeedConnection == True:\n",
    "#       print(\"Connection is low speed\")\n",
    "#       connection = None\n",
    "#       application = None\n",
    "#       SapGuiAuto = None\n",
    "#       return\n",
    "\n",
    "\n",
    "# #-Begin-----------------------------------------------------------------\n",
    "\n",
    "# #-Includes--------------------------------------------------------------\n",
    "import sys\n",
    "import win32com.client\n",
    "\n",
    "#-Sub Main--------------------------------------------------------------\n",
    "def Main():\n",
    "\n",
    "  try:\n",
    "\n",
    "    SapGuiAuto = win32com.client.GetObject(\"SAPGUI\")\n",
    "    if not type(SapGuiAuto) == win32com.client.CDispatch:\n",
    "      return\n",
    "\n",
    "    application = SapGuiAuto.GetScriptingEngine\n",
    "    if not type(application) == win32com.client.CDispatch:\n",
    "      SapGuiAuto = None\n",
    "      return\n",
    "\n",
    "    connection = application.Children(0)\n",
    "    if not type(connection) == win32com.client.CDispatch:\n",
    "      application = None\n",
    "      SapGuiAuto = None\n",
    "      return\n",
    "\n",
    "    if connection.DisabledByServer == True:\n",
    "      application = None\n",
    "      SapGuiAuto = None\n",
    "      return\n",
    "\n",
    "    session = connection.Children(0)\n",
    "    if not type(session) == win32com.client.CDispatch:\n",
    "      connection = None\n",
    "      application = None\n",
    "      SapGuiAuto = None\n",
    "      return\n",
    "\n",
    "    if session.Info.IsLowSpeedConnection == True:\n",
    "      connection = None\n",
    "      application = None\n",
    "      SapGuiAuto = None\n",
    "      return\n",
    "    \n",
    "    \n",
    "    \n",
    "    \n",
    "    \n",
    "    \n",
    "    \n",
    "    \n",
    "    \n",
    "    \n",
    "    \n",
    "    \n",
    "    \n",
    "    \n",
    "    \n",
    "\n",
    "     #>Insert your SAP GUI Scripting code here<\n",
    "        \n",
    "\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "    for i in range(0,10): # i is the i-st value in PO_list\n",
    "        session.findById(\"wnd[0]\").resizeWorkingPane(175, 30, 0)\n",
    "        session.findById(\"wnd[0]/tbar[0]/okcd\").text = \"me23n\"\n",
    "        session.findById(\"wnd[0]\").sendVKey(0)\n",
    "        session.findById(\"wnd[0]/tbar[1]/btn[17]\").press()\n",
    "        session.findById(\"wnd[1]/usr/subSUB0:SAPLMEGUI:0003/ctxtMEPO_SELECT-EBELN\").text = PO_list[i]\n",
    "        session.findById(\"wnd[1]/tbar[0]/btn[0]\").press()\n",
    "        # Found the PO        \n",
    "        \n",
    "        \n",
    "        # Check if the current material is the errored material\n",
    "        for j in range(0,10): # j is To iterate through the material box            \n",
    "            if str(material[i]) in session.findById(\"wnd[0]/usr/subSUB0:SAPLMEGUI:0019/subSUB3:SAPLMEVIEWS:1100/subSUB2:SAPLMEVIEWS:1200/subSUB1:SAPLMEGUI:1301/subSUB1:/LOT/SAPLOS_PO_ME2X:6000/subSUB_6000:SAPLMEGUI:6000/cmbDYN_6000-LIST\").Text: # Check user material is same with the saved material\n",
    "                # Found the material\n",
    "                for k in range(0,10): # k is for iterate through the status quo, search within a specific material\n",
    "                    path = \"wnd[0]/usr/subSUB0:SAPLMEGUI:0019/subSUB3:SAPLMEVIEWS:1100/subSUB2:SAPLMEVIEWS:1200/subSUB1:SAPLMEGUI:1301/subSUB2:SAPLMEGUI:1303/tabsITEM_DETAIL/tabpTABIDT17/ssubTABSTRIPCONTROL1SUB:SAPLMEVIEWS:1101/subSUB2:SAPLMEGUI:1332/subSUB0:SAPLEINB:0300/tblSAPLEINBTC_0300/ctxtEKES-EBTYP[0,\" + str(i) +\"]\"\n",
    "                    if session.findById(path).text != \"__\":\n",
    "                        print(session.findById(path).text)\n",
    "                        out.loc[PO_list[i],['PO']] = session.findById(path).text\n",
    "                        out.loc[PO_list[i],['Status']] = \n",
    "                    else:\n",
    "                        print(\"Done\")\n",
    "                        break\n",
    "            else:\n",
    "                session.findById(\"wnd[0]/usr/subSUB0:SAPLMEGUI:0019/subSUB3:SAPLMEVIEWS:1100/subSUB2:SAPLMEVIEWS:1200/subSUB1:SAPLMEGUI:1301/subSUB1:/LOT/SAPLOS_PO_ME2X:6000/subSUB_6000:SAPLMEGUI:6000/btn%#AUTOTEXT002\").press()\n",
    "                continue\n",
    "                # Press the down button\n",
    "                \n",
    "                \n",
    "  except:\n",
    "    print(sys.exc_info()[0])\n",
    "\n",
    "  finally:\n",
    "    session = None\n",
    "    connection = None\n",
    "    application = None\n",
    "    SapGuiAuto = None\n",
    "\n",
    "#-Main------------------------------------------------------------------\n",
    "Main()\n",
    "\n",
    "#-End-------------------------------------------------------------------"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>PO</th>\n",
       "      <th>Status</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>4591800182</th>\n",
       "      <td>AB</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4591817010</th>\n",
       "      <td>AB</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4591826486</th>\n",
       "      <td>AB</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4591887708</th>\n",
       "      <td>AB</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            PO  Status\n",
       "4591800182  AB     NaN\n",
       "4591817010  AB     NaN\n",
       "4591826486  AB     NaN\n",
       "4591887708  AB     NaN"
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "out"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}