Drop Columns#
Description:
Remove specified columns from a table.
Function:
Drop_columns(table = string, cols = string)
Parameters:
Table: Table name on which to perform function
Column(s): Column(s) to drop
Example:
Drop_columns(table = Budget, cols = ["Delta", "Plan")
Date |
Geo |
Business |
Plan |
Actual |
Delta |
|---|---|---|---|---|---|
7/1/2024 |
Middle East & Africa |
Healthcare |
1200 |
900 |
-300 |
7/1/2024 |
Middle East & Africa |
Healthcare |
1150 |
1000 |
-150 |
8/1/2024 |
Asia-Pacific |
Energy |
800 |
750 |
-50 |
8/1/2024 |
Asia-Pacific |
Technology |
950 |
1050 |
100 |
9/1/2024 |
Asia-Pacific |
Technology |
1500 |
1300 |
-200 |
9/1/2024 |
Asia-Pacific |
Energy |
1700 |
1400 |
-300 |
Date |
Geo |
Business |
Actual |
|---|---|---|---|
7/1/2024 |
Middle East & Africa |
Healthcare |
900 |
7/1/2024 |
Middle East & Africa |
Healthcare |
1000 |
8/1/2024 |
Asia-Pacific |
Energy |
750 |
8/1/2024 |
Asia-Pacific |
Technology |
1050 |
9/1/2024 |
Asia-Pacific |
Technology |
1300 |
9/1/2024 |
Asia-Pacific |
Energy |
1400 |