Purpose:

The Python script is designed to clear the ‘AUTOMATION - Outlier’ column in a data set, effectively resetting its values.

To Elaborate

The script addresses the need to reset or clear the ‘AUTOMATION - Outlier’ column in a given data set. This is particularly useful in scenarios where the outlier information needs to be refreshed or removed for further analysis or processing. The script takes an input data frame, copies it to avoid altering the original data, and then clears the specified column by setting its values to an empty string. This ensures that any previous outlier data is removed, allowing for a clean slate for subsequent operations or analyses.

Walking Through the Code

1. Data Preparation:
   • The script begins by defining the primary data source and relevant column names from the input data frame (inputDf). These columns include identifiers like ‘Group’, ‘Publisher’, ‘Account’, ‘Campaign’, and ‘Group ID’, as well as the ‘AUTOMATION - Outlier’ column that is the focus of this script.
2. Output Initialization:
   • The script initializes the output data frame (outputDf) by copying the input data frame. This step is crucial to ensure that the original data remains unchanged while modifications are made to the copy.
   • The ‘AUTOMATION - Outlier’ column in the output data frame is then cleared by setting its values to an empty string. This effectively removes any existing outlier information from the column.
3. Result Display:
   • Finally, the script prints the first few rows of the modified output data frame using the tableize function, providing a quick view of the changes made to the data.

Vitals

• Script ID : 1129
• Client ID / Customer ID: 1306913045 / 60268001
• Action Type: Bulk Upload
• Item Changed: AdGroup
• Output Columns: Account, Campaign, Group, AUTOMATION - Outlier
• Linked Datasource: M1 Report
• Reference Datasource: None
• Owner: dwaidhas@marinsoftware.com (dwaidhas@marinsoftware.com)
• Created by dwaidhas@marinsoftware.com on 2024-05-22 17:45
• Last Updated by dwaidhas@marinsoftware.com on 2024-05-22 17:46

> See it in Action

Python Code

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
##
## name: Clear Automation - Outlier
## description:
##  
## 
## author: Dana Waidhas 
## created: 2024-05-22
## 

today = datetime.datetime.now(CLIENT_TIMEZONE).date()

# primary data source and columns
inputDf = dataSourceDict["1"]
RPT_COL_GROUP = 'Group'
RPT_COL_PUBLISHER = 'Publisher'
RPT_COL_ACCOUNT = 'Account'
RPT_COL_CAMPAIGN = 'Campaign'
RPT_COL_GROUP_ID = 'Group ID'
RPT_COL_AUTOMATION__OUTLIER = 'AUTOMATION - Outlier'

# output columns and initial values
BULK_COL_ACCOUNT = 'Account'
BULK_COL_CAMPAIGN = 'Campaign'
BULK_COL_GROUP = 'Group'
BULK_COL_AUTOMATION__OUTLIER = 'AUTOMATION - Outlier'
outputDf[BULK_COL_AUTOMATION__OUTLIER] = "<<YOUR VALUE>>"

# user code start here
outputDf = inputDf.copy()  # Make a copy to avoid modifying the original DataFrame
outputDf[BULK_COL_AUTOMATION__OUTLIER] = ""  # Clear the 'AUTOMATION INFO' column

# user code start here
print(tableize(outputDf.head()))

Post generated on 2025-03-11 01:25:51 GMT