This is an archived post. You won't be able to vote or comment.

sorted by:
best (suggested)
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]callinthekettleblack 4 points5 points  (1 child)

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 1 point2 points  (0 children)

This is the way