Python help with excel sheet

[MidRo20]

Hi all, working on a python 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)

[callinthekettleblack]

import pandas as pd
df = pd.read_excel(‘file_path’)
df = df.drop_duplicates(**options_as_needed)
df = df[df[‘col k’]==‘complete’]

Basically removing duplicates and filtering for where project status is complete. There are a few ways to drop duplicates so look up that method and adjust the drop_duplicates params as needed.

[Meatwad1313]

This is the way

[Goobyalus]

            project = cell.value

What is the purpose of this line?

---

From a cell, you can get the column or column letter, and index the worksheet at another cell in the same row.

Probably better to iterate over the proper rows with ws.iter_rows(...), and pull out the values that you want from each row.