Drop Duplicates#
Description:
Remove duplicate rows in specified columns.
Function:
Drop_Duplicates(table = string, col = string)
Parameters:
Table: Table name on which to perform function
Column(s): Columns to drop duplicates from
Example:
Drop_Duplicates(table = Budget, col = ["Date", "Geo", "Business Unit", "Plan", "Actual"])
Date |
Geo |
Business |
Plan |
Actual |
|---|---|---|---|---|
7/1/2024 |
Middle East & Africa |
Healthcare |
1200 |
900 |
7/1/2024 |
Middle East & Africa |
Healthcare |
1150 |
1000 |
9/1/2024 |
Asia-Pacific |
Energy |
1700 |
1400 |
9/1/2024 |
Asia-Pacific |
Energy |
1700 |
1400 |
9/1/2024 |
Asia-Pacific |
Energy |
1700 |
1400 |
9/1/2024 |
Asia-Pacific |
Energy |
1700 |
1400 |
Date |
Geo |
Business |
Plan |
Actual |
|---|---|---|---|---|
7/1/2024 |
Middle East & Africa |
Healthcare |
1200 |
900 |
7/1/2024 |
Middle East & Africa |
Healthcare |
1150 |
1000 |
9/1/2024 |
Asia-Pacific |
Energy |
1700 |
1400 |