JosephZYU
11/8/2019 - 3:53 PM

duplicates

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]]