ResistorDigikeyPNSearch.py

import csv



def convert_resistor_code(input_value):
    
    input_value = input_value.replace('r', 'R')
    input_value = input_value.replace('k', 'K') # All letters now uppercase (assume M/m will not be confused with each other)
    
    #save the multiplier of the code
    if(input_value == '0'):
        input_value = '0R'
    if('K' in input_value):
        letter = 'K'
        multiplier = 1000
    elif('M' in input_value):
        letter = 'M'
        multiplier = 1000000
    elif('m' in input_value):
        letter = 'm'
        multiplier = 0.001
    else:
        letter = 'R'
        multiplier = 1
        
# the two accepted forms for resistor naming is 5.1K and 5K1. After this code, all resistors should be in form 5K100000. The zeros add a buffer in case they need to be spliced off at the end. 
    if('.' in input_value): 
        input_value = input_value.replace(letter, '')
    input_value = input_value.replace('.', letter)
    if(letter != 'R'):
        input_value = input_value.replace('R', '')
    output_value = input_value + '0000000'
    return output_value[:4] # Stackpole uses 3 sig figs + a letter for resistor naming

with open('BOM.csv') as csv_file:
    csv_reader = csv.reader(csv_file, delimiter=',')
    line_count = 0
    first_row = next(csv_reader)
    
    # determine the index of the value and footprint row. this helps identify the column to look for resistor values in. 
    IndexOfValue = first_row.index('Value') if 'Value' in first_row else None
    if(IndexOfValue == None):
        print("Error! Could not find column named 'Value'!")
    IndexOfFootprint = first_row.index('Footprint') if 'Footprint' in first_row else None
    if(IndexOfFootprint == None):
        print("Error! Could not find column named 'Value'!")
  
    for row in csv_reader:
        if('R_' in row[IndexOfFootprint]):
            footprint = row[IndexOfFootprint].split('R_')[1][:4] #Returns 4 letter code from KiCAD footprint
            resistance = row[IndexOfValue].split(' ')[0].split('/')[0] # Grabs Resistance value from KiCAD footprint. It chucks tolerances for now lol
            if(footprint in resistance):
                resistance = row[IndexOfValue].split(footprint)[1].split(',')[1]
            resistanceCode = convert_resistor_code(resistance)
            
            #Stockpole naming
            NamePrefix = 'RMCF'
            Packaging = 'FT'
            if("0R00" in resistanceCode):
                Packaging = "ZT"
            Suffix = 'CT-ND'
            print(NamePrefix+ footprint + Packaging + resistanceCode + Suffix) #remove suffix if you want Manufacturer product number, keep it if you want digikey part number