2. Dropping Duplicates

Dropping duplicates

# Drop duplicate store/type columns combinations

store_types = sales.drop_duplicates(subset=["store","type"])

print(store_types.head())

# Drop duplicate store/department columns combinations

store_depts = sales.drop_duplicates(subset=["store","department"])

print(store_depts.head())

# Subset the rows that are holiday weeks and drop duplicate dates

holiday_dates = sales[sales["is_holiday"]==True].drop_duplicates(subset="date")

print(holiday_dates["date"]) # Print date col of holiday_dates