{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "### Notebook configuration" ] }, { "cell_type": "code", "execution_count": 115, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "The autoreload extension is already loaded. To reload it, use:\n", " %reload_ext autoreload\n" ] } ], "source": [ "%load_ext autoreload\n", "%autoreload 2\n", "\n", "%aimport ee.kicad.bom\n", "%aimport ee.kicad.bom.io\n", "\n", "from ee.kicad.bom import *\n", "from ee.kicad.bom.io import read_bom" ] }, { "cell_type": "code", "execution_count": 170, "metadata": { "collapsed": true }, "outputs": [], "source": [ "bom_file = \"../kicad/bom/A64-OlinuXino_Rev_C.xml\"\n", "bom_file = \"../kicad/bom/gw.xml\"" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "# Load the BOM, sort by reference" ] }, { "cell_type": "code", "execution_count": 199, "metadata": { "scrolled": true }, "outputs": [], "source": [ "import os\n", "import os.path\n", "import pandas\n", "\n", "bom = read_bom(bom_file).to_pandas()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "# Sort a BOM" ] }, { "cell_type": "code", "execution_count": 200, "metadata": { "scrolled": true }, "outputs": [], "source": [ "f=lambda x: pandas.Series(data=x, index=['ref_name', 'ref_num', 'ref_rest'])\n", "sort_fields=bom[\"ref\"].map(ee.kicad.bom.split_ref).apply(f)\n", "\n", "bom=pandas.concat([bom, sort_fields], axis=1, join_axes=[bom.index])\n", "bom=bom.sort_values(by=list(sort_fields.columns))\n" ] }, { "cell_type": "code", "execution_count": 201, "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", "
CapacitanceColorDescriptionFrequencyImpedanceInductanceManufacturerPart NumberResistancerefvalueref_nameref_numref_rest
C11.0uFNone1.0uF, 10Vdc, ±20%, X5RNoneNoneNoneMurataGRM153R61A105ME95NoneC1C0402_1u_10Vdc_X5RC1
C21.0uFNone1.0uF, 10Vdc, ±20%, X5RNoneNoneNoneMurataGRM153R61A105ME95NoneC2C0402_1u_10Vdc_X5RC2
C31.0uFNone1.0uF, 10Vdc, ±20%, X5RNoneNoneNoneMurataGRM153R61A105ME95NoneC3C0402_1u_10Vdc_X5RC3
C41.0uFNone1.0uF, 10Vdc, ±20%, X5RNoneNoneNoneMurataGRM153R61A105ME95NoneC4C0402_1u_10Vdc_X5RC4
C51.0uFNone1.0uF, 10Vdc, ±20%, X5RNoneNoneNoneMurataGRM153R61A105ME95NoneC5C0402_1u_10Vdc_X5RC5
C61.0uFNone1.0uF, 10Vdc, ±20%, X5RNoneNoneNoneMurataGRM153R61A105ME95NoneC6C0402_1u_10Vdc_X5RC6
C71.0uFNone1.0uF, 10Vdc, ±20%, X5RNoneNoneNoneMurataGRM153R61A105ME95NoneC7C0402_1u_10Vdc_X5RC7
C81.0uFNone1.0uF, 10Vdc, ±20%, X5RNoneNoneNoneMurataGRM153R61A105ME95NoneC8C0402_1u_10Vdc_X5RC8
C91.0uFNone1.0uF, 10Vdc, ±20%, X5RNoneNoneNoneMurataGRM153R61A105ME95NoneC9C0402_1u_10Vdc_X5RC9
C104.7uFNone4.7uF, 6.3Vdc, ±20%, X5RNoneNoneNoneMurataGRM185R60J475ME15NoneC10C0603_4u7_6.3Vdc_X5RC10
C114.7uFNone4.7uF, 6.3Vdc, ±20%, X5RNoneNoneNoneMurataGRM185R60J475ME15NoneC11C0603_4u7_6.3Vdc_X5RC11
C124.7uFNone4.7uF, 6.3Vdc, ±20%, X5RNoneNoneNoneMurataGRM185R60J475ME15NoneC12C0603_4u7_6.3Vdc_X5RC12
C131.0uFNone1.0uF, 10Vdc, ±20%, X5RNoneNoneNoneMurataGRM153R61A105ME95NoneC13C0402_1u_10Vdc_X5RC13
C141.0uFNone1.0uF, 10Vdc, ±20%, X5RNoneNoneNoneMurataGRM153R61A105ME95NoneC14C0402_1u_10Vdc_X5RC14
C1510000pFNone10000pF, 10Vdc, ±10%, X5RNoneNoneNoneMurataGRM155R61A103KA01NoneC15C0402_10n_10Vdc_X5RC15
C1610000pFNone10000pF, 10Vdc, ±10%, X5RNoneNoneNoneMurataGRM155R61A103KA01NoneC16C0402_10n_10Vdc_X5RC16
C1710000pFNone10000pF, 10Vdc, ±10%, X5RNoneNoneNoneMurataGRM155R61A103KA01NoneC17C0402_10n_10Vdc_X5RC17
C181.0uFNone1.0uF, 10Vdc, ±20%, X5RNoneNoneNoneMurataGRM153R61A105ME95NoneC18C0402_1u_10Vdc_X5RC18
C191.0uFNone1.0uF, 10Vdc, ±20%, X5RNoneNoneNoneMurataGRM153R61A105ME95NoneC19C0402_1u_10Vdc_X5RC19
C201.0uFNone1.0uF, 10Vdc, ±20%, X5RNoneNoneNoneMurataGRM153R61A105ME95NoneC20C0402_1u_10Vdc_X5RC20
C211.0uFNone1.0uF, 10Vdc, ±20%, X5RNoneNoneNoneMurataGRM153R61A105ME95NoneC21C0402_1u_10Vdc_X5RC21
C2210pFNone10pF, 100Vdc, ±2%, C0GNoneNoneNoneMurataGRM1555C2A100GA01NoneC22C0402_10p_100Vdc_C0GC22
C2310pFNone10pF, 100Vdc, ±2%, C0GNoneNoneNoneMurataGRM1555C2A100GA01NoneC23C0402_10p_100Vdc_C0GC23
C2410pFNone10pF, 100Vdc, ±2%, C0GNoneNoneNoneMurataGRM1555C2A100GA01NoneC24C0402_10p_100Vdc_C0GC24
C2510pFNone10pF, 100Vdc, ±2%, C0GNoneNoneNoneMurataGRM1555C2A100GA01NoneC25C0402_10p_100Vdc_C0GC25
C2610pFNone10pF, 100Vdc, ±2%, C0GNoneNoneNoneMurataGRM1555C2A100GA01NoneC26C0402_10p_100Vdc_C0GC26
C271.0uFNone1.0uF, 10Vdc, ±20%, X5RNoneNoneNoneMurataGRM153R61A105ME95NoneC27C0402_1u_10Vdc_X5RC27
C2815pFNone15pF, 100Vdc, ±2%, C0GNoneNoneNoneMurataGRM1555C2A150GA01NoneC28C0402_15p_100Vdc_C0GC28
C291.0uFNone1.0uF, 10Vdc, ±20%, X5RNoneNoneNoneMurataGRM153R61A105ME95NoneC29C0402_1u_10Vdc_X5RC29
C3015pFNone15pF, 100Vdc, ±2%, C0GNoneNoneNoneMurataGRM1555C2A150GA01NoneC30C0402_15p_100Vdc_C0GC30
.............................................
R32NoneNone1.5k, ±1%, 0.063WNoneNoneNoneVishayCRCW04021K50FKED1.5kR32R0402_1k50R32
R33NoneNone10k, ±1%, 0.063WNoneNoneNoneVishayCRCW040210K0FKED10kR33R0402_10kR33
R34NoneNone330, ±1%, 0.063WNoneNoneNoneVishayCRCW0402330RFKED330R34R0402_330RR34
R35NoneNone330, ±1%, 0.063WNoneNoneNoneVishayCRCW0402330RFKED330R35R0402_330RR35
R36NoneNone10k, ±1%, 0.063WNoneNoneNoneVishayCRCW040210K0FKED10kR36R0402_10kR36
R37NoneNone100k, ±1%, 0.063WNoneNoneNoneVishayCRCW0402100KFKED100kR37R0402_100kR37
R38NoneNone100k, ±1%, 0.063WNoneNoneNoneVishayCRCW0402100KFKED100kR38R0402_100kR38
R39NoneNone100k, ±1%, 0.063WNoneNoneNoneVishayCRCW0402100KFKED100kR39R0402_100kR39
R40NoneNone100, ±1%, 0.063WNoneNoneNoneVishayCRCW0402100RFKED100R40R0402_100RR40
R41NoneNone100, ±1%, 0.063WNoneNoneNoneVishayCRCW0402100RFKED100R41R0402_100RR41
R42NoneNone39, ±1%, 0.063WNoneNoneNoneVishayCRCW040239R0FKED39R42R0402_39RR42
R43NoneNone39, ±1%, 0.063WNoneNoneNoneVishayCRCW040239R0FKED39R43R0402_39RR43
R44NoneNone10k, ±1%, 0.063WNoneNoneNoneVishayCRCW040210K0FKED10kR44R0402_10kR44
T1NoneNoneNoneNoneNoneNoneNoneNoneNoneT1S558-5999-T7-FT1
U1NoneNoneNoneNoneNoneNoneNoneNoneNoneU1AT91SAM9G25U1
U2NoneNoneNoneNoneNoneNoneNoneNoneNoneU2USBLC6-4U2
U3NoneNoneNoneNoneNoneNoneNoneNoneNoneU3CC2520U3
U4NoneNoneNoneNoneNoneNoneNoneNoneNoneU4NCP360SNAET1GU4
U5NoneNoneNoneNoneNoneNoneNoneNoneNoneU5TPS62742U5
U6NoneNoneNoneNoneNoneNoneNoneNoneNoneU6MIC23254U6
U7NoneNoneNoneNoneNoneNoneNoneNoneNoneU7IS46DR16640BU7
U8NoneNoneNoneNoneNoneNoneNoneNoneNoneU8MX30LF1G08AAU8
U9NoneNoneNoneNoneNoneNoneNoneNoneNoneU9LAN8710U9
U10NoneNoneNoneNoneNoneNoneNoneNoneNoneU10USBLC6-4U10
U11NoneNoneNoneNoneNoneNoneNoneNoneNoneU11LP3470M5-3.08U11
X1NoneNonef=12MHz, Stability:±150ppm, Tol:±50ppm,Load ca...12MHzNoneNoneNDKNX3225GA-12.000M-STD-CRA-1NoneX1NX3225GA-12.000M-STD-CRA-1X1
X2NoneNonef=32.768kHz, Stability:-, Tol:±20ppm,Load capa...32.768kHzNoneNoneNDKNX2012SA-32.768K-STD-MUB-1NoneX2NX2012SA-32.768K-STD-MUB-1X2
X3NoneNonef=32MHz, Stability:±10ppm, Tol:±10ppm,Load cap...32MHzNoneNoneNDKNX2520SA-32.000000MHZNoneX3NX2520SA-32.000000MHZX3
X4NoneNonef=25MHz, Stability:±25ppm, Tol:±15ppm,Load cap...25MHzNoneNoneNDKNX2520SA-25.000M-STD-CSW-5NoneX4NX2520SA-25.000M-STD-CSW-5X4
Z1NoneNoneNoneNoneNoneNoneNoneNoneNoneZ1WLA.01Z1
\n", "

165 rows × 14 columns

\n", "
" ], "text/plain": [ " Capacitance Color Description \\\n", "C1 1.0uF None 1.0uF, 10Vdc, ±20%, X5R \n", "C2 1.0uF None 1.0uF, 10Vdc, ±20%, X5R \n", "C3 1.0uF None 1.0uF, 10Vdc, ±20%, X5R \n", "C4 1.0uF None 1.0uF, 10Vdc, ±20%, X5R \n", "C5 1.0uF None 1.0uF, 10Vdc, ±20%, X5R \n", "C6 1.0uF None 1.0uF, 10Vdc, ±20%, X5R \n", "C7 1.0uF None 1.0uF, 10Vdc, ±20%, X5R \n", "C8 1.0uF None 1.0uF, 10Vdc, ±20%, X5R \n", "C9 1.0uF None 1.0uF, 10Vdc, ±20%, X5R \n", "C10 4.7uF None 4.7uF, 6.3Vdc, ±20%, X5R \n", "C11 4.7uF None 4.7uF, 6.3Vdc, ±20%, X5R \n", "C12 4.7uF None 4.7uF, 6.3Vdc, ±20%, X5R \n", "C13 1.0uF None 1.0uF, 10Vdc, ±20%, X5R \n", "C14 1.0uF None 1.0uF, 10Vdc, ±20%, X5R \n", "C15 10000pF None 10000pF, 10Vdc, ±10%, X5R \n", "C16 10000pF None 10000pF, 10Vdc, ±10%, X5R \n", "C17 10000pF None 10000pF, 10Vdc, ±10%, X5R \n", "C18 1.0uF None 1.0uF, 10Vdc, ±20%, X5R \n", "C19 1.0uF None 1.0uF, 10Vdc, ±20%, X5R \n", "C20 1.0uF None 1.0uF, 10Vdc, ±20%, X5R \n", "C21 1.0uF None 1.0uF, 10Vdc, ±20%, X5R \n", "C22 10pF None 10pF, 100Vdc, ±2%, C0G \n", "C23 10pF None 10pF, 100Vdc, ±2%, C0G \n", "C24 10pF None 10pF, 100Vdc, ±2%, C0G \n", "C25 10pF None 10pF, 100Vdc, ±2%, C0G \n", "C26 10pF None 10pF, 100Vdc, ±2%, C0G \n", "C27 1.0uF None 1.0uF, 10Vdc, ±20%, X5R \n", "C28 15pF None 15pF, 100Vdc, ±2%, C0G \n", "C29 1.0uF None 1.0uF, 10Vdc, ±20%, X5R \n", "C30 15pF None 15pF, 100Vdc, ±2%, C0G \n", ".. ... ... ... \n", "R32 None None 1.5k, ±1%, 0.063W \n", "R33 None None 10k, ±1%, 0.063W \n", "R34 None None 330, ±1%, 0.063W \n", "R35 None None 330, ±1%, 0.063W \n", "R36 None None 10k, ±1%, 0.063W \n", "R37 None None 100k, ±1%, 0.063W \n", "R38 None None 100k, ±1%, 0.063W \n", "R39 None None 100k, ±1%, 0.063W \n", "R40 None None 100, ±1%, 0.063W \n", "R41 None None 100, ±1%, 0.063W \n", "R42 None None 39, ±1%, 0.063W \n", "R43 None None 39, ±1%, 0.063W \n", "R44 None None 10k, ±1%, 0.063W \n", "T1 None None None \n", "U1 None None None \n", "U2 None None None \n", "U3 None None None \n", "U4 None None None \n", "U5 None None None \n", "U6 None None None \n", "U7 None None None \n", "U8 None None None \n", "U9 None None None \n", "U10 None None None \n", "U11 None None None \n", "X1 None None f=12MHz, Stability:±150ppm, Tol:±50ppm,Load ca... \n", "X2 None None f=32.768kHz, Stability:-, Tol:±20ppm,Load capa... \n", "X3 None None f=32MHz, Stability:±10ppm, Tol:±10ppm,Load cap... \n", "X4 None None f=25MHz, Stability:±25ppm, Tol:±15ppm,Load cap... \n", "Z1 None None None \n", "\n", " Frequency Impedance Inductance Manufacturer Part Number \\\n", "C1 None None None Murata GRM153R61A105ME95 \n", "C2 None None None Murata GRM153R61A105ME95 \n", "C3 None None None Murata GRM153R61A105ME95 \n", "C4 None None None Murata GRM153R61A105ME95 \n", "C5 None None None Murata GRM153R61A105ME95 \n", "C6 None None None Murata GRM153R61A105ME95 \n", "C7 None None None Murata GRM153R61A105ME95 \n", "C8 None None None Murata GRM153R61A105ME95 \n", "C9 None None None Murata GRM153R61A105ME95 \n", "C10 None None None Murata GRM185R60J475ME15 \n", "C11 None None None Murata GRM185R60J475ME15 \n", "C12 None None None Murata GRM185R60J475ME15 \n", "C13 None None None Murata GRM153R61A105ME95 \n", "C14 None None None Murata GRM153R61A105ME95 \n", "C15 None None None Murata GRM155R61A103KA01 \n", "C16 None None None Murata GRM155R61A103KA01 \n", "C17 None None None Murata GRM155R61A103KA01 \n", "C18 None None None Murata GRM153R61A105ME95 \n", "C19 None None None Murata GRM153R61A105ME95 \n", "C20 None None None Murata GRM153R61A105ME95 \n", "C21 None None None Murata GRM153R61A105ME95 \n", "C22 None None None Murata GRM1555C2A100GA01 \n", "C23 None None None Murata GRM1555C2A100GA01 \n", "C24 None None None Murata GRM1555C2A100GA01 \n", "C25 None None None Murata GRM1555C2A100GA01 \n", "C26 None None None Murata GRM1555C2A100GA01 \n", "C27 None None None Murata GRM153R61A105ME95 \n", "C28 None None None Murata GRM1555C2A150GA01 \n", "C29 None None None Murata GRM153R61A105ME95 \n", "C30 None None None Murata GRM1555C2A150GA01 \n", ".. ... ... ... ... ... \n", "R32 None None None Vishay CRCW04021K50FKED \n", "R33 None None None Vishay CRCW040210K0FKED \n", "R34 None None None Vishay CRCW0402330RFKED \n", "R35 None None None Vishay CRCW0402330RFKED \n", "R36 None None None Vishay CRCW040210K0FKED \n", "R37 None None None Vishay CRCW0402100KFKED \n", "R38 None None None Vishay CRCW0402100KFKED \n", "R39 None None None Vishay CRCW0402100KFKED \n", "R40 None None None Vishay CRCW0402100RFKED \n", "R41 None None None Vishay CRCW0402100RFKED \n", "R42 None None None Vishay CRCW040239R0FKED \n", "R43 None None None Vishay CRCW040239R0FKED \n", "R44 None None None Vishay CRCW040210K0FKED \n", "T1 None None None None None \n", "U1 None None None None None \n", "U2 None None None None None \n", "U3 None None None None None \n", "U4 None None None None None \n", "U5 None None None None None \n", "U6 None None None None None \n", "U7 None None None None None \n", "U8 None None None None None \n", "U9 None None None None None \n", "U10 None None None None None \n", "U11 None None None None None \n", "X1 12MHz None None NDK NX3225GA-12.000M-STD-CRA-1 \n", "X2 32.768kHz None None NDK NX2012SA-32.768K-STD-MUB-1 \n", "X3 32MHz None None NDK NX2520SA-32.000000MHZ \n", "X4 25MHz None None NDK NX2520SA-25.000M-STD-CSW-5 \n", "Z1 None None None None None \n", "\n", " Resistance ref value ref_name ref_num ref_rest \n", "C1 None C1 C0402_1u_10Vdc_X5R C 1 \n", "C2 None C2 C0402_1u_10Vdc_X5R C 2 \n", "C3 None C3 C0402_1u_10Vdc_X5R C 3 \n", "C4 None C4 C0402_1u_10Vdc_X5R C 4 \n", "C5 None C5 C0402_1u_10Vdc_X5R C 5 \n", "C6 None C6 C0402_1u_10Vdc_X5R C 6 \n", "C7 None C7 C0402_1u_10Vdc_X5R C 7 \n", "C8 None C8 C0402_1u_10Vdc_X5R C 8 \n", "C9 None C9 C0402_1u_10Vdc_X5R C 9 \n", "C10 None C10 C0603_4u7_6.3Vdc_X5R C 10 \n", "C11 None C11 C0603_4u7_6.3Vdc_X5R C 11 \n", "C12 None C12 C0603_4u7_6.3Vdc_X5R C 12 \n", "C13 None C13 C0402_1u_10Vdc_X5R C 13 \n", "C14 None C14 C0402_1u_10Vdc_X5R C 14 \n", "C15 None C15 C0402_10n_10Vdc_X5R C 15 \n", "C16 None C16 C0402_10n_10Vdc_X5R C 16 \n", "C17 None C17 C0402_10n_10Vdc_X5R C 17 \n", "C18 None C18 C0402_1u_10Vdc_X5R C 18 \n", "C19 None C19 C0402_1u_10Vdc_X5R C 19 \n", "C20 None C20 C0402_1u_10Vdc_X5R C 20 \n", "C21 None C21 C0402_1u_10Vdc_X5R C 21 \n", "C22 None C22 C0402_10p_100Vdc_C0G C 22 \n", "C23 None C23 C0402_10p_100Vdc_C0G C 23 \n", "C24 None C24 C0402_10p_100Vdc_C0G C 24 \n", "C25 None C25 C0402_10p_100Vdc_C0G C 25 \n", "C26 None C26 C0402_10p_100Vdc_C0G C 26 \n", "C27 None C27 C0402_1u_10Vdc_X5R C 27 \n", "C28 None C28 C0402_15p_100Vdc_C0G C 28 \n", "C29 None C29 C0402_1u_10Vdc_X5R C 29 \n", "C30 None C30 C0402_15p_100Vdc_C0G C 30 \n", ".. ... ... ... ... ... ... \n", "R32 1.5k R32 R0402_1k50 R 32 \n", "R33 10k R33 R0402_10k R 33 \n", "R34 330 R34 R0402_330R R 34 \n", "R35 330 R35 R0402_330R R 35 \n", "R36 10k R36 R0402_10k R 36 \n", "R37 100k R37 R0402_100k R 37 \n", "R38 100k R38 R0402_100k R 38 \n", "R39 100k R39 R0402_100k R 39 \n", "R40 100 R40 R0402_100R R 40 \n", "R41 100 R41 R0402_100R R 41 \n", "R42 39 R42 R0402_39R R 42 \n", "R43 39 R43 R0402_39R R 43 \n", "R44 10k R44 R0402_10k R 44 \n", "T1 None T1 S558-5999-T7-F T 1 \n", "U1 None U1 AT91SAM9G25 U 1 \n", "U2 None U2 USBLC6-4 U 2 \n", "U3 None U3 CC2520 U 3 \n", "U4 None U4 NCP360SNAET1G U 4 \n", "U5 None U5 TPS62742 U 5 \n", "U6 None U6 MIC23254 U 6 \n", "U7 None U7 IS46DR16640B U 7 \n", "U8 None U8 MX30LF1G08AA U 8 \n", "U9 None U9 LAN8710 U 9 \n", "U10 None U10 USBLC6-4 U 10 \n", "U11 None U11 LP3470M5-3.08 U 11 \n", "X1 None X1 NX3225GA-12.000M-STD-CRA-1 X 1 \n", "X2 None X2 NX2012SA-32.768K-STD-MUB-1 X 2 \n", "X3 None X3 NX2520SA-32.000000MHZ X 3 \n", "X4 None X4 NX2520SA-25.000M-STD-CSW-5 X 4 \n", "Z1 None Z1 WLA.01 Z 1 \n", "\n", "[165 rows x 14 columns]" ] }, "execution_count": 201, "metadata": {}, "output_type": "execute_result" } ], "source": [ "bom" ] } ], "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.5.4rc1" } }, "nbformat": 4, "nbformat_minor": 2 }