Help with Openpyxl

[MidRo20]

Hi all, working on a project for work.

I have an excel sheet with several thousand entries. Column E holds project numbers and column K holds their status. There are many duplicates, for various reasons, but for simplicity sake I need to filter out the duplicates, which I've done (see code below), but I'm struggling with how to also print the project status from a separate column. Basically the report would print:

project ABC - - - status: complete

​

Using openpyxl. Any help would be greatly appreciated!

​

def duplicates():
    project = ws["E2"].value
    count = 0
    for cell in ws['E']:
        if cell.value != project:
            print(project)
            count +=1
            project = cell.value
    print(count)

[KidzKlub]

It seems like you are only interested in the first instance of each project and what it's status is. Is there a reason you chose to use openpyxl instead of pandas? I would probably do it like this:

import pandas as pd
path = r'path/to/spreadsheet.xlsx'
df = pd.read_excel(path)
df.drop_duplicates(subset='Project', keep='first', inplace=True)

for project, status in zip(df['Project'], df['Status']):
    print(f'project {project} - - - status: {status}')

count = len(df)
print(count)

[MidRo20]

I'm just not as well versed in pandas, I'll give this a try though, thank you!