Linking_PnP_and_BOM_Files_Script.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 101,
   "id": "ee24122f",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "3.9.7 (tags/v3.9.7:1016ef3, Aug 30 2021, 20:19:38) [MSC v.1929 64 bit (AMD64)]\n",
      "BOM File\n",
      "               Comment                                         Designator  \\\n",
      "0                 10uf                                                 C1   \n",
      "1                 22pf                                              C2,C3   \n",
      "2                  1uf                                                 C4   \n",
      "3                100nf  C5,C6,C7,C8,C9,C10,C11,C12,C13,C14,C15,C16,C17...   \n",
      "4                    D  D1,D2,D3,D4,D5,D6,D7,D8,D9,D10,D11,D12,D13,D14...   \n",
      "5                 5.1K                                              R1,R2   \n",
      "6                  10K                                              R3,R8   \n",
      "7                   22                                              R4,R5   \n",
      "8                  220                                              R6,R7   \n",
      "9              SW_Push                                            SW1,SW2   \n",
      "10       ATmega32U4-AU                                                 U1   \n",
      "11  HRO-TYPE-C-31-M-12                                               USB1   \n",
      "12               16MHz                                                 Y1   \n",
      "\n",
      "                                         Footprint     LCSC  \n",
      "0                  Capacitor_SMD:C_0402_1005Metric   C15525  \n",
      "1                  Capacitor_SMD:C_0805_2012Metric    C1804  \n",
      "2                  Capacitor_SMD:C_0805_2012Metric   C28323  \n",
      "3                  Capacitor_SMD:C_0603_1608Metric   C14663  \n",
      "4                              Diode_SMD:D_SOD-123    C8598  \n",
      "5                   Resistor_SMD:R_0603_1608Metric   C23186  \n",
      "6                   Resistor_SMD:R_1206_3216Metric   C17902  \n",
      "7                   Resistor_SMD:R_0603_1608Metric    C1203  \n",
      "8                   Resistor_SMD:R_0603_1608Metric   C22962  \n",
      "9   Button_Switch_SMD:SW_Push_1P1T_NO_6x6mm_H9.5mm  C620316  \n",
      "10              Package_QFP:TQFP-44_10x10mm_P0.8mm   C44854  \n",
      "11                       Type-C:HRO-TYPE-C-31-M-12  C165948  \n",
      "12         Crystal:Crystal_SMD_3225-4Pin_3.2x2.5mm   C13738  \n",
      "\n",
      "\n",
      "PNP File\n",
      "    Designator                 Val                          Package    Mid X  \\\n",
      "0           C1                10uf                C_0402_1005Metric  110.970   \n",
      "1           C2                22pf                C_0805_2012Metric   80.010   \n",
      "2           C3                22pf                C_0805_2012Metric   82.550   \n",
      "3           C4                 1uf                C_0805_2012Metric   86.360   \n",
      "4           C5               100nf                C_0603_1608Metric   38.530   \n",
      "..         ...                 ...                              ...      ...   \n",
      "140         R8                 10K                R_1206_3216Metric  140.462   \n",
      "141        SW1             SW_Push     SW_Push_1P1T_NO_6x6mm_H9.5mm  127.381   \n",
      "142         U1       ATmega32U4-AU           TQFP-44_10x10mm_P0.8mm  107.950   \n",
      "143       USB1  HRO-TYPE-C-31-M-12               HRO-TYPE-C-31-M-12  107.950   \n",
      "144         Y1               16MHz  Crystal_SMD_3225-4Pin_3.2x2.5mm   83.355   \n",
      "\n",
      "      Mid Y  Rotation Layer LCSC  \n",
      "0   -40.640         0   top  N/A  \n",
      "1   -41.656        90   top  N/A  \n",
      "2   -41.656        90   top  N/A  \n",
      "3   -41.656        90   top  N/A  \n",
      "4   -78.740       180   top  N/A  \n",
      "..      ...       ...   ...  ...  \n",
      "140 -41.783         0   top  N/A  \n",
      "141 -36.957         0   top  N/A  \n",
      "142 -50.165       315   top  N/A  \n",
      "143 -29.210       180   top  N/A  \n",
      "144 -49.315         0   top  N/A  \n",
      "\n",
      "[145 rows x 8 columns]\n",
      "LCSC Values\n",
      "Dictionary Object for LCSC keys and Designator values\n",
      "{'C15525': ['C1'], 'C1804': ['C2', 'C3'], 'C28323': ['C4'], 'C14663': ['C5', 'C6', 'C7', 'C8', 'C9', 'C10', 'C11', 'C12', 'C13', 'C14', 'C15', 'C16', 'C17', 'C18', 'C19', 'C20', 'C21', 'C22', 'C23', 'C24', 'C25', 'C26', 'C27', 'C28', 'C29', 'C30', 'C31', 'C32', 'C33', 'C34', 'C35', 'C36', 'C37', 'C38', 'C39', 'C40', 'C41', 'C42', 'C43', 'C44', 'C45', 'C46', 'C47', 'C48', 'C49', 'C50', 'C51', 'C52', 'C53', 'C54', 'C55', 'C56', 'C57', 'C58', 'C59', 'C60', 'C61', 'C62', 'C63', 'C64', 'C65', 'C66', 'C67', 'C68'], 'C8598': ['D1', 'D2', 'D3', 'D4', 'D5', 'D6', 'D7', 'D8', 'D9', 'D10', 'D11', 'D12', 'D13', 'D14', 'D15', 'D16', 'D17', 'D18', 'D19', 'D20', 'D21', 'D22', 'D23', 'D24', 'D25', 'D26', 'D27', 'D28', 'D29', 'D30', 'D31', 'D32', 'D33', 'D34', 'D35', 'D36', 'D37', 'D38', 'D39', 'D40', 'D41', 'D42', 'D43', 'D44', 'D45', 'D46', 'D47', 'D48', 'D49', 'D50', 'D51', 'D52', 'D53', 'D54', 'D55', 'D56', 'D57', 'D58', 'D59', 'D60', 'D61', 'D62', 'D63', 'D64'], 'C23186': ['R1', 'R2'], 'C17902': ['R3', 'R8'], 'C1203': ['R4', 'R5'], 'C22962': ['R6', 'R7'], 'C620316': ['SW1', 'SW2'], 'C44854': ['U1'], 'C165948': ['USB1'], 'C13738': ['Y1']}\n",
      "[0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 133, 134, 135, 140, 136, 137, 138, 139, 141, 132, 142, 143, 144]\n",
      "New PNP File\n",
      "    Designator                 Val                          Package    Mid X  \\\n",
      "0           C1                10uf                C_0402_1005Metric  110.970   \n",
      "1           C2                22pf                C_0805_2012Metric   80.010   \n",
      "2           C3                22pf                C_0805_2012Metric   82.550   \n",
      "3           C4                 1uf                C_0805_2012Metric   86.360   \n",
      "4           C5               100nf                C_0603_1608Metric   38.530   \n",
      "..         ...                 ...                              ...      ...   \n",
      "140         R8                 10K                R_1206_3216Metric  140.462   \n",
      "141        SW1             SW_Push     SW_Push_1P1T_NO_6x6mm_H9.5mm  127.381   \n",
      "142         U1       ATmega32U4-AU           TQFP-44_10x10mm_P0.8mm  107.950   \n",
      "143       USB1  HRO-TYPE-C-31-M-12               HRO-TYPE-C-31-M-12  107.950   \n",
      "144         Y1               16MHz  Crystal_SMD_3225-4Pin_3.2x2.5mm   83.355   \n",
      "\n",
      "      Mid Y  Rotation Layer     LCSC  \n",
      "0   -40.640         0   top   C15525  \n",
      "1   -41.656        90   top    C1804  \n",
      "2   -41.656        90   top    C1804  \n",
      "3   -41.656        90   top   C28323  \n",
      "4   -78.740       180   top   C14663  \n",
      "..      ...       ...   ...      ...  \n",
      "140 -41.783         0   top   C17902  \n",
      "141 -36.957         0   top  C620316  \n",
      "142 -50.165       315   top   C44854  \n",
      "143 -29.210       180   top  C165948  \n",
      "144 -49.315         0   top   C13738  \n",
      "\n",
      "[145 rows x 8 columns]\n",
      "Grouped PNP File\n",
      "['C1' '10uf' 'C_0402_1005Metric' 110.97 -40.64 0 'top' 'C15525']\n",
      "['C2' '22pf' 'C_0805_2012Metric' 80.01 -41.656 90 'top' 'C1804']\n",
      "['C3' '22pf' 'C_0805_2012Metric' 82.55 -41.656 90 'top' 'C1804']\n",
      "['C4' '1uf' 'C_0805_2012Metric' 86.36 -41.656 90 'top' 'C28323']\n",
      "['C5' '100nf' 'C_0603_1608Metric' 38.53 -78.74 180 'top' 'C14663']\n",
      "['C6' '100nf' 'C_0603_1608Metric' 57.58 -78.74 180 'top' 'C14663']\n",
      "['C7' '100nf' 'C_0603_1608Metric' 76.63 -78.705 180 'top' 'C14663']\n",
      "['C8' '100nf' 'C_0603_1608Metric' 95.68 -78.74 180 'top' 'C14663']\n",
      "['C9' '100nf' 'C_0603_1608Metric' 114.73 -78.74 180 'top' 'C14663']\n",
      "['C10' '100nf' 'C_0603_1608Metric' 133.78 -78.74 180 'top' 'C14663']\n",
      "['C11' '100nf' 'C_0603_1608Metric' 152.83 -78.74 180 'top' 'C14663']\n",
      "['C12' '100nf' 'C_0603_1608Metric' 171.88 -78.74 180 'top' 'C14663']\n",
      "['C13' '100nf' 'C_0603_1608Metric' 38.53 -97.79 180 'top' 'C14663']\n",
      "['C14' '100nf' 'C_0603_1608Metric' 57.58 -97.79 180 'top' 'C14663']\n",
      "['C15' '100nf' 'C_0603_1608Metric' 76.63 -97.79 180 'top' 'C14663']\n",
      "['C16' '100nf' 'C_0603_1608Metric' 95.68 -97.79 180 'top' 'C14663']\n",
      "['C17' '100nf' 'C_0603_1608Metric' 114.73 -97.79 180 'top' 'C14663']\n",
      "['C18' '100nf' 'C_0603_1608Metric' 133.78 -97.79 180 'top' 'C14663']\n",
      "['C19' '100nf' 'C_0603_1608Metric' 152.83 -97.79 180 'top' 'C14663']\n",
      "['C20' '100nf' 'C_0603_1608Metric' 171.88 -97.79 180 'top' 'C14663']\n",
      "['C21' '100nf' 'C_0603_1608Metric' 38.53 -116.84 180 'top' 'C14663']\n",
      "['C22' '100nf' 'C_0603_1608Metric' 57.58 -116.84 180 'top' 'C14663']\n",
      "['C23' '100nf' 'C_0603_1608Metric' 76.63 -116.84 180 'top' 'C14663']\n",
      "['C24' '100nf' 'C_0603_1608Metric' 95.68 -116.84 180 'top' 'C14663']\n",
      "['C25' '100nf' 'C_0603_1608Metric' 114.73 -116.84 180 'top' 'C14663']\n",
      "['C26' '100nf' 'C_0603_1608Metric' 133.78 -116.84 180 'top' 'C14663']\n",
      "['C27' '100nf' 'C_0603_1608Metric' 152.83 -116.84 180 'top' 'C14663']\n",
      "['C28' '100nf' 'C_0603_1608Metric' 171.88 -116.84 180 'top' 'C14663']\n",
      "['C29' '100nf' 'C_0603_1608Metric' 38.53 -135.89 180 'top' 'C14663']\n",
      "['C30' '100nf' 'C_0603_1608Metric' 57.58 -135.89 180 'top' 'C14663']\n",
      "['C31' '100nf' 'C_0603_1608Metric' 76.63 -135.89 180 'top' 'C14663']\n",
      "['C32' '100nf' 'C_0603_1608Metric' 95.68 -135.89 180 'top' 'C14663']\n",
      "['C33' '100nf' 'C_0603_1608Metric' 114.73 -135.89 180 'top' 'C14663']\n",
      "['C34' '100nf' 'C_0603_1608Metric' 133.78 -135.89 180 'top' 'C14663']\n",
      "['C35' '100nf' 'C_0603_1608Metric' 152.83 -135.89 180 'top' 'C14663']\n",
      "['C36' '100nf' 'C_0603_1608Metric' 171.88 -135.89 180 'top' 'C14663']\n",
      "['C37' '100nf' 'C_0603_1608Metric' 38.53 -154.94 180 'top' 'C14663']\n",
      "['C38' '100nf' 'C_0603_1608Metric' 57.58 -154.94 180 'top' 'C14663']\n",
      "['C39' '100nf' 'C_0603_1608Metric' 76.63 -154.94 180 'top' 'C14663']\n",
      "['C40' '100nf' 'C_0603_1608Metric' 95.68 -154.94 180 'top' 'C14663']\n",
      "['C41' '100nf' 'C_0603_1608Metric' 114.73 -154.94 180 'top' 'C14663']\n",
      "['C42' '100nf' 'C_0603_1608Metric' 133.78 -154.94 180 'top' 'C14663']\n",
      "['C43' '100nf' 'C_0603_1608Metric' 152.83 -154.94 180 'top' 'C14663']\n",
      "['C44' '100nf' 'C_0603_1608Metric' 171.88 -154.94 180 'top' 'C14663']\n",
      "['C45' '100nf' 'C_0603_1608Metric' 38.53 -173.99 180 'top' 'C14663']\n",
      "['C46' '100nf' 'C_0603_1608Metric' 57.58 -173.99 180 'top' 'C14663']\n",
      "['C47' '100nf' 'C_0603_1608Metric' 76.63 -173.99 180 'top' 'C14663']\n",
      "['C48' '100nf' 'C_0603_1608Metric' 95.68 -173.99 180 'top' 'C14663']\n",
      "['C49' '100nf' 'C_0603_1608Metric' 114.73 -173.99 180 'top' 'C14663']\n",
      "['C50' '100nf' 'C_0603_1608Metric' 133.78 -173.99 180 'top' 'C14663']\n",
      "['C51' '100nf' 'C_0603_1608Metric' 152.83 -173.99 180 'top' 'C14663']\n",
      "['C52' '100nf' 'C_0603_1608Metric' 171.88 -173.99 180 'top' 'C14663']\n",
      "['C53' '100nf' 'C_0603_1608Metric' 38.53 -193.04 180 'top' 'C14663']\n",
      "['C54' '100nf' 'C_0603_1608Metric' 57.58 -193.04 180 'top' 'C14663']\n",
      "['C55' '100nf' 'C_0603_1608Metric' 76.63 -193.04 180 'top' 'C14663']\n",
      "['C56' '100nf' 'C_0603_1608Metric' 95.68 -193.04 180 'top' 'C14663']\n",
      "['C57' '100nf' 'C_0603_1608Metric' 114.73 -193.04 180 'top' 'C14663']\n",
      "['C58' '100nf' 'C_0603_1608Metric' 133.78 -193.04 180 'top' 'C14663']\n",
      "['C59' '100nf' 'C_0603_1608Metric' 152.83 -193.04 180 'top' 'C14663']\n",
      "['C60' '100nf' 'C_0603_1608Metric' 171.88 -193.04 180 'top' 'C14663']\n",
      "['C61' '100nf' 'C_0603_1608Metric' 41.275 -212.09 180 'top' 'C14663']\n",
      "['C62' '100nf' 'C_0603_1608Metric' 60.325 -212.09 180 'top' 'C14663']\n",
      "['C63' '100nf' 'C_0603_1608Metric' 79.375 -212.09 180 'top' 'C14663']\n",
      "['C64' '100nf' 'C_0603_1608Metric' 98.425 -212.09 180 'top' 'C14663']\n",
      "['C65' '100nf' 'C_0603_1608Metric' 117.475 -212.09 180 'top' 'C14663']\n",
      "['C66' '100nf' 'C_0603_1608Metric' 136.525 -212.09 180 'top' 'C14663']\n",
      "['C67' '100nf' 'C_0603_1608Metric' 155.575 -212.09 180 'top' 'C14663']\n",
      "['C68' '100nf' 'C_0603_1608Metric' 174.625 -212.09 180 'top' 'C14663']\n",
      "['D1' 'D' 'D_SOD-123' 41.275 -59.69 180 'top' 'C8598']\n",
      "['D2' 'D' 'D_SOD-123' 60.325 -59.69 180 'top' 'C8598']\n",
      "['D3' 'D' 'D_SOD-123' 79.375 -59.69 180 'top' 'C8598']\n",
      "['D4' 'D' 'D_SOD-123' 98.425 -59.69 180 'top' 'C8598']\n",
      "['D5' 'D' 'D_SOD-123' 117.475 -59.69 180 'top' 'C8598']\n",
      "['D6' 'D' 'D_SOD-123' 136.525 -59.69 180 'top' 'C8598']\n",
      "['D7' 'D' 'D_SOD-123' 155.575 -59.69 180 'top' 'C8598']\n",
      "['D8' 'D' 'D_SOD-123' 174.625 -59.69 180 'top' 'C8598']\n",
      "['D9' 'D' 'D_SOD-123' 44.45 -78.74 180 'top' 'C8598']\n",
      "['D10' 'D' 'D_SOD-123' 63.5 -78.74 180 'top' 'C8598']\n",
      "['D11' 'D' 'D_SOD-123' 82.55 -78.74 180 'top' 'C8598']\n",
      "['D12' 'D' 'D_SOD-123' 101.6 -78.74 180 'top' 'C8598']\n",
      "['D13' 'D' 'D_SOD-123' 120.65 -78.74 180 'top' 'C8598']\n",
      "['D14' 'D' 'D_SOD-123' 139.7 -78.74 180 'top' 'C8598']\n",
      "['D15' 'D' 'D_SOD-123' 158.75 -78.74 180 'top' 'C8598']\n",
      "['D16' 'D' 'D_SOD-123' 177.8 -78.74 180 'top' 'C8598']\n",
      "['D17' 'D' 'D_SOD-123' 44.45 -97.79 180 'top' 'C8598']\n",
      "['D18' 'D' 'D_SOD-123' 63.5 -97.79 180 'top' 'C8598']\n",
      "['D19' 'D' 'D_SOD-123' 82.55 -97.79 180 'top' 'C8598']\n",
      "['D20' 'D' 'D_SOD-123' 101.6 -97.79 180 'top' 'C8598']\n",
      "['D21' 'D' 'D_SOD-123' 120.65 -97.79 180 'top' 'C8598']\n",
      "['D22' 'D' 'D_SOD-123' 139.7 -97.79 180 'top' 'C8598']\n",
      "['D23' 'D' 'D_SOD-123' 158.75 -97.79 180 'top' 'C8598']\n",
      "['D24' 'D' 'D_SOD-123' 177.8 -97.79 180 'top' 'C8598']\n",
      "['D25' 'D' 'D_SOD-123' 44.45 -116.84 180 'top' 'C8598']\n",
      "['D26' 'D' 'D_SOD-123' 63.5 -116.84 180 'top' 'C8598']\n",
      "['D27' 'D' 'D_SOD-123' 82.55 -116.84 180 'top' 'C8598']\n",
      "['D28' 'D' 'D_SOD-123' 101.6 -116.84 180 'top' 'C8598']\n",
      "['D29' 'D' 'D_SOD-123' 120.65 -116.84 180 'top' 'C8598']\n",
      "['D30' 'D' 'D_SOD-123' 139.7 -116.84 180 'top' 'C8598']\n",
      "['D31' 'D' 'D_SOD-123' 158.75 -116.84 180 'top' 'C8598']\n",
      "['D32' 'D' 'D_SOD-123' 177.8 -116.84 180 'top' 'C8598']\n",
      "['D33' 'D' 'D_SOD-123' 44.45 -135.89 180 'top' 'C8598']\n",
      "['D34' 'D' 'D_SOD-123' 63.5 -135.89 180 'top' 'C8598']\n",
      "['D35' 'D' 'D_SOD-123' 82.55 -135.89 180 'top' 'C8598']\n",
      "['D36' 'D' 'D_SOD-123' 101.6 -135.89 180 'top' 'C8598']\n",
      "['D37' 'D' 'D_SOD-123' 120.65 -135.89 180 'top' 'C8598']\n",
      "['D38' 'D' 'D_SOD-123' 139.7 -135.89 180 'top' 'C8598']\n",
      "['D39' 'D' 'D_SOD-123' 158.75 -135.89 180 'top' 'C8598']\n",
      "['D40' 'D' 'D_SOD-123' 177.8 -135.89 180 'top' 'C8598']\n",
      "['D41' 'D' 'D_SOD-123' 44.45 -154.94 180 'top' 'C8598']\n",
      "['D42' 'D' 'D_SOD-123' 63.5 -154.94 180 'top' 'C8598']\n",
      "['D43' 'D' 'D_SOD-123' 82.55 -154.94 180 'top' 'C8598']\n",
      "['D44' 'D' 'D_SOD-123' 101.6 -154.94 180 'top' 'C8598']\n",
      "['D45' 'D' 'D_SOD-123' 120.65 -154.94 180 'top' 'C8598']\n",
      "['D46' 'D' 'D_SOD-123' 139.7 -154.94 180 'top' 'C8598']\n",
      "['D47' 'D' 'D_SOD-123' 158.75 -154.94 180 'top' 'C8598']\n",
      "['D48' 'D' 'D_SOD-123' 177.8 -154.94 180 'top' 'C8598']\n",
      "['D49' 'D' 'D_SOD-123' 44.45 -173.99 180 'top' 'C8598']\n",
      "['D50' 'D' 'D_SOD-123' 63.5 -173.99 180 'top' 'C8598']\n",
      "['D51' 'D' 'D_SOD-123' 82.55 -173.99 180 'top' 'C8598']\n",
      "['D52' 'D' 'D_SOD-123' 101.6 -173.99 180 'top' 'C8598']\n",
      "['D53' 'D' 'D_SOD-123' 120.65 -173.99 180 'top' 'C8598']\n",
      "['D54' 'D' 'D_SOD-123' 139.7 -173.99 180 'top' 'C8598']\n",
      "['D55' 'D' 'D_SOD-123' 158.75 -173.99 180 'top' 'C8598']\n",
      "['D56' 'D' 'D_SOD-123' 177.8 -173.99 180 'top' 'C8598']\n",
      "['D57' 'D' 'D_SOD-123' 44.45 -193.04 180 'top' 'C8598']\n",
      "['D58' 'D' 'D_SOD-123' 63.5 -193.04 180 'top' 'C8598']\n",
      "['D59' 'D' 'D_SOD-123' 82.805 -193.04 180 'top' 'C8598']\n",
      "['D60' 'D' 'D_SOD-123' 101.6 -193.04 180 'top' 'C8598']\n",
      "['D61' 'D' 'D_SOD-123' 120.65 -193.04 180 'top' 'C8598']\n",
      "['D62' 'D' 'D_SOD-123' 139.7 -193.04 180 'top' 'C8598']\n",
      "['D63' 'D' 'D_SOD-123' 158.75 -193.04 180 'top' 'C8598']\n",
      "['D64' 'D' 'D_SOD-123' 177.8 -193.04 180 'top' 'C8598']\n",
      "['R1' '5.1K' 'R_0603_1608Metric' 93.98 -41.402 90 'top' 'C23186']\n",
      "['R2' '5.1K' 'R_0603_1608Metric' 91.44 -41.465 90 'top' 'C23186']\n",
      "['R3' '10K' 'R_1206_3216Metric' 127.355 -41.783 180 'top' 'C17902']\n",
      "['R8' '10K' 'R_1206_3216Metric' 140.462 -41.783 0 'top' 'C17902']\n",
      "['R4' 22 'R_0603_1608Metric' 99.06 -41.465 90 'top' 'C1203']\n",
      "['R5' 22 'R_0603_1608Metric' 101.6 -41.465 90 'top' 'C1203']\n",
      "['R6' 220 'R_0603_1608Metric' 156.781 -39.624 180 'top' 'C22962']\n",
      "['R7' 220 'R_0603_1608Metric' 151.447 -39.624 180 'top' 'C22962']\n",
      "['SW1' 'SW_Push' 'SW_Push_1P1T_NO_6x6mm_H9.5mm' 127.381 -36.957 0 'top'\n",
      " 'C620316']\n",
      "['SW2' 'SW_Push' 'SW_Push_1P1T_NO_6x6mm_H9.5mm' 140.462 -36.957 0 'top'\n",
      " 'C620316']\n",
      "['U1' 'ATmega32U4-AU' 'TQFP-44_10x10mm_P0.8mm' 107.95 -50.165 315 'top'\n",
      " 'C44854']\n",
      "['USB1' 'HRO-TYPE-C-31-M-12' 'HRO-TYPE-C-31-M-12' 107.95 -29.21 180 'top'\n",
      " 'C165948']\n",
      "['Y1' '16MHz' 'Crystal_SMD_3225-4Pin_3.2x2.5mm' 83.355 -49.315 0 'top'\n",
      " 'C13738']\n",
      "['C1203', 'C1804', 'C8598', 'C13738', 'C14663', 'C15525', 'C17902', 'C22962', 'C23186', 'C28323', 'C44854', 'C165948', 'C620316']\n",
      "Sorted PNP File\n",
      "['R4' 22 'R_0603_1608Metric' 99.06 -41.465 90 'top' 'C1203']\n",
      "['R5' 22 'R_0603_1608Metric' 101.6 -41.465 90 'top' 'C1203']\n",
      "['C2' '22pf' 'C_0805_2012Metric' 80.01 -41.656 90 'top' 'C1804']\n",
      "['C3' '22pf' 'C_0805_2012Metric' 82.55 -41.656 90 'top' 'C1804']\n",
      "['D1' 'D' 'D_SOD-123' 41.275 -59.69 180 'top' 'C8598']\n",
      "['D2' 'D' 'D_SOD-123' 60.325 -59.69 180 'top' 'C8598']\n",
      "['D3' 'D' 'D_SOD-123' 79.375 -59.69 180 'top' 'C8598']\n",
      "['D4' 'D' 'D_SOD-123' 98.425 -59.69 180 'top' 'C8598']\n",
      "['D5' 'D' 'D_SOD-123' 117.475 -59.69 180 'top' 'C8598']\n",
      "['D6' 'D' 'D_SOD-123' 136.525 -59.69 180 'top' 'C8598']\n",
      "['D7' 'D' 'D_SOD-123' 155.575 -59.69 180 'top' 'C8598']\n",
      "['D8' 'D' 'D_SOD-123' 174.625 -59.69 180 'top' 'C8598']\n",
      "['D9' 'D' 'D_SOD-123' 44.45 -78.74 180 'top' 'C8598']\n",
      "['D10' 'D' 'D_SOD-123' 63.5 -78.74 180 'top' 'C8598']\n",
      "['D11' 'D' 'D_SOD-123' 82.55 -78.74 180 'top' 'C8598']\n",
      "['D12' 'D' 'D_SOD-123' 101.6 -78.74 180 'top' 'C8598']\n",
      "['D13' 'D' 'D_SOD-123' 120.65 -78.74 180 'top' 'C8598']\n",
      "['D14' 'D' 'D_SOD-123' 139.7 -78.74 180 'top' 'C8598']\n",
      "['D15' 'D' 'D_SOD-123' 158.75 -78.74 180 'top' 'C8598']\n",
      "['D16' 'D' 'D_SOD-123' 177.8 -78.74 180 'top' 'C8598']\n",
      "['D17' 'D' 'D_SOD-123' 44.45 -97.79 180 'top' 'C8598']\n",
      "['D18' 'D' 'D_SOD-123' 63.5 -97.79 180 'top' 'C8598']\n",
      "['D19' 'D' 'D_SOD-123' 82.55 -97.79 180 'top' 'C8598']\n",
      "['D20' 'D' 'D_SOD-123' 101.6 -97.79 180 'top' 'C8598']\n",
      "['D21' 'D' 'D_SOD-123' 120.65 -97.79 180 'top' 'C8598']\n",
      "['D22' 'D' 'D_SOD-123' 139.7 -97.79 180 'top' 'C8598']\n",
      "['D23' 'D' 'D_SOD-123' 158.75 -97.79 180 'top' 'C8598']\n",
      "['D24' 'D' 'D_SOD-123' 177.8 -97.79 180 'top' 'C8598']\n",
      "['D25' 'D' 'D_SOD-123' 44.45 -116.84 180 'top' 'C8598']\n",
      "['D26' 'D' 'D_SOD-123' 63.5 -116.84 180 'top' 'C8598']\n",
      "['D27' 'D' 'D_SOD-123' 82.55 -116.84 180 'top' 'C8598']\n",
      "['D28' 'D' 'D_SOD-123' 101.6 -116.84 180 'top' 'C8598']\n",
      "['D29' 'D' 'D_SOD-123' 120.65 -116.84 180 'top' 'C8598']\n",
      "['D30' 'D' 'D_SOD-123' 139.7 -116.84 180 'top' 'C8598']\n",
      "['D31' 'D' 'D_SOD-123' 158.75 -116.84 180 'top' 'C8598']\n",
      "['D32' 'D' 'D_SOD-123' 177.8 -116.84 180 'top' 'C8598']\n",
      "['D33' 'D' 'D_SOD-123' 44.45 -135.89 180 'top' 'C8598']\n",
      "['D34' 'D' 'D_SOD-123' 63.5 -135.89 180 'top' 'C8598']\n",
      "['D35' 'D' 'D_SOD-123' 82.55 -135.89 180 'top' 'C8598']\n",
      "['D36' 'D' 'D_SOD-123' 101.6 -135.89 180 'top' 'C8598']\n",
      "['D37' 'D' 'D_SOD-123' 120.65 -135.89 180 'top' 'C8598']\n",
      "['D38' 'D' 'D_SOD-123' 139.7 -135.89 180 'top' 'C8598']\n",
      "['D39' 'D' 'D_SOD-123' 158.75 -135.89 180 'top' 'C8598']\n",
      "['D40' 'D' 'D_SOD-123' 177.8 -135.89 180 'top' 'C8598']\n",
      "['D41' 'D' 'D_SOD-123' 44.45 -154.94 180 'top' 'C8598']\n",
      "['D42' 'D' 'D_SOD-123' 63.5 -154.94 180 'top' 'C8598']\n",
      "['D43' 'D' 'D_SOD-123' 82.55 -154.94 180 'top' 'C8598']\n",
      "['D44' 'D' 'D_SOD-123' 101.6 -154.94 180 'top' 'C8598']\n",
      "['D45' 'D' 'D_SOD-123' 120.65 -154.94 180 'top' 'C8598']\n",
      "['D46' 'D' 'D_SOD-123' 139.7 -154.94 180 'top' 'C8598']\n",
      "['D47' 'D' 'D_SOD-123' 158.75 -154.94 180 'top' 'C8598']\n",
      "['D48' 'D' 'D_SOD-123' 177.8 -154.94 180 'top' 'C8598']\n",
      "['D49' 'D' 'D_SOD-123' 44.45 -173.99 180 'top' 'C8598']\n",
      "['D50' 'D' 'D_SOD-123' 63.5 -173.99 180 'top' 'C8598']\n",
      "['D51' 'D' 'D_SOD-123' 82.55 -173.99 180 'top' 'C8598']\n",
      "['D52' 'D' 'D_SOD-123' 101.6 -173.99 180 'top' 'C8598']\n",
      "['D53' 'D' 'D_SOD-123' 120.65 -173.99 180 'top' 'C8598']\n",
      "['D54' 'D' 'D_SOD-123' 139.7 -173.99 180 'top' 'C8598']\n",
      "['D55' 'D' 'D_SOD-123' 158.75 -173.99 180 'top' 'C8598']\n",
      "['D56' 'D' 'D_SOD-123' 177.8 -173.99 180 'top' 'C8598']\n",
      "['D57' 'D' 'D_SOD-123' 44.45 -193.04 180 'top' 'C8598']\n",
      "['D58' 'D' 'D_SOD-123' 63.5 -193.04 180 'top' 'C8598']\n",
      "['D59' 'D' 'D_SOD-123' 82.805 -193.04 180 'top' 'C8598']\n",
      "['D60' 'D' 'D_SOD-123' 101.6 -193.04 180 'top' 'C8598']\n",
      "['D61' 'D' 'D_SOD-123' 120.65 -193.04 180 'top' 'C8598']\n",
      "['D62' 'D' 'D_SOD-123' 139.7 -193.04 180 'top' 'C8598']\n",
      "['D63' 'D' 'D_SOD-123' 158.75 -193.04 180 'top' 'C8598']\n",
      "['D64' 'D' 'D_SOD-123' 177.8 -193.04 180 'top' 'C8598']\n",
      "['Y1' '16MHz' 'Crystal_SMD_3225-4Pin_3.2x2.5mm' 83.355 -49.315 0 'top'\n",
      " 'C13738']\n",
      "['C5' '100nf' 'C_0603_1608Metric' 38.53 -78.74 180 'top' 'C14663']\n",
      "['C6' '100nf' 'C_0603_1608Metric' 57.58 -78.74 180 'top' 'C14663']\n",
      "['C7' '100nf' 'C_0603_1608Metric' 76.63 -78.705 180 'top' 'C14663']\n",
      "['C8' '100nf' 'C_0603_1608Metric' 95.68 -78.74 180 'top' 'C14663']\n",
      "['C9' '100nf' 'C_0603_1608Metric' 114.73 -78.74 180 'top' 'C14663']\n",
      "['C10' '100nf' 'C_0603_1608Metric' 133.78 -78.74 180 'top' 'C14663']\n",
      "['C11' '100nf' 'C_0603_1608Metric' 152.83 -78.74 180 'top' 'C14663']\n",
      "['C12' '100nf' 'C_0603_1608Metric' 171.88 -78.74 180 'top' 'C14663']\n",
      "['C13' '100nf' 'C_0603_1608Metric' 38.53 -97.79 180 'top' 'C14663']\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['C14' '100nf' 'C_0603_1608Metric' 57.58 -97.79 180 'top' 'C14663']\n",
      "['C15' '100nf' 'C_0603_1608Metric' 76.63 -97.79 180 'top' 'C14663']\n",
      "['C16' '100nf' 'C_0603_1608Metric' 95.68 -97.79 180 'top' 'C14663']\n",
      "['C17' '100nf' 'C_0603_1608Metric' 114.73 -97.79 180 'top' 'C14663']\n",
      "['C18' '100nf' 'C_0603_1608Metric' 133.78 -97.79 180 'top' 'C14663']\n",
      "['C19' '100nf' 'C_0603_1608Metric' 152.83 -97.79 180 'top' 'C14663']\n",
      "['C20' '100nf' 'C_0603_1608Metric' 171.88 -97.79 180 'top' 'C14663']\n",
      "['C21' '100nf' 'C_0603_1608Metric' 38.53 -116.84 180 'top' 'C14663']\n",
      "['C22' '100nf' 'C_0603_1608Metric' 57.58 -116.84 180 'top' 'C14663']\n",
      "['C23' '100nf' 'C_0603_1608Metric' 76.63 -116.84 180 'top' 'C14663']\n",
      "['C24' '100nf' 'C_0603_1608Metric' 95.68 -116.84 180 'top' 'C14663']\n",
      "['C25' '100nf' 'C_0603_1608Metric' 114.73 -116.84 180 'top' 'C14663']\n",
      "['C26' '100nf' 'C_0603_1608Metric' 133.78 -116.84 180 'top' 'C14663']\n",
      "['C27' '100nf' 'C_0603_1608Metric' 152.83 -116.84 180 'top' 'C14663']\n",
      "['C28' '100nf' 'C_0603_1608Metric' 171.88 -116.84 180 'top' 'C14663']\n",
      "['C29' '100nf' 'C_0603_1608Metric' 38.53 -135.89 180 'top' 'C14663']\n",
      "['C30' '100nf' 'C_0603_1608Metric' 57.58 -135.89 180 'top' 'C14663']\n",
      "['C31' '100nf' 'C_0603_1608Metric' 76.63 -135.89 180 'top' 'C14663']\n",
      "['C32' '100nf' 'C_0603_1608Metric' 95.68 -135.89 180 'top' 'C14663']\n",
      "['C33' '100nf' 'C_0603_1608Metric' 114.73 -135.89 180 'top' 'C14663']\n",
      "['C34' '100nf' 'C_0603_1608Metric' 133.78 -135.89 180 'top' 'C14663']\n",
      "['C35' '100nf' 'C_0603_1608Metric' 152.83 -135.89 180 'top' 'C14663']\n",
      "['C36' '100nf' 'C_0603_1608Metric' 171.88 -135.89 180 'top' 'C14663']\n",
      "['C37' '100nf' 'C_0603_1608Metric' 38.53 -154.94 180 'top' 'C14663']\n",
      "['C38' '100nf' 'C_0603_1608Metric' 57.58 -154.94 180 'top' 'C14663']\n",
      "['C39' '100nf' 'C_0603_1608Metric' 76.63 -154.94 180 'top' 'C14663']\n",
      "['C40' '100nf' 'C_0603_1608Metric' 95.68 -154.94 180 'top' 'C14663']\n",
      "['C41' '100nf' 'C_0603_1608Metric' 114.73 -154.94 180 'top' 'C14663']\n",
      "['C42' '100nf' 'C_0603_1608Metric' 133.78 -154.94 180 'top' 'C14663']\n",
      "['C43' '100nf' 'C_0603_1608Metric' 152.83 -154.94 180 'top' 'C14663']\n",
      "['C44' '100nf' 'C_0603_1608Metric' 171.88 -154.94 180 'top' 'C14663']\n",
      "['C45' '100nf' 'C_0603_1608Metric' 38.53 -173.99 180 'top' 'C14663']\n",
      "['C46' '100nf' 'C_0603_1608Metric' 57.58 -173.99 180 'top' 'C14663']\n",
      "['C47' '100nf' 'C_0603_1608Metric' 76.63 -173.99 180 'top' 'C14663']\n",
      "['C48' '100nf' 'C_0603_1608Metric' 95.68 -173.99 180 'top' 'C14663']\n",
      "['C49' '100nf' 'C_0603_1608Metric' 114.73 -173.99 180 'top' 'C14663']\n",
      "['C50' '100nf' 'C_0603_1608Metric' 133.78 -173.99 180 'top' 'C14663']\n",
      "['C51' '100nf' 'C_0603_1608Metric' 152.83 -173.99 180 'top' 'C14663']\n",
      "['C52' '100nf' 'C_0603_1608Metric' 171.88 -173.99 180 'top' 'C14663']\n",
      "['C53' '100nf' 'C_0603_1608Metric' 38.53 -193.04 180 'top' 'C14663']\n",
      "['C54' '100nf' 'C_0603_1608Metric' 57.58 -193.04 180 'top' 'C14663']\n",
      "['C55' '100nf' 'C_0603_1608Metric' 76.63 -193.04 180 'top' 'C14663']\n",
      "['C56' '100nf' 'C_0603_1608Metric' 95.68 -193.04 180 'top' 'C14663']\n",
      "['C57' '100nf' 'C_0603_1608Metric' 114.73 -193.04 180 'top' 'C14663']\n",
      "['C58' '100nf' 'C_0603_1608Metric' 133.78 -193.04 180 'top' 'C14663']\n",
      "['C59' '100nf' 'C_0603_1608Metric' 152.83 -193.04 180 'top' 'C14663']\n",
      "['C60' '100nf' 'C_0603_1608Metric' 171.88 -193.04 180 'top' 'C14663']\n",
      "['C61' '100nf' 'C_0603_1608Metric' 41.275 -212.09 180 'top' 'C14663']\n",
      "['C62' '100nf' 'C_0603_1608Metric' 60.325 -212.09 180 'top' 'C14663']\n",
      "['C63' '100nf' 'C_0603_1608Metric' 79.375 -212.09 180 'top' 'C14663']\n",
      "['C64' '100nf' 'C_0603_1608Metric' 98.425 -212.09 180 'top' 'C14663']\n",
      "['C65' '100nf' 'C_0603_1608Metric' 117.475 -212.09 180 'top' 'C14663']\n",
      "['C66' '100nf' 'C_0603_1608Metric' 136.525 -212.09 180 'top' 'C14663']\n",
      "['C67' '100nf' 'C_0603_1608Metric' 155.575 -212.09 180 'top' 'C14663']\n",
      "['C68' '100nf' 'C_0603_1608Metric' 174.625 -212.09 180 'top' 'C14663']\n",
      "['C1' '10uf' 'C_0402_1005Metric' 110.97 -40.64 0 'top' 'C15525']\n",
      "['R3' '10K' 'R_1206_3216Metric' 127.355 -41.783 180 'top' 'C17902']\n",
      "['R8' '10K' 'R_1206_3216Metric' 140.462 -41.783 0 'top' 'C17902']\n",
      "['R6' 220 'R_0603_1608Metric' 156.781 -39.624 180 'top' 'C22962']\n",
      "['R7' 220 'R_0603_1608Metric' 151.447 -39.624 180 'top' 'C22962']\n",
      "['R1' '5.1K' 'R_0603_1608Metric' 93.98 -41.402 90 'top' 'C23186']\n",
      "['R2' '5.1K' 'R_0603_1608Metric' 91.44 -41.465 90 'top' 'C23186']\n",
      "['C4' '1uf' 'C_0805_2012Metric' 86.36 -41.656 90 'top' 'C28323']\n",
      "['U1' 'ATmega32U4-AU' 'TQFP-44_10x10mm_P0.8mm' 107.95 -50.165 315 'top'\n",
      " 'C44854']\n",
      "['USB1' 'HRO-TYPE-C-31-M-12' 'HRO-TYPE-C-31-M-12' 107.95 -29.21 180 'top'\n",
      " 'C165948']\n",
      "['SW2' 'SW_Push' 'SW_Push_1P1T_NO_6x6mm_H9.5mm' 140.462 -36.957 0 'top'\n",
      " 'C620316']\n",
      "['SW1' 'SW_Push' 'SW_Push_1P1T_NO_6x6mm_H9.5mm' 127.381 -36.957 0 'top'\n",
      " 'C620316']\n"
     ]
    }
   ],
   "source": [
    "import numpy as np # imports the numpy library\n",
    "import pandas as pd # imports the pandas library for dataframe generation\n",
    "import openpyxl # imports the library for xlsx file\n",
    "import sys # imports the library for system info\n",
    "\n",
    "print(sys.version)\n",
    "# Reads the BOM csv file\n",
    "bomFile = pd.read_csv(\"bom.csv\")\n",
    "print(\"BOM File\")\n",
    "print(bomFile)\n",
    "print(\"\\n\")\n",
    "# Reads the PNP excel file\n",
    "pnpFile = pd.read_excel(\"RedBoard-top.xlsx\")\n",
    "# Adds an LCSC column to the PNP file\n",
    "pnpFile['LCSC'] = 'N/A'\n",
    "print(\"PNP File\")\n",
    "print(pnpFile)\n",
    "print(\"LCSC Values\")\n",
    "# Initializes arrays of LCSC values and Designator values\n",
    "numCols_BOM = bomFile.shape[0]\n",
    "values_LCSC = []\n",
    "values_Design = []\n",
    "all_Designators = []\n",
    "# Stores LCSC values from BOM file into array\n",
    "for lcscElement in bomFile['LCSC']:\n",
    "    values_LCSC.append(lcscElement)\n",
    "#print(values_LCSC)\n",
    "#print(\"\\n\")\n",
    "# Stores Designator values from BOM file into array\n",
    "designIndex = 0\n",
    "for designElement in bomFile['Designator']:\n",
    "    # Splits arrays with multiple designator elements\n",
    "    designArray = designElement.split(\",\")\n",
    "    # Stores these designator elements individually in a normal array\n",
    "    for designArrayVal in designArray:\n",
    "        all_Designators.append(designArrayVal)\n",
    "    # Stores these values in the corresponding 2D array\n",
    "    values_Design.insert(designIndex, designArray)  \n",
    "    # Increments the design index by 1\n",
    "    designIndex = designIndex + 1\n",
    "#print(values_Design)\n",
    "#print(\"\\n\")\n",
    "#print(all_Designators)\n",
    "#print(\"\\n\")\n",
    "# Initializes a dictionary object for LCSC keys and Designator values\n",
    "values_LCSC_Design_Dict = {}\n",
    "lcsc_row = 0\n",
    "# Traverses the LCSC array and stores Designator values for the corresponding LCSC key\n",
    "for ind_LCSC in values_LCSC:\n",
    "    values_LCSC_Design_Dict[ind_LCSC] = values_Design[lcsc_row]\n",
    "    # Increments the row number by 1\n",
    "    lcsc_row = lcsc_row + 1\n",
    "print(\"Dictionary Object for LCSC keys and Designator values\")\n",
    "print(values_LCSC_Design_Dict)\n",
    "# Creates a PNP file duplicate for easy accessibility\n",
    "pnpDuplicate = np.array(pnpFile)\n",
    "rowStorage = []\n",
    "# Traverses all designators\n",
    "for elementDes in all_Designators:\n",
    "    # Stores the row number index for each designator\n",
    "    rowNum = np.where(pnpDuplicate == elementDes)[0][0]\n",
    "    # Adds this index to the row storage array\n",
    "    rowStorage.append(rowNum)\n",
    "print(rowStorage)\n",
    "# Suppresses the SettingWithCopy warning\n",
    "pd.options.mode.chained_assignment = None\n",
    "# Initializes designator index\n",
    "designatorIndex = 0\n",
    "# Traverses through all keys in the dictionary (Linking Process)\n",
    "for key in values_LCSC_Design_Dict:\n",
    "    # Looks at each individual designator in the dictionary\n",
    "    for designator in values_LCSC_Design_Dict[key]:\n",
    "        # Provides the LCSC value for each designator\n",
    "        pnpFile[\"LCSC\"][rowStorage[designatorIndex]] = key\n",
    "        # Incremenets the designator index by 1\n",
    "        designatorIndex = designatorIndex + 1\n",
    "print(\"New PNP File\")\n",
    "print(pnpFile)\n",
    "# Traverses through all row numbers in the row storage array to group based on LCSC (Grouping Process)\n",
    "print(\"Grouped PNP File\")\n",
    "pnpCopy = np.array(pnpFile)\n",
    "for rowIndex in rowStorage:\n",
    "    print(pnpCopy[rowIndex])\n",
    "# Rearranges the rows based on the increasing order of the LCSC part number (Sorting Process)\n",
    "# Retrieves the list of keys\n",
    "keyList = list(values_LCSC_Design_Dict.keys())\n",
    "# Initializes two empty arrays for key list copies\n",
    "keyListCopy = []\n",
    "finalKeyCopy = []\n",
    "# Traverses through the key list\n",
    "for key in keyList:\n",
    "    # Converts the string value without the letter into an int\n",
    "    keyListCopy.append(int(key[1:]))\n",
    "    # Sorts the integer values\n",
    "    keyListCopy.sort()\n",
    "# Traverses through the key list copy with sorted integers\n",
    "keyIndex = 0\n",
    "for key in keyListCopy:\n",
    "    # Assembles the original key in the sorted format\n",
    "    newKey = keyList[keyIndex][0:1] + str(key)\n",
    "    # Adds the new key to the final key list\n",
    "    finalKeyCopy.append(newKey)\n",
    "print(finalKeyCopy)\n",
    "row_LCSC_Design_Dict = {}\n",
    "newRowStorage = []\n",
    "pnpMoreDuplicate = np.array(pnpFile)\n",
    "# Traverses the LCSC keys in the final key array\n",
    "for ind_LCSC in finalKeyCopy:\n",
    "    # Finds the row numbers corresponding to the LCSC keys\n",
    "    location = list(np.where(pnpMoreDuplicate == ind_LCSC)[0])\n",
    "    # Provides these row numbers as values for each LCSC key\n",
    "    row_LCSC_Design_Dict[ind_LCSC] = location\n",
    "# Traverses the LCSC keys in the newly constructed dictionary containing LCSC keys and corresponding row values\n",
    "print(\"Sorted PNP File\")\n",
    "for keyVal in row_LCSC_Design_Dict:\n",
    "    # Looks at each row number in the value array for each key\n",
    "    for rowNumber in row_LCSC_Design_Dict[keyVal]:\n",
    "        # Prints the corresponding row number from the PNP file\n",
    "        print(pnpMoreDuplicate[rowNumber])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "224af392",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "808e9aaf",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "1010b157",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}