continues alternative groups in BOM

continuesAltGroupsInBOM.py

import pandas as pd
  
# Create DataFrame
df = pd.read_csv('data.csv')
jnum = 1
    #loop through each row of dataframe (not including the first/zeroeth)
df['Global group'].loc[0] = jnum
for i in range(1,len(df)):
    if df.BOM.loc[i] == df.BOM.loc[i-1] and df['Group'].loc[i] == df['Group'].loc[i-1]:
        df['Global group'].loc[i] = jnum
    else:  
        jnum += 1
        df['Global group'].loc[i] = jnum
for m in range(0,len(df)):
    df['Class'].loc[m] = df['Global group'].loc[m]

for k in range(0, len(df)):
    for l in range(k,len(df)):
        if df['Material'].loc[k] == df['Material'].loc[l]:
            df['Class'].loc[l] = df['Class'].loc[k]
            groupn = df['Global group'].loc[l] 
            for m in range(k, len(df)):
                if df['Global group'].loc[m] == groupn:
                    df['Class'].loc[m] = df['Class'].loc[k]

print(df)
#df.to_csv('data.csv')

data.csv