import pandas as pd import numpy as np df = pd.read_excel("../data/sample-salesv3.xlsx") df.drop_duplicates(subset=["account number","name"]).head() df.drop_duplicates(subset=["account number","name"]).iloc[:,[0,1]]